Code:
<?php
global $database;
$query = 'SELECT u.id, u.username, k.klicks ' .
'FROM #__users as u ' .
'INNER JOIN #__klicks_rel AS k ON k.userid = u.id ' . // join the klicks table by user id
'INNER JOIN #__core_acl_aro AS aro ON aro.value = u.id ' .
'INNER JOIN #__core_acl_groups_aro_map AS map ON map.aro_id = aro.aro_id ' .
'INNER JOIN #__core_acl_aro_groups AS g ON g.group_id = map.group_id ' .
'WHERE g.group_id != 25 ' .
'GROUP BY u.id ' .
'ORDER BY k.klicks DESC ' .
'LIMIT 5'
;
$database->setQuery($query);
$list = $database->loadObjectList();
$buffer = '';
if(count($list)) {
$buffer .= '<dl class="list">';
foreach($list as $obj) {
if(!empty($obj->klicks)) {
$link = 'index.php?option=com_comprofiler&task=userProfile&user=' . (int)$obj->id;
$buffer .= sprintf('<dt><a href="%s">%s</a></dt><dd>%d</dd>', sefRelToAbs($link), $obj->username, $obj->klicks);
}
}
$buffer .= '</dl>';
}
echo $buffer;
?>
PHP-Code:
$query = 'UPDATE #__klicks_rel SET klicks = ' . (int)$alles . ' WHERE userid = ' . (int)$user->id;
$database->setQuery($query);
$database->query();
LinkBack URL
About LinkBacks
Schlacht der Gummibären
Zitieren
Zitat von PuNkBaStaRd
Lesezeichen