format - Printable Version

format - 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: format (/showthread.php?tid=625842)

format - Loinal - 07.01.2017

PHP код:



format(connectionHandle, sizeof(connectionHandle), "SELECT `name` FROM `banlog` WHERE name = '%s' AND banned = 1 LIMIT 1", escstring(params));

Код:

D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(3320) : error 035: argument type mismatch (argument 1)
D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(3320) : error 035: argument type mismatch (argument 1)

Re: format - Jack_Leslie - 07.01.2017

Try mysql_format?

Re: format - Loinal - 07.01.2017

gives same error

PHP код:



mysql_format(connectionHandle, sizeof(connectionHandle), "SELECT `name` FROM `banlog` WHERE name = '%s' AND banned = 1 LIMIT 1", escstring(params));

Re: format - iLearner - 07.01.2017

PHP код:



new query[100];

mysql_format(connectionHandle, query, sizeof(query), "SELECT `name` FROM `banlog` WHERE name = '%s' AND banned = 1 LIMIT 1", escstring(params));  


mysql_query(connectionHandle, query);

Re: format - ranme15 - 07.01.2017

Show us escstring, connectionHandle.

Re: format - Loinal - 07.01.2017

Quote:

Originally Posted by iLearner

PHP код:



new query[100];

mysql_format(connectionHandle, query, sizeof(query), "SELECT `name` FROM `banlog` WHERE name = '%s' AND banned = 1 LIMIT 1", escstring(params));  


mysql_query(connectionHandle, query);

Код:

D:\samp folder\(XteMeS) xMs\gamemodes\xMs.pwn(3321) : warning 213: tag mismatch

PHP код:



mysql_format(connectionHandle,query, sizeof(connectionHandle), "SELECT `name` FROM `banlog` WHERE name = '%s' AND banned = 1 LIMIT 1", escstring(params));

Re: format - iLearner - 07.01.2017

1: show us where did you define connectionhandle
2: Show us what (where) did you assign to connectionhandle.
3: sizeof(query), not sizeof(connectionhandle)

Re: format - Yaa - 07.01.2017

PHP код:



mysql_format(connectionHandle,query, sizeof(query), "SELECT `name` FROM `banlog` WHERE name = '%s' AND banned = 1 LIMIT 1", escstring(params));

also check if definition of connhandle it's

PHP код:



new MySQL:connectionHandle;

Re: format - Loinal - 07.01.2017

gives me same warnings

Re: format - StrikerZ - 07.01.2017

PHP код:



mysql_format(connectionHandle,query, sizeof(query), "SELECT `name` FROM `banlog` WHERE `name` = '%s' AND `banned` = '%d' LIMIT 1", escstring(params),1);

And tell us the mysql version you use.