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);
}
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));
}
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 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);
}
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 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 DBAsynAlterUserItem(DBActiveWrapper db, string command)
{
return(db.SqlExecNonQuery(command));
}
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 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));
}
