1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
2 problems with MySQL R40
Kraeror
Gangsta
****
Posts: 536
Threads: 81
Joined: Mar 2017
Reputation: 0
#1

05.01.2018, 12:19
Hello guys can you help me please?
I'm using R40 as I said!
I have two problems, so the first one is:
PHP код:
new h; cache_get_row_count(h);
new query[2048];
mysql_format(zMySQL, query, sizeof(query), "INSERT INTO `houses`(`ID`, `Owner`, `Price`, `X`, `Y`, `Z`, `World`, `X2`, `Y2`, `Z2`, `A2`, `Int:X`, `Int:Y`, `Int:Z`, `Int:X2`, `Int:Y2`, `Int:Z2`, `Int:A2`, `Interior`, `Spawn:X`, `Spawn:Y`, `Spawn:Z`, `Spawn:A`, `Status`) VALUES ('%d', '%e', '%d', '%f', '%f', '%f', '%d', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%f', '%d', '%f', '%f', '%f', '%f', '%d')",
h, HouseInfo[h][hOwner], HouseInfo[h][hPrice], HouseInfo[h][hX], HouseInfo[hY], HouseInfo[h][hZ], -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1);
mysql_tquery(zMySQL, query); 
Output: X: 151.123201, Y: 0, Z: 13.05541 and etc.
The problem is that, the database set the Y coordinate to 0, I tried it to save with dini and dini is saving it correct, but there is problem with my mysql code I'm sure that the table is creating the table with float value. I have already checked it!

And the second is that houses can't be loaded
Here is loading(OnGameModeInit callback):
PHP код:
for(new h = 1; h < MAX_HOUSES; h++)
    {
        new house[64], query[1024];
        mysql_format(zMySQL, query, sizeof(query), "SELECT * FROM `houses` WHERE `ID` = %d", h);
          mysql_tquery(zMySQL, query, "LoadHouses", "h");
        if( strcmp(HouseInfo[h][hOwner], "No", true) == 0 )
        {
            HouseInfo[h][hPickup] = CreatePickup(1273, 1, HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ]);
            HouseInfo[h][hIcon] = CreateDynamicMapIcon(HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ], 31, 0,0,0);
        }
        else
        {
            HouseInfo[h][hPickup] = CreatePickup(19522, 1, HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ]);
            HouseInfo[h][hIcon] = CreateDynamicMapIcon(HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ], 32, 0,0,0);
        }
    } 
and here is my LoadHouses callback:
PHP код:
forward LoadHouses(houseid);
public LoadHouses(houseid)
{
    cache_get_value_name(houseid, "Owner", HouseInfo[houseid][hOwner]);
    cache_get_value_name_float(houseid, "X", HouseInfo[houseid][hX]);
    cache_get_value_name_float(houseid, "Y", HouseInfo[houseid][hY]);
    cache_get_value_name_float(houseid, "Z", HouseInfo[houseid][hZ]);
    cache_get_value_name_float(houseid, "Int:X", HouseInfo[houseid][hiX]);
    cache_get_value_name_float(houseid, "Int:Y", HouseInfo[houseid][hiY]);
    cache_get_value_name_float(houseid, "Int:Z", HouseInfo[houseid][hiZ]);
    cache_get_value_name_float(houseid, "X2", HouseInfo[houseid][hX2]);
    cache_get_value_name_float(houseid, "Y2", HouseInfo[houseid][hY2]);
    cache_get_value_name_float(houseid, "Z2", HouseInfo[houseid][hZ2]);
    cache_get_value_name_float(houseid, "A2", HouseInfo[houseid][hA2]);
    cache_get_value_name_float(houseid, "Int:X2", HouseInfo[houseid][hiX2]);
    cache_get_value_name_float(houseid, "Int:Y2", HouseInfo[houseid][hiY2]);
    cache_get_value_name_float(houseid, "Int:Z2", HouseInfo[houseid][hiZ2]);
    cache_get_value_name_float(houseid, "Int:A2", HouseInfo[houseid][hiA2]);
    cache_get_value_name_float(houseid, "Spawn:X", HouseInfo[houseid][hsX]);
    cache_get_value_name_float(houseid, "Spawn:Y", HouseInfo[houseid][hsY]);
    cache_get_value_name_float(houseid, "Spawn:Z", HouseInfo[houseid][hsZ]);
     cache_get_value_name_float(houseid, "Spawn:A", HouseInfo[houseid][hsA]);
    cache_get_value_name_int(houseid, "Interior", HouseInfo[houseid][hInt]);
    cache_get_value_name_int(houseid, "World", HouseInfo[houseid][hVW]);
    cache_get_value_name_int(houseid, "Price", HouseInfo[houseid][hPrice]);
    cache_get_value_name_int(houseid, "Status", HouseInfo[houseid][hStatus]);
    return 1;
} 
Sorry for my realy bad english!
Find
Reply
iLearner
Gangsta
****
Posts: 579
Threads: 18
Joined: Apr 2017
Reputation: 0
#2

