01.11.2014, 01:41
hello guys . my function of loading houses from db doesnt work , ingame i doesnt see the pickup house on player name(Houseowner) and i cant even see nothing all i see when im doing /findhouse he is telling me you have 2 houes but in BleuBerry Acres !! that's a bug , because i dont even own a house yet , i own one it needs to load from the database ...
PHP код:
if(strcmp(cmd, "/findhouse", true) == 0)
{
new house = PlayerInfo[playerid][pHouseKey];
new house_2 = PlayerInfo[playerid][pHouseKey2];
new house_3 = PlayerInfo[playerid][pHouseKey3];
new house_4 = PlayerInfo[playerid][pHouseKey4];
if(house == -1 && house_2 == -1 && house_2 == -3 && house_4 == -1) return SendClientMessage(playerid, GREY, " You don't own a house.");
tmp = strtok(cmdtext, idx);
if(!strlen(tmp))
{
SyntaxMessage(playerid, "/findhouse [1/2/3/4]");
return 1;
}
new slot = strval(tmp);
new location[28];
if (slot < 1 || slot > 2) return SendClientMessage(playerid, GREY, "Slot can't be below 1, or above 2.");
if (slot == 1)
{
if (PlayerInfo[playerid][pHouseKey] == -1) return SendClientMessage(playerid, GREY, " You don't own a house in that slot.");
SetPlayerCheckpoint(playerid, HouseInfo[house][HouseEnterX], HouseInfo[house][HouseEnterY], HouseInfo[house][HouseEnterZ], 10.0);
SetPVarInt(playerid, "findingspace", 1);
Get2DZone(location, 28, HouseInfo[house][HouseEnterX], HouseInfo[house][HouseEnterY], HouseInfo[house][HouseEnterZ]);
format(string, sizeof(string), "Your house is in {FFFFFF}%s.", location);
SendClientMessage(playerid, YELLOW, string);
}
if (slot == 2)
{
if (PlayerInfo[playerid][pHouseKey2] == -1) return SendClientMessage(playerid, GREY, " You don't own a house in that slot.");
SetPlayerCheckpoint(playerid, HouseInfo[house_2][HouseEnterX], HouseInfo[house_2][HouseEnterY], HouseInfo[house_2][HouseEnterZ], 10.0);
SetPVarInt(playerid, "findingspace", 1);
Get2DZone(location, 28, HouseInfo[house_2][HouseEnterX], HouseInfo[house_2][HouseEnterY], HouseInfo[house_2][HouseEnterZ]);
format(string, sizeof(string), "Your house is in {FFFFFF}%s.", location);
SendClientMessage(playerid, YELLOW, string);
}
if (slot == 3)
{
if (PlayerInfo[playerid][pHouseKey3] == -1) return SendClientMessage(playerid, GREY, " You don't own a house in that slot.");
SetPlayerCheckpoint(playerid, HouseInfo[house_3][HouseEnterX], HouseInfo[house_3][HouseEnterY], HouseInfo[house_3][HouseEnterZ], 10.0);
SetPVarInt(playerid, "findingspace", 1);
Get2DZone(location, 28, HouseInfo[house_3][HouseEnterX], HouseInfo[house_3][HouseEnterY], HouseInfo[house_3][HouseEnterZ]);
format(string, sizeof(string), "Your house is in {FFFFFF}%s.", location);
SendClientMessage(playerid, YELLOW, string);
}
if (slot == 4)
{
if (PlayerInfo[playerid][pHouseKey4] == -1) return SendClientMessage(playerid, GREY, " You don't own a house in that slot.");
SetPlayerCheckpoint(playerid, HouseInfo[house_4][HouseEnterX], HouseInfo[house_4][HouseEnterY], HouseInfo[house_4][HouseEnterZ], 10.0);
SetPVarInt(playerid, "findingspace", 1);
Get2DZone(location, 28, HouseInfo[house_4][HouseEnterX], HouseInfo[house_4][HouseEnterY], HouseInfo[house_4][HouseEnterZ]);
format(string, sizeof(string), "Your house is in {FFFFFF}%s.", location);
SendClientMessage(playerid, YELLOW, string);
}
return 1;
}
PHP код:
LoadHouses()
{
new string[256];
new arrCoords[33][64];
new strFromFile2[260];
new houseQuery[500], DBResult: resulthouse, houseplayername[MAX_PLAYER_NAME], HouseInfo1[256];
new HouseInfo2[256];
new HouseInfo3[256];
new HouseInfo4[256];
new HouseInfo5[256];
new HouseInfo6[256];
new HouseInfo7[256];
new HouseInfo8[256];
new HouseInfo9[256];
new HouseInfo10[256];
new HouseInfo11[256];
new HouseInfo12[256];
new HouseInfo13[256];
new HouseInfo14[256];
new HouseInfo15[256];
new HouseInfo16[256];
new HouseInfo17[256];
new HouseInfo18[256];
new HouseInfo19[256];
new HouseInfo20[256];
new HouseInfo21[256];
new HouseInfo22[256];
new HouseInfo23[256];
new HouseInfo24[256];
new HouseInfo25[256];
new HouseInfo26[256];
new HouseInfo27[256];
new HouseInfo28[256];
new HouseInfo29[256];
new HouseInfo30[256];
new HouseInfo31[256];
new HouseInfo32[256];
new HouseInfo33[256];
new idx;
while (idx < sizeof(HouseInfo))
{
GetPlayerName(playerid, houseplayername, MAX_PLAYER_NAME);
format(houseQuery, sizeof(houseQuery), "select * from `Houses` where `HouseOwner` = '%s'", houseplayername);
resulthouse = db_query(AccountDB, houseQuery);
db_get_field(resulthouse, "HouseIDTaken", HouseInfo1, sizeof(HouseInfo1));
db_get_field(resulthouse, "HouseOwned", HouseInfo2, sizeof(HouseInfo2));
db_get_field(resulthouse, "HousePrice", HouseInfo3, sizeof(HouseInfo3));
db_get_field(resulthouse, "HouseVirtual", HouseInfo4, sizeof(HouseInfo4));
db_get_field(resulthouse, "HouseEnterX", HouseInfo5, sizeof(HouseInfo5));
db_get_field(resulthouse, "HouseEnterY", HouseInfo6, sizeof(HouseInfo6));
db_get_field(resulthouse, "HouseEnterZ", HouseInfo7, sizeof(HouseInfo7));
db_get_field(resulthouse, "HouseInsideX", HouseInfo8, sizeof(HouseInfo8));
db_get_field(resulthouse, "HouseInsideY", HouseInfo9, sizeof(HouseInfo9));
db_get_field(resulthouse, "HouseInsideZ", HouseInfo10, sizeof(HouseInfo10));
db_get_field(resulthouse, "HouseInsideA", HouseInfo11, sizeof(HouseInfo11));
db_get_field(resulthouse, "HouseInterior", HouseInfo12, sizeof(HouseInfo12));
db_get_field(resulthouse, "HouseType", HouseInfo13, sizeof(HouseInfo13));
db_get_field(resulthouse, "HouseOwner", HouseInfo14, sizeof(HouseInfo14));
db_get_field(resulthouse, "HouseSafe", HouseInfo15, sizeof(HouseInfo15));
db_get_field(resulthouse, "HouseLock", HouseInfo16, sizeof(HouseInfo16));
db_get_field(resulthouse, "HouseSafeX", HouseInfo17, sizeof(HouseInfo17));
db_get_field(resulthouse, "HouseSafeY", HouseInfo18, sizeof(HouseInfo18));
db_get_field(resulthouse, "HouseSafeZ", HouseInfo19, sizeof(HouseInfo19));
db_get_field(resulthouse, "HouseCash", HouseInfo20, sizeof(HouseInfo20));
db_get_field(resulthouse, "HouseMats", HouseInfo21, sizeof(HouseInfo21));
db_get_field(resulthouse, "HouseWeed", HouseInfo22, sizeof(HouseInfo22));
db_get_field(resulthouse, "HouseCocaine", HouseInfo23, sizeof(HouseInfo23));
db_get_field(resulthouse, "HouseGun1", HouseInfo24, sizeof(HouseInfo24));
db_get_field(resulthouse, "HouseGun2", HouseInfo25, sizeof(HouseInfo25));
db_get_field(resulthouse, "HouseGun3", HouseInfo26, sizeof(HouseInfo26));
db_get_field(resulthouse, "HouseGun4", HouseInfo27, sizeof(HouseInfo27));
db_get_field(resulthouse, "HouseSafeCode", HouseInfo28, sizeof(HouseInfo28));
db_get_field(resulthouse, "HouseExitVW", HouseInfo29, sizeof(HouseInfo29));
db_get_field(resulthouse, "HouseExitInt", HouseInfo30, sizeof(HouseInfo30));
db_get_field(resulthouse, "HouseMeth", HouseInfo31, sizeof(HouseInfo31));
db_get_field(resulthouse, "HouseHeroin", HouseInfo32, sizeof(HouseInfo32));
db_get_field(resulthouse, "HouseWait", HouseInfo33, sizeof(HouseInfo33));
HouseInfo[idx][HouseIDTaken] = HouseInfo1;
HouseInfo[idx][HouseOwned] = HouseInfo2;
HouseInfo[idx][HousePrice] = HouseInfo3;
HouseInfo[idx][HouseVirtual] = HouseInfo4;
HouseInfo[idx][HouseEnterX] = HouseInfo5;
HouseInfo[idx][HouseEnterY] = HouseInfo6;
HouseInfo[idx][HouseEnterZ] = HouseInfo7;
HouseInfo[idx][HouseInsideX] = HouseInfo8;
HouseInfo[idx][HouseInsideY] = HouseInfo9;
HouseInfo[idx][HouseInsideZ] = HouseInfo10;
HouseInfo[idx][HouseInsideA] = HouseInfo11;
HouseInfo[idx][HouseInterior] = HouseInfo12;
HouseInfo[idx][HouseType] = HouseInfo13;
HouseInfo[idx][HouseOwner] = HouseInfo14;
HouseInfo[idx][HouseSafe] = HouseInfo15;
HouseInfo[idx][HouseLock] = HouseInfo16;
HouseInfo[idx][HouseSafeX] = HouseInfo17;
HouseInfo[idx][HouseSafeY] = HouseInfo18;
HouseInfo[idx][HouseSafeZ] = HouseInfo19;
HouseInfo[idx][HouseCash] = HouseInfo20;
HouseInfo[idx][HouseMats] = HouseInfo21;
HouseInfo[idx][HouseWeed] = HouseInfo22;
HouseInfo[idx][HouseCocaine] = HouseInfo23;
HouseInfo[idx][HouseGun1] = HouseInfo24;
HouseInfo[idx][HouseGun2] = HouseInfo25;
HouseInfo[idx][HouseGun3] = HouseInfo26;
HouseInfo[idx][HouseGun4] = HouseInfo27;
HouseInfo[idx][HouseSafeCode] = HouseInfo28;
HouseInfo[idx][HouseExitVW] = HouseInfo29;
HouseInfo[idx][HouseExitInt] = HouseInfo30;
HouseInfo[idx][HouseMeth] = HouseInfo31;
HouseInfo[idx][HouseHeroin] = HouseInfo32;
HouseInfo[idx][HouseWait] = HouseInfo33;
new location[MAX_ZONE_NAME];
HouseInfo[idx][HousePickup] = CreateDynamicPickup(1273, 23, HouseInfo[idx][HouseEnterX], HouseInfo[idx][HouseEnterY], HouseInfo[idx][HouseEnterZ]);
Get2DZone(location, MAX_ZONE_NAME, HouseInfo[idx][HouseEnterX], HouseInfo[idx][HouseEnterY], HouseInfo[idx][HouseEnterZ]);
format(string, sizeof(string), "House Owner: {FFFFFF}%s\n"HOUSE_HEX"House Location: {FFFFFF}%s\n"HOUSE_HEX"House Interior: {FFFFFF}%s\n"HOUSE_HEX"House Cost: {FFFFFF}$%d", HouseInfo[idx][HouseOwner], location, HouseInfo[idx][HouseType], HouseInfo[idx][HousePrice]);
HouseInfo[idx][HouseLabel] = CreateStreamed3DTextLabel(string, HOUSE_COLOR, HouseInfo[idx][HouseEnterX], HouseInfo[idx][HouseEnterY], HouseInfo[idx][HouseEnterZ], 10.0, 0);
HouseInfo[idx][HouseSafeLabel] = CreateStreamed3DTextLabel("House Safe", HOUSE_COLOR, HouseInfo[idx][HouseSafeX], HouseInfo[idx][HouseSafeY], HouseInfo[idx][HouseSafeZ], 10.0, idx);
HouseInfo[idx][HouseSafePickup] = CreateDynamicPickup(1239, 23, HouseInfo[idx][HouseSafeX], HouseInfo[idx][HouseSafeY], HouseInfo[idx][HouseSafeZ], idx);
}
idx++;
return 1;
}
