SA-MP Forums Archive
SQL Help - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: SQL Help (/showthread.php?tid=634700)


SQL Help - fatlirmorina - 24.05.2017

Well, I am trying to make an ban system but whatever SQL always occurs errors cos I'm a noobie.

Gimme a hand.
Errors:
Код:
[17:59:41] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELCET * FROM `bans` WHERE `ip` = '127.0.0.1'' at line 1
[17:59:41] [WARNING] cache_get_row_count - no active cache
[17:59:41] [WARNING] CMySQLHandle::DeleteSavedResult - invalid result id ('0')
Script:
Код:
new sql123[500], Cache:result;
	mysql_format(sqldb, sql123, sizeof sql123, "SELCET * FROM `bans` WHERE `ip` = '%s'", plrIP);
 	result = mysql_query(sqldb, sql123);
	if(cache_num_rows())
	{
	    SendClientMessage(playerid, -1, "works");
	}
	cache_delete(result);


Re: SQL Help - Banditul18 - 24.05.2017

SELCET

to

SELECT

Re: SQL Help - fatlirmorina - 24.05.2017

oh my fucking god, sorry for this. I am so dumb, thanks mate!

Re: SQL Help - fatlirmorina - 24.05.2017

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;
}


Re: SQL Help - Banditul18 - 24.05.2017

Try like this
PHP код:
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` = '%e'", gpcija);
    result = mysql_query(sqldb, sql);
    new rows = cache_num_rows();
    if(rows > 0)
    {
        for(new row; row < rows; row++)
        {
            new emri1[128];
            cache_get_field_content(row, "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;
}