Updated Tool - EqItems Item Editor

[GeorgeS]

Newest version is a big update.

I decided to include TABLE editing of items as an option now. Click on button "Grid Item Edit" to show the form and then you must execute the query. You can copy and delete items. You can also run any simple one line query as well (use only SELECT FROM type queries). The sql that's shown in the text box approximates what you selected.


- 13.5.0 - You can now edit items in a Table/Grid - Click on button "Grid Item Edit" and execute query. All edits are LIVE!. Fixed misc issues related to the new editing.


GeorgeS

[ChaosSlayer]

George - it seems as of late i lost the ability to drag items from top display window into inventory of a player.
I can drag item over a slot which allreday has an item to replace it, but not into an empty slot.

Also soemthing weird still going with colors. Soem sort of inconsistency.
For exmaple i have an item with some color X, and some color of color Y.
I am goign directly into item fields, into color field copying off the number, and then inserting this number into item Y color field. Hit enter, reload- the window on display STILL shows old item color....

I am still playign around with it, but for the future I think you shoudl also add the field editing for original eq number as well so I can directly copy/paste colors betwen items wihout using the color selection.




Another general thing- the item ICON # which is shown when you move cursor over item display, could you also have value of "IDfile" field to be displayed next to it- that woudl very helpfull (refernce to how thsi item looks in game)



few notes of future posible things - more with editign char itself:
ability to fully edit charactor itself: race, class, stats and deyty

[GeorgeS]

Ok fixed those issues. Minor bug fixes. I will consider editing the character in a future release as it requires blob field editing, and it's not often you can change class.

Editing items in table view requires you to move between fields for it to stick. In quick edit (single line per item view) just hitting enter suffices.


GeorgeS

[ChaosSlayer]

All is working perfect now =)
Thank You =)
Would you consider adding an aditional window to coloring simular to the one liek in game? Where it would have 3 scrollbars which can be scrolled in decimal mode 0 to 255 for RBG? Like the one in game. It seems that "cube" is missing some of the more darker colors

thanks again =)

[sesmar]

I was just trying to download the source for your tools and I am getting a File not found error. I just wanted to let you know.

[Aramid]

George,

First, let me say Thank You for all the work you have done with your Emu Tools. They are Fantastic....

One thing I have found. In the item Editor, if you place an item on your toon that has a clicky effect, it says it's out of charges. For Instance. I drag & dropped a set of Fabled Journeyman's Boots on my toon and when I right click on it, it says it is out of charges. The item is clickable at level 1 so it's has nothing to do with the toons level.
Now, if I spawn an NPC and have them drop the same item as the loot, the clicky works just fine. I've done this on 2 different toons with the same result. See if you can duplicate this on your server.
This is on your latest version as of today.

Thanks again.

[GeorgeS]

- 13.5.2 - Enhanced color editing by adding interactive sliders. All color changes must be applied to be saved as normal.

Fixed it so my server will allow source.zip to download now - thnkx for the trouble report!

Now with item charges - this has be baffled. When one spawns the boots in game, where in the items table do you get the max charges from? The boots show maxcharges to be -1 in the field - what's that decode to? - is that something like 255 charges?

I realise that value then gets put into the toons inventory table. No problem there. Once I know about the max charges, then I will code that it tuesday...

GeorgeS

Originally Posted by Aramid

George,

Originally Posted by Aramid

First, let me say Thank You for all the work you have done with your Emu Tools. They are Fantastic....

One thing I have found. In the item Editor, if you place an item on your toon that has a clicky effect, it says it's out of charges. For Instance. I drag & dropped a set of Fabled Journeyman's Boots on my toon and when I right click on it, it says it is out of charges. The item is clickable at level 1 so it's has nothing to do with the toons level.
Now, if I spawn an NPC and have them drop the same item as the loot, the clicky works just fine. I've done this on 2 different toons with the same result. See if you can duplicate this on your server.
This is on your latest version as of today.

Thanks again.

[ChaosSlayer]

George,
-1 means UNLIMITED charges
0 - well zero =) items usualy don't start with 0 zero, but may eventualy reach this

any other number above 0 are the actual number of charges. usualy potiosn have 1,5, or 10 charges, and soem old world items had some X number of charges on them

[trevius]

Added note:

If you set a clickie item to 0 charges and click it, the item will vanish.

Bug?:
For some reason with the latest download as of right now, even after I register the OCX like normally, if I click on the grid editor, it says that MSDATGRD.OCX isn't registered. Also, I am now able to edit the all/all (previously misc) items and copy them, which used to crash the program for me. But, now when I am trying to change the name of the item and click another field or hit enter for it to stick, the program crashes. I will keep messing with it to see if I can get it running properly.

Thanks again for all of your work GeorgeS! I don't know where we would be without you!

[ChaosSlayer]

Originally Posted by trevius

Added note:

If you set a clickie item to 0 charges and click it, the item will vanish.

this one is a bug in emulator itself. The emulator at this time cannot tell diffirence between a consumeable potions which supose to "poof" when it reaches 0 charges and a normal item with 0 charges

[GeorgeS]

Thanks for the maxcharges info. Now when you aquire the item, the charges are saved in inventory in field charges (I presume). So that seems simple. But if an item has infinite charges, what value goes in that field. It is an unsigned int, so no negatives are allowed. I'm a bit puzzled here.

I'm trying to make it so charges are editable in the editor.

GeorgeS

[ChaosSlayer]

acording to DB maxcharges declared as:

maxcharges int(11) NOT NULL default '0'

and yeah -1 should be a legal value since otherwise item won't have unlimited charges

[ChaosSlayer]

in inventory table :
`charges` tinyint(3) unsigned default '0'

I just looked at my char who has soem clicky items and items with unlimited charges listed as havign 255 charges which is prabobly substitute for unlimited

[GeorgeS]

Originally Posted by ChaosSlayer

in inventory table :

Originally Posted by ChaosSlayer

`charges` tinyint(3) unsigned default '0'

I just looked at my char who has some clicky items and items with unlimited charges listed as havign 255 charges which is prabobly substitute for unlimited

Correct -I put in 255 and the item then gets unlimited charges - just checked on my server. Added a potion of 10 charges and it worked in game as well. Newest version has the updated code for charges. If you have trouble with the OCX, register it via my register_ocx.bat.

GeorgeS

[Telltolin]

I love this tool, but I hate the interface. I would love it even more if it ran in a normal window.