[PAGALBOS] Dėl mysql R37 Saugojimo

[BoCeNas*]

Sveiki, yra klausimas, kodel man nesaugo duomenu?

[17:56:25] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "lsmp", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[17:56:25] [DEBUG] CMySQLHandle::Create - creating new connection..
[17:56:25] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[17:56:25] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[17:56:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[17:56:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[17:56:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[17:56:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[17:56:25] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[17:56:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[17:56:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[17:56:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[17:56:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[17:56:25] [DEBUG] CMySQLConnection::Connect - connection was successful
[17:56:25] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[17:57:00] [DEBUG] orm_create - table: "zaidejai", connectionHandle: 1
[17:57:00] [DEBUG] COrm::Create - creating new orm object..
[17:57:00] [DEBUG] COrm::Create - orm object created (id: 1)
[17:57:00] [DEBUG] orm_addvar - orm_id: 1, var: 02CD97B4, datatype: 0, varname: "ID", var_maxlen: 1
[17:57:00] [DEBUG] orm_addvar - orm_id: 1, var: 02CD97B8, datatype: 2, varname: "Vardas", var_maxlen: 24
[17:57:00] [DEBUG] orm_addvar - orm_id: 1, var: 02CD9818, datatype: 2, varname: "Slaptazodis", var_maxlen: 24
[17:57:00] [DEBUG] orm_addvar - orm_id: 1, var: 02CD9880, datatype: 0, varname: "PINIGAI", var_maxlen: 1
[17:57:00] [DEBUG] orm_addvar - orm_id: 1, var: 02CD9884, datatype: 0, varname: "SCORE", var_maxlen: 1
[17:57:00] [DEBUG] orm_addvar - orm_id: 1, var: 02CD988C, datatype: 1, varname: "HealthEx", var_maxlen: 1
[17:57:00] [DEBUG] orm_addvar - orm_id: 1, var: 02CD9894, datatype: 1, varname: "posx", var_maxlen: 1
[17:57:00] [DEBUG] orm_addvar - orm_id: 1, var: 02CD9898, datatype: 1, varname: "posy", var_maxlen: 1
[17:57:00] [DEBUG] orm_addvar - orm_id: 1, var: 02CD989C, datatype: 1, varname: "posz", var_maxlen: 1
[17:57:00] [DEBUG] orm_addvar - orm_id: 1, var: 02CD98A0, datatype: 1, varname: "posa", var_maxlen: 1
[17:57:00] [DEBUG] orm_setkey - orm_id: 1, varname: "Vardas"
[17:57:00] [DEBUG] orm_select - orm_id: 1, callback: "OnPlayerCheck", format: "d"
[17:57:00] [DEBUG] CMySQLQuery::Execute[OnPlayerCheck] - starting query execution
[17:57:01] [DEBUG] CMySQLQuery::Execute[OnPlayerCheck] - query was successfully executed within 127.920 milliseconds
[17:57:01] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[17:57:01] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "0"
[17:57:01] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '1', data: "lalalalal"
[17:57:01] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '2', data: "0"
[17:57:01] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '3', data: "0"
[17:57:01] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '4', data: "0"
[17:57:01] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '5', data: "0"
[17:57:01] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '6', data: "0"
[17:57:01] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '7', data: "0"
[17:57:01] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '8', data: "0"
[17:57:01] [DEBUG] Calling callback "OnPlayerCheck"..
[17:57:01] [DEBUG] orm_errno - orm_id: 1
[17:57:01] [DEBUG] orm_setkey - orm_id: 1, varname: "ID"
[17:57:01] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

Daryta pagal sia pamoka http://www.supergames.lt/topic/140890-pamokamysql-saugojimaskrovimas/

Redaguota Balandžio 9, 2014, nario BoCeNas*

[bebras]

Krauna. Viskas čia gerai.

[BoCeNas*]

Bet pazaidziu ir kai atsijungiu, turetu rodyti kad gavau 2 xp, Bet duomenu bazei viskas 0.

[bebras]

Ne taip perskaičiau... log'e nėra saugojimo.

[BoCeNas*]

Šis nieko neduoda 

stock SaveStats(playerid)
{
orm_update(ORMID[playerid]);
return 1;
}

Gal parašysi kaip ta saugojima daryt?

[bebras]

O tu jį kurnors naudoji?

[BoCeNas*]

O tu jį kurnors naudoji?

Kaip suprast naudoju? 

O gal aš ne taip supratau, gal reikia čia kažką prirašyt? orm_update(ORMID[playerid]);?

[bebras]

public OnPlayerDisconnect(playerid,reason)

{

SaveStats(playerid);

}

[BoCeNas*]

public OnPlayerDisconnect(playerid,reason)
{
   SaveStats(playerid);
}

Yra viskas tj, testinsiu iš naujo.

[BoCeNas*]

Tas pats 0 rodo.

[18:17:47] [DEBUG] COrm::Create - orm object created (id: 1)
[18:17:47] [DEBUG] orm_addvar - orm_id: 1, var: 02CD93FC, datatype: 0, varname: "ID", var_maxlen: 1
[18:17:47] [DEBUG] orm_addvar - orm_id: 1, var: 02CD9400, datatype: 2, varname: "Vardas", var_maxlen: 24
[18:17:47] [DEBUG] orm_addvar - orm_id: 1, var: 02CD9460, datatype: 2, varname: "Slaptazodis", var_maxlen: 24
[18:17:47] [DEBUG] orm_addvar - orm_id: 1, var: 02CD94C8, datatype: 0, varname: "PINIGAI", var_maxlen: 1
[18:17:47] [DEBUG] orm_addvar - orm_id: 1, var: 02CD94CC, datatype: 0, varname: "SCORE", var_maxlen: 1
[18:17:47] [DEBUG] orm_addvar - orm_id: 1, var: 02CD94D4, datatype: 1, varname: "HealthEx", var_maxlen: 1
[18:17:47] [DEBUG] orm_setkey - orm_id: 1, varname: "Vardas"
[18:17:47] [DEBUG] orm_select - orm_id: 1, callback: "OnPlayerCheck", format: "d"
[18:17:47] [DEBUG] CMySQLQuery::Execute[OnPlayerCheck] - starting query execution
[18:17:47] [DEBUG] CMySQLQuery::Execute[OnPlayerCheck] - query was successfully executed within 0.410 milliseconds
[18:17:47] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[18:17:47] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '0', data: "0"
[18:17:47] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '1', data: "lalalaal"
[18:17:47] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '2', data: "0"
[18:17:47] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '3', data: "0"
[18:17:47] [DEBUG] CMySQLResult::GetRowData - row: '0', field: '4', data: "0"
[18:17:47] [DEBUG] Calling callback "OnPlayerCheck"..
[18:17:47] [DEBUG] orm_errno - orm_id: 1
[18:17:47] [DEBUG] orm_setkey - orm_id: 1, varname: "ID"
[18:17:47] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called

[bebras]

Log'e nesimato orm_update. Ir kur nulius rodo? Duomenų bazėje?

[BoCeNas*]

Bet rimtai nerodo. As graziai viska sudejes kaip parodyta, kodel taip yra?