Nero

DROP TABLE K_WARPINFO
CREATE TABLE [K_WARPINFO] (
	[sWarpID] [smallint] NOT NULL ,
	[strWarpName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[strAnnounce] [varchar] (256) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[sZone] [smallint] NOT NULL CONSTRAINT [DF_K_WARPINFO_sZone] DEFAULT (0),
	[dwPay] [int] NOT NULL CONSTRAINT [DF_K_WARPINFO_dwPay] DEFAULT (0),
	[sPosX] [smallint] NOT NULL CONSTRAINT [DF_K_WARPINFO_sPosX] DEFAULT (0),
	[sPosZ] [smallint] NOT NULL CONSTRAINT [DF_K_WARPINFO_sPosZ] DEFAULT (0),
	[sPosY] [smallint] NOT NULL CONSTRAINT [DF_K_WARPINFO_sPosY] DEFAULT (0),
	[sLevel] [tinyint] NOT NULL CONSTRAINT [DF_K_WARPINFO_sLevel] DEFAULT (0)
) ON [PRIMARY]
GO

INSERT INTO [K_WARPINFO]  VALUES (111,'Bellua Village','You will be transported to Bellua Village, home of the rogues. Bellua Village vicinity is suitable for players at Level 35-45. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (112,'Kalluga Valley Entrance','You will be transported to the mouth of the kalluga Valley. Referred to as the Valley of Lost Souls, the transport fee to the valley is 15,000 Noahs.',0,15000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (113,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (114,'Moradon','You will be transported to Moradon. Moradon is a free-trade zone in southern Adonis continent inhabited by fairies and dragons. Moradon region is suitable for players at Level 1-20. Transport fee is 1,000 Noahs.',21,1000,815,515,0,0);
INSERT INTO [K_WARPINFO]  VALUES (115,'Roan Camp','You will be transported to Roan Camp. The camp acts as an instrumental strategic territory in time of war. War outcome can be determined by the camps sharpshooters. Transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (116,'Eslant entrance','You will be transported to Eslant entrance. Players can advance to Eslant from the entrance. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (121,'Luferson Castle','You will be transported to Luferson Castle. Home of Kooglins tombstone, it is a village of warriors and priests. Luferson Castle vicinity is suitable for players at Level 35. There is no transport fee.',1,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (122,'Linart Village','You will be transported to Linart Village, a village of mages. Linart Village vicinity is suitable for players at Level 45 and above. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (123,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (124,'Lunar Valley','You will be teleported to the Lunar Valley Entrance. A war is waging in the valley. Players above Level 35 can engage in the battle. Only level 35-50 players can engage in the Dark Lunar Wars. The fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (125,'Roan Camp','You will be transported to Roan Camp. The camp acts as an instrumental strategic territory in time of war. War outcome can be determined by the camps sharpshooters. Transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (131,'Bellua Village','You will be transported to Bellua Village, home of the rogues. Bellua Village vicinity is suitable for players at Level 35-45. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (132,'Kalluga Valley Entrance','You will be transported to the mouth of the kalluga Valley. Referred to as the Valley of Lost Souls, the transport fee to the valley is 15,000 Noahs.',0,15000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (133,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (134,'Lunar Valley','You will be teleported to the Lunar Valley Entrance. A war is waging in the valley. Players above Level 35 can engage in the battle. Only level 35-50 players can engage in the Dark Lunar Wars. The fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (135,'Roan Camp','You will be transported to Roan Camp. The camp acts as an instrumental strategic territory in time of war. War outcome can be determined by the camps sharpshooters. Transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (141,'Bellua Village','You will be transported to Bellua Village, home of the rogues. Bellua Village vicinity is suitable for players at Level 35-45. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (142,'Linart Village','You will be transported to Linart Village, a village of mages. Linart Village vicinity is suitable for players at Level 45 and above. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (143,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (151,'Bellua Village','You will be transported to Bellua Village, home of the rogues. Bellua Village vicinity is suitable for players at Level 35-45. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (152,'Linart Village','You will be transported to Linart Village, a village of mages. Linart Village vicinity is suitable for players at Level 45 and above. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (153,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (154,'Eslant','You will be transported to Eslant. A high-level player hunting grount suitable for players above Level 60, only players above Level 60 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,60);
INSERT INTO [K_WARPINFO]  VALUES (162,'Linart Village','You will be transported to Linart Village, a village of mages. Linart Village vicinity is suitable for players at Level 45 and above. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (163,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (171,'Luferson Castle','You will be transported to Luferson Castle. Home of Kooglins tombstone, it is a village of warriors and priests. Luferson Castle vicinity is suitable for players at Level 35. There is no transport fee.',1,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (172,'Linart Village','You will be transported to Linart Village, a village of mages. Linart Village vicinity is suitable for players at Level 45 and above. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (173,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,10000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (174,'Bellua Village','You will be transported to Bellua Village, home of the rogues. Bellua Village vicinity is suitable for players at Level 35-45. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (211,'Asga Village','You will be transported to Asga Village, home of the rogues. Asga Village vicinity is suitable for players at Level 35-45. The transport fee is 10,000 Noahs.',2,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (212,'Kalluga Valley Entrance','You will be transported to the mouth of the kalluga Valley. Referred to as the Valley of Lost Souls, the transport fee to the valley is 15,000 Noahs.',2,15000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (213,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',2,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (214,'Moradon','You will be transported to Moradon. Moradon is a free-trade zone in southern Adonis continent inhabited by fairies and dragons. Moradon region is suitable for players at Level 1-20. Transport fee is 1,000 Noahs.',21,1000,815,515,0,0);
INSERT INTO [K_WARPINFO]  VALUES (215,'Doda Camp','You will be transported to Doda Camp. The camp acts as an instrumental strategic territory in time of war. War outcome can be determined by the camps sharpshooters. Transport fee is 10,000 Noahs.',2,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (216,'Eslant entrance','You will be transported to Eslant entrance. Players can advance to Eslant from the entrance. The transport fee is 10,000 Noahs.',2,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (221,'El Morad Castle','You will be transported to El Morad Castle. Home of Pianna Knight Squad Tower, it is a village of warriors and priests. El Morad Castle vicinity is suitable for players at Level 35. There is no transport fee.',2,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (222,'Laiba Village','You will be transported to Laiba Village, a village of mages. Laiba Village vicinity is suitable for players at Level 45 and above. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (223,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (224,'Eslant entrance','You will be transported to Eslant entrance. Players can advance to Eslant from the entrance. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (225,'Doda Camp','You will be transported to Doda Camp. The camp acts as an instrumental strategic territory in time of war. War outcome can be determined by the camps sharpshooters. Transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (231,'Asga Village','You will be transported to Asga Village, home of the rogues. Asga Village vicinity is suitable for players at Level 35-45. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (232,'Kalluga Valley Entrance','You will be transported to the mouth of the kalluga Valley. Referred to as the Valley of Lost Souls, the transport fee to the valley is 15,000 Noahs.',0,15000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (233,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (234,'Lunar Valley','You will be teleported to the Lunar Valley Entrance. A war is waging in the valley. Players above Level 35 can engage in the battle. Only level 35-50 players can engage in the Dark Lunar Wars. The fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (235,'Doda Camp','You will be transported to Doda Camp. The camp acts as an instrumental strategic territory in time of war. War outcome can be determined by the camps sharpshooters. Transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (241,'Asga Village','You will be transported to Asga Village, home of the rogues. Asga Village vicinity is suitable for players at Level 35-45. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (242,'Laiba Village','You will be transported to Laiba Village, a village of mages. Laiba Village vicinity is suitable for players at Level 45 and above. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (243,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (251,'Asga Village','You will be transported to Asga Village, home of the rogues. Asga Village vicinity is suitable for players at Level 35-45. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (252,'Laiba Village','You will be transported to Laiba Village, a village of mages. Laiba Village vicinity is suitable for players at Level 45 and above. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (253,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (254,'Eslant','You will be transported to Eslant. A high-level player hunting grount suitable for players above Level 60, only players above Level 60 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,60);
INSERT INTO [K_WARPINFO]  VALUES (262,'Laiba Village','You will be transported to Laiba Village, a village of mages. Laiba Village vicinity is suitable for players at Level 45 and above. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (263,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (271,'El Morad Castle','You will be transported to El Morad Castle. Home of Pianna Knight Squad Tower, it is a village of warriors and priests. El Morad Castle vicinity is suitable for players at Level 35. There is no transport fee.',2,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (272,'Laiba Village','You will be transported to Laiba Village, a village of mages. Laiba Village vicinity is suitable for players at Level 45 and above. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (273,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 35 are allowed entry. Transport fee is 17,000 Noahs.',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (274,'Asga Village','You will be transported to Asga Village, home of the rogues. Asga Village vicinity is suitable for players at Level 35-45. The transport fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (2111,'Luferson Castle','You will be transported to Luferson Castle. Home of Kooglins tombstone, it is a village of warriors and priests. Luferson Castle vicinity is suitable for players at Level 35. There is no transport fee.',1,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (2113,'Folk Village','You will be transported to Folk Village. A small village which is located in the middle of Moradon, and it is an important place for Moradon field travelers and which gives lots of facilities to the travelers. Relocating fee is 3,000 Noahs.',0,3000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (2114,'Tale Village','You will be transported to Tale Village. A village which is located the eng of Rock Snake Canyon, and it is an important place for explorating canyon. Relocating fee is 3,000 Noahs.',0,3000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (2115,'Delos','You will be transported to the Siege Zone. Transport fee is 17,000 Noahs.',0,17000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (2117,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 60 are allowed entry. Transport fee 17,000 Noahs',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (2118,'Lunar Valley','You will be teleported to the Lunar Valley Entrance. A War is waging in the valley. Players above Level 35 can engage in the battle. Only level 30-50 players can engage in the Dark Lunar Wars. The fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (2121,'El Morad Castle','You will be transported to El Morad Castle. Home of Pianna Knight Squad Tower, it is a village of warriors and priests. El Morad Castle vicinity is suitable for players at Level 35. Transport fee is 5,000 Noahs.',2,5000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (2123,'Folk Village','You will be transported to Folk Village. A small village which is located in the middle of Moradon, and it is an important place for Moradon field travelers and which gives lots of facilities to the travelers. Relocating fee is 3,000 Noahs.',0,3000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (2124,'Tale Village','You will be transported to Tale Village. A village which is located the eng of Rock Snake Canyon, and it is an important place for explorating canyon. Relocating fee is 3,000 Noahs.',0,3000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (2125,'Delos','You will be transported to the Siege Zone. Transport fee is 17,000 Noahs.',0,17000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (2127,'Ronark Land','You will be transported to Ronark Land where players can hunt or wage battle against players of opposing countries. Only players above Level 60 are allowed entry. Transport fee 17,000 Noahs',0,17000,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (2128,'Lunar Valley','You will be teleported to the Lunar Valley Entrance. A War is waging in the valley. Players above Level 35 can engage in the battle. Only level 30-50 players can engage in the Dark Lunar Wars. The fee is 10,000 Noahs.',0,10000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (3014,'Moradon','You will be transported to Moradon. Moradon is a free-trade zone in southern Adonis continent inhabited by fairies and dragons. Moradon region is suitable for players at Level 1-20. There is no transport fee.',21,0,815,515,0,0);
INSERT INTO [K_WARPINFO]  VALUES (3024,'Moradon','You will be transported to Moradon. Moradon is a free-trade zone in southern Adonis continent inhabited by fairies and dragons. Moradon region is suitable for players at Level 1-20. There is no transport fee.',21,0,815,515,0,0);
INSERT INTO [K_WARPINFO]  VALUES (3034,'Moradon','You will be transported to Moradon. Moradon is a free-trade zone in southern Adonis continent inhabited by fairies and dragons. Moradon region is suitable for players at Level 1-20. There is no transport fee.',21,0,815,515,0,0);
INSERT INTO [K_WARPINFO]  VALUES (3044,'Moradon','You will be transported to Moradon. Moradon is a free-trade zone in southern Adonis continent inhabited by fairies and dragons. Moradon region is suitable for players at Level 1-20. There is no transport fee.',21,0,815,515,0,0);
INSERT INTO [K_WARPINFO]  VALUES (3055,'Abyss dungeon','You will be transported to abyss dungeon. Abyss is an infinite underground prison with no stairway or doors leading up. Players can move to another floor only via the valuts located on each floor. The transport fee is 20,000 noahs.',0,20000,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (10111,'Luferson Castle','You will be transported to Luferson Castle. Home of Kooglins tombstone, it is a village of warriors and priests. Luferson Castle vicinity is suitable for players at Level 35. There is no transport fee.',1,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (10121,'El Morad Castle','You will be transported to El Morad Castle. Home of Pianna Knight Squad Tower, it is a village of warriors and priests. El Morad Castle vicinity is suitable for players at Level 35. There is no transport fee.',2,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (10211,'Luferson Castle','You will be transported to Luferson Castle. Home of Kooglins tombstone, it is a village of warriors and priests. Luferson Castle vicinity is suitable for players at Level 35. There is no transport fee.',1,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (10221,'El Morad Castle','You will be transported to El Morad Castle. Home of Pianna Knight Squad Tower, it is a village of warriors and priests. El Morad Castle vicinity is suitable for players at Level 35. There is no transport fee.',2,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (10311,'Luferson Castle','You will be transported to Luferson Castle. Home of Kooglins tombstone, it is a village of warriors and priests. Luferson Castle vicinity is suitable for players at Level 35. There is no transport fee.',1,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (10312,'Alseids Prairie','You will be transported to Alseids Prairie. Transport fee is 2,500 Noahs.',0,2500,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (10321,'Nereidth Island','You will be transported to Nereidth Island. Transport fee is 2,500 Noahs.',0,2500,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (10331,'El Morad Castle','You will be transported to El Morad Castle. Home of Pianna Knight Squad Tower, it is a village of warriors and priests. El Morad Castle vicinity is suitable for players at Level 35. There is no transport fee.',2,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (10332,'Alseids Prairie','You will be transported to Alseids Prairie. Transport fee is 2,500 Noahs.',0,2500,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (10341,'Nereidth Island','You will be transported to Nereidth Island. Transport fee is 2,500 Noahs.',0,2500,0,0,0,0);
INSERT INTO [K_WARPINFO]  VALUES (20111,'Luferson Castle','You will be transported to Luferson Castle. Home of Kooglins tombstone, it is a village of warriors and priests. Luferson Castle vicinity is suitable for players at Level 35. There is no transport fee.',1,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (20114,'Moradon','You will be transported to Moradon. Moradon is a free-trade zone in southern Adonis continent inhabited by fairies and dragons. Moradon region is suitable for players at Level 1-20. There is no transport fee.',21,0,815,515,0,0);
INSERT INTO [K_WARPINFO]  VALUES (20121,'El Morad Castle','You will be transported to El Morad Castle. Home of Piana Knight Squad Tower, it is a village of warriors and priests. El Morad Castle vicinity is suitable for players at Level 35. There is no transport fee.',2,0,0,0,0,35);
INSERT INTO [K_WARPINFO]  VALUES (20124,'Moradon','You will be transported to Moradon. Moradon is a free-trade zone in southern Adonis continent inhabited by fairies and dragons. Moradon region is suitable for players at Level 1-20. There is no transport fee.',21,0,815,515,0,0);

knights_cape tablosuna eklenecek
nBuyLoyalty int
byRanking tinyint
knights tablosu güncelleme
sCape = sCapeC olacak
sCapeR
sCapeG
sCapeB

magic tablosuna
MagicNum2

magic type1 tablosuna
MagicNum

magic type 6 tablosuna
UseItem1 int
UseItem2 int

update knights_cape set nBuyLoyalty = 0, byRanking = 0;
update knights set Gold = 0, sCapeR = 0, sCapeG = 0, sCapeB = 0; -- gold null olursa yüklenirken hata verir
-- aslında bunları eklemek lazım ben tbl almıştım listeyi
update magic set MagicNum2 = MagicNum;
update magic_type1 set MagicNum = 0;
update magic_type6 set UseItem1 = 0, UseItem2 = 0;

TABLE [MAGIC_TYPE9] (
	[nIndex] [int] NOT NULL ,
	[strName] [char] (30) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[strNote] [char] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL ,
	[byValidGroup] [tinyint] NOT NULL ,
	[byNationChange] [tinyint] NOT NULL ,
	[shMonsterNum] [smallint] NOT NULL ,
	[byTargetChange] [tinyint] NOT NULL ,
	[byStateChange] [tinyint] NOT NULL ,
	[byRadius] [smallint] NOT NULL ,
	[shHitrate] [smallint] NOT NULL ,
	[shDuration] [smallint] NOT NULL ,
	[shDamage] [smallint] NOT NULL ,
	[byVision] [smallint] NOT NULL ,
	[nNeedItem] [int] NOT NULL 
) ON [PRIMARY]

-- Use CREATE PROCEDURE instead of ALTER PROCEDURE if you don't already have this procedure

ALTER PROCEDURE [dbo].[UPDATE_WAREHOUSE_PW]

        @strAccountID varchar(21),

        @strWarehousePw varchar(20),

        @Money int,

        @dwTime int,

        @strWarehouseData varchar(1600),

        @strSerial varchar(1600)

AS

BEGIN

        DECLARE @FirstRun int

        SELECT @FirstRun = COUNT(*) FROM WAREHOUSE WHERE strAccountID = @strAccountID AND strWarehousePw IS NULL



        IF @FirstRun = 0

        BEGIN

                SELECT @strWarehousePw = strWarehouseNo FROM TB_USER WHERE strAccountID = @strAccountID

  END         



  UPDATE WAREHOUSE SET strWarehousePw = @strWarehousePw, dwTime = @dwTime, nMoney = @Money, WareHouseData = @strWarehouseData, strSerial = @strSerial WHERE strAccountID = @strAccountID

END



ALTER  PROCEDURE [dbo].[UPDATE_WAREHOUSE]

        @accountid              varchar(21),

        @Money          int,

        @dwTime        int,

        @strItem                varchar(1600),

        @strSerial              varchar(1600)

AS

UPDATE  WAREHOUSE

Set

        nMoney          = @Money,

        dwTime          = @dwTime,

        WarehouseData  = @strItem,

        strSerial              = @strSerial

WHERE  strAccountID    = @accountid



ALTER  PROCEDURE [dbo].[UPDATE_USER_DATA]

        @id            varchar(21),

        @Nation tinyint,

        @Race          tinyint,

        @Class          smallint,

        @HairColor      tinyint,

        @Rank          tinyint,

        @Title          tinyint,

        @Level          tinyint,

        @Exp            int,

        @Loyalty        int,

        @Face          tinyint,

        @City          tinyint,       

        @Knights        smallint,

        @Fame          tinyint,

        @Hp            smallint,

        @Mp            smallint,

        @Sp            smallint,

        @Str            tinyint,

        @Sta            tinyint,

        @Dex            tinyint,

        @Intel          tinyint,

        @Cha            tinyint,

        @Authority      tinyint,

        @Points        smallint,       -- @Points (and Points in USERDATA) need to be smallint

        @Gold          int,

        @Zone          tinyint,

        @Bind          smallint,

        @PX            int,

        @PZ            int,

        @PY            int,

        @dwTime int,

        @QuestTotal      smallint,

        @strSkill      varchar(20),

        @strItem        varchar(400),

        @strSerial      varchar(400),

        @strQuest      varchar(400),

        @MannerPoint  int,

        @LoyaltyMonthly int

AS



DECLARE @KnightsIndex smallint



IF @Zone > 2            -- battle zone user

BEGIN

        SELECT @KnightsIndex=Knights FROM USERDATA WHERE strUserId=@id

        IF @KnightsIndex = -1  -- expel user

        BEGIN

                SET @Knights = 0

                SET @Fame = 0

        END

END



UPDATE  USERDATA

Set

        Nation          = @Nation,

        Race            = @Race,

        Class          = @Class,

        HairColor      = @HairColor,

        Rank            = @Rank,

        Title          = @Title,

        [Level]        = @Level,

        [Exp]          = @Exp,

        Loyalty        = @Loyalty,

        Face            = @Face,

        City            = @City,       

        Knights        = @Knights,

        Fame            = @Fame,

        Hp              = @Hp,

        Mp              = @Mp,

        Sp              = @Sp,

        Strong          = @Str,

        Sta            = @Sta,

        Dex            = @Dex,

        Intel          = @Intel,

        Cha            = @Cha,

        Authority      = @Authority,

        Points          = @Points,

        Gold            = @Gold,

        [Zone]          = @Zone,

        Bind            = @Bind,

        PX              = @PX,

        PZ              = @PZ,

        PY              = @PY,

        dwTime          = @dwTime,

        strSkill                = @strSkill,

        strItem        = @strItem,

        strSerial              = @strSerial,  -- 2002 11. 12

        sQuestCount    = @QuestTotal,  -- 2003.04.09

        strQuest                = @strQuest,    -- 2003.04.09

        MannerPoint    = @MannerPoint, -- 2004.01.30

        LoyaltyMonthly  = @LoyaltyMonthly,      -- 2004.04.22

        UpdateTime        = getdate()

WHERE  strUserId      = @id