vBulletin CMS Widgets - Widget: Top 5 Posters this Week

......................................

[javivi0]

hi, thanks for mod !!!!! I installed !!!

one question??? can I add this code in vbblock for sidebar of the forum?

thanks

[k1klass]

Changed the id to guild group, but top poster displays - Posts:%u00A066

any idea's?

[CORSO]

Me too

[rikmac]

Me Too.

[rikmac]

Ok, try this code, and ad your group id: in $grouparray = "2,3,4,5,"; in the first line.

$grouparray = "2";
$groupids = explode(',',$grouparray);

$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."'
      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="_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();

[MOGmartin]

Originally Posted by javivi0

hi, thanks for mod !!!!! I installed !!!

one question??? can I add this code in vbblock for sidebar of the forum?

thanks

Ive tried, no luck, althought Id love this for the forum area only...

any ideas anyone?

[MedellinStyle]

hi Maria, How to apply this code in a sidebar block?????

[pcalloway]

Having to uninstall this - it crashed my website with mysql errors as well.

mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Lost connection to MySQL server during query
/home/authent/public_html/forum/includes/class_core.php on line 312
MySQL Error :
Error Number :
Request Date : Wednesday, March 3rd 2010 @ 03:31:44 PM
Error Date : Wednesday, March 3rd 2010 @ 03:31:44 PM
Script : http://www.authentic-campaigner.com/...and=1267648292
Referrer : http://www.authentic-campaigner.com/forum/content.php?
IP Address : xxx.xxx.xxx.xxx
Username :
Classname : vB_Database
MySQL Version :

[KHALIK]

I've installed this on vb 4.0.2 and is working fine.

Installed it on my home page.

[neudimenxion]

Installed. Just the member's profile photo didn't appear though already add in the photo in the profile page. I want exactly like the screen shot. What's the matter with my installation.

TQ.