<?php
$host = "";
$from_db = "";
$from_user = "";
$from_pass = "";

$db1 = mysql_connect($host, $from_user, $from_pass);
mysql_select_db($from_db, $db1) || die ("Database is not selected.". mysql_error());

$PageSize = 3000;

$query = "SELECT MIN(card_sent_id) as min, MAX(card_sent_id) as max FROM card_sent_archive";
$result = mysql_query($query, $db1);
$rs = mysql_fetch_assoc($result);
$min = $rs["min"];
$curent_max = $min + $PageSize;
$max = $rs["max"];

$end = 0;
$i=1;

while (!$end) {
    $result=mysql_query("SELECT card_sent_id FROM card_sent_archive
                            WHERE card_sent_id BETWEEN $min AND $curent_max
                            AND sent>0
                            AND blocked='no'
                            AND sent_time<DATE_SUB(NOW(),INTERVAL 31 DAY)
                            ");
    while ($ecard=mysql_fetch_array($result)) {
        $card_sent_id=$ecard['card_sent_id'];
        $dummy=mysql_query("REPLACE DELAYED INTO card_sent_address_archieve
                                                SELECT * FROM card_sent_address_archive WHERE card_sent_id=$card_sent_id");
        if (mysql_affected_rows()>0) {
            $dummy=mysql_query("REPLACE DELAYED INTO card_sent_archieve
                                                SELECT * FROM card_sent_archive WHERE card_sent_id=$card_sent_id");
        }
        $dummy=mysql_query("DELETE FROM card_sent_archive WHERE card_sent_id=$card_sent_id");
        $dummy=mysql_query("DELETE FROM card_sent_address_archive WHERE card_sent_id=$card_sent_id");
        //echo " $card_sent_id";
    }
    //echo "\n\n";


    $min = $min + $PageSize;
    $curent_max = $min + $PageSize;

    echo ($i * $PageSize)."\n";
    //usleep(10000);
    $i++;

    if ($min >= intval($max)){
    //if ($i * $PageSize > 10000){
        $end = 1;
    }
    //$end = 1;
}
?>