Question Join Comprofiler Table and Display CB Fields in Post

Hello,

I was able to hack the source code of Kunena 1.5 to display user's phone number in the forum using the signature function. However, I do not know how to modify the source code of Kunena 1.6 to have the same effect.

I understand the functions are now at /funcs/view.php and the database is now #__kunena

But code modification is really difficult now. I can pay for this hack if necessary.


Can anybody help? Below is my reference source code for Kunena 1.5.

---

a) components/com_kunena/template/default_ex/view.php - Line 502:

// Modified code to link kunena user to cb profile. Join comprofiler table with fb table -

$kunena_db->setQuery("SELECT a.*, b.id, c.phone, b.name, b.username, b.gid ".
"FROM #__fb_users AS a " .
"JOIN `#__comprofiler` AS c ON a.userid = c.id " .
"LEFT JOIN #__users AS b ON b.id=a.userid WHERE a.userid='{$fmessage->userid}'");

b) components/com_kunena/template/default_ex/message.php - Line 420:

// Replace with signature function -

<?php
// Modified code to display phone [using the forum signature function]
$phone = $userinfo->phone;
echo $phone;
?>