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

[Vaupell]

Originally Posted by Floris

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]

Originally Posted by Vaupell

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

[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