| [ Index ] |
|
Code source de e107 0.7.8 |
1 <?php 2 /* 3 + ----------------------------------------------------------------------------+ 4 | e107 website system 5 | 6 | ©Steve Dunstan 2001-2002 7 | http://e107.org 8 | jalist@e107.org 9 | 10 | Released under the terms and conditions of the 11 | GNU General Public License (http://gnu.org). 12 | 13 | $Source: /cvsroot/e107/e107_0.7/top.php,v $ 14 | $Revision: 1.11 $ 15 | $Date: 2006/08/04 01:26:35 $ 16 | $Author: mcfly_e107 $ 17 +----------------------------------------------------------------------------+ 18 */ 19 require_once ("class2.php"); 20 if (!e_QUERY) { 21 $action = "top"; 22 $subaction = "all"; 23 $from = 0; 24 $view = 10; 25 } else { 26 $tmp = explode(".", e_QUERY); 27 $from = intval($tmp[0]); 28 $action = $tmp[1]; 29 $subaction = $tmp[2]; 30 $view = ($tmp[3] ? intval($tmp[3]) : 10); 31 } 32 if ($action == "top") { 33 define("e_PAGETITLE", ": ".LAN_8); 34 } elseif($action == "active") { 35 define("e_PAGETITLE", ": ".LAN_7); 36 } 37 38 39 require_once(HEADERF); 40 if ($action == "active") { 41 require_once(e_HANDLER."userclass_class.php"); 42 43 $query = " 44 SELECT 45 t.*, f.forum_name, f.forum_class, u.user_name, fp.forum_class FROM #forum_t AS t 46 LEFT JOIN #forum AS f 47 ON t.thread_forum_id = f.forum_id 48 LEFT JOIN #user AS u 49 ON SUBSTRING_INDEX(t.thread_user,'.',1) = u.user_id 50 LEFT JOIN #forum AS fp 51 ON fp.forum_id = f.forum_parent 52 WHERE 53 t.thread_parent = 0 54 AND fp.forum_class IN (".USERCLASS_LIST.") 55 AND f.forum_class IN (".USERCLASS_LIST.") 56 ORDER BY 57 t.thread_views DESC 58 LIMIT 59 {$from}, {$view}"; 60 61 if ($sql->db_Select_gen($query)) { 62 $text = "<div style='text-align:center'>\n<table style='width:auto' class='fborder'>\n"; 63 if (!is_object($gen)) { 64 $gen = new convert; 65 } 66 67 $text .= "<tr> 68 <td style='width:5%' class='forumheader'> </td> 69 <td style='width:45%' class='forumheader'>".LAN_1."</td> 70 <td style='width:15%; text-align:center' class='forumheader'>".LAN_2."</td> 71 <td style='width:5%; text-align:center' class='forumheader'>".LAN_3."</td> 72 <td style='width:5%; text-align:center' class='forumheader'>".LAN_4."</td> 73 <td style='width:25%; text-align:center' class='forumheader'>".LAN_5."</td> 74 </tr>\n"; 75 76 while ($row = $sql->db_Fetch()) { 77 extract($row); 78 if (check_class($forum_class)) { 79 80 if($user_name) 81 { 82 $POSTER = "<a href='".e_HTTP."user.php?id.{$thread_user}'>{$user_name}</a>"; 83 } else { 84 list($anonposter, $ipaddress) = explode(chr(1), $thread_anon); 85 $POSTER = $anonposter; 86 } 87 88 $LINKTOTHREAD = e_PLUGIN_ABS."forum/forum_viewtopic.php?".$thread_id; 89 $LINKTOFORUM = e_PLUGIN_ABS."forum/forum_viewforum.php?".$thread_forum_id; 90 $lastpost_datestamp = $gen->convert_date($thread_lastpost, "forum"); 91 list($lastpost_id, $lastpost_name) = explode('.', $thread_lastuser, 2); 92 if (!$lastpost_id) { 93 $LASTPOST = $lastpost_name.'<br />'.$lastpost_datestamp; 94 } else { 95 $LASTPOST = "<a href='".e_HTTP."user.php?id.".$lastpost_id."'>".$lastpost_name."</a><br />".$lastpost_datestamp; 96 } 97 98 $text .= "<tr> 99 <td style='width:5%; text-align:center' class='forumheader3'><img src='".e_PLUGIN_ABS."forum/images/".IMODE."/new_small.png' alt='' /></td> 100 <td style='width:45%' class='forumheader3'><b><a href='{$LINKTOTHREAD}'>{$thread_name}</a></b> <span class='smalltext'>(<a href='{$LINKTOFORUM}'>{$forum_name}</a>)</span></td> 101 <td style='width:15%; text-align:center' class='forumheader3'>{$POSTER}</td> 102 <td style='width:5%; text-align:center' class='forumheader3'>{$thread_views}</td> 103 <td style='width:5%; text-align:center' class='forumheader3'>{$thread_total_replies}</td> 104 <td style='width:25%; text-align:center' class='forumheader3'>{$LASTPOST}</td> 105 </tr>\n"; 106 } 107 } 108 109 $text .= "</table>\n</div>"; 110 111 $ns->tablerender(LAN_7, $text, "nfp"); 112 require_once(e_HANDLER."np_class.php"); 113 $ftotal = $sql->db_Select("forum_t", "*", "thread_parent='0'"); 114 $ix = new nextprev("top.php", $from, $view, $ftotal, "", "active.forum.".$view.""); 115 } 116 } 117 if ($action == "top") { 118 require_once(e_HANDLER."level_handler.php"); 119 define("IMAGE_rank_main_admin_image", ($pref['rank_main_admin_image'] && file_exists(THEME."forum/".$pref['rank_main_admin_image']) ? "<img src='".THEME_ABS."forum/".$pref['rank_main_admin_image']."' alt='' />" : "<img src='".e_PLUGIN_ABS."forum/images/".IMODE."/main_admin.png' alt='' />")); 120 define("IMAGE_rank_admin_image", ($pref['rank_admin_image'] && file_exists(THEME."forum/".$pref['rank_admin_image']) ? "<img src='".THEME_ABS."forum/".$pref['rank_admin_image']."' alt='' />" : "<img src='".e_PLUGIN_ABS."forum/images/".IMODE."/admin.png' alt='' />")); 121 define("IMAGE_rank_moderator_image", ($pref['rank_moderator_image'] && file_exists(THEME."forum/".$pref['rank_moderator_image']) ? "<img src='".THEME_ABS."forum/".$pref['rank_moderator_image']."' alt='' />" : "<img src='".e_PLUGIN_ABS."forum/images/".IMODE."/moderator.png' alt='' />")); 122 123 if ($subaction == "forum" || $subaction == "all") { 124 $top_forum_posters = $sql->db_Select("user", "*", "`user_forums` > 0 ORDER BY user_forums DESC LIMIT ".$from.", ".$view.""); 125 $text = " 126 <div style='text-align:center'> 127 <table style='width:95%' class='fborder'> 128 <tr> 129 <td style='width:10%; text-align:center' class='forumheader3'> </td> 130 <td style='width:50%' class='forumheader3'>".TOP_LAN_1."</td> 131 <td style='width:10%; text-align:center' class='forumheader3'>".TOP_LAN_2."</td> 132 <td style='width:30%; text-align:center' class='forumheader3'>".TOP_LAN_6."</td> 133 </tr>\n"; 134 $counter = 1 + $from; 135 while ($row = $sql->db_Fetch()) { 136 extract($row); 137 $ldata = get_level($user_id, $user_forums, $user_comments, $user_chats, $user_visits, $user_join, $user_admin, $user_perms, $pref); 138 $text .= "<tr> 139 <td style='width:10%; text-align:center' class='forumheader3'>{$counter}</td> 140 <td style='width:50%' class='forumheader3'><a href='".e_HTTP."user.php?id.{$user_id}'>{$user_name}</a></td> 141 <td style='width:10%; text-align:center' class='forumheader3'>{$user_forums}</td> 142 <td style='width:30%; text-align:center' class='forumheader3'>".(strstr($ldata[0], "LAN") ? $ldata[1] : $ldata[0])."</td> 143 </tr>"; 144 $counter++; 145 } 146 $text .= "</table>\n</div>"; 147 $ns->tablerender(TOP_LAN_0, $text); 148 if ($subaction == "forum") { 149 require_once(e_HANDLER."np_class.php"); 150 $ftotal = $sql->db_Count("user", "(*)", "WHERE `user_forums` > 0"); 151 $ix = new nextprev("top.php", $from, $view, $ftotal, "Forum Posts", "top.forum.".$view.""); 152 } 153 } 154 155 156 if ($subaction == "comment" || $subaction == "all") { 157 $top_forum_posters = $sql->db_Select("user", "*", "`user_comments` > 0 ORDER BY user_comments DESC LIMIT 0, 10"); 158 $text = " 159 <div style='text-align:center'> 160 <table style='width:95%' class='fborder'> 161 <tr> 162 <td style='width:10%; text-align:center' class='forumheader3'> </td> 163 <td style='width:50%' class='forumheader3'>".TOP_LAN_1."</td> 164 <td style='width:10%; text-align:center' class='forumheader3'>".TOP_LAN_4."</td> 165 <td style='width:30%; text-align:center' class='forumheader3'>".TOP_LAN_6."</td> 166 </tr>\n"; 167 $counter = 1; 168 while ($row = $sql->db_Fetch()) { 169 extract($row); 170 $ldata = get_level($user_id, $user_forums, $user_comments, $user_chats, $user_visits, $user_join, $user_admin, $user_perms, $pref); 171 $text .= "<tr> 172 <td style='width:10%; text-align:center' class='forumheader3'>{$counter}</td> 173 <td style='width:50%' class='forumheader3'><a href='".e_HTTP."user.php?id.{$user_id}'>{$user_name}</a></td> 174 <td style='width:10%; text-align:center' class='forumheader3'>{$user_comments}</td> 175 <td style='width:30%; text-align:center' class='forumheader3'>".(strstr($ldata[0], "LAN") ? $ldata[1] : $ldata[0])."</td> 176 </tr>"; 177 $counter++; 178 } 179 $text .= "</table>\n</div>"; 180 $ns->tablerender(TOP_LAN_3, $text); 181 } 182 183 if ($subaction == "chat" || $subaction == "all") { 184 $top_forum_posters = $sql->db_Select("user", "*", "`user_chats` > 0 ORDER BY user_chats DESC LIMIT 0, 10"); 185 $text = " 186 <div style='text-align:center'> 187 <table style='width:95%' class='fborder'> 188 <tr> 189 <td style='width:10%; text-align:center' class='forumheader3'> </td> 190 <td style='width:20%' class='forumheader3'>".TOP_LAN_1."</td> 191 <td style='width:10%; text-align:center' class='forumheader3'>".TOP_LAN_2."</td> 192 <td style='width:30%; text-align:center' class='forumheader3'>".TOP_LAN_6."</td> 193 </tr>\n"; 194 $counter = 1; 195 while ($row = $sql->db_Fetch()) { 196 extract($row); 197 $ldata = get_level($user_id, $user_forums, $user_comments, $user_chats, $user_visits, $user_join, $user_admin, $user_perms, $pref); 198 $text .= "<tr> 199 <td style='width:10%; text-align:center' class='forumheader3'>{$counter}</td> 200 <td style='width:50%' class='forumheader3'><a href='".e_HTTP."user.php?id.{$user_id}'>{$user_name}</a></td> 201 <td style='width:10%; text-align:center' class='forumheader3'>{$user_chats}</td> 202 <td style='width:30%; text-align:center' class='forumheader3'>".(strstr($ldata[0], "LAN") ? $ldata[1] : $ldata[0])."</td> 203 </tr>"; 204 $counter++; 205 } 206 $text .= "</table>\n</div>"; 207 $ns->tablerender(TOP_LAN_5, $text); 208 } 209 } 210 require_once(FOOTERF); 211 ?>
titre
Description
Corps
titre
Description
Corps
titre
Description
Corps
titre
Corps
| Généré le : Sun Apr 1 01:23:32 2007 | par Balluche grâce à PHPXref 0.7 |