private ErrorCode DBAsynQueryUserCallBack(GBuffer buffer, DBActiveWrapper db)
{
CSToDB.QueryUserReq msg = new CSToDB.QueryUserReq();
msg.MergeFrom(buffer.GetBuffer(), 0, ( int )buffer.length);
GCToCS.Login login = new GCToCS.Login();
login.MergeFrom(ByteString.CopyFromUtf8(msg.Logininfo));
UserDBData userDbData = new UserDBData();
userDbData.usrDBData.un64ObjIdx = ( ulong )msg.Objid;
userDbData.usrDBData.userPlatform = ( UserPlatform )login.Sdk;
DBToCS.QueryUser queryUser = new DBToCS.QueryUser();
this.DBAsynQueryUser(userDbData, queryUser, db);
using (MemoryStream ms = new MemoryStream())
{
Serializer.Serialize(ms, userDbData.usrDBData);
queryUser.Db = Encoding.UTF8.GetString(ms.GetBuffer(), 0, ( int )ms.Length);
queryUser.Login = msg.Logininfo;
queryUser.Gcnetid = msg.Gcnetid;
queryUser.Gsid = msg.Gsid;
queryUser.Nickname = userDbData.szNickName;
}
CS.instance.userMgr.EncodeAndSendToLogicThread(queryUser, ( int )DBToCS.MsgID.EQueryUserDbcallBack);
return(ErrorCode.Success);
}
private ErrorCode DBAsynInsertNoticeCall(GBuffer buffer, DBActiveWrapper db)
{
CSToDB.InsertNotice msg = new CSToDB.InsertNotice();
msg.MergeFrom(buffer.GetBuffer(), 0, ( int )buffer.length);
return(db.SqlExecNonQuery(msg.SqlStr));
}
private ErrorCode DBAsynAlterSNSList(GBuffer buffer, DBActiveWrapper db)
{
CSToDB.AlterSNSList msg = new CSToDB.AlterSNSList();
msg.MergeFrom(buffer.GetBuffer(), 0, ( int )buffer.length);
return(this.AlterUserSNSList(db, msg.UserId, msg.RelatedId, ( RelationShip )msg.Related, ( DBOperation )msg.Opration));
}
private ErrorCode DBAsyAlterItemCallBack(GBuffer buffer, DBActiveWrapper db)
{
CSToDB.AlterItem msg = new CSToDB.AlterItem();
msg.MergeFrom(buffer.GetBuffer(), 0, ( int )buffer.length);
return(this.DBAsynAlterUserItem(db, msg.SqlStr));
}
private ErrorCode AlterUserSNSList(DBActiveWrapper db, ulong askerGuid, ulong relatedID, RelationShip rsType, DBOperation opType)
{
if (DBOperation.Add == opType)
{
Logger.Info($"add user:{askerGuid} to user:{relatedID} SNS as type:{rsType}");
ErrorCode errorCode = db.SqlExecNonQuery($"insert into gameuser_sns(user_id,related_id,relation) values({askerGuid},{relatedID},{rsType});");
if (errorCode != ErrorCode.Success)
{
return(errorCode);
}
Logger.Log($"user:{askerGuid} add user:{relatedID} to SNS List as type:{rsType}");
}
else
{
Logger.Info($"remove user:{relatedID} from user:{askerGuid} SNS as type:{rsType}");
ErrorCode errorCode = db.SqlExecNonQuery($"delete from gameuser_sns where user_id={askerGuid} and related_id={relatedID};");
if (errorCode != ErrorCode.Success)
{
return(errorCode);
}
if (rsType == RelationShip.Friends)
{
Logger.Info($"remove user:{askerGuid} from user:{relatedID} SNS as type:{rsType}");
errorCode = db.SqlExecNonQuery($"delete from gameuser_sns where user_id={relatedID} and related_id={askerGuid};");
if (errorCode != ErrorCode.Success)
{
return(errorCode);
}
}
}
return(ErrorCode.Success);
}
/// <summary>
/// 异步方式储存玩家数据
/// </summary>
private void UserCacheDBAsynHandler(GBuffer buffer)
{
DBActiveWrapper db = this.GetDBSource(buffer.actorID);
CSToDB.MsgID msgID = (CSToDB.MsgID)buffer.data;
switch (msgID)
{
case CSToDB.MsgID.EUpdateUserDbcallBack:
this.DBAsynUpdateUserCallback(buffer, db);
break;
case CSToDB.MsgID.EAlterSnslistDbcall:
this.DBAsynAlterSNSList(buffer, db);
break;
case CSToDB.MsgID.EAlterItemDbcall:
this.DBAsyAlterItemCallBack(buffer, db);
break;
case CSToDB.MsgID.EInsertNoticeDbcall:
this.DBAsynInsertNoticeCall(buffer, db);
break;
default:
Logger.Error("unknown msg");
break;
}
}
private ErrorCode DBAsynQueryNoticeCallBack(DBActiveWrapper db)
{
ErrorCode errorCode = db.SqlExecQuery("select * from notice;", dataReader =>
{
DBToCS.QueryNotice notice = new DBToCS.QueryNotice();
while (dataReader.Read())
{
DBToCS.QueryNotice.Types.Notice info =
new DBToCS.QueryNotice.Types.Notice
{
Id = dataReader.GetUInt32("id"),
Platform = dataReader.GetUInt32("platform_id"),
Title = dataReader.GetString("title"),
Eflag = dataReader.GetInt32("eflag"),
Estate = dataReader.GetInt32("estate"),
Priority = dataReader.GetInt32("priority"),
Notice_ = dataReader.GetString("notice"),
StarTime = dataReader.GetUInt64("star_time"),
EndTime = dataReader.GetUInt64("end_time")
};
notice.NoticeInfo.Add(info);
}
CS.instance.userMgr.EncodeAndSendToLogicThread(notice, ( int )DBToCS.MsgID.EQueryNoticeCallBack);
return(ErrorCode.Success);
});
return(errorCode);
}
private ErrorCode DBAsynUpdateGameMail(GBuffer buffer, DBActiveWrapper db)
{
CSToDB.UpdateGameMail pMsg = new CSToDB.UpdateGameMail();
pMsg.MergeFrom(buffer.GetBuffer(), 0, ( int )buffer.length);
int total = pMsg.Maillist.Count;
if (total <= 0)
{
return(ErrorCode.Success);
}
string[] sqlStrs = new string[3];
sqlStrs[0] = "begin; set autocommit=0;";
for (int i = 0; i < total; i++)
{
CSToDB.GameMailInfo mail = pMsg.Maillist[i];
if (mail.Curtstate == CSToDB.EMailCurtState.EMailStateDel)
{
sqlStrs[1] = $"update game_mail set mail_del_state ={mail.Curtstate} where mail_id={mail.MailId};";
}
else if (mail.Curtstate == CSToDB.EMailCurtState.EMailStateNew)
{
sqlStrs[1] =
$"insert into game_mail(mail_id,mail_sdk,mail_type,mail_user_id,mail_title,mail_content,mail_gift,mail_send,mail_create_time,mail_over_time,mail_del_state) values({mail.MailId},{mail.Sdkidx},{mail.Type},{mail.Userid},\'{mail.Title}\',\'{mail.Content}\',\'{mail.Giftstr}\',\'{mail.Sender}\',\'{mail.Createtime}\',\'{mail.Overtime}\',{mail.Curtstate});";
}
}
sqlStrs[2] = "commit;";
return(db.SqlExecNonQuery(sqlStrs));
}
public CSUserMgr()
{
this.today = new DateTime();
DBCfg cfgGameDB = CS.instance.csCfg.GetDBCfg(DBType.Game);
DBCfg cfgCdkeyDB = CS.instance.csCfg.GetDBCfg(DBType.Cdkey);
//第一个参数是更新玩家数据的方法,这是一个异步回调,通常由别的线程投递更新请求
//此实例会开启一个线程专门消费这些更新请求
//第三个参数是当这个线程开启时的回调函数,也是一个异步回调,这个回调只会执行一次,也就是服务器开启的时候
//具体该方法是处理什么消息,以后继续探讨
this._userCacheDBActiveWrapper = new DBActiveWrapper(this.UserCacheDBAsynHandler, cfgGameDB, this.DBAsynQueryWhenThreadBegin);
this._userCacheDBActiveWrapper.Start();
//服务端启动就开启一个线程查询玩家数据
this._cdkeyWrapper = new DBActiveWrapper(this.UserAskDBAsynHandler, cfgCdkeyDB, this.CDKThreadBeginCallback);
this._cdkeyWrapper.Start();
for (int i = 0; i < G_THREAD; i++)
{
DBActiveWrapper threadDBWrapper = new DBActiveWrapper(this.UserAskDBAsynHandler, cfgGameDB, null);
threadDBWrapper.Start();
this._userAskDBActiveWrappers.Add(threadDBWrapper);
}
this.gcMsgHandlers[( int )GCToCS.MsgNum.EMsgToGstoCsfromGcAskComleteUserInfo] = this.OnMsgToGstoCsfromGcAskComleteUserInfo;
this.gcMsgHandlers[( int )GCToCS.MsgNum.EMsgToGstoCsfromGcAskLogin] = this.OnMsgToGstoCsfromGcAskLogin;
this.gcMsgHandlers[( int )GCToCS.MsgNum.EMsgToGstoCsfromGcAskReconnectGame] = this.OnMsgToGstoCsfromGcAskReconnectGame;
this.gcMsgHandlers[( int )GCToCS.MsgNum.EMsgToGstoCsfromGcAskChangeNickName] = this.OnMsgToGstoCsfromGcAskChangeNickName;
this.gcMsgHandlers[( int )GCToCS.MsgNum.EMsgToGstoCsfromGcAskChangeheaderId] = this.OnMsgToGstoCsfromGcAskChangeheaderId;
}
private ErrorCode DBAsynChangeNickNameCallBack(GBuffer buffer, DBActiveWrapper db)
{
CSToDB.ChangeNickName sChangeNickName = new CSToDB.ChangeNickName();
sChangeNickName.MergeFrom(buffer.GetBuffer(), 0, ( int )buffer.length);
string mystream =
$"update account_user set user_name=\'{sChangeNickName.Nickname}\' where id={sChangeNickName.Guid};";
ErrorCode errorCode = db.SqlExecNonQuery(mystream);
return(errorCode);
}
/// <summary>
/// 把消息编码并投递到处理队列(异步生产,同步消费)
/// </summary>
private ErrorCode EncodeAndSendToLogicThread(IMessage msg, int msgID)
{
GBuffer buffer = this._dbCallbackQueuePool.Pop();
ErrorCode errorCode = DBActiveWrapper.EncodeProtoMsgToBuffer(msg, msgID, buffer);
if (errorCode != ErrorCode.Success)
{
this._dbCallbackQueuePool.Push(buffer);
return(ErrorCode.EncodeMsgToBufferFailed);
}
this._dbCallbackQueue.Push(buffer);
return(ErrorCode.Success);
}
private ErrorCode DBAsynQueryGameMailList(DBActiveWrapper db, long objIdx)
{
string sqlStr = "select * from game_mail where mail_del_state<> " + MailCurtState.Del;
if (objIdx > 0)
{
sqlStr += " and mail_user_id = " + objIdx;
}
else
{
sqlStr += " and (mail_user_id is NULL or mail_user_id < 1) ";
}
sqlStr += " and unix_timestamp(mail_over_time ) > unix_timestamp(NOW()) order by mail_id DESC;";
ErrorCode errorCode = db.SqlExecQuery(sqlStr, dataReader =>
{
while (dataReader.Read())
{
MailDBData mailDb = new MailDBData
{
mailId = dataReader.GetInt32("mail_id"),
mailType = ( MailType )dataReader.GetInt32("mail_type"),
channelId = dataReader.GetInt32("mail_sdk"),
mailTitle = dataReader.GetString("mail_title"),
mailContent = dataReader.GetString("mail_content"),
mailGift = dataReader.GetString("mail_gift"),
szSender = dataReader.GetString("mail_send"),
mCreateTime = dataReader.GetString("mail_create_time"),
mEndTime = dataReader.GetString("mail_over_time")
};
mailDb.objIdx = objIdx > 0 ? objIdx : mailDb.objIdx;
DBToCS.MailCallBack pMsg = new DBToCS.MailCallBack
{
Mailid = mailDb.mailId,
Mailtype = ( int )mailDb.mailType,
Channel = mailDb.channelId,
Title = mailDb.mailTitle,
Content = mailDb.mailContent,
Gift = mailDb.mailGift,
Sender = mailDb.szSender,
Createtime = mailDb.mCreateTime,
Objid = mailDb.objIdx
};
CS.instance.userMgr.EncodeAndSendToLogicThread(pMsg, ( int )DBToCS.MsgID.EMailCallBack);
}
return(ErrorCode.Success);
});
return(errorCode);
}
private ErrorCode DBAsynUpdateUserCallback(GBuffer buffer, DBActiveWrapper db)
{
CSToDB.UpdateUser msg = new CSToDB.UpdateUser();
msg.MergeFrom(buffer.GetBuffer(), 0, ( int )buffer.length);
ErrorCode errorCode = db.SqlExecNonQuery(new[] { "begin;set autocommit=0;", msg.Sqlstr, "commit;" });
if (errorCode != ErrorCode.Success)
{
return(errorCode);
}
Logger.Log($"udate user {msg.Guid} to db");
return(ErrorCode.Success);
}
private ErrorCode DBAsynQueryUserSNSList(DBActiveWrapper db, ulong un64ObjIdx, Dictionary <ulong, uint> t_map)
{
string sqlStr = $"select * from gameuser_sns where user_id={un64ObjIdx};";
ErrorCode errorCode = db.SqlExecQuery(sqlStr, dataReader =>
{
while (dataReader.Read())
{
t_map[dataReader.GetUInt64("related_id")] = dataReader.GetUInt32("relation");
}
return(ErrorCode.Success);
});
return(errorCode);
}
private ErrorCode DBAsynQueryUserHeaderAndNickname(DBActiveWrapper db, ulong un64ObjIdx, DBToCS.RSinfo rs_info)
{
string sqlStr = $"select obj_name,obj_headid,obj_vip_lv from gameuser where obj_id={un64ObjIdx};";
ErrorCode errorCode = db.SqlExecQuery(sqlStr, dataReader =>
{
if (dataReader.Read())
{
rs_info.RelatedName = dataReader.GetString("obj_name");
rs_info.RelatedHeader = dataReader.GetUInt32("obj_headid");
rs_info.RelatedVip = dataReader.GetUInt32("obj_vip_lv");
}
return(ErrorCode.Success);
});
return(errorCode);
}
/// <summary>
/// 异步查询/更新玩家数据
/// </summary>
private void UserAskDBAsynHandler(GBuffer buffer)
{
DBActiveWrapper db = this.GetDBSource(buffer.actorID);
CSToDB.MsgID msgID = (CSToDB.MsgID)buffer.data;
switch (msgID)
{
case CSToDB.MsgID.EQueryUserDbcallBack:
this.DBAsynQueryUserCallBack(buffer, db);
break;
case CSToDB.MsgID.EUpdateGameMailDbcallBack:
this.DBAsynUpdateGameMail(buffer, db);
break;
case CSToDB.MsgID.EChangeNickNameDbcall:
this.DBAsynChangeNickNameCallBack(buffer, db);
break;
case CSToDB.MsgID.EExeSqlCall:
this.DBAsynExeSQL(buffer, db);
break;
case CSToDB.MsgID.EInsertCdkeyEvents:
this.InsertCDKeyEvent(buffer, db);
break;
case CSToDB.MsgID.EUpdateUserGameMailDbcallBack:
this.DBAsynUpdateUserGameMail(buffer, db);
break;
case CSToDB.MsgID.EUpdateCdkeyInfo:
this.UpdateCDKey(buffer, db);
break;
case CSToDB.MsgID.EInsertCdkeyInfo:
this.InsertCDKey(buffer, db);
break;
default:
Logger.Error("unknown msg");
break;
}
}
private ErrorCode GetUserHeros(DBActiveWrapper db, ulong un64ObjIdx, DBToCS.QueryUser sQueryUser)
{
string sqlStr = $"select hero_id,hero_end_time,hero_buy_time from gameuser_hero where user_id={un64ObjIdx};";
ErrorCode errorCode = db.SqlExecQuery(sqlStr, dataReader =>
{
while (dataReader.Read())
{
DBToCS.HeroCfg heroDB = new DBToCS.HeroCfg
{
Buytime = dataReader.GetInt64("hero_buy_time"),
Expiredtime = dataReader.GetInt64("hero_end_time"),
Commodityid = dataReader.GetUInt32("hero_id")
};
sQueryUser.Herocfg.Add(heroDB);
}
return(ErrorCode.Success);
});
return(errorCode);
}
private ErrorCode DBAsynQueryUserItems(DBActiveWrapper db, ulong user_id, DBToCS.QueryUser sQueryUser)
{
string sqlStr = $"select * from gameuser_item where user_id={user_id};";
ErrorCode errorCode = db.SqlExecQuery(sqlStr, dataReader =>
{
while (dataReader.Read())
{
DBToCS.ItemInfo item_info = new DBToCS.ItemInfo
{
ItemId = dataReader.GetInt32("item_id"),
ItemNum = dataReader.GetUInt32("item_num"),
BuyTime = dataReader.GetInt32("buy_time"),
EndTime = dataReader.GetInt32("end_time")
};
sQueryUser.ItemInfo.Add(item_info);
}
return(ErrorCode.Success);
});
return(errorCode);
}
private ErrorCode GetUserShortGiftMail(DBActiveWrapper db, UserDBData sUserData, DBToCS.QueryUser sQueryUser)
{
string sqlStr =
$"select mail_id,mail_state from gameuser_mail where user_id = {sUserData.usrDBData.un64ObjIdx} order by mail_id DESC;";
ErrorCode errorCode = db.SqlExecQuery(sqlStr, dataReader =>
{
while (dataReader.Read())
{
DBToCS.MailInfo mailInfo = new DBToCS.MailInfo
{
Mailid = dataReader.GetInt32("mail_id"),
State = dataReader.GetInt32("mail_state")
};
sQueryUser.MailInfo.Add(mailInfo);
}
this.DBAsynQueryGameMailList(db, sUserData.usrDBData.un64ObjIdx);
return(ErrorCode.Success);
});
return(errorCode);
}
private ErrorCode DBAsynUpdateUserGameMail(GBuffer buffer, DBActiveWrapper db)
{
CSToDB.UpdateUserMail pMsg = new CSToDB.UpdateUserMail();
pMsg.MergeFrom(buffer.GetBuffer(), 0, ( int )buffer.length);
string sqlStr = $"select id from gameuser_mail where mail_id={pMsg.Mailid} and user_id={pMsg.Objid};";
int ntotal = 0;
ErrorCode errorCode = db.SqlExecQuery(sqlStr, dataReader =>
{
ntotal = dataReader.GetInt32("id");
return(ErrorCode.Success);
});
if (errorCode != ErrorCode.Success)
{
return(errorCode);
}
sqlStr = ntotal > 0
? $"update gameuser_mail set mail_state={pMsg.Cstate} where mail_id={pMsg.Mailid} and user_id={pMsg.Objid};"
: $"insert into gameuser_mail (mail_id,user_id, mail_state) values({pMsg.Mailid},{pMsg.Objid},{pMsg.Cstate});";
errorCode = db.SqlExecNonQuery(sqlStr);
return(errorCode);
}
private ErrorCode DBAsynQueryUser(UserDBData userData, DBToCS.QueryUser queryUser, DBActiveWrapper db)
{
string sqlStr =
$"select * from gameuser, gameuser_runne,gameuser_guide where gameuser.obj_id = {userData.usrDBData.un64ObjIdx} and " +
$"gameuser_runne.user_id ={userData.usrDBData.un64ObjIdx} and gameuser_guide.obj_id = {userData.usrDBData.un64ObjIdx};";
ErrorCode errorCode = db.SqlExecQuery(sqlStr, dataReader =>
{
if (!dataReader.Read())
{
Logger.Warn("could not find user data");
return(ErrorCode.UserDataNotFound);
}
userData.szNickName = dataReader.GetString("obj_name");
userData.usrDBData.n16Sex = dataReader.GetInt16("obj_sex");
userData.usrDBData.userPlatform = ( UserPlatform )dataReader.GetInt32("sdk_id");
userData.usrDBData.un16HeaderID = dataReader.GetUInt16("obj_headid");
userData.usrDBData.n64Score = dataReader.GetInt64("obj_score");
userData.usrDBData.n64Diamond = dataReader.GetInt64("obj_diamond");
userData.usrDBData.n64Gold = dataReader.GetInt64("obj_gold");
userData.usrDBData.un32TotalGameInns = dataReader.GetUInt32("obj_game_inns");
userData.usrDBData.un32TotalWinInns = dataReader.GetUInt32("obj_game_winns");
userData.usrDBData.un32TotalHeroKills = dataReader.GetUInt32("obj_kill_hero_num");
userData.usrDBData.un32TotalAssist = dataReader.GetUInt32("obj_ass_kill_num");
userData.usrDBData.un32TotalDestoryBuildings = dataReader.GetUInt32("obj_dest_building_num");
userData.usrDBData.un32TotalDeadTimes = dataReader.GetUInt32("obj_dead_num");
userData.usrDBData.un32UserCurLvExp = dataReader.GetUInt32("obj_cur_lv_exp");
userData.usrDBData.un8UserLv = dataReader.GetByte("obj_lv");
userData.usrDBData.un16Cldays = dataReader.GetUInt16("obj_cldays");
userData.usrDBData.un16VipLv = dataReader.GetInt16("obj_vip_lv");
userData.usrDBData.un32LastGetLoginRewardDay = dataReader.GetInt32("obj_last_loginreward_time");
userData.usrDBData.tRegisteUTCMillisec = dataReader.GetInt64("obj_register_time");
userData.szTaskData = dataReader.GetString("obj_task_data");
queryUser.TaskData = userData.szTaskData;
DBToCS.RuneInfo runedB = new DBToCS.RuneInfo
{
SlotStr = dataReader.GetString("runeslot_json"),
BagStr = dataReader.GetString("runnebag_json")
};
queryUser.Runeinfo.Add(runedB);
queryUser.Guidestr = dataReader.GetString("obj_cs_guide_com_steps");
return(ErrorCode.Success);
});
if (errorCode != ErrorCode.Success)
{
return(errorCode);
}
errorCode = this.GetUserHeros(db, userData.usrDBData.un64ObjIdx, queryUser);
if (errorCode != ErrorCode.Success)
{
return(errorCode);
}
Dictionary <ulong, uint> t_map = new Dictionary <ulong, uint>();
errorCode = this.DBAsynQueryUserSNSList(db, userData.usrDBData.un64ObjIdx, t_map);
if (errorCode == ErrorCode.Success)
{
foreach (KeyValuePair <ulong, uint> kv in t_map)
{
DBToCS.RSinfo info = new DBToCS.RSinfo
{
RelatedId = kv.Key,
Relation = kv.Value
};
queryUser.Rsinfo.Add(info);
this.DBAsynQueryUserHeaderAndNickname(db, kv.Value, info);
}
}
else
{
Logger.Error($"DBAsynQueryUserSNSList error:{errorCode}");
}
errorCode = this.DBAsynQueryUserItems(db, userData.usrDBData.un64ObjIdx, queryUser);
if (errorCode != ErrorCode.Success)
{
Logger.Error($"DBAsynQueryUserItems error:{errorCode}");
}
errorCode = this.GetUserShortGiftMail(db, userData, queryUser);
if (errorCode != ErrorCode.Success)
{
Logger.Error($"GetUserShortGiftMail error:{errorCode}");
}
return(errorCode);
}
private ErrorCode DBAsynExeSQL(GBuffer buffer, DBActiveWrapper db)
{
CSToDB.ExeSQL_Call sMsg = new CSToDB.ExeSQL_Call();
sMsg.MergeFrom(buffer.GetBuffer(), 0, ( int )buffer.length);
return(db.SqlExecNonQuery(sMsg.Sql));
}
private ErrorCode InsertCDKey(GBuffer buffer, DBActiveWrapper db)
{
CSToDB.InsertCDKeyInfo sMsg = new CSToDB.InsertCDKeyInfo();
sMsg.MergeFrom(buffer.GetBuffer(), 0, ( int )buffer.length);
return(db.SqlExecNonQuery(sMsg.SqlStr));
}
private ErrorCode DBAsynAlterUserItem(DBActiveWrapper db, string command)
{
return(db.SqlExecNonQuery(command));
}
