/// <summary>
/// 查询角色信息
/// </summary>
/// <param name="info"></param>
/// <param name="callback"></param>
public static void QueryCharacterInfo(long char_idx, PlayerInfoForGL data, Action <bool> callback)
{
bool ret = false;
string sql = "call SP_CHARACTER_BASE(" + char_idx + ")";
DBManager.Instance.GetDB(eDBType.Center).Query(sql, (reader) =>
{
if (reader.HasRows && reader.Read())
{
int idx = 0;
data.char_idx = char_idx;
data.char_name = reader.GetString(idx++);
data.char_type = reader.GetByte(idx++);
data.spid = reader.GetUInt16(idx++);
data.ws_id = reader.GetUInt16(idx++);
data.scene_type_idx = reader.GetUInt32(idx++);
data.flags = reader.GetUInt32(idx++);
data.model_idx = reader.GetUInt32(idx++);
data.job = reader.GetByte(idx++);
data.level = reader.GetUInt16(idx++);
data.exp = reader.GetUInt32(idx++);
data.gold = reader.GetUInt32(idx++);
data.coin = reader.GetUInt32(idx++);
data.vip_grade = reader.GetUInt32(idx++);
ret = true;
}
else
{
Log.Warning("查询角色失败:" + char_idx);
}
callback(ret);
});
}
/// <summary>
/// 同步好友最新数据：玩家上线时触发
/// </summary>
public void SyncDataFromUnit()
{
foreach (var obj in m_relations)
{
RelationInfo info = obj.Value;
Unit unit = UnitManager.Instance.GetUnitByIdx(info.char_idx);
if (unit == null)
{//取db离线数据
long target_char_idx = info.char_idx;
PlayerInfoForGL data = CommonObjectPools.Spawn <PlayerInfoForGL>();
SQLCharHandle.QueryCharacterInfo(target_char_idx, data, (ret) =>
{
if (ret)
{
RelationInfo db_info;
if (m_relations.TryGetValue(target_char_idx, out db_info))
{
db_info.Copy(data);
}
}
CommonObjectPools.Despawn(data);
this.SyncRelation2SS(target_char_idx);
});
}
else
{
info.Copy(unit.player_data);
this.SyncRelation2SS(info.char_idx);
}
}
}
/// <summary>
/// 登入处理
/// </summary>
public void HandleLogin(ushort ss_uid, PlayerInfoForGL data)
{
Unit unit = GetUnitByIdx(data.char_idx);
if (unit != null)
{
this.RemoveUnit(unit);
}
//创建玩家
unit = CommonObjectPools.Spawn <Unit>();
unit.Setup(ss_uid, data);
UnitManager.Instance.AddUnit(unit);
unit.OnEnter();
}
public void Copy(PlayerInfoForGL info)
{
char_idx = info.char_idx;
spid = info.spid;
char_name = info.char_name;
char_type = info.char_type;
ws_id = info.ws_id;
//flags = eRelationFlag.Invalid;
model_idx = info.model_idx;
job = info.job;
level = info.level;
exp = info.exp;
gold = info.gold;
coin = info.coin;
vip_grade = info.vip_grade;
}
public uint vip_grade; // vip等级
public void Copy(PlayerInfoForGL info)
{
char_idx = info.char_idx;
char_name = info.char_name;
char_type = info.char_type;
spid = info.spid;
ws_id = info.ws_id;
scene_type_idx = info.scene_type_idx;
flags = info.flags;
model_idx = info.model_idx;
job = info.job;
level = info.level;
exp = info.exp;
gold = info.gold;
coin = info.coin;
vip_grade = info.vip_grade;
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="info"></param>
public static void SaveCharacterInfo(PlayerInfoForGL info)
{
string sql = ("replace into `character` (`char_index`,`char_name`,`char_type`,`spid`,`ws_id`,`scene_type_idx`,`flags`,`model_idx`,`job`,`level`,`exp`,`gold`,`coin`,`vip_grade`,`time_last_logout`) values(" +
info.char_idx + ",'" +
info.char_name + "'," + // 名字
info.char_type + "," + // 角色类型(男 or 女 )
info.spid + "," + //
info.ws_id + "," + //
info.scene_type_idx + "," +
info.flags + "," + // 特殊标记
info.model_idx + "," + // 模型ID
info.job + "," + // 职业
info.level + "," + // 角色等级
info.exp + "," + // 当前经验
info.gold + "," + // 金币（点卷）
info.coin + "," + // 游戏币(铜币)
info.vip_grade + "," +
"now());"
);
DBManager.Instance.GetDB(eDBType.Center).Execute(sql);
}
public void Setup(ushort uid, PlayerInfoForGL info)
{
m_char_idx = info.char_idx;
m_ss_srv_uid = uid;
m_player_data.Copy(info);
}
/// <summary>
/// 处理关系事件
/// </summary>
private void HandleRelationEvent(List <RelationEventInfo> list_event)
{
//查询过程中如果下线
if (m_char_idx == 0)
{
return;
}
Unit player = UnitManager.Instance.GetUnitByIdx(m_char_idx);
if (player == null)
{
return;
}
foreach (var relation_evt in list_event)
{
switch (relation_evt.event_type)
{
case eRelationEvent.Add: //对方申请加你好友
{
//超过上限
if (IsRelationFull(relation_evt.bin_content.bin_add_content.flag))
{
//清除处理过的事件
SQLRelationHandle.RemoveRelationEvent(relation_evt.event_idx);
continue;
}
//是否已经存在相同关系
RelationInfo relation_info = null;
if (m_relations.TryGetValue(relation_evt.source_char_idx, out relation_info) && relation_info.flags == relation_evt.bin_content.bin_add_content.flag)
{
//清除处理过的事件
SQLRelationHandle.RemoveRelationEvent(relation_evt.event_idx);
continue;
}
//拉黑不需要同意，所以不添加事件
if (relation_evt.bin_content.bin_add_content.flag == eRelationFlag.Block)
{
if (m_relations.TryGetValue(relation_evt.source_char_idx, out relation_info))
{ //已经存在其他关系，则用新关系覆盖旧关系
relation_info.flags = eRelationFlag.Block;
this.SyncRelation2SS(relation_evt.source_char_idx);
}
else
{
Unit target_player = UnitManager.Instance.GetUnitByIdx(relation_evt.source_char_idx);
if (target_player == null)
{
PlayerInfoForGL data = CommonObjectPools.Spawn <PlayerInfoForGL>();
SQLCharHandle.QueryCharacterInfo(relation_evt.source_char_idx, data, (ret) =>
{
if (ret && m_char_idx > 0)
{
relation_info = CommonObjectPools.Spawn <RelationInfo>();
relation_info.Copy(data);
relation_info.flags = eRelationFlag.Block;
this.AddRelation(relation_info);
this.SyncRelation2SS(relation_evt.source_char_idx);
}
CommonObjectPools.Despawn(data);
});
}
else
{
relation_info = CommonObjectPools.Spawn <RelationInfo>();
relation_info.Copy(target_player.player_data);
relation_info.flags = eRelationFlag.Block;
this.AddRelation(relation_info);
this.SyncRelation2SS(relation_evt.source_char_idx);
}
}
//清除处理过的事件
SQLRelationHandle.RemoveRelationEvent(relation_evt.event_idx);
m_relation_events.Remove(relation_evt.event_idx);
}
else
{
//添加关系事件
if (m_relation_events.ContainsKey(relation_evt.event_idx))
{
continue;
}
else
{
m_relation_events.Add(relation_evt.event_idx, relation_evt);
}
//通知逻辑服，由逻辑服转发给客户端
gl2ss.RelationAdd msg = PacketPools.Get(gl2ss.msg.RELATION_ADD) as gl2ss.RelationAdd;
msg.event_idx = relation_evt.event_idx;
msg.char_idx = m_char_idx;
msg.player_id.Set(relation_evt.source_char_idx, relation_evt.bin_content.bin_add_content.char_name);
msg.message = relation_evt.bin_content.bin_add_content.message;
msg.flag = relation_evt.bin_content.bin_add_content.flag;
ForServerNetManager.Instance.Send(player.ss_srv_uid, msg);
}
break;
}
case eRelationEvent.Delete: //对方删除了你
{
if (m_relations.ContainsKey(relation_evt.source_char_idx))
{
this.RemoveRelation(relation_evt.source_char_idx);
//通知逻辑服，由逻辑服转发给客户端
gl2ss.RelationRemove msg_remove = PacketPools.Get(gl2ss.msg.RELATION_REMOVE) as gl2ss.RelationRemove;
msg_remove.char_idx = m_char_idx;
msg_remove.target_idx = relation_evt.source_char_idx;
ForServerNetManager.Instance.Send(player.ss_srv_uid, msg_remove);
}
//清除处理过的事件
SQLRelationHandle.RemoveRelationEvent(relation_evt.event_idx);
m_relation_events.Remove(relation_evt.event_idx);
break;
}
case eRelationEvent.Agree: //对方同意了你的申请
{
if (relation_evt.bin_content.bin_agree_content.cmd == eRelationApplyCmd.Agree)
{
//如果对方在线，则取对方身上的数据；否则取数据库的数据
Unit target_player = UnitManager.Instance.GetUnitByIdx(relation_evt.source_char_idx);
if (target_player != null)
{
this.RemoveRelation(relation_evt.source_char_idx);
RelationInfo relation_info = CommonObjectPools.Spawn <RelationInfo>();
relation_info.Copy(target_player.player_data);
relation_info.flags = relation_evt.bin_content.bin_agree_content.flag;
this.AddRelation(relation_info);
this.SyncRelation2SS(relation_evt.source_char_idx);
//清除处理过的事件
SQLRelationHandle.RemoveRelationEvent(relation_evt.event_idx);
m_relation_events.Remove(relation_evt.event_idx);
}
else
{
PlayerInfoForGL data = CommonObjectPools.Spawn <PlayerInfoForGL>();
SQLCharHandle.QueryCharacterInfo(relation_evt.source_char_idx, data, (ret) =>
{
if (ret && m_char_idx > 0)
{
this.RemoveRelation(relation_evt.source_char_idx);
RelationInfo relation_info = CommonObjectPools.Spawn <RelationInfo>();
relation_info.Copy(data);
relation_info.flags = relation_evt.bin_content.bin_agree_content.flag;
this.AddRelation(relation_info);
this.SyncRelation2SS(relation_evt.source_char_idx);
}
CommonObjectPools.Despawn(data);
//清除处理过的事件
SQLRelationHandle.RemoveRelationEvent(relation_evt.event_idx);
m_relation_events.Remove(relation_evt.event_idx);
});
}
}
else
{
//清除处理过的事件
SQLRelationHandle.RemoveRelationEvent(relation_evt.event_idx);
m_relation_events.Remove(relation_evt.event_idx);
}
break;
}
case eRelationEvent.Give:
{
Log.Info("赠送 src:" + relation_evt.source_char_idx + " dst:" + relation_evt.target_char_idx);
RelationEventContent.GiveContent give_info = relation_evt.bin_content.bin_give_content;
//发给ss处理
if (item.IsValidItem(give_info.item_id))
{
gl2ss.RelationGive msg_give = PacketPools.Get(gl2ss.msg.RELATION_GIVE) as gl2ss.RelationGive;
msg_give.char_idx = m_char_idx;
msg_give.src_player_id.Set(relation_evt.source_char_idx, give_info.char_name);
msg_give.item_id = give_info.item_id;
ForServerNetManager.Instance.Send(player.ss_srv_uid, msg_give);
}
//清除处理过的事件
SQLRelationHandle.RemoveRelationEvent(relation_evt.event_idx);
m_relation_events.Remove(relation_evt.event_idx);
break;
}
}
}
}
/// <summary>
/// 申请反馈
/// </summary>
public void ApplyRelationCommand(long event_idx, long target_char_idx, eRelationApplyCmd cmd)
{
//是否存在申请事件
RelationEventInfo relation_evt;
if (!m_relation_events.TryGetValue(event_idx, out relation_evt))
{
return;
}
switch (relation_evt.event_type)
{
case eRelationEvent.Add:
{
eRelationFlag flag = relation_evt.bin_content.bin_add_content.flag;
if (cmd == eRelationApplyCmd.Agree)
{
//超过上限
if (IsRelationFull(flag))
{
SQLRelationHandle.RemoveRelationEvent(event_idx);
m_relation_events.Remove(event_idx);
return;
}
//是否已经存在相同关系：是则返回；非相同关系先移除，再添加
RelationInfo relation_info;
if (m_relations.TryGetValue(target_char_idx, out relation_info))
{
if (relation_info.flags == flag)
{
SQLRelationHandle.RemoveRelationEvent(event_idx);
m_relation_events.Remove(event_idx);
return;
}
else
{
this.RemoveRelation(target_char_idx);
}
}
//如果对方在线，则取对方身上的数据；否则取数据库的数据
Unit target_player = UnitManager.Instance.GetUnitByIdx(target_char_idx);
if (target_player != null)
{
relation_info = CommonObjectPools.Spawn <RelationInfo>();
relation_info.Copy(target_player.player_data);
relation_info.flags = flag;
this.AddRelation(relation_info);
this.SyncRelation2SS(target_char_idx);
}
else
{
PlayerInfoForGL data = CommonObjectPools.Spawn <PlayerInfoForGL>();
SQLCharHandle.QueryCharacterInfo(target_char_idx, data, (ret) =>
{
if (ret && m_char_idx > 0)
{
relation_info = CommonObjectPools.Spawn <RelationInfo>();
relation_info.Copy(data);
relation_info.flags = flag;
this.AddRelation(relation_info);
this.SyncRelation2SS(target_char_idx);
}
CommonObjectPools.Despawn(data);
});
}
}
else
{
//undo
}
//写入事件
RelationEventInfo e_info = new RelationEventInfo();
e_info.target_char_idx = target_char_idx;
e_info.source_char_idx = m_char_idx;
e_info.event_type = eRelationEvent.Agree;
e_info.bin_content.bin_agree_content.flag = flag;
e_info.bin_content.bin_agree_content.cmd = cmd;
SQLRelationHandle.InsertRelationEvent(e_info);
//立刻通知接受者
this.BroadcastEvent(e_info.target_char_idx, e_info.event_type);
}
break;
}
//清除处理过的事件
SQLRelationHandle.RemoveRelationEvent(event_idx);
//从事件列表移除
m_relation_events.Remove(event_idx);
}
/// <summary>
/// 添加关系
/// </summary>
public void AddRelationCommand(RelationAddTarget target_id, eRelationFlag flag, string message)
{
//超过上限
if (IsRelationFull(flag))
{
return;
}
//不在线了
Unit player = UnitManager.Instance.GetUnitByIdx(m_char_idx);
if (player == null)
{
return;
}
//判断是否已经存在关系，另外防止添加自己为好友
if (target_id.type == eRelationAddType.Idx)
{
if (target_id.char_idx == m_char_idx)
{
return;
}
RelationInfo relation_info;
if (m_relations.TryGetValue(target_id.char_idx, out relation_info) && relation_info.flags == flag)
{
return;
}
}
else
{
if (target_id.char_name == player.char_name)
{
return;
}
foreach (var relation_info in m_relations)
{
if (relation_info.Value.char_name == target_id.char_name && relation_info.Value.flags == flag)
{
return;
}
}
}
//如果是根据名称加好友，必须在缓存里面能查找到玩家数据
Unit target_player = null;
if (target_id.type == eRelationAddType.Idx)
{
target_player = UnitManager.Instance.GetUnitByIdx(target_id.char_idx);
}
else if (target_id.type == eRelationAddType.Name)
{
target_player = UnitManager.Instance.GetUnitByName(target_id.char_name);
if (target_player == null)
{
return;//TODO:后期如果有需求，可以查表
}
else
{
target_id.char_idx = target_player.char_idx;
}
}
//拉黑直接处理，如果有好友关系，需要先去掉好友
if (flag == eRelationFlag.Block)
{
RelationInfo relation_info;
if (m_relations.TryGetValue(target_id.char_idx, out relation_info))
{
relation_info.flags = eRelationFlag.Block;
this.SyncRelation2SS(target_id.char_idx);
}
else
{
if (target_player == null)
{
PlayerInfoForGL data = CommonObjectPools.Spawn <PlayerInfoForGL>();
SQLCharHandle.QueryCharacterInfo(target_id.char_idx, data, (ret) =>
{
if (ret && m_char_idx > 0)
{
relation_info = CommonObjectPools.Spawn <RelationInfo>();
relation_info.Copy(data);
relation_info.flags = flag;
this.AddRelation(relation_info);
this.SyncRelation2SS(target_id.char_idx);
}
CommonObjectPools.Despawn(data);
});
}
else
{
relation_info = CommonObjectPools.Spawn <RelationInfo>();
relation_info.Copy(target_player.player_data);
relation_info.flags = flag;
this.AddRelation(relation_info);
this.SyncRelation2SS(target_id.char_idx);
}
}
}
//添加到db,需要先判断数据库是否已经有写入过，防止重复写入
//注：如果赠送可以同时存在的话，这里需要屏蔽赠送类型
SQLRelationHandle.QueryExistsRelationEvent(m_char_idx, target_id.char_idx, flag, (event_idx) =>
{
if (event_idx == 0 && m_char_idx > 0)
{//保存事件
RelationEventInfo e_info = new RelationEventInfo();
e_info.target_char_idx = target_id.char_idx;
e_info.source_char_idx = m_char_idx;
e_info.event_type = eRelationEvent.Add;
e_info.bin_content.bin_add_content.char_name = player.char_name;
e_info.bin_content.bin_add_content.message = message;
e_info.bin_content.bin_add_content.flag = flag;
SQLRelationHandle.InsertRelationEvent(e_info);
//立刻通知接受者
this.BroadcastEvent(e_info.target_char_idx, e_info.event_type);
}
});
}
