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!

[Tyegurl]

okay now i ran the query if that was for me and if it wasn't i ran it anyway lol. it did something lol

now i can install it without a problem? (hopefully)

[derekivey]

Should work now. That error means the column was missing.

[Keyser S?ze]

think maybe an added feature of making the browser icons a link to the download page of that browser?

[derekivey]

Sounds like a good idea. I will think about it and add it if I it doesn't involve a lot of work.

[Keyser S?ze]

ok my server got hacked, so i had to have the OS reinstalled and all that, i backed up the site files and the database and alll, but since then this hack has not worked

i tried updating it, but that doesnt fix it, i tried uninstalling it, and i get this error

Database error in vBulletin 3.5.4:

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

MySQL Error : Can't DROP 'browser'; check that column/key exists
Error Number : 1091
Date : Thursday, July 27th 2006 @ 12:42:53 AM
Script : http:///forums/admincp/plugin.php
Referrer : http:///forums/admincp/plugin.php?do...wser_on_wol&s=
IP Address :
Username : Ice
Classname : vb_database

i went in the mysql and its right its just not there, however vb shows that it is, as u can see in the attachments, now i dont know what to do can anyone offer me some assistance? maybe some manual mysql commands

[derekivey]

This query should fix it...

[sql]ALTER TABLE `session` ADD `browser` VARCHAR( 50 ) DEFAULT '' NOT NULL[/sql]

Be sure to add your table prefix to it if you have one.

Derek

[Keyser S?ze]

sadly it still does not work, ill tell u another problem i am having, maybe they are related i dont know, anyone that is not currently logged in, gets a mysql error when they go to the forums, but if ur already logged in, then ur fine everything works

well except this hack

[bashy]

Hi

I too had this error, but only with 1 member, it was down to his browser, but i ended up uninstalling in case other potential members had the issue!!

[Keyser S?ze]

not the same thing man, thats just cuz sometimes it dont read it and gets an unknown error,

[bashy]

not quite...this member in paticular could not login at all unless 1: i disabled or 2: he used a different browser, It also gave me sql errors same as you...

I didnt have that many members at the time hence it was only him and no one else!!