color in the items table

[GeorgeS]

Use this program from my site to get the RGB (F6 copies HEX value)
the use as mentioned before ColourNum = Red * 2^16 + Green * 2^8 + Blue

http://66.159.225.58/eqemu/ColorDetector.zip

George

[fathernitwit]

you can put the RGB hex values directly into mysql with 0x:

0xAARRGGBB
AA = alpha (transparency)
RR = reg
GG = green
BB = blue
in hex.

eg:
UPDATE items SET color=0xFFFF0000 WHERE id=1001;
should turn the cloth cap red.

I think you want to have an alpha of FF for solid colors (00 is completely transparent I think)... not sure though.

somebody should put this on the wiki.