Welcome to the Achaea Forums! Please be sure to read the Forum Rules.

Denizen ID Database

AhmetAhmet Wherever I wanna beMember Posts: 3,370 @@ - Legendary Achaean
Hi!

I realize there are some resources out there like The Achaean Denizen Database Project, but that one's horribly out of date and incomplete (only about 1/4 of the denizens total), so I figured I'd drop this here for anyone to use if they'd like.

List of all numbered denizens I could grab, names/IDs for all and areas for some. Good background for a walkto reference or searching for denizens. Available in csv and sql format. May as well save you all the time of collecting the 24k denizens or so (those who haven't already, anyway). Just over 10k of the denizens have areas. 2753 of 3765 uniquely named denizens have areas.

Up to date as of early February, should have most if not all denizens.

Enjoy.
Huh. Neat.
UtianimaJeslynJannaRohaiSeverina

Comments

  • YaeYae Member Posts: 307 @@ - Legendary Achaean
    Foozle will never be the same.  :'(
    Art commissions are closed! I am (practically) dormant.   :s
    Rangor
  • ShirszaeShirszae Santo DomingoMember Posts: 3,263 @@ - Legendary Achaean
    Isn't walkto deactivated for fozzles anyway?  Though I suppose a list like this is going to be rather useful anyway.

    And you won't understand the cause of your grief...


    ...But you'll always follow the voices beneath.

    Halos
  • HalosHalos San FranciscoMember Posts: 1,469 @@ - Legendary Achaean
    Yes, WALK TO is disabled during foozle.

  • KryptonKrypton shi-KhurenaMember Posts: 2,377 @@ - Legendary Achaean
    You are too far away from the incomprehensible mind of the Lord of Oblivion to walk there automatically.
    (Mhaldor): Herenicus says, "Apologies, I am in-and-out of hold with Verizon wireless customer service."
    JannaYae
  • AhmetAhmet Wherever I wanna beMember Posts: 3,370 @@ - Legendary Achaean
    Krypton said:
    You are too far away from the incomprehensible mind of the Lord of Oblivion to walk there automatically.
    One of my favorites :>

    30030 is pretty good too.

    267377 is interesting.

    I need to sneak a peek at 139298.
    Huh. Neat.
    Krypton
  • XadenXaden Member Posts: 2,315 @@ - Legendary Achaean
    edited March 2016
    Gaheris Lighthawk is in there with two different ID's?

    ETA: Sorry, not picking holes. More Curiosity. (Don't yell at me)
         He is a coward who has to bring two friends as backup to jump people hunting.

  • KryptonKrypton shi-KhurenaMember Posts: 2,377 @@ - Legendary Achaean
    All the newbie intro characters have two IDs because the ones in the cities are different entities from the ones that appear in the pygmy dungeons.
    (Mhaldor): Herenicus says, "Apologies, I am in-and-out of hold with Verizon wireless customer service."
  • AhmetAhmet Wherever I wanna beMember Posts: 3,370 @@ - Legendary Achaean
    Krypton said:
    All the newbie intro characters have two IDs because the ones in the cities are different entities from the ones that appear in the pygmy dungeons.
    A lot of them have more than two.

    One has like 25 :open_mouth: 
    Huh. Neat.
  • MelodieMelodie Port Saint Lucie, FloridaMember Posts: 5,084 @@ - Legendary Achaean
    Possibly a different one for every section of the main questline, would be my guess.
               My wing tips waltz across naive
                     Wood floors they creak
                  Innocently down the stairs

                          Drag melody
    My percussive feet serve cobweb headaches as a
              Matching set of marching clocks
                The slumbering apparitions
              That they've come to wake up
  • PenwizePenwize Member Posts: 1,538 @@ - Legendary Achaean
    Lorielan said:
    As one of the Gods with an item on Ahmet's extra interesting list pulled from the main, I'd like to mention how much folks in the RP side of things hate this sort of datamining.

    When you take time to go out of your way to create new and interesting things, easter eggs, secrets, special interactions for the game, it's fairly disheartening to have someone spam through a list of numbers to find out what's attached to each, using a system that's supposed to assist players in playing the game to achieve this sort of database.

    From a creating person's standpoint it's discouraging and demoralising when suddenly players start asking us to share things that we're "secretly" working on. It can strip the magic away from a new release, can draw the ooo factor out of the special things we try to do, and makes the people working on the creative expansions wonder to themselves why they should bother planning special release events when everyone knew X area, or Y creature already existed.
    I also imagine brute force spamming WALK TO X can't be good on the server.  To discourage it, the WALK TO failure message should not translate numbers into denizen names, so the only feedback you'll be able to get with WALK TO X is just "You are too far away from 12345 to walk there automatically." instead of "You are too far away from Rurin, the Crafter to walk there automatically."

    Yes, that'll still tell you that a denizen with ID#12345 exists, but that could just be someone's shipmate or a city guard or whatever.
    Siduri
  • AhmetAhmet Wherever I wanna beMember Posts: 3,370 @@ - Legendary Achaean
    I'll just shut up and go back to sitting in my corner then :(
    Penwize said:

    I also imagine brute force spamming WALK TO X can't be good on the server.
    Probably not, but I put a reasonable delay on it (once a second ftw) and only ran it at low-pop times.

    And @Lorielan I can somewhat understand what you're saying, but it also helps hype things up on our end when we have a bit (or a lot) of warning that something's upcoming or going to happen. Tbqf, if I knew nothing about the upcoming areas I'd be much more frustrated with the state of exploration than I am now. Holding out that bit of hope is nice, and keeps me from going insane knowing that at this point my explorer ranking is almost entirely reliant on the off chance of ridiculous kindness or complete idiocy of others.

    Maybe that's just me.

    Tl;dr: Keeping stuff to myself from now on.
    Huh. Neat.
  • KryptonKrypton shi-KhurenaMember Posts: 2,377 @@ - Legendary Achaean
    Some people enjoy the element of surprise. Other people enjoy cracking secrets / being in the know. Not sure why it's necessarily demoralizing when the latter group succeeds in cracking a mystery, and gets enjoyment out of that.
    (Mhaldor): Herenicus says, "Apologies, I am in-and-out of hold with Verizon wireless customer service."
    AhmetJeslyn
  • SobriquetSobriquet Member Posts: 2,419 @@ - Legendary Achaean
    Have I missed something here? Who's leaked what? I thought this was just a mob list
    image
    Jeslyn
  • ShirszaeShirszae Santo DomingoMember Posts: 3,263 @@ - Legendary Achaean
    Sobriquet said:
    Have I missed something here? Who's leaked what? I thought this was just a mob list
    The point is that people can 'leak' things through these lists by finding the ids of denizens/things that have yet to be officially unveiled. And I agree with Lorielan that it definitely sucks.

    And you won't understand the cause of your grief...


    ...But you'll always follow the voices beneath.

    Siduri
  • VadimusesVadimuses Member Posts: 1,119 @ - Epic Achaean
    The only person who leaked here anything was the coder who made the function to translate a denizens number into the name. Without Ahmets posting, people would've used this anyway, albeit privately and available to a select few. Props to Ahmet for bringing this into the public light.
    Rangor
  • AhmetAhmet Wherever I wanna beMember Posts: 3,370 @@ - Legendary Achaean
    Well it's certainly fixed up now, so no more datamining! (for now muahhahaha)


    Huh. Neat.
    Rangor
  • ColganoColgano ✭✭ - Stalwart Member Posts: 15 ✭✭ - Stalwart
    I used this db as a learning tool for the db: functions, and it was quite fun to learn it. I made a way to view the contents in game.



    I've made a way to search for the mob by name, or you can list all the mobs in an area. :)

    Anyway, I appreciate the database if for no other reason than it gave me a way to learn using actual data.
    Sobriquet
  • AhmetAhmet Wherever I wanna beMember Posts: 3,370 @@ - Legendary Achaean
    That indenting

    *twitch*

    :p
    Huh. Neat.
  • DaironDairon ✭✭✭ - Distinguished Member Posts: 330 ✭✭✭ - Distinguished
    Colgano said:
    I used this db as a learning tool for the db: functions, and it was quite fun to learn it. I made a way to view the contents in game.



    I've made a way to search for the mob by name, or you can list all the mobs in an area. :)

    Anyway, I appreciate the database if for no other reason than it gave me a way to learn using actual data.
    I need to do this also - looks like a neat way to learn db
  • ColganoColgano ✭✭ - Stalwart Member Posts: 15 ✭✭ - Stalwart
    Ahmet said:
    That indenting

    *twitch*

    :p
    Sadly, you have no idea how long it took me to get it looking even THAT good. Like I said, it was a learning experience and a valuable one at that.  Thanks for your contribution.

    Feel free to suggest an easier way to format that. I had to go with string.cut() because I couldn't figure out any other way to do it. I welcome the lesson @Ahmet ...

    And @Dairon it was totally worth the time. Best way to learn it is to do it. B) =)
  • ColganoColgano ✭✭ - Stalwart Member Posts: 15 ✭✭ - Stalwart
    @Ahmet I fixed the spacing just for you.



    :)

    Ahmet
Sign In to Comment.