public static void SaveMOTD() { //save motd using (DatabaseConnection dbConnection = new DatabaseConnection(DatabaseID.Data)) { MySql database = dbConnection.Database; database.UpdateOrInsert("title", new IDataColumn[] { database.CreateColumn(true, "id", "MOTD"), database.CreateColumn(false, "message", MOTD) }); } }
public static void AddNews(string newNews) { string date = DateTime.Now.ToString("yyyy-mm-dd hh:mm:ss"); News.Add("[" + date + "] " + newNews); using (DatabaseConnection dbConnection = new DatabaseConnection(DatabaseID.Data)) { MySql database = dbConnection.Database; database.AddRow("news", new IDataColumn[] { database.CreateColumn(false, "message", newNews) }); } }