05.01.2018, 12:25
About question 1, debug the HouseInfo[hY] value (
PHP код:
printf("%f", HouseInfo[hY]); 
) and post it.

Second one goes this way:
PHP код:
for(new h = 1; h < MAX_HOUSES; h++) 
{ 
    new house[64], query[1024]; 
    mysql_format(zMySQL, query, sizeof(query), "SELECT * FROM `houses` WHERE `ID` = %d", h); 
    mysql_tquery(zMySQL, query, "LoadHouses", "i",h);  
}  
forward LoadHouses(houseid); 
public LoadHouses(houseid) 
{ 
    cache_get_value_name(houseid, "Owner", HouseInfo[houseid][hOwner]); 
    cache_get_value_name_float(houseid, "X", HouseInfo[houseid][hX]); 
    cache_get_value_name_float(houseid, "Y", HouseInfo[houseid][hY]); 
    cache_get_value_name_float(houseid, "Z", HouseInfo[houseid][hZ]); 
    cache_get_value_name_float(houseid, "Int:X", HouseInfo[houseid][hiX]); 
    cache_get_value_name_float(houseid, "Int:Y", HouseInfo[houseid][hiY]); 
    cache_get_value_name_float(houseid, "Int:Z", HouseInfo[houseid][hiZ]); 
    cache_get_value_name_float(houseid, "X2", HouseInfo[houseid][hX2]); 
    cache_get_value_name_float(houseid, "Y2", HouseInfo[houseid][hY2]); 
    cache_get_value_name_float(houseid, "Z2", HouseInfo[houseid][hZ2]); 
    cache_get_value_name_float(houseid, "A2", HouseInfo[houseid][hA2]); 
    cache_get_value_name_float(houseid, "Int:X2", HouseInfo[houseid][hiX2]); 
    cache_get_value_name_float(houseid, "Int:Y2", HouseInfo[houseid][hiY2]); 
    cache_get_value_name_float(houseid, "Int:Z2", HouseInfo[houseid][hiZ2]); 
    cache_get_value_name_float(houseid, "Int:A2", HouseInfo[houseid][hiA2]); 
    cache_get_value_name_float(houseid, "Spawn:X", HouseInfo[houseid][hsX]); 
    cache_get_value_name_float(houseid, "Spawn:Y", HouseInfo[houseid][hsY]); 
    cache_get_value_name_float(houseid, "Spawn:Z", HouseInfo[houseid][hsZ]); 
    cache_get_value_name_float(houseid, "Spawn:A", HouseInfo[houseid][hsA]); 
    cache_get_value_name_int(houseid, "Interior", HouseInfo[houseid][hInt]); 
    cache_get_value_name_int(houseid, "World", HouseInfo[houseid][hVW]); 
    cache_get_value_name_int(houseid, "Price", HouseInfo[houseid][hPrice]); 
    cache_get_value_name_int(houseid, "Status", HouseInfo[houseid][hStatus]);
    if( strcmp(HouseInfo[h][hOwner], "No", true) == 0 ) 
    { 
        HouseInfo[h][hPickup] = CreatePickup(1273, 1, HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ]); 
        HouseInfo[h][hIcon] = CreateDynamicMapIcon(HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ], 31, 0,0,0); 
    } 
    else 
    { 
        HouseInfo[h][hPickup] = CreatePickup(19522, 1, HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ]); 
        HouseInfo[h][hIcon] = CreateDynamicMapIcon(HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ], 32, 0,0,0); 
    } 
    return 1; 
} 
Find
Reply
Kraeror
Gangsta
****
Posts: 536
Threads: 81
Joined: Mar 2017
Reputation: 0
#3

