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.

  • Dikkat Konulara Cevap yazarken +++ tytb gini saçma kısa ve anlamsız yazı yazanlar Sonsuza denk Ban yiyecektir emeklere saygı.
  • Önemli duyuru! Geçici dosya yükleme sitelerindeki sorunlar nedeniyle, daha kalıcı ve güvenilir siteleri kullanmanızı öneriyoruz. Detaylar için buraya tıklayın.

Ko-cuce
Ko-cuce
Ko-cuce
Ko-cuce
Ko-cuce
Teknoloji Forumu
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 7,535 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
Katılım
6 Ağu 2019
Mesajlar
235
Tepkime puanı
839
Aktiflik Süresi
0
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...

 
Katılım
5 Kas 2019
Mesajlar
183
Tepkime puanı
4
Aktiflik Süresi
0
Puanları
18
Yaş
34
TEŞEKKÜRLERRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRRR
 
Katılım
21 Ara 2019
Mesajlar
14
Tepkime puanı
2
Aktiflik Süresi
0
Puanları
3
Yaş
35
tesekkürler
 

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

Dikkat

SPAM YAPMAK YASAKTIR!
  • Bir başkasının mesajını kopyalayıp aynısını yazmak yasaktır.
  • Bilginiz olmadığı konulara yorum sayınız artsın diye mesaj atmak yasaktır.
  • Yorum yaparken kendi fikrinizi yazınız!
  • Konulara Cevap yazarken +++, tytb gini saçma kısa ve anlamsız yazı yazanlar Sonsuza denk Ban yiyecektir emeklere saygı.

Konuyu görüntüleyenler