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

Threaded Mode
BlueG MySQL only loading 1 row
seanny
High-roller
*****
Posts: 1,429
Threads: 321
Joined: Oct 2010
Reputation: 0
#1

23.04.2018, 20:57
( Последний раз редактировалось seanny; 25.04.2018 в 13:35. Причина: Solved )
I'm having a problem where BlueG MySQL is only loading data from 1 row but it sees that there is 37 rows.

samp-server.exe:
Код:
House rows = 37
House 1 ID = 1
* 1 houses were loaded from the database.
Code:
PHP код:
public OnGameModeInit()
{
    ....
    mysql_tquery(g_SQL, "SELECT * FROM `houses`", "Query_LoadHouses");
    ....
}
public Query_LoadHouses()
{
    new rows = cache_num_rows();
    if(!rows)
        return print("* No houses were loaded from the database.");
    printf("House rows = %d", rows);
    new countHouses = 0;
    for(new i = 0; i < rows; i++)
    {
        cache_get_value_int(i, "ID", HouseInfo[i+1][HouseID]);
        if(HouseInfo[i+1][HouseID])
        {
            printf("House %d ID = %d", i+1, HouseInfo[i+1][HouseID]);
            cache_get_value_int(i, "OwnerID", HouseInfo[i+1][HouseOwnerID]);
            cache_get_value_int(i, "MarketPrice", HouseInfo[i+1][HouseMarketPrice]);
            cache_get_value_float(i, "ExteriorX", HouseInfo[i+1][HouseExteriorX]);
            cache_get_value_float(i, "ExteriorY", HouseInfo[i+1][HouseExteriorY]);
            cache_get_value_float(i, "ExteriorZ", HouseInfo[i+1][HouseExteriorZ]);
            cache_get_value_float(i, "ExteriorA", HouseInfo[i+1][HouseExteriorA]);
            cache_get_value_int(i, "ExteriorInt", HouseInfo[i+1][HouseExteriorInt]);
            cache_get_value_int(i, "ExteriorVW", HouseInfo[i+1][HouseExteriorVW]);
            cache_get_value_float(i, "InteriorX", HouseInfo[i+1][HouseInteriorX]);
            cache_get_value_float(i, "InteriorY", HouseInfo[i+1][HouseInteriorY]);
            cache_get_value_float(i, "InteriorZ", HouseInfo[i+1][HouseInteriorZ]);
            cache_get_value_float(i, "InteriorA", HouseInfo[i+1][HouseInteriorA]);
            cache_get_value_int(i, "InteriorInt", HouseInfo[i+1][HouseInteriorInt]);
            cache_get_value_int(i, "Locked", HouseInfo[i+1][HouseLocked]);
            cache_get_value_int(i, "CashBox", HouseInfo[i+1][HouseCashBox]);
            // I rrly do not like this code, but having a loop made the compiler cry :(
            cache_get_value_int(i, "Weapons0", HouseInfo[i+1][HouseWeapons][0]);
            cache_get_value_int(i, "Weapons1", HouseInfo[i+1][HouseWeapons][1]);
            cache_get_value_int(i, "Weapons2", HouseInfo[i+1][HouseWeapons][2]);
            cache_get_value_int(i, "Weapons3", HouseInfo[i+1][HouseWeapons][3]);
            cache_get_value_int(i, "Weapons4", HouseInfo[i+1][HouseWeapons][4]);
            cache_get_value_int(i, "Weapons5", HouseInfo[i+1][HouseWeapons][5]);
            cache_get_value_int(i, "Weapons6", HouseInfo[i+1][HouseWeapons][6]);
            cache_get_value_int(i, "Weapons7", HouseInfo[i+1][HouseWeapons][7]);
            cache_get_value_int(i, "Weapons8", HouseInfo[i+1][HouseWeapons][8]);
            cache_get_value_int(i, "Weapons9", HouseInfo[i+1][HouseWeapons][9]);
            cache_get_value_int(i, "Weapons10", HouseInfo[i+1][HouseWeapons][10]);
            cache_get_value_int(i, "Weapons11", HouseInfo[i+1][HouseWeapons][11]);
            cache_get_value_int(i, "Weapons12", HouseInfo[i+1][HouseWeapons][12]);
            cache_get_value_int(i, "Weapons13", HouseInfo[i+1][HouseWeapons][13]);
            cache_get_value_int(i, "Weapons14", HouseInfo[i+1][HouseWeapons][14]);
            cache_get_value_int(i, "Weapons15", HouseInfo[i+1][HouseWeapons][15]);
            cache_get_value_int(i, "Weapons16", HouseInfo[i+1][HouseWeapons][16]);
            cache_get_value_int(i, "Weapons17", HouseInfo[i+1][HouseWeapons][17]);
            cache_get_value_int(i, "Weapons18", HouseInfo[i+1][HouseWeapons][18]);
            cache_get_value_int(i, "Weapons19", HouseInfo[i+1][HouseWeapons][19]);
            cache_get_value_int(i, "Weapons20", HouseInfo[i+1][HouseWeapons][20]);
            // I rrly do not like this code, but having a loop made the compiler cry :(
            cache_get_value_int(i, "WeaponsAmmo0", HouseInfo[i+1][HouseWeaponsAmmo][0]);
            cache_get_value_int(i, "WeaponsAmmo1", HouseInfo[i+1][HouseWeaponsAmmo][1]);
            cache_get_value_int(i, "WeaponsAmmo2", HouseInfo[i+1][HouseWeaponsAmmo][2]);
            cache_get_value_int(i, "WeaponsAmmo3", HouseInfo[i+1][HouseWeaponsAmmo][4]);
            cache_get_value_int(i, "WeaponsAmmo5", HouseInfo[i+1][HouseWeaponsAmmo][5]);
            cache_get_value_int(i, "WeaponsAmmo6", HouseInfo[i+1][HouseWeaponsAmmo][6]);
            cache_get_value_int(i, "WeaponsAmmo7", HouseInfo[i+1][HouseWeaponsAmmo][7]);
            cache_get_value_int(i, "WeaponsAmmo8", HouseInfo[i+1][HouseWeaponsAmmo][8]);
            cache_get_value_int(i, "WeaponsAmmo9", HouseInfo[i+1][HouseWeaponsAmmo][9]);
            cache_get_value_int(i, "WeaponsAmmo10", HouseInfo[i+1][HouseWeaponsAmmo][10]);
            cache_get_value_int(i, "WeaponsAmmo11", HouseInfo[i+1][HouseWeaponsAmmo][11]);
            cache_get_value_int(i, "WeaponsAmmo12", HouseInfo[i+1][HouseWeaponsAmmo][12]);
            cache_get_value_int(i, "WeaponsAmmo13", HouseInfo[i+1][HouseWeaponsAmmo][13]);
            cache_get_value_int(i, "WeaponsAmmo14", HouseInfo[i+1][HouseWeaponsAmmo][14]);
            cache_get_value_int(i, "WeaponsAmmo15", HouseInfo[i+1][HouseWeaponsAmmo][15]);
            cache_get_value_int(i, "WeaponsAmmo16", HouseInfo[i+1][HouseWeaponsAmmo][16]);
            cache_get_value_int(i, "WeaponsAmmo17", HouseInfo[i+1][HouseWeaponsAmmo][17]);
            cache_get_value_int(i, "WeaponsAmmo18", HouseInfo[i+1][HouseWeaponsAmmo][18]);
            cache_get_value_int(i, "WeaponsAmmo19", HouseInfo[i+1][HouseWeaponsAmmo][19]);
            cache_get_value_int(i, "WeaponsAmmo20", HouseInfo[i+1][HouseWeaponsAmmo][20]);
            
            cache_get_value_float(i, "PlacePosX", HouseInfo[i+1][HousePlacePosX]);
            cache_get_value_float(i, "PlacePosY", HouseInfo[i+1][HousePlacePosY]);
            cache_get_value_float(i, "PlacePosZ", HouseInfo[i+1][HousePlacePosZ]);
            cache_get_value_int(i, "Boombox", HouseInfo[i+1][HouseBoombox]);
            cache_get_value_int(i, "RentFee", HouseInfo[i+1][HouseRentFee]);
            cache_get_value_int(i, "Rentable", HouseInfo[i+1][HouseRentable]);
            new query[128];
            mysql_format(g_SQL, query, sizeof query, "SELECT * FROM furniture WHERE HouseID = %d", HouseInfo[i+1][HouseID]);
            mysql_tquery(g_SQL, query, "OnLoadFurniture", "d", i);
            
            if(HouseInfo[i+1][HouseLocked] == 0)
                HouseInfo[i+1][HouseLocked] = 1;
            UpdateHousePickup(i+1);
            countHouses++;
        }
    }
    printf("* %d houses were loaded from the database.", countHouses);
    return 1;
} 
Код:
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
[22:09:01] [ERROR] cache_get_value_name_int: no active cache (./Source/Properties/House.pwn:877)
Find
Reply
AmigaBlizzard
Huge Clucker
****
Posts: 319
Threads: 7
Joined: Jul 2012
Reputation: 0
#2

