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