ya esta ya la cace
me quedó asi:
///modificado por l para top 25 comentarios
$sql = "SELECT user_comments, user_name, user_id FROM ".USERS_TABLE."
WHERE user_level != '".ADMIN."'
ORDER BY user_comments DESC
LIMIT 25";
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {
$last_action_user_list .= '<a href ="'.$site_sess->url(ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id']).'"><b>'.$row['user_name'].'</b></a> <span class="smalltext">'.$row['user_comments'].'</span><br>';
}
$site_template->register_vars(array(
"user_comments_list" => $last_action_user_list,
));
unset($user_comments_list);
///fin modificado para top 25 comentarios
///modificado l para top 25 uploader
$sql = "SELECT user_t_images, user_name, user_id FROM ".USERS_TABLE."
WHERE user_level >= '".USER."'
ORDER BY user_t_images DESC
LIMIT 25";
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {
$last_action_user_list2 .= '<a href ="'.ROOT_PATH.'member.php?action=showprofile&user_id='.$row['user_id'].'"><b>'.$row['user_name'].'</b></a> <span class="smalltext">'.$row['user_t_images'].'</span><br>';
}
$site_template->register_vars(array(
"user_uploaders_list" => $last_action_user_list2,
));
unset($user_uploaders_list);
///fin modificado para top 25 uploader
?>