SA-MP Forums Archive
MySQL Question - 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 Question (/showthread.php?tid=573828)



MySQL Question - Tony$$ - 10.05.2015

Yo,
Just wanted to ask in BlueG's R7 MySQL is there any code that i can replace with this? cache_get_row_int


Re: MySQL Question - Yashas - 11.05.2015

What are you even trying?


cache_get_field_content_int
if you do not know the field number you can use the field name.

Both the functions are the same but this one accepts a field name where as the one you mentioned accepts the field index.

Код:
new int_dest = cache_get_field_content_int(2, "money");
printf("The value in the third row and in the field 'money' is '%d'.", int_dest);
[code]new int_dest = cache_get_row_int(3, 0);
printf("The number stored in the fourth row and first field is '%d'.", int_dest);


Re: MySQL Question - Konstantinos - 11.05.2015

cache_get_row -> strval

Though R7 is an old version, update to R39-3.


Re: MySQL Question - Tony$$ - 11.05.2015

I would though but got this issue whenever i try to upload any MySQL gamemodes with any mysql version except R7
Код:
 [15:22:50]  Loading plugin: mysql.so
[15:22:51]   Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16 not defined in file libmysqlclient_r.so.16 with link time reference)



Re: MySQL Question - Konstantinos - 11.05.2015

Q: I get a Failed (plugins/mysql.so: symbol __cxa_pure_virtual, version libmysqlclient_16[...] error, is there any way to fix it?
A: That likely means that you are using a 64bit system and thus a 64bit libmysqlclient library. You'll have to use the static version of the plugin, the mysql_static.so.


Re: MySQL Question - Tony$$ - 12.05.2015

oh shit it works thanks konstatinimus