[LuisManson]

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.':&nbsp;'.$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();