// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
// #######################################
Before It ADD>>
// #######################################
// Top 5 Statistics BY NanoEntity
// Top 5 Posters
$posts5 = $DB_site->query('SELECT userid,username,posts FROM user ORDER BY posts DESC LIMIT 5');
while ($posts5top = mysql_fetch_array($posts5)):
++$posts5topnbsp;
$posts5name .= "? <a href=member.php?s=$session[sessionhash]&action=getinfo&userid=$posts5top[userid]>$posts5top[username]</a><br>";
$posts5post .= "$posts5top[posts] ?<br>";
endwhile;
// Top 5 Posters
// Top 5 New Members
$user = $DB_site->query('SELECT userid,posts,username,joindate FROM user ORDER BY joindate DESC LIMIT 5');
while ($usertop = mysql_fetch_array($user)):
++$usertopnbsp;
$username .= "? <a href=member.php?s=$session[sessionhash]&action=getinfo&userid=$usertop[userid]>$usertop[username]</a><br>";
$userposts .= "$usertop[posts] ?<br>";
endwhile;
// Top 5 New Members
// Top 5 Thread Replys
$pop = $DB_site->query('SELECT title,threadid,lastpost,lastposter,views FROM thread ORDER BY lastpost DESC LIMIT 5');
while ($poptop = mysql_fetch_array($pop)):
++$poptopnbsp;
$popthread .= "? <a href=showthread.php?s=$session[sessionhash]&threadid=$poptop[threadid]>$poptop[title]</a><br>";
$poplastposter .= "$poptop[lastposter]<br>";
$popviews .= "$poptop[views] ?<br>";
endwhile;
// Top 5 Thread Replys
// Top 1 Most Popular Thread
$pop1 = $DB_site->query('SELECT title,threadid,views FROM thread ORDER BY views DESC LIMIT 1');
while ($pop1top = mysql_fetch_array($pop1)):
++$pop1topnbsp;
$pop1title .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$pop1top[threadid]>$pop1top[title]</a>";
$pop1views .= "$pop1top[views]";
endwhile;
// Top 1 Most Popular Thread
// Top 1 Most Rated Thread
$rated = $DB_site->query('SELECT title,threadid,votenum FROM thread ORDER BY votenum DESC LIMIT 1');
while ($ratedtop = mysql_fetch_array($rated)):
++$ratedtopnbsp;
$ratedtitle .= "<a href=showthread.php?s=$session[sessionhash]&threadid=$ratedtop[threadid]>$ratedtop[title]</a>";
$ratedrating .= "$ratedtop[votenum]";
endwhile;
// Top 1 Most Rated Thread
eval("\$top5threadstats = \"".gettemplate("hl_statistics")."\";");
// Top 5 Statistics BY NanoEntity
// #######################################
Add where ever you like>>
// #######################################
$top5threadstats
// #######################################
N O T E
// #######################################
$pop = $DB_site->query("SELECT title,threadid,lastpost,lastposter,views FROM
thread WHERE forumid<>'X' AND forumid<>'Y' AND forumid<>'Z' ORDER BY
lastpost DESC LIMIT 5");
Just replace x, y and z with the forums you want to exclude,
this was not implemented becouse I didn't had time.
I am working on a better version, and with mysql CP (options) support for admin,
+ something else, (none public release), but this version is, so enjoy.
- NanoEntity (hololith.com)
// #######################################
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
with this code do u have to add all the forums you want to show or all the ones you don't
$pop = $DB_site->query('SELECT title,threadid,lastpost,lastposter,views FROM thread WHERE forumid='XX' AND forumid='X' AND forumid='XX'ORDER BY lastpost DESC LIMIT 10');
$pop = $DB_site->query('SELECT title,threadid,lastpost,lastposter,views,user.user name FROM thread WHERE forumid NOT IN(1,56,83,13), usergroupid NOT IN(8,4,3,1)
LEFT JOIN user
ON (user.username=thread.lastposter)
ORDER BY lastpost DESC LIMIT 10');
8 = Banned by Moderators
4 = (COPPA) Users Awaiting Moderation
3 = Users Awaiting Email Confirmation
1 = Unregistered / Not Logged In
Details »»
About Developer
Visit Web Site
No support by the author.
Thats the problem for the 
09-28-2002, 02:07 AM
