What is the different SP ep3.5 and ep4

4TheEnjoy · Jul 31, 2016

hi guys.
what is the different strategyc point system on ep3.5 and ep4.
Ep4 have renewal system etc etc.
Anyone can tell anything ?

St34lth4ng3l · Jul 31, 2016

You have more logspamming..... Well honestly i don't know
Reading Masangs code is like reading mandarine without knowing it.

PanKJ · Dec 24, 2016

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:

[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

After renewal

Code:

[b]atum_LoadRenewalStrategyPointSummonTime[/b]
	SELECT DayOfWeek, StartTime, EndTime, CountBCU, CountANI
	FROM td_RenewalStrategyPointSummonTime WITH(NOLOCK)

[b]atum_LoadStrategyPointMapInfluenceInfo[/b]
	SELECT MapIndex, MapName, MapInfluenceType
	FROM atum2_db_account.dbo.ti_MapInfo
	WHERE MapIndex IN (SELECT MapIndex FROM atum2_db_account.dbo.ti_StrategyPointSummonMapIndex)

[b]atum_LoadStrategyPointSummonInfo[/b]
	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.

SolikFrt · Jan 5, 2017

What's the difference, I think, and it all works fine!

What is the different SP ep3.5 and ep4

4TheEnjoy

Junior Spellweaver

St34lth4ng3l

[emoji19]

PanKJ

You won't get me...

SolikFrt

Initiate Mage