malgraph4 icon indicating copy to clipboard operation
malgraph4 copied to clipboard
verified publisher icon rr-

Achievement ideas

Open oczki opened this issue 12 years ago • 19 comments

Anime

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

Manga

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

Misc

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

oczki avatar Aug 07 '13 13:08 oczki

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

These values look okay to me.

rr- avatar Aug 13 '13 10:08 rr-

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?

oczki avatar Aug 18 '13 17:08 oczki

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

rr- avatar Aug 18 '13 18:08 rr-

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 avatar Aug 29 '13 08:08 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).

oczki avatar Sep 11 '13 20:09 oczki

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.

rr- avatar Sep 12 '13 07:09 rr-

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.

oczki avatar Sep 14 '13 14:09 oczki

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;

rr- avatar Sep 14 '13 21:09 rr-

Great results. Thanks!

oczki avatar Sep 14 '13 22:09 oczki

@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 >.<

simdimdim avatar Dec 19 '13 11:12 simdimdim

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

oczki avatar Dec 19 '13 11:12 oczki

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.)

rr- avatar Dec 19 '13 11:12 rr-

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".

oczki avatar Dec 19 '13 12:12 oczki

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 avatar Dec 21 '13 03:12 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)

simdimdim avatar Dec 21 '13 13:12 simdimdim

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

rr- avatar Dec 21 '13 13:12 rr-

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)

simdimdim avatar Dec 21 '13 13:12 simdimdim

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.

rr- avatar Dec 21 '13 13:12 rr-

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 :+1: , keep it up ^^, I promise I'll be enjoying it :)

simdimdim avatar Dec 21 '13 14:12 simdimdim