MySQL [R7] ?
#1

FIXED
Reply
#2

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

Could you show me your house loading query?
Reply
#3

Quote:
Originally Posted by Misiur
View Post
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
Reply
#4

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!)
Reply
#5

Quote:
Originally Posted by Misiur
View Post
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 ?
Reply
#6

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

Quote:
Originally Posted by Misiur
View Post
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
Reply
#8

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.
Reply
#9

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

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


Forum Jump:


Users browsing this thread: 1 Guest(s)