Mysql help - Printable Version

Mysql 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: Mysql help (/showthread.php?tid=599178)

Mysql help - SilverStand - 22.01.2016

Код:

    mysql_format(connection, query, sizeof(query),"SELECT * FROM `banneds` WHERE `name` = '%e' LIMIT 1", pName(playerid));

error

Код:

error 012: invalid function call, not a valid address
warning 215: expression has no effect
error 001: expected token: ";", but found ")"
error 029: invalid expression, assumed zero
fatal error 107: too many error messages on one line

that error is on one line

Re: Mysql help - jlalt - 22.01.2016

Show line which is above

PHP код:



     mysql_format(connection, query, sizeof(query),"SELECT * FROM `banneds` WHERE `name` = '%e' LIMIT 1", pName(playerid));

Re: Mysql help - SilverStand - 22.01.2016

Quote:

Originally Posted by jlalt

Show line which is above

PHP код:



     mysql_format(connection, query, sizeof(query),"SELECT * FROM `banneds` WHERE `name` = '%e' LIMIT 1", pName(playerid));

i put it under onplayerconnect

Re: Mysql help - jlalt - 22.01.2016

Quote:

Originally Posted by SilverStand

i put it under onplayerconnect

Nothing is wrong with your code show lines which above it O.O

Re: Mysql help - SilverStand - 22.01.2016

Код:

public OnPlayerConnect(playerid)
{
	new Query[400];
        mysql_format(connection, Query, sizeof(Query),"SELECT * FROM `banneds` WHERE `name` = '%e' LIMIT 1", pName(playerid));
	mysql_tquery(connection, Query, "BanCheck", "i", playerid);

._.