wog3_sql_big5.sql

WEBGAME源码,有架设说明,只是非常简单

CREATE TABLE `wog_cp` (
  `p_id` int(11) unsigned NOT NULL auto_increment,
  `p_birth` tinyint(3) unsigned NOT NULL default '0',
  `p_name` varchar(30) NOT NULL default '',
  `p_at` smallint(5) unsigned NOT NULL default '0',
  `p_df` smallint(5) unsigned NOT NULL default '0',
  `p_mat` smallint(5) unsigned NOT NULL default '0',
  `p_mdf` smallint(5) unsigned NOT NULL default '0',
  `p_s` tinyint(1) unsigned NOT NULL default '1',
  `p_url` varchar(100) NOT NULL default '',
  `p_homename` varchar(30) NOT NULL default '',
  `p_str` smallint(5) unsigned NOT NULL default '0',
  `p_life` smallint(5) unsigned NOT NULL default '0',
  `p_vit` smallint(5) unsigned NOT NULL default '0',
  `p_smart` smallint(5) unsigned NOT NULL default '0',
  `p_agl` smallint(5) unsigned NOT NULL default '0',
  `p_hp` int(11) unsigned NOT NULL default '0',
  `p_luck` tinyint(4) unsigned NOT NULL default '0',
  `p_sat_name` varchar(250) default NULL,
  `p_hpmax` int(10) unsigned NOT NULL default '0',
  `p_win_total` int(10) unsigned NOT NULL default '0',
  `p_lv` int(10) unsigned NOT NULL default '0',
  `a_id` smallint(5) unsigned NOT NULL default '0',
  `d_body_id` smallint(5) unsigned NOT NULL default '0',
  `d_foot_id` smallint(5) unsigned NOT NULL default '0',
  `d_hand_id` smallint(5) unsigned NOT NULL default '0',
  `d_head_id` smallint(5) unsigned NOT NULL default '0',
  `d_item_id` smallint(5) unsigned NOT NULL default '0',
  `p_sex` tinyint(1) NOT NULL default '0',
  `p_money` int(10) unsigned NOT NULL default '0',
  `p_exp` int(11) NOT NULL default '0',
  `p_nextexp` int(11) NOT NULL default '0',
  `p_win` int(10) unsigned NOT NULL default '0',
  `p_lost` int(10) unsigned NOT NULL default '0',
  `i_img` smallint(3) NOT NULL default '0',
  `p_img_url` varchar(200) NOT NULL default '',
  `p_img_set` tinyint(3) unsigned NOT NULL default '0',
  `ch_id` tinyint(4) unsigned NOT NULL default '0',
  `p_pid` int(10) NOT NULL default '0',
  `p_au` smallint(5) unsigned NOT NULL default '0',
  `p_be` smallint(5) unsigned NOT NULL default '0',
  `p_ch_s_id` tinyint(2) unsigned NOT NULL default '0',
  `p_g_id` int(10) unsigned NOT NULL default '0',
  `p_place` tinyint(3) unsigned NOT NULL default '0',
  `p_cdate` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`p_id`)
) TYPE=MyISAM;

#
# Dumping data for table wog_cp
#

INSERT INTO `wog_cp` VALUES (1,0,'test',9,9,9,9,1,'http://www.2233.idv.tw/','WOG',9,9,8,9,9,45,0,'',45,1,1,0,0,0,0,0,0,2,8000,0,1000,1,1,1,'',0,6,1,8,8,0,0,1,1148147535);

#
# Table structure for table wog_df
#

