Selamlar Öncelikle Konu Alıntıdır







Birinci Kodumuz...









Kod:

# DELETE FROM K_NPC WHERE sSid IN(601, 602, 603, 604, 605, 16095, 15012)

# DELETE FROM K_NPCPOS WHERE NpcId IN(601, 602, 603, 604, 605, 16095, 15012)

# -- delete if you have these rows 601, 602, 603, 604, 605, 16095, and 1501

2. Kodumuz...









Kod:

1. INSERT INTO K_NPC

2. VALUES(601, 'Bi-Frost Monument', 30020, 100, 0, 0, 0, 0, 154, 1, 1, 1, 0, 100, 10000, 1200, 700000, 0, 0, 15000, 642, 842, 0, 1000, 0, 0, 1000, 0, 0, 0, 30000, 30000, 30000, 30000, 30000, 30000, 30000, 100, 5, 5, 5, 0, 0, 0, 0, 0)

3.



4. INSERT INTO K_NPC

5. VALUES(602, 'Bi-frost Gate', 30100, 100, 0, 0, 1, 0, 150, 1, 1, 1, 0, 80, 0, 0, 10000, 0, 0, 480, 375, 375, 0, 1000, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 100, 5, 5, 5, 0, 0, 0, 0, 0)

6.



7. INSERT INTO K_NPC

8. VALUES(603, 'Chaotic Generator', 30200, 100, 0, 0, 1, 0, 162, 1, 1, 1, 0, 100, 0, 0, 700000, 0, 0, 15000, 642, 842, 0, 1000, 0, 0, 1000, 0, 0, 0, 30000, 30000, 30000, 30000, 30000, 30000, 30000, 100, 5, 5, 5, 0, 0, 0, 0, 0)

9.



10. INSERT INTO K_NPC

11. VALUES(604, 'The Gate of Greed', 604, 100, 0, 0, 1, 0, 50, 1, 1, 1, 0, 100, 0, 0, 20000, 0, 0, 600, 642, 642, 0, 1000, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 100, 5, 5, 5, 0, 0, 0, 0, 0)

12.



13. INSERT INTO K_NPC

14. VALUES(605, 'Lever', 605, 100, 0, 0, 1, 0, 55, 1, 1, 1, 0, 60, 0, 0, 10000, 0, 0, 360, 194, 194, 0, 1000, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 100, 5, 5, 5, 0, 0, 0, 0, 0)

15.



16. INSERT INTO K_NPC

17. VALUES(16095, '[Gatekeeper of Lost Room]', 11510, 100, 0, 0, 1, 1, 163, 1, 0, 1, 0, 60, 0, 0, 30000, 0, 0, 5000, 194, 194, 1000, 1500, 2, 5, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 25, 0, 16095, 0, 0, 1)

Ve Son Kodunuz NPC yerlerini Ayarlamak için...









Kod:

this is guide to get 1310 chaotic generator to work and bifrost in cz

open K_NPC



1. DELETE FROM K_NPC WHERE sSid IN(601, 602, 603, 604, 605, 16095, 15012)

2. DELETE FROM K_NPCPOS WHERE NpcId IN(601, 602, 603, 604, 605, 16095, 15012)

3. -- delete if you have these rows 601, 602, 603, 604, 605, 16095, and 15012



Copy Code

replace with this



1. INSERT INTO K_NPC

2. VALUES(601, 'Bi-Frost Monument', 30020, 100, 0, 0, 0, 0, 154, 1, 1, 1, 0, 100, 10000, 1200, 700000, 0, 0, 15000, 642, 842, 0, 1000, 0, 0, 1000, 0, 0, 0, 30000, 30000, 30000, 30000, 30000, 30000, 30000, 100, 5, 5, 5, 0, 0, 0, 0, 0)

3.



4. INSERT INTO K_NPC

5. VALUES(602, 'Bi-frost Gate', 30100, 100, 0, 0, 1, 0, 150, 1, 1, 1, 0, 80, 0, 0, 10000, 0, 0, 480, 375, 375, 0, 1000, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 100, 5, 5, 5, 0, 0, 0, 0, 0)

6.



7. INSERT INTO K_NPC

8. VALUES(603, 'Chaotic Generator', 30200, 100, 0, 0, 1, 0, 162, 1, 1, 1, 0, 100, 0, 0, 700000, 0, 0, 15000, 642, 842, 0, 1000, 0, 0, 1000, 0, 0, 0, 30000, 30000, 30000, 30000, 30000, 30000, 30000, 100, 5, 5, 5, 0, 0, 0, 0, 0)

9.



10. INSERT INTO K_NPC

11. VALUES(604, 'The Gate of Greed', 604, 100, 0, 0, 1, 0, 50, 1, 1, 1, 0, 100, 0, 0, 20000, 0, 0, 600, 642, 642, 0, 1000, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 100, 5, 5, 5, 0, 0, 0, 0, 0)

12.



13. INSERT INTO K_NPC

14. VALUES(605, 'Lever', 605, 100, 0, 0, 1, 0, 55, 1, 1, 1, 0, 60, 0, 0, 10000, 0, 0, 360, 194, 194, 0, 1000, 0, 0, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 100, 5, 5, 5, 0, 0, 0, 0, 0)

15.



16. INSERT INTO K_NPC

17. VALUES(16095, '[Gatekeeper of Lost Room]', 11510, 100, 0, 0, 1, 1, 163, 1, 0, 1, 0, 60, 0, 0, 30000, 0, 0, 5000, 194, 194, 1000, 1500, 2, 5, 1000, 0, 0, 0, 250, 250, 250, 250, 250, 250, 250, 90, 7, 14, 25, 0, 16095, 0, 0, 1)



Copy Code

now open K_NPCPOS

add following rows



1. INSERT INTO K_NPCPOS

2. VALUES(201, 601, 100, 0, 0, 0, 0, 1015, 1003, 1015, 1003, 1015, 1003, 1015, 1003, 1, 200, 0, 0, NULL)

3.



4. INSERT INTO K_NPCPOS

5. VALUES(201, 602, 100, 0, 0, 0, 0, 1020, 1010, 1020, 1010, 1020, 1010, 1020, 1010, 1, 20, 0, 0, NULL)

6.



7. INSERT INTO K_NPCPOS

8. VALUES(21, 603, 100, 0, 0, 0, 0, 273, 453, 273, 453, 273, 453, 273, 453, 1, 10, 0, 2, NULL)

9.



10. INSERT INTO K_NPCPOS

11. VALUES(31, 16095, 100, 0, 0, 0, 0, 884, 185, 884, 185, 884, 185, 884, 185, 1, 200, 0, 0, NULL)













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.