Nation War Reward+Bringer Title
Hi guys, how can i solve the BRINGER TITLE in nation war and the NATION REWARD for the winning nation?
Thank you in advance.
Re: Nation War Reward+Bringer Title
Bringer title is properly working you don't have to change anything ! :)
And for NATION REWARD just lurk around there are 2 ways to fix that, 1 war win (Saturday) / week or by using a query who will count all fights.
Re: Nation War Reward+Bringer Title
Do you know how to do that? Because i didn't found a way to solve that, even with query's maybe my query's was not good....
Re: Nation War Reward+Bringer Title
Re: Nation War Reward+Bringer Title
Ok for the Nation Reward i found the solution!
Quote:
Originally Posted by
x30unlimited
made a stored proc that you can schedule once a week :D it takes into account all nation wins over 7 day period, so ppl don't just have to win 1 war :)
Code:
CREATE PROCEDURE [dbo].[nation_selectWin]
AS
BEGIN
DECLARE @win1 INT
DECLARE @win2 INT
DECLARE @lastid INT
select @win1 = count(*) FROM cabal_instantWar_results WHERE StartDateTime > DATEADD(DAY, -7, GETDATE()) AND VictoryNation=1
select @win2 = count(*) FROM cabal_instantWar_results WHERE StartDateTime > DATEADD(DAY, -7, GETDATE()) AND VictoryNation=2
select @lastid = MAX(WarResultsID) FROM cabal_instantWar_results WHERE StartDateTime > DATEADD(DAY, -7, GETDATE())
INSERT INTO cabal_instantWar_nationRewardWarResults(TotalRound,CapellaWin,ProcyonWin,RewardStartDateTime,LastWarResultsID,DurationDay) VALUES (@win1+@win2,@win1,@win2,GETDATE(),@lastid,7)
END
Bringer title is not working, it is not saving the results on the table!
Re: Nation War Reward+Bringer Title
Quote:
Originally Posted by
S37uP!Update
Ok for the Nation Reward i found the solution!
Bringer title is not working, it is not saving the results on the table!
Restore DB from Justin Bieber release and check all procedures / tables. :)
Also, try to read some patch notes in order to see how these things should work, something is telling me you don't know s**t. xD
Re: Nation War Reward+Bringer Title
http://forum.ragezone.com/f451/artif...ringer-918435/
Quote:
Originally Posted by
motanu
Restore DB from Justin Bieber release and check all procedures / tables. :)
Good idea!
Re: Nation War Reward+Bringer Title
Quote:
Originally Posted by
motanu
Restore DB from Justin Bieber release and check all procedures / tables. :)
Also, try to read some patch notes in order to see how these things should work, something is telling me you don't know s**t. xD
yes , im agree with you ! xD
Re: Nation War Reward+Bringer Title
Quote:
Originally Posted by
S37uP!Update
Ok for the Nation Reward i found the solution!
Bringer title is not working, it is not saving the results on the table!
U need to finish 7 mission wars with a character, to get the bringer title. Dont need to edit anything in the DB for it.
Re: Nation War Reward+Bringer Title
Quote:
Originally Posted by
NeoRazor18
U need to finish 7 mission wars with a character, to get the bringer title. Dont need to edit anything in the DB for it.
What do you mean by 7 mission war? Can you explain more details please? Sorry new here :(
Re: Nation War Reward+Bringer Title
Quote:
Originally Posted by
KaitoDaumoto
What do you mean by 7 mission war? Can you explain more details please? Sorry new here :(
Only characters which have been on Nation War MINIMUM 7 times can participate to be an Bringer.