DROP TABLE IF EXISTS `wog_df`;
CREATE TABLE `wog_df` (
  `d_id` int(11) NOT NULL auto_increment,
  `d_df` smallint(5) NOT NULL default '0',
  `d_mdf` smallint(5) NOT NULL default '0',
  `d_agl` smallint(5) NOT NULL default '0',
  `d_mstr` smallint(5) NOT NULL default '0',
  `d_magl` smallint(5) NOT NULL default '0',
  `d_msmart` smallint(5) NOT NULL default '0',
  `ch_id` int(11) NOT NULL default '0',
  `d_money` int(11) NOT NULL default '10',
  `d_name` varchar(96) NOT NULL default '',
  `d_type` tinyint(1) unsigned NOT NULL default '0',
  `d_at` smallint(4) NOT NULL default '0',
  `d_mat` smallint(4) NOT NULL default '0',
  `d_dbst` tinyint(1) NOT NULL default '0',
  `d_g_hp` int(10) unsigned NOT NULL default '0',
  `d_g_str` tinyint(3) unsigned NOT NULL default '0',
  `d_g_smart` tinyint(3) unsigned NOT NULL default '0',
  `d_g_agl` tinyint(3) unsigned NOT NULL default '0',
  `d_g_life` tinyint(3) unsigned NOT NULL default '0',
  `d_g_vit` tinyint(3) unsigned NOT NULL default '0',
  `d_g_au` tinyint(3) unsigned NOT NULL default '0',
  `d_g_be` tinyint(3) unsigned NOT NULL default '0',
  `d_g_exp` int(10) unsigned NOT NULL default '0',
  `d_g_bag` tinyint(3) unsigned NOT NULL default '0',
  `d_s` tinyint(3) unsigned default NULL,
  `d_lv` tinyint(3) unsigned NOT NULL default '0',
  `ch_pro` int(10) unsigned NOT NULL default '0',
  `d_send` tinyint(5) unsigned NOT NULL default '0',
  `d_vip` tinyint(1) unsigned NOT NULL default '0',
  PRIMARY KEY  (`d_id`),
  UNIQUE KEY `d_name` (`d_name`),
  KEY `d_lv` (`d_lv`)
) TYPE=MyISAM;

#
# Dumping data for table wog_df
#

