so you want to edit npc's part deux

[Angelox]

Originally Posted by GeorgeS

Tradeskill recipe editor is completed today with updated help files

I've created a zip of ALL my recent utilities here.
-npc and looteditor
-waypoint/grid editor
-tradeskill recipe editor
-spawn editor


http://66.159.225.58/eqemu/GeorgeS_EqEmu_Files.zip

I spent a lot of time working on these, so if you've any problems, just let me know what the issue was and I will fix it asap.


my eq items viewer http://66.159.225.58/eqemu/eqitems.zip
my eq database backup/restore tool http://66.159.225.58/eqemu/eq_db_backup.zip

Thank you!
I'm downloading them now

[Angelox]

I was using your editor before (with PEQ) and really liked it - when I changed database they Cavedude's EQ, it won't work anymore, I would like to use them all (The Spawn editor looks real good too!).
Is it possible to make these compatible with EQ database also?

Thank you

[GeorgeS]

The compatibility between the two databases has me perplexed. I am downloading cavedudes installer and will install his database to compare with peq to see what the differences are.

I have no idea why the data structs should be different, but that's the hard part. If anyone has any ideas what's going on...

Anyway, I will make the programs compatible with both


GeorgeS

[sesmar]

Cavedude's and the PEQ database are both compatable with each other, what seems to be the problem is that the last installer that was put out was for version 0.7.0 and since that release there have been a few DB changes that must be applied to the Database in order for it to work with the newest binaries.

Since Cavdedude releases his DB with the installer people forget, or do not realize, these changes still need to be applied to his database as well as PEQ in order for it to stay up to date. If your Editor it made to be used with all the lastest changes this is probably the problem.

I have answered a few questions similar to this recently and in most cases they seem to have to do with this SQL update.

ALTER TABLE spawnentry DROP spawn_limit;
ALTER TABLE spawngroup ADD spawn_limit tinyint(4) NOT NULL default '0';
ALTER TABLE altadv_vars ADD class_type int unsigned NOT NULL DEFAULT 0;

Hope this helps some.

[GeorgeS]

Thanks for the info. I agree the 0.6.6 and 0.7.x have those changes to the spawnentry and spawnentry tables.

Also, I have taken a serious look at both databases and found the discrepancies -specifically in the npc table.

Anyways, I fixed ALL the programs to work with both PEQ and CAVEDUDES 0.6.6 databases. 0.7.x should work in all except the spawneditor.exe because of the field changes.

Let me know of any problems...

GeorgeS
http://66.159.225.58/eqemu/GeorgeS_EqEmu_Files.zip

[Angelox]

Originally Posted by GeorgeS

Thanks for the info. I agree the 0.6.6 and 0.7.x have those changes to the spawnentry and spawnentry tables.

Also, I have taken a serious look at both databases and found the discrepancies -specifically in the npc table.

Anyways, I fixed ALL the programs to work with both PEQ and CAVEDUDES 0.6.6 databases. 0.7.x should work in all except the spawneditor.exe because of the field changes.

Let me know of any problems...

GeorgeS
http://66.159.225.58/eqemu/GeorgeS_EqEmu_Files.zip

I'm useing the latest EQEMU (0.7.0-800), I'm able to see everything, and I can edit / put in changes , but the won't save into the EQ database; when I restart the editor, the changes are gone. I tried the loot editor in Harbinger's Spire , and the Grid editor in Lfay (didn't try anything else yet).
I will keep you informed of whatever problems I run into with your programs.
The Spawn Editor would be very helpful also, but "beggars can't be choosy!" Im really happy with what you already have made out.

Thank you very much for doing this - If I ever get a lot done with this database, anyone who wants it, can have it.

[sesmar]

I downloaded and was looking at your Editors today and noticed you have to run the batch file to register a few DLL's might I suggest using the /s option to get rid of the annoying message box.

regsvr32 a.ocx /s
regsvr32 DXAnimatedGIF.ocx /s
regsvr32 imagelist.ocx /s

echo all registered

Just my thoughts.

[Havocx]

whenever i run the eqitems and click on any piece of armor it pops up with error-Armour Referance Error. dont know what this means but it dosnt give any stats to the piece of armour.

[GeorgeS]

ok, so far I cannot reproduce this error - is it only for armour?

What db are you all using and version#

GeorgeS

[Havocx]

i am useing cavedudes db and version 7.0-821

[GeorgeS]

You don't get an error for any other query - weapons, bags,misc?

GeorgeS

[Havocx]

Awsome...

[Avaran]

This is awsome, thanks for all these great tools, georges!!


Edit: Your link in your signature doesn't seem to be working.

[Havocx]

Still haveing the same errors. im useing 7.0-833 with eq db. Thanks for looking into this Georges

[Avaran]

I'm using your software suite and I don't seem to know how to get it all functioning.

If someone could write up a little how-to for installing this package that would be awsome!

Thanks