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!

[derekivey]

Originally Posted by Hellraider

Got the same error as mentioned in post #16 on uninstalling version 1.0.1.

Manually reverting the template and file edits seems to be OK.

But product is still shown in installed product list and could not be removed.

How do I remove the entry in the product list?

Sorry about that, I'll take a look and get back to you.

Originally Posted by lanc3lot

- Can i have this only appear on the Who's Online page?

No, that is currently not in this hack. I am looking into adding it, and it should be in a new version...

Originally Posted by lanc3lot

Why is not working with the guests? I mean can it see what the guest browser is, and show approximately?

Currently, since your first question isn't in this hack, it can't show it for guests. When I add it to the Whos online page, I will make it show for guests too, but since guests don't show on the who's online box, it's not possible to show their browser with this hack.

Originally Posted by lan3lot

What will happen if we have special html markaps for our users in our forums? We use special mini icons for each of our usergroups. Will they be replaced from the browser icons or will display both of them (for this i only want to have it on my Who's Online page, prefferably with both the icons displayed)

If you keep your code in there and have the code for this hack, it should show both.

Derek

[Bubble #5]

Very nice hack Derek! We'll be adding it soon and look forward to the new features :nervous:

[lanc3lot]

Thnx for your replies, waiting for the new version

[Xtrato]

Edit: i fixed it it seems i needed to to the tempalte edits then the porduct before i do the index.php edit.

There seems to have been a problem with the 
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.5.2:

Invalid SQL:

		SELECT
			user.username, (user.options & 512) AS invisible, user.usergroupid,
			session.userid, session.browser, session.inforum, session.lastactivity,
			IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
		FROM vb3_session AS session
		LEFT JOIN vb3_user AS user ON(user.userid = session.userid)
		WHERE session.lastactivity > 1136662721
		ORDER BY username ASC;

MySQL Error  : Unknown column 'session.browser' in 'field list'
Error Number : 1054
Date         : Saturday, January 7th 2006 @ 01:53:41 PM
Script       : 
Referrer     : 
IP Address   : 
Username     : 
Classname    : vb_database

[bashy]

Edit ya IP address m8..tis best if ya do

[Xtrato]

Wow of all the things a deleted i left the ip wow thanks hehe

[bashy]

NP m8, just trying to help

Have fun

Bashy

[derekivey]

Hmm, for some reason the SQL query didn't get executed when you imported the product. Please run the following query in your AdminCP or PHPMyAdmin:
[sql]
ALTER TABLE `vb3_session` ADD `browser` VARCHAR( 50 ) DEFAULT '' NOT NULL;
[/sql]

Let me know if you still have any problems.

Derek

[murrtex]

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

MySQL Error : Can't DROP 'browser'; check that column/key exists
Error Number : 1091

uninstall problem I have...how can I fix it for uninstall???

[derekivey]

Just edit the product and remove the stuff in the uninstall code selected, then try uninstalling, that should fix it.