Version: 4.0.138, by Omranic
Developer Last Online: Sep 2021
Category: Administrative and Maintenance Tools -
Version: 3.8.x
Rating:
Released: 01-02-2010
Last Update: 12-25-2011
Installs: 59
DB Changes Uses Plugins
Re-useable Code Additional Files Translations
No support by the author.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
!.................. Brought to you by PHP KingDom (www.phpkd.net) ..................!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please remember to click Mark as Installed if you use this product.
Support requests from members who have not marked this as installed will be considered low priority.
Name: PHPKD - vB Link Verifier Bot 'Lite' Version: 4.0.138
Description: This product extract sharing links (Rapidshare, Megaupload, Zshare, Adrive, Depositfiles, Filefactory, ...etc) from posts, then verifies them; If they're "Alive" the post will pass, otherwise the post will be punished (Fully Customizable).
Compatible with: All 3.8.x/4.0.x/4.1.x vBulletin versions.
Ability to check threads/posts in certain date range.
Ability to detect masked links even if it's recursively masked.
Doing all default vBulletin checks & vBulletin Fully Compatible.
Ability to check any of the following protocols (HTTP / HTTPS / FTP).
Board Load Zero Queries, queries executed only when the scheduled task run.
Ability to exclude threads/posts with certain modes from being checked [opened/closed/moderated/sticky/deleted].
Ability to scan links within all tags or within certain tags such as [ CODE ] & [ QIOTE ], and yes supports [ HIDE ] & [ CHARGE ].
The product has a cronjob (Scheduled Task) that run every day once (configured). If you run the cronjob from the AdminCP manually, you will get a nice report for the process instantly for your review.
The cronjob (scheduled Task) logs every run details in "Scheduled Task Log", so you can review it later.
Ability to follow redirected pages till reaching the actual download page & verify it.
The product's code base is very solid/rich which allows easy expansion.
Specific Features:-
AdminCP Options:
ON/OFF
Choose whether the product "PHPKD - Link Verifier Bot" is active or not (Global On/Off Switch).
Include/Exclude Users (Ultimate Edition Only)
You can specify certain users to check their posts against dead links, or to exclude others' posts from being checked at all.
You've three options to choose from:
Include All Users
Include Specific Users
Exclude Specific Users
Select "Include All Users" to check all users' posts, or select "Include Specific Users" to check only those specific users' posts -defined in the following setting-, or select "Exclude Specific Users" to check all users' posts except those specific users' posts -defined in the following setting-.
Included/Excluded Users (Ultimate Edition Only)
If you've chosen "Include Specific Users" OR "Exclude Specific Users" from the above setting, then you've to enter those specified user IDs here in this setting's field. Please enter user IDs separated with commas.
Include/Exclude User Groups (Ultimate Edition Only)
You can specify certain user groups to check their posts against dead links, or to exclude others' posts from being checked at all.
You've three options to choose from:
Include All User Groups
Include Specific User Groups
Exclude Specific User Groups
Select "Include All User Groups" to check all user groups' posts, or select "Include Specific User Groups" to check only those specific user groups' posts -defined in the following setting-, or select "Exclude Specific User Groups" to check all user groups' posts except those specific user groups' posts -defined in the following setting-.
Included/Excluded User Groups (Ultimate Edition Only)
If you've chosen "Include Specific User Groups" OR "Exclude Specific User Groups" from the above setting, then you've to choose those specified user groups from the list displayed. Please note that you can multiple select options by clicking "CTRL" key & keep holding it while selecting.
Include/Exclude Forums
You can specify certain forums to check their posts against dead links, or to exclude others' posts from being checked at all.
You've three options to choose from:
Include All Forums
Include Specific Forums
Exclude Specific Forums
Select "Include All Forums" to check all forums' posts, or select "Include Specific Forums" to check only those specific forums' posts -defined in the following setting-, or select "Exclude Specific Forums" to check all forums' posts except those specific user groups' posts -defined in the following setting-.
Included/Excluded Forums
If you've chosen "Include Specific Forums" OR "Exclude Specific Forums" from the above setting, then you've to choose those specified forums from the list displayed. Please note that you can multiple select options by clicking "CTRL" key & keep holding it while selecting.
Time/Date Cutoff Mode
You can force this product to process only posts in a specific time frame.
You've two modes to choose from:
Specific Date: This mode will check all posts posted after that specific date.
Last X Days: This mode will check all posts posted only in the last X days.
After choosing your preferred mode, you've to enter the appropriate value either it's for "Specific Date" OR "Last X Days" in the following setting.
If you don't wish to use the Cutoff feature then enter "0" in the following setting's field "Time/Date Cutoff Value".
Time/Date Cutoff Value
If you wish to force this product to process only posts in a specific time frame, then choose your preferred mode in the above setting, then enter the appropriate value here in this setting's field according to the following definition:
Specific Date: Enter a correct date in the format (yyyy-mm-dd) to check posts posted after it.
Last X Days: Enter a correct positive integer value for that period in days to check posts posted within last X days.
If you don't wish to use the Cutoff feature then enter "0" in this setting's field.
Checked Protocols (Ultimate Edition Only)
Which internet protocols do you wish to check? You've the ability to specify certain protocols to check it's links within posts.
HTTP
HTTPS
FTP
Checked BBCodes (Ultimate Edition Only)
You're caring which BBCodes should be scanned & which shouldn't!? You can check scanned/checked BBCodes from the list as you wish. Please note that URL tags are checked by default.
Basic BB Code
Color BB Code
Size BB Code
Font BB Code
Alignment BB Code
List BB Code
Link BB Code
Code BB Code
PHP BB Code
HTML BB Code
QUOTE BB Code
HIDE BB Code
CHARGE BB Code
'Lite' Version scans & check all default vBulletin BBCode Tags without the ability to select which should & which shouldn't be checked. It's also doesn't support [ HIDE ] & [ CHARGE ] Tags.
Excluded Thread Modes (Ultimate Edition Only)
You can exclude specific thread modes from being checked. By default all threads are being checked regardless of it's mode. To exclude any thread mode from being checked, just check it's check box & save your settings.
Opened
Closed
Moderated
Sticky
Deleted
Redirected
Excluded Post Modes (Ultimate Edition Only)
You can exclude specific post modes from being checked. By default all posts are being checked regardless of it's mode. To exclude any post mode from being checked, just check it's check box & save your settings.
Opened
Moderated
Deleted
Existing Posts: What to check?
Which posts do you wish to check against dead links? You can choose between checking "All Posts" or checking only "First Post from each thread".
Options: [None | All Posts (Thread's First Post + All Replies) | First Post Only (Only Thread's First Post)]
New Posts: What to check?
Which new posts do you wish to check against dead links? You can choose between checking "All New Posts" or checking only "New Threads" (thread's header, without replies).
Options: [None | All New Posts (Threads & Replies) | Only New Threads (Just Thread's Header/First Post)]
Edited Posts: What to check? (Ultimate Edition Only)
Which edited posts do you wish to check against dead links? You can choose between checking "All Edited Posts" or checking only "Edited Threads" (thread's header, without replies).
Options: [None | All Edited Posts (Threads & Replies) | Only Edited Threads (Just Thread's Header/First Post)]
Maximum Links to check per post
How many links do you wish to check per post? If any post contains more than that defined limit, then those 'over limit' links will be ignored & will not be checked; only the first X links (as defined here) will be checked against dead links. Enter "0" for UNLIMITED.
Critical Limit/Red Line
Checked posts may contain dead links, you can control when posts should be punished because of high percentage of dead links within it. Just enter the Red Line percentage here as a positive integer value (without any symbols). This critical Limit/Red Line is the maximum percentage that dead links can represent from all links available per post. Examples: If you enter "10", that means 10% only of dead links allowed per post (And 90% alive), if that post contains more than that percentage of dead links from all links, then it will be flagged; this way it can be punished by the way you specify in the settings below. If the post has less than 10% of dead links then it will pass as valid without punishment. Please note that "0" means that all links per post should be valid & alive (no dead links allowed, if just one link is dead the post will be flagged); While "100" means the opposite, it means that all links per post should be dead to be flagged, that means if there is only one link alive & the rest are dead, the post will pass as valid without punishment. Note Also: If any post has only 5 links within it to be checked, then that means each link represents 20% from the whole checked links. This means also if only one link is dead & you've set this setting to '10%' the expression will evaluate as true & will punish that post since it has 20% dead links.
Check Succession Period
You can determine the separating time period between successive checks for same posts, so those "checked recently" posts don't be checked every time the script runs. If you wish you can force posts to be checked multiple times, but with at least 1 day between each two successive checks. Enter how many days you wish to separate each two successive checks here, or enter "0" to disable this feature. Note: "7" means your posts will be checked every seven days, those checked posts will not be checked again before seven days has been passed from the last check, "0" means that checked posts will be checked just once. A Higher Value usually recommended specially for large boards.
Posts To Check in Each Batch
Commonly, it's recommended to set a specific number of posts to process in each turn to prevent any possible timeout or Memory/CPU exhausting during the execution process. A Lower Value usually recommended specially for boards that has long posts containing many links. There's other important factors that have strong affect also such as: "Time/Date Cutoff Mode" & "Time/Date Cutoff Value", "Existing Posts: Which posts to check?", "Maximum Links to check per post", "Check Succession Period"; So please take care & try to set a logical value for each of these settings/options or you may result in unexpected results; Such as checking only the first X number of posts in the forum & re-check them again without shifting to other posts. You're the one who knows your board & you're the one who can determine which suits you & your board according to your board's activity/content/requirements. Enter "0" for UNLIMITED!
Kill Link Masks (Ultimate Edition Only)
Links within posts may be masked & not direct links for real hosts, you've the ability to select which masks to kill & retrieve hidden/real hosts links. Check/Un-Check masks to be killed as preferred.
Anonym.to
Linkbucks.com
Lix.in
... AND COUNTING ...
Recusive Unmasking (Ultimate Edition Only)
Real links may be double or triple masked. This means, masked links may contain masked links within & so on till you reach the real link embedded in the deep. If you wish to detecet masks recursively till extracting the real link, just activate this option.
Unmasking recursion level (Ultimate Edition Only)
If you've activated "Recusive Unmasking", then you may wish to set recusive level. Just enter how many levels do you wish to go in the deep. Please note that '0' means UNLIMITED (NOT recommended).
Sending Reports To Staff
If you've chosen to send reports to staff as "PMs" or "Emails", then you've the ability to select which staff should receive these reports.
Options: [Send Reports To Moderators Only | Send Reports To Moderators & Administrators]
Staff Reports Mode (Ultimate Edition Only)
When do you wish to send staff reports? You've four options to choose from:
Always send (always send regardless there's checked/dead/punished posts or not)
Send Only If there's Checked posts (send only if there's checked posts, regardless there's dead/punished posts or not)
Send Only If there's Dead posts (send only if there's checked posts with dead links regardless it exceeds the critical limit or not (punished or not))
Send Only If there's Punished posts (send only if there's punished posts (checked, contains dead links and exceeds the critical limit))
Staff Reports
After each run of the script, it's possible to auto send the final report to staff using any of the following methods: (PM, Email, New Reply, New Thread).
User Reports
After each run of the script, if there is punished posts: it's possible to auto send a simple report to their owners using any of the following methods: (PM, Email) telling them that some of their posts has dead links.
Reports Handler Staff User
Reports (1. Sent as PMs to staff and/or to normal users, 2. Posted as replies or threads) upon script run needs a valid staff member username to use as a sender & poster for these reports. Please enter the valid specified staff username here in this setting's field. Note: If this username is invalid or doesn't has appropriate permissions, then all "PM/Reply/Thread Reports" will be terminated & will not function until it's corrected, only "Email Reports" will be functional -if enabled-.
Report Forum
If you've chosen to post reports as new threads, so you've to determine that forum from here.
Report Thread (Ultimate Edition Only)
If you've chosen to post reports as new replies, so you've to determine the specified thread's ID from here. Just enter a valid thread ID.
Punishment Method for Dead posts
You may want to punish posts that has dead links; If so, then choose which actions you wish to use as punishment for those dead posts.
Punishment Recycle Bin Forum
If you've chosen to punish dead posts by moving threads, so you've to determine "Recycle Bin Forum" from here. Those punished dead posts will be auto moved to this "Recycle Bin Forum".
On Edit: Revert Actions (Ultimate Edition Only)
If any of the punished dead posts has been edited, the product will re-check links within again (if this feature enabled), if it passed the check & doesn't reach the "Critical Limit/Red Line" then "Punishment Actions" can be reverted. This means if the recent punishment for a specific post was (Moving to the "Punishment Recycle Bin Forum" & Moderating Posts & Closing Thread), then after successful check the punishment will be taken off & the post/thread will be (Moved back to the original forum & Posts un-moderated "Approved" & Thread re-opened). Choose "Yes" to activate this behavior, or "No" to disable it.
Powerful User Groups
Powerful User Groups are those user groups that can override/overcome the "Critical Limit/Red Line" & force their posts to be posted despite of having dead links. Please enter User Group IDs separated by commas. Note: This powerful ability doesn't affect only posts for those powerful user groups, but affects also any posts edited by those powerful user groups (regardless of being for them or for other users). It means they can overcome limits when posting & when editing others posts (They should have permissions of course -ex: moderators, staff).
Link Status Colors (Ultimate Edition Only)
You can change link status colors from this setting, just enter the color's name (or hexadecimal code) for each link status as preferred.
Used Phrases
You've the ability to control/localize the content used in automated messages & reports sent to staff & users.
Turkish .. (by laztrix)
.. and counting!
Submit new translation & get free 'Ultimate' edition!
Installation Procedure:
Upload required files to their appropriate places:
includes
cron
phpkd_vblvb.php
functions_phpkd_vblvb.php
md5_sums_phpkd_vblvb.php
Import the product's XML file "product-phpkd_vblvb.xml" from AdminCP.
Configure product's settings.
[Optional] Translations: vBulletin AdminCP ? Languages & Phrases ? Download / Upload Languages ? Import Language XML File (Make sure that your forum's Character Set is equivalent to the imported language as follow):
Arabic ? ISO-8859-6
English, French, Spanish ? ISO-8859-1
Greek ? ISO-8859-7
Italian ? ISO-8859-16
Russian ? ISO-8859-5
Turkish ? ISO-8859-9
You can change language file's encoding before import to whatever encoding you wish/your forum works on (ex: UTF-8) using the wonderful applications "Encoding Master".
You're Done .
Upgrade Procedure:
Same as "Installation Procedure", but "Allow Overwrite" for both file uploads & product import.
Spreading the 'Lite' edition of this product product. Yes, you're free to re-distribute 'Lite' edition of this product as it is (See 'Free' license details).
Known Issues:
None!
History:
v3.8.100 01/01/2010 12:12 AM UTC: First 3.8.x release (public)
Flag declaration:
OK: means that there's no different between the old & the current version of this host's module. It was working fine & still working as it is.
Fixed: means that the previous version of that host's module had some problems & wasn't working good, but the new version has been fixed & confirmed to be working fine now.
Updated: means that the previous version of that host's module was good, but the current one has some tweaks & some optimizations.
Thats a nice Hack.. Thank You! I'll buy the Expanded Editon soon.
When i have more time, ill translate it to "German"
*Nominated*
But i have a Feature-Request.
1.) If it possible that check linkcrypter like linksave.in, linkcrypt.ws etc?
2.) Check FTP's for online and offline (or password is wrong) :P not for files only check if they online.
Hi there, this is fantastic. Just one thing. When I manually run the bot I get this database error:
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT user.username, user.usergroupid, user.email, user.languageid, post.userid, post.postid, post.threadid, post.dateline, post.title, post.pagetext, thread.forumid, thread.title AS threadtitle
FROM vbpost AS post
LEFT JOIN vbuser AS user ON (post.userid = user.userid)
LEFT JOIN vbthread AS thread ON (post.threadid = thread.threadid)
Where thread.open = 1
AND thread.visible = 1
AND post.visible = 1
-1728000
AND post.phpkd_vblvb_lastcheck < 1261972669LIMIT 100;
MySQL 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 '100' at line 9
Error Number : 1064
Request Date : Sunday, January 3rd 2010 @ 09:57:49 PM
Error Date : Sunday, January 3rd 2010 @ 09:57:49 PM
Script : http://www.creativx.net/forums/admin...cron&cronid=65
Referrer : http://www.creativx.net/forums/admin....php?do=modify
IP Address :
Username : TheBull
Classname : vB_Database
MySQL Version : 5.0.85-community
AND post.phpkd_vblvb_lastcheck < 1261972669LIMIT 100;
need a space between 1261972669 and LIMIT -->AND post.phpkd_vblvb_lastcheck < 1261972669 LIMIT 100;
you just find the slq command then add space between it
hope this help
AND post.phpkd_vblvb_lastcheck < 1261972669LIMIT 100;
need a space between 1261972669 and LIMIT -->AND post.phpkd_vblvb_lastcheck < 1261972669 LIMIT 100;
you just find the slq command then add space between it
hope this help
Sorry, I don't understand what you mean. Where do I find the sql command?
im getting an sql error
Database error in vBulletin 3.8.4:
Invalid SQL:
SELECT user.username, user.usergroupid, user.email, user.languageid, post.userid, post.postid, post.threadid, post.dateline, post.title, post.pagetext, thread.forumid, thread.title AS threadtitle
FROM post AS post
LEFT JOIN user AS user ON (post.userid = user.userid)
LEFT JOIN thread AS thread ON (post.threadid = thread.threadid)
Where thread.open = 1
AND thread.visible = 1
AND post.visible = 1
AND post.phpkd_vblvb_lastcheck < 1261978529LIMIT 5;
MySQL 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 '5' at line 9
Error Number : 1064
PHPKD - vB Link Verifier Bot Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
01-03-2010, 06:49 PM
