public void Refresh()
{
refreshTimer = 0;
servers.Clear();
string connectionString = String.Format("Server = {0}; database = {1}; UID = {2}; password = {3}", sqlServer, database, UID, password);
string queryString = "SELECT * FROM servers";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
MySqlCommand command = new MySqlCommand(queryString, connection);
int count = (int?)command.ExecuteScalar() ?? 0;
MySqlDataReader result = command.ExecuteReader();
if (count > 0)
{
while (result.Read())
{
servers.Add(new ServerItem(result.GetString("servername"), result.GetInt16("status"), result.GetString("ip"), result.GetInt16("port")));
}
}
connection.Dispose();
connection.Close();
}
serverList = new ServerList(new Vector2(browserPos.X, browserPos.Y), servers);
}
public ServerBrowser()
{
string connectionString = String.Format("Server = {0}; database = {1}; UID = {2}; password = {3}", sqlServer, database, UID, password);
string queryString = "SELECT * FROM servers";
using (MySqlConnection connection = new MySqlConnection(connectionString))
{
connection.Open();
MySqlCommand command = new MySqlCommand(queryString, connection);
int count = (int?)command.ExecuteScalar() ?? 0;
MySqlDataReader result = command.ExecuteReader();
if (count > 0)
{
while (result.Read())
{
servers.Add(new ServerItem(result.GetString("servername"), result.GetInt16("status"), result.GetString("ip"), result.GetInt16("port")));
}
}
connection.Dispose();
connection.Close();
}
browserPos = new Rectangle((int)browserPos.X, (int)browserPos.Y, 0, 0);
serverList = new ServerList(new Vector2(browserPos.X, browserPos.Y), servers);
int height = (int)((50 * 2) + ((ContentChest.Instance.menuFont.MeasureString("World 1").Y) * 3) - 10);
int width = (int)(browserPos.X + (50 * (servers.Count)) + (200 * (servers.Count)) - 50);
browserPos.Height = height;
browserPos.Width = width;
browserPos.X = (Resolution.GameWidth / 2) - (browserPos.Width / 2);
browserPos.Y = (Resolution.GameHeight / 2) - (browserPos.Height / 2);
serverList.SetPos(new Vector2(browserPos.X, browserPos.Y));
}
