传世服务器的基本构造

这里是初步拟订的(相当与1.60版)结构,还包含了几个做好的服务端结构性设备,现在进展很快,有的图发不上来很遗憾.不感发出来怕犯法,就自己留着玩啦

www.sfmir2.com
www.sfmir2.com

www.sfmir2.com
                                日志说明书www.sfmir2.com
            一、 文件描述www.sfmir2.com
            项目标识项目名称日志www.sfmir2.com
            项目经理 王峰设计者吴文仲审核者www.sfmir2.com
            设计日期2005.3.25审核日期

www.sfmir2.com
www.sfmir2.com

www.sfmir2.com
            二、 文档修订纪录

www.sfmir2.com
www.sfmir2.com

            序  号修改时间修 改 人审 核 人备            注www.sfmir2.com
            1   www.sfmir2.com
            2www.sfmir2.com
            3www.sfmir2.com
            4www.sfmir2.com
            5www.sfmir2.com
            6www.sfmir2.com
            7www.sfmir2.com
            8www.sfmir2.com
            9www.sfmir2.com
            15www.sfmir2.com
            16www.sfmir2.com
            17

www.sfmir2.com
www.sfmir2.com

            三、 功能及运行www.sfmir2.com
            日志通过UDP协议接收GameServer www.sfmir2.com
            发送来的加密日志信息包，解密并解析相关内容后，发送给已连接的MySQL数据库，在MySQL数据库中记录下相关日志信息。

www.sfmir2.com
www.sfmir2.com

www.sfmir2.com
            在启动日志服务器之前,首先必须启动MySQL数据库，且建好数据库表(见建表脚本文件table_script.txt)。然后正确配置日志的配置文件Config.ini

www.sfmir2.com
www.sfmir2.com

            四、配置文件说明

www.sfmir2.com
www.sfmir2.com

            配置文件：Config.ini www.sfmir2.com
            [LogServer] www.sfmir2.com
            logip = 10.10.10.36      ( LogServer 接收信息端的IP地址 ,必须与GameServer的配置一致)www.sfmir2.com
            logport = 6801          ( LogServer 接收信息端的端口，必须与GameServer的配置一致)

www.sfmir2.com
www.sfmir2.com

            [MySqlServer]www.sfmir2.com
            mysqlip = 10.10.10.160  ( MySQL数据库的IP地址 )www.sfmir2.com
            mysqlport = 3306 ( MySQL数据库的端口 )www.sfmir2.com
            dbname = logs     ( 数据库的名称 )www.sfmir2.com
            user = root  ( 数据库用户名 )www.sfmir2.com
            password =            ( 数据库密码 )

www.sfmir2.com
www.sfmir2.com

www.sfmir2.com
            五、表结构说明

www.sfmir2.com
www.sfmir2.com

            1. GD行为日志表www.sfmir2.com
            create table Gd_Action_Logswww.sfmir2.com
            (www.sfmir2.com
            rowidbigint unsignednot null AUTO_INCREMENT,www.sfmir2.com
              Player_Idvarchar(14)not null,www.sfmir2.com
              Player_Chrvarchar(18)not null,www.sfmir2.com
              Player_IPvarchar(18)not null,www.sfmir2.com
              GD_Commandvarchar(255)not null,www.sfmir2.com
              Use_datedatetimenot null default ＇NOW()＇,www.sfmir2.com
              ActionTypevarchar(50)not null,www.sfmir2.com
              primary key (rowid)www.sfmir2.com
            );

www.sfmir2.com
www.sfmir2.com

            字段说明:www.sfmir2.com
            Player_Id  玩家帐号 www.sfmir2.com
            Player_Chr 玩家角色名 www.sfmir2.com
            Player_IP玩家IP地址www.sfmir2.com
            Use_date时间

