27.02.2014, 16:49
Are you looking for this?
If this is what you're searching for, take a while to look through the code I gave you, eventually you will understand how it works.
pawn Код:
new string[500];
format(string, sizeof(string), "SELECT * FROM users WHERE Name = '%s'", UserStats[playerid][Name]);
mysql_query(string);
mysql_store_result();
while (mysql_retrieve_row())
{
mysql_fetch_field_row(string, "Password");
format(UserStats[playerid][Password], 129, "%s", string);
mysql_fetch_field_row(string, "Admin");
UserStats[playerid][Admin] = strval(string);
mysql_fetch_field_row(string, "Kills");
UserStats[playerid][Kills] = strval(string);
mysql_fetch_field_row(string, "Deaths");
UserStats[playerid][Deaths] = strval(string);
}
mysql_free_result();