vb Linkchecker Bot 1.1

[wtfsoccerdude]

I followed all the instructions but when I manually run the Schedules task of Link Checking I get the following error:

Warning: fopen(botruns.txt) [function.fopen]: failed to open stream: Permission denied in [path]/vbbot.php on line 25

Warning: fclose(): supplied argument is not a valid stream resource in [path]/vbbot.php on line 26

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'apache'@'localhost' (using password: NO) in [path]/vbbot.php on line 112
Unable to connect to mysql server.

What to do?

Also, one more thing that, I have added the auto-coder to my board. It automatically codes all the links so the [URL] tags in functions_newpost.php were replaced by [CODE] tags. Do I need to revert that change or it won't create any troubles?

[Dman91]

It is not able to connect to mysql, make sure it is in the root folder.
Also for the mod you added, it should not create any troubles but if it does, you can revert the change.

[deltrumweb]

I am getting this error at the header when I view a PM from the Bot:

Warning: Invalid argument supplied for foreach() in [path]/private.php on line 1523

Here are my user defined variables (I have edited out the domain for security) :

// Start of user defined variables
$trash = '37'; //Forum id of trash
$botid = '355'; //Userid of bot
$botname = 'LinkChecker Bot'; //Username of bot
$check = '`forumid` = 2 OR `forumid` = 3 OR `forumid` = 4 OR `forumid` = 5 OR `forumid` = 9 OR `forumid` = 21 OR `forumid` = 10'; //Forums to check
$pa = '
Links checked on ' . date('d/m/y'). ' by LinkChecker Bot'; //This will append this at the end of the checked post
$ppa = '<br /> Links checked on ' . date('d/m/y'). ' by LinkChecker Bot'; //VB uses a caching technique, this will append it to end of parsed post. This is HTML!
$perd = '75'; //Percent decision variable.
$tr = "More than $perd percent on the links are dead that is why the topic is moved to trash"; // This is the reply in the topic.
$pmt = 'Dead Links Removed !'; // PM Title
$reportforumid = '19'; //This is where bot will make new topics stating reports
$showurl = 'http://*******.com/showthread.php?t='; //Your URL
//Check Line 226 to edit PM message.
//End of user defined variables.

The bot is a member with ID: 355 however, when I go to view his profile, I can see it no problem. However, when I click his user name under one of his moved threads, it says:

This user has not registered and therefore does not have a profile to view.

I think this may be a code error ???? Someone please help !!!! lol

[wtfsoccerdude]

How to enter the forum id's??

Like this:

$check = '`forumid` = 2 OR `forumid` = 3'

OR

$check = '`forumid` = 2,3,4,5,6'

The bot is running but it doesn't check any links. It doesn't leave the link checked message on the posts and neither does it move to trash.

[dxflw]

i cant understand how to add time check via phpmyadmin and the rest i dont see any..vb_ on my phpmyadmin database...
i have edit the vbbot.php like this:
// Start of user defined variables
$trash = '135'; //Forum id of trash
$botid = '1'; //Userid of bot
$botname = '*****'; //Username of bot
$check = '`forumid` = 31'; //Forums to check
$pa = '
Links checked on ' . date('d/m/y'). ' by link checker bot'; //This will append this at the end of the checked post
$ppa = '<br /> Links checked on ' . date('d/m/y'). ' by link checker bot'; //VB uses a caching technique, this will append it to end of parsed post. This is HTML!
$perd = '75'; //Percent decision variable.
$tr = "More than $perd percent on the links are dead that is why the topic is moved to trash"; // This is the reply in the topic.
$pmt = 'I have moved your topic to trash'; // PM Title
$reportforumid = '5'; //This is where bot will make new topics stating reports
$showurl = 'http://*****.com/forum/showthread.php?t='; //Your URL

i have uploaded direct the php and i get this errors:

Warning: fopen(botruns.txt) [function.fopen]: failed to open stream: Permission denied in /home/*****/public_html/forum/vbbot.php on line 25

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

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

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/*****/public_html/forum/vbbot.php on line 129
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/*****/public_html/forum/vbbot.php on line 147

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

[howcome]

i pm'd my php have u taken a look?

[Dman91]

@deltrumweb - PM Error is a bug that needs to fixed. As for the user not found i think your the first one to get that. PM me your board url, with that problem.
@wtfsuccerdude - forum ids need to be entered like $check = '`forumid` = 2 OR `forumid` = 3'
@dxflw - open phpmyadmin and run those queries. for fopen error read the faq.
@homecome - pmed you back.

[Dman91]

https://vborg.vbsupport.ru/external/2008/11/29.jpg Thought would post screenshot of the new version

[Skavenger]

Good job!

[soundbarrierpro]

I'd like to use this because I have thousands of sendspace links on my site, but I'm afraid to be messing with phpmyadmin since I have a lot of customizations and add ons.

[howcome]

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 33292288 bytes) in /home2/name/public_html/siteurl/forums/folder/vbbot.php on line 76

[Dman91]

classic rapidshare error...
https://vborg.vbsupport.ru/showpost.php?p=1619720&postcount=85
Or wait for the new version i am implementing a new method to check rapidshare

[howcome]

is that two me?

[Dman91]

yes it is to you.

[howcome]

