1 |
dpavlin |
1.1 |
<?php |
2 |
|
|
|
3 |
|
|
###################################################################### |
4 |
|
|
# PHP-NUKE: Web Portal System |
5 |
|
|
# =========================== |
6 |
|
|
# |
7 |
|
|
# Copyright (c) 2000 by Francisco Burzi (fburzi@ncc.org.ve) |
8 |
|
|
# http://www.ncc.org.ve/php-nuke.php |
9 |
|
|
# |
10 |
|
|
# This modules is for the top10 page generated in real time |
11 |
|
|
# |
12 |
|
|
# This program is free software. You can redistribute it and/or modify |
13 |
|
|
# it under the terms of the GNU General Public License as published by |
14 |
|
|
# the Free Software Foundation; either version 2 of the License. |
15 |
|
|
###################################################################### |
16 |
|
|
|
17 |
|
|
if(!isset($mainfile)) { include("mainfile.php"); } |
18 |
|
|
include("header.php"); |
19 |
|
|
include("config.php"); |
20 |
|
|
dbconnect(); |
21 |
|
|
|
22 |
|
|
echo "<font face=Arial,Helvetica size=3> |
23 |
|
|
<center> |
24 |
|
|
<table cellpadding=2 cellspacing=0 bgcolor=000000 width=100% border=0><tr><td> |
25 |
|
|
<table cellpadding=2 cellspacing=0 bgcolor=FFFFFF width=100% border=0><tr><td> |
26 |
|
|
<font face=Lucida,Verdana,Arial,Helvetica size=4> |
27 |
|
|
<br><center><b>".translate("Welcome to the TOP page for")." $sitename!</b><br><br>"; |
28 |
|
|
|
29 |
|
|
// Top 10 read stories |
30 |
|
|
|
31 |
|
|
$result = mysql_query("select sid, title, time, counter from stories order by counter DESC limit 0,$top"); |
32 |
|
|
|
33 |
|
|
echo "<table border=0 cellpadding=10 width=100%><tr><td align=left><font face=Arial,Helvetica size=4> |
34 |
|
|
<b>$top ".translate("most readed stories")."</b><br><br><font size=3>"; |
35 |
|
|
$lugar=1; |
36 |
|
|
while(list($sid, $title, $time, $counter) = mysql_fetch_row($result)) { |
37 |
|
|
if($counter>0) { |
38 |
|
|
echo "<li>$lugar: <a href=article.php?sid=$sid>$title</a> - (".translate("readed:")." $counter ".translate("times").")<br>"; |
39 |
|
|
$lugar++; |
40 |
|
|
} |
41 |
|
|
} |
42 |
|
|
mysql_free_result($result); |
43 |
|
|
echo "</td></tr></table><br>"; |
44 |
|
|
|
45 |
|
|
// Top 10 commented stories |
46 |
|
|
|
47 |
|
|
$result = mysql_query("select sid, title, comments from stories order by comments DESC limit 0,$top"); |
48 |
|
|
|
49 |
|
|
echo "<table border=0 cellpadding=10 width=100%><tr><td align=left><font face=Arial,Helvetica size=4> |
50 |
|
|
<b>$top ".translate("most commented stories")."</b><br><br><font size=3>"; |
51 |
|
|
$lugar=1; |
52 |
|
|
while(list($sid, $title, $comments) = mysql_fetch_row($result)) { |
53 |
|
|
if($comments>0) { |
54 |
|
|
echo "<li>$lugar: <a href=article.php?sid=$sid>$title</a> - (".translate("comments:")." $comments)<br>"; |
55 |
|
|
$lugar++; |
56 |
|
|
} |
57 |
|
|
} |
58 |
|
|
mysql_free_result($result); |
59 |
|
|
echo "</td></tr></table><br>"; |
60 |
|
|
|
61 |
|
|
// Top 10 articles in special sections |
62 |
|
|
|
63 |
|
|
$result = mysql_query("select artid, secid, title, content, counter from seccont order by counter DESC limit 0,$top"); |
64 |
|
|
|
65 |
|
|
echo "<table border=0 cellpadding=10 width=100%><tr><td align=left><font face=Arial,Helvetica size=4> |
66 |
|
|
<b>$top ".translate("most readed articles in special sections")."</b><br><br><font size=3>"; |
67 |
|
|
$lugar=1; |
68 |
|
|
while(list($artid, $secid, $title, $content, $counter) = mysql_fetch_row($result)) { |
69 |
|
|
echo "<li>$lugar: <a href=sections.php?op=viewarticle&artid=$artid>$title</a> - (".translate("readed:")." $counter ".translate("times").")<br>"; |
70 |
|
|
$lugar++; |
71 |
|
|
} |
72 |
|
|
mysql_free_result($result); |
73 |
|
|
echo "</td></tr></table><br>"; |
74 |
|
|
|
75 |
|
|
// Top 10 users submitters |
76 |
|
|
|
77 |
|
|
$result = mysql_query("select uname, counter from users order by counter DESC limit 0,$top"); |
78 |
|
|
|
79 |
|
|
echo "<table border=0 cellpadding=10 width=100%><tr><td align=left><font face=Arial,Helvetica size=4> |
80 |
|
|
<b>$top ".translate("most active news submitters")."</b><br><br><font size=3>"; |
81 |
|
|
$lugar=1; |
82 |
|
|
while(list($uname, $counter) = mysql_fetch_row($result)) { |
83 |
|
|
if($counter>0) { |
84 |
|
|
echo "<li>$lugar: <a href=user.php?op=userinfo&uname=$uname>$uname</a> - (".translate("sent news:")." $counter)<br>"; |
85 |
|
|
$lugar++; |
86 |
|
|
} |
87 |
|
|
} |
88 |
|
|
mysql_free_result($result); |
89 |
|
|
echo "</td></tr></table><br>"; |
90 |
|
|
|
91 |
|
|
|
92 |
|
|
// Top 10 Polls |
93 |
|
|
|
94 |
|
|
$result = mysql_query("select pollID, pollTitle, voters from poll_desc order by voters DESC limit 0,$top"); |
95 |
|
|
|
96 |
|
|
echo "<table border=0 cellpadding=10 width=100%><tr><td align=left><font face=Arial,Helvetica size=4> |
97 |
|
|
<b>$top ".translate("most voted polls")."</b><br><br><font size=3>"; |
98 |
|
|
$lugar=1; |
99 |
|
|
while(list($pollID, $pollTitle, $voters) = mysql_fetch_row($result)) { |
100 |
|
|
if($voters>0) { |
101 |
|
|
echo "<li>$lugar: <a href=pollBooth.php?op=results&pollID=$pollID>$pollTitle</a> - (".translate("votes:")." $voters)<br>"; |
102 |
|
|
$lugar++; |
103 |
|
|
} |
104 |
|
|
} |
105 |
|
|
mysql_free_result($result); |
106 |
|
|
echo "</td></tr></table><br>"; |
107 |
|
|
|
108 |
|
|
// Top 10 authors |
109 |
|
|
|
110 |
|
|
$result = mysql_query("select aid, counter from authors order by counter DESC limit 0,$top"); |
111 |
|
|
|
112 |
|
|
echo "<table border=0 cellpadding=10 width=100%><tr><td align=left><font face=Arial,Helvetica size=4> |
113 |
|
|
<b>$top ".translate("most active authors")."</b><br><br><font size=3>"; |
114 |
|
|
$lugar=1; |
115 |
|
|
while(list($aid, $counter) = mysql_fetch_row($result)) { |
116 |
|
|
if($counter>0) { |
117 |
|
|
echo "<li>$lugar: <a href=search.php?query=&author=$aid>$aid</a> - (".translate("news published:")." $counter)<br>"; |
118 |
|
|
$lugar++; |
119 |
|
|
} |
120 |
|
|
} |
121 |
|
|
mysql_free_result($result); |
122 |
|
|
echo "</td></tr></table><br> |
123 |
|
|
<br><br></center> |
124 |
|
|
</td></tr></table></td></tr></table>"; |
125 |
|
|
|
126 |
|
|
include("footer.php"); |
127 |
|
|
?> |