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]

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/master/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]

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

[Oleris]

had someone look into some drops for me like a year ago. Definitely possible with the database.

https://docs.google.com/spreadsheets/d/1kTxyi9gnnyXqqGP2jYyMHtVQYCEGCHhejGaS5LA0BJs/edit#gid=0

[DRAGONBAIT]

bullshit, every open source project takes a lot of people lots of time, and they share it anyway.

[loramin]

bullshit, every open source project takes a lot of people lots of time, and they share it anyway.

This is 100% correct, and I think Sirken kind of gave the wrong answer, or at least only part of the right one.

There's zero reason, if this was a normal OSS project, for them to share the database ... but it isn't a normal project. It's a game, and all the "secrets" of the game are in that database.

Take ZEMs for instance: if the public got access to the official database, everyone would know exactly, mathematically, where the best XP in the game was for every level. It would absolutely destroy the population in every other zone.

I'm huge on OSS, and I do feel that someday, when R&N and are ready to throw in the towel on running this place, they absolutely should share that database with someone (maybe not the public, but at least a few other devs who show serious interest in starting classic servers).

But until then, it would clearly hurt the P99 community for them to do so (and I say this as someone who once spent like 20 pages arguing they were legally required to share the source code, based on a misunderstanding of the CC license they chose) .