[Thomixio]

Quote:

Originally Posted by iFarbod This tut can help you https://sampforum.blast.hk/showthread.php?tid=485633

Already seen it, added and updated the onplayerdisconnect to my script-.. still doesn't add the info to my database.

Enabeled the debugging, and there are no errors at this point. However, this doesn't make sense to me?

My OnPlayerDisconnect:

Quote:

[20:36:06] [DEBUG] mysql_format - connection: 1, len: 2048, format: "UPDATE `accounts` SET `Level`=%d, `Gender`=%d, `Age`=%d, `Admin`=%d, `Skin`=%d, `posX`=%f, `posY`=%f, `posZ`=%f WHERE `ID`=%d" [20:36:06] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `Level`=1, `Gender`=1, `Age`=24, `Admin`=0", callback: "OnQueryFinish", format: "ii" [20:36:06] [DEBUG] CMySQLQuery::Execute[OnQueryFinish] - starting query execution [20:36:06] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [20:36:06] [DEBUG] Calling callback "OnQueryFinish".. [20:36:06] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

The only thing getting saved is the username and password?

Code:

public OnPlayerDisconnect(playerid, reason)
{
    GetPlayerPos(playerid, PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2]); 
    mysql_format(Pipeline, szQuery, sizeof(szQuery), "UPDATE `accounts` SET `Level`=%d, `Gender`=%d, `Age`=%d, `Admin`=%d, `Skin`=%d, `posX`=%f, `posY`=%f, `posZ`=%f WHERE `ID`=%d",\
    PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pGender], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pSkin], PlayerInfo[playerid][pPos][0], PlayerInfo[playerid][pPos][1], PlayerInfo[playerid][pPos][2], PlayerInfo[playerid][pID]);
    mysql_function_query(Pipeline, szQuery, true, "OnQueryFinish", "ii", THREAD_NO_RESULT, playerid);
    return 1;
}