$signinEmail = cleanValue($_POST['signinEmail']);
$signinPassword = cleanValue($_POST['signinPassword']);
// lookup database record
$signinAccountSQL = "SELECT `hash`,`email`,`id`,`permissions` FROM {$tbName} WHERE `email` = '{$signinEmail}'";
$result = $conn->query($signinAccountSQL);
// results from databse
if ($result->num_rows > 0) {
while ($user = $result->fetch_assoc()) {
if (password_verify($signinPassword, $user["hash"]) && $user["email"] == $signinEmail) {
$arr = array('status' => 'success', 'user_data' => array('id' => $user["id"], 'email' => $signinEmail, 'permissions' => $user["permissions"]), 'message' => 'You have successfully signed in', 'timestamp' => $date);
createJSON($arr);
} else {
$arr = array('status' => 'failure', 'user_data' => array('email' => $signinEmail), 'message' => 'There was an error', 'timestamp' => $date);
createJSON($arr, true);
}
}
} else {
$arr = array('status' => 'no record', 'user_data' => array('email' => $signinEmail), 'message' => 'This account does not exist', 'timestamp' => $date);
createJSON($arr, true);
}
}
if (isset($_POST['startSession'])) {
session_start();
$_SESSION['active'] = true;
$_SESSION['user'] = $_POST['sessionUser'];
$arr = array('sessionActive' => $_SESSION['active'], 'sessionUser' => $_SESSION['user']);
createJSON($arr);
}
// close database connection & clear form data
$conn->close();
unset($_POST);
function build_ribbonJSON()
{
global $wpdb;
require_once TEMPLATEPATH . '/partials/ribbonJSON.php';
$yearSql = $wpdb->get_results("SELECT distinct(year) FROM wp_mf_ribbons where entry_id > 0 order by year desc");
foreach ($yearSql as $year) {
$json = createJSON($year->year);
//write json file
unlink(TEMPLATEPATH . '/partials/data/' . $year->year . 'ribbonData.json');
//delete json file if exists
$fp = fopen(TEMPLATEPATH . '/partials/data/' . $year->year . 'ribbonData.json', 'w');
//create json file
fwrite($fp, $json);
fclose($fp);
}
}
