vb.org Archive - End-User Options - Username Font Selection Per User (Light) By BOP5 VB4

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

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

- - End-User Options - Username Font Selection Per User (Light) By BOP5 VB4 (https://vborg.vbsupport.ru/showthread.php?t=271892)

Thanks. :up:

I know when I was making this (which was actually weeks ago) I considered an option to keep any existing HTML markup present and just add to it, instead of replace it... but I don't remember why I didn't include it. I will have to check it out when I get time, might be something I can add in.

Getting weird error, and my Who's Online don't work with this....Is there a quick fix?....seems to Not like the UserNames listed in Who's online....much the same error as in above post by Sunka...or will it Not work in VB4.x at all?

Quote:

Originally Posted by rob39 (Post 2256581)

I would need to see the exact error to make a diagnosis...

The "quick fix" is to uninstall or disable for now until I can see the error.

You could UNINSTALL and attempt re-installing as well if you are up for it. If it is indeed the same error your board might have timed out making the database update.

Here's the error i got...the mod works in postbit, ect....just renders Who's online inoperable...???
Had the Mod running for about two hours, and never noticed anything wrong until i tried to go to Who's online....and the error shows then...who's online doesn't load

https://vborg.vbsupport.ru/external/2011/10/41.jpg

I am seeing it now.
Sorry about that.

The "quick fix" is to go to plugin manager and disable the plugin "Who's Online Query" for this mod, the errors should stop but I still need to fix whosonline so the markup works.

OK, very sorry about this but it looks like a bug was introduced in VB 4.1.4 where they accidentally re-used the same variable for new query causing this database error.

Currently affected versions are VB 4.1.4 - 4.1.7 and even though it's not out yet, 4.1.8 will probably have it too.

To fix the problem you will have to manually edit your file: online.php

Find the code (around line 277- may vary by version):

PHP Code:


		
			
//VBIV-5766 get the count of members and guests online.
$userscount = $db->query_read_slave("
    SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
    $hook_query_fields
    FROM " . TABLE_PREFIX . "session as session
    $hook_query_joins
    WHERE session.lastactivity > $datecut
    ". iif(!$showmembers, " AND session.userid < 1", "") ."
    $hook_query_where
    $where
    GROUP BY isuser
");

and delete the line $hook_query_fields so you make it:

PHP Code:


		
			
//VBIV-5766 get the count of members and guests online.
$userscount = $db->query_read_slave("
    SELECT IF(userid > 0, 1, 0) as isuser, COUNT(session.userid) as online_users
    FROM " . TABLE_PREFIX . "session as session
    $hook_query_joins
    WHERE session.lastactivity > $datecut
    ". iif(!$showmembers, " AND session.userid < 1", "") ."
    $hook_query_where
    $where
    GROUP BY isuser
");

And save and upload the fixed file. (Save a backup of the original of course.)

This will fix the database error on who's online.

I realize it is a pain to do a manual file edit so I release an update soon that will give you the option to disable display on who's online so you don't have to worry about the file edit.

Just to reiterate- VB versions below 4.1.4 are not affected by this bug.

Thanks for the fix....this is a nice mod....:)

Since i have't installed this yet do i have to still edit the online.php i am running 4.1.7 or the update you made today should be good to go?

If you want the mod to work on "Who's Online" you will need to edit the file. That will not go away until vBulletin fixes the bug in the future version.

OR you can just install the mod and leave the option to use it on "Who's Online" off and the mod will work everywhere else without issue, but it won't show the custom usernames on Who's Online.

X vBulletin 3.8.12 by vBS Debug 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_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01103 seconds Memory Usage 1,749KB 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_php_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (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
Messages: