vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Forum Display Enhancements - Remove Spiders from Who's Online (https://vborg.vbsupport.ru/showthread.php?t=152321)

ERuiz 07-15-2007 07:33 PM

I installed this mod and made the corresponding changes to the onlineusers.php file, but when I access my homepage, it says there are some guests on the who's online module block but if I go to the forum who's online display, it says there are no guests. What could be wrong?

mfyvie 07-15-2007 07:44 PM

Quote:

Originally Posted by ERuiz (Post 1292088)
I installed this mod and made the corresponding changes to the onlineusers.php file, but when I access my homepage, it says there are some guests on the who's online module block but if I go to the forum who's online display, it says there are no guests. What could be wrong?

Point 3 of the installation instructions - wait a few minutes ;)

When you first install the mod you will get different values for the numbers of guests in your vbadvanced block, the who's online total, and the total listed on the main forum index. Once your cookie timeout has expired (15-30 minutes) these values should converge to be the same. The reason is that you may be seeing old sessions which (because they are not active) have not been reclassified to either spider or non-spider in the session table.

ERuiz 07-15-2007 07:52 PM

Quote:

Originally Posted by mfyvie (Post 1292093)
Point 3 of the installation instructions - wait a few minutes ;)

When you first install the mod you will get different values for the numbers of guests in your vbadvanced block, the who's online total, and the total listed on the main forum index. Once your cookie timeout has expired (15-30 minutes) these values should converge to be the same. The reason is that you may be seeing old sessions which (because they are not active) have not been reclassified to either spider or non-spider in the session table.

Thanks for the quick response. Ok, I will give it 1 hour, LOL. Thanks again...

ERuiz 07-15-2007 08:01 PM

I did the edit for the control panel option and I get an error... It says it can't find the session table.

I had to manually add vb3_ (my prefix) to the session.spider portion of the code you provided and this got rid of the error.

I am using 3.6.7 and VBA RC1

mfyvie 07-15-2007 08:32 PM

Quote:

Originally Posted by ERuiz (Post 1292107)
I had to manually add vb3_ (my prefix) to the session.spider portion of the code you provided and this got rid of the error.

Thanks for pointing that out - I checked my example above and changed it slightly. I dropped off the "sessions." part which means it should work without a prefix. I also noticed a small problem with that example - the value to test for was 0, it should have been -1. You should change yours accordingly otherwise it will report your number of guests as 0.

keyness 07-15-2007 10:18 PM

There is something wrong in this mod mfyvie, I've installed it 30 minutes ago, but when I click to who's online, I just can see 5 members and 1 guest, but I am pretty sure, there are at least 10 active users for last 2 minutes. I'll wait several minutes too.

efil 07-16-2007 03:20 AM

Hi,
When i use vBadvanced onlineusers.php edit, I get this database error:
Quote:

Database error in vBulletin 3.6.7:

Invalid SQL:

SELECT session.userid, username, usergroupid, (user.options & 512) AS invisible, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity > 1184558427
AND " . TABLE_PREFIX . "session.spider = 0

ORDER BY username ASC;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'session.spider = 0

ORDER BY username ASC' at line 5
Error Number : 1064

mfyvie 07-16-2007 05:28 AM

Quote:

Originally Posted by keyness (Post 1292214)
There is something wrong in this mod mfyvie, I've installed it 30 minutes ago, but when I click to who's online, I just can see 5 members and 1 guest, but I am pretty sure, there are at least 10 active users for last 2 minutes. I'll wait several minutes too.

How are you sure that there are 10 active users? The other 4 may be spiders, or they may be inactive. Which view was this? Check both the front page of your forum, and the who's online display - in the first 15-30 minutes these may report different numbers. If you still don't believe it, you can manually check the session table in the database (however, this also shows sessions that are inactive). In the column "spider" you'll see -1, 0 or 1. 1 means spider, -1 means non-spider and 0 means that it hasn't decided yet (happens on new installs for inactive sessions). I wouldn't be so quick to pronounce something wrong with the mod, it could simply be that you have less "real users" than you thought ;)

Quote:

Originally Posted by efil (Post 1292408)
Hi, When i use vBadvanced onlineusers.php edit, I get this database error:

I've altered the syntax of that example I posted slightly use double quotes instead of single quotes. If you just change the two single quotes into double quotes it should work (or recopy the line from my example in the mod text at the top). I've tested this on my own forum and it worked.

Hornstar 07-16-2007 06:08 AM

Thanks, I may consider installing this, as it might offer an improvement on performance.

projectego 07-16-2007 08:56 AM

Great idea. Thanks a bunch!

/me clicks install


All times are GMT. The time now is 07:05 AM.

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.01044 seconds
  • Memory Usage 1,745KB
  • 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
  • (6)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
  • (10)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