public static function authenticateGameEditor($pack)
{
if (!users::authenticateUser($pack)) {
return false;
}
if (dbconnection::queryObject("SELECT * FROM user_games WHERE user_id = '{$pack->user_id}' AND game_id = '{$pack->game_id}'")) {
return true;
}
util::errorLog("Failed Game Editor Authentication!");
return false;
}
public static function authenticateUser($pack)
{
$userId = addslashes($pack->user_id);
$permission = addslashes($pack->permission);
$key = addslashes($pack->key);
$user = dbconnection::queryObject("SELECT * FROM users WHERE user_id = '{$userId}' LIMIT 1");
if ($user && $user->{$permission . "_key"} == $key) {
return true;
}
util::errorLog("Failed Editor Authentication!");
return false;
}
protected static function queryArrayAssoc($query, $debug = false)
{
if ($debug) {
echo $query;
}
if (!($sql_data = mysqli_query(dbconnection::$con, $query))) {
util::errorLog(mysqli_error(dbconnection::$con));
return false;
}
$ret = array();
while ($o = mysqli_fetch_array($sql_data, MYSQLI_ASSOC)) {
$ret[] = $o;
}
return $ret;
}
