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)

cshellworld 12-02-2013 11:54 PM

4.2.1 installed , rating 5 , nominated
thanks

RedTrinity 01-29-2014 08:09 AM

Hi, just installed this for the first time, followed the instructions, getting this SQL error when I activate the block, which messes up the forum:

Quote:

Database error in vBulletin 4.2.2:

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

FROM redtrin_session AS session
LEFT JOIN redtrin_user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1390984366 AND user.usergroupid IN ()
ORDER BY username ASC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY username ASC' at line 8
I've double checked everything, can't seem to work out where the problem is. Help!

:)

warfield 02-27-2014 12:37 PM

:( i dont know how to edit additional.css

Meler 03-01-2014 05:10 PM

You can add sorting displayed groups?

edgeless 03-13-2014 02:24 AM

I've just installed this. How do you change the block title 'Current Staff Online' to something else? Changing the title in the 'edit block' form makes no difference.

ozzy47 03-13-2014 02:26 AM

Try changing the phrase bop5_staff_online

edgeless 03-13-2014 03:08 AM

Oh yeah. Thanks :)

ozzy47 03-13-2014 03:13 AM

Not a problem, glad to help. :)

edgeless 03-13-2014 02:58 PM

Well, here's one issue that I'm noticing... the current settings within the provided additional.css code tend to squeeze the larger avatars to the point of image distortion. For example, we have some staff avatars that are 180px × 120px and they end up looking very squeezed within the sidebar.

The actual aspect ratios of member avatars can however be preserved by changing max-width: 40px; to max-width: 60px; ...however, that misaligns the usernames and titles because they are each positioned the same distance from their respective multiple-width avatars.

So my choices seem to be: 1) accept the overly squeezed larger avatars, 2) accept the misaligned usernames, or 3) disable the display of avatars within this sideblock mod. The first two options don't look quite right. Playing around a bit, I've found that I can adjust the padding directive from 4px to, say, 24px. This will move the usernames farther toward the center of the sideblock. But unfortunately they are still misaligned.

I've noticed that various other sideblocks I add to the sidebar will auto-reduce avatar size proportionally in order to preserve aspect ratio and retain alignment of the text margin points. Can this somehow be done for this sideblock mod as well? And if not, is there any other solution that will allow the usernames and title text to line up while retaining the aspect ratios for larger avatars?

Other than this issue, I really love the mod!

Thanks

edgeless 03-13-2014 08:31 PM

Update:
I've changed the max-width to 54 pixels ...while it's not perfect, I think I can live with it if there's no other available solution.


All times are GMT. The time now is 06:15 PM.

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.01291 seconds
  • Memory Usage 1,735KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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