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