test123.sql

武侠世界Flash版

(24,1100702,'星宿海矿点2',1,25,1222200,1222214,1222213,1222240,1121001,1120002,1121001,1120002,1121003,1120004,1121003,1120004,1121103,1120104,1201000,1201003,1211016,1211017,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(25,1200703,'星宿海矿点3',1,25,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2),
(26,1100901,'翠竹林矿点1',1,25,1222200,1222215,1222216,1222239,1121001,1120002,1121001,1120002,1121003,1120004,1121003,1120004,1121103,1120104,1201000,1201003,1211020,1211021,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(27,1100902,'翠竹林矿点2',1,25,1222200,1222216,1222215,1222240,1121001,1120002,1121001,1120002,1121003,1120004,1121003,1120004,1121103,1120104,1201000,1201003,1211022,1211023,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(28,1200903,'翠竹林矿点2',1,25,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2),
(29,2100001,'龙门村草药1',2,25,1222100,1222101,1222149,1222135,1131001,1130002,1131001,1130002,1131001,1130002,1131001,1130002,1131101,1130102,1201000,1201003,1211000,1211001,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(30,2100002,'龙门村草药2',2,25,1222141,1222149,1222101,1222135,1131001,1130002,1131001,1130002,1131001,1130002,1131001,1130002,1131101,1130102,1201000,1201003,1211002,1211003,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(31,2100101,'乡间小路草药1',2,25,1222142,1222108,1222106,1222136,1131001,1130002,1131001,1130002,1131001,1130002,1131001,1130002,1131101,1130102,1201000,1201003,1211002,1211003,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(32,2100102,'乡间小路草药2',2,25,1222143,1222106,1222108,1222136,1131001,1130002,1131001,1130002,1131001,1130002,1131001,1130002,1131101,1130102,1201000,1201003,1211004,1211005,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(33,2200103,'乡间小路草药3',2,25,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2),
(34,2100501,'青柯坪草药1',2,25,1222144,1222109,1222110,1222137,1131001,1130002,1131001,1130002,1131003,1130004,1131003,1130004,1131103,1130104,1201000,1201003,1211008,1211009,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(35,2100502,'青柯坪草药2',2,25,1222145,1222110,1222109,1222138,1131001,1130002,1131001,1130002,1131003,1130004,1131003,1130004,1131103,1130104,1201000,1201003,1211010,1211011,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(36,2200503,'青柯坪草药3',2,25,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2),
(37,2100701,'星宿海草药1',2,25,1222146,1222113,1222114,1222139,1131001,1130002,1131001,1130002,1131003,1130004,1131003,1130004,1131103,1130104,1201000,1201003,1211014,1211015,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(38,2100702,'星宿海草药2',2,25,1222147,1222114,1222113,1222140,1131001,1130002,1131001,1130002,1131003,1130004,1131003,1130004,1131103,1130104,1201000,1201003,1211016,1211017,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(39,2200703,'星宿海草药3',2,25,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2),
(40,2100901,'翠竹林草药1',2,25,1222147,1222115,1222116,1222140,1131001,1130002,1131001,1130002,1131003,1130004,1131003,1130004,1131103,1130104,1201000,1201003,1211020,1211021,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(41,2100902,'翠竹林草药2',2,25,1222147,1222116,1222115,1222140,1131001,1130002,1131001,1130002,1131003,1130004,1131003,1130004,1131103,1130104,1201000,1201003,1211022,1211023,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(42,2200903,'翠竹林草药2',2,25,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2,-2),
(43,3100001,'龙门村鸡窝',3,25,1222300,1222301,1222302,1222303,1142001,1142001,1142001,1142001,1142001,1142001,1142001,1142001,1142101,1142101,1201000,1201003,1211000,1211001,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(44,3100101,'乡间小路鸡窝',3,25,1222300,1222310,1222311,1222303,1142001,1142001,1142001,1142001,1142001,1142001,1142001,1142001,1142101,1142101,1201000,1201003,1211002,1211003,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(45,3100501,'青柯坪鸡窝',3,25,1222300,1222312,1222313,1222303,1142001,1142001,1142001,1142001,1142001,1142001,1142002,1142002,1142102,1142102,1201000,1201003,1211008,1211009,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(46,3100701,'星宿海鸡窝',3,25,1222300,1222314,1222315,1222303,1142001,1142001,1142001,1142001,1142001,1142001,1142002,1142002,1142102,1142102,1201000,1201003,1211014,1211015,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(47,3100901,'翠竹林鸡窝1',3,25,1222300,1222316,1222317,1222303,1142001,1142001,1142001,1142001,1142001,1142001,1142002,1142002,1142102,1142102,1201000,1201003,1211020,1211021,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(48,4100001,'龙门村马厩',4,25,1222304,1222305,1222306,1222309,1152001,1152001,1152001,1152001,1152001,1152001,1152001,1152001,1152101,1152101,1201000,1201003,1211004,1211005,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(49,4100101,'乡间小路马厩',4,25,1222304,1222305,1222308,1222309,1152001,1152001,1152001,1152001,1152001,1152001,1152001,1152001,1152101,1152101,1201000,1201003,1211002,1211003,1222108,1222208,4280,3000,1800,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(50,5100101,'乡间小路青蛙点',5,20,1222400,1222401,1222402,1222403,1182001,1182001,1182001,1182001,1182001,1182001,1182001,1182001,1182101,1182101,1201000,1201003,1211000,1211001,1222108,1222208,3080,3000,3000,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(51,6100501,'青柯坪蜻蜓点',6,20,1222408,1222409,1222410,1222411,1172001,1172001,1172001,1172001,1172001,1172001,1172002,1172002,1172102,1172102,1201000,1201003,1211010,1211011,1222108,1222208,3080,3000,3000,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(52,7100701,'星宿海蛾子点',7,20,1222412,1222413,1222414,1222415,1172001,1172001,1172001,1172001,1172001,1172001,1172002,1172002,1172102,1172102,1201000,1201003,1211016,1211017,1222108,1222208,3080,3000,3000,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150),
(53,8100001,'龙门村箱子',8,25,1162001,1162001,1162001,1162001,1162001,1162001,1162001,1162001,1162101,1162101,1201000,1201003,1211000,1211001,1201000,1201003,1222300,1222005,1222102,1222202,1,1,1,1,1,1,1,1,1,1,600,600,600,600,2240,2200,800,800,800,800),
(54,8100101,'乡间小路箱子',8,25,1162001,1162001,1162001,1162001,1162001,1162001,1162001,1162001,1162101,1162101,1201000,1201003,1211002,1211003,1201000,1201003,1222301,1222006,1222108,1222203,1,1,1,1,1,1,1,1,1,1,600,600,600,600,2240,2200,800,800,800,800),
(55,8100201,'扬州东大街箱子',8,25,1162001,1162001,1162001,1162001,1162001,1162001,1162002,1162002,1162102,1162102,1201000,1201003,1211004,1211005,1201000,1201003,1222302,1222007,1222104,1222204,1,1,1,1,1,1,1,1,1,1,600,600,600,600,2240,2200,800,800,800,800),
(56,8100301,'扬州城广场箱子',8,25,1162001,1162001,1162001,1162001,1162001,1162001,1162002,1162002,1162102,1162102,1201000,1201003,1211006,1211007,1201000,1201003,1222304,1222008,1222105,1222205,1,1,1,1,1,1,1,1,1,1,600,600,600,600,2240,2200,800,800,800,800),
(57,8100501,'青柯坪箱子',8,25,1162001,1162001,1162001,1162001,1162001,1162001,1162002,1162002,1162102,1162102,1201000,1201003,1211008,1211009,1201000,1201003,1222305,1222009,1222106,1222206,1,1,1,1,1,1,1,1,1,1,600,600,600,600,2240,2200,800,800,800,800),
(58,8100401,'华山派箱子',8,25,1162001,1162001,1162001,1162001,1162001,1162001,1162002,1162002,1162102,1162102,1201000,1201003,1211010,1211011,1201000,1201003,1222306,1222010,1222107,1222207,1,1,1,1,1,1,1,1,1,1,600,600,600,600,2240,2200,800,800,800,800),(59,8100701,'星宿海箱子',8,25,1162001,1162001,1162001,1162001,1162001,1162001,1162002,1162002,1162102,1162102,1201000,1201003,1211012,1211013,1201000,1201003,1222307,1222011,1222108,1222208,1,1,1,1,1,1,1,1,1,1,600,600,600,600,2240,2200,800,800,800,800),(60,8100601,'星宿派箱子',8,25,1162001,1162001,1162001,1162001,1162001,1162001,1162002,1162002,1162102,1162102,1201000,1201003,1211014,1211015,1201000,1201003,1222308,1222012,1222109,1222209,1,1,1,1,1,1,1,1,1,1,600,600,600,600,2240,2200,800,800,800,800),(61,8100801,'丐帮箱子',8,25,1162001,1162001,1162001,1162001,1162001,1162001,1162002,1162002,1162102,1162102,1201000,1201003,1211016,1211017,1201000,1201003,1222308,1222012,1222109,1222209,1,1,1,1,1,1,1,1,1,1,600,600,600,600,2240,2200,800,800,800,800),
(62,8100901,'翠竹林箱子',8,25,1162001,1162001,1162001,1162001,1162001,1162001,1162002,1162002,1162102,1162102,1201000,1201003,1211018,1211019,1201000,1201003,1222308,1222012,1222109,1222209,1,1,1,1,1,1,1,1,1,1,600,600,600,600,2240,2200,800,800,800,800),(63,9100901,'翠竹林蜂窝点',9,20,1222318,1222319,1222320,1222321,1172001,1172001,1172001,1172001,1172001,1172001,1172002,1172002,1172102,1172102,1201000,1201003,1211022,1211023,1222108,1222208,3080,3000,3000,10,1,1,1,1,1,1,1,1,1,1,150,150,150,150,150,150);


DROP TABLE IF EXISTS `campaign`;

CREATE TABLE `campaign` (
  `ID` int(11) NOT NULL auto_increment,
  `GLOBAL_CHARACTER_ID` int(11) NOT NULL default '0',
  `TASK_ID` int(11) NOT NULL default '0',
  `Date` varchar(24) NOT NULL default '',
  `Count` int(11) NOT NULL default '-1',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


DROP TABLE IF EXISTS `characters`;

CREATE TABLE `characters` (
  `GLOBAL_CHARACTER_ID` int(11) NOT NULL auto_increment,
  `USER_ACCOUNT_ID` int(11) NOT NULL default '-1',
  `IN_GAME` int(4) NOT NULL default '0',
  `CHAR_NAME` varchar(32) NOT NULL default '',
  `CHAR_SEX` int(4) NOT NULL default '0',
  `CHAR_GM` int(11) NOT NULL default '0',
  `CHAR_SCENEID` int(11) NOT NULL default '0',
  `CHAR_SCENE_X` int(11) NOT NULL default '37',
  `CHAR_SCENE_Y` int(11) NOT NULL default '3',
  `CHAR_SCENE_DIRECTION` int(11) NOT NULL default '2',
  `CHAR_EQUIP` int(4) NOT NULL default '0',
  `CHAR_EQUIP_STRING` varchar(32) NOT NULL default '',
  `CHAR_LEVEL` int(4) NOT NULL default '1',
  `CHAR_EXP` int(11) NOT NULL default '0',
  `CHAR_NEXT_EXP` int(11) NOT NULL default '0',
  `CHAR_MONEY` int(11) NOT NULL default '0',
  `CHAR_MONEY_BANK` int(11) NOT NULL default '0',
  `CHAR_HMONEY` int(11) NOT NULL default '0',
  `CHAR_CHENGHAO` varchar(12) NOT NULL default '',
  `CHAR_MINGSHENG` varchar(12) NOT NULL default '',
  `CHAR_MENPAI_ID` int(4) NOT NULL default '0',
  `CHAR_MENPAI` varchar(12) NOT NULL default '',
  `CHAR_BANGHUI_ID` int(4) NOT NULL default '0',
  `CHAR_BANGHUI` varchar(12) NOT NULL default '',
  `CHAR_PEIOU_ID` int(4) NOT NULL default '0',
  `CHAR_PEIOU` varchar(12) NOT NULL default '',
  `CHAR_CUR_HP` int(11) NOT NULL default '0',
  `CHAR_MAX_HP` int(11) NOT NULL default '0',
  `CHAR_CUR_MP` int(11) NOT NULL default '0',
  `CHAR_MAX_MP` int(11) NOT NULL default '0',
  `CHAR_JH_SHENGWANG` int(11) NOT NULL default '0',
  `CHAR_MP_SHENGWANG` int(11) NOT NULL default '0',
  `CHAR_BP_GONGXIAN` int(11) NOT NULL default '0',
  `CHAR_PK` int(11) NOT NULL default '0',
  `CHAR_BINGQIPU` int(11) NOT NULL default '0',
  `CHAR_WENCAI` int(11) NOT NULL default '0',
  `CHAR_FUYUAN` int(11) NOT NULL default '0',
  `CHAR_RONGMAO` int(11) NOT NULL default '0',
  `CHAR_SHANE` int(11) NOT NULL default '0',
  `CHAR_WAI_ATTACK` int(11) NOT NULL default '0',
  `CHAR_WAI_DEFEND` int(11) NOT NULL default '0',
  `CHAR_NEI_ATTACK` int(11) NOT NULL default '0',
  `CHAR_NEI_DEFEND` int(11) NOT NULL default '0',