I was wondering the same so I had a quick look at the source code. I checked the loading part in the field db manager. So here is what I found out.
DB queries (in the order they are executed) before renewal:
Code:
atum_LoadStrategyPointSummonRangeTimeInfo
SELECT StartTime, EndTime, SummonRange, StrategyPointSummonCheck, MaxSummonCountDaily
FROM dbo.td_StrategyPointSummonRangeTimeInfo WITH (NOLOCK)
atum_UpdateStrategyPointSummonInfoByMapIndex
DELETE dbo.td_StrategyPointSummonInfo
WHERE MapIndex NOT IN (SELECT MapIndex FROM atum2_db_account.dbo.ti_StrategyPointSummonMapIndex)
INSERT INTO dbo.td_StrategyPointSummonInfo
SELECT MapIndex, 0, GetDATE(), NULL
FROM atum2_db_account.dbo.ti_StrategyPointSummonMapIndex
WHERE MapIndex NOT IN (SELECT MapIndex FROM dbo.td_StrategyPointSummonInfo)
atum_UpdateStrategyPointSummonInfoByNewSummonRange
UPDATE dbo.td_StrategyPointSummonInfo SET SummonCount = SummonCount + 1
DECLARE @tmNewSTime DATETIME
SET @tmNewSTime =
(SELECT EndTime FROM dbo.td_StrategyPointSummonRangeTimeInfo)
DECLARE @tmSummonRange SMALLINT
SET @tmSummonRange =
(SELECT SummonRange FROM atum2_db_account.dbo.td_StrategyPointSummonRange)
DECLARE @tmStrategyPointSummonCheck TINYINT
SET @tmStrategyPointSummonCheck =
(SELECT StrategyPointSummonCheck FROM atum2_db_account.dbo.td_StrategyPointSummonRange)
DECLARE @tmMaxSummonCountDaily TINYINT
SET @tmMaxSummonCountDaily =
(SELECT MaxSummonCountDaily FROM atum2_db_account.dbo.td_StrategyPointSummonRange)
UPDATE dbo.td_StrategyPointSummonRangeTimeInfo
SET StartTime = @tmNewSTime, EndTime = DateAdd(day, @tmSummonRange, EndTime),
SummonRange = @tmSummonRange,
StrategyPointSummonCheck = @tmStrategyPointSummonCheck,
MaxSummonCountDaily = @tmMaxSummonCountDaily
atum_LoadStrategyPointSummonRangeTimeInfo
SELECT StartTime, EndTime, SummonRange, StrategyPointSummonCheck, MaxSummonCountDaily
FROM dbo.td_StrategyPointSummonRangeTimeInfo WITH (NOLOCK)
atum_LoadStrategyPointSummonInfo
SELECT MapIndex, SummonCount, SummonTime, SummonAttribute
FROM dbo.td_StrategyPointSummonInfo WITH (NOLOCK)
atum_LoadStrategyPointNotSummonTime
SELECT DayOfWeek, StartTime, EndTime, CheckSummon
FROM atum2_db_account.dbo.td_StrategyPointNotSummonTime
After renewal
Code:
atum_LoadRenewalStrategyPointSummonTime
SELECT DayOfWeek, StartTime, EndTime, CountBCU, CountANI
FROM td_RenewalStrategyPointSummonTime WITH(NOLOCK)
atum_LoadStrategyPointMapInfluenceInfo
SELECT MapIndex, MapName, MapInfluenceType
FROM atum2_db_account.dbo.ti_MapInfo
WHERE MapIndex IN (SELECT MapIndex FROM atum2_db_account.dbo.ti_StrategyPointSummonMapIndex)
atum_LoadStrategyPointSummonInfo
SELECT MapIndex, SummonCount, SummonTime, SummonAttribute
FROM dbo.td_StrategyPointSummonInfo WITH (NOLOCK)
More stuff I found was added with the renewal include FP_ADMIN_STRATRGYPOINT_INFO_CHANGE message type, CInflWarManager::SetDoingInfluenceWar (checks if there's an influence war going on and disables monster maps) and of course CInflWarManager::OnDoMinutelyWarkInflWarManager is also updated.