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!

[relaxiha]

When we enter a subject we are faced with the following error message

Database error in vBulletin 3.8.3:

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,
			spamlog.postid AS spamlog_postid,
			deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
			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
			
			,helpfulpost.goodrank,helpfulpost.totalrank,helpfulanswer.helpfulanswerid,helpfulanswer.yesno, browserosinfo.browser AS browser, browserosinfo.OS as OS
		FROM post AS post
		LEFT JOIN user AS user ON(user.userid = post.userid)
		LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
		LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
		LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
		LEFT JOIN avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN customavatar AS customavatar ON(customavatar.userid = user.userid)
		LEFT JOIN spamlog AS spamlog ON(spamlog.postid = post.postid)
			LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND deletionlog.type = 'post')
		LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
		LEFT JOIN postparsed AS postparsed ON(postparsed.postid = post.postid AND postparsed.styleid = 32 AND postparsed.languageid = 11)
		LEFT JOIN sigparsed AS sigparsed ON(sigparsed.userid = user.userid AND sigparsed.styleid = 32 AND sigparsed.languageid = 11)
		LEFT JOIN sigpic AS sigpic ON(sigpic.userid = post.userid)
			LEFT JOIN helpfulpost AS helpfulpost ON(helpfulpost.postid = post.postid)LEFT JOIN helpfulanswer AS helpfulanswer ON(helpfulanswer.postid = post.postid and helpfulanswer.userid = 1)LEFT JOIN browserosinfo AS browserosinfo ON (post.postid=browserosinfo.postid)
		WHERE post.postid IN (0,57611,57612)
		ORDER BY post.dateline;

MySQL Error   : Table '*********_db.browserosinfo' doesn't exist
Error Number  : 1146
Request Date  : Saturday, August 1st 2009 @ 04:06:19 AM
Error Date    : Saturday, August 1st 2009 @ 04:06:19 AM
Script        : http://******************/forums/showthread.php?p=57612
Referrer      : http://***************/forums/index.php
IP Address    : ***********
Username      : Commando
Classname     : vB_Database
MySQL Version : 5.0.81-community

[Fighter1405]

Looks like the install has failed for some reason, try running the following three SQL queries manually - replacing ******_db with your table prefix

CREATE TABLE `******_db.browserosinfo` (
`postid` INT( 6 ) NOT NULL ,
`os` VARCHAR( 20 ) NOT NULL ,
`browser` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM ;

ALTER TABLE `******_db.browserosinfo` ADD PRIMARY KEY ( `postid` )

ALTER TABLE `******_db.browserosinfo` ADD INDEX ( `postid` )

This really is the last time I check in, good luck getting it working

[John69Steph]

I have installed the product and the folder useragent in my serrve, but i don't see no image in my postbit

[relaxiha]

An error occurred while attempting to execute your query. The following information was returned. 
error number: 1103 
error desc: Incorrect table name '********_db.browserosinfo

[LifesGreatestGift]

I would like to make a suggestion.
1. Put Windows 7 in the browser detection, Its useragent string is "Windows 6.1"
2. Can you make the display in the postbit look like this?



3. Another thing, here is a OS & Browser Detection mod for SMF Forums, it has a lot more browsers and OS's, plus it has the icons for both, check it out for future releases of this mod.

http://custom.simplemachines.org/mod...=1515;id=96843

I will wait until you release a version that displays it like the picture above.

Great work so far!

[blogthea]

Thank you for this mod. I get this db error by email (tons of these):

Database error in vBulletin 3.8.3:

Invalid SQL:
INSERT INTO browserosinfo (postid, OS, browser) VALUES (280448,'windows_vista' ,'firefox');

MySQL Error   : Duplicate entry '280448' for key 1
Error Number  : 1062
Request Date  : Tuesday, August 4th 2009 @ 09:59:24 PM
Error Date    : Tuesday, August 4th 2009 @ 09:59:25 PM

i understand this mod isn't supported but i would appreciate if u help me

[AKBAR]

Thank you

[synseal]

Just tried it again and it is still showing windows 7 as windows 98, uninstalled, will re-install once this has been fixed, many thanks.

[relaxiha]

Database error in vBulletin 3.8.4:

Invalid SQL:
DROP TABLE `browserosinfo`;

MySQL Error   : Unknown table 'browserosinfo'
Error Number  : 1051
Request Date  : Sunday, August 16th 2009 @ 05:10:24 AM
Error Date    : Sunday, August 16th 2009 @ 05:10:24 AM
Script        : http://********.com/forums/admincp/plugin.php?do=productkill
Referrer      : http://************.com/forums/admincp/plugin.php?do=productdelete&productid=displayos&s=
IP Address    : 2***************
Username      : ************
Classname     : ********_Database
MySQL Version : 5.0.81-community

[Huy Ho?ng]

I have installed the product and the folder useragent in my server, but i don't see no image in my postbit