Achievement ideas

[oczki]

Anime

• Romance 1
• Romance 2
• Romance 3
• Romance 4
• Space 1 (use genre ID + Numi's post)
• Space 2
• Space 3
• Space 4
• No drop
• More dropped than completed (one level)
• Long runner (one level)
• Old school (pre-1980) (one level)

---

Manga

• Romance 1
• Romance 2
• Romance 3
• Romance 4
• Vampires/Demons 1
• Vampires/Demons 2
• Vampires/Demons 3
• Vampires/Demons 4
• Psychological/Dementia 1
• Psychological/Dementia 2
• Psychological/Dementia 3
• Psychological/Dementia 4
• Horror 1
• Horror 2
• Horror 3
• Horror 4
• No drop
• More dropped than completed (one level)
• Long runner (one level)
• Old school (pre-1980) (one level)
• Mean score > 8.5
• Mean score < 5
• Mean score < 3

---

Misc

• MAL contributor (making 5/10/20 reviews, 10/25/50 recommendations)

[rr-]

MAL contributor (making 5/10/20 reviews, 10/25/50 recommendations - to be discussed)

These values look okay to me.

[oczki]

MAL contributor (making 5/10/20 reviews, 10/25/50 recommendations - to be discussed)

These values look okay to me.

Okay, but are these to be two separate achievements? Or one with two simultaneous thresholds?

[rr-]

I'd make them two separate achievements, each one 3 level.

[oczki]

I'll keep this issue opened and update it with achievements suggested by users.
Current stats:

• Anime: 11 badges, 42 images
• Manga: 8 badges, 33 images

In other words, manga has priority now.

[oczki]

Added some new suggestions from Moderator and forums. What do you think? I'm not sure about the Psychological/Dementia and Horror ones - wouldn't they overlap? Also please comment on the last idea (the opposite of no-drop).

[rr-]

Psychological vs Horror: they probably would overlap, much like romance overlaps with... pretty much everything, now. Let me know if you want me to ask the DB about this.

The opposite of no-drop: nice idea.

[oczki]

To make sure of that, and for future achievements, we'll need quite a few numbers from the database. Genre IDs in parentheses.

Anime

1. Count of space (29) anime
2. Count of space (29) anime that is not mecha (18)
3. Count of anime that finished airing before 1990

Manga

1. Count of manga that are either psychological (40) or dementia (5)
2. Count of horror (14) manga
3. Count of horror (14) manga that is not psychological (40) nor dementia (5) nor vampire (32)
4. Count of manga that finished publishing before 1990
5. Count of manga that is 20+ volumes long

Manga 5 is for the "long runner" badge. Its threshold should be high enough to be hard to obtain (as with 150-ep anime). Do it in your spare time, I'll try to make some badges now.

[rr-]

Below results were obtained from DB containing 8360 unique anime entries and 24590 unique manga entries.

Anime

1. Count of space (29) anime: 191

   SELECT COUNT(DISTINCT m.id)
       FROM media m
       INNER JOIN mediagenre mg ON mg.media_id = m.id
       WHERE media='A'
           AND mg.mal_id = 29;
   

2. Count of space (29) anime that is not mecha (18): 112

   SELECT COUNT(DISTINCT m.id)
       FROM media m
       INNER JOIN mediagenre mg ON mg.media_id = m.id
       WHERE media='A'
           AND mg.mal_id = 29
           AND NOT EXISTS (SELECT 0
               FROM mediagenre mg2
               WHERE mg2.media_id = m.id
                   AND mg2.mal_id = 18);
   

3. Count of anime that finished airing before 1990: 1612

SELECT COUNT(*)
    FROM media m
    WHERE media = 'A'
        AND CAST(SUBSTR(published_to, 1, 4) AS INT) <= 1990
        AND SUBSTR(published_to, 1, 4) <> '????';

Manga

1. Count of manga that are either psychological (40) or dementia (5): 783

   SELECT COUNT(DISTINCT m.id)
       FROM media m
       INNER JOIN mediagenre mg ON mg.media_id = m.id
       WHERE media='M'
           AND mg.mal_id IN(40,5);
   

2. Count of horror (14) manga: 851

   SELECT COUNT(DISTINCT m.id)
       FROM media m
       INNER JOIN mediagenre mg ON mg.media_id = m.id
       WHERE media='M'
           AND mg.mal_id = 14;
   

3. Count of horror (14) manga that is not psychological (40) nor dementia (5) nor vampire (32): 608

   SELECT COUNT(DISTINCT m.id)
       FROM media m
       INNER JOIN mediagenre mg ON mg.media_id = m.id
       WHERE media='M'
           AND mg.mal_id = 14
           AND NOT EXISTS (SELECT 0
               FROM mediagenre mg2
               WHERE mg2.media_id = m.id
                   AND mg2.mal_id IN (40, 5, 32));
   

4. Count of manga that finished publishing before 1990: 749

   SELECT COUNT(*)
       FROM media m
       WHERE media = 'M'
           AND CAST(SUBSTR(published_to, 1, 4) AS INT) <= 1990
           AND SUBSTR(published_to, 1, 4) <> '????';
   

5. Count of manga that is over 20 volumes long: 359

   SELECT COUNT(*)
       FROM media m
       WHERE media = 'M'
           AND volumes >= 20;
   

[oczki]

Great results. Thanks!

[simdimdim]

@rr- not sure if I should be bothering you with this, but there seem to be a small grammar issue with the anime no drop badge description ( https://github.com/rr-/malgraph4/blob/master/data/achievements/anime-no-drop.json ) shouldn't either be 'much anime' or 'many animes', although as stated here at line 62 here https://github.com/rr-/malgraph4/blob/master/data/achievements/anime-completed.json you support the 'no plural' movement, therefore uncountable, therefore many shouldn't be used, right?

Also thanks for the awesome site and sorry for nitpicking >.<

[oczki]

Could you specify what should it say, then? English isn't our native language and we're open to fixing errors like this.

[rr-]

Thanks for feedback!
"Much anime" sounds silly to me... on the other hand, "animes" sounds even worse. (That's why we used "many anime", like "many animé" even though it's probably incorrect.)

[oczki]

What's wrong with "many anime", by the way?

That file says "the plural of anime is anime", not "there's no plural of 'anime'" - it doesn't say that it's uncountable. Just like "one sheep" and "many sheep".

[simdimdim]

I don't know if it should be much anime or many animes, but many + uncountable is (in my eyes) an error. But then like you said the plural of anime is anime... so I'm at a loss...
there's also this : http://en.wiktionary.org/wiki/anime#Noun

(English ain't my native language either ^^, it's quite possible a slang I've seen somewhere is clouding my judgment...)
Aaah, dunno, it was just bothering me, so I thought I'd share that thought with you :)

The confusion could be avoided with "You’ve managed to survive watching all that anime without dropping a single one (of them). ..." or something like that, rephrasing usually fixes such situations ^^' though I'm not even certain there's actually a problem ... ^^
cheers.

[simdimdim]

And an idea for franchise specific badge(s) like the Gundam franchise ( http://en.wikipedia.org/wiki/Gundam#Animated_series_and_films )
or Dragon Ball, .hack, Ghost in a shell, Pokemon, Sailor moon, and others.

Another idea badges for both seeing an anime and reading the manga and/or for mainly reading manga/watching anime, though those shall be account wide badges and not anime/manga related specifically (i.e. account achievements)

[rr-]

I guess we'll leave "many anime", http://en.wiktionary.org/wiki/anime#Noun says it's ok.

[simdimdim]

Ok :). And on the badge idea?

(your Missing Titles script should already be able to do most of the work on that (I think))(If you don't have them somewhere on db already)

[rr-]

At first this sounds like a good idea, but there are way too many franchises to make images for and it would probably cause much distress "why my <insert-niche-franchise-here> doesn't have an achievement!?". Also for now we're quite busy with other stuff and adding new features is postponed for foreseeable future.

[simdimdim]

I see. I was thinking just for the big/popular ones either with 5+ titles or with a lot of episodes/films. (people love badges, they would load the page just to check out how many they've got already @simdimdim <- one of those ppl :D)
(another idea (for when/if you get the time) total times rewatched badge, (since some people like to watch the same thing over and over again ^^) )
Also you've done a great job so far 👍 , keep it up ^^, I promise I'll be enjoying it :)