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

[Stark]

Selamlar Buyrun

Ö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]

Tekrar Eklemek İçin Arkadaşlar Ancak 3 4 item eksik dbmde yoktu buyrun

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)

 

[Stark]

Selamlar Buyrun

Ö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]

Tekrar Eklemek İçin Arkadaşlar Ancak 3 4 item eksik dbmde yoktu buyrun

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)