Example #1
0
/**
 * Returns the directory based on subdomain.
 *
 * @return mixed
 */
function cronDir()
{
    return APP_PATH . 'views/cron/' . subdomain_as_directory() . '/';
}
Example #2
0
             $result->balanceDue = '0';
             $result->where('stuID = ?', $r['stuID'])->_and_()->where('termCode = ?', $r['termCode'])->update();
         } elseif ($r['Balance'] < 0) {
             $result = $app->db->stu_acct_bill();
             $result->balanceDue = '1';
             $result->where('stuID = ?', $r['stuID'])->_and_()->where('termCode = ?', $r['termCode'])->update();
         }
     }
 });
 $app->get('/runDBBackup/', function () {
     $dbhost = DB_HOST;
     $dbuser = DB_USER;
     $dbpass = DB_PASS;
     $dbname = DB_NAME;
     _mkdir('/tmp/' . subdomain_as_directory() . '/backups/');
     $backupDir = '/tmp/' . subdomain_as_directory() . '/backups/';
     $backupFile = $backupDir . $dbname . '-' . date("Y-m-d-H-i-s") . '.gz';
     if (!file_exists($backupFile)) {
         $command = "mysqldump --opt -h {$dbhost} -u {$dbuser} -p{$dbpass} {$dbname} | gzip > {$backupFile}";
         system($command);
     }
     $files = glob($backupDir . "*.gz");
     if (is_array($files)) {
         foreach ($files as $file) {
             if (is_file($file) && time() - filemtime($file) >= 20 * 24 * 3600) {
                 // 20 days
                 unlink($file);
             }
         }
     }
 });