Browser on Who's Online

[derekivey]

Browser on Who's Online
Developers: derekivey (http://www.vbulletin.org/forum/member.php?u=81169)
Version: 1.0.2
vBulletin Version: 3.5.5 (3.6.0 version available here (http://www.vbulletin.org/forum/showthread.php?t=133784))
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 bugFeatures/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 (http://www.vbulletin.org/forum/member.php?u=110843).

Note: If you are using vBadvanced CMPS, please follow 350Chevy's post (http://www.vbulletin.org/forum/showpost.php?p=871310&postcount=64) 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 http://www.vbulletin.org/forum/images/smoothblue/buttons/installed.gif (http://www.vbulletin.org/forum/vborg_miscactions.php?do=installhack&threadid=103996) If you installed this hack.

Thanks!

[Impreza04]

Wow.. nice idea

I'll give this a go in a minute :)

[derekivey]

Thanks, let me know if you have any problems. I tested it on my public site and my test board and it works for me.

[Psionic Vision]

This hack has poor code for the following reasons:
- It does not treat strings as strings, rather as constants. PHP, however, will only show an error if there is an E_NOTICE error reporting turned on.
- It is completely unnecessary to alter user table and save browser informations.
- Addslashes() is deprected in vbulletin 3.5. Use $db->escape_string() instead.
- There is no point in the "unknown" value. That value will just take up db space. Why not make a default empty string which will return false when accessed. E.g. you can change <if condition="$loggedin[browser] == unknown"> to <if condition="!$loggedin[browser]"> if you do that.

That said, I like the idea. Only, I think I've seen the same thing released a couple of days ago. Maybe I have hallucations, Idk :(

[derekivey]

What do you mean it treats them as constants? Can I see an example of what you mean please?

Also, how would you suggest that I store the browsers then??

[Psionic Vision]

What do you mean it treats them as constants?

A string must be wrapped in single or double quotes.
When you call is_browser(ie), it looks for a constant IE. Because PHP is a very non-restrictive language, it then treats ie as a string, even though it is not; it will only display an error if E_NOTICE is enabled. But since vBulletin error reporting is E_ALL ^ E_NOTICE, you don't see the error.

The right way would be using is_browser('ie').

Also, how would you suggest that I store the browsers then??

I would store browser information in the session table, because there it is temporary and deleted automatically when the user leaves the board.

[derekivey]

Ok, I fixed the first thing. I'll take a look at the rest later. I uploaded a new zip file.

[Psionic Vision]

Nice. Also, you can get a list of all vbulletin-detectable browser from the is_browser function itself :)



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[swa]

nice idea!

[derekivey]

Ok, zip file has been updated. I changed addslashes to $db->escape_string.

[Psionic Vision]

Ok, now if you expand the browsers list and move browser identification storage to session table, that'll be the best.

Hint: class_core.php, line 2514:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[rb290]

mines displays on the "Members who have visited in the last 24 hours", and shows those ones as the ? picture, also how come all the pics are bordered by a blue box ?

[rb290]

this what looks like:

http://img506.imageshack.us/img506/20/jhj7yf.jpg

[derekivey]

Add border="0" to each of the images in the conditionals. That should fix it.

[rb290]

thanks
do you know how I can make it only appear on the Whos On Line?

[YOimYO]

ok. i have problems, and need to uninstall it. but the auto uninstaller isnt working. what do i need to delete off the database to remove this. ???






Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[YOimYO]

ok. i have disabled it. and my forum still works. but .... what changes were made to any temlates that i need to manually cahgne back ?

[derekivey]

What kind of problem were you having? Because that uninstall error means that the browser field was never added to the user table. If you want to just uninstall my hack, all you have to do now is just revert the edited templates or if you have customized them before you can just take out the edits you made for my hack. Also you will need to take out the file edits.

[YOimYO]

What kind of problem were you having? Because that uninstall error means that the browser field was never added to the user table. If you want to just uninstall my hack, all you have to do now is just revert the edited templates or if you have customized them before you can just take out the edits you made for my hack. Also you will need to take out the file edits.


yeah i did all that. was just wanting to make sure that it didnt do anything else that i needed to change :)


thx :)


but anyhow what i tried to do was install it on vb 3.5.0 and there is NO Skype ;)

so it gave errors, then sql erros .... but its back to norm. I would Like to try this on 3.5.0 though :)


let me know if you have a fix for the database table edits ;)



thx :)

[bashy]

Hi

I started to install this but once the manual edits were complete i checked my site and it gave a database error, so i removed all edits and now my Online Users looks like this..

a href="member.php?u=1">Bashy, a href="member.php?u=13">bezo, a href="member.php?u=4">tango232, a href="member.php?u=119">mickriss, MSNBot

