Need to quickly index *THOUSANDS* of profile links? Here's the quick and easy code..

rnc505

Regular Member
Joined
Oct 28, 2008
Messages
229
Reaction score
112
Hey guys,

I personally don't own xrumer so I tend to purchase a lot of $5 blast for fiverr (I get them from this guy - he does 5250 guaranteed profiles and I usually get 6k+ -- I'm not affiliated with him, so if you'd like his link see below - and he has a litterally 12 - 24 hour turn around... its awesome).
EDIT: Here's the guys link: link - and to prove he isn't me, my fiverr username is "rnc505" (like my BHW name lol)...

So I own Scrapebox, but the pinging tool thing is kinda topsy-turvy and I don't know if like its actually pinged.

So I wrote some PHP code that imports a .csv list (I import my .txt i get from the guy into excel and resave as .csv) into mySQL database, then randomly chooses a link from the database and then you can manipulate it as you wish (I like doing a 1x1 invisible pingomatic iframe).

So Here we go:

You must create a database. then you need to change the user, pass, dbname, table, and column name values below, which are in various colors.

connect.php:
Code:
<?php
$username = [COLOR="Cyan"]USERNAME[/COLOR];
$pass = [COLOR="DeepSkyBlue"]PASSWORD[/COLOR];
$dbname = [COLOR="Lime"]DATABASENAME[/COLOR];
session_start();

$db = mysql_connect("localhost", $username, $pass) or die("Could not connect.");

if(!$db) 

	die("no db");

if(!mysql_select_db($dbname,$db))

 	die("No database selected.");

?>

import.php:
Code:
<?php
//die("REMOVE THIS"); //--> get rid of the // in the front of die when you are done w/ script the script, but put them back when you want to use it again.
include "connect.php";

if(isset($_POST['submit']))

   {

     $filename=$_POST['filename'];

     $handle = fopen("$filename", "r");

     while (($data = fgetcsv($handle, 0, "\r")) !== FALSE)

     {
$array = array(); 
foreach( $data as $row ) {
    $array[] = '("'.mysql_real_escape_string($row).'")';
}
mysql_query('INSERT INTO [COLOR="Red"]*tablename*[/COLOR]([COLOR="Magenta"]*columnName*[/COLOR]) VALUES '.implode(',', $array));

    }

     fclose($handle);

     print "Import done";

 

   }

   else

   {

 

      print "<form action='import.php' method='post'>";

      print "Type file name to import:<br>";

      print "<input type='text' name='filename' size='20'><br>";

      print "<input type='submit' name='submit' value='submit'></form>";

   }
?>

rndm.php:
Code:
<?php
include "connect.php";

$row = mysql_fetch_row(mysql_query('SELECT [COLOR="DarkOrange"]*columnName*[/COLOR] FROM [COLOR="Plum"]*tablename*[/COLOR] ORDER BY Rand() LIMIT 1'));
$url = $row[0];

?>

kick.php:
Code:
<?php
include "rndm.php";
// $url

$Ping = "http://pingomatic.com/ping/?title=&blogurl=$url&rssurl=&chk_weblogscom=on&chk_blogs=on&chk_feedburner=on&chk_syndic8=on&chk_newsgator=on&chk_myyahoo=on&chk_pubsubcom=on&chk_blogdigger=on&chk_blogstreet=on&chk_weblogalot=on&chk_icerocket=on&chk_newsisfree=on&chk_topicexchange=on&chk_google=on&chk_tailrank=on&chk_postrank=on&chk_skygrid=on&chk_collecta=on&chk_superfeedr=on&chk_audioweblogs=on&chk_rubhub=on&chk_geourl=on&chk_a2b=on&chk_blogshares=on";


echo "<iframe src=\"$Ping\" />";

?>



You will also have to upload your .csv file to the same folder as all of these files. then to import the values, go to
Code:
http://YOURWEBSITE.com/import.php
. type in the name of your csv file.

I used a file with 12k rows of only 1 column (the url) and it literally did it in about .85 seconds and I'm on JustHost shared hosting. Most shared hosting have a 30 second time out, so with some testing, you'll probably find that you can use files that have like 100k+ entries at 1 time -- but I truly don't know, because I only had 1 12k file of links.

Then, once you've uploaded, remove the // in front of die in import.php so you or anyone else can mess up your DB.

Then, what I did was signed up for some auto traffic exchanges and made a page on my site with 3 - 5 iframes of kick.php and then put that page through the auto traffic exchange -- within a day or two most/all of your profile links (or otherwise) will be pretty much indexed -- depending on how many autotraffic creds you have.

You twist this in SOOO MANY ways also--

for example -- I also iframed my kick.php page on my high traffic blog so about 3 - 5k of the urls are pinged each day.

Get Creative and ENJOY!

Rnc505
 
Last edited:
Any feedback?? -- sorry for the bump...
 
First, thanks a ton for the Fiverr link. It's going to save me a ton of time.

The iframe pinging is also a great idea. I'm probably going to do something similar, except with cURL posting to Ping-o-matic.
 
First, thanks a ton for the Fiverr link. It's going to save me a ton of time.

The iframe pinging is also a great idea. I'm probably going to do something similar, except with cURL posting to Ping-o-matic.

yeah, me too!

thanks.
 
Iframe idea is really great, thanks for sharing. I'll try to use it somewhere
 
Back
Top