Server keeps crashing

[JonnyTruant]

I need help with this please, every 10 minutes or so, my Supervisor says "game NUMBER finished" then it starts again. I've checked their logs and this is it:

000128.245| !!! r3d_assert 'w.Items[slot].InventoryID == 0' at ..\..\..\src\EclipseStudio\Sources\GameCode\UserProfile.cpp line 198
000128.246| !!! crashed

The line that it's crashing is this (whole function):

static void parseCharBackpack(pugi::xml_node xmlItem, wiCharDataFull& w)
{
    // enter into items list
    xmlItem = xmlItem.first_child();
    while(!xmlItem.empty())
    {
        wiInventoryItem itm;
        parseInventoryItem(xmlItem, itm);


        int slot = xmlItem.attribute("s").as_int();


        r3d_assert(slot >= 0 && slot < w.BackpackSize);
        r3d_assert(w.Items[slot].InventoryID == 0);
        w.Items[slot] = itm;


        xmlItem = xmlItem.next_sibling();
    }


    
     return;
}

Please help me. I really need this.

[MentaL]

[JonnyTruant]

Anyone with the same issue?

[DarkOur]

Release?

[JonnyTruant]

I'm using DNC's Release with all updates.

[doidloko]

remove r3d_assert(w.Items[slot].InventoryID == 0);

[JonnyTruant]

Okay, will try with that.

Okay doidloko, after I commented the line you said to remove, this is the error.

000017.903| WO_API: failed with error code 7  game still active
000017.903| !!!! api_SrvUserJoinedGame failed, code: 7

[CodexPo]

maybe your problem is with API no source, i have the same version and not have this error

[JonnyTruant]

Well, do you have any idea CodexPo?

EDIT: procedure for CODE 7:

-- ----------------------------
-- Procedure structure for [WZ_SRV_UserJoinedGame2]
-- ----------------------------


ALTER PROCEDURE [WZ_SRV_UserJoinedGame2]
	@in_CustomerID int,
	@in_CharID int,
	@in_GameMapId int,
	@in_GameServerId bigint
AS
BEGIN
	SET NOCOUNT ON;


	-- check if game is still active or 90sec passed from last update (COPYPASTE_GAMECHECK, search for others)
	declare @lastgamedate datetime
	declare @GameServerId int
	select @GameServerId=GameServerId, @lastgamedate=lastgamedate from UsersData where CustomerID=@in_CustomerID
	if(@GameServerId > 0 and DATEDIFF(second, @lastgamedate, GETDATE()) < 90) begin
		select 7 as ResultCode, 'game still active' as ResultMsg
		return
	end
	
	-- store current user server location
	update UsersData set 
		lastgamedate=GETDATE(),
		GameServerId=@in_GameServerId
	where CustomerID=@in_CustomerID
	
	-- per char info
	update UsersChars set 
		GameMapId=@in_GameMapId,
		GameServerId=@in_GameServerId
	where CharID=@in_CharID
		
	-- we're done
	select 0 as ResultCode


END

[CodexPo]

I would try the following, restart the SQL server and its settings, also routes your API, ISS logs that sometimes you get error tracks, proves that in case

[JonnyTruant]

I tried, there ain't IIS logs but still when a player joins the game crashes.

[CodexPo]

you cant see the menu? or only ingame crash

[JonnyTruant]

Crash I mean the server says "finished" and we get loading game data.

[CodexPo]

the User has created correctly?

[JonnyTruant]

Yeah, I asked my friend to join he joined after a few minutes it crashed.

[CodexPo]

Well, do you have any idea CodexPo?

EDIT: procedure for CODE 7:

-- ----------------------------
-- Procedure structure for [WZ_SRV_UserJoinedGame2]
-- ----------------------------


ALTER PROCEDURE [WZ_SRV_UserJoinedGame2]
    @in_CustomerID int,
    @in_CharID int,
    @in_GameMapId int,
    @in_GameServerId bigint
AS
BEGIN
    SET NOCOUNT ON;


    -- check if game is still active or 90sec passed from last update (COPYPASTE_GAMECHECK, search for others)
    declare @lastgamedate datetime
    declare @GameServerId int
    select @GameServerId=GameServerId, @lastgamedate=lastgamedate from UsersData where CustomerID=@in_CustomerID
    if(@GameServerId > 0 and DATEDIFF(second, @lastgamedate, GETDATE()) < 90) begin
        select 7 as ResultCode, 'game still active' as ResultMsg
        return
    end
    
    -- store current user server location
    update UsersData set 
        lastgamedate=GETDATE(),
        GameServerId=@in_GameServerId
    where CustomerID=@in_CustomerID
    
    -- per char info
    update UsersChars set 
        GameMapId=@in_GameMapId,
        GameServerId=@in_GameServerId
    where CharID=@in_CharID
        
    -- we're done
    select 0 as ResultCode


END

is the same as mine, get into the menu to create a character?

[JonnyTruant]

is the same as mine, get into the menu to create a character?

I created it, nothing weird.

[CodexPo]

then is the problem on your server does not communicate well with the api seems to be

you have full log?

[DarkOur]

Check

-- ----------------------------
-- Procedure structure for [WZ_SRV_UserJoinedGame]
-- ----------------------------


