EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Development::GeorgeS's Tools (https://www.eqemulator.org/forums/forumdisplay.php?f=674)
-   -   Updated Tool - EqItems Item Editor (https://www.eqemulator.org/forums/showthread.php?t=21442)

iggi 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 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 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 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 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 02-05-2008 11:52 AM

Anyone having luck with changing colors?

GeorgeS 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 02-05-2008 04:21 PM

Okay cool, thanks George.

iggi 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 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 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 02-07-2008 06:38 AM

Quote:

Originally Posted by iggi (Post 142901)
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 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 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 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


All times are GMT -4. The time now is 03:48 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.