[ Paylaşım ] Ronark Land Base Eklemek [ QA ]

HTML-Kodu:
-- Update SMD Name UPDATE ZONE_INFO SET strZoneName = 'freezone_1018.smd' WHERE ZoneNo = 203 -- Update Start Position DELETE FROM START_POSITION WHERE ZoneID = 203 INSERT INTO START_POSITION VALUES(203,516,105,511,916,10,10,0,0,0,0) -- Add Ronark Base Moment DELETE FROM K_NPC WHERE sSid = 24000 INSERT INTO K_NPC VALUES (24000 , 'Ronark Base Monument' , 14005 , 120 , 0 , 0 , 3 , 0 , 2 , 1 , 1 , 1 , 0 , 80 , 0 , 75 , 85713 , 0 , 0 , 800 , 124 , 124 , 0 , 1000 , 0 , 0 , 1000 , 0 , 0 , 0 , 250 , 250 , 250 , 250 , 250 , 250 , 250 , 100 , 5 , 5 , 5 , 32000 , 32578 , 0 , 0 , 0) -- Add New Guard Tower DELETE FROM K_NPC WHERE sSid = 5800 DELETE FROM K_NPC WHERE sSid = 5900 INSERT INTO K_NPC VALUES (5800,'Guard Tower',5301,100,0,0,2,0,62,1,1,1,0,90,0,0,100000,0,0,15000,497,497,0,1500,0,0,1000,300139,0,0,255,255,255,255,255,255,255,200,30,35,35,0,0,1,1,0) INSERT INTO K_NPC VALUES (5900,'Guard Tower',5401,100,0,0,1,0,62,1,1,1,0,90,0,0,100000,0,0,15000,497,497,0,1500,0,0,1000,300139,0,0,255,255,255,255,255,255,255,200,30,35,35,0,0,1,1,0) -- Add New Damage Skills for New Guard Tower UPDATE MAGIC_TYPE3 SET FirstDamage = -15000,EndDamage = 0,DirectType = 1,Radius = 20,TimeDamage = 0,Duration = 0,Attribute = 1 WHERE iNum = 300139 -- Add NPC Location's DELETE FROM K_NPCPOS WHERE ZoneID = 203 INSERT INTO K_NPCPOS VALUES (203 , 5900 , 104 , 0 , 0 , 0 , 0 , 475 , 168 , 475 , 168 , 475 , 168 , 475 , 168 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5900 , 104 , 0 , 0 , 0 , 0 , 494 , 168 , 494 , 168 , 494 , 168 , 494 , 168 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5900 , 104 , 0 , 0 , 0 , 0 , 511 , 168 , 511 , 168 , 511 , 168 , 511 , 168 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5900 , 104 , 0 , 0 , 0 , 0 , 536 , 168 , 536 , 168 , 536 , 168 , 536 , 168 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5900 , 104 , 0 , 0 , 0 , 0 , 555 , 168 , 555 , 168 , 555 , 168 , 555 , 168 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5900 , 104 , 0 , 0 , 0 , 0 , 483 , 144 , 483 , 144 , 483 , 144 , 483 , 144 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5900 , 104 , 0 , 0 , 0 , 0 , 540 , 144 , 540 , 144 , 540 , 144 , 540 , 144 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5900 , 104 , 0 , 0 , 0 , 0 , 528 , 125 , 528 , 125 , 528 , 125 , 528 , 125 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5900 , 104 , 0 , 0 , 0 , 0 , 490 , 88 , 490 , 88 , 490 , 88 , 490 , 88 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5900 , 104 , 0 , 0 , 0 , 0 , 548 , 88 , 548 , 88 , 548 , 88 , 548 , 88 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 528 , 100 , 0 , 0 , 0 , 0 , 521 , 119 , 521 , 119 , 521 , 119 , 521 , 119 , 1 , 60 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 22120 , 100 , 0 , 0 , 0 , 0 , 508 , 119 , 508 , 119 , 508 , 119 , 508 , 119 , 1 , 1800 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 22000 , 100 , 0 , 0 , 0 , 0 , 515 , 119 , 515 , 119 , 515 , 119 , 515 , 119 , 1 , 4400 , 0 , 3 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5800 , 104 , 0 , 0 , 0 , 0 , 510 , 846 , 510 , 846 , 510 , 846 , 510 , 846 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5800 , 104 , 0 , 0 , 0 , 0 , 524 , 846 , 524 , 846 , 524 , 846 , 524 , 846 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5800 , 104 , 0 , 0 , 0 , 0 , 549 , 846 , 549 , 846 , 549 , 846 , 549 , 846 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5800 , 104 , 0 , 0 , 0 , 0 , 473 , 869 , 473 , 869 , 473 , 869 , 473 , 869 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5800 , 104 , 0 , 0 , 0 , 0 , 543 , 866 , 543 , 866 , 543 , 866 , 543 , 866 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5800 , 104 , 0 , 0 , 0 , 0 , 535 , 890 , 535 , 890 , 535 , 890 , 535 , 890 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5800 , 104 , 0 , 0 , 0 , 0 , 482 , 914 , 482 , 914 , 482 , 914 , 482 , 914 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5800 , 104 , 0 , 0 , 0 , 0 , 545 , 917 , 545 , 917 , 545 , 917 , 545 , 917 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5800 , 104 , 0 , 0 , 0 , 0 , 543 , 948 , 543 , 948 , 543 , 948 , 543 , 948 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5800 , 104 , 0 , 0 , 0 , 0 , 474 , 948 , 474 , 948 , 474 , 948 , 474 , 948 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 5800 , 104 , 0 , 0 , 0 , 0 , 481 , 845 , 481 , 845 , 481 , 845 , 481 , 845 , 1 , 90 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 16089 , 100 , 0 , 0 , 0 , 0 , 506 , 895 , 506 , 895 , 506 , 895 , 506 , 895 , 1 , 60 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 12120 , 100 , 0 , 0 , 0 , 0 , 518 , 895 , 518 , 895 , 518 , 895 , 518 , 895 , 1 , 1800 , 0 , 0 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 16096 , 100 , 0 , 0 , 0 , 0 , 512 , 895 , 512 , 895 , 512 , 895 , 512 , 895 , 1 , 4400 , 0 , 3 , 'NULL') INSERT INTO K_NPCPOS VALUES (203 , 24000 , 137 , 0 , 0 , 0 , 0 , 509 , 509 , 509 , 509 , 509 , 509 , 509 , 509 , 1 , 1000 , 0 , 0 , 'NULL') -- Repair Monsters DECLARE @sSid int DECLARE RM_CX CURSOR FOR SELECT NpcID FROM K_NPCPOS WHERE ZoneID = 203 AND NpcID <> 5800 AND NpcID <> 5900 OPEN RM_CX FETCH NEXT FROM RM_CX INTO @sSid WHILE @@FETCH_STATUS = 0 BEGIN IF @sSid = 22000 UPDATE K_NPC SET byActType = 0 WHERE sSid = @sSid ELSE IF @sSid = 22120 UPDATE K_NPC SET byActType = 0 WHERE sSid = @sSid ELSE IF @sSid = 12120 UPDATE K_NPC SET byActType = 0 WHERE sSid = @sSid ELSE IF @sSid = 16096 UPDATE K_NPC SET byActType = 0 WHERE sSid = @sSid ELSE IF @sSid = 528 UPDATE K_NPC SET byActType = 0 WHERE sSid = @sSid ELSE IF @sSid = 16089 UPDATE K_NPC SET byActType = 0 WHERE sSid = @sSid ELSE UPDATE K_MONSTER SET byActType = 7,byType = 12 WHERE sSid = @sSid FETCH NEXT FROM RM_CX INTO @sSid END CLOSE RM_CX DEALLOCATE RM_CX