EEE (EQ Emu Editor)

[Waeric]

I have finally got my Database Editor to BETA quality (*cough* if that).

First off you need this installed:

http://waeric.no-ip.org/myODBC.exe

Follow this example for a User DSN for using my program:

http://waeric.no-ip.org/myodbc.jpg

Lastly, you will need the 10-11mb installer:

http://waeric.no-ip.org/eee.zip

Once you have it installed .. go nuts =) it will take abit of learning to get up to date and you can find me on IRC for some help if I have time.

The source _MAY_ get released and only to certain people I feel I wont have to hold their hand through it (it is VB6 and not documented).

Features should be pretty easy to add and I will be adding in Starting Items editing if it seems it should be. (plus others)

For the newest exe check:

http://waeric.no-ip.org/eee/exe.zip

- I will post on the forum if there are any major changes, for minor changes just download the 120k zip and check the date of the .exe vs your current .exe


Thanks,

Waeric

[ice^storm]

Very nice man, keep up the good work :)

[Baron Sprite]

Rules for posting new tools:

1) Make sure Baron Sprite is off work (11:30 PM GMT)
2) Make sure HE IS OFF WORK!
3) Do not hype your program, if he is at work.


;) thanks for the program dude!

[Lurker_005]

Lol Baron!

Nice work!!!

Some things I noticed, Maps are reversed in both the X and Y axis. Refresh does not update the map. The lore field is displayed, but you can't edit it. Book items don't have an ID field (starts at hex offset AF)

Think thats enough for now :)

[Waeric]

>Some things I noticed, Maps are reversed in both the X and Y
>axis. Refresh does not update the map. The lore field is
>displayed, but you can't edit it. Book items don't have an ID field
>(starts at hex offset AF)

Books are not really editable currently (as you might not I do not have Books as a tab anywhere =))

Maps I prefer this way.. however I think I'll add in a option in the Main bar to allow you to change it.

Refresh, damn I noticed that earlier too. It will be fixed tomorrow.

Lore field, yep I'm getting that one tomorrow too.

Also a note on items.. they will not work if you create them with this version, I messed up when I started putting in my error checking and it will be fixed tonight, so check exe.zip later tonight.


Thanks for the feedback!

Waeric

[Waeric]

New exe is out with some fixes

- Items save properly also check if you dont use the correct id #s

- Spawns -> Map now refreshes when you click refresh (stays on same zoom etc)

- Lore is now a checkbox instead of a textbox


http://waeric.no-ip.org/eee/exe.zip (new exe)

http://waeric.no-ip.org/eee.zip (installer)

Installer is not updated as of this moment 3:22pm PST but will be up in a few mins.

TODO:

- Change Character editing zone to combo box (and use safe_x-z)

- Add in check to Main bar menu for map flip

- Change cost text box to four text boxes (pp, gp, sp, cp)


Thanks for your feedback!


Waeric

[devn00b]

Hmm interesting error here.. (and only on items) loads the list correctly i click on an item and a box comes up

" Runtime Error 3219

Operation not aloud in this context "

any ideas?

Win ME 512meg ram

[Waeric]

Hrmm I might need a bit more info on that one =)

I'm not sure what is causing it because I've never heard it before. Anyone else have it on the new exe?


dev-noob you have the newest exe right?

[devn00b]

yep downloaded it tonight was happening on the old one too...just while doing item editing =( other than that WORKS well..

[Waeric]

Operation and nothing else... hrmm where does it.. if you're around jump in IRC lol

[zzaqfox]

This EQ Emu Edit need use VB6 ??
or Type Exe will can use it ??

me Down back to use it ! but not use !

[Lurker_005]

zzagfox, get the second link, eee.zip

exe.zip is only for updating if you already installed the full thing.

[Lurker_005]

Regarding the lore textbox, There is a lore flag, aka only have 1 of that item. And there is the lore text, what shows up if you cast identify on an item. Usually the lore text box is the same as the name field, but for things like "ancient silver coin" it identifies which of the ancient silver coins for the player. It would be nice to have the text box back, and editable. :)

Also for Item icons, I know windcatcher used eqinside.dll to access the icons, and display them. It is a nice feature.

the bit about books I mentioned above does work, but It seems liited to about 64 characters right now for some reason... Adding a field that displays the book ID (editable) and a textbox to input the text would be great!

Opening the zone a mob is in if you click (or perhaps double click) on the spawn...

Better search capabilities. And sorting of columns.

I'm looking foward to future versions of this!

[Furinex]

DSN config, How do I get into that...?

[Everdude02]

Furinex, if you are using windows, you can reach the DNS settings from the control panel. Select administrative tools, then click on the Data Sources icon. (Make sure you have myODBC installed) Then select the driver and click on the configure button.

[Furinex]

Thanks bro.

[Waeric]

>Regarding the lore textbox, There is a lore flag, aka only have 1
>of that item. And there is the lore text, what shows up if you cast identify on an item. Usually the lore text box is the same as
>the name field, but for things like "ancient silver coin" it
>identifies which of the ancient silver coins for the player. It
>would be nice to have the text box back, and editable.

I am thinking of putting the text box back, I'm just wondering where to put it =)

>Also for Item icons, I know windcatcher used eqinside.dll to
>access the icons, and display them. It is a nice feature.

Umm yeah it is.. umm I dont have time to add this really heh

>the bit about books I mentioned above does work, but It seems
>liited to about 64 characters right now for some reason...
>Adding a field that displays the book ID (editable) and a textbox
>to input the text would be great!

