Updated Tool - EqItems Item Editor - Page 9

iggi · #**121** 02-04-2008, 05:46 PM

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

Quote:

"Run-time error '-2147217871 (80040e31)' : field 'UNK132' doesn't have a default value"

moydock · #**122** 02-04-2008, 10:41 PM

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?

**GeorgeS** · #**123** 02-05-2008, 03:14 AM

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]

iggi · #**124** 02-05-2008, 08:56 AM

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

iggi · #**125** 02-05-2008, 09:02 AM

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.

moydock · #**126** 02-05-2008, 11:52 AM

Anyone having luck with changing colors?

**GeorgeS** · #**127** 02-05-2008, 03:43 PM

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

moydock · #**128** 02-05-2008, 04:21 PM

Okay cool, thanks George.

iggi · #**129** 02-06-2008, 08:33 AM

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

**trevius** · #**130** 02-06-2008, 02:41 PM

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.

iggi · #**131** 02-07-2008, 05:27 AM

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.

ChaosSlayer · #**132** 02-07-2008, 06:38 AM

Quote:

Originally Posted by iggi

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?

moydock · #**133** 02-07-2008, 03:03 PM

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

.

**GeorgeS** · #**134** 02-07-2008, 03:36 PM

- 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

**GeorgeS** · #**135** 02-07-2008, 04:21 PM

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