// 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.
is there anyway of making it so it don't show posts from certain forum like posts in the Admin forum etc so others can see titles of posts from certain forums
yeah ill help ya a bit further then sayong run some queries
goto the index php
find the first
// Top 5 Thread Replys
then look where it says $pop
mske the line look this way
Code:
$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 5');
simply remove the extras if you only need one or add more if desired
Originally posted by almightyone yeah ill help ya a bit further then sayong run some queries
goto the index php
find the first
// Top 5 Thread Replys
then look where it says $pop
mske the line look this way
Code:
$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 5');
simply remove the extras if you only need one or add more if desired
is it forumid<>'(forum id number) or do you need a "=" between <> and '(forum id number)'?
Here's a minor adjustment that a friend did up for me.
Its to cut off the last 5 replies if Theyre too long for your setup.
(I have a thin welcome panel and long thread titles wrap around and look like crap)
Code:
// 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;
$thelength=25;
$thetitle=$poptop[title];
if(strlen($poptop[title]) > $thelength) {
$thetitle=substr($poptop[title], 0, $thelength)."...";
}
$popthread .= "? <a href=showthread.php?s=$session[sessionhash]&threadid=$poptop[threadid] title=\"$poptop[title]\">$thetitle</a><br>";
$poplastposter .= "$poptop[lastposter]<br>";
$popviews .= "$poptop[views] ?<br>";
endwhile;
// Top 5 Thread Replys
$thelength= being the number of characters you want to show. This also shows the full title when a user hovers over the thread title.
Im not sure what's different since I didnt do it, so just copy that over your current code starting with the //Top5 replys and ending with it too.
Oh, this is in the index.php in case you didnt know lol.
Originally posted by almightyone yeah ill help ya a bit further then sayong run some queries
goto the index php
find the first
// Top 5 Thread Replys
then look where it says $pop
mske the line look this way
Code:
$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 5');
simply remove the extras if you only need one or add more if desired