iEQ
 

First of all, iEQ isnt a brilliant new idea that none have ever thought of making and such. In fact almost everything it does is already covered, in one way or another, by the other great tools here such as EQAdmin or the awesome LootEditor.

In fact it was Sandy's LootEditor that made me start this project for various reasons, a thing that I feel needs to be said cause its also the source of all these great icons that iEQ uses :wink:

Now that I have said it, iEQ is a tool that helps world builders work mainly with NPCs Faction, Loot sets and Merchant sets. It lets you change/create/delete/rename Factions, assign the to NPC's, create/change lootsets, cash, merchant sets, adding items etc. It also comes with a nice Item browser (to select items) and lets you change in general some details of each spawn, like NPC level, hit points etc. Also it has a build in Report Generator that lists all details of each zone, like wrong faction IDs, incorrect items in lootsets etc.

Before using it, it would be usefull to read the iEQ.txt file that comes with the .zip, as I have included a bit more info there. Just to give you a general idea, before you even install it, you need a) the .NET FRAMEWORK 1.1 (from microsoft) plus to source in your DB the iEQ.sql file, which is also included in the .zip. (more details on the .txt file)

Of course you also need to edit the iEQ.ini file, but I have included all info in the iEQ.txt file.

The link you can download is the follow:

http://www.reporter.gr/thanos/files/zara/ieq.zip

Please note that this isnt a finalized program. It most definately has some random bugs here and there (although I have cought the most obvious ones). It also needs a lot of improvements like Berserker support, a bit more functionality and such.

Let me know if you find it usefull or if you have any problems by using it.

ps. I have developed it using the myWorld-5.5-alpha1 database and the 5.5DR1 server program, so take this in mind if you face any difficulties.

Sounds pretty cool, thanks for your help with the Project :)

well, capusr5, I have got to say you are a mind reader. this is exactly what I needed to easily setup my server. I was thinking of writing something in php to do this but now I have more time to spend setting up the world.

you are a god and I thank you very much.

if I do come across any problems with it I shall pass them on.

this is a great tool.

NOTE: to the other gods out there, there can be more than One god =)

We are always in search of good tools to use, so I checked this out. It looks great! I highly recommend it!

I am about to add something to NPCs. If you'd like to talk, your program would be very useful for the world builders in dealing with the change...

If you like you can PM me with what you have in mind Scorpious2k, if you prefer not to post it here for the moment. For as long as I

