DB/Holidays: Difference between revisions

From wowdev
Jump to navigation Jump to search
Line 9: Line 9:
|0  || ID  || Integer  || Not complettely sure - most likely will be
|0  || ID  || Integer  || Not complettely sure - most likely will be
|-  
|-  
|1  || stage1Length || Integer  || Event preparation or main event (stage1 - where they create their tents etc etc etc) (Timed)
|1  || stage1Length || Integer  || Event preparation or main event (stage1) (Timed)
|-  
|-  
|2  || stage2Length || Integer  || Event stage2 active - where all the fun is) (Timed)
|2  || stage2Length || Integer  || Event stage2 active (Timed)
|-
|-
|11 || eventStart || Integer || Unixtime-style timestamp with WotLK startdate as origin date, or just simply day/month pickup.
|11 || eventStart || Integer || Unixtime-style timestamp with WotLK startdate as origin date, or just simply day/month pickup.
|-
|-
|12 - 23 || eventReoccuranceTimes || Integer || Adjusted eventdates for certain events
|12 - 23 || eventReoccuranceTimes || Integer || Adjusted eventdates for certain events where needed
|-  
|-  
|24 - 36 || <unknown> || Integer || <Unknown>
|24 - 36 || <unknown> || Integer || <Unknown>
Line 34: Line 34:
   -1: <currently unknown>
   -1: <currently unknown>
   0: <currently unknown>
   0: <currently unknown>
   1: pre-event exists - do stage1, start stage2 at once as it's timed out (with stage2 being the eventActive time)
   1: event stage2 exists : do stage1, start stage2 at once as it's timed out
   2: wait X hours untill next occurance (with mainEventLength(stage2) being the eventPause time)
   2: wait X hours untill next occurance (with mainEventLength(stage2) being the eventPause time)

Revision as of 23:16, 18 October 2010

9183

Column Field Type Notes
0 ID Integer Not complettely sure - most likely will be
1 stage1Length Integer Event preparation or main event (stage1) (Timed)
2 stage2Length Integer Event stage2 active (Timed)
11 eventStart Integer Unixtime-style timestamp with WotLK startdate as origin date, or just simply day/month pickup.
12 - 23 eventReoccuranceTimes Integer Adjusted eventdates for certain events where needed
24 - 36 <unknown> Integer <Unknown>
49 Holidayname iRefID Ref to Loc in HolidayNames.dbc
50 Holidaydescription iRefID Ref to Loc in HolidayDescriptions.dbc
51 Calendarname String If the Holiday is part of the Calendar its name is written here
52 periodAdjustment (?) Integer Adjustment for reoccurance-timers (+/- the amount of "periodTypes"
53 periodType Integer -1, 0, 1, 2

periodType - defines if the event is to wait, pause, stop, start etc., and if it uses different stages(?) :

 -1: <currently unknown>
 0: <currently unknown>
 1: event stage2 exists : do stage1, start stage2 at once as it's timed out
 2: wait X hours untill next occurance (with mainEventLength(stage2) being the eventPause time)