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