static function selectSignupInvite($token) { return DBConn::selectColumn("SELECT team_id AS teamId FROM " . DBConn::prefix() . "tokens_player_invites " . "WHERE user_id IS NULL AND response IS NULL AND expires >= NOW() " . "AND token = :token LIMIT 1;", array(':token' => $token)); }
public static function selectGroupIdBySlug($slug) { return DBConn::selectColumn("SELECT g.id FROM " . DBConn::prefix() . "auth_groups AS g WHERE g.slug = :slug LIMIT 1;", array(':slug' => $slug)); }
static function selectUserIdByEmail($email) { return DBConn::selectColumn("SELECT id FROM " . DBConn::prefix() . "users " . "WHERE email = :email LIMIT 1;", array(':email' => $email)); }