General Discussion (#1) - SQl help for bot (#14) - Message List

this is my code for sql. Problem is bot doesn't write to the sql database. I'm sure its a dumb error because I haven't programmed something in a few years. That query isnt done yet. I still need to add to make it update if theres a duplicate key. Any ideas?

public void handleEvent(PlayerEntered event)

{

String name = event.getPlayerName(); String squad = event.getSquadName(); short wins = event.getWins(); short losses = event.getLosses(); int kpoints = event.getKillPoints(); int fpoints = event.getFlagPoints();

String query = "INSERT INTO stat (name, squad, wins, losses, kpoints, fpoints) VALUES('"+name+"','"+squad+"','"+wins+"','"+losses+"','"+kpoints+"','"+fpoints+"') ; try {

m_botAction.SQLQuery(mySQLHost, query);

} catch (SQLException e) { e.printStackTrace();

}

}