- Katılım
- 24 Ağu 2023
- Mesajlar
- 323
- Çözümler
- 4
- Tepkime puanı
- 26
- Puanları
- 0
arkadaşlar 1299 jpko database kullanıyorum scroll NPC ekledim maradona aşağıdaki gibi itemleri kontrol ettim hepsinin DB de sellinggrup 205 dogru item_org_us'u da editledim 205 olarak fakat speed potion harici digerleri çekilmiyor DB de itemsell tabloda yok nerden halledecegim 2014 uyumlu db indirdim 7-8 tane hiç birinde o tablo yok tuhafıma giden birde item_org_us 35'e kadar 36'ncı satır yok sundures kayıtları filan hep 35 de kayıtlı denemediğim bir o ile birde itemsell tablosu kaldı yardımcı olacak varmı sorun neyden kaynaklanıyor olabilir
DELETE FROM K_NPC WHERE sSid = 27004
DELETE FROM K_NPCPOS WHERE npcid = 27004
INSERT INTO K_NPC VALUES(27004,'Scroll Satıcısı',19005,160,0,0,1,7,22,1,0,1,205000,50,0,0,30000,0,0,7500,335,325,3000,1500,2,5,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,25,0,27004,0,0,1)
insert into K_NPCPOS values (21,27004,100,0,0,0,0,850,608,850,608,850,608,850,608,1,90,0,0,NULL)
update ITEM set sellinggroup = 205 where Num = EKLEMEK İSTEDİĞİMİZ İTEM'in Num'u
update ITEM set sellinggroup = 205 where Num = 800015000 ;Speed-Up Potion update ITEM set sellinggroup = 205 where Num = 800014000 ;Scroll of Attack update ITEM set sellinggroup = 205 where Num = 800021000 ;Scroll of teleport friend update ITEM set sellinggroup = 205 where Num = 800006000 ;Scroll of inteligence(L) update ITEM set sellinggroup = 205 where Num = 800010000 ;Scroll of Armor 300 update ITEM set sellinggroup = 205 where Num = 800008000 ;Scroll of Lion Strength(L) update ITEM set sellinggroup = 205 where Num = 800005000 ;Scroll of Dexterity (L) update ITEM set sellinggroup = 205 where Num = 800013000 ;HP scroll 1500 update ITEM set sellinggroup = 205 where Num = 800003000 ;Scroll of Strength(L) update ITEM set sellinggroup = 205 where Num = 800007000 ;Scroll of Magic power update ITEM set sellinggroup = 205 where Num = 800004000 ;Scroll of Health(L)
DELETE FROM K_NPC WHERE sSid = 27004
DELETE FROM K_NPCPOS WHERE npcid = 27004
INSERT INTO K_NPC VALUES(27004,'Scroll Satıcısı',19005,160,0,0,1,7,22,1,0,1,205000,50,0,0,30000,0,0,7500,335,325,3000,1500,2,5,1000,0,0,0,100,100,100,100,100,100,100,90,7,14,25,0,27004,0,0,1)
insert into K_NPCPOS values (21,27004,100,0,0,0,0,850,608,850,608,850,608,850,608,1,90,0,0,NULL)
update ITEM set sellinggroup = 205 where Num = EKLEMEK İSTEDİĞİMİZ İTEM'in Num'u
update ITEM set sellinggroup = 205 where Num = 800015000 ;Speed-Up Potion update ITEM set sellinggroup = 205 where Num = 800014000 ;Scroll of Attack update ITEM set sellinggroup = 205 where Num = 800021000 ;Scroll of teleport friend update ITEM set sellinggroup = 205 where Num = 800006000 ;Scroll of inteligence(L) update ITEM set sellinggroup = 205 where Num = 800010000 ;Scroll of Armor 300 update ITEM set sellinggroup = 205 where Num = 800008000 ;Scroll of Lion Strength(L) update ITEM set sellinggroup = 205 where Num = 800005000 ;Scroll of Dexterity (L) update ITEM set sellinggroup = 205 where Num = 800013000 ;HP scroll 1500 update ITEM set sellinggroup = 205 where Num = 800003000 ;Scroll of Strength(L) update ITEM set sellinggroup = 205 where Num = 800007000 ;Scroll of Magic power update ITEM set sellinggroup = 205 where Num = 800004000 ;Scroll of Health(L)