function user_query_user_score($username, $mysqli)
{
$user = db_query_user($username, $mysqli);
if ($user != null) {
$user_id = $user["id"];
return db_query_user_score($user_id, $mysqli);
} else {
return null;
}
}
function db_insert_user_score($score, $mysqli)
{
// if user exists
if (db_query_user_score($score['user_id'], $mysqli) != null) {
return "Score_Exists";
}
$query = "INSERT INTO RushScore(`user_id`, `win`, `lose`, `spirit`, `max_spirit`) VALUES (?,?,?,?,?)";
if ($stmt = $mysqli->prepare($query)) {
//die("before");
$stmt->bind_param("iiiii", $score['user_id'], $score['win'], $score['lose'], $score['spirit'], $score['max_spirit']);
//die("OK");
if ($stmt->execute()) {
return "OK";
} else {
return "Database_Error";
}
} else {
return "Database_Query_Error";
}
}
