- Katılım
- 6 Mayıs 2022
- Mesajlar
- 45,967
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'Vendor Exploit Fix For Myko
Knight Online Private Server dünyasında geliştirme yaparken karşılaşılan en yaygın sorunlardan birisi vendor exploit olarak bilinen güvenlik açığıdır. Özellikle Myko tabanlı sunucularda bu exploit, oyuncuların ürün satış sırasında hile yapmalarına olanak sağlayabilir. Bu yazıda, Myko üzerinde vendor exploit sorununu nasıl çözeceğinizi adım adım anlatacağız.
Vendor Exploit Nedir?
Vendor exploit, oyuncuların bir NPC'ye ürün satarak hatalı sistem tepkilerinden yararlanarak ürünün hem satılmasını hem de envanterde kalmasını sağlayan bir güvenlik açığıdır. Bu durum, sunucu dengesini bozar ve ekonomiyi olumsuz etkileyebilir. Özellikle KO Development süreçlerinde bu tür açıkların erken fark edilmesi büyük önem taşır.
Myko Üzerinde Exploit Fix Uygulaması
Myko tabanlı sunucularda vendor exploit fix uygulamak için öncelikle emulator kaynak kodlarına erişim gereklidir. Bu fix genellikle C++ dilinde yazılmış fonksiyonlarda yapılan küçük ama kritik değişikliklerle sağlanır. Aşağıdaki adımları izlemek, exploitin engellenmesinde etkili olacaktır:
Adım 1: Vendor Paketi Kontrolü[/BR]
Sunucudan gelen vendor paketlerini kontrol eden fonksiyonu güncelleyerek, eksik ya da hatalı paketlerin işlenmemesini sağlayın. Bu işlem genellikle UserVendor.cpp[/BR] dosyasında yapılır.
Adım 2: Eşya Kontrolü[/BR]
Satılan eşyanın gerçekten oyuncuda bulunup bulunmadığını ve envanterin doğru şekilde güncellenip güncellenmediğini kontrol eden fonakları ekleyin. Bu sayede envanter senkronizasyonu sağlanır ve hileli işlemler engellenir.
Adım 3: Loglama Sistemi[/BR]
Tüm vendor işlemleri loglanmalıdır. Bu loglar sayesinde şüpheli hareketler kolayca tespit edilebilir. KO Dev[/BR] sürecinde bu loglar kritik öneme sahiptir.
Fix Uygulandıktan Sonra Ne Yapmalı?[/BR]
Fix uygulandıktan sonra mutlaka test ortamında denemeler yapılmalı. Myko sunucu dosyalarında değişiklik yapıldıktan sonra recompile[/BR] işlemi yapılarak sunucu yeniden başlatılmalıdır. Ayrıca, USKO[/BR] veya ROFD[/BR] tabanlı sunucularda da benzer kontroller yapılmalıdır.
Knight Lobby Üzerinden Geliştirme[/BR]
KnightLobby.com[/BR] olarak bizler, KO Development[/BR] konusunda uzman ekip ile destek sunuyoruz. Myko[/BR] üzerinde çalışan geliştiriciler için özel fixler, modül setleri ve teknik destek sağlıyoruz. KO Source Code[/BR] düzenlemeleri, emulator[/BR] geliştirmeleri ve exploit fix[/BR] süreçleri hakkında detaylı bilgi almak için sitemizi ziyaret edebilirsiniz.
Sonuç[/BR]
Vendor exploit[/BR] gibi güvenlik açıklarını önlemek, Knight Online Private Server[/BR] projelerinizin istikrarı için hayati önem taşır. Myko[/BR] tabanlı sunucularda bu fixlerin uygulanması, hem oyuncu deneyimini artırır hem de sunucu güvenliğini sağlar. Daha fazla KO Development[/BR] kaynağı için KnightLobby.com[/BR] adresini takip edin.
Vendor Exploit Fix For Myko
Knight Online Private Server world often encounters a common issue known as vendor exploit. This vulnerability allows players to abuse the system during item selling processes, especially on servers based on Myko. In this article, we will explain step by step how to fix the vendor exploit issue on Myko.
What is Vendor Exploit?
Vendor exploit refers to a security flaw where players sell items to NPCs but due to incorrect server responses, the item remains in their inventory while also being registered as sold. This disrupts server balance and negatively affects the game economy. Detecting such vulnerabilities early during KO Development phases is highly important.
Implementing Exploit Fix on Myko
To apply a vendor exploit fix on Myko-based servers, you first need access to the emulator source code. The fix usually involves small but critical changes in C++ functions. Follow these steps to prevent the exploit:
Step 1: Vendor Packet Check
Update the function that checks vendor packets coming from the client to prevent processing invalid or malformed packets. This process is generally done inside the UserVendor.cpp file.
Step 2: Item Verification
Add functions to verify whether the item being sold actually exists in the player's inventory and whether the inventory is updated correctly. This ensures proper synchronization and prevents fraudulent transactions.
Step 3: Logging System
All vendor transactions must be logged. These logs allow for quick detection of suspicious activities. During KO Dev processes, these logs are critically important.
After Applying the Fix
After applying the fix, always perform tests in a test environment. After making changes to Myko server files, you should recompile the project and restart the server. Additionally, similar checks should be performed on USKO or ROFD-based servers.
Development Through Knight Lobby
As KnightLobby.com, we offer support with our expert team in KO Development matters. We provide custom fixes, module sets, and technical support for developers working on Myko-based servers. Visit our site for more information about KO Source Code modifications, emulator improvements, and exploit fix procedures.
Conclusion
Preventing security vulnerabilities like vendor exploit is vital for the stability of your Knight Online Private Server projects. Applying these fixes on Myko-based servers improves both player experience and server security. Follow KnightLobby.com for more KO Development resources.
