The Arcive of Official vBulletin Modifications Site.

Current Staff Online Forum Sideblock and CMS Widget by BOP5 · **Released**: 06-18-2012

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!

CAG CheechDogg · #**172** 01-06-2016, 01:35 PM

Quote:

Originally Posted by BirdOPrey5

Exact PHP version and VB Version?

I sent you a pm with the information BOP5 ... I rather not post it for security reasons ... hope you understand

geosharing · #**173** 02-05-2016, 09:54 AM

not working at my side i am setup all things but now active ..

WindVoice · #**174** 01-10-2017, 08:51 PM

How to order admins by their usergroups.

XotelHotel · #**175** 02-12-2017, 03:24 PM

Hey loving the Mod installed it all right did the Forum Block due toi me not havingf the CMS to do widget yet i see nothing on the main style help

update fixed the 1st half it dosn't show the new post and other things on the slider and i am useing the alternertave slider from your mod help
also this pops up when i useing your slider

Code:

PHP Warning: mysqli_query(): (42S22/1054): Unknown column 'user.bop5_userfont' in 'field list' in ..../includes/class_core.php on line 1394
Database Error	Database error
The Habbolution database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the forums.habbolution.com home page, then try to open another page.
Click the Back button to try another link.
The forums.habbolution.com forum technical staff have been notified of the error, though you may contact them if the problem persists.
 
We apologise for any inconvenience.

Database error in vBulletin 4.2.3:

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  , user.bop5_usersize AS bop5_usersize  , user.bop5_usercolor AS bop5_usercolor 
        FROM session AS session
        LEFT JOIN user AS user ON(user.userid = session.userid)
        WHERE session.lastactivity > 1486939441 AND user.usergroupid IN (7,2,6,10,13,16,17,11,14,18,9,19,12,15,20,-1)
        ORDER BY username ASC;

MySQL Error   : Unknown column 'user.bop5_userfont' in 'field list'
Error Number  : 1054
Request Date  : Sunday, February 12th 2017 @ 10:59:01 PM
Error Date    : Sunday, February 12th 2017 @ 10:59:01 PM
Script        : http://forums.habbolution.com/forum.php
Referrer      : http://forums.habbolution.com/forum.php
IP Address    : My IP been removed on here for secruity Reasons
Username      : YTFilthyAngelOfHype
Classname     : vB_Database_MySQLi
MySQL Version : 10.1.18-MariaDB

XotelHotel · #**176** 02-13-2017, 02:17 PM

@BOP5

BirdOPrey5 · #**177** 02-14-2017, 07:09 PM

Hello,

I see your post, but I'm sorry this mod is unsupported. I hate this mod, it worked(s) for most people but it was an ugly mod to build and I don't have the time to support it. I'm sorry.

The code is marked re-usable in case someone else wants to take it over.

yilmaz · #**178** 01-18-2018, 01:46 AM

Quote:

Originally Posted by BirdOPrey5

Hello,

I see your post, but I'm sorry this mod is unsupported. I hate this mod, it worked(s) for most people but it was an ugly mod to build and I don't have the time to support it. I'm sorry.

The code is marked re-usable in case someone else wants to take it over.

Thank you for marking the reusable code.

I made some changes for easy installation.

If you allow, I would like to share it with another topic.

Thank you!

CAG CheechDogg · #**179** 01-18-2018, 02:40 AM

Quote:

Originally Posted by yilmaz

Thank you for marking the reusable code.

I made some changes for easy installation.

If you allow, I would like to share it with another topic.

Thank you!

He said it's reusable so I am sure he doesn't mind ...

BirdOPrey5 · #**180** 01-20-2018, 03:05 PM

Quote:

Originally Posted by yilmaz

Thank you for marking the reusable code.

I made some changes for easy installation.

If you allow, I would like to share it with another topic.

Thank you!

Quote:

Originally Posted by CAG CheechDogg

He said it's reusable so I am sure he doesn't mind ...

CAG CheechDogg is correct, if it's marked reusable it means you are free to repost it under your own thread on vBulletin.org. Please just mention/link to where you got the code from in your post.

ramesh_umk3 · #**181** 02-03-2020, 10:57 AM

For https support use below code

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'] = str_replace('http','https',$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;
}

Credits: Exp500

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05009 seconds Memory Usage 2,387KB Queries Executed 28 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_code (5)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (4)navbar_link (120)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)pagenav_pagelinkrel (11)post_thanks_box (17)post_thanks_box_bit (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (4)post_thanks_postbit (11)post_thanks_postbit_info (10)postbit (11)postbit_attachment (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start fetch_musername post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end post_thanks_function_fetch_thanks_bit_start post_thanks_function_show_thanks_date_start post_thanks_function_show_thanks_date_end post_thanks_function_fetch_thanks_bit_end post_thanks_function_fetch_post_thanks_template_start post_thanks_function_fetch_post_thanks_template_end postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_attachment postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

11 благодарности(ей) от:
akz645, Alex@bulletin, blind-eddie, findingpeace, Gemma, Hornstar, NoMatt3r, sodasusu, t-j, Taurus1, Techno Cowboy

2 благодарности(ей) от:
BirdOPrey5, CAG CheechDogg

3 благодарности(ей) от:
CAG CheechDogg, Fenomeno10, yilmaz

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!