Please advise ASAP as it looks a tad silly :(

Regards

Bashy
www.bashys-place.com

[derekivey]

Hi, did you import the product?

[derekivey]

yeah i did all that. was just wanting to make sure that it didnt do anything else that i needed to change :)


thx :)


but anyhow what i tried to do was install it on vb 3.5.0 and there is NO Skype ;)

so it gave errors, then sql erros .... but its back to norm. I would Like to try this on 3.5.0 though :)


let me know if you have a fix for the database table edits ;)



thx :)

Zip file updated. Please try now, it should work now.

[derekivey]

bashy, try reverting the templates that were changed.

[bashy]

Hi m8

No, i didnt get that far...

Hi, did you import the product?

[bashy]

I have reverted all that i changed, i have also triple checked everything :(

Bashy

[bashy]

Heres a screen shot of the issue..

I have just checked the template and index.php edits and there deffo back to there original state!

Bashy

[bashy]

Right...

I have just reinstalled it all and the images are working fine, but i still get
a href="member.php?u=1"> in front of the usernames...
It looks like its lost the link to the members profile from that point on the
forum, so something as messed up somwhere.... and is only showing the raw code...

This is where the problem lies, somewhere in here, well, from what i can tell lol
this is my "forumhome_loggedinuser" When i removed the edits the 1st time,
did i take something else out by accident?


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Any ideas yet please?

What have i cocked up, what would cause this?

Bashy

[derekivey]

You are missing a < in front of a href="member.php.

[bashy]

Sounds good to me :) cheers m8, that sorted it..

It helps when ya got all the info in front of you ;)

Thanks again, great little hack.... *bashy runs to click install*

Thanks again for ya patience

Bashy

You are missing a < in front of a href="member.php.

[4number8]

Working on 3.5.1, You don't have images for a dark type forum do you? thanks for this btw, pretty cool.

[derekivey]

Nope sorry, don't have any images for a dark forum. I just found those images on Google's Image Search and edited them so they would have a transparent background.

[4number8]

Thanks just the same, I have to admit this looks alot better with firefox than with IE

[Snake]

Sweeeeeeeeeeeeeeet!

Thanks.

[Feckie (Roger)]

Nice Addition

And thanks again for the code mod.

Clicks Installs......... :banana:

[Mastar]

Installed and working!

[Xtrato]

Nice Hack this is widely used on IPB boards

[Landlord]

i had this happen...

http://img.photobucket.com/albums/v102/flyman564/usernamesgoof.jpg

[derekivey]

i had this happen...

http://img.photobucket.com/albums/v102/flyman564/usernamesgoof.jpg

Make sure you have a < before your <a href="

Another user had this problem and thats what caused it, a missing < at the beginning of the a href... If you still have problems, please paste your template code here and I will look at it.

Derek

[Landlord]

i don't even see an <a href= anywhere around :rolleyes:


here is my code, and also where do i change the border to 0 at? In the template or in the index.php?




$stylevar[dirmark]<a href="member.php?$session[sessionurl]u=$loggedin[userid]"
<!-- Start: Browser on Who's Online by derekivey - Version 1.0.0 -->
<if condition="$loggedin[browser] == internet_explorer">
<img src="$stylevar[imgdir_misc]/ie.gif" alt="$vbphrase[browser_internet_explorer]" />
</if>
<if condition="$loggedin[browser] == opera">
<img src="$stylevar[imgdir_misc]/opera.gif" alt="$vbphrase[browser_opera]" />
</if>
<if condition="$loggedin[browser] == firefox">
<img src="$stylevar[imgdir_misc]/ff.gif" alt="$vbphrase[browser_firefox]" />
</if>
<if condition="$loggedin[browser] == camino">
<img src="$stylevar[imgdir_misc]/camino.gif" alt="$vbphrase[browser_camino]" />
</if>
<if condition="$loggedin[browser] == konqueror">
<img src="$stylevar[imgdir_misc]/konqueror.gif" alt="$vbphrase[browser_konqueror]" />
</if>
<if condition="$loggedin[browser] == safari">
<img src="$stylevar[imgdir_misc]/safari.gif" alt="$vbphrase[browser_safari]" />
</if>
<if condition="$loggedin[browser] == netscape">
<img src="$stylevar[imgdir_misc]/netscape.gif" alt="$vbphrase[browser_netscape]" />
</if>
<if condition="$loggedin[browser] == unknown">
<img src="$stylevar[imgdir_misc]/question_icon.gif" alt="$vbphrase[browser_unknown]" />
</if>
<!-- End: Browser on Who's Online by derekivey - Version 1.0.0 -->
rel="nofollow">$loggedin[musername]</a>$loggedin[invisiblemark]$loggedin[buddymark]

