Raid batch creation vs. summer / winter time

[arnecls]

When creating raids as a batch (multiple raids in a row) and this batch spans over a summer / winter time change, all raids after the summer / winter time change will have the wrong hour set.

[arnecls]

To fix this you can use the following query:

UPDATE raids_Raid SET Start = FROM_UNIXTIME(UNIX_TIMESTAMP(Start) + 3600), End = FROM_UNIXTIME(UNIX_TIMESTAMP(End) + 3600) WHERE Start >= "2014-10-26"

This will move all raids greater than (and including) the given date by one hour. Use "- 3600" for the opposite direction.