using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using SnowLight.Storage;

namespace SnowLightV3.Forms
{
    public partial class StabilityOptions : Form
    {
        public StabilityOptions()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
            {
                MySqlClient.ExecuteNonQuery("OPTIMIZE TABLE `accounts`, `achievements`, `avatar_effects`, `badges`, `badge_definitions`, `bans`, `bots`, `bots_speech`, `bot_responses`, `catalog`, `catalog_items`, `catalog_subscriptions`, `characters`, `crossdomain`, `drink_sets`, `favorites`, `flat_categories`, `help_categories`, `help_topics`, `ignores`, `interstitials`, `items`, `item_definitions`, `messenger_friendships`, `moderation_action_log`, `moderation_chatlogs`, `moderation_presets`, `moderation_preset_action_categories`, `moderation_preset_action_messages`, `moderation_tickets`, `navigator_event_search_categories`, `navigator_frontpage`, `new_items`, `pets`, `pet_races`, `pet_tricks`, `quests`, `recycler_rewards`, `rights`, `rooms`, `room_models`, `room_rights`, `room_visits`, `server_statistics`, `songs`, `static_objects`, `tags`, `user_achievements`, `user_quests`, `user_subscriptions`, `vouchers`, `wardrobe`");
            }
        }

        private void button2_Click(object sender, EventArgs e)
        {
            using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
            {
                MySqlClient.ExecuteNonQuery("REPAIR TABLE `accounts`, `achievements`, `avatar_effects`, `badges`, `badge_definitions`, `bans`, `bots`, `bots_speech`, `bot_responses`, `catalog`, `catalog_items`, `catalog_subscriptions`, `characters`, `crossdomain`, `drink_sets`, `favorites`, `flat_categories`, `help_categories`, `help_topics`, `ignores`, `interstitials`, `items`, `item_definitions`, `messenger_friendships`, `moderation_action_log`, `moderation_chatlogs`, `moderation_presets`, `moderation_preset_action_categories`, `moderation_preset_action_messages`, `moderation_tickets`, `navigator_event_search_categories`, `navigator_frontpage`, `new_items`, `pets`, `pet_races`, `pet_tricks`, `quests`, `recycler_rewards`, `rights`, `rooms`, `room_models`, `room_rights`, `room_visits`, `server_statistics`, `songs`, `static_objects`, `tags`, `user_achievements`, `user_quests`, `user_subscriptions`, `vouchers`, `wardrobe`");
            }
        }

        private void button3_Click(object sender, EventArgs e)
        {
            using (SqlDatabaseClient MySqlClient = SqlDatabaseManager.GetClient())
            {
                MySqlClient.ExecuteNonQuery("OPTIMIZE TABLE `accounts`, `achievements`, `avatar_effects`, `badges`, `badge_definitions`, `bans`, `bots`, `bots_speech`, `bot_responses`, `catalog`, `catalog_items`, `catalog_subscriptions`, `characters`, `crossdomain`, `drink_sets`, `favorites`, `flat_categories`, `help_categories`, `help_topics`, `ignores`, `interstitials`, `items`, `item_definitions`, `messenger_friendships`, `moderation_action_log`, `moderation_chatlogs`, `moderation_presets`, `moderation_preset_action_categories`, `moderation_preset_action_messages`, `moderation_tickets`, `navigator_event_search_categories`, `navigator_frontpage`, `new_items`, `pets`, `pet_races`, `pet_tricks`, `quests`, `recycler_rewards`, `rights`, `rooms`, `room_models`, `room_rights`, `room_visits`, `server_statistics`, `songs`, `static_objects`, `tags`, `user_achievements`, `user_quests`, `user_subscriptions`, `vouchers`, `wardrobe`");
                MySqlClient.ExecuteNonQuery("REPAIR TABLE `accounts`, `achievements`, `avatar_effects`, `badges`, `badge_definitions`, `bans`, `bots`, `bots_speech`, `bot_responses`, `catalog`, `catalog_items`, `catalog_subscriptions`, `characters`, `crossdomain`, `drink_sets`, `favorites`, `flat_categories`, `help_categories`, `help_topics`, `ignores`, `interstitials`, `items`, `item_definitions`, `messenger_friendships`, `moderation_action_log`, `moderation_chatlogs`, `moderation_presets`, `moderation_preset_action_categories`, `moderation_preset_action_messages`, `moderation_tickets`, `navigator_event_search_categories`, `navigator_frontpage`, `new_items`, `pets`, `pet_races`, `pet_tricks`, `quests`, `recycler_rewards`, `rights`, `rooms`, `room_models`, `room_rights`, `room_visits`, `server_statistics`, `songs`, `static_objects`, `tags`, `user_achievements`, `user_quests`, `user_subscriptions`, `vouchers`, `wardrobe`");
            }
        }
    }
}