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.

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.

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....

I have not tried the TG yet but you can look here if it helps, how to gain bringer, http://forum.ragezone.com/f460/ep8-n...ml#post7575924, http://forum.ragezone.com/f460/ep8-a...5/#post7561284.

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!

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

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!

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

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.

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 :(

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.