Browser on Who's Online

Browser on Who's Online
Developers: derekivey
Version: 1.0.2
vBulletin Version: 3.5.5 (3.6.0 version available here)
File Edits: 2
Template Edits: 1
New Phrases: 8
Uses Plugins: Yes
Difficulty: Easy

Description: This hack will show each user's browser in the Who's Online Box beside their name. It supports IE, Firefox, Opera, Camino, Safari, Konqueror, and Netscape. If the user is using a browser that is unsupported with this hack, it will show a Question mark icon, which means its an Unknown browser.

*** I Strongly Recommend That You Backup Before Installing/Upgrading This Hack! ***

Planned features for a later release:

• Add support for more browsers.
• Add browser to online.php
• Show only 1 image for each browser when there is more than 1 person with that browser.
• Whatever is suggested.

Features/Changes in Version 1.0.2:

• Fixed SQL bug

Features/Changes in Version 1.0.1:

• Moved browsers to session table.
• Removed 'Unknown' from being stored in database, replaced it with Psionic Vision's suggestion.

This was a hack request by ReadOrDie.

Note: If you are using vBadvanced CMPS, please follow 350Chevy's post to get this hack working on it, if you want to show their browser on the CMPS' Who's Online.

I have added screen shots of this hack in action below.

Please click If you installed this hack.

Thanks!

[bashy]

PM on way...

As for installing out to do with the sessions, not sure, i cant emember sorry, but i am sure you can see for ya self m8, I have 1 or 2 installed pmsl....

Originally Posted by derekivey

Hmm, thats a weird error. Want to PM me admin access details so I can take a look? Also have you installed any hacks that modify user sessions?

Thanks,
Derek

[bashy]

Hi m8

I have got to the bottom of this..

Its his firewall blocking ya script....
He is using sygate

[derekivey]

Thats really weird lol. It just uses vB's is_browser function to determine the browser, so I guess your right. His firewall must be blocking access to your forum somehow.

[bashy]

Very m8 lol...Like i say, turn ya hack off and he gets in no problem lol

Originally Posted by derekivey

Thats really weird lol. It just uses vB's is_browser function to determine the browser, so I guess your right. His firewall must be blocking access to your forum somehow.

[rza733]

I have a huge problem... When i try to uninstall this it gives me a DB error

Database error in vBulletin 3.5.0:

Invalid SQL:
ALTER TABLE `session` DROP `browser`;;

MySQL Error  : Can't DROP 'browser'; check that column/key exists
Error Number : 1091
Date         : Sunday, February 5th 2006 @ 12:30:31 PM
Script       : http://www.rzasspot.com/admincp/plugin.php
Referrer     : http://www.rzasspot.com/admincp/plugin.php?do=productdelete&productid=browser_on_wol&s=
IP Address   : 70.228.161.236
Username     : RzA
Classname    : vb_database

any suggestion on what to do?? Im using 3.5.0

[derekivey]

You can ignore that error. That just means that field doesn't exist in your database.

If it won't let you uninstall completely, just edit the product and remove the uninstall code.

Derek

[rza733]

Originally Posted by derekivey

You can ignore that error. That just means that field doesn't exist in your database.

If it won't let you uninstall completely, just edit the product and remove the uninstall code.

Derek

Ok that seemed to work thank you...

for some reason when i had it installed i kept gettin DB errors

[rza733]

I am now getting this error

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE session SET browser='internet_explorer' WHERE userid='80';

MySQL Error  : Unknown column 'browser' in 'field list'
Error Number : 1054
Date         : Sunday, February 5th 2006 @ 02:46:38 PM
Script       : http://www.rzasspot.com/vbshout.php
Referrer     : http://www.rzasspot.com/index2.php?
IP Address   : 66.245.131.35
Username     : Wild1LORI
Classname    : vb_database

any idea why?

[derekivey]

That means it didn't insert the browser field to the session table. To fix it run this query in PHPMyAdmin or vB's Query page in the AdminCP:
[sql]
ALTER TABLE `session` ADD `browser` VARCHAR( 50 ) DEFAULT '' NOT NULL;
[/sql]

[rza733]

Originally Posted by derekivey

That means it didn't insert the browser field to the session table. To fix it run this query in PHPMyAdmin or vB's Query page in the AdminCP:
[sql]
ALTER TABLE `session` ADD `browser` VARCHAR( 50 ) DEFAULT '' NOT NULL;
[/sql]

thanks again man!!!