TEMA:

//Get Badge Number
$this->execPieceByName('ff_InitLib');
$db = JFactory::getDBO();
$userid = JFactory::getUser()->id;
$db->setQuery('SELECT value FROM #__fields_values WHERE field_id=1');
$result = $db->loadResult();
ff_setValue('badge', $result);

//Get Badge Number
$this->execPieceByName('ff_InitLib');
$db = JFactory::getDBO();
$userid = JFactory::getUser()->id;
$db->setQuery('SELECT * FROM #__fields_values
INNER JOIN #__users on #__fields_values.field_id=#__users.id
WHERE #__users.id='.$userid);
$result = $db->loadResult();
ff_setValue('badge', $result);