Thanks for the reply George. So if I, hypothetically, want a 500 damage 1HS - not only do I need to write that to the mysql database, there needs to be custom coding done to the server code itself?

Hey George first just wanted to say i love your tools and makes life so much easier. Second not sure if this is where i should put a request or another place but is there any chance at some point you might be able to organize the item icons to some type of format that goes along with weapon/shield pictures? The tool is great for making custom stuff but with swords sometimes its real hard going through all the pictures to try and find a graphic match to the item icon. Either way big Thanks! again

would be pointless imho.
Original era items have no reletions to icon what so ever.
Kunark items - did
Velious weaposn - did not
Luclin weapons did not
PoP weapons - some.
LoY - did
LDON - did
Gates - did not

Starting from OoW and onward they mostly did, but far less new models were made.

GeorgeS,

If you get time, can you take a look at the changes made in Rev1542 to the items table and adjust the tool to make up with the new schema for it:

http://code.google.com/p/projecteqem...svn1542&r=1542

A few fields were renamed and quite a few useless unknowns were removed.

You may want to leave a copy of the old one up as well, so people who aren't running the current source yet can still get and use your item editor.

Thanks as always :)

Hello Georges,

One more minor issue.
The Load Character window can't handle character id's (Toon_id) in higher ranges as: 1000000720 or so. You can select the character by name in the Load character window, but selecting the toon and clicking Load Character again will result in:
Error: Ron-time error '6': Overflow

I'm not sure if hight character id range is specific to our server or not, but I would appreciate if you could look into it too.
Thanks in advance.

The adaptation to the items table schema should require just a few code adjustments, and for Lillu I can use a double integer for the character loading.

I'll work on these and should have the changes done asap.

GeorgeS

Thank you for the quick reply and fixes GeorgeS, you are great!

Updated the program to use the new schema. Ironically, nothing broke when the schema (r1542) was applied, but I checked functionality and it's ok as far as I can tell.

Also, changed a character viariable to long integer type, so now high toon id's will work.


Newest version is - 14.5.0 - enjoy


GeorgeS

Thank you GeorgeS!

Awesome as always, GeorgeS! Thanks much :)

If you get time, here are some other minor adjustments that would be nice to have at some point:

1. In the New Edit window, could you add the power source slot for items? Even though the Power Source slot is technically slot 21, we actually use slot 22 in the database due to slot 21 being used by Titanium for the ammo slot already. So, it is just 1 bitfield higher than ammo. I notice that when I copy an item set to use slot 22 already, it sets the slots to 0, so that may need adjusting too.

2. In the info window for click effects, here is some better info on Click Type:

Click Types:
1 = Clickable from inventory if Level reqs are met
3 = Expendable - normally limited charges such as potions
4 = Must equip to click
5 = Clickable from inventory if Level/Class/Race reqs are met


That's all I can think of for now, but they are fairly minor. Thanks again for the updates!

Not sure if this item editor is updated but;

The Download links are broken... New ones please?

Thank you.

Links seem fine to me. Use the site listed in GeorgeS' sig:

http://www.georgestools.eqemulator.net/

Power slot will be added in the next release. Currently fixing schema issues with the other tools.


Georges

Also, another nice note worth adding/changing is this:
Click Level -- Level that the spell will be cast as
Click Level2 -- Minimum level to use the click cast

The main one is clicklevel2, for setting the min level to cast it, but the normal clicklevel field is the level that the spell will be cast as. So, if clicklevel is set to 1, the buffs won't last long, because it will be like a level 1 cast the spell, but if set to 70, they will last much longer.

Hey GeorgeS, was playing with your item editor and about oh.. 300 custom items later, once I got to drakkin only items, I realized there were no drakkin selection option.. Took just a few minutes to test, and drakkin actually use the shroud option..

Was wondering if you could fix this? Possibly add in shroud capability as well? I know there are shroud usable items already in DB (the coldain weapons from the monster mission come to mind)..

Was playing around with making pre-set armor sets today and I ran into a few issues.

When trying to insert items into the inventory list then it does not always work. An example of a non-working item is spiritlight earring, but I've also had it happen with many others.

