Administrative and Maintenance Tools - vb Linkchecker Bot 1.1

MaxWCoders present vB Link Checker Bot 1.1

===========
DESCRIPTION
===========

1) Checks Rapidshare.de , Rapidshare.com , Sendspace.com , Megaupload.com , Depositfiles.com and Mediafire.com links using cURL.
2) Works for post with all BBCodes.
3) Bins the post if more than specified percent of dead links are found , pms the user about it and posts in that topic
4) If all links are alive it adds specified message at the end of the post and the description.
5) If some links are live and some are dead i.e less than specified % , it makes a thread in a specified forum about it
6)Has a debug mode, to help you debug the errors.
7)Bot doesn't timeout due to MySQL timeout or PHP timeout.
8)It is a product, can be imported and settings can be changed easily.
9)Methods are accessible with keywords.

VBBot Installation How-To
=========================

1. Upload vbbot.php to your root folder where your VB installation is
Note : If you had older version of the bot, delete vbbot.php (or the folder) and replace it by new one.

2. Goto your ACP and go to 'Plugins & Products' and then click on 'Manage Products'

3. In the top box eneter the location of the product-link_bot.xml file on your computer
and then click the 'Import' button.

4. You have just installed the VB Link Checker bot.

5. If you had older version of the bot, delete vbbot.php (or the folder) and replace it by new one.


Setting up and configuring your VB Link Checker
===============================================

1. Create a new user that will be used for your Link Checker Bot. Make sure the bot has
the appropriate permissions for where it will be posting. (ie, VIP/Private forums)

2. Create the forums you will be using for good and bad links if you have not done so already.

3. Goto vBulletin Opions and select the MaxWCoders LinkChecker Bot.

4. All the options/setting are pretty self explanatory and each option has the description
of what the setting are for and do. Refer the the bottow of this Read Me of finding the
correct IDs you will need if you are not sure where to look.

5. Once you have everything set up hit the save button at the bottom.


Security
========
1. For security reasons, it is highly recommended you rename your bot to something else for instance 63454.php

Running your Link Checker Bot
=============================

1. You can run the bot by setting up a Cron job to run at a set time so you will not have to
run it manually. This can be found in your cPannel of your server.

2. You can call it manually by running vbbot.php (ie. http://www.siteurl.com/vbbot.php)

How to find all of your needed IDs.
===================================

How to find your forum ID:
Just goto the forum in question and the URL will look like the one below.

http://www.yourwebsite.com/forumdisplay.php?f=18 <--- The number at the end of the URL
will be the forum ID. In this example
it is 18.

---------------------------------------------------------------------------

How to find your user ID
Find the user that is going to be your bot and click on the user name.
Now look at the URL in the address bar. It should look something like the one below

http://www.yourwebsite.com/member.php?u=2 <--- The number at the end of the URL will be
the user ID. In this example the user ID
is 2.

================================================== ===================================






Bot in action




Script support on

www.maxwcoders.com

Read the glossary included in the RAR and ZIPs.

Get them at

http://www.maxwcoders.com/bots/downloads/vbbot11.rar

Changelog:
1.0 - 1.1 -> Bug fixes and Product installer

Bugs:

Unfortunately due to time constraints due to 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

[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) :

PHP Code:

// 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:

PHP Code:

// 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]

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.