Mysql Convert - Printable Version

Mysql Convert - 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 Convert (/showthread.php?tid=623981)

Mysql Convert - saffierr - 09.12.2016

Since I've just noticed the update from Mysql to R41-2, I'm really struggling with it in pawno, I've read a tutorial on how to convert everything yet I find difficulties to change it succesfully, hence this topic, I'd like to get some help guys.

One example:

PHP код:



cache_get_data(rows, fields, mysql);

What'd be the correct way to convert this?

Re: Mysql Convert - AroseKhanNiazi - 09.12.2016

Sorry not helping but if there's a tutorial on it can you link me to it? I was not able to locate it.

Re: Mysql Convert - X337 - 09.12.2016

There's a tutorial already about updating mysql plugin https://sampforum.blast.hk/showthread.php?tid=616103

Re: Mysql Convert - saffierr - 09.12.2016

Quote:

Originally Posted by saffierr

I've read a tutorial on how to convert everything yet I find difficulties to change it succesfully.

What'd be the correct way to convert this?

Quote:

Originally Posted by X337

There's a tutorial already about updating mysql plugin https://sampforum.blast.hk/showthread.php?tid=616103

I already tried, though getting a push in the back would help alot.

Re: Mysql Convert - Konstantinos - 09.12.2016

I just read the part about the function you mentioned and it is pretty clear to me that the function was completely removed. As the example shown in the tutorial, you'd use:

pawn Код:

new rows;
cache_get_row_count(rows);

to get the rows or:

pawn Код:

new fields;
cache_get_field_count(fields);

to get the number of fields. Something that I'm not sure if it is mentioned in the tutorial is that you can retrieve the number of rows using:

pawn Код:

new rows = cache_num_rows();

as well.

Re: Mysql Convert - saffierr - 09.12.2016

I see, lol I gave out an easy peace of code. Well, I guess I'll just try it myself, that's the best after all.
Thanks anyways for helping.

Re: Mysql Convert - AroseKhanNiazi - 09.12.2016

Your thread, informed me that there is tutorial for converting and I already converted my post script

so thanks!