// -----------------------------------------------------------------------------------
// UCE_UnlockTravelroute
// @Server
// -----------------------------------------------------------------------------------
public void UCE_UnlockTravelroute(UCE_Unlockroute unlockroute)
{
if (unlockroute == null)
{
return;
}
string name = "";
bool pass = true;
// ------------------------------------------------------------------ get Name
if (unlockroute.teleportationTarget.Valid)
{
name = unlockroute.teleportationTarget.name;
}
// ------------------------------------------------------------------ Validate Name
if (!UCE_travelroutes.Any(t => t.name == name))
{
// -- validate and unlock
if (pass && !string.IsNullOrWhiteSpace(name))
{
UCE_TravelrouteClass tRoute = new UCE_TravelrouteClass(name);
UCE_travelroutes.Add(tRoute);
experience += unlockroute.ExpGain;
string msg = travelroutePopup.message + name;
UCE_ShowPopup(msg, travelroutePopup.iconId, travelroutePopup.soundId);
}
}
}
private void CharacterLoad_UCE_Travelroutes(Player player)
{
#if _MYSQL && _SERVER
var table = ExecuteReaderMySql("SELECT travelroute FROM character_travelroutes WHERE `character`=@name", new MySqlParameter("@name", player.name));
foreach (var row in table)
{
UCE_TravelrouteClass tRoute = new UCE_TravelrouteClass((string)row[0]);
player.UCE_travelroutes.Add(tRoute);
}
#elif _SQLITE && _SERVER
var table = connection.Query <character_travelroutes>("SELECT travelroute FROM character_travelroutes WHERE character=?", player.name);
foreach (var row in table)
{
UCE_TravelrouteClass tRoute = new UCE_TravelrouteClass(row.travelroute);
player.UCE_travelroutes.Add(tRoute);
}
#endif
}
private void CharacterLoad_UCE_Travelroutes(Player player)
{
#if _MYSQL
var table = ExecuteReaderMySql("SELECT travelroute FROM character_travelroutes WHERE `character`=@name", new MySqlParameter("@name", player.name));
foreach (var row in table)
{
UCE_TravelrouteClass tRoute = new UCE_TravelrouteClass((string)row[0]);
player.UCE_travelroutes.Add(tRoute);
}
#elif _SQLITE
var table = ExecuteReader("SELECT travelroute FROM character_travelroutes WHERE `character`=@name", new SqliteParameter("@name", player.name));
foreach (var row in table)
{
UCE_TravelrouteClass tRoute = new UCE_TravelrouteClass((string)row[0]);
player.UCE_travelroutes.Add(tRoute);
}
#endif
}