[GamerJunk.net]

What does this do for guests and spiders?

[Landlord]

i think one part of the problemw ould be that my ENTIRE original code in the forumdisplay_loggedinuser is

$stylevar[dirmark]<a href="member.php?$session[sessionurl]u=$loggedin[userid]" target="_blank">$loggedin[musername]</a>$loggedin[invisiblemark]$loggedin[buddymark]


so i don't know where to find a <if condition="$loggedin[userid]"> like the install asks...

[derekivey]

Move the code you added for this hack up before


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



That will fix it.

[derekivey]

What does this do for guests and spiders?

It doesn't do anything for them. They appear normal on the online page.

[Xtrato]

what if i dont add this
FIND:

user.username, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, user.usergroupid,

IN LINE FIND:

user.username,

AFTER ADD:

user.browser,

cuz i get errors if i do

[derekivey]

What error do you get? You need that or the hack will not work.

[derekivey]

Version 1.0.1 has been released. I have moved the users' browser information to the session table instead of the user table. Also, I have removed 'Unknown' from being stored in the database, and have replaced it with Psionic Vision's suggestion.

Simply follow the upgrade instructions in the install.txt file to upgrade.

Let me know if you have any problems.

Derek

[Felan]

Version 1.0.1 has been released. I have moved the users' browser information to the session table instead of the user table. Also, I have removed 'Unknown' from being stored in the database, and have replaced it with Psionic Vision's suggestion.

Simply follow the upgrade instructions in the install.txt file to upgrade.

Let me know if you have any problems.

Derek

in my who have visited hack not appear the browser,why?

P.S.great hack ;)

[derekivey]

Sorry, this hack doesn't support that hack, so therefore the browser information isn't shown on that hack.

[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?

[lanc3lot]

Hello nice idea, some questions.

- Can i have this only appear on the Who's Online page?
- Why is not working with the guests? I mean can it see what the guest browser is, and show approximately?
- 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)

Thnx in advance for any reply :)

[derekivey]

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.

- 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...

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.

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.



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[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:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



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.

[soulface]

Installed... working fine so far without any prob. I think it'll be very nice if it'll show nick as 'Group by Browser', bcuz when thr'll be 50/100 users online it'll look funny or messy :/

[EasyTarget]

heh, I just came here to request what soulface said... organize the wol by browser so that only 1 icon is displayed for each browser in use.

[derekivey]

Ok, I can probably add an option to do that. I'll take a look and see. Nice Suggestion!

[350Chevy]

Looks good.. One problem though, vBAdvanced CMPS v2.0.0 needed to be modified as well if you use it and would like it to show properly on your home page. ;)

For those who use vbAdvanced and would like it to work for your home page do the following.

in /modules/onlineusers.php find:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



and replace it with:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



again in /modules/onlineusers.php find:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



add after:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



That should do it. :)

* Clicks install.

[derekivey]

Thanks for that tutorial. I'll add it to the first post so that people who use vBa know what to do. :)

Thanks again,
Derek

[350Chevy]

Working on 3.5.1, You don't have images for a dark type forum do you? thanks for this btw, pretty cool.

I have cleaned the images up a bit so they look ok on any background. Feel free to use. :) derekivey, feel free to place these in place of yours if you'd like. ;)

Thanks for that tutorial. I'll add it to the first post so that people who use vBa know what to do.

Thanks again,
Derek
No problem. And it's just your code with a bit of common sense so there's no need to thank me. You would've easily figured it out if you were using vBAdvanced. ;)

[350Chevy]

Anyway we can add WebTV as a browser?

Edit: Attached WebTV icon in case you decide to add it or use it. ;)

[derekivey]

Thanks, I'll add it to the next release with your images too.

Thanks so much!

Derek

[bashy]

Hi peeps

I get this error (below) from only 1 member atm, he cannot login when this
hack is turned on, turn it off an he can login although the ? icon shows when turned off so looks a tad untidy...anyway back to the issue at hand lol...

Whats ya thoughs, his browser is IE6 but the WOL is showing him as mozilla?
Your hack is showing him as a question mark and stops him from loggin in

Database error in vBulletin 3.5.3:

Invalid SQL:
;

MySQL Error : Query was empty
Error Number : 1065
Date : Saturday, February 4th 2006 @ 07:08:08 PM
Script : http://IP.ADDY/bashys-place.com/forums/index.php
Referrer :
IP Address : This was an IP addy :p
Username : This used to be a username
Classname : some database

[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]

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....

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

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



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



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]

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



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



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:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[rza733]

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:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



thanks again man!!!

[derekivey]

I will be updating this hack sometime this week to make it show only 1 image per browser when there is more than one person with that browser. I will also be adding webtv as a supported browser to show.

[Eagle Creek]

