Function Load from Db doesnt work -
MCZOFT - 01.11.2014
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;
}
Re : Function Load from Db doesnt work -
MCZOFT - 01.11.2014
Bump for godsake answer guys
Re: Function Load from Db doesnt work -
Runn3R - 01.11.2014
Dude use an enum for house info lmfao...
And you're doing it wrong. You're using an array which is 256 cells big to store an ID into it? Dude..
Re : Function Load from Db doesnt work -
MCZOFT - 01.11.2014
then how it should be done ?
Re : Function Load from Db doesnt work -
MCZOFT - 01.11.2014
No one ?