275 lines
8.4 KiB
C++
275 lines
8.4 KiB
C++
#pragma once
|
||
#ifndef _ACTOR_DB_DATA_H_
|
||
#define _ACTOR_DB_DATA_H_
|
||
|
||
#include "common.h"
|
||
#include "common/datalist.h"
|
||
#include "common/property_set.h"
|
||
|
||
#pragma pack(push,4)
|
||
|
||
/*
|
||
玩家需要存盘的数据结构体
|
||
*/
|
||
|
||
using namespace SrvDef;
|
||
|
||
//tolua_begin
|
||
struct ActorBasicData
|
||
{
|
||
unsigned int account_id; //账户的ID
|
||
//ACCOUNT account_name; //账户名字
|
||
char account_name[ACCOUNT_LENGTH]; //账户名字
|
||
int actor_id; //角色id
|
||
//ACTORNAME actor_name; //名字
|
||
char actor_name[ACTOR_NAME_BUFF_LENGTH]; //名字
|
||
unsigned int server_idnex;
|
||
|
||
unsigned char job; // 第一个角色职业
|
||
unsigned char sex; // 第一个角色性别
|
||
unsigned int level;
|
||
unsigned int exp;
|
||
long long int fb_uid; //副本的uid
|
||
unsigned int fb_scene_id; //副本内的场景id
|
||
|
||
unsigned int create_time; //创建的时间
|
||
unsigned int last_online_time; //最后在线时间
|
||
unsigned long long last_login_ip;//上次登录的ip,还没支持
|
||
|
||
unsigned int total_online; //总的在线时长
|
||
unsigned int daily_online; //单日在线时长
|
||
|
||
unsigned int bag_grid; // 背包开启数量
|
||
long long int gold;
|
||
long long int yuanbao;
|
||
long long int total_power; // 总战力
|
||
long long int rank_power; //用于排行榜的战力
|
||
unsigned int recharge; // 充值元宝数
|
||
unsigned int paid; // 消费元宝数
|
||
unsigned int chapter_level; // 所在关卡数 同时用于选择静态场景所在的场景
|
||
unsigned int vip_level; // vip等级
|
||
int essence; // 精魄
|
||
int zhuansheng_lv; // 转生等级
|
||
int zhuansheng_exp; // 转生修为
|
||
unsigned char monthcard; //0为没购买1,为没过期,2为过期
|
||
int tianti_level; //天梯级别
|
||
int tianti_dan; //天梯段位
|
||
int tianti_win_count; //天梯净胜
|
||
int tianti_week_refres; //天梯周刷新
|
||
|
||
|
||
long long int total_wing_power; //翅膀总战力
|
||
long long int warrior_power; //战士战力
|
||
long long int mage_power; //法师战力
|
||
long long int taoistpriest_power; //道士战力
|
||
int train_level; //神工(爵位)等级
|
||
int train_exp; //神工(爵位)经验
|
||
int total_stone_level; //宝石(精炼)总等级
|
||
int total_zhuling_level;//铸造总等级
|
||
int guild_id_; //公会ID
|
||
char guild_name_[32];//工会名
|
||
|
||
int zhan_ling_star; //
|
||
int zhan_ling_stage; //
|
||
int total_loongsoul_level;
|
||
|
||
int prestige_exp; //威望值
|
||
long long int feats; // 功勋
|
||
|
||
unsigned int ex_ring_lv[8];//特戒等级,最高位为1时候出战
|
||
|
||
long long int shatter; //符文碎片
|
||
long long int spcshatter; //特殊符文碎片
|
||
|
||
unsigned int knighthood_lv;//勋章等级
|
||
|
||
long long int togeatter;//合击碎片
|
||
int total_wing_lv; //翅膀总阶级
|
||
long long int total_tujian_power;//图鉴总战力
|
||
long long int total_equip_power;//装备总评分
|
||
long long int togeatterhigh;//高级合击碎片
|
||
|
||
unsigned char privilege_monthcard; //特权月卡， 未购买或已过期为0,1为没过期
|
||
int reincarnate_lv; // 轮回等级
|
||
int reincarnate_exp; // 轮回修为
|
||
|
||
long long int dianquan;//点券
|
||
int quota; //交易额度
|
||
};
|
||
|
||
inline ActorBasicData* toActorBasicData(void* data) { return (ActorBasicData*)data; }
|
||
//tolua_end
|
||
|
||
struct ActorCsData {
|
||
unsigned int actor_id; //角色id
|
||
|
||
// 跨服数据
|
||
unsigned long long cw_fbhdl_sid_; // 跨服战的位置信息,低4位是fuben的handle，高4位是战斗服的sid
|
||
unsigned long long cw_scene_xy_; // 跨服战的位置信息,低4位是场景id，高4位中的低高两位分别是x，y
|
||
unsigned long long cw_static_pos_; // 进入副本前，在普通场景的位置，低4位是场景id，高4位中的低高两位分别是x，y
|
||
|
||
ActorCsData() {
|
||
memset(this, 0, sizeof(ActorCsData));
|
||
}
|
||
};
|
||
|
||
#pragma pack(pop)
|
||
|
||
inline void ReadActorBasicData(ActorBasicData& actor_data, MYSQL_ROW &pRow, unsigned long *fieldLength)
|
||
{
|
||
/*select level, exp, baggridcount, gold, yuanbao, totalpower, paid, fbhandle, sceneid,
|
||
createtime, lastlogouttime, totalonline, dailyonline
|
||
from actors
|
||
where actorid = nactorid and(status & 2) = 2;
|
||
*/
|
||
#define GetRowInt(i, data) sscanf(pRow[i], "%d", &(data))
|
||
#define GetRowUChar(i, data) int temp##i; sscanf(pRow[i], "%d", &(temp##i)); data = temp##i;
|
||
#define GetRowLInt(i, data) sscanf(pRow[i], "%lld", &(data))
|
||
#define GetRowString(i, data) sscanf(pRow[i], "%s", (data))
|
||
#define GetRowData(i,data) if(pRow[i]!=NULL) memcpy(&(data),pRow[i],fieldLength[i])
|
||
|
||
|
||
#ifdef _MSC_VER
|
||
#pragma message("todo 封装数据库流程")
|
||
#endif
|
||
GetRowInt(0, actor_data.account_id);
|
||
GetRowString(1, actor_data.account_name);
|
||
GetRowInt(2, actor_data.actor_id);
|
||
GetRowString(3, actor_data.actor_name);
|
||
GetRowUChar(4, actor_data.job);
|
||
GetRowUChar(5, actor_data.sex);
|
||
//GetRowInt(6, actor_data.status);
|
||
GetRowInt(7, actor_data.level);
|
||
GetRowInt(8, actor_data.exp);
|
||
GetRowInt(9, actor_data.server_idnex);
|
||
|
||
//GetRowInt(10, actor_data.create_time);
|
||
tm t;
|
||
memset(&t, 0, sizeof(t));
|
||
sscanf(pRow[10], "%d-%d-%d %d:%d:%d",
|
||
&t.tm_year,
|
||
&t.tm_mon,
|
||
&t.tm_mday,
|
||
&t.tm_hour,
|
||
&t.tm_min,
|
||
&t.tm_sec
|
||
);
|
||
t.tm_year -= 1900;
|
||
t.tm_mon -= 1;
|
||
actor_data.create_time = (unsigned int)mktime(&t);
|
||
//GetRowInt(11, actor_data.updatetime);
|
||
GetRowInt(12, actor_data.last_online_time);
|
||
GetRowLInt(13, actor_data.last_login_ip);
|
||
GetRowInt(14, actor_data.bag_grid);
|
||
GetRowLInt(15, actor_data.gold);
|
||
GetRowLInt(16, actor_data.yuanbao);
|
||
GetRowLInt(17, actor_data.total_power);
|
||
GetRowInt(18, actor_data.recharge);
|
||
GetRowInt(19, actor_data.paid);
|
||
GetRowLInt(20, actor_data.fb_uid);
|
||
GetRowInt(21, actor_data.fb_scene_id);
|
||
GetRowInt(22, actor_data.total_online);
|
||
GetRowInt(23, actor_data.daily_online);
|
||
GetRowInt(24, actor_data.chapter_level);
|
||
GetRowInt(25, actor_data.vip_level);
|
||
GetRowInt(26, actor_data.essence);
|
||
GetRowInt(27, actor_data.zhuansheng_lv);
|
||
GetRowInt(28, actor_data.zhuansheng_exp);
|
||
GetRowUChar(29, actor_data.monthcard);
|
||
GetRowInt(30, actor_data.tianti_level);
|
||
GetRowInt(31, actor_data.tianti_dan);
|
||
GetRowInt(32, actor_data.tianti_win_count);
|
||
GetRowInt(33, actor_data.tianti_week_refres);
|
||
|
||
|
||
GetRowLInt(34, actor_data.total_wing_power);
|
||
GetRowLInt(35, actor_data.warrior_power);
|
||
GetRowLInt(36, actor_data.mage_power);
|
||
GetRowLInt(37, actor_data.taoistpriest_power);
|
||
GetRowInt(38, actor_data.train_level);
|
||
GetRowInt(39, actor_data.train_exp);
|
||
GetRowInt(40, actor_data.total_stone_level);
|
||
|
||
GetRowInt(41, actor_data.guild_id_);
|
||
|
||
GetRowInt(42, actor_data.zhan_ling_star);
|
||
GetRowInt(43, actor_data.zhan_ling_stage);
|
||
GetRowInt(44, actor_data.total_loongsoul_level);
|
||
GetRowLInt(45, actor_data.feats);
|
||
GetRowData(46, actor_data.ex_ring_lv);
|
||
GetRowLInt(47, actor_data.shatter);
|
||
GetRowLInt(48, actor_data.spcshatter);
|
||
GetRowInt(49, actor_data.knighthood_lv);
|
||
GetRowLInt(50, actor_data.togeatter);
|
||
GetRowLInt(51, actor_data.rank_power);
|
||
GetRowInt(52, actor_data.total_wing_lv);
|
||
GetRowLInt(53, actor_data.total_tujian_power);
|
||
GetRowLInt(54, actor_data.total_equip_power);
|
||
GetRowLInt(55, actor_data.togeatterhigh);
|
||
GetRowInt(56, actor_data.total_zhuling_level);
|
||
GetRowInt(57, actor_data.prestige_exp);
|
||
GetRowInt(58, actor_data.reincarnate_lv);
|
||
GetRowInt(59, actor_data.reincarnate_exp);
|
||
GetRowLInt(60, actor_data.dianquan);
|
||
GetRowInt(61, actor_data.quota);
|
||
//中间有两个 appid和pfid
|
||
GetRowString(64, actor_data.guild_name_);
|
||
}
|
||
|
||
|
||
#endif
|
||
|
||
/*
|
||
//这个是（以前斩仙）和db通信的包
|
||
typedef struct tagActorDbData:
|
||
ActorProperty
|
||
{
|
||
ACTORNAME name; //名字
|
||
unsigned nFbHandle; //副本的句柄，如果是0表示是普通的场景
|
||
unsigned nScenceID; //场景id
|
||
unsigned nEnterFbScenceID;
|
||
int nEnterFbPos; //X 和y放在了一起
|
||
|
||
unsigned int nCreateTime; //创建的时间
|
||
unsigned long long lLastLoginIp ;//上次登录的ip,还没支持
|
||
unsigned int nLastLogoutTime; //上次的下线时间,这个表示上次在逻辑服务器的下线时间,minidate格式
|
||
unsigned int nFbTeamId; // 个人积分(无用)
|
||
ACCOUNT accountName; //账户名字
|
||
|
||
unsigned int achieveTime; //成就达成时间
|
||
|
||
unsigned int nAccountId; //账户的ID
|
||
|
||
int64_t csrevivepoint; //普通场景的复活点，是场景id,x,y的组合
|
||
int64_t fbrevivepoint; //副本场景的复活点，是场景id,x,y的组合
|
||
int64_t cityrevivepoint; //城镇的复活点，是场景id,x,y的组合
|
||
int free_baptize_; // 免费洗炼的次数
|
||
int one_key_time_; // 剩余一键征友的次数
|
||
int mount_score_; // 坐骑评分
|
||
int friend_cong_; // 好友祝贺的数据
|
||
int reserve_data_; // 保留字段数据，可使用
|
||
unsigned int spirit_score_; //玩家的精灵的总分
|
||
int lianfuTeamId; //连服队伍id
|
||
// 跨服数据
|
||
unsigned long long cw_fbhdl_sid_; // 跨服战的位置信息,低4位是fuben的handle，高4位是战斗服的sid
|
||
unsigned long long cw_scene_xy_; // 跨服战的位置信息,低4位是场景id，高4位中的低高两位分别是x，y
|
||
unsigned long long cw_static_pos_; // 进入副本前，在普通场景的位置，低4位是场景id，高4位中的低高两位分别是x，y
|
||
|
||
int war_team_id_; // 战队ID
|
||
int cross_honor_; // 跨服荣誉值
|
||
unsigned int upgrade_time_; //玩家等级升级的时间
|
||
|
||
unsigned int total_online_; //总的在线时长
|
||
unsigned int daily_online_; //单日在线时长
|
||
|
||
char quest[1000]; //任务的数据
|
||
|
||
char mis_for_php_[128]; //供后台查询的一些数据
|
||
|
||
tagActorDbData()
|
||
{
|
||
memset(this, 0, sizeof(tagActorDbData));
|
||
}
|
||
} ACTORDBDATA, *PACTORDBDATA;
|
||
*/
|