now i get
Using Method where time_check is 0
1879
the bot worked once upon a time now all these errors :(

[momo2]

looks great, how ever for my sites, we over 400,000 posts all with rapidshare links
this can handle that size b4 i install it ??

[howcome]

when is new version comin j/w?

[Nightcast]

Oh God yes I can't wait for the new version. Mine is still working great and i use it every day. Thanks again.

[Dman91]

@howcome good... now you know the topic id which is giving trouble
UPDATE `thread` SET `ignore_check` = 1 WHERE `threadid` = '1879'
run this query in phpmyadmin
and then undo the edits you did... and it should work...
@momo2 - I suggest you wait for next version.
New version will be out in 1 week max.

[soundbarrierpro]

Will you still have to mess with the tables in phpmyadmin with the new version?

[Skierpetros]

It stopped working suddenly and it stuck...this mean that is finish?

[howcome]

maybe i will just wait a week for new version

[Dman91]

@Skierpetros - What do you mean it stopped ?
I need beta testers for new version, anyone willing to help please PM me.

[howcome]

yea it fixed it for a lil bit then i get that memory error again i run the bot and it scans one post the max memory error

@Dman what do you require from beta testers?

[Dman91]

Testing all the features of the bot, if they work fine.

[soundbarrierpro]

Do you know if the table edits in phpmyadmin affect any other parts of the forum structure? My hand keeps on touching the cookies, but I keep pulling it out of the cookie jar. I really need a mod to check my links but I'm also really afraid of messing with the tables.

[3DPiMp]

it is working pretty well so far!!! I can't wait till it works PERFECTLY!!!

[wtfsoccerdude]

@wtfsuccerdude - forum ids need to be entered like $check = '`forumid` = 2 OR `forumid` = 3'


Here's what I have but still doesn't work. In cron tasks, it says running but, it doesn't post the link checked message or send a PM on dead links:

// Start of user defined variables
$trash = '81'; //Forum id of trash
$botid = '150'; //Userid of bot
$botname = 'NovaBot'; //Username of bot
$check = '`forumid` = 15 OR `forumid` = 67 OR `forumid` = 9 OR `forumid` = 72 OR `forumid` = 73 OR `forumid` = 11 OR `forumid` = 65 OR `forumid` = 12 OR `forumid` = 68 OR `forumid` = 13 OR `forumid` = 69 OR `forumid` = 16 OR `forumid` = 63 OR `forumid` = 70 OR `forumid` = 71 OR `forumid` = 52 OR `forumid` = 76 OR `forumid` = 24 OR `forumid` = 56 OR `forumid` = 54 OR `forumid` = 53 OR `forumid` = 2OR3 `forumid` = 55 OR `forumid` = 61 OR `forumid` = 42 OR `forumid` = 44 OR `forumid` = 45 OR `forumid` = 46 OR `forumid` = 48 OR `forumid` = 50'; //Forums to check
$pa = '
Links checked on ' . date('d/m/y'). ' by <font color="#B4045F"><b>NovaBot</b></font>.'; //This will append this at the end of the checked post
$ppa = '<br /> Links checked on ' . date('m/d/y'). ' by <b>NovaBot</b>.'; //VB uses a caching technique, this will append it to end of parsed post. This is HTML!
$perd = '87'; //Percent decision variable.
$tr = "More than $perd percent of the links are dead. The topic is NovaDump-ed."; // This is the reply in the topic.
$pmt = 'Your Topic has been NovaDump-ed!'; // PM Title
$reportforumid = '79'; //This is where bot will make new topics stating reports
$showurl = 'http://mysite.com/showthread.php?t='; //Your URL
//Check Line 226 to edit PM message.

*mysite is just to keep my site anonymous.

Also, I have the tfSEO installed, so will it interfere with this mod?

Thanks!

[Dman91]

Read this http://maxwcoders.com/forum/viewtopic.php?f=26&t=24

[kramxel13]

Very nice work :)

Its flawless

Would be nice to have it included in the ACP

Guess I will work on it

[Dman91]

I guess I will release the new version sometime today.

[hostmela]

is there any easy way to install bot??

[Dman91]

Wait for the next version.

[soundbarrierpro]

Wait for the next version.

Hi Dman, would that be the version you will be releasing today?:o

[mac-warez]

Yes it would be

[Dman91]

Yes, everything is ready except a readme.

[soundbarrierpro]

Is this the new package here for download? There is a readme it and it looks like the old download package. :confused:

[Dman91]

Its not released yet.

[howcome]

i cant wait

[Dman91]

Found a bug sorry for the delay guys, but release will have to wait until its fixed.
Edit : Screenshots of the new ACP
https://vborg.vbsupport.ru/external/2008/12/104.jpg
https://vborg.vbsupport.ru/external/2008/12/105.jpg
https://vborg.vbsupport.ru/external/2008/12/106.jpg

[soundbarrierpro]

Looks fantastic Dman, you've been doing alot of work:) Can't wait

[mac-warez]

hope it gets released soon

[ziko_583]

wow , it will be nice :D

[Nightcast]

I've been testing the new release and It has been running great so far. Although it could be just me because I have never had a problem with the old one. Either way I'm glad to be able to test it early.

[howcome]

when is this comin out?

[sarkar]

We would be informing all via Update once we get it ready.

[GhoHan]

LOL... This is a good idea :)

But something you must thinking first about your webhosting server.
how about if the hosting webserver can't access the link checker.
All of thread in forumid of check will be moved all to Forum id of trash?

[Dman91]

