DRP Editor 5.0

therealjjj77 · #1 06-30-2006, 03:52 PM

Awesome tool. This rocks! I have a few luclin named mobs edited to be more in line with their live counterparts. 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? So far I have Praetorian Myral and Lord Inquisitor Seru(the Seru(16) body type needs to be made invulnerable to melee attacks except seru bane weapons and also immune to magic based spells). I'm gonna also get working on revamping all the NPCs in Vex Thal to make them more like live. There also are a lot of named mobs that Cavedude and other packet collectors missed due to them being constantly camped. Going to work on adding those in for the zones I'm familiar with. I plan on definitely tackling Sseru, Greigsend, Ferubi, Vex Thal, and Wall of Slaughter. These zones I've spent days ++ grouping/soloing. Might even do some other GoD and OOW zones that I'm familiar with on live.

This tool is definitely made for the noob.

<-------Noob

There is one field I'm a little uncertain on. That's Attack Speed. I understand what it is used for but I'm unsure on which direction is faster and which is slower. For instance, -25 is faster than 0 but you can't enter in a negative sign. I only know this because of investigating mobs who have a negative attack speed. Any time I try to make it positive the mob hits much slower. But I can't make a mob faster because you can't put in a neg sign. Well big thanks goes out to the developers for their hard work!!

Angelox · #2 07-01-2006, 01:36 AM

"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** · #3 07-01-2006, 05:18 PM

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** · #4 07-01-2006, 07:01 PM

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 · #5 07-02-2006, 12:04 AM

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

Angelox · #6 07-02-2006, 01:09 AM

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.

**GeorgeS** · #7 07-02-2006, 06:55 AM

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 · #8 07-02-2006, 07:54 AM

Quote:

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** · #9 07-02-2006, 11:07 AM

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

Angelox · #10 07-02-2006, 01:29 PM

Quote:

Originally Posted by 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

That's right - this will enable for us to very easily share our work - I'll download and keep you informed.

Angelox · #11 07-02-2006, 02:19 PM

I just tried it out, so far it runs perfectly! To think all the trouble I went through before, just to ready what I had, now you made it so easy.
I have Gunthak almost done, just need to set a few more spawn cycles. and fix some grids. Then I'll do Dulak, these two are the worst, they have 200+ npc's per zone. Ill try and dump/post everything from Gunthark when I'm done, see how it adds into your database.

therealjjj77 · #12 07-02-2006, 06:14 PM

Would we call this progress?... or acceleration! =P Awesome tool!

**GeorgeS** · #13 07-03-2006, 04:29 AM

Glad you like it. This must be the fastest written app i've made in a while. I think it was ~2 hours of coding and researching how to pull out mySQL schemas via .net/myODBC

next in the works is full table editing...

GeorgeS