P99 Database Query

[lakedoo23]

Is there a way to do a SELECT query on the p1999 database or get an export of the database? I wanted to experiment with a character/content manager. I know the wiki has this information but I would like to add different filters and search criteria to it, unless the wiki can do that. Thanks in advance. (hopefully this is the right forum for this)

[quido]

lol good luck with that one

[lakedoo23]

Yeah after thinking about it a little more, I would only want to query the items and spells. Since querying anything else would give too much of an advantage. Oh well. Guess this can be deleted.

[Secrets]

Originally Posted by lakedoo23 [You must be logged in to view images. Log in or Register.]

Yeah after thinking about it a little more, I would only want to query the items and spells. Since querying anything else would give too much of an advantage. Oh well. Guess this can be deleted.

You can query the PEQ database. It's virtually the same thing.

EQEmulator has a spellfile importer/exporter that exports the spells_us.txt file into a database table. See here:

https://github.com/EQEmu/Server/tree...r/client_files

[lakedoo23]

I will look into that, thank you for the reply! I would assume a new column would be needed for the era, to create the subset for p1999?

[Sirken]

Originally Posted by lakedoo23 [You must be logged in to view images. Log in or Register.]

I will look into that, thank you for the reply! I would assume a new column would be needed for the era, to create the subset for p1999?

if youre looking for a stock classic eq database you aren't going to find one. it took a lot of people a lot of time and effort to get things to where they are. if youre just looking for item/spell info, go with secrets' advice imo

[lakedoo23]

I dont want to duplicate the efforts of p1999, I just wanted an easy way to filter the content in p1999 to look for specific things. For example if I wanted to look up a helm that is >= 13 and <= 20 AC WITH +charm, this would of course be within the set of items available in p1999.

[lakedoo23]

Great work on the videos btw Sirken, I get a chance to watch them once in a while, I need to join the Twitch channel next time you do it live!

[Man0warr]

P1999's database (and server-side code) is really the only thing proprietary they have and it took a lot of work to get to that point. It's not a public resource.

[dafier]

so much data entry.....ugh