Right looking thru TXT files i found the following so im thinking mayb we create the DB ourself?
Code:
1. GDÐÐΪÈÕÖ¾±í
create table Gd_Action_Logs
(
rowid bigint unsigned not null AUTO_INCREMENT,
Player_Id varchar(14) not null,
Player_Chr varchar(18) not null,
Player_IP varchar(18) not null,
GD_Command varchar(255) not null,
Use_date datetime not null default 'NOW()',
ActionType varchar(50) not null,
primary key (rowid)
);
×Ö¶Î˵Ã÷:
Player_Id Íæ¼ÒÕʺÅ
Player_Chr Íæ¼Ò½ÇÉ«Ãû
Player_IP Íæ¼ÒIPµØÖ·
Use_date ʱ¼ä
ActionType GD_Command
ÉÏÏÂÏß ÉÏÏß/ÏÂÏß
GDÖ¸Áî ¶ÔÏó/ʹÓòÎÊý/°üÀ¨Èº·¢ÏûÏ¢µÄÏûÏ¢ÄÚÈÝ¡£
½»Ò× ¶Ô·½/ÎïÆ·/
×é¶Ó ¶Ó³¤½ÇÉ«/×éÔ±
Ðлá ÐлáÃû/ÔÚÆäÖе£ÈεÄÖ°Îñ/
·¢ÑÔÄÚÈÝ ·¢ÑÔ·½Ê½£¨×é¶Ó/ÆÕͨ/ÐлáÄÚ/º°»°µÈ£©/˽ÁĶÔÏó/·¢ÑÔÄÚÈÝ
¼ðÎïÆ·/ÈÓÎïÆ· ¶¯×÷ÀàÐÍ£¨ÈÓ/¼ð£©ÎïÆ·/½ðÇ®ÊýÁ¿
×°±¸/È¡ÏÂÎïÆ· ¶¯×÷ÀàÐÍ/×°±¸/È¡ÏÂÎïÆ·
PK µØͼ/¶Ô·½/ʤ¸º¶Ô·½ËÀ/×Ô¼ºËÀ/¶Ô·½ÊÜÉ˺¦µ«Ã»ÓÐËÀ/ÎÞÉ˺¦/×Ô¼ºµÄ
É˺¦Çé¿ö£©
´ò¹Ö µØͼ/¹ÖÎï/
ËÀÍö µØͼ/¶Ô·½£¨ÈË»ò¹ÖÎ
·ÇÒþÉí״̬ ʱ¼äʼÖÕµã/
GD²ÎÓëÓÎÏ·µÄ¾Ù¶¯
2. ½»Ò×ÈÕÖ¾±í
create table Items_Transform_Logs
(
rowid bigint unsigned not null AUTO_INCREMENT,
Player_Chr1 varchar(18) not null,
Item_List1 text not null,
Player_Chr2 varchar(18) not null,
Item_List2 text not null,
Trans_date datetime not null default 'NOW()',
primary key (rowid)
);
×Ö¶Î˵Ã÷:
Player_Chr1 ²ÎÓë½»Ò×µÄÍæ¼Ò1½ÇÉ«Ãû
Item_List1 Íæ¼Ò1µÄ½»Ò×ÎïÆ·
Player_Chr2 ²ÎÓë½»Ò×µÄÍæ¼Ò2½ÇÉ«Ãû
Item_List2 Íæ¼Ò2µÄ½»Ò×ÎïÆ·
Trans_date ½»Ò×ʱ¼ä
3. ÌøGSÈÕÖ¾±í
create table Jump_Gs_Logs
(
rowid bigint unsigned not null AUTO_INCREMENT,
Player_Chr varchar(18) not null,
JumpDetail varchar(80) not null,
Jump_date datetime not null default 'NOW()',
primary key (rowid)
);
×Ö¶Î˵Ã÷:
Player_Chr Íæ¼Ò½ÇÉ«Ãû
JumpDetail ÌøGSµÄÏêϸÃèÊö
Jump_date ÌøGSʱ¼ä
4. ×é¶ÓÈÕÖ¾±í
create table Group_Logs
(
rowid bigint unsigned not null AUTO_INCREMENT,
Player_Chr varchar(18) not null,
GroupDetail varchar(100) not null,
Group_date datetime not null default 'NOW()',
primary key (rowid)
);
×Ö¶Î˵Ã÷:
Player_Chr Íæ¼Ò½ÇÉ«Ãû
GroupDetail ×é¶ÓµÄÏêϸÃèÊö
Group_date ×é¶Óʱ¼ä
5. ²Ö¿â´æÈ¡ÎïÆ·¼Ç¼ÈÕÖ¾±í
create table StoreItem_Logs
(
rowid bigint unsigned not null AUTO_INCREMENT,
Item_Id bigint unsigned not null,
Item_Name varchar(30) not null,
Item_Host varchar(18) not null,
Action_Type varchar(10) not null,
Item_Property varchar(255) not null,
StoreDate datetime not null default 'NOW()',
primary key (rowid)
);
×Ö¶Î˵Ã÷:
Item_Id ÎïÆ·ID
Item_Name ÎïÆ·Ãû³Æ
Item_Host ÎïÆ·µÄËùÓÐÕß
Action_Type ´æÎïÆ·/È¡ÎïÆ·
Item_Property ÎïÆ·ÊôÐÔ
StoreDate ´æÈ¡ÎïƷʱ¼ä
ÎäÆ÷Éý¼¶¼Ç¼ÈÕÖ¾
create table WeaponUpdate_Logs
(
rowid bigint unsigned not null AUTO_INCREMENT,
Weapon_Id bigint unsigned not null,
Weapon_Name varchar(30) not null,
Weapon_Host varchar(18) not null,
Update_Type varchar(20) not null,
Weapon_Property varchar(255) not null,
UpdateDate datetime not null default 'NOW()',
primary key (rowid)
);
×Ö¶Î˵Ã÷:
Weapon_Id ÎäÆ÷ID
Weapon_Name ÎäÆ÷Ãû³Æ
Weapon_Host ÎäÆ÷ËùÓÐÕß
Update_Type ʹÓÃ×£¸£Óͱ»×£¸£/ʹÓÃ×£¸£Óͱ»×çÖä/ÐÞÁ·/PK±»×çÖä
Weapon_Property ÎäÆ÷Éý¼¶Ç°ÊôÐÔºÍÉý¼¶ºóÊôÐÔ
UpdateDate ʱ¼ä
7. PK¼Ç¼ÈÕÖ¾±í
create table pk_logs
(
rowid bigint unsigned not null AUTO_INCREMENT,
Player1_Chr varchar(18) not null,
Player2_Chr varchar(18) not null,
Pk_Result varchar(50) not null,
Pkdate datetime not null default 'NOW()',
primary key (rowid)
);
×Ö¶Î˵Ã÷:
Player1_Chr Íæ¼Ò½ÇÉ«Ãû
Player2_Chr ¶Ô·½Íæ¼Ò½ÇÉ«Ãû
Pk_Result Pk½á¹û
Pkdate PKʱ¼ä
8. Ðлá¼Ç¼ÈÕÖ¾±í
create table guild_logs
(
rowid bigint unsigned not null AUTO_INCREMENT,
Player_Chr varchar(18) not null,
Guild_Name varchar(30) not null,
IsGuildChair smallint unsigned not null,
Action_Type varchar(20) not null,
Detail varchar(20) ,
Pkdate datetime not null default 'NOW()',
primary key (rowid)
);
×Ö¶Î˵Ã÷:
Player_Chr Íæ¼Ò½ÇÉ«Ãû
Guild_Name Íæ¼ÒËùÊôÐлáÃû
IsGuildChair 0
Pkdate ʱ¼ä
Action_Type Detail
¼ÓÈëÐлá
Í˳öÐлá
½¨Á¢Ðлá
ɾ³ýÐлá
±à¼*·âºÅ
±à¼*¹«¸æ
ÉêÇëÐлáÕ½
¶Ô·½ÐлáÃû
ͬÃË ¶Ô·½ÐлáÃû
½â³ýͬÃË ¶Ô·½ÐлáÃû
Ìí¼ÓÐлá³ÉÔ± ³ÉÔ±½ÇÉ«Ãû
ɾ³ýÐлá³ÉÔ± ³ÉÔ±½ÇÉ«Ãû
ÉêÇë¹¥³Ç ³ÇÖ÷Ðлá
9. Éý¼¶¼Ç¼ÈÕÖ¾±í
create table upgrade_logs
(
rowid bigint unsigned not null AUTO_INCREMENT,
Player_Id varchar(14) not null,
Player_Chr varchar(18) not null,
Upgrade varchar(10) not null,
date datetime not null default 'NOW()',
primary key (rowid)
);
×Ö¶Î˵Ã÷:
Player_Id Íæ¼ÒÕʺÅ
Player_Chr Íæ¼Ò½ÇÉ«Ãû
Upgrade Éý¼¶ÃèÊö £¨ÀýÈç´ÓÒ»¼¶Éýµ½¶þ¼¶Îª£º1->2 £©
Date Éý¼¶Ê±¼ä
10. ÉùÍûÖµ¼Ç¼ÈÕÖ¾±í
create table repute
(
rowid bigint unsigned not null AUTO_INCREMENT,
player_Chr varchar(18) not null,
repute varchar(20) not null,
detail varchar(50) not null,
date datetime not null default 'NOW()',
primary key (rowid)
);
×Ö¶Î˵Ã÷:
player_Chr Íæ¼Ò½ÇÉ«Ãû
repute ÉùÍûÖµ±ä»¯
detail ÉùÍûÖµ±ä»¯Ô*Òò
date ʱ¼ä
11. »éÒö¹Øϵ¼Ç¼ÈÕÖ¾±í
create table marry
(
rowid bigint unsigned not null AUTO_INCREMENT,
husband varchar(18) not null,
wife varchar(18) not null,
type varchar(20) not null,
detail varchar(50) not null,
date datetime not null default 'NOW()',
primary key (rowid)
);
×Ö¶Î˵Ã÷:
husband ÕÉ·ò½ÇÉ«Ãû
wife ÆÞ×Ó½ÇÉ«Ãû
type ½á»é¡¢Àë»é
detail ½á»é»òÀë»éµÄÔ*Òò
date ʱ¼ä
12. ʦͽ¹Øϵ¼Ç¼ÈÕÖ¾±í
create table teacher
(
rowid bigint unsigned not null AUTO_INCREMENT,
teacher varchar(18) not null,
student varchar(18) not null,
type varchar(20) not null,
detail varchar(50) not null,
date datetime not null default 'NOW()',
primary key (rowid)
);
×Ö¶Î˵Ã÷:
teacher ʦ¸¸½ÇÉ«Ãû
student ͽµÜ½ÇÉ«Ãû
type ½¨Á¢Ê¦Í½¹Øϵ¡¢½â³ýʦͽ¹Øϵ
detail ½¨Á¢»ò½â³ýʦͽ¹ØϵµÄÔ*Òò
date ʱ¼ä