Hi!

How 'safe' is it to install this hack? Because I like the idea (I run a security board so it's nice to see what browsers people are using) but because you say very urgent
I Strongly Recommend That You Backup Before Installing/Upgrading This Hack!

I'm a little affraid to install.......

[derekivey]

It's very safe. I just say that on all of my hacks so that people actually backup. It's just incase your database gets messed up at all (which is shouldn't because it is only adding fields to the session table). You shouldn't have any problems with this hack.

[Luggruff]

Nice ! ;D INSTALLS!
Could you add msn's browser? Think alot of users use that one..

[teedizz]

my forumhome_loggedinuser looks like this:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



so where would I add the template change for that?

[derekivey]

my forumhome_loggedinuser looks like this:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



so where would I add the template change for that?

Sorry about that, just add the code right before


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



When I wrote this hack, I didn't notice that my template was customized.

[derekivey]

Nice ! ;D INSTALLS!
Could you add msn's browser? Think alot of users use that one..

Sorry, I don't think vBulletin's is_browser function supports MSN's browser. That is what this hack uses to determine the browser.

Derek

[Smiry Kin's]

what about AOL browser?

[derekivey]

Nope, doesn't look like vB's function has that either. Maybe they will add that later on.

Derek

[teedizz]

it seems as if anything other than a I.E. browser shows up as unknown...why is that?

[teedizz]

nevermind...its working fine. Thanks

[S@NL - BlackBik]

MySQL Error : Query was empty
Error Number : 1065
Date : Saturday, February 4th 2006 @ 07:08:08 PM
Script : http://IP.ADDY/bashys-place.com/forums/index.php
Referrer :
IP Address : This was an IP addy
Username : This used to be a username
Classname : some database
I've got the same error from some people.
One only has it when using Netscape, he can login using Internet Explorer or telling Netscape to act as IE.
One other had this error ones, but not all the time.

Could it still be something that's been blocked by a firewall?

[S@NL - BlackBik]

Well, I fixed the problem, i think.
I've added one line of code to the plugin, at the bottom of the elseif statements:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------


Now the people who use a browser that is not detected by vBulletin don't get a sql-error no more.

[derekivey]

Ok, that should work, I will take a look at my code and see if I can release a better fix that doesn't require 'unknown' to be added to the database.

Derek

[S@NL - BlackBik]

Well, since it's stored in the session table, wich is temporary, I don't have a big problem with it :)

[Brandon Sheley]

this doesn't really work for me ?

it shows a ? icon on a FF or IE browser.. I'll check it out for a little while.. may un-install later

[Luggruff]

this doesn't really work for me ?

it shows a ? icon on a FF or IE browser.. I'll check it out for a little while.. may un-install later

It may take some time for the system to register what browser a user uses.

[derekivey]

Yeah, you usually have to load another page or refresh after the session is created. I'm currently not sure why this does this, sorry.

Derek

[Brandon Sheley]

it's been installed a few hours now and there is still an issue

before i seen the ? mark icon next to my name.. but now I see an error on IE and just the text " Internet Explorer" on FF

with the error the page loads slower it seems on IE

http://locoforum.com u can see

[derekivey]

Did you do the file edits?

[derekivey]

Wait it also looks like your missing the images, you have to upload them to the misc folder of every skin's image folder.

[Brandon Sheley]

Did you do the file edits?

yup, in the index.php and the template file..

this is the ?icon i was saying i seen earlier.


Wait it also looks like your missing the images, you have to upload them to the misc folder of every skin's image folder.

ah, didn't think of that..lol

this was my problem.. thanks for the help
/me clicks install

[derekivey]

Great, glad to see it's working. Is it detecting the correct browser after you hit refresh?

[Brandon Sheley]

yup,, it's working perfect for me now

just had to put the images in the correct style :p

[C_P]

For a person that knows nothing about coding (ME), this is a very nice little mod. I would also commend you on the easy to install step by step instructions you include. Not many go through that kind of trouble to add these types of guides for a modification. Hands off nice install instructions and mod works great.

[derekivey]

Thanks C_P glad you like it! :). See you at NBS.

Derek

[Joe Gronlund]

I get a SQL error when i try and remove this product. Is there a way to manually remove products so i can get rid of this product from my installed products list? Right now i just have it disabled, if i try and uninstall the product i get this error.

Database error in vBulletin 3.5.4:

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

MySQL Error : Can't DROP 'browser'. Check that column/key exists
Error Number : 1091
Date : Friday, February 24th 2006 @ 12:21:43 AM
Script : http://forums.jadedsouls.net/admincp/plugin.php
Referrer : http://forums.jadedsouls.net/admincp/plugin.php?do=productdelete&productid=browser_on_wol&s=
IP Address : xx.xxx.xxx.xxx
Username : Timewalk
Classname : vb_database

Any help is greatly appreciated.

[eNforce]

Attached here are some browser images that will look better on a Dark style

btw, does this put much of a load on the server? Say about 300+ members were online at a time, just curious. I never have more then 20 members online once

[derekivey]

I get a SQL error when i try and remove this product. Is there a way to manually remove products so i can get rid of this product from my installed products list? Right now i just have it disabled, if i try and uninstall the product i get this error.

Database error in vBulletin 3.5.4:

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

MySQL Error : Can't DROP 'browser'. Check that column/key exists
Error Number : 1091
Date : Friday, February 24th 2006 @ 12:21:43 AM
Script : http://forums.jadedsouls.net/admincp/plugin.php
Referrer : http://forums.jadedsouls.net/admincp/plugin.php?do=productdelete&productid=browser_on_wol&s=
IP Address : xx.xxx.xxx.xxx
Username : Timewalk
Classname : vb_database

Any help is greatly appreciated.

Just edit the product and remove the uninstall code from it, it should uninstall then.

[derekivey]

Attached here are some browser images that will look better on a Dark style

btw, does this put much of a load on the server? Say about 300+ members were online at a time, just curious. I never have more then 20 members online once

Thanks,
I'll include them in the zip file when I get back from school.

Also I'm not sure how well it works with big sites, I don't have a big enough site to test it on.

Derek

[CoreIssue]

OK. Stupid question here. Where are the template edits? I do not see them anywhere in the zip file.

[bashy]

There in the readme.html i just checked!!

[derekivey]

Yup, they should be in the readme file.

[CoreIssue]

Yep. There is a readme with some file edits in it.

But what do I do with the css scripting above the finds? No instructions.

I am new to VB. Came from phpBB where I did tons of modding.

So, if this in unclear to me it is going to be unclear to others.

Thanks.

[bashy]

what css scripting?

[CoreIssue]

Look at the top of the readme file. At least half the data is css styling. Right off the bat is formatted

CSS Stylesheet

I deleted the surround coding.

[bashy]

do you mean this?



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[CoreIssue]

No. The css material above it. You are starting at least half way down the file.

If the css stuff has no meaning why is it there?

[bashy]

This is all i can see



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[CoreIssue]

I just downloaded it and it has this in it above what you posted.


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[bashy]

Your seeing the reame.html in code for some reason!!

You need to open that readme in a browser not notepad or wordpad

[CoreIssue]

Yep. That cleanse it up!

Never had this before. And may explain another problem I am having with the Search and Quick Links not always dropping for me.

Now, where is the issue coming from? Sigh!

Thanks!!!:nervous:

[bashy]

This maybe the browser your using, If i was you i would try another browser and if thats no good then ask over at vbulletin.com as this sounds like an issue for them..
Unless its a hack that you have installed that could be conflicting....

You could also try turning off recently installed hacks to se if that works!
Best not to take over derekivey's thread anymore with other issues though :)


Sorry derekivey for taking over your hack thread :o

[CoreIssue]

This maybe the browser your using, If i was you i would try another browser and if thats no good then ask over at vbulletin.com as this sounds like an issue for them..
Unless its a hack that you have installed that could be conflicting....

You could also try turning off recently installed hacks to se if that works!
Best not to take over derekivey's thread anymore with other issues though :)


Sorry derekivey for taking over your hack thread :o
Already did that stuff.

And not taking over his thread. Just thanking you for your help here.

Installed and working fine. Clicking Install now.

[bashy]

Your welcome, glad ya got it sorted, tisa great addon for any forum :)
Have a good night :)