05.01.2018, 12:35
Quote:
Originally Posted by iLearner
Посмотреть сообщение
About question 1, debug the HouseInfo[hY] value (
PHP код:
printf("%f", HouseInfo[hY]); 
) and post it.

Second one goes this way:
PHP код:
for(new h = 1; h < MAX_HOUSES; h++) 
{ 
    new house[64], query[1024]; 
    mysql_format(zMySQL, query, sizeof(query), "SELECT * FROM `houses` WHERE `ID` = %d", h); 
    mysql_tquery(zMySQL, query, "LoadHouses", "i",h);  
}  
forward LoadHouses(houseid); 
public LoadHouses(houseid) 
{ 
    cache_get_value_name(houseid, "Owner", HouseInfo[houseid][hOwner]); 
    cache_get_value_name_float(houseid, "X", HouseInfo[houseid][hX]); 
    cache_get_value_name_float(houseid, "Y", HouseInfo[houseid][hY]); 
    cache_get_value_name_float(houseid, "Z", HouseInfo[houseid][hZ]); 
    cache_get_value_name_float(houseid, "Int:X", HouseInfo[houseid][hiX]); 
    cache_get_value_name_float(houseid, "Int:Y", HouseInfo[houseid][hiY]); 
    cache_get_value_name_float(houseid, "Int:Z", HouseInfo[houseid][hiZ]); 
    cache_get_value_name_float(houseid, "X2", HouseInfo[houseid][hX2]); 
    cache_get_value_name_float(houseid, "Y2", HouseInfo[houseid][hY2]); 
    cache_get_value_name_float(houseid, "Z2", HouseInfo[houseid][hZ2]); 
    cache_get_value_name_float(houseid, "A2", HouseInfo[houseid][hA2]); 
    cache_get_value_name_float(houseid, "Int:X2", HouseInfo[houseid][hiX2]); 
    cache_get_value_name_float(houseid, "Int:Y2", HouseInfo[houseid][hiY2]); 
    cache_get_value_name_float(houseid, "Int:Z2", HouseInfo[houseid][hiZ2]); 
    cache_get_value_name_float(houseid, "Int:A2", HouseInfo[houseid][hiA2]); 
    cache_get_value_name_float(houseid, "Spawn:X", HouseInfo[houseid][hsX]); 
    cache_get_value_name_float(houseid, "Spawn:Y", HouseInfo[houseid][hsY]); 
    cache_get_value_name_float(houseid, "Spawn:Z", HouseInfo[houseid][hsZ]); 
    cache_get_value_name_float(houseid, "Spawn:A", HouseInfo[houseid][hsA]); 
    cache_get_value_name_int(houseid, "Interior", HouseInfo[houseid][hInt]); 
    cache_get_value_name_int(houseid, "World", HouseInfo[houseid][hVW]); 
    cache_get_value_name_int(houseid, "Price", HouseInfo[houseid][hPrice]); 
    cache_get_value_name_int(houseid, "Status", HouseInfo[houseid][hStatus]);
    if( strcmp(HouseInfo[h][hOwner], "No", true) == 0 ) 
    { 
        HouseInfo[h][hPickup] = CreatePickup(1273, 1, HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ]); 
        HouseInfo[h][hIcon] = CreateDynamicMapIcon(HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ], 31, 0,0,0); 
    } 
    else 
    { 
        HouseInfo[h][hPickup] = CreatePickup(19522, 1, HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ]); 
        HouseInfo[h][hIcon] = CreateDynamicMapIcon(HouseInfo[h][hX], HouseInfo[h][hY], HouseInfo[h][hZ], 32, 0,0,0); 
    } 
    return 1; 
} 
It prints correct!
There is problem with table or code
Can you help me pls! I checked the table and the all floats, that I created are recreated to "double", but X and Z coordinates are saved without any problems!
Find
Reply
iLearner
Gangsta
****
Posts: 579
Threads: 18
Joined: Apr 2017
Reputation: 0
#4

05.01.2018, 12:43
Can you show your table structure?
Find
Reply
Kraeror
Gangsta
****
Posts: 536
Threads: 81
Joined: Mar 2017
Reputation: 0
#5

05.01.2018, 12:52
Here you are: https://imgur.com/a/DV1bP
Find
Reply
Kraeror
Gangsta
****
Posts: 536
Threads: 81
Joined: Mar 2017
Reputation: 0
#6

