Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Metin2 > Metin2 Private Server
1146 Table 'log.command.log' doesn't exit 1146 Table 'log.command.log' doesn't exit
You last visited: Today at 18:35

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

1146 Table 'log.command.log' doesn't exit

Discussion on 1146 Table 'log.command.log' doesn't exit within the Metin2 Private Server forum part of the Metin2 category.

Reply
 
Old   #1
 
elite*gold: 506
The Black Market: 1/0/0
Join Date: Nov 2009
Posts: 307
Received Thanks: 104
1146 Table 'log.command.log' doesn't exit

Liebe Epvp'ler,
Ich habe ein Problem, und zwar wenn ich in der Datenbank versuche die Command.log öffne dann öffnet sich ein fenster in dem steht
"1146 Table 'log.command.log' doesn't exit".

Weis jemand wie ich das beheben kann?


King Regards,
n0ize is offline  
Old 10/14/2012, 21:01   #2
 
elite*gold: 32
The Black Market: 120/0/1
Join Date: Mar 2012
Posts: 6,717
Received Thanks: 2,737
eine Comandlog einfügen?
Syuki is offline  
Old 10/14/2012, 21:04   #3
 
elite*gold: 506
The Black Market: 1/0/0
Join Date: Nov 2009
Posts: 307
Received Thanks: 104
Quote:
Originally Posted by Marcely View Post
eine Comandlog einfügen?

du kannst mir nicht zufällig sagen / schreiben wie das geht?
n0ize is offline  
Old 10/15/2012, 01:01   #4
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Jun 2012
Posts: 53
Received Thanks: 8
1. make a file and name it
command_log.sql.

2. open it and put this in it
PHP Code:
-- ----------------------------
-- 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(20) CHARACTER SET big5 COLLATE big5_bin DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of command_log
-- ---------------------------- 
3. open navicat, right click on log and execute the command_log.sql file.

done.
dreamsmaker is offline  
Thanks
1 User
Old 11/21/2012, 20:10   #5
 
elite*gold: 0
The Black Market: 0/0/0
Join Date: Nov 2012
Posts: 243
Received Thanks: 371
Hier haste nochmal die komplette log :

Code:
SET FOREIGN_KEY_CHECKS=0;

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

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

-- ----------------------------
-- Table structure for `change_name`
-- ----------------------------
DROP TABLE IF EXISTS `change_name`;
CREATE TABLE `change_name` (
  `pid` int(20) NOT NULL DEFAULT '0',
  `old_name` varchar(30) DEFAULT NULL,
  `new_name` varchar(30) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `ip` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`pid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of change_name
-- ----------------------------

-- ----------------------------
-- 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(18) CHARACTER SET big5 NOT NULL DEFAULT 'NONAME',
  `command` varchar(128) CHARACTER SET big5 COLLATE big5_bin DEFAULT NULL,
  `date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- ----------------------------
-- Table structure for `cube`
-- ----------------------------
DROP TABLE IF EXISTS `cube`;
CREATE TABLE `cube` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `pid` int(20) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `x` int(40) DEFAULT NULL,
  `y` int(40) DEFAULT NULL,
  `item_vnum` int(40) DEFAULT NULL,
  `item_uid` varchar(40) DEFAULT NULL,
  `item_count` int(20) DEFAULT NULL,
  `succes` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM 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` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `date` date DEFAULT NULL,
  `time` time DEFAULT NULL,
  `pid` int(20) DEFAULT NULL,
  `what` int(20) DEFAULT NULL,
  `how` varchar(20) DEFAULT NULL,
  `hint` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=310 DEFAULT CHARSET=latin1;

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

-- ----------------------------
-- Table structure for `hack_crc_log`
-- ----------------------------
DROP TABLE IF EXISTS `hack_crc_log`;
CREATE TABLE `hack_crc_log` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `time` datetime DEFAULT NULL,
  `login` varchar(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `ip` varchar(30) DEFAULT NULL,
  `server` int(20) DEFAULT NULL,
  `why` varchar(20) DEFAULT NULL,
  `crc` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) 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` time DEFAULT NULL,
  `login` longtext COLLATE big5_bin,
  `name` varchar(25) COLLATE big5_bin DEFAULT NULL,
  `ip` text CHARACTER SET latin1,
  `server` varchar(25) COLLATE big5_bin DEFAULT NULL,
  `why` varchar(25) 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(20) NOT NULL AUTO_INCREMENT,
  `time` datetime DEFAULT NULL,
  `account_id` int(20) DEFAULT NULL,
  `login` varchar(20) DEFAULT NULL,
  `pid` int(20) DEFAULT NULL,
  `name` varchar(20) DEFAULT NULL,
  `reason` varchar(20) DEFAULT NULL,
  `ip` varchar(30) DEFAULT 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` datetime DEFAULT NULL,
  `account_id` int(11) NOT NULL,
  `pid` int(11) 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` datetime DEFAULT NULL,
  `who` int(20) DEFAULT NULL,
  `x` int(11) DEFAULT NULL,
  `y` int(11) DEFAULT NULL,
  `what` int(20) DEFAULT NULL,
  `how` varchar(1024) COLLATE big5_bin DEFAULT NULL,
  `hint` varchar(1024) COLLATE big5_bin DEFAULT NULL,
  `ip` varchar(30) COLLATE big5_bin DEFAULT NULL,
  `vnum` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

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

-- ----------------------------
-- Table structure for `loginlog`
-- ----------------------------
DROP TABLE IF EXISTS `loginlog`;
CREATE TABLE `loginlog` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `type` text,
  `time` datetime DEFAULT NULL,
  `channel` int(20) DEFAULT NULL,
  `account_id` int(20) DEFAULT NULL,
  `pid` int(20) DEFAULT NULL,
  `level` int(20) DEFAULT NULL,
  `job` int(20) DEFAULT NULL,
  `playtime` int(20) DEFAULT NULL,
  PRIMARY KEY (`id`)
) 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=60579 DEFAULT CHARSET=latin1;

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

