Help !giveep command dont save EP to DB

[Bryan Lim]

guys can u guys help me? my !giveep command doesnt save the EP to my DB.. idk why? give ep command is fine when i giveep to myself it have but after i relog the eventpoints gone. i can give myself ep but when i restart the ep reset too. for player i gave them but they dont receive any even tho i check thier event points amount

[MentaL]

[Luxray]

Do you include them in the saveToDB function? If not, it'll just stay local and won't be saved.

[MVCipher]

Go to MapleCharacter.java and find

public void saveToDB

then scroll down until you find the part of your MySQL you want to save (I am assuming accounts.)

                ps = con.prepareStatement("UPDATE accounts SET `paypalNX` = ?, `mPoints` = ?, `cardNX` = ?, `EP` = ? WHERE id = ?");
                ps.setInt(1, paypalnx);
                ps.setInt(2, maplepoints);
                ps.setInt(3, cardnx);
                ps.setInt(4, EP);
                ps.setInt(5, client.getAccID());
                ps.executeUpdate();
                ps.close();

That's an example of what yours should be (but please only look at that as a reference, if your names aren't the same it will mess up.)