Changeset 3333

Timestamp:

07/28/09 08:50:23 (12 months ago)

Author:

milosh

Message:

Make !scorereset reset all player stats. #372

Files:

• trunk/twcore/src/twcore/bots/elim/elim.java (modified) (2 diffs)

trunk/twcore/src/twcore/bots/elim/elim.java

@@ -189 +189 @@
                                 "| !classic      - Toggles whether or not you'd like to be spec'd when out.   |",
                                 "| !warp         - Warps you out of the safe if you're stuck.                 |",
-                                "| !scorereset   - Resets your arena score card to zero. No going back. (!sr) |",
+                                "| !scorereset   - Resets all of your stats to zero. No going back. (!sr)     |",
 
                 };List<String> reg = Arrays.asList(reghelp);
@@ -515 +515 @@
         try{
                 m_botAction.SQLQueryAndClose(db, "UPDATE tblElimCasualRecs SET fnKills = 0, fnDeaths = 0 WHERE fcUserName = '" + Tools.addSlashesToString(name.toLowerCase()) + "' AND fnGameType = " + cfg_gameType);
+                m_botAction.SQLQueryAndClose(db, "DELETE * FROM tblElimPlayer WHERE fcUserName = '" + Tools.addSlashesToString(name.toLowerCase()) + "'");
                 m_botAction.sendSmartPrivateMessage( name, "Your wins and losses have been reset to zero.");
         }catch(SQLException e){