SORUNSUZ RONAKLAND BASE BY_IBO

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