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!

[nomoreturn]

Originally Posted by psychobike

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 :

I also have same problem in 3.8.2 i use your product-displayos(5) file and when try to open post got same error

[synseal]

Hi thanks for this mod, one problem I'm having so far is I'm using windows 7 and my posts show as windows 98_nt_2000

[Charlie98902]

Originally Posted by synseal

Hi thanks for this mod, one problem I'm having so far is I'm using windows 7 and my posts show as windows 98_nt_2000

I get that too but the data errors are most important I think? The OS isn't officially out yet so we may have to wait?

[relaxiha]

Hello. I did and did not catch where it will show! Please pose all the better to understand

[Fighter1405]

Here we go, another version. This should fix the SQL query errors two of you got and the nasty red Xs in ie7. Uninstall any previous version installed before using this one.

[apiasto]

thnx it doesn't show any error but how would i be able to show image,this is already there in the temp,$template_hook[postbit_userinfo_right]
should we put the whole useragent folder in icon folder or what,this part is cofusing

[Charlie98902]

Put that folder in the images folder. No database error and is working so far will do more testing later this morning.

[bollie]

Originally Posted by bollie

images/useragent/

Helpppp

[onlyfree]

Originally Posted by bollie

Helpppp

?dit: Sorry - My fault - wrong plugin

!!!!

[Andy69]

all uploaded correctly but no images showing the instructions are a bit confusing i imported the xml were do i put the images and is there any template edits !