23.04.2018, 21:05
Try commenting the query to load your furniture and see if that does the trick.

If it now loads all houses, you can be certain that sending the query and calling the OnLoadFurniture callback exitst the house-loading loop by going to the other callback and not returning here.
Then you can fix it by loading all furniture at once after you've finished loading all the houses and looping through the result and store your furniture at each house. You may want to order it all by the HouseID.

If not, then I don't know what the problem might be.
Find
Reply
seanny
High-roller
*****
Posts: 1,429
Threads: 321
Joined: Oct 2010
Reputation: 0
#3

23.04.2018, 21:08
Quote:
Originally Posted by AmigaBlizzard
Посмотреть сообщение
Try commenting the query to load your furniture and see if that does the trick.

If it now loads all houses, you can be certain that sending the query and calling the OnLoadFurniture callback exitst the house-loading loop by going to the other callback and not returning here.
Then you can fix it by loading all furniture at once after you've finished loading all the houses and looping through the result and store your furniture at each house. You may want to order it all by the HouseID.

If not, then I don't know what the problem might be.
I'll try that, but I honestly doubt that's the issue.

EDIT: Nope, just as I suspected, that did nothing.
Find
Reply
Phreak
Little Clucker
**
Posts: 23
Threads: 2
Joined: Apr 2018
Reputation: 0
#4

