SQL Help
#4

Needed help again, can someone help me search everything what matches this GPCI? If you get what i mean
Код:
COMMAND:match(playerid, params[])
{
    if(!PlayerInfo[playerid][power]) return SendClientError(playerid, CANT_USE_CMD);
    new emri;
    if(sscanf(params, "u", emri)) return SCP(playerid, "<partofname/playerid>");
	new sql[500], gpcija[64], Cache:result;
	gpci(emri, gpcija, sizeof(gpcija));
	mysql_format(sqldb, sql, sizeof sql, "SELECT * FROM `gpci` WHERE `gpci` = '%s'", gpcija);
	mysql_query(sqldb, sql);
	if(cache_num_rows())
	{
	    new rows = cache_num_rows();
	    for(new i; i<=rows; i++)
	    {
		    new emri1[128];
			cache_get_field_content(0, "name", emri1);
			format(iStr, sizeof(iStr), "{ff0000}%s matches with %s", emri1, PlayerName(emri));
			SendClientMessage(playerid, -1, iStr);
		}
	}
	else
	{
	    SendClientMessage(playerid, -1, "{ff0000}Can't find any!");
	}
	cache_delete(result);
	return 1;
}
Reply


Messages In This Thread
SQL Help - by fatlirmorina - 24.05.2017, 16:16
Re: SQL Help - by Banditul18 - 24.05.2017, 16:22
Re: SQL Help - by fatlirmorina - 24.05.2017, 16:29
Re: SQL Help - by fatlirmorina - 24.05.2017, 17:40
Re: SQL Help - by Banditul18 - 24.05.2017, 17:53

Forum Jump:


Users browsing this thread: 1 Guest(s)