05.01.2018, 12:58
Fixed bro :X, realy stupid mistake... Look HouseInfo[hY] it have to be HouseInfo[h][hY]...
Find
Reply
Kraeror
Gangsta
****
Posts: 536
Threads: 81
Joined: Mar 2017
Reputation: 0
#7

05.01.2018, 13:04
About the loading system, it loads all of the houses to coordinates 0,0,0! Please help! I think it is because of the houses IDs, so in the table the IDs are started from 17! It was started from 1 or 0, but when I delete any house there is some problem Please help me brother
Find
Reply
iLearner
Gangsta
****
Posts: 579
Threads: 18
Joined: Apr 2017
Reputation: 0
#8

05.01.2018, 13:12
PHP код:
// whereever you load your houses   
mysql_tquery(zMySQL, "SELECT * FROM `houses`", "LoadHouses");     

forward LoadHouses();  
public LoadHouses()  
{  
    for(new i=0; i<cache_num_rows(); i++)
    {
        cache_get_value_name(i, "Owner", HouseInfo[i][hOwner]);  
        cache_get_value_name_float(i, "X", HouseInfo[i][hX]);  
        cache_get_value_name_float(i, "Y", HouseInfo[i][hY]);  
        cache_get_value_name_float(i, "Z", HouseInfo[i][hZ]);  
        cache_get_value_name_float(i, "Int:X", HouseInfo[i][hiX]);  
        cache_get_value_name_float(i, "Int:Y", HouseInfo[i][hiY]);  
        cache_get_value_name_float(i, "Int:Z", HouseInfo[i][hiZ]);  
        cache_get_value_name_float(i, "X2", HouseInfo[i][hX2]);  
        cache_get_value_name_float(i, "Y2", HouseInfo[i][hY2]);  
        cache_get_value_name_float(i, "Z2", HouseInfo[i][hZ2]);  
        cache_get_value_name_float(i, "A2", HouseInfo[i][hA2]);  
        cache_get_value_name_float(i, "Int:X2", HouseInfo[i][hiX2]);  
        cache_get_value_name_float(i, "Int:Y2", HouseInfo[i][hiY2]);  
        cache_get_value_name_float(i, "Int:Z2", HouseInfo[i][hiZ2]);  
        cache_get_value_name_float(i, "Int:A2", HouseInfo[i][hiA2]);  
        cache_get_value_name_float(i, "Spawn:X", HouseInfo[i][hsX]);  
        cache_get_value_name_float(i, "Spawn:Y", HouseInfo[i][hsY]);  
        cache_get_value_name_float(i, "Spawn:Z", HouseInfo[i][hsZ]);  
        cache_get_value_name_float(i, "Spawn:A", HouseInfo[i][hsA]);  
        cache_get_value_name_int(i, "Interior", HouseInfo[i][hInt]);  
        cache_get_value_name_int(i, "World", HouseInfo[i][hVW]);  
        cache_get_value_name_int(i, "Price", HouseInfo[i][hPrice]);  
        cache_get_value_name_int(i, "Status", HouseInfo[i][hStatus]); 
        if( strcmp(HouseInfo[i][hOwner], "No", true) == 0 )  
        {  
            HouseInfo[i][hPickup] = CreatePickup(1273, 1, HouseInfo[i][hX], HouseInfo[i][hY], HouseInfo[i][hZ]);  
            HouseInfo[i][hIcon] = CreateDynamicMapIcon(HouseInfo[i][hX], HouseInfo[i][hY], HouseInfo[i][hZ], 31, 0,0,0);  
        }  
        else  
        {  
            HouseInfo[i][hPickup] = CreatePickup(19522, 1, HouseInfo[i][hX], HouseInfo[i][hY], HouseInfo[i][hZ]);  
            HouseInfo[i][hIcon] = CreateDynamicMapIcon(HouseInfo[i][hX], HouseInfo[i][hY], HouseInfo[i][hZ], 32, 0,0,0);  
        }
    }  
    return 1;  
} 
Find
Reply
Kraeror
Gangsta
****
Posts: 536
Threads: 81
Joined: Mar 2017
Reputation: 0
#9

05.01.2018, 13:18
You are PROOO! Thank s a lot! And sorry for my stupid questions, can I send you private messages for MySQL help, because I'm still learning it!

+1 REP!!!
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help