vb.org Archive - Administrative and Maintenance Tools

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)

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.

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

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

Bot in action
https://vborg.vbsupport.ru/external/2008/09/51.jpg
https://vborg.vbsupport.ru/external/2008/09/52.jpg
https://vborg.vbsupport.ru/external/2008/09/53.jpg

Script support on

Code:

www.maxwcoders.com

Read the glossary included in the RAR and ZIPs.

Get them at

Code:

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

LOL My buddy got this like 3 days ago and been working on this , Do you have Dman's permission to be posting this ???

wow... I'm not install yet, but the information very interesting . anyone try it yet?
thanks for share...

wow looks good thanks, book marked for later ;)

@bgbixt, yes i have Dman's permission to post this.

Thats cool , because I heard that this was supposed to be a private hack...

It was supposed to be a private hack, but got leaked somehow... Anyway i am also an admin on MaxWCoders to check :)

Thanks, I'm going to try this in a few days. It would be nice to have a product of this.

wow this is interesting i'm going to test this on my test forum..no one can ever get this stable.should be in beta

It is a stable mod and works fine on a live board.

Quote:

Originally Posted by sarkar (Post 1617953)

It is a stable mod and works fine on a live board.

i most say props to you:up: The only thing i encountered the pms, instead of generating one pm with the list of bad links its doing it one by one whcih i now have 20 pm's ..I guess something you can fix..

Quote:

First goto phpmyadmin and execute this queries:

ALTER TABLE `vb_thread` ADD `time_check` INT( 10 ) NOT NULL DEFAULT '0' AFTER `taglist` ;
ALTER TABLE `vb_thread` ADD `ignore_check` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `time_check` ;

Where vb_ is the forum table prefix.

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

Quote:

Originally Posted by sarkar (Post 1617940)

It was supposed to be a private hack, but got leaked somehow... Anyway i am also an admin on MaxWCoders to check :)

Somehow?

The only way I can see this being leaked is via another admin on that site or one of the developers (hired(?)) sharing it with friends. Time to revisit the admin list and rethink who you hire as a developer., I guess.

also found another issue in the pm when showing the bad links to the post the url to the post is broken for example : http://your_site.com82719/ thats how is showing in pm

About the PM thing i cant do anything you will have to survive it
And the URL in PM thing works fine...
$showurl = 'http://yourdomain.com/forum/showthread.php?t='; //Your URL url needs to be in this format
the variable $showurl needs to be in this format
There is a bug fix please update everyone..

Quote:

Originally Posted by sarkar (Post 1617973)

ok that worked...:up: dont know what happened! so far so good :)

Thanks, this is quite a good release as it does come in handy when you have many RS links on your site. Thanks.

few more things! sorry to be a pain but I'm helping you,This have potential.

1- the forum id for the trash post, i put the forum id # now everything goes to the post that i designated to.But if you in forum home, when i click on the post that was placed in the trash, it does not take me to theat post it takes me to another post other then the trash post.

2- report forum id, Id# chosen, but nothing is not going to that post at all..

pm is ok

-pb

Quote:

Originally Posted by Floris (Post 1617966)

Actually earlier it was a paid modification. So guy bought it and spread it all over. So we decided why does that guy get credit? We then released, both the versions i.e. vBulletin and IPB bots on our site and are working on SMF and MyBB.

That is how the bot got leaked.

can you please let me know how many query this hack used? thanks.

@puertoblack2003 i cant understand what are you talking about can you pm me the real urls and what you mean in pm ?
@rapidphim - This mod adds two columns to thread table.

sorry for being dumb, but I'd like to know how many query this hack uses and will it slow down the server while checking the assigned forum(s)? Sorry for asking this since I am on a shared host and chance of being suspended for CPU overload is really high.

It uses 6-7 queries i guess (estimate) and cpu load increases in average by 10-20%

darn, that's quite a bit of usage. I'd love to use this hack, but I have to pass it on :-(

Quote:

Originally Posted by sarkar (Post 1618022)

@puertoblack2003 i cant understand what are you talking about can you pm me the real urls and what you mean in pm.

it don't matter rather its here or pm, you still won't understand it. lets someone else tell ya...i wont put this on my live forum yet..

to all for i didn't notice any high queries it was fast and quick

Quote:

Originally Posted by puertoblack2003 (Post 1618264)

Ok thats ur call. Yeah sometimes it does come to high queries when it encounters many links in a topic (and especially when servers come up and down like rs did today)

I do not understand, I made the following settings, according to the settings of my Vbulletin:

Quote:

After doing this, I did this:

maxwcoders

Then start the script:

www.bestuniom.net/vbbot.php

And the following message appeared:

Quote:

Using Method where it seems that all topics have been checked.

And there appeared no message to boot on my Forum / topics. What do I do? It has more to do any setup?

Sorry for my English. I am Brazilian and I do not see much of the English language.

I wish it was easier to install and just went live with some default settings. I'm too lazy to do all that.

Quote:

Originally Posted by edermix (Post 1618604)

I do not understand, I made the following settings, according to the settings of my Vbulletin:

After doing this, I did this:

maxwcoders

Then start the script:

www.bestuniom.net/vbbot.php

And the following message appeared:

And there appeared no message to boot on my Forum / topics. What do I do? It has more to do any setup?

Sorry for my English. I am Brazilian and I do not see much of the English language.

just use this providing you not using any prefix

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

@edermix Did you run SQL Queries. Are you sure the forums to check you have entered are not categories ?
@pb - You mean reports are not working ? It will report a post only when less than $perd links are dead. And i will have a look at the trash thing you are telling today.

This is an excellent mod -works fantastic for a site like ours that has hundreds of external links!!!

Thank you so much - its working great :D:D:D

Glad i could help you to get it working :)

Cool...how can i add up to 10 forums for check?

Hi please can you help me with this i got this message when i ran the query

Code:

Error

SQL query: 



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







MySQL said:  



#1146 - Table 'my_forum1.vb_thread' doesn't exist

from where do i find to

change it to mach the prefix of your database tables.

thanks

Works good byt when i read PM from bot i saw this error on the top Warning: Invalid argument supplied for foreach() in [path]/private.php on line 1523

Quote:

Originally Posted by steve1966 (Post 1618911)

Hi please can you help me with this i got this message when i ran the query

Code:

Error

SQL query: 



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







MySQL said:  



#1146 - Table 'my_forum1.vb_thread' doesn't exist

from where do i find to

change it to mach the prefix of your database tables.

thanks

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.

Onother problem

Quote:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/rmxs/domains/rmxsmania.com/public_html/Vb/bot/bot.php on line 170
No Relevant Links Found : 13213

There is a link byt its not clickable (like in code)

Quote:

Originally Posted by rmxs (Post 1618904)

Cool...how can i add up to 10 forums for check?

Forums to check syntax
`forumid` = 2 OR `forumid` = 3 - This will check both forum id 2 and 3
`forumid` != 2 OR `forumid` != 3 - This will all forums EXCEPT forum id 2 and 3

Quote:

Originally Posted by rmxs (Post 1618947)

Onother problem

There is a link byt its not clickable (like in code)

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.

Quote:

Originally Posted by rmxs (Post 1618927)

Works good byt when i read PM from bot i saw this error on the top Warning: Invalid argument supplied for foreach() in [path]/private.php on line 1523

This error will be fixed in the next release.

I make a pitcure for this link checker :D

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01660 seconds Memory Usage 1,843KB 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 (4)bbcode_code_printable (15)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
Messages: