db_Select_gen($query)) {
$text = "
\n
\n";
if (!is_object($gen)) {
$gen = new convert;
}
$text .= "
\n";
while ($row = $sql->db_Fetch()) {
extract($row);
if (check_class($forum_class)) {
if($user_name)
{
$POSTER = "{$user_name}";
} else {
list($anonposter, $ipaddress) = explode(chr(1), $thread_anon);
$POSTER = $anonposter;
}
$LINKTOTHREAD = e_PLUGIN_ABS."forum/forum_viewtopic.php?".$thread_id;
$LINKTOFORUM = e_PLUGIN_ABS."forum/forum_viewforum.php?".$thread_forum_id;
$lastpost_datestamp = $gen->convert_date($thread_lastpost, "forum");
list($lastpost_id, $lastpost_name) = explode('.', $thread_lastuser, 2);
if (!$lastpost_id) {
$LASTPOST = $lastpost_name.'
'.$lastpost_datestamp;
} else {
$LASTPOST = "".$lastpost_name."
".$lastpost_datestamp;
}
$text .= "
\n";
}
}
$text .= "
\n
";
$ns->tablerender(LAN_7, $text, "nfp");
require_once(e_HANDLER."np_class.php");
$ftotal = $sql->db_Count("forum_t", "(*)", "WHERE thread_parent = 0");
$ix = new nextprev("top.php", $from, $view, $ftotal, "", "active.forum.".$view."");
}
}
if ($action == "top") {
require_once(e_HANDLER."level_handler.php");
define("IMAGE_rank_main_admin_image", ($pref['rank_main_admin_image'] && file_exists(THEME."forum/".$pref['rank_main_admin_image']) ? "" : ""));
define("IMAGE_rank_admin_image", ($pref['rank_admin_image'] && file_exists(THEME."forum/".$pref['rank_admin_image']) ? "" : ""));
define("IMAGE_rank_moderator_image", ($pref['rank_moderator_image'] && file_exists(THEME."forum/".$pref['rank_moderator_image']) ? "" : ""));
if ($subaction == "forum" || $subaction == "all") {
$top_forum_posters = $sql->db_Select("user", "*", "`user_forums` > 0 ORDER BY user_forums DESC LIMIT ".$from.", ".$view."");
$text = "
\n";
$counter = 1 + $from;
while ($row = $sql->db_Fetch()) {
extract($row);
$ldata = get_level($user_id, $user_forums, $user_comments, $user_chats, $user_visits, $user_join, $user_admin, $user_perms, $pref);
$text .= "
";
$counter++;
}
$text .= "
\n
";
$ns->tablerender(TOP_LAN_0, $text);
if ($subaction == "forum") {
require_once(e_HANDLER."np_class.php");
$ftotal = $sql->db_Count("user", "(*)", "WHERE `user_forums` > 0");
$ix = new nextprev("top.php", $from, $view, $ftotal, "Forum Posts", "top.forum.".$view."");
}
}
if ($subaction == "comment" || $subaction == "all") {
$top_forum_posters = $sql->db_Select("user", "*", "`user_comments` > 0 ORDER BY user_comments DESC LIMIT 0, 10");
$text = "
\n";
$counter = 1;
while ($row = $sql->db_Fetch()) {
extract($row);
$ldata = get_level($user_id, $user_forums, $user_comments, $user_chats, $user_visits, $user_join, $user_admin, $user_perms, $pref);
$text .= "
";
$counter++;
}
$text .= "
\n
";
$ns->tablerender(TOP_LAN_3, $text);
}
if ($subaction == "chat" || $subaction == "all") {
$top_forum_posters = $sql->db_Select("user", "*", "`user_chats` > 0 ORDER BY user_chats DESC LIMIT 0, 10");
$text = "
\n";
$counter = 1;
while ($row = $sql->db_Fetch()) {
extract($row);
$ldata = get_level($user_id, $user_forums, $user_comments, $user_chats, $user_visits, $user_join, $user_admin, $user_perms, $pref);
$text .= "
";
$counter++;
}
$text .= "
\n
";
$ns->tablerender(TOP_LAN_5, $text);
}
}
require_once(FOOTERF);
?>