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