View Single Post
  #5  
Old 07-24-2007, 03:30 PM
Strake
Sarnak
 
Join Date: Jul 2007
Posts: 37
Default

heh, no stackers left on my server.

SELECT * FROM eqemu.inventory WHERE augslot1 > 0 OR augslot2 > or OR augslot3 > 0 OR augslot4 > 0 OR augslot5 > 0;

and then

UPDATE eqemu.inventory SET augslot1=0, augslot2=0, augslot3=0, augslot4=0, augslot5=0;

and that one will remove ALL stacked items and turn them to normal. =p
Reply With Quote