vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   Browser on Who's Online (https://vborg.vbsupport.ru/showthread.php?t=103996)

Landlord 01-02-2006 05:29 AM

i think one part of the problemw ould be that my ENTIRE original code in the forumdisplay_loggedinuser is

$stylevar[dirmark]<a href="member.php?$session[sessionurl]u=$loggedin[userid]" target="_blank">$loggedin[musername]</a>$loggedin[invisiblemark]$loggedin[buddymark]

so i don't know where to find a <if condition="$loggedin[userid]"> like the install asks...

derekivey 01-02-2006 03:31 PM

Move the code you added for this hack up before
Code:

$stylevar[dirmark]<a href="member.php?$session[sessionurl]u=$loggedin[userid]"
That will fix it.

derekivey 01-02-2006 03:32 PM

Quote:

Originally Posted by RasMasta
What does this do for guests and spiders?

It doesn't do anything for them. They appear normal on the online page.

Xtrato 01-03-2006 08:59 PM

what if i dont add this
FIND:

user.username, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, user.usergroupid,

IN LINE FIND:

user.username,

AFTER ADD:

user.browser,

cuz i get errors if i do

derekivey 01-03-2006 10:38 PM

What error do you get? You need that or the hack will not work.

derekivey 01-04-2006 11:49 PM

Version 1.0.1 has been released. I have moved the users' browser information to the session table instead of the user table. Also, I have removed 'Unknown' from being stored in the database, and have replaced it with Psionic Vision's suggestion.

Simply follow the upgrade instructions in the install.txt file to upgrade.

Let me know if you have any problems.

Derek

Felan 01-05-2006 09:09 AM

Quote:

Originally Posted by derekivey
Version 1.0.1 has been released. I have moved the users' browser information to the session table instead of the user table. Also, I have removed 'Unknown' from being stored in the database, and have replaced it with Psionic Vision's suggestion.

Simply follow the upgrade instructions in the install.txt file to upgrade.

Let me know if you have any problems.

Derek

in my who have visited hack not appear the browser,why?

P.S.great hack ;)

derekivey 01-05-2006 09:43 AM

Sorry, this hack doesn't support that hack, so therefore the browser information isn't shown on that hack.

Hellraider 01-05-2006 02:57 PM

Got the same error as mentioned in post #16 on uninstalling version 1.0.1.

Manually reverting the template and file edits seems to be OK.

But product is still shown in installed product list and could not be removed.

How do I remove the entry in the product list?

lanc3lot 01-06-2006 07:37 AM

Hello nice idea, some questions.

- Can i have this only appear on the Who's Online page?
- Why is not working with the guests? I mean can it see what the guest browser is, and show approximately?
- What will happen if we have special html markaps for our users in our forums? We use special mini icons for each of our usergroups. Will they be replaced from the browser icons or will display both of them (for this i only want to have it on my Who's Online page, prefferably with both the icons displayed)

Thnx in advance for any reply :)

derekivey 01-06-2006 06:42 PM

Quote:

Originally Posted by Hellraider
Got the same error as mentioned in post #16 on uninstalling version 1.0.1.

Manually reverting the template and file edits seems to be OK.

But product is still shown in installed product list and could not be removed.

How do I remove the entry in the product list?

Sorry about that, I'll take a look and get back to you.

Quote:

Originally Posted by lanc3lot
- Can i have this only appear on the Who's Online page?

No, that is currently not in this hack. I am looking into adding it, and it should be in a new version...

Quote:

Originally Posted by lanc3lot
Why is not working with the guests? I mean can it see what the guest browser is, and show approximately?

Currently, since your first question isn't in this hack, it can't show it for guests. When I add it to the Whos online page, I will make it show for guests too, but since guests don't show on the who's online box, it's not possible to show their browser with this hack.

Quote:

Originally Posted by lan3lot
What will happen if we have special html markaps for our users in our forums? We use special mini icons for each of our usergroups. Will they be replaced from the browser icons or will display both of them (for this i only want to have it on my Who's Online page, prefferably with both the icons displayed)

If you keep your code in there and have the code for this hack, it should show both.

Derek

Bubble #5 01-06-2006 07:45 PM

Very nice hack Derek! We'll be adding it soon and look forward to the new features :nervous:

lanc3lot 01-06-2006 09:22 PM

Thnx for your replies, waiting for the new version :)

Xtrato 01-07-2006 05:55 PM

Edit: i fixed it it seems i needed to to the tempalte edits then the porduct before i do the index.php edit.