Unfortunately due to time constraints and my exams, I am not able to find the bug fix for the PM bug. Whenever bot tries to PM a certain member with PM disabled, or something similar, it returns a big error. So far only fix for it is, disable PM for that topic and run it again. Maybe after my exams, I can have a better look. Other than that, the new version is just fine :). @i-comers - Bot will probably timeout.

[sarkar]

Updated to version 1.1

Have a look at the main post.

Cheers

[Dman91]

Finally its out enjoy guys. :)

[crazyfalcon]

Looks great thank guys

[inder123]

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 1on query :SELECT `threadid` ,`firstpostid`, `forumid`, `replycount`, `title` FROM `thread` WHERE `time_check` = '0' AND `ignore_check` = '0' AND (`forumid` NOT IN ())

what i can do about this error and does this mod works with vbseo installed??

[soundbarrierpro]

Installed. Great mod. Registered at your site, just have one question regarding some "undead" mediafire links being binned as dead. Otherwise awesome job.

[Dman91]

@inder123 - Looks like you havent entered the forumids of the forums you dont want to check.
@soundbarrierpro - Replied there. :)

[howcome]

now if my thread got subforums but the name on the section is id 8 will it skip them all? or just skip 8

[Dman91]

It will just skip 8.

[x0r]

This is Great, thank you so mutch for working on this!

[bleros]

Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in [path]/bot.php on line 22

[sarkar]

@bleros:

Your host is running PHP Safe mode. Get it turned off.

[tommyturnage]

How often does it run the CRON and whats the name of it so maybe I can change the times it runs

[sunnylikbeckham]

A conflict was detected in the bitfields. You cannot continue with the installation of this product until this has been fixed. The conflicts found were:
Bitfield Collision: credits_cantearn = prefixrequired

[sunnylikbeckham]

sorry prob was on my other hack

[soundbarrierpro]

How and where do you setup a cron job?

[bleros]

@bleros:

Your host is running PHP Safe mode. Get it turned off.

For security reason must be ON SAFE Mode no OF :)

is nor my server in server must turn of safe mode no in host

[wtfsoccerdude]

I ran vbbot.php and after checking a few hundred links, I got this:

http://www.imageurlhost.com/images/6256jkziotqjz9lfm1wr.jpg

It's an error re-connecting to the DB. How to solve this?

[tommyturnage]

I found another bug with this Mod

If a megaupload link is "Temporarily Unavailable" it treats it as a DEAD link

This is a HUGE problem because megaupload tends to say that the link is "Temporarily Unavailable"

[skol]

I found another bug with this Mod

If a megaupload link is "Temporarily Unavailable" it treats it as a DEAD link

This is a HUGE problem because megaupload tends to say that the link is "Temporarily Unavailable"


And....

Nice One Guys..Stiill have a little problem with the pm...But bloody good work..well done..

[Dman91]

@wtfsoccerdude interesting... try this and report back
add
cc(FALSE, FALSE);
before $pmdm->save();
@soundbarrierpro - What is the control panel you use?
@bleros - Bot will timeout due to safe mode being on
@tommyturnage - try this code and report back array("megaupload\.com/([a-z]{2}\/)?\?d=", "(Filename:)|(All download slots assigned to your country)|(The file you are trying to access is temporarily unavailable)", "@\/([a-z]{2}\/)@i", "/en/"),
@skol - What problem? The one that is mentioned already? and thank you.

[soundbarrierpro]

Hi Dman- when you say control panel....do you mean vb ACP?

Just in case, I'm being proactive
Admin Control Panel (vBulletin 3.7.2 Patch Level 1)

Thank you for your awesome work.

[tommyturnage]

@tommyturnage - try this code and report back array("megaupload\.com/([a-z]{2}\/)?\?d=", "(Filename:)|(All download slots assigned to your country)|(The file you are trying to access is temporarily unavailable)", "@\/([a-z]{2}\/)@i", "/en/"),

Not to sound like a complete n00b but where do U put that code

[Dman91]

@soundbarrierpro - No the web hosting control panel.
@tommyturnage - in the file vbbot.php replace the current megaupload code with this.

[soundbarrierpro]

@soundbarrierpro - No the web hosting control panel.
@tommyturnage - in the file vbbot.php replace the current megaupload code with this.


? No idea. never been there. My whole site is vbulletin. Everything I need to do is through vb ACP.

[Dman91]

You will need to ask your host to enable cronjobs.

[skol]

? No idea. never been there. My whole site is vbulletin. Everything I need to do is through vb ACP.



Or try calling the bot manually as posted..I have a small board and works perfect for me..

Just had to select the forums for the bot..and not use the option for the whole site..

@dman i'm waiting for responce about the pm pretty sure it's down too me when testing..

[paketeto]

Does this bot works also with links in replies?

I made some tests, and it seems to only explore the links of the first post, ignoring links in replies.

If you create a topic without links, and then a reply with links, the bot dont see them.

Somebody noticed the same?

[tommyturnage]

That doesnt fix it

[furst]

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 's Finest'' at line 1on query :SELECT `username` FROM `vb_user` WHERE `username` = 'Antwerp's Finest'

What can I do to fix this error?

[tommyturnage]

Now its deleting all the Megaupload links. Even if they aren't dead

[mitch84]

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 's Finest'' at line 1on query :SELECT `username` FROM `vb_user` WHERE `username` = 'Antwerp's Finest'

What can I do to fix this error?same for me

[Dman91]