There doesn't appear to be a way to save a template straight from the eqitems program. You can load already pre-set profiles, but cannot save newly created ones.

Load Raid Bots doesn't work. If I load it, then select a bot, then the program crashes. The error code is: http://i.imgur.com/w5srK.jpg. Again, this only happens once I click on the bot name.

Hopefully I'm missing something and that's why I'm having these issues, but I was hoping to create a few armor templates after reading about it on your website.

Thanks for all the work you do!

Thanks for the report. I am looking into this and hopefully it won't be a big problem to address.

GeorgeS

Ok checked this out pretty extensively, and I can do everything as expected. No errors, and spiritlight earring works fine in the bots.

The error has to come from a null in your field somewhere. I am running v.1751

pre-set profiles can be saved buy going into the load bots button, and there's options to save.

You can check in your table why spiritlight earring causes problems. If there's a null somewhere or my table is too old then that could cause this.

GeorgeS

Noob
 

Is there a guide or tutorial page that explains on how to get many of the EQEMU tools created by George to work? If so please provide the link. It would be much appreciated.

Okay, step one, I need to ensure that my db.ini is filled out correctly. Okay, right here I start to panic. My server is on a Debian Linux box, which is on the same network as my Windows 7 machine. So, would the host be the Linux box IP address?

database=peq, what does peq stand for and is this the default?

everquest_folders=(whatever). I assume this is where I put the location of the EQ files that are located on the Linux box, not my local machine that has the client?

What I am trying to do, if possible, is to use George's wonderful tools from my Windows 7 box to edit the files needed on my Linux box. Is this a possible task and if so, what are the appropriate steps needed to accomplish said task?

I would like to thanks everybody for their hard work and please excuse me if my questions are redundant.

host=<ip address of the database machine>
user=<username in MySQL that you want to use>
password=<password for whoever the user is in the database>
database=<whatever you named your EQ database>
everquest_folder=<directory where you have your EQ client installed>

That made a difference.

I click it now and get a window with music. When I click start, the window disappears and nothing happens? Does it take a long time to load... or? In my processes window, the EQitems icon disappears.

Never mind, ocx registration....

Hmm. Got everything running.

Got a problem though. I made a change to the Archaic Blade of Battle to test things out. Changed the damage from 37 to 50 so I could easily spot it in the item entry. Hit save and go-back exited the program and opened the peq DB with Notepad++. The damage was still 37.

Opened the editor and brought up the blade. It still shows my change - a damage of 50 - while the DB still shows 37.

:?

What am I missing here?

The editor works on the database in MySQL, it doesn't change the dump you imported to initially create your database.

Item changes also require a restart of your server before they show up, so if you restart the server, enter the game, target yourself, and #gi <whatever the id is> you should be able to examine the item there.

That first part confused me. If it doesn't change the DB, even though the editor uses the DB for initial info, then what exactly does the editor change? Is not mysql just the interface language used to make changes to the DB?

You mentioned dump... the db_dump.sql is what I have been using for certain changes - namely the LDoN point cost for items that isn't shown anywhere else. Can't change LDoN cost in the editor. Is not the db_dump.sql the root of all this info used in running the server?

If I'm wasting my time editing the wrong file, lemme know! :shock:



EDIT: from reading your post a few times, you are saying my db_dump.sql is not the DB my game is using... where should I be looking for the one that is?

I get the impression the Archaic Blade of Battle would show up in my game with heightened damage, but still retain the original LDoN cost... :oops:

I would greatly appreciate a pointer to where my game DB is that is being used so I can alter the LDoN point costs. ;)

The editor uses the database specified in the db.ini file, whereas your eq game always uses the the database specified in eqemu_config.xml and/or login.ini.

Now if they are the same, then here's a disconnect somewhere. The editor always writes the data or it crashes/fails when it cannot write.

My guess you have more than 1 database.

GeorgeS

This is my db.ini file:

host=127.0.0.1
user=xxx
password=xxx
database=peq
everquest_folder=F:\Program Files (x86)\Sony\EverQuest

The only db file in my peq folder is the db_dump.sql.

The eqemu config shows the same:

