vBulletin Forum Sideblocks - Current Staff Online Forum Sideblock and CMS Widget by BOP5

Brought to you by BirdOPrey5
www.Qapla.com

New Version: 0.99 Beta
New in 0.99

• Added Widget
• Added Settings instead of manual configuration
• Added phrases for "None" and "No staff currently online." text.
• Made code more compatible with older VB Versions (should work in 4.1.x now)

This is my first attempt at a Sideblock and Widget. The purpose of this is to list all forum staff members online.

There are settings to choose which usergroups are considered staff groups and for other basic settings.

The product .xml file contains the necessary templates and phrases but you will need to manually install the sideblock code itself and/or manually create the widget.

Specific installation instructions are in the .txt file in the zip file but the overall process is:

• Upload the Product XML File
• Add code to additional.css template
• Edit Settings in Admin CP -> Options to setup your options
• Create Sideblock (if using Sideblock)
• Create Widget (if using widget)
• Add Widget to Layout(s) (if using widget)

Overall this is working well- it is Beta as it's my fist Sideblock and Widget. I know it works on VB 4.2.0 but it should work on earlier versions as well (code was revised in Beta 0.99 for greater compatibility.)

If you get an error at the top of the browser window when you enable the sideblock or widget you know your VB version is too old.

In addition to working with my Font Selection by Username mod it will also work withe my Sidebar Anywhere mod.

Does not work with "Everywhere Sidebar" mod but DOES work with MY "Sidebar Anywhere" mod.

------------------------------------------------------

Please "Mark as Installed" if you use this.
Donations always appreciated. :up:
Nominate MOTM if you LOVE it!

[Marcin1]

How to reorder of the groups displayed? I've got Mod currently on top, Admin below.

[Mark_Zuckerberg]

how to create site block to show staff online i am also using your add on sidebar everywhere after installing this mod edited its settings but when i go to forum block i cant see any block of staff online to create?

[ozzy47]

Did you do this part of the instructions?

Go to Admin CP -> Forums & Moderators (on the side menu) -> Forum Blocks Manager

Click on "Add Block"

Choose "Custom HTML/PHP" from the drop down menu and click "Continue"

Title: Staff Online by BOP5
Description: Sideblock shows current forum staff online.
Cache Time: 1
Display Order: (Your Choice)

Content Type: PHP
Template to use: block_staff_online_bop5

Content:

<<<<<<< COPY BELOW THIS LINE >>>>>>>>

PHP Code:

global $vbulletin, $vbphrase;
$vbo = &$vbulletin->options;

