[bogushas]

PHP код:

stock saveHouses(id)
{
    format(g_szBuffer, sizeof g_szBuffer, 
    "UPDATE "MySQL_HOUSES_TABLE" SET \
    \
        savininkas = '%s', \
        PirkimoBusena = %i,    \
        verte = %i, \
        interior = %i, \
        kaina = %i,    \
        uzraktas = %i, \
        security = %i, \
        TotalTaxes = %i, \
        Renter = '%s', \
        RentPrice = %i, \
        Rentable = %i, \
        Case = %i, \
        TotalCase = %i \
    \
    WHERE ID = %i",
    namai[id][hSavininkas],
    namai[ id ][ hNupirktas ], 
    namai[ id ][ hVerte ],
    namai[ id ][ hInterior ],
    namai[ id ][ hKaina ],
    namai[ id ][ hLock ],
    namai[ id ][ hSecurity ],
    namai[ id ][ hTotalTaxes ],
    namai[ id ][ hRenter ],
    namai[ id ][ hRentPrice ],
    namai[ id ][ hRentable ],
    namai[ id ][ hCase ],
    namai[ id ][ hTotalCase ],
    namai[ id ][ fromSQL ]);
    sql_query(sql, g_szBuffer, QUERY_THREADED); // threaded naudoti kai neimi duomenų iљ mysql
} 


debug:

PHP код:

[20:21:03][debug] Natives::sql_query: Scheduling statement (stmt->id = 38, stmt->query = UPDATE houses SET savininkas = 'Iam_Satan', PirkimoBusena = 1,    verte = 234046, interior = 0, kaina = 234046,    uzraktas = 0, security = 0, TotalTaxes = 1670, Renter = '-', RentPrice = 0, Rentable = 0, Case = 0, TotalCase = 0 WHERE ID = 2, stmt->callback = ) for execution... 


TotalTaxes is 1670 when saving, but in database it shows as 0

[bogushas]

any ideas?

[NGGMars]

You check that on Server Init The Connection to the Mysql DB is Succesful. Sometimes the Gamemode may glitch on the Mysql DB Connection Problems

I dont Have any other ideas, This Problem is Strange to me

[bogushas]

Quote:

Originally Posted by FuriousRoleplay You check that on Server Init The Connection to the Mysql DB is Succesful. Sometimes the Gamemode may glitch on the Mysql DB Connection Problems I dont Have any other ideas, This Problem is Strange to me

Everything is okay with the connection.

[Misiur]

Is that your whole log? Isn't there a next line like

Quote:

[21:24:20][debug] Natives:ql_query: Statement executed (stmt->id = 38, stmt->error = 0). No callback found!

[bogushas]

Quote:

Originally Posted by Misiur Is that your whole log? Isn't there a next line like

http://pastebin.com/A508cDm4 it's the whole log, it shows no callback found but all the houses load in server with their information perfect.

[Misiur]

"Case" is a reserved keyword. Either change your field name to something else, or use backticks, like

Quote:

`Case` = 123

Also I saw

Quote:

mokestis = 0WHERE ID = '1'

you are missing a space there, so that query won't execute either

Isn't there any error reporting for that specific plugin?

[bogushas]

Quote:

Originally Posted by Misiur "Case" is a reserved keyword. Either change your field name to something else, or use backticks, like Also I saw you are missing a space there, so that query won't execute either Isn't there any error reporting for that specific plugin?

Oh.. Thanks, the problem was with "case"!