Salut am o problema se salveaza casele si in gm si in baza de date si dupa ce dau restart la gm dispar din gm adica din joc
CMD:createhouse(playerid, params[])
{
if(gPlayerLogged[playerid] == 0) return SCM(playerid, COLOR_ERROR, "Trebuie sa te autentifici pe server!");
if(PlayerInfo[playerid][pAdmin] >= 7 && Niku(playerid))
{
if(PlayerInfo[playerid][pAdmin] >= 6)
{
new house[64],Float:pX,Float:pY,Float:pZ,PropertyString[1000],query[500];
if(sscanf(params, "s[64]", house)) return SendClientMessage(playerid, 0xFFFFFFFF, "{A9C4E4}Folosire: {FFFFFF}/createhouse [interios</small/medium/big>]");
if(strcmp(house,"medium",true) == 0)
{
GetPlayerPos(playerid, pX, pY, pZ);
SetPVarFloat(playerid, "pHeX", pX);
SetPVarFloat(playerid, "pHeY", pY);
SetPVarFloat(playerid, "pHeZ", pZ);
SetPVarInt(playerid, "hExt", 1);
SetPVarFloat(playerid, "pHiX", 243.4247);
SetPVarFloat(playerid, "pHiY", -1851.5872);
SetPVarFloat(playerid, "pHiZ", 3333.9329);
SetPVarInt(playerid, "pHiID", 0);
new i = housess+1;
mysql_format(SQL, query, sizeof(query), "INSERT INTO houses (Owner, Lockk, Hel, Arm, Level, Rentabil, Rent, Owned, Discription, Value, Takings) VALUES('The State', '0', '0', '0', '10', '1', '500', '0', 'House', '10000000', '0')");
mysql_tquery(SQL, query, "", "");
HouseInfo[hID] = i;
HouseInfo[hEntrancex] = GetPVarFloat(playerid, "pHeX");
HouseInfo[hEntrancey] = GetPVarFloat(playerid, "pHeY");
HouseInfo[hEntrancez] = GetPVarFloat(playerid, "pHeZ");
HouseInfo[hExitx] = GetPVarFloat(playerid, "pHiX");
HouseInfo[hExity] = GetPVarFloat(playerid, "pHiY");
HouseInfo[hExitz] = GetPVarFloat(playerid, "pHiZ");
format(HouseInfo[hOwner], 64, "The State");
format(HouseInfo[hDiscription], 64, "House");
HouseInfo[hValue] = 10000000;
SetPVarInt(playerid, "pHiVW", housess+HouseInfo[hValue]);
HouseInfo[hHel] = 0;
HouseInfo[hArm] = 0;
HouseInfo[hInterior] = GetPVarInt(playerid, "pHiID");
HouseInfo[hLock] = 0;
HouseInfo[hOwned] = 0;
HouseInfo[hRent] = 500;
HouseInfo[hRentabil] = 1;
HouseInfo[hTakings] = 0;
HouseInfo[hLevel] = 5;
HouseInfo[hVirtual] = GetPVarInt(playerid, "pHiVW");
mysql_format(SQL, query, sizeof(query), "UPDATE `houses` SET `Entrancex`='%f',`Entrancey`='%f',`Entrancez`='%f',`Exitx`='%f',`Exity`='%f',`Exitz`='%f',`Interior`='%d',`Virtual`='%d' WHERE `ID`='%d'",HouseInfo[hEntrancex],HouseInfo[hEntrancey],HouseInfo[hEntrancez],HouseInfo[hExitx],HouseInfo[hExity],HouseInfo[hExitz],HouseInfo[hInterior],HouseInfo[hVirtual],i);
mysql_tquery(SQL,query,"","");
DeletePVar(playerid, "pHeX");
DeletePVar(playerid, "pHeY");
DeletePVar(playerid, "pHeZ");
DeletePVar(playerid, "pHiX");
DeletePVar(playerid, "pHeY");
DeletePVar(playerid, "pHeZ");
DeletePVar(playerid, "pHiID");
DeletePVar(playerid, "pHiVW");
DeletePVar(playerid, "pExt");
DeletePVar(playerid, "pInt");
DestroyDynamic3DTextLabel(HouseLabel);
format(PropertyString, sizeof(PropertyString),"{FFFFFF}House {A9C4E4}%d \n{A9C4E4}This house is for sale(/buyhouse) ! \n{FFFFFF}Description: {A9C4E4}%s \n{FFFFFF}Price: {A9C4E4}$%s \n{FFFFFF}Level: {A9C4E4}%d",i,HouseInfo[hDiscription],FormatNumber(HouseInfo[hValue]),HouseInfo[hLevel]);
HouseLabel = CreateDynamic3DTextLabel(PropertyString ,0x09FF00CC,HouseInfo[hEntrancex], HouseInfo[hEntrancey], HouseInfo[hEntrancez],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0);
SetPlayerInterior(playerid, 0);
SetPlayerVirtualWorld(playerid, 0);
SetPlayerPos(playerid, HouseInfo[hEntrancex], HouseInfo[hEntrancey], HouseInfo[hEntrancez]);
housess++;
SendClientMessage(playerid, COLOR_YELLOW, "House added interior: medium.");
}
if(strcmp(house,"small",true) == 0)
{
GetPlayerPos(playerid, pX, pY, pZ);
SetPVarFloat(playerid, "pHeX", pX);
SetPVarFloat(playerid, "pHeY", pY);
SetPVarFloat(playerid, "pHeZ", pZ);
SetPVarFloat(playerid, "pHiX", 210.6192);
SetPVarFloat(playerid, "pHiY", 1753.7064);
SetPVarFloat(playerid, "pHiZ", 3334.2429);
SetPVarInt(playerid, "pHiID", 0);
new i = housess+1;
mysql_format(SQL, query, sizeof(query), "INSERT INTO houses (Owner, Lockk, Hel, Arm, Level, Rentabil, Rent, Owned, Discription, Value, Takings) VALUES('The State', '0', '0', '0', '10', '1', '500', '0', 'House', '10000000', '0')");
mysql_tquery(SQL, query, "", "");
HouseInfo[hID] = i;
HouseInfo[hEntrancex] = GetPVarFloat(playerid, "pHeX");
HouseInfo[hEntrancey] = GetPVarFloat(playerid, "pHeY");
HouseInfo[hEntrancez] = GetPVarFloat(playerid, "pHeZ");
HouseInfo[hExitx] = GetPVarFloat(playerid, "pHiX");
HouseInfo[hExity] = GetPVarFloat(playerid, "pHiY");
HouseInfo[hExitz] = GetPVarFloat(playerid, "pHiZ");
format(HouseInfo[hOwner], 64, "The State");
format(HouseInfo[hDiscription], 64, "House");
HouseInfo[hValue] = 5000000;
SetPVarInt(playerid, "pHiVW", housess+HouseInfo[hValue]);
HouseInfo[hHel] = 0;
HouseInfo[hArm] = 0;
HouseInfo[hInterior] = GetPVarInt(playerid, "pHiID");
HouseInfo[hLock] = 0;
HouseInfo[hOwned] = 0;
HouseInfo[hRent] = 500;
HouseInfo[hRentabil] = 1;
HouseInfo[hTakings] = 0;
HouseInfo[hLevel] = 3;
HouseInfo[hVirtual] = GetPVarInt(playerid, "pHiVW");
mysql_format(SQL, query, sizeof(query), "UPDATE `houses` SET `Entrancex`='%f',`Entrancey`='%f',`Entrancez`='%f',`Exitx`='%f',`Exity`='%f',`Exitz`='%f',`Interior`='%d',`Virtual`='%d' WHERE `ID`='%d'",HouseInfo[hEntrancex],HouseInfo[hEntrancey],HouseInfo[hEntrancez],HouseInfo[hExitx],HouseInfo[hExity],HouseInfo[hExitz],HouseInfo[hInterior],HouseInfo[hVirtual],i);
mysql_tquery(SQL,query,"","");
DeletePVar(playerid, "pHeX");
DeletePVar(playerid, "pHeY");
DeletePVar(playerid, "pHeZ");
DeletePVar(playerid, "pHiX");
DeletePVar(playerid, "pHeY");
DeletePVar(playerid, "pHeZ");
DeletePVar(playerid, "pHiID");
DeletePVar(playerid, "pHiVW");
DeletePVar(playerid, "pExt");
DeletePVar(playerid, "pInt");
DestroyDynamic3DTextLabel(HouseLabel);
format(PropertyString, sizeof(PropertyString),"{FFFFFF}House {A9C4E4}%d \n{A9C4E4}This house is for sale(/buyhouse) ! \n{FFFFFF}Description: {A9C4E4}%s \n{FFFFFF}Price: {A9C4E4}$%s \n{FFFFFF}Level: {A9C4E4}%d",i,HouseInfo[hDiscription],FormatNumber(HouseInfo[hValue]),HouseInfo[hLevel]);
HouseLabel = CreateDynamic3DTextLabel(PropertyString ,0x09FF00CC,HouseInfo[hEntrancex], HouseInfo[hEntrancey], HouseInfo[hEntrancez],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0);
SetPlayerInterior(playerid, 0);
SetPlayerVirtualWorld(playerid, 0);
SetPlayerPos(playerid, HouseInfo[hEntrancex], HouseInfo[hEntrancey], HouseInfo[hEntrancez]);
housess++;
SendClientMessage(playerid, COLOR_YELLOW, "House added interior: small.");
}
if(strcmp(house,"big",true) == 0)
{
GetPlayerPos(playerid, pX, pY, pZ);
SetPVarFloat(playerid, "pHeX", pX);
SetPVarFloat(playerid, "pHeY", pY);
SetPVarFloat(playerid, "pHeZ", pZ);
SetPVarFloat(playerid, "pHiX", 1686.6067);
SetPVarFloat(playerid, "pHiY", 3843.6399);
SetPVarFloat(playerid, "pHiZ", 8.0741);
SetPVarInt(playerid, "pHiID", 0);
new i = housess+1;
mysql_format(SQL, query, sizeof(query), "INSERT INTO houses (Owner, Lockk, Hel, Arm, Level, Rentabil, Rent, Owned, Discription, Value, Takings) VALUES('The State', '0', '0', '0', '10', '1', '500', '0', 'House', '10000000', '0')");
mysql_tquery(SQL, query, "", "");
HouseInfo[hID] = i;
HouseInfo[hEntrancex] = GetPVarFloat(playerid, "pHeX");
HouseInfo[hEntrancey] = GetPVarFloat(playerid, "pHeY");
HouseInfo[hEntrancez] = GetPVarFloat(playerid, "pHeZ");
HouseInfo[hExitx] = GetPVarFloat(playerid, "pHiX");
HouseInfo[hExity] = GetPVarFloat(playerid, "pHiY");
HouseInfo[hExitz] = GetPVarFloat(playerid, "pHiZ");
format(HouseInfo[hOwner], 64, "The State");
format(HouseInfo[hDiscription], 64, "House");
HouseInfo[hValue] = 15000000;
SetPVarInt(playerid, "pHiVW", housess+HouseInfo[hValue]);
HouseInfo[hHel] = 0;
HouseInfo[hArm] = 0;
HouseInfo[hInterior] = GetPVarInt(playerid, "pHiID");
HouseInfo[hLock] = 0;
HouseInfo[hOwned] = 0;
HouseInfo[hRent] = 500;
HouseInfo[hRentabil] = 1;
HouseInfo[hTakings] = 0;
HouseInfo[hLevel] = 7;
HouseInfo[hVirtual] = GetPVarInt(playerid, "pHiVW");
mysql_format(SQL, query, sizeof(query), "UPDATE `houses` SET `Entrancex`='%f',`Entrancey`='%f',`Entrancez`='%f',`Exitx`='%f',`Exity`='%f',`Exitz`='%f',`Interior`='%d',`Virtual`='%d' WHERE `ID`='%d'",HouseInfo[hEntrancex],HouseInfo[hEntrancey],HouseInfo[hEntrancez],HouseInfo[hExitx],HouseInfo[hExity],HouseInfo[hExitz],HouseInfo[hInterior],HouseInfo[hVirtual],i);
mysql_tquery(SQL,query,"","");
DeletePVar(playerid, "pHeX");
DeletePVar(playerid, "pHeY");
DeletePVar(playerid, "pHeZ");
DeletePVar(playerid, "pHiX");
DeletePVar(playerid, "pHeY");
DeletePVar(playerid, "pHeZ");
DeletePVar(playerid, "pHiID");
DeletePVar(playerid, "pHiVW");
DeletePVar(playerid, "pExt");
DeletePVar(playerid, "pInt");
DestroyDynamic3DTextLabel(HouseLabel);
format(PropertyString, sizeof(PropertyString),"{FFFFFF}House {A9C4E4}%d \n{A9C4E4}This house is for sale(/buyhouse) ! \n{FFFFFF}Description: {A9C4E4}%s \n{FFFFFF}Price: {A9C4E4}$%s \n{FFFFFF}Level: {A9C4E4}%d",i,HouseInfo[hDiscription],FormatNumber(HouseInfo[hValue]),HouseInfo[hLevel]);
HouseLabel = CreateDynamic3DTextLabel(PropertyString ,0x09FF00CC,HouseInfo[hEntrancex], HouseInfo[hEntrancey], HouseInfo[hEntrancez],25, INVALID_PLAYER_ID, INVALID_VEHICLE_ID, 1, -1, -1, -1, 100.0);
SetPlayerInterior(playerid, 0);
SetPlayerVirtualWorld(playerid, 0);
SetPlayerPos(playerid, HouseInfo[hEntrancex], HouseInfo[hEntrancey], HouseInfo[hEntrancez]);
housess++;
SendClientMessage(playerid, COLOR_YELLOW, "House added interior: big.");
}
}
else return SendClientMessage(playerid, COLOR_ERROR, AdminOnly);
}
return 1;
}
