[zT KiNgKoNg]

No errors in the mysql_debug.txt nor in the console.

pawn Код:

stock LoadDynamicHouses()
{
    new str[128], i = 1, lable[100];
    mysql_query("SELECT * FROM `house_data`");
    mysql_store_result();

    if(mysql_num_rows() != 0)
    {
        while(mysql_fetch_row(str))
        {
            sscanf(str, "e<p<|>iiiiiis[30]ffffff>", DynamicHouseData[i]);
            if(DynamicHouseData[i][HouseExists] == 1)
            {
                DynamicHouseData[i][HouseID] = i;

                if(DynamicHouseData[i][HouseOwned] == 0)
                {
                    format(lable,sizeof(lable),"{FFFFFF}[{FFC801}Property{FFFFFF}]\n» Property For Sale: %d",DynamicHouseData[i][HousePrice], DynamicHouseData[i][HouseInterior]);
                    DynamicHouseData[i][HouseLable] = CreateDynamic3DTextLabel(lable, 0xFFFFFF, DynamicHouseData[i][House_X],DynamicHouseData[i][House_Y],DynamicHouseData[i][House_Z], 5.0);
                    DynamicHouseData[i][HousePickup] = CreateDynamicPickup(1273, 1, DynamicHouseData[i][House_X],DynamicHouseData[i][House_Y],DynamicHouseData[i][House_Z],0,0,-1,300.0);
                    format(str,sizeof(str),"Dynamic House Loaded %i Free", i);
                    printc(RED, str);
                }
                else if(DynamicHouseData[i][HouseOwned] == 1)
                {
                    format(str,sizeof(str),"{FFFFFF}[{FFC801}Property{FFFFFF}]\nOwner: %s", DynamicHouseData[i][HouseOwner]);
                    DynamicHouseData[i][HouseLable] = CreateDynamic3DTextLabel(lable, 0xFFFFFF, DynamicHouseData[i][House_X],DynamicHouseData[i][House_Y],DynamicHouseData[i][House_Z], 5.0);
                    DynamicHouseData[i][HousePickup] = CreateDynamicPickup(1272, 1, DynamicHouseData[i][House_X],DynamicHouseData[i][House_Y],DynamicHouseData[i][House_Z],0,0,-1,300.0);
                    format(str,sizeof(str),"Dynamic House Loaded %i (Owned)", i);
                    printc(RED, str);
                }
                i++;
            }
        }
    } else {
        print("There are no houses to load or there is a connection/loading issue");
    }
    return 1;
}

[MrTinder]

try this:

Код:

stock LoadDynamicHouses()
{
    new str[128], i = 1, lable[100];
    mysql_query("SELECT * FROM `house_data`");
    mysql_store_result();

    if(mysql_num_rows() != 0)
    {
        while(mysql_fetch_row(str))
        {
            sscanf(str, "e<p<|>iiiiiis[30]ffffff>", DynamicHouseData[i]);
            if(DynamicHouseData[i][HouseExists] == 1)
            {
                DynamicHouseData[i][HouseID] = i;

                if(DynamicHouseData[i][HouseOwned] == 0)
                {
                    format(lable,sizeof(lable),"{FFFFFF}[{FFC801}Property{FFFFFF}]\n» Property For Sale: %d",DynamicHouseData[i][HousePrice], DynamicHouseData[i][HouseInterior]);
                    DynamicHouseData[i][HouseLable] = CreateDynamic3DTextLabel(lable, 0xFFFFFF, DynamicHouseData[i][House_X],DynamicHouseData[i][House_Y],DynamicHouseData[i][House_Z], 5.0);
                    DynamicHouseData[i][HousePickup] = CreateDynamicPickup(1273, 1, DynamicHouseData[i][House_X],DynamicHouseData[i][House_Y],DynamicHouseData[i][House_Z],0,0,-1,300.0);
                    format(str,sizeof(str),"Dynamic House Loaded %i Free", i);
                    printc(RED, str);
                }
                else if(DynamicHouseData[i][HouseOwned] == 1)
                {
                    format(lable,sizeof(lable),"{FFFFFF}[{FFC801}Property{FFFFFF}]\nOwner: %s", DynamicHouseData[i][HouseOwner]);
                    DynamicHouseData[i][HouseLable] = CreateDynamic3DTextLabel(lable, 0xFFFFFF, DynamicHouseData[i][House_X],DynamicHouseData[i][House_Y],DynamicHouseData[i][House_Z], 5.0);
                    DynamicHouseData[i][HousePickup] = CreateDynamicPickup(1272, 1, DynamicHouseData[i][House_X],DynamicHouseData[i][House_Y],DynamicHouseData[i][House_Z],0,0,-1,300.0);
                    format(str,sizeof(str),"Dynamic House Loaded %i (Owned)", i);
                    printc(RED, str);
                }
                i++;
            }
        }
    } else {
        print("There are no houses to load or there is a connection/loading issue");
    }
    return 1;
}