📄 createzoneinfo.sql

📁 天之炼狱OpenDE_SQL.tar.gz
💻 SQL
📖 第 1 页 / 共 4 页
字号:
12 3 4 下一页
##################################################################################  Project : Online Game DARKEDEN#  Module  : SQL - Game Info##  FileName    : CreateZoneInfo.sql#  Description : ##  History      Writer          Description# ------------ -------------- -----------------------------------------------# 2002.08.13    厘全芒        脚痹 颇老 积己 ## 2002.09.04    厘全芒        PKZone, NoPortalZone 眠啊################################################################################################################################################################# 抛捞喉 积己 DROP TABLE IF EXISTS ZoneInfo;CREATE TABLE ZoneInfo (  ZoneID smallint(5) unsigned not null default '0',  ZoneGroupID smallint(5) unsigned not null default '0',  Type enum('NORMAL_FIELD',	        'NORMAL_DUNGEON',			'SLAYER_GUILD',			'RESERVED_SLAYER_GUILD',			'PC_VAMPIRE_LAIR',			'NPC_VAMPIRE_LAIR',			'NPC_HOME',			'NPC_SHOP',			'RANDOM_MAP',			'CASTLE') not null default 'NORMAL_FIELD',  Level tinyint(3) unsigned not null default '0',  AccessMode enum('PUBLIC','PRIVATE') not null default 'PUBLIC',  OwnerId varchar(20) default null,  MonsterList text,  EventMonsterList text,  SResurrectZoneID int(11) not null default '0',  SResurrectX int(11) not null default '0',  SResurrectY int(11) not null default '0',  VResurrectZoneID int(11) not null default '0',  VResurrectX int(11) not null default '0',  VResurrectY int(11) not null default '0',  OResurrectZoneID int(11) not null default '0',  OResurrectX int(11) not null default '0',  OResurrectY int(11) not null default '0',  SmpFileName varchar(40) not null default '',  SsiFileName varchar(40) not null default '',  FullName varchar(40) not null default '',  ShortName varchar(40) not null default '',  PayPlayZone tinyint(1) unsigned not null default '0',  PremiumZone tinyint(1) unsigned not null default '0',  PKZone      tinyint(1) unsigned NOT NULL default 0,  NoPortalZone tinyint(1) unsigned NOT NULL default 0,  HolyLand	tinyint(1) unsigned NOT NULL default 0,  Available	tinyint(1) unsigned NOT NULL default 0,  OpenLevel tinyint(3) unsigned NOT NULL default 0,  PRIMARY KEY(ZoneID)) type=myisam;################################################################################# 牢郸胶 积己################################################################################# Sequence 积己################################################################################# 鼻茄 汲沥 ################################################################################# 单捞磐 持扁INSERT INTO ZoneInfo VALUES (11,1,'NORMAL_FIELD',0,'PUBLIC',NULL,'		 #舅沫       (106,8)(129,8)(130,8)(131,8)(132,8)(133,8)(134,8)(135,8)(136,8)(137,8)		 #龋喉       (165,3)(167,3)(168,3)(169,3)(170,3)(171,3)(172,3)(173,3)(174,3)(175,3)         #孤畔飘     (187,15)(188,15)(189,15)(190,15)(191,15)(192,15)(193,15)(194,15)(195,15)(196,15)         #酒捞攫萍静 (256,20)(257,20)(258,20)(259,20)(260,20)(261,20)(262,20)(263,20)(264,20)(265,20)		','         #摹橇舅沫		 ( 570,1,1800)		 #摹橇龋喉		 ( 579,1,1800)         #摹橇孤畔飘	 ( 573,1,1800)         #摹橇酒捞攫萍静 ( 571,1,1800)		', 12,227,154,1003,65,70,1311,24,73,'eslania_NE.smp','eslania_NE.ssi','俊浇扼聪酒合悼','俊浇合悼',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (12,1,'NORMAL_FIELD',0,'PUBLIC',NULL,'         #虐靛 ( 6,10)( 47,10)( 48,10)( 49,10)( 50,10)( 51,10)( 52,10)( 53,10)( 54,10)( 55,10)         #贾廉 ( 9,15)( 74,15)( 75,15) (76,15)( 77,15)( 78,15)( 79,15)( 80,15)( 81,15)( 82,15)         #母凭 ( 8,10)( 65,10)( 66,10)( 67,10)( 68,10)( 69,10)( 70,10)( 71,10)( 72,10)( 73,10)		 #舅沫 (106,5)(129,5)(130,5)(131,5)(132,5)(133,5)(134,5)(135,5)(136,5)(137,5)		','         #摹橇虐靛 ( 567,5,1800 )         #摹橇贾廉 ( 461,1,1800 )         #摹橇母凭 ( 569,1,1800 )         #摹橇舅沫 ( 570,1,1800)		', 12,227,154,1003,65,70,1311,24,73,'eslania_NW.smp','eslania_NW.ssi','俊浇扼聪酒合辑','俊浇合辑',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (13,1,'NORMAL_FIELD',0,'PUBLIC',NULL,'		 #府欺         (328,5)(329,5)(330,5)(331,5)(332,5)(333,5)(334,5)(335,5)(336,5)(337,5)		 #龋喉         (165,5)(167,5)(168,5)(169,5)(170,5)(171,5)(172,5)(173,5)(174,5)(175,5)		 #榜饭赣       (104,15)(111,15)(112,15)(113,15)(114,15)(115,15)(116,15)(117,15)(118,15)(119,15)		 #酒捞攫萍静   (256,10)(257,10)(258,10)(259,10)(260,10)(261,10)(262,10)(263,10)(264,10)(265,10)		','		 #摹橇府欺       ( 585,1,1800)		 #摹橇龋喉       ( 579,1,1800 )		 #摹橇榜饭赣     ( 582,4,1800 )		 #摹橇酒捞攫萍静 ( 571,1,1800 )		', 12,227,154,1003,65,70,1311,24,73,'eslania_SE.smp','eslania_SE.ssi','俊浇扼聪酒巢悼','俊浇巢悼',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (14,1,'NORMAL_FIELD',0,'PUBLIC',NULL,'		 #舅沫         (106,5)(129,5)(130,5)(131,5)(132,5)(133,5)(134,5)(135,5)(136,5)(137,5)		 #葛单扼胶     (221,5)(222,5)(223,5)(224,5)(225,5)(226,5)(227,5)(228,5)(229,5)(218,5)		 #孤畔飘       (187,20)(188,20)(189,20)(190,20)(191,20)(192,20)(193,20)(194,20)(195,20)(196,20)		 #母凭         ( 8,10)( 65,10)( 66,10)( 67,10)( 68,10)( 69,10)( 70,10)( 71,10)( 72,10)( 73,10)		','		 #摹橇舅沫     ( 570,6,1800)		 #摹橇葛单扼胶 ( 574,1,1800 )		 #摹橇孤畔飘   ( 573,1,1800)		 #摹橇母凭     ( 569,1,1800 )		', 12,227,154,1003,65,70,1311,24,73,'eslania_SW.smp','eslania_SW.ssi','俊浇扼聪酒巢辑','俊浇巢辑',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (21,2,'NORMAL_FIELD',0,'PUBLIC',NULL,'		#母凭           ( 8,18)( 65,18)( 66,18)( 67,18)( 68,18)( 69,18)( 70,18)( 71,18)( 72,18)( 73,18)		#葛单扼胶       (221,11)(222,11)(223,11)(224,11)(225,11)(226,10)(227,10)(228,10)(229,10)(218,10)		#俊胶飘肺捞歹   (207,3)(208,3)(209,3)(210,3)(211,3)(212,3)(213,3)(214,3)(215,3)(216,3)		#困档快胶       (197,1)(198,1)(199,1)(200,1)(201,1)(202,2)(203,2)(204,2)(205,2)(206,2)		','		#摹橇母凭       ( 569,1,1800 )		#摹橇葛单扼胶   ( 574,1,1800 )		#摹橇俊胶飘肺捞歹 ( 577,1,1800 )		#摹橇困档快胶 ( 578,1,1800 )		', 12,227,154,1003,65,70,1311,24,73,'limbo_lair_NE.smp','limbo_lair_NE.ssi','覆焊己合悼','覆焊合悼',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (22,2,'NORMAL_FIELD',0,'PUBLIC',NULL,'		#榜饭赣 (104,18)(111,18)(112,18)(113,18)(114,18)(115,18)(116,18)(117,18)(118,18)(119,18)		#龋喉 (165,9)(167,9)(168,9)(169,9)(170,9)(171,9)(172,9)(173,9)(174,9)(175,9)		#溅档快喇 (166,5)(176,5)(177,5)(178,5)(179,5)(180,4)(181,4)(182,4)(183,4)(184,4)		#墨坷胶啊叼攫 (147,1)(148,1)(149,1)(150,1)(151,1)(152,2)(153,2)(154,2)(155,2)(156,2)		','		#摹橇榜饭赣 ( 582,1,1800 )		#摹橇龋喉 ( 579,1,1800 )		#摹橇溅档快喇 ( 583,1,1800 )		#摹橇墨坷胶啊叼攫 ( 589,1,1800 )		', 12,227,154,1003,65,70,1311,24,73,'limbo_lair_NW.smp','limbo_lair_NW.ssi','覆焊己合辑','覆焊合辑',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (23,2,'NORMAL_FIELD',0,'PUBLIC',NULL,'		#磐醋单靛 ( 5,18)( 38,18)( 39,18)( 40,18)( 41,18)( 42,18)( 43,18)( 44,18)( 45,18)( 46,18)		#磐醋家匡 ( 7,11)( 56,11)( 57,11)( 58,11)( 59,11)( 60,10)( 61,10)( 62,10)( 63,10)( 64,10)		#虐靛 ( 6,3)( 47,3)( 48,3)( 49,3)( 50,3)( 51,3)( 52,3)( 53,3)( 54,3)( 55,3)		#贾廉 ( 9,2)( 74,2)( 75,2)( 76,2)( 77,2)( 78,1)( 79,1)( 80,1)( 81,1)( 82,1)		','		#摹橇磐醋单靛 ( 565,1,1800 )		#摹橇磐醋家匡 ( 566,1,1800 )		#摹橇虐靛 ( 567,1,1800 )		', 12,227,154,1003,65,70,1311,24,73,'limbo_lair_SE.smp','limbo_lair_SE.ssi','覆焊己巢悼','覆焊巢悼',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (24,2,'NORMAL_FIELD',0,'PUBLIC',NULL,'		#酒捞攫萍静 (256,11)(257,11)(258,11)(259,11)(260,11)(261,10)(262,10)(263,10)(264,10)(265,10)		#榜饭赣 (104,14)(111,14)(112,14)(113,14)(114,14)(115,13)(116,13)(117,13)(118,13)(119,13)		#喉矾靛况废 ( 28,8)( 83,8)( 84,8)( 85,8)( 86,8)( 87,7)( 88,7)( 89,7)( 90,7)( 91,7)		#促农胶农府赣 (348,2)(349,2)(350,2)(351,2)(352,2)(353,1)(354,1)(355,1)(356,1)(357,1)		','		#摹橇酒捞攫萍静 ( 571,1,1800 )		#摹橇榜饭赣 ( 581,1,1800 )		#摹橇喉矾靛况废 ( 581,1,1800 )		#摹橇促农胶农府赣 ( 588,1,1800 )		#摹橇舅沫         ( 570,5,1800)		', 12,227,154,1003,65,70,1311,24,73,'limbo_lair_SW.smp','limbo_lair_SW.ssi','覆焊己巢辑','覆焊巢辑',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (31,6,'NORMAL_FIELD',0,'PUBLIC',NULL,'		#墨坷胶啊叼攫 (147,15)(148,15)(149,15)(150,15)(151,15)(152,15)(153,15)(154,15)(155,15)(156,15)		#喉矾靛况废   ( 28,3)( 83,3)( 84,3)( 85,3)( 86,3)( 87,3)( 88,3)( 89,3)( 90,3)( 91,3)		#榜饭赣       (104,10)(111,10)(112,10)(113,10)(114,10)(115,10)(116,10)(117,10)(118,10)(119,10)		#促农胶农府赣 (266,1)(267,1)(268,1)(269,1)(270,1)(271,1)(272,1)(273,1)(274,1)(275,1)	   ','		#摹橇墨坷胶啊叼攫   (589,1,1800)  		#摹橇喉矾靛况废     (581,1,1800)		#摹橇榜饭赣         (582,1,1800)		#摹橇促农胶农府赣   (588,4,1800)  	   ', 12,227,154,1003,65,70,1311,24,73,'drobeta_NE.smp','drobeta_NE.ssi','靛肺海鸥合悼','靛肺合悼',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (32,6,'NORMAL_FIELD',0,'PUBLIC',NULL,'		#俊胶飘肺捞歹 (207,20)(208,20)(209,20)(210,20)(211,20)(212,20)(213,20)(214,20)(215,20)(216,20)		#饭靛酒捞     (107,5)(138,5)(139,5)(140,5)(141,5)(142,5)(143,5)(144,5)(145,5)(146,5)		#贾廉         (  9,10)( 74,10)( 75,10)( 76,10)( 77,10)( 78,10)( 79,10)( 80,10)( 81,10)( 82,10)        #歹萍胶飘扼捞歹 (105,3)(120,3)(121,3)(122,3)(123,3)(124,3)(125,3)(126,3)(127,3)(128,3)	  ','		#摹橇俊胶飘肺捞歹 ( 577,1,1800)		#摹橇饭靛酒捞     ( 572,1,1800)        #摹橇贾廉         ( 461,1,1800 )        #摹橇歹萍胶飘扼捞歹 ( 576,1,1800)	  ', 12,227,154,1003,65,70,1311,24,73,'drobeta_NW.smp','drobeta_NW.ssi','靛肺海鸥合辑','靛肺合辑',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (33,6,'NORMAL_FIELD',0,'PUBLIC',NULL,'		#墨坷胶唱捞飘 (276,12)(277,12)(278,12)(279,12)(280,12)(281,12)(282,12)(283,12)(284,12)(285,12)		#墨坷胶啊叼攫 (147,12)(148,12)(149,12)(150,12)(151,12)(152,12)(153,12)(154,12)(155,12)(156,12)		#秋困磊靛     (348,3)(349,3)(350,3)(351,3)(352,3)(353,3)(354,3)(355,3)(356,3)(357,3)		#肺靛墨坷胶   (387,2)(388,2)(389,2)(390,2)(391,2)(392,2)(393,2)(394,2)(395,2)(396,2)	  ','		#摹橇墨坷胶唱捞飘 ( 586,1,1800)		#摹橇墨坷胶啊叼攫 ( 589,5,1800)		#摹橇秋困磊靛 ( 587,1,1800)		#摹橇肺靛墨坷胶 ( 592,1,1800)	  ', 12,227,154,1003,65,70,1311,24,73,'drobeta_SE.smp','drobeta_SE.ssi','靛肺海鸥巢悼','靛肺巢悼',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (34,6,'NORMAL_FIELD',0,'PUBLIC',NULL,'		#喉矾靛况废    ( 28,2)( 83,2)( 84,2)( 85,2)( 86,2)( 87,2)( 88,2)( 89,2)( 90,2)( 91,2)		#饭靛酒捞      (107,5)(138,5)(139,5)(140,5)(141,5)(142,5)(143,5)(144,5)(145,5)(146,5)		#墨坷胶唱捞飘  (276,15)(277,15)(278,15)(279,15)(280,15)(281,15)(282,15)(283,15)(284,15)(285,15)		#俊胶飘肺捞歹  (207,15)(208,15)(209,15)(210,15)(211,15)(212,15)(213,15)(214,15)(215,15)(216,15)	  ','		#摹橇喉矾靛况废     ( 581,1,1800)		#摹橇饭靛酒捞       ( 572,1,1800)		#摹橇墨坷胶唱捞飘   ( 586,1,1800)		#摹橇俊胶飘肺捞歹   ( 577,5,1800)	  ', 12,227,154,1003,65,70,1311,24,73,'drobeta_SW.smp','drobeta_SW.ssi','靛肺海鸥巢辑','靛肺巢辑',0, 1, 0, 0, 0,0,0);INSERT INTO ZoneInfo VALUES (41,3,'NORMAL_FIELD',0,'PUBLIC',NULL,'		#俊胶飘肺捞歹 (207,10)(208,10)(209,10)(210,10)(211,10)(212,10)(213,10)(214,10)(215,10)(216,10)		#亥代扼捞历   (230,20)(231,20)(232,20)(233,20)(234,20)(235,20)(236,20)(237,20)(238,20)(239,20)        #府欺         (328,3)(329,3)(330,3)(331,3)(332,3)(333,3)(334,3)(335,3)(336,3)(337,3)		#困档快胶     (197,3)(198,3)(199,3)(200,3)(201,3)(202,3)(203,3)(204,3)(205,3)(206,3)		','		#摹橇俊胶飘肺捞歹 ( 577,1,1800)		#摹橇亥代扼捞历   ( 575,1,1800)        #摹橇府欺         ( 585,1,1800)		#摹橇困档快胶     ( 578,1,1800)		', 12,227,154,1003,65,70,1311,24,73,'rodin_NE.smp','rodin_NE.ssi','肺凋魂合悼','肺凋合悼',1, 1, 0, 0, 0,0,5);INSERT INTO ZoneInfo VALUES (42,3,'NORMAL_FIELD',0,'PUBLIC',NULL,'		#俊胶飘肺捞歹 (207,20)(208,20)(209,20)(210,20)(211,20)(212,19)(213,19)(214,19)(215,19)(216,19)		#溅档快喇 (166,6)(176,6)(177,6)(178,6)(179,6)(180,6)(181,6)(182,6)(183,6)(184,6)		#农覆郊浇肺磐 (286,5)(287,5)(288,5)(289,5)(290,5)(291,4)(292,4)(293,4)(294,4)(295,4)		#墨坷胶啊叼攫 (147,3)(148,3)(149,3)(150,3)(151,3)(152,3)(153,3)(154,3)(155,3)(156,3)		','		#摹橇俊胶飘肺捞歹 ( 577,1,1800)		#摹橇溅档快喇 ( 583,1,1800)		#摹橇农覆郊浇肺磐 ( 584,1,1800)
12 3 4 下一页
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -