•         

            

            

            

  • HyperFilter | DoS Protection | DDoS Protection | DoS Mitigation | DDoS Mitigation | AntiDoS | AntiDDoS | Proxy Shielding

[Code] Vendor Exploit Fix For Myko

bigahega

bigahega

Administrator
Yönetici
KoCuce.Com
Katılım
7 Mart 2012
Mesajlar
12,842

magew.jpg


This is an issue i find almost all database has it people wont bother to fix , vendors can sell every item to +1 from 10+ this is quite a big exploit. i fix it now only +1 and +0 items only thing you can buy from vendor

With these codes +2 to +10 items blocked from buying database side works best with




Kod: 
--daggers
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '11'
--swords
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '21'
--2h swords
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '22'
--axes
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '31'
--2h axes
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '32'
--maces
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '41'
--2h maces
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '42'
--spears
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '51'
--2h spears
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '52'
--bows
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '70'
--xbows
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '71'
--shields
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '60'
--staves
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '110'
--armor 1
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '210'
--armor 2
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '220'
--armor 3
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '230'
--armor 4
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='201' AND ItemType LIKE '5' AND Kind LIKE '240'
-------------------------------
-------------------------------
-------------------------------
--daggers
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '11'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '11'
--swords
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '21'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '21'
--2h swords
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '22'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '22'
--axes
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '31'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '31'
--2h axes
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '32'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '32'
--maces
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '41'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '41'
--2h maces
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '42'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '42'
--spears
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '51'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '51'
--2h spears
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '52'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '52'
--bows
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '70'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '70'
--xbows
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '71'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '71'
--shields
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '60'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '60'
--staves
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '110'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='101' AND ItemType LIKE '5' AND Kind LIKE '110'
-------------------------------
-------------------------------
-------------------------------
--armor 1
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '210'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '210'
--armor 2
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '220'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '220'
--armor 3
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '230'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '230'
--armor 4
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+2%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+3%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+4%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+5%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+6%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+7%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+8%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+9%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '240'
UPDATE ITEM SET SellingGroup='0' WHERE strName LIKE '%+0%' AND SellingGroup='202' AND ItemType LIKE '5' AND Kind LIKE '240'
 

Online istatistikleri

Çevrimiçi kullanıcılar
437
Çevrimiçi ziyaretçiler
2,532
Toplam ziyaretçi
2,969
Toplamlar, gizli ziyaretçiler içerebilir.

Ko-Cuce Links

En yeni üyeler

KoCuce Sosyal

Geri
Üst