Updated Tool - EqItems Item Editor

iggi · #1 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 · #2 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** · #3 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 · #4 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 · #5 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 · #6 02-05-2008, 11:52 AM

Anyone having luck with changing colors?

**GeorgeS** · #7 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 · #8 02-05-2008, 04:21 PM

Okay cool, thanks George.