Nothing of that dint work, and Vince, i have annother code for saving player stats the same way built, and it works fine, so i dont think its that. Interesting not though.
The code looks like this now, and has exacly the same problems. Here i have more of it if you can spot something interesting from it. Sorry for the failsteps!
pawn Код:
printf("Started to save house %d", HouseID);
//Open sqlite database
print("Failstep 1");
new DB:Database, DBResult:Result;
print("Failstep 2");
new HouseStrCat[800];
print("Failstep 3");
new Query[1100];
new HouseIDQuery[128];
print("Failstep 4");
Database = db_open("DataHouses.db");
print("Failstep 5");
format(HouseIDQuery, sizeof(HouseIDQuery), "SELECT * FROM `Houses` WHERE `HouseID` = '%d'", HouseID);
print("Failstep 6");
Result = db_query(Database, HouseIDQuery);
print("Searching for house in database...");
if(!db_num_rows(Result)) //No house with this ID was found in the database
{
print("No house with that id was found. Adding in in the database...");
print("Failstep 7");
strcat(HouseStrCat, "INSERT INTO `Houses` (`HouseID`, `HouseAddress`, `HouseName`, `HouseX`, `HouseY`, `HouseZ`, `HouseInterior`, `HouseMaxSlots`, `HouseNewMaxSlots`, `HousePrice`, `Owned`, `HouseOpened`, `PlayerIsTycoon`, `Owner`, `Insurance`) ", sizeof(HouseStrCat)); // 15
strcat(HouseStrCat, "VALUES('%d','%s','%s','%f','%f','%f','%d','%d','%d','%d','%d','%d','%d','%s','%d')", sizeof(HouseStrCat)); // 44
print("Failstep 8");
format(Query, sizeof(Query), HouseStrCat, HouseID, AHouseData[HouseID][HouseAddress], AHouseData[HouseID][HouseName], AHouseData[HouseID][HouseX], AHouseData[HouseID][HouseY], AHouseData[HouseID][HouseZ], AHouseData[HouseID][HouseInterior], AHouseData[HouseID][HouseMaxSlots], AHouseData[HouseID][HouseNewMaxSlots],
AHouseData[HouseID][HousePrice], AHouseData[HouseID][Owned], AHouseData[HouseID][HouseOpened], AHouseData[HouseID][PlayerIsTycoon], AHouseData[HouseID][Owner], AHouseData[HouseID][Insurance]);
print("Failstep 9");
db_free_result(db_query(Database, Query));
print("Failstep 10");
strdel(HouseStrCat, 0, 800);
print("Added!");
}
else if(db_num_rows(Result)) // The house ID is in the database. Update the values
{
print("House found in database! Updaing...");
new Owned33 = 0;
if(AHouseData[HouseID][Owned] == true)
{
Owned33 = 1;
}
else if(AHouseData[HouseID][Owned] == false)
{
Owned33 = 0;
}
printf("House owned %d House Owner %s", Owned33, AHouseData[HouseID][Owner]);
print("Failstep 9");
//UPDATE `Houses` SET `HouseAddress` = '%s', `HouseName` = '%s', `HouseX` = '%f', `HouseY` = '%f', `HouseZ` = '%f', `HouseInterior` = '%d', `HouseMaxSlots` = '%d', `HouseNewMaxSlots` = '%d', `HousePrice` = '%d', `Owned` = '%d', `HouseOpened` = '%d', `PlayerIsTycoon` = '%d', `Owner` = '%s', `Insurance` = '%d' WHERE `HouseID` = '%d'
format(Query, sizeof(Query), "UPDATE Houses SET HouseAddress = '%s', HouseName = '%s', HouseX = %f, HouseY = %f, HouseZ = %f, HouseInterior = %d, HouseMaxSlots = %d, HouseNewMaxSlots = %d, HousePrice = %d, Owned = %d, HouseOpened = %d, PlayerIsTycoon = %d, Owner = '%s', Insurance = %d WHERE HouseID = %d",
AHouseData[HouseID][HouseAddress], AHouseData[HouseID][HouseName], AHouseData[HouseID][HouseX], AHouseData[HouseID][HouseY], AHouseData[HouseID][HouseZ], AHouseData[HouseID][HouseInterior], AHouseData[HouseID][HouseMaxSlots], AHouseData[HouseID][HouseNewMaxSlots], AHouseData[HouseID][HousePrice], Owned33,
AHouseData[HouseID][HouseOpened], AHouseData[HouseID][PlayerIsTycoon], AHouseData[HouseID][Owner], AHouseData[HouseID][Insurance], HouseID); // 15
print("Failstep 10");
db_free_result(db_query(Database, Query));
print("Failstep 11");
}
db_free_result(Result);
print("House saved. Stating to save vehicles...");
And the AHouseData as RoboN1X asked for :
pawn Код:
// Setup a custom type that holds all data for houses
enum THouseData
{
PickupID, // Holds the pickup-id that is linked to this house
Text3D:DoorText, // Holds the reference to the 3DText above the house's pickup
MapIconID, // Holds the ID of the mapicon for the house
HouseAddress[100], // Holds the address of the house (this will be displayed above the pickup near the house when it's owned)
HouseName[100], // Holds the name of the house (this will be displayed above the pickup near the house when it's owned)
Insurance, // Holds "1" if the house has an insurance for the vehicles belonging to this house
Float:HouseX, // Holds the X-coordinate of the pickup for the house
Float:HouseY, // Holds the Y-coordinate of the pickup for the house
Float:HouseZ, // Holds the Z-coordinate of the pickup for the house
HouseInterior, // Holds the interior of the house
HouseMaxSlots, // Holds the maximum ammount of slots this house has originally
HouseNewMaxSlots, // Holds the maximum level this house can be upgraded to
HousePrice, // Holds the price for buying the house, the same price applies when upgrading a house per level
bool:Owned, // Holds true if the house is owned by somebody
bool:PlayerIsTycoon, // Holds true if the house owner has 1000 or more truckloads
Owner[24], // Holds the name of the owner of the house
bool:HouseOpened, // Holds true if the house is open to the public (anyone can enter), false means: only the owner can enter it
VehicleIDs[50] // Holds the vehicle-id's of the vehicles linked to this house
}
// Holds the data for all houses
new AHouseData[MAX_HOUSES][THouseData];
Let me clearify that creating a house and putting the values of the house into database using "INSERT INTO `Houses`" works. I just checked with a database browser and saw that the values for the house was correct. The problem is that when a player buys the house, it wont save the new values eg. house owned/owner/house name etc.
Thanks for your replies!
