[vassilis]

PHP Code:

    if(db_num_rows(queryresult) == MAX_HOUSES_PER_PLAYER) return SendClientMessage(playerid, 0xFF0000, "You already have the max amount of houses"); 


How this line could be converted in MySQL?

[Sawalha]

https://sampwiki.blast.hk/wiki/MySQL/R33#cache_get_data

using it in a threaded queries, but first define variables of rows and fields to use them in the function, and then the rows variable will hold the number of rows of the threaded-query.
you can use it in the callback you call in mysql_tquery function.

[vassilis]

PHP Code:

new rows, fields;
cache_get_data(rows, fields); 


I know this function. Should i use it something like this?

PHP Code:

if(rows == MAX_PLAYER_PER_HOUSE 


[Sawalha]

exactly, but as i have told you, you have to use it in the callback that the function mysql_tquery called to store the query results in using cache_get_data