static function deleteRoleAssignment($data) { return DBConn::delete("DELETE FROM " . DBConn::prefix() . "auth_lookup_group_role " . "WHERE auth_group_id = :auth_group_id AND auth_role_id = :auth_role_id;", $data); }
static function deleteAuthToken($identifier) { return DBConn::delete('DELETE FROM ' . DBConn::prefix() . 'tokens_auth WHERE identifier = :identifier;', $identifier); }
static function deleteGroupAssignment($data) { return DBConn::delete("DELETE FROM " . DBConn::prefix() . "auth_lookup_user_group " . "WHERE user_id = :user_id AND auth_group_id = :auth_group_id;", $data); }
static function cleanLookupUserGroup() { return DBConn::delete("DELETE " . DBConn::prefix() . "auth_lookup_user_group FROM " . DBConn::prefix() . "auth_lookup_user_group " . "LEFT JOIN " . DBConn::prefix() . "auth_groups AS g ON auth_group_id = g.id " . "LEFT JOIN " . DBConn::prefix() . "auth_users AS u ON user_id = u.id " . "WHERE g.id IS NULL OR u.id IS NULL"); }
public static function deleteVariable($id) { return DBConn::delete("DELETE FROM " . DBConn::prefix() . "system_config WHERE id = :id AND locked != 1;", array(':id' => $id)); }
static function updateAcceptTeamInvite($validInvite) { DBConn::delete("DELETE FROM " . DBConn::prefix() . "team_members WHERE user_id = :user_id;", array(':user_id' => $validInvite[':user_id'])); DBConn::insert("INSERT INTO " . DBConn::prefix() . "team_members(user_id, team_id, added_by) " . "VALUES (:user_id, :team_id, :added_by);", array(':user_id' => $validInvite[':user_id'], ':team_id' => $validInvite[':team_id'], ':added_by' => $validInvite[':user_id'])); return DBConn::update("UPDATE " . DBConn::prefix() . "tokens_player_invites SET " . "response='accepted', last_visited=NOW() WHERE token = :token AND user_id = :user_id " . "AND team_id = :team_id AND expires > NOW() LIMIT 1;", $validInvite); }