Declare @Var varbinary(50)
Set @Var=0x000000
select cast(@Var as bigint)
update rohangame.dbo.titem
set attr =@Var
where type='itemid #' and char_id='playerid #'
that is the sql statement to modify the attr column as i have been using it
i may go ahead and write up an application/php script to make it easier on myself on remembering the hex values. if i do i will release it for you guys