vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Forum Home Enhancements - vbBOL 1.3.2 (https://vborg.vbsupport.ru/showthread.php?t=112877)

hambil 04-12-2006 10:00 PM

vbBOL 1.3.2
 
This version is no longer active. Get eXtremeTim's 3.6.x version: EWT - Enhanced Users Online With Spider Tracking

It's also compatible with 3.5.x.

Good luck, and good bot hunting!

evenmonkeys 04-13-2006 03:12 AM

That's actually pretty clever. =D

Makaveli105 04-13-2006 03:23 AM

nice idea. does this show to everyone or just admins?

SlaPPiE 04-13-2006 03:33 AM

Seems to show to everyone.

Works great, but is there a way to remove the extraneous space at the end of the spider name before the comma?

Freesteyelz 04-13-2006 03:33 AM

Hmm...I like this very much, Hambil. I've been playing with the style in vB Options and it's quite flexible. I'm using "italics" for now...Nothing fancy.

*Clicked Install*

Makaveli105 04-13-2006 03:37 AM

could it be an option in the admincp to make it show to just admins?

Tyegurl 04-13-2006 03:39 AM

ty hambil i hate having to go to the WOL to see the bots searching....

mathias 04-13-2006 04:25 AM

crashes my forum

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.skype,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity > 1144896870;

MySQL Error : Unknown column 'user.skype' in 'field list'

hambil 04-13-2006 04:29 AM

Quote:

Originally Posted by mathias
crashes my forum


Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid, user.options, session.host, session.badlocation, session.incalendar, user.aim, user.icq, user.msn, user.yahoo, user.skype,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity > 1144896870;

MySQL Error : Unknown column 'user.skype' in 'field list'

It won't work with 3.5.0. skype is after that version, somewhere. Probably don't need it. I'll trim the query in the next update sometime tonight.

tamborinegal 04-13-2006 04:40 AM

Thanks Hambil, very nice.

Clancy

mathias 04-13-2006 04:42 AM

Quote:

Originally Posted by hambil
It won't work with 3.5.0. skype is after that version, somewhere. Probably don't need it. I'll trim the query in the next update sometime tonight.


alright thank you sir

hambil 04-13-2006 04:49 AM

Updated...

mathias 04-13-2006 04:54 AM

works great thank you

hambil 04-13-2006 05:46 AM

I would also recommend replacing your default spiders_vbulletin.xml (in includes/xml) with this file. It will track many more spiders and bots.

Rickie3 04-13-2006 06:04 AM

this is the best yet works great on my 3.5.0 thankyou *installed*

Robru 04-13-2006 06:18 AM

Quote:

Originally Posted by hambil
I would also recommend replacing your default spiders_vbulletin.xml (in includes/xml) with this file. It will track many more spiders and bots.

Link is not working, sorry :)

Brandon Sheley 04-13-2006 06:19 AM

<a href="http://www.vbulletin.com/forum/attachment.php?attachmentid=14284" target="_blank">http://www.vbulletin.com/forum/attac...chmentid=14284</a> ^ for this person

btw my WOL already shows the spiders ?

Makaveli105 04-13-2006 06:23 AM

^^it says its forbidden?

Brandon Sheley 04-13-2006 06:23 AM

save taget as ;)

or here

Makaveli105 04-13-2006 06:25 AM

Thanks :D

Phalynx 04-13-2006 06:25 AM

Works great, thanks

Allan 04-13-2006 06:26 AM

i like this hack ;)

Click Install :)

File attach: French language ;)

Robru 04-13-2006 06:32 AM

Thanks for sharing :)

Phalynx 04-13-2006 07:06 AM

Seems not always to work like it should, I'm getting this message, now the 3rd time:


Code:

SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity >;

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 '' at line 4



It seems that $datecut is not always filled out.

Injektilo 04-13-2006 07:15 AM

same problem here : 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 '' at line 4 Error Number : 1064

foulplay 04-13-2006 07:32 AM

Very nice! *clicks install*

hugh_ 04-13-2006 07:37 AM

Nice work, thanks! I've been waiting for this as a plugin for ages...

reteep 04-13-2006 07:59 AM

Cool, installed.

Allan 04-13-2006 08:05 AM

No error for me.

Rickie3 04-13-2006 08:53 AM

no error here running sweet very happy

hambil 04-13-2006 09:55 AM

Quote:

Originally Posted by Phalynx
Seems not always to work like it should, I'm getting this message, now the 3rd time:


Code:

SELECT user.username, session.useragent, session.location, session.lastactivity, user.userid
FROM session AS session
LEFT JOIN user AS user USING (userid)
WHERE session.lastactivity >;

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 '' at line 4

It seems that $datecut is not always filled out.

Quote:

Originally Posted by Injektilo
same problem here : 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 '' at line 4 Error Number : 1064

Try it now - make sure "Allow Overwrite" is yes.

Phalynx 04-13-2006 09:59 AM

Thanks for update, works now.

Impreza04 04-13-2006 10:58 AM

Nice work, wan't keen on using Amy's Code Editing version..

Just a note however that forumhome_spider is uncached : )

Developer 04-13-2006 11:24 AM

very very great work ;) ... realy
i'll install it as soon as i change my index file due to amy's hack

Tyegurl 04-13-2006 12:49 PM

lol i install this and then there is an update....lmao

ty!

Snake 04-13-2006 01:42 PM

Now that's a great idea. Thanks! :)

Gizmo5h1t3 04-13-2006 02:09 PM

theres an uncached template on this, which adds a query every time a spider appears..

Quote:

"forumhome_spider"

hambil 04-13-2006 02:25 PM

Quote:

Originally Posted by Gizmo5h1t3
theres an uncached template on this, which adds a query every time a spider appears..

Thank you. It'll be fixed in the next release :)

Gottcha 04-13-2006 02:27 PM

thanks

dieselpowered 04-13-2006 02:40 PM

Quote:

Originally Posted by hambil
I would also recommend replacing your default spiders_vbulletin.xml (in includes/xml) with this file. It will track many more spiders and bots.

Hey there, your link does not work :)

Great hack..installed!


All times are GMT. The time now is 02:36 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.01508 seconds
  • Memory Usage 1,791KB
  • 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
  • (2)bbcode_code_printable
  • (8)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