Armor Color

Ueguvil · #1 07-03-2006, 12:39 PM

No matter what piece I put on, all the armor on my server is the default white color. I thought this was something wrong with the actual emu, but I checked my database, and for some reason all my items were indeed default white. Is there any easy way to get everything restored to their proper color?

Angelox · #2 07-03-2006, 12:43 PM

I had a problem like this once, and it was my video card - make sure that's not the problem.

Elysius · #3 07-03-2006, 01:13 PM

Quote:

Originally Posted by Angelox

I had a problem like this once, and it was my video card - make sure that's not the problem.

I'm pretty sure that's not the problem, because like I said, the actual color of the items in my database is set to plain white/silver.

tallerin · #4 07-06-2006, 08:04 AM

Its not an issue with your vid card or database. It has something to do with eqemu 7.0 as i just ran into this issue. Color works great on 6.6 797. So if you want color to work go back to 6.6. Or just wait it out and see if it gets resolved wich it is not a major issue so might not get fixed right away as it does not interfear in gameplay any just the color of armour ect.

Scratch that i just compared my 6.6 database to my 7.0 database and the color colums differ alot for the items so that might be the colprit. i don't understand how the color column changed this much updateing the database to 7.0 compatibility might have to spend some time and change some of the values and see if they work but man theres alot of items to change manually heh.

tallerin · #5 07-06-2006, 09:55 AM

found a fix for the color.

you need to alter the color column under the items table not sure if you can just alter one string by itself or not but any ways.

I dropped the items table and resourced a new items table (SQL is floating around in the wikki) BUT the code for the color in the sql needs to be changed.

Quote:

color int(11) NOT NULL default '0',

this is the part that needs to be changed to this

Quote:

color int(10) unsigned NOT NULL default '0',

i tested it on my server useing red fine plate mail that was white/silver before change and it showed red after the changed.

**fathernitwit** · #6 07-08-2006, 07:56 AM

nice catch.

can also throw a "alter table items change color color int(10) unsigned NOT NULL default '0';" at it, and then re-import from 13th floor... I need to check to see if 13th floor import is still working.