vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Miscellaneous Hacks - Display OS and Browser Information on Postbit (https://vborg.vbsupport.ru/showthread.php?t=219687)

nomoreturn 07-30-2009 03:49 PM

Quote:

Originally Posted by psychobike (Post 1857959)
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 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

Quote:

Originally Posted by synseal (Post 1858678)
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/user...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

1 Attachment(s)
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

Quote:

Originally Posted by bollie (Post 1858341)
images/useragent/

Helpppp

onlyfree 07-31-2009 11:22 AM

Quote:

Originally Posted by bollie (Post 1858972)
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

Quote:

Originally Posted by Andy69 (Post 1859005)
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

Quote:

Originally Posted by psychobike (Post 1859118)
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

Quote:

Originally Posted by Fighter1405 (Post 1859136)
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

Quote:

Originally Posted by psychobike (Post 1859143)
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

Quote:

Originally Posted by psychobike (Post 1859143)
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
Code:

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

Code:

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

Code:

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

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

Code:

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/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):

Code:

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

Code:

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

Quote:

Originally Posted by Huy Ho?ng (Post 1868343)
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/admin....php?do=search
postbit_legacy (open it )

and search for :
Code:

<if condition="$show['reppower']">
add above :
Code:

$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:
Code:

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

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


All times are GMT. The time now is 03:35 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01524 seconds
  • Memory Usage 1,865KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (11)bbcode_code_printable
  • (10)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete