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]

Sure, I will update it for 3.6.0. The update should be out tomorrow.

Thanks,
Derek

[Tyegurl]

wow thanks sooooooooooooo much!!!

[derekivey]

Actually, I just tried it, and there is no need for me to release a 3.6 version, because it works fine on 3.6. Make sure that you redid the file edits when you upgraded to vB 3.6. If it still isn't working, tell me whats happening so I can try and figure out whats wrong.

Thanks,

Derek

[Tyegurl]

Originally Posted by derekivey

Actually, I just tried it, and there is no need for me to release a 3.6 version, because it works fine on 3.6. Make sure that you redid the file edits when you upgraded to vB 3.6. If it still isn't working, tell me whats happening so I can try and figure out whats wrong.

Thanks,

Derek

will do....i think i reverted my templates but i think i redid them....probably not though

[OndaReal]

I attempted to install this but i kept getting a database error so i uninstalled everything and now my Avatars have dissapeared. Instead of the avatars being there, theres a link instead for example "Username avatar" If i click on the avatar it takes me to the members profile and again where the avatar should be in the members profile it says "username avatar"

[derekivey]

What database error were you getting? Also this shouldn't mess with the avatars at all, because it doesn't modify anything related to the avatars.

Derek

[Tyegurl]

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 session AS session
LEFT JOIN user AS user ON(user.userid = session.userid)
WHERE session.lastactivity > 1151261698
ORDER BY username ASC;

MySQL Error : Unknown column 'session.browser' in 'field list'
Error Number : 1054
Date : Sunday, June 25th 2006 @ 12:09:59 PM
Script : http://www.teamrespawn.com/vBulletin/forum.php
Referrer : http://www.teamrespawn.com/vBulletin...?p=323#post323


and no i did the edits still a no go

[derekivey]

Ok, Open PHPMyAdmin, and execute the following SQL query...
[sql]ALTER TABLE `session` ADD `browser` VARCHAR( 50 ) DEFAULT '' NOT NULL[/sql]

That should fix it.

Derek

[Shazz]

Isen't this the same as pauls?
________
Mercedes-Benz W463 specifications

[derekivey]

Which one? Link please...