ko cuce                                      ko cuce

ko cuce                                      ko cuce

ko cuce                                      ko cuce

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

[XFB] 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,158 kez görüntülenmiş, 4 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 flesk

kocuce

Admin
Yönetici
Site Yetkilisi
Normal Üye
The XtremE
Katılım
6 Ağu 2019
Mesajlar
226
Tepkime puanı
564
Online Süresi
1h 59m
Puanları
93
Ofline
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...

 

groys

Yeni Üye
Normal Üye
Katılım
10 Eyl 2019
Mesajlar
997
Tepkime puanı
8
Online Süresi
5m
Puanları
18
Yaş
25
Ofline
TEŞEKKÜRLERRRRRRRRRRRRRRRRRRRRRRR
 

PainS

Yeni Üye
Normal Üye
Katılım
5 Kas 2019
Mesajlar
181
Tepkime puanı
0
Online Süresi
0
Puanları
0
Yaş
30
Ofline
TEŞEKKÜRLERRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
 

flesk

Yeni Üye
Normal Üye
Katılım
21 Ara 2019
Mesajlar
12
Tepkime puanı
0
Online Süresi
0
Puanları
0
Yaş
31
Ofline
tesekkürler
 
Üst