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