How to active ??
And Edit Bonus EXP
Imgur: The most awesome images on the Internet
Printable View
How to active ??
And Edit Bonus EXP
Imgur: The most awesome images on the Internet
Method # 1
Credit : x30Code: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
Method # 2
http://forum.ragezone.com/f460/ep8-a...rps-tg-911975/
tks very much