vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.7 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=228)
-   -   Administrative and Maintenance Tools - vb Linkchecker Bot 1.1 (https://vborg.vbsupport.ru/showthread.php?t=190407)

sarkar 09-10-2008 01:23 PM

LOL @ BW

Where do we use it ?

steve1966 09-10-2008 02:12 PM

Quote:

Originally Posted by rmxs (Post 1618941)
login to phpmyadmin and look on the right if the tables have any prefix like vb_

Now with this query you try to alter in
my_forum1.


hi please could you includer a screenshot as i dont know where to look thanks

sarkar 09-10-2008 02:24 PM

https://vborg.vbsupport.ru/external/2008/09/44.jpg

U see here the table prefix is vb_

If u dont have anythin, then ur table prefix is blank.

steve1966 09-10-2008 02:37 PM

Quote:

Originally Posted by sarkar (Post 1619027)
https://vborg.vbsupport.ru/external/2008/09/44.jpg

U see here the table prefix is vb_

If u dont have anythin, then ur table prefix is blank.

thanks it worked my prefix was blank

sarkar 09-10-2008 02:42 PM

Quote:

Originally Posted by steve1966 (Post 1619044)
thanks it worked my prefix was blank

No problems. Always here to help.

steve1966 09-10-2008 02:49 PM

Juts one more question please i have recieved the pm to report my dead links

http://myforum/forums/vbbot/showthread.php?t=137

and i have thislink above but when i click on it the link is dead have i forgot to edit something in the php file ? thanks

Dman91 09-10-2008 02:59 PM

I dont understand, please explain more clearly... and pm me your bot.php file.

steve1966 09-10-2008 03:18 PM

Quote:

Originally Posted by Dman91 (Post 1619058)
I dont understand, please explain more clearly... and pm me your bot.php file.


Hi i have pm you my file here is the mesaage i recieve when i click on this link

http://my forum/forums/vbbot/showthread.php?t=256

it does not connect to anywhere



Code:

I have moved your topic to trash
Hey,I'm the LC Bot.
Your topic has been moved to trash since the links in it were dead.
Please check it out.If u suppose the I am wrong, don't PM me, but PM any of the staff members of the site
http://my forum/forums/vbbot/showthread.php?t=256


Dman91 09-10-2008 03:24 PM

steve,
PHP Code:

$showurl 'http://www.yourdomain.com/forums/vbbot/showthread.php?t='//Your URL 

needs to be
PHP Code:

$showurl 'http://www.yourdomain.com/forums/showthread.php?t='//Your URL 

Regards,
Dman

steve1966 09-10-2008 03:25 PM

many thanks

steve1966 09-10-2008 03:28 PM

last question should the working links on my forum show now as checked because i have not seen any posts that say the links have been checked the bot has sent the dead links to trash

Dman91 09-10-2008 03:29 PM

It should...

steve1966 09-10-2008 03:35 PM

i used my userid here is that correct ?

$botid = '1'; //Userid of bot

thanks

Dman91 09-10-2008 03:39 PM

yeah thats fine.

steve1966 09-10-2008 03:56 PM

Quote:

Originally Posted by Dman91 (Post 1619097)
It should...

i have looked to see if there is a posts that says linked checke d i still cannot find one ?

fordsho 09-10-2008 04:25 PM

Hello Dman installed and a great hack just ran into 1 problem.

Bot ran for around 30mins then stopped.

Now every time i try to run the bot now i get the following error.

Code:

Using Method where time_check is 0
Active : http://rapidshare.com/files/45298518/HPTDH.part01.raror

Fatal error: Call to undefined function curl_init() in /home/forum/public_html/vbbot.php on line 64


Dman91 09-10-2008 06:18 PM

Ask your administrator to install cURL in PHP.

rmxs 09-10-2008 07:08 PM

Quote:

Originally Posted by sarkar (Post 1618968)
Replace:

$qu2 = mysql_query("SELECT `pagetext`, `userid` , `username` FROM `".$prefix."post` WHERE `postid` = '$pid'");

With this:

$qu2 = mysql_query("SELECT `pagetext`, `userid` , `username` FROM `".$prefix."post` WHERE `postid` = '$pid'") or die(mysql_error());

And please report back what you get.



This error will be fixed in the next release.

Till now after 500 threads check no error

rmxs 09-10-2008 07:15 PM

I try to find in the code what happening when in post with 10 links 2 its dead..byt nothing found..
FInally whats happening?

iPodHacking.com 09-10-2008 07:48 PM

Hey i am getting this error
Parse error: syntax error, unexpected T_STRING in /home/mysite/public_html/vbbot.php on line 37

Can anyone help?

pierians 09-10-2008 07:49 PM

Thnx a lot!
Works perfect on 3.7.1

rmxs 09-10-2008 07:49 PM

Quote:

Originally Posted by iPodHacking.com (Post 1619359)
Hey i am getting this error
Parse error: syntax error, unexpected T_STRING in /home/mysite/public_html/vbbot.php on line 37

Can anyone help?

Replace with this

Links checked on ' . date('d/m/y'). ' by Link Check Bot'; //This will append this at the end of the checked post

rmxs 09-10-2008 07:52 PM

If i make this `forumid` = 2 OR `forumid` = 3 OR `forumid` = 4 OR `forumid` = 5 OR `forumid` = 6

Its ok for more forums search?

iPodHacking.com 09-10-2008 08:00 PM

I am still getting the same error. Even when replaceing that

rmxs 09-10-2008 08:19 PM

Replace also this...

Quote:

// Start of user defined variables
$trash = '209'; //Forum id of trash
$botid = '3'; //Userid of bot
$botname = 'Port_Wolf_Check'; //Username of bot
$check = '`forumid` = 222'; //Forums to check
$pa = '
Make sure that you dont have delete any ; or $

iPodHacking.com 09-10-2008 08:23 PM

Ok i did that now i get this
"Warning: fopen(botruns.txt) [function.fopen]: failed to open stream: Permission denied in /home/mysite/public_html/vbbot.php on line 25

Warning: fclose(): supplied argument is not a valid stream resource in /home/mysite/public_html/vbbot.php on line 26

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mysite/public_html/vbbot.php on line 123

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mysite/public_html/vbbot.php on line 128
Using Method where it seems that all topics have been checked.

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mysite/public_html/vbbot.php on line 146

Warning: unlink(botruns.txt) [function.unlink]: No such file or directory in /home/mysite/public_html/vbbot.php on line 293"

rmxs 09-10-2008 08:33 PM

Quote:

Originally Posted by iPodHacking.com (Post 1619389)
Ok i did that now i get this
"Warning: fopen(botruns.txt) [function.fopen]: failed to open stream: Permission denied in /home/mysite/public_html/vbbot.php on line 25

Warning: fclose(): supplied argument is not a valid stream resource in /home/mysite/public_html/vbbot.php on line 26

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mysite/public_html/vbbot.php on line 123

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mysite/public_html/vbbot.php on line 128
Using Method where it seems that all topics have been checked.

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/mysite/public_html/vbbot.php on line 146

Warning: unlink(botruns.txt) [function.unlink]: No such file or directory in /home/mysite/public_html/vbbot.php on line 293"

Ok create a folder at your forum root with name exp. BOT chmod this folder to 777

Change line ~28 with
Quote:

require_once "../includes/config.php"; //assumes this is in vb folder
you access now with domain.com/BOT/bot.php

iPodHacking.com 09-10-2008 08:45 PM

ok thanks. Now i get this
Bot is running

Is that normal

iPodHacking.com 09-10-2008 08:50 PM

also does this check links in [code] tags?

rmxs 09-10-2008 08:55 PM

Yes work on code..

If you get this message there is the log file in the folder try this /bot.php?deletefile

and then run the bot again

fordsho 09-10-2008 08:58 PM

Quote:

Originally Posted by Dman91 (Post 1619267)
Ask your administrator to install cURL in PHP.

Thanks Dman rebuilding apache now.

fordsho 09-10-2008 09:07 PM

OK question what is the best way to set the bot to run every 24hrs.

Im guessing Scheduled Task Manager and set one to run every 24hrs then one to delete every 23hrs sound good?

iPodHacking.com 09-10-2008 09:15 PM

Quote:

Originally Posted by rmxs (Post 1619403)
Yes work on code..

If you get this message there is the log file in the folder try this /bot.php?deletefile

and then run the bot again

OK thanks

iPodHacking.com 09-10-2008 09:16 PM

Also. Do i have to run the script manually to make it check the links. Or does it do it by its self?

f4vn 09-10-2008 10:46 PM

What happen if my board's thousands of threads and ~10 links in each thread ... when you run this bot may be it become a DDoS tool :D

iPodHacking.com 09-10-2008 11:26 PM

Hey when i run the vbbot.php the first time i get this error"Warning: require_once(/includes/config.php) [function.require-once]: failed to open stream: No such file or directory in /home/mysite/public_html/bot/vbbot.php on line 28

Fatal error: require_once() [function.require]: Failed opening required '/includes/config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mysite/public_html/bot/vbbot.php on line 28"

And if i press refresh it says :Bot is running.
But it hasn't checked any links after running for 3 hours. So i think there might be an error

FRANKTHETANK 2 09-10-2008 11:35 PM

I keep getting this error when I run my sql queries.

Error

SQL query:

ALTER TABLE `thread` ADD `time_check` INT( 10 ) NOT NULL DEFAULT '0' AFTER `taglist`

MySQL said: Documentation
#1060 - Duplicate column name 'time_check'

Any Idea's

edermix 09-11-2008 12:19 AM

Thank you friends, succeed, but still left me some doubts:

-- Active status active on the links that are inactive, the right not appear deria Bouncing?

-- The length of time of MySQL is very short: 15 seconds, changed here:

Quote:

echo 'Now script will pause for 15 seconds';
Sleep (15);
For 50 (sleep) but did not work, I have to be deleting this file and restarting always, to finish?

Thank you!

sarkar 09-11-2008 01:09 AM

Quote:

Originally Posted by iPodHacking.com (Post 1619500)
Hey when i run the vbbot.php the first time i get this error"Warning: require_once(/includes/config.php) [function.require-once]: failed to open stream: No such file or directory in /home/mysite/public_html/bot/vbbot.php on line 28

Fatal error: require_once() [function.require]: Failed opening required '/includes/config.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/mysite/public_html/bot/vbbot.php on line 28"

And if i press refresh it says :Bot is running.
But it hasn't checked any links after running for 3 hours. So i think there might be an error

If its in the directory called exp use ./includes/config.php

Quote:

Originally Posted by FRANKTHETANK 2 (Post 1619506)
I keep getting this error when I run my sql queries.

Error

SQL query:

ALTER TABLE `thread` ADD `time_check` INT( 10 ) NOT NULL DEFAULT '0' AFTER `taglist`

MySQL said: Documentation
#1060 - Duplicate column name 'time_check'

Any Idea's

U have to do it once.

sarkar 09-11-2008 01:19 AM

Quote:

Originally Posted by iPodHacking.com (Post 1619420)
Also. Do i have to run the script manually to make it check the links. Or does it do it by its self?

You can set up a cron and make it run every xx hours or minutes

Quote:

Originally Posted by fordsho (Post 1619411)
OK question what is the best way to set the bot to run every 24hrs.

Im guessing Scheduled Task Manager and set one to run every 24hrs then one to delete every 23hrs sound good?

Use cron. Its ur call. It depends on ur board size and no of threads and posts to check. Our next version would have the product installer and so I think u can use the vB Task Manager then.

Quote:

Originally Posted by f4vn (Post 1619478)
What happen if my board's thousands of threads and ~10 links in each thread ... when you run this bot may be it become a DDoS tool :D

Password protect the directory where the bot lies.. somewhere likke inside admincp a directory called secretstuff :D and password protect it, so that no one else can misuse it.


All times are GMT. The time now is 06:20 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.01626 seconds
  • Memory Usage 1,834KB
  • 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
  • (2)bbcode_php_printable
  • (18)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