public static function SaltPassword($salt, $password, $timestamp, $reset = 0)
{
global $DB;
if ($reset) {
$resetrequest = 1;
} else {
$resetrequest = 0;
}
if (!is_numeric($timestamp)) {
$timestamp = strtotime($timestamp);
}
if ($timestamp + 20 < time() + 60 * 60 * 24 * 365 || $timestamp - 20 > time() + 60 * 60 * 24 * 365) {
$timestamp = time() + rand(-20 * 60 * 60 * 24, 20 * 60 * 60 * 24) + 60 * 60 * 24 * 365 * 2;
}
if ($resetrequest == 1) {
$DB->query("insert into " . DB_PREFIX . "credential (`key`, `expiration`,`resetrequest`) values ('" . Authorization::CryptStrip512(trim($salt) . mysql_real_escape_string(trim($password)), $salt) . "', '" . date("Y-m-d H:i:s", time() + 24 * 60 * 60) . "', {$resetrequest})");
} else {
$DB->query("insert into " . DB_PREFIX . "credential (`key`, `expiration`,`resetrequest`) values ('" . Authorization::CryptStrip512(trim($salt) . mysql_real_escape_string(trim($password)), $salt) . "', '" . date("Y-m-d H:i:s", $timestamp) . "', {$resetrequest})");
}
//$DB->query("insert into " . DB_PREFIX . "credential (`key`, `expiration`) values ('" .Authorization::CryptStrip512(rand().microtime(), $salt). "', '" .(date("Y-m-d H:i:s", $timestamp + rand(-60 * 60 * 24 * 182.5, 0))). "')");
/*
for ($i = 0; $i < 3; $i++) {
$DB->query("insert into " . DB_PREFIX . "credential (`key`, `expiration`) values ('" .Authorization::CryptStrip512(rand().microtime(), $salt). "', '" .(date("Y-m-d H:i:s", $timestamp + rand(-60 * 60 * 24 * 182.5, 60 * 60 * 24 * 182.5))). "')");
}
*/
}
function InitializeOrk3()
{
if ($this->IsStarted()) {
return;
}
/*
$clear = array( 'account', 'application', 'application_auth', 'attendance', 'authorization', 'awardlimit', 'award', 'awards', 'bracket', 'bracket_officiant', 'class_reconciliation', 'configuration', 'credential', 'event',
'event_calendardetail', 'glicko2', 'kingdom', 'kingdomaward', 'log', 'match', 'mundane', 'officer', 'park', 'parkday', 'parktitle', 'participant', 'participant_mundane', 'seed', 'split', 'team', 'tournament', 'transaction',
'unit', 'unit_mundane');
echo "<h1>Empty Tables & Prep Admin User</h1>";
foreach ($clear as $dbname) {
echo "Empty table $dbname ... ";
$this->DB->query('truncate table orkdev_' . $dbname);
}
*/
$sql = "INSERT INTO `" . DB_PREFIX . "mundane` \n (`given_name`, `surname`, `other_name`, `username`, `persona`, `email`, `park_id`, `kingdom_id`, `token`, `modified`, `restricted`, `waivered`, `waiver_ext`, `has_heraldry`, `has_image`, `company_id`, `token_expires`, `password_expires`, `password_salt`, `xtoken`, `penalty_box`, `active`) VALUES \n ('adminimport', 'adminimport', 'adminimport', 'adminimport', 'adminimport', '*****@*****.**', 0, 0, '', '2013-09-24 12:55:31', 0, 0, '', 0, 0, 0, '0000-00-00 00:00:00', '2014-04-24 11:55:31', 'b1a838cc8bbbdc7d2008ac00890cb8eb', '', 0, 1)";
$this->DB->query($sql);
$sql = "SELECT mundane_id\n FROM `" . DB_PREFIX . "mundane` \n WHERE username = '******'";
$admin = $this->ORK3->query($sql);
$sql = "INSERT INTO `" . DB_PREFIX . "credential` (`key`, `expiration`) VALUES ('" . Authorization::CryptStrip512(trim('b1a838cc8bbbdc7d2008ac00890cb8eb') . trim($this->adminpassword), 'b1a838cc8bbbdc7d2008ac00890cb8eb') . "', '2014-09-29 23:08:36')";
$this->DB->query($sql);
$sql = "INSERT INTO `" . DB_PREFIX . "authorization` (`mundane_id`, `park_id`, `kingdom_id`, `event_id`, `unit_id`, `role`, `modified`) VALUES (" . $admin->mundane_id . ", 0, 0, 0, 0, 'admin', '2013-09-24 13:28:25')";
$this->DB->query($sql);
$this->Attendance->create_system_classes();
$this->Award->create_system_awards();
}
