honestly there isn't much you can do to prevent the multiple queries without complex scripting
most you can do is clean up the "'" with the numbers.
Also personaly I would set the talent to 255 to still keep the block open..
most you can do is clean up the "'" with the numbers.
Also personaly I would set the talent to 255 to still keep the block open..
Code:
update cq_eudemon set talent1=255 where talent1 NOT IN (51,52,53,54,55,192,191,190,255,0); update cq_eudemon set talent2=255 where talent2 NOT IN (51,52,53,54,55,192,191,190,255,0); update cq_eudemon set talent3=255 where talent3 NOT IN (51,52,53,54,55,192,191,190,255,0); update cq_eudemon set talent4=255 where talent4 NOT IN (51,52,53,54,55,192,191,190,255,0); update cq_eudemon set talent5=255 where talent5 NOT IN (51,52,53,54,55,192,191,190,255,0);