Question Kunena and JomSocial. And the signature?

sababer9 wrote: Hey guys,,

Studies few earlier messages in this post for the same requirement, the signautre integration with jomsocial. I think you ppl have got the solution with a plugin may be.

in the meantime, i built up my own solution, thought it might help anyone there.

Its an extra field in jomsocial which picks and puts signature in kunena table with following code.

// no direct access
defined('_JEXEC') or die('Restricted access');

class CFieldsForumSignature
{
function getFieldHTML( $field , $required )
{
$config =& CFactory::getConfig();
$js = '/assets/validate-1.5';
$js .= ( $config->getBool('usepackedjavascript') ) ? '.pack.js' : '.js';
CAssets::attach($js, 'js');

// If maximum is not set, we define it to a default
$field->max = empty( $field->max ) ? 200 : $field->max;

$loggedInUser =& JFactory::getUser();
$userid = JRequest::getVar('userid',$loggedInUser->id,'get');
$db =& JFactory::getDBO();
$query = "SELECT signature FROM #__kunena_users WHERE userid = $userid";
$db->setQuery($query);
$field->value = $db->loadResult();

$class = ($field->required == 1) ? ' required' : '';
CFactory::load( 'helpers' , 'string' );
$html = '<textarea id="field' . $field->id . '" name="field' . $field->id . '" class="jomTips tipRight inputbox textarea' . $class . '" title="' . $field->name . '::' . CStringHelper::escape( $field->tips ) . '">' . $field->value . '</textarea>';
$html .= '<span id="errfield'.$field->id.'msg" style="display:none;">&nbsp;</span>';
$html .= '<script type="text/javascript">cvalidate.setMaxLength("#field' . $field->id . '", "' . $field->max . '");</script>';

return $html;
}

function isValid( $value , $required )
{
if( $required && empty($value))
{
return false;
}
$loggedInUser =& JFactory::getUser();
$userid = JRequest::getVar('id',$loggedInUser->id);
$db =& JFactory::getDBO();
$query = "UPDATE #__kunena_users SET signature ='$value' WHERE userid = $userid";
$db->setQuery($query);
$db->query();

return true;
}
}

Regards,
The signature from jomsocial

tuumke wrote: JomSocial Version: 2.2.2
Joomla! Version Joomla! 1.6.3 Stable
Installed version: Kunena 1.6.4

We do have an extra field in the profile, but the signature does not appear in Kunena

i've tried with <?php at beginnen, ?> at the end...
all dont work

-edit-
It's puttin the info in: jos_community_fields_values
even when you change
$query = "SELECT signature FROM #__kunena_users WHERE userid = $userid";
to
$query = "SELECT signature FROM jos_kunena_users WHERE userid = $userid";