summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorYorhel <git@yorhel.nl>2022-04-21 17:19:17 +0200
committerYorhel <git@yorhel.nl>2022-04-21 17:19:17 +0200
commit77c83e6a837d5789c77cf1d7ee969733dd0bf263 (patch)
tree98c59fc821720a315b89d8e9f76b726b50b110fe
parent530f5c61eaa0d421bafe41356d32f93ee104462f (diff)
ExtLinks: Remove Erogetrailers.com links
-rw-r--r--lib/VNDB/ExtLinks.pm5
-rw-r--r--sql/schema.sql2
2 files changed, 2 insertions, 5 deletions
diff --git a/lib/VNDB/ExtLinks.pm b/lib/VNDB/ExtLinks.pm
index e9be887a..378bf075 100644
--- a/lib/VNDB/ExtLinks.pm
+++ b/lib/VNDB/ExtLinks.pm
@@ -79,9 +79,6 @@ our %LINKS = (
l_egs => { label => 'ErogameScape'
, fmt => 'https://erogamescape.dyndns.org/~ap2/ero/toukei_kaiseki/game.php?game=%d'
, regex => qr{erogamescape\.dyndns\.org/~ap2/ero/toukei_kaiseki/(?:before_)?game\.php\?(?:.*&)?game=([0-9]+)(?:&.*)?} },
- l_erotrail => { label => 'ErogeTrailers'
- , fmt => 'http://erogetrailers.com/soft/%d'
- , regex => qr{(?:www\.)?erogetrailers\.com/soft/([0-9]+)} },
l_steam => { label => 'Steam'
, fmt => 'https://store.steampowered.com/app/%d/'
, fmt2 => 'https://store.steampowered.com/app/%d/?utm_source=vndb'
@@ -181,6 +178,7 @@ our %LINKS = (
, regex => qr{store\.playstation\.com/(?:[-a-z]+\/)?product\/(EP\d{4}-[A-Z]{4}\d{5}_00-[\dA-Z_]{16})} },
# deprecated
l_dlsiteen => { label => 'DLsite (eng)', fmt => 'https://www.dlsite.com/eng/work/=/product_id/%s.html' },
+ l_erotrail => { label => 'ErogeTrailers', fmt => 'http://erogetrailers.com/soft/%d' },
},
s => {
l_site => { label => 'Official website', fmt => '%s' },
@@ -285,7 +283,6 @@ sub enrich_extlinks {
# Release links
if($type eq 'r') {
l 'l_egs';
- l 'l_erotrail';
l 'l_steam';
push @links, [ 'SteamDB', sprintf('https://steamdb.info/app/%d/info', $obj->{l_steam}), undef ] if $obj->{l_steam};
l 'l_dlsite', $obj->{l_dlsite_price};
diff --git a/sql/schema.sql b/sql/schema.sql
index 903b00ce..78e9b7cc 100644
--- a/sql/schema.sql
+++ b/sql/schema.sql
@@ -386,7 +386,7 @@ CREATE TABLE releases ( -- dbentry_type=r
l_getchu integer NOT NULL DEFAULT 0, -- [pub]
l_getchudl integer NOT NULL DEFAULT 0, -- [pub]
l_egs integer NOT NULL DEFAULT 0, -- [pub]
- l_erotrail integer NOT NULL DEFAULT 0, -- [pub]
+ l_erotrail integer NOT NULL DEFAULT 0, -- [pub] (deprecated, site hasn't been reachable for a while)
l_melonjp integer NOT NULL DEFAULT 0, -- [pub]
l_gamejolt integer NOT NULL DEFAULT 0, -- [pub]
l_animateg integer NOT NULL DEFAULT 0, -- [pub]