Jump to content

Tablas LOG files 2010

Rafa23Alzira

By Rafa23Alzira
in Bug fixes

 Share

Recommended Posts

Rafa23Alzira Newbie

Rafa23Alzira

Posted
Posted

Hola chicos, como hay un hilo abierto que pide estas tablas y se de más gente que las ha estado buscando como hice yo en mi día y tarde mucho en encontrarlas totalmente fixeadas pongo este mini-aporte para el que lo necesite.

-- ------------------------------ Table structure for `bootlog`-- ----------------------------DROP TABLE IF EXISTS `bootlog`;CREATE TABLE `bootlog` (  `time` int(11) DEFAULT NULL,  `hostname` int(11) DEFAULT NULL,  `channel` int(11) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ Table structure for `command_log`-- ----------------------------DROP TABLE IF EXISTS `command_log`;CREATE TABLE `command_log` (  `userid` int(11) DEFAULT NULL,  `server` int(11) DEFAULT NULL,  `ip` text,  `port` int(11) DEFAULT NULL,  `username` varchar(12) CHARACTER SET big5 NOT NULL DEFAULT 'NONAME',  `command` varchar(200) CHARACTER SET big5 COLLATE big5_bin DEFAULT NULL,  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00') ENGINE=MyISAM DEFAULT CHARSET=latin1;-- ------------------------------ Table structure for `cube`-- ----------------------------DROP TABLE IF EXISTS `cube`;CREATE TABLE `cube` (  `pid` int(11) NOT NULL DEFAULT '0',  `time` time DEFAULT NULL,  `x` int(11) DEFAULT NULL,  `y` int(11) DEFAULT NULL,  `item_vnum` int(11) DEFAULT NULL,  `item_uid` int(11) DEFAULT NULL,  `item_count` int(11) DEFAULT NULL,  `success` int(11) DEFAULT NULL,  PRIMARY KEY (`pid`)) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ Table structure for `fish_log`-- ----------------------------DROP TABLE IF EXISTS `fish_log`;CREATE TABLE `fish_log` (  `1` int(11) DEFAULT NULL,  `2` int(11) DEFAULT NULL,  `3` int(11) DEFAULT NULL,  `4` int(11) DEFAULT NULL,  `5` int(11) DEFAULT NULL,  `6` int(11) DEFAULT NULL,  `7` int(11) DEFAULT NULL,  `8` int(11) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ Table structure for `gmhost`-- ----------------------------DROP TABLE IF EXISTS `gmhost`;CREATE TABLE `gmhost` (  `mIP` varchar(16) NOT NULL DEFAULT '',  PRIMARY KEY (`mIP`)) ENGINE=MyISAM DEFAULT CHARSET=big5;-- ------------------------------ Table structure for `gmlist`-- ----------------------------DROP TABLE IF EXISTS `gmlist`;CREATE TABLE `gmlist` (  `mID` int(10) unsigned NOT NULL AUTO_INCREMENT,  `mAccount` varchar(16) NOT NULL DEFAULT '',  `mName` varchar(16) NOT NULL DEFAULT '',  `mContactIP` varchar(16) NOT NULL DEFAULT '',  `mServerIP` varchar(16) NOT NULL DEFAULT 'ALL',  `mAuthority` enum('IMPLEMENTOR','HIGH_WIZARD','GOD','LOW_WIZARD','PLAYER') DEFAULT 'PLAYER',  PRIMARY KEY (`mID`)) ENGINE=MyISAM DEFAULT CHARSET=big5;-- ------------------------------ Table structure for `goldlog`-- ----------------------------DROP TABLE IF EXISTS `goldlog`;CREATE TABLE `goldlog` (  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',  `time` time DEFAULT NULL,  `pid` int(11) DEFAULT NULL,  `what` int(11) DEFAULT NULL,  `how` int(11) DEFAULT NULL,  `hint` int(11) DEFAULT NULL,  PRIMARY KEY (`date`)) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ Table structure for `hack_log`-- ----------------------------DROP TABLE IF EXISTS `hack_log`;CREATE TABLE `hack_log` (  `time` time DEFAULT NULL,  `login` longtext COLLATE big5_bin,  `name` varchar(11) COLLATE big5_bin DEFAULT NULL,  `ip` text CHARACTER SET latin1,  `server` varchar(11) COLLATE big5_bin DEFAULT NULL,  `why` varchar(22) COLLATE big5_bin DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ Table structure for `levellog`-- ----------------------------DROP TABLE IF EXISTS `levellog`;CREATE TABLE `levellog` (  `name` varchar(50) COLLATE big5_bin DEFAULT NULL,  `level` int(11) DEFAULT NULL,  `time` datetime DEFAULT NULL,  `account_id` int(50) DEFAULT NULL,  `pid` int(30) DEFAULT NULL,  `playtime` int(11) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ Table structure for `locale`-- ----------------------------DROP TABLE IF EXISTS `locale`;CREATE TABLE `locale` (  `mKey` varchar(255) NOT NULL DEFAULT '',  `mValue` varchar(255) NOT NULL DEFAULT '',  PRIMARY KEY (`mKey`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;-- ------------------------------ Table structure for `locale_bug`-- ----------------------------DROP TABLE IF EXISTS `locale_bug`;CREATE TABLE `locale_bug` (  `mKey` varchar(255) NOT NULL DEFAULT '',  `mValue` varchar(255) NOT NULL DEFAULT '',  PRIMARY KEY (`mKey`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;-- ------------------------------ Table structure for `log`-- ----------------------------DROP TABLE IF EXISTS `log`;CREATE TABLE `log` (  `type` varchar(20) COLLATE big5_bin DEFAULT NULL,  `time` datetime DEFAULT NULL,  `who` int(11) DEFAULT NULL,  `x` int(11) DEFAULT NULL,  `y` int(11) DEFAULT NULL,  `what` int(11) DEFAULT NULL,  `how` varchar(20) COLLATE big5_bin DEFAULT NULL,  `hint` varchar(20) COLLATE big5_bin DEFAULT NULL,  `ip` text CHARACTER SET latin1,  `vnum` int(11) DEFAULT '0') ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ Table structure for `loginlog2`-- ----------------------------DROP TABLE IF EXISTS `loginlog2`;CREATE TABLE `loginlog2` (  `id` int(11) NOT NULL AUTO_INCREMENT,  `type` text,  `is_gm` int(11) DEFAULT NULL,  `login_time` datetime DEFAULT NULL,  `channel` int(11) DEFAULT NULL,  `account_id` int(11) DEFAULT NULL,  `pid` int(11) DEFAULT NULL,  `client_version` text,  `ip` text,  `logout_time` datetime DEFAULT NULL,  `playtime` int(11) NOT NULL DEFAULT '0',  PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;-- ------------------------------ Table structure for `money_log`-- ----------------------------DROP TABLE IF EXISTS `money_log`;CREATE TABLE `money_log` (  `year` int(11) DEFAULT NULL,  `time` time DEFAULT NULL,  `vnum` int(11) DEFAULT '0',  `pid` int(11) DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;-- ------------------------------ Table structure for `quest_reward_log`-- ----------------------------DROP TABLE IF EXISTS `quest_reward_log`;CREATE TABLE `quest_reward_log` (  `1` varchar(50) COLLATE big5_bin DEFAULT NULL,  `2` int(11) DEFAULT NULL,  `3` int(11) DEFAULT NULL,  `4` int(11) DEFAULT NULL,  `5` int(11) DEFAULT NULL,  `6` int(11) DEFAULT NULL,  `7` time DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ Table structure for `refinelog`-- ----------------------------DROP TABLE IF EXISTS `refinelog`;CREATE TABLE `refinelog` (  `Id` int(11) DEFAULT NULL,  `pid` int(11) DEFAULT NULL,  `item_name` varchar(50) COLLATE big5_bin DEFAULT NULL,  `item_id` int(11) DEFAULT NULL,  `step` int(11) DEFAULT NULL,  `time` time DEFAULT NULL,  `is_success` int(11) DEFAULT NULL,  `setType` varchar(50) COLLATE big5_bin DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ Table structure for `shout_log`-- ----------------------------DROP TABLE IF EXISTS `shout_log`;CREATE TABLE `shout_log` (  `1` time DEFAULT NULL,  `2` int(11) DEFAULT NULL,  `3` int(11) DEFAULT NULL,  `4` varchar(50) COLLATE big5_bin DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;-- ------------------------------ Table structure for `speed_hack`-- ----------------------------DROP TABLE IF EXISTS `speed_hack`;CREATE TABLE `speed_hack` (  `pid` int(11) DEFAULT NULL,  `time` time DEFAULT NULL,  `x` int(11) DEFAULT NULL,  `y` int(11) DEFAULT NULL,  `hack_count` varchar(20) COLLATE big5_bin DEFAULT NULL) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

Un saludo.

  • Dilong locked this topic
Guest
This topic is now closed to further replies.
 Share
Go to topic listing

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...

Important Information

This site uses cookies to enhance your browsing experience and provide relevant content. By continuing to browse, you agree to our We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. and Terms of Use. For more information on how we protect your data, please check our Privacy Policy.