[Release] 2010 Logs databases

.Rebel · 02/06/2011, 05:33

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

dCheeTos · 02/06/2011, 05:37

Thx

Mαhdin · 02/06/2011, 05:38

For what we can use it? :<

~~Almari~~ · 02/06/2011, 05:38

N1ce Release, as i already said, the one thing i especially needed was "fishlog", but thanks anyways. It will help a lot of people.

.Rebel · 02/06/2011, 05:46

Quote:

Originally Posted by MaяTiη :3

For what we can use it? :<

loooool

for what lol

maybe your server need make log for everything hapen on the server if you dont have that tables,
well you have a bigggggg syserr.txt on your server and if you have that well maybe you have also a lot of bugs on your server if you dont know read your syserr.txt you have a lots of work

the syserr.txt is the file record all problems on your server if miss some table like on the logs will recorder everytime the server try record stuff on that miss table

Mαhdin · 02/06/2011, 05:49

Quote:

Originally Posted by Lexico

loooool

for what lol

maybe your server need make log for everything hapen on the server if you dont have that tables,
well you have a bigggggg syserr.txt on your server and if you have that well maybe you have also a lot of bugs on your server if you dont know read your syserr.txt you have a lots of work

the syserr.txt is the file record all problems on your server if miss some table like on the logs will recorder everytime the server try record stuff on that miss table

i mean the fishlog etc

So, you can look how many fishes was thrown?

.Rebel · 02/06/2011, 05:55

Quote:

Originally Posted by MaяTiη :3

i mean the fishlog etc
So, you can look how many fishes was thrown?

ofcorse
you will see everything people fishing for you maybe is nothing

but for me and some another servers we have all record no mather what you do the server record everything
all you do
what you do
what you drop
what you get
what you fish
what you transfer with how etc
what you speack in general chat
what comands the gm use
when login when log out
speed hack
combo hack
multihack
where you are

everithing is record

~~Almari~~ · 02/06/2011, 05:57

Quote:

Originally Posted by Lexico

ofcorse
you will see everything people fishing for you maybe is nothing

but for me and some another servers we have all record no mather what you do the server record everything
all you do
what you do
what you drop
what you get
what you fish
what you transfer with how etc
what you speack in general chat
what comands the gm use
when login when log out
speed hack
combo hack
multihack
where you are

everithing is record

gameforge lässt grüssen^^

Gameforge gives loving greetings^^

.Rebel · 02/06/2011, 05:58

Quote:

Originally Posted by .99Percent

GF lässt grüssen^^

GF gives loving greetings^^

loooool yay they love privat servers every day more

~~Almari~~ · 02/06/2011, 06:15

Quote:

Originally Posted by Lexico

loooool yay they love privat servers every day more

hows yours?

.Rebel · 02/06/2011, 06:42

Quote:

Originally Posted by .99Percent

hows yours?

if i tell you i need kill you
you know to mutch

~~Almari~~ · 02/06/2011, 06:45

Quote:

Originally Posted by Lexico

if i tell you i need kill you
you know to mutch

you`re welcome :P

LG+
.99Percent

PS: Have skype,icq or msn? Then PN me!

~~YouFailed~~ · 02/06/2011, 07:25

Niiiice -> pserver hat Jetz de überholt Logs,lvlanzeige,shoptische <3

~~Almari~~ · 02/06/2011, 07:26

Quote:

Originally Posted by YouFailed

Niiiice -> pserver hat Jetz de überholt Logs,lvlanzeige,shoptische <3

Überholt? Niemals -.-
Wenn dann etwas eingeholt, den Hackshield haben wir immernoch nicht, ganz geschwiegen der Lizenz. Naja kannst ja betrachten, wie du willst, ich halte mich da raus^^

~~YouFailed~~ · 02/06/2011, 07:28

Wollte eig fast eingeholt schreiben aber gf ist eh fail