Sitemizden Yararlanmak İçin

Sitemize Üye Olmalısınız

or Kayıt ol
Server Tanitimi , Ko Tanitimi , Silkroad Pvp Serverler , Metin2 Pvp Serverler

Db 'Den Tek Kodla +1 +2 +3 +4 +5 Takıları Silme

[XFB] Konu Bilgileri

Konu Hakkında Merhaba, tarihinde Knight Online Pvp Prosedür & Kod Paylaşımları kategorisinde Stark tarafından oluşturulan Db 'Den Tek Kodla +1 +2 +3 +4 +5 Takıları Silme başlıklı konuyu okuyorsunuz. Bu konu şimdiye dek 1,201 kez görüntülenmiş, 1 yorum ve 0 tepki puanı almıştır...
Kategori Adı Knight Online Pvp Prosedür & Kod Paylaşımları
Konu Başlığı Db 'Den Tek Kodla +1 +2 +3 +4 +5 Takıları Silme
Konbuyu başlatan Stark
Başlangıç tarihi
Cevaplar
Görüntüleme
İlk mesaj tepki puanı
Son Mesaj Yazan Stark

Stark

K.Destek Yöneticisi
Katılım
27 May 2013
Mesajlar
2,664
Tepkime puanı
15
Puanları
38
Selamlar Buyrun
smile.gif








Örnek ; Database den isminde +3 veya +4 geçen ve slotları takı slotları olan itemleri siliyoruz ..









Kod:

DELETE FROM ITEM WHERE STRNAME Like '%(+4)%' and slot = '11'

DELETE FROM ITEM WHERE STRNAME Like '%(+4)%' and slot = '14'

DELETE FROM ITEM WHERE STRNAME Like '%(+4)%' and slot = '12'

DELETE FROM ITEM WHERE STRNAME Like '%(+4)%' and slot = '10'

DELETE FROM ITEM WHERE STRNAME Like '%(+5)%' and slot = '11'

DELETE FROM ITEM WHERE STRNAME Like '%(+5)%' and slot = '14'

DELETE FROM ITEM WHERE STRNAME Like '%(+5)%' and slot = '12'

DELETE FROM ITEM WHERE STRNAME Like '%(+5)%' and slot = '10'

Bu Şekilde +4 Ve +5 Olan Tüm takıları DB Den kaldırdık..







Yazıdaki Mavi Kısımları değiştiğinizde o + daki Takıları silecektir..







Umarım Faydalı olmuştur. Arayan çok kişi gördüm.
 

Stark

K.Destek Yöneticisi
Katılım
27 May 2013
Mesajlar
2,664
Tepkime puanı
15
Puanları
38
Tekrar Eklemek İçin Arkadaşlar Ancak 3 4 item eksik dbmde yoktu buyrun
smile.gif










Kod:

Insert Into [ITEM] Values (320310414,'Iron Necklace(+4) ',92,11,0,0,0,100,0,0,1,640,0,0,0,0,0,1,99,0,0,0,0 ,0,0,0,0,4,0,0,15,15,15,15,15,15,0,0,0,0,0,0,0,0,0 ,15,40,0,0,0,0,0,0,0,0,0,0,0)

Insert Into [ITEM] Values (330620434,'Ring of the Felankor(+4) ',93,12,0,0,0,100,0,0,1,640,0,75,0,0,0,1,99,0,0,0, 0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,24 ,24,24,24,24,150,150,45,0,0,0,0,0)

Insert Into [ITEM] Values (340410164,'String of Skulls(+4) ',94,14,0,0,0,100,0,0,1,640,0,18,0,0,0,1,99,0,0,0, 0,0,0,0,0,4,50,0,13,0,13,0,13,0,0,0,0,0,0,0,0,0,0, 21,21,0,0,0,0,0,0,45,0,0,0,0)

Insert Into [ITEM] Values (340410454,'Skeleton Belt(+4) ',94,14,0,0,0,100,0,0,1,640,0,40,0,0,0,1,99,0,0,0, 0,0,0,0,0,4,50,0,15,0,15,0,15,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,45,0,0,0,0)

Insert Into [ITEM] Values (330930624,'Imir Ring(+4) ',93,12,0,0,0,100,0,0,1,640,0,45,0,0,0,1,99,0,0,0, 0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15 ,15,0,15,0,0,20,20,0,0,0,0)

Insert Into [ITEM] Values (310514164,'Lillimes Enticement(+4) ',91,10,0,12,0,100,0,0,1,640,0,10,0,0,0,60,99,0,0, 0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,15 ,15,0,0,0,160,0,25,25,0,45,0,0)

Insert Into [ITEM] Values (310512144,'Howling Rooster(+4) ',91,10,0,8,0,100,0,0,1,640,0,10,0,0,0,60,99,0,0,0 ,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,19,0,0,160,0,25,25,0,0,0,0)

Insert Into [ITEM] Values (310511134,'Minotaurs Earring(+4) ',91,10,0,6,0,100,0,0,1,640,0,10,0,0,0,60,99,0,0,0 ,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,19, 0,0,0,0,180,0,25,25,0,0,0,0)

Insert Into [ITEM] Values (310513154,'Lich Kings Pride(+4) ',91,10,0,10,0,100,0,0,1,640,0,10,0,0,0,60,99,0,0, 0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 15,0,0,5,160,150,25,25,0,25,0,0)

Insert Into [ITEM] Values (330151454,'Legionnaire Band(+4) ',93,12,0,0,0,100,0,0,1,640,0,55,0,0,0,1,99,0,0,0, 0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 22,21,0,0,150,130,35,45,0,0,0,45)

Insert Into [ITEM] Values (330111444,'Heros Valor(+4) ',93,12,0,0,0,100,0,0,1,640,0,35,0,0,0,1,99,0,0,0, 0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,22 ,19,0,0,0,150,0,65,25,0,0,0,45)

Insert Into [ITEM] Values (330920614,'Shio Tears(+4) ',93,12,0,0,0,100,0,0,1,640,0,45,0,0,0,1,99,0,0,0, 0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,1 5,15,0,15,0,0,20,35,0,0,0,0)

Insert Into [ITEM] Values (330910604,'Flame Ring(+4) ',93,12,0,0,0,100,0,0,1,640,0,45,0,0,0,1,99,0,0,0, 0,0,0,0,0,4,0,0,0,0,0,0,0,0,90,0,0,0,0,0,0,0,0,0,1 5,15,0,15,0,0,35,20,0,0,0,0)

Insert Into [ITEM] Values (330150314,'Ring of Magic(+4) ',93,12,0,0,0,100,0,0,1,640,0,65,0,0,0,1,99,0,0,0, 0,0,0,0,103,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 21,0,0,21,0,150,0,35,0,0,0,45)

Insert Into [ITEM] Values (310410264,'Secret-Silver Earring(+4) ',91,10,0,0,0,100,0,0,1,640,0,45,0,0,0,1,99,0,0,0, 0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,30 ,0,0,0,0,0,0,0,0,0,0,0)

Insert Into [ITEM] Values (330610394,'Silver Ring(+4) ',93,12,0,0,0,100,0,0,1,640,0,20,0,0,0,1,99,0,0,0, 0,0,0,0,0,4,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, 0,0,0,0,150,30,0,0,0,0,35)

Insert Into [ITEM] Values (340610374,'Iron Belt(+4) ',94,14,0,0,0,100,0,0,1,640,0,60,0,0,0,1,99,0,0,0, 0,0,0,0,0,4,0,0,15,15,15,15,15,15,0,0,0,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,0,0)
 
Üst
Silkroad Serverler