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