[derekivey]

Thats just the CSS for the readme file, you should open the readme file in a browser to view it correctly.

[C_P]

I love this addition, however, it looks like I have to remove it until a fix is done. I have a few users that get this issue when I have this modification enabled when they visit the site:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Here is some history on this. I have also seen other users here posting same issue to no particualr resolution at this point. I have sucessfully deduced that the cause is the plug in as after trying multiple things, the only sucess I had with user signing in was AFTER disabling this plug in.
Here are some things tried.

This user reports the following:

Having a problem getting in on my 98SE computer. I got two more of those, which I'll compare and post - if they are different.

I cleaned out all my cp cookies. I checked to see if the pass was the wrong one and the password was blank. I tried again; I got the main page to load but when I try to login, up comes that screen.

First I checked plodr errors and the only thing different is that the time changes.

Here is what I've done thus far: I deleted my cpfools bookmark, I removed the password because it was blank, I unprotected all cp cookies and removed them. I closed out the browser. I can get to the main page, I go to login I put in plodr then tab to password, I type that in, see the ***********, whether I select autologin or not the minute I click the sign in the password box changes to a blank box (in other words, it seems as if my password disappears and the db thinks I put in no password). I shut down the browser, made sure there weren't any cookies nor saved passwords. I tried to login as normal user account and observed the exact behavior - the password box goes blank. At least, I got a different appearing error. I'm going to reboot my 98 box and see if it changes the behavior - be prepared for a slew of error messages. Sorry.
FF also now includes some tool, clear privacy data. I have it configured to NOT clear cookies and passwords because I use other tools. I also have it set to alert me before it clears anything.

