*Problemă: Imi pica server-ul
Tipologie server(PvM / PvP): PvM
*Resursă folosită: *Link exclusiv J4M*
*ServerFiles utilizat:-/-
*Syserr: SYSERR:
Aug 1 01:50:15 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 4629, 953279, 260804, 10052956, 'COMBINE (REFINE SUCCESS)', 'Esarfa Rege (normala) 1 ', errno: 1064)
SYSERR: Aug 1 01:50:18 :: ChildLoop: AsyncSQL: query failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 4629, 953279, 260804, 10014108, 'COMBINE (REFINE SUCCESS)', 'Esarfa Roiala (normala) 1 ' errno: 1064)
SYSERR: Aug 1 02:29:55 :: pid_init:
Start of pid: 1552
Poză:
*Detalii suplimentare: Imi pica sever-ul si primesc aceasta eroare in putty , pica cam la 30m - o ora
- terminate called after throwing an instance of 'std::logic_error' what(): basic_string::_S_construct null not valid
Imi pica sv , AJUTORRRRRR
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]Fac un fisier cu ce ai scris tu aici si il adaug in log din game99 , ch ( 1 ,2,3,4 ) sau cum >??[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]
Din câte înțeleg eu ai problema la partea de log-uri. Nu ai tabelele sau sunt incomplete și nu are unde sa scrie datele. Te pot ajuta eu mâine dacă e și ma uit mai bine și știu.
Cum am spus, nu știu 100% nu vreau sa fiu luat la p#le aiurea
[ Postat de pe iPhone ]
Cum am spus, nu știu 100% nu vreau sa fiu luat la p#le aiurea
[ Postat de pe iPhone ]
- Pentru acest mesaj, Murrdok97b for the post:
- haristhc
Ok..Murrdok97b scrie:Din câte înțeleg eu ai problema la partea de log-uri. Nu ai tabelele sau sunt incomplete și nu are unde sa scrie datele. Te pot ajuta eu mâine dacă e și ma uit mai bine și știu.
Cum am spus, nu știu 100% nu vreau sa fiu luat la p#le aiurea
[ Postat de pe iPhone ]
de 
de 
de -
- Informaţie
-
Cine este conectat
Utilizatori ce ce navighează pe acest forum: sanducatalin1 și 32 vizitatori