View Issue Details

IDProjectCategoryView StatusLast Update
0000192AniDB IRC (Chii/Lafiel)Bug Reportpublic2008-02-25 08:26
ReporterRar Assigned Toexp  
PrioritynormalSeverityminorReproducibilityalways
Status resolvedResolutionfixed 
Summary0000192: !anime change synonym to official title (english)
DescriptionThis part of the command predates the current synonym system, and currently gives rather unhelful results, often returning either no result where there's a well known english title, or an unexpected synonym rather than the common name.

!anime laputa
>ANIME: Tenkuu no Shiro Rapyuta (331), 1 eps...

!anime gits
>ANIME: Koukaku Kidoutai (61), 1 eps...

!anime moo
>ANIME: Boukyaku no Senritsu (1551), also known as Forgotten Melody, 24 eps...

Code changes to output english title instead given below (do test before implementing though).
Additional InformationIn adb_cmd_anime:

line 79 from:
       my $syn = &adb_db::getsql($main::db,"SELECT id,name FROM animetitletb WHERE aid=$aid AND type=2");
to:
       my $eng = &adb_db::getsql($main::db,"SELECT id,name FROM animetitletb WHERE aid=$aid AND type=20");

lines 87-89 from:
       if ($syn->[0]->{'id'}) {
      $out .= ",".$main::color."11 also known as $syn->[0]->{'name'}";
       }
to:
       if ($eng->[0]->{'id'}) {
      $out .= ",".$main::color."11 english title $eng->[0]->{'name'}";
       }
TagsNo tags attached.

Activities

exp

2005-06-09 20:34

administrator   ~0000511

might be fixed now.

Issue History

Date Modified Username Field Change
2005-06-03 14:18 Rar New Issue
2005-06-09 20:34 exp Status new => resolved
2005-06-09 20:34 exp Resolution open => fixed
2005-06-09 20:34 exp Assigned To => exp
2005-06-09 20:34 exp Note Added: 0000511
2005-06-09 20:34 exp Assigned To exp =>
2008-02-25 08:26 epoximator Assigned To => exp