Pagalbos su Mysql saugojimu/ krovimu

[Kapone]

Sveiki visi ,tagi pradėjau vėl kažką daryti, ir iškilo bėda, nesaugo nei skin, nei darbo aprangos, nei pačio darbo,

 

Kodai saugojimo ::

 

  

    format(Query, sizeof(Query), "UPDATE `zaidejai` SET Darbas = %d, Drabuziai = '%i',Specialybe = '%i', Uniforma = '%d', plead = '%i' WHERE Vardas = '%s'",\

    pDB[playerid][specialybe], pDB[playerid][drabuziai],pDB[playerid][Darbas], pDB[playerid][uniforma], pDB[playerid][pLytis], pDB[playerid][plead], GetPlayerNameEx(playerid));

    mysql_query( Query );

Krovimas :

   mysql_fetch_field_row( fetch, "Lead");          pDB[playerid][plead] = strval(fetch);

    mysql_fetch_field_row( fetch, "Lytis");         pDB[playerid][lytis] = strval(fetch);

    mysql_fetch_field_row( fetch, "Uniforma");      pDB[playerid][uniforma] = strval(fetch);

    mysql_fetch_field_row( fetch, "Drabuziai");     pDB[playerid][drabuziai] = strval(fetch);

[bebras]

MySQL log?

[Kapone]

MySQL log?

O kur jį rast? nes pats ieškojau ir neradau, galvojau pats pažiūrėsiu

[bebras]

Serverio direktorijoje. Senesnėse MySQL versijose jis vadinasi "debug.txt"

[Kapone]

[15:07:57] >> mysql_connect( )

[15:07:57] CMySQLHandler::CMySQLHandler() - constructor called.

[15:07:57] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "serveris" | Username: "root" ...

[15:07:57] CMySQLHandler::Connect() - Connection was successful.

[15:07:57] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[15:07:57] >> mysql_ping( Connection handle: 1 )

[15:07:57] CMySQLHandler::Ping() - Connection is still alive.

[15:08:22] >> mysql_query( Connection handle: 1 )

[15:08:22] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Ponas_Kentas') - Successfully executed.

[15:08:22] >> mysql_store_result( Connection handle: 1 )

[15:08:22] CMySQLHandler::StoreResult() - Result was stored.

[15:08:22] >> mysql_num_rows( Connection handle: 1 )

[15:08:22] CMySQLHandler::NumRows() - Returned 1 row(s)

[15:08:22] >> mysql_free_result( Connection handle: 1 )

[15:08:22] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:08:26] >> mysql_real_escape_string( Connection handle: 1 )

[15:08:26] CMySQLHandler::EscapeString(654321as); - Escaped 8 characters to 654321as.

[15:08:26] >> mysql_query( Connection handle: 1 )

[15:08:26] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Ponas_Kentas' AND slaptazodis = '654321as') - Successfully executed.

[15:08:26] >> mysql_store_result( Connection handle: 1 )

[15:08:26] CMySQLHandler::StoreResult() - Result was stored.

[15:08:26] >> mysql_num_rows( Connection handle: 1 )

[15:08:26] CMySQLHandler::NumRows() - Returned 1 row(s)

[15:08:27] >> mysql_query( Connection handle: 1 )

[15:08:27] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE vardas = 'Ponas_Kentas') - Successfully executed.

[15:08:27] >> mysql_store_result( Connection handle: 1 )

[15:08:27] CMySQLHandler::StoreResult() - Result was stored.

[15:08:27] >> mysql_retrieve_row( Connection handle: 1 )

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("x") - 1739.287353

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("y") - -1837.235107

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("z") - 13.566157

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("skin") - 0

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("pinigai") - 500000

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("patirtis") -

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Vip") - 1

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Viplaikas") -

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Kreditai") -

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("XPboost") -

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Admin") - 4

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Kalejime") -

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Surakintas") -

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Alga") -

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Pradirbo") -

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Ispejimai") -

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Lead") - 1

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Lytis") -

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Uniforma") - 0

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("Drabuziai") - 0

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("hp") - 100

[15:08:27] >> mysql_fetch_field_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::FetchField("armour") - 100

[15:08:27] >> mysql_free_result( Connection handle: 1 )

[15:08:27] CMySQLHandler::FreeResult() - Result was successfully free'd.

[15:08:27] >> mysql_query( Connection handle: 1 )

[15:08:27] CMySQLHandler::Query(SELECT * FROM masinos WHERE Savininkas='Ponas_Kentas') - An error has occured. (Error ID: 1146, Table 'serveris.masinos' doesn't exist)

[15:08:27] >> mysql_store_result( Connection handle: 1 )

[15:08:27] CMySQLHandler::StoreResult() - No data to store.

[15:08:27] >> mysql_retrieve_row( Connection handle: 1 )

[15:08:27] CMySQLHandler::RetrieveRow() - You cannot call this function now. (Reason: Empty Result)

[bebras]

Tavo saugojimo užklausa nėra log'e. Gal saugojimas yra kažkokioj funkcijoje? 

[Kapone]

gali detaliau paaiškint?

[Kapone]

Išmėginau visus būdus, įsidarbinu, atsijungiu vėl be skin. ir be darbo ... nervas ima negaliu... gal kaikas padėt galit? nes nesuprantu kas yra

Redaguota Liepos 12, 2014, nario Justas Š.
Narys įspėtas už šį pranešimą: nesinaudojimas "Redaguoti" mygtuku(double-post)

[SpowneR]

Pabandyk galbūt, po OnPlayerDisconnect, prirašyti TAVOSAUGOJIMOPAVADINIMAS(playerid);

 

Ir beje tu neužkrauni darbo.

Redaguota Liepos 12, 2014, nario -EVΛNAS

[Anatomys]

Pabandyk prie krovimo pridėt. P.S. Čia tik mano spėjimas, naujokas aš dar skriptinime.

    mysql_fetch_field_row( fetch, "Drabuziai");     pDB[playerid][drabuziai] = strval(fetch);     SetPlayerSkin(playerid, pDB[playerid][drabuziai]);

Redaguota Liepos 12, 2014, nario Haxogen