private void CreateStatus(HardSkill hardSkill)
{
int nextCoding = hardSkill.GetNextBonusCoding();
int nextDesign = hardSkill.GetNextBonusDesign();
int nextTesting = hardSkill.GetNextBonusTesting();
int nextArt = hardSkill.GetNextBonusArt();
int nextSound = hardSkill.GetNextBonusSound();
if (nextCoding > 0)
{
CreateTemplate(INST_CODING_ID, hardSkill.CurrentTotalBonusCodingStatus, nextCoding);
}
if (nextDesign > 0)
{
CreateTemplate(INST_DESIGN_ID, hardSkill.CurrentTotalBonusDesignStatus, nextDesign);
}
if (nextTesting > 0)
{
CreateTemplate(INST_TESTING_ID, hardSkill.CurrentTotalBonusTestingStatus, nextTesting);
}
if (nextArt > 0)
{
CreateTemplate(INST_ART_ID, hardSkill.CurrentTotalBonusArtStatus, nextArt);
}
if (nextSound > 0)
{
CreateTemplate(INST_SOUND_ID, hardSkill.CurrentTotalBonusSoundStatus, nextSound);
}
_template.SetActive(false);
}
//Optimization: Function doesn't return if all three components have been found.
void ApplySkillValues(Transform parent, Skill skill)
{
for (int i = 0; i < parent.childCount; i++)
{
Transform child = parent.GetChild(i);
if (child.CompareTag("ExpFill"))
{
child.GetComponent <Image>().fillAmount = skill.expPercentage;
}
else if (skill.IsHard() && child.CompareTag("PassionFill"))
{
HardSkill hS = (HardSkill)skill;
child.GetComponent <Image>().fillAmount = hS.passionPercentage;
}
else if (child.CompareTag("Title"))
{
parent.name = skill.title;
child.GetComponent <Text>().text = skill.title;
}
else
{
ApplySkillValues(child, skill);
}
}
}
private void OnHardSkillUpdateHandler(string id)
{
HardSkill hardSkill = hardskills[id];
switch (id)
{
case INST_Math_Id:
math_levelTMP.text = hardSkill.CurrentLevel.ToString();
mathExpImage.fillAmount = hardSkill.GetExpFillAmount();
break;
case INST_Programming_Id:
programming_levelTMP.text = hardSkill.CurrentLevel.ToString();
programmingExpImage.fillAmount = hardSkill.GetExpFillAmount();
break;
case INST_Engine_Id:
engine_levelTMP.text = hardSkill.CurrentLevel.ToString();
engineExpImage.fillAmount = hardSkill.GetExpFillAmount();
break;
case INST_Ai_Id:
ai_levelTMP.text = hardSkill.CurrentLevel.ToString();
aiExpImage.fillAmount = hardSkill.GetExpFillAmount();
break;
case INST_Network_Id:
network_levelTMP.text = hardSkill.CurrentLevel.ToString();
networkExpImage.fillAmount = hardSkill.GetExpFillAmount();
break;
case INST_Design_Id:
design_levelTMP.text = hardSkill.CurrentLevel.ToString();
designExpImage.fillAmount = hardSkill.GetExpFillAmount();
break;
case INST_Testing_Id:
testing_levelTMP.text = hardSkill.CurrentLevel.ToString();
testingExpImage.fillAmount = hardSkill.GetExpFillAmount();
break;
case INST_Art_Id:
art_levelTMP.text = hardSkill.CurrentLevel.ToString();
artExpImage.fillAmount = hardSkill.GetExpFillAmount();
break;
case INST_Sound_Id:
sound_levelTMP.text = hardSkill.CurrentLevel.ToString();
soundExpImage.fillAmount = hardSkill.GetExpFillAmount();
break;
}
}
private void DisplayedHardSkill()
{
int i = 0;
foreach (KeyValuePair <string, HardSkill> hardskill in hardSkillsController.Hardskills)
{
HardSkill hardSkill = hardskill.Value;
if (!ReferenceEquals(hardSkill, null))
{
hardSkillSlots[i].HARDSKILL = hardskill.Value;
}
i++;
}
}
public BaseSkill GetSkillByLevelAndID(int skillid, int skilllevel)
{
DbParameter skillIdParameter = _db.CreateParameter(DbNames.GETSKILLBYLEVELANDID_SKILLID_PARAMETER, skillid);
skillIdParameter.DbType = DbType.Int32;
DbParameter skillLevelParameter = _db.CreateParameter(DbNames.GETSKILLBYLEVELANDID_SKILLLEVEL_PARAMETER, skilllevel);
skillLevelParameter.DbType = DbType.Int32;
_db.Open();
DbDataReader reader = _db.ExcecuteReader(DbNames.GETSKILLBYLEVELANDID_STOREDPROC, CommandType.StoredProcedure, skillLevelParameter, skillIdParameter);
int ordinalSkill_skillid = reader.GetOrdinal(DbNames.SKILL_SKILLID);
int ordinalSkill_skilllevel = reader.GetOrdinal(DbNames.SKILL_SKILLLEVEL);
int ordinalSkill_requiredlevel = reader.GetOrdinal(DbNames.SKILL_REQUIREDLEVEL);
int ordinalSkill_requiredstr = reader.GetOrdinal(DbNames.SKILL_REQUIREDSTR);
int ordinalSkill_requiredsta = reader.GetOrdinal(DbNames.SKILL_REQUIREDSTA);
int ordinalSkill_requireddex = reader.GetOrdinal(DbNames.SKILL_REQUIREDDEX);
int ordinalSkill_requiredene = reader.GetOrdinal(DbNames.SKILL_REQUIREDENE);
int ordinalSkill_manacost = reader.GetOrdinal(DbNames.SKILL_MANACOST);
int ordinalSkill_predelay = reader.GetOrdinal(DbNames.SKILL_PREDELAY);
int ordinalSkill_postdelay = reader.GetOrdinal(DbNames.SKILL_POSTDELAY);
int ordinalSkill_requiredtraining = reader.GetOrdinal(DbNames.SKILL_REQUIREDTRAINING);
int ordinalSkill_readonlybook = reader.GetOrdinal(DbNames.SKILL_READONLYBOOK);
int ordinalSkill_incdamage = reader.GetOrdinal(DbNames.SKILL_INCDAMAGE);
int ordinalSkill_incdamageperc = reader.GetOrdinal(DbNames.SKILL_INCDAMAGEPERC);
int ordinalSkill_incdefense = reader.GetOrdinal(DbNames.SKILL_INCDEFENSE);
int ordinalSkill_incdefenseperc = reader.GetOrdinal(DbNames.SKILL_INCDEFENSEPERC);
int ordinalSkill_incattackrating = reader.GetOrdinal(DbNames.SKILL_INCATTACKRATING);
int ordinalSkill_incattackratingperc = reader.GetOrdinal(DbNames.SKILL_INCATTACKRATINGPERC);
int ordinalSkill_inchpmax = reader.GetOrdinal(DbNames.SKILL_INCHPMAX);
int ordinalSkill_inchpcur = reader.GetOrdinal(DbNames.SKILL_INCHPCUR);
int ordinalSkill_inchpcurperc = reader.GetOrdinal(DbNames.SKILL_INCHPCURPERC);
int ordinalSkill_recoverhp = reader.GetOrdinal(DbNames.SKILL_RECOVERHP);
int ordinalSkill_recoverhpperc = reader.GetOrdinal(DbNames.SKILL_RECOVERHPPERC);
int ordinalSkill_incmanamax = reader.GetOrdinal(DbNames.SKILL_INCMANAMAX);
int ordinalSkill_incmanacur = reader.GetOrdinal(DbNames.SKILL_INCMANACUR);
int ordinalSkill_incmanacurperc = reader.GetOrdinal(DbNames.SKILL_INCMANACURPERC);
int ordinalSkill_recovermana = reader.GetOrdinal(DbNames.SKILL_RECOVERMANA);
int ordinalSkill_recovermanaperc = reader.GetOrdinal(DbNames.SKILL_RECOVERMANAPERC);
int ordinalSkill_inccritical = reader.GetOrdinal(DbNames.SKILL_INCCRITICAL);
int ordinalSkill_inccriticalperc = reader.GetOrdinal(DbNames.SKILL_INCCRITICALPERC);
int ordinalSkill_incpkperc = reader.GetOrdinal(DbNames.SKILL_INCPKPERC);
int ordinalSkill_keepuptime = reader.GetOrdinal(DbNames.SKILL_KEEPUPTIME);
int ordinalSkill_distance = reader.GetOrdinal(DbNames.SKILL_DISTANCE);
int ordinalSkill_successchance = reader.GetOrdinal(DbNames.SKILL_SUCCESSCHANCE);
int ordinalSkill_netc1 = reader.GetOrdinal(DbNames.SKILL_NETC1);
int ordinalSkill_netc2 = reader.GetOrdinal(DbNames.SKILL_NETC2);
int ordinalSkill_netc3 = reader.GetOrdinal(DbNames.SKILL_NETC3);
BaseSkill skill = null;
while (reader.Read())
{
short id = reader.GetInt16(ordinalSkill_skillid);
if (id <= 15)
skill = new SoftSkill();
else
skill = new HardSkill();
skill.SkillID = reader.GetInt16(ordinalSkill_skillid);
skill.SkillLevel = reader.GetByte(ordinalSkill_skilllevel);
skill.RequiredLevel = reader.GetByte(ordinalSkill_requiredlevel);
skill.RequiredStrength = reader.GetInt16(ordinalSkill_requiredstr);
skill.RequiredStamina = reader.GetInt16(ordinalSkill_requiredsta);
skill.RequiredDexterity = reader.GetInt16(ordinalSkill_requireddex);
skill.RequiredEnergy = reader.GetInt16(ordinalSkill_requiredene);
skill.ManaCost = reader.GetInt16(ordinalSkill_manacost);
skill.PreDelay = reader.GetInt16(ordinalSkill_predelay);
skill.PostDelay = reader.GetInt16(ordinalSkill_postdelay);
skill.RequiredTraining = reader.GetInt16(ordinalSkill_requiredtraining);
skill.ReadOnlyBook = reader.GetByte(ordinalSkill_readonlybook);
skill.IncDamage = reader.GetInt16(ordinalSkill_incdamage);
skill.IncDamagePerc = reader.GetInt16(ordinalSkill_incdamageperc);
skill.IncDefense = reader.GetInt16(ordinalSkill_incdefense);
skill.IncDefensePerc = reader.GetInt16(ordinalSkill_incdefenseperc);
skill.IncAttackRating = reader.GetInt16(ordinalSkill_incattackrating);
skill.IncAttackRatingPerc = reader.GetInt16(ordinalSkill_incattackratingperc);
skill.IncHpMax = reader.GetInt16(ordinalSkill_inchpmax);
skill.IncHpCur = reader.GetInt16(ordinalSkill_inchpcur);
skill.IncHpCurPerc = reader.GetInt16(ordinalSkill_inchpcurperc);
skill.RecoverHp = reader.GetInt16(ordinalSkill_recoverhp);
skill.RecoverHpPerc = reader.GetInt16(ordinalSkill_recoverhpperc);
skill.IncManaMax = reader.GetInt16(ordinalSkill_incmanamax);
skill.IncManaCur = reader.GetInt16(ordinalSkill_incmanacur);
skill.IncManaCurPerc = reader.GetInt16(ordinalSkill_incmanacurperc);
skill.RecoverMana = reader.GetInt16(ordinalSkill_recovermana);
skill.RecoverManaPerc = reader.GetInt16(ordinalSkill_recovermanaperc);
skill.IncCritical = reader.GetInt16(ordinalSkill_inccritical);
skill.IncCriticalPerc = reader.GetInt16(ordinalSkill_inccriticalperc);
skill.IncPKPerc = reader.GetInt16(ordinalSkill_incpkperc);
skill.KeepUpTime = reader.GetInt32(ordinalSkill_keepuptime);
skill.Distance = reader.GetInt16(ordinalSkill_distance);
skill.SuccessChance = reader.GetInt16(ordinalSkill_successchance);
skill.nEtc1 = reader.GetInt32(ordinalSkill_netc1);
skill.nEtc2 = reader.GetInt32(ordinalSkill_netc2);
skill.nEtc3 = reader.GetInt32(ordinalSkill_netc3);
}
reader.Close();
_db.Close();
return skill;
}
public void CreateTemplate(HardSkill hardSkill)
{
_template.SetActive(true);
ClearTmeplate();
CreateStatus(hardSkill);
}
public BaseSkill GetSkillByLevelAndID(int skillid, int skilllevel)
{
DbParameter skillIdParameter = _db.CreateParameter(DbNames.GETSKILLBYLEVELANDID_SKILLID_PARAMETER, skillid);
skillIdParameter.DbType = DbType.Int32;
DbParameter skillLevelParameter = _db.CreateParameter(DbNames.GETSKILLBYLEVELANDID_SKILLLEVEL_PARAMETER, skilllevel);
skillLevelParameter.DbType = DbType.Int32;
_db.Open();
DbDataReader reader = _db.ExcecuteReader(DbNames.GETSKILLBYLEVELANDID_STOREDPROC, CommandType.StoredProcedure, skillLevelParameter, skillIdParameter);
int ordinalSkill_skillid = reader.GetOrdinal(DbNames.SKILL_SKILLID);
int ordinalSkill_skilllevel = reader.GetOrdinal(DbNames.SKILL_SKILLLEVEL);
int ordinalSkill_requiredlevel = reader.GetOrdinal(DbNames.SKILL_REQUIREDLEVEL);
int ordinalSkill_requiredstr = reader.GetOrdinal(DbNames.SKILL_REQUIREDSTR);
int ordinalSkill_requiredsta = reader.GetOrdinal(DbNames.SKILL_REQUIREDSTA);
int ordinalSkill_requireddex = reader.GetOrdinal(DbNames.SKILL_REQUIREDDEX);
int ordinalSkill_requiredene = reader.GetOrdinal(DbNames.SKILL_REQUIREDENE);
int ordinalSkill_manacost = reader.GetOrdinal(DbNames.SKILL_MANACOST);
int ordinalSkill_predelay = reader.GetOrdinal(DbNames.SKILL_PREDELAY);
int ordinalSkill_postdelay = reader.GetOrdinal(DbNames.SKILL_POSTDELAY);
int ordinalSkill_requiredtraining = reader.GetOrdinal(DbNames.SKILL_REQUIREDTRAINING);
int ordinalSkill_readonlybook = reader.GetOrdinal(DbNames.SKILL_READONLYBOOK);
int ordinalSkill_incdamage = reader.GetOrdinal(DbNames.SKILL_INCDAMAGE);
int ordinalSkill_incdamageperc = reader.GetOrdinal(DbNames.SKILL_INCDAMAGEPERC);
int ordinalSkill_incdefense = reader.GetOrdinal(DbNames.SKILL_INCDEFENSE);
int ordinalSkill_incdefenseperc = reader.GetOrdinal(DbNames.SKILL_INCDEFENSEPERC);
int ordinalSkill_incattackrating = reader.GetOrdinal(DbNames.SKILL_INCATTACKRATING);
int ordinalSkill_incattackratingperc = reader.GetOrdinal(DbNames.SKILL_INCATTACKRATINGPERC);
int ordinalSkill_inchpmax = reader.GetOrdinal(DbNames.SKILL_INCHPMAX);
int ordinalSkill_inchpcur = reader.GetOrdinal(DbNames.SKILL_INCHPCUR);
int ordinalSkill_inchpcurperc = reader.GetOrdinal(DbNames.SKILL_INCHPCURPERC);
int ordinalSkill_recoverhp = reader.GetOrdinal(DbNames.SKILL_RECOVERHP);
int ordinalSkill_recoverhpperc = reader.GetOrdinal(DbNames.SKILL_RECOVERHPPERC);
int ordinalSkill_incmanamax = reader.GetOrdinal(DbNames.SKILL_INCMANAMAX);
int ordinalSkill_incmanacur = reader.GetOrdinal(DbNames.SKILL_INCMANACUR);
int ordinalSkill_incmanacurperc = reader.GetOrdinal(DbNames.SKILL_INCMANACURPERC);
int ordinalSkill_recovermana = reader.GetOrdinal(DbNames.SKILL_RECOVERMANA);
int ordinalSkill_recovermanaperc = reader.GetOrdinal(DbNames.SKILL_RECOVERMANAPERC);
int ordinalSkill_inccritical = reader.GetOrdinal(DbNames.SKILL_INCCRITICAL);
int ordinalSkill_inccriticalperc = reader.GetOrdinal(DbNames.SKILL_INCCRITICALPERC);
int ordinalSkill_incpkperc = reader.GetOrdinal(DbNames.SKILL_INCPKPERC);
int ordinalSkill_keepuptime = reader.GetOrdinal(DbNames.SKILL_KEEPUPTIME);
int ordinalSkill_distance = reader.GetOrdinal(DbNames.SKILL_DISTANCE);
int ordinalSkill_successchance = reader.GetOrdinal(DbNames.SKILL_SUCCESSCHANCE);
int ordinalSkill_netc1 = reader.GetOrdinal(DbNames.SKILL_NETC1);
int ordinalSkill_netc2 = reader.GetOrdinal(DbNames.SKILL_NETC2);
int ordinalSkill_netc3 = reader.GetOrdinal(DbNames.SKILL_NETC3);
BaseSkill skill = null;
while (reader.Read())
{
short id = reader.GetInt16(ordinalSkill_skillid);
if (id <= 15)
{
skill = new SoftSkill();
}
else
{
skill = new HardSkill();
}
skill.SkillID = reader.GetInt16(ordinalSkill_skillid);
skill.SkillLevel = reader.GetByte(ordinalSkill_skilllevel);
skill.RequiredLevel = reader.GetByte(ordinalSkill_requiredlevel);
skill.RequiredStrength = reader.GetInt16(ordinalSkill_requiredstr);
skill.RequiredStamina = reader.GetInt16(ordinalSkill_requiredsta);
skill.RequiredDexterity = reader.GetInt16(ordinalSkill_requireddex);
skill.RequiredEnergy = reader.GetInt16(ordinalSkill_requiredene);
skill.ManaCost = reader.GetInt16(ordinalSkill_manacost);
skill.PreDelay = reader.GetInt16(ordinalSkill_predelay);
skill.PostDelay = reader.GetInt16(ordinalSkill_postdelay);
skill.RequiredTraining = reader.GetInt16(ordinalSkill_requiredtraining);
skill.ReadOnlyBook = reader.GetByte(ordinalSkill_readonlybook);
skill.IncDamage = reader.GetInt16(ordinalSkill_incdamage);
skill.IncDamagePerc = reader.GetInt16(ordinalSkill_incdamageperc);
skill.IncDefense = reader.GetInt16(ordinalSkill_incdefense);
skill.IncDefensePerc = reader.GetInt16(ordinalSkill_incdefenseperc);
skill.IncAttackRating = reader.GetInt16(ordinalSkill_incattackrating);
skill.IncAttackRatingPerc = reader.GetInt16(ordinalSkill_incattackratingperc);
skill.IncHpMax = reader.GetInt16(ordinalSkill_inchpmax);
skill.IncHpCur = reader.GetInt16(ordinalSkill_inchpcur);
skill.IncHpCurPerc = reader.GetInt16(ordinalSkill_inchpcurperc);
skill.RecoverHp = reader.GetInt16(ordinalSkill_recoverhp);
skill.RecoverHpPerc = reader.GetInt16(ordinalSkill_recoverhpperc);
skill.IncManaMax = reader.GetInt16(ordinalSkill_incmanamax);
skill.IncManaCur = reader.GetInt16(ordinalSkill_incmanacur);
skill.IncManaCurPerc = reader.GetInt16(ordinalSkill_incmanacurperc);
skill.RecoverMana = reader.GetInt16(ordinalSkill_recovermana);
skill.RecoverManaPerc = reader.GetInt16(ordinalSkill_recovermanaperc);
skill.IncCritical = reader.GetInt16(ordinalSkill_inccritical);
skill.IncCriticalPerc = reader.GetInt16(ordinalSkill_inccriticalperc);
skill.IncPKPerc = reader.GetInt16(ordinalSkill_incpkperc);
skill.KeepUpTime = reader.GetInt32(ordinalSkill_keepuptime);
skill.Distance = reader.GetInt16(ordinalSkill_distance);
skill.SuccessChance = reader.GetInt16(ordinalSkill_successchance);
skill.nEtc1 = reader.GetInt32(ordinalSkill_netc1);
skill.nEtc2 = reader.GetInt32(ordinalSkill_netc2);
skill.nEtc3 = reader.GetInt32(ordinalSkill_netc3);
}
reader.Close();
_db.Close();
return(skill);
}
