Denizen ID Database

Ahmet

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.

Yae

Foozle will never be the same. 

Shirszae

Isn't walkto deactivated for fozzles anyway?  Though I suppose a list like this is going to be rather useful anyway.

Halos

Yes, WALK TO is disabled during foozle.

Krypton

You are too far away from the incomprehensible mind of the Lord of Oblivion to walk there automatically.

Ahmet

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.

Xaden

Gaheris Lighthawk is in there with two different ID's?

ETA: Sorry, not picking holes. More Curiosity. (Don't yell at me)

Krypton

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.

Ahmet

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  

Melodie

Possibly a different one for every section of the main questline, would be my guess.

Lorielan

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.

Penwize

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.

Ahmet

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.

Krypton

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.

Penwize

When you're a creator of something, I think one of the biggest rewards you get out of it is the reactions the reveal draws from people.  When chunks of what you're creating get leaked, a chunk of that reaction is spoiled and you lose creative control over how the reveal unfolds.  Shouldn't really be hard to understand why that loss would be demoralizing I think.

Sobriquet

Have I missed something here? Who's leaked what? I thought this was just a mob list

Shirszae

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.

Vadimuses

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.

Ahmet

Well it's certainly fixed up now, so no more datamining! (for now muahhahaha)

Colgano

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.

Ahmet

That indenting

*twitch*

Dairon

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

Colgano

Ahmet said:

That indenting

*twitch*

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.

Colgano

@Ahmet I fixed the spacing just for you.