Code:

There seems to have been a problem with the
Please try again by clicking the Refresh button in your web browser.

An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.

We apologise for any inconvenience.

Database error in vBulletin 3.5.2:

Invalid SQL:

                SELECT
                        user.username, (user.options & 512) AS invisible, user.usergroupid,
                        session.userid, session.browser, session.inforum, session.lastactivity,
                        IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
                FROM vb3_session AS session
                LEFT JOIN vb3_user AS user ON(user.userid = session.userid)
                WHERE session.lastactivity > 1136662721
                ORDER BY username ASC;

MySQL Error  : Unknown column 'session.browser' in 'field list'
Error Number : 1054
Date        : Saturday, January 7th 2006 @ 01:53:41 PM
Script      :
Referrer    :
IP Address  :
Username    :
Classname    : vb_database


bashy 01-07-2006 05:57 PM

Edit ya IP address m8..tis best if ya do :)

Xtrato 01-07-2006 06:05 PM

Wow of all the things a deleted i left the ip wow thanks hehe

bashy 01-07-2006 06:07 PM

NP m8, just trying to help :)

Have fun

Bashy

derekivey 01-07-2006 10:56 PM

Hmm, for some reason the SQL query didn't get executed when you imported the product. Please run the following query in your AdminCP or PHPMyAdmin:
[sql]
ALTER TABLE `vb3_session` ADD `browser` VARCHAR( 50 ) DEFAULT '' NOT NULL;
[/sql]

Let me know if you still have any problems.

Derek

murrtex 01-09-2006 02:09 AM

Invalid SQL:
ALTER TABLE `session` DROP `browser`;;

MySQL Error : Can't DROP 'browser'; check that column/key exists
Error Number : 1091

uninstall problem I have...how can I fix it for uninstall???

derekivey 01-09-2006 09:33 AM

Just edit the product and remove the stuff in the uninstall code selected, then try uninstalling, that should fix it.

soulface 01-11-2006 04:49 PM

Installed... working fine so far without any prob. I think it'll be very nice if it'll show nick as 'Group by Browser', bcuz when thr'll be 50/100 users online it'll look funny or messy :/

EasyTarget 01-11-2006 05:04 PM

heh, I just came here to request what soulface said... organize the wol by browser so that only 1 icon is displayed for each browser in use.

derekivey 01-11-2006 06:53 PM

Ok, I can probably add an option to do that. I'll take a look and see. Nice Suggestion!

350Chevy 01-12-2006 01:53 AM

Looks good.. One problem though, vBAdvanced CMPS v2.0.0 needed to be modified as well if you use it and would like it to show properly on your home page. ;)

For those who use vbAdvanced and would like it to work for your home page do the following.

in /modules/onlineusers.php find:

Code:

                        SELECT session.userid, username, usergroupid, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
and replace it with:

Code:

                        SELECT session.userid, session.browser, username, usergroupid, (user.options & " . $vbulletin->bf_misc_useroptions['invisible'] . ") AS invisible, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
again in /modules/onlineusers.php find:

Code:

                                'username' => $vbulletin->userinfo['username'],
add after:

Code:

                                'browser' => $vbulletin->session->vars['browser'],
That should do it. :)

* Clicks install.

derekivey 01-12-2006 08:03 PM

Thanks for that tutorial. I'll add it to the first post so that people who use vBa know what to do. :)

Thanks again,
Derek

350Chevy 01-13-2006 01:01 AM

Quote:

Originally Posted by 4number8
Working on 3.5.1, You don't have images for a dark type forum do you? thanks for this btw, pretty cool.

I have cleaned the images up a bit so they look ok on any background. Feel free to use. :) derekivey, feel free to place these in place of yours if you'd like. ;)

Quote:

Originally Posted by derekivey
Thanks for that tutorial. I'll add it to the first post so that people who use vBa know what to do.

Thanks again,
Derek

No problem. And it's just your code with a bit of common sense so there's no need to thank me. You would've easily figured it out if you were using vBAdvanced. ;)

350Chevy 01-13-2006 01:10 AM

Anyway we can add WebTV as a browser?

Edit: Attached WebTV icon in case you decide to add it or use it. ;)

derekivey 01-13-2006 01:57 AM

Thanks, I'll add it to the next release with your images too.

Thanks so much!

Derek

bashy 02-04-2006 05:32 PM

Hi peeps

I get this error (below) from only 1 member atm, he cannot login when this
hack is turned on, turn it off an he can login although the ? icon shows when turned off so looks a tad untidy...anyway back to the issue at hand lol...

