an easy query?

[eqemuross]

is there an easy query to make all weapons no drop?

[Rogean]

update items set nodrop = 0 where damage > 0;

[eqemuross]

update items set nodrop = 0 where damage > 0;

Thanks Rogean!