I made a linkchecker for phpbb3, and have made it work with myBB for someone, so i will share it.
Paste to linkchecker.php
http://paste2.org/p/603569
Edit lines 181-208 with your forum IDs you want to allow topics to be dumped from.
Then line 215 to match.
Edit 210, 219-222 with your forum Graveyard ID
Make sure bots can view any warez sections
Run the script using the url linkchecker.php?topic=1&limit=200
t= is starting topic & limit is how many topics to check after that in one go.
SQL Query
Paste to linkchecker.php
http://paste2.org/p/603569
Edit lines 181-208 with your forum IDs you want to allow topics to be dumped from.
Then line 215 to match.
Edit 210, 219-222 with your forum Graveyard ID
Make sure bots can view any warez sections
Run the script using the url linkchecker.php?topic=1&limit=200
t= is starting topic & limit is how many topics to check after that in one go.
SQL Query
Code:
CREATE TABLE IF NOT EXISTS `checked_topics` (
`id` int(9) unsigned NOT NULL auto_increment,
`topicid` varchar(255) default NULL,
`date` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`oldforumid` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=103796 ;