[Ryz]

....

[yanir3]

`id` is not set to Auto-Increment. Click on 'change' on the id row and mark the A_I option, then confirm the change.

It should show up like this:

[Ryz]

ohh let me try it

[Ryz]

not fixed!

[MacT]

Are you sure you db code in samp is correct way. Maybe something wrong in sql dump file

[Vince]

Read the error closely:

Код:

in 'order clause'

That means you're looking for a query that has ORDER BY in it.

[Ryz]

Quote:

Originally Posted by Vince Read the error closely: Код: in 'order clause' That means you're looking for a query that has ORDER BY in it.

I have already ordered him complete.

here is all quarry list

pawn Код:

Query("INSERT INTO `playerinfo` (`user`,`password`,`IP`,`date`) VALUES ('%s',%d,'%s',%d)",

SaveStats(playerid)
{
    if (!gPlayerInfo[playerid][pLogged]) return 1;
    new query[300];
    Query("UPDATE `playerinfo` SET `score`='%d',`money`='%d',`kills`='%d',`deaths`='%d',`level`='%d',`operator`='%d',`donor`='%d',`pilot`='%d',`isnavy`='%d',`hourson`='%d', `tag`='%d' WHERE `id`='%i'",
    gPlayerInfo[playerid][pScore],gPlayerInfo[playerid][pMoney],gPlayerInfo[playerid][pKills],gPlayerInfo[playerid][pDeaths],
    gPlayerInfo[playerid][pAlevel],gPlayerInfo[playerid][pOp],gPlayerInfo[playerid][pDonor],gPlayerInfo[playerid][pPilot],gPlayerInfo[playerid][pNavy], gPlayerInfo[ playerid ][ Hours ], gPlayerInfo[playerid][pTAG],
    gPlayerInfo[playerid][pDBID]);
    mysql_query(query); //queries
    SendClientMessage(playerid,YELLOW,"Stats saved!");
    return 1;
}