Размер файла: 2.19Kb
- <?
- if($version == "wml")
- {
- header("Content-type: text/vnd.wap.wml; charset=utf-8");
- echo(doctype("Топ-20").$tag);
- echo("Имя - сообщений<br />\r\n");
- $query = mysql_query(" SELECT users.username, users.id, COUNT( posts.name ) AS cnt
- FROM posts, users
- WHERE users.username = posts.name
- GROUP BY users.id
- ORDER BY cnt DESC
- LIMIT 20");
- while($rows = mysql_fetch_assoc($query))
- {
- if($authorize)
- {
- echo("<a href=\"./?p=6&v=".$version."&sid=".$sid."&id=".$rows['id']."\">".$rows['username']."</a> ");
- echo("<b>(".$rows['cnt'].")</b><br />\r\n");
- }
- }
- echo
- "<a href=\"./?p=0&v=wml&sid=".$sid."\">Форумы</a>\r\n",
- $tagC."</p></card></wml>";
- }
- elseif($version == "xhtml")
- {
- header("Content-type: text/html; charset=utf-8");
- echo('<html>
- <head>
- <title>Топ-20</title>
- </head>
- <body bgcolor="'.$style['background'].'" link="'.$style['link'].'" vlink="'.$style['link'].'" text="#000000">
- <table align="center" border="0" cellspacing="1" cellpadding="5" width="350">
- <tr align="center" bgcolor="'.$style['title'].'"><td colspan="2">
- <font color="#FFFFFF"><b>Топ-20</b></font>
- </td></tr>
- <tr bgcolor="'.$style['bottom'].'"><td colspan="2"></td></tr>
- <tr bgcolor="'.$style['text'].'"><td>'.$tag.'Имя'.$tagC.'</td><td>'.$tag.'сообщений'.$tagC.'</td></tr>');
-
-
- $query = mysql_query("SELECT users.username, users.id, COUNT( posts.name ) AS cnt
- FROM posts, users
- WHERE users.username = posts.name
- GROUP BY users.id
- ORDER BY cnt DESC
- LIMIT 20");
- while($rows = mysql_fetch_assoc($query))
- {
- echo("<tr bgcolor=\"".$style['text']."\">\r\n");
- if($authorize)
- {
- echo("<td>".$tag."<a href=\"./?p=6&v=".$version."&sid=".$sid."&id=".$rows['id']."\">".$rows['username']."</a>".$tagC."</td>\r\n");
- echo("<td><b>(".$tag.$rows['cnt'].$tagC.")</b></td>");
- echo("</tr>");
- }
- }
- echo('<tr bgcolor="'.$style['bottom'].'"><td colspan="2">
- '.$tag.'<a href="./?p=0&v=xhtml&sid='.$sid.'">В форум</a> '.$tagC.'
- </td></tr></table>
- </body></html>');
- }
- ?>