Log Db

[radsj1993]

Ich suche eine funktionierende 2011 Log Db.
Meine spuckt immer nur Fehlermeldungen in der syserr aus und manche Tabellen gehen gar nicht oder sind beschädigt.

MfG

[ebert.tonna]

das in log (mysql) als query ausführen

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `bootlog`
-- ----------------------------
DROP TABLE IF EXISTS `bootlog`;
CREATE TABLE `bootlog` (
`time` datetime DEFAULT NULL,
`hostname` int(11) DEFAULT NULL,
`channel` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Records of bootlog
-- ----------------------------

-- ----------------------------
-- 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) NOT NULL DEFAULT 'NONAME',
`command` varchar(50) DEFAULT NULL,
`date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=big5;

-- ----------------------------
-- Records of command_log
-- ----------------------------

-- ----------------------------
-- Table structure for `cube`
-- ----------------------------
DROP TABLE IF EXISTS `cube`;
CREATE TABLE `cube` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`pid` int(11) unsigned NOT NULL DEFAULT '0',
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`x` int(11) unsigned NOT NULL DEFAULT '0',
`y` int(11) unsigned NOT NULL DEFAULT '0',
`item_vnum` int(11) unsigned NOT NULL DEFAULT '0',
`item_uid` int(11) unsigned NOT NULL DEFAULT '0',
`item_count` int(5) unsigned NOT NULL DEFAULT '0',
`success` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `pid` (`pid`),
KEY `item_vnum` (`item_vnum`),
KEY `item_uid` (`item_uid`)
) ENGINE=MyISAM AUTO_INCREMENT=336 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of cube
-- ----------------------------

-- ----------------------------
-- Table structure for `dragon_slay_log`
-- ----------------------------
DROP TABLE IF EXISTS `dragon_slay_log`;
CREATE TABLE `dragon_slay_log` (
`1` varchar(255) NOT NULL,
`2` varchar(255) NOT NULL,
`3` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`4` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of dragon_slay_log
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of fish_log
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of gmhost
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of gmlist
-- ----------------------------

-- ----------------------------
-- Table structure for `goldlog`
-- ----------------------------
DROP TABLE IF EXISTS `goldlog`;
CREATE TABLE `goldlog` (
`date` varchar(10) NOT NULL DEFAULT '0000-00-00',
`time` varchar(8) NOT NULL DEFAULT '00:00:00',
`pid` int(10) unsigned NOT NULL DEFAULT '0',
`what` int(11) NOT NULL DEFAULT '0',
`how` set('BUY','SELL','SHOP_SELL','SHOP_BUY','EXCHANGE_ TAKE','EXCHANGE_GIVE','QUEST') DEFAULT NULL,
`hint` varchar(50) DEFAULT NULL,
KEY `date_idx` (`date`),
KEY `pid_idx` (`pid`),
KEY `what_idx` (`what`),
KEY `how_idx` (`how`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of goldlog
-- ----------------------------

-- ----------------------------
-- Table structure for `hack_crc_log`
-- ----------------------------
DROP TABLE IF EXISTS `hack_crc_log`;
CREATE TABLE `hack_crc_log` (
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`login` char(16) NOT NULL DEFAULT '',
`name` char(24) NOT NULL DEFAULT '',
`ip` char(15) NOT NULL DEFAULT '',
`server` char(100) NOT NULL DEFAULT '',
`why` char(255) NOT NULL DEFAULT '',
`crc` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of hack_crc_log
-- ----------------------------

-- ----------------------------
-- Table structure for `hack_log`
-- ----------------------------
DROP TABLE IF EXISTS `hack_log`;
CREATE TABLE `hack_log` (
`time` datetime 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;

-- ----------------------------
-- Records of hack_log
-- ----------------------------

-- ----------------------------
-- Table structure for `hackshield_log`
-- ----------------------------
DROP TABLE IF EXISTS `hackshield_log`;
CREATE TABLE `hackshield_log` (
`id` int(255) NOT NULL AUTO_INCREMENT,
`time` datetime NOT NULL,
`account_id` int(255) NOT NULL,
`login` varchar(30) NOT NULL,
`pid` int(255) NOT NULL,
`name` varchar(30) NOT NULL,
`reason` varchar(255) NOT NULL,
`ip` varchar(15) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of hackshield_log
-- ----------------------------

-- ----------------------------
-- Table structure for `ingame_ban_log`
-- ----------------------------
DROP TABLE IF EXISTS `ingame_ban_log`;
CREATE TABLE `ingame_ban_log` (
`ban_time` datetime DEFAULT NULL,
`who` varchar(255) COLLATE big5_bin DEFAULT NULL,
`GM` varchar(255) COLLATE big5_bin DEFAULT NULL,
`cause` varchar(255) COLLATE big5_bin DEFAULT NULL,
`until` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Records of ingame_ban_log
-- ----------------------------

-- ----------------------------
-- 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` time DEFAULT NULL,
`playtime` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Records of levellog
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of locale
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of locale_bug
-- ----------------------------

