/// <summary> /// 角色加点取系数 /// </summary> /// <param name="key"></param> /// <returns></returns> public static Dictionary <uint, float> GetAddProperty(string key) { List <string> data_attr_conv = DBManager.Instance.QuerySqliteField <string>(GlobalConfig.DBFile, "data_attr_conv", "csv_id", key, "client_attrs"); if (data_attr_conv.Count == 0) { return(null); } string raw = data_attr_conv[0]; raw = raw.Replace(" ", ""); var matchs = Regex.Matches(raw, @"\{(\d+),(\d+)\}"); Dictionary <uint, float> list = new Dictionary <uint, float>(); foreach (Match _match in matchs) { if (_match.Success) { uint id = (DBTextResource.ParseUI(_match.Groups[1].Value)); var value = (DBTextResource.ParseF(_match.Groups[2].Value) / 100.0f); list.Add(id, value); } } return(list); }
protected override void ParseData(SqliteDataReader reader) { if (reader == null || !reader.HasRows) { return; } m_AnimationInfos.Clear(); AnimationInfo info; while (reader.Read()) { info = new AnimationInfo(); info.Anchor = GetReaderString(reader, "anchor"); uint ani_count = DBTextResource.ParseUI(GetReaderString(reader, "ani_count")); info.AnimationName = new string[ani_count]; for (int i = 0; i < ani_count; ++i) { info.AnimationName[i] = GetReaderString(reader, "ani_" + i); } m_AnimationInfos[info.Anchor] = info; } }
public static List <Dictionary <uint, float> > GetRecommendAttrByVocation(uint vocation) { List <Dictionary <uint, float> > finalList = new List <Dictionary <uint, float> >(); List <string> lvpoint_recommend = DBManager.Instance.QuerySqliteField <string>(GlobalConfig.DBFile, "lvpoint_recommend", "vocation", vocation.ToString(), "recommend_attr"); if (lvpoint_recommend.Count == 0) { return(finalList); } string raw = lvpoint_recommend[0]; raw = raw.Replace(" ", ""); var matchs = Regex.Matches(raw, @"\{(\d+),(\d+)\}"); foreach (Match _match in matchs) { if (_match.Success) { Dictionary <uint, float> list = new Dictionary <uint, float>(); uint id = (DBTextResource.ParseUI(_match.Groups[1].Value)); var value = (DBTextResource.ParseF(_match.Groups[2].Value) / 100.0f); list.Add(id, value); finalList.Add(list); } } return(finalList); }
private DBAndroidMajiaItem GetItemInfo(uint app_id) { string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "app_id", app_id); var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query); if (reader == null) { data[app_id] = null; return(null); } if (!reader.HasRows || !reader.Read()) { data[app_id] = null; reader.Close(); reader.Dispose(); return(null); } DBAndroidMajiaItem ad = new DBAndroidMajiaItem(); ad.AppID = app_id; ad.ShowUserCenter = DBTextResource.ParseUI(GetReaderString(reader, "show_user_center")) == 1; ad.ShowLogo = DBTextResource.ParseUI(GetReaderString(reader, "show_logo")) == 1; ad.ShowKv = DBTextResource.ParseUI(GetReaderString(reader, "show_kv")) == 1; ad.ShowEffect = DBTextResource.ParseUI(GetReaderString(reader, "show_effect")) == 1; data.Add(ad.AppID, ad); reader.Close(); reader.Dispose(); return(ad); }
protected override void ParseData(SqliteDataReader reader) { if (reader == null || !reader.HasRows) { return; } while (reader.Read()) { var guide = new GuideData(); guide.Id = DBTextResource.ParseUI(GetReaderString(reader, "guide_id")); guide.Priority = DBTextResource.ParseUS(GetReaderString(reader, "priority")); guide.PreSys = DBTextResource.ParseUI(GetReaderString(reader, "sys")); guide.MinLevel = DBTextResource.ParseUI(GetReaderString(reader, "min_level")); guide.MaxLevel = DBTextResource.ParseUI(GetReaderString(reader, "max_level")); guide.InstanceType = DBTextResource.ParseI_s(GetReaderString(reader, "inst_type"), -1); guide.InstanceSubType = DBTextResource.ParseI_s(GetReaderString(reader, "inst_sub_type"), -1); guide.TriggerType = (GuideData.GuideTrigger)Enum.Parse(typeof(GuideData.GuideTrigger), GetReaderString(reader, "trigger_type")); guide.TriggerParams = new List <uint>(); string[] param = TextHelper.GetListFromString(GetReaderString(reader, "trigger_params")); if (param != null) { foreach (string s in param) { guide.TriggerParams.Add(DBTextResource.ParseUI_s(s, 0)); } } string rawStr = GetReaderString(reader, "auto_fight_when_finish"); if (string.IsNullOrEmpty(rawStr) == true || rawStr.Equals("0") == true) { guide.AutoFightWhenFinish = false; } else { guide.AutoFightWhenFinish = true; } guide.TimelineWhenFinish = DBTextResource.ParseUI_s(GetReaderString(reader, "timeline_when_finish"), 0); rawStr = GetReaderString(reader, "guide_main_task_when_finish_and_return_main_wnd"); if (string.IsNullOrEmpty(rawStr) == true || rawStr.Equals("0") == true) { guide.GuideMainTaskWhenFinishAndReturnMainWnd = false; } else { guide.GuideMainTaskWhenFinishAndReturnMainWnd = true; } guide.IsFinished = false; Guides.Add(guide.Id, guide); GuideList.Add(guide); } GuideList.Sort(); }
List <DBSuitAttrInfo> GetItemInfo(uint id, uint lv) { uint uid = MakeUID(id, lv); string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\" AND {0}.{3}=\"{4}\"", mTableName, "id", id, "lv", lv); var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query); if (reader == null) { mInfos[uid] = null; return(null); } if (!reader.HasRows) { mInfos[uid] = null; reader.Close(); reader.Dispose(); return(null); } List <DBSuitAttrInfo> attrInfos = null; while (reader.Read()) { DBSuitAttrInfo info = new DBSuitAttrInfo(); info.Id = id; info.Lv = lv; info.Num = DBTextResource.ParseBT_s(GetReaderString(reader, "num"), 0); info.EffectId = DBTextResource.ParseUI_s(GetReaderString(reader, "effect_id"), 0); string raw = GetReaderString(reader, "base_attr"); raw = raw.Replace(" ", ""); var matchs = Regex.Matches(raw, @"\{(\d+),(\d+)\}"); info.BasicAttrs = new ActorAttribute(); foreach (Match _match in matchs) { if (_match.Success) { uint attrId = (DBTextResource.ParseUI(_match.Groups[1].Value)); var attrVal = DBTextResource.ParseUI(_match.Groups[2].Value); info.BasicAttrs.Add(attrId, attrVal); } } if (attrInfos == null) { attrInfos = new List <DBSuitAttrInfo>(); } attrInfos.Add(info); } mInfos[uid] = attrInfos; reader.Close(); reader.Dispose(); return(attrInfos); }
/// <summary> /// 获取一个洗练属性标准值配置信息 /// </summary> /// <param name="posId"></param> /// <returns></returns> public DBBaptizeCostInfo GetOneInfo(uint id) { DBBaptizeCostInfo info; if (mInfos.TryGetValue(id, out info)) { return(info); } string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "num", id); var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query); if (reader == null) { mInfos[id] = null; return(null); } if (!reader.HasRows || !reader.Read()) { mInfos[id] = null; reader.Close(); reader.Dispose(); return(null); } info = new DBBaptizeCostInfo(); info.Num = DBTextResource.ParseUI_s(GetReaderString(reader, "num"), 0); info.CostDiamond = DBTextResource.ParseUI_s(GetReaderString(reader, "cost_diamond"), 0); string raw = GetReaderString(reader, "cost_goods"); info.CostGoods = new List <KeyValuePair <uint, uint> >(); info.CostGoods.Clear(); raw = raw.Replace(" ", ""); var matchs = Regex.Matches(raw, @"\{(\d+),(\d+)\}"); foreach (Match _match in matchs) { if (_match.Success) { uint goodsId = (DBTextResource.ParseUI(_match.Groups[1].Value)); uint num = DBTextResource.ParseUI(_match.Groups[2].Value); KeyValuePair <uint, uint> goods = new KeyValuePair <uint, uint>(goodsId, num); info.CostGoods.Add(goods); } } mInfos[info.Num] = info; reader.Close(); reader.Dispose(); return(info); }
public ActorAttribute GetGoodsShowAttr(uint gid) { ActorAttribute attr = null; if (mGoodsShowAttrsInfos.TryGetValue(gid, out attr)) { return(attr); } string query_str = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "gid", gid.ToString()); var table_reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query_str); if (table_reader == null) { mGoodsShowAttrsInfos[gid] = null; return(null); } if (!table_reader.HasRows) { mGoodsShowAttrsInfos[gid] = null; table_reader.Close(); table_reader.Dispose(); return(null); } if (!table_reader.Read()) { mGoodsShowAttrsInfos[gid] = null; table_reader.Close(); table_reader.Dispose(); return(null); } attr = new ActorAttribute(); string attrsStr = GetReaderString(table_reader, "attrs"); attrsStr = attrsStr.Replace(" ", ""); var matchs = Regex.Matches(attrsStr, @"\{(\d+),(\d+)\}"); foreach (Match _match in matchs) { if (_match.Success) { uint attrId = (DBTextResource.ParseUI(_match.Groups[1].Value)); uint attrValue = DBTextResource.ParseUI(_match.Groups[2].Value); attr.Add(attrId, attrValue); } } mGoodsShowAttrsInfos[gid] = attr; table_reader.Close(); table_reader.Dispose(); return(attr); }
public DBWeddingRingGoodsItem GetData(uint id_info) { DBWeddingRingGoodsItem ad = null; if (data.TryGetValue(id_info, out ad)) { return(ad); } string query_str = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", "data_ring", "id", id_info.ToString()); var table_reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, "data_ring", query_str); if (table_reader == null) { data[id_info] = null; return(null); } if (!table_reader.HasRows) { data[id_info] = null; table_reader.Close(); table_reader.Dispose(); return(null); } if (!table_reader.Read()) { data[id_info] = null; table_reader.Close(); table_reader.Dispose(); return(null); } ad = new DBWeddingRingGoodsItem(); ad.id_info = DBTextResource.ParseUI(GetReaderString(table_reader, "id")); ad.step = DBTextResource.ParseUI(GetReaderString(table_reader, "step")); ad.lv = DBTextResource.ParseUI(GetReaderString(table_reader, "lv")); ad.need_exp = DBTextResource.ParseUI(GetReaderString(table_reader, "need_exp")); ad.normal_attrs = DBTextResource.ParseDBAttrItems(GetReaderString(table_reader, "normal_attrs")); ad.couple_attrs = DBTextResource.ParseDBAttrItems(GetReaderString(table_reader, "couple_attrs")); ad.skill = DBTextResource.ParseUI(GetReaderString(table_reader, "skill")); ad.gid = DBTextResource.ParseUI(GetReaderString(table_reader, "gid")); data.Add(ad.id_info, ad); table_reader.Close(); table_reader.Dispose(); return(ad); }
protected override void ParseData(SqliteDataReader reader) { if (reader == null || !reader.HasRows) { return; } mInfos.Clear(); mSortInfos.Clear(); while (reader.Read()) { var tmp_info = new TrialBossItem(); tmp_info.DgnId = DBTextResource.ParseUI(GetReaderString(reader, "dgn_id")); //副本ID tmp_info.TrialType = DBTextResource.ParseUI(GetReaderString(reader, "type")); tmp_info.Rank = DBTextResource.ParseUI(GetReaderString(reader, "rank")); tmp_info.ActorId = DBTextResource.ParseUI(GetReaderString(reader, "actor_id")); tmp_info.ShowAward = DBTextResource.ParseDBGoodsItem(GetReaderString(reader, "show_award")); tmp_info.ShowAssistAward = DBTextResource.ParseDBGoodsItem(GetReaderString(reader, "show_assist_award")); tmp_info.ModelCameraOffset = DBTextResource.ParseVector3(GetReaderString(reader, "model_camera_offset")); tmp_info.DefaultAngles = DBTextResource.ParseVector3(GetReaderString(reader, "default_angles")); tmp_info.CameraViewField = DBTextResource.ParseF(GetReaderString(reader, "camera_view_field")); tmp_info.CameraRotate = DBTextResource.ParseVector3(GetReaderString(reader, "camera_rotate")); tmp_info.DefaultActionName = GetReaderString(reader, "default_action_name"); tmp_info.Icon = GetReaderString(reader, "icon"); if (mInfos.ContainsKey(tmp_info.DgnId) == false) { mInfos.Add(tmp_info.DgnId, tmp_info); if (mSortInfos.ContainsKey(tmp_info.TrialType) == false) { mSortInfos.Add(tmp_info.TrialType, new List <TrialBossItem>()); } mSortInfos[tmp_info.TrialType].Add(tmp_info); } else { GameDebug.LogError("DBTrialBoss contain the same info; Dgn_id = " + tmp_info.DgnId); } } foreach (var item in mSortInfos) { mSortInfos[item.Key].Sort((a, b) => { if (a.Rank < b.Rank) { return(-1); } else if (a.Rank > b.Rank) { return(1); } return(0); }); } }
private DBMagicEquipItem GetItemInfo(uint gid) { string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "gid", gid); var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query); if (reader == null) { data[gid] = null; return(null); } if (!reader.HasRows || !reader.Read()) { data[gid] = null; reader.Close(); reader.Dispose(); return(null); } DBMagicEquipItem ad = new DBMagicEquipItem(); ad.Gid = gid; ad.PosId = DBTextResource.ParseUI(GetReaderString(reader, "pos_id")); ad.StrengthMax = DBTextResource.ParseUI(GetReaderString(reader, "max_lv")); ad.Star = DBTextResource.ParseUI(GetReaderString(reader, "star")); ad.SwallowExpValue = DBTextResource.ParseUI(GetReaderString(reader, "exp")); ad.DefaultAppendDesc = GetReaderString(reader, "default_append_desc"); ad.BaseAttrs = DBTextResource.ParseDBAttrItems(GetReaderString(reader, "base_attrs")); uint num = 0; string appendAttrStr = GetReaderString(reader, "spec_attrs"); appendAttrStr = appendAttrStr.Replace(" ", ""); var matchs = Regex.Matches(appendAttrStr, @"\{(\d+),(\d+)\}"); foreach (Match _match in matchs) { if (_match.Success) { num = num + DBTextResource.ParseUI(_match.Groups[2].Value); } } ad.AppendAttrNum = num; data.Add(ad.Gid, ad); reader.Close(); reader.Dispose(); return(ad); }
public EquipSubAttrData GetSubAttrData(uint sub_attr_id) { EquipSubAttrData data = null; if (EquipSubAttrDescs.TryGetValue(sub_attr_id, out data)) { return(data); } string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "id", sub_attr_id); var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query); if (reader == null) { EquipSubAttrDescs[sub_attr_id] = null; return(null); } if (!reader.HasRows || !reader.Read()) { EquipSubAttrDescs[sub_attr_id] = null; reader.Close(); reader.Dispose(); return(null); } var id = DBTextResource.ParseUI(GetReaderString(reader, "id")); var des = GetReaderString(reader, "desc"); var tmp_str = GetReaderString(reader, "attr_type"); tmp_str = tmp_str.Substring(1, tmp_str.Length - 2); var _tmp_split = tmp_str.Split(','); List <uint> at_type = new List <uint>(); uint c = 0; for (int i = 0; i < _tmp_split.Length; i++) { if (uint.TryParse(_tmp_split[i], out c)) { if (c != 9) { at_type.Add(c); } } } data = new EquipSubAttrData(id, des, at_type); EquipSubAttrDescs.Add(id, data); reader.Close(); reader.Dispose(); return(data); }
public SoulLvInfo GetData(string csvId) { SoulLvInfo info = null; if (mInfos.TryGetValue(csvId, out info)) { return(info); } string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "csv_id", csvId); var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query); if (reader == null) { mInfos[csvId] = null; return(null); } if (!reader.HasRows || !reader.Read()) { mInfos[csvId] = null; reader.Close(); reader.Dispose(); return(null); } info = new SoulLvInfo(); info.cream = DBTextResource.ParseUI(GetReaderString(reader, "cream")); var attr = GetReaderString(reader, "attr"); attr = attr.Replace(" ", ""); var matchs = Regex.Matches(attr, @"\{(\d+),(\d+)\}"); foreach (Match _match in matchs) { if (_match.Success) { uint attrId = (DBTextResource.ParseUI(_match.Groups[1].Value)); uint attrValue = DBTextResource.ParseUI(_match.Groups[2].Value); info.attr[attrId] = attrValue; } } mInfos[csvId] = info; reader.Close(); reader.Dispose(); return(info); }
/// <summary> /// 通过csv_id来获取指定的套装精炼数据 /// </summary> /// <param name="id"></param> /// <returns></returns> public DBSuitRefineItem GetData(string id) { DBSuitRefineItem ad = null; if (data.TryGetValue(id, out ad)) { return(ad); } string query_str = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "csv_id", id); var table_reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query_str); if (table_reader == null) { data[id] = null; return(null); } if (!table_reader.HasRows) { data[id] = null; table_reader.Close(); table_reader.Dispose(); return(null); } if (!table_reader.Read()) { data[id] = null; table_reader.Close(); table_reader.Dispose(); return(null); } ad = new DBSuitRefineItem(); ad.Id = GetReaderString(table_reader, "csv_id"); ad.Pos = DBTextResource.ParseUI(GetReaderString(table_reader, "pos")); ad.Step = DBTextResource.ParseUI(GetReaderString(table_reader, "step")); ad.Level = DBTextResource.ParseUI(GetReaderString(table_reader, "lv")); ad.Cost = DBTextResource.ParseDBGoodsItem(GetReaderString(table_reader, "costs")); ad.Addition = GetReaderUint(table_reader, "addition"); data[ad.Id] = ad; table_reader.Close(); table_reader.Dispose(); return(ad); }
public void UpdateAttr(uint gid, Net.PkgGoodsInfo decorate) { NetDecorate = decorate; if (BasicAttrs == null) { BasicAttrs = new ActorAttribute(); } else { BasicAttrs.Clear(); } if (LegendAttrs == null) { LegendAttrs = new EquipAttributes(); } else { LegendAttrs.Clear(); } var rec = DBDecorate.Instance.GetData(gid); if (rec != null) { string raw = rec.Attrs; raw = raw.Replace(" ", ""); var matchs = Regex.Matches(raw, @"\{(\d+),(\d+)\}"); foreach (Match _match in matchs) { if (_match.Success) { uint attrId = (DBTextResource.ParseUI(_match.Groups[1].Value)); uint attrValue = DBTextResource.ParseUI(_match.Groups[2].Value); BasicAttrs.Add(attrId, attrValue); } } } if (decorate != null && decorate.decorate != null && decorate.decorate.legend_attrs != null) { foreach (var attr in decorate.decorate.legend_attrs) { LegendAttrs.Add(attr.id, attr.vals); } } }
SuitEffectInfo GetItemInfo(uint id) { 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) { mSuitEffectInfos[id] = null; return(null); } if (!reader.HasRows || !reader.Read()) { mSuitEffectInfos[id] = null; reader.Close(); reader.Dispose(); return(null); } SuitEffectInfo info = new SuitEffectInfo(); info.id = id; info.effect_type = DBTextResource.ParseUI(GetReaderString(reader, "effect_type")); int effect_count = DBTextResource.ParseI(GetReaderString(reader, "effect_count")); info.bind_infos = new List <BindInfo>(effect_count); for (int i = 0; i < effect_count; ++i) { var bind_info = new BindInfo(); bind_info.model_id = DBTextResource.ParseUI(GetReaderString(reader, "model_id_" + (i + 1))); bind_info.low_model_id = DBTextResource.ParseUI(GetReaderString(reader, "low_model_id_" + (i + 1))); bind_info.ui_model_id = DBTextResource.ParseUI(GetReaderString(reader, "ui_model_id_" + (i + 1))); if (bind_info.ui_model_id == 0) { bind_info.ui_model_id = bind_info.model_id; } bind_info.bind_node = GetReaderString(reader, "bind_node_" + (i + 1)); info.bind_infos.Add(bind_info); } mSuitEffectInfos[info.id] = info; reader.Close(); reader.Dispose(); return(info); }
protected override void ParseData(SqliteDataReader reader) { base.ParseData(reader); mSkillInfos.Clear(); int fieldCount = reader.FieldCount; while (reader.Read()) { SkillBasicInfo info = new SkillBasicInfo(); for (int i = 0; i < fieldCount; i++) { string rawName = reader.GetName(i); if (rawName == "id") { info.Id = DBTextResource.ParseUI(reader.GetString(i)); } else if (rawName == "show_in_ui") { info.ShowInUI = DBTextResource.ParseUI(reader.GetString(i)); } else if (rawName == "name") { info.Name = reader.GetString(i); } else if (rawName == "type") { info.Type = DBTextResource.ParseUS_s(reader.GetString(i), 1); } else if (rawName == "sub_type") { info.SubType = DBTextResource.ParseUS_s(reader.GetString(i), 1); } else if (rawName == "icon") { info.Icon = reader.GetString(i); } else if (rawName == "skill_type_descript") { info.SkillTypeDescript = reader.GetString(i); } } mSkillInfos.Add(info.Id, info); } }
public Dictionary <uint, uint> GetAttrInfo(uint gid) { Dictionary <uint, uint> info = null; if (mBaseAttrInfos.TryGetValue(gid, out info)) { return(info); } string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "gid", gid); var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query); if (reader == null) { mBaseAttrInfos[gid] = null; return(null); } if (!reader.HasRows || !reader.Read()) { mBaseAttrInfos[gid] = null; reader.Close(); reader.Dispose(); return(null); } info = new Dictionary <uint, uint>(); var attr = GetReaderString(reader, "base_attr"); attr = attr.Replace(" ", ""); var matchs = Regex.Matches(attr, @"\{(\d+),(\d+)\}"); foreach (Match _match in matchs) { if (_match.Success) { uint attrId = (DBTextResource.ParseUI(_match.Groups[1].Value)); uint attrValue = DBTextResource.ParseUI(_match.Groups[2].Value); info[attrId] = attrValue; } } mBaseAttrInfos[gid] = info; reader.Close(); reader.Dispose(); return(info); }
public static List <uint> ParseArrayUintAndUint(string arrayString, string del) { List <uint> list = null; if (arrayString.Contains("[")) { list = DBTextResource.ParseArrayUint(arrayString, del); } else { list = new List <uint>(); uint value = DBTextResource.ParseUI(arrayString); list.Add(value); } return(list); }
public GoodsSoul(uint typeId, Net.PkgGoodsInfo info) { CreateGoodsByTypeId(typeId); var data_soul = DBManager.Instance.QuerySqliteLikeKeyRow <string>(GlobalConfig.DBFile, "data_soul", "gid", type_idx.ToString()); if (data_soul.Count > 0) { var table = data_soul[0]; ResolveGetVal = DBTextResource.ParseUI(table["resolve"]); } if (info != null) { UpdateSoul(info.soul); } }
public DBTrialBossDifficultyItem GetItem(uint diff_id) { DBTrialBossDifficultyItem item; if (mInfos.TryGetValue(diff_id, out item)) { return(item); } string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "id", diff_id); var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query); if (reader == null) { mInfos[diff_id] = null; return(null); } if (!reader.HasRows || !reader.Read()) { mInfos[diff_id] = null; reader.Close(); reader.Dispose(); return(null); } var tmp_info = new DBTrialBossDifficultyItem(); tmp_info.DifficultyId = DBTextResource.ParseUI(GetReaderString(reader, "id")); tmp_info.Name = GetReaderString(reader, "name"); tmp_info.Color = DBTextResource.ParseUI(GetReaderString(reader, "color")); if (mInfos.ContainsKey(tmp_info.DifficultyId) == false) { mInfos.Add(tmp_info.DifficultyId, tmp_info); } else { GameDebug.LogError("DBTrialBossDifficulty contain the same info; DifficultyId = " + tmp_info.DifficultyId); } reader.Close(); reader.Dispose(); return(tmp_info); }
DBBaptizeAttrStandardInfo GetItemInfo(uint id) { string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "lv_step", id); var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query); if (reader == null) { mInfos[id] = null; return(null); } if (!reader.HasRows || !reader.Read()) { mInfos[id] = null; reader.Close(); reader.Dispose(); return(null); } DBBaptizeAttrStandardInfo info = new DBBaptizeAttrStandardInfo(); info.LvStep = id; info.BaseAttrs = new ActorAttribute(); string raw = GetReaderString(reader, "base_attr"); raw = raw.Replace(" ", ""); var matchs = Regex.Matches(raw, @"\{(\d+),(\d+)\}"); foreach (Match _match in matchs) { if (_match.Success) { uint attrId = (DBTextResource.ParseUI(_match.Groups[1].Value)); uint attrVal = DBTextResource.ParseUI(_match.Groups[2].Value); info.BaseAttrs.Add(attrId, attrVal); } } mInfos[info.LvStep] = info; reader.Close(); reader.Dispose(); return(info); }
public DBDecorateItem GetData(uint gid) { DBDecorateItem ad = null; if (data.TryGetValue(gid, out ad)) { return(ad); } string query = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\"", mTableName, "gid", gid); var reader = DBManager.Instance.ExecuteSqliteQueryToReader(GlobalConfig.DBFile, mTableName, query); if (reader == null) { data[gid] = null; return(null); } if (!reader.HasRows || !reader.Read()) { data[gid] = null; reader.Close(); reader.Dispose(); return(null); } var ret = new DBDecorateItem(); ret.Gid = DBTextResource.ParseUI(GetReaderString(reader, "gid")); ret.Pos = DBTextResource.ParseUI(GetReaderString(reader, "pos_id")); ret.StrengthMax = DBTextResource.ParseUI(GetReaderString(reader, "max_lv")); ret.LvStep = DBTextResource.ParseUI(GetReaderString(reader, "lv_step")); ret.SwallowExpValue = DBTextResource.ParseUI(GetReaderString(reader, "value")); ret.Attrs = GetReaderString(reader, "attrs"); ret.LegendAttrs = DBTextResource.ParseArrayUintUint(GetReaderString(reader, "legend_attrs")); ret.DefaultExtraDesc = GetReaderString(reader, "default_extra_desc"); ret.DefaultStar = DBTextResource.ParseUI(GetReaderString(reader, "default_star")); data.Add(ret.Gid, ret); reader.Close(); reader.Dispose(); return(ret); }
public DBGodEquipGoodsItem GetData(uint id) { DBGodEquipGoodsItem ad = null; if (!data.TryGetValue(id, out ad)) { string query_str = string.Format("SELECT * FROM {0} WHERE {0}.{1}=\"{2}\" ", mTableName, "gid", id.ToString()); var table_reader = DBManager.Instance.ExecuteSqliteQueryToReader(mFileName, VoiceTableName, query_str); if (table_reader == null) { data[id] = null; return(null); } if (!table_reader.HasRows) { data[id] = null; table_reader.Close(); table_reader.Dispose(); return(null); } if (!table_reader.Read()) { data[id] = null; table_reader.Close(); table_reader.Dispose(); return(null); } ad = new DBGodEquipGoodsItem(); ad.Gid = DBTextResource.ParseUI(GetReaderString(table_reader, "gid")); ad.Pos = DBTextResource.ParseUI(GetReaderString(table_reader, "pos_id")); ad.LvStep = DBTextResource.ParseUI(GetReaderString(table_reader, "lv_step")); ad.SwallowExpValue = DBTextResource.ParseUI(GetReaderString(table_reader, "value")); ad.GrooveNum = DBTextResource.ParseUI(GetReaderString(table_reader, "groove_num")); ad.BasicAttrs = DBTextResource.ParseDictionaryUintUint(GetReaderString(table_reader, "attrs")); data.Add(ad.Gid, ad); table_reader.Close(); table_reader.Dispose(); } return(ad); }
protected override void ParseData(SqliteDataReader reader) { if (reader == null || !reader.HasRows) { return; } mData.Clear(); while (reader.Read()) { Data data = new Data(); data.bodyId = DBTextResource.ParseUI(GetReaderString(reader, "body")); data.weaponId = DBTextResource.ParseUI(GetReaderString(reader, "weapon")); data.default_res = GetReaderString(reader, "default_res"); mData.Add((Actor.EVocationType)DBTextResource.ParseUI(GetReaderString(reader, "vocation")), data); } }
public DBHonorItem GetData(uint id) { DBHonorItem 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 DBHonorItem(); ret.Id = DBTextResource.ParseUI(GetReaderString(reader, "id")); ret.Name = GetReaderString(reader, "name"); ret.Icon = GetReaderString(reader, "icon"); ret.NeedPower = DBTextResource.ParseL(GetReaderString(reader, "need_pw")); ret.NeedGoods = DBTextResource.ParseDBGoodsItem(GetReaderString(reader, "need_goods")); ret.AddAttr = DBTextResource.ParseDBAttrItems(GetReaderString(reader, "attr")); ret.Quality = DBTextResource.ParseUI_s(GetReaderString(reader, "qual"), 0); data.Add(ret.Id, ret); reader.Close(); reader.Dispose(); return(ret); }
protected override void ParseData(SqliteDataReader reader) { if (reader == null || !reader.HasRows) { return; } while (reader.Read()) { DBFootprintItem ad = new DBFootprintItem(); ad.Id = DBTextResource.ParseUI(GetReaderString(reader, "id")); ad.EffectFile = GetReaderString(reader, "effect_file"); ad.LowEffectFile = GetReaderString(reader, "low_effect_file"); ad.DelayTime = DBTextResource.ParseF(GetReaderString(reader, "delay_time")); ad.CDTime = DBTextResource.ParseF(GetReaderString(reader, "cd_time")); ad.MinDistance = DBTextResource.ParseF(GetReaderString(reader, "min_distance")); data.Add(ad.Id, ad); } }
protected override void ParseData(SqliteDataReader reader) { if (reader == null || !reader.HasRows) { return; } #if UNITY_IPHONE mIosDevices.Clear(); while (reader.Read()) { string id = GetReaderString(reader, "id"); var quality = DBTextResource.ParseUI(GetReaderString(reader, "quality")); var device_type = (UnityEngine.iOS.DeviceGeneration)Enum.Parse(typeof(UnityEngine.iOS.DeviceGeneration), id, true); mIosDevices[device_type] = quality; } #endif }
protected override void ParseData(SqliteDataReader reader) { if (reader == null || !reader.HasRows) { return; } while (reader.Read()) { DBSysPreviewInfo info = new DBSysPreviewInfo(); info.SysId = DBTextResource.ParseUI(GetReaderString(reader, "sys_id")); info.Notice = GetReaderString(reader, "notice"); info.UiNotice = GetReaderString(reader, "ui_notice"); info.RewardId = DBTextResource.ParseUI(GetReaderString(reader, "reward_id")); info.SysDesc = GetReaderString(reader, "sys_desc"); Data.Add(info.SysId, info); } }
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); }