static bool InitNpcWithDb(PeEntity entity, Mono.Data.SqliteClient.SqliteDataReader reader) { string strTemp = reader.GetString(reader.GetOrdinal("startpoint")); string[] pos = strTemp.Split(','); if (pos.Length < 3) { Debug.LogError("Npc's StartPoint is Error"); } else { float x = System.Convert.ToSingle(pos[0]); float y = System.Convert.ToSingle(pos[1]); float z = System.Convert.ToSingle(pos[2]); PeTrans view = entity.peTrans; if (null != view) { view.position = new Vector3(x, y, z); } NpcCmpt cmpt = entity.NpcCmpt; if (null != cmpt) { cmpt.FixedPointPos = new Vector3(x, y, z); } } SetNpcMoney(entity, reader.GetString(reader.GetOrdinal("money"))); AddWeaponItem(entity, reader.GetString(reader.GetOrdinal("weapon")), reader.GetString(reader.GetOrdinal("item"))); SetNpcAbility(entity, reader.GetString(reader.GetOrdinal("speciality"))); return(true); }
public static void CreateStoryLineNpcFromID(int npcID, Vector3 position) { Mono.Data.SqliteClient.SqliteDataReader reader = LocalDatabase.Instance.ReadFullTable("NPC"); NpcMissionDataRepository.Reset(); while (reader.Read()) { int id = Convert.ToInt32(reader.GetString(reader.GetOrdinal("NPC_ID"))); int protoId = Convert.ToInt32(reader.GetString(reader.GetOrdinal("PrototypeNPC"))); if (id == npcID) { PeEntity entity = PeCreature.Instance.CreateNpc(id, protoId, Vector3.zero, Quaternion.identity, Vector3.one); if (entity == null) { continue; } InitNpcWithDb(entity, reader); NpcMissionData nmd = NpcMissionDataRepository.GetMissionData(entity.Id); entity.SetUserData(nmd); SetNpcShopIcon(entity); entity.position = position; break; } } }
public static void LoadData() { Mono.Data.SqliteClient.SqliteDataReader reader = LocalDatabase.Instance.ReadFullTable("colonyinfo"); while (reader.Read()) { int id = Convert.ToInt32(reader.GetString(reader.GetOrdinal("id"))); PublicAttr(GetInfo(id), reader); string str = reader.GetString(reader.GetOrdinal("_property")); if (str != "0") { SplitInfo(str, id); } } }
public static void LoadData() { _protoDescs = new List <PrototypeDesc>(); Mono.Data.SqliteClient.SqliteDataReader reader = LocalDatabase.Instance.ReadFullTable("PrototypeEffect"); while (reader.Read()) { PrototypeDesc rand = new PrototypeDesc(); rand._pid = System.Convert.ToInt32(reader.GetString(reader.GetOrdinal("id"))); rand._strAssetbundle = null; rand._strPrefab = reader.GetString(reader.GetOrdinal("prefab_path")); _protoDescs.Add(rand); } }
public static void LoadData() { Mono.Data.SqliteClient.SqliteDataReader reader = LocalDatabase.Instance.ReadFullTable("NPCMission"); while (reader.Read()) { NpcMissionData missionData = new NpcMissionData(); int id = System.Convert.ToInt32(reader.GetString(reader.GetOrdinal("NPC_ID"))); string strTemp = reader.GetString(reader.GetOrdinal("missionlist")); string[] missionlist = strTemp.Split(','); for (int i = 0; i < missionlist.Length; i++) { if (missionlist[i] != "0") { missionData.m_MissionList.Add(System.Convert.ToInt32(missionlist[i])); } } strTemp = reader.GetString(reader.GetOrdinal("missionlistreply")); string[] missionlistreply = strTemp.Split(','); for (int i = 0; i < missionlistreply.Length; i++) { if (missionlistreply[i] != "0") { missionData.AddMissionListReply(System.Convert.ToInt32(missionlistreply[i])); } } strTemp = reader.GetString(reader.GetOrdinal("Colony_RecruitMissionID")); missionlist = strTemp.Split(','); for (int i = 0; i < missionlist.Length; i++) { if (missionlist[i] != "0") { missionData.m_CSRecruitMissionList.Add(Convert.ToInt32(missionlist[i])); } } NpcMissionDataRepository.AddMissionData(id, missionData); } LoadNpcRandomMissionData(); LoadAdRandMisNpcData(); }
public static void LoadData() { Mono.Data.SqliteClient.SqliteDataReader reader = LocalDatabase.Instance.ReadFullTable("MountsSkill"); _mounstersIndex = new int[100]; _MskillDatas = new int[50][][]; _prounceData = new Dictionary <int, string>(); try { while (reader.Read()) { int id = Convert.ToInt32(reader.GetString(reader.GetOrdinal("ID"))); int MonsterID = Convert.ToInt32(reader.GetString(reader.GetOrdinal("MonsterID"))); _mounstersIndex[MonsterID] = id; _MskillDatas[id] = new int[(int)Pathea.MountsSkillKey.Max][]; _MskillDatas[id][(int)Pathea.MountsSkillKey.Mskill_L] = PETools.PEUtil.ToArrayInt32(reader.GetString(reader.GetOrdinal("SkillLeft")), ','); _MskillDatas[id][(int)Pathea.MountsSkillKey.Mskill_Space] = PETools.PEUtil.ToArrayInt32(reader.GetString(reader.GetOrdinal("SkillSpace")), ','); string[] str0 = PETools.PEUtil.ToArrayString(reader.GetString(reader.GetOrdinal("SkillJump")), ','); List <int> jum = new List <int>(); if (str0 != null) { for (int i = 0; i < str0.Length; i++) { string[] str1 = PETools.PEUtil.ToArrayString(str0[i], ':'); if (str1.Length == 2) { jum.Add(System.Convert.ToInt32(str1[0])); _prounceData.Add(System.Convert.ToInt32(str1[0]), str1[1]); } } } _MskillDatas[id][(int)Pathea.MountsSkillKey.Mskill_pounce] = jum.ToArray(); _MskillDatas[id][(int)Pathea.MountsSkillKey.Mskill_tame] = PETools.PEUtil.ToArrayInt32(reader.GetString(reader.GetOrdinal("RideAnim")), ','); } } catch { Debug.LogError("mounstsSKill !!!!"); } }
static float[] ReadFromDb(Mono.Data.SqliteClient.SqliteDataReader reader) { float[] attributeArray = new float[(int)Pathea.AttribType.Max]; for (int i = (int)Pathea.AttribType.HpMax; i < (int)Pathea.AttribType.Max; i++) { Pathea.AttribType a = (Pathea.AttribType)i; string attributeName = a.ToString(); attributeArray[i] = System.Convert.ToSingle(reader.GetString(reader.GetOrdinal(attributeName))); } return(attributeArray); }
public static void CreateStoryLineNpc() { Mono.Data.SqliteClient.SqliteDataReader reader = LocalDatabase.Instance.ReadFullTable("NPC"); NpcMissionDataRepository.Reset(); while (reader.Read()) { int id = Convert.ToInt32(reader.GetString(reader.GetOrdinal("NPC_ID"))); int protoId = Convert.ToInt32(reader.GetString(reader.GetOrdinal("PrototypeNPC"))); if (PeGameMgr.IsMultiStory) { return; // string strTemp = reader.GetString(reader.GetOrdinal("startpoint")); // string[] pos = strTemp.Split(','); // if (pos.Length < 3) // { // Debug.LogError("Npc's StartPoint is Error"); // } // else // { // float x = System.Convert.ToSingle(pos[0]); // float y = System.Convert.ToSingle(pos[1]); // float z = System.Convert.ToSingle(pos[2]); // Vector3 startPos = new Vector3(x, y, z); // PlayerNetwork.MainPlayer.RequestCreateStNpc(id, startPos,protoId); // } // continue; } PeEntity entity = PeCreature.Instance.CreateNpc(id, protoId, Vector3.zero, Quaternion.identity, Vector3.one); if (entity == null) { continue; } InitNpcWithDb(entity, reader); NpcMissionData nmd = NpcMissionDataRepository.GetMissionData(entity.Id); entity.SetUserData(nmd); SetNpcShopIcon(entity); } }
static void PublicAttr(CSInfo info, Mono.Data.SqliteClient.SqliteDataReader reader) { info.m_Durability = Convert.ToSingle(reader.GetString(reader.GetOrdinal("durability"))); info.m_RepairTime = Convert.ToSingle(reader.GetString(reader.GetOrdinal("repairtime"))); info.m_DeleteTime = Convert.ToSingle(reader.GetString(reader.GetOrdinal("deletetime"))); info.m_Power = Convert.ToSingle(reader.GetString(reader.GetOrdinal("power"))); info.m_WorkersCnt = Convert.ToInt32(reader.GetString(reader.GetOrdinal("workerscnt"))); info.workSound = Convert.ToInt32(reader.GetString(reader.GetOrdinal("worksound"))); if (Application.isEditor) { info.m_DeleteTime = 20; } }
public static void LoadAdRandMisNpcData() { Mono.Data.SqliteClient.SqliteDataReader reader = LocalDatabase.Instance.ReadFullTable("AdRandNPCMission"); while (reader.Read()) { AdNpcData adNpcData = new AdNpcData(); adNpcData.mID = Convert.ToInt32(reader.GetString(reader.GetOrdinal("ID"))); adNpcData.mRnpc_ID = Convert.ToInt32(reader.GetString(reader.GetOrdinal("RNPC_ID"))); adNpcData.mRecruitQC_ID = Convert.ToInt32(reader.GetString(reader.GetOrdinal("RecruitQC_ID"))); adNpcData.mArea = Convert.ToInt32(reader.GetString(reader.GetOrdinal("Area"))); adNpcData.mWild = Convert.ToInt32(reader.GetString(reader.GetOrdinal("Wild"))); string strTmp = reader.GetString(reader.GetOrdinal("QC_ID")); string[] tmpList0 = strTmp.Split('_'); string[] tmpList = tmpList0[0].Split(';'); for (int i = 0; i < tmpList.Length; i++) { string[] listTmp1 = tmpList[i].Split(','); if (listTmp1.Length != 2) { continue; } GroupInfo gi; gi.id = Convert.ToInt32(listTmp1[0]); gi.radius = Convert.ToInt32(listTmp1[1]); adNpcData.mQC_IDList.Add(gi); } strTmp = reader.GetString(reader.GetOrdinal("Colony_RecruitMissionChainID")); tmpList = strTmp.Split(','); for (int i = 0; i < tmpList.Length; i++) { if (tmpList[i] != "0") { adNpcData.m_CSRecruitMissionList.Add(Convert.ToInt32(tmpList[i])); } } m_AdRandMisNpcData.Add(adNpcData.mID, adNpcData); } }
public static void CreateTutorialLineNpc() { Mono.Data.SqliteClient.SqliteDataReader reader = LocalDatabase.Instance.ReadFullTable("NPC"); while (reader.Read()) { int id = Convert.ToInt32(reader.GetString(reader.GetOrdinal("NPC_ID"))); int protoId = Convert.ToInt32(reader.GetString(reader.GetOrdinal("PrototypeNPC"))); string strTemp = reader.GetString(reader.GetOrdinal("training_pos")); if (strTemp != "0,0,0") { string[] strPos = strTemp.Split(','); Vector3 pos = Vector3.zero; if (strPos.Length < 3) { Debug.LogError("Npc's StartPoint is Error at NPC_ID=" + id); } else { pos.x = System.Convert.ToSingle(strPos[0]); pos.y = System.Convert.ToSingle(strPos[1]); pos.z = System.Convert.ToSingle(strPos[2]); } PeEntity entity = PeCreature.Instance.CreateNpc(id, protoId, pos, Quaternion.identity, Vector3.one); if (entity == null) { continue; } SetNpcMoney(entity, reader.GetString(reader.GetOrdinal("money"))); AddWeaponItem(entity, reader.GetString(reader.GetOrdinal("weapon")), reader.GetString(reader.GetOrdinal("item"))); SetNpcAbility(entity, reader.GetString(reader.GetOrdinal("speciality"))); NpcMissionData nmd = NpcMissionDataRepository.GetMissionData(entity.Id); entity.SetUserData(nmd); SetNpcShopIcon(entity); } } }
static void LoadNpcRandomMissionData() { Mono.Data.SqliteClient.SqliteDataReader reader = LocalDatabase.Instance.ReadFullTable("RandNPCMission"); while (reader.Read()) { NpcMissionData missionData = new NpcMissionData(); missionData.mCurComMisNum = 0; int id = Convert.ToInt32(reader.GetString(reader.GetOrdinal("ID"))); missionData.m_Rnpc_ID = Convert.ToInt32(reader.GetString(reader.GetOrdinal("RNPC_ID"))); string tmp; string[] tmplist; tmp = reader.GetString(reader.GetOrdinal("natalplace")); tmplist = tmp.Split(','); if (tmplist.Length == 3) { float x = Convert.ToSingle(tmplist[0]); float y = Convert.ToSingle(tmplist[1]); float z = Convert.ToSingle(tmplist[2]); missionData.m_Pos = new Vector3(x, y, z); } tmp = reader.GetString(reader.GetOrdinal("Rmissionlist")); if (tmp != "0") { missionData.m_RandomMission = Convert.ToInt32(tmp); } tmp = reader.GetString(reader.GetOrdinal("missionlist")); tmplist = tmp.Split(','); for (int i = 0; i < tmplist.Length; i++) { if (tmplist[i] != "0") { missionData.m_MissionList.Add(Convert.ToInt32(tmplist[i])); } } tmp = reader.GetString(reader.GetOrdinal("RecruitMissionID")); tmplist = tmp.Split(','); for (int i = 0; i < tmplist.Length; i++) { if (tmplist[i] != "0") { missionData.m_RecruitMissionList.Add(Convert.ToInt32(tmplist[i])); } } missionData.mCompletedMissionCount = Convert.ToInt32(reader.GetString(reader.GetOrdinal("RecruitMissionNum"))); tmp = reader.GetString(reader.GetOrdinal("Colony_RecruitMissionID")); tmplist = tmp.Split(','); for (int i = 0; i < tmplist.Length; i++) { if (tmplist[i] != "0") { missionData.m_CSRecruitMissionList.Add(Convert.ToInt32(tmplist[i])); } } missionData.m_bRandomNpc = true; NpcMissionDataRepository.AddMissionData(id, missionData); } }