i can make it as a forum and with MANY groups.... :(
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:
$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();