hello,thanks for the great job,it looks very good!But I cannot use it =(.I configured the .ini and when I am going to execute IEQ.exe,an error message pops up and it says:
The application cannot be initialized(0xc0000135).Click on ok button to finish the application.
Could you help me please?

Have you properly installed the .NET FRAMEWORK 1.1 first? If not then this might be the reason why.

It doesn't work, It cannot read my database it asks if im sure i installed the iEQ.sql file. I did


use eq;

source iEQ.sql;


It adding the colums, and it still gives me that error when trying to start iEQ.


Then I tried to source it again and it added it with no errors and no duplicate entries (which is wierd cus its saying it wrote it to the database) it looks like the iEQ.sql file is messed up and its not really writing to the database like it says it is.

If the message you getting is "Error reading database. Have you sourced iEQ.sql yet?" then it comes from not being able to load data from the ZONE table or from the ZONE_ERA one.

iEQ doenst do anything with the ZONE table so if I take as granded that ZONE table exists with proper data, the problem should be in your ZONE_ERA one.

That means either it doenst exist or its format (columns) isnt correct. Check with mysql or mysql-front or sthng like that the existance of ZONE_ERA and its format.

What iEQ.sql file actualy does is first DELETE the tables and then recreating them plus filling them with data. There is no such thing as iEQ.sql is messed up and not actually write to the database, assuming that there is a valid database you use.

All the above of course have meaning if the database you use is a valid database, that is you use it to connect to EQ without problems, user has sufficient rights etc.

I wasnt able to reproduce the problem on any other occasion other than the one I mentioned in the beginning of my post. If you still have problems please post and I'll see what else I can do.

Ok wow
 

All I have to say about your program is...






OMG THIS THING IS INSANELY AWESOME! :shock: (no offence to others who have contributed great programs such as Sandy's loot editer and EQAdmin) But this is honestly a wonderful program! I really love it it also helped me to free up a bit of crap in my DB :wink: I went into my DB and deleted EVERY merchant ID because this program made it possible for me to quickly tell what the merchant ID actually had.

Which I quickly found out was really not stuff the way I wanted it so I decided (for space and possibly speed) that I didnt need all of that stuff especially since I am just starting my server out.

Thanks for the great contribution!

And again Sandy's loot editor and EQAdmin are great programs but sandy's stopped working on my computer and EQadmin I only need for a few things that I cannot interpret on the database. :(

And by the way deleting all of your merchant lists is NOT RECOMMENDED. I ran acrossed the problem of not being able to add a merchant list through IEQ after I did that but it is easily fixed you go back into your DB and create a merchant ID and you can just leave it blank or put a 1 for the ID (Put a 1 of it doesnt work blank) and then you can make merchant lists through IEQ.

And dont even attempt it unless you know what you are doing in the first place just make some custom ones leaving the ones already there alone if you dont want to delete them.

And it screws up all of your merchants so if you do it dont come back complaining that something isnt working. So dont do it unless you are starting from bottom up on your server. And dont bug anybody if something gets screwed up.

I'm actually having a problem with IEQ. I've imported the database, I've configured the ini, and I've downloaded the .net framework. When I run the program it just sits as a minimized program on the task bar. Any idea whats going on with it?

I take offense =)

iEQ support Shadowrest ? Because i cant seem to find zone in zone list ...

Great tool. Thanks a bunch! :D

I have a problem using iEQ, actually, when i want to add/manage merchants set and want add an item to the set, i got an error about "SPELL_US.TXT" not being present in iEQ forder, well it is.
My "SPELL_US.TXT" isnt the original EQLive file, as im rewrinting spells and im around 1600 atm, just wanted to know if problem is that iEQ have a problem loading custom spells.

You sure you have the correct directory in your .ini file that points to your spells file? I dont think it has anything to do with custom spells cause it only reads a fixed amount of info.

I have already made a new version of iEQ with many things added/fixed but I have a terrible work schedule these last few weeks (and dont know when it will calm down) so I dont have the time to properly test it, in order to post it.

Awesome Tool
 

I'm just wanting to say how awesome this tool is. Finally i'm getting to setup loot tables for my mobs. I appreciate the program, and wait for the next release in anticipation.

Yup.... I like it.... Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!!!!!!!!!!!!!!11two

edit: ok so, anyway. uhm, Your Program is near perfect.. Only thing i suggest adding is a spawn editor. So i can delete/add spawns..

Maybe there is, and i dont see it cause im just dumb or somethin.

Anyway, Thanks for the awsome program!

Great work. I love how you set this up and hope to see different tools from you in the future. :D

Having an issue with the program. I'm trying to search for one of the loot tables to apply to Rallos Zek at the moment, and when i do a -1 to search for it, the program freezes and it won't go any further w/o a CTRL-ALT-DEL close. Also, just to maybe fix this in an alternate way, is there any way you can give a release, in txt form or something, of the different loot sets and their coinciding mobs? Thanks for the help.

I tried to replicate the problem but couldnt make the program freeze in any way.

One thing I noticed is that with the current database, it takes a bit more time to build up the required tables than with the database I released iEQ. This is normal of course and is the result of the extended loottables this DB has.

I dont know your PC configuration but to give you an idea, my 1500mhz P4 takes about 15-17 seconds to build up the loottables, and my 3.02 P4 one, about 6 seconds. So I would suggest wait a bit more time before pressing ctrl+alt+delete to see what happens. Eitherway, I'm gonna take a look at the function to see what can be done to speed things a little.

One other thing that comes to mind, is that maybe you have the "showicons" line in iEQ.ini set to TRUE which I would strongly advice seting it to FALSE instead.

Other than that, I dont think there is any other way of making iEQ lock in that menu, cause if it was a DB error, it would return an relevant DB error the moment you entered the -1.

Hello,

Very nice program.

one bug report, if your still working on this thing: when editing merchant set names, it puts ###.ItemSetName_set instead of just ItemSetName as the default text in the text box.


Anyways, the real reason I am posting is that using iEQ, I have given every merchant ID in the DB a useful name, and developed a patch to use it as the merchant's last name. You can get the patch and SQL file here:
http://eqemu.psend.com
the thread about the patch is here:
http://www.eqemulator.net/forums/viewtopic.php?t=16422

you can just use the SQL file if you dont want to use my patch, it will work just for iEQ without messing with it.

Hopefully the merchantsets table can get added to project EQ and will be kept up to date, but prolly not.

The `npc_types` table already has a lastname field in it. If I remember correctly, the EQCollector takes any (name in parentheses) under the merchant and stores it here.

It's a small change to just 3 or 4 lines of code to get the server to stop saying (EQEmu Shopkeeper) and start saying what's in the lastname field. I don't have the source where I am but I can get it later tonight if need be.

I've gotten the .NET framework and sourced in the SQL. and have the spells files in the folder. Updated all the proper paths and i'm getting errors right when i run it.

An Unhandled Exception has occured in your application.

MySQLDriverCS Exception: MySQLDriverCS Error: wrong Query: Unknown column 'class' in field list..

theres a details button that shows waay too much crap to post here.

Sotonin, just a question you didn't happen to have a "Class" table in your custom database already did you? I used the application and had to rename mine to my_classes just to give it a different name, I only ask because you have a custom server if I recall properly. =)

EDIT (ADDED): maybe I've just been reading way to many posts lately too LOL. =)

Darkwaters

nope.... and reading the iEQ.sql there is NO class table. only classes. which yes it created

its looking for a field "class" in some table.... which the only one i can think of would be npc_types which yes has that field...

but doing a search of iEQ.sql for "class" brings up nothing.

im clueless

iEQ!!
 

iEQ is awesome!!! Thanks so much!! Great job!
Does what Mysql-front does without hassle *claps*

No errors found yet but I just d/led it today :D