MySQL [R7] ? - Printable Version

MySQL [R7] ? - 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 [R7] ? (/showthread.php?tid=567270)

MySQL [R7] ? - Aprezt - 12.03.2015

FIXED

Re: MySQL [R7] ? - Misiur - 12.03.2015

Edit: Oh sorry, I'm wrong about that.

Could you show me your house loading query?

Re: MySQL [R7] ? - Aprezt - 12.03.2015

Quote:

Originally Posted by Misiur

You forgot callback!

pawn Code:

mysql_function_query(g_ConnectionHandle, string, true, "onHouseDataLoad", "");

Its load everything just i want to get know why this thing dont load name to 3dtextlabe. I want use this function (nameFromSQL) again in another things like Car owner. Its dont load ID to name. I

Re: MySQL [R7] ? - Misiur - 12.03.2015

I know, but you can fetch player name at the same time in single query:

pawn Code:

SELECT h.*, p.name FROM houses h LEFT JOIN players p ON p.id = h.owner_id

(warning, return field names can be different due to aliases!)

Re: MySQL [R7] ? - Aprezt - 12.03.2015

Quote:

Originally Posted by Misiur

I know, but you can fetch player name at the same time in single query:

pawn Code:

SELECT h.*, p.name FROM houses h LEFT JOIN players p ON p.id = h.owner_id

(warning, return field names can be different due to aliases!)

Still nothing.
Somebody ?

Re: MySQL [R7] ? - Misiur - 12.03.2015

You can't use it as is, in your onHouseDataLoad player name is available under cache_get_row(x, 13, fetch);

Re: MySQL [R7] ? - Aprezt - 12.03.2015

Quote:

Originally Posted by Misiur

You can't use it as is, in your onHouseDataLoad player name is available under cache_get_row(x, 13, fetch);

R5 or R6 version i dont remember and that worked and didnt do any shit. and now R7 cant handle that

Re: MySQL [R7] ? - Misiur - 12.03.2015

This used nonthreaded queries, so if you like your server lagging and 1s lag when someone uses this command, you could use threaded version. But if you want to code smarter, not choosing the easy path, please reread what I've written.

Re: MySQL [R7] ? - Abagail - 12.03.2015

R7 isn't supposed to be better, r33 is.

You shouldn't expect so much of such an old version.