vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   Show Spiders Online on ForumHome (https://vborg.vbsupport.ru/showthread.php?t=75986)

amykhar 02-11-2005 12:19 AM

Support will be slow for the next couple of days. My home DSL is down and I can't spend a lot of time on the web at work.

shadiguy1 02-11-2005 11:00 AM

can anyone find out why it wont work with 3.0.3 i would relly like to use it . Thanks in advance.

Couch 02-11-2005 04:50 PM

Works Perfectly. Thank you :)

richiepearce 02-11-2005 05:13 PM

Quote:

Originally Posted by shadiguy1
can anyone find out why it wont work with 3.0.3 i would relly like to use it . Thanks in advance.


I am using 3.0.3 and it works OK.

Viks 02-14-2005 02:42 PM

problem appears to be the syntax...not the mod.
try this
in line -> SELECT DISTINCT user.username, session.useragent,user.userid

there sud be a space between "session.useragent," AND "user.userid"

like below:

SELECT DISTINCT user.username, session.useragent, user.userid





Quote:

Originally Posted by shadiguy1
this is what i get when i install it.

Database error in vBulletin 3.0.3:

Invalid SQL:
SELECT DISTINCT user.username, session.useragent,user.userid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity >

ORDER BY session.userid

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 'ORDER BY session.userid' at line 7

mysql error number: 1064

Date: Thursday 10th of February 2005 08:46:21 AM
Script: http://nextelelite.com/forums/index.php?
Referer: http://nextelelite.com/
Username: Shadiguy1
IP Address: 205.188.116.7


amykhar 02-14-2005 03:54 PM

I have the requested changes made. I am just testing them - need to wait for more spiders to hit my site.

amykhar 02-14-2005 04:37 PM

If you have spiders on your site now and are willing to try out raw code , please follow the directions in this text file AFTER you have installed the original hack.

I have not been able to verify that this works because the spiders aren't crawling in hordes at my site today. If you install this test code and need help, you must be willing to share your forum url and have the who's online page available to guests. I can't debug otherwise.

(Attachment removed and posted down below.)

eva01_ 02-14-2005 05:31 PM

it wont let me edit the phrase O_o

kall 02-14-2005 06:47 PM

Quote:

Originally Posted by amykhar
If you have spiders on your site now and are willing to try out raw code , please follow the directions in this text file AFTER you have installed the original hack.

I have not been able to verify that this works because the spiders aren't crawling in hordes at my site today. If you install this test code and need help, you must be willing to share your forum url and have the who's online page available to guests. I can't debug otherwise.

It works fine for me.

http://forums.nzboards.com :)

For now, unregistereds can view the who's online.

*edit* although...I have google showing up multiple times.

Quote:

Originally Posted by forumhome.php
Most users ever online was 260, 06-Dec-2004 at 09:48 PM.
kall , google(1) , yahoofeedseeker(1) , google(2) , google(3) , google(4) , yahoo! slurp(1) , google(5) , yahoo! slurp(2)

*edit2*
And whosonline is spitting out the foul taste of an error:
Quote:

Originally Posted by online.php
1 members and 16 guests and [ARG:3 UNDEFINED] search engine spiders


eva01_ 02-14-2005 07:06 PM

curses why wont it let me edit the phrase ><!!!!

is it because we found a bug in vB when using safari?


All times are GMT. The time now is 05:46 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.02278 seconds
  • Memory Usage 1,742KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (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