www.sfmir2.com
www.sfmir2.com

            ActionTypeGD_Commandwww.sfmir2.com
            上下线上线/下线www.sfmir2.com
            GD指令对象/使用参数/包括群发消息的消息内容。www.sfmir2.com
            交易对方/物品/www.sfmir2.com
            组队队长角色/组员www.sfmir2.com
            行会行会名/在其中担任的职务/www.sfmir2.com
            发言内容发言方式（组队/普通/行会内/喊话等）/私聊对象/发言内容www.sfmir2.com
            拣物品/扔物品动作类型（扔/拣）物品/金钱数量www.sfmir2.com
            装备/取下物品动作类型/装备/取下物品www.sfmir2.com
            PK地图/对方/胜负对方死/自己死/对方受伤害但没有死/无伤害/自己的www.sfmir2.com
            伤害情况）www.sfmir2.com
            打怪地图/怪物/www.sfmir2.com
            死亡地图/对方（人或怪物）www.sfmir2.com
            非隐身状态时间始终点/www.sfmir2.com
            GD参与的举动

www.sfmir2.com
www.sfmir2.com

            2. 交易日志表www.sfmir2.com
            create table Items_Transform_Logswww.sfmir2.com
            (www.sfmir2.com
              rowidbigint unsignednot null AUTO_INCREMENT,www.sfmir2.com
              Player_Chr1varchar(18)not null,www.sfmir2.com
              Item_List1textnot null,www.sfmir2.com
              Player_Chr2varchar(18)not null,  www.sfmir2.com
              Item_List2textnot null,www.sfmir2.com
              Trans_datedatetimenot null default ＇NOW()＇,www.sfmir2.com
              primary key (rowid)www.sfmir2.com
            );www.sfmir2.com
            字段说明:www.sfmir2.com
            Player_Chr1参与交易的玩家1角色名www.sfmir2.com
            Item_List1玩家1的交易物品www.sfmir2.com
            Player_Chr2参与交易的玩家2角色名www.sfmir2.com
            Item_List2玩家2的交易物品www.sfmir2.com
            Trans_date交易时间

www.sfmir2.com
www.sfmir2.com

            3.  跳GS日志表www.sfmir2.com
            create table Jump_Gs_Logswww.sfmir2.com
            ( www.sfmir2.com
            rowidbigint unsignednot null AUTO_INCREMENT,www.sfmir2.com
              Player_Chrvarchar(18)not null,www.sfmir2.com
              JumpDetailvarchar(80)not null,www.sfmir2.com
              Jump_datedatetimenot null default ＇NOW()＇,www.sfmir2.com
              primary key (rowid)www.sfmir2.com
            );www.sfmir2.com
            字段说明:www.sfmir2.com
            Player_Chr玩家角色名www.sfmir2.com
            JumpDetail跳GS的详细描述www.sfmir2.com
            Jump_date跳GS时间

www.sfmir2.com
www.sfmir2.com

            4. 组队日志表www.sfmir2.com
            create table Group_Logswww.sfmir2.com
            (  www.sfmir2.com
            rowidbigint unsignednot null AUTO_INCREMENT,www.sfmir2.com
              Player_Chrvarchar(18)not null,www.sfmir2.com
              GroupDetailvarchar(100) not null,www.sfmir2.com
              Group_datedatetimenot null default ＇NOW()＇,www.sfmir2.com
              primary key (rowid)www.sfmir2.com
            );www.sfmir2.com
            字段说明:www.sfmir2.com
            Player_Chr玩家角色名www.sfmir2.com
            GroupDetail组队的详细描述www.sfmir2.com
            Group_date组队时间

www.sfmir2.com
www.sfmir2.com

            5. 仓库存取物品记录日志表www.sfmir2.com
            create table StoreItem_Logswww.sfmir2.com
            (www.sfmir2.com
            rowidbigint unsignednot null AUTO_INCREMENT,www.sfmir2.com
              Item_Idbigint unsignednot null,www.sfmir2.com
              Item_Namevarchar(30)not null,www.sfmir2.com
              Item_Hostvarchar(18)not null, www.sfmir2.com
              Action_Typevarchar(10)not null,www.sfmir2.com
              Item_Propertyvarchar(255)not null,www.sfmir2.com
              StoreDatedatetimenot null default ＇NOW()＇,www.sfmir2.com
              primary key (rowid)www.sfmir2.com
            );www.sfmir2.com
            字段说明:www.sfmir2.com
            Item_Id物品IDwww.sfmir2.com
            Item_Name物品名称www.sfmir2.com
            Item_Host物品的所有者www.sfmir2.com
            Action_Type存物品/取物品www.sfmir2.com
            Item_Property物品属性www.sfmir2.com
            StoreDate存取物品时间

