[kbalor]

i'm using blueg mysql r7, then after compiling iHouse v2 filtersript by Brandon_More it shows "error 017: undefined symbol "mysql_query"

Is there any way to fix it, to make it compatible with mysql r7? because if I tried to changing my mysql r7 to mysql r6 then after compiling my gamemode it shows hundreds of warnings.

EDIT: Did they change mysql_query to something?

EDIT2: I tried changing mysql_query to mysql_function_query but it shows "error 035: argument type mismatch (argument 1)"

[Abagail]

It's easy to upgrade to r33+. Just use the a_mysql from r33 and show us the errors, and we'll be able to help you.

[Nightkill]

Instead of mysql_query i use

Код:

mysql_format(mysql, sql, sizeof(sql), "SELECT * FROM yourtable");
mysql_tquery(mysql, sql, "", "");

[kbalor]

Quote:

Originally Posted by Abagail It's easy to upgrade to r33+. Just use the a_mysql from r33 and show us the errors, and we'll be able to help you.

Okay thanks, so after upgrading then compiling this errors shows below

Quote:

error 017: undefined symbol "mysql_debug" <= mysql_debug(1); error 035: argument type mismatch (argument 1) <= all the mysql_query - 20+ error lines

[kbalor]

Quote:

Originally Posted by Nightkill Instead of mysql_query i use Код: mysql_format(mysql, sql, sizeof(sql), "SELECT * FROM yourtable"); mysql_tquery(mysql, sql, "", "");

which version of mysql you're using?

coz my gamemode is only compatible for mysql r7 if I upgraded to the latest version it shows hundreds of errors and the filterscript that I'am using is compatible with mysql r6.

[Nightkill]

I'm using R39-2 which I think it's the latest.

[kbalor]

Quote:

Originally Posted by Nightkill I'm using R39-2 which I think it's the latest.

cool! I hope someone help me with this. I tried using R39-2 but it shows warning

Quote:

warning 206: redundant test: constant expression is non-zero warning 215: expression has no effect

line:

Quote:

mysql_debug(1);

[Nightkill]

On main() I have something like this for debug

Код:

mysql_log(LOG_ERROR | LOG_WARNING | LOG_DEBUG);
mysql = mysql_connect(host, user, db, pass);

so everytime I start the server a file named mysql_log.txt will be created and there I have the full debugging

[Dutheil]

Quote:

Originally Posted by Nightkill Instead of mysql_query i use Код: mysql_format(mysql, sql, sizeof(sql), "SELECT * FROM yourtable"); mysql_tquery(mysql, sql, "", "");

just : mysql_tquery(mysql, sql);
will work