Forum Home Enhancements - Browser on Who's Online

Browser on Who's Online
Developers: derekivey
Version: 1.0.3
vBulletin Version: 3.6.4 (3.5.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.3:

• Fixed bug where some of you were just getting unknown for everyone's browser.

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 Install If you installed this hack.


Thanks!

[derekivey]

Originally Posted by tansu

well installed, then unistalled and this happened..

MySQL Error  : Unknown column 'browser' in 'field list'
Error Number : 1054

Forum gone? any ideas?

Try editing the current product you have installed, and remove the uninstall code, that should let you uninstall it now. I think you somehow got rid of the field in the sessions table. Once you remove the uninstall code, then try importing the new product file.

Originally Posted by Bison

Thanks for updating your hack, but why didn't you add the "other browsers" in this version?

Those will be in a later version, this was just a quick port of my 3.5 version.

[ubblite]

I went to uninstall this hack because it wasn't showing a few common browsers and had problems as well.

Here is the error:

Database error in vBulletin 3.6.4:

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

MySQL Error  : Can't DROP 'browser'; check that column/key exists
Error Number : 1091
Date         : Tuesday, December 12th 2006 @ 07:14:15 AM
Script       : http://www.xxxxxxxxxxxxxxxx/forum/ad...do=productkill
Referrer     : http://www.xxxxxxxxxxxxxxxx/forum/ad...wser_on_wol&s=
IP Address   : -----------------
Username     : -----------------
Classname    : vB_Database

---------------------------------------

Please help.

[Snake]

Wow! I love this.

[tansu]

Originally Posted by derekivey

Try editing the current product you have installed, and remove the uninstall code, that should let you uninstall it now. I think you somehow got rid of the field in the sessions table. Once you remove the uninstall code, then try importing the new product file.

That did it..
thanks.

[projectego]

Excellent!

[Distance]

This is rubbish, everyone is getting errors, same as me

Database error in vBulletin 3.6.4:

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

MySQL Error : Can't DROP 'browser'; check that column/key exists
Error Number : 1091
Date : Tuesday, December 12th 2006 @ 04:24:38 PM
Script : http://SITE/admincp/plugin.php?do=productkill
Referrer : http://SITE/admincp/plugin.php?do=pr...wser_on_wol&s=
IP Address : 172.159.132.228
Username : Distance
Classname : vb_database

[Distance]

Also removing the uninstall code, wont that just be leaving the tables there?

[asj]

Database error in vBulletin 3.6.4:

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

MySQL Error : Can't DROP 'browser'; check that column/key exists
Error Number : 1091
Date : Tuesday, December 12th 2006 @ 08:52:59 PM
Script : http://www.asj.com/forum/admincp/plu...do=productkill
Referrer : http://www.asj.com/forum/admincp/plu...&productid=&s=
IP Address : 127.0.0.1
Username : asj
Classname : forum_database
??

[silks]

nice hack and currently using it - thanks

can u tell me if its possible to remove the space between the gif and the users name?

im using it on the cmps - leftblock

[ubblite]

Originally Posted by Distance

Also removing the uninstall code, wont that just be leaving the tables there?

That was the only way I was able to uninstall this hack, but I think you're right - the tables are still there so it's not really uninstalled. Reinstalling & then uninstalling the hack also didn't work. There is an obvious bug with this modification that needs to be fixed.