@skol - What is the problem again?
@paketeto - It only checks first post of the topic.
@tommyturnage - Check PM.
@furst - You have found another bug, thanks I will post fix in a moment.
Bug Fix :
Replace
$qu5 = cc($qu5, "SELECT `username` FROM `".$prefix."user` WHERE `username` = '$uname'");
by
$qu5 = cc($qu5, "SELECT `username` FROM `".$prefix."user` WHERE `username` = '".mysql_real_escape_string($uname)."'");

[Skavenger]

thanks for the new version!

Could you add an option to disable bot posts?

Other thing you could add is an option to add custom BBCodes to get removed so the bot can get the real link, some users use a download box or something like that to put all the links.
Also megaupload messages in all languages.

I'll be reporting if I find any bug.

thanks again!

[paketeto]

Thanks for replying, Dman.

Could you add the option for the bot to explore all replies in posts and not only the first one?

Thank you.

[furst]

Good hack, but still very rough around the edges. Hope to see an updated version soon.

Thank you for the hack.

[Dman91]

@Skavenger - Thanks for suggestions, I will look into them.
@paketeto - Not really, I have never looked forward to it.
@furst - You mean binning incorrectly? That is a very complicated issue, and needs your co-operation.
I have just found out that megaupload sometimes blocks your IP and sometimes instead of showing the link as alive, bot shows it as dead.

[tommyturnage]

You ever fix the problem I was having

[Dman91]

Not really, its megaupload blocking the IPs.

[dxflw]

Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in [path]/vbbot.php on line 22
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 1on query :SELECT `threadid` ,`firstpostid`, `forumid`, `replycount`, `title` FROM `thread` WHERE `time_check` = '0' AND `ignore_check` = '0' AND (`forumid` NOT IN ())

my board is 3.7.3

[Dman91]

For set_time_limit get safe mode disabled. For the second error, have you set the forums to want to check?

[howcome]

it scanning deposit files saying there dead when they're alive links and i got a question is there anyway to make a cron job to http://www.yoursite.com.com/vbbot.php?method=alleido that link?

[momo2]

I decided to install this, well i have over 90,000 posts all with rs or mu filefactory and i tell u in 45 mins it found over 12 pages of dead links :) it would have taking me for ever to test them
thanks i got few Questions ! the page vbbot.php i see unchecked ignore 1 day etc what are they for ???

[momo2]

humm it worked excellent, after 2 hours it stopped, why ? does need to be reset ?

[momo2]

ok few extra Q my forum has many sub forums, according to u this does not do the repeated numbers so if i have 30 forums and 100 subs this skips the repeated numbers ? that's going to be a problem each of my sections have like 20 subs

[soundbarrierpro]

humm it worked excellent, after 2 hours it stopped, why ? does need to be reset ?


It doesn't work all by itself. You have to setup automatically on your server with a thing called a cron job, or run it manually.

[momo2]

Well all i know i now have a clean forum, it found over 4000 dead links threads :)

Results stats in 9 hours work..

Threads: 52,068, Posts: 83,130, Members: 168,577

Threads: 48,488, Posts: 76,629, Members: 168,637

[Behzad Varedi]

Hello,

first, thank for this great mod.
when I import the xml and try to run "http://www.yourwebsite.com/vbbot.php (http://www.yourwebsite.com/member.php?u=2)" I get this error:
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 1on query :SELECT `threadid` ,`firstpostid`, `forumid`, `replycount`, `title` FROM `thread` WHERE `time_check` = '0' AND `ignore_check` = '0' AND (`forumid` IN ())
please tell me what should I do.
thanks

[Dman91]

@Behzad Varedi - Looks like a bug, many people are getting the same error, I will work on a fix asap.
@howcome - Please PM me the link where it does that.
@momo2 - Can you explain again?

[cabledr]

it seems to report rapidshare direct links dead ie ones that start rs182 any help ?

[andrewtr89]