if ($vbo['bop5sob_en'])
{
    $staff_usergroupids = $vbo['bop5so_groups']; 
  
    $bopshowav = $vbo['bop5so_showav'];
  
    $dofonts = $vbo['bop5so_intfont'];   
    $dosizes = $vbo['bop5so_intsize'];                 
    $docolor = $vbo['bop5so_intcolor'];                 
      
    $showinvisible = $vbo['bop5so_showinvis'];
    
    $nostaffuser = $vbphrase['bop5_staff_online_none'];
    $nostaffusertitle = $vbphrase['bop5_staff_online_no_staff'];

  if (THIS_SCRIPT != 'index') 
  {
     require_once(DIR . '/includes/functions_bigthree.php');
  } 


  $cooktimeout = TIMENOW - $vbulletin->options['cookietimeout'];
  $staffcount = 0;

  $bop5_fields = '';

  if ($dofonts)
    $bop5_fields .= " , user.bop5_userfont AS bop5_userfont ";

  if ($dosizes)
    $bop5_fields .= " , user.bop5_usersize AS bop5_usersize ";

  if ($docolor)
    $bop5_fields .= " , user.bop5_usercolor AS bop5_usercolor ";


  if ($showinvisible)
  {
    $forumstaff = $vbulletin->db->query_read_slave("
        SELECT
            user.username, user.usergroupid, user.lastvisit, user.usertitle,
            session.userid, session.inforum, session.lastactivity,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
            $bop5_fields
        FROM " . TABLE_PREFIX . "session AS session
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = session.userid)
        WHERE session.lastactivity > $cooktimeout AND user.usergroupid IN (".$staff_usergroupids .")
        ORDER BY username ASC");
  }
  else
  {
    $forumstaff = $vbulletin->db->query_read_slave("
        SELECT
            user.username, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, user.usergroupid, user.lastvisit, user.usertitle,
            session.userid, session.inforum, session.lastactivity,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
            $bop5_fields
        FROM " . TABLE_PREFIX . "session AS session
        LEFT JOIN " . TABLE_PREFIX . "user AS user ON(user.userid = session.userid)
        WHERE session.lastactivity > $cooktimeout AND user.usergroupid IN (".$staff_usergroupids .")
        ORDER BY username ASC");
  }

  $bp5i = 0;
  while ($staffon = $vbulletin->db->fetch_array($forumstaff))
  {
      $bp5i++;
      $userid = $staffon['userid'];    
      $userinfos[$userid] = $staffon;
  }

  if (!$bp5i) //No Staff Online
  {
      $userid = 0;    
      $userinfos[$userid] = $staffon;  
      $staffon['showav'] = 0;
      $staffon['musername'] = $staffon['username'] = $nostaffuser;
      $staffon['usertitle'] = $nostaffusertitle;
      $staffon['none'] = true;
      $activestaff[0] = $staffon;
  }
  else
  {
    $activestaff = array();
    foreach ($userinfos AS $userid => $staffon)
    {
        fetch_musername($staffon);
        
        $staffon['none'] = false;
        $staffon['showav'] = $bopshowav;
        
        if ($bopshowav)
        {
          require_once('./includes/functions_user.php');
          
          $staffon['avatarurl'] = fetch_avatar_url($staffon['userid']);

          if (!$staffon['avatarurl']) 
            $staffon['avatarurl'] = $stylevar['imgdir_misc'] . 'images/misc/unknown.gif'; 
          else 
          { 
            $staffon['avatarurl'] = $vbulletin->options['bburl'] . '/' . 
            $staffon['avatarurl'][0];   
          }     
        }

        if (fetch_online_status($staffon))
        {
            $staffcount++;
            $activestaff[$staffcount] = $staffon;
        }
    }
  }

  unset($userinfos, $staffon);

  $vbulletin->db->free_result($forumstaff);

  $staffsarray = array('activestaff'    => $activestaff); 

  return $staffsarray;
} 


[Mark_Zuckerberg]

YAAAAYYYYYY!!!!

after posting that code which you have mentioned is working fine.... by the way that code is not mentioned in the readme file nor on the post page? it must be added iznt that? thanks much much for the help you are great

[ozzy47]

It is in the text document that came with this mod, it is named, Staff Online Sideblock & Widget by BOP5 Install

[Mark_Zuckerberg]

True sorry my bad i appologize i didnt scrooled down till end :/ thats why it occurs thank you dear

[ozzy47]

It's cool, it happens to all of us at some point.

[Buzzle]

Any idea why i'm getting a databaser error?

Invalid SQL:

        SELECT
            user.username, user.usergroupid, user.lastvisit, user.usertitle,
            session.userid, session.inforum, session.lastactivity,
            IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
             , user.bop5_userfont AS bop5_userfont 
        FROM vB_session AS session
        LEFT JOIN vB_user AS user ON(user.userid = session.userid)
        WHERE session.lastactivity > 1408204549 AND user.usergroupid IN (13,14,5,7,6,-1)
        ORDER BY username ASC;

MySQL Error   : Unknown column 'user.bop5_userfont' in 'field list'

[CAG CheechDogg]

Bummer..even with the update this still doesn't work for me ...I get the following error:

Warning: Invalid argument supplied for foreach() in [path]/includes/class_core.php(4606) : eval()'d code on line 12

[CAG CheechDogg]

Any idea about this BOP5? ....