[b]atum_LoadStrategyPointSummonRangeTimeInfo[/b]
SELECT StartTime, EndTime, SummonRange, StrategyPointSummonCheck, MaxSummonCountDaily
FROM dbo.td_StrategyPointSummonRangeTimeInfo WITH (NOLOCK)
[b]atum_UpdateStrategyPointSummonInfoByMapIndex[/b]
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)
[b]atum_UpdateStrategyPointSummonInfoByNewSummonRange[/b]
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
[b]atum_LoadStrategyPointSummonRangeTimeInfo[/b]
SELECT StartTime, EndTime, SummonRange, StrategyPointSummonCheck, MaxSummonCountDaily
FROM dbo.td_StrategyPointSummonRangeTimeInfo WITH (NOLOCK)
[b]atum_LoadStrategyPointSummonInfo[/b]
SELECT MapIndex, SummonCount, SummonTime, SummonAttribute
FROM dbo.td_StrategyPointSummonInfo WITH (NOLOCK)
[b]atum_LoadStrategyPointNotSummonTime[/b]
SELECT DayOfWeek, StartTime, EndTime, CheckSummon
FROM atum2_db_account.dbo.td_StrategyPointNotSummonTime