[help] how to fix Account Premium Revive time (dbo.WZ_CharRevive)

[javaz97]

my set up

normal account Revive time = 15 min

premium account Revive time = 10 min << not work

[dbo].[WZ_CharRevive]

-- note that revive timer is 1hrs, change in WZ_GetAccountInfo1 as well
declare @sectorevive int
declare @alive int = 0
select
[COLOR="#FF0000" @sectorevive=DATEDIFF (second, GETUTCDATE (), DATEADD (second, 900, DeathUtcTime)),[/COLOR]
@alive=Alive
from UsersChars
where CharID=@in_CharID


-- new code
if ( @iSPRemium = 1)
@sectorevive=DATEDIFF (second, GETUTCDATE (), DATEADD (second, 600, DeathUtcTime)),
else
@sectorevive=DATEDIFF (second, GETUTCDATE (), DATEADD (second, 900, DeathUtcTime)),

how to write full code ?

- - - Updated - - -

plz test

ALTER PROCEDURE [dbo].[WZ_CharRevive]
...
...

    -- note that revive timer is 1hrs, change in WZ_GetAccountInfo1 as well
    declare    @sectorevive int
    declare    @alive int = 0
    declare    @iSPRemium int

	SELECT    @iSPRemium=isPremium FROM UsersData WHERE CustomerID=@in_CustomerID

	-- check premium account
    if    @iSPRemium = 1) begin
		select
		    @sectorevive=DATEDIFF (second, GETUTCDATE (), DATEADD (second, 600, DeathUtcTime)),
		    @alive=Alive
		from UsersChars
		where CharID=@in_CharID
	end

	else begin
		select
		    @sectorevive=DATEDIFF (second, GETUTCDATE (), DATEADD (second, 900, DeathUtcTime)),
		    @alive=Alive
		from UsersChars
		where CharID=@in_CharID
	end

- - - Updated - - -


--- edit 2

if ( @iSPRemium = 1 ) begin

[MentaL]

[javaz97]

work ??