I shut down CounterSpy. I also decided to use the keyboard only insted of the mouse. No difference. As soon as I press/click login, my password disappears so you get the end result that I'm trying to login without a password.

I know it isn't the db because it happens on both accounts. I confirmed that this disappearing password is unique to this site. I went to another site. No cookies nor password appeared anywhere. I went to login and my password did not disappear.

So something on my 98SE computer is interfering with something specific to this site.

This is an admin at my site and this issue does not happen to me. So, again, the only thing that stopped this issue was disabling the plug in here.

[bashy]

Try disableing the firewall ;)
I have 1 member that had this problem and we found out it was his firewall
and it stopped him from logging in, yes its sommat to do with this hack but its the firewall that dont like it!!

I love this addition, however, it looks like I have to remove it until a fix is done. I have a few users that get this issue when I have this modification enabled when they visit the site:


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Here is some history on this. I have also seen other users here posting same issue to no particualr resolution at this point. I have sucessfully deduced that the cause is the plug in as after trying multiple things, the only sucess I had with user signing in was AFTER disabling this plug in.
Here are some things tried.

This user reports the following:



This is an admin at my site and this issue does not happen to me. So, again, the only thing that stopped this issue was disabling the plug in here.

[Rickie3]

wow only just found this *installed thankyou*

[Rickie3]

hi i have a user using Netscape/7.2 but its not showing on WOL just a ? mark saying unknown,is there a fix for this please

[soulface]

am getting this error when uninstalling this product (removed the index.php edit, removed templates edit, then trying to uninstall the product)

Database error in vBulletin 3.5.4:

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

MySQL Error : Can't DROP 'browser'; check that column/key exists
Error Number : 1091
Date : Tuesday, February 28th 2006 @ 01:07:48 AM
Referrer :
IP Address : *********
Username : ********
Classname : vb_database

[derekivey]

hi i have a user using Netscape/7.2 but its not showing on WOL just a ? mark saying unknown,is there a fix for this please
vB's is_browser function might now support that version. I'll take a look when I get back from school.


am getting this error when uninstalling this product (removed the index.php edit, removed templates edit, then trying to uninstall the product)



Database error in vBulletin 3.5.4:



Invalid SQL:

ALTER TABLE `session` DROP `browser`;;



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

Error Number : 1091

Date : Tuesday, February 28th 2006 @ 01:07:48 AM

Referrer :

IP Address : *********

Username : ********

Classname : vb_database

That means the browser field is missing from the session table. Just edit the product and remove the uninstall code and it should uninstall fine.

Derek

[Rickie3]

vB's is_browser function might now support that version. I'll take a look when I get back from school.





Derek
thankyou for your support look foward to a reply

[soulface]

thx derekivey. i really loved this hack but had to remove it for that login prob & empty sql query error. am looking forward for this bug fix & that 'one browser icon for same browser users'... :)

[Rickie3]

ive had to uninstall this as a couple of members use netscape and kept getting an error if you sort it out will install back on my board,in the meantime watching this thread thankyou

[derekivey]

Hey guys,

I'm not sure whats wrong with it. I'll have to try writing my own function that detects the browser instead of using vB's.

Derek

[Rickie3]

thankyou derekivey i hope you sort it out as i really want this hack to work,its a nice addition,and looked great on my board

[S@NL - BlackBik]

I had the same error on Netscape browsers.
I posted a fix here (http://www.vbulletin.org/forum/showpost.php?p=896770&postcount=93).
This ain't pretty, but it does the trick.
It inserts "unknown" in the sessions table when the browers is not recognised. But since the sessions entry is temporary I don't mind having some stupid overhead in there ;)

[derekivey]

Good idea, I will update the hack with the fix.

Thanks,
Derek

[derekivey]

Ok, Version 1.0.2 has been released. Thanks to everyone who reported the bug. Also thanks to S@NL - BlackBik for posting a fix.

I have also included eNforce's browser icons in the do_not_upload folder, in the Extras folder.

Derek

[S@NL - BlackBik]

Allright! my first official bugfix!! :D
Glad to have been of service :)

[derekivey]

Lol, Thanks again :).

[Joe Gronlund]

I get the following database error when i try and uninstall this hack.
Can anyone help me??



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[derekivey]

