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 insertRoleAssignment($data) { return DBConn::insert("INSERT INTO " . DBConn::prefix() . "auth_lookup_group_role(`auth_group_id`, `auth_role_id`, `created_user_id`) " . "VALUES (:auth_group_id, :auth_role_id, :created_user_id)", $data); }
public static function insertQuestion($data) { return DBConn::insert("INSERT INTO " . DBConn::prefix() . "user_additional_info(user_id, question, answer) " . "VALUES (:user_id, :question, :answer);", $data); }
static function insertGroupAssignment($data) { return DBConn::insert("INSERT INTO " . DBConn::prefix() . "auth_lookup_user_group(`auth_group_id`, `user_id`, `created_user_id`) " . "VALUES (:auth_group_id, :user_id, :created_user_id);", $data); }
public static function insertVariable($validConfig) { return DBConn::insert("INSERT INTO " . DBConn::prefix() . "system_config(name, value, disabled, created_user_id, last_updated_by) " . "VALUES (:name, :value, :disabled, :created_user_id, :last_updated_by);", $validConfig); }
static function insertAction($validAction) { return DBConn::insert("INSERT INTO " . DBConn::prefix() . "logs_action_tracking(`ip_address`, `code`, `action`, `http_referer`, `created_user_id`) " . "VALUES (:ip_address, :code, :action, :http_referer, :created_user_id);", $validAction); }
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); }