What is the different SP ep3.5 and ep4

Results 1 to 4 of 4
  1. #1
    Member 4TheEnjoy is offline
    MemberRank
    Feb 2016 Join Date
    86Posts

    What is the different SP ep3.5 and ep4


    RaGEZONE Recommends

    RaGEZONE Recommends

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


  2. #2
    What is the different SP ep3.5 and ep4 St34lth4ng3l is offline
    True MemberRank
    Apr 2013 Join Date
    __FILE__Location
    818Posts

    Re: What is the different SP ep3.5 and ep4

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

  3. #3
    You won't get me... PanKJ is offline
    True MemberRank
    Sep 2010 Join Date
    Too Damn HighLocation
    590Posts

    Re: What is the different SP ep3.5 and ep4

    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.
    [Berserker] has been activated

  4. #4

    Re: What is the different SP ep3.5 and ep4

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




Advertisement