[MatthewRoss]

hi, i have a problem with my mysql log, error:

PHP код:

[ERROR] CMySQLQuery::Execute[UploadPlayerAccountNumber] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'VA' at line 1 


in .pwn

PHP код:

forward UploadPlayerAccountNumber(playerid);
public UploadPlayerAccountNumber(playerid) pInfo[playerid][pID] = cache_insert_id(mysql_connect_id); 


public calls when player register account:

PHP код:

stock CreateNewAccount(playerid, password[])
{
    new query_string[66+MAX_PLAYER_NAME-4+30];
    format(query_string, sizeof(query_string), "INSERT INTO `accounts` (`player_name`, `password`, `VIP`, `Mute`, `admin`, `Warns`, `Kills`, `Deaths`, `Banned`) VALUES ('%s', '%s', '%d', '%d', '%d', '%d', '%d', '%d', '%d')",
    pInfo[playerid][pName],
    password,
    pInfo[playerid][pVIP],
    pInfo[playerid][pMute],
    pInfo[playerid][pAdmin],
    pInfo[playerid][pWarns],
    pInfo[playerid][pKills],
    pInfo[playerid][pDeaths],
    pInfo[playerid][pBanned]);
    mysql_function_query(mysql_connect_id, query_string, true, "UploadPlayerAccountNumber", "i", playerid);
    player_is_authorized{playerid} = 1;
    SpawnPlayer(playerid);
    return 1;
} 


thanks!

[Vince]

Query string way too short.

[MatthewRoss]

Quote:

Originally Posted by Vince Query string way too short.

work, thanks!