<database>
<host>localhost</host>
<port>3306</port>
<username>xxx</username>
<password>xxx</password>
<db>peq</db>
</database>


So, the question is, if the db_dump.sql isn't the db file I should be editing for the LDoN point costs, then where should my n00b butt be looking? :oops:

BTW, yes, the changes I have made using the editor do show up in-game. I altered Djerv's solo server Gate potion costs. He had some at 4300 plat. I altered it using the editor and it shows all the changes in-game.

So the question still remains, to where are the editor changes to my db being made so that I can alter the LDoN item costs?

I only have one peq folder and the only file of any size there is the db_dump.sql.



Well, that's okay if you're all busy. If the editor does indeed change the db and it does show in game (as it does), then the "Old Edit" contains a spot for LDoN pricing that the New Edit doesn't. I guess I shouldn't be overly concerned about it if I'm able to alter what I need.

Suggestion, throw in the LDoN pricing field somewhere in the new Edit! :)

The dump file you sourced to create your server database is just a snapshot. You import that into a MySQL database which is what the server uses for it's data and what the various editors modify.

Making changes to the dump file doesn't do anything unless you import it into MySQL again. Doing so replaces your existing database with the dump again. Unless you really want to start from scratch this is the wrong thing to do.

To edit items in the MySQL database you can use the item editor you're already using, or you will need something like HeidiSQL or Navicat.

As an example, if you used HeidiSQL or Navicat you would be able to execute queries on your database to change items.

This would select a particular item:

SELECT `Name`,`ldonprice` FROM items WHERE `Name` LIKE "%Archaic Blade of Battle%"

And this would change its price to 75

UPDATE items SET `ldonprice` = 75 WHERE `Name` LIKE "%Archaic Blade of Battle%"

Depending on the tool you use you can also edit things in a grid like a spreadsheet and then save those changes back to the database.

Ok, so there isn't really a file I could just pop open with Notepad and create fire-breathing earrings... :grin:

Using the editor in this thread seems simpler than typing commands as you listed. Just opened the db items list with navicat. A bit clunky, but that answers my question nicely.

Thank you so much for your help ;)

Edit - I feel stupid... there are pages in the db tables...

Does it matter if I load Titanium or SoF in the spell tool?

Hmm, ran into a problem using the spell editor. It ran fine yesterday.

Today, I get:

Loaded DB.INI
Connected to Database OK

SPELL TABLE contains: 14799 spells
SPELL TABLE contains: 215 FIELDS!
Your file is MISSING/WRONG FOLDER

1 or more errors Prevent IMPORT

:rolleyes:

I know the answer must be obvious, but I haven't started drinking yet today, so I haven't figured out why the spell editor can't find my spell files today when it did just fine yesterday.

Any suggestions on this one? :oops:

Please....?

Ok, your spells_us.txt has some problem with it regarding field count or a extra "^" delimmeter somewhere.
My spellfilehandler (this tool) has an extra copy. If it's knackered, then redownload another copy.

Ti uses 200 fields and SoF has 215 fields

GeorgeS

I noticed the tool will also freak out if you have extra blank lines at the end of the file. If you delete them it fixes it.

Redownload? Ok, thanks. Will downloading again effect any of my new spells added?

Just export a new file from your database.

Not to sound contrary, but I tried that when my server was not connecting. Tried several times to export from Navicat so that my work wasn't wasted.

None of the files were readable. Couldn't source any of them.

The errors hinted at duplicate fields and some -1 values. http://www.freesmileys.org/smileys/smiley-sleep019.gif

At that point, I lose patience.


Edit: however, I now use the backup command function liberally.

You don't use Navicat to export a spell file... There are several spell file utilities available. There's one on Georges web site, you can do it with Null's Spell Editor, and there's a perl script in the utils directory where you downloaded the server source.

As a side note, I've exported and imported tables with Navicat and had no issues. It doesn't dump them in a very efficient manner though. I prefer SQLyog for that.

I would think your back up plan sounds good. When you are ready to export the EQ spell file, then just make copies of the text spell file and the spell table.

I should think your new custom spells are fine. Just import them in as usual.