The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
Comments |
#42
|
||||
|
||||
|
#43
|
|||
|
|||
Is there any way to ignore some usernames from the list?
|
#44
|
|||
|
|||
This fixes the display problem with IE7
Code:
$posts = "Posts"; ob_start(); require_once('./includes/functions_user.php'); require_once('./includes/functions_bigthree.php'); // Current Week Top Posters $starttime = mktime(0, 0, 0, date('n'), date('j'), date('Y')) - ((date('N')-1)*3600*24); // Get Top Members for current week $mostactiveweek_get = vB::$db->query_read(" SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle, COUNT(".TABLE_PREFIX."post.postid) AS postcount FROM ".TABLE_PREFIX."user LEFT JOIN ".TABLE_PREFIX."post ON ".TABLE_PREFIX."post.userid=".TABLE_PREFIX."user.userid AND dateline>'".$starttime."' WHERE usergroupid=2 GROUP BY ".TABLE_PREFIX."user.userid ORDER BY postcount DESC LIMIT 5"); $topposter = true; $output_bits = ''; while($user = vB::$db->fetch_array($mostactiveweek_get)) { $percentage = round(($user[postcount]/$totalposts[postcount]) * 100); if($topposter == true) { $avatarurl = fetch_avatar_url($user[userid]); if (!$avatarurl) { $useravatar = 'images/misc/avatar.png'; } else { $useravatar = $avatarurl[0]; } $output_bits .='<div align="center"> <img border="0" src="'.$useravatar.'"><br /> <a target="_self" href="member.php?u='.$user[userid].'">'.$user[username].'</a><br /> '.$user[usertitle].'<br /> '.$posts.': '.$user[postcount].'<br /> </div><hr />'; $topposter = false; } else { $output_bits .= '<a target="_self" href="member.php?u='.$user[userid].'">'.$user[username].'</a><div style="text-align: right;margin-top:-15px;">'.$user[postcount].'</div>'; } } $output = $output_bits; ob_end_clean(); Enjoy TazDevilLooney |
#45
|
|||
|
|||
Awesome! Thanks xD
Is there a way that we can have this for forum sideblock? |
#46
|
|||
|
|||
installed, much appreciated. I just set my for 2 hours . If its slow, I dont care
|
#47
|
|||
|
|||
Yes you sould be able to add it to a forum block. Try this....
AdminCP -> Forums and Moderators -> Forum Block Manager -> Add Block Pick -> Custom HTML/PHP Change title to what you want! Content type -> PHP Copy the code in to the Content Box That sould be it.... TazDevilLooney -> Update <- Tested it my self and works fine enjoy............. |
#48
|
|||
|
|||
i can make it as a forum and with MANY groups....
Code:
Database error in vBulletin 4.0.5: Invalid SQL: SELECT user.userid, user.username, user.usertitle, COUNT(post.postid) AS postcount FROM user LEFT JOIN post ON post.userid=user.userid AND dateline>'1277953200' WHERE usergroupid IN (Array) GROUP BY user.userid ORDER BY postcount DESC LIMIT 5; MySQL Error : Unknown column 'Array' in 'where clause' Error Number : 1054 Request Date : Friday, July 30th 2010 @ 06:47:57 PM Error Date : Friday, July 30th 2010 @ 06:47:57 PM Script : http://www.ccccc.com/forum.php Referrer : http://www.cccc.com/admincp/index.php?do=head IP Address : 201.253.32.50 Username : xxxxxx Classname : vB_Database MySQL Version : 5.0.90 Code used: Code:
$grouparray = "2,28,23,26,24,25"; $groupids = explode(',',$grouparray); $posts = "Posts"; ob_start(); require_once('./includes/functions_user.php'); require_once('./includes/functions_bigthree.php'); // Current Month Top Posters $starttime = mktime(0, 0, 0, date('m'), 1, date('Y')); // Get Top Members for current month $mostactivemonth_get = vB::$db->query_read(" SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle, COUNT(".TABLE_PREFIX."post.postid) AS postcount FROM ".TABLE_PREFIX."user LEFT JOIN ".TABLE_PREFIX."post ON ".TABLE_PREFIX."post.userid=".TABLE_PREFIX."user.userid AND dateline>'".$starttime."' WHERE usergroupid IN ($groupids) GROUP BY ".TABLE_PREFIX."user.userid ORDER BY postcount DESC LIMIT 5"); $topposter = true; $output_bits = ''; while($user = vB::$db->fetch_array($mostactivemonth_get)) { $percentage = round(($user[postcount]/$totalposts[postcount]) * 100); if($topposter == true) { $avatarurl = fetch_avatar_url($user[userid]); if (!$avatarurl) { $useravatar = 'images/misc/avatar.png'; } else { $useravatar = $avatarurl[0]; } $output_bits .='<div align="center"> <img border="0" src="'.$useravatar.'"><br /> <a target="_blank" href="member.php?u='.$user[userid].'">'.$user[username].'</a><br /> '.$user[usertitle].'<br /> '.$posts.': '.$user[postcount].'<br /> </div><hr />'; $topposter = false; } else { $output_bits .= '<a target="_blank" href="member.php?u='.$user[userid].'">'.$user[username].'</a><div style="float: right;">'.$user[postcount].'</div><br />'; } } $output = $output_bits; ob_end_clean(); |
#49
|
|||
|
|||
Quote:
|
#50
|
|||
|
|||
Quote:
|
#51
|
|||
|
|||
Yes you sould be able to add it to a forum block. Try this....
AdminCP -> Forums and Moderators -> Forum Block Manager -> Add Block Quote:
Code:
$posts = "Posts"; ob_start(); require_once('./includes/functions_user.php'); require_once('./includes/functions_bigthree.php'); // Current Week Top Posters $starttime = mktime(0, 0, 0, date('n'), date('j'), date('Y')) - ((date('N')-1)*3600*24); // Get Top Members for current week $mostactiveweek_get = vB::$db->query_read(" SELECT ".TABLE_PREFIX."user.userid, ".TABLE_PREFIX."user.username, ".TABLE_PREFIX."user.usertitle, COUNT(".TABLE_PREFIX."post.postid) AS postcount FROM ".TABLE_PREFIX."user LEFT JOIN ".TABLE_PREFIX."post ON ".TABLE_PREFIX."post.userid=".TABLE_PREFIX."user.userid AND dateline>'".$starttime."' WHERE usergroupid=2 GROUP BY ".TABLE_PREFIX."user.userid ORDER BY postcount DESC LIMIT 5"); $topposter = true; $output_bits = ''; while($user = vB::$db->fetch_array($mostactiveweek_get)) { $percentage = round(($user[postcount]/$totalposts[postcount]) * 100); if($topposter == true) { $avatarurl = fetch_avatar_url($user[userid]); if (!$avatarurl) { $useravatar = 'images/misc/avatar.png'; } else { $useravatar = $avatarurl[0]; } $output_bits .='<div align="center"> <img border="0" src="'.$useravatar.'"><br /> <a target="_self" href="member.php?u='.$user[userid].'">'.$user[username].'</a><br /> '.$user[usertitle].'<br /> '.$posts.': '.$user[postcount].'<br /> </div><hr />'; $topposter = false; } else { $output_bits .= '<a target="_self" href="member.php?u='.$user[userid].'">'.$user[username].'</a><div style="text-align: right;margin-top:-15px;">'.$user[postcount].'</div>'; } } $output = $output_bits; ob_end_clean(); VB 4.0.5 Server Errors In Log = 0/None |
Thread Tools | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|