Buscar en la comunidad
Mostrando resultados para las etiquetas 'log'.
Encontrado 2 resultados
-
Hola saludos tengo un pequeño problema soy nuevo con la creación de servers y ando practicando. Monte un server siguiendo un tutorial pero decidí utilizar un cliente que me gusto como base, le cambie ip todo fino los channels salen Encendidos, cree la cuenta con el Navicat, pero a la hora de ingresar justo a la selección de pj después que dice "Registro en curso" me sale el error LOG con esas descripciones. Como podria corregirlos?
-
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.