Still don't work
LoadHouse CODE
Код:
forward LoadHouses();
public LoadHouses()
{
new arrCoords[28][64];
new sql[80], row[512];
format(sql, sizeof(sql), "SELECT COUNT(*) FROM Houses");
mysql_query(sql);
mysql_store_result();
mysql_fetch_row(row);
mysql_free_result();
for (new idx=0; idx<MAX_HOUSES; idx++)
{
format(sql, sizeof(sql), "SELECT * FROM Houses WHERE HouseID=%d", idx);
mysql_query(sql);
mysql_store_result();
if (mysql_num_rows() > 0)
{
mysql_fetch_row(row);
split(row, arrCoords, '|');
mysql_free_result();
Houses[idx][EnterX] = floatstr(arrCoords[1]);
Houses[idx][EnterY] = floatstr(arrCoords[2]);
Houses[idx][EnterZ] = floatstr(arrCoords[3]);
Houses[idx][EnterAngle] = floatstr(arrCoords[4]);
Houses[idx][ExitX] = floatstr(arrCoords[5]);
Houses[idx][ExitY] = floatstr(arrCoords[6]);
Houses[idx][ExitZ] = floatstr(arrCoords[7]);
strmid(Houses[idx][Owner], arrCoords[8], 0, strlen(arrCoords[8]), 255);
Houses[idx][Owned] = strval(arrCoords[9]);
Houses[idx][HousePrice] = strval(arrCoords[10]);
Houses[idx][ExitInterior] = strval(arrCoords[11]);
Houses[idx][hGun1] = strval(arrCoords[12]);
Houses[idx][hGunAmmo1] = strval(arrCoords[13]);
Houses[idx][hGun2] = strval(arrCoords[14]);
Houses[idx][hGunAmmo2] = strval(arrCoords[15]);
Houses[idx][hGun3] = strval(arrCoords[16]);
Houses[idx][hGunAmmo3] = strval(arrCoords[17]);
Houses[idx][Money] = strval(arrCoords[18]);
Houses[idx][Rentable] = strval(arrCoords[19]);
Houses[idx][RentCost] = strval(arrCoords[20]);
Houses[idx][PickupID] = strval(arrCoords[21]);
Houses[idx][hFridge] = strval(arrCoords[22]);
Houses[idx][hBox] = strval(arrCoords[23]);
Houses[idx][Drugs] = strval(arrCoords[24]);
Houses[idx][Dynamic] = strval(arrCoords[25]);
Houses[idx][Materials] = strval(arrCoords[26]);
Houses[idx][Locked] = strval(arrCoords[27]);
Houses[idx][PickupID] = CreateDynamicCP(Houses[idx][EnterX], Houses[idx][EnterY], Houses[idx][EnterZ], 1.4, -1, -1, -1, 1.4);
Streamer_SetIntData(STREAMER_TYPE_CP, Houses[idx][PickupID], E_STREAMER_EXTRA_ID, MAX_HOUSES + idx);
new string[128];
if(Houses[idx][Owned] == 0)
{
new houselocation[MAX_ZONE_NAME];
GetCoords2DZone(Houses[idx][EnterX],Houses[idx][EnterY], houselocation, MAX_ZONE_NAME);
format(string, sizeof(string), "[For Sale]\nAddress: %d %s\nPrice: %d$",idx,houselocation,Houses[idx][HousePrice]);
housetext2[idx] = Create3DTextLabel(string,COLOR_BLACK,Houses[idx][EnterX],Houses[idx][EnterY],Houses[idx][EnterZ],5.0,0, 0);
format(string, sizeof(string), "[For Sale]\nAddress: %d %s\nPrice: %d$",idx,houselocation,Houses[idx][HousePrice]);
housetext[idx] = Create3DTextLabel(string,0xbec339ff,Houses[idx][EnterX],Houses[idx][EnterY],Houses[idx][EnterZ],5.0,0, 0);
}
}
}
mysql_free_result();
printf("%d house load from databse", MAX_HOUSES);
return true;
}
OnPlayerEnterDynamicCP
Код:
public OnPlayerEnterDynamicCP(playerid, checkpointid)
{
if(GetPlayerState(playerid) == PLAYER_STATE_ONFOOT)
{
new house_index = Streamer_GetIntData(STREAMER_TYPE_CP, checkpoint, E_STREAMER_EXTRA_ID);
if (house_index >= MAX_HOUSES)
{
house_index -= MAX_HOUSES;
if (Houses[house_index][HousePrice])
{
if (!Houses[house_index][Owned])
{
SendClientMessage(playerid, COLOR_GREEN, "Do you want to buy this house?");
new string[20];
format(string, sizeof(string), "Price: $%d", Houses[house_index][HousePrice]);
SendClientMessage(playerid, COLOR_GREEN, string);
SendClientMessage(playerid, COLOR_WHITE, "Available commands: /buyhouse, /enter, /ds(hout)");
}
else
{
new string[70];
if (Houses[house_index][Rentable])
{
format(string, sizeof(string), "[Adress: %d] You're standing on %s's porch.", house_index, Houses[house_index][Owner]);
SendClientMessage(playerid, COLOR_GREEN, string);
format(string, sizeof(string), "Available commands: /enter, /ds(hout), /rentroom (Price: $%d)", Houses[house_index][RentCost]);
SendClientMessage(playerid, COLOR_WHITE, string);
}
else
{
format(string, sizeof(string), "[Adress: %d] You're standing on %s's porch", house_index, Houses[house_index][Owner]);
SendClientMessage(playerid, COLOR_GREEN, string);
SendClientMessage(playerid, COLOR_WHITE, "Available commands: /enter, /ds(hout)");
}
}
}
}
}
return 1;
}
I think is problem with checkpoint ..
