InvasionMMO Source, aleatory pve and pvp

Hello everyone, I'm doing a system for when a player leave the map PVE = GamePosand logs on the map PVP = GamePos2 and back to the map pve, and he is at the same location

Colorado PVE = GamePos
Colorado PVP = GamePos2


I'm managing to get the position of the map GamePos2 pvp, but when I go out and then back in pve and pvp to generate a new position he still wearing the GamePos

UserProfile.cpp

Code:

---

w.GamePos = r3dPoint3D(0, 0, 0);
        if (w.GameMapId == 3)//for Colorado PVP
            sscanf(xmlItem.attribute("GamePos2").value(), "%f %f %f %f", &w.GamePos.x, &w.GamePos.y, &w.GamePos.z, &w.GameDir);
        else if (w.GameMapId == 2)//for Colorado PVE
            sscanf(xmlItem.attribute("GamePos").value(), "%f %f %f %f", &w.GamePos.x, &w.GamePos.y, &w.GamePos.z, &w.GameDir);
        else
            sscanf(xmlItem.attribute("GamePos").value(), "%f %f %f %f", &w.GamePos.x, &w.GamePos.y, &w.GamePos.z, &w.GameDir);

---

NetPacketsGameInfo.h

Code:

---

struct GBGameInfo
{
    enum EMapId
    {
      MAPID_Editor_Particles = 0,
      MAPID_ServerTest = 1,
      MAPID_WZ_Colorado = 2,
      MAPID_WZ_Colorado_Old = 3,
      MAPID_WZ_Event = 4,
      // NOTE: do *NOT* add maps inside current IDs, add ONLY at the end
      // otherwise current map statistics in DB will be broken
      MAPID_MAX_ID,
    };

---

api_GetProfile1.aspx.cs

Code:

---

            xml.Append(xml_attr("GameServerId", reader["GameServerId"]));
            xml.Append(xml_attr("GamePos", reader["GamePos"]));
            xml.Append(xml_attr("GamePos2", reader["GamePos2"]));

---

api_SrvCharUpdate.aspx.cs

Code:

---


        sqcmd.CommandText = "WZ_Char_SRV_SetStatus";
        sqcmd.Parameters.AddWithValue("@in_CustomerID", CustomerID);
        sqcmd.Parameters.AddWithValue("@in_MapID", web.Param("map"));

---

WZ_Char_SRV_SetStatus

Code:

---

    -- update basic character data
 if @in_MapID = 3
  update UsersChars set
    GamePos2=@in_GamePos,
        GameFlags=@in_GameFlags,
        Alive=@in_Alive,
        Health=@in_Health,
        Food=@in_Hunger,
        Water=@in_Thirst,
        Toxic=@in_Toxic,
        TimePlayed=@in_TimePlayed,
        LastUpdateDate=GETDATE(),
        XP=@in_XP,
        Reputation=@in_Reputation,
        Stat00=@in_Stat00,
        Stat01=@in_Stat01,
        Stat02=@in_Stat02,
        Stat03=@in_Stat03,
        Stat04=@in_Stat04,
        Stat05=@in_Stat05,
        SkillID0=@in_SkillID0,
        SkillID1=@in_SkillID1,
        SkillID2=@in_SkillID2,
        SkillID3=@in_SkillID3,
        SkillID4=@in_SkillID4,
        SkillID5=@in_SkillID5,
        SkillID6=@in_SkillID6,
        SkillID7=@in_SkillID7,
        SkillID8=@in_SkillID8,
        SkillID9=@in_SkillID9,
        SkillID10=@in_SkillID10,
        SkillID11=@in_SkillID11,
        SkillID12=@in_SkillID12,
        SkillID13=@in_SkillID13,
        SkillID14=@in_SkillID14,
        SkillID15=@in_SkillID15,
        SkillID16=@in_SkillID16,
        SkillID17=@in_SkillID17,
        SkillID18=@in_SkillID18,
        SkillID19=@in_SkillID19,
        SkillID20=@in_SkillID20,
        SkillID21=@in_SkillID21,
        SkillID22=@in_SkillID22,
        SkillID23=@in_SkillID23,
        SkillID24=@in_SkillID24,
        SkillID25=@in_SkillID25,
        SkillID26=@in_SkillID26,
        SkillID27=@in_SkillID27,
        SkillID28=@in_SkillID28,
        SkillID29=@in_SkillID29,
        SkillID30=@in_SkillID30,
        SkillID31=@in_SkillID31,
        SkillID32=@in_SkillID32,
        SkillID33=@in_SkillID33   


    where CharID=@in_CharID
    else if @in_MapID = 2
    update UsersChars set
        GamePos=@in_GamePos,
        GameFlags=@in_GameFlags,
        Alive=@in_Alive,
        Health=@in_Health,
        Food=@in_Hunger,
        Water=@in_Thirst,
        Toxic=@in_Toxic,
        TimePlayed=@in_TimePlayed,
        LastUpdateDate=GETDATE(),
        XP=@in_XP,
        Reputation=@in_Reputation,
        Stat00=@in_Stat00,
        Stat01=@in_Stat01,
        Stat02=@in_Stat02,
        Stat03=@in_Stat03,
        Stat04=@in_Stat04,
        Stat05=@in_Stat05,
        SkillID0=@in_SkillID0,
        SkillID1=@in_SkillID1,
        SkillID2=@in_SkillID2,
        SkillID3=@in_SkillID3,
        SkillID4=@in_SkillID4,
        SkillID5=@in_SkillID5,
        SkillID6=@in_SkillID6,
        SkillID7=@in_SkillID7,
        SkillID8=@in_SkillID8,
        SkillID9=@in_SkillID9,
        SkillID10=@in_SkillID10,
        SkillID11=@in_SkillID11,
        SkillID12=@in_SkillID12,
        SkillID13=@in_SkillID13,
        SkillID14=@in_SkillID14,
        SkillID15=@in_SkillID15,
        SkillID16=@in_SkillID16,
        SkillID17=@in_SkillID17,
        SkillID18=@in_SkillID18,
        SkillID19=@in_SkillID19,
        SkillID20=@in_SkillID20,
        SkillID21=@in_SkillID21,
        SkillID22=@in_SkillID22,
        SkillID23=@in_SkillID23,
        SkillID24=@in_SkillID24,
        SkillID25=@in_SkillID25,
        SkillID26=@in_SkillID26,
        SkillID27=@in_SkillID27,
        SkillID28=@in_SkillID28,
        SkillID29=@in_SkillID29,
        SkillID30=@in_SkillID30,
        SkillID31=@in_SkillID31,
        SkillID32=@in_SkillID32,
        SkillID33=@in_SkillID33   


    where CharID=@in_CharID

---

Warz.dbo.UsersChars

GamePos
GamePos2