so you want to edit npc's part deux

[GeorgeS]

So in my effort to translate the excel version to a standalone exe, I am releasing the newest version of this NPC and Loot Editor - Compiled!

This will be multipart series of a variety of programs that will help in zone editing and NPC maintenance.

NPC and Loot Editor - 100% done
Item Viewer - 100% done
Merchant Editor - 0% done
Waypoint Editor - 0% done
Spawn Editor - 0% done
Database Backup/restore 100% done
Remember this only works with 0.6.6 and 0.7.x version databases.
Let me know any issues you encounter. Before running the NPC and Loot Editor, fill in the db.ini file first.

Links
NPC and Loot Editor http://66.159.225.58/eqemu/npc_land_loot_editor.zip
Item Viewer http://66.159.225.58/eqemu/eqitems.zip
Database Backup/restore http://66.159.225.58/eqemu/eq_db_backup.zip

If you need - ODBC drivers for mysql
http://66.159.225.58/eqemu/ODBC_DRIVERS.ZIP

[jimbabwe]

it will be put to use post haste! thanks for the update.

[Belfedia]

Yeahh nice work georges :)

[Muuss]

'Part deux' ? Georges is Belfedia's reincarnation ! :D

[Belfedia]

'Part deux' ? Georges is Belfedia's reincarnation ! :D

Heeee !!!
I'm necromancer, i'm not dead :p or perhaps i have forgotten this :p
I can't reincarnate :p lol

[jimbabwe]

whenever i search for an npc, i get the error below, and the program crashes.

Run time error 3265
Item cannot be found in the collection corresponding to the requested name or ordinal.

I got this error with the default settings of orc and crushbone.

edit: nevermind, i got this because i was using cavedude's db

[Topgun19691]

I am getting a run-time error 339 component 'imagelist.ocx or one of it's dependencies not correctly registered: a file is missing or invalid.


Figured it out though, just register with microsoft regsvr32.exe in windows/system32 directory.

[jimbabwe]

i just moved it into the same directory as the .exe file

[GeorgeS]

I moved the ocx's to the /resources/ folder to make it work better.
New version should work without the errors I hope..

GeorgeS

[GeorgeS]

Folks,
The Spawn Editor and Grid/Waypoint Editor are finished. You can get the dl here from my server.

http://66.159.225.58/eqemu/grid_and_spawn_editor.zip

These utilities enable you to place spawns in game and attach waypoint grids. Also, a utility for waypoint editing is provided. All are .exe

...Next is the merchant editor.

GeorgeS

[GeorgeS]

NPC/Loot editor- 100% done
Item Viewer - 100% done
Merchant Editor - 20% done
Waypoint Editor - 100% done
Spawn Editor - 100% done
Database Backup/restore 100% done
Tradeskill Editor 0% done
Remember this only works with 0.6.6 and 0.7.x version databases.
Let me know any issues you encounter. Before running any of the programs, register the ocx files with the utility in resources folder called register_ocx.bat. Also fill the db.ini with mysql user info.

I have combined the
Waypoint Editor ,Spawn Editor ,NPC/Loot editor into one download
http://66.159.225.58/eqemu/grid_and_spawn_editor.zip

Also in the works is a Tradeskill Recipe Editor....stay tuned

GeorgeS

[hansolojim]

Thanks, GeorgeS, that makes my work much easier! I really appreciate all the hard work it must've taken for those programs. Keep up the good work.

[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

[Angelox]

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]

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.

[Angelox]

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.

I had done this before; Everytime I got an .ocx error, I'd find the file , run regsrvr32 on it. I did run your batch just incase.
I figured out my mistake- it was a stupid one; i wasn't saving them! I had been useing the peqeditor since it works partially on eq database and it spoiled me into not saving.

Thanks for the help

[GeorgeS]

The Spawn Editor would be very easy to fix, but I think a unique version for 0.7.x and later would be better than trying to make one version to work on all every db schema out there.

So anyway, an 0.7 version is next up...

Next in the cards will be an enhancement to the existing eqitems.exe (items viewer) so you will be able to equip any of your characters easily with a eq like graphical interface. I'm going to start coding this enhancement later this week.


- sesmar - your changes are noted and will be done. -