-- ----------------------------
-- Table structure for `money_log`
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
  `time` datetime DEFAULT NULL,
  `DELAYED` int(11) 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(20) NOT NULL AUTO_INCREMENT,
  `time` datetime DEFAULT NULL,
  `pcbang_id` int(20) DEFAULT NULL,
  `ip` varchar(30) DEFAULT NULL,
  `pid` int(20) DEFAULT NULL,
  `play_time` int(20) DEFAULT NULL,
  PRIMARY KEY (`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` time 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` 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;

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

-- ----------------------------
-- 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(2555) 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
-- ----------------------------
.SeveN is offline  
Thanks
3 Users
Reply

« Quest reload Problem | (^;^)/Übersicht über den P-Server Urwald(^;^)/ »

Similar Threads Similar Threads
/warp.... Befehl nicht funktioniert /command doesn't work
04/19/2012 - Metin2 Private Server - 0 Replies
Hi guys & grls, i have problem with command /warp ,..... Any "warps" teleports to the same place, just where I stand. syser server : first test: SYSERR: Apr 16 19:20:18 :: WarpSet: cannot find map location index 0 x 91110000 y 91110000 name admine scnd test: SYSERR: Apr 16 19:25:15 :: Process: SEQUENCE 461eb500 mismatch 0xaf != 0x0 header 254 SYSERR: Apr 16 19:25:15 :: Process: SEQUENCE_LOG -------------
/warp.... Befehl nicht funktioniert /command doesn't work
04/16/2012 - Metin2 Private Server - 0 Replies
Hi guys & grls, i have problem with command /warp ,..... Any "warps" teleports to the same place, just where I stand. syser server : first test: SYSERR: Apr 16 19:20:18 :: WarpSet: cannot find map location index 0 x 91110000 y 91110000 name admine scnd test: SYSERR: Apr 16 19:25:15 :: Process: SEQUENCE 461eb500 mismatch 0xaf != 0x0 header 254 SYSERR: Apr 16 19:25:15 :: Process: SEQUENCE_LOG -------------
/run command Doesn't work
12/02/2011 - Rappelz Private Server - 8 Replies
solved
ArcadiaRepack - Command doesn't Work
09/18/2011 - Rappelz - 3 Replies
Salut tous, Quand j'écris par exemple " #insert_item( 540037, 50, 50, 50, 1, "Character Name") " je trouve rien dans l'inventaire mais les autre command buff , warp learn skill sa marche _________________________________________________ __ Hi All, When I write for example "# insert_item (540,037, 50, 50, 50, 1," Character Name ")" I find nothing in the inventory but the other command buff, learn skill warp its progress
Exit Runes Command gesucht
06/12/2010 - General Gaming Discussion - 2 Replies
Hallo Gemeinde, ich suche einen Macrobefehl zum schliessen von ROM , nicht zum Logout den habe ich schon gefunden. Ich freue mich auf eure Unterstützung. DER DOC



All times are GMT +2. The time now is 18:35.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.