23.04.2018, 21:09
What error does the mysql log show?
Find
Reply
seanny
High-roller
*****
Posts: 1,429
Threads: 321
Joined: Oct 2010
Reputation: 0
#5

23.04.2018, 21:11
Quote:
Originally Posted by Phreak
Посмотреть сообщение
What error does the mysql log show?
I added the MySQL log.
Find
Reply
Logic_
Banned
Posts: 1,506
Threads: 13
Joined: Jun 2015
#6

24.04.2018, 09:27
There are tons of mistakes in your code!

Why are you adding +1 to the loop ID? The arrays start from 0 not 1 and you should.
PHP код:
HouseInfo[i+1][HouseID]); 
Remove the if statement in the loop. That clearly doesn't makes sense if your house row IDs have auto increment.

SQL is a relational database, make use of foreign keys. Make a separate table dedicated to house weapons!
PHP код:
          cache_get_value_int(i, "Weapons0", HouseInfo[i+1][HouseWeapons][0]); 
            cache_get_value_int(i, "Weapons1", HouseInfo[i+1][HouseWeapons][1]); 
            cache_get_value_int(i, "Weapons2", HouseInfo[i+1][HouseWeapons][2]); 
            cache_get_value_int(i, "Weapons3", HouseInfo[i+1][HouseWeapons][3]); 
            cache_get_value_int(i, "Weapons4", HouseInfo[i+1][HouseWeapons][4]); 
            cache_get_value_int(i, "Weapons5", HouseInfo[i+1][HouseWeapons][5]); 
            cache_get_value_int(i, "Weapons6", HouseInfo[i+1][HouseWeapons][6]); 
            cache_get_value_int(i, "Weapons7", HouseInfo[i+1][HouseWeapons][7]); 
            cache_get_value_int(i, "Weapons8", HouseInfo[i+1][HouseWeapons][8]); 
            cache_get_value_int(i, "Weapons9", HouseInfo[i+1][HouseWeapons][9]); 
            cache_get_value_int(i, "Weapons10", HouseInfo[i+1][HouseWeapons][10]); 
            cache_get_value_int(i, "Weapons11", HouseInfo[i+1][HouseWeapons][11]); 
            cache_get_value_int(i, "Weapons12", HouseInfo[i+1][HouseWeapons][12]); 
            cache_get_value_int(i, "Weapons13", HouseInfo[i+1][HouseWeapons][13]); 
            cache_get_value_int(i, "Weapons14", HouseInfo[i+1][HouseWeapons][14]); 
            cache_get_value_int(i, "Weapons15", HouseInfo[i+1][HouseWeapons][15]); 
            cache_get_value_int(i, "Weapons16", HouseInfo[i+1][HouseWeapons][16]); 
            cache_get_value_int(i, "Weapons17", HouseInfo[i+1][HouseWeapons][17]); 
            cache_get_value_int(i, "Weapons18", HouseInfo[i+1][HouseWeapons][18]); 
            cache_get_value_int(i, "Weapons19", HouseInfo[i+1][HouseWeapons][19]); 
            cache_get_value_int(i, "Weapons20", HouseInfo[i+1][HouseWeapons][20]); 