If anyone's interested in the source code - it's going to be available when I get my server updated to a larger hardrive.

GeorgeS

[Jibbatwinkers]

I'm having some issue with connecting to MYSql. I've messed with the db.ini for about an hour, i know my database name is 'eq', ive tried the pw/name i use for all my database things, and ive tried 127.0.0.1/168.192.1.5(onlan)/and localhost but nothing seems to work. I have winMYSQLAdmin 1.4 and I've tried it with a vew different versions of 7.0 (i saw in the readme which were supported). Any ideas?

[GeorgeS]

If you can go to winmysqladmin 1.4 server properties and in my.ini Setup tab you should see your username/pass info at the bottom.

Next you should download the myODBC driver from my site
http://66.159.225.58/eqemu/ODBC_DRIVERS.ZIP
and install. Reboot and try again.

If that does not work then send me a private email and we can go from there.
also, what is the error you're getting?

GeorgeS

[akimo]

Hey, can someone please post links to GeorgeS' programs or update link? It seems all the ones on his IP are removed as i keep getting "Resource Not Found" response from his server the past few days.

[jimbabwe]

here is a temporary solution for ya.

Download Me! (http://www.vertexmode.net/files/georges.zip)

edit: I do think this is his latest version but I'm only like 99% sure.

[GeorgeS]

..dhcp router was renewing ip every day, so server would go off line every few days. I think I fixed the issue.

Worked hard to bring a few updates to the table.
I've done a total rewrite of the eqitems program, now it not only allows searching of your items, but you can load in any character and change or equip him/her with any items.

Also, to facilitate better version comunication, i've set up a webpage for all my downloads. Check out the files and don't hesitate to email me bugs.

http://66.159.225.58/eqemu/eq.html

GeorgeS

[GeorgeS]

Just an update, a new utility is being released this week. What it does is simply allow 'random' loots off mobs of specified levels. Just like in DiabloII, where any number of stuff drops depending on mob level, this utility does the same. The best part changes written to the db are undoable and will revert back to 'native' state. So you can 'rotate' stuff on npc's very easily.

I played my lvl70 necro in POStorms, and found some wonderful loot off lvl 65 mobs, never seen before! I actually enjoyed th egame much better before, because I had no idea what to find.

So how does it work?

(1) You specificy what item/s you want to add - these are classified by:
armour,weapons,spells,shields,ales,runes,food,misc low lvl, misc high lvl,etc...
You pick 1 category at a time.

(2) Then specifiy what level NPC's to apply it to i.e levels 31-40, or 50-60 etc..

(3) Then specifiy what % of mobs get these items as a lootdrop

(4) Then specifiy % chance of dropping at death

The program also gives a 'stats' of modified loots per every 10 levels and by item category, so you can identify which levels drop what categories of items - very useful.
You are also able to undo by level, so you can make rapid changesm restart server and changes are good to go for next repop.

This app is a work in progress, but once I 'skin' it for a better appearance, I will release it for testing.

A full html help file will be included -

Any questions?

GeorgeS

[Angelox]

Just an update, a new utility is being released this week. What it does is simply allow 'random' loots off mobs of specified levels. Just like in DiabloII, where any number of stuff drops depending on mob level, this utility does the same. The best part changes written to the db are undoable and will revert back to 'native' state. So you can 'rotate' stuff on npc's very easily.

I played my lvl70 necro in POStorms, and found some wonderful loot off lvl 65 mobs, never seen before! I actually enjoyed th egame much better before, because I had no idea what to find.

So how does it work?

(1) You specificy what item/s you want to add - these are classified by:
armour,weapons,spells,shields,ales,runes,food,misc low lvl, misc high lvl,etc...
You pick 1 category at a time.

(2) Then specifiy what level NPC's to apply it to i.e levels 31-40, or 50-60 etc..

(3) Then specifiy what % of mobs get these items as a lootdrop

(4) Then specifiy % chance of dropping at death

The program also gives a 'stats' of modified loots per every 10 levels and by item category, so you can identify which levels drop what categories of items - very useful.
You are also able to undo by level, so you can make rapid changesm restart server and changes are good to go for next repop.

This app is a work in progress, but once I 'skin' it for a better appearance, I will release it for testing.

A full html help file will be included -

Any questions?

GeorgeS


This is a real good idea - I think you should start a new thread on this new program of yours.

[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]

i get that error when i click on everything, armor, bags,and weapons, and misc. I get a referance error for each one.

[Thristam]

Im getting the same issue.

If i click on the item in the list i get the reference error for whatever radio button i have chose.

So for example i click on warrior, and choose left earring.

and the radio button is on armor.

thee items come up, but if i click on one in the list i get a armore reference error. Im using a 7.0.823 DB and the DB is on another box.

[GeorgeS]

Ok, I found the bug finally after many days pulling my hair out. It was a schema change from 0.6.x to 0.7.x. I just installed titanium and got the error myself! So the fixed exe will be online tonight!!

GeorgeS

[Havocx]

Awsome... :D

[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 :-)

[GeorgeS]

Avaran - sent you a PM.
Havocx - redownload the eqitems zip. The correct version is now added to that zip.

http://66.159.225.58/eqemu/eq.html

[Angelox]

Avaran - sent you a PM.
Havocx - redownload the eqitems zip. The correct version is now added to that zip.

http://66.159.225.58/eqemu/eq.html

Make sure you clear your browser cache, if you are downloading a new file with the same name, else you may not get the new one.

[Avaran]

Thanks for the PM GeorgeS!! Everything is working now... awsome job!

-Av

[GeorgeS]

Glad you got it to work.

I'm working on the eqdatabase backup tool and then a new eq item editor, that works with current db schemas.

GeorgeS

[Thristam]

hey, here is a "bug" for ya:

In the NPC and loot editor, i cant get the Loot drop chance to stick. Every time i set the loot drop chance it looks like it took, but if i go back, its reset to its old value. Im speaking about the chance for that item table to have somthing drop, not the actually item it's self.

[GeorgeS]

In order to make the change stick, you must go to menu item File/Update Loot Tables.

Whenever you change a npc stat, you would thus use File/Update NPC Table

I did this because no undo is available, but again, you must update the loottable with File/Update Loot Tables

Let me know if it works for you.

GeorgeS

[GeorgeS]

Program Update:

NPC and Loot Editor 11.3.00
-In this version, npc editing made easier - changing any npc cell value is now live - i.e changes are saved immediately - no need to save npc's
-Buttons added to make and delete npc on main page. Made a button for saving npc loot.
-Whenever a new npc is created via a copy, a row is inserted with the copy lying one row below original npc.
-Fixed a few misc things to make the program run better

Enjoy
GeorgeS

[unknownhost]

excellent programs GeorgeS =)

