vb.org Archive

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)

CAG CheechDogg 01-06-2016 01:35 PM

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

geosharing 02-05-2016 09:54 AM

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

WindVoice 01-10-2017 08:51 PM

How to order admins by their usergroups.

XotelHotel 02-12-2017 03:24 PM

1 Attachment(s)
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 02-13-2017 02:17 PM

@BOP5

BirdOPrey5 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 01-18-2018 01:46 AM

1 Attachment(s)
Quote:

Originally Posted by BirdOPrey5 (Post 2582345)
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 01-18-2018 02:40 AM

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

BirdOPrey5 01-20-2018 03:05 PM

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.

ramesh_umk3 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


All times are GMT. The time now is 06:13 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01197 seconds
  • Memory Usage 1,760KB
  • 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
  • (2)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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