Thing works better than good. Only problem is it has a problem with links coded like Click here to download (http://example.com/)

It seems to just count them all as dead.

[Dman91]

@Behzad Varedi - Its not a bug, you have not configured the bot lol.
@cabledr - If the rapidshare link checker regards a link as dead, so will the bot. Nevertheless, would you PM me an example link?
@andrewtr89 - This shouldn't be happening, PM me board url with MSN info etc.

[momo2]

@Behzad Varedi - Looks like a bug, many people are getting the same error, I will work on a fix asap.
@howcome - Please PM me the link where it does that.
@momo2 - Can you explain again?


well i been using it and now my forum is semi cleaned, how ever like i said b4, it does have a bug, I'm %100 sure of it, i can see some posts it say this posts has been checked by the linkchecker with the date, and most other ones do not have this, so that means it did not check them, I'm willing to pay for a pro version as my forum is all about links, and i must have a fully working functional hack like this !!! i know i have a large forum but i also have a super fast dedicated server, and yet when this thing running my forum lags big time !!! so i only install it when i want to run it !!!

[Cloud_Strife]

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 1on query :SELECT `threadid` ,`firstpostid`, `forumid`, `replycount`, `title` FROM `thread` WHERE `time_check` = '0' AND `ignore_check` = '0' AND (`forumid` NOT IN ())

What is this?

[Dman91]

@momo2 - It does not check all posts. It only checks the first post of the topic. Pro version doesn't exist, and I am not interested in developing it. The forum shouldn't be lagging especially when you say you have a super fast dedicated server as this doesn't use lot of resources.
@Cloud_Strife - You haven't configured the bot.

[joedirt]

i installed this and it does a good job it cleans the forum up good but there is only one thing i would like to know how to fix is when it checks a thread and if the link in that thread is good and it adds ( Links checked on 07/01/09 by link checker bot) it adds it right under the link is there any way to get it to move it down a line or two under the link and not right under the link on the next line

this is what i get now:

xxxx://rapidshare.xxx/files/62845153/xxxxxxxxxxxx_8.rar
Links checked on 07/01/09 by link checker bot

and this is what i would like for it to do:

xxxx://rapidshare.xxx/files/62845153/xxxxxxxxxxxx_8.rar

Links checked on 07/01/09 by link checker bot

thanks for all the help

[soundbarrierpro]

i installed this and it does a good job it cleans the forum up good but there is only one thing i would like to know how to fix is when it checks a thread and if the link in that thread is good and it adds ( Links checked on 07/01/09 by link checker bot) it adds it right under the link is there any way to get it to move it down a line or two under the link and not right under the link on the next line

this is what i get now:

xxxx://rapidshare.xxx/files/62845153/xxxxxxxxxxxx_8.rar
Links checked on 07/01/09 by link checker bot

and this is what i would like for it to do:

xxxx://rapidshare.xxx/files/62845153/xxxxxxxxxxxx_8.rar


Links checked on 07/01/09 by link checker bot


thanks for all the help


Where does it add that? I don't see that anywhere on mine.

[joedirt]

Where does it add that? I don't see that anywhere on mine.

i have found it on lots of threads the bot has checked im sure they are on your forum also

[LordNinja]

will this work with vbanonymizer?

thanks

[Dman91]

@joedirt - $pa = '
Links checked on ' . date('d/m/y'). ' by link checker bot';
$ppa = '<!--Botstart--><br /> Links checked on ' . date('d/m/y'). ' by link checker bot<!--Botend-->';
change this code to
$pa = '


Links checked on ' . date('d/m/y'). ' by link checker bot';
$ppa = '<!--Botstart--><br /><br /><br /> Links checked on ' . date('d/m/y'). ' by link checker bot<!--Botend-->';
@soundbarrierpro - In every topic bot checks, it adds this line.
@LordNinja - I'm not sure, sorry.

[soundbarrierpro]

@joedirt - $pa = '
Links checked on ' . date('d/m/y'). ' by link checker bot';
$ppa = '<!--Botstart--><br /> Links checked on ' . date('d/m/y'). ' by link checker bot<!--Botend-->';
change this code to
$pa = '


Links checked on ' . date('d/m/y'). ' by link checker bot';
$ppa = '<!--Botstart--><br /><br /><br /> Links checked on ' . date('d/m/y'). ' by link checker bot<!--Botend-->';
@soundbarrierpro - In every topic bot checks, it adds this line.
@LordNinja - I'm not sure, sorry.

Ha! I see now, I didn't realize this. Is there anyway for a <br/> and <b></b> to be added to the link check status?
<br/> to add a break between the last checked link that is.
Thanks, Love it

[howcome]

hey the new version don't check megashares? or my file is messed up???

[joedirt]

@joedirt - $pa = '
Links checked on ' . date('d/m/y'). ' by link checker bot';
$ppa = '<!--Botstart--><br /> Links checked on ' . date('d/m/y'). ' by link checker bot<!--Botend-->';
change this code to
$pa = '


Links checked on ' . date('d/m/y'). ' by link checker bot';
$ppa = '<!--Botstart--><br /><br /><br /> Links checked on ' . date('d/m/y'). ' by link checker bot<!--Botend-->';
@soundbarrierpro - In every topic bot checks, it adds this line.
@LordNinja - I'm not sure, sorry.

Thanks Dman91 that worked

links checked is now about 3 lines below the download link

[fahl]

Getting this error

Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'nobody'@'localhost' (using password: NO) in [path]/vbbot.php on line 120
Unable to connect to mysql server.

[KissOfDeath]

Is this compatible with 3.8?

i installed it on 3.7.4 where it was working great, but i made the mistake of setting the cron job up for http://www.mydomain.com/forums/vbbot.php so it only checked links once,

i then installed 3.8 and changed the cron job to http://www.mydomain.com/forums/vbbot.php?method=all

now i'm getting a problem where it's pm?ng the wrong users, and don't know if it because of an incompatibility issue with 3.8 or if i shouldn't have set the cron job up for http://www.mydomain.com/forums/vbbot.php?method=all ?

Any advice?

I have my own dedicated server and have set the cron job to run every 6 hours, this does not slow my board down at all end everything else works fine.

It is a bit annoying when the rapidshare servers go down like they did a few days ago and the link checker moves everything... but i don't think you can do anything about that can you?

[momo2]

i got a problem look below

Active : http://www.megaupload.com/?d=RJSKQOO6
Active : http://www.megaupload.com/?d=N5JYBU4E
Active : http://www.megaupload.com/?d=AJSKUSMB
Active : http://www.megaupload.com/?d=ORG6JN8C
Active : http://www.megaupload.com/?d=S3L3AXQ3
Active : http://www.megaupload.com/?d=BU7ZCSRR
Active : http://www.megaupload.com/?d=D12ERAG4
Active : http://www.megaupload.com/?d=BLDM6SBO
Active : http://www.megaupload.com/?d=SY5V5RR7
Active : http://www.megaupload.com/?d=SS96CHLO
Dead : http://www.megaupload.com/?d=S5V3035D
Active : http://www.megaupload.com/?d=A197JO9V
Active : http://www.megaupload.com/?d=8WM4VZ3G
Active : http://www.megaupload.com/?d=DPXI3T70
Active : http://www.megaupload.com/?d=SB22E5XY
Active : http://www.megaupload.com/?d=QOHAHFJE
Active : http://www.megaupload.com/?d=08HW4HUY
Active : http://www.megaupload.com/?d=8VQY5850
Active : http://www.megaupload.com/?d=OGEN88X6
Active : http://www.megaupload.com/?d=M21PBQVD
Active : http://www.megaupload.com/?d=ZKWCYV2I
Active : http://www.megaupload.com/?d=I7P316TE
Active : http://www.megaupload.com/?d=M9QYFAGD
Dead : http://www.megaupload.com/?d=ZEFGV3LY
Active : http://www.megaupload.com/?d=FLH0SL8H
Active : http://www.megaupload.com/?d=OFHQY903
Active : http://www.megaupload.com/?d=MBLJUTR1
Active : http://www.megaupload.com/?d=OOYPGHXS
Dead : http://www.megaupload.com/?d=O33VZ6A2
Active : http://www.megaupload.com/?d=UGUIL3DL
Active : http://www.megaupload.com/?d=BB516DTO
Active : http://www.megaupload.com/?d=3TMNPH1T
Dead : http://www.megaupload.com/?d=RC9Y0832
Active : http://www.megaupload.com/?d=I3QUK443
Active : http://www.megaupload.com/?d=SEDYJS7Z
Active : http://www.megaupload.com/?d=JMVGPYEF
Active : http://www.megaupload.com/?d=6MF8HJK7
Active : http://www.megaupload.com/?d=CW0QBML3
Active : http://www.megaupload.com/?d=OXQRRO68

but it should have trashed it, also i get lots of Post Reported: 3134
but the link for post reported its only a number rather than the thread link, so how i am suppose to check it ?

[momo2]

Its set at %75 but what good does it do, say if this a movie in 12 parts and one of them is dead. once 1 die the rests are useless !!! any ideas ???

[howcome]

Its set at %75 but what good does it do, say if this a movie in 12 parts and one of them is dead. once 1 die the rests are useless !!! any ideas ???

you can change the % of dead links in a post to what you want in your admin cp link checker options

[IIAnDoII]

I get this error can some one help

Warning: require_once(includes/config.php) [function.require-once]: failed to open stream: No such file or directory in /home/iiandoii/public_html/vbbot/vbbot.php on line 20

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

[JetHaCkR]

I get this error can some one help


You did not upload the files properly.

[IIAnDoII]

i dident know there was a wrong way to upload files (its just drag and drop into and FTP client)

Can you tell me the correct way ?

[Dman91]

Just a heads up, I am going to be away till March 20th. I won't be able to give support while I'm away.

[IIAnDoII]

dam can you just help me before you go please

[Vaupell]

The vB product can run these queries, and takes table prefix into account.

i do admin work on 6 different vb boards, ive seen the query area
but none of them allow me to run query's

agree with poster, i also use phpmyadmin,
dont know why it dosent work, but hay dont need it.:up:

[Tuga??]

Hi any help with this error ?

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT graveyard, graveyard_id, pmUID, pmUNA, acheck, alast, pmSub, pmMsg FROM dlc_config LIMIT 1;

MySQL Error : Table 'tugateaf_forum.dlc_config' doesn't exist
Error Number : 1146

[Slugger00001]

i do admin work on 6 different vb boards, ive seen the query area
but none of them allow me to run query's

agree with poster, i also use phpmyadmin,
dont know why it dosent work, but hay dont need it.:up:


in config.php you have to put your user id to allow yourself to run quarys from admincp

[Tuga??]

Onother error wen try to run query

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 'ALTER TABLE `thread` ADD `ignore_check` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER ' at line 2

[dxflw]

db error

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)

