Miscellaneous Hacks - Display OS and Browser Information on Postbit

Hey all,

First plugin, so I hope I'm doing this right! As requested here, it'll display a small icon for both the users operating system and browser on the postbit.

Install steps:
1. Upload the Product
2. upload icon images for each os/browser to images/useragent in the form icon_(browser/os).gif - Sample Icons attached

Thanks to this mybb mod for the sample images and some of the browser detection code.

Screenshot:


Thanks and let me know if you have any problems!

[1320Nation]

Originally Posted by Fighter1405

That just crashed your board? I'm very sorry then, although I have no idea why. The standard uninstall function from the admincp should do it. Is the board giving any particular errors?

The board returned to normal once the uninstall was completed. I can give you more info if needed.

[Fighter1405]

If you could that would be great, I'd like to figure out why it happened. Do you remember what error you were getting?

[1320Nation]

Originally Posted by Fighter1405

If you could that would be great, I'd like to figure out why it happened. Do you remember what error you were getting?

Here was the common error:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,
avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline,customavatar.width AS avwidth,customavatar.height AS avheight,


editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason, editlog.hashistory,
postparsed.pagetext_html, postparsed.hasimages,
sigparsed.signatureparsed, sigparsed.hasimages AS sighasimages,
sigpic.userid AS sigpic, sigpic.dateline AS sigpicdateline, sigpic.width AS sigpicwidth, sigpic.height AS sigpicheight,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid, infractiongroupid
, '' AS field9, '' AS field11
, gcache.ids as gcacheids, gcache.dateline as gcachedateline, browserosinfo.browser AS browser, browserosinfo.OS as OS
FROM board_post AS post
LEFT JOIN board_user AS user ON(user.userid = post.userid)
LEFT JOIN board_userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN board_usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN board_icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN board_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN board_customavatar AS customavatar ON(customavatar.userid = user.userid)


LEFT JOIN board_editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN board_postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 3 AND postparsed.languageid = 1)
LEFT JOIN board_sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 3 AND sigparsed.languageid = 1)
LEFT JOIN board_sigpic AS sigpic ON(sigpic.userid = post.userid)
LEFT JOIN board_gal_cache as gcache ON (post.postid = gcache.postid)LEFT JOIN board_browserosinfo AS postinfo ON (post.postid=browserosinfo.postid)
WHERE post.postid IN (0,263014,263123,263177,263763,263821)
ORDER BY post.dateline;

MySQL Error : Unknown column 'browserosinfo.browser' in 'field list'
Error Number : 1054
Request Date : Wednesday, July 29th 2009 @ 02:22:43 PM
Error Date : Wednesday, July 29th 2009 @ 02:22:43 PM
Script : http://******/forums/garage-sale/255...1-150-tyd.html
Referrer : http://******/forums/garage-sale/
IP Address : *******
Username : slo poke
Classname : vB_Database
MySQL Version :

[Fighter1405]

I see the problem, thanks for copying the error Are you interested in a fixed version or not? I don't blame you if you aren't after all the problems you've had with it

[1320Nation]

Originally Posted by Fighter1405

I see the problem, thanks for copying the error Are you interested in a fixed version or not? I don't blame you if you aren't after all the problems you've had with it

I appreciate your dedication to your support. Yes after all this I would like to use a working version if possible.

[Fighter1405]

Originally Posted by psychobike

I appreciate your dedication to your support. Yes after all this I would like to use a working version if possible.

Just before I write it can we do one check so I don't break your board again? Can you load up phpmyadmin (or similar) and check that there is no table on the vbulletin database called 'board_browserosinfo'?

[SupraGame]

im using the original xml and i installed it and have the gifs in the useragent folder, but the images arent displaying. theyre just showing up as

windows_xp_2003firefox for example.

is there something wrong in the template? or do i need to use (4) and (5)?

EDIT: it might be a browser issue or from my computer. not sure. some users can see it apparently

[bollie]

Originally Posted by bollie
Work not for me.
Show not icon_(browser/os).gif
Originally Posted by Farman
Not working here even, Please give proper instruction, where to upload!
An example icon name would be "icon_firefox.gif" and that should be in the images/useragent folder, what do you have in that folder?

images/useragent/

[Charlie98902]

IE7 seems to do this according to my moderator that has that installed. But Chrime/Firefix/IE8 has no issues.

[1320Nation]

Originally Posted by Fighter1405

Just before I write it can we do one check so I don't break your board again? Can you load up phpmyadmin (or similar) and check that there is no table on the vbulletin database called 'board_browserosinfo'?

After checking there is NO 'board_browserosinfo' table.