House doesn't save - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: House doesn't save (/showthread.php?tid=602932)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: House doesn't save (/showthread.php?tid=602932)
House doesn't save - lulo356 - 15.03.2016
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;
}
Re: House doesn't save - iKevin - 15.03.2016
I don't see a mistake. Try expanding your custom defines and try to make a command to save houses manually or set them to save themselves every x amount of time (I use this). I have the both ways and works perfect.
Re: House doesn't save - thegamer355 - 15.03.2016
If you are creating a house, then you can't use UPDATE in the mysql query, you will need to use INSERT
Re: House doesn't save - lulo356 - 15.03.2016
PHP код:
forward SaveHouseCallback(houseid, playerid);
public SaveHouseCallback(houseid, playerid)
{
new
rows;
if(rows == 1)
{
//SendClientMessage(SavingVehiclePlayerID, RED, "This Vehicle already exists");
SendClientMessage(playerid, RED, "This House already exists!");
}
else if(rows == 0)
{
new query[2000];
format(query, sizeof(query), "INSERT INTO `Houses` (`hInteriorID`, `hInteriorX`, `hInteriorY`, `hInteriorZ`, `hInteriorA`, `hExteriorID`, `hExteriorX`, `hExteriorY`, `hExteriorZ`, `hExteriorA`, `hSpawnID`, ");
format(query, sizeof(query), "%s`hSpawnX`, `hSpawnY`, `hSpawnZ`, `hSpawnA`, `hOwner`, `hAddress`, `HousePrice`, `hLockStatus`, `hType`) VALUES ", query);
format(query, sizeof(query), "%s(%d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', '%s', '%s', %d, %d, '%s')",
query, 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],
Houses[houseid][hOwner],
Houses[houseid][hAddress],
-1,
1,
Houses[houseid][hType]);
mysql_queryM(query, "DefaultCallback");
new query2[400];
format(query2, sizeof(query2), "SELECT * FROM `Houses` WHERE `HouseID` = %d", houseid); // Selects all the information from the table
mysql_queryM(query2,"LoadHousesCallback", "d", houseid);
}
else
{
//SendClientMessage(SavingVehiclePlayerID, COLOR_WHITE, "There was a "#COL_EMB_RED"fatal error "#COL_EMB_WHITE"during registration! Please contact a developer.");
SendClientMessage(playerid, COLOR_WHITE, "There was a "#COL_EMB_RED"fatal error "#COL_EMB_WHITE"during registration! Please contact a developer.");
}
return 1;
}
Re: House doesn't save - thegamer355 - 15.03.2016
Now it creates because you have INSERT INTO, which is for creating.
You could check in the database if there are results already and if there are, format the update query,
if there aren't format the create query.
This is the only way to use both in 1 stock
Re: House doesn't save - lulo356 - 15.03.2016
Quote:
|
Originally Posted by thegamer355
 Now it creates because you have INSERT INTO, which is for creating.
You could check in the database if there are results already and if there are, format the update query, if there aren't format the create query. This is the only way to use both in 1 stock |
Re: House doesn't save - thegamer355 - 16.03.2016
If you have 2 callbacks to save the houses, make sure 1 has INSERT INTO and the other has UPDATE.
Use the one with INSERT INTO for the creating, and the one with UPDATE for saving.
To be honest, i'm a bit confused now, because you showed us 2 different callbacks, and i'm not sure which one is supposed to do what.
Re: House doesn't save - lulo356 - 16.03.2016
Update.
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;
}
PHP код:
forward SaveHouseCallback(houseid, playerid);
public SaveHouseCallback(houseid, playerid)
{
new
rows;
if(rows == 1)
{
//SendClientMessage(SavingVehiclePlayerID, RED, "This Vehicle already exists");
SendClientMessage(playerid, RED, "This House already exists!");
}
else if(rows == 0)
{
new query[2000];
format(query, sizeof(query), "INSERT INTO `Houses` (`hInteriorID`, `hInteriorX`, `hInteriorY`, `hInteriorZ`, `hInteriorA`, `hExteriorID`, `hExteriorX`, `hExteriorY`, `hExteriorZ`, `hExteriorA`, `hSpawnID`, ");
format(query, sizeof(query), "%s`hSpawnX`, `hSpawnY`, `hSpawnZ`, `hSpawnA`, `hOwner`, `hAddress`, `HousePrice`, `hLockStatus`, `hType`) VALUES ", query);
format(query, sizeof(query), "%s(%d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', %d, '%f', '%f', '%f', '%f', '%s', '%s', %d, %d, '%s')",
query, 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],
Houses[houseid][hOwner],
Houses[houseid][hAddress],
-1,
1,
Houses[houseid][hType]);
mysql_queryM(query, "DefaultCallback");
new query2[400];
format(query2, sizeof(query2), "SELECT * FROM `Houses` WHERE `HouseID` = %d", houseid); // Selects all the information from the table
mysql_queryM(query2,"LoadHousesCallback", "d", houseid);
}
else
{
//SendClientMessage(SavingVehiclePlayerID, COLOR_WHITE, "There was a "#COL_EMB_RED"fatal error "#COL_EMB_WHITE"during registration! Please contact a developer.");
SendClientMessage(playerid, COLOR_WHITE, "There was a "#COL_EMB_RED"fatal error "#COL_EMB_WHITE"during registration! Please contact a developer.");
}
return 1;
}
Re: House doesn't save - thegamer355 - 16.03.2016
Quote:
|
Originally Posted by lulo356
Can someone maybe help me out? This is mine house system but it doesn't save in the mysql... Thanks for your advise
PHP код:
|
So in your command (or in another stock) make a query which checks if the house exists and let it return a value.
Depending on that value, decide wether to create or update the house.
That's all i can understand from it