PHP Code:
ALTER PROCEDURE [dbo].[WZ_SRV_UserLeftGame]
@in_CustomerID int,
@in_CharID int,
@in_GameMapId int,
@in_GameServerId bigint,
@in_TimePlayed int
AS
BEGIN
SET NOCOUNT ON;
-- store current user server location
update UsersData set
lastgamedate=GETDATE(),
GameServerId=0,
TimePlayed=(TimePlayed+@in_TimePlayed)
where CustomerID=@in_CustomerID
declare [MENTION=417136]iSPR[/MENTION]emium datetime
declare @IsDeveloper int
select [MENTION=417136]iSPR[/MENTION]emium=PremiumExpireTime FROM UsersData WHERE CustomerID=@in_CustomerID
select @IsDeveloper=IsDeveloper FROM Accounts WHERE CustomerID=@in_CustomerID
-- update some stats here
if [MENTION=417136]iSPR[/MENTION]emium > GETDATE()) begin
update UsersChars set
GameFlags=1
where CharID=@in_CharID
end
else begin
if (@IsDeveloper != 0) begin
update UsersChars set
GameFlags=1
where CharID=@in_CharID
end
else begin
update UsersChars set
GameFlags=0
where CharID=@in_CharID
end
end
-- we're done
select 0 as ResultCode
exec DBG_StoreApiCall 'LeftGame', 0, @in_CustomerID, @in_CharID, @in_GameServerId
END