[dev] Phiêu Miễu Tuyết Vực

[tumickey]

1. Bổ sung log gm (mysql):
Dùng để log các thông số user cho việc thống kê.

-- -------------------------------------------------------- -- Host:                         127.0.0.1 -- Server version:               5.1.48-community-log - MySQL Community Server (GPL) -- Server OS:                    Win32 -- HeidiSQL version:             7.0.0.4234 -- Date/time:                    2013-06-04 16:55:39 -- --------------------------------------------------------  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET NAMES utf8 */; /*!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' */;  -- Dumping structure for table db_web.log_create_role DROP TABLE IF EXISTS `log_create_role`; CREATE TABLE IF NOT EXISTS `log_create_role` ( `username` varchar(50) CHARACTER SET latin1 DEFAULT NULL, `userid` int(11) DEFAULT NULL, `rolename` varchar(50) CHARACTER SET latin1 DEFAULT NULL, `roleid` int(11) DEFAULT NULL, `roleclass` int(11) DEFAULT NULL, `gender` int(11) DEFAULT NULL, `ipaddress` int(11) DEFAULT NULL, `visitor_bool` bit(1) DEFAULT NULL, `create_time` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_drop_rule DROP TABLE IF EXISTS `log_drop_rule`; CREATE TABLE IF NOT EXISTS `log_drop_rule` ( `ruleid` int(10) DEFAULT NULL, `itemid` int(10) DEFAULT NULL, `count` int(10) DEFAULT NULL, `roleflag` int(10) DEFAULT NULL, `create_time` int(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_ever_quest_accepted DROP TABLE IF EXISTS `log_ever_quest_accepted`; CREATE TABLE IF NOT EXISTS `log_ever_quest_accepted` ( `roleid` int(10) DEFAULT NULL, `ever_questid` int(10) DEFAULT NULL, `questid` int(10) DEFAULT NULL, `current_round` int(10) DEFAULT NULL, `current_count` int(10) DEFAULT NULL, `rolelevel` int(10) DEFAULT NULL, `create_time` int(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_buy_mall_item DROP TABLE IF EXISTS `log_role_buy_mall_item`; CREATE TABLE IF NOT EXISTS `log_role_buy_mall_item` ( `roleid` int(10) DEFAULT NULL, `itemid` int(10) DEFAULT NULL, `price` int(10) DEFAULT NULL, `count` int(10) DEFAULT NULL, `pricetype` int(10) DEFAULT NULL, `rolelevel` int(10) DEFAULT NULL, `create_time` int(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_consume_item DROP TABLE IF EXISTS `log_role_consume_item`; CREATE TABLE IF NOT EXISTS `log_role_consume_item` ( `roleid` int(10) DEFAULT NULL, `itemid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `item` int(11) DEFAULT NULL, `count` int(11) DEFAULT NULL, `leftcount` int(11) DEFAULT NULL, `create_date` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_expand_package_log DROP TABLE IF EXISTS `log_role_expand_package_log`; CREATE TABLE IF NOT EXISTS `log_role_expand_package_log` ( `roleid` int(10) DEFAULT NULL, `newpackagesize` int(10) DEFAULT NULL, `expandsize` int(10) DEFAULT NULL, `create_time` int(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_get_item DROP TABLE IF EXISTS `log_role_get_item`; CREATE TABLE IF NOT EXISTS `log_role_get_item` ( `roleid` int(10) DEFAULT NULL, `item` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `count` int(10) DEFAULT NULL, `proto` int(10) DEFAULT NULL, `reason` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `rolelevel` int(11) DEFAULT NULL, `create_time` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_gold_change DROP TABLE IF EXISTS `log_role_gold_change`; CREATE TABLE IF NOT EXISTS `log_role_gold_change` ( `username` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `roleid` int(11) DEFAULT NULL, `changecount` int(11) DEFAULT NULL, `newcount` int(11) DEFAULT NULL, `reason` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `create_time` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_join_instance DROP TABLE IF EXISTS `log_role_join_instance`; CREATE TABLE IF NOT EXISTS `log_role_join_instance` ( `roleid` int(10) DEFAULT NULL, `level` int(10) DEFAULT NULL, `groupmember` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `instanceid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `protoid` int(11) DEFAULT NULL, `times` int(11) DEFAULT NULL, `create_time` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_level_instance DROP TABLE IF EXISTS `log_role_level_instance`; CREATE TABLE IF NOT EXISTS `log_role_level_instance` ( `roleid` int(10) DEFAULT NULL, `level` int(10) DEFAULT NULL, `groupmember` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `instanceid` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `protoid` int(11) DEFAULT NULL, `times` int(11) DEFAULT NULL, `create_time` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=DYNAMIC;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_leve_up DROP TABLE IF EXISTS `log_role_leve_up`; CREATE TABLE IF NOT EXISTS `log_role_leve_up` ( `roleid` int(10) DEFAULT NULL, `level` int(10) DEFAULT NULL, `count` int(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_login DROP TABLE IF EXISTS `log_role_login`; CREATE TABLE IF NOT EXISTS `log_role_login` ( `roleid` int(10) DEFAULT NULL, `ipaddress` int(11) DEFAULT NULL, `rolelevel` int(10) DEFAULT NULL, `create_time` int(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_logout DROP TABLE IF EXISTS `log_role_logout`; CREATE TABLE IF NOT EXISTS `log_role_logout` ( `roleid` int(10) DEFAULT NULL, `ipaddress` int(11) DEFAULT NULL, `timeonline` int(11) DEFAULT NULL, `rolelevel` int(11) DEFAULT NULL, `create_time` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_quest_log DROP TABLE IF EXISTS `log_role_quest_log`; CREATE TABLE IF NOT EXISTS `log_role_quest_log` ( `roleid` int(10) DEFAULT NULL, `action` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `quest` int(10) DEFAULT NULL, `rolelevel` int(10) DEFAULT NULL, `create_time` int(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_release_item DROP TABLE IF EXISTS `log_role_release_item`; CREATE TABLE IF NOT EXISTS `log_role_release_item` ( `roleid` int(10) DEFAULT NULL, `protoid` int(10) DEFAULT NULL, `item` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `dstrole` int(11) DEFAULT NULL, `reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `rolelevel` int(11) DEFAULT NULL, `create_time` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_silver_change DROP TABLE IF EXISTS `log_role_silver_change`; CREATE TABLE IF NOT EXISTS `log_role_silver_change` ( `roleid` int(10) DEFAULT NULL, `MoneyCount` int(10) DEFAULT NULL, `NewSilver` int(10) DEFAULT NULL, `Reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `level` int(11) DEFAULT NULL, `create_time` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_skill_learn DROP TABLE IF EXISTS `log_role_skill_learn`; CREATE TABLE IF NOT EXISTS `log_role_skill_learn` ( `roleid` int(10) DEFAULT NULL, `skill` int(10) DEFAULT NULL, `level` int(10) DEFAULT NULL, `rolelevel` int(10) DEFAULT NULL, `create_time` int(10) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.log_role_ticket_change DROP TABLE IF EXISTS `log_role_ticket_change`; CREATE TABLE IF NOT EXISTS `log_role_ticket_change` ( `roleid` int(10) DEFAULT NULL, `changecount` int(10) DEFAULT NULL, `newcount` int(10) DEFAULT NULL, `reason` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL, `rolelevel` int(11) DEFAULT NULL, `create_time` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected.   -- Dumping structure for table db_web.role_user DROP TABLE IF EXISTS `role_user`; CREATE TABLE IF NOT EXISTS `role_user` ( `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `userid` int(11) DEFAULT NULL, `level` int(11) DEFAULT NULL, `skill` int(11) DEFAULT NULL, `guild` int(11) DEFAULT NULL, `rolename` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `ticket` int(11) DEFAULT NULL, `roleid` int(11) DEFAULT NULL, `roleclass` int(11) DEFAULT NULL, `gender` int(11) DEFAULT NULL, `ipaddress` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL, `visitor_bool` bit(1) DEFAULT NULL, `create_time` int(11) DEFAULT NULL, `gold` int(10) DEFAULT NULL, `silver` int(10) DEFAULT NULL, `lastLoginIp` varchar(150) COLLATE utf8_unicode_ci DEFAULT NULL, `lastLoginTime` int(11) DEFAULT NULL, `lastLogoutTime` int(11) DEFAULT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;  -- Data exporting was unselected. /*!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 */;

link [Only registered and activated users can see links. ]