From 3c866d5529826761c161de7ff9e2e60d5060edb6 Mon Sep 17 00:00:00 2001 From: runningnak3d Date: Sun, 16 Nov 2008 02:28:44 -0600 Subject: [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 --- src/game/GameEvent.cpp | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'src/game/GameEvent.cpp') 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(); -- cgit v1.2.3