public DBTitleEffectItem GetData(uint id)
{
DBTitleEffectItem ad = null;
if (Data.TryGetValue(id, out ad))
{
return(ad);
}
string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "id", id);
var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query);
if (reader == null)
{
Data[id] = null;
return(null);
}
if (!reader.HasRows || !reader.Read())
{
Data[id] = null;
reader.Close();
reader.Dispose();
return(null);
}
var ret = new DBTitleEffectItem();
ret.Id = DBTextResource.ParseUI(GetReaderString(reader, "id"));
ret.Name = GetReaderString(reader, "name");
ret.Arg = DBTextResource.ParseVector2(GetReaderString(reader, "arg"));
ret.FrameSize = DBTextResource.ParseVector2(GetReaderString(reader, "frame_size"));
ret.PatchId = DBTextResource.ParseUI(GetReaderString(reader, "patch_id"));
Data.Add(ret.Id, ret);
reader.Close();
reader.Dispose();
return(ret);
}
protected override void ParseData(SqliteDataReader reader)
{
if (reader == null || !reader.HasRows)
{
return;
}
//List<string> mount_action_name_array = new List<string>(){ "rideidle", "rideidle01", "rideidle02", "rideidle03", "rideidle04", "rideidle06" };
m_VocationMountInfos = new Dictionary <uint, VocationMountInfo>();
while (reader.Read())
{
var vocation = DBTextResource.ParseUI(GetReaderString(reader, "vocation"));
VocationMountInfo data = new VocationMountInfo();
//data.mount_offset_dict = new Dictionary<string, Vector3>();
data.rider_self_height_dict = new Dictionary <string, VocationMountInfo.OnRideActionInfo>();
for (int index = 0; index < mount_action_name_array.Count; ++index)
{
List <string> list_str = DBTextResource.ParseArrayString(GetReaderString(reader, mount_action_name_array[index]), ";");
if (list_str == null || list_str.Count == 0)
{
continue;
}
data.rider_self_height_dict[mount_action_name_array[index]] = new VocationMountInfo.OnRideActionInfo();
VocationMountInfo.OnRideActionInfo tmp_info = data.rider_self_height_dict[mount_action_name_array[index]];
if (list_str.Count >= 1)
{
tmp_info.mount_offset_dict = DBTextResource.ParseVector3(list_str[0]);
}
if (list_str.Count >= 2)
{
Vector2 v2 = DBTextResource.ParseVector2(list_str[1]);
tmp_info.self_center_height = v2.x;
tmp_info.self_height = v2.y;
}
}
m_VocationMountInfos[vocation] = data;
}
}
/// <summary>
/// 获取某个副本的信息
/// </summary>
/// <returns>The instance info.</returns>
/// <param name="id">Identifier.</param>
public InstanceInfo GetInstanceInfo(uint id)
{
InstanceInfo info = null;
if (mInstanceInfos.TryGetValue(id, out info))
{
return(info);
}
string queryStr = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "id", id.ToString());
var table_reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, queryStr);
if (table_reader == null)
{
mInstanceInfos.Add(id, null);
return(null);
}
if (!table_reader.HasRows)
{
mInstanceInfos.Add(id, null);
table_reader.Close();
table_reader.Dispose();
return(null);
}
if (!table_reader.Read())
{
mInstanceInfos.Add(id, null);
table_reader.Close();
table_reader.Dispose();
return(null);
}
info = new InstanceInfo();
Type gameConstType = typeof(GameConst);
info.mId = DBTextResource.ParseUI_s(GetReaderString(table_reader, "id"), 0);
info.mMaxTime = DBTextResource.ParseI(GetReaderString(table_reader, "max_time"));
info.mNeedGoods = DBTextResource.ParseDictionaryUintUint(GetReaderString(table_reader, "need_goods"));
info.mDyNeedGoods = DBTextResource.ParseArrayUintUint(GetReaderString(table_reader, "dy_need_goods"));
info.mNeedLv = DBTextResource.ParseUS_s(GetReaderString(table_reader, "need_lv"), 0);
info.mLvUpLimit = DBTextResource.ParseUS_s(GetReaderString(table_reader, "lv_up_limit"), 0);
info.mRecommendAttrs = ParseRecommendAttrs(GetReaderString(table_reader, "recommend_attrs"));
info.mSingleEnter = DBTextResource.ParseI(GetReaderString(table_reader, "single_enter")) == 1 ? true : false;
string mbCountStr = GetReaderString(table_reader, "mb_count");
ushort mbCount = 0;
/* 进入人数四种要求:
* 0：可单人，也可以任意组队(不用配)
* 1：必须单人(可以没有队伍，也可以在只有他一个人的队伍中)
* N(N>=2)：必须N人以上组队
* {M,N}：大于等于M且小于等于N */
if (string.IsNullOrEmpty(mbCountStr) == true)
{
info.mMinMemberCount = 0;
info.mMaxMemberCount = GameConstHelper.GetShort("GAME_TEAM_MEMBER_LIMIT");
}
else if (ushort.TryParse(mbCountStr, out mbCount) == true)
{
info.mMinMemberCount = mbCount;
if (info.mMinMemberCount == 0)
{
info.mMaxMemberCount = GameConstHelper.GetShort("GAME_TEAM_MEMBER_LIMIT");
}
else if (info.mMinMemberCount == 1)
{
info.mMinMemberCount = 0;
info.mMaxMemberCount = 1;
}
else
{
info.mMaxMemberCount = GameConstHelper.GetShort("GAME_TEAM_MEMBER_LIMIT");
}
}
else
{
List <uint> mbCountList = DBTextResource.ParseArrayUint(mbCountStr, ",");
if (mbCountList.Count >= 2)
{
info.mMinMemberCount = (ushort)mbCountList[0];
info.mMaxMemberCount = (ushort)mbCountList[1];
}
}
info.mSweepCosts = DBTextResource.ParseDictionaryUintUint(GetReaderString(table_reader, "sweep_costs"));
info.mSweepLimit = DBTextResource.ParseVector2(GetReaderString(table_reader, "sweep_limit"));
info.mName = GetReaderString(table_reader, "name");
//System.Reflection.FieldInfo fieldInfo = null;
//string warTypeStr = GetReaderString(table_reader, "war_type");
//if (mGameConstUintValueCache.ContainsKey(warTypeStr) == true)
//{
// info.mWarType = mGameConstUintValueCache[warTypeStr];
//}
//else
//{
// fieldInfo = gameConstType.GetField(warTypeStr);
// if (fieldInfo != null)
// {
// info.mWarType = Convert.ToUInt32(fieldInfo.GetValue(null));
// mGameConstUintValueCache[warTypeStr] = info.mWarType;
// }
// else
// {
// GameDebug.LogError("Can not find war type " + warTypeStr + " in db instance!!!");
// }
//}
//string warsubTypeStr = GetReaderString(table_reader, "war_subtype");
//if (string.IsNullOrEmpty(warsubTypeStr) == false)
//{
// if (mGameConstUintValueCache.ContainsKey(warsubTypeStr) == true)
// {
// info.mWarSubType = mGameConstUintValueCache[warsubTypeStr];
// }
// else
// {
// fieldInfo = gameConstType.GetField(warsubTypeStr);
// if (fieldInfo != null)
// {
// info.mWarSubType = Convert.ToUInt32(fieldInfo.GetValue(null));
// mGameConstUintValueCache[warsubTypeStr] = info.mWarSubType;
// }
// else
// {
// GameDebug.LogError("Can not find sub war type " + warsubTypeStr + " in db instance!!!");
// }
// }
//}
uint warType = 0;
uint warSubType = 0;
string warTypeStr = GetReaderString(table_reader, "war_type");
string warSubTypeStr = GetReaderString(table_reader, "war_subtype");
ConvertWarType(warTypeStr, warSubTypeStr, out warType, out warSubType);
info.mWarType = warType;
info.mWarSubType = warSubType;
info.mDesc = GetReaderString(table_reader, "desc");
info.mStages.Clear();
string stagesStr = GetReaderString(table_reader, "stages");
List <string> stages = DBTextResource.ParseArrayString(stagesStr);
for (int j = 0; j < stages.Count; j++)
{
if (!String.IsNullOrEmpty(stages[j]))
{
info.mStages.Add(DBTextResource.ParseUI(stages[j]));
}
}
info.mPKType = DBTextResource.ParseI(GetReaderString(table_reader, "pk_type"));
info.mReviveTimes = DBTextResource.ParseUS(GetReaderString(table_reader, "revive_times"));
info.mReadyCountDown = DBTextResource.ParseUS(GetReaderString(table_reader, "ready_count_down"));
info.mResultCountDown = DBTextResource.ParseUI(GetReaderString(table_reader, "result_count_down"));
info.mIsReloadSceneWhenTheSame = DBTextResource.ParseI(GetReaderString(table_reader, "is_reload_scene_when_the_same")) == 0 ? false : true;
info.mMinPos = DBTextResource.ParseVector2(GetReaderString(table_reader, "mini_map_pos_x"));
info.mMaxPos = DBTextResource.ParseVector2(GetReaderString(table_reader, "mini_map_pos_y"));
info.mMiniMapWidth = info.mMaxPos.x - info.mMinPos.x;
info.mMiniMapHeight = info.mMaxPos.y - info.mMinPos.y;
info.mMiniMapName = GetReaderString(table_reader, "mini_map");
info.mIsCanOpenMiniMap = DBTextResource.ParseI(GetReaderString(table_reader, "is_open_mini_map")) == 0 ? false : true;
string isShowMarkStr = GetReaderString(table_reader, "is_show_mark");
if (isShowMarkStr == string.Empty || isShowMarkStr == "0")
{
info.mIsShowMark = false;
}
else
{
info.mIsShowMark = true;
}
string isAutoFightStr = GetReaderString(table_reader, "is_auto_fight");
if (isAutoFightStr == string.Empty || isAutoFightStr == "0")
{
info.mIsAutoFight = false;
}
else
{
info.mIsAutoFight = true;
}
string canNotRideStr = GetReaderString(table_reader, "can_not_ride");
if (canNotRideStr == string.Empty || canNotRideStr == "0")
{
info.mCanNotRide = false;
}
else
{
info.mCanNotRide = true;
}
info.mRewardIds = DBTextResource.ParseArrayUint(GetReaderString(table_reader, "reward_1"), ",");
info.mShowRewardIds = DBTextResource.ParseArrayUint(GetReaderString(table_reader, "show_rewards"), ",");
info.mNeedTaskId = DBTextResource.ParseUI_s(GetReaderString(table_reader, "need_task_id"), 0);
info.mPlanesInstanceId = DBTextResource.ParseUI_s(GetReaderString(table_reader, "planes_dg_id"), 0);
info.mStartTimeline = DBTextResource.ParseUI_s(GetReaderString(table_reader, "start_timeline"), 0);
info.mGuardedNpcId = DBTextResource.ParseUI_s(GetReaderString(table_reader, "npc_id"), 0);
string showBossAssStr = GetReaderString(table_reader, "show_boss_assistant");
if (showBossAssStr == string.Empty || showBossAssStr == "0")
{
info.mShowBossAssistant = false;
}
else
{
info.mShowBossAssistant = true;
}
info.mForbidJumpOutAnimationOut = DBTextResource.ParseUI_s(GetReaderString(table_reader, "forbid_jump_out_animation_out"), 0) == 1;
info.mForbidWaterWaveEffect = DBTextResource.ParseUI_s(GetReaderString(table_reader, "forbid_water_wave_effect"), 0) == 1;
info.mIsCanSendPosition = DBTextResource.ParseUI_s(GetReaderString(table_reader, "is_can_send_position"), 0) == 1;
info.mMergeLevel = DBTextResource.ParseUI_s(GetReaderString(table_reader, "merge_level"), 0);
info.mMergeConsume = DBTextResource.ParseDictionaryUintUint(GetReaderString(table_reader, "merge_consume"));
#if UNITY_EDITOR
if (mInstanceInfos.ContainsKey(info.mId))
{
GameDebug.LogError(string.Format("[{0}]表重复添加的域id[{1}]", mTableName, info.mId));
table_reader.Close();
table_reader.Dispose();
return(info);
}
#endif
mInstanceInfos.Add(info.mId, info);
table_reader.Close();
table_reader.Dispose();
return(info);
}
