Categories for aliases [DONE]

[PetriW]

As posted by whaha in:
http://www.anidb.net/forum/viewtopic.php?t=1149

Does it really help if it's shown in its decoded form? ^^

????????? ????????

[As it's in this thread's context, let me refine my previous feature-request from Change encoding to UTF-8 [DENIED]]
IMO, instead of just increasing the possible lenght of aliases, it'd be much better to also properly distinguish them, for example like this:
"Original title (Japanese, Kanji)"
"Original title (Japanese, Romaji)"
"Original title (Other)"
"Official translation (English)"
"Unofficial translation (English)"
"Other titles"
If the English- and the Romaji-entries would be limited to ASCII, these could be used whenever unicode doesn't get to work.

An example:

"Original title (Japanese, Kanji)": ?????????
"Original title (Japanese, Romaji)": Uchuu no Stellvia
"Unofficial translation (English)": Stellvia of the Universe, Cosmic Stellvia

One big reason for this is there are several who name their anime by the japanese title, of who I am one now.
And as I'm too lazy to rename all my files I just wish I could use AOM to do it but then we need something to see the difference between different titles.

As I kinda know how that table looks I envision this as a new category (aka cat_title) and a new column in animetitle that specifies the title category (ie in leave type alone), 0 (or 1, whatever is best for EXP) being default and pointing at "Other".
Then let us maniacs do the rest.

[exp]

i think this is a good idea.
ontodo

BYe!
EXP

[exp]

first version implemented.

BYe!
EXP

[Iceman[grrrr]]

I guess adding a way to CReq the titles will greatly help the admins!

[rowaasr13]

Hmm, it seems I can't edit titles for anime I've added. After I click "Synonym/Short Title" there is link "Edit" for each title, but when I click it, I just get "ERROR - ACCESS DENIED".

[bbaab]

Hmm, it seems I can't edit titles for anime I've added. After I click "Synonym/Short Title" there is link "Edit" for each title, but when I click it, I just get "ERROR - ACCESS DENIED".

See http://www.anidb.net/forum/viewtopic.php?t=1439

Deleting and re-adding the title works.

[Skywalka]

This might be somewhat related.

Is it possible to have the Anime titles displayed in your mylist in the same way?

For instance "Shinkon Gattai Godannar" currently shows up in my Mylist as "Godannar" which kinda sucks to be honest - I never used that title anywhere up untill I added the files to my Mylist. On the other hand what I only knew as "Queen Millennia" (or by it's german title "Königin der 1000 Jahre") is in the list as "Shin Taketori Monogatari"

So I really wonder if there is a general naming convention or if there in fact is none

It would be nice if we could choose which titles are displayed in our Mylists as well (or if there already is a way that someone point me in the right direction so I can set the options right ^_^)

[exp]

well,

currently the animes main title is used for the mylist page.
those are supposed to be the official japanese names in romaji.
however there was no strict rule to enforce that up till now but we'll be more restrictive from now on (since we have the new alias system now).

once all titles are fixed a new profile option will be added which will allow you to select your prefered title type (jap romaji, jap kanji, eng).
those will then (if present) be used for your mylist overview and maybe also for some other parts of anidb.
as the jap romaji is the only required title it will be used as fallback whenever your prefered title type is not added.

-> ontodo

BYe!
EXP

[Skywalka]

Neat, Thx EXP

[exp]

hm,

i've looked into that today and it might be really trouble some.
i've not yet found a solution which allows me to give the user a profile setting to decide on his prefered anime title language in mylist without putting too much load on the server.
or rather I haven even found one that works at all

BYe!
EXP

[Elberet]

Ano... this might be too much to ask, but would it be possible to let users choose that for each anime in their anime list? For example, I've gotten used to "Stellvia of the Universe", but highly prefer "Mujin Wakusei Survive" over "Uninhabited Planet Survival". It'd be two small changes to the SQL statement we were already talking about, plus the necessary user interface to change that setting in the cache table.

The interface to this feauture would consist of a link in each anime-column of the mylist output table. That link takes the user to a page which lists all currently available titles with a radio button besides each and a submit button below. Submitting the form updates the cache table.

Here's the updated statement. "/* <-- */" marks changed lines.

Code: Select all

SELECT
    c.aid,c.epcnt,c.seen,c.spepcnt,c.spseen,c.state,c.typepref, /* <-- */
    COALESCE(at2.name, at1.name) AS aname, a.eps AS aeps,
    a.rating AS arating,a.votes AS avotes,a.atts,a.attavg,
    LOWER(aname) as q_sortname,
    LEFT(aname, 1) as q_firstchar
FROM
    listcachetb AS c
    LEFT JOIN animetb AS a ON (a.id=c.aid)
    LEFT JOIN animetitletb AS at1 ON (at1.aid=a.id AND at1.type=1)
    LEFT JOIN animetitletb AS at2 ON (at2.aid=a.id AND at2.type=c.typepref) /* <-- */
WHERE
    c.uid=1 AND q_firstchar='x' /*AND a.id=357*/
ORDER BY q_sortname ASC

[exp]

last part is implemented.

it's not yet possible to select the title type on an anime basis.
dunno if we really need that.

BYe!
EXP

[Elberet]

I'd categorize it as "nice to have, but not important". Tho if you ever find yourself extremely bored and out of stuff to implement...

[Iceman[grrrr]]

I'd categorize it as "nice to have, but not important". Tho if you ever find yourself extremely bored and out of stuff to implement...

Unless he dumps the project this is unlikely to happen!

[bbaab]

I'd like to have a plain "Original title" category, too. Looking through my list, there are animes with an english (Gunslinger Girl), german (Weiß Kreuz) and even greek (ΠΛΑΝΗΤΕΣ) original title. I wish there was a way to show that in my mylist.