[Bogdan1992]

Well i really don't know what is happening to my strip, i didn't change nothing. It doesnt want to save peoples infos. Strange is that i dont have problems, even if i'm id 5, etc. But i know something, it doesn't execute this.

mysql_free_result();
Here

PHP код:

stock MySQL_Login(playerid)
{
    new query[300], pnamez[24], savingstring[20];
    GetPlayerName(playerid, pnamez, 24);
    format(query, sizeof(query), "SELECT * FROM `playerdata` WHERE user = '%s' LIMIT 1", pnamez);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(savingstring, "admin");     PlayerInfo[playerid][pAdmin] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "vip");     PlayerInfo[playerid][pVip] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "skin");     PlayerInfo[playerid][pSkin] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "score");     PlayerInfo[playerid][pScore] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "money");     PlayerInfo[playerid][pMoney] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "kills");     PlayerInfo[playerid][pKills] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "deaths");     PlayerInfo[playerid][pDeaths] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "posX");     PlayerInfo[playerid][pPosX] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "posY");     PlayerInfo[playerid][pPosY] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "posZ");     PlayerInfo[playerid][pPosZ] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "posA");     PlayerInfo[playerid][pPosA] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "hours");     PlayerInfo[playerid][pHours] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "minutes"); PlayerInfo[playerid][pMinutes] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "seconds"); PlayerInfo[playerid][pSeconds] = strval(savingstring);
    }
    mysql_free_result();
    GetPlayerName(playerid, pname, sizeof pname);
    format( mystring, sizeof mystring, "Welcome back %s, you logged in successfully.", pname);
    SendClientMessage( playerid, COLOR_WHITE, mystring);
    Logged[playerid] = 1;
    return 1;
} 


or here

PHP код:

    new pnameez[24], query[200];
    GetPlayerName(playerid, pnameez, 24);
    format(query, sizeof(query), "SELECT * FROM `playerdata` WHERE user = '%s' LIMIT 1", pnameez);
    mysql_query(query);
    mysql_store_result();
    new rows = mysql_num_rows();
    if(!rows)
    {
        new strz[182];
        GetPlayerName(playerid, pname, sizeof pname);
          format(strz,sizeof(strz), "{00FFFF}Account: {FFFFFF}%s\n\n{FFFFFF}Type your password below to register a new account.",pnameez);
        ShowPlayerDialog(playerid, 15000, DIALOG_STYLE_PASSWORD, "{FFFFFF}Register an account", strz,"Register","Quit");
    }
    if(rows == 1)
    {
            new strz[182];
            GetPlayerName(playerid, pname, sizeof pname);
        format(strz,sizeof(strz), "{00FFFF}Account: {FFFFFF}%s\n\n{FFFFFF}Type your password below in order to login.",pname);
        ShowPlayerDialog(playerid, 15500, DIALOG_STYLE_PASSWORD, "{FFFFFF}Login", strz,"Login","Quit");
        IsRegistered[playerid] = 1;
    }
    mysql_free_result();