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)

Charlie98902 07-18-2007 01:24 PM

When it is running it may be conflicting with one of my other mods, it was just a want not a I need this really, so I can live without it.

Kohhal 07-18-2007 02:48 PM

Quote:

Originally Posted by mfyvie (Post 1293575)
Ok, well there are only 3 places I know of where this can happen. The admincp (which my mod stops from updating the total), the who's online display, the main forum display, and the vbadvanced module (if you are running vbadvanced). If for example you are running vbadvanced and forgot to edit this module, it will be reseting the totals for you.

Can you confirm that you aren't running vbadvanced, and that you don't have any other areas of your forum where the maxonline is displayed (or updated)? Also, which version of vb are you running? If you are running pre 3.6.6 there is different code, but I wasn't able to test this because I'm running 3.6.7.

I'm not running vbadvanced and I've no hacks or anything installed that should affect this. Only couple of minor hacks installed.

I don't have any non-default displays of max users online anywhere so dunno if that could be it.

I'm running 3.6.7 PL1

SnitchSeeker 07-22-2007 05:05 PM

Quote:

I've never understood why people want to know the number of spiders on their board - it's a totally meaningless number - you could have 500 yahoo slurp spiders crawling one page per session, or you could have a single spider crawl 500 pages in a single session. What's more important to check is the spider activity in your weblogs - it really doesn't have any place in your online users in vbulletin.
I suppose you're right. I was thinking mainly for my own benefit so that if the site is slow I can see if it's due to a high number of spiders on. I've never been good at checking logs. They're complicated to understand for me at least. I'm not very technical savvy.

rungok 07-22-2007 06:32 PM

Thanx for this mod. But I have a problem wich you have talked about before. When I insert
Code:

" . ($killspiders ? " AND " . TABLE_PREFIX . "session.spider = -1 " : null) . "
in the onlineusers.php I get this fault:
Quote:

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT session.userid, username, usergroupid, (user.options & 512) AS invisible, IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM vb_session AS session
LEFT JOIN vb_user AS user USING (userid)
WHERE session.lastactivity > 1185130825
AND vb_session.spider = -1
ORDER BY invisible ASC, username ASC;

MySQL Error : Unknown table 'vb_session' in where clause
Error Number : 1109
Date : Sunday, July 22nd 2007 @ 09:30:25 PM
Script : http://www.nettkafeen.no/forums/portal.php
Referrer : http://www.nettkafeen.no/forums/index.php
IP Address : 81.167.190.76
Username : Mr.Man
Classname : vb_database
and the vb_session table exist.

rungok 07-22-2007 07:02 PM

Solved it. I just pasted this line without the table prefix, and it worked.
Code:

" . ($killspiders ? " AND session.spider = -1 " : null) . "
All of my tables have table-prefix _vb, but the rest of the original query refers to this table without it.

AndyP 07-27-2007 01:57 AM

Is anyone else trying to use this mod with PaulM's most ever mod?

I'm currently getting low counts for active users, that is, spiders aren't included.
But the most ever guest count is a lot higher than I'd expect. It must be including spiders, and in turn affecting the most ever users online stat.

Are they compatable? To me it doesn't look like it.

lebanon 07-28-2007 11:46 AM

I just added ur mod, however whats weird is my record of users went down from 1600 to 172 members online and today as the record.
My who is online shows guests but the main page shows 0 guests,
Am only confused cause i cant see in the code what could mess up the record query !

mfyvie 07-28-2007 12:13 PM

Quote:

Originally Posted by rungok (Post 1298478)
Solved it. I just pasted this line without the table prefix, and it worked.
Code:

" . ($killspiders ? " AND session.spider = -1 " : null) . "
All of my tables have table-prefix _vb, but the rest of the original query refers to this table without it.

Thanks for that. Very strange though - I have to check more into that syntax. I don't use table prefixes, or mysql 5 - are you using mysql 5 and if so, is strict mode set?

Quote:

Originally Posted by AndyP (Post 1302783)
Is anyone else trying to use this mod with PaulM's most ever mod?

I'm currently getting low counts for active users, that is, spiders aren't included.
But the most ever guest count is a lot higher than I'd expect. It must be including spiders, and in turn affecting the most ever users online stat.

Are they compatable? To me it doesn't look like it.

From the looks of it they wouldn't be compatible. The reason is that Paul's mod will not be differentiating spiders in the totals, and is probably re-writing the max online statistic.

Quote:

Originally Posted by lebanon (Post 1303819)
I just added ur mod, however whats weird is my record of users went down from 1600 to 172 members online and today as the record.
My who is online shows guests but the main page shows 0 guests,
Am only confused cause i cant see in the code what could mess up the record query !

Sounds like the mod is functioning exactly as designed. I suggest you give it time (see other posts on this thread which cover the same subject) and the number of guests will increase to the correct number. If in doubt -use the test script I included to verify that everything is working as you expect.

AndyP 07-28-2007 12:19 PM

Thanks mfyvie, that's what I thought. It would be great if they did work together though, as now it looks like I might have to drop one of them, unless I can work out a way to edit it myself.

mfyvie 07-28-2007 12:23 PM

Quote:

Originally Posted by AndyP (Post 1303833)
Thanks mfyvie, that's what I thought. It would be great if they did work together though, as now it looks like I might have to drop one of them, unless I can work out a way to edit it myself.

Take a look into Paul's mod and see if you can see the part where it does a query to get the number of guests. It should just be a matter of adding "AND spider = -1" to the "WHERE" section of the query. After that you'll probably want to manually reset the max online totals again.


All times are GMT. The time now is 06:35 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.01060 seconds
  • Memory Usage 1,751KB
  • 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
  • (3)bbcode_code_printable
  • (7)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)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