public CServerListItem[] CSQL_GetServerList()
{
string sql = "SELECT servers.server_friend_name, servers.server_addr " +
"FROM servers;";
string sql_count = "SELECT servers.server_friend_name, count(*) as TotalServers " +
"from servers;";
SqliteCommand dbhCmd;
SqliteDataReader dbhReader;
CServerListItem[] _server_list;
int server_count = 0;
int count = 0;
if (CSQL_Connected())
{
dbhCmd = new SqliteCommand(sql_count, dbh);
dbhReader = dbhCmd.ExecuteReader();
/**
* Get the number of servers for the array size.
*/
if (dbhReader.HasRows)
{
dbhReader.Read();
server_count = dbhReader.GetInt32(1);
if (server_count == 0)
{
cleanup();
return(null);
}
}
else
{
cleanup();
return(null);
}
/**
* Get server list.
*/
_server_list = new CServerListItem[server_count];
dbhCmd = new SqliteCommand(sql, dbh);
dbhReader = dbhCmd.ExecuteReader();
if (dbhReader.HasRows)
{
while (dbhReader.Read())
{
_server_list [count++] = new CServerListItem(
dbhReader.GetString(0),
dbhReader.GetString(1));
}
cleanup();
return(_server_list);
}
else
{
cleanup();
return(null);
}
}
cleanup();
return(null);
}
public CServerListItem[] CSQL_GetServerList()
{
string sql = "SELECT servers.server_friend_name, servers.server_addr " +
"FROM servers;";
string sql_count = "SELECT servers.server_friend_name, count(*) as TotalServers " +
"from servers;";
SqliteCommand dbhCmd;
SqliteDataReader dbhReader;
CServerListItem[] _server_list;
int server_count = 0;
int count = 0;
if (CSQL_Connected ()) {
dbhCmd = new SqliteCommand (sql_count, dbh);
dbhReader = dbhCmd.ExecuteReader ();
/**
* Get the number of servers for the array size.
*/
if (dbhReader.HasRows) {
dbhReader.Read ();
server_count = dbhReader.GetInt32 (1);
if (server_count == 0) {
cleanup ();
return null;
}
} else {
cleanup ();
return null;
}
/**
* Get server list.
*/
_server_list = new CServerListItem[server_count];
dbhCmd = new SqliteCommand (sql, dbh);
dbhReader = dbhCmd.ExecuteReader ();
if (dbhReader.HasRows) {
while (dbhReader.Read ()) {
_server_list [count++] = new CServerListItem (
dbhReader.GetString (0),
dbhReader.GetString (1));
}
cleanup ();
return _server_list;
} else {
cleanup ();
return null;
}
}
cleanup ();
return null;
}