INSERT INTO `wog_df` VALUES (1,3,1,2,0,0,0,0,18,'布衣',2,0,0,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);
INSERT INTO `wog_df` VALUES (2,0,0,5,0,0,0,0,14,'木刀',0,15,0,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);
INSERT INTO `wog_df` VALUES (3,0,0,8,0,0,0,0,14,'木弓',0,11,0,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);
INSERT INTO `wog_df` VALUES (4,0,0,5,0,0,0,0,14,'木杖',0,0,15,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);
INSERT INTO `wog_df` VALUES (5,0,0,7,0,0,0,0,89,'小刀',0,18,0,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);
INSERT INTO `wog_df` VALUES (6,0,0,6,8,8,8,0,103,'精致木杖',0,0,18,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);
INSERT INTO `wog_df` VALUES (7,0,0,3,19,10,8,0,269,'弯刀',0,21,0,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);
INSERT INTO `wog_df` VALUES (8,0,0,1,28,15,8,0,429,'短剑',0,26,0,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);
INSERT INTO `wog_df` VALUES (9,0,0,0,38,17,8,0,752,'长剑',0,30,0,0,0,0,0,0,0,0,0,0,0,0,NULL,2,0,0,0);
INSERT INTO `wog_df` VALUES (10,0,0,8,44,21,8,0,1397,'火热弯刀',0,37,0,0,0,0,0,0,0,0,0,0,0,0,NULL,2,0,0,0);
INSERT INTO `wog_df` VALUES (11,0,0,6,46,23,8,0,1693,'双头剑',0,44,0,0,0,0,0,0,0,0,0,0,0,0,NULL,2,0,0,0);
INSERT INTO `wog_df` VALUES (12,0,0,0,54,25,8,0,1988,'强化之剑',0,50,0,0,0,0,0,0,0,0,0,0,0,0,NULL,2,0,0,0);
INSERT INTO `wog_df` VALUES (13,0,0,12,71,31,16,0,3922,'雷鸣剑',0,70,0,0,0,0,0,0,0,0,0,0,0,0,NULL,2,0,0,0);
INSERT INTO `wog_df` VALUES (14,0,0,0,61,46,16,0,4003,'火鸣剑',0,76,0,0,0,0,0,0,0,0,0,0,0,0,NULL,2,0,0,0);
INSERT INTO `wog_df` VALUES (15,5,0,10,86,46,16,0,9697,'卡西奈特剑',0,88,0,0,0,0,0,0,0,0,0,0,0,0,NULL,3,0,0,0);
INSERT INTO `wog_df` VALUES (16,0,20,12,71,36,91,0,4863,'魔法剑',0,75,75,0,0,0,0,0,0,0,0,0,0,0,NULL,3,0,0,0);
INSERT INTO `wog_df` VALUES (17,10,10,21,127,41,28,0,23264,'陶瓷剑',0,129,20,0,0,0,0,0,0,0,0,0,0,0,NULL,3,0,0,0);
INSERT INTO `wog_df` VALUES (18,25,0,-15,161,16,16,0,10,'亚克铁锤',0,165,0,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0);
INSERT INTO `wog_df` VALUES (19,10,5,0,196,46,16,0,81291,'怒之剑',0,174,80,0,0,0,0,0,0,0,0,0,0,0,NULL,4,0,0,0);
INSERT INTO `wog_df` VALUES (20,10,0,0,161,16,16,0,46502,'重剑',0,149,0,0,0,0,0,0,0,0,0,0,0,0,NULL,4,0,0,0);
INSERT INTO `wog_df` VALUES (21,15,15,15,213,56,80,0,137974,'龙剑',0,180,165,0,0,0,0,0,0,0,0,0,0,0,NULL,4,0,0,0);
INSERT INTO `wog_df` VALUES (22,10,0,10,256,70,16,0,400381,'狂暴剑',0,260,100,0,0,0,0,0,0,0,0,0,0,0,NULL,4,0,0,0);
INSERT INTO `wog_df` VALUES (23,0,5,5,8,8,20,0,564,'魔法杖',0,0,23,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);
INSERT INTO `wog_df` VALUES (24,0,6,5,8,8,51,0,402,'魔弹之杖',0,0,30,0,0,0,0,0,0,0,0,0,0,0,NULL,2,0,0,0);
INSERT INTO `wog_df` VALUES (25,0,0,10,8,8,56,0,1075,'雷之杖',0,0,37,0,0,0,0,0,0,0,0,0,0,0,NULL,2,0,0,0);
INSERT INTO `wog_df` VALUES (26,0,5,0,8,8,61,0,1371,'治疗之杖',0,0,44,0,0,0,0,0,0,0,0,0,0,0,NULL,2,0,0,0);
INSERT INTO `wog_df` VALUES (27,0,0,6,8,8,61,0,1693,'毒之杖',0,0,61,0,0,0,0,0,0,0,0,0,0,0,NULL,2,0,0,0);
INSERT INTO `wog_df` VALUES (28,5,5,12,10,10,76,0,2498,'圣魔杖',0,0,66,0,0,0,0,0,0,0,0,0,0,0,NULL,2,0,0,0);
INSERT INTO `wog_df` VALUES (29,10,0,0,16,16,86,0,4029,'可巴斯之杖',0,0,78,0,0,0,0,0,0,0,0,0,0,0,NULL,3,0,0,0);
INSERT INTO `wog_df` VALUES (30,0,10,12,16,16,93,0,7039,'妖精之杖',0,0,86,0,0,0,0,0,0,0,0,0,0,0,NULL,3,0,0,0);
INSERT INTO `wog_df` VALUES (31,0,0,0,16,16,106,0,4782,'永恒之杖',0,25,96,0,0,0,0,0,0,0,0,0,0,0,NULL,3,0,0,0);
INSERT INTO `wog_df` VALUES (32,12,10,0,16,16,126,0,8005,'圣光杖',0,35,130,0,0,0,0,0,0,0,0,0,0,0,NULL,3,0,0,0);
INSERT INTO `wog_df` VALUES (33,0,0,0,16,16,149,0,15419,'精灵之力',0,0,133,0,0,0,0,0,0,0,0,0,0,0,NULL,3,0,0,0);
INSERT INTO `wog_df` VALUES (34,0,10,10,16,16,179,0,27832,'火球术',0,0,152,0,0,0,0,0,0,0,0,0,0,0,NULL,4,0,0,0);
INSERT INTO `wog_df` VALUES (35,10,0,0,16,16,204,0,10,'冰柱术',0,0,159,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0);
INSERT INTO `wog_df` VALUES (36,0,0,15,16,16,207,0,49268,'电光球',0,0,184,0,0,0,0,0,0,0,0,0,0,0,NULL,4,0,0,0);
INSERT INTO `wog_df` VALUES (37,0,10,0,16,16,249,0,94185,'火焰术',0,0,200,0,0,0,0,0,0,0,0,0,0,0,NULL,4,0,0,0);
INSERT INTO `wog_df` VALUES (38,10,0,0,16,16,260,0,202715,'冰雪术',0,0,237,0,0,0,0,0,0,0,0,0,0,0,NULL,4,0,0,0);
INSERT INTO `wog_df` VALUES (39,0,0,8,8,12,8,0,254,'回旋刀',0,19,0,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);
INSERT INTO `wog_df` VALUES (40,0,0,10,8,16,8,0,358,'火焰弓箭',0,23,0,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);
INSERT INTO `wog_df` VALUES (41,0,0,12,8,20,8,0,546,'侠盗弓箭',0,23,0,0,0,0,0,0,0,0,0,0,0,0,NULL,1,0,0,0);