[GeonMake]

I went on mysql id, user, admin password but I do not go saving

pawn Код:

public OnPlayerRegister(playerid, password[]) // v1.0 by Luk0r
{
    if(IsPlayerConnected(playerid))
    {
        MySQLCheckConnection();
        new playername3[MAX_PLAYER_NAME];
        GetPlayerName(playerid, playername3, sizeof(playername3));
        new newaccountsqlid = MySQLCreateAccount(playername3, password);
        if (newaccountsqlid != 0)
        {
            PlayerInfo[playerid][pSQLID] = newaccountsqlid;
            //PlayerInfo[playerid][pKey] = password;
            strmid(PlayerInfo[playerid][pKey], password, 0, strlen(password), 255);
            OnPlayerUpdate(playerid);
            new loginstring[128];
            new loginname[64];
            GetPlayerName(playerid,loginname,sizeof(loginname));
            format(loginstring,sizeof(loginstring),"Bine ai venit, {91B17A}%s{A9C4E4}\nAcum poti sa te loghezi pe cont:",loginname);
            ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"Login",loginstring,"Login","Exit");
            return 1;
        }
        else
        {
            SendClientMessage(playerid, 0xFF6347AA, "There was an error creating your account. You will be disconnected now.");
            Kick(playerid);
            return 0;
        }
    }
    return 0;
}

public OnPlayerUpdate(playerid) // by Luk0r v1.2
{
    if(IsPlayerConnected(playerid))
    {
        if(gPlayerLogged[playerid])
        {
            MySQLCheckConnection();
            new query[MAX_STRING];
            format(query, MAX_STRING, "UPDATE players SET ");
            MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "Password", PlayerInfo[playerid][pKey]);
            MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "Sex", PlayerInfo[playerid][pSex]);
            MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "Origin", PlayerInfo[playerid][pOrigin]);
            //MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "FirstLogin", PlayerInfo[playerid][pFLogin]);
            MySQLUpdatePlayerStr(query, PlayerInfo[playerid][pSQLID], "Staff", PlayerInfo[playerid][pStaff]);
            MySQLUpdateFinish(query, PlayerInfo[playerid][pSQLID]);
        }
    }
    return 1;
}

public OnPlayerLogin(playerid,password[]) // by Luk0r v1.0
{
    MySQLCheckConnection();
//  new tmp2[256];
//  new string2[64];
    new playername2[MAX_PLAYER_NAME];
    new playernamesplit[3][MAX_PLAYER_NAME];
    GetPlayerName(playerid, playername2, sizeof(playername2));
    split(playername2, playernamesplit, '_');
    MySQLFetchAcctSingle(PlayerInfo[playerid][pSQLID], "Password", PlayerInfo[playerid][pKey]);
    if(strcmp(PlayerInfo[playerid][pKey],password, true ) == 0 )
    {
        new Data[1024];
        new Field[64];
        new rcnt = 1;
        MySQLFetchAcctRecord(PlayerInfo[playerid][pSQLID], Data);
        samp_mysql_strtok(Field, "|", Data);
        while (samp_mysql_strtok(Field, "|", "")==1)
        {
            if (rcnt == 3) PlayerInfo[playerid][pSex] = strval(Field);
            if (rcnt == 4) PlayerInfo[playerid][pOrigin] = strval(Field);
            //if (rcnt == 5) PlayerInfo[playerid][pFLogin] = strval(Field);
            if (rcnt == 5) PlayerInfo[playerid][pStaff] = strval(Field);
            rcnt++;
        }
//          samp_mysql_free_result();
        }
        else
        {
        new loginstring[128];
        new loginname[64];
        GetPlayerName(playerid,loginname,sizeof(loginname));
        format(loginstring,sizeof(loginstring),"PAROLA GRESITA\nTe rog baga parola corecta:",loginname);
        ShowPlayerDialog(playerid,3,DIALOG_STYLE_INPUT,"Login",loginstring,"Login","Exit");
        gPlayerLogTries[playerid] += 1;
        if(gPlayerLogTries[playerid] == 4) { Ban(playerid); }
        return 1;
    }
    SpawnPlayer(playerid);
    return 1;
}

[WackoX]

Pffff.. what did the SQL log say?

[GeonMake]

I do not understand

[GeonMake]

where to find the sql logs?

[GeonMake]

aa mysql_log is blank

[GeonMake]

pawn Код:

[01:36:45]  

[01:36:45] ---------------------------

[01:36:45] MySQL Debugging activated (06/16/11)

[01:36:45] ---------------------------

[01:36:45]  

[01:37:11] >> mysql_real_escape_string( Connection handle: 1 )

[01:37:11] CMySQLHandler::EscapeString(WaLLy_Larro); - Escaped 11 characters to WaLLy_Larro.

[01:37:11] >> mysql_query( Connection handle: 1 )

[01:37:11] CMySQLHandler::Query(SELECT `id` FROM `players` WHERE `name` = 'WaLLy_Larro' LIMIT 1) - Successfully executed.

[01:37:11] >> mysql_store_result( Connection handle: 1 )

[01:37:11] CMySQLHandler::StoreResult() - Result was stored.

[01:37:11] >> mysql_num_rows( Connection handle: 1 )

[01:37:11] CMySQLHandler::NumRows() - Returned 1 row(s)

[01:37:11] >> mysql_fetch_row_format( Connection handle: 1 )

[01:37:11] CMySQLHandler::FetchRow() - Return: 2

[01:37:14] >> mysql_query( Connection handle: 1 )

[01:37:14] CMySQLHandler::Query(SELECT * FROM `players` WHERE `name` = 'WaLLy_Larro' AND `password` = 'engame') - Successfully executed.

[01:37:14] >> mysql_store_result( Connection handle: 1 )

[01:37:14] CMySQLHandler::StoreResult() - Result was stored.

[01:37:14] >> mysql_num_rows( Connection handle: 1 )

[01:37:14] CMySQLHandler::NumRows() - Returned 1 row(s)

[01:37:14] >> mysql_fetch_row_format( Connection handle: 1 )

[01:37:14] CMySQLHandler::FetchRow() - Return: 2|WaLLy_Larro|engame|1|1|4|0

[01:37:14] >> mysql_free_result( Connection handle: 1 )

[01:37:14] CMySQLHandler::FreeResult() - Result was successfully free'd.

[01:38:11] >> mysql_close( Connection handle: 1 )

[01:38:11] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[01:38:11] CMySQLHandler::FreeResult() - The result is already empty.

[01:38:11] CMySQLHandler::Disconnect() - Connection was closed.