<?php require_once 'db.php';
 // функция вычисления ТИц с Яндекс.Бара
   function getCY($_url) {
        $_uri = "http://bar-navig.yandex.ru/u?ver=2&url=".urlencode("http://".$_url)."&show=1";
        $fd = @fopen($_uri, "r");
        if ($fd) {
         while ($buffer = fgets($fd, 4096)) $haystack.=$buffer;
            set_time_limit(180);
            fclose($fd);
            preg_match("/<tcy rang=\"(.*)\" value=\"(.*)\"\/>/isU",
            $haystack,$cy);
         return $cy[2];
      
        } else return 0;
   }


$sql = "SEL ECT url FR OM serp";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);

while ($myrow = mysql_fetch_array($result)) {
set_time_limit(180);

        preg_match_all('/url__item"(.*?)<\/a>/is', file_get_contents($myrow['url']), $link);
         
        
        for ($i = 1; $i != 10; $i++) {
            set_time_limit(180);
          //echo $lonk[0][$i] = substr($lonk[0][$i],9); //Debug
          echo strip_tags(substr($link[0][$i],11)).' - ';
          echo "Яндекс тиц: ".getCY(strip_tags(substr($link[0][$i],11)))."<br>";
          
          $sql = "INS ERT INTO IpBoard (domain,cy) 
                      VAL UES ('".strip_tags(substr($link[0][$i],11))."', '".getCY(strip_tags(substr($link[0][$i],11)))."')";
          mysql_query($sql);
        }
}
?>

<?php require_once 'db.php';
for ($i = 1 ; $i < 98 ; $i++) {
$query = "INS ERT INTO serp (url) VAL UES ('http://yandex.ru/yandsearch?p=$i&text=%D0%9F%D1%80%D0%BE%D1%81%D0%BC%D0%BE%D1%82%D1%80%D1%8B+%D0%BF%D1%80%D0%BE%D1%84%D0%B8%D0%BB%D1%8F+%D0%BE%D0%B1%D0%BD%D0%BE%D0%B2%D0%BB%D1%8F%D1%8E%D1%82%D1%81%D1%8F+%D0%BA%D0%B0%D0%B6%D0%B4%D1%8B%D0%B9+%D1%87%D0%B0%D1%81&lr=44')";
$insert = mysql_query($query);
}
?>