How to take off rideing skill and level from mounts

[manager2]

This Guide Will Learn You To Take The Riding Skill And Level From Mounts ! Iv Done It Whit '' Black War Tiger''

1:

2:

3:

4:

5:

6:

7:


Enjoy !

creadis all goto emiloz i did not make this guide emiloz made it this is repost !!

[beileroord]

I have one Query to do this for me I'll share it with you :

This removes all requirements for mounts:
Code:

update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =2411); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =2414); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5655); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5656); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5665); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5668); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5864); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5872); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5873); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =5874); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8563); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8586); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8588); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8591); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8592); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8595); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8629); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8631); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =8632); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12302); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12303); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12330); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12351); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12353); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =12354); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13086); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13317); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13321); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13322); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13325); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13326); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13327); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13328); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13329); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13331); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13332); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13333); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13334); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =13335); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =15277); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =15290); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =15292); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =15293); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18241); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18242); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18243); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18244); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18245); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18246); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18247); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18248); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18766); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18767); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18772); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18773); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18774); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18776); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18777); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18778); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18785); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18786); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18787); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18788); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18789); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18790); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18791); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18793); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18794); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18795); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18796); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18797); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18798); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =18902); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =19029); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =19030); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =19872); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =19902); 
update items set buyprice = 4000000, sellprice = 800000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =21176); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =21218); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =21321); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =21323); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =21324); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25470); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25471); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25472); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25473); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25474); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25475); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25476); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25477); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25527); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25528); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25529); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25531); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25532); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =25533); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =28481); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =28915); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =28927); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =28936); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29102); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29103); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29104); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29105); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29220); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29221); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29222); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29223); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29224); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29227); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29228); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29229); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29230); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29231); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29465); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29466); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29467); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29468); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29469); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29470); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29471); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29472); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29743); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29744); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29745); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29746); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =29747); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =30480); 
update items set sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =30609); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31829); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31830); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31831); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31832); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31833); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31834); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31835); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =31836); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32314); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32316); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32317); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32318); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32319); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32458); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32768); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32857); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32858); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32859); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32860); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32861); 
update items set allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =32862); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33224); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33225); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33176); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33182); 
update items set buyprice = 2000000, sellprice = 400000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33184); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33183); 
update items set buyprice = 100000, sellprice = 20000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33976); 
update items set buyprice = 1000000, sellprice = 200000, allowableclass = -1, allowablerace = -1, itemlevel = 0, requiredlevel = 0, requiredskill = 0, requiredskillrank = 0 where (entry =33977)

also found it somewhere

[manager2]

lol
nice!!
thank you for sheareing it with me

[jlhkgjfhd]

that cool much needed thats guys "[+rep]"

[XC4T4LY5TX]

omg lol thank you! ive been looking for this lol +rep

[latruwski]

i posted that query also long time ago... people should use search more often

grtz

[manager2]

Really sry dude i posted it from emiloz so i did not give u credis coz i nerver new that u posted it i'll put credits in there for u in just a sec