[svn] * Fixed a SQL issue that was causing game events to not be saved

* FROM_UNIXTIME doesn't allow '' inside the ()
* This should solve the issue of jumping from phase 1 -> 2 -> 3 -> 4 without completing the objectives
* This should also tick a LOT of players off if their servers are running with the stock TDB blizz values :P (low pop servers at least).

--HG--
branch : trunk

1 files changed, 1 insertions, 1 deletions

diff --git a/src/game/GameEvent.cpp b/src/game/GameEvent.cpp
index 6a7ce09a02d..88028290dba 100644
--- a/src/game/GameEvent.cpp
+++ b/src/game/GameEvent.cpp
@@ -1503,7 +1503,7 @@ void GameEvent::SaveWorldEventStateToDB(uint16 event_id)
     CharacterDatabase.BeginTransaction();
     CharacterDatabase.PExecute("DELETE FROM game_event_save WHERE event_id = '%u'",event_id);
     if(mGameEvent[event_id].nextstart)
-        CharacterDatabase.PExecute("INSERT INTO game_event_save (event_id, state, next_start) VALUES ('%u','%u',FROM_UNIXTIME('"I64FMTD"'))",event_id,mGameEvent[event_id].state,mGameEvent[event_id].nextstart);
+        CharacterDatabase.PExecute("INSERT INTO game_event_save (event_id, state, next_start) VALUES ('%u','%u',FROM_UNIXTIME("I64FMTD"))",event_id,mGameEvent[event_id].state,mGameEvent[event_id].nextstart);
     else
         CharacterDatabase.PExecute("INSERT INTO game_event_save (event_id, state, next_start) VALUES ('%u','%u','0000-00-00 00:00:00')",event_id,mGameEvent[event_id].state);
     CharacterDatabase.CommitTransaction();