MySQL help (Vehicle System)
#4

pawn Код:
stock SavePlayer(playerid)
{
    mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET adminlevel ='%d' WHERE accname ='%e'", PlayerInfo[playerid][pAdmin], GetName(playerid));
    mysql_query(sqldb, query);
    //
    new Float: x, Float: y, Float: z, Float: angle;
    GetPlayerPos(playerid, x, y, z);
    GetPlayerFacingAngle(playerid, angle);
   
    mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET posx ='%f' WHERE accname ='%e'", x, GetName(playerid));
    mysql_query(sqldb, query);
   
    mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET posy ='%f' WHERE accname ='%e'", y, GetName(playerid));
    mysql_query(sqldb, query);
   
    mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET posz ='%f' WHERE accname ='%e'", z, GetName(playerid));
    mysql_query(sqldb, query);
   
    mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET angle ='%f' WHERE accname ='%e'", angle, GetName(playerid));
    mysql_query(sqldb, query);
    //
    mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET skin ='%d' WHERE accname ='%e'", GetPlayerSkin(playerid), GetName(playerid));
    mysql_query(sqldb, query);
   
    mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET faction ='%d' WHERE accname ='%e'", PlayerInfo[playerid][pFaction], GetName(playerid));
    mysql_query(sqldb, query);
   
    mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET division ='%d' WHERE accname ='%e'", PlayerInfo[playerid][pDivision], GetName(playerid));
    mysql_query(sqldb, query);
   
    mysql_format(sqldb, query, sizeof(query), "UPDATE accounts SET rank ='%d' WHERE accname ='%e'", PlayerInfo[playerid][pRank], GetName(playerid));
    mysql_query(sqldb, query);
    return 1;
}
Just why? You can run just 1 query. Use strcat to append the other parts of the query.
Would be nice if you also showed us the MySQL debug log.
Reply


Messages In This Thread
MySQL help (Vehicle System) - by Stevolas - 06.04.2014, 20:03
Re: MySQL help (Vehicle System) - by Stevolas - 07.04.2014, 10:08
Re: MySQL help (Vehicle System) - by Sascha - 07.04.2014, 11:55
Re: MySQL help (Vehicle System) - by gtakillerIV - 07.04.2014, 17:16
Re: MySQL help (Vehicle System) - by Stevolas - 07.04.2014, 18:05
Re: MySQL help (Vehicle System) - by gtakillerIV - 07.04.2014, 19:06
Re: MySQL help (Vehicle System) - by Stevolas - 07.04.2014, 20:50
Re: MySQL help (Vehicle System) - by gtakillerIV - 07.04.2014, 21:14
Re: MySQL help (Vehicle System) - by Stevolas - 08.04.2014, 01:02
Re: MySQL help (Vehicle System) - by Binx - 08.04.2014, 01:35

Forum Jump:


Users browsing this thread: 1 Guest(s)