15.03.2016, 19:39
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;
}
PHP код:
stock SaveHouse(houseid)
{
new query[2000];
format(query, sizeof(query), "UPDATE `Houses` SET `hInteriorID` = %d, `hInteriorX` = '%f', `hInteriorY` = '%f', `hInteriorZ` = '%f', `hInteriorA` = '%f', `hExteriorID` = %d, `hExteriorX` = '%f', `hExteriorY` = '%f', `hExteriorZ` = '%f', `hExteriorA` = '%f', `hSpawnID` = %d, `hSpawnX` = '%f', `hSpawnY` = '%f', `hSpawnZ` = '%f', `hSpawnA` = '%f', ",
Houses[houseid][hInteriorID],
Houses[houseid][hInteriorX],
Houses[houseid][hInteriorY],
Houses[houseid][hInteriorZ],
Houses[houseid][hInteriorA],
Houses[houseid][hExteriorID],
Houses[houseid][hExteriorX],
Houses[houseid][hExteriorY],
Houses[houseid][hExteriorZ],
Houses[houseid][hExteriorA],
Houses[houseid][hSpawnID],
Houses[houseid][hSpawnX],
Houses[houseid][hSpawnY],
Houses[houseid][hSpawnZ],
Houses[houseid][hSpawnA]);
format(query, sizeof(query), "%s`hOwner` = '%s', `hAddress` = '%s', `HousePrice` = %d, `hLockStatus` = %d, `hType` = '%s', `hLastLoginDate` = %d WHERE `HouseID` = %d",
query,
Houses[houseid][hOwner],
Houses[houseid][hAddress],
Houses[houseid][HousePrice],
Houses[houseid][hLockStatus],
Houses[houseid][hType],
Houses[houseid][hLastLoginDate],
houseid);
mysql_query(query);
return 1;
}
