cron-check.php

#!/usr/bin/php
<?php
/*
    2014-07-22 : v1
    - check pendaftaran: udah 2hari tapi belum bayar
        * insert ke table users_delete
        * delete dari table users
        * entry ke table cron_log

*/
// mandatory utk php 4.5 and above
    date_default_timezone_set('Asia/Jakarta');

// config mysql
    define('DB_HOSTNAME', 'localhost');
    define('DB_USERNAME', 'blablabla');
    define('DB_PASSWORD', 'blublublu');
    define('DB_DATABASE', 'blebleble');

    $mysqlId = mysql_connect(DB_HOSTNAME,DB_USERNAME,DB_PASSWORD);
    mysql_select_db(DB_DATABASE,$mysqlId);
    mysql_query("SET time_zone = '+7:00'",$mysqlId);

// 2 hari yg lalu
    $tbatas = strtotime("-2 days");

// cek dulu ada gak?
    $query = "SELECT COUNT(*) FROM users WHERE (UNIX_TIMESTAMP(created)<'$tbatas' AND konfirmasi='0')";
    $result = mysql_query($query,$mysqlId);
    list($nrows) = mysql_fetch_row($result);
    mysql_free_result($result);

    if($nrows) {    // ada > 0
        // copy dulu ke table users_deleted
        $query = "INSERT INTO users_deleted
                SELECT * FROM users WHERE (UNIX_TIMESTAMP(created)<'$tbatas' AND konfirmasi='0')";
        mysql_query($query,$mysqlId);

        // delete dari table users
        $query = "DELETE FROM users WHERE (UNIX_TIMESTAMP(created)<'$tbatas' AND konfirmasi='0')";
        mysql_query($query,$mysqlId);

        // log
        $query = "INSERT INTO cronlog SET tanggal=NOW(), proses = 'DELETE $nrows Pendaftar'";
    } else {    // gk ada
        // log doank
        $query = "INSERT INTO cronlog SET tanggal=NOW(), proses = 'TIDAK ADA DELETE Pendaftar'";
    }

    mysql_query($query,$mysqlId);
    mysql_close($mysqlId);
?>