Show
Ignore:
Timestamp:
11/19/08 13:49:57 (17 years ago)
Author:
yumileroy
Message:

[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).

Original author: runningnak3d
Date: 2008-11-16 02:28:44-06:00

Files:
1 modified

Legend:

Unmodified
Added
Removed
  • trunk/src/game/GameEvent.cpp

    r186 r242  
    15041504    CharacterDatabase.PExecute("DELETE FROM game_event_save WHERE event_id = '%u'",event_id); 
    15051505    if(mGameEvent[event_id].nextstart) 
    1506         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); 
     1506        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); 
    15071507    else 
    15081508        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);