<? include_once($_SERVER['DOCUMENT_ROOT'] . '/xtracks-app/bootstrap.php');

// Execute crons.
globalCronRun();

function globalCronRun()
{
    $dbs = db::getRows('SHOW DATABASES');

    foreach($dbs as $db)
    {
        $db_name = $db['Database'];

        if (preg_match('/^prosper_(.+)/', $db_name, $match)) {
            if ($match[1] == 'master') {
                continue;
            } else {
                // Run client jobs.
                clientCronRun($db_name);
            }
        }
    }
}

function clientCronRun($db)
{
    //heres the psuedo cronjobs
    if (Run1MinCronjob($db) == true) {
        if (RunHourlyCronJob($db) == true) {
            RunDailyCronjob($db);
        }
    }
}

function RunDailyCronjob($db)
{
    //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 $db.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 $db.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 $db.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 $db.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 $db.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($db) {
//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 $db.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($db)
{
    //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 $db.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 $db.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 $db.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
		$delayed_sql = "DELETE FROM $db.202_delayed_sqls WHERE delayed_time <=".time();
		$delayed_result = _mysql_query($delayed_sql);


		return true;
	}  else {
		return false;
	}
}