31.10.2013, 09:00
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;
}