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);
}
}
