Quote:
|
Originally Posted by GeorgeS
I just compiled a quick database query tool - you type the query and
then you can output to text.
It's very simple, but can be expanded into a more serious tool.
http://66.159.225.58/eqemu/database_query_tool.zip
...any ideas what features it should have?
GeorgeS |
This works very well, you pretty much could make it "dedicated" do do certain things - for example, in my case I will be dumping contents of grid, grid_entries, npc_types, spawn2, spawnentry, spawngroup, into CSV text format - then have to convert them to something that can be added to a SQL database: a grid dump of "98,37,3,0" has to be converted to "INSERT INTO grid VALUES (98,37,3,0);" what really slows me down is this conversion.
Also, there's the four loot-related tables which I've been adding to, probably would be nice to make available also.
This would work for PEQ, - PEQ npc_types has an extra column that is always "0", I think it was column 30 - so a dump from EQ to be made to PEQ, would need an added "0" - filled column 30. The rest of the tables I worked with are the same.
What really is needed for me, is the text to sql converter , something that will place INSERTINTO "whatever" VALUES , and at the end ; - I can't place parenthesis, forum won't allow it.