Aslında birşeyler paylaşmayı düşünmüyordum eski HDD'm elime geçti geçmişken temizliyim dedim bu yazdığğım ufak koda rastladım



Aslında çok basit bir kod ama paylaşım işte emeğe saygı duymak gerekir :-:

Ayrıca bu Moblar zaten V1 ve v2 Dbmde zaten bulunuyordu fakat paylaşmamıştım bir arkadaş paylaşmıştı oda dbden altığı için item den satır almayı unutmuş onada burdan selamar.



Beğendiyseniz Bir Teşekkür yeter.



Monsterlar Düzgün ayarlanmıştır.

Drop eklenebilir veya değiştirilebilir.

Npcpos dikkatlice yapılmıştır.






Kod:
--Made By TheGameGuard at 02.02.2009----
delete from k_monster where ssid = 115
delete from k_monster where ssid = 209
delete from k_monster where ssid = 519
delete from k_monster where ssid = 807
delete from k_monster where ssid = 756
delete from k_monster where ssid = 258

INSERT INTO [k_monster] Values (115,'Kecoon   King',100,320,140250000,0,0,1,0,100,0,0,0,30,1,0,1108,1351,0,204,28,69,83,1500,2,3,5000,115,115,0,0,0,45,45,48,33,45,45,45,70,5,5,45,0,0,0)
INSERT INTO [k_monster] Values (209,'Bulcan   Queen',200,350,0,0,0,5,0,100,0,0,0,17,1,0,1000,489,5,20,10,17,22,1800,2,3,5000,209,203,0,0,0,36,36,36,21,36,36,36,100,5,5,45,0,0,0)
INSERT INTO [k_monster] Values (519,'Lycan   Queen',500,200,190450000,0,0,5,0,100,0,0,0,33,1,0,2500,1631,0,224,34,82,104,1500,5,5,5000,519,505,0,0,0,49,49,49,36,49,49,49,175,5,5,60,0,0,0)
INSERT INTO [k_monster] Values (807,'Bandicot   Queen',800,254,0,0,0,1,0,8,0,100,0,100,1,0,1000,34,1,25,1,1,4,2000,3,3,1500,807,800,0,0,0,20,20,20,20,20,9,9,85,5,3,40,0,0,0)
INSERT INTO [k_monster] Values (756,'Worm   King',700,400,0,0,0,1,0,100,0,0,0,100,1,0,1000,120,0,31,3,4,6,2000,2,4,1000,756,754,0,0,0,18,18,18,13,18,18,18,75,5,3,40,0,0,0)
INSERT INTO [k_monster] Values (258,'Shilan   King',210,185,0,0,0,5,0,100,0,0,0,100,1,0,1000,1000,0,104,14,22,50,1800,2,3,5000,258,0,0,0,0,22,22,22,22,22,22,22,100,3,5,30,0,0,0)



delete from k_npcpos where npcid = 756 
delete from k_npcpos where npcid = 807
delete from k_npcpos where npcid = 519
delete from k_npcpos where npcid = 209
delete from k_npcpos where npcid = 115
delete from k_npcpos where npcid = 258
INSERT INTO [k_npcpos] Values (21,756,1,0,0,0,0,246,272,246,272,246,272,246,272,1,44,0,3,null)
INSERT INTO [k_npcpos] Values (21,807,1,0,0,0,0,196,314,196,314,196,314,196,314,1,44,0,3,null)
INSERT INTO [k_npcpos] Values (21,519,1,0,0,0,0,94,244,94,244,94,244,94,244,1,44,0,3,null)
INSERT INTO [k_npcpos] Values (21,209,1,0,0,0,0,182,188,182,188,182,188,182,188,1,44,0,3,null)
INSERT INTO [k_npcpos] Values (21,115,1,0,0,0,0,158,182,158,172,158,172,158,172,1,44,0,3,null)
INSERT INTO [k_npcpos] Values (21,258,1,0,0,0,0,106,86,106,86,106,86,106,86,1,44,0,3,null)

delete from k_monster_item where sindex = 756 
delete from k_monster_item where sindex = 807
delete from k_monster_item where sindex = 519
delete from k_monster_item where sindex = 209
delete from k_monster_item where sindex = 115
delete from k_monster_item where sindex = 258
INSERT INTO [k_monster_item] Values (756,0,10000,0,10000,0,10000,0,10000,0,10000)
INSERT INTO [k_monster_item] Values (807,0,10000,0,10000,0,10000,0,10000,0,10000)
INSERT INTO [k_monster_item] Values (519,0,10000,0,10000,0,10000,0,10000,0,10000)
INSERT INTO [k_monster_item] Values (209,0,10000,0,10000,0,10000,0,10000,0,10000)
INSERT INTO [k_monster_item] Values (115,0,10000,0,10000,0,10000,0,10000,0,10000)
INSERT INTO [k_monster_item] Values (258,0,10000,0,10000,0,10000,0,10000,0,10000)
Kullanımı ...



1 Başlat > Tüm Programlar > Microsoft SQL Server > Query Analyzer ‘ a giriyoruz.

2 SQL Server’ a bağlanıyoruz ve açılan ekranda ” master ” yerine ” DBmizi ” seçiyoruz.

3 Seçtikten sonra aşağıdaki kodu kopyalayıp , yapıştırıyoruz ve F5 yaparak kodumuzu uyguluyoruz.





Alıntıdır