[Szukam] tabela log

[qualit]

witam szukam Tabeli Log do mysql

 

Mam Pliki By Rain :P

 

Prosze o szybkie odp

[IceShiva]

-- MySQL dump 10.7
--
-- Host: localhost    Database: korea_log
-- ------------------------------------------------------
-- Server version 4.1.3-beta-log
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE="NO_AUTO_VALUE_ON_ZERO" */;
--
-- Table structure for table `bootlog`
--
DROP TABLE IF EXISTS `bootlog`;
CREATE TABLE `bootlog` (
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `hostname` char(128) NOT NULL default 'UNKNOWN',
 `channel` tinyint(1) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=big5;
--
-- Table structure for table `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 DEFAULT CHARSET=big5;
--
-- Table structure for table `fish_log`
--
DROP TABLE IF EXISTS `fish_log`;
CREATE TABLE `fish_log` (
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `player_id` int(10) unsigned NOT NULL default '0',
 `map_index` tinyint(4) NOT NULL default '0',
 `fish_id` int(10) unsigned NOT NULL default '0',
 `fishing_level` int(11) NOT NULL default '0',
 `waiting_time` int(11) NOT NULL default '0',
 `success` tinyint(4) NOT NULL default '0',
 `size` smallint(6) NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=big5;
--
-- Table structure for table `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=big5;
--
-- Table structure for table `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=big5;
--
-- Table structure for table `hack_log`
--
DROP TABLE IF EXISTS `hack_log`;
CREATE TABLE `hack_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 ''
) ENGINE=MyISAM DEFAULT CHARSET=big5;
--
-- Table structure for table `levellog`
--
DROP TABLE IF EXISTS `levellog`;
CREATE TABLE `levellog` (
 `name` char(24) NOT NULL default '',
 `level` tinyint(4) NOT NULL default '0',
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `playtime` int(11) NOT NULL default '0',
 PRIMARY KEY  (`name`,`level`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;
--
-- Table structure for table `log`
--
DROP TABLE IF EXISTS `log`;
CREATE TABLE `log` (
 `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=big5;
--
-- Table structure for table `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=big5;
--
-- Table structure for table `money_log`
--
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
 `time` datetime default NULL,
 `type` enum('MONSTER','SHOP','REFINE','QUEST','GUILD','MISC','KILL','DROP') default NULL,
 `vnum` int(11) NOT NULL default '0',
 `gold` int(11) NOT NULL default '0',
 KEY `type` (`type`,`vnum`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;
--
-- Table structure for table `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=big5;
--
-- Table structure for table `quest_reward_log`
--
DROP TABLE IF EXISTS `quest_reward_log`;
CREATE TABLE `quest_reward_log` (
 `quest_name` varchar(32) default NULL,
 `player_id` int(10) unsigned default NULL,
 `player_level` tinyint(4) default NULL,
 `reward_type` enum('EXP','ITEM') default NULL,
 `reward_value1` int(10) unsigned default NULL,
 `reward_value2` int(11) default NULL,
 `time` datetime default NULL,
 KEY `player_id` (`player_id`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;
--
-- Table structure for table `refinelog`
--
DROP TABLE IF EXISTS `refinelog`;
CREATE TABLE `refinelog` (
 `pid` int(10) unsigned default NULL,
 `item_name` varchar(24) NOT NULL default '',
 `item_id` int(11) NOT NULL default '0',
 `step` varchar(50) NOT NULL default '',
 `time` datetime NOT NULL default '0000-00-00 00:00:00',
 `is_success` tinyint(1) NOT NULL default '0',
 `setType` set('SOCKET','POWER','ROD','GUILD','SCROLL','HYUNIRON','GOD_SCROLL') default NULL
) ENGINE=MyISAM DEFAULT CHARSET=big5;
--
-- Table structure for table `shout_log`
--
DROP TABLE IF EXISTS `shout_log`;
CREATE TABLE `shout_log` (
 `time` datetime default '0000-00-00 00:00:00',
 `channel` tinyint(4) default NULL,
 `empire` tinyint(4) default NULL,
 `shout` varchar(64) default NULL,
 KEY `time_idx` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=big5;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

[qualit]

dzieki

Alez mam nowy problem przy odpalaniu serva wyskakuje mi blad

 

./autorun.sh ./autorun not found

[IceShiva]

Być może uruchamia się inną komendą np start lub run zobacz pliki w katalogu / i w katalogu z serwerem gry

// nie baw się tymi starymi plikami polecam Tobie pliki z 2010 roku