Looks like it is executing old uninstall code, just edit the product in vBulletin, and remove the uninstall code, it should then uninstall fine.

Derek

[Joe Gronlund]

Looks like it is executing old uninstall code, just edit the product in vBulletin, and remove the uninstall code, it should then uninstall fine.

Derek

Yep, it worked.. Thanks Derek :D

[derekivey]

No Problem :).

[350Chevy]

Attached here are some browser images that will look better on a Dark style

You could've saved yourself alot of trouble if you would've read the messages. :)

Back on page 5 I posted some icons I edited that work well on ANY background. ;)

http://www.vbulletin.org/forum/showpost.php?p=872054&postcount=66

[wssm]

How can I show the who's online on an HTML page?

Anyone knows?




:bunny: Wendy

[derekivey]

Please start a new thread rather than invading mine.

Thank You.

[wssm]

ops.. sorry mr:tired:

[derekivey]

No Problem :).

[Snort_2005]

Hmm.. I've had this installed for a few weeks and my members like it.. However, there seems to be a problem when the user first enters a vBulletin powered page such as vBadvanced CMPS or the vBulletin Admin/Mod Control Panels.. It doesn't seem to detect the browser right away like it did with an Invision Board hack that did this very thing.

What I am wondering, is how to get the browser icon to show on the first page view. (Sometimes I have to refresh a few times to get it to recognise my browser.)

[Tyegurl]

Hmm.. I've had this installed for a few weeks and my members like it.. However, there seems to be a problem when the user first enters a vBulletin powered page such as vBadvanced CMPS or the vBulletin Admin/Mod Control Panels.. It doesn't seem to detect the browser right away like it did with an Invision Board hack that did this very thing.

What I am wondering, is how to get the browser icon to show on the first page view. (Sometimes I have to refresh a few times to get it to recognise my browser.)

you can get it to show on vbadvance index page?i can't lol i would like to see the fix for that myself ;)

[derekivey]

Hmm.. I've had this installed for a few weeks and my members like it.. However, there seems to be a problem when the user first enters a vBulletin powered page such as vBadvanced CMPS or the vBulletin Admin/Mod Control Panels.. It doesn't seem to detect the browser right away like it did with an Invision Board hack that did this very thing.

What I am wondering, is how to get the browser icon to show on the first page view. (Sometimes I have to refresh a few times to get it to recognise my browser.)

Thats happens because I guess vB's sessions start before the hack itself so it doesn't get added the first time when they view the page, but after the session is created it gets added. I might have to take away the plugin and make it a file mod to get it in the right place. I'll try and have it fixed for the next version.

Derek

[saba]

i cant find the codes in the index.php file

[derekivey]

Try finding session.userid. You might have installed a few hacks that changed the line.

[saba]

Try finding session.userid. You might have installed a few hacks that changed the line.
trye that aswell i dont see session.userid anywhere and i havant installed anything that use editin index.pho



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[derekivey]

You didn't paste the whole file, the code is near the end I think.

Derek

[saba]

here it is :confused:

[derekivey]

I found it in there. Find $forumusers = $db->query_read(", its like 3-4 lines down from that: session.userid, session.inforum, session.lastactivity

Derek

[saba]

i edit all that stuff but i just get that database error

here my index.php code it seems right to me



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------

[bashy]

Hi

I am trying to uninstall this but i get


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Please advise?

[Tyegurl]

Looks good.. One problem though, vBAdvanced CMPS v2.0.0 needed to be modified as well if you use it and would like it to show properly on your home page. ;)

For those who use vbAdvanced and would like it to work for your home page do the following.

in /modules/onlineusers.php find:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



and replace it with:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



again in /modules/onlineusers.php find:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



add after:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



That should do it. :)

* Clicks install.


thanks so much! didn't see this post had been added...hoped to get an update email when this had been fixed! but thanks it worked perfect

[derekivey]

i edit all that stuff but i just get that database error

here my index.php code it seems right to me



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



You didn't do the last file edit for that file.

[derekivey]

Hi

I am trying to uninstall this but i get


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



Please advise?

Just remove that code from the uninstall code in the product manager. It doesn't look like you have that field for some reason.

Derek

[bashy]

Cheers Derek, that sorted it :)

[derekivey]

No Problem :)

[Danecookie]

I am having very dreadfull problems with this MOD.

The mod has some problem with tables something, when installed, it gives session table, when i removed this mod, some of it tables were not gettin removed from database, i installed again, and removed again, but still the mod is not gettin outa database completely..

my members are hving problems with it.. please inform me with the compelte code of this mod, so that i can install and then remove it compeltely form my database..

[derekivey]

Hello,

