コード例 #1
0
        private void LoadGuilds()
        {
            MySqlCommand    mysqlCmd    = new MySqlCommand("SELECT * FROM Guilds", Program.DatabaseManager.GetClient().GetConnection());
            int             GuildCount  = 0;
            MySqlDataReader GuildReader = mysqlCmd.ExecuteReader();

            {
                for (int i = 0; i < GuildReader.FieldCount; i++)
                {
                    while (GuildReader.Read())
                    {
                        Guild g = new Guild(Program.DatabaseManager.GetClient().GetConnection(), GuildReader);
                        GuildManager.AddGuildToList(g);
                        GuildCount++;
                    }
                }
            }
            GuildReader.Close();
            Log.WriteLine(LogLevel.Info, "Load {0} Guilds", GuildCount);
        }