|
You last visited: Today at 09:58
Advertisement
[Release] 2010 Logs databases
Discussion on [Release] 2010 Logs databases within the Metin2 PServer Guides & Strategies forum part of the Metin2 Private Server category.
02/06/2011, 09:17
|
#16
|
elite*gold: 2 
Join Date: Jan 2009
Posts: 839
Received Thanks: 316
|
Quote:
Originally Posted by YouFailed
Wollte eig fast eingeholt schreiben aber gf ist eh fail  |
***.
Die haben VIEL zu spät mit dem HS reagiert und so.
Kann man nichts machen.
Aufs HS "kann" man eig beim P Server scheissen.
Und Lizens sowieso 
|
|
|
|
02/06/2011, 10:01
|
#17
|
elite*gold: 10
Join Date: Jul 2009
Posts: 1,786
Received Thanks: 1,090
|
Thanks for sharing.
Aber hat Daroo nicht schon die .US DB in seinen 2010er Files drin?
|
|
|
|
|
02/06/2011, 13:16
|
#18
|
elite*gold: 0
Join Date: Jan 2011
Posts: 1,484
Received Thanks: 3,151
|
Lol, ich hab doch schon die Metin2.US DB pub gemacht, da ist sie
drin.
|
|
|
|
|
02/06/2011, 13:41
|
#19
|
elite*gold: 173
Join Date: May 2010
Posts: 712
Received Thanks: 209
|
aber die Logs... sind teilweise inkompatibel....
als da wäre der Log
oder der command_log....
jetzt läufts...
MfG Bull
|
|
|
|
|
02/06/2011, 15:44
|
#20
|
elite*gold: 60
Join Date: May 2010
Posts: 766
Received Thanks: 1,025
|
Quote:
Originally Posted by °IceCold°
Thanks for sharing.
Aber hat Daroo nicht schon die .US DB in seinen 2010er Files drin?
|
Quote:
Originally Posted by 'Daroo
Lol, ich hab doch schon die Metin2.US DB pub gemacht, da ist sie
drin. |
no the us db by daro miss many tables like loglogin2 speed hack moneylog command log and anothers i dont remember now without say many table also missing on the databases he have
edit daro usdb have this
bootlog
fishlog
gmhost
gmlist
level log
locale
locale bug
log
quest reward
refine log
shout log
and that databases some are wrong config missing tables wrong tables names etc
|
|
|
|
|
02/06/2011, 15:45
|
#21
|
elite*gold: 30
Join Date: Jul 2010
Posts: 1,627
Received Thanks: 1,450
|
Daaro: Die Tabellen die hier erwähnt sind, sind in deiner us db nicht dabei.
|
|
|
|
|
02/06/2011, 15:52
|
#22
|
elite*gold: 5
Join Date: Nov 2009
Posts: 1,863
Received Thanks: 2,778
|
Aber die hat doch nico_w doch schonmal pub gemacht, also Ofizelle log Db.
Zwar nicht von 2010 geht ja auch nicht, glaube wenn ist hier eine tabelle neu, bzw. gar keine.
MfG .Kay331
|
|
|
|
|
02/06/2011, 15:59
|
#23
|
elite*gold: 60
Join Date: May 2010
Posts: 766
Received Thanks: 1,025
|
Quote:
Originally Posted by .Kay331
Aber die hat doch nico_w doch schonmal pub gemacht, also Ofizelle log Db.
Zwar nicht von 2010 geht ja auch nicht, glaube wenn ist hier eine tabelle neu, bzw. gar keine.
MfG .Kay331
|
yes nico have release a log time ago for 2006/2007 serverfiles with 2010 alot of tables change "names position get out off 1 go to another" is not the same and if you guys have 2010 servers files just go to your syserr and see a lots of errors you have if you use the logs from 2006 from nico or from usdb from daro
|
|
|
|
|
03/30/2011, 14:10
|
#24
|
elite*gold: 0
Join Date: Aug 2010
Posts: 54
Received Thanks: 14
|
For the log command, you need some game special?
|
|
|
|
|
03/30/2011, 17:21
|
#25
|
elite*gold: 0
Join Date: Oct 2008
Posts: 737
Received Thanks: 311
|
#deleted
|
|
|
|
|
04/22/2011, 16:42
|
#26
|
elite*gold: 0
Join Date: Jun 2009
Posts: 1
Received Thanks: 0
|
para que es ese log me podian decir
|
|
|
|
|
04/22/2011, 17:30
|
#27
|
elite*gold: 0
Join Date: Nov 2010
Posts: 309
Received Thanks: 90
|
Was kann das?
Moin,
Könnte mir und den anderen mal jemand übersetzten was das ist?
Meine Englisch Kentnisse sind nicht gleich auf diesem Niveau....
Danke
MfG
CauTaRt
|
|
|
|
|
05/14/2011, 19:53
|
#28
|
elite*gold: 26
Join Date: Aug 2009
Posts: 107
Received Thanks: 62
|
Thanks!! 
|
|
|
|
|
06/20/2011, 20:50
|
#29
|
elite*gold: 0
Join Date: Jul 2010
Posts: 827
Received Thanks: 153
|
very good! works perfect! ty
don't forget to add this link in your sig lex
|
|
|
|
|
08/29/2014, 14:33
|
#30
|
elite*gold: 0
Join Date: Jan 2012
Posts: 6
Received Thanks: 0
|
Quote:
Originally Posted by .Rebel
Well after 3 weeks server online in my 2010 server just request that tables for the logs
Have fun
PHP 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 `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
-- ----------------------------
-- ----------------------------
-- 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 `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;
-- ----------------------------
-- Records of hack_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` time 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` time 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;
-- ----------------------------
-- Records of log
-- ----------------------------
-- ----------------------------
-- 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;
-- ----------------------------
-- Records of loginlog2
-- ----------------------------
-- ----------------------------
-- Table structure for `money_log`
-- ----------------------------
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
`VALUES` int(11) DEFAULT NULL,
`DELAYED` int(11) DEFAULT NULL,
`time` time DEFAULT NULL,
`vnum` int(11) DEFAULT '0',
`pid` int(11) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- ----------------------------
-- Records of money_log
-- ----------------------------
-- ----------------------------
-- 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(50) 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
-- ----------------------------
|
Very good I have been having problems with my log Database for ages
Thank you very much
|
|
|
|
 |
