Quote:
Originally Posted by Pinguinn
Somewhere at the top
pawn Код:
#define TABLE_NAME "[table name here]"
new pDeath[MAX_PLAYERS];
pawn Код:
public OnPlayerDeath(playerid, killerid, reason)
{
if(killerid != INVALID_PLAYER_ID)
{
pDeath[playerid]++;
}
}
public OnPlayerDisconnect(playerid)
{
// make sure you have already connected to the database
new name[MAX_PLAYER_NAME]; GetPlayerName(playerid, name, sizeof(name));
mysql_query("UPDATE %s SET death = '%d' WHERE name = '%s'", TABLE_NAME, pDeath[playerid], name);
}
|
You would need to format the query before sending it, since mysql_query doesn't.
pawn Код:
new query[256];
format(query, sizeof (query), "UPDATE `users` SET `death` = %d WHERE `name` = '%s'", pDeath[playerid], name);
mysql_query(query);
or, if you're using BlueG's plugin you can use mysql_format.
pawn Код:
new query[256];
mysql_format(-1, query, "UPDATE `users` SET `death` = %d WHERE `name` = '%s'", pDeath[playerid], name);
mysql_query(query);
And for the kills, you do exactly the same thing, only that you're updating the kills column instead of the death one.
