Function like format, mysql_format -
andyandyy8 - 04.04.2014
Hi!
I want to use a function for mysql_query something like Function("UPDATE players SET money=%s where id=%d",name,id);
Can I make something like this?
I tried all what i know...
Re: Function like format, mysql_format -
Dignity - 04.04.2014
You want "function" to do what "mysql_query" does?
If so (top of your script);
pawn Код:
#define Function mysql_query
Should work.
Re: Function like format, mysql_format -
Dokins - 04.04.2014
pawn Код:
new query[256];
format(query, sizeof(query), "UPDATE %s SET %s = %d WHERE id = %d LIMIT 1", tablename, fieldname, value, sqlid);
mysql_query(query);
It's simple, just create a string, format it and query it!
You can also replace the '%s' %d etc with actual values.
Of course if you need to retrieve them, do it like you would in a string.
Have fun dude!
Re: Function like format, mysql_format -
andyandyy8 - 05.04.2014
You didn't understand what i want ...
I must to be more explicit...
I want a stock who combine mysql_format and mysql_query...
To execute query you must write only the query....
Function("UPDATE players SET age=%d where id=%d" age,id);
Re: Function like format, mysql_format -
Dokins - 05.04.2014
pawn Код:
MySQL_SetInteger(sqlid, fieldname[], value, tablename[])
{
new query[256];
format(query, sizeof(query), "UPDATE %s SET %s = %d WHERE id = %d LIMIT 1", tablename, fieldname, value, sqlid);
return mysql_query(query);
}
Re: Function like format, mysql_format -
andyandyy8 - 05.04.2014
Thanks a lot !
Re: Function like format, mysql_format -
Dokins - 05.04.2014
No problem, but I'd advise only to use this when updating a single value.
It may cause lag if used excessively.
Re: Function like format, mysql_format -
andyandyy8 - 05.04.2014
Quote:
It may cause lag if used excessively.
|
Why?Is the same thing like
Quote:
format(query, sizeof(query), "UPDATE pl SET s = 5 WHERE id = 1 LIMIT 1");
mysql_query(query);
|
Why did you put there LIMIT 1?
Re: Function like format, mysql_format -
Dokins - 05.04.2014
To limit the query to one update.