Some help plz

[ClownZee]

Ok im making a online gaming clan site. and i need to get the ranks off of a site and put them on mine. I have found out how to pull the ranks but i dont know how to break them up then put them into a database. I have been trying for about a week and can't do it so if anyone can help i would really appreciate it. ill post the code i have and what the page looks like. Plz help.

<?php

$i = 1;

$myfile = 'http://e3.swirve.com/data/ranks.txt';
$command = "tac $myfile > /data/ranks.txt";
passthru($command);
$ic = 0;
$ic_max = 10; 
$handle = fopen("/data/ranks.txt", "r");
while (!feof($handle) && ++$ic<=$ic_max && $i<=10) {
   $buffer = fgets($handle, 4096);
      if (!feof($handle))
         {echo "$i."  ;
             ++$i;   

          echo $buffer."<br>";
         }
}

fclose($handle);

?>

this is how it shows up on a page http://darktao.com/ranks.php

1. 785 1st MKR Vol Cavalry (#785) 16045 6208217 MKR C 0
2. 798 Hunters Destroyer (#798) 13398 6058943 OoAoDToO T 0
3. 692 IRONtoTHEtop (#692) 11157 6036398 IRON C 0
4. 421 BattlestarPegasus (#421) 22829 6003698 RMortis C 0
5. 236 Neos Kraken (#236) 11367 5831627 XNEOFEDX C 0
6. 507 The Cults Days (#507) 12791 5826125 CultFist T 0
7. 406 Hermey the ELF (#406) 11333 5673002 ELF C 0
8. 78 my own empire (#78) 19782 5545837 RMortis C 0
9. 610 microsonic buMMies (#610) 12274 5503114 ROMExELY C 0
10. 109 Mz (#109) 13222 5442289 DepaRted C 0

But now i need to know how to some how break that up and import it into a database..... anyhelp will be great thank you!

[bradgrafelman]

Well... best I can offer is a regexp syntax (based on the sample data you've provided - it may not be exactly accurate to fit your needs as you may need to adjust what data is allowed for each "column") that would grab each piece of data separately. Inserting the columns in the proper order as well as verifying the integrity of the data/format (e.g. one line in the file isn't missing a column) is up to you.

Here's what I came up with:

$pattern = '/\s*([0-9]+) ([a-z0-9 ]+) (\(#[0-9]+\)) ([0-9]+) ([0-9]+) ([a-z0-9]+) ([a-z]) ([0-9])\s*/iU';
preg_match_all($pattern, $data, $matches);

Which would produce an array, $matches, that looks like:

Array
(
    [0] => Array
        (
            [0] =>  785 1st MKR Vol Cavalry (#785) 16045 6208217 MKR C 0
            [1] =>  798 Hunters Destroyer (#798) 13398 6058943 OoAoDToO T 0
            [2] =>  692 IRONtoTHEtop (#692) 11157 6036398 IRON C 0
            [3] =>  203 Springfield Foreverrr (#203) 7444 5999953 MKR R 0
            [4] =>  180 Beology (#180) 6750 5859246 Marines R 0
            [5] =>  236 Neos Kraken (#236) 11367 5831627 XNEOFEDX C 0
            [6] =>  421 BattlestarPegasus (#421) 22829 5777879 RMortis C 0
            [7] =>  507 The Cults Days (#507) 12791 5706689 CultFist T 0
            [8] =>  78 my own empire (#78) 19782 5545837 RMortis C 0
            [9] =>  610 microsonic buMMies (#610) 12274 5503114 ROMExELY C 0
        )

[1] => Array
    (
        [0] => 785
        [1] => 798
        [2] => 692
        [3] => 203
        [4] => 180
        [5] => 236
        [6] => 421
        [7] => 507
        [8] => 78
        [9] => 610
    )

[2] => Array
    (
        [0] => 1st MKR Vol Cavalry
        [1] => Hunters Destroyer
        [2] => IRONtoTHEtop
        [3] => Springfield Foreverrr
        [4] => Beology
        [5] => Neos Kraken
        [6] => BattlestarPegasus
        [7] => The Cults Days
        [8] => my own empire
        [9] => microsonic buMMies
    )

[3] => Array
    (
        [0] => (#785)
        [1] => (#798)
        [2] => (#692)
        [3] => (#203)
        [4] => (#180)
        [5] => (#236)
        [6] => (#421)
        [7] => (#507)
        [8] => (#78)
        [9] => (#610)
    )

[4] => Array
    (
        [0] => 16045
        [1] => 13398
        [2] => 11157
        [3] => 7444
        [4] => 6750
        [5] => 11367
        [6] => 22829
        [7] => 12791
        [8] => 19782
        [9] => 12274
    )

[5] => Array
    (
        [0] => 6208217
        [1] => 6058943
        [2] => 6036398
        [3] => 5999953
        [4] => 5859246
        [5] => 5831627
        [6] => 5777879
        [7] => 5706689
        [8] => 5545837
        [9] => 5503114
    )

[6] => Array
    (
        [0] => MKR
        [1] => OoAoDToO
        [2] => IRON
        [3] => MKR
        [4] => Marines
        [5] => XNEOFEDX
        [6] => RMortis
        [7] => CultFist
        [8] => RMortis
        [9] => ROMExELY
    )

[7] => Array
    (
        [0] => C
        [1] => T
        [2] => C
        [3] => R
        [4] => R
        [5] => C
        [6] => C
        [7] => T
        [8] => C
        [9] => C
    )

[8] => Array
    (
        [0] => 0
        [1] => 0
        [2] => 0
        [3] => 0
        [4] => 0
        [5] => 0
        [6] => 0
        [7] => 0
        [8] => 0
        [9] => 0
    )

)

assuming that you read the entire contents of the file (e.g. using a function such as [man]file_get_contents/man) into a variable called $data.

[minifairy]

oops