<?php
set_time_limit(0);
$dbhost = "localhost:3307";
$dbname = "cuck";
$dbuser = "root";
$dbpass = "usbw";
$connect = @mysql_connect($dbhost, $dbuser, $dbpass) or die (mysql_error());
@mysql_select_db($dbname) or die (mysql_error());
mysql_set_charset('utf8',$connect);
function curl_download($Url){
    $ch = curl_init();
    curl_setopt($ch, CURLOPT_URL, $Url);
    curl_setopt($ch, CURLOPT_REFERER, "http://www.example.org/yay.htm");
    curl_setopt($ch, CURLOPT_USERAGENT, "MozillaXYZ/1.0");
    curl_setopt($ch, CURLOPT_HEADER, 0);
    curl_setopt($ch, CURLOPT_RETURNTRANSFER, true);
    curl_setopt($ch, CURLOPT_TIMEOUT, 10);
    curl_setopt($ch, CURLOPT_VERBOSE, true);
    curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false);
    curl_setopt($ch, CURLOPT_CAINFO, 'cacert.pem');
    curl_setopt($ch, CURLOPT_COOKIE, "PHPSESSID=nafg3base9mdtvkju4vag6qmf1");
    $output = curl_exec($ch);
    curl_close($ch);
    return $output;
};
function normalizeString ($str = '')
{
    $str = strip_tags($str);
    $str = preg_replace('/[\r\n\t ]+/', ' ', $str);
    $str = preg_replace('/[\"\*\/\:\<\>\?\'\|]+/', ' ', $str);
    $str = strtolower($str);
    $str = html_entity_decode( $str, ENT_QUOTES, "utf-8" );
    $str = htmlentities($str, ENT_QUOTES, "utf-8");
    $str = preg_replace("/(&)([a-z])([a-z]+;)/i", '$2', $str);
    $str = str_replace(' ', '_', $str);
    $str = rawurlencode($str);
    $str = str_replace('%', '_', $str);
    return $str;
};
$query=mysql_query("SELECT * from video_url where (download is NULL || download='')  limit 1981");
while ($row=mysql_fetch_array($query)) {
    $explode_1=explode('type: "video/mp4",
                	src:  "',curl_download($row['url']));
    $explode_2=explode('"',$explode_1[1]);
    $explode_3=explode('<div class="avviso_vid">
<h1>',$explode_1[1]);
    $explode_4=explode("</h1>",$explode_3[1]);
    $file = $explode_2[0];
    $explode_5=explode('class="nicx">',$explode_3[1]);
    $explode_6=explode("</a>",$explode_5[1]);
    $nick=$explode_6[0];
    if($file=='' || $file==null || !isset($file) ) {}
    else {
        if($row['id']<10) {$numero='0000'.$row['id'];}
        else if($row['id']<100) {$numero='000'.$row['id'];}
        else if($row['id']<1000) {$numero='00'.$row['id'];}
        else if($row['id']<10000) {$numero='0'.$row['id'];}
        else if($row['id']<100000) {$numero=$row['id'];}
        if($explode_4[0]=='' || $explode_4[0]==null || !isset($explode_4[0])) {$explode_4[0]="Senza_Titolo";}
        if($explode_6[0]=='' || $explode_6[0]==null || !isset($explode_6[0])) {$explode_6[0]="Sconosciuto";}
        file_put_contents("/videos/" . $numero.'-'.normalizeString($explode_4[0]).'-'.normalizeString($explode_6[0]).".mp4", file_get_contents($file));
        mysql_query("UPDATE video_url SET download='1' WHERE id='".$row['id']."' ");
    }
}?>