1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

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

Discussion in 'Black Hat SEO' started by rnc505, Feb 28, 2011.

  1. rnc505

    rnc505 Regular Member

    Joined:
    Oct 28, 2008
    Messages:
    229
    Likes Received:
    109
    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
     
    • Thanks Thanks x 3
    Last edited: Feb 28, 2011
  2. rnc505

    rnc505 Regular Member

    Joined:
    Oct 28, 2008
    Messages:
    229
    Likes Received:
    109
    Any feedback?? -- sorry for the bump...
     
  3. artizhay

    artizhay BANNED BANNED

    Joined:
    Nov 21, 2010
    Messages:
    1,867
    Likes Received:
    1,335
    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.
     
    • Thanks Thanks x 1
  4. curious73

    curious73 Junior Member

    Joined:
    Jul 11, 2012
    Messages:
    121
    Likes Received:
    17
    Location:
    Birmingham, UK
    yeah, me too!

    thanks.
     
  5. asilent

    asilent Junior Member

    Joined:
    Jul 24, 2008
    Messages:
    100
    Likes Received:
    13
    Iframe idea is really great, thanks for sharing. I'll try to use it somewhere