www.sfmir2.com
www.sfmir2.com

            6. 武器升级记录日志www.sfmir2.com
            create table WeaponUpdate_Logswww.sfmir2.com
            (www.sfmir2.com
            rowid bigint unsigned not null AUTO_INCREMENT,www.sfmir2.com
              Weapon_Idbigint unsigned not null,www.sfmir2.com
              Weapon_Name varchar(30) not null,www.sfmir2.com
              Weapon_Host varchar(18) not null, www.sfmir2.com

              Update_Type varchar(20) not null,www.sfmir2.com
              Weapon_Property varchar(255) not null,www.sfmir2.com
              UpdateDate datetime not null default ＇NOW()＇,www.sfmir2.com
              primary key (rowid)www.sfmir2.com
            );www.sfmir2.com
            字段说明:www.sfmir2.com
            Weapon_Id武器IDwww.sfmir2.com
            Weapon_Name武器名称www.sfmir2.com
            Weapon_Host武器所有者www.sfmir2.com
            Update_Type使用祝福油被祝福/使用祝福油被诅咒/修练/PK被诅咒www.sfmir2.com
            Weapon_Property武器升级前属性和升级后属性www.sfmir2.com
            UpdateDate时间

www.sfmir2.com
www.sfmir2.com

www.sfmir2.com
www.sfmir2.com
www.sfmir2.com
www.sfmir2.com

www.sfmir2.com
www.sfmir2.com

            7. PK记录日志表www.sfmir2.com
            create table pk_logswww.sfmir2.com
            (www.sfmir2.com
            rowid bigint unsigned not null AUTO_INCREMENT,www.sfmir2.com
              Player1_Chr varchar(18) not null,www.sfmir2.com
              Player2_Chrvarchar(18) not null,www.sfmir2.com
              Pk_Resultvarchar(50) not null,www.sfmir2.com
              Pkdatedatetime not null default ＇NOW()＇,www.sfmir2.com
              primary key (rowid)www.sfmir2.com
            );

www.sfmir2.com
www.sfmir2.com

            字段说明:www.sfmir2.com
            Player1_Chr玩家角色名www.sfmir2.com
            Player2_Chr对方玩家角色名www.sfmir2.com
            Pk_ResultPk结果www.sfmir2.com
            PkdatePK时间

www.sfmir2.com
www.sfmir2.com

            8. 行会记录日志表www.sfmir2.com
            create table guild_logswww.sfmir2.com
            (www.sfmir2.com
              rowid bigint unsigned not null AUTO_INCREMENT,www.sfmir2.com
              Player_Chr varchar(18) not null,www.sfmir2.com
              Guild_Name varchar(30) not null,www.sfmir2.com
              IsGuildChairsmallint unsignednot null,www.sfmir2.com
              Action_Type varchar(20) not null,www.sfmir2.com
              Detailvarchar(20) ,www.sfmir2.com
              Pkdate datetime not null default ＇NOW()＇,www.sfmir2.com
              primary key (rowid)www.sfmir2.com
            );

www.sfmir2.com
www.sfmir2.com

            字段说明:www.sfmir2.com
            Player_Chr玩家角色名www.sfmir2.com
            Guild_Name玩家所属行会名www.sfmir2.com
            IsGuildChair0www.sfmir2.com
            Pkdate时间