Sorry to hear that you are having problems with this mod. To remove it simply remove all of the files that this mod added, undo the file edits and template edits, and then uninstall the product from vB's Product Manager. It should remove the stuff it added to the database. The only thing that was added was a field in the session table called browser.

Hope this helps.

Derek

[Tyegurl]

small request....can you either update this for 3.6.0 or can you tell me how to uninstall it lmfao....i can't seem to...i did everything you said above...but blah it didn't work....

[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]

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 :confused:

[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/showthread.php?p=323#post323


and no i did the edits still a no go :(

[derekivey]

Ok, Open PHPMyAdmin, and execute the following SQL query...


Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



That should fix it.

Derek

[Shazz]

Isen't this the same as pauls?
________
Mercedes-Benz W463 specifications (http://www.mercedes-wiki.com/wiki/Mercedes-Benz_W463)

[derekivey]

Which one? Link please...

[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=productdelete&productid=browser_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...



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



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!!

[derekivey]

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
Mind PMing me admin details so I can take a look?

Thanks,
Derek

[Keyser Söze]

i feel like a total dumbass, just been doing too much getting my server/sites back up and running, i forgot to make the .php edits!!! gah

ok well thats it for me everything is fixed and working well, thanks

[derekivey]

Lol. Glad to see you got it working now :).

[XtremeCrash]

Hi,

Great product but I have 1 small problem.I did everything the way it was explained and I get this:



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



And when I upload the product its not there.Can someone Help:hurt:

[derekivey]

Looks like something to do with the sessions. Please make sure you did the file edits correctly, and try doing them again if you still have problems.

Derek

[XtremeCrash]

Edit: Nevermind works now:)

[derekivey]

Edit: Nevermind works now:)
Ok, great! :).

[principino1984]

works fine on 3.6.0 GOLD ;)

Marco

[Keyser Söze]

does not seem to work in 3.6.1, for me it shows im using firefox but everyone else it shows "?" been like that for 30 hours now, i thought maybe it might need time to refresh but it has had that

[derekivey]

does not seem to work in 3.6.1, for me it shows im using firefox but everyone else it shows "?" been like that for 30 hours now, i thought maybe it might need time to refresh but it has had that
They probably just went to your forum and didn't go to anymore pages. It does not get the browser when the session is first initiated due to the way vB codes the isbrowser() function. Also make sure you redid the file edits after you upgraded to 3.6.1.

Derek

[Keyser Söze]

i redid all the file edits, and no ones browser is showing up

[derekivey]

Hmm, I'll install this on my 3.6 board later and see if it works on 3.6, maybe something was changed in 3.6 which stopped it from working.

[Bison]

Users are getting a database error when they log into the site using the SeaMonkey web browser.



Code:
---------------
Code is only visible to licensed users, and only when logged into the forums.
---------------



http://www.mozilla.org/projects/seamonkey/

There's no login problems using any other browser...

[derekivey]

I think someone had this problem before and it was caused by a firewall. Have you tried disabling any firewalls and seeing if the error goes away?

[Bison]

I've figured it out ... I modified your XML and text code in the instructions adding the seamonkey browser. If you like, I generated a seamonkey gif file from an icon if you decide to add other browsers to your hack.

[derekivey]

Ok, I will add it to the next version.

Thanks,
Derek

[Bison]

Ok, I will add it to the next version.

Thanks,
Derek

So when are you going to update this to accomodate more browsers?

[deeoo]

Works great on 3.6.4.
I just can't seem to get it to work on the search.php page. Any ideas?

[derekivey]

Works great on 3.6.4.
I just can't seem to get it to work on the search.php page. Any ideas?
What do you mean?

[Bison]

Can't seem to find a few lines in the index.php in 3.64:

'username' => $vbulletin->userinfo['username'],

and in

forumhome_loggedinuser

FIND:

<if condition="$loggedin[userid]">

[derekivey]

I'll look into it. I might have to release a 3.6 version.

Derek

[derekivey]

3.6.4 version released here (http://www.vbulletin.org/forum/showthread.php?t=133784).

[deeoo]

What do you mean?

I have it working now. I had to add an include in the search.php and add the loggedin-part of the index.php in the search.php. Works like a charm now.

[MiahBeSmokin420]

ya i would realy like to get this working on the whos online page (online.php)

any help on that would be awsome

thanks

[TCE Killa]

Will this work for 3.6.X?

[TCE Killa]

.....?

[S@NL - BlackBik]

I've installed the code to detect Google Chrome (http://www.vbulletin.org/forum/showthread.php?t=189991) and i've modified the plugin code from this mod. I also uploaded a gif to the misc dir and modified the loggedinusers template.
But I can't get to work.
Google Chrome will not be detected and does not show on WOL.

Has anyone got this mod working for Google Chrome?