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