www.sfmir2.com
www.sfmir2.com

            Action_TypeDetailwww.sfmir2.com
            加入行会www.sfmir2.com
            退出行会www.sfmir2.com
            建立行会www.sfmir2.com
            删除行会               www.sfmir2.com
            编辑封号www.sfmir2.com
            编辑公告www.sfmir2.com

            申请行会战对方行会名www.sfmir2.com
            同盟对方行会名www.sfmir2.com
            解除同盟对方行会名www.sfmir2.com
            添加行会成员成员角色名www.sfmir2.com
            删除行会成员成员角色名www.sfmir2.com
            申请攻城           城主行会

www.sfmir2.com
www.sfmir2.com

www.sfmir2.com
            9. 升级记录日志表www.sfmir2.com
            create table upgrade_logswww.sfmir2.com
            (www.sfmir2.com
              rowid bigint unsigned       not null AUTO_INCREMENT,www.sfmir2.com
              Player_Id         varchar(14)             not null,www.sfmir2.com
              Player_Chr        varchar(18)             not null,www.sfmir2.com
              Upgradevarchar(10)      not null,www.sfmir2.com
              date     datetime           not null default ＇NOW()＇,www.sfmir2.com
              primary key (rowid)www.sfmir2.com
            );

www.sfmir2.com
www.sfmir2.com

            字段说明:www.sfmir2.com
            Player_Id  玩家帐号 www.sfmir2.com
            Player_Chr 玩家角色名 www.sfmir2.com
            Upgrade升级描述 （例如从一级升到二级为：1->2 ）www.sfmir2.com
            Date升级时间

www.sfmir2.com
www.sfmir2.com

www.sfmir2.com
            10. 声望值记录日志表www.sfmir2.com
            create table reputewww.sfmir2.com
            (www.sfmir2.com
               rowid bigint unsigned       not null AUTO_INCREMENT,www.sfmir2.com
              player_Chrvarchar(18)not null,www.sfmir2.com
            reputevarchar(20)not null,www.sfmir2.com

            detailvarchar(50)not null,www.sfmir2.com
              date datetime       not null default ＇NOW()＇,www.sfmir2.com
              primary key (rowid)www.sfmir2.com
            );www.sfmir2.com
            字段说明:www.sfmir2.com
            player_Chr玩家角色名www.sfmir2.com
            repute声望值变化www.sfmir2.com
            detail声望值变化原因www.sfmir2.com

            date时间

www.sfmir2.com
www.sfmir2.com

www.sfmir2.com
            11. 婚姻关系记录日志表www.sfmir2.com
            create table marrywww.sfmir2.com
            (www.sfmir2.com
            rowid bigint unsigned     not null AUTO_INCREMENT,www.sfmir2.com
            hu##andvarchar(18)not null,www.sfmir2.com
            wifevarchar(18)not null,www.sfmir2.com
            typevarchar(20)not null,www.sfmir2.com

            detailvarchar(50)not null,www.sfmir2.com
            date datetime       not null default ＇NOW()＇,www.sfmir2.com
            primary key (rowid)www.sfmir2.com
            );www.sfmir2.com
            字段说明:www.sfmir2.com
            hu##and丈夫角色名www.sfmir2.com
            wife妻子角色名www.sfmir2.com
            type结婚、离婚www.sfmir2.com
            detail结婚或离婚的原因www.sfmir2.com
            date时间

www.sfmir2.com
www.sfmir2.com

www.sfmir2.com
            12. 师徒关系记录日志表www.sfmir2.com
            create table teacherwww.sfmir2.com
            (www.sfmir2.com
            rowid bigint unsigned     not null AUTO_INCREMENT,www.sfmir2.com
            teachervarchar(18)not null,www.sfmir2.com
            studentvarchar(18)not null,www.sfmir2.com
            typevarchar(20)not null,www.sfmir2.com
            detailvarchar(50)not null,www.sfmir2.com
            date datetime     not null default ＇NOW()＇,www.sfmir2.com
            primary key (rowid)www.sfmir2.com
            );www.sfmir2.com
            字段说明:www.sfmir2.com
            teacher师父角色名www.sfmir2.com
            student徒弟角色名www.sfmir2.com
            type建立师徒关系、解除师徒关系www.sfmir2.com

            detail建立或解除师徒关系的原因www.sfmir2.com
            date时间