[HELP]Global Inventory Codex SRC

Results 1 to 2 of 2
  1. #1
    Valued Member asd4129 is offline
    MemberRank
    Dec 2012 Join Date
    Loose, Germany,Location
    146Posts

    angry [HELP]Global Inventory Codex SRC

    Dont work :S http://forum.ragezone.com/f791/tut-g...entory-931908/

    help me please

    My Source : Latest Codex Src
    My WZ_SRV_UserLeftGame
    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 != 0begin
                            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 


  2. #2
    Account Upgraded | Title Enabled! GetRektBambi is offline
    MemberRank
    Oct 2015 Join Date
    268Posts

    Re: [HELP]Global Inventory Codex SRC

    Maybe your should explain how it doesnt work..



Advertisement