30.12.2012, 10:39
Give this a whirl.
PHP Code:
format(query, sizeof(query), "SELECT `user` FROM accounts WHERE `user`='%s' LIMIT 1", name);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() > 0)
{
Player[playerid][Money] -= price;
format(string, sizeof(string), "[Contract] A contract for $%s has been added to your PDA. Please check it now.", FormatNumber(price));
SendFactionMessage(2, YELLOW, string);
SaveContract(pName(playerid), name, price);
format(string, sizeof(string), "You have successfully placed a hit on %s for $%s.", name, FormatNumber(price));
SendClientMessage(playerid, YELLOW, string);
return true;
}
else
{
SendClientMessage(playerid, GREY, "That name isn't in the database.");
return true;
}