View Full Version : Miscellaneous Hacks - Display OS and Browser Information on Postbit
Fighter1405
07-28-2009, 10:00 PM
Hey all,
First plugin, so I hope I'm doing this right! As requested here (https://vborg.vbsupport.ru/showthread.php?t=152283), 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 (http://community.mybboard.net/showthread.php?tid=20953) for the sample images and some of the browser detection code.
Screenshot:
http://img18.imageshack.us/img18/738/browsershow.jpg
Thanks and let me know if you have any problems!
Deceptor
07-29-2009, 12:44 AM
Nice for a first modification :) I'd suggest the following change so it doesn't clash/break other mods:
$hook_query_joins = "LEFT JOIN " . TABLE_PREFIX . "postinfo AS postinfo ON (post.postid=postinfo.postid)";
$hook_query_fields = ", postinfo.browser AS browser, postinfo.OS as OS";
To:
$hook_query_joins .= "LEFT JOIN " . TABLE_PREFIX . "postinfo AS postinfo ON (post.postid=postinfo.postid)";
$hook_query_fields .= ", postinfo.browser AS browser, postinfo.OS as OS";
Basically change = to .= :)
Fighter1405
07-29-2009, 12:49 AM
Thanks for the feedback :) I made the change you suggested, makes sense to me :)
erel34
07-29-2009, 01:33 AM
Thanks to all
KevinL
07-29-2009, 01:35 AM
Nice mod...but how many queries will this add?
bollie
07-29-2009, 05:14 AM
Work not for me.
Show not icon_(browser/os).gif
dartho
07-29-2009, 07:03 AM
Nice mod...but how many queries will this add?
Looks like it will add a single query when a post is created.
onlyfree
07-29-2009, 09:42 AM
hey nice feature,
but is there a chance to get the possebility for users to turn on/off these icons?
Farman
07-29-2009, 10:39 AM
Not working here even, Please give proper instruction, where to upload!
Fighter1405
07-29-2009, 10:50 AM
Work not for me.
Show not icon_(browser/os).gif
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?
Looks like it will add a single query when a post is created.
That is correct, it loads the information back through the use of a left join so no extra queries are needed on showthread.
hey nice feature,
but is there a chance to get the possebility for users to turn on/off these icons?
You'd like it turned off on a post by post basis or for the user to set it globally on the UCP?
Charlie98902
07-29-2009, 11:18 AM
I am using the opposite postbit style you are using and it isn't showing on my board.
onlyfree
07-29-2009, 12:53 PM
I am using the opposite postbit style you are using and it isn't showing on my board.
Go on postbit or postbit_legacy template and put this where you want to have these stats
$template_hook[postbit_userinfo_right]
@developer. it would be nice if the user could block his os and browser generally for all his posts in his UCP :)
1320Nation
07-29-2009, 12:58 PM
Not working....
Database error in vBulletin 3.7.3:
Invalid SQL:
CREATE TABLE `board_postinfo` (
`postid` INT( 6 ) NOT NULL ,
`os` VARCHAR( 20 ) NOT NULL ,
`browser` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM ;;
MySQL Error : Table 'board_postinfo' already exists
Error Number : 1050
Request Date : Wednesday, July 29th 2009 @ 10:55:42 AM
Error Date : Wednesday, July 29th 2009 @ 10:55:42 AM
Script : http://www.*****.com/forums/admincp/plugin.php?do=productimport
Referrer : http://www.*****.com/forums/admincp/plugin.php?do=productadd
IP Address : ***.****
Username :********
Classname : vB_Database
MySQL Version : 5.0.45
Charlie98902
07-29-2009, 01:14 PM
Go on postbit or postbit_legacy template and put this where you want to have these stats
$template_hook[postbit_userinfo_right]
@developer. it would be nice if the user could block his os and browser generally for all his posts in his UCP :)
Nope it is a not go. :(
Fighter1405
07-29-2009, 02:03 PM
I am using the opposite postbit style you are using and it isn't showing on my board.
Go on postbit or postbit_legacy template and put this where you want to have these stats
$template_hook[postbit_userinfo_right]
That hook does already exist on the new postbit anyway, it should appear right under the post count. Does anything display there? Remember that if you are using quick reply it won't display until you refresh the page.
@developer. it would be nice if the user could block his os and browser generally for all his posts in his UCP :)
I'll take a look at implementing that later today :)
Not working....
Database error in vBulletin 3.7.3:
Invalid SQL:
CREATE TABLE `board_postinfo` (
`postid` INT( 6 ) NOT NULL ,
`os` VARCHAR( 20 ) NOT NULL ,
`browser` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM ;;
MySQL Error : Table 'board_postinfo' already exists
Error Number : 1050
Request Date : Wednesday, July 29th 2009 @ 10:55:42 AM
Error Date : Wednesday, July 29th 2009 @ 10:55:42 AM
Script : http://www.*****.com/forums/admincp/plugin.php?do=productimport
Referrer : http://www.*****.com/forums/admincp/plugin.php?do=productadd
IP Address : ***.****
Username :********
Classname : vB_Database
MySQL Version : 5.0.45
Sounds like you already have another mod that creates the postinfo table, try the version attached to this post that creates a 'browserosinfo' table instead.
1320Nation
07-29-2009, 02:10 PM
No luck...same issue.
Database error in vBulletin 3.7.3:
Invalid SQL:
ALTER TABLE `browserosinfo` ADD PRIMARY KEY ( `postid` );
MySQL Error : Table 'vbulletin.browserosinfo' doesn't exist
Error Number : 1146
Request Date : Wednesday, July 29th 2009 @ 12:07:35 PM
Error Date : Wednesday, July 29th 2009 @ 12:07:35 PM
Script : http://*****.com/forums/admincp/plugin.php?do=productimport
Referrer : http://*****.com/forums/admincp/plugin.php?do=productadd
IP Address : ****
Username : ***
Classname : vB_Database
MySQL Version : 5.0.45
Fighter1405
07-29-2009, 02:16 PM
No luck...same issue.
Database error in vBulletin 3.7.3:
Invalid SQL:
ALTER TABLE `browserosinfo` ADD PRIMARY KEY ( `postid` );
MySQL Error : Table 'vbulletin.browserosinfo' doesn't exist
Error Number : 1146
Request Date : Wednesday, July 29th 2009 @ 12:07:35 PM
Error Date : Wednesday, July 29th 2009 @ 12:07:35 PM
Script : http://*****.com/forums/admincp/plugin.php?do=productimport
Referrer : http://*****.com/forums/admincp/plugin.php?do=productadd
IP Address : ****
Username : ***
Classname : vB_Database
MySQL Version : 5.0.45
Sorry, that's just me being silly and not testing the version I changed for you. Missing the TABLE_PREFIX. Try this version I uploaded now, and we'll see if we have better luck this time :p
apiasto
07-29-2009, 02:27 PM
i tried (5) on 3.8.3 and got this error
MySQL Error : Unknown column 'browserosinfo.browser' in 'field list'
Error Number : 1054
Charlie98902
07-29-2009, 02:36 PM
I got the original to work and the new one you just posted to create a table gives me a database error.
Charlie98902
07-29-2009, 02:42 PM
Fighter1405
I did notice from the original plugin that if you use the quick reply it won't show the OS to you until you hit f5. Also the other thing I have noticed is that it doesn't update older posts. Can this be accomplished?
Charlie98902
07-29-2009, 02:57 PM
Also I know that it isn't released yet but those using Win 7 shows the 98/nt/2000 icon win 7 will be the same as vista's icon I believe?
1320Nation
07-29-2009, 02:58 PM
Still no luck...
Invalid SQL:
CREATE TABLE `board_browserosinfo` (
`postid` INT( 6 ) NOT NULL ,
`os` VARCHAR( 20 ) NOT NULL ,
`browser` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM ;;
MySQL Error : Table 'board_browserosinfo' already exists
Error Number : 1050
Request Date : Wednesday, July 29th 2009 @ 12:56:05 PM
Error Date : Wednesday, July 29th 2009 @ 12:56:05 PM
Script : http://www.******.com/forums/admincp/plugin.php?do=productimport
Referrer : http://www.*******.com/forums/admincp/plugin.php?do=productadd
IP Address : ******
Username : *****
Classname : vB_Database
MySQL Version : 5.0.45
Fighter1405
07-29-2009, 03:29 PM
Fighter1405
I did notice from the original plugin that if you use the quick reply it won't show the OS to you until you hit f5. Also the other thing I have noticed is that it doesn't update older posts. Can this be accomplished?
I'm afraid it can't be changed retrospectively as the none of the information has been saved for previous posts =/
Also I know that it isn't released yet but those using Win 7 shows the 98/nt/2000 icon win 7 will be the same as vista's icon I believe?
I'll have a look into that
Still no luck...
Invalid SQL:
CREATE TABLE `board_browserosinfo` (
`postid` INT( 6 ) NOT NULL ,
`os` VARCHAR( 20 ) NOT NULL ,
`browser` VARCHAR( 20 ) NOT NULL
) ENGINE = MYISAM ;;
MySQL Error : Table 'board_browserosinfo' already exists
Error Number : 1050
Request Date : Wednesday, July 29th 2009 @ 12:56:05 PM
Error Date : Wednesday, July 29th 2009 @ 12:56:05 PM
Script : http://www.******.com/forums/admincp/plugin.php?do=productimport
Referrer : http://www.*******.com/forums/admincp/plugin.php?do=productadd
IP Address : ******
Username : *****
Classname : vB_Database
MySQL Version : 5.0.45
Did you install 4 then 5? That could explain that.
Charlie98902
07-29-2009, 03:35 PM
I did notice from the original plugin that if you use the quick reply it won't show the OS to you until you hit f5.
What about this?
Fighter1405
07-29-2009, 03:45 PM
What about this?
That probably can be resolved, but it'll need a little figuring out. Users generally don't need to see their own OS and browser anyway, it is more for the benefit of other members :p
1320Nation
07-29-2009, 04:07 PM
I'm afraid it can't be changed retrospectively as the none of the information has been saved for previous posts =/
I'll have a look into that
Did you install 4 then 5? That could explain that.
From what I can see the mod is not installing at all. When importing the product it stops and gives the error's I listed above.
Charlie98902
07-29-2009, 04:17 PM
v4 then v5 gave me database errors so I am using the original xml plugin and no errors.
Fighter1405
07-29-2009, 04:20 PM
From what I can see the mod is not installing at all. When importing the product it stops and gives the error's I listed above.
My guess is that the first time you tried installing number 4 it did part of the installation and then failed, try using the attached file instead (sorry for all this).
Note: No one else should use this file, some of the installation code is missing from it.
1320Nation
07-29-2009, 04:25 PM
My guess is that the first time you tried installing number 4 it did part of the installation and then failed, try using the attached file instead (sorry for all this).
Note: No one else should use this file, some of the installation code is missing from it.
That just crashed my board. How do I uninstall it? I figured out the uninstall.
Fighter1405
07-29-2009, 04:28 PM
That just crashed my board. How do I uninstall it?
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?
1320Nation
07-29-2009, 04:32 PM
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
07-29-2009, 04:33 PM
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
07-29-2009, 04:44 PM
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/25546-99-2000-usb-111-150-tyd.html
Referrer : http://******/forums/garage-sale/
IP Address : *******
Username : slo poke
Classname : vB_Database
MySQL Version :
Fighter1405
07-29-2009, 04:48 PM
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 :p
1320Nation
07-29-2009, 04:54 PM
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 :p
I appreciate your dedication to your support. Yes after all this I would like to use a working version if possible.
Fighter1405
07-29-2009, 04:57 PM
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
07-30-2009, 01:42 AM
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
07-30-2009, 07:00 AM
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
07-30-2009, 10:09 AM
IE7 seems to do this according to my moderator that has that installed. But Chrime/Firefix/IE8 has no issues.
1320Nation
07-30-2009, 10:39 AM
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.
nomoreturn
07-30-2009, 03:49 PM
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/25546-99-2000-usb-111-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
07-30-2009, 06:32 PM
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 https://vborg.vbsupport.ru/
Charlie98902
07-30-2009, 06:43 PM
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 http://www.techkings.org/images/useragent/icon_windows_98_nt_2000.gif
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
07-30-2009, 09:31 PM
Hello. I did and did not catch where it will show! Please pose all the better to understand
Fighter1405
07-31-2009, 01:29 AM
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
07-31-2009, 09:23 AM
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
07-31-2009, 10:05 AM
Put that folder in the images folder. No database error and is working so far will do more testing later this morning.
bollie
07-31-2009, 10:14 AM
images/useragent/
Helpppp
onlyfree
07-31-2009, 11:22 AM
Helpppp
?dit: Sorry - My fault - wrong plugin :D
!!!!
Andy69
07-31-2009, 11:42 AM
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 !
Fighter1405
07-31-2009, 01:07 PM
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 !
There are no template edits, and the images should be in vbroot/images/useragent
For example if you install vbulletin on 127.0.0.1 in the folder vb, you should be able to find this file if the images are in the correct place:
http://127.0.0.1/vb/images/useragent/icon_firefox.gif
Charlie98902
07-31-2009, 02:47 PM
Here is the direct URL in cpanel to assist as well.
/ public_html / images / or / public_html /forum / images /
Hope that helps some out.
1320Nation
07-31-2009, 03:22 PM
I no longer am getting a sql error but there is no images showing in the members postbit anywhere. My image path is forums/images/useragent.
Fighter1405
07-31-2009, 03:52 PM
I no longer am getting a sql error but there is no images showing in the members postbit anywhere. My image path is forums/images/useragent.
That should work then, can you just verify that the actual icons are in there for sure? Remember that they will only show up for posts made after the plugin was installed. If you view the source of the postbit for one such post, do you see the image tags in the HTML?
1320Nation
07-31-2009, 04:05 PM
That should work then, can you just verify that the actual icons are in there for sure? Remember that they will only show up for posts made after the plugin was installed. If you view the source of the postbit for one such post, do you see the image tags in the HTML?
Awe yes....."Remember that they will only show up for posts made after the plugin was installed.".....you are correct. The mod now appears to be working as described! Wow, and to think I almost gave up on this mod. Thank you for staying dedicated to the support of your mod.
Fighter1405
07-31-2009, 04:06 PM
Awe yes....."Remember that they will only show up for posts made after the plugin was installed.".....you are correct. The mod now appears to be working as described! Wow, and to think I almost gave up on this mod. Thank you for staying dedicated to the support of your mod.
Great :) I am glad we finally got it working :p Thanks for keeping trying
Charlie98902
07-31-2009, 04:19 PM
Awe yes....."Remember that they will only show up for posts made after the plugin was installed.".....you are correct. The mod now appears to be working as described! Wow, and to think I almost gave up on this mod. Thank you for staying dedicated to the support of your mod.
If you post hit F5 and you'll see yours too when using quick reply. :)
apiasto
07-31-2009, 04:28 PM
ya great so far its working thanks
Alfa1
07-31-2009, 07:45 PM
Could add the function to turn this on in specific (sub)forums only? This would be great for my 'bug tracker' subforum, but I have no use for it in other parts of my site.
Fighter1405
07-31-2009, 11:20 PM
Sorry to say this guys, but I am going away for two weeks tomorrow and will have very little internet in that time (I'll be managing my own community with the internet I do have). I have updated the file in the first post but there is no need to upgrade if everything already works for you, and will look at adding some new features (as well as resuming support) when I get back.
relaxiha
08-01-2009, 03:07 AM
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,helpfu lanswer.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
08-01-2009, 06:54 AM
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
08-01-2009, 07:17 AM
I have installed the product and the folder useragent in my serrve, but i don't see no image in my postbit
http://www.imagefacile.com/img/x05d1_image_1.png
relaxiha
08-01-2009, 04:44 PM
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
08-03-2009, 12:07 AM
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?
https://vborg.vbsupport.ru/external/2009/08/29.png
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/mods/index.php?action=download;mod=1515;id=96843
I will wait until you release a version that displays it like the picture above.
Great work so far!
blogthea
08-04-2009, 09:15 PM
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
08-11-2009, 03:05 PM
Thank you:)
synseal
08-11-2009, 04:13 PM
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
08-16-2009, 04:11 AM
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
08-16-2009, 06:50 AM
I have installed the product and the folder useragent in my server, but i don't see no image in my postbit :(
Claverhouse
08-16-2009, 11:22 AM
I have installed the product and the folder useragent in my server, but i don't see no image in my postbit :(
See if folder useragent is in /images.
Works straight off the bat here. Nice work. Perhaps alternate images could be made more suitable for darker boards, but I'll still use it as it is.
tandy
08-16-2009, 12:12 PM
Installed but no image in postbit.
nomoreturn
08-16-2009, 02:25 PM
Works in 3.8.4 thanks for it but its better if its works on previous posting too its just works on new posting after installing it
relaxiha
08-16-2009, 04:05 PM
please Update ...i think have problem
bleros
08-16-2009, 07:01 PM
is not work for me >.. any idea how to fix it
bleros
08-16-2009, 07:38 PM
this .. sh..t is not work . now i can login to my site i can uninstall :@
hailiat.com
08-16-2009, 10:09 PM
if you cant see please try do :-
from cp go to http://www.your_site.com/forum/admincp/template.php?do=search
postbit_legacy (open it )
and search for : <if condition="$show['reppower']">
add above :
$template_hook[postbit_userinfo_right]
and save it.
again do that with : postbit
relaxiha
08-23-2009, 11:00 PM
i can't remove this product from admin cp
error:
Database error in vBulletin 3.8.4:
Invalid SQL:
DROP TABLE `browserosinfo`;
MySQL Error : Unknown table 'browserosinfo'
Error Number : 1051
Request Date : Sunday, August 23rd 2009 @ 11:56:17 PM
Error Date : Sunday, August 23rd 2009 @ 11:56:17 PM
Script : http://********.com/forums/admincp/plugin.php?do=productkill
Referrer : http://***********.com/forums/admincp/plugin.php?do=productdelete&productid=displayos&s=
IP Address : ******************
Username : ****************
Classname : vB_Database
MySQL Version : 5.0.81-community
Although I do still shows an error message.
Database error in vBulletin 3.8.4:
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
, browserosinfo.browser AS browser, browserosinfo.OS as OS,helpfulpost.goodrank,helpfulpost.totalrank,help fulanswer.helpfulanswerid,helpfulanswer.yesno
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 browserosinfo AS browserosinfo ON (post.postid=browserosinfo.postid)LEFT JOIN helpfulpost AS helpfulpost ON(helpfulpost.postid = post.postid)LEFT JOIN helpfulanswer AS helpfulanswer ON(helpfulanswer.postid = post.postid and helpfulanswer.userid = 1)
WHERE post.postid IN (0,62295,62300,62354,62356)
ORDER BY post.dateline;
MySQL Error : Table '*********_vb.browserosinfo' doesn't exist
Error Number : 1146
Request Date : Sunday, August 23rd 2009 @ 11:55:35 PM
Error Date : Sunday, August 23rd 2009 @ 11:55:35 PM
Script : http://******************/forums/showthread.php?p=62356
Referrer : http://*************/forums/index.php
IP Address : *************
Username : ******
Classname : ******_Database
MySQL Version : 5.0.81-community
Please help us to one. We have stuck. And the person is not responsive
archet1337
09-13-2009, 02:27 PM
after installing this mod, where can I find the options for it?
I've been looking though all of admincp now, cant find anything
relaxiha
09-16-2009, 02:11 AM
please update it
cbiweb
09-29-2009, 12:36 AM
Installed.
Doesn't show any icons
No settings in ACP or anywhere!
UNINSTALLED.
bollie
10-09-2009, 03:46 PM
opdate please for windows 7
smokin1337
10-10-2009, 02:56 PM
I added windows 7 but had to delete windows 98 from the xml to make it work. To do it go into Plugins->Manage Plugins->Display OS and Browser->save on new post
Repalce ALL with:
$useragent = $_SERVER ? $_SERVER['HTTP_USER_AGENT'] : $HTTP_SERVER_VARS['HTTP_USER_AGENT'];
$ua = strtolower($useragent);
$ua_browser = 'unknown';
$ua_os = 'unknown';
// Browser detection:
if (strpos($ua, 'firefox') !== false) $ua_browser = 'firefox';
else if (strpos($ua, 'msie') !== false) $ua_browser = 'ie';
else if (strpos($ua, 'opera') !== false)
{
if (strpos($ua, 'opera mini ') === false) $ua_browser = 'opera';
else $ua_browser = 'operamini';
}
else if (strpos($ua, 'mozilla') !== false && strpos($ua, 'rv:') !== false) $ua_browser = 'mozilla';
else if (strpos($ua, 'netscape') !== false) $ua_browser = 'netscape';
else if (strpos($ua, 'safari') !== false) $ua_browser = 'safari';
else if (strpos($ua, 'epiphany') !== false) $ua_browser = 'epiphany';
else if (strpos($ua, 'galeon') !== false) $ua_browser = 'galeon';
else if (strpos($ua, 'konqueror') !== false) $ua_browser = 'konqueror';
else if (strpos($ua, 'firebird') !== false) $ua_browser = 'firebird';
else if (strpos($ua, 'avant browser') !== false) $ua_browser = 'avant';
else if (strpos($ua, 'maxthon') !== false || strpos($ua, 'myie') !== false) $ua_browser = 'maxthon';
else if (strpos($ua, 'slimbrowser') !== false) $ua_browser = 'slimbrowser';
else if (strpos($ua, 'chrome') !== false) $ua_browser = 'gc';
// OS detection:
if (strpos($ua, 'windows nt 6.1') !== false) $ua_os = 'win_7';
else if (strpos($ua, 'windows nt 5.0') !== false) $ua_os = 'windows_98_nt_2000';
else if (strpos($ua, 'windows 95') !== false) $ua_os = 'windows_98_nt_2000';
else if (strpos($ua, 'windows me') !== false) $ua_os = 'windows_me';
else if (strpos($ua, 'windows 98') !== false) $ua_os = 'windows_98_nt_2000';
else if (strpos($ua, 'windows nt 5.2') !== false || strpos($ua, 'windows nt 5.1') !== false) $ua_os = 'windows_xp_2003';
else if (strpos($ua, 'windows nt 6.0') !== false) $ua_os = 'windows_vista';
else if (strpos($ua, 'linux') !== false)
{
if (strpos($ua, 'debian') !== false) $ua_os = 'linuxdebian';
else if (strpos($ua, 'fedora') !== false) $ua_os = 'linuxfedora';
else if (strpos($ua, 'gentoo') !== false) $ua_os = 'linuxgentoo';
else if (strpos($ua, 'kateos') !== false || strpos($ua, 'kate os') !== false) $ua_os = 'linuxkateos';
else if (strpos($ua, 'knoppix') !== false) $ua_os = 'linuxknoppix';
else if (strpos($ua, 'kubuntu') !== false) $ua_os = 'linuxkubuntu';
else if (strpos($ua, 'mandriva') !== false || strpos($ua, 'mandrake') !== false) $ua_os = 'linuxmandriva';
else if (strpos($ua, 'redhat') !== false || strpos($ua, 'red hat') !== false) $ua_os = 'linuxredhat';
else if (strpos($ua, 'slackware') !== false) $ua_os = 'linuxslackware';
else if (strpos($ua, 'suse') !== false) $ua_os = 'linuxsuse';
else if (strpos($ua, 'ubuntu') !== false) $ua_os = 'linuxubuntu';
else if (strpos($ua, 'arch') !== false) $ua_os = 'linuxarch';
else $ua_os = 'linux';
}
if (strpos($ua, 'iPhone') !== false) $ua_os = 'ipod';
else if (strpos($ua, 'mac os x') !== false) $ua_os = 'macos';
else if (strpos($ua, 'amiga') !== false) $ua_os = 'amiga';
else if (strpos($ua, 'beos; ') !== false) $ua_os = 'beos';
else if (strpos($ua, 'freebsd') !== false) $ua_os = 'freebsd';
else if (strpos($ua, 'netbsd') !== false) $ua_os = 'netbsd';
else if (strpos($ua, 'sunos') !== false || strpos($ua, 'solaris') !== false) $ua_os = 'solaris';
else if (strpos($ua, 'symbian') !== false) $ua_os = 'symbian';
else if (strpos($ua, 'unix') !== false) $ua_os = 'unix';
$browser = $ua_browser;
$os = $ua_os;
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "postinfo (postid, OS, browser) VALUES (" . $post['postid'] . ",'$os' ,'$browser')");
Then edit Display the information on postbit:
Find:
$osname = array(
Add after:
'win_7' => "Windows 7",
Then i used this icon (leave it named what it is) Add it to images/useragent:
bollie
10-10-2009, 03:05 PM
I added windows 7 but had to delete windows 98 from the xml to make it work. To do it go into Plugins->Manage Plugins->Display OS and Browser->save on new post
Repalce ALL with:
$useragent = $_SERVER ? $_SERVER['HTTP_USER_AGENT'] : $HTTP_SERVER_VARS['HTTP_USER_AGENT'];
$ua = strtolower($useragent);
$ua_browser = 'unknown';
$ua_os = 'unknown';
// Browser detection:
if (strpos($ua, 'firefox') !== false) $ua_browser = 'firefox';
else if (strpos($ua, 'msie') !== false) $ua_browser = 'ie';
else if (strpos($ua, 'opera') !== false)
{
if (strpos($ua, 'opera mini ') === false) $ua_browser = 'opera';
else $ua_browser = 'operamini';
}
else if (strpos($ua, 'mozilla') !== false && strpos($ua, 'rv:') !== false) $ua_browser = 'mozilla';
else if (strpos($ua, 'netscape') !== false) $ua_browser = 'netscape';
else if (strpos($ua, 'safari') !== false) $ua_browser = 'safari';
else if (strpos($ua, 'epiphany') !== false) $ua_browser = 'epiphany';
else if (strpos($ua, 'galeon') !== false) $ua_browser = 'galeon';
else if (strpos($ua, 'konqueror') !== false) $ua_browser = 'konqueror';
else if (strpos($ua, 'firebird') !== false) $ua_browser = 'firebird';
else if (strpos($ua, 'avant browser') !== false) $ua_browser = 'avant';
else if (strpos($ua, 'maxthon') !== false || strpos($ua, 'myie') !== false) $ua_browser = 'maxthon';
else if (strpos($ua, 'slimbrowser') !== false) $ua_browser = 'slimbrowser';
else if (strpos($ua, 'chrome') !== false) $ua_browser = 'gc';
// OS detection:
if (strpos($ua, 'windows nt 6.1') !== false) $ua_os = 'win_7';
else if (strpos($ua, 'windows nt 5.0') !== false) $ua_os = 'windows_98_nt_2000';
else if (strpos($ua, 'windows 95') !== false) $ua_os = 'windows_98_nt_2000';
else if (strpos($ua, 'windows me') !== false) $ua_os = 'windows_me';
else if (strpos($ua, 'windows 98') !== false) $ua_os = 'windows_98_nt_2000';
else if (strpos($ua, 'windows nt 5.2') !== false || strpos($ua, 'windows nt 5.1') !== false) $ua_os = 'windows_xp_2003';
else if (strpos($ua, 'windows nt 6.0') !== false) $ua_os = 'windows_vista';
else if (strpos($ua, 'linux') !== false)
{
if (strpos($ua, 'debian') !== false) $ua_os = 'linuxdebian';
else if (strpos($ua, 'fedora') !== false) $ua_os = 'linuxfedora';
else if (strpos($ua, 'gentoo') !== false) $ua_os = 'linuxgentoo';
else if (strpos($ua, 'kateos') !== false || strpos($ua, 'kate os') !== false) $ua_os = 'linuxkateos';
else if (strpos($ua, 'knoppix') !== false) $ua_os = 'linuxknoppix';
else if (strpos($ua, 'kubuntu') !== false) $ua_os = 'linuxkubuntu';
else if (strpos($ua, 'mandriva') !== false || strpos($ua, 'mandrake') !== false) $ua_os = 'linuxmandriva';
else if (strpos($ua, 'redhat') !== false || strpos($ua, 'red hat') !== false) $ua_os = 'linuxredhat';
else if (strpos($ua, 'slackware') !== false) $ua_os = 'linuxslackware';
else if (strpos($ua, 'suse') !== false) $ua_os = 'linuxsuse';
else if (strpos($ua, 'ubuntu') !== false) $ua_os = 'linuxubuntu';
else if (strpos($ua, 'arch') !== false) $ua_os = 'linuxarch';
else $ua_os = 'linux';
}
if (strpos($ua, 'iPhone') !== false) $ua_os = 'ipod';
else if (strpos($ua, 'mac os x') !== false) $ua_os = 'macos';
else if (strpos($ua, 'amiga') !== false) $ua_os = 'amiga';
else if (strpos($ua, 'beos; ') !== false) $ua_os = 'beos';
else if (strpos($ua, 'freebsd') !== false) $ua_os = 'freebsd';
else if (strpos($ua, 'netbsd') !== false) $ua_os = 'netbsd';
else if (strpos($ua, 'sunos') !== false || strpos($ua, 'solaris') !== false) $ua_os = 'solaris';
else if (strpos($ua, 'symbian') !== false) $ua_os = 'symbian';
else if (strpos($ua, 'unix') !== false) $ua_os = 'unix';
$browser = $ua_browser;
$os = $ua_os;
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "postinfo (postid, OS, browser) VALUES (" . $post['postid'] . ",'$os' ,'$browser')");
Then edit Display the information on postbit:
Find:
$osname = array(
Add after:
'win_7' => "Windows 7",
Then i used this icon (leave it named what it is) Add it to images/useragent:
Thanks ;)
Joshkrz
10-27-2009, 02:38 PM
I added windows 7 but had to delete windows 98 from the xml to make it work. To do it go into Plugins->Manage Plugins->Display OS and Browser->save on new post
Repalce ALL with:
$useragent = $_SERVER ? $_SERVER['HTTP_USER_AGENT'] : $HTTP_SERVER_VARS['HTTP_USER_AGENT'];
$ua = strtolower($useragent);
$ua_browser = 'unknown';
$ua_os = 'unknown';
// Browser detection:
if (strpos($ua, 'firefox') !== false) $ua_browser = 'firefox';
else if (strpos($ua, 'msie') !== false) $ua_browser = 'ie';
else if (strpos($ua, 'opera') !== false)
{
if (strpos($ua, 'opera mini ') === false) $ua_browser = 'opera';
else $ua_browser = 'operamini';
}
else if (strpos($ua, 'mozilla') !== false && strpos($ua, 'rv:') !== false) $ua_browser = 'mozilla';
else if (strpos($ua, 'netscape') !== false) $ua_browser = 'netscape';
else if (strpos($ua, 'safari') !== false) $ua_browser = 'safari';
else if (strpos($ua, 'epiphany') !== false) $ua_browser = 'epiphany';
else if (strpos($ua, 'galeon') !== false) $ua_browser = 'galeon';
else if (strpos($ua, 'konqueror') !== false) $ua_browser = 'konqueror';
else if (strpos($ua, 'firebird') !== false) $ua_browser = 'firebird';
else if (strpos($ua, 'avant browser') !== false) $ua_browser = 'avant';
else if (strpos($ua, 'maxthon') !== false || strpos($ua, 'myie') !== false) $ua_browser = 'maxthon';
else if (strpos($ua, 'slimbrowser') !== false) $ua_browser = 'slimbrowser';
else if (strpos($ua, 'chrome') !== false) $ua_browser = 'gc';
// OS detection:
if (strpos($ua, 'windows nt 6.1') !== false) $ua_os = 'win_7';
else if (strpos($ua, 'windows nt 5.0') !== false) $ua_os = 'windows_98_nt_2000';
else if (strpos($ua, 'windows 95') !== false) $ua_os = 'windows_98_nt_2000';
else if (strpos($ua, 'windows me') !== false) $ua_os = 'windows_me';
else if (strpos($ua, 'windows 98') !== false) $ua_os = 'windows_98_nt_2000';
else if (strpos($ua, 'windows nt 5.2') !== false || strpos($ua, 'windows nt 5.1') !== false) $ua_os = 'windows_xp_2003';
else if (strpos($ua, 'windows nt 6.0') !== false) $ua_os = 'windows_vista';
else if (strpos($ua, 'linux') !== false)
{
if (strpos($ua, 'debian') !== false) $ua_os = 'linuxdebian';
else if (strpos($ua, 'fedora') !== false) $ua_os = 'linuxfedora';
else if (strpos($ua, 'gentoo') !== false) $ua_os = 'linuxgentoo';
else if (strpos($ua, 'kateos') !== false || strpos($ua, 'kate os') !== false) $ua_os = 'linuxkateos';
else if (strpos($ua, 'knoppix') !== false) $ua_os = 'linuxknoppix';
else if (strpos($ua, 'kubuntu') !== false) $ua_os = 'linuxkubuntu';
else if (strpos($ua, 'mandriva') !== false || strpos($ua, 'mandrake') !== false) $ua_os = 'linuxmandriva';
else if (strpos($ua, 'redhat') !== false || strpos($ua, 'red hat') !== false) $ua_os = 'linuxredhat';
else if (strpos($ua, 'slackware') !== false) $ua_os = 'linuxslackware';
else if (strpos($ua, 'suse') !== false) $ua_os = 'linuxsuse';
else if (strpos($ua, 'ubuntu') !== false) $ua_os = 'linuxubuntu';
else if (strpos($ua, 'arch') !== false) $ua_os = 'linuxarch';
else $ua_os = 'linux';
}
if (strpos($ua, 'iPhone') !== false) $ua_os = 'ipod';
else if (strpos($ua, 'mac os x') !== false) $ua_os = 'macos';
else if (strpos($ua, 'amiga') !== false) $ua_os = 'amiga';
else if (strpos($ua, 'beos; ') !== false) $ua_os = 'beos';
else if (strpos($ua, 'freebsd') !== false) $ua_os = 'freebsd';
else if (strpos($ua, 'netbsd') !== false) $ua_os = 'netbsd';
else if (strpos($ua, 'sunos') !== false || strpos($ua, 'solaris') !== false) $ua_os = 'solaris';
else if (strpos($ua, 'symbian') !== false) $ua_os = 'symbian';
else if (strpos($ua, 'unix') !== false) $ua_os = 'unix';
$browser = $ua_browser;
$os = $ua_os;
$vbulletin->db->query_write("INSERT INTO " . TABLE_PREFIX . "postinfo (postid, OS, browser) VALUES (" . $post['postid'] . ",'$os' ,'$browser')");Then edit Display the information on postbit:
Find:
$osname = array(Add after:
'win_7' => "Windows 7",Then i used this icon (leave it named what it is) Add it to images/useragent:
There isn't a "$osname = array(" anywhere.
smokin1337
10-27-2009, 07:10 PM
This is the entire plugin Display information on postbit with win 7 added:
$os = $post['OS'];
$browser = $post['browser'];
iF (!empty($os) && !empty($browser)) {
$browsername = array(
'firefox' => "Mozilla Firefox",
'ie' => "Windows Internet Explorer",
'opera' => "Opera",
'operamini' => "Opera Mini",
'mozilla' => "Mozilla",
'netscape' => "Netscape Navigator",
'safari' => "Safari",
'epiphany' => "Epiphany",
'galeon' => "Galeon",
'konqueror' => "Konqueror",
'firebird' => "Mozilla Firebird",
'avant' => "Avant Browser",
'maxthon' => "Maxthon",
'slimbrowser' => "SlimBrowser",
'gc' => "Google Chrome"
);
$osname = array(
'win_7' => "Windows 7",
'windows_xp_2003' => "Windows XP/2003",
'windows_vista' => "Windows Vista",
'linuxdebian' => "Debian",
'linuxfedora' => "Fedora",
'linuxgentoo' => "Gentoo Linux",
'linuxkateos' => "KateOS",
'linuxknoppix' => "knoppix",
'linuxkubuntu' => "Kubuntu",
'linuxmandriva' => "Mandriva Linux",
'linuxredhat' => "Red Hat Linux",
'linuxslackware' => "Slackware",
'linuxsuse' => "OpenSUSE",
'linuxubuntu' => "Ubuntu",
'linuxarch' => "Arch Linux",
'linux' => "Linux",
'macos' => "Mac OS",
'amiga' => "Amiga",
'beos' => "BeOS",
'freebsd' => "FreeBSD",
'netbsd' => "NetBSD",
'solaris' => "Solaris",
'symbian' => "Symbian OS",
'unix' => "Unix",
'windows_98_nt_2000' => "Windows 98/NT/2000",
'windows_me' => "Windows ME"
);
$os_name = $osname[$os];
$os_name = empty($os_name) ? $os : $os_name;
$browser_name = $browsername[$browser];
$browser_name = empty($browser_name) ? $browser : $browser_name;
$template_hook['postbit_userinfo_right'] .= "<img src='images/useragent/icon_$os.gif' alt='$os_name' /> <img src='images/useragent/icon_$browser.gif' alt='$browser_name' />";
}
tomalla
10-29-2009, 03:12 PM
Again Windows7
I've installed today this product. Information about Windows7 doesn't displayed. How to add Windows 7 icon and correct displaying info about windows 7. Actually windows 7 is displayed as windows nt,2000
bollie
10-29-2009, 03:30 PM
I have code matched
Look http://www.pctuts.be/f182/installeren-van-superantispyware-32690/ work for windows 7
samdu
04-16-2010, 06:22 PM
I got Windows 7 working pretty easily. Now Chrome on the other hand, not so much. I added a line in the Detect Browser section that should work and uploaded a matching icon to the proper location, but Chrome on MacOS still shows up as Safari. Is this a Chrome thing or something I'm missing in the Mod?
samdu
04-16-2010, 06:26 PM
Update: Chrome shows up as Safari in Windows as well.
lav0s
09-15-2010, 03:08 AM
any hope of seeing this on 4?
prologe60
10-03-2010, 08:34 PM
Good morning, I love this plugin you've adapted to vbulletin. But I have a problem is that every time I post on my forum with Google Chrome I get the Safari icon. I added the line mentioned above but I still have the same problem. If you can fix it please post the solution.
Greetings
bollie
12-05-2010, 01:50 PM
Look @ http://www.pctuts.be/f3/forum-bezoekers-37675/
Georgio H
01-07-2011, 03:04 PM
Mhm, it's a nice plugin i love it but it doesn't work that well..
I run windows 7 and it shows that i run windows 98? hahaha :P
Anything that's wrong?
Thanks.
danyxxx
09-18-2011, 06:55 AM
Is not working on 3.8.7 ...
EliasAlucard
04-29-2012, 11:56 AM
Mhm, it's a nice plugin i love it but it doesn't work that well..
I run windows 7 and it shows that i run windows 98? hahaha :P
Anything that's wrong?
Thanks.No, nothing wrong. The original author of this plugin did not include Windows 7. I've added Windows 7, Android and other operating systems in my modified version.
I am looking for a similar product but showing OS browser name too, not just icons.
This mod flaw is that not everyone can figure out the icons meaning.I've added more diversified icons for each specific operating system version. I'll continue improving this plugin, perhaps I'll upload my modified version later as a new plugin once I'm finished.
Is it possible to have something that resemble that:
http://www.emulab.it/forum/index.php?topic=422That's a bit difficult to implement with my current coding skills, although it's an interesting challenge I'm willing to take on.
Is not working on 3.8.7 ...It works fine here on 3.8.7 so you must have done something wrong. Has anyone tried this plugin with vB4 by the way?
EliasAlucard
05-10-2012, 02:03 PM
Anyone here knows if this plugin works with vB4?
EliasAlucard
07-11-2012, 09:24 AM
Here's my more up to date replacement, UADisplay:
https://vborg.vbsupport.ru/showthread.php?t=285373
sadiq6210
08-08-2012, 05:18 PM
I need it for vb4 =(
EliasAlucard
08-08-2012, 10:00 PM
I need it for vb4 =(Here's my update, works on vB4:
https://vborg.vbsupport.ru/showthread.php?t=285373
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.