As a result of a number of requests from my own clients and Xrumer users rightfully complaining how their databases are full of “crap” links (false positives), I decided to put up this tutorial, which I believe has been long overdue in the Xrumer community.
For you to make the most out of this tutorial, you will not need a large AI file, custom captchas, or even mods to the XURL and XMessages files (although if you want to be able to post to more unspammed forums, this is the area that you want to look into).
Anyhow, you will still be able to build a highly optimized database that should provide you with an over 40% actual success rate with a default Xrumer configuration.
—————–
With all your harvested databases, first blast your project with the entire database. We’re going to be using the resulting success.txt to build you a new optimized database from the original one. You don’t want to use this unoptimized database each and every time for all your projects, you’re just going to end up wasting server time and bandwidth.
Note that you can also follow the below tutorial to build an optimized database just for profile posting (imagine a 30 K database of profiles, with 20 K actual successful profiles being created each time).
(I wrote this tutorial around 6 am today, so there may be mistakes or things I left out. If you find this to be true, please let me know.)
———————————————–
Ok enough chit chat, let’s start this thing!!
Step 1:
To begin: go to Tools + Link Database Filter
Once it loads up, uncheck “use filter”
Next in Src database: this is the success.txt file created from your recent blast, which you want to use to clean up the database/optimize it. So find the success.txt and load it up.
Res. Database: leave this as it is
Then in the “filter words” section: you’re going to run a bunch of words against the success.txt file, so the resulting file will contain only the “actual” successful submissions. Some of the words you’re going to use to filter the database are the below:
showtopic.php
viewtopic.php
showthread.php
profile.php
viewprofile
member.php
u=
etc. Go through your success list and mark which URLs are actual success rates and not false positives, then notice that these URLs have a “footprint”, like “showtopic.php”. You’ll notice that most of the URLS actually have a successful post. (If you’ve modified xrumer’s internal files, you will likely have more footprints to filter the database against)
Next, type in each of the words, one by one, enable the option “remain, remove others”, and choose “only links” from the dropdown box (search scope) then hit: “start”.
So the first run you’re going to go after “showtopic.php”, then the next run, you’re going to go after “viewtopic.php”, then hit start again, etc, etc.
Step 2:
After your done filtering against these words, run the resultant database (e.g. LinksList id1_res.txt) against the duplicate removal tool, this will get rid of the dupes and make sure your database is 100% unique.
Next load up Link Database Filter tool again.
This time make the following changes:
Src Database: the database you used to run the blast
Filter: the resultant database from the previous step (where you filtered against the footprints – LinksList id1_res.txt)
Res. Database: leave this as it is
Enable “are present in the filter database”
Keep the “options” section as it is, you don’t need to touch it.
Then hit “start”.
Next run the duplicate removal tool on this new database.
The final resultant database will contain only the successful links and will be ready to use.
Use this method with all your harvested databases. Have one “master database”, which you will add all your final resultant databases to this one database, so over time you’ll have a highly optimized and successful list of links you can use on all your sites.







