SA-MP Forums Archive
Saving fightsyles mysql - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: Saving fightsyles mysql (/showthread.php?tid=580826)


Saving fightsyles mysql - STONEGOLD - 08.07.2015

I am trying to players fightstyles as my mysql

But this

PHP код:
21:18:13] [DEBUG] mysql_format - connection: 1, len: 128, format: "WHERE `ID`= %d AND `Username`= '%e'"
[21:18:13] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `players` SET `Admin`=4, `Donator`=0, `RegularPlayer`=0, ", callback: "(null)", format: "(null)"
[21:18:13] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[21:18:13] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prиs de '`FightStyles`=1' а la ligne 1
[21:18:13] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError 
PHP код:
public SavePlayerData(playerid)
{
    new query[2316];
    new tmp[128];
    pData[playerid][pFightStyles] = FightStyleID{playerid};
            
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format(query, sizeof(query), "UPDATE `players` SET " );
        
        format(tmp, sizeof(tmp), "`FightStyles`=%d ", pData[playerid][pFightStyles] );
        strcat(query, tmp);
        mysql_format(mysql, tmp, sizeof(tmp), "WHERE `ID`= %d AND `Username`= '%e'", pData[playerid][pID],  Name[playerid] );
        mysql_tquery(mysql, query, "", "");
        printf("Query:%s", query);
    }
    return 1;
} 


Re: Saving fightsyles mysql - Infernux - 08.07.2015

Try this:

pawn Код:
public SavePlayerData(playerid)
{
    new query[128];
    pData[playerid][pFightStyles] = GetPlayerFightingStyle(playerid);

    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `FightStyles`=%d WHERE `Username`='%s'", pData[playerid][pFightStyles], Name[playerid]);
        mysql_tquery(mysql, query, "", "");
        printf("Query:%s", query);
    }
    return 1;
}
Or maybe FightStyle's structure is not in INT format.

Re : Saving fightsyles mysql - streetpeace - 08.07.2015

PHP код:
public SavePlayerData(playerid)
{
    new query[128];
    pData[playerid][pFightStyles] = GetPlayerFightingStyle(playerid);

    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        mysql_format(mysql, query, sizeof(query), "UPDATE `players` SET `FightStyles`=%d WHERE `Username`='%s'", pData[playerid][pFightStyles], Name[playerid]);
        mysql_query(mysql, query);
        printf("Query:%s", query);
    }
    return 1;
} 
Try this too.

Re: Saving fightsyles mysql - dusk - 08.07.2015

According to your log, you are not showing us the whole code.

Also, for the WHERE part, you format "tmp" and never concatenate it with you "query" variable.

Re: Saving fightsyles mysql - STONEGOLD - 08.07.2015

I am using stract. If i use mysql_format for Update then my others things doesn't work.

here's some codes:

PHP код:
public SavePlayerData(playerid)
{
    new query[2316];
    new tmp[128];
    pData[playerid][pFightStyles] = FightStyleID{playerid};
            
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid))
    {
        format(query, sizeof(query), "UPDATE `players` SET " );
        
        format(tmp, sizeof(tmp), "`Admin`=%d, ", pData[playerid][pAdmin] );
        strcat(query, tmp);
        format(tmp, sizeof(tmp), "`Minutes`=%d, ", pData[playerid][pMinutes] );
        strcat(query, tmp);
        format(tmp, sizeof(tmp), "`Hours`=%d, ", pData[playerid][pHours] );
        strcat(query, tmp);
        format(tmp, sizeof(tmp), "`vLock`=%d ", pData[playerid][pLock] );
        strcat(query, tmp);
        
        format(tmp, sizeof(tmp), "`FightStyles`=%d ", pData[playerid][pFightStyles] );
        strcat(query, tmp);
        mysql_format(mysql, tmp, sizeof(tmp), "WHERE `ID`= %d AND `Username`= '%e'", pData[playerid][pID],  Name[playerid] );
        mysql_tquery(mysql, query, "", "");
        printf("Query:%s", query);
    }
    return 1;
}
//let's load player's information
public OnAccountLoad(playerid)
{
    SetPlayerColor(playerid, -1);
    pData[playerid][pFightStyles] = cache_get_field_content_int(0, "FightStyles");
    IsLoggedIn[playerid] = 1;
    SendClientMessage(playerid, COLOR_CYAN, "You have been logged in, Continue your current life.");
    return 1;
} 


Re: Saving fightsyles mysql - Infernux - 08.07.2015

So, try changing FightStyleID{playerid} to GetPlayerFightingStyle(playerid).

Re: Saving fightsyles mysql - dusk - 08.07.2015

pawn Код:
public SavePlayerData(playerid) 
{ 
    new query[2316]; 
    new tmp[128]; 
    pData[playerid][pFightStyles] = FightStyleID{playerid}; 
             
    if(IsLoggedIn[playerid] == 1 && playerid != INVALID_PLAYER_ID && !IsPlayerNPC(playerid)) 
    { 
        format(query, sizeof(query), "UPDATE `players` SET " ); 
         
        format(tmp, sizeof(tmp), "`Admin`=%d, ", pData[playerid][pAdmin] ); 
        strcat(query, tmp); 

        format(tmp, sizeof(tmp), "`Minutes`=%d, ", pData[playerid][pMinutes] ); 
        strcat(query, tmp); 

        format(tmp, sizeof(tmp), "`Hours`=%d, ", pData[playerid][pHours] ); 
        strcat(query, tmp); 

        format(tmp, sizeof(tmp), "`vLock`=%d, ", pData[playerid][pLock] ); 
        strcat(query, tmp); 
         
        format(tmp, sizeof(tmp), "`FightStyles`=%d ", pData[playerid][pFightStyles] ); 
        strcat(query, tmp); 

        mysql_format(mysql, tmp, sizeof(tmp), "WHERE `ID`= %d AND `Username`= '%e'", pData[playerid][pID],  Name[playerid] ); 
        strcat(query, tmp);
        mysql_tquery(mysql, query, "", ""); 
        printf("Query:%s", query); 
    } 
    return 1; 
}
There was a missing comma after vlock.

Re: Saving fightsyles mysql - STONEGOLD - 08.07.2015

Thanks lol ^^. How the f**K i can miss it.! thanks