KO 1534 Server Files (VB6 Source)

Nero · Temmuz 13, 2017

Zamanında can sıkıntısına yapmıştım eski bir dil olsa da vb6 olanakları yüksek bir yazılım dili, yabancıların kaynak kodlarını internet üzerinden araştırırsanız aslında vb6 ile yapılabilecek çok şey var. hö

@ Dawn bu projeyi geliştirmişti diye hatırlıyorum onun güncellediği halini bulamadım

Veritabanınız ile uyum sağlamayabilir, zamanında ben hangi database üzerine bu projeyi hazırladım hatırlamıyorum.

Resimler

Spoiler

GameServer load içerisinde exit sub var ilk bir kaç tablo yüklendikten sonra diğerleri kullanılmadığı için yüklemiyor. Gözünüzden kaçmasın..

Gerekli k_warpinfo güncellemesi

Spoiler

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

hepsinin zoneid girilmiş değil orijinal tablodan karşılaştırarak alabilirsiniz

Gerekli veritabanı güncellemesi

Spoiler

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]

İçerik

LogInServer
GameServer

Gizli İçerik

Gizli içeriği görmek için bu konuya bir mesaj yazın.

nizarss · Temmuz 13, 2017

teşekkür ederim bir ara nette bulmuştum 2 tane source vardı aynısımı bilmiyorum bir bakayım yinede xd

edit :

aradığın dosyalar bunlar olabilir xd

https://yadi.sk/d/Cs-QlvLO3L2GtN

Nero · Temmuz 14, 2017

can sıkıntısına npc ve monsterları ekledim belki daha da geliştirebilirim vakit bulursam
geliştirilmeye baya açık fakat ileride sql şişme problemi yaşanılabilir

~~YNG~~ · Temmuz 20, 2017

Teşekkürler MYPacketTool Sorun yok dimi Dinleniyor..

~~HKS~~ · Temmuz 23, 2017

Teşekkürler

kosp51 · Temmuz 24, 2017

Teşekkürler

CENGLYY · Temmuz 24, 2017

İncelicem teşekkkürler

~~Terry~~ · Temmuz 24, 2017

@ Nero Şişme problemini otomatik query yardımıyla çözebilirsin diye tahmin ediyorum.

orkan · Temmuz 28, 2017

teşekkürler incelemek isterim :)

~~omear~~ · Temmuz 29, 2017

teşşekürler hemen denemek isterim.

kojz · Temmuz 29, 2017

teşekkürler

LostMan · Temmuz 29, 2017

Teşekkür ederim nero güzel paylaşım

~~bluemansiiz~~ · Ağustos 1, 2017

teşekkürler.

Z3RO · Ağustos 9, 2017

teşekkürler

Ağustos 9, 2017

teşekkürler.

~~alones~~ · Eylül 3, 2017

+++++++++++++++++++

GameServer load içerisinde exit sub var ilk bir kaç tablo yüklendikten sonra diğerleri kullanılmadığı için yüklemiyor. Gözünüzden kaçmasın..

Gerekli k_warpinfo güncellemesi

Spoiler

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

hepsinin zoneid girilmiş değil orijinal tablodan karşılaştırarak alabilirsiniz

Gerekli veritabanı güncellemesi

Spoiler

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]

İçerik

55Obede · Eylül 4, 2017

Ohh Good, thanks

~~symbol54~~ · Eylül 4, 2017

teşekkürler

KO 1534 Server Files (VB6 Source)

eno · Eylül 6, 2017

cok teşekkürler

~~zudokuxd10~~ · Kasım 8, 2017

does the events are working? i mean bdw,chaos¡?

Nero · Kasım 9, 2017

no its just for fun

slmmurat199 · Kasım 9, 2017

teşekkürler

Pysliq · Kasım 18, 2017

Teskkurler ellerine saglik

~~elm412~~ · Aralık 5, 2017

teşekkür

~~Knight~~ · Aralık 25, 2017

tşk ederim

Giriş Yap

KO 1534 Server Files (VB6 Source)

Önerilen Mesajlar

Nero 867

İletiyi paylaş

Link to post

Sitelerde Paylaş

nizarss 22

İletiyi paylaş

Link to post

Sitelerde Paylaş

Nero 867

İletiyi paylaş

Link to post

Sitelerde Paylaş

YNG 55

İletiyi paylaş

Link to post

Sitelerde Paylaş

HKS 341

İletiyi paylaş

Link to post

Sitelerde Paylaş

kosp51 8

İletiyi paylaş

Link to post

Sitelerde Paylaş

CENGLYY 163

İletiyi paylaş

Link to post

Sitelerde Paylaş

Terry 19

İletiyi paylaş

Link to post

Sitelerde Paylaş

orkan 3

İletiyi paylaş

Link to post

Sitelerde Paylaş

omear 3

İletiyi paylaş

Link to post

Sitelerde Paylaş

kojz 4

İletiyi paylaş

Link to post

Sitelerde Paylaş

LostMan 37

İletiyi paylaş

Link to post

Sitelerde Paylaş

bluemansiiz 12

İletiyi paylaş

Link to post

Sitelerde Paylaş

Z3RO 0

İletiyi paylaş

Link to post

Sitelerde Paylaş

aakinci 142

İletiyi paylaş

Link to post

Sitelerde Paylaş

alones 0

İletiyi paylaş

Link to post

Sitelerde Paylaş

55Obede 8

İletiyi paylaş

Link to post

Sitelerde Paylaş

symbol54 11

İletiyi paylaş

Link to post

Sitelerde Paylaş

eno 3

İletiyi paylaş

Link to post

Sitelerde Paylaş

zudokuxd10 3

142