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);
}
}
