// -----------------------------------------------------------------------------------
// UCE_AddFactionRating
// -----------------------------------------------------------------------------------
public void UCE_AddFactionRating(UCE_Tmpl_Faction faction, int ratingAmount)
{
if (faction == null || ratingAmount == 0)
{
return;
}
int rating = UCE_GetFactionRating(faction);
if (rating == -99999)
{
UCE_Faction f = new UCE_Faction();
f.name = faction.name;
f.rating = ratingAmount;
UCE_Factions.Add(f);
}
else
{
int idx = UCE_Factions.FindIndex(x => x.name == faction.name);
UCE_Faction f = UCE_Factions.FirstOrDefault(x => x.name == faction.name);
f.rating += ratingAmount;
UCE_Factions[idx] = f;
}
UCE_TargetAddMessage(faction.name + messageFactionModified + ratingAmount.ToString());
}
// -----------------------------------------------------------------------------------
// Show
// -----------------------------------------------------------------------------------
public void Show(UCE_Faction faction)
{
UCE_Tmpl_Faction data = faction.data;
nameText.text = data.name + " [" + data.getRank(faction.rating) + "]";
factionIcon.sprite = data.image;
ratingSlider.value = faction.rating;
tooltip.enabled = true;
tooltip.text = data.name + " [" + faction.rating.ToString() + " " + data.getRank(faction.rating) + "]\n" + data.description;
}
public void CharacterLoad_UCE_Factions(Player player)
{
var table = connection.Query <character_factions>(
"SELECT faction, rating FROM character_factions WHERE character = ?", player.name);
foreach (var row in table)
{
UCE_Faction faction = new UCE_Faction {
name = row.faction, rating = row.rating
};
player.UCE_Factions.Add(faction);
}
}
public void CharacterLoad_UCE_Factions(Player player)
{
#if _MYSQL
var table = ExecuteReaderMySql("SELECT faction, rating FROM character_factions WHERE `character`=@character", new MySqlParameter("@character", player.name));
foreach (var row in table)
{
UCE_Faction faction = new UCE_Faction();
faction.name = (string)row[0];
faction.rating = Convert.ToInt32(row[1]);
player.UCE_Factions.Add(faction);
}
#elif _SQLITE
var table = ExecuteReader("SELECT faction, rating FROM character_factions WHERE character=@character", new SqliteParameter("@character", player.name));
foreach (var row in table)
{
UCE_Faction faction = new UCE_Faction();
faction.name = (string)row[0];
faction.rating = Convert.ToInt32((long)row[1]);
player.UCE_Factions.Add(faction);
}
#endif
}
private void CharacterLoad_UCE_Factions(Player player)
{
#if _MYSQL && _SERVER
var table = ExecuteReaderMySql("SELECT faction, rating FROM character_factions WHERE `character`=@character", new MySqlParameter("@character", player.name));
foreach (var row in table)
{
UCE_Faction faction = new UCE_Faction();
faction.name = (string)row[0];
faction.rating = Convert.ToInt32(row[1]);
player.UCE_Factions.Add(faction);
}
#elif _SQLITE && _SERVER
var table = connection.Query <character_factions>("SELECT faction, rating FROM character_factions WHERE character=?", player.name);
foreach (var row in table)
{
UCE_Faction faction = new UCE_Faction();
faction.name = row.faction;
faction.rating = row.rating;
player.UCE_Factions.Add(faction);
}
#endif
}
