dans ./administrator/templates/bluestork/html/com_hikashop/user/listing.php
au debut
$ids = array();
foreach($this->rows as $row) {
$ids[] = $row->user_cms_id;
}
$userids = implode(',', $ids);
$qaup = 'SELECT userid,points FROM #__alpha_userpoints WHERE userid IN ';
$db = JFactory::getDBO();
$db->setQuery($qaup . '(' . $userids . ')' );
$ret = $db->loadObjectList('userid');
foreach($this->rows as $k => $row) {
if( isset($ret[$row->user_cms_id]) ) {
$this->rows[$k]->aup_points = $ret[$row->user_cms_id]->points;
}
}
et on recupere la valeur <?= round(@$row->aup_points,0); ?>