WHERE user.userid = 1797;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, February 16th 2009 @ 10:33:46 AM
Error Date : Monday, February 16th 2009 @ 10:37:55 AM
Script : http://******.net/forum/vbbot.php?method=all
Referrer : http://******.net/forum/vbbot.php
IP Address : 79.103.214.217
Username : ^^freakos^^
Classname : vB_Database
MySQL Version :

[IIAnDoII]

momo2 i have the same problem can any 1 help

http://g.imagehost.org/0219/Untitled-1.png

[Jibba Jabbas]

Great mod and apologies if already asked. But what I am curious about, is it possible to have the bot just make a new post saying that the link is dead rather than move the thread all together? Or better yet, not even make a post but just add at the bottom of the post "link checked [date] deleted" or "link checked [date] alive" ... That sort of thing?

Any help is greatly appreciated, thanks.

[Sup101]

This seems not to work with 3.8.1 it trashes every single thread... Plus tells me cURL is not working right...

[putergirl]

downloaded

[Shamil.]

Ive found a bug. But I cant seem to fix it.

When the bot reports a thread it doesn't set the thread to visible. Ive tried changing the SQL queries but they all seem to be ok.

I dont know what else to do. At the moment only admins can see the reports :(

[hscorp]

wow

the new version is better thanks

[dxflw]

Developer Last Online: Dec 2008:eek::confused::confused:

Ok installed unistalled and installed again.
I get this messafe:
Fatal error: Only variables can be passed by reference in /var/www/vhosts/********.com/httpdocs/forum/includes/class_bbcode.php(360) : eval()'d code on line 28

Thanks for the try

[IIAnDoII]

ye its a great mod if you can get it working, But there are so many members that have problems etc and theres just no support

[robbiefritz]

seems to work fine. testing on 3.8.1

[howcome]

i had 3.8.1 and it was running fine when i added the files for 3.8.1 pl1 i ran it walked away and it trashed every single thread and all of them were working

[Nightcast]

Hey, I just checking in saying my bot has been running fine on 3.8.1 but As my board keeps getting more and more posts per day I would like to set it to run once a day byitself.

How would I do that, I know it has something to do with cron job?

[laztrix]

When I run the plugin, it sends some alive topics to the trash can.Expecially a certant users topics which links are not death. Why would it do that?

[tommyturnage]

this deletes links that work

in my opinion this should be in the trash because i have been waiting sooo long for a WORKING link checker and still nothing

shame

[hscorp]

db error

Database error in vBulletin 3.7.3:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid)

WHERE user.userid = 1797;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Monday, February 16th 2009 @ 10:33:46 AM
Error Date : Monday, February 16th 2009 @ 10:37:55 AM
Script : http://******.net/forum/vbbot.php?method=all
Referrer : http://******.net/forum/vbbot.php
IP Address : 79.103.214.217
Username : ^^freakos^^
Classname : vB_Database
MySQL Version :
put this in the php.ini file on your host

max_allowed_packet = 2M
wait_timeout = 1800
connect_timeout = 10
query_cache = 2M
query_cache_limit = 2M

[IIAnDoII]

When I run the plugin, it sends some alive topics to the trash can.Expecially a certant users topics which links are not death. Why would it do that?

Set up a cron job in your cpanel

[Neo_obs]

Is there any way you can have it add an entry into the threadhistory so we know where it came from? And can it just move posts?

[rmxs]

Hello its possivble at report and at pm have THREAD NAME?and no just the link??

[Dman91]

Rapidshare has changed their checklinks.cgi page, so it will bin all the rapidshare links.

[Manoel J?nior]

This functionally with VBSEO??

[mobd3box]

^^ great

[zero5854]

yes can someone please tell us the new url for the bot right now in vbbot.php it is....

http://rapidshare.com/cgi-bin/checkfiles.cgi

They either changed that or the key words for a dead file that this bot uses.

EDIT: NVM thats not the problem. I checked the script of a updated link checker PHP and it uses that address as well so its gotta be something else.

I noticed hes missing a line here that SHOULD be for rapidshare.com he only has .de

$sites = array(
array("megaupload\.com/([a-z]{2}\/)?\?d=", "(Filename:)|(All download slots assigned to your country)", "@\/([a-z]{2}\/)@i", "/en/"),
array("rapidshare\.de\/files\/", "You want to download"),
array("filefactory\.com\/file\/", "(download link)|(Please try again later)"),
array("mediafire\.com\/?", "You requested", "@com\?@i", "com/download.php?"),
array("mediafire\.com\/\?sharekey", "Folder Name:"),
array("depositfiles\.com\/([a-z]{2}\/)?files\/", "File Name", "@(com\/files\/)|(com\/[a-z]{2}\/files\/)@i", "com/en/files/"),
array("sendspace\.com\/file\/", "The download link is located below.")
);

NEEEEEVVVVEEERRR MIND!

I am using this on vb 3.8.2 with NOOOOOOOOOO PROBLEMS! please check ur server settings and that u have the bot settings correct.

I have checked ALL the posts it has binned and it is correct everytime.

[zero5854]

@joedirt - $pa = '
Links checked on ' . date('d/m/y'). ' by link checker bot';
$ppa = '<!--Botstart--><br /> Links checked on ' . date('d/m/y'). ' by link checker bot<!--Botend-->';
change this code to
$pa = '


Links checked on ' . date('d/m/y'). ' by link checker bot';
$ppa = '<!--Botstart--><br /><br /><br /> Links checked on ' . date('d/m/y'). ' by link checker bot<!--Botend-->';
@soundbarrierpro - In every topic bot checks, it adds this line.
@LordNinja - I'm not sure, sorry.

Mine doesnt show at all even with the edit?
Using 3.8.2

NVM this worked but it also messed up my tables

[ACiD619]

Hey,

Not sure how to remove 1 line of this;
Links checked on 12/09/08 by: ****** Link Checker Bot
Links checked on 12/09/08 by: ****** Link Checker Bot

The bot works fine but it adds 2 links of
''Links Checked on [DATE] by: [NAME] Link Checker Bot. (As shown above).

Is it possible to do some ''tweaking'' to remove 1 line...?

Help would be appreciated. Ty.

[teedizz]

Dman, has this bot been fixed to be compatible with the new rapidshare layout? My forum has A LOT of rapidshare links so it would be useless for me to download and install this if that hasn't been corrected. Appreciate this hack homie, this is something that I've needed for a LONG time. Good lookin out.

[Dman91]

I'll probably update this. Till then use it on your OWN RISK. I will keep you guys posted.

[Skierpetros]

i take errors on 3.8

[GCSkye]

now i'm getting a problem where it's pm?ng the wrong users, and don't know if it because of an incompatibility issue with 3.8 or if i shouldn't have set the cron job up for http://www.mydomain.com/forums/vbbot.php?method=all ?


Seems to be working fine with 3.8.2. The only problem is concerning pms.

The problem seems to be coming from it trashing a thread. After it trashes a thread it sends the proper pm to the proper user. After that it will send the same pm to everyone with a dead thread in that session.

At least that is what I believe. Possible solution coming soon?

[BobbyT]

Tagged for future reference.

[Terminatoronly]

Hello,
thanks for your effort sarkar :), this is a lovely script that i really wanted.
i am getting an error when i am trying to run the vbbot file:
Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in [path]/vbbot.php on line 22
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 1on query :SELECT `threadid` ,`firstpostid`, `forumid`, `replycount`, `title` FROM `thread` WHERE `time_check` = '0' AND `ignore_check` = '0' AND (`forumid` NOT IN ())

but when i filled every option of this script on admincp and then run the vbbot i get this error:
Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in [path]/vbbot.php on line 22
Unchecked | Ignored | 1 Day | All except ignored | All | Debug Mode
Current Method : Checking unchecked topics

Please help

[Skierpetros]

Hello,
thanks for your effort sarkar :), this is a lovely script that i really wanted.
i am getting an error when i am trying to run the vbbot file:
Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in [path]/vbbot.php on line 22
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 1on query :SELECT `threadid` ,`firstpostid`, `forumid`, `replycount`, `title` FROM `thread` WHERE `time_check` = '0' AND `ignore_check` = '0' AND (`forumid` NOT IN ())

but when i filled every option of this script on admincp and then run the vbbot i get this error:
Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in [path]/vbbot.php on line 22
Unchecked | Ignored | 1 Day | All except ignored | All | Debug Mode
Current Method : Checking unchecked topics


Please help
which version you use 3.7.x or 3.8.x

[bleros]

Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in [path]/vbbot.php on line 22
Unchecked | Ignored | 1 Day | All except ignored | All | Debug Mode
Current Method : Checking unchecked topics

Fatal error: Call to undefined function curl_init() in /home/www/web1/html/vbbot.php on line 50

[Terminatoronly]

3.7.x thanks

[Terminatoronly]

which version you use 3.7.x or 3.8.x

3.7.x

[dancue]

A few questions I have for you:

If the link is within a code tags, will it be checked?
Should I be getting a note in the original post which states when the links were checked? I'm not getting any.

If the link is not parsed will it be checked?

The PM issue I'm receiving is with the threadid being the same one used for every PM.

[sargatanas]

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 1on query :SELECT `threadid` ,`firstpostid`, `forumid`, `replycount`, `title` FROM `thread` WHERE `time_check` = '0' AND `ignore_check` = '0' AND (`forumid` NOT IN ())

after i run the vbbot.php, please help'

[algert]

Does this work on 3.8.x??

[pierians]

After the bot checks some post this message appears:
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 'm the LC Bot.
Your topic has been moved to trash since the links in it we' at line 1on query :INSERT INTO `post` (`threadid` , `parentid` , `username` , `userid` , `dateline` , `pagetext`, `ipaddress` , `visible`) VALUES ('211' , '211' , 'LinkBot' , '3' , 1245658464 , '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 you intenet to upload it again please use the report button(when the upload is finished). If u suppose the I am wrong, don't PM me, but PM any of the staff members of the site.' , '127.0.0.1' , '1')

Does anybody know what's wrong?

[Kuimera]

After the bot checks some post this message appears:


Does anybody know what's wrong?


Same thing here...

[alloutvb]

hello ok i have a little prob here is mover all my Megaupload.com post to the trash how can i stop this did they change something? please let me know thanks

[sdfaheem]

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 1on query :SELECT `threadid` ,`firstpostid`, `forumid`, `replycount`, `title` FROM `thread` WHERE `time_check` = '0' AND `ignore_check` = '0' AND (`forumid` NOT IN ())

after i run the vbbot.php, please help'

I am also getting the same message and also the Link checker is not replying whether the link is dead or live even though i have created a separate user group for the bot and granted complete access to all the forums.

Could anyone please shed light on this issue???

[elenh]

For all the users who have installed this hack:

Disable the auto sending pm's.

They will work correct without that.
I think this hack is longer no supported... :S

[marshal_ramdev]

thanks

[MalakaiGonzalez]

It seams to work good for me, except for Megaupload & Mediafire links. It sends them to the trash when the links are alive...

Is there a way to remove them too file hosts from being checked (& moved).

[rmxs]

Hello how is possible to remove the message at every thread that display the scan Day?

deleting this helps?Links checked on ' . date('d/m/y'). '';
$ppa = '<!--Botstart--><br /> Links checked on ' . date('d/m/y'). '<!--Botend-->';

[opl]

Ok i am reading all and dont find , so:

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 1on query :SELECT `threadid` ,`firstpostid`, `forumid`, `replycount`, `title` FROM `thread` WHERE `time_check` = '0' AND `ignore_check` = '0' AND (`forumid` NOT IN ())



help?

[hardgeneration]

Fatal error: Call to a member function query_first_slave() on a non-object in /home/np16487/domains/my_forum/public_html/global.php on line 242

Anyone?

[oxblood12]

thanks

[oxblood12]

This application make me problems.

do not recognize the good links of megaupload and i get a message as if they were dead, despite than are good

[nyunyu]

Is this plugin still supported?
Any chance to see it on vb4?