Can someone maybe help me out? This is mine house system but it doesn't save in the mysql... Thanks for your advise
PHP код:
command(createhouse, playerid, params[])
{
new Usage[128], string[128];
if(sscanf(params, "z", Usage))
{
if(AdminLoggedIn[playerid] == 1 && Player[playerid][Adminlevel] >= 6)
{
SendClientMessage(playerid, WHITE, "SYNTAX: /createhouse [usage]");
SendClientMessage(playerid, GREY, "Usage: Interior, Exterior, Spawn or Complete.");
}
else
{
RemoveTextMessage(playerid);
TextDrawShowForPlayer(playerid, Text:CantCommand);
SetTimerEx("RemoveTextMessage", 3500, false, "d", playerid);
}
}
else
{
if(AdminLoggedIn[playerid] == 1 && Player[playerid][Adminlevel] >= 6)
{
if(strcmp(Usage, "exterior", true) == 0)
{
Player[playerid][HouseExterior]++;
Player[playerid][hExtID] = GetPlayerInterior(playerid);
GetPlayerFacingAngle(playerid, Player[playerid][hExtA]);
GetPlayerPos(playerid, Player[playerid][hExtX], Player[playerid][hExtY], Player[playerid][hExtZ]);
format(string, sizeof(string), "Exterior set! (X: %f, Y: %f, Z: %f).", Player[playerid][hExtX], Player[playerid][hExtY], Player[playerid][hExtZ]);
SendClientMessage(playerid, WHITE, string);
}
if(strcmp(Usage, "interior", true) == 0)
{
Player[playerid][HouseInterior]++;
Player[playerid][hIntID] = GetPlayerInterior(playerid);
GetPlayerFacingAngle(playerid, Player[playerid][hIntA]);
GetPlayerPos(playerid, Player[playerid][hIntX], Player[playerid][hIntY], Player[playerid][hIntZ]);
format(string, sizeof(string), "Interior set! (X: %f, Y: %f, Z: %f).", Player[playerid][hIntX], Player[playerid][hIntY], Player[playerid][hIntZ]);
SendClientMessage(playerid, WHITE, string);
}
if(strcmp(Usage, "spawn", true) == 0)
{
Player[playerid][HouseSpawn]++;
Player[playerid][hSpaID] = GetPlayerInterior(playerid);
GetPlayerFacingAngle(playerid, Player[playerid][hSpaA]);
GetPlayerPos(playerid, Player[playerid][hSpaX], Player[playerid][hSpaY], Player[playerid][hSpaZ]);
format(string, sizeof(string), "Spawn possition set! (X: %f, Y: %f, Z: %f).", Player[playerid][hSpaX], Player[playerid][hSpaY], Player[playerid][hSpaZ]);
SendClientMessage(playerid, WHITE, string);
}
if(strcmp(Usage, "complete", true) == 0)
{
if(Player[playerid][HouseInterior] > 0 || Player[playerid][HouseExterior] > 0)
{
new NewHouseID = SpawnedHouses+1;
if(NewHouseID >= MAX_HOUSES)
{
SendClientMessage(playerid, RED, "> Too many houses are currently spawned!");
}
else
{
format(Houses[NewHouseID][hAddress], 255, "None");
format(Houses[NewHouseID][hType], 255, "Unknown");
Houses[NewHouseID][hInteriorID] = Player[playerid][hIntID];
Houses[NewHouseID][hExteriorID] = Player[playerid][hExtID];
Houses[NewHouseID][hSpawnID] = Player[playerid][hSpaID];
Houses[NewHouseID][hInteriorX] = Player[playerid][hIntX];
Houses[NewHouseID][hInteriorY] = Player[playerid][hIntY];
Houses[NewHouseID][hInteriorZ] = Player[playerid][hIntZ];
Houses[NewHouseID][hInteriorA] = Player[playerid][hIntA];
Houses[NewHouseID][hExteriorX] = Player[playerid][hExtX];
Houses[NewHouseID][hExteriorY] = Player[playerid][hExtY];
Houses[NewHouseID][hExteriorZ] = Player[playerid][hExtZ];
Houses[NewHouseID][hExteriorA] = Player[playerid][hExtA];
Houses[NewHouseID][hSpawnX] = Player[playerid][hSpaX];
Houses[NewHouseID][hSpawnY] = Player[playerid][hSpaY];
Houses[NewHouseID][hSpawnZ] = Player[playerid][hSpaZ];
Houses[NewHouseID][hSpawnA] = Player[playerid][hSpaA];
Player[playerid][HouseExterior]--;
Player[playerid][HouseInterior]--;
Player[playerid][HouseSpawn]--;
SendClientMessage(playerid, NICESKY, "Successfully created house, don't forget to /sethouseprice, /sethouseaddress, /sethousetype!");
SetPlayerInterior(playerid, Houses[NewHouseID][hExteriorID]);
SetPlayerVirtualWorld(playerid, 0);
SetPlayerPos(playerid, Houses[NewHouseID][hExteriorX], Houses[NewHouseID][hExteriorY], Houses[NewHouseID][hExteriorZ]);
SavedHouses++;
SaveHouse(NewHouseID);
}
}
else
{
SendClientMessage(playerid, WHITE, "> You must select an exterior and an interior first!");
}
}
}
else
{
RemoveTextMessage(playerid);
TextDrawShowForPlayer(playerid, Text:CantCommand);
SetTimerEx("RemoveTextMessage", 3500, false, "d", playerid);
}
}
return 1;
}
