// ----------------------------------------------------------------------------------- // 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 }