ALTER PROCEDURE [dbo].[WZ_SRV_UserJoinedGame] 
	@in_CustomerID int,
	@in_CharID int,
	@in_GameMapId int,
	@in_GameServerId bigint,
	@in_GamePos varchar(256)
AS
BEGIN
	SET NOCOUNT ON;
	
	-- store current user server location
	update UsersData set 
		lastgamedate=GETDATE(),
		GameServerId=@in_GameServerId
	where CustomerID=@in_CustomerID
	
	-- per char info
	update UsersChars set 
		GameMapId=@in_GameMapId,
		GameServerId=@in_GameServerId
	where CharID=@in_CharID
		
	update Accounts Set
		Online = 1
	WHERE CustomerID=@in_CustomerID
	
	-- we're done
	select 0 as ResultCode


END

-- ----------------------------
-- Procedure structure for [WZ_SRV_UserJoinedGame2]
-- ----------------------------


ALTER PROCEDURE [dbo].[WZ_SRV_UserJoinedGame2]
	@in_CustomerID int,
	@in_CharID int,
	@in_GameMapId int,
	@in_GameServerId bigint
AS
BEGIN
	SET NOCOUNT ON;


	-- check if game is still active or 90sec passed from last update (COPYPASTE_GAMECHECK, search for others)
	declare @lastgamedate datetime
	declare @Online int
	declare @GameServerId int
	select @GameServerId=GameServerId, @lastgamedate=lastgamedate from UsersData where CustomerID=@in_CustomerID
	select @Online = Online FRom Accounts where CustomerID=@in_CustomerID
	
	if(@GameServerId > 0 and @Online > 0) begin
		select 7 as ResultCode, 'game still active' as ResultMsg
		return
	end
	
	-- store current user server location
	update UsersData set 
		lastgamedate=GETDATE(),
		GameServerId=@in_GameServerId
	where CustomerID=@in_CustomerID
	
	-- per char info
	update UsersChars set 
		GameMapId=@in_GameMapId,
		GameServerId=@in_GameServerId
	where CharID=@in_CharID
	
	update Accounts set
		Online = 1
	WHERE CustomerID= @in_CustomerID
		
	-- we're done
	select 0 as ResultCode


END

[JonnyTruant]

Maybe it was an issue with Novoc's spawn protection. As soon as I get home, I'll try the fix for Novoc's Protection.

[iKasu]

Check

-- ----------------------------
-- Procedure structure for [WZ_SRV_UserJoinedGame]
-- ----------------------------


ALTER PROCEDURE [dbo].[WZ_SRV_UserJoinedGame] 
    @in_CustomerID int,
    @in_CharID int,
    @in_GameMapId int,
    @in_GameServerId bigint,
    @in_GamePos varchar(256)
AS
BEGIN
    SET NOCOUNT ON;
    
    -- store current user server location
    update UsersData set 
        lastgamedate=GETDATE(),
        GameServerId=@in_GameServerId
    where CustomerID=@in_CustomerID
    
    -- per char info
    update UsersChars set 
        GameMapId=@in_GameMapId,
        GameServerId=@in_GameServerId
    where CharID=@in_CharID
        
    update Accounts Set
        Online = 1
    WHERE CustomerID=@in_CustomerID
    
    -- we're done
    select 0 as ResultCode


END

-- ----------------------------
-- Procedure structure for [WZ_SRV_UserJoinedGame2]
-- ----------------------------


ALTER PROCEDURE [dbo].[WZ_SRV_UserJoinedGame2]
    @in_CustomerID int,
    @in_CharID int,
    @in_GameMapId int,
    @in_GameServerId bigint
AS
BEGIN
    SET NOCOUNT ON;


    -- check if game is still active or 90sec passed from last update (COPYPASTE_GAMECHECK, search for others)
    declare @lastgamedate datetime
    declare @Online int
    declare @GameServerId int
    select @GameServerId=GameServerId, @lastgamedate=lastgamedate from UsersData where CustomerID=@in_CustomerID
    select @Online = Online FRom Accounts where CustomerID=@in_CustomerID
    
    if(@GameServerId > 0 and @Online > 0) begin
        select 7 as ResultCode, 'game still active' as ResultMsg
        return
    end
    
    -- store current user server location
    update UsersData set 
        lastgamedate=GETDATE(),
        GameServerId=@in_GameServerId
    where CustomerID=@in_CustomerID
    
    -- per char info
    update UsersChars set 
        GameMapId=@in_GameMapId,
        GameServerId=@in_GameServerId
    where CharID=@in_CharID
    
    update Accounts set
        Online = 1
    WHERE CustomerID= @in_CustomerID
        
    -- we're done
    select 0 as ResultCode


END

 update Accounts Set
        Online = 1
    WHERE CustomerID=@in_CustomerID

Mhh.... DNC Release.... Looks like mine to fix the Dupe xD

Maybe it was an issue with Novoc's spawn protection. As soon as I get home, I'll try the fix for Novoc's Protection.

Run this Command in SQL:

Use WarZ
UPDATE Accoutes SET Online=0

[JonnyTruant]

 update Accounts Set
        Online = 1
    WHERE CustomerID=@in_CustomerID

Mhh.... DNC Release.... Looks like mine to fix the Dupe xD



Run this Command in SQL:

Use WarZ
UPDATE Accoutes SET Online=0

[s]Do I need to change Accounts design and add Online?[/s]
Did that, and I've also put that when you leave the server, your Online is set to 0.