I have one bug to report,when I try to create multiple copies or a single copy it gives me

Sweet George, thanks for the update on color. However! :) There's something not working right about it. I change a color on a robe, hit the button to update it to the DB, reboot the server, and the color doesn't change. Instead, when I put the robe on, the color I chose shows up for a split second, and then it turns back to the original color. How this is happening i'm pretty perplexed... The color it changes to isn't even the base texture of the robe, it's the previous color the robe was. Which made me think the server is somehow not refreshing it's memory. So i rebooted both my client computer and the server completely. Still the same result. I'm clueless here, can you make any sense of it?

There must be an empty or NULL in field UNK132 in your DB. Check that first. All UNKxxx fields must not be NULL. Also, I do not have a field called UNK132, but that shouldn't matter.

GeorgeS

[quote=iggi;142813]I have one bug to report,when I try to create multiple copies or a single copy it gives me field 'UNK132' doesn't have a default value" [/quote]

Yeah, sorry GeorgeS, it wasn't a program issue. Apparently that just appeared in my database somehow, here is how I fixed it:

http://eqemulator.net/forums/showthr...d=1#post142849

GeorgeS, is there any reason why there is a 10 second pause every time I change anything on an item? I did a ping to the server and it is <1ms. This doesn't matter weather I hit SET or REM.

Anyone having luck with changing colors?

Ok, fixed the Red and Blue HEX issues - Hex values were swapped for some reason. Bizarre, but I tried making a green, red or blue Robe and it worked in game. Colors of Robes represented the colors I changed it to. Sorry for the confusion. Give the newest release a go.

As to why your queries take a long time to execute - I will see if there's anything in the code to be optimised, but on my laptop, changes are realtime....

GeorgeS

Okay cool, thanks George.

I ran the item editor on my server and it runs fine, it must be a database thing. An idea may be when you edit an item, it constructs/edits a SQL query and then processes it when you ether hit a button or close the window. As for any bugs so far, nothing big, it wont let me change the id or name by manually editing it in the displayed row (it doesn't commit changes) instead I have to use Navicat to edit those. could be an isolated issue (to only me).

Iggi, when you make any changes at the bottom field section when you are editing an item, try hitting tab after you are done entering the name or ID, or any field down there really. Tab or just clicking the blank area below the fields should work. However, if you enter any data and then immediately scroll the window left or right, it will revert the entry back to what it was before. You just need to make sure the box you changed isn't currently being edited before you scroll and it should be fine.

I hit enter after every one, the cursor goes away and everything, it shows the correct ID as I edit the name then I edit the name and they both are correct. I go to edit something else (not by using the manual edit, but by the GUI) and it refreshes and reverts back to the original name and ID.

are you editing NAME in EDIT window or directly in list that shows items found in search?

Thanks George, problem seems to be fixed! A couple more things though - Transparency doesn't seem to be functioning and would it be possible to add the ability to put your own hex colors in? For instance if I wanted grey instead of black I could put in #333333. Thanks, no rush, loving what you've done already :).

- 13.4.6 - You can now change item name on main form and delete items directly without going into the edit panel.

So as you can see, the newest ver. allows editing of item names directly, and ability to delete directly as well. Item id cannot be changed, and fixed it so it no longer allows focus on the cell.


GeorgeS

Before I forget, you can also change the color by inputting your RRGGBB HEX values in. I.e for example FFFFFF = white, FF0000=red, etc..

This was added due to moydock's request. There is a textbox added where you can type this in - click on SET and then write to DB.

Also, I cannot vouch for transparency because this is either a emu bug of Fathernitwits description of this is wrong.

It was described to me as FF FF FF FF, so blue = 0xFF0000FF
let's see what others say


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

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

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

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 =)

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.

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.

- 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

Quote:

Originally Posted by Aramid (Post 143116) George,

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

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!

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

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

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

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

Quote:

Originally Posted by ChaosSlayer (Post 143153) in inventory table :

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

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

I like the interface, easy on the eyes.

George - a minor note on your Grid editor.
It is missing 1 important collumn: the 'type2' collumn which comes from 'grid' tables, and along with 'type' defines pathing behavior.
Which is described in your own guide how to create mob pathing =)

Also, could you please rename the collumns into 'wonder type' (for type) and Pause Type (for type2) so they don't get confused =)

Thanks =)

-as per request, changed the editor to include type2 and renamed the columns as well.

GeorgeS

thank you much George =)

George, there seem to be a problem with chaging name of the item with the last version- the program will crash with an error "incorect variable type"

Give the recent one I just compiled a go.- 13.5.5
I didi not get the error in this version...


- if for whatever reason you still have errors, describe it in detail so I can track it fast.
GeorgeS

all seem in order now- no more crashes with this version
thanks George =)

This is only a minor issue, but when you set no rent to NO it sets the norent field to 255 as it should, but when you set it to YES it set the norent field to 1. Setting it to 1 does not set the item to no rent. It has to set the norent field to 0 for no rent to be enabled.

Thanks, fixed it in the newest version

GeorgeS

hehe i am using a laptop, and the screen doesnt fully load on my computer, anyway you can make it smaller?