public static void LoadNews() { using (DatabaseConnection dbConnection = new DatabaseConnection(DatabaseID.Data)) { MySql database = dbConnection.Database; //load most recent news string query = "SELECT num, news_time, message " + "FROM news WHERE news.num > (SELECT COUNT(num) FROM news) - 10"; foreach (DataColumnCollection columnCollection in database.RetrieveRowsEnumerable(query)) { int num = columnCollection["num"].ValueString.ToInt(); News.Add("[" + columnCollection["news_time"].ValueString + "] " + columnCollection["message"].ValueString); } } }
public static void LoadConfig() { using (XmlReader reader = XmlReader.Create(IO.Paths.DataFolder + "config.xml")) { while (reader.Read()) { if (reader.IsStartElement()) { switch (reader.Name) { case "GamePort": if (reader.Read()) { GamePort = reader.ReadString().ToInt(); } break; case "DatabaseIP": if (reader.Read()) { DatabaseIP = reader.ReadString(); } break; case "DatabasePort": if (reader.Read()) { DatabasePort = reader.ReadString().ToInt(); } break; case "DatabaseUser": if (reader.Read()) { DatabaseUser = reader.ReadString(); } break; case "DatabasePassword": if (reader.Read()) { DatabasePassword = reader.ReadString(); } break; } } } } using (DatabaseConnection dbConnection = new DatabaseConnection(DatabaseID.Data)) { MySql database = dbConnection.Database; //load most recent news string query = "SELECT id, message " + "FROM title WHERE title.id = 'GameName' OR title.id = 'MOTD' OR title.id = 'GameNameShort'"; foreach (DataColumnCollection columnCollection in database.RetrieveRowsEnumerable(query)) { switch (columnCollection["id"].ValueString) { case "GameName": { GameName = columnCollection["message"].ValueString; } break; case "GameNameShort": { GameNameShort = columnCollection["message"].ValueString; } break; case "MOTD": { MOTD = columnCollection["message"].ValueString; } break; } } query = "SELECT id, val " + "FROM start_value " + "WHERE start_value.id = 'Crossroads' " + "OR start_value.id = 'NewCharForm' " + "OR start_value.id = 'NewCharSpecies' " + "OR start_value.id = 'StartMap' " + "OR start_value.id = 'StartX' " + "OR start_value.id = 'StartY'"; foreach (DataColumnCollection columnCollection in database.RetrieveRowsEnumerable(query)) { switch (columnCollection["id"].ValueString) { case "Crossroads": { Crossroads = columnCollection["val"].ValueString.ToInt(); } break; case "NewCharForm": { NewCharForm = columnCollection["val"].ValueString.ToInt(); } break; case "NewCharSpecies": { NewCharSpecies = columnCollection["val"].ValueString.ToInt(); } break; case "StartMap": { StartMap = columnCollection["val"].ValueString.ToInt(); } break; case "StartX": { StartX = columnCollection["val"].ValueString.ToInt(); } break; case "StartY": { StartY = columnCollection["val"].ValueString.ToInt(); } break; } } } }