public void Save()
{
Logger.Log("Saving " + Username + " to the database", LogType.Debug);
List <string> commands = new List <string>();
commands.Add("UPDATE _players SET money=" + Money + ", lastlogin='******', firstlogin='******' WHERE UID=" + UID);
commands.Add("UPDATE _players SET color='" + Color.SqlEscape() + "' WHERE UID=" + UID);
DataSaved.Call(this, new DataSavedEventArgs(UID));
Database.executeQuery(commands.ToArray());
}
public void save()
{
OnSQLSaveEvent.Call(this);
if (cancelmysql)
{
cancelmysql = false; return;
}
// Player disconnected before SQL data was retrieved
if (!gotSQLData)
{
return;
}
long blocks = PlayerData.Pack(TotalPlaced, TotalModified);
long drawn = PlayerData.Pack(TotalDeleted, TotalDrawn);
Database.UpdateRows("Players", "IP=@0, LastLogin=@1, totalLogin=@2, totalDeaths=@3, Money=@4, " +
"totalBlocks=@5, totalCuboided=@6, totalKicked=@7, TimeSpent=@8, Messages=@9", "WHERE Name=@10",
ip, LastLogin.ToString(Database.DateFormat),
TimesVisited, TimesDied, money, blocks,
drawn, TimesBeenKicked, (long)TotalTime.TotalSeconds, TotalMessagesSent, name);
}
public string GetLastLogin()
{
return(LastLogin.ToString());
}
public void Load()
{
Logger.Log("Loading " + Username + " from the database", LogType.Debug);
DataTable playerdb = Database.fillData("SELECT * FROM _players WHERE Name='" + Username.SqlEscape() + "'");
if (playerdb.Rows.Count == 0)
{
FirstLogin = DateTime.Now;
LastLogin = DateTime.Now;
Money = 0;
Database.executeQuery("INSERT INTO _players (Name, IP, firstlogin, lastlogin, money, color) VALUES ('" + Username.SqlEscape() + "', '" + Ip.SqlEscape() + "', '" + FirstLogin.ToString("yyyy-MM-dd HH:mm:ss").SqlEscape() + "', '" + LastLogin.ToString("yyyy-MM-dd HH:mm:ss").SqlEscape() + "', 0, '" + Color.SqlEscape() + "')");
DataTable temp = Database.fillData("SELECT * FROM _players WHERE Name='" + Username.SqlEscape() + "'");
if (temp.Rows.Count != 0)
{
UID = int.Parse(temp.Rows[0]["UID"].ToString());
}
temp.Dispose();
}
else
{
UID = int.Parse(playerdb.Rows[0]["UID"].ToString());
FirstLogin = DateTime.Parse(playerdb.Rows[0]["firstlogin"].ToString());
LastLogin = DateTime.Now;
Money = int.Parse(playerdb.Rows[0]["money"].ToString());
Color = playerdb.Rows[0]["color"].ToString();
//TODO Add total login and total Blocks
}
playerdb.Dispose();
LoadExtra();
//Because milk
this.OnPlayerDisconnect.Important += delegate {
Save();
};
}
void InitializeButtons()
{
arr = new char[4];
if (PlayerPrefs.HasKey("DataStream"))
{
arr = PlayerPrefs.GetString("DataStream").ToCharArray();
CurrentTime = DateTime.Now;
if (PlayerPrefs.HasKey("LastLogin"))
{
for (int i = 0; i < 4; i++)
{
MakeButtonsInteractive(i, false);
}
if (arr[0] == '0')
{
MakeButtonsInteractive(0, true);
}
if (arr[1] == '0')
{
MakeButtonsInteractive(1, true);
}
if (arr[2] == '0')
{
MakeButtonsInteractive(2, true);
}
if (arr[3] == '0')
{
MakeButtonsInteractive(3, true);
}
if (arr[0] == '1' || arr[1] == '1' || arr[2] == '1' || arr[3] == '1')
{
LastLogin = DateTime.Parse(PlayerPrefs.GetString("LastLogin"), System.Globalization.CultureInfo.CurrentCulture);
Debug.Log(LastLogin.ToString());
if (DateTime.Compare(LastLogin.Date, CurrentTime.Date) < 0)
{
for (int i = 0; i < 4; i++)
{
MakeButtonsInteractive(i, true);
}
}
else
{
for (int i = 0; i < 4; i++)
{
MakeButtonsInteractive(i, false);
}
}
}
}
else
{
for (int i = 0; i < 4; i++)
{
MakeButtonsInteractive(i, true);
}
}
}
else
{
for (int i = 0; i < 4; i++)
{
MakeButtonsInteractive(i, true);
}
}
}
public override string ToString()
{
const string oddelovac = MujSystem.oddelovac;
string s = JeAdmin.ToString() + oddelovac + Username + oddelovac + HesloHash + oddelovac + Jmeno + oddelovac + Prijmeni + oddelovac + LastLogin.ToString() + oddelovac + ChciNoveHeslo.ToString();
return(s);
}