#1
|
|||
|
P99 Database Query
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)
| ||
#2
|
|||
|
lol good luck with that one
__________________
Bush <Toxic>
Jeremy <TMO> - Patron Saint of Blue | ||
#3
|
|||
|
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.
| ||
#4
|
||||
|
Quote:
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
__________________
Engineer of Things and Stuff, Wearer of Many Hats
“Knowing yourself is the beginning of all wisdom.” — Aristotle | |||
#5
|
|||
|
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?
| ||
#6
|
||||||
|
Quote:
__________________
Ever wonder what Braknar does around here? - https://youtu.be/WTtFXBgggpI
Sirken's Twitch Stream - www.twitch.tv/sirken_ Quote:
Quote:
| |||||
#7
|
|||
|
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.
| ||
#8
|
|||
|
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!
| ||
#9
|
|||
|
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.
__________________
Green
Tofusin - Monk <Force of Will> Manowarr - Druid Blue Tofusin - 60 Monk <BDA> Shiroe - 60 Enchanter Manowarr - 60 Druid | ||
#10
|
|||
|
so much data entry.....ugh
__________________
Rebbon - BDA
Happy Epic Mage | ||
|
|