vb.org Archive - vBulletin Forum Sideblocks - Current Staff Online Forum Sideblock and CMS Widget by BOP5

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - vBulletin Forum Sideblocks - Current Staff Online Forum Sideblock and CMS Widget by BOP5 (https://vborg.vbsupport.ru/showthread.php?t=284617)

after selecting the usergroups that are to be classified as "staff" and then clicking save will reload the page as normal but then none of the usergroups that were previously selected....are then ALL un-ticked.

No 'extra' usergroups showed up for me either...
then I got a big database error very similar to Cheechdog

Bottom line is once I got it back to working it still didn't show any group besides admin/mods... no other group I checked (which was an option to do) showed up while that group was online for quite some time.

Quote:

Originally Posted by Buzzle (Post 2511526)

Any idea why i'm getting a databaser error?

Code:

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'

You likely do not have the "PER USERNAME COLOR, SIZE, FONT MOD" installed and have set one or more of the options depending on this mod to yes. Try setting those last 3 options to "No" and see if you have bliss...:D

Installed and working just fine with 4.2.2

Can someone look into why this doesn't work on 4.1.x ....

What exactly isn't working? Are you getting an error? A white screen? nothing? Did you try the sideblock or cms widget? both? What version of VB and PHP exactly? You should include this basic info if a mod isn't working, just reporting it not working is useless. Need to give me something to work with. Thanks.

Quote:

Originally Posted by CAG CheechDogg (Post 2511536)

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

Quote:

Originally Posted by BirdOPrey5 (Post 2562025)

I asked about this before BOP5s ...

The sidebar block doesn't display anything at all and the error mentioned above pops up ...

Exact PHP version and VB Version?

Quote:

Originally Posted by BirdOPrey5 (Post 2562076)

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

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

How to order admins by their usergroups.

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

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.

Quote:

Originally Posted by BirdOPrey5 (Post 2582345)

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 yilmaz (Post 2592315)

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 ...

Quote:

Originally Posted by yilmaz (Post 2592315)

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 (Post 2592316)

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.

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

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01360 seconds Memory Usage 1,803KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (20)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: