vB4 Username Font Selection Per User (Light) By BOP5 VB4

[ven0m]

Heisenberg submitted a new resource:

You must be registered for see links

- Username Font Selection Per User (Light) By BOP5 VB4

vB Version: 4.x.x

Version 1.0 - Initial Release
Version 1.1 - Bugfix for vB 4.1.4 and above
Version 1.7.7 - Critical Security Update
Version 1.8.0 - Added post count setting / Added existing Markup setting

The purpose of this mod is to let users pick a custom font (either from a list you specify or optionally, a custom font they choose) to show up wherever username markup is allowed. (The postbit, profiles, who's online, blogs, CMS, etc...)

This is the free...

You must be registered for see links

 

[ven0m]

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.

This is a vBulletin bug, not a bug with this mod.

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):

[B][B][SIZE=2][I][B][B][B][B]//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
");[/B][/B][/B][/B][/I][/SIZE][/B][/B]

and delete the line $hook_query_fields so you make it:

[B][B][SIZE=2][I][B][B][B][B]//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
");[/B][/B][/B][/B][/I][/SIZE][/B][/B]

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 added an option to simply disable the mod on "Who's Online" to avoid this bug.

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