static string ParseColor(object value) { string col = value.ToString().Trim(); if (col == "") { return(col); } // Try parse color name, then color code string parsed = Colors.Parse(col); if (parsed != "") { return(parsed); } return(Colors.Name(col) == "" ? "" : col); }
internal static void LoadInfo(DataTable playerDb, Player p) { DataRow row = playerDb.Rows[0]; p.totalLogins = int.Parse(row["totalLogin"].ToString()) + 1; p.time = row["TimeSpent"].ToString().ParseDBTime(); p.userID = int.Parse(row["ID"].ToString()); p.firstLogin = DateTime.Parse(row["firstLogin"].ToString()); p.timeLogged = DateTime.Now; p.title = row["Title"].ToString().Trim(); if (p.title != "") { p.title = p.title.Replace("[", "").Replace("]", ""); } p.titlecolor = row["title_color"].ToString().Trim(); if (p.titlecolor != "") { p.titlecolor = Colors.Parse(p.titlecolor); } else { p.titlecolor = ""; } p.color = row["color"].ToString().Trim(); if (p.color != "") { p.color = Colors.Parse(p.color); } else { p.color = p.group.color; } p.overallDeath = int.Parse(row["TotalDeaths"].ToString()); p.overallBlocks = long.Parse(row["totalBlocks"].ToString().Trim()); //money = int.Parse(playerDb.Rows[0]["Money"].ToString()); p.money = Economy.RetrieveEcoStats(p.name).money; p.loginMoney = p.money; p.totalKicked = int.Parse(row["totalKicked"].ToString()); }
public static OfflinePlayer FindOffline(string name, bool fullStats = false) { ParameterisedQuery query = ParameterisedQuery.Create(); query.AddParam("@Name", name); string syntax = Server.useMySQL ? "SELECT * FROM Players WHERE Name=@Name COLLATE utf8_general_ci" : "SELECT * FROM Players WHERE Name=@Name COLLATE NOCASE"; using (DataTable playerDB = Database.fillData(query, syntax)) { if (playerDB.Rows.Count == 0) { return(null); } OfflinePlayer pl = new OfflinePlayer(); DataRow row = playerDB.Rows[0]; pl.name = row["Name"].ToString().Trim(); pl.ip = row["IP"].ToString().Trim(); pl.totalTime = row["TimeSpent"].ToString(); pl.firstLogin = row["FirstLogin"].ToString(); pl.lastLogin = row["LastLogin"].ToString(); if (!fullStats) { return(pl); } pl.title = row["Title"].ToString().Trim(); pl.titleColor = Colors.Parse(row["title_color"].ToString().Trim()); pl.color = Colors.Parse(row["color"].ToString().Trim()); pl.money = row["Money"].ToString(); pl.deaths = row["TotalDeaths"].ToString(); pl.blocks = row["totalBlocks"].ToString(); pl.logins = row["totalLogin"].ToString(); pl.kicks = row["totalKicked"].ToString(); return(pl); } }