Whats ya thoughs, his browser is IE6 but the WOL is showing him as mozilla?
Your hack is showing him as a question mark and stops him from loggin in

Database error in vBulletin 3.5.3:

Invalid SQL:
;

MySQL Error : Query was empty
Error Number : 1065
Date : Saturday, February 4th 2006 @ 07:08:08 PM
Script : http://IP.ADDY/bashys-place.com/forums/index.php
Referrer :
IP Address : This was an IP addy :p
Username : This used to be a username
Classname : some database

derekivey 02-04-2006 06:25 PM

Hmm, thats a weird error. Want to PM me admin access details so I can take a look? Also have you installed any hacks that modify user sessions?

Thanks,
Derek

bashy 02-04-2006 06:37 PM

PM on way...

As for installing out to do with the sessions, not sure, i cant emember sorry, but i am sure you can see for ya self m8, I have 1 or 2 installed pmsl....

Quote:

Originally Posted by derekivey
Hmm, thats a weird error. Want to PM me admin access details so I can take a look? Also have you installed any hacks that modify user sessions?

Thanks,
Derek


bashy 02-04-2006 07:36 PM

Hi m8

I have got to the bottom of this..

Its his firewall blocking ya script....
He is using sygate

derekivey 02-04-2006 08:40 PM

Thats really weird lol. It just uses vB's is_browser function to determine the browser, so I guess your right. His firewall must be blocking access to your forum somehow.

bashy 02-04-2006 09:01 PM

Very m8 lol...Like i say, turn ya hack off and he gets in no problem lol

Quote:

Originally Posted by derekivey
Thats really weird lol. It just uses vB's is_browser function to determine the browser, so I guess your right. His firewall must be blocking access to your forum somehow.


rza733 02-05-2006 05:31 PM

I have a huge problem... When i try to uninstall this it gives me a DB error

Code:

Database error in vBulletin 3.5.0:

Invalid SQL:
ALTER TABLE `session` DROP `browser`;;

MySQL Error  : Can't DROP 'browser'; check that column/key exists
Error Number : 1091
Date        : Sunday, February 5th 2006 @ 12:30:31 PM
Script      : http://www.rzasspot.com/admincp/plugin.php
Referrer    : http://www.rzasspot.com/admincp/plugin.php?do=productdelete&productid=browser_on_wol&s=
IP Address  : 70.228.161.236
Username    : RzA
Classname    : vb_database

any suggestion on what to do?? Im using 3.5.0

derekivey 02-05-2006 06:30 PM

You can ignore that error. That just means that field doesn't exist in your database.

If it won't let you uninstall completely, just edit the product and remove the uninstall code.

Derek

rza733 02-05-2006 07:55 PM

Quote:

Originally Posted by derekivey
You can ignore that error. That just means that field doesn't exist in your database.

If it won't let you uninstall completely, just edit the product and remove the uninstall code.

Derek


Ok that seemed to work thank you...

for some reason when i had it installed i kept gettin DB errors :(

rza733 02-05-2006 09:44 PM

I am now getting this error

Code:

Database error in vBulletin 3.5.0:

Invalid SQL:
UPDATE session SET browser='internet_explorer' WHERE userid='80';

MySQL Error  : Unknown column 'browser' in 'field list'
Error Number : 1054
Date        : Sunday, February 5th 2006 @ 02:46:38 PM
Script      : http://www.rzasspot.com/vbshout.php
Referrer    : http://www.rzasspot.com/index2.php?
IP Address  : 66.245.131.35
Username    : Wild1LORI
Classname    : vb_database

any idea why?

derekivey 02-05-2006 11:27 PM

That means it didn't insert the browser field to the session table. To fix it run this query in PHPMyAdmin or vB's Query page in the AdminCP:
[sql]
ALTER TABLE `session` ADD `browser` VARCHAR( 50 ) DEFAULT '' NOT NULL;
[/sql]

rza733 02-06-2006 01:13 AM

Quote:

Originally Posted by derekivey
That means it didn't insert the browser field to the session table. To fix it run this query in PHPMyAdmin or vB's Query page in the AdminCP:
[sql]
ALTER TABLE `session` ADD `browser` VARCHAR( 50 ) DEFAULT '' NOT NULL;
[/sql]

thanks again man!!!


All times are GMT. The time now is 12:53 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.01392 seconds
  • Memory Usage 1,839KB
  • 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
  • (8)bbcode_code_printable
  • (12)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)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