I'll look into books if I get time =)

>Opening the zone a mob is in if you click (or perhaps double
>click) on the spawn...

So on the Spawns Tab you mean.. alrighty

>Better search capabilities. And sorting of columns.

I might make a form for searching and attach it to each window by a button if I get the chance.

>I'm looking foward to future versions of this!

Fixes I can do, new versions might be a bit more rough =)


Thanks for the feedback!

Waeric

[Waeric]

New exes, there was a problem in remote editing of Spawn Groups. A silly bug that Malevolent was kind enough to find =)

http://waeric.no-ip.org/eee/exe.zip (if you have EEE already installed)

http://waeric.no-ip.org/eee/exe030.zip (for you silly people on 3.0 still)


Thanks,

Waeric

[Ariak]

Cheers

[morpheus014]

Could someone plz tell me where I can download the .map files for the editor, i would like to work on some zones on my own but i dont have the map files and its a bit hard just going on loc :)

[stormgod]

They are included in the eee.zip

[Aegdaien]

I downloaded and installed everything, and after opening up EEE, the first tables begin to load, but when it gets to the NPC and Spawn information it gives a 'Run-Time Error '6' Overflow' and then shuts down. Anyone know a fix for this? Thanks :)

[Nuad]

I downloaded and installed everything, and after opening up EEE, the first tables begin to load, but when it gets to the NPC and Spawn information it gives a 'Run-Time Error '6' Overflow' and then shuts down. Anyone know a fix for this? Thanks :)

I had this also one time... sounds like your DB is screwed... maybe you sourced every sql you found in your db? only fix for this: set up a new DB...

[morpheus014]

One more quick question regarding the setup-- I downloaded and installed everything, but Im at a loss as to where to find the setup tool for the MyODBC portion of it. If someone could enlighten me that would be great :P

[Aegdaien]

That was the problem Nuad, thank you :) I deleted the eq database and re-installed the .9 DB. Works like a charm now!

[Locoelf]

Well Waeric with the slow loading of the EQAdmin 2.5 I have come over to your EEE tool. And with the upgrade of the DEV database and Drawde's 0.9 yours seems to be the best. I was just wondering if/when you were thinking of adding the other componets that EQAdmins has like:

Zone Servers
Zone States
Guilds
Books
Zone Server Auth.
Doors
Petitions
Quests
Starting Items
Tradeskill Recipes
Player Corpses
Raw Zone Points

A big plus would be to add all the avilable "book names" to make them editable, which no one has done yet. Just a thought <smile> Keep up the great work <smile>

[wycked]

Waeric, so far i love your editor it's super fast and easy but "problem" when i try to edit something or change it then save, it gives me a runtime error 6 overflow i thought it was my DB like metioned above so i rebuilt my DB and gives me the same error, it only happens on clicking save... any ideas?

[Raige3184]

Links are down /sigh And i soo wanna check out this proggy

[Waeric]

I am going to try to update the tool for .3.3.1 maybe today or this weekend if I get the chance. I'm working on three much large projects then this one so this takes a side-burner or might be put in the freezer =). I'll put up a new link to the files a little later today when/if I get IIS to work properly with FPSE.


As to an error with the app, if you're saving characters that _will_ happen. I also have to check any changes in the mysql db to see if I'm missing a few things. If I do get the link up I will also put up the source (ugly, undocumented Visual Basic) for anyone who wants to make their own changes or maybe take it over.


Waeric

[stormgod]

Hey waeric if you need a temporary hosting for your files I can take them to my website just send me a message on icq

[Waeric]

Sadly this may be one of the last times I update this project.. too much fun on other projects =)

http://waeric.no-ip.org/eee/eee.zip (for the full install)
http://waeric.no-ip.org/eee/exe.zip (for newest exe only)
http://waeric.no-ip.org/eee/source.zip (for source only)

http://waeric.no-ip.org/eee/myodbc.exe (needed if not installed)
http://waeric.no-ip.org/eee/myodbc.jpg (how to set up myodbc)

With Stormgod's help reaching the files should become easier.


Waeric

[TheClaus]

I will try to maintain this project for Waeric while he is doing RL stuff. I'll try to keep it up to date and ready for people as new releases of the emu comes out which DB changes. Though you guys have the source so you can make your own changes also.

[stormgod]

I'm uploading the files on my site right now , The Claus if you update the exe or something just pm me and I will upload it to my site , or if you want to host files just say it ;)

right now it is on http://www.stormgod-online.com/eee.php
just go there for the downloads

[Raige3184]

Maybe i just stupid but i cant seem to find where you set up mysql obcd i installed it installed eee then when i try and run eee says soem crap about obcd not being set up properly on obcd it dont have any short cuts to set up and stuff and dont really tell you what directorys to install to i searched for obcd useing find files and i cant seem to find out where to set up like the screen shot hsows how do i set it up where is the exe to where i can type in the options and stuff sorry i'm very new to this and any help would be appreciated

[stormgod]

if your using windows xp look in control panel >administrative tools > data sources , for other version of windows I dont know

[Waeric]

Win XP & 2000
Control Panel -> Administrative Tools -> Data Sources (ODBC)

Win 98 & ME
*should be
Control Panel -> ODBC Administrator

Thanks to The Clause and Stormgod for keeping this tool alive while I die an early death =)

Waeric

[stormgod]

I just moved all to the main page so now to get it its here :
http://www.stormgod-online.com/