19.06.2012, 21:36
just do like:
Warning, this is just a simple code.
pawn Код:
new ip[20], pname[60], query[100];
GetPlayerIp(playerid, ip, sizeof(ip));
GetPlayerName(playerid, name, sizeof(name));
format(query, sizeof(query), "SELECT * FROM <table name> WHERE username = '%s' AND ip = '%s'", pname, ip);
mysql_query(query);
if(mysql_num_rows() == 1)
{
SendClientMessage(playerid, -1, "Your ip is the same!");
}
else {
new update[100];
format(update, sizeof(update), "UPDATE <table name> SET ip = '%s' WHERE username = '%s'", ip, pname);
SendClientMessage(playerid, -1, "Your ip is different!");
}