Hey,
Wenn ich Ingame ein Haus erstelle wird es nicht in der Tabelle Gespeichert.
In der mysql_log steht
[Thu Aug 02 18:14:59 2012] Function: mysql_query executed: "UPDATE `houses` SET `hhealthy` = '0',`hhealthz` = '0', `harmourx` = '0', `harmoury` = '0', `harmourz` = '0', `howner` = 'Zu Verkaufen',`hdiscription` = '', `hvalue` = '20000',`hhel` = '1' WHERE `houseid`='0'" with result: "0".
[Thu Aug 02 18:14:59 2012] Function: mysql_query executed: "UPDATE `houses` SET `harm` = '1',`hint` = '1',`hlock` = '1',`howned` = '0',`hrooms` = '0',`hrent` = '50',`hrentabil` = '0',`htakings` = '0',`hdate` = '0',`hlevel` = '3',`hmuell` = '0' WHERE `houseid`='0'" with result: "0".
[Thu Aug 02 18:15:02 2012] Function: mysql_query executed: "UPDATE `houses` SET `hcreated` = '1' ,`hentrancex` = '1019.047241' ,`hentrancey` = '-1730.531860' ,`hentrancez` = '20.710937' ,`hexitx` = '244.500000', `hexity` = '305.000000', `hexitz` = '999.148376', `hhealthx` = '0' WHERE `houseid`='1'" with result: "0".
[Thu Aug 02 18:15:02 2012] Function: mysql_query executed: "UPDATE `houses` SET `hhealthy` = '0',`hhealthz` = '0', `harmourx` = '0', `harmoury` = '0', `harmourz` = '0', `howner` = 'Zu Verkaufen',`hdiscription` = '', `hvalue` = '20000',`hhel` = '1' WHERE `houseid`='1'" with result: "0".
[Thu Aug 02 18:15:02 2012] Function: mysql_query executed: "UPDATE `houses` SET `harm` = '1',`hint` = '1',`hlock` = '1',`howned` = '0',`hrooms` = '0',`hrent` = '50',`hrentabil` = '0',`htakings` = '0',`hdate` = '0',`hlevel` = '3',`hmuell` = '0' WHERE `houseid`='1'" with result: "0".
[Thu Aug 02 18:15:04 2012] Function: mysql_query executed: "UPDATE `houses` SET `hcreated` = '1' ,`hentrancex` = '1017.721191' ,`hentrancey` = '-1730.081542' ,`hentrancez` = '20.710937' ,`hexitx` = '244.500000', `hexity` = '305.000000', `hexitz` = '999.148376', `hhealthx` = '0' WHERE `houseid`='2'" with result: "0".
[Thu Aug 02 18:15:04 2012] Function: mysql_query executed: "UPDATE `houses` SET `hhealthy` = '0',`hhealthz` = '0', `harmourx` = '0', `harmoury` = '0', `harmourz` = '0', `howner` = 'Zu Verkaufen',`hdiscription` = '', `hvalue` = '20000',`hhel` = '1' WHERE `houseid`='2'" with result: "0".
[Thu Aug 02 18:15:04 2012] Function: mysql_query executed: "UPDATE `houses` SET `harm` = '1',`hint` = '1',`hlock` = '1',`howned` = '0',`hrooms` = '0',`hrent` = '50',`hrentabil` = '0',`htakings` = '0',`hdate` = '0',`hlevel` = '3',`hmuell` = '0' WHERE `houseid`='2'" with result: "0".
HIer soll des gespeichert werden aber es passiert nichts.
public SaveProperty(h)
{
new query[1024];
format(query,sizeof(query),"UPDATE `houses` SET `hcreated` = '%i' ,`hentrancex` = '%f' ,`hentrancey` = '%f' ,`hentrancez` = '%f' ,`hexitx` = '%f', `hexity` = '%f', `hexitz` = '%f', `hhealthx` = '%i' WHERE `houseid`='%i'",
HouseInfo[h][hCreated],HouseInfo[h][hEntrancex],HouseInfo[h][hEntrancey],HouseInfo[h][hEntrancez],HouseInfo[h][hExitx],HouseInfo[h][hExity],HouseInfo[h][hExitz],HouseInfo[h][hHealthx], h);
mysql_query(query);
format(query,sizeof(query),"UPDATE `houses` SET `hhealthy` = '%i',`hhealthz` = '%i', `harmourx` = '%i', `harmoury` = '%i', `harmourz` = '%i', `howner` = '%s',`hdiscription` = '%s', `hvalue` = '%i',`hhel` = '%i' WHERE `houseid`='%i'",
HouseInfo[h][hHealthy],HouseInfo[h][hHealthz],HouseInfo[h][hArmourx],HouseInfo[h][hArmoury],HouseInfo[h][hArmourz], HouseInfo[h][hOwner], HouseInfo[h][hDiscription],HouseInfo[h][hValue],HouseInfo[h][hHel], h);
mysql_query(query);
format(query,sizeof(query),"UPDATE `houses` SET `harm` = '%i',`hint` = '%i',`hlock` = '%i',`howned` = '%i',`hrooms` = '%i',`hrent` = '%i',`hrentabil` = '%i',`htakings` = '%i',`hdate` = '%i',`hlevel` = '%i',`hmuell` = '%i' WHERE `houseid`='%i'",
HouseInfo[h][hArm],HouseInfo[h][hInt],HouseInfo[h][hLock],HouseInfo[h][hOwned],HouseInfo[h][hRooms],HouseInfo[h][hRent],HouseInfo[h][hRentabil],HouseInfo[h][hTakings],HouseInfo[h][hDate],HouseInfo[h][hLevel],HouseInfo[h][hMuell], h);
mysql_query(query);
return 1;
}
Hoffe ihr könnt mir weiter helfen