Häuser werden nicht Gespeichert (MySQL)

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • Hey,


    Wenn ich Ingame ein Haus erstelle wird es nicht in der Tabelle Gespeichert.


    In der mysql_log steht

    Spoiler anzeigen
    [Thu Aug 02 18:14:59 2012] Function: mysql_query executed: "UPDATE `houses` SET `hcreated` = '1' ,`hentrancex` = '1020.719177' ,`hentrancey` = '-1729.331420' ,`hentrancez` = '20.710937' ,`hexitx` = '244.500000', `hexity` = '305.000000', `hexitz` = '999.148376', `hhealthx` = '0' WHERE `houseid`='0'" with result: "0".
    [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

    Einmal editiert, zuletzt von dnlk ()