Foruma hoş geldin, Ziyaretçi

Forum içeriğine ve tüm hizmetlerimize erişim sağlamak için foruma kayıt olmalı ya da giriş yapmalısınız. Foruma üye olmak tamamen ücretsizdir.

Giriş yap Şimdi kayıt ol

Satıcı Npclerin Bugu Myko için Fix Exploit

Konu Bilgileri

Konu Hakkında Merhaba, tarihinde Genel Paylaşımlar kategorisinde kocuce tarafından oluşturulan Satıcı Npclerin Bugu Myko için Fix Exploit başlıklı konuyu okuyorsunuz. Bu konu şimdiye dek 6,985 kez görüntülenmiş, 5 yorum ve 0 tepki puanı almıştır...
Kategori Adı Genel Paylaşımlar
Konu Başlığı Satıcı Npclerin Bugu Myko için Fix Exploit
Konbuyu başlatan kocuce
Başlangıç tarihi
Cevaplar
Görüntüleme
İlk mesaj tepki puanı
Son Mesaj Yazan engin35
kocuce

kocuce

Kayıtlı Üye
Katılım
6 Ağu 2019
Mesajlar
235
Tepkime puanı
823
Puanları
93
E36eqf.jpg
​
Merhaba Arkadaşlar Bu BUG hemen hemen tüm veritabanı Varolan bir sorun , satıcılar her itemi +10 dan + 1'e satabilir bu oldukça büyük bir istismar. Şimdi sadece +1 ve +0 öğelerini satıcıdan satın alabileceğiniz tek şeyi düzeltiyorum
Bu kodlarla +2 ila +10 maddelere veri tabanı satın almaları engellenmiştir
Satıcı Myko için Fix Exploit
[HIDE-THANKS][/HIDE-THANKS][HIDE-THANKS]
[HIDE-POSTS=25]
SQL: 
--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'

[/HIDE-POSTS]
[/HIDE-THANKS]
ALINTIDIR...

 
P

PainS

Kayıtlı Üye
Katılım
5 Kas 2019
Mesajlar
180
Tepkime puanı
0
Puanları
0
Yaş
33
TEŞEKKÜRLERRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
 
Cevap yazmak için giriş yap yada kayıt ol.

Forumdan daha fazla yararlanmak için giriş yapın yada üye olun!

Forumdan daha fazla yararlanmak için giriş yapın veya kayıt olun!

Kayıt ol

Forumda bir hesap oluşturmak tamamen ücretsizdir.

Şimdi kayıt ol
Giriş yap

Eğer bir hesabınız var ise lütfen giriş yapın

Giriş yap
+++---yyzzhhe tarzı Yorum Yazanlar Ko cuce Yönetimi Tarafından Ban Atılacaktır

Konuyu görüntüleyenler

Toplam: 2 (Kullanıcı: 0, ziyaretçi: 2)