have one lil issue i cant seem to figure out. (nor track down an answer in the wiki or forums here hehe)


using Npc & Loot editor version 12.05.00
cavedudes database v066

im currently going through and adding many missing "named" mobs in permafrost. i add for example. a goblin archeologist i give him a unique
loot table id. set his loot drop ids and % chances up. set up the corresponding item ids in the itemlist.
i hit the "save loot" button a couple times throughout along the way.

close editor. run eqemu and then the client to check out my handiwork but it seems none of the items actually make it to the npcs in game.
i reopen the npc & loot editor and it shows my changes as still being there like i put them. i can even change existing mobs loot and that seems to work no problem.
just cant add a new loottable or even add a new lootdrop id to an existing loottable. it looks like it adds, but in game nothing seems to get there.
mobs are dropping cash btw though.

anyhow i know its probably somthing silly on my part. tends to be the case 99% of the time with me.
hate to ask at all but kinda running out ideas here hehe. thanks mate in advance =)

[unknownhost]

sorry i didnt see a way to edit my previous post.

i found a workaround.
its weird but as far as i can tell it now works if i add lootdropid from the tools menu. adds same as it did from adding directly from the "lootdrop_id" menu. but for some reason i cant fathom is working fine for me.


ahh well is working now as long as i use the selections from the tools menu only hehe.


again,
love your tools mate. amazingly helpful without doubt! first issue ive had out of the whole lot. =) and its still probably somthing on my end i say hehe!

[GeorgeS]

Thanks for trying out the tools. I'll look at the editor and see if I can
find anything that describes what you mentioned.


-you say you're using 0.6.6 database?

GeorgeS