|
Similar Threads
|
2010 logs
02/12/2012 - Metin2 Private Server - 4 Replies
Hi peaple i need a hand with the table money_log for the server files 2010
4 10:12:38 :: ChildLoop: AsyncSQL: query failed: DELAYED option not supported for table 'money_log' (query: INSERT DELAYED INTO money_log VALUES (NOW(), 8, 71118, 10) errno: 1616)
i have made this
DROP TABLE IF EXISTS `money_log`;
CREATE TABLE `money_log` (
`VALUES` int(11) DEFAULT NULL,
|
Shaiya EP5 Databases MAP 71
06/01/2011 - Shaiya Private Server - 5 Replies
Hey wenn ich meinen Server mit dem SQL Manager starten möchte,
sagt er das MAP71 nicht geladen werden kann.
2011-01-05 14:26:13 data/map/71.svmap map open failed
2011-01-05 14:26:13 map 71 Load failed
Hat wer die MAp71 oder weiß wieman diesen fehler beseitigt?
|
[Release]Rakion Server Files + Databases
02/18/2011 - General Gaming Discussion - 20 Replies
Server download: Rakion::Server
Database download: Databases::Good
Maybe Correct Client Download: Client
|
[Help]Databases.
07/26/2009 - Cabal Private Server - 0 Replies
Hello all... I installed and configured the centos and wmare and they are working i think... Now what is left is to configure the SQL server... And there the problem began... I don't have any databases for cabal... Can somebody tell me where can i get databases or download?
|
[Release]Rakion Server Files + Databases
07/20/2008 - Private Server Advertising - 3 Replies
Server download: Rakion::Server
Database download: Databases::Good
Maybe Correct Client Download: Client
|
All times are GMT +1. The time now is 10:00.
|
|
![[Release] 2010 Logs databases](https://www.elitepvpers.com/forum/iconimages/metin2-pserver-guides-strategies/release-2010-logs-databases_ltr.gif){kind=small}