(( Ewww, Yuck! ))

Just run this query separately once you've loaded all the houses!
PHP код:
            new query[128]; 
            mysql_format(g_SQL, query, sizeof query, "SELECT * FROM furniture WHERE HouseID = %d", HouseInfo[i+1][HouseID]); 
            mysql_tquery(g_SQL, query, "OnLoadFurniture", "d", i); 
becomes
PHP код:
mysql_tquery(g_SQL, "SELECT * FROM furniture", "OnLoadFurnitures"); 
Find
Reply
seanny
High-roller
*****
Posts: 1,429
Threads: 321
Joined: Oct 2010
Reputation: 0
#7

24.04.2018, 15:58
Quote:
Originally Posted by Logic_
Посмотреть сообщение
There are tons of mistakes in your code!

Why are you adding +1 to the loop ID? The arrays start from 0 not 1 and you should.
PHP код:
HouseInfo[i+1][HouseID]); 
Remove the if statement in the loop. That clearly doesn't makes sense if your house row IDs have auto increment.

SQL is a relational database, make use of foreign keys. Make a separate table dedicated to house weapons!
PHP код:
          cache_get_value_int(i, "Weapons0", HouseInfo[i+1][HouseWeapons][0]); 
            cache_get_value_int(i, "Weapons1", HouseInfo[i+1][HouseWeapons][1]); 
            cache_get_value_int(i, "Weapons2", HouseInfo[i+1][HouseWeapons][2]); 
            cache_get_value_int(i, "Weapons3", HouseInfo[i+1][HouseWeapons][3]); 
            cache_get_value_int(i, "Weapons4", HouseInfo[i+1][HouseWeapons][4]); 
            cache_get_value_int(i, "Weapons5", HouseInfo[i+1][HouseWeapons][5]); 
            cache_get_value_int(i, "Weapons6", HouseInfo[i+1][HouseWeapons][6]); 
            cache_get_value_int(i, "Weapons7", HouseInfo[i+1][HouseWeapons][7]); 
            cache_get_value_int(i, "Weapons8", HouseInfo[i+1][HouseWeapons][8]); 
            cache_get_value_int(i, "Weapons9", HouseInfo[i+1][HouseWeapons][9]); 
            cache_get_value_int(i, "Weapons10", HouseInfo[i+1][HouseWeapons][10]); 
            cache_get_value_int(i, "Weapons11", HouseInfo[i+1][HouseWeapons][11]); 
            cache_get_value_int(i, "Weapons12", HouseInfo[i+1][HouseWeapons][12]); 
            cache_get_value_int(i, "Weapons13", HouseInfo[i+1][HouseWeapons][13]); 
            cache_get_value_int(i, "Weapons14", HouseInfo[i+1][HouseWeapons][14]); 
            cache_get_value_int(i, "Weapons15", HouseInfo[i+1][HouseWeapons][15]); 
            cache_get_value_int(i, "Weapons16", HouseInfo[i+1][HouseWeapons][16]); 
            cache_get_value_int(i, "Weapons17", HouseInfo[i+1][HouseWeapons][17]); 
            cache_get_value_int(i, "Weapons18", HouseInfo[i+1][HouseWeapons][18]); 
            cache_get_value_int(i, "Weapons19", HouseInfo[i+1][HouseWeapons][19]); 
            cache_get_value_int(i, "Weapons20", HouseInfo[i+1][HouseWeapons][20]); 
