Item Levels

[Pretentious]

I've made a few threads today, and each time I've gotten responses, for which I am thankful.

Anyone happen to know of a query I could run through my DB that would set the item requirements on all items to 0?

Just want to completely remove the item requirements for levels.

Thanks.

Edit: Also, would just dropping the column and making another one with the same name cause stability issues?

[ChaosSlayerZ]

I would suggest NOT dropping any columns =)
I know some sql expert use that trick but its better set it to something than have a potential headache later on if you screw up something.

As far as setting lev to 0:

update items set reqlevel=0;

[Pretentious]

Awesome, thanks a ton!

Ugh, a year ago I would have known that, but since the WoW servers, I have given up on SQL.

/bonk.