-- ----------------------------
-- Table structure for `log`
-- ----------------------------
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
`type` varchar(20) COLLATE big5_bin DEFAULT NULL,
`time` time 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',
`id` int(20) NOT NULL AUTO_INCREMENT,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=590 DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Records of log
-- ----------------------------

-- ----------------------------
-- Table structure for `log_090101`
-- ----------------------------
DROP TABLE IF EXISTS `log_090101`;
CREATE TABLE `log_090101` (
`type` enum('ITEM','CHARACTER') NOT NULL DEFAULT 'ITEM',
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`who` int(10) unsigned NOT NULL DEFAULT '0',
`x` int(10) unsigned NOT NULL DEFAULT '0',
`y` int(10) unsigned NOT NULL DEFAULT '0',
`what` int(11) NOT NULL DEFAULT '0',
`how` varchar(50) NOT NULL DEFAULT '',
`hint` varchar(50) DEFAULT NULL,
KEY `who_idx` (`who`),
KEY `what_idx` (`what`),
KEY `how_idx` (`how`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of log_090101
-- ----------------------------

-- ----------------------------
-- Table structure for `log_090102`
-- ----------------------------
DROP TABLE IF EXISTS `log_090102`;
CREATE TABLE `log_090102` (
`type` enum('ITEM','CHARACTER') NOT NULL DEFAULT 'ITEM',
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`who` int(10) unsigned NOT NULL DEFAULT '0',
`x` int(10) unsigned NOT NULL DEFAULT '0',
`y` int(10) unsigned NOT NULL DEFAULT '0',
`what` int(11) NOT NULL DEFAULT '0',
`how` varchar(50) NOT NULL DEFAULT '',
`hint` varchar(50) DEFAULT NULL,
KEY `who_idx` (`who`),
KEY `what_idx` (`what`),
KEY `how_idx` (`how`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of log_090102
-- ----------------------------

-- ----------------------------
-- Table structure for `log_090103`
-- ----------------------------
DROP TABLE IF EXISTS `log_090103`;
CREATE TABLE `log_090103` (
`type` enum('ITEM','CHARACTER') NOT NULL DEFAULT 'ITEM',
`time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`who` int(10) unsigned NOT NULL DEFAULT '0',
`x` int(10) unsigned NOT NULL DEFAULT '0',
`y` int(10) unsigned NOT NULL DEFAULT '0',
`what` int(11) NOT NULL DEFAULT '0',
`how` varchar(50) NOT NULL DEFAULT '',
`hint` varchar(50) DEFAULT NULL,
KEY `who_idx` (`who`),
KEY `what_idx` (`what`),
KEY `how_idx` (`how`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of log_090103
-- ----------------------------

-- ----------------------------
-- Table structure for `loginlog`
-- ----------------------------
DROP TABLE IF EXISTS `loginlog`;
CREATE TABLE `loginlog` (
`type` enum('LOGIN','LOGOUT') DEFAULT NULL,
`time` datetime DEFAULT NULL,
`channel` tinyint(4) DEFAULT NULL,
`account_id` int(10) unsigned DEFAULT NULL,
`pid` int(10) unsigned DEFAULT NULL,
`level` smallint(6) DEFAULT NULL,
`job` tinyint(4) DEFAULT NULL,
`playtime` int(10) unsigned DEFAULT NULL,
KEY `pid` (`pid`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of loginlog
-- ----------------------------

-- ----------------------------
-- 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 AUTO_INCREMENT=291180 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of loginlog2
-- ----------------------------

-- ----------------------------
-- Table structure for `money_log`
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
`VALUES` int(11) DEFAULT NULL,
`DELAYED` int(11) DEFAULT NULL,
`time` time DEFAULT NULL,
`vnum` int(11) DEFAULT '0',
`pid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of money_log
-- ----------------------------

-- ----------------------------
-- Table structure for `pcbang_loginlog`
-- ----------------------------
DROP TABLE IF EXISTS `pcbang_loginlog`;
CREATE TABLE `pcbang_loginlog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`time` datetime DEFAULT NULL,
`pcbang_id` int(11) NOT NULL DEFAULT '0',
`ip` varchar(15) NOT NULL DEFAULT '000.000.000.000',
`pid` int(10) unsigned DEFAULT NULL,
`play_time` int(10) unsigned DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `pid` (`pid`),
KEY `pcbang_id` (`pcbang_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pcbang_loginlog
-- ----------------------------

-- ----------------------------
-- 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` datetime DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Records of quest_reward_log
-- ----------------------------

-- ----------------------------
-- 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` datetime DEFAULT NULL,
`is_success` int(11) DEFAULT NULL,
`setType` varchar(50) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

-- ----------------------------
-- Records of refinelog
-- ----------------------------

-- ----------------------------
-- Table structure for `shout_log`
-- ----------------------------
DROP TABLE IF EXISTS `shout_log`;
CREATE TABLE `shout_log` (
`1` datetime 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;

-- ----------------------------
-- Records of shout_log
-- ----------------------------

-- ----------------------------
-- 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;

-- ----------------------------
-- Records of speed_hack
-- ----------------------------