(( Ewww, Yuck! ))

Just run this query separately once you've loaded all the houses!
PHP код:
            new query[128]; 
            mysql_format(g_SQL, query, sizeof query, "SELECT * FROM furniture WHERE HouseID = %d", HouseInfo[i+1][HouseID]); 
            mysql_tquery(g_SQL, query, "OnLoadFurniture", "d", i); 
becomes
PHP код:
mysql_tquery(g_SQL, "SELECT * FROM furniture", "OnLoadFurnitures"); 
That doesn't fix the issue at all, I'm still getting the same result as before. I have changed the code accordingly though.
Find
Reply
UFF
Banned
Posts: 357
Threads: 6
Joined: Feb 2018
#8

24.04.2018, 16:47
Код:
public OnGameModeInit()
{
    ....
    mysql_tquery(g_SQL, "SELECT * FROM houses", "Query_LoadHouses", "");
    ....
}

public Query_LoadHouses()
{
    new rows = cache_num_rows();
    mysql_store_result();
    if(rows)
  	{
    for(new i; i < rows; i++)
    {
            new h;
            h = cache_get_field_content_int(i, "ID");
            cache_get_field_content(i, "OwnerID", HouseInfo[h][HouseOwnerID]);
            HouseInfo[h][HouseMarketPrice] = cache_get_field_content_int(i, "hpass");
            HouseInfo[h][HouseExteriorX] = cache_get_field_content_float(i, "ExteriorX");
            HouseInfo[h][HouseExteriorY] = cache_get_field_content_float(i, "ExteriorY");
            HouseInfo[h][HouseExteriorZ] = cache_get_field_content_float(i, "ExteriorZ");
            HouseInfo[h][HouseExteriorA] = cache_get_field_content_float(i, "ExteriorA");
            HouseInfo[h][HouseExteriorInt] = cache_get_field_content_int(i, "ExteriorInt")
            HouseInfo[h][HouseExteriorVW] = cache_get_field_content_int(i, "ExteriorVW")
            HouseInfo[h][HouseInteriorX] = cache_get_field_content_float(i, "InteriorX");
            HouseInfo[h][HouseInteriorY] = cache_get_field_content_float(i, "InteriorY");
            HouseInfo[h][HouseInteriorZ] = cache_get_field_content_float(i, "InteriorZ");
            HouseInfo[h][HouseInteriorA] = cache_get_field_content_float(i, "InteriorA");
            HouseInfo[h][HouseInteriorInt] = cache_get_field_content_int(i, "InteriorInt");
            HouseInfo[h][HouseLocked] = cache_get_field_content_int(i, "Locked");
            HouseInfo[h][HouseCashBox] = cache_get_field_content_int(i, "CashBox");

            // I rrly do not like this code, but having a loop made the compiler cry :(
            cache_get_value_int(i, "Weapons0", HouseInfo[h][HouseWeapons][0]);
            cache_get_value_int(i, "Weapons1", HouseInfo[h][HouseWeapons][1]);
            cache_get_value_int(i, "Weapons2", HouseInfo[h][HouseWeapons][2]);
            cache_get_value_int(i, "Weapons3", HouseInfo[h][HouseWeapons][3]);
            cache_get_value_int(i, "Weapons4", HouseInfo[h][HouseWeapons][4]);
            cache_get_value_int(i, "Weapons5", HouseInfo[h][HouseWeapons][5]);
            cache_get_value_int(i, "Weapons6", HouseInfo[h][HouseWeapons][6]);
            cache_get_value_int(i, "Weapons7", HouseInfo[h][HouseWeapons][7]);
            cache_get_value_int(i, "Weapons8", HouseInfo[h][HouseWeapons][8]);
            cache_get_value_int(i, "Weapons9", HouseInfo[h][HouseWeapons][9]);
            cache_get_value_int(i, "Weapons10", HouseInfo[h][HouseWeapons][10]);
            cache_get_value_int(i, "Weapons11", HouseInfo[h][HouseWeapons][11]);
            cache_get_value_int(i, "Weapons12", HouseInfo[h][HouseWeapons][12]);
            cache_get_value_int(i, "Weapons13", HouseInfo[h][HouseWeapons][13]);
            cache_get_value_int(i, "Weapons14", HouseInfo[h][HouseWeapons][14]);
            cache_get_value_int(i, "Weapons15", HouseInfo[h][HouseWeapons][15]);
            cache_get_value_int(i, "Weapons16", HouseInfo[h][HouseWeapons][16]);
            cache_get_value_int(i, "Weapons17", HouseInfo[h][HouseWeapons][17]);
            cache_get_value_int(i, "Weapons18", HouseInfo[h][HouseWeapons][18]);
            cache_get_value_int(i, "Weapons19", HouseInfo[h][HouseWeapons][19]);
            cache_get_value_int(i, "Weapons20", HouseInfo[h][HouseWeapons][20]);

            // I rrly do not like this code, but having a loop made the compiler cry :(
            cache_get_value_int(i, "WeaponsAmmo0", HouseInfo[h][HouseWeaponsAmmo][0]);
            cache_get_value_int(i, "WeaponsAmmo1", HouseInfo[h][HouseWeaponsAmmo][1]);
            cache_get_value_int(i, "WeaponsAmmo2", HouseInfo[h][HouseWeaponsAmmo][2]);
            cache_get_value_int(i, "WeaponsAmmo3", HouseInfo[h][HouseWeaponsAmmo][4]);
            cache_get_value_int(i, "WeaponsAmmo5", HouseInfo[h][HouseWeaponsAmmo][5]);
            cache_get_value_int(i, "WeaponsAmmo6", HouseInfo[h][HouseWeaponsAmmo][6]);
            cache_get_value_int(i, "WeaponsAmmo7", HouseInfo[h][HouseWeaponsAmmo][7]);
            cache_get_value_int(i, "WeaponsAmmo8", HouseInfo[h][HouseWeaponsAmmo][8]);
            cache_get_value_int(i, "WeaponsAmmo9", HouseInfo[h][HouseWeaponsAmmo][9]);
            cache_get_value_int(i, "WeaponsAmmo10", HouseInfo[h][HouseWeaponsAmmo][10]);
            cache_get_value_int(i, "WeaponsAmmo11", HouseInfo[h][HouseWeaponsAmmo][11]);
            cache_get_value_int(i, "WeaponsAmmo12", HouseInfo[h][HouseWeaponsAmmo][12]);
            cache_get_value_int(i, "WeaponsAmmo13", HouseInfo[h][HouseWeaponsAmmo][13]);
            cache_get_value_int(i, "WeaponsAmmo14", HouseInfo[h][HouseWeaponsAmmo][14]);
            cache_get_value_int(i, "WeaponsAmmo15", HouseInfo[h][HouseWeaponsAmmo][15]);
            cache_get_value_int(i, "WeaponsAmmo16", HouseInfo[h][HouseWeaponsAmmo][16]);
            cache_get_value_int(i, "WeaponsAmmo17", HouseInfo[h][HouseWeaponsAmmo][17]);
            cache_get_value_int(i, "WeaponsAmmo18", HouseInfo[h][HouseWeaponsAmmo][18]);
            cache_get_value_int(i, "WeaponsAmmo19", HouseInfo[h][HouseWeaponsAmmo][19]);
            cache_get_value_int(i, "WeaponsAmmo20", HouseInfo[h][HouseWeaponsAmmo][20]);

            cache_get_value_float(i, "PlacePosX", HouseInfo[h][HousePlacePosX]);
            cache_get_value_float(i, "PlacePosY", HouseInfo[h][HousePlacePosY]);
            cache_get_value_float(i, "PlacePosZ", HouseInfo[h][HousePlacePosZ]);

            cache_get_value_int(i, "Boombox", HouseInfo[h][HouseBoombox]);
            cache_get_value_int(i, "RentFee", HouseInfo[h][HouseRentFee]);
            cache_get_value_int(i, "Rentable", HouseInfo[h][HouseRentable]);

            new query[128];
            mysql_format(g_SQL, query, sizeof query, "SELECT * FROM furniture WHERE HouseID = %d", HouseInfo[h][HouseID]);
            mysql_tquery(g_SQL, query, "OnLoadFurniture", "d", h);

            if(HouseInfo[h][HouseLocked] == 0)
                HouseInfo[h][HouseLocked] = 1;

            UpdateHousePickup(h);
            h++;
        }
    }
    mysql_free_result();
    printf("* %d houses were loaded from the database.", rows);
    return 1;
}
try this
Find
Reply
seanny
High-roller
*****
Posts: 1,429
Threads: 321
Joined: Oct 2010
Reputation: 0
#9

