static function updateGroup($validGroup) { return DBConn::update("UPDATE " . DBConn::prefix() . "auth_groups SET `group`=:group, `slug`=:slug, `desc`=:desc, " . "`last_updated_by`=:last_updated_by WHERE `id`=:id;", $validGroup); }
static function updateRole($validRole) { return DBConn::update("UPDATE " . DBConn::prefix() . "auth_roles SET `role`=:role, `slug`=:slug, " . "`desc`=:desc, `last_updated_by`=:last_updated_by WHERE `id`=:id;", $validRole); }
static function updateAcceptSignupTeamInvite($validInvite) { 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', user_id = :user_id WHERE token = :token " . "AND team_id = :team_id AND response IS NULL AND expires >= NOW() LIMIT 1;", $validInvite); }
static function updateVisibilityElementInit($identifier) { return DBConn::update("UPDATE " . DBConn::prefix() . "auth_fields SET initialized=NOW(), last_updated_by=:last_updated_by " . "WHERE identifier=:identifier LIMIT 1;", $identifier); }
public static function saveTerms($data) { return DBConn::update("UPDATE " . DBConn::prefix() . "users SET accepted_terms = :accepted_terms " . "WHERE id = :user_id LIMIT 1;", $data); }
static function enableUser($userId) { return DBConn::update("UPDATE " . DBConn::prefix() . "users SET disabled=NULL WHERE id = :id AND disabled IS NOT NULL;", array(':id' => $userId)); }
public static function updateVariablePermissions($validConfig) { return DBConn::update("UPDATE " . DBConn::prefix() . "system_config SET last_updated_by=:last_updated_by, " . "indestructible=:indestructible, locked=:locked WHERE id=:id;", $validConfig); }
static function updateDeclineInvite($validInvite) { return DBConn::update("UPDATE " . DBConn::prefix() . "tokens_player_invites SET " . "response='declined', last_visited=NOW() WHERE token = :token AND user_id = :user_id " . "AND team_id = :team_id AND expires > NOW() LIMIT 1;", $validInvite); }