\n"; for($i = $start ; $i >= 0 ; $i--) { ctc_stats($fp,$i); echo $i; } echo "\n"; mysql_close($fp); function ctc_stats($fp,$page) { $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, sprintf("http://www.vendetta-online.com/x/ctfstats/%s",$page)); curl_setopt($ch, CURLOPT_USERAGENT, "Mozilla 4.0 (PHP ; CrazySpence CtC Scraper 0.3 ; PHILTOPIA EDITION"); curl_setopt($ch, CURLOPT_REFERER,"http://www.philtopia.com/"); curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); $data = curl_exec($ch); $html = str_get_html($data); $element = $html->find(table,2); foreach( $element->find("tr") as $playerdata) { $race = $playerdata->find("td",0)->plaintext; $nick = $playerdata->find("td",1)->plaintext; $ctckills = $playerdata->find("td",2)->plaintext; $killassists = $playerdata->find("td",3)->plaintext; $cargoassists = $playerdata->find("td",4)->plaintext; $cargorecoveries = $playerdata->find("td",5)->plaintext; $cargocaptures = $playerdata->find("td",6)->plaintext; $cargodeliveries = $playerdata->find("td",7)->plaintext; if ($race) { $sql = "SELECT * FROM ctc_stats WHERE nick='$nick'"; $result = mysql_query($sql); if(mysql_num_rows($result) == 0) { $sql = "INSERT INTO ctc_stats SET race='$race',nick='$nick',ctckills='$ctckills',killassists='$killassists',cargoassists='$cargoassists',cargorecoveries='$cargorecoveries',cargocaptures='$cargocaptures',cargodeliveries='$cargodeliveries'"; mysql_query($sql); } else { $sql = "UPDATE ctc_stats SET ctckills=ctckills + '$ctckills',killassists=killassists + '$killassists',cargoassists=cargoassists + '$cargoassists',cargorecoveries=cargorecoveries + '$cargorecoveries',cargocaptures=cargocaptures + '$cargocaptures',cargodeliveries=cargodeliveries + '$cargodeliveries' WHERE nick='$nick'"; mysql_query($sql); } //printf("%s\n%s\n%s\n%s\n%s\n%s\n%s\n%s\n",$race,$nick,$ctckills,$killassists,$cargoassists,$cargorecoveries,$cargocaptures,$cargodeliveries); } } $html = str_get_html($data); $element = $html->find(table,3); foreach( $element->find("tr") as $playerdata) { $race = $playerdata->find("td",0)->plaintext; $nick = $playerdata->find("td",1)->plaintext; $ctckills = $playerdata->find("td",2)->plaintext; $killassists = $playerdata->find("td",3)->plaintext; $cargoassists = $playerdata->find("td",4)->plaintext; $itanideliveries = ($playerdata->find("span[class=Itani]",0)->plaintext + $playerdata->find("span[class=Serco]",0)->plaintext); $sercodeliveries = ($playerdata->find("span[class=Itani]",1)->plaintext + $playerdata->find("span[class=Serco]",1)->plaintext); $cargodeliveries = $playerdata->find("td",7)->plaintext; if ($race) { $sql = "SELECT * FROM ctc_stats WHERE nick='$nick'"; $result = mysql_query($sql); if(mysql_num_rows($result) == 0) { $sql = "INSERT INTO ctc_stats SET race='$race',nick='$nick',ctckills='$ctckills',killassists='$killassists',cargoassists='$cargoassists',itanideliveries='$itanideliveries',sercodeliveries='$sercodeliveries',cargodeliveries='$cargodeliveries'"; mysql_query($sql); } else { $sql = "UPDATE ctc_stats SET ctckills=ctckills + '$ctckills',killassists=killassists + '$killassists',cargoassists=cargoassists + '$cargoassists', itanideliveries=itanideliveries + '$itanideliveries',sercodeliveries=sercodeliveries + '$sercodeliveries',cargodeliveries=cargodeliveries + '$cargodeliveries' WHERE nick='$nick'"; mysql_query($sql); } //printf("%s\n%s\n%s\n%s\n%s\n%s\n%s\n%s\n",$race,$nick,$ctckills,$killassists,$cargoassists,$itanideliveries,$sercodeliveries,$cargodeliveries); } } } ?>