!delChar

[Incrala]

Place this into a command.java of your preference:

else if (splitted[0].equals("!delchar")) {
            MapleCharacter victim = cserv.getPlayerStorage().getCharacterByName(splitted[1]);
            victim.getClient().getSession().close();
            victim.getClient().disconnect();
            victim.saveToDB(true);
            cserv.removePlayer(victim);
            victim.delChar(true);
        }

Place this into MapleCharacter.java

public static boolean delChar(boolean charId) {
        PreparedStatement ps;
        Connection con = DatabaseConnection.getConnection();
        boolean ret = false;
        try {
            ps = con.prepareStatement("SELECT id FROM characters WHERE name = ?");
            ResultSet rs = ps.executeQuery();
            if (!rs.next()) {
                ps.close();
            }
            if (rs.next()) {
                PreparedStatement psb = con.prepareStatement("DELETE FROM characters WHERE name = ?");
                psb.setInt(1, rs.getInt(1));
                psb.executeUpdate();
                psb.close();
                ret = true;
            }
            rs.close();
            ps.close();
        } catch (SQLException e) {
            log.error("Error while deleting character", e);
        }
        return ret;
    }

It has NOT been tested.

 

[Ehab]

Won't that be better than update? (That's if the update even works .. not sure)

delete from characters where name = ?

Good Release :

 

[Incrala]

Hah, like I said, NOT tested.

 

[holthelper]

test before you release.

 

[Piggy]

I agree, test before release . Looks like a great release thou. better than manually remove it - typing bdays or checking mysql brower

 

[Ehab]

it will work with my query (99% sure)

 

[watzmename]

Why bother saving the character if its going to be deleted?
Tip: Should also make it delete there items, cheatlog, skills, etc.

 

[scarlet12379]

Why bother saving the character if its going to be deleted?
Tip: Should also make it delete there items, cheatlog, skills, etc.

usualy when u delete the character all its stuff goes with it =]

 

[Incrala]

Fixed the SQL execution