haristhc scrie:

[ST]SSH scrie:Insereaza asta in log :

[spoiler]/*
Navicat MySQL Data Transfer

Source Server         : test sv
Source Server Version : 50552
Source Host           : 188.212.100.75:3306
Source Database       : log

Target Server Type    : MYSQL
Target Server Version : 50552
File Encoding         : 65001

Date: 2018-07-31 21:47:10
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for acce
-- ----------------------------
DROP TABLE IF EXISTS `acce`;
CREATE TABLE `acce` (
  `pid` int(11) NOT NULL,
  `time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `x` int(1) NOT NULL,
  `y` int(1) NOT NULL,
  `item_vnum` int(11) NOT NULL,
  `item_uid` int(11) NOT NULL,
  `item_count` smallint(3) NOT NULL,
  `item_abs_chance` smallint(3) NOT NULL,
  `success` varbinary(3) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs ROW_FORMAT=FIXED;

-- ----------------------------
-- Table structure for bonus_hack
-- ----------------------------
DROP TABLE IF EXISTS `bonus_hack`;
CREATE TABLE `bonus_hack` (
  `login` longtext COLLATE big5_bin,
  `nickname` varchar(11) COLLATE big5_bin DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

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

-- ----------------------------
-- 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 DEFAULT 'NONAME',
  `command` varchar(105) CHARACTER SET big5 COLLATE big5_bin DEFAULT NULL,
  `date` datetime 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` varchar(20) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `x` varchar(40) DEFAULT NULL,
  `y` varchar(40) DEFAULT NULL,
  `item_vnum` varchar(40) DEFAULT NULL,
  `item_uid` varchar(40) DEFAULT NULL,
  `item_count` varchar(20) DEFAULT NULL,
  `success` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- ----------------------------
-- Table structure for exo_bank_log
-- ----------------------------
DROP TABLE IF EXISTS `exo_bank_log`;
CREATE TABLE `exo_bank_log` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(30) NOT NULL,
  `money` int(20) NOT NULL,
  `art` varchar(10) NOT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- 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` (
  `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=21523 DEFAULT CHARSET=latin1;

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

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

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

-- ----------------------------
-- 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,
  `account_id` varchar(30) COLLATE big5_bin DEFAULT NULL,
  `pid` varchar(30) COLLATE big5_bin 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` (
  `ID` int(11) DEFAULT NULL,
  `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` varchar(30) COLLATE big5_bin DEFAULT NULL,
  `vnum` int(50) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5 COLLATE=big5_bin;

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

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

-- ----------------------------
-- Table structure for money_log
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
  `time` datetime DEFAULT NULL,
  `1` varchar(20) DEFAULT NULL,
  `2` varchar(20) DEFAULT '0',
  `3` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

-- ----------------------------
-- 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(400) 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;

-- ----------------------------
-- Table structure for voucher_log
-- ----------------------------
DROP TABLE IF EXISTS `voucher_log`;
CREATE TABLE `voucher_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(10) unsigned NOT NULL,
  `monede` int(10) unsigned NOT NULL,
  `data` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for whisper_log
-- ----------------------------
DROP TABLE IF EXISTS `whisper_log`;
CREATE TABLE `whisper_log` (
  `id` int(20) NOT NULL AUTO_INCREMENT,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `from_msg` varchar(24) NOT NULL DEFAULT 'error',
  `to_msg` varchar(24) NOT NULL DEFAULT 'error',
  `msg_text` varchar(250) NOT NULL DEFAULT 'empty_msg_error',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=349498 DEFAULT CHARSET=utf8;[/spoiler]

AM inserat in log si tot imi pica sv din ora in ora