Server keeps crashing

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:

Code:

---

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):

Code:

---

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.

Anyone with the same issue?

Release?

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

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

Okay, will try with that.

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

Code:

---

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

---

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

Well, do you have any idea CodexPo?

EDIT: procedure for CODE 7:

Code:

---



-- ----------------------------
-- 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

---

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

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

you cant see the menu? or only ingame crash

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

the User has created correctly?

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

Quote:

---

Originally Posted by JonnyTruant

Well, do you have any idea CodexPo?

EDIT: procedure for CODE 7:

Code:

---



-- ----------------------------
-- 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?