24.04.2018, 17:11
Quote:
Originally Posted by UFF
Посмотреть сообщение
Код:
public OnGameModeInit()
{
    ....
    mysql_tquery(g_SQL, "SELECT * FROM houses", "Query_LoadHouses", "");
    ....
}

public Query_LoadHouses()
{
    new rows = cache_num_rows();
    mysql_store_result();
    if(rows)
  	{
    for(new i; i < rows; i++)
    {
            new h;
            h = cache_get_field_content_int(i, "ID");
            cache_get_field_content(i, "OwnerID", HouseInfo[h][HouseOwnerID]);
            HouseInfo[h][HouseMarketPrice] = cache_get_field_content_int(i, "hpass");
            HouseInfo[h][HouseExteriorX] = cache_get_field_content_float(i, "ExteriorX");
            HouseInfo[h][HouseExteriorY] = cache_get_field_content_float(i, "ExteriorY");
            HouseInfo[h][HouseExteriorZ] = cache_get_field_content_float(i, "ExteriorZ");
            HouseInfo[h][HouseExteriorA] = cache_get_field_content_float(i, "ExteriorA");
            HouseInfo[h][HouseExteriorInt] = cache_get_field_content_int(i, "ExteriorInt")
            HouseInfo[h][HouseExteriorVW] = cache_get_field_content_int(i, "ExteriorVW")
            HouseInfo[h][HouseInteriorX] = cache_get_field_content_float(i, "InteriorX");
            HouseInfo[h][HouseInteriorY] = cache_get_field_content_float(i, "InteriorY");
            HouseInfo[h][HouseInteriorZ] = cache_get_field_content_float(i, "InteriorZ");
            HouseInfo[h][HouseInteriorA] = cache_get_field_content_float(i, "InteriorA");
            HouseInfo[h][HouseInteriorInt] = cache_get_field_content_int(i, "InteriorInt");
            HouseInfo[h][HouseLocked] = cache_get_field_content_int(i, "Locked");
            HouseInfo[h][HouseCashBox] = cache_get_field_content_int(i, "CashBox");

            // I rrly do not like this code, but having a loop made the compiler cry :(
            cache_get_value_int(i, "Weapons0", HouseInfo[h][HouseWeapons][0]);
            cache_get_value_int(i, "Weapons1", HouseInfo[h][HouseWeapons][1]);
            cache_get_value_int(i, "Weapons2", HouseInfo[h][HouseWeapons][2]);
            cache_get_value_int(i, "Weapons3", HouseInfo[h][HouseWeapons][3]);
            cache_get_value_int(i, "Weapons4", HouseInfo[h][HouseWeapons][4]);
            cache_get_value_int(i, "Weapons5", HouseInfo[h][HouseWeapons][5]);
            cache_get_value_int(i, "Weapons6", HouseInfo[h][HouseWeapons][6]);
            cache_get_value_int(i, "Weapons7", HouseInfo[h][HouseWeapons][7]);
            cache_get_value_int(i, "Weapons8", HouseInfo[h][HouseWeapons][8]);
            cache_get_value_int(i, "Weapons9", HouseInfo[h][HouseWeapons][9]);
            cache_get_value_int(i, "Weapons10", HouseInfo[h][HouseWeapons][10]);
            cache_get_value_int(i, "Weapons11", HouseInfo[h][HouseWeapons][11]);
            cache_get_value_int(i, "Weapons12", HouseInfo[h][HouseWeapons][12]);
            cache_get_value_int(i, "Weapons13", HouseInfo[h][HouseWeapons][13]);
            cache_get_value_int(i, "Weapons14", HouseInfo[h][HouseWeapons][14]);
            cache_get_value_int(i, "Weapons15", HouseInfo[h][HouseWeapons][15]);
            cache_get_value_int(i, "Weapons16", HouseInfo[h][HouseWeapons][16]);
            cache_get_value_int(i, "Weapons17", HouseInfo[h][HouseWeapons][17]);
            cache_get_value_int(i, "Weapons18", HouseInfo[h][HouseWeapons][18]);
            cache_get_value_int(i, "Weapons19", HouseInfo[h][HouseWeapons][19]);
            cache_get_value_int(i, "Weapons20", HouseInfo[h][HouseWeapons][20]);

            // I rrly do not like this code, but having a loop made the compiler cry :(
            cache_get_value_int(i, "WeaponsAmmo0", HouseInfo[h][HouseWeaponsAmmo][0]);
            cache_get_value_int(i, "WeaponsAmmo1", HouseInfo[h][HouseWeaponsAmmo][1]);
            cache_get_value_int(i, "WeaponsAmmo2", HouseInfo[h][HouseWeaponsAmmo][2]);
            cache_get_value_int(i, "WeaponsAmmo3", HouseInfo[h][HouseWeaponsAmmo][4]);
            cache_get_value_int(i, "WeaponsAmmo5", HouseInfo[h][HouseWeaponsAmmo][5]);
            cache_get_value_int(i, "WeaponsAmmo6", HouseInfo[h][HouseWeaponsAmmo][6]);
            cache_get_value_int(i, "WeaponsAmmo7", HouseInfo[h][HouseWeaponsAmmo][7]);
            cache_get_value_int(i, "WeaponsAmmo8", HouseInfo[h][HouseWeaponsAmmo][8]);
            cache_get_value_int(i, "WeaponsAmmo9", HouseInfo[h][HouseWeaponsAmmo][9]);
            cache_get_value_int(i, "WeaponsAmmo10", HouseInfo[h][HouseWeaponsAmmo][10]);
            cache_get_value_int(i, "WeaponsAmmo11", HouseInfo[h][HouseWeaponsAmmo][11]);
            cache_get_value_int(i, "WeaponsAmmo12", HouseInfo[h][HouseWeaponsAmmo][12]);
            cache_get_value_int(i, "WeaponsAmmo13", HouseInfo[h][HouseWeaponsAmmo][13]);
            cache_get_value_int(i, "WeaponsAmmo14", HouseInfo[h][HouseWeaponsAmmo][14]);
            cache_get_value_int(i, "WeaponsAmmo15", HouseInfo[h][HouseWeaponsAmmo][15]);
            cache_get_value_int(i, "WeaponsAmmo16", HouseInfo[h][HouseWeaponsAmmo][16]);
            cache_get_value_int(i, "WeaponsAmmo17", HouseInfo[h][HouseWeaponsAmmo][17]);
            cache_get_value_int(i, "WeaponsAmmo18", HouseInfo[h][HouseWeaponsAmmo][18]);
            cache_get_value_int(i, "WeaponsAmmo19", HouseInfo[h][HouseWeaponsAmmo][19]);
            cache_get_value_int(i, "WeaponsAmmo20", HouseInfo[h][HouseWeaponsAmmo][20]);

            cache_get_value_float(i, "PlacePosX", HouseInfo[h][HousePlacePosX]);
            cache_get_value_float(i, "PlacePosY", HouseInfo[h][HousePlacePosY]);
            cache_get_value_float(i, "PlacePosZ", HouseInfo[h][HousePlacePosZ]);

            cache_get_value_int(i, "Boombox", HouseInfo[h][HouseBoombox]);
            cache_get_value_int(i, "RentFee", HouseInfo[h][HouseRentFee]);
            cache_get_value_int(i, "Rentable", HouseInfo[h][HouseRentable]);

            new query[128];
            mysql_format(g_SQL, query, sizeof query, "SELECT * FROM furniture WHERE HouseID = %d", HouseInfo[h][HouseID]);
            mysql_tquery(g_SQL, query, "OnLoadFurniture", "d", h);

            if(HouseInfo[h][HouseLocked] == 0)
                HouseInfo[h][HouseLocked] = 1;

            UpdateHousePickup(h);
            h++;
        }
    }
    mysql_free_result();
    printf("* %d houses were loaded from the database.", rows);
    return 1;
}
try this
That will not work, I'm using R40-4, you're using an the API of an older (incompaitable) version of MySQL.
Find
Reply
Phreak
Little Clucker
**
Posts: 23
Threads: 2
Joined: Apr 2018
Reputation: 0
#10

24.04.2018, 17:28
Can you show us which line is this? ./Source/Properties/House.pwn:877

Also, try placing countHouses++ outside the if statement and see if the number of houses changes.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


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