View Full Version : [Release] Top10 Status
sonic3d
01-18-2003, 10:00 PM
Top10 Status for vBulletin 2.2.9+
Author: NanoEntity
Description: Shows lastest replies, newest members and top posters.
SS:Screenshot (http://www.vbulletintemplates.com/mods/attachment.php?s=&postid=23289)
All credit goes to NanoEntity
Requested by someone.
l8er
sonic
Sean123
01-19-2003, 03:41 PM
uhmm ... can you show a screenshot?
sonic3d
01-19-2003, 03:43 PM
sorry, its coming up
Breaker
01-19-2003, 04:22 PM
nice mod...
Tony G
01-19-2003, 11:26 PM
Warning, I'm pretty sure this adds 3 queries to forumhome. I'm not sure, so filburt can correct me.
Smoothie
01-20-2003, 01:09 AM
what about showing threads from private forums? Does this take into account permissions?
Rufus69
01-20-2003, 01:34 AM
hmmm nice but I don't like the 3 more queries part ._.
Disturbed
01-20-2003, 01:50 AM
Originally posted by Smoothie
what about showing threads from private forums? Does this take into account permissions?
well in the txt file it shows you how to exclude certain forums from the stats
// STATISTICS V2 (NanoEntity)?hololith.com
$statusexclude = "0"; // What forums should we exclude/hide from INDEX.PHP? EXAMPLE: "1,106,78,910".
$statuslimit = "10"; // What limit should we set for INDEX.PHP?
if thats wat you mean neway
It adds the querys to EVERY page generated by vBulletin
Tony G
01-20-2003, 05:00 AM
This shows the evilness of phpinclude.
Hacking is more efficent in this situation by the look of it.
imported_compat
01-20-2003, 11:15 AM
nice
Originally posted by Tony
This shows the evilness of phpinclude.
Hacking is more efficent in this situation by the look of it.
If you know what you are doing you can control on what pages querys will run. The problem is people going over to vB.org. Finding a hack and sticking its query code in the phpinclude template without coding it themselves.
filburt1
01-20-2003, 06:41 PM
Originally posted by Tony
Warning, I'm pretty sure this adds 3 queries to forumhome. I'm not sure, so filburt can correct me.
5, actually, because the two templates aren't cached and have to be fetched from the db before being eval'ed.
sonic3d
01-20-2003, 09:56 PM
if u want u can delete. i was wondering how many queries it ran. sorry guys.
also does ne1 know how much queries run if it was put in the php file?
l8er
sonic
filburt1
01-20-2003, 09:57 PM
It would be 3 if hacked well.
sonic3d
01-21-2003, 12:23 AM
ok thanx.
imported_subu1
04-15-2003, 03:06 PM
sorry but i don't understand. I have put my private Forums into this, but the user can see threads from private forrum.
$statusexclude = "75,94,110,76,77,104,80,79,6,99,112,4"; // What forums should we exclude/hide from HL_STATISTICS.PHP? EXAMPLE: "1,106,78,910".
$statuslimit = "35"; // What limit should we set for HL_STATISTICS.PHP?
what can i do :confused: :cool:
sonic3d
04-17-2003, 02:41 AM
they have to be private to begin with.
if they aren't private, u can go to your admin cp, then modify under forums and moderators. then go to the forum u want to be private. click on edit. where it says Private forum, click yes.
is that what u wanted.
l8er
sonic
imported_subu1
04-17-2003, 05:24 AM
that is already clear, but that is not which I meant. In the Top 10 titles indicated for the user out mine private forums. The user can see the titles and that is not so beautiful.
greetz subu1
sonic3d
04-18-2003, 09:49 PM
i am not sure i understand you but in $statusexclude, u put the forums that are private. if u want im with AIM(Ayman86) so we can talk.
l8er
sonic
imported_subu1
04-20-2003, 02:50 PM
ok, now i am as normaly user on my Board, but i see this private Forum, although this is a private Forum (bibi)
its my Germanboard :)
you know war i mean :(
imported_subu1
04-20-2003, 02:51 PM
ups i forgot my Pic :)
edit: ups where is my attachment :confused:
imported_subu1
04-22-2003, 08:56 AM
oh my gott, i am verryyyyy stupid, i forgot to put this in phpinclude
// STATISTICS V2 (NanoEntity)?hololith.com
$statusexclude = "75,94,110,76,77,104,80,79,6,99,112,4"; // What forums should we exclude/hide from INDEX.PHP? EXAMPLE: "1,106,78,910".
$statuslimit = "10"; // What limit should we set for INDEX.PHP?
// POSTERS
$hl_posters = $DB_site->query("SELECT userid,username,posts FROM user ORDER BY posts DESC LIMIT $statuslimit");
while ($hl_poster = $DB_site->fetch_array($hl_posters)) {
$hl_postername .= "<a href=\"member.php?s=$session[sessionhash]&action=getinfo&userid=$hl_poster[userid]\" title=\"View profile for $hl_poster[username]\">$hl_poster[username]</a><br>";
$hl_posterposts .= "$hl_poster[posts]<br>";
}
// /POSTERS
// MEMBERS
$hl_members = $DB_site->query("SELECT userid,posts,username,joindate FROM user ORDER BY joindate DESC LIMIT $statuslimit");
while ($hl_member = $DB_site->fetch_array($hl_members)) {
$hl_membername .= "<a href=\"member.php?s=$session[sessionhash]&action=getinfo&userid=$hl_member[userid]\" title=\"View profile for $hl_member[username]\">$hl_member[username]</a><br>";
$hl_memberposts .= "$hl_member[posts]<br>";
}
// /MEMBERS
// REPLIES
$hl_replies = $DB_site->query("SELECT thread.replycount,thread.threadid,thread.lastpost, thread.lastposter,thread.views,thread.title,user.u serid FROM thread LEFT JOIN user ON (user.username=thread.lastposter) WHERE forumid NOT IN($statusexclude) ORDER BY lastpost DESC LIMIT $statuslimit");
while ($hl_reply = $DB_site->fetch_array($hl_replies)) {
$hl_replytitle2=unhtmlspecialchars($hl_reply['title']);
$hl_replytitle=iif(strlen($hl_replytitle2)>22,substr($hl_replytitle2,0,17)."..".substr($hl_replytitle2,-10),$hl_replytitle2);
$hl_replythread .= "<i>[$hl_reply[replycount]]</i> <a href=\"showthread.php?s=$session[sessionhash]&threadid=$hl_reply[threadid]\" title=\"$hl_replytitle2\">$hl_replytitle</a><br>";
$hl_replyposter .= "<a href=\"member.php?s=$session[sessionhash]&action=getinfo&userid=$hl_reply[userid]\" title=\"View profile for $hl_reply[lastposter]\">$hl_reply[lastposter]</a><br>";
$hl_replyviews .= "$hl_reply[views]<br>";
}
// /REPLIES
eval("\$hl_top10status = \"".gettemplate("hl_statistics")."\";");
// /STATISTICS V2 (NanoEntity)?hololith.com
now it works, (hide is hide)but now i have top20 :confused: :D
http://www.cover.netcheckershosting.de/cover/subu/Top20.gif
I thank you much for yours strive, where is my error,hihi
Breaker
04-22-2003, 09:07 AM
if u look, it is the top 10 twice :)
imported_subu1
04-22-2003, 09:40 AM
it now also saw, what I can do, where I must search
thank you
sonic3d
04-22-2003, 10:49 PM
lol. to make it twenty just chnage it to this
$statuslimit = "20"
l8er
sonic
imported_Jamie
04-29-2003, 11:47 PM
This is weird. When i put 5 in the $statuslimit It still shows 10! :( Someone please help!
sonic3d
04-30-2003, 12:39 AM
r u sure it isn't repeating the 5 from b4.
make sure you wrote/copied every thing right.
l8er
sonic
imported_Jamie
04-30-2003, 01:36 AM
Fixed it. Thanks man
MindTrix
11-22-2003, 09:34 PM
Just installed, its brilliant thanks
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.