Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

What is the different SP ep3.5 and ep4

Junior Spellweaver
Joined
Feb 7, 2016
Messages
109
Reaction score
6
hi guys.
what is the different strategyc point system on ep3.5 and ep4.
Ep4 have renewal system etc etc.
Anyone can tell anything ?
 
Joined
Sep 7, 2010
Messages
431
Reaction score
263
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.
 
Initiate Mage
Joined
Jan 5, 2017
Messages
1
Reaction score
0
What's the difference, I think, and it all works fine!
 
Back
Top