private static function selectEmailTemplate($templateId) { $template = DBConn::selectOne("SELECT id, identifier, from_email AS fromEmail, from_name AS fromName, " . "reply_email AS replyEmail, reply_name AS replyName, subject, body_html AS bodyHtml, body_plain AS bodyPlain " . "FROM " . DBConn::prefix() . "email_templates WHERE identifier = :identifier LIMIT 1;", array(':identifier' => $templateId)); if (!$template) { self::logMailError(LOG_ERR, "ERROR RETRIEVING EMAIL TEMPLATE, templateId <{$templateId}>"); return false; } return $template; }
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 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); }
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); }
public static function saveTerms($data) { return DBConn::update("UPDATE " . DBConn::prefix() . "users SET accepted_terms = :accepted_terms " . "WHERE id = :user_id LIMIT 1;", $data); }
public static function userTableTestVal() { return DBConn::selectOne("SELECT u.id FROM " . DBConn::prefix() . "users AS u LIMIT 1;"); }
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"); }
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); }
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 selectStoreTags() { return DBConn::selectAll("SELECT t.id, t.tag, t.identifier, t.description, t.created, t.last_updated AS lastUpdated, " . "CONCAT(u1.name_first, ' ', u1.name_last) AS createdBy, CONCAT(u2.name_first, ' ', u2.name_last) AS updatedBy " . "FROM " . DBConn::prefix() . "store_tags AS t " . "JOIN " . DBConn::prefix() . "users AS u1 ON u1.id = t.created_user_id " . "JOIN " . DBConn::prefix() . "users AS u2 ON u2.id = t.last_updated_by;"); }
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 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); }
static function selectVisibilityFields() { return DBConn::selectAll("SELECT f.id, CONCAT('(', f.type, ') ', f.identifier) AS label " . "FROM " . DBConn::prefix() . "auth_fields AS f ORDER BY label;"); }