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; }