DRP Editor 5.0

[Angelox]

"Once I get done with all of them, how can I get the information to someone who will be able to consolidate it and make it public?"

One tool I found very helpful for this is, "MySQL Query Browser" - you can export data to CSV format. Then the problem is, finding the lines you want and converting them to SQL again. I haven't found any free tools for this. I did find a few, but were like $50.00, and I don't have $50.00 to spend like that.
You can still do it with a lot of "cut and paste", also the Linux "Gnumeric" helps alot.

[GeorgeS]

Actually making a query browser should be trivial to make. If you would find it useful, I can code one up in a few days with export to sql or txt ability.


GeorgeS

[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

[Angelox]

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 is nice, thanks! let me play with it a while - I'll tell you what I think might help.

[Angelox]

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.

[GeorgeS]

Ok, newest version sports the sql export function. I tried it with several queries and it does work.

I'm looking at making the data editable. Special fields like BLOBS will be read only. This feature may take a while.

GeorgeS

[Angelox]

Originally Posted by GeorgeS

Ok, newest version sports the sql export function. I tried it with several queries and it does work.

I'm looking at making the data editable. Special fields like BLOBS will be read only. This feature may take a while.

GeorgeS

Almost there;
heres part of an export:
INSERT INTO npc_types VALUES ('335041','#Varin_Deathclaw','','64','0','1','1',' 4736','2','0','143',etc.
should read:
INSERT INTO npc_types VALUES (335041,"#Varin_Deathclaw","'',64,0,1,1,4736,2,0,1 43,etc.
note that empty spaces are double quoted -

[GeorgeS]

Ok, as requested, changes are done. Newest version is up.

Anyone else have feature suggestions?

BTW - I think this could become quite a useful tool for us database users

GeorgeS