暗黑3暴击伤害上限中"无法加入该频道,这类频道的数量已达到上限(Code10017)"怎么解决，速度求帮助啊
点击联系发帖人
时间：2015-04-23 00:17
/ newProBase
项目语言:C++
权限:read-only(如需更高权限请先加入项目)
newProBase/
Index: account.sql
===================================================================
--- account.sql (revision 0)
+++ account.sql (revision 2)
@@ -0,0 +1,1217 @@
+-- --------------------------------------------------------
120.26.67.185
+-- 服务器版本:
5.6.11 - MySQL Community Server (GPL)
+-- 服务器操作系统:
+-- HeidiSQL 版本:
9.2.0.4950
+-- --------------------------------------------------------
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET NAMES utf8mb4 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
表 wg01_account.account 结构
+DROP TABLE IF EXISTS `account`;
+CREATE TABLE IF NOT EXISTS `account` (
`id` int(4) unsigned NOT NULL AUTO_INCREMENT COMMENT '账号id, 从10W开始',
`name` varchar(64) NOT NULL DEFAULT '' COMMENT '账号名',
`password` varchar(128) NOT NULL DEFAULT '' COMMENT '账号密码',
`reg_time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '注册utc时间',
`account_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号类型, 0普通, 1GM, 2高级GM',
`account_status` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号状态, 0正常, 1临时封停, 2永久封停',
`account_status_param` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号状态补充参数, 临时封停结束utc时间',
`platform` varchar(32) NOT NULL DEFAULT '' COMMENT '平台',
`channel` varchar(32) NOT NULL DEFAULT '' COMMENT '渠道',
`os` varchar(32) NOT NULL DEFAULT '' COMMENT '系统',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `platform` (`platform`),
KEY `reg_time` (`reg_time`),
KEY `channel` (`channel`)
+) ENGINE=InnoDB AUTO_INCREMENT=300073 DEFAULT CHARSET=utf8 COMMENT='账号表';
+-- 正在导出表
wg01_account.account 的数据：~13 rows (大约)
+/*!40000 ALTER TABLE `account` DISABLE KEYS */;
+REPLACE INTO `account` (`id`, `name`, `password`, `reg_time`, `account_type`, `account_status`, `account_status_param`, `platform`, `channel`, `os`) VALUES
+ (100000, 'pwq1', '1', 0, 2, 0, 0, '', '', ''),
+ (100001, 'lms', '1', 0, 2, 0, 0, '', '', ''),
+ (100002, 'pwq2', '1', 0, 2, 0, 0, '', '', ''),
+ (100003, 't1', '1', 0, 2, 0, 0, '', '', ''),
+ (100004, 't2', '1', 0, 2, 0, 0, '', '', ''),
+ (100005, 'cjj', '1', 0, 2, 0, 0, '', '', ''),
+ (100006, 'cjj2', '1', 0, 2, 0, 0, '', '', ''),
+ (300067, 'lyh1', '1', 0, 2, 0, 0, '', '', ''),
+ (300068, 'lyh2', '1', 0, 2, 0, 0, '', '', ''),
+ (300069, 'rhx1', '1', 0, 2, 0, 0, '', '', ''),
+ (300070, 'rhx2', '1', 0, 2, 0, 0, '', '', ''),
+ (300071, 'test1', '1', 0, 2, 0, 0, '', '', ''),
+ (300072, 'test2', '1', 0, 2, 0, 0, '', '', '');
+/*!40000 ALTER TABLE `account` ENABLE KEYS */;
表 wg01_account.gm_mac 结构
+DROP TABLE IF EXISTS `gm_mac`;
+CREATE TABLE IF NOT EXISTS `gm_mac` (
`address_mac` varchar(32) NOT NULL DEFAULT '' COMMENT 'mac地址',
`param_string` varchar(64) NOT NULL DEFAULT '' COMMENT '注释参数',
UNIQUE KEY `address_mac` (`address_mac`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='gm的mac地址';
+-- 正在导出表
wg01_account.gm_mac 的数据：~0 rows (大约)
+/*!40000 ALTER TABLE `gm_mac` DISABLE KEYS */;
+/*!40000 ALTER TABLE `gm_mac` ENABLE KEYS */;
表 wg01_account.log_item 结构
+DROP TABLE IF EXISTS `log_item`;
+CREATE TABLE IF NOT EXISTS `log_item` (
`id` bigint(8) NOT NULL AUTO_INCREMENT,
`user_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '玩家id',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '线路',
`time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '时间',
`flow_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '流向类型',
`item_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '物品id',
`item_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '物品类型',
`reason` varchar(127) NOT NULL DEFAULT '' COMMENT '物品流向原因',
`reasion_number` int(4) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `server_group` (`server_group`),
KEY `flow_type` (`flow_type`),
KEY `time` (`time`),
KEY `item_type` (`item_type`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='物品流向表';
+-- 正在导出表
wg01_account.log_item 的数据：~0 rows (大约)
+/*!40000 ALTER TABLE `log_item` DISABLE KEYS */;
+/*!40000 ALTER TABLE `log_item` ENABLE KEYS */;
表 wg01_account.log_loginout 结构
+DROP TABLE IF EXISTS `log_loginout`;
+CREATE TABLE IF NOT EXISTS `log_loginout` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增长id',
`loginout` int(4) NOT NULL DEFAULT '0' COMMENT '登入1 登出2',
`account_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号id',
`account_name` varchar(64) NOT NULL DEFAULT '' COMMENT '账号名',
`user_id` int(4) NOT NULL DEFAULT '0' COMMENT '角色id',
`user_name` varchar(64) NOT NULL DEFAULT '' COMMENT '角色名',
`time` int(4) NOT NULL DEFAULT '0' COMMENT 'utc时间戳',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=192 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='登入登出日志';
+-- 正在导出表
wg01_account.log_loginout 的数据：~190 rows (大约)
+/*!40000 ALTER TABLE `log_loginout` DISABLE KEYS */;
+REPLACE INTO `log_loginout` (`id`, `loginout`, `account_id`, `account_name`, `user_id`, `user_name`, `time`, `server_group`, `server_line`) VALUES
+ (2, 1, 100000, 'pwq1', , '彭文奇', , 1, 0),
+ (3, 2, 100000, 'pwq1', , '彭文奇', , 1, 0),
+ (4, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (5, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (6, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (7, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (8, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (9, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (10, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (11, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (12, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (13, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (14, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (15, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (16, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (17, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (18, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (19, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (20, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (21, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (22, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (23, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (24, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (25, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (26, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (27, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (28, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (29, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (30, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (31, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (32, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (33, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (34, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (35, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (36, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (37, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (38, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (39, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (40, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (41, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (42, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (43, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (44, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (45, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (46, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (47, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (48, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (49, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (50, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (51, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (52, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (53, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (54, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (55, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (56, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (57, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (58, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (59, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (60, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (61, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (62, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (63, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (64, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (65, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (66, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (67, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (68, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (69, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (70, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (71, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (72, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (73, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (74, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (75, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (76, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (77, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (78, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (79, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (80, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (81, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (82, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (83, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (84, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (85, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (86, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (87, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (88, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (89, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (90, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (91, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (92, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (93, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (94, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (95, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (96, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (97, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (98, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (99, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (100, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (101, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (102, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (103, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (104, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (105, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (106, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (107, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (108, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (109, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (110, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (111, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (112, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (113, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (114, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (115, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (116, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (117, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (118, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (119, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (120, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (121, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (122, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (123, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (124, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (125, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (126, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (127, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (128, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (129, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (130, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (131, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (132, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (133, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (134, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (135, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (136, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (137, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (138, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (139, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (140, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (141, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (142, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (143, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (144, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (145, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (146, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (147, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (148, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (149, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (150, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (151, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (152, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (153, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (154, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (155, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (156, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (157, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (158, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (159, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (160, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (161, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (162, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (163, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (164, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (165, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (166, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (167, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (168, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (169, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (170, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (171, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (172, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (173, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (174, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (175, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (176, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (177, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (178, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (179, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (180, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (181, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (182, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (183, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (184, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (185, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (186, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (187, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (188, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (189, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (190, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (191, 2, 100000, 'pwq1', , '彭文奇', , 1, 1);
+/*!40000 ALTER TABLE `log_loginout` ENABLE KEYS */;
表 wg01_account.log_money 结构
+DROP TABLE IF EXISTS `log_money`;
+CREATE TABLE IF NOT EXISTS `log_money` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号id',
`user_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线',
`flow_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '类型, 1获得, 2消费',
`time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '发生时间, utc秒',
`reason` varchar(127) NOT NULL DEFAULT '未填写' COMMENT '记录日志原因',
`reason_amount` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '记录日志数量',
`money_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '金钱类型',
`point` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作点数',
`after_point` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作后点数',
`del_time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`),
KEY `user_id` (`user_id`),
KEY `server_group` (`server_group`),
KEY `time` (`time`),
KEY `flow_type` (`flow_type`),
KEY `money_type` (`money_type`),
KEY `del_time` (`del_time`)
+) ENGINE=InnoDB AUTO_INCREMENT=232 DEFAULT CHARSET=utf8 COMMENT='金钱日志';
+-- 正在导出表
wg01_account.log_money 的数据：~231 rows (大约)
+/*!40000 ALTER TABLE `log_money` DISABLE KEYS */;
+REPLACE INTO `log_money` (`id`, `account_id`, `user_id`, `server_group`, `server_line`, `flow_type`, `time`, `reason`, `reason_amount`, `money_type`, `point`, `after_point`, `del_time`) VALUES
+ (1, , 1, 1, , 'gm命令', 1, 501, ),
+ (2, , 1, 1, , 'gm命令', 1, 130, 30, 30, ),
+ (3, , 1, 1, , 'gm命令', 1, 130, 30, 60, ),
+ (4, , 1, 1, , 'gm命令', 1, 130, 30, 90, ),
+ (5, , 1, 1, , 'gm命令', 1, 130, 30, 120, ),
+ (6, , 1, 2, , 'gm命令', 1, 130, 100, 20, ),
+ (7, , 1, 2, , 'gm命令', 1, 130, 2, 18, ),
+ (8, , 1, 1, , 'gm命令', 1, 130, 20, 38, ),
+ (9, , 2, 1, , '背包上限购买', 1, 130, 2, 2, ),
+ (10, , 2, 1, , '背包上限购买', 1, 130, 2, 4, ),
+ (11, , 2, 1, , '背包上限购买', 1, 130, 2, 6, ),
+ (12, , 2, 1, , '背包上限购买', 1, 130, 2, 8, ),
+ (13, , 2, 1, , '背包上限购买', 1, 130, 2, 10, ),
+ (14, , 2, 1, , '背包上限购买', 1, 130, 2, 12, ),
+ (15, , 2, 1, , '背包上限购买', 1, 130, 2, 14, ),
+ (16, , 2, 1, , '背包上限购买', 1, 130, 2, 16, ),
+ (17, , 2, 1, , '背包上限购买', 1, 130, 2, 18, ),
+ (18, , 2, 1, , '背包上限购买', 1, 130, 2, 20, ),
+ (19, , 2, 1, , '背包上限购买', 1, 130, 2, 22, ),
+ (20, , 2, 1, , '背包上限购买', 1, 130, 2, 24, ),
+ (21, , 2, 1, , '背包上限购买', 1, 130, 2, 26, ),
+ (22, , 2, 1, , '背包上限购买', 1, 130, 2, 28, ),
+ (23, , 2, 1, , '背包上限购买', 1, 130, 2, 30, ),
+ (24, , 2, 1, , '背包上限购买', 1, 130, 2, 32, ),
+ (25, , 2, 1, , '背包上限购买', 1, 130, 2, 34, ),
+ (26, , 2, 1, , '背包上限购买', 1, 130, 2, 36, ),
+ (27, , 2, 1, , '背包上限购买', 1, 130, 2, 38, ),
+ (28, , 2, 2, , 'gm命令', 1, 130, 20, 18, ),
+ (29, , 2, 1, , '背包上限购买', 1, 130, 2, 20, ),
+ (30, , 2, 1, , '背包上限购买', 1, 130, 2, 22, ),
+ (31, , 2, 1, , '背包上限购买', 1, 130, 2, 24, ),
+ (32, , 2, 1, , '背包上限购买', 1, 130, 2, 26, ),
+ (33, , 2, 1, , '背包上限购买', 1, 130, 2, 28, ),
+ (34, , 2, 1, , '背包上限购买', 1, 130, 2, 30, ),
+ (35, , 2, 1, , '背包上限购买', 1, 130, 2, 32, ),
+ (36, , 2, 1, , '背包上限购买', 1, 130, 2, 34, ),
+ (37, , 2, 1, , '背包上限购买', 1, 130, 2, 36, ),
+ (38, , 2, 1, , '背包上限购买', 1, 130, 2, 38, ),
+ (39, , 2, 1, , '背包上限购买', 1, 130, 2, 40, ),
+ (40, , 2, 1, , '背包上限购买', 1, 130, 2, 42, ),
+ (41, , 2, 1, , '背包上限购买', 1, 130, 2, 44, ),
+ (42, , 1, 1, , 'gm命令', 1, 101, , ),
+ (43, , 1, 1, , 'gm命令', 1, 102, , ),
+ (44, , 1, 1, , 'gm命令', 1, 103, 3, ),
+ (45, , 1, 1, , 'gm命令', 1, 104, , ),
+ (46, , 1, 1, , 'gm命令', 1, 105, , ),
+ (47, , 1, 1, , 'gm命令', 1, 106, , ),
+ (48, , 1, 1, , 'gm命令', 1, 107, , ),
+ (49, , 1, 1, , 'gm命令', 1, 108, , ),
+ (50, , 1, 1, , 'gm命令', 1, 109, , ),
+ (51, , 1, 1, , 'gm命令', 1, 110, , ),
+ (52, , 1, 1, , 'gm命令', 1, 111, , ),
+ (53, , 1, 1, , 'gm命令', 1, 112, , ),
+ (54, , 1, 1, , 'gm命令', 1, 113, , ),
+ (55, , 1, 1, , 'gm命令', 1, 114, , ),
+ (56, , 1, 1, , 'gm命令', 1, 115, , ),
+ (57, , 1, 1, , 'gm命令', 1, 116, , ),
+ (58, , 1, 1, , 'gm命令', 1, 117, , ),
+ (59, , 1, 1, , 'gm命令', 1, 118, , ),
+ (60, , 1, 2, , '卡牌强化', 1, 101, 10, 19399),
+ (61, , 1, 2, , '卡牌强化', 1, 101, 14, 19407),
+ (62, , 1, 2, , '卡牌强化', 1, 102, 10, ),
+ (63, , 1, 2, , '卡牌强化', 1, 102, 14, ),
+ (64, , 1, 2, , '卡牌强化', 1, 102, 18, ),
+ (65, , 1, 2, , '卡牌强化', 1, 103, 16, ),
+ (66, , 1, 2, , '卡牌强化', 1, 103, 24, ),
+ (67, , 1, 2, , '卡牌强化', 1, 103, 24, ),
+ (68, , 1, 2, , '卡牌强化', 1, 103, 24, ),
+ (69, , 1, 2, , '卡牌强化', 1, 104, 16, 19440),
+ (70, , 1, 2, , '卡牌强化', 1, 104, 18, 19443),
+ (71, , 1, 2, , '卡牌强化', 1, 105, 16, 9460),
+ (72, , 1, 2, , '卡牌强化', 1, 105, 24, 9462),
+ (73, , 1, 2, , '卡牌强化', 1, 105, 24, 9467),
+ (74, , 1, 2, , '卡牌强化', 1, 105, 24, 9468),
+ (75, , 1, 2, , '卡牌强化', 1, 110, 15, 9470),
+ (76, , 1, 2, , '卡牌强化', 1, 115, 3, 9470),
+ (77, , 1, 2, , '卡牌强化', 1, 110, 15, 9486),
+ (78, , 1, 2, , '卡牌强化', 1, 115, 3, 9486),
+ (79, , 1, 2, , '卡牌强化', 1, 117, 1, 9486),
+ (80, , 1, 2, , '卡牌强化', 1, 110, 15, 9490),
+ (81, , 1, 2, , '卡牌强化', 1, 115, 4, 9490),
+ (82, , 1, 2, , '卡牌强化', 1, 117, 1, 9490),
+ (83, , 1, 2, , '卡牌强化', 1, 110, 15, 9497),
+ (84, , 1, 2, , '卡牌强化', 1, 115, 4, 9497),
+ (85, , 1, 2, , '卡牌强化', 1, 117, 2, 9497),
+ (86, , 1, 2, , '卡牌强化', 1, 110, 15, 9504),
+ (87, , 1, 2, , '卡牌强化', 1, 115, 4, 9504),
+ (88, , 1, 2, , '卡牌强化', 1, 117, 2, 9504),
+ (89, , 1, 2, , '卡牌强化', 1, 110, 15, 9506),
+ (90, , 1, 2, , '卡牌强化', 1, 115, 8, 9506),
+ (91, , 1, 2, , '卡牌强化', 1, 117, 2, 9506),
+ (92, , 1, 2, , '卡牌强化', 1, 110, 15, 9509),
+ (93, , 1, 2, , '卡牌强化', 1, 115, 8, 9509),
+ (94, , 1, 2, , '卡牌强化', 1, 117, 2, 9509),
+ (95, , 1, 2, , '卡牌强化', 1, 110, 15, 9511),
+ (96, , 1, 2, , '卡牌强化', 1, 115, 8, 9511),
+ (97, , 1, 2, , '卡牌强化', 1, 117, 2, 9511),
+ (98, , 1, 2, , '卡牌强化', 1, 110, 15, 9513),
+ (99, , 1, 2, , '卡牌强化', 1, 115, 8, 9513),
+ (100, , 1, 2, , '卡牌强化', 1, 117, 2, 9513),
+ (101, , 1, 2, , '卡牌强化', 1, 110, 15, 9515),
+ (102, , 1, 2, , '卡牌强化', 1, 115, 8, 9515),
+ (103, , 1, 2, , '卡牌强化', 1, 117, 2, 9515),
+ (104, , 1, 2, , '卡牌强化', 1, 110, 15, 9517),
+ (105, , 1, 2, , '卡牌强化', 1, 115, 8, 9517),
+ (106, , 1, 2, , '卡牌强化', 1, 117, 2, 9517),
+ (107, , 1, 2, , '卡牌强化', 1, 110, 15, 9521),
+ (108, , 1, 2, , '卡牌强化', 1, 115, 8, 9521),
+ (109, , 1, 2, , '卡牌强化', 1, 117, 2, 9521),
+ (110, , 1, 2, , '卡牌强化', 1, 110, 15, 9536),
+ (111, , 1, 2, , '卡牌强化', 1, 115, 8, 9536),
+ (112, , 1, 2, , '卡牌强化', 1, 117, 2, 9536),
+ (113, , 1, 2, , '卡牌强化', 1, 110, 15, 9538),
+ (114, , 1, 2, , '卡牌强化', 1, 115, 8, 9538),
+ (115, , 1, 2, , '卡牌强化', 1, 117, 2, 9538),
+ (116, , 1, 2, , '卡牌强化', 1, 115, 8, 9570),
+ (117, , 1, 2, , '卡牌强化', 1, 117, 3, 9570),
+ (118, , 1, 2, , '卡牌强化', 1, 118, 1, 9570),
+ (119, , 1, 2, , '卡牌强化', 1, 115, 8, 9577),
+ (120, , 1, 2, , '卡牌强化', 1, 117, 3, 9577),
+ (121, , 1, 2, , '卡牌强化', 1, 118, 1, 9577),
+ (122, , 1, 2, , '卡牌强化', 1, 115, 16, 0268),
+ (123, , 1, 2, , '卡牌强化', 1, 117, 3, 0268),
+ (124, , 1, 2, , '卡牌强化', 1, 118, 1, 0268),
+ (125, , 1, 2, , '卡牌强化', 1, 106, 10, 0272),
+ (126, , 1, 2, , '卡牌强化', 1, 115, 16, 0272),
+ (127, , 1, 2, , '卡牌强化', 1, 117, 9, 0272),
+ (128, , 1, 2, , '卡牌强化', 1, 118, 3, 0272),
+ (129, , 1, 2, , '卡牌强化', 1, 106, 10, 0277),
+ (130, , 1, 2, , '卡牌强化', 1, 115, 16, 0277),
+ (131, , 1, 2, , '卡牌强化', 1, 117, 9, 0277),
+ (132, , 1, 2, , '卡牌强化', 1, 118, 3, 0277),
+ (133, , 1, 2, , '卡牌强化', 1, 106, 10, 0279),
+ (134, , 1, 2, , '卡牌强化', 1, 115, 16, 0279),
+ (135, , 1, 2, , '卡牌强化', 1, 117, 9, 0279),
+ (136, , 1, 2, , '卡牌强化', 1, 118, 3, 0279),
+ (137, , 1, 2, , '卡牌强化', 1, 106, 10, 0282),
+ (138, , 1, 2, , '卡牌强化', 1, 115, 16, 0282),
+ (139, , 1, 2, , '卡牌强化', 1, 117, 9, 0282),
+ (140, , 1, 2, , '卡牌强化', 1, 118, 3, 0282),
+ (141, , 1, 2, , '卡牌强化', 1, 106, 10, 0284),
+ (142, , 1, 2, , '卡牌强化', 1, 115, 16, 0284),
+ (143, , 1, 2, , '卡牌强化', 1, 117, 9, 0284),
+ (144, , 1, 2, , '卡牌强化', 1, 118, 3, 0284),
+ (145, , 1, 2, , '卡牌强化', 1, 106, 10, 0286),
+ (146, , 1, 2, , '卡牌强化', 1, 115, 16, 0286),
+ (147, , 1, 2, , '卡牌强化', 1, 117, 9, 0286),
+ (148, , 1, 2, , '卡牌强化', 1, 118, 3, 0286),
+ (149, , 1, 2, , '卡牌强化', 1, 106, 10, 0305),
+ (150, , 1, 2, , '卡牌强化', 1, 115, 16, 0305),
+ (151, , 1, 2, , '卡牌强化', 1, 117, 9, 0305),
+ (152, , 1, 2, , '卡牌强化', 1, 118, 3, 0305),
+ (153, , 1, 2, , '卡牌强化', 1, 107, 10, 0312),
+ (154, , 1, 2, , '卡牌强化', 1, 115, 18, 0312),
+ (155, , 1, 2, , '卡牌强化', 1, 117, 9, 0312),
+ (156, , 1, 2, , '卡牌强化', 1, 118, 3, 0312),
+ (157, , 1, 2, , '卡牌强化', 1, 108, 10, 0319),
+ (158, , 1, 2, , '卡牌强化', 1, 115, 24, 0319),
+ (159, , 1, 2, , '卡牌强化', 1, 117, 15, 0319),
+ (160, , 1, 2, , '卡牌强化', 1, 118, 3, 0319),
+ (161, , 1, 2, , '卡牌强化', 1, 109, 10, 0328),
+ (162, , 1, 2, , '卡牌强化', 1, 115, 24, 0328),
+ (163, , 1, 2, , '卡牌强化', 1, 117, 15, 0328),
+ (164, , 1, 2, , '卡牌强化', 1, 118, 9, 0328),
+ (165, , 1, 1, , 'gm命令', 1, 501, , , ),
+ (166, , 1, 2, , '卡牌打造武器', 1, 501, ),
+ (167, , 1, 2, , '卡牌打造武器', 1, 111, 6, 0626),
+ (168, , 1, 2, , '卡牌打造武器', 1, 112, 6, 0626),
+ (169, , 1, 2, , '卡牌打造武器', 1, 113, 6, 0626),
+ (170, , 1, 2, , '卡牌打造武器', 1, 114, 6, 0626),
+ (171, , 2, 1, , '背包上限购买', 1, 130, 2, 46, ),
+ (172, , 2, 1, , '背包上限购买', 1, 130, 2, 48, ),
+ (173, , 2, 1, , '背包上限购买', 1, 130, 2, 50, ),
+ (174, , 2, 1, , '背包上限购买', 1, 130, 2, 52, ),
+ (175, , 2, 1, , '背包上限购买', 1, 130, 2, 54, ),
+ (176, , 1, 1, , '卡牌分解', 1, 502, 38854),
+ (177, , 1, 1, , '卡牌分解', 1, 119, , ),
+ (178, , 1, 1, , '卡牌分解', 1, 119, , ),
+ (179, , 1, 2, , '卡牌召回', 1, 119, 1),
+ (180, , 1, 1, , 'gm命令', 1, 502, ),
+ (181, , 1, 2, , '卡牌强化', 1, 101, 10, 15001),
+ (182, , 1, 2, , '卡牌强化', 1, 101, 14, 15008),
+ (183, , 1, 2, , '卡牌强化', 1, 102, 10, ),
+ (184, , 1, 2, , '卡牌强化', 1, 102, 14, ),
+ (185, , 1, 2, , '卡牌强化', 1, 102, 18, ),
+ (186, , 1, 2, , '卡牌强化', 1, 102, 18, ),
+ (187, , 1, 2, , '卡牌强化', 1, 102, 18, ),
+ (188, , 1, 2, , '卡牌强化', 1, 103, 16, ),
+ (189, , 1, 2, , '卡牌强化', 1, 103, 24, ),
+ (190, , 1, 2, , '卡牌强化', 1, 103, 24, ),
+ (191, , 1, 2, , '卡牌强化', 1, 104, 16, 15013),
+ (192, , 1, 2, , '卡牌强化', 1, 104, 16, 5021),
+ (193, , 1, 2, , '卡牌强化', 1, 104, 18, 5022),
+ (194, , 1, 2, , '卡牌强化', 1, 104, 18, 5022),
+ (195, , 1, 2, , '卡牌强化', 1, 104, 18, 5023),
+ (196, , 1, 2, , '卡牌强化', 1, 105, 16, 5024),
+ (197, , 1, 2, , '卡牌强化', 1, 105, 16, 5024),
+ (198, , 1, 2, , '卡牌强化', 1, 105, 16, 5025),
+ (199, , 1, 2, , '卡牌强化', 1, 105, 16, 5025),
+ (200, , 1, 2, , '卡牌强化', 1, 105, 16, 5026),
+ (201, , 1, 2, , '卡牌强化', 1, 105, 16, 5026),
+ (202, , 1, 2, , '卡牌强化', 1, 105, 16, 5026),
+ (203, , 1, 2, , '卡牌强化', 1, 105, 24, 5028),
+ (204, , 1, 2, , '卡牌强化', 1, 105, 24, 5036),
+ (205, , 1, 2, , '卡牌强化', 1, 110, 15, 5044),
+ (206, , 1, 2, , '卡牌强化', 1, 115, 3, 5044),
+ (207, , 1, 2, , '卡牌打造武器', 1, 501, ),
+ (208, , 1, 2, , '卡牌打造武器', 1, 111, 6, 5053),
+ (209, , 1, 2, , '卡牌打造武器', 1, 112, 6, 5053),
+ (210, , 1, 2, , '卡牌打造武器', 1, 113, 6, 5053),
+ (211, , 1, 2, , '卡牌打造武器', 1, 114, 6, 5053),
+ (212, , 2, 1, , '背包上限购买', 1, 130, 2, 56, ),
+ (213, , 2, 1, , '背包上限购买', 1, 130, 2, 58, ),
+ (214, , 2, 1, , '背包上限购买', 1, 130, 2, 60, ),
+ (215, , 2, 1, , '背包上限购买', 1, 130, 2, 60, ),
+ (216, , 2, 1, , '背包上限购买', 1, 130, 2, 60, ),
+ (217, , 1, 1, , '背包上限购买', 1, 130, 2, 40, ),
+ (218, , 1, 1, , '背包上限购买', 1, 130, 2, 42, ),
+ (219, , 1, 1, , '背包上限购买', 1, 130, 2, 44, ),
+ (220, , 1, 1, , '背包上限购买', 1, 130, 2, 46, ),
+ (221, , 1, 1, , '背包上限购买', 1, 130, 2, 48, ),
+ (222, , 1, 1, , '礼包获得', 1, 501, ),
+ (223, , 1, 1, , '礼包获得', 1, 502, ),
+ (224, , 1, 1, , 'gm命令', 1, 119, 7660),
+ (225, , 1, 2, , '神殿换卡', 1, 119, , ),
+ (226, , 1, 2, , '神殿换卡', 1, 119, , ),
+ (227, , 1, 2, , '神殿换卡', 1, 119, , ),
+ (228, , 1, 2, , '神殿换卡', 1, 119, , ),
+ (229, , 1, 2, , '神殿换卡', 1, 119, , ),
+ (230, , 1, 1, , '卡牌分解', 1, 119, , ),
+ (231, , 1, 1, , '卡牌分解', 1, 119, , );
+/*!40000 ALTER TABLE `log_money` ENABLE KEYS */;
表 wg01_account.log_online 结构
+DROP TABLE IF EXISTS `log_online`;
+CREATE TABLE IF NOT EXISTS `log_online` (
`logid` int(4) unsigned NOT NULL AUTO_INCREMENT,
`time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '时间, utc秒',
`count_online` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '该组总在线',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
PRIMARY KEY (`logid`),
KEY `time` (`time`),
KEY `server_group` (`server_group`)
+) ENGINE=InnoDB AUTO_INCREMENT=380 DEFAULT CHARSET=utf8 COMMENT='在线日志表';
+-- 正在导出表
wg01_account.log_online 的数据：~341 rows (大约)
+/*!40000 ALTER TABLE `log_online` DISABLE KEYS */;
+REPLACE INTO `log_online` (`logid`, `time`, `count_online`, `server_group`) VALUES
+ (1, , 1, 1),
+ (2, , 0, 1),
+ (3, , 1, 1),
+ (4, , 0, 1),
+ (5, , 0, 1),
+ (6, , 0, 1),
+ (7, , 0, 1),
+ (8, , 0, 1),
+ (9, , 0, 1),
+ (10, , 0, 1),
+ (11, , 0, 1),
+ (12, , 0, 1),
+ (13, , 0, 1),
+ (14, , 0, 1),
+ (15, , 0, 1),
+ (16, , 0, 1),
+ (17, , 0, 1),
+ (18, , 0, 1),
+ (19, , 0, 1),
+ (20, , 0, 1),
+ (21, , 0, 1),
+ (22, , 0, 1),
+ (23, , 0, 1),
+ (24, , 0, 1),
+ (25, , 0, 1),
+ (26, , 0, 1),
+ (27, , 0, 1),
+ (28, , 0, 1),
+ (29, , 0, 1),
+ (30, , 0, 1),
+ (31, , 0, 1),
+ (32, , 0, 1),
+ (33, , 0, 1),
+ (34, , 0, 1),
+ (35, , 0, 1),
+ (36, , 0, 1),
+ (37, , 0, 1),
+ (38, , 0, 1),
+ (39, , 0, 1),
+ (40, , 0, 1),
+ (41, , 0, 1),
+ (42, , 0, 1),
+ (43, , 0, 1),
+ (44, , 0, 1),
+ (45, , 0, 1),
+ (46, , 0, 1),
+ (47, , 0, 1),
+ (48, , 0, 1),
+ (49, , 0, 1),
+ (50, , 0, 1),
+ (51, , 0, 1),
+ (52, , 0, 1),
+ (53, , 0, 1),
+ (54, , 0, 1),
+ (55, , 0, 1),
+ (56, , 0, 1),
+ (57, , 0, 1),
+ (58, , 0, 1),
+ (59, , 0, 1),
+ (60, , 0, 1),
+ (61, , 0, 1),
+ (62, , 0, 1),
+ (63, , 0, 1),
+ (64, , 0, 1),
+ (65, , 0, 1),
+ (66, , 1, 1),
+ (67, , 0, 1),
+ (68, , 0, 1),
+ (69, , 0, 1),
+ (70, , 0, 1),
+ (71, , 0, 1),
+ (72, , 0, 1),
+ (73, , 1, 1),
+ (74, , 0, 1),
+ (75, , 0, 1),
+ (76, , 0, 1),
+ (77, , 0, 1),
+ (78, , 0, 1),
+ (79, , 1, 1),
+ (80, , 0, 1),
+ (81, , 0, 1),
+ (82, , 0, 1),
+ (83, , 1, 1),
+ (84, , 0, 1),
+ (85, , 0, 1),
+ (86, , 0, 1),
+ (87, , 0, 1),
+ (88, , 0, 1),
+ (89, , 1, 1),
+ (90, , 0, 1),
+ (91, , 0, 1),
+ (92, , 0, 1),
+ (93, , 1, 1),
+ (94, , 0, 1),
+ (95, , 1, 1),
+ (96, , 0, 1),
+ (97, , 1, 1),
+ (98, , 0, 1),
+ (99, , 1, 1),
+ (100, , 0, 1),
+ (101, , 1, 1),
+ (102, , 0, 1),
+ (103, , 0, 1),
+ (104, , 0, 1),
+ (105, , 0, 1),
+ (106, , 0, 1),
+ (107, , 0, 1),
+ (108, , 0, 1),
+ (109, , 0, 1),
+ (110, , 0, 1),
+ (111, , 0, 1),
+ (112, , 0, 1),
+ (113, , 0, 1),
+ (114, , 0, 1),
+ (115, , 0, 1),
+ (116, , 1, 1),
+ (117, , 0, 1),
+ (118, , 0, 1),
+ (119, , 1, 1),
+ (120, , 0, 1),
+ (121, , 1, 1),
+ (122, , 1, 1),
+ (123, , 1, 1),
+ (124, , 0, 1),
+ (125, , 1, 1),
+ (126, , 0, 1),
+ (127, , 1, 1),
+ (128, , 0, 1),
+ (129, , 0, 1),
+ (130, , 0, 1),
+ (131, , 0, 1),
+ (132, , 0, 1),
+ (133, , 0, 1),
+ (134, , 0, 1),
+ (135, , 0, 1),
+ (136, , 0, 1),
+ (137, , 0, 1),
+ (138, , 0, 1),
+ (139, , 0, 1),
+ (140, , 0, 1),
+ (141, , 0, 1),
+ (142, , 0, 1),
+ (143, , 0, 1),
+ (144, , 0, 1),
+ (145, , 0, 1),
+ (146, , 0, 1),
+ (147, , 0, 1),
+ (148, , 0, 1),
+ (149, , 0, 1),
+ (150, , 0, 1),
+ (151, , 1, 1),
+ (152, , 0, 1),
+ (153, , 1, 1),
+ (154, , 0, 1),
+ (155, , 1, 1),
+ (156, , 0, 1),
+ (157, , 1, 1),
+ (158, , 0, 1),
+ (159, , 1, 1),
+ (160, , 0, 1),
+ (161, , 0, 1),
+ (162, , 0, 1),
+ (163, , 1, 1),
+ (164, , 0, 1),
+ (165, , 1, 1),
+ (166, , 0, 1),
+ (167, , 1, 1),
+ (168, , 0, 1),
+ (169, , 0, 1),
+ (170, , 0, 1),
+ (171, , 1, 1),
+ (172, , 0, 1),
+ (173, , 1, 1),
+ (174, , 0, 1),
+ (175, , 1, 1),
+ (176, , 0, 1),
+ (177, , 1, 1),
+ (178, , 1, 1),
+ (179, , 1, 1),
+ (180, , 1, 1),
+ (181, , 0, 1),
+ (182, , 1, 1),
+ (183, , 0, 1),
+ (184, , 0, 1),
+ (185, , 0, 1),
+ (186, , 0, 1),
+ (187, , 0, 1),
+ (188, , 0, 1),
+ (189, , 0, 1),
+ (190, , 0, 1),
+ (191, , 0, 1),
+ (192, , 0, 1),
+ (193, , 1, 1),
+ (194, , 0, 1),
+ (195, , 0, 1),
+ (196, , 0, 1),
+ (197, , 0, 1),
+ (198, , 0, 1),
+ (199, , 0, 1),
+ (200, , 0, 1),
+ (201, , 0, 1),
+ (202, , 0, 1),
+ (203, , 0, 1),
+ (204, , 0, 1),
+ (205, , 0, 1),
+ (206, , 0, 1),
+ (207, , 0, 1),
+ (208, , 0, 1),
+ (209, , 0, 1),
+ (210, , 0, 1),
+ (211, , 0, 1),
+ (212, , 0, 1),
+ (213, , 0, 1),
+ (214, , 0, 1),
+ (215, , 0, 1),
+ (216, , 0, 1),
+ (217, , 0, 1),
+ (218, , 0, 1),
+ (219, , 0, 1),
+ (220, , 0, 1),
+ (221, , 0, 1),
+ (222, , 1, 1),
+ (223, , 0, 1),
+ (224, , 0, 1),
+ (225, , 0, 1),
+ (226, , 1, 1),
+ (227, , 0, 1),
+ (228, , 1, 1),
+ (229, , 0, 1),
+ (230, , 1, 1),
+ (231, , 0, 1),
+ (232, , 0, 1),
+ (233, , 0, 1),
+ (234, , 0, 1),
+ (235, , 0, 1),
+ (236, , 0, 1),
+ (237, , 0, 1),
+ (238, , 0, 1),
+ (239, , 0, 1),
+ (240, , 0, 1),
+ (241, , 0, 1),
+ (242, , 0, 1),
+ (243, , 0, 1),
+ (244, , 0, 1),
+ (245, , 0, 1),
+ (246, , 0, 1),
+ (247, , 0, 1),
+ (248, , 0, 1),
+ (249, , 1, 1),
+ (250, , 0, 1),
+ (251, , 1, 1),
+ (252, , 0, 1),
+ (253, , 1, 1),
+ (254, , 0, 1),
+ (255, , 0, 1),
+ (256, , 0, 1),
+ (257, , 0, 1),
+ (258, , 0, 1),
+ (259, , 0, 1),
+ (260, , 0, 1),
+ (261, , 0, 1),
+ (262, , 0, 1),
+ (263, , 1, 1),
+ (264, , 0, 1),
+ (265, , 1, 1),
+ (266, , 0, 1),
+ (267, , 0, 1),
+ (268, , 0, 1),
+ (269, , 0, 1),
+ (270, , 0, 1),
+ (271, , 0, 1),
+ (272, , 0, 1),
+ (273, , 1, 1),
+ (274, , 0, 1),
+ (275, , 0, 1),
+ (276, , 1, 1),
+ (277, , 1, 1),
+ (278, , 0, 1),
+ (279, , 1, 1),
+ (280, , 1, 1),
+ (281, , 1, 1),
+ (282, , 0, 1),
+ (283, , 0, 1),
+ (284, , 1, 1),
+ (285, , 1, 1),
+ (286, , 0, 1),
+ (287, , 1, 1),
+ (288, , 0, 1),
+ (289, , 1, 1),
+ (290, , 0, 1),
+ (291, , 1, 1),
+ (292, , 0, 1),
+ (293, , 1, 1),
+ (294, , 0, 1),
+ (295, , 1, 1),
+ (296, , 0, 1),
+ (297, , 1, 1),
+ (298, , 0, 1),
+ (299, , 1, 1),
+ (300, , 1, 1),
+ (301, , 1, 1),
+ (302, , 1, 1),
+ (303, , 1, 1),
+ (304, , 1, 1),
+ (305, , 0, 1),
+ (306, , 1, 1),
+ (307, , 0, 1),
+ (308, , 0, 1),
+ (309, , 0, 1),
+ (310, , 0, 1),
+ (311, , 1, 1),
+ (312, , 1, 1),
+ (313, , 1, 1),
+ (314, , 0, 1),
+ (315, , 1, 1),
+ (316, , 0, 1),
+ (317, , 1, 1),
+ (318, , 0, 1),
+ (319, , 0, 1),
+ (320, , 0, 1),
+ (321, , 1, 1),
+ (322, , 0, 1),
+ (323, , 0, 1),
+ (324, , 0, 1),
+ (325, , 0, 1),
+ (326, , 0, 1),
+ (327, , 0, 1),
+ (328, , 0, 1),
+ (329, , 0, 1),
+ (330, , 0, 1),
+ (331, , 0, 1),
+ (332, , 0, 1),
+ (333, , 0, 1),
+ (334, , 0, 1),
+ (335, , 0, 1),
+ (336, , 0, 1),
+ (337, , 0, 1),
+ (338, , 0, 1),
+ (339, , 0, 1),
+ (340, , 0, 1),
+ (341, , 0, 1),
+ (342, , 0, 1),
+ (343, , 0, 1),
+ (344, , 0, 1),
+ (345, , 0, 1),
+ (346, , 0, 1),
+ (347, , 0, 1),
+ (348, , 0, 1),
+ (349, , 0, 1),
+ (350, , 0, 1),
+ (351, , 0, 1),
+ (352, , 0, 1),
+ (353, , 0, 1),
+ (354, , 0, 1),
+ (355, , 0, 1),
+ (356, , 0, 1),
+ (357, , 0, 1),
+ (358, , 0, 1),
+ (359, , 0, 1),
+ (360, , 0, 1),
+ (361, , 0, 1),
+ (362, , 0, 1),
+ (363, , 0, 1),
+ (364, , 0, 1),
+ (365, , 0, 1),
+ (366, , 0, 1),
+ (367, , 0, 1),
+ (368, , 0, 1),
+ (369, , 0, 1),
+ (370, , 0, 1),
+ (371, , 0, 1),
+ (372, , 0, 1),
+ (373, , 0, 1),
+ (374, , 0, 1),
+ (375, , 0, 1),
+ (376, , 0, 1),
+ (377, , 0, 1),
+ (378, , 0, 1),
+ (379, , 0, 1);
+/*!40000 ALTER TABLE `log_online` ENABLE KEYS */;
表 wg01_account.log_poker 结构
+DROP TABLE IF EXISTS `log_poker`;
+CREATE TABLE IF NOT EXISTS `log_poker` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`account_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号id',
`user_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线',
`time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '记录utc时间',
`type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '类型',
`poker_id` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '卡牌id',
`data` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '数据',
`reason` varchar(255) NOT NULL DEFAULT '' COMMENT '原因',
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`),
KEY `user_id` (`user_id`),
KEY `server_group` (`server_group`),
KEY `type` (`type`),
KEY `time` (`time`)
+) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8 COMMENT='卡牌日志';
+-- 正在导出表
wg01_account.log_poker 的数据：~103 rows (大约)
+/*!40000 ALTER TABLE `log_poker` DISABLE KEYS */;
+REPLACE INTO `log_poker` (`id`, `account_id`, `user_id`, `server_group`, `server_line`, `time`, `type`, `poker_id`, `data`, `reason`) VALUES
+ (1, , 1, , 1, 86, 2001, '新增新吧唧'),
+ (2, , 1, , 1, 87, 2001, '新增[新吧唧]'),
+ (3, , 1, , 2, 86, 2001, '解雇[新吧唧] 等级[1] 星级[1] 强化[0] 宝具[0] 突破[0] 随机四围[41]'),
+ (4, , 1, , 3, 87, 2001, '升级[新吧唧] 等级[1-&2] 消耗经验[45]'),
+ (5, , 1, , 3, 87, 2001, '升级[新吧唧] 等级[2-&3] 消耗经验[133]'),
+ (6, , 1, , 3, 87, 2001, '升级[新吧唧] 等级[3-&4] 消耗经验[220]'),
+ (7, , 1, , 3, 87, 2001, '升级[新吧唧] 等级[4-&5] 消耗经验[306]'),
+ (8, , 1, , 3, 87, 2001, '升级[新吧唧] 等级[5-&6] 消耗经验[391]'),
+ (9, , 1, , 4, 82, 5001, '升星[卓戈卡奥] 星级[1-&2] 雕像[0] 金币[6000]'),
+ (10, , 1, , 1, 88, 6001, '新增[夫子]'),
+ (11, , 1, , 5, 84, 6001, '强化[夫子] 强化[4-&5] 基础概率[9000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (12, , 1, , 5, 84, 6001, '强化[夫子] 强化[5-&6] 基础概率[9000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (13, , 1, , 5, 84, 6001, '强化[夫子] 强化[6-&7] 基础概率[9000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (14, , 1, , 5, 84, 6001, '强化[夫子] 强化[7-&8] 基础概率[8000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (15, , 1, , 5, 84, 6001, '强化[夫子] 强化[8-&9] 基础概率[8000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (16, , 1, , 5, 84, 6001, '强化[夫子] 强化[9-&10] 基础概率[8000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (17, , 1, , 5, 84, 6001, '强化[夫子] 强化[9-&10] 基础概率[8000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (18, , 1, , 5, 84, 6001, '强化[夫子] 强化[9-&10] 基础概率[8000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (19, , 1, , 5, 84, 6001, '强化[夫子] 强化[10-&11] 基础概率[7000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (20, , 1, , 5, 84, 6001, '强化[夫子] 强化[11-&12] 基础概率[7000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (21, , 1, , 5, 84, 6001, '强化[夫子] 强化[12-&13] 基础概率[6000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (22, , 1, , 5, 84, 6001, '强化[夫子] 强化[12-&13] 基础概率[6000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (23, , 1, , 5, 84, 6001, '强化[夫子] 强化[13-&14] 基础概率[6000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (24, , 1, , 5, 84, 6001, '强化[夫子] 强化[14-&15] 基础概率[5000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (25, , 1, , 5, 84, 6001, '强化[夫子] 强化[14-&15] 基础概率[5000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (26, , 1, , 5, 84, 6001, '强化[夫子] 强化[15-&16] 基础概率[5000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (27, , 1, , 5, 84, 6001, '强化[夫子] 强化[15-&16] 基础概率[5000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (28, , 1, , 5, 84, 6001, '强化[夫子] 强化[15-&16] 基础概率[5000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (29, , 1, , 5, 84, 6001, '强化[夫子] 强化[16-&17] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (30, , 1, , 5, 84, 6001, '强化[夫子] 强化[16-&17] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (31, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (32, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (33, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (34, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (35, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (36, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (37, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (38, , 1, , 5, 84, 6001, '强化[夫子] 强化[18-&19] 基础概率[3000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (39, , 1, , 5, 84, 6001, '强化[夫子] 强化[18-&19] 基础概率[3000] 增加概率[7000] 消耗元宝[170] 成功[1]'),
+ (40, , 1, , 5, 84, 6001, '强化[夫子] 强化[19-&20] 基础概率[3000] 增加概率[7000] 消耗元宝[170] 成功[1]'),
+ (41, , 1, , 7, 84, 6001, '宝具打造[夫子]'),
+ (42, , 1, , 8, 84, 87, '能力转移[夫子-&新吧唧] 元宝消耗[32] 源{等级[1] 星级[1] 强化[20] 宝具[1] 突破[0]} 目标{等级[6] 星级[1] 强化[0] 宝具[0] 突破[0]}'),
+ (43, , 1, , 8, 87, 84, '能力转移[新吧唧-&夫子] 元宝消耗[256] 源{等级[1] 星级[1] 强化[20] 宝具[1] 突破[0]} 目标{等级[1] 星级[1] 强化[0] 宝具[0] 突破[0]}'),
+ (44, , 1, , 1, 91, 5002, '新增[亚瑟]'),
+ (45, , 1, , 1, 92, 5002, '新增[亚瑟]'),
+ (46, , 1, , 1, 93, 5002, '新增[亚瑟]'),
+ (47, , 1, , 1, 94, 5002, '新增[亚瑟]'),
+ (48, , 1, , 1, 95, 5002, '新增[亚瑟]'),
+ (49, , 1, , 1, 96, 1001, '新增[暴力打手]'),
+ (50, , 1, , 1, 97, 1001, '新增[暴力打手]'),
+ (51, , 1, , 1, 98, 1001, '新增[暴力打手]'),
+ (52, , 1, , 1, 99, 5002, '新增[亚瑟]'),
+ (53, , 1, , 1, 100, 1001, '新增[暴力打手]'),
+ (54, , 1, , 1, 101, 1001, '新增[暴力打手]'),
+ (55, , 1, , 1, 102, 1001, '新增[暴力打手]'),
+ (56, , 1, , 1, 103, 1001, '新增[暴力打手]'),
+ (57, , 1, , 1, 104, 1001, '新增[暴力打手]'),
+ (58, , 1, , 1, 105, 1001, '新增[暴力打手]'),
+ (59, , 1, , 1, 106, 3002, '新增[蓝龙]'),
+ (60, , 1, , 1, 107, 2001, '新增[新吧唧]'),
+ (61, , 1, , 1, 108, 4002, '新增[金三胖]'),
+ (62, , 1, , 1, 109, 3002, '新增[蓝龙]'),
+ (63, , 1, , 1, 110, 3002, '新增[蓝龙]'),
+ (64, , 1, , 1, 111, 4003, '新增[奥巴马]'),
+ (65, , 1, , 1, 112, 3002, '新增[蓝龙]'),
+ (66, , 1, , 1, 113, 3002, '新增[蓝龙]'),
+ (67, , 1, , 1, 114, 4002, '新增[金三胖]'),
+ (68, , 1, , 1, 115, 3001, '新增[美狄亚]'),
+ (69, , 1, , 1, 116, 4003, '新增[奥巴马]'),
+ (70, , 1, , 1, 117, 5002, '新增[亚瑟]'),
+ (71, , 1, , 1, 118, 3002, '新增[蓝龙]'),
+ (72, , 1, , 1, 119, 3001, '新增[美狄亚]'),
+ (73, , 1, , 1, 120, 3002, '新增[蓝龙]'),
+ (74, , 1, , 1, 121, 4003, '新增[奥巴马]'),
+ (75, , 1, , 1, 122, 3001, '新增[美狄亚]'),
+ (76, , 1, , 1, 123, 3002, '新增[蓝龙]'),
+ (77, , 1, , 1, 124, 3002, '新增[蓝龙]'),
+ (78, , 1, , 1, 125, 3001, '新增[美狄亚]'),
+ (79, , 1, , 1, 126, 3002, '新增[蓝龙]'),
+ (80, , 1, , 1, 127, 3002, '新增[蓝龙]'),
+ (81, , 1, , 1, 128, 3002, '新增[蓝龙]'),
+ (82, , 1, , 2, 95, 5002, '解雇[亚瑟] 等级[1] 星级[1] 强化[0] 宝具[0] 突破[0] 随机四围[35]'),
+ (83, , 1, , 2, 99, 5002, '解雇[亚瑟] 等级[1] 星级[1] 强化[0] 宝具[0] 突破[0] 随机四围[25]'),
+ (84, , 1, , 1, 129, 1001, '新增[暴力打手]'),
+ (85, , 1, , 1, 130, 1001, '新增[暴力打手]'),
+ (86, , 1, , 1, 131, 4002, '新增[金三胖]'),
+ (87, , 1, , 1, 132, 1001, '新增[暴力打手]'),
+ (88, , 1, , 1, 133, 1001, '新增[暴力打手]'),
+ (89, , 1, , 1, 134, 1001, '新增[暴力打手]'),
+ (90, , 1, , 1, 135, 1001, '新增[暴力打手]'),
+ (91, , 1, , 1, 136, 1001, '新增[暴力打手]'),
+ (92, , 1, , 1, 137, 1001, '新增[暴力打手]'),
+ (93, , 1, , 1, 138, 1001, '新增[暴力打手]'),
+ (94, , 1, , 1, 139, 1001, '新增[暴力打手]'),
+ (95, , 1, , 1, 140, 1001, '新增[暴力打手]'),
+ (96, , 1, , 1, 141, 4003, '新增[奥巴马]'),
+ (97, , 1, , 1, 142, 1001, '新增[暴力打手]'),
+ (98, , 1, , 1, 143, 1001, '新增[暴力打手]'),
+ (99, , 1, , 1, 144, 1001, '新增[暴力打手]'),
+ (100, , 1, , 1, 145, 1001, '新增[暴力打手]'),
+ (101, , 1, , 1, 146, 1001, '新增[暴力打手]'),
+ (102, , 1, , 1, 147, 1001, '新增[暴力打手]'),
+ (103, , 1, , 1, 148, 1001, '新增[暴力打手]');
+/*!40000 ALTER TABLE `log_poker` ENABLE KEYS */;
表 wg01_account.log_vas 结构
+DROP TABLE IF EXISTS `log_vas`;
+CREATE TABLE IF NOT EXISTS `log_vas` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号id',
`user_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线',
`flow_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '类型, 1获得, 2消费',
`time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '发生时间, utc秒',
`reason` varchar(127) NOT NULL DEFAULT '未填写' COMMENT '记录日志原因',
`reason_amount` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '记录日志数量',
`point` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作点数',
`after_point` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作后点数',
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`),
KEY `user_id` (`user_id`),
KEY `itemtype_id` (`reason`),
KEY `server_group` (`server_group`),
KEY `time` (`time`),
KEY `flow_type` (`flow_type`)
+) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='元宝日志';
+-- 正在导出表
wg01_account.log_vas 的数据：~27 rows (大约)
+/*!40000 ALTER TABLE `log_vas` DISABLE KEYS */;
+REPLACE INTO `log_vas` (`id`, `account_id`, `user_id`, `server_group`, `server_line`, `flow_type`, `time`, `reason`, `reason_amount`, `point`, `after_point`) VALUES
+ (1, , 1, 1, , 'gm命令', 1, 100, 130),
+ (2, , 1, 2, , 'gm命令', 1, 100, 30),
+ (3, , 1, 1, , 'gm命令', 1, 100, 130),
+ (4, , 1, 1, , 'gm命令', 1, 10, 140),
+ (5, , 1, 1, , 'gm命令', 1, 10, 150),
+ (6, , 1, 1, , 'gm命令', 1, 10, 160),
+ (7, , 1, 1, , 'gm命令', 1, 10, 170),
+ (8, , 1, 1, , 'gm命令', 1, 100, 270),
+ (9, , 1, 1, , 'gm命令', 1, 100, 370),
+ (10, , 1, 1, , 'gm命令', 1, 30, 400),
+ (11, , 1, 1, , 'gm命令', 1, 30, 430),
+ (12, , 1, 2, , '卡牌能力转移', 1, 256, 174),
+ (13, , 1, 1, , 'gm命令', 1, 000173),
+ (14, , 1, 2, , '卡牌强化', 1, 650, 9999523),
+ (15, , 1, 2, , '卡牌强化', 1, 650, 9998873),
+ (16, , 1, 2, , '卡牌强化', 1, 3),
+ (17, , 1, 2, , '卡牌强化', 1, 3),
+ (18, , 1, 2, , '卡牌能力转移', 1, 256, 9993957),
+ (19, , 1, 2, , '卡牌强化', 1, 170, 9993787),
+ (20, , 1, 2, , '卡牌强化', 1, 170, 9993617),
+ (21, , 1, 2, , '卡牌能力转移', 1, 32, 9993585),
+ (22, , 1, 2, , '卡牌能力转移', 1, 256, 9993329),
+ (23, , 1, 2, , '抽卡', 1, 60, 9993269),
+ (24, , 1, 2, , '抽卡', 1, 580, 9992689),
+ (25, , 1, 2, , '抽卡', 1, 580, 9992109),
+ (26, , 1, 2, , '抽卡', 1, 480, 9991629),
+ (27, , 1, 2, , '抽卡', 1, 480, 9991149);
+/*!40000 ALTER TABLE `log_vas` ENABLE KEYS */;
表 wg01_account.newcard 结构
+DROP TABLE IF EXISTS `newcard`;
+CREATE TABLE IF NOT EXISTS `newcard` (
`Id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`card` varchar(64) NOT NULL DEFAULT '0' COMMENT '卡号',
`picked` int(4) unsigned zerofill NOT NULL DEFAULT '0000' COMMENT '使用标记（0未使用，1已使用）',
`platform` varchar(10) NOT NULL DEFAULT '' COMMENT '平台',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
PRIMARY KEY (`Id`),
UNIQUE KEY `newcard` (`card`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='新手卡号码表';
+-- 正在导出表
wg01_account.newcard 的数据：~0 rows (大约)
+/*!40000 ALTER TABLE `newcard` DISABLE KEYS */;
+/*!40000 ALTER TABLE `newcard` ENABLE KEYS */;
表 wg01_account.pay 结构
+DROP TABLE IF EXISTS `pay`;
+CREATE TABLE IF NOT EXISTS `pay` (
`logid` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
`paynum` varchar(255) NOT NULL DEFAULT '0' COMMENT '流水号，18位正整数',
`logdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '日志写入时间戳',
`account_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '账号id',
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
`ip` varchar(20) NOT NULL DEFAULT '',
`paygold` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '充值元宝',
`freegold` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '赠送元宝(平台插入时填0)',
`paymoney` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '充值RMB',
`used` int(10) unsigned DEFAULT '0' COMMENT '是否使用过(平台插入时填0)',
`channel` varchar(20) DEFAULT '0',
`channel_fee` float(4,3) NOT NULL DEFAULT '0.000',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组号',
`config_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配置id',
PRIMARY KEY (`logid`),
UNIQUE KEY `paynum` (`paynum`),
KEY `used` (`used`),
KEY `userid` (`account_id`),
KEY `logdate` (`logdate`),
KEY `server_line` (`server_group`),
KEY `user_id` (`user_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='玩家充值记录';
+-- 正在导出表
wg01_account.pay 的数据：~0 rows (大约)
+/*!40000 ALTER TABLE `pay` DISABLE KEYS */;
+/*!40000 ALTER TABLE `pay` ENABLE KEYS */;
表 wg01_account.server_list 结构
+DROP TABLE IF EXISTS `server_list`;
+CREATE TABLE IF NOT EXISTS `server_list` (
`server_group` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线路',
`client_ip` varchar(50) NOT NULL DEFAULT '' COMMENT '客户端连接ip',
`client_port` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '客户端连接端口',
`close` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关闭标志, 不等于0开入口',
UNIQUE KEY `group_line` (`server_group`,`server_line`),
KEY `server_group` (`server_group`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='服务器配置表\r\n该表不由策划管控, 故放置在账号库';
+-- 正在导出表
wg01_account.server_list 的数据：~2 rows (大约)
+/*!40000 ALTER TABLE `server_list` DISABLE KEYS */;
+REPLACE INTO `server_list` (`server_group`, `server_line`, `client_ip`, `client_port`, `close`) VALUES
+ (1, 1, '10.0.0.51', 10002, 0),
+ (1, 2, '10.0.0.52', 10002, 0),
+ (1, 3, '120.26.67.185', 10003, 0);
+/*!40000 ALTER TABLE `server_list` ENABLE KEYS */;
+/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
+/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Index: const.sql
===================================================================
--- const.sql (revision 0)
+++ const.sql (revision 2)
@@ -0,0 +1,3529 @@
+-- --------------------------------------------------------
120.26.67.185
+-- 服务器版本:
5.6.11 - MySQL Community Server (GPL)
+-- 服务器操作系统:
+-- HeidiSQL 版本:
9.2.0.4950
+-- --------------------------------------------------------
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET NAMES utf8mb4 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
表 wg01_const.action 结构
+CREATE TABLE IF NOT EXISTS `action` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`file_path` varchar(128) NOT NULL DEFAULT '' COMMENT '文件路径',
`function` varchar(128) NOT NULL DEFAULT '' COMMENT '函数入口',
`client_trigger` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '0客户端不可触发, 1客户端可触发',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=888889 DEFAULT CHARSET=utf8 COMMENT='脚本action';
+-- 正在导出表
wg01_const.action 的数据：~6 rows (大约)
+/*!40000 ALTER TABLE `action` DISABLE KEYS */;
+REPLACE INTO `action` (`id`, `file_path`, `function`, `client_trigger`) VALUES
+ (100, 'login.lua', 'login()', 0),
+ (123, 'syn\\syndicate.lua', 'JoinSyndicateSaveTime()', 0),
+ (321, 'syn\\syndicate.lua', 'QuitSyndicateSaveTime()', 0),
+ (998, 'challenge.lua', 'ChallengeWin()', 0),
+ (999, 'challenge.lua', 'WorldRankAward()', 0),
+ (888888, 'test.lua', 'test()', 0);
+/*!40000 ALTER TABLE `action` ENABLE KEYS */;
表 wg01_const.activities 结构
+CREATE TABLE IF NOT EXISTS `activities` (
`id` int(4) NOT NULL AUTO_INCREMENT COMMENT '活动id',
`type` int(4) NOT NULL DEFAULT '0' COMMENT '活动类型',
`time_type` int(4) NOT NULL DEFAULT '0' COMMENT '活动时间类别',
`begin_time` int(4) NOT NULL DEFAULT '0' COMMENT '开始时间',
`end_time` int(4) NOT NULL DEFAULT '0' COMMENT '结束时间',
`begin_action` int(4) NOT NULL DEFAULT '0' COMMENT '活动开始触发脚本',
`end_action` int(4) NOT NULL DEFAULT '0' COMMENT '活动结束触发脚本',
`server_group` int(4) NOT NULL DEFAULT '0' COMMENT '服务器组(99999表示所有服务器组开启）',
`server_line` int(4) NOT NULL DEFAULT '0' COMMENT '服务器线路(99999表示全服开启，0表示不开启）',
`param1` int(4) NOT NULL DEFAULT '0' COMMENT '预留参数1',
`param2` int(4) NOT NULL DEFAULT '0' COMMENT '预留参数2',
`param3` int(4) NOT NULL DEFAULT '0' COMMENT '预留参数3',
`param4` int(4) NOT NULL DEFAULT '0' COMMENT '预留参数4',
`param5` int(4) NOT NULL DEFAULT '0' COMMENT '预留参数5',
`comment` varchar(127) NOT NULL DEFAULT '0' COMMENT '注释字段',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='活动配置表';
+-- 正在导出表
wg01_const.activities 的数据：~2 rows (大约)
+/*!40000 ALTER TABLE `activities` DISABLE KEYS */;
+REPLACE INTO `activities` (`id`, `type`, `time_type`, `begin_time`, `end_time`, `begin_action`, `end_action`, `server_group`, `server_line`, `param1`, `param2`, `param3`, `param4`, `param5`, `comment`) VALUES
+ (1, 1, 2, 8, 0, 0, 90, , 0, 0, 0, 'Test'),
+ (2, 1, 2, , 9, 480, , 0, 0, 0, 'Test');
+/*!40000 ALTER TABLE `activities` ENABLE KEYS */;
表 wg01_const.auto_reload 结构
+CREATE TABLE IF NOT EXISTS `auto_reload` (
`table_name` varchar(255) NOT NULL DEFAULT '' COMMENT '表名',
`server_group` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组号, 填0表示全部',
`server_line` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线路号, 填0表示全部',
`utc_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '指定时间, 填0表示即时',
UNIQUE KEY `table_name_group` (`table_name`,`server_group`),
KEY `group` (`server_group`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='自动加载配置表\r\n通过点击关系服按钮触发';
+-- 正在导出表
wg01_const.auto_reload 的数据：~0 rows (大约)
+/*!40000 ALTER TABLE `auto_reload` DISABLE KEYS */;
+/*!40000 ALTER TABLE `auto_reload` ENABLE KEYS */;
表 wg01_const.config 结构
+CREATE TABLE IF NOT EXISTS `config` (
`type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '可配置数据类型',
`data` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '数据1',
`comment` varchar(127) NOT NULL DEFAULT '无' COMMENT '注释字段(该字段不读入数据库)',
UNIQUE KEY `type` (`type`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='const_常量配置表';
+-- 正在导出表
wg01_const.config 的数据：~15 rows (大约)
+/*!40000 ALTER TABLE `config` DISABLE KEYS */;
+REPLACE INTO `config` (`type`, `data`, `comment`) VALUES
+ (1, 3, '聊天限时，私聊限制'),
+ (2, 3, '聊天限时，帮派限制'),
+ (3, 20, '聊天限时，世界限制'),
+ (4, 20, '聊天等级限制，世界限制'),
+ (6, 30, '聊天配置，私聊记录上限'),
+ (7, 30, '聊天配置，帮派聊天记录上限'),
+ (8, 30, '聊天配置，世界聊天记录上限'),
+ (10, 0, '创建帮派，需要玩家等级'),
+ (11, 0, '创建帮派 需要元宝'),
+ (12, 0, '创建帮派 需要元宝'),
+ (13, 0, '帮派活跃 帮派每日活跃上限'),
+ (16, 0, '体力恢复时间间隔'),
+ (17, 0, '每日第一次签到开始时间'),
+ (18, 120000, '每日第二次签到开始时间'),
+ (19, 180000, '每日第三次签到开始时间');
+/*!40000 ALTER TABLE `config` ENABLE KEYS */;
表 wg01_const.config_text 结构
+CREATE TABLE IF NOT EXISTS `config_text` (
`id` int(4) unsigned NOT NULL AUTO_INCREMENT COMMENT '文字id',
`text` varchar(511) NOT NULL DEFAULT '' COMMENT '可配置文字内容',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=305 DEFAULT CHARSET=utf8 COMMENT='const_可配置的文字表';
+-- 正在导出表
wg01_const.config_text 的数据：~59 rows (大约)
+/*!40000 ALTER TABLE `config_text` DISABLE KEYS */;
+REPLACE INTO `config_text` (`id`, `text`) VALUES
+ (2, '玩家不存在或不在线'),
+ (3, '发送消息过快'),
+ (4, '不合法的消息'),
+ (5, '等级不够'),
+ (6, '元宝不足'),
+ (7, '最新的服务器'),
+ (8, '登陆过的服务器'),
+ (9, '全部服务器'),
+ (10, '被系统踢出'),
+ (11, '密码错误'),
+ (12, '在其他处登入'),
+ (13, '在其他地方登入'),
+ (14, '登入人数过多，登入失败'),
+ (15, '被GM踢出'),
+ (16, '服务器入口未开放'),
+ (17, 'GM工具Mac地址验证错误'),
+ (18, '系统将您踢出'),
+ (19, 'GM命令踢自己'),
+ (20, '登陆超时'),
+ (21, '您的账号被临时封停，预计%d小时后解封'),
+ (22, '您的账号被永久封停'),
+ (31, '%s创建公会%s'),
+ (32, '会长'),
+ (33, '长老'),
+ (34, '成员'),
+ (35, '公会不存在'),
+ (41, '【%s】创建公会'),
+ (42, '【%s】加入公会'),
+ (43, '【%s】退出公会'),
+ (44, '公会%s【%s】将【%s】踢出了公会'),
+ (45, '公会%s【%s】修改了公会公告'),
+ (46, '会长【%s】将【%s】提升为长老'),
+ (47, '会长【%s】取消了【%s】的长老职位'),
+ (48, '公会%s【%s】重置了团队副本：第%d章'),
+ (49, '团队副本:第%d章通关，最后一击由【%s】完成'),
+ (50, '【%s】将会长职位移交给了【%s】'),
+ (51, '【%s】在战利品%s的队列中插队'),
+ (52, '公会%s【%s】批准了【%s】加入公会'),
+ (53, '公会%s【%s】修改了加入公会最小战队等级为：%d级'),
+ (54, '公会%s【%s】将%s分配给了【%s】'),
+ (55, '公会%s【%s】修改了公会类型为：需验证'),
+ (56, '公会%s【%s】修改了公会类型为：不需要验证'),
+ (57, '会长【%s】长时间未上线，会长职位自动禅让给【%s】'),
+ (71, '请先选择服务器！'),
+ (72, '没有游戏服可以连接！'),
+ (73, '游戏服务器连接失败！'),
+ (74, '角色创建失败！'),
+ (75, '名字中包含非法字符！'),
+ (76, '非法字符！'),
+ (77, '重复的角色名'),
+ (78, '无法创建更多的角色！'),
+ (79, '操作失败！'),
+ (80, '未知的操作类型！'),
+ (81, '背包空间不足！'),
+ (82, '元宝不足！'),
+ (83, '需要%d个【%s】'),
+ (84, '开始自动重连'),
+ (85, '重连成功'),
+ (86, '重连失败');
+/*!40000 ALTER TABLE `config_text` ENABLE KEYS */;
表 wg01_const.drop_rule 结构
+CREATE TABLE IF NOT EXISTS `drop_rule` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主id',
`type` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '掉落类型规则, 1一次规则, 2多次规则',
`count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '一次规则表示按权重掉多少个, 多次规则表示执行多少次独立权重',
`chance` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '触发概率, 万分比, 满足概率才进行权重',
`group1_type` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '六位数直接表示itemtype, 三位数表示货币类型, 其余做保留',
`group1_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '数量',
`group1_weight` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '权重',
`group1_group` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '归属,0玩家,1帮派',
`group2_type` int(10) unsigned NOT NULL DEFAULT '0',
`group2_}
项目语言:C++
权限:read-only(如需更高权限请先加入项目)
newProBase/
Index: account.sql
===================================================================
--- account.sql (revision 0)
+++ account.sql (revision 2)
@@ -0,0 +1,1217 @@
+-- --------------------------------------------------------
120.26.67.185
+-- 服务器版本:
5.6.11 - MySQL Community Server (GPL)
+-- 服务器操作系统:
+-- HeidiSQL 版本:
9.2.0.4950
+-- --------------------------------------------------------
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET NAMES utf8mb4 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
表 wg01_account.account 结构
+DROP TABLE IF EXISTS `account`;
+CREATE TABLE IF NOT EXISTS `account` (
`id` int(4) unsigned NOT NULL AUTO_INCREMENT COMMENT '账号id, 从10W开始',
`name` varchar(64) NOT NULL DEFAULT '' COMMENT '账号名',
`password` varchar(128) NOT NULL DEFAULT '' COMMENT '账号密码',
`reg_time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '注册utc时间',
`account_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号类型, 0普通, 1GM, 2高级GM',
`account_status` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号状态, 0正常, 1临时封停, 2永久封停',
`account_status_param` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号状态补充参数, 临时封停结束utc时间',
`platform` varchar(32) NOT NULL DEFAULT '' COMMENT '平台',
`channel` varchar(32) NOT NULL DEFAULT '' COMMENT '渠道',
`os` varchar(32) NOT NULL DEFAULT '' COMMENT '系统',
PRIMARY KEY (`id`),
UNIQUE KEY `name` (`name`),
KEY `platform` (`platform`),
KEY `reg_time` (`reg_time`),
KEY `channel` (`channel`)
+) ENGINE=InnoDB AUTO_INCREMENT=300073 DEFAULT CHARSET=utf8 COMMENT='账号表';
+-- 正在导出表
wg01_account.account 的数据：~13 rows (大约)
+/*!40000 ALTER TABLE `account` DISABLE KEYS */;
+REPLACE INTO `account` (`id`, `name`, `password`, `reg_time`, `account_type`, `account_status`, `account_status_param`, `platform`, `channel`, `os`) VALUES
+ (100000, 'pwq1', '1', 0, 2, 0, 0, '', '', ''),
+ (100001, 'lms', '1', 0, 2, 0, 0, '', '', ''),
+ (100002, 'pwq2', '1', 0, 2, 0, 0, '', '', ''),
+ (100003, 't1', '1', 0, 2, 0, 0, '', '', ''),
+ (100004, 't2', '1', 0, 2, 0, 0, '', '', ''),
+ (100005, 'cjj', '1', 0, 2, 0, 0, '', '', ''),
+ (100006, 'cjj2', '1', 0, 2, 0, 0, '', '', ''),
+ (300067, 'lyh1', '1', 0, 2, 0, 0, '', '', ''),
+ (300068, 'lyh2', '1', 0, 2, 0, 0, '', '', ''),
+ (300069, 'rhx1', '1', 0, 2, 0, 0, '', '', ''),
+ (300070, 'rhx2', '1', 0, 2, 0, 0, '', '', ''),
+ (300071, 'test1', '1', 0, 2, 0, 0, '', '', ''),
+ (300072, 'test2', '1', 0, 2, 0, 0, '', '', '');
+/*!40000 ALTER TABLE `account` ENABLE KEYS */;
表 wg01_account.gm_mac 结构
+DROP TABLE IF EXISTS `gm_mac`;
+CREATE TABLE IF NOT EXISTS `gm_mac` (
`address_mac` varchar(32) NOT NULL DEFAULT '' COMMENT 'mac地址',
`param_string` varchar(64) NOT NULL DEFAULT '' COMMENT '注释参数',
UNIQUE KEY `address_mac` (`address_mac`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='gm的mac地址';
+-- 正在导出表
wg01_account.gm_mac 的数据：~0 rows (大约)
+/*!40000 ALTER TABLE `gm_mac` DISABLE KEYS */;
+/*!40000 ALTER TABLE `gm_mac` ENABLE KEYS */;
表 wg01_account.log_item 结构
+DROP TABLE IF EXISTS `log_item`;
+CREATE TABLE IF NOT EXISTS `log_item` (
`id` bigint(8) NOT NULL AUTO_INCREMENT,
`user_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '玩家id',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '线路',
`time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '时间',
`flow_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '流向类型',
`item_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '物品id',
`item_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '物品类型',
`reason` varchar(127) NOT NULL DEFAULT '' COMMENT '物品流向原因',
`reasion_number` int(4) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `user_id` (`user_id`),
KEY `server_group` (`server_group`),
KEY `flow_type` (`flow_type`),
KEY `time` (`time`),
KEY `item_type` (`item_type`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='物品流向表';
+-- 正在导出表
wg01_account.log_item 的数据：~0 rows (大约)
+/*!40000 ALTER TABLE `log_item` DISABLE KEYS */;
+/*!40000 ALTER TABLE `log_item` ENABLE KEYS */;
表 wg01_account.log_loginout 结构
+DROP TABLE IF EXISTS `log_loginout`;
+CREATE TABLE IF NOT EXISTS `log_loginout` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增长id',
`loginout` int(4) NOT NULL DEFAULT '0' COMMENT '登入1 登出2',
`account_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号id',
`account_name` varchar(64) NOT NULL DEFAULT '' COMMENT '账号名',
`user_id` int(4) NOT NULL DEFAULT '0' COMMENT '角色id',
`user_name` varchar(64) NOT NULL DEFAULT '' COMMENT '角色名',
`time` int(4) NOT NULL DEFAULT '0' COMMENT 'utc时间戳',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=192 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='登入登出日志';
+-- 正在导出表
wg01_account.log_loginout 的数据：~190 rows (大约)
+/*!40000 ALTER TABLE `log_loginout` DISABLE KEYS */;
+REPLACE INTO `log_loginout` (`id`, `loginout`, `account_id`, `account_name`, `user_id`, `user_name`, `time`, `server_group`, `server_line`) VALUES
+ (2, 1, 100000, 'pwq1', , '彭文奇', , 1, 0),
+ (3, 2, 100000, 'pwq1', , '彭文奇', , 1, 0),
+ (4, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (5, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (6, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (7, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (8, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (9, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (10, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (11, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (12, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (13, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (14, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (15, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (16, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (17, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (18, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (19, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (20, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (21, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (22, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (23, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (24, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (25, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (26, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (27, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (28, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (29, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (30, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (31, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (32, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (33, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (34, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (35, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (36, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (37, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (38, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (39, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (40, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (41, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (42, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (43, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (44, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (45, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (46, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (47, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (48, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (49, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (50, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (51, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (52, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (53, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (54, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (55, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (56, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (57, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (58, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (59, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (60, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (61, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (62, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (63, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (64, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (65, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (66, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (67, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (68, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (69, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (70, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (71, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (72, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (73, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (74, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (75, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (76, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (77, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (78, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (79, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (80, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (81, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (82, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (83, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (84, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (85, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (86, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (87, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (88, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (89, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (90, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (91, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (92, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (93, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (94, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (95, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (96, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (97, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (98, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (99, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (100, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (101, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (102, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (103, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (104, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (105, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (106, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (107, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (108, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (109, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (110, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (111, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (112, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (113, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (114, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (115, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (116, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (117, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (118, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (119, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (120, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (121, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (122, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (123, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (124, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (125, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (126, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (127, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (128, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (129, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (130, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (131, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (132, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (133, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (134, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (135, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (136, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (137, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (138, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (139, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (140, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (141, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (142, 1, 100005, 'cjj', , 'cjj', , 1, 2),
+ (143, 2, 100005, 'cjj', , 'cjj', , 1, 2),
+ (144, 1, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (145, 2, 100006, 'cjj2', , 'epcgfsugj', , 1, 2),
+ (146, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (147, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (148, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (149, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (150, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (151, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (152, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (153, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (154, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (155, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (156, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (157, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (158, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (159, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (160, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (161, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (162, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (163, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (164, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (165, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (166, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (167, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (168, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (169, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (170, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (171, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (172, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (173, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (174, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (175, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (176, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (177, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (178, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (179, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (180, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (181, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (182, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (183, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (184, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (185, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (186, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (187, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (188, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (189, 2, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (190, 1, 100000, 'pwq1', , '彭文奇', , 1, 1),
+ (191, 2, 100000, 'pwq1', , '彭文奇', , 1, 1);
+/*!40000 ALTER TABLE `log_loginout` ENABLE KEYS */;
表 wg01_account.log_money 结构
+DROP TABLE IF EXISTS `log_money`;
+CREATE TABLE IF NOT EXISTS `log_money` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号id',
`user_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线',
`flow_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '类型, 1获得, 2消费',
`time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '发生时间, utc秒',
`reason` varchar(127) NOT NULL DEFAULT '未填写' COMMENT '记录日志原因',
`reason_amount` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '记录日志数量',
`money_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '金钱类型',
`point` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作点数',
`after_point` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作后点数',
`del_time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '删除时间',
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`),
KEY `user_id` (`user_id`),
KEY `server_group` (`server_group`),
KEY `time` (`time`),
KEY `flow_type` (`flow_type`),
KEY `money_type` (`money_type`),
KEY `del_time` (`del_time`)
+) ENGINE=InnoDB AUTO_INCREMENT=232 DEFAULT CHARSET=utf8 COMMENT='金钱日志';
+-- 正在导出表
wg01_account.log_money 的数据：~231 rows (大约)
+/*!40000 ALTER TABLE `log_money` DISABLE KEYS */;
+REPLACE INTO `log_money` (`id`, `account_id`, `user_id`, `server_group`, `server_line`, `flow_type`, `time`, `reason`, `reason_amount`, `money_type`, `point`, `after_point`, `del_time`) VALUES
+ (1, , 1, 1, , 'gm命令', 1, 501, ),
+ (2, , 1, 1, , 'gm命令', 1, 130, 30, 30, ),
+ (3, , 1, 1, , 'gm命令', 1, 130, 30, 60, ),
+ (4, , 1, 1, , 'gm命令', 1, 130, 30, 90, ),
+ (5, , 1, 1, , 'gm命令', 1, 130, 30, 120, ),
+ (6, , 1, 2, , 'gm命令', 1, 130, 100, 20, ),
+ (7, , 1, 2, , 'gm命令', 1, 130, 2, 18, ),
+ (8, , 1, 1, , 'gm命令', 1, 130, 20, 38, ),
+ (9, , 2, 1, , '背包上限购买', 1, 130, 2, 2, ),
+ (10, , 2, 1, , '背包上限购买', 1, 130, 2, 4, ),
+ (11, , 2, 1, , '背包上限购买', 1, 130, 2, 6, ),
+ (12, , 2, 1, , '背包上限购买', 1, 130, 2, 8, ),
+ (13, , 2, 1, , '背包上限购买', 1, 130, 2, 10, ),
+ (14, , 2, 1, , '背包上限购买', 1, 130, 2, 12, ),
+ (15, , 2, 1, , '背包上限购买', 1, 130, 2, 14, ),
+ (16, , 2, 1, , '背包上限购买', 1, 130, 2, 16, ),
+ (17, , 2, 1, , '背包上限购买', 1, 130, 2, 18, ),
+ (18, , 2, 1, , '背包上限购买', 1, 130, 2, 20, ),
+ (19, , 2, 1, , '背包上限购买', 1, 130, 2, 22, ),
+ (20, , 2, 1, , '背包上限购买', 1, 130, 2, 24, ),
+ (21, , 2, 1, , '背包上限购买', 1, 130, 2, 26, ),
+ (22, , 2, 1, , '背包上限购买', 1, 130, 2, 28, ),
+ (23, , 2, 1, , '背包上限购买', 1, 130, 2, 30, ),
+ (24, , 2, 1, , '背包上限购买', 1, 130, 2, 32, ),
+ (25, , 2, 1, , '背包上限购买', 1, 130, 2, 34, ),
+ (26, , 2, 1, , '背包上限购买', 1, 130, 2, 36, ),
+ (27, , 2, 1, , '背包上限购买', 1, 130, 2, 38, ),
+ (28, , 2, 2, , 'gm命令', 1, 130, 20, 18, ),
+ (29, , 2, 1, , '背包上限购买', 1, 130, 2, 20, ),
+ (30, , 2, 1, , '背包上限购买', 1, 130, 2, 22, ),
+ (31, , 2, 1, , '背包上限购买', 1, 130, 2, 24, ),
+ (32, , 2, 1, , '背包上限购买', 1, 130, 2, 26, ),
+ (33, , 2, 1, , '背包上限购买', 1, 130, 2, 28, ),
+ (34, , 2, 1, , '背包上限购买', 1, 130, 2, 30, ),
+ (35, , 2, 1, , '背包上限购买', 1, 130, 2, 32, ),
+ (36, , 2, 1, , '背包上限购买', 1, 130, 2, 34, ),
+ (37, , 2, 1, , '背包上限购买', 1, 130, 2, 36, ),
+ (38, , 2, 1, , '背包上限购买', 1, 130, 2, 38, ),
+ (39, , 2, 1, , '背包上限购买', 1, 130, 2, 40, ),
+ (40, , 2, 1, , '背包上限购买', 1, 130, 2, 42, ),
+ (41, , 2, 1, , '背包上限购买', 1, 130, 2, 44, ),
+ (42, , 1, 1, , 'gm命令', 1, 101, , ),
+ (43, , 1, 1, , 'gm命令', 1, 102, , ),
+ (44, , 1, 1, , 'gm命令', 1, 103, 3, ),
+ (45, , 1, 1, , 'gm命令', 1, 104, , ),
+ (46, , 1, 1, , 'gm命令', 1, 105, , ),
+ (47, , 1, 1, , 'gm命令', 1, 106, , ),
+ (48, , 1, 1, , 'gm命令', 1, 107, , ),
+ (49, , 1, 1, , 'gm命令', 1, 108, , ),
+ (50, , 1, 1, , 'gm命令', 1, 109, , ),
+ (51, , 1, 1, , 'gm命令', 1, 110, , ),
+ (52, , 1, 1, , 'gm命令', 1, 111, , ),
+ (53, , 1, 1, , 'gm命令', 1, 112, , ),
+ (54, , 1, 1, , 'gm命令', 1, 113, , ),
+ (55, , 1, 1, , 'gm命令', 1, 114, , ),
+ (56, , 1, 1, , 'gm命令', 1, 115, , ),
+ (57, , 1, 1, , 'gm命令', 1, 116, , ),
+ (58, , 1, 1, , 'gm命令', 1, 117, , ),
+ (59, , 1, 1, , 'gm命令', 1, 118, , ),
+ (60, , 1, 2, , '卡牌强化', 1, 101, 10, 19399),
+ (61, , 1, 2, , '卡牌强化', 1, 101, 14, 19407),
+ (62, , 1, 2, , '卡牌强化', 1, 102, 10, ),
+ (63, , 1, 2, , '卡牌强化', 1, 102, 14, ),
+ (64, , 1, 2, , '卡牌强化', 1, 102, 18, ),
+ (65, , 1, 2, , '卡牌强化', 1, 103, 16, ),
+ (66, , 1, 2, , '卡牌强化', 1, 103, 24, ),
+ (67, , 1, 2, , '卡牌强化', 1, 103, 24, ),
+ (68, , 1, 2, , '卡牌强化', 1, 103, 24, ),
+ (69, , 1, 2, , '卡牌强化', 1, 104, 16, 19440),
+ (70, , 1, 2, , '卡牌强化', 1, 104, 18, 19443),
+ (71, , 1, 2, , '卡牌强化', 1, 105, 16, 9460),
+ (72, , 1, 2, , '卡牌强化', 1, 105, 24, 9462),
+ (73, , 1, 2, , '卡牌强化', 1, 105, 24, 9467),
+ (74, , 1, 2, , '卡牌强化', 1, 105, 24, 9468),
+ (75, , 1, 2, , '卡牌强化', 1, 110, 15, 9470),
+ (76, , 1, 2, , '卡牌强化', 1, 115, 3, 9470),
+ (77, , 1, 2, , '卡牌强化', 1, 110, 15, 9486),
+ (78, , 1, 2, , '卡牌强化', 1, 115, 3, 9486),
+ (79, , 1, 2, , '卡牌强化', 1, 117, 1, 9486),
+ (80, , 1, 2, , '卡牌强化', 1, 110, 15, 9490),
+ (81, , 1, 2, , '卡牌强化', 1, 115, 4, 9490),
+ (82, , 1, 2, , '卡牌强化', 1, 117, 1, 9490),
+ (83, , 1, 2, , '卡牌强化', 1, 110, 15, 9497),
+ (84, , 1, 2, , '卡牌强化', 1, 115, 4, 9497),
+ (85, , 1, 2, , '卡牌强化', 1, 117, 2, 9497),
+ (86, , 1, 2, , '卡牌强化', 1, 110, 15, 9504),
+ (87, , 1, 2, , '卡牌强化', 1, 115, 4, 9504),
+ (88, , 1, 2, , '卡牌强化', 1, 117, 2, 9504),
+ (89, , 1, 2, , '卡牌强化', 1, 110, 15, 9506),
+ (90, , 1, 2, , '卡牌强化', 1, 115, 8, 9506),
+ (91, , 1, 2, , '卡牌强化', 1, 117, 2, 9506),
+ (92, , 1, 2, , '卡牌强化', 1, 110, 15, 9509),
+ (93, , 1, 2, , '卡牌强化', 1, 115, 8, 9509),
+ (94, , 1, 2, , '卡牌强化', 1, 117, 2, 9509),
+ (95, , 1, 2, , '卡牌强化', 1, 110, 15, 9511),
+ (96, , 1, 2, , '卡牌强化', 1, 115, 8, 9511),
+ (97, , 1, 2, , '卡牌强化', 1, 117, 2, 9511),
+ (98, , 1, 2, , '卡牌强化', 1, 110, 15, 9513),
+ (99, , 1, 2, , '卡牌强化', 1, 115, 8, 9513),
+ (100, , 1, 2, , '卡牌强化', 1, 117, 2, 9513),
+ (101, , 1, 2, , '卡牌强化', 1, 110, 15, 9515),
+ (102, , 1, 2, , '卡牌强化', 1, 115, 8, 9515),
+ (103, , 1, 2, , '卡牌强化', 1, 117, 2, 9515),
+ (104, , 1, 2, , '卡牌强化', 1, 110, 15, 9517),
+ (105, , 1, 2, , '卡牌强化', 1, 115, 8, 9517),
+ (106, , 1, 2, , '卡牌强化', 1, 117, 2, 9517),
+ (107, , 1, 2, , '卡牌强化', 1, 110, 15, 9521),
+ (108, , 1, 2, , '卡牌强化', 1, 115, 8, 9521),
+ (109, , 1, 2, , '卡牌强化', 1, 117, 2, 9521),
+ (110, , 1, 2, , '卡牌强化', 1, 110, 15, 9536),
+ (111, , 1, 2, , '卡牌强化', 1, 115, 8, 9536),
+ (112, , 1, 2, , '卡牌强化', 1, 117, 2, 9536),
+ (113, , 1, 2, , '卡牌强化', 1, 110, 15, 9538),
+ (114, , 1, 2, , '卡牌强化', 1, 115, 8, 9538),
+ (115, , 1, 2, , '卡牌强化', 1, 117, 2, 9538),
+ (116, , 1, 2, , '卡牌强化', 1, 115, 8, 9570),
+ (117, , 1, 2, , '卡牌强化', 1, 117, 3, 9570),
+ (118, , 1, 2, , '卡牌强化', 1, 118, 1, 9570),
+ (119, , 1, 2, , '卡牌强化', 1, 115, 8, 9577),
+ (120, , 1, 2, , '卡牌强化', 1, 117, 3, 9577),
+ (121, , 1, 2, , '卡牌强化', 1, 118, 1, 9577),
+ (122, , 1, 2, , '卡牌强化', 1, 115, 16, 0268),
+ (123, , 1, 2, , '卡牌强化', 1, 117, 3, 0268),
+ (124, , 1, 2, , '卡牌强化', 1, 118, 1, 0268),
+ (125, , 1, 2, , '卡牌强化', 1, 106, 10, 0272),
+ (126, , 1, 2, , '卡牌强化', 1, 115, 16, 0272),
+ (127, , 1, 2, , '卡牌强化', 1, 117, 9, 0272),
+ (128, , 1, 2, , '卡牌强化', 1, 118, 3, 0272),
+ (129, , 1, 2, , '卡牌强化', 1, 106, 10, 0277),
+ (130, , 1, 2, , '卡牌强化', 1, 115, 16, 0277),
+ (131, , 1, 2, , '卡牌强化', 1, 117, 9, 0277),
+ (132, , 1, 2, , '卡牌强化', 1, 118, 3, 0277),
+ (133, , 1, 2, , '卡牌强化', 1, 106, 10, 0279),
+ (134, , 1, 2, , '卡牌强化', 1, 115, 16, 0279),
+ (135, , 1, 2, , '卡牌强化', 1, 117, 9, 0279),
+ (136, , 1, 2, , '卡牌强化', 1, 118, 3, 0279),
+ (137, , 1, 2, , '卡牌强化', 1, 106, 10, 0282),
+ (138, , 1, 2, , '卡牌强化', 1, 115, 16, 0282),
+ (139, , 1, 2, , '卡牌强化', 1, 117, 9, 0282),
+ (140, , 1, 2, , '卡牌强化', 1, 118, 3, 0282),
+ (141, , 1, 2, , '卡牌强化', 1, 106, 10, 0284),
+ (142, , 1, 2, , '卡牌强化', 1, 115, 16, 0284),
+ (143, , 1, 2, , '卡牌强化', 1, 117, 9, 0284),
+ (144, , 1, 2, , '卡牌强化', 1, 118, 3, 0284),
+ (145, , 1, 2, , '卡牌强化', 1, 106, 10, 0286),
+ (146, , 1, 2, , '卡牌强化', 1, 115, 16, 0286),
+ (147, , 1, 2, , '卡牌强化', 1, 117, 9, 0286),
+ (148, , 1, 2, , '卡牌强化', 1, 118, 3, 0286),
+ (149, , 1, 2, , '卡牌强化', 1, 106, 10, 0305),
+ (150, , 1, 2, , '卡牌强化', 1, 115, 16, 0305),
+ (151, , 1, 2, , '卡牌强化', 1, 117, 9, 0305),
+ (152, , 1, 2, , '卡牌强化', 1, 118, 3, 0305),
+ (153, , 1, 2, , '卡牌强化', 1, 107, 10, 0312),
+ (154, , 1, 2, , '卡牌强化', 1, 115, 18, 0312),
+ (155, , 1, 2, , '卡牌强化', 1, 117, 9, 0312),
+ (156, , 1, 2, , '卡牌强化', 1, 118, 3, 0312),
+ (157, , 1, 2, , '卡牌强化', 1, 108, 10, 0319),
+ (158, , 1, 2, , '卡牌强化', 1, 115, 24, 0319),
+ (159, , 1, 2, , '卡牌强化', 1, 117, 15, 0319),
+ (160, , 1, 2, , '卡牌强化', 1, 118, 3, 0319),
+ (161, , 1, 2, , '卡牌强化', 1, 109, 10, 0328),
+ (162, , 1, 2, , '卡牌强化', 1, 115, 24, 0328),
+ (163, , 1, 2, , '卡牌强化', 1, 117, 15, 0328),
+ (164, , 1, 2, , '卡牌强化', 1, 118, 9, 0328),
+ (165, , 1, 1, , 'gm命令', 1, 501, , , ),
+ (166, , 1, 2, , '卡牌打造武器', 1, 501, ),
+ (167, , 1, 2, , '卡牌打造武器', 1, 111, 6, 0626),
+ (168, , 1, 2, , '卡牌打造武器', 1, 112, 6, 0626),
+ (169, , 1, 2, , '卡牌打造武器', 1, 113, 6, 0626),
+ (170, , 1, 2, , '卡牌打造武器', 1, 114, 6, 0626),
+ (171, , 2, 1, , '背包上限购买', 1, 130, 2, 46, ),
+ (172, , 2, 1, , '背包上限购买', 1, 130, 2, 48, ),
+ (173, , 2, 1, , '背包上限购买', 1, 130, 2, 50, ),
+ (174, , 2, 1, , '背包上限购买', 1, 130, 2, 52, ),
+ (175, , 2, 1, , '背包上限购买', 1, 130, 2, 54, ),
+ (176, , 1, 1, , '卡牌分解', 1, 502, 38854),
+ (177, , 1, 1, , '卡牌分解', 1, 119, , ),
+ (178, , 1, 1, , '卡牌分解', 1, 119, , ),
+ (179, , 1, 2, , '卡牌召回', 1, 119, 1),
+ (180, , 1, 1, , 'gm命令', 1, 502, ),
+ (181, , 1, 2, , '卡牌强化', 1, 101, 10, 15001),
+ (182, , 1, 2, , '卡牌强化', 1, 101, 14, 15008),
+ (183, , 1, 2, , '卡牌强化', 1, 102, 10, ),
+ (184, , 1, 2, , '卡牌强化', 1, 102, 14, ),
+ (185, , 1, 2, , '卡牌强化', 1, 102, 18, ),
+ (186, , 1, 2, , '卡牌强化', 1, 102, 18, ),
+ (187, , 1, 2, , '卡牌强化', 1, 102, 18, ),
+ (188, , 1, 2, , '卡牌强化', 1, 103, 16, ),
+ (189, , 1, 2, , '卡牌强化', 1, 103, 24, ),
+ (190, , 1, 2, , '卡牌强化', 1, 103, 24, ),
+ (191, , 1, 2, , '卡牌强化', 1, 104, 16, 15013),
+ (192, , 1, 2, , '卡牌强化', 1, 104, 16, 5021),
+ (193, , 1, 2, , '卡牌强化', 1, 104, 18, 5022),
+ (194, , 1, 2, , '卡牌强化', 1, 104, 18, 5022),
+ (195, , 1, 2, , '卡牌强化', 1, 104, 18, 5023),
+ (196, , 1, 2, , '卡牌强化', 1, 105, 16, 5024),
+ (197, , 1, 2, , '卡牌强化', 1, 105, 16, 5024),
+ (198, , 1, 2, , '卡牌强化', 1, 105, 16, 5025),
+ (199, , 1, 2, , '卡牌强化', 1, 105, 16, 5025),
+ (200, , 1, 2, , '卡牌强化', 1, 105, 16, 5026),
+ (201, , 1, 2, , '卡牌强化', 1, 105, 16, 5026),
+ (202, , 1, 2, , '卡牌强化', 1, 105, 16, 5026),
+ (203, , 1, 2, , '卡牌强化', 1, 105, 24, 5028),
+ (204, , 1, 2, , '卡牌强化', 1, 105, 24, 5036),
+ (205, , 1, 2, , '卡牌强化', 1, 110, 15, 5044),
+ (206, , 1, 2, , '卡牌强化', 1, 115, 3, 5044),
+ (207, , 1, 2, , '卡牌打造武器', 1, 501, ),
+ (208, , 1, 2, , '卡牌打造武器', 1, 111, 6, 5053),
+ (209, , 1, 2, , '卡牌打造武器', 1, 112, 6, 5053),
+ (210, , 1, 2, , '卡牌打造武器', 1, 113, 6, 5053),
+ (211, , 1, 2, , '卡牌打造武器', 1, 114, 6, 5053),
+ (212, , 2, 1, , '背包上限购买', 1, 130, 2, 56, ),
+ (213, , 2, 1, , '背包上限购买', 1, 130, 2, 58, ),
+ (214, , 2, 1, , '背包上限购买', 1, 130, 2, 60, ),
+ (215, , 2, 1, , '背包上限购买', 1, 130, 2, 60, ),
+ (216, , 2, 1, , '背包上限购买', 1, 130, 2, 60, ),
+ (217, , 1, 1, , '背包上限购买', 1, 130, 2, 40, ),
+ (218, , 1, 1, , '背包上限购买', 1, 130, 2, 42, ),
+ (219, , 1, 1, , '背包上限购买', 1, 130, 2, 44, ),
+ (220, , 1, 1, , '背包上限购买', 1, 130, 2, 46, ),
+ (221, , 1, 1, , '背包上限购买', 1, 130, 2, 48, ),
+ (222, , 1, 1, , '礼包获得', 1, 501, ),
+ (223, , 1, 1, , '礼包获得', 1, 502, ),
+ (224, , 1, 1, , 'gm命令', 1, 119, 7660),
+ (225, , 1, 2, , '神殿换卡', 1, 119, , ),
+ (226, , 1, 2, , '神殿换卡', 1, 119, , ),
+ (227, , 1, 2, , '神殿换卡', 1, 119, , ),
+ (228, , 1, 2, , '神殿换卡', 1, 119, , ),
+ (229, , 1, 2, , '神殿换卡', 1, 119, , ),
+ (230, , 1, 1, , '卡牌分解', 1, 119, , ),
+ (231, , 1, 1, , '卡牌分解', 1, 119, , );
+/*!40000 ALTER TABLE `log_money` ENABLE KEYS */;
表 wg01_account.log_online 结构
+DROP TABLE IF EXISTS `log_online`;
+CREATE TABLE IF NOT EXISTS `log_online` (
`logid` int(4) unsigned NOT NULL AUTO_INCREMENT,
`time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '时间, utc秒',
`count_online` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '该组总在线',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
PRIMARY KEY (`logid`),
KEY `time` (`time`),
KEY `server_group` (`server_group`)
+) ENGINE=InnoDB AUTO_INCREMENT=380 DEFAULT CHARSET=utf8 COMMENT='在线日志表';
+-- 正在导出表
wg01_account.log_online 的数据：~341 rows (大约)
+/*!40000 ALTER TABLE `log_online` DISABLE KEYS */;
+REPLACE INTO `log_online` (`logid`, `time`, `count_online`, `server_group`) VALUES
+ (1, , 1, 1),
+ (2, , 0, 1),
+ (3, , 1, 1),
+ (4, , 0, 1),
+ (5, , 0, 1),
+ (6, , 0, 1),
+ (7, , 0, 1),
+ (8, , 0, 1),
+ (9, , 0, 1),
+ (10, , 0, 1),
+ (11, , 0, 1),
+ (12, , 0, 1),
+ (13, , 0, 1),
+ (14, , 0, 1),
+ (15, , 0, 1),
+ (16, , 0, 1),
+ (17, , 0, 1),
+ (18, , 0, 1),
+ (19, , 0, 1),
+ (20, , 0, 1),
+ (21, , 0, 1),
+ (22, , 0, 1),
+ (23, , 0, 1),
+ (24, , 0, 1),
+ (25, , 0, 1),
+ (26, , 0, 1),
+ (27, , 0, 1),
+ (28, , 0, 1),
+ (29, , 0, 1),
+ (30, , 0, 1),
+ (31, , 0, 1),
+ (32, , 0, 1),
+ (33, , 0, 1),
+ (34, , 0, 1),
+ (35, , 0, 1),
+ (36, , 0, 1),
+ (37, , 0, 1),
+ (38, , 0, 1),
+ (39, , 0, 1),
+ (40, , 0, 1),
+ (41, , 0, 1),
+ (42, , 0, 1),
+ (43, , 0, 1),
+ (44, , 0, 1),
+ (45, , 0, 1),
+ (46, , 0, 1),
+ (47, , 0, 1),
+ (48, , 0, 1),
+ (49, , 0, 1),
+ (50, , 0, 1),
+ (51, , 0, 1),
+ (52, , 0, 1),
+ (53, , 0, 1),
+ (54, , 0, 1),
+ (55, , 0, 1),
+ (56, , 0, 1),
+ (57, , 0, 1),
+ (58, , 0, 1),
+ (59, , 0, 1),
+ (60, , 0, 1),
+ (61, , 0, 1),
+ (62, , 0, 1),
+ (63, , 0, 1),
+ (64, , 0, 1),
+ (65, , 0, 1),
+ (66, , 1, 1),
+ (67, , 0, 1),
+ (68, , 0, 1),
+ (69, , 0, 1),
+ (70, , 0, 1),
+ (71, , 0, 1),
+ (72, , 0, 1),
+ (73, , 1, 1),
+ (74, , 0, 1),
+ (75, , 0, 1),
+ (76, , 0, 1),
+ (77, , 0, 1),
+ (78, , 0, 1),
+ (79, , 1, 1),
+ (80, , 0, 1),
+ (81, , 0, 1),
+ (82, , 0, 1),
+ (83, , 1, 1),
+ (84, , 0, 1),
+ (85, , 0, 1),
+ (86, , 0, 1),
+ (87, , 0, 1),
+ (88, , 0, 1),
+ (89, , 1, 1),
+ (90, , 0, 1),
+ (91, , 0, 1),
+ (92, , 0, 1),
+ (93, , 1, 1),
+ (94, , 0, 1),
+ (95, , 1, 1),
+ (96, , 0, 1),
+ (97, , 1, 1),
+ (98, , 0, 1),
+ (99, , 1, 1),
+ (100, , 0, 1),
+ (101, , 1, 1),
+ (102, , 0, 1),
+ (103, , 0, 1),
+ (104, , 0, 1),
+ (105, , 0, 1),
+ (106, , 0, 1),
+ (107, , 0, 1),
+ (108, , 0, 1),
+ (109, , 0, 1),
+ (110, , 0, 1),
+ (111, , 0, 1),
+ (112, , 0, 1),
+ (113, , 0, 1),
+ (114, , 0, 1),
+ (115, , 0, 1),
+ (116, , 1, 1),
+ (117, , 0, 1),
+ (118, , 0, 1),
+ (119, , 1, 1),
+ (120, , 0, 1),
+ (121, , 1, 1),
+ (122, , 1, 1),
+ (123, , 1, 1),
+ (124, , 0, 1),
+ (125, , 1, 1),
+ (126, , 0, 1),
+ (127, , 1, 1),
+ (128, , 0, 1),
+ (129, , 0, 1),
+ (130, , 0, 1),
+ (131, , 0, 1),
+ (132, , 0, 1),
+ (133, , 0, 1),
+ (134, , 0, 1),
+ (135, , 0, 1),
+ (136, , 0, 1),
+ (137, , 0, 1),
+ (138, , 0, 1),
+ (139, , 0, 1),
+ (140, , 0, 1),
+ (141, , 0, 1),
+ (142, , 0, 1),
+ (143, , 0, 1),
+ (144, , 0, 1),
+ (145, , 0, 1),
+ (146, , 0, 1),
+ (147, , 0, 1),
+ (148, , 0, 1),
+ (149, , 0, 1),
+ (150, , 0, 1),
+ (151, , 1, 1),
+ (152, , 0, 1),
+ (153, , 1, 1),
+ (154, , 0, 1),
+ (155, , 1, 1),
+ (156, , 0, 1),
+ (157, , 1, 1),
+ (158, , 0, 1),
+ (159, , 1, 1),
+ (160, , 0, 1),
+ (161, , 0, 1),
+ (162, , 0, 1),
+ (163, , 1, 1),
+ (164, , 0, 1),
+ (165, , 1, 1),
+ (166, , 0, 1),
+ (167, , 1, 1),
+ (168, , 0, 1),
+ (169, , 0, 1),
+ (170, , 0, 1),
+ (171, , 1, 1),
+ (172, , 0, 1),
+ (173, , 1, 1),
+ (174, , 0, 1),
+ (175, , 1, 1),
+ (176, , 0, 1),
+ (177, , 1, 1),
+ (178, , 1, 1),
+ (179, , 1, 1),
+ (180, , 1, 1),
+ (181, , 0, 1),
+ (182, , 1, 1),
+ (183, , 0, 1),
+ (184, , 0, 1),
+ (185, , 0, 1),
+ (186, , 0, 1),
+ (187, , 0, 1),
+ (188, , 0, 1),
+ (189, , 0, 1),
+ (190, , 0, 1),
+ (191, , 0, 1),
+ (192, , 0, 1),
+ (193, , 1, 1),
+ (194, , 0, 1),
+ (195, , 0, 1),
+ (196, , 0, 1),
+ (197, , 0, 1),
+ (198, , 0, 1),
+ (199, , 0, 1),
+ (200, , 0, 1),
+ (201, , 0, 1),
+ (202, , 0, 1),
+ (203, , 0, 1),
+ (204, , 0, 1),
+ (205, , 0, 1),
+ (206, , 0, 1),
+ (207, , 0, 1),
+ (208, , 0, 1),
+ (209, , 0, 1),
+ (210, , 0, 1),
+ (211, , 0, 1),
+ (212, , 0, 1),
+ (213, , 0, 1),
+ (214, , 0, 1),
+ (215, , 0, 1),
+ (216, , 0, 1),
+ (217, , 0, 1),
+ (218, , 0, 1),
+ (219, , 0, 1),
+ (220, , 0, 1),
+ (221, , 0, 1),
+ (222, , 1, 1),
+ (223, , 0, 1),
+ (224, , 0, 1),
+ (225, , 0, 1),
+ (226, , 1, 1),
+ (227, , 0, 1),
+ (228, , 1, 1),
+ (229, , 0, 1),
+ (230, , 1, 1),
+ (231, , 0, 1),
+ (232, , 0, 1),
+ (233, , 0, 1),
+ (234, , 0, 1),
+ (235, , 0, 1),
+ (236, , 0, 1),
+ (237, , 0, 1),
+ (238, , 0, 1),
+ (239, , 0, 1),
+ (240, , 0, 1),
+ (241, , 0, 1),
+ (242, , 0, 1),
+ (243, , 0, 1),
+ (244, , 0, 1),
+ (245, , 0, 1),
+ (246, , 0, 1),
+ (247, , 0, 1),
+ (248, , 0, 1),
+ (249, , 1, 1),
+ (250, , 0, 1),
+ (251, , 1, 1),
+ (252, , 0, 1),
+ (253, , 1, 1),
+ (254, , 0, 1),
+ (255, , 0, 1),
+ (256, , 0, 1),
+ (257, , 0, 1),
+ (258, , 0, 1),
+ (259, , 0, 1),
+ (260, , 0, 1),
+ (261, , 0, 1),
+ (262, , 0, 1),
+ (263, , 1, 1),
+ (264, , 0, 1),
+ (265, , 1, 1),
+ (266, , 0, 1),
+ (267, , 0, 1),
+ (268, , 0, 1),
+ (269, , 0, 1),
+ (270, , 0, 1),
+ (271, , 0, 1),
+ (272, , 0, 1),
+ (273, , 1, 1),
+ (274, , 0, 1),
+ (275, , 0, 1),
+ (276, , 1, 1),
+ (277, , 1, 1),
+ (278, , 0, 1),
+ (279, , 1, 1),
+ (280, , 1, 1),
+ (281, , 1, 1),
+ (282, , 0, 1),
+ (283, , 0, 1),
+ (284, , 1, 1),
+ (285, , 1, 1),
+ (286, , 0, 1),
+ (287, , 1, 1),
+ (288, , 0, 1),
+ (289, , 1, 1),
+ (290, , 0, 1),
+ (291, , 1, 1),
+ (292, , 0, 1),
+ (293, , 1, 1),
+ (294, , 0, 1),
+ (295, , 1, 1),
+ (296, , 0, 1),
+ (297, , 1, 1),
+ (298, , 0, 1),
+ (299, , 1, 1),
+ (300, , 1, 1),
+ (301, , 1, 1),
+ (302, , 1, 1),
+ (303, , 1, 1),
+ (304, , 1, 1),
+ (305, , 0, 1),
+ (306, , 1, 1),
+ (307, , 0, 1),
+ (308, , 0, 1),
+ (309, , 0, 1),
+ (310, , 0, 1),
+ (311, , 1, 1),
+ (312, , 1, 1),
+ (313, , 1, 1),
+ (314, , 0, 1),
+ (315, , 1, 1),
+ (316, , 0, 1),
+ (317, , 1, 1),
+ (318, , 0, 1),
+ (319, , 0, 1),
+ (320, , 0, 1),
+ (321, , 1, 1),
+ (322, , 0, 1),
+ (323, , 0, 1),
+ (324, , 0, 1),
+ (325, , 0, 1),
+ (326, , 0, 1),
+ (327, , 0, 1),
+ (328, , 0, 1),
+ (329, , 0, 1),
+ (330, , 0, 1),
+ (331, , 0, 1),
+ (332, , 0, 1),
+ (333, , 0, 1),
+ (334, , 0, 1),
+ (335, , 0, 1),
+ (336, , 0, 1),
+ (337, , 0, 1),
+ (338, , 0, 1),
+ (339, , 0, 1),
+ (340, , 0, 1),
+ (341, , 0, 1),
+ (342, , 0, 1),
+ (343, , 0, 1),
+ (344, , 0, 1),
+ (345, , 0, 1),
+ (346, , 0, 1),
+ (347, , 0, 1),
+ (348, , 0, 1),
+ (349, , 0, 1),
+ (350, , 0, 1),
+ (351, , 0, 1),
+ (352, , 0, 1),
+ (353, , 0, 1),
+ (354, , 0, 1),
+ (355, , 0, 1),
+ (356, , 0, 1),
+ (357, , 0, 1),
+ (358, , 0, 1),
+ (359, , 0, 1),
+ (360, , 0, 1),
+ (361, , 0, 1),
+ (362, , 0, 1),
+ (363, , 0, 1),
+ (364, , 0, 1),
+ (365, , 0, 1),
+ (366, , 0, 1),
+ (367, , 0, 1),
+ (368, , 0, 1),
+ (369, , 0, 1),
+ (370, , 0, 1),
+ (371, , 0, 1),
+ (372, , 0, 1),
+ (373, , 0, 1),
+ (374, , 0, 1),
+ (375, , 0, 1),
+ (376, , 0, 1),
+ (377, , 0, 1),
+ (378, , 0, 1),
+ (379, , 0, 1);
+/*!40000 ALTER TABLE `log_online` ENABLE KEYS */;
表 wg01_account.log_poker 结构
+DROP TABLE IF EXISTS `log_poker`;
+CREATE TABLE IF NOT EXISTS `log_poker` (
`id` bigint(10) NOT NULL AUTO_INCREMENT,
`account_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号id',
`user_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线',
`time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '记录utc时间',
`type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '类型',
`poker_id` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '卡牌id',
`data` bigint(10) unsigned NOT NULL DEFAULT '0' COMMENT '数据',
`reason` varchar(255) NOT NULL DEFAULT '' COMMENT '原因',
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`),
KEY `user_id` (`user_id`),
KEY `server_group` (`server_group`),
KEY `type` (`type`),
KEY `time` (`time`)
+) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8 COMMENT='卡牌日志';
+-- 正在导出表
wg01_account.log_poker 的数据：~103 rows (大约)
+/*!40000 ALTER TABLE `log_poker` DISABLE KEYS */;
+REPLACE INTO `log_poker` (`id`, `account_id`, `user_id`, `server_group`, `server_line`, `time`, `type`, `poker_id`, `data`, `reason`) VALUES
+ (1, , 1, , 1, 86, 2001, '新增新吧唧'),
+ (2, , 1, , 1, 87, 2001, '新增[新吧唧]'),
+ (3, , 1, , 2, 86, 2001, '解雇[新吧唧] 等级[1] 星级[1] 强化[0] 宝具[0] 突破[0] 随机四围[41]'),
+ (4, , 1, , 3, 87, 2001, '升级[新吧唧] 等级[1-&2] 消耗经验[45]'),
+ (5, , 1, , 3, 87, 2001, '升级[新吧唧] 等级[2-&3] 消耗经验[133]'),
+ (6, , 1, , 3, 87, 2001, '升级[新吧唧] 等级[3-&4] 消耗经验[220]'),
+ (7, , 1, , 3, 87, 2001, '升级[新吧唧] 等级[4-&5] 消耗经验[306]'),
+ (8, , 1, , 3, 87, 2001, '升级[新吧唧] 等级[5-&6] 消耗经验[391]'),
+ (9, , 1, , 4, 82, 5001, '升星[卓戈卡奥] 星级[1-&2] 雕像[0] 金币[6000]'),
+ (10, , 1, , 1, 88, 6001, '新增[夫子]'),
+ (11, , 1, , 5, 84, 6001, '强化[夫子] 强化[4-&5] 基础概率[9000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (12, , 1, , 5, 84, 6001, '强化[夫子] 强化[5-&6] 基础概率[9000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (13, , 1, , 5, 84, 6001, '强化[夫子] 强化[6-&7] 基础概率[9000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (14, , 1, , 5, 84, 6001, '强化[夫子] 强化[7-&8] 基础概率[8000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (15, , 1, , 5, 84, 6001, '强化[夫子] 强化[8-&9] 基础概率[8000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (16, , 1, , 5, 84, 6001, '强化[夫子] 强化[9-&10] 基础概率[8000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (17, , 1, , 5, 84, 6001, '强化[夫子] 强化[9-&10] 基础概率[8000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (18, , 1, , 5, 84, 6001, '强化[夫子] 强化[9-&10] 基础概率[8000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (19, , 1, , 5, 84, 6001, '强化[夫子] 强化[10-&11] 基础概率[7000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (20, , 1, , 5, 84, 6001, '强化[夫子] 强化[11-&12] 基础概率[7000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (21, , 1, , 5, 84, 6001, '强化[夫子] 强化[12-&13] 基础概率[6000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (22, , 1, , 5, 84, 6001, '强化[夫子] 强化[12-&13] 基础概率[6000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (23, , 1, , 5, 84, 6001, '强化[夫子] 强化[13-&14] 基础概率[6000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (24, , 1, , 5, 84, 6001, '强化[夫子] 强化[14-&15] 基础概率[5000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (25, , 1, , 5, 84, 6001, '强化[夫子] 强化[14-&15] 基础概率[5000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (26, , 1, , 5, 84, 6001, '强化[夫子] 强化[15-&16] 基础概率[5000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (27, , 1, , 5, 84, 6001, '强化[夫子] 强化[15-&16] 基础概率[5000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (28, , 1, , 5, 84, 6001, '强化[夫子] 强化[15-&16] 基础概率[5000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (29, , 1, , 5, 84, 6001, '强化[夫子] 强化[16-&17] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (30, , 1, , 5, 84, 6001, '强化[夫子] 强化[16-&17] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (31, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (32, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (33, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (34, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (35, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (36, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (37, , 1, , 5, 84, 6001, '强化[夫子] 强化[17-&18] 基础概率[4000] 增加概率[0] 消耗元宝[0] 成功[1]'),
+ (38, , 1, , 5, 84, 6001, '强化[夫子] 强化[18-&19] 基础概率[3000] 增加概率[0] 消耗元宝[0] 成功[0]'),
+ (39, , 1, , 5, 84, 6001, '强化[夫子] 强化[18-&19] 基础概率[3000] 增加概率[7000] 消耗元宝[170] 成功[1]'),
+ (40, , 1, , 5, 84, 6001, '强化[夫子] 强化[19-&20] 基础概率[3000] 增加概率[7000] 消耗元宝[170] 成功[1]'),
+ (41, , 1, , 7, 84, 6001, '宝具打造[夫子]'),
+ (42, , 1, , 8, 84, 87, '能力转移[夫子-&新吧唧] 元宝消耗[32] 源{等级[1] 星级[1] 强化[20] 宝具[1] 突破[0]} 目标{等级[6] 星级[1] 强化[0] 宝具[0] 突破[0]}'),
+ (43, , 1, , 8, 87, 84, '能力转移[新吧唧-&夫子] 元宝消耗[256] 源{等级[1] 星级[1] 强化[20] 宝具[1] 突破[0]} 目标{等级[1] 星级[1] 强化[0] 宝具[0] 突破[0]}'),
+ (44, , 1, , 1, 91, 5002, '新增[亚瑟]'),
+ (45, , 1, , 1, 92, 5002, '新增[亚瑟]'),
+ (46, , 1, , 1, 93, 5002, '新增[亚瑟]'),
+ (47, , 1, , 1, 94, 5002, '新增[亚瑟]'),
+ (48, , 1, , 1, 95, 5002, '新增[亚瑟]'),
+ (49, , 1, , 1, 96, 1001, '新增[暴力打手]'),
+ (50, , 1, , 1, 97, 1001, '新增[暴力打手]'),
+ (51, , 1, , 1, 98, 1001, '新增[暴力打手]'),
+ (52, , 1, , 1, 99, 5002, '新增[亚瑟]'),
+ (53, , 1, , 1, 100, 1001, '新增[暴力打手]'),
+ (54, , 1, , 1, 101, 1001, '新增[暴力打手]'),
+ (55, , 1, , 1, 102, 1001, '新增[暴力打手]'),
+ (56, , 1, , 1, 103, 1001, '新增[暴力打手]'),
+ (57, , 1, , 1, 104, 1001, '新增[暴力打手]'),
+ (58, , 1, , 1, 105, 1001, '新增[暴力打手]'),
+ (59, , 1, , 1, 106, 3002, '新增[蓝龙]'),
+ (60, , 1, , 1, 107, 2001, '新增[新吧唧]'),
+ (61, , 1, , 1, 108, 4002, '新增[金三胖]'),
+ (62, , 1, , 1, 109, 3002, '新增[蓝龙]'),
+ (63, , 1, , 1, 110, 3002, '新增[蓝龙]'),
+ (64, , 1, , 1, 111, 4003, '新增[奥巴马]'),
+ (65, , 1, , 1, 112, 3002, '新增[蓝龙]'),
+ (66, , 1, , 1, 113, 3002, '新增[蓝龙]'),
+ (67, , 1, , 1, 114, 4002, '新增[金三胖]'),
+ (68, , 1, , 1, 115, 3001, '新增[美狄亚]'),
+ (69, , 1, , 1, 116, 4003, '新增[奥巴马]'),
+ (70, , 1, , 1, 117, 5002, '新增[亚瑟]'),
+ (71, , 1, , 1, 118, 3002, '新增[蓝龙]'),
+ (72, , 1, , 1, 119, 3001, '新增[美狄亚]'),
+ (73, , 1, , 1, 120, 3002, '新增[蓝龙]'),
+ (74, , 1, , 1, 121, 4003, '新增[奥巴马]'),
+ (75, , 1, , 1, 122, 3001, '新增[美狄亚]'),
+ (76, , 1, , 1, 123, 3002, '新增[蓝龙]'),
+ (77, , 1, , 1, 124, 3002, '新增[蓝龙]'),
+ (78, , 1, , 1, 125, 3001, '新增[美狄亚]'),
+ (79, , 1, , 1, 126, 3002, '新增[蓝龙]'),
+ (80, , 1, , 1, 127, 3002, '新增[蓝龙]'),
+ (81, , 1, , 1, 128, 3002, '新增[蓝龙]'),
+ (82, , 1, , 2, 95, 5002, '解雇[亚瑟] 等级[1] 星级[1] 强化[0] 宝具[0] 突破[0] 随机四围[35]'),
+ (83, , 1, , 2, 99, 5002, '解雇[亚瑟] 等级[1] 星级[1] 强化[0] 宝具[0] 突破[0] 随机四围[25]'),
+ (84, , 1, , 1, 129, 1001, '新增[暴力打手]'),
+ (85, , 1, , 1, 130, 1001, '新增[暴力打手]'),
+ (86, , 1, , 1, 131, 4002, '新增[金三胖]'),
+ (87, , 1, , 1, 132, 1001, '新增[暴力打手]'),
+ (88, , 1, , 1, 133, 1001, '新增[暴力打手]'),
+ (89, , 1, , 1, 134, 1001, '新增[暴力打手]'),
+ (90, , 1, , 1, 135, 1001, '新增[暴力打手]'),
+ (91, , 1, , 1, 136, 1001, '新增[暴力打手]'),
+ (92, , 1, , 1, 137, 1001, '新增[暴力打手]'),
+ (93, , 1, , 1, 138, 1001, '新增[暴力打手]'),
+ (94, , 1, , 1, 139, 1001, '新增[暴力打手]'),
+ (95, , 1, , 1, 140, 1001, '新增[暴力打手]'),
+ (96, , 1, , 1, 141, 4003, '新增[奥巴马]'),
+ (97, , 1, , 1, 142, 1001, '新增[暴力打手]'),
+ (98, , 1, , 1, 143, 1001, '新增[暴力打手]'),
+ (99, , 1, , 1, 144, 1001, '新增[暴力打手]'),
+ (100, , 1, , 1, 145, 1001, '新增[暴力打手]'),
+ (101, , 1, , 1, 146, 1001, '新增[暴力打手]'),
+ (102, , 1, , 1, 147, 1001, '新增[暴力打手]'),
+ (103, , 1, , 1, 148, 1001, '新增[暴力打手]');
+/*!40000 ALTER TABLE `log_poker` ENABLE KEYS */;
表 wg01_account.log_vas 结构
+DROP TABLE IF EXISTS `log_vas`;
+CREATE TABLE IF NOT EXISTS `log_vas` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`account_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '账号id',
`user_id` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线',
`flow_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '类型, 1获得, 2消费',
`time` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '发生时间, utc秒',
`reason` varchar(127) NOT NULL DEFAULT '未填写' COMMENT '记录日志原因',
`reason_amount` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '记录日志数量',
`point` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作点数',
`after_point` bigint(20) NOT NULL DEFAULT '0' COMMENT '操作后点数',
PRIMARY KEY (`id`),
KEY `account_id` (`account_id`),
KEY `user_id` (`user_id`),
KEY `itemtype_id` (`reason`),
KEY `server_group` (`server_group`),
KEY `time` (`time`),
KEY `flow_type` (`flow_type`)
+) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COMMENT='元宝日志';
+-- 正在导出表
wg01_account.log_vas 的数据：~27 rows (大约)
+/*!40000 ALTER TABLE `log_vas` DISABLE KEYS */;
+REPLACE INTO `log_vas` (`id`, `account_id`, `user_id`, `server_group`, `server_line`, `flow_type`, `time`, `reason`, `reason_amount`, `point`, `after_point`) VALUES
+ (1, , 1, 1, , 'gm命令', 1, 100, 130),
+ (2, , 1, 2, , 'gm命令', 1, 100, 30),
+ (3, , 1, 1, , 'gm命令', 1, 100, 130),
+ (4, , 1, 1, , 'gm命令', 1, 10, 140),
+ (5, , 1, 1, , 'gm命令', 1, 10, 150),
+ (6, , 1, 1, , 'gm命令', 1, 10, 160),
+ (7, , 1, 1, , 'gm命令', 1, 10, 170),
+ (8, , 1, 1, , 'gm命令', 1, 100, 270),
+ (9, , 1, 1, , 'gm命令', 1, 100, 370),
+ (10, , 1, 1, , 'gm命令', 1, 30, 400),
+ (11, , 1, 1, , 'gm命令', 1, 30, 430),
+ (12, , 1, 2, , '卡牌能力转移', 1, 256, 174),
+ (13, , 1, 1, , 'gm命令', 1, 000173),
+ (14, , 1, 2, , '卡牌强化', 1, 650, 9999523),
+ (15, , 1, 2, , '卡牌强化', 1, 650, 9998873),
+ (16, , 1, 2, , '卡牌强化', 1, 3),
+ (17, , 1, 2, , '卡牌强化', 1, 3),
+ (18, , 1, 2, , '卡牌能力转移', 1, 256, 9993957),
+ (19, , 1, 2, , '卡牌强化', 1, 170, 9993787),
+ (20, , 1, 2, , '卡牌强化', 1, 170, 9993617),
+ (21, , 1, 2, , '卡牌能力转移', 1, 32, 9993585),
+ (22, , 1, 2, , '卡牌能力转移', 1, 256, 9993329),
+ (23, , 1, 2, , '抽卡', 1, 60, 9993269),
+ (24, , 1, 2, , '抽卡', 1, 580, 9992689),
+ (25, , 1, 2, , '抽卡', 1, 580, 9992109),
+ (26, , 1, 2, , '抽卡', 1, 480, 9991629),
+ (27, , 1, 2, , '抽卡', 1, 480, 9991149);
+/*!40000 ALTER TABLE `log_vas` ENABLE KEYS */;
表 wg01_account.newcard 结构
+DROP TABLE IF EXISTS `newcard`;
+CREATE TABLE IF NOT EXISTS `newcard` (
`Id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`card` varchar(64) NOT NULL DEFAULT '0' COMMENT '卡号',
`picked` int(4) unsigned zerofill NOT NULL DEFAULT '0000' COMMENT '使用标记（0未使用，1已使用）',
`platform` varchar(10) NOT NULL DEFAULT '' COMMENT '平台',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
PRIMARY KEY (`Id`),
UNIQUE KEY `newcard` (`card`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='新手卡号码表';
+-- 正在导出表
wg01_account.newcard 的数据：~0 rows (大约)
+/*!40000 ALTER TABLE `newcard` DISABLE KEYS */;
+/*!40000 ALTER TABLE `newcard` ENABLE KEYS */;
表 wg01_account.pay 结构
+DROP TABLE IF EXISTS `pay`;
+CREATE TABLE IF NOT EXISTS `pay` (
`logid` bigint(10) unsigned NOT NULL AUTO_INCREMENT,
`paynum` varchar(255) NOT NULL DEFAULT '0' COMMENT '流水号，18位正整数',
`logdate` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '日志写入时间戳',
`account_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '账号id',
`user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '角色id',
`ip` varchar(20) NOT NULL DEFAULT '',
`paygold` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '充值元宝',
`freegold` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '赠送元宝(平台插入时填0)',
`paymoney` decimal(10,2) unsigned DEFAULT '0.00' COMMENT '充值RMB',
`used` int(10) unsigned DEFAULT '0' COMMENT '是否使用过(平台插入时填0)',
`channel` varchar(20) DEFAULT '0',
`channel_fee` float(4,3) NOT NULL DEFAULT '0.000',
`server_group` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组号',
`config_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '配置id',
PRIMARY KEY (`logid`),
UNIQUE KEY `paynum` (`paynum`),
KEY `used` (`used`),
KEY `userid` (`account_id`),
KEY `logdate` (`logdate`),
KEY `server_line` (`server_group`),
KEY `user_id` (`user_id`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='玩家充值记录';
+-- 正在导出表
wg01_account.pay 的数据：~0 rows (大约)
+/*!40000 ALTER TABLE `pay` DISABLE KEYS */;
+/*!40000 ALTER TABLE `pay` ENABLE KEYS */;
表 wg01_account.server_list 结构
+DROP TABLE IF EXISTS `server_list`;
+CREATE TABLE IF NOT EXISTS `server_list` (
`server_group` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组',
`server_line` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线路',
`client_ip` varchar(50) NOT NULL DEFAULT '' COMMENT '客户端连接ip',
`client_port` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '客户端连接端口',
`close` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关闭标志, 不等于0开入口',
UNIQUE KEY `group_line` (`server_group`,`server_line`),
KEY `server_group` (`server_group`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='服务器配置表\r\n该表不由策划管控, 故放置在账号库';
+-- 正在导出表
wg01_account.server_list 的数据：~2 rows (大约)
+/*!40000 ALTER TABLE `server_list` DISABLE KEYS */;
+REPLACE INTO `server_list` (`server_group`, `server_line`, `client_ip`, `client_port`, `close`) VALUES
+ (1, 1, '10.0.0.51', 10002, 0),
+ (1, 2, '10.0.0.52', 10002, 0),
+ (1, 3, '120.26.67.185', 10003, 0);
+/*!40000 ALTER TABLE `server_list` ENABLE KEYS */;
+/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
+/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
+/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Index: const.sql
===================================================================
--- const.sql (revision 0)
+++ const.sql (revision 2)
@@ -0,0 +1,3529 @@
+-- --------------------------------------------------------
120.26.67.185
+-- 服务器版本:
5.6.11 - MySQL Community Server (GPL)
+-- 服务器操作系统:
+-- HeidiSQL 版本:
9.2.0.4950
+-- --------------------------------------------------------
+/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
+/*!40101 SET NAMES utf8mb4 */;
+/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
+/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
表 wg01_const.action 结构
+CREATE TABLE IF NOT EXISTS `action` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`file_path` varchar(128) NOT NULL DEFAULT '' COMMENT '文件路径',
`function` varchar(128) NOT NULL DEFAULT '' COMMENT '函数入口',
`client_trigger` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '0客户端不可触发, 1客户端可触发',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=888889 DEFAULT CHARSET=utf8 COMMENT='脚本action';
+-- 正在导出表
wg01_const.action 的数据：~6 rows (大约)
+/*!40000 ALTER TABLE `action` DISABLE KEYS */;
+REPLACE INTO `action` (`id`, `file_path`, `function`, `client_trigger`) VALUES
+ (100, 'login.lua', 'login()', 0),
+ (123, 'syn\\syndicate.lua', 'JoinSyndicateSaveTime()', 0),
+ (321, 'syn\\syndicate.lua', 'QuitSyndicateSaveTime()', 0),
+ (998, 'challenge.lua', 'ChallengeWin()', 0),
+ (999, 'challenge.lua', 'WorldRankAward()', 0),
+ (888888, 'test.lua', 'test()', 0);
+/*!40000 ALTER TABLE `action` ENABLE KEYS */;
表 wg01_const.activities 结构
+CREATE TABLE IF NOT EXISTS `activities` (
`id` int(4) NOT NULL AUTO_INCREMENT COMMENT '活动id',
`type` int(4) NOT NULL DEFAULT '0' COMMENT '活动类型',
`time_type` int(4) NOT NULL DEFAULT '0' COMMENT '活动时间类别',
`begin_time` int(4) NOT NULL DEFAULT '0' COMMENT '开始时间',
`end_time` int(4) NOT NULL DEFAULT '0' COMMENT '结束时间',
`begin_action` int(4) NOT NULL DEFAULT '0' COMMENT '活动开始触发脚本',
`end_action` int(4) NOT NULL DEFAULT '0' COMMENT '活动结束触发脚本',
`server_group` int(4) NOT NULL DEFAULT '0' COMMENT '服务器组(99999表示所有服务器组开启）',
`server_line` int(4) NOT NULL DEFAULT '0' COMMENT '服务器线路(99999表示全服开启，0表示不开启）',
`param1` int(4) NOT NULL DEFAULT '0' COMMENT '预留参数1',
`param2` int(4) NOT NULL DEFAULT '0' COMMENT '预留参数2',
`param3` int(4) NOT NULL DEFAULT '0' COMMENT '预留参数3',
`param4` int(4) NOT NULL DEFAULT '0' COMMENT '预留参数4',
`param5` int(4) NOT NULL DEFAULT '0' COMMENT '预留参数5',
`comment` varchar(127) NOT NULL DEFAULT '0' COMMENT '注释字段',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8 COMMENT='活动配置表';
+-- 正在导出表
wg01_const.activities 的数据：~2 rows (大约)
+/*!40000 ALTER TABLE `activities` DISABLE KEYS */;
+REPLACE INTO `activities` (`id`, `type`, `time_type`, `begin_time`, `end_time`, `begin_action`, `end_action`, `server_group`, `server_line`, `param1`, `param2`, `param3`, `param4`, `param5`, `comment`) VALUES
+ (1, 1, 2, 8, 0, 0, 90, , 0, 0, 0, 'Test'),
+ (2, 1, 2, , 9, 480, , 0, 0, 0, 'Test');
+/*!40000 ALTER TABLE `activities` ENABLE KEYS */;
表 wg01_const.auto_reload 结构
+CREATE TABLE IF NOT EXISTS `auto_reload` (
`table_name` varchar(255) NOT NULL DEFAULT '' COMMENT '表名',
`server_group` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '服务器组号, 填0表示全部',
`server_line` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '服务器线路号, 填0表示全部',
`utc_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '指定时间, 填0表示即时',
UNIQUE KEY `table_name_group` (`table_name`,`server_group`),
KEY `group` (`server_group`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='自动加载配置表\r\n通过点击关系服按钮触发';
+-- 正在导出表
wg01_const.auto_reload 的数据：~0 rows (大约)
+/*!40000 ALTER TABLE `auto_reload` DISABLE KEYS */;
+/*!40000 ALTER TABLE `auto_reload` ENABLE KEYS */;
表 wg01_const.config 结构
+CREATE TABLE IF NOT EXISTS `config` (
`type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '可配置数据类型',
`data` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '数据1',
`comment` varchar(127) NOT NULL DEFAULT '无' COMMENT '注释字段(该字段不读入数据库)',
UNIQUE KEY `type` (`type`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='const_常量配置表';
+-- 正在导出表
wg01_const.config 的数据：~15 rows (大约)
+/*!40000 ALTER TABLE `config` DISABLE KEYS */;
+REPLACE INTO `config` (`type`, `data`, `comment`) VALUES
+ (1, 3, '聊天限时，私聊限制'),
+ (2, 3, '聊天限时，帮派限制'),
+ (3, 20, '聊天限时，世界限制'),
+ (4, 20, '聊天等级限制，世界限制'),
+ (6, 30, '聊天配置，私聊记录上限'),
+ (7, 30, '聊天配置，帮派聊天记录上限'),
+ (8, 30, '聊天配置，世界聊天记录上限'),
+ (10, 0, '创建帮派，需要玩家等级'),
+ (11, 0, '创建帮派 需要元宝'),
+ (12, 0, '创建帮派 需要元宝'),
+ (13, 0, '帮派活跃 帮派每日活跃上限'),
+ (16, 0, '体力恢复时间间隔'),
+ (17, 0, '每日第一次签到开始时间'),
+ (18, 120000, '每日第二次签到开始时间'),
+ (19, 180000, '每日第三次签到开始时间');
+/*!40000 ALTER TABLE `config` ENABLE KEYS */;
表 wg01_const.config_text 结构
+CREATE TABLE IF NOT EXISTS `config_text` (
`id` int(4) unsigned NOT NULL AUTO_INCREMENT COMMENT '文字id',
`text` varchar(511) NOT NULL DEFAULT '' COMMENT '可配置文字内容',
PRIMARY KEY (`id`)
+) ENGINE=InnoDB AUTO_INCREMENT=305 DEFAULT CHARSET=utf8 COMMENT='const_可配置的文字表';
+-- 正在导出表
wg01_const.config_text 的数据：~59 rows (大约)
+/*!40000 ALTER TABLE `config_text` DISABLE KEYS */;
+REPLACE INTO `config_text` (`id`, `text`) VALUES
+ (2, '玩家不存在或不在线'),
+ (3, '发送消息过快'),
+ (4, '不合法的消息'),
+ (5, '等级不够'),
+ (6, '元宝不足'),
+ (7, '最新的服务器'),
+ (8, '登陆过的服务器'),
+ (9, '全部服务器'),
+ (10, '被系统踢出'),
+ (11, '密码错误'),
+ (12, '在其他处登入'),
+ (13, '在其他地方登入'),
+ (14, '登入人数过多，登入失败'),
+ (15, '被GM踢出'),
+ (16, '服务器入口未开放'),
+ (17, 'GM工具Mac地址验证错误'),
+ (18, '系统将您踢出'),
+ (19, 'GM命令踢自己'),
+ (20, '登陆超时'),
+ (21, '您的账号被临时封停，预计%d小时后解封'),
+ (22, '您的账号被永久封停'),
+ (31, '%s创建公会%s'),
+ (32, '会长'),
+ (33, '长老'),
+ (34, '成员'),
+ (35, '公会不存在'),
+ (41, '【%s】创建公会'),
+ (42, '【%s】加入公会'),
+ (43, '【%s】退出公会'),
+ (44, '公会%s【%s】将【%s】踢出了公会'),
+ (45, '公会%s【%s】修改了公会公告'),
+ (46, '会长【%s】将【%s】提升为长老'),
+ (47, '会长【%s】取消了【%s】的长老职位'),
+ (48, '公会%s【%s】重置了团队副本：第%d章'),
+ (49, '团队副本:第%d章通关，最后一击由【%s】完成'),
+ (50, '【%s】将会长职位移交给了【%s】'),
+ (51, '【%s】在战利品%s的队列中插队'),
+ (52, '公会%s【%s】批准了【%s】加入公会'),
+ (53, '公会%s【%s】修改了加入公会最小战队等级为：%d级'),
+ (54, '公会%s【%s】将%s分配给了【%s】'),
+ (55, '公会%s【%s】修改了公会类型为：需验证'),
+ (56, '公会%s【%s】修改了公会类型为：不需要验证'),
+ (57, '会长【%s】长时间未上线，会长职位自动禅让给【%s】'),
+ (71, '请先选择服务器！'),
+ (72, '没有游戏服可以连接！'),
+ (73, '游戏服务器连接失败！'),
+ (74, '角色创建失败！'),
+ (75, '名字中包含非法字符！'),
+ (76, '非法字符！'),
+ (77, '重复的角色名'),
+ (78, '无法创建更多的角色！'),
+ (79, '操作失败！'),
+ (80, '未知的操作类型！'),
+ (81, '背包空间不足！'),
+ (82, '元宝不足！'),
+ (83, '需要%d个【%s】'),
+ (84, '开始自动重连'),
+ (85, '重连成功'),
+ (86, '重连失败');
+/*!40000 ALTER TABLE `config_text` ENABLE KEYS */;
表 wg01_const.drop_rule 结构
+CREATE TABLE IF NOT EXISTS `drop_rule` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主id',
`type` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '掉落类型规则, 1一次规则, 2多次规则',
`count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '一次规则表示按权重掉多少个, 多次规则表示执行多少次独立权重',
`chance` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '触发概率, 万分比, 满足概率才进行权重',
`group1_type` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '六位数直接表示itemtype, 三位数表示货币类型, 其余做保留',
`group1_count` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '数量',
`group1_weight` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '权重',
`group1_group` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '归属,0玩家,1帮派',
`group2_type` int(10) unsigned NOT NULL DEFAULT '0',
`group2_}
我要回帖
更多关于 暗黑3暴击几率上限 的文章
- ·三剑豪 我的圣诞套装加7%暴击那个 为什么脱了跟穿上神武法术暴击几率率都一样
- ·code10017无法加入该频道,你加入这类频道的数量已达到上限 暗黑3减cd上限 求解决
- ·暗黑3暴击伤害上限中"无法加入该频道,这类频道的数量已达到上限(Code10017)"怎么解决，速度求帮助啊
- ·暗黑3野蛮人爆暗黑3暴击几率上限多少算毕业
- ·暗黑3巅峰等级上限城主有背包上限吗？
- ·刷图防具生命阴阳师怎么堆暴击几率率暴击伤害好还是全属性攻击双爆好
- ·阴阳师怎么堆暴击几率率0.95能出暴击吗
- ·DNF假面提升率，现在假设，原始阴阳师怎么堆暴击几率率60%，提升阴阳师怎么堆暴击几率率30%（假面），
- ·会心上限好还是会心英雄联盟暴击几率上限好
- ·各位，这游戏的梦幻西游手游暴击几率率怎么算的
- ·龙王捕鱼 JDB电子gamednf暴击几率率有多高？？ ？？？？
更多推荐
- ·杀戮尖塔很难玩吗冰球流机器人怎么玩介绍_杀戮尖塔很难玩吗冰球流机器人怎么玩是什么
- ·求PS游戏神界诸神之战游戏手机版-盖亚首领这款游戏,有无大佬能发一下
- ·《大汉龙腾》新手指引之攻城掠地兵器180直接升神兵吗获取介绍_《大汉龙腾》新手指引之攻城掠地兵器180直接升神兵吗获取是什么
- ·《小李飞刀攻略》竞技场攻略介绍_《小李飞刀攻略》竞技场攻略是什么
- ·无限法则怎么退出黑夜模式式什么时候开启介绍_无限法则怎么退出黑夜模式式什么时候开启是什么
- ·我的jj号有人在玩.的怎么把他停了人人网现在还有人玩吗
- ·侠盗猎车手3 罪恶都市罪恶都市超级武器在哪
- ·血染力量22号在NGA发生了什么事？怎么删除钢铁力量账号好多贴被删了啊
- ·马池中路冰箱周围有臭味这么臭
- ·怎么获取掌上cf的cf百宝箱怎么卸载
- ·全球使命2好玩吗怎么上不去2.1.78
- ·lol2015热门英雄近期增强英雄
- ·永恒之塔要塞视频 打开阿祖要塞里面箱子的钥匙任务在哪里接受
- ·新版欢乐斗地主新版本输赢400万
- ·全民奇迹装备进阶打飞机精英级太空堡垒进阶材料清单
- ·传奇霸业wg怎么不能开wg
- ·这什么配置能玩gta5可以玩gta v 吗？
- ·一刀外挂一刀辅助免费版怎么调合适
- ·仙域论坛宠物美人鱼和暴龙合成会合出什么?
- ·暗黑3暴击伤害上限中"无法加入该频道,这类频道的数量已达到上限(Code10017)"怎么解决，速度求帮助啊
- ·剑网3藏剑宏加速阙值
- ·我想问一下四年的滇重楼种植技术视频有多大
- ·lol游戏程序正在运行仍在运行中
- ·gta4自由城之章秘籍进不去啊
- ·黑暗传说单机rpg 存档无线钻币存档
- ·yy上lol小智在哪个yy直播担保的那个十块购买q币是真的?
- ·我想找回更新前的欢乐斗地主下载
- ·爆无影剑艾格斯视频附光卡百分之二十五伤害稳定吗?
- ·舰娘提督名字魔改时名字的字体颜色怎么设置
- ·拳皇2002风云再起破解龙二破防的手刀怎么使
- ·扣扣qq飞车预下载是什么登不上拉，是什么情况？
- ·海立方官网要是快玩游戏盒官网，他有什么好的呢？ ？？
- ·最火爆客户端IP地址 是会变得吗？？大海传奇里面怎么挂机小传奇打内功
- ·求个传奇仿飘逸时空传奇挂和怎么调的视频
- ·热血传奇怎么升级武器英雄内功怎么升级
