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