Dėl nuosavų drabužių saugojimo.

[rytukas51]

Sveiki visi. Taigi užsiregistravus ir prisijungus nuosavus drabužius duoda, bet atsijungus ir prisijungus užsideda CJ skinas? Kame bėda gali būti?

 

Krovimas:

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

Saugojimas:

format(Query, sizeof(Query), "UPDATE `zaidejai` SET Drabuziai = '%i' WHERE Vardas = '%s'",\
playerDB[playerid][drabuziai],
GautiVarda(playerid));
mysql_query(Query);

 

Po kurio laiko duomenų bazėje nuosavų drabužių ID nusistato į -1, tai pat po registracijos atsijungus ir prisijungus printiną jog drabužių ID -1

[Swedbank]

Šaunu.

[bebras]

mysql log rodyk. 

SetPlayerSkin(playerid,playerDB[playerid][drabuziai]);
//šita eilutė yra?

[rytukas51]

 

mysql log rodyk. 

SetPlayerSkin(playerid,playerDB[playerid][drabuziai]);
//šita eilutė yra?

Eilute yra.

 

[16:09:59] ---------------------------

[16:09:59] MySQL Debugging activated (01/23/14)

[16:09:59] ---------------------------

[16:09:59]

[16:09:59] >> mysql_connect( )

[16:09:59] CMySQLHandler::CMySQLHandler() - constructor called.

[16:09:59] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "tmg" | Username: "root" ...

[16:09:59] CMySQLHandler::Connect() - Connection was successful.

[16:09:59] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

[16:09:59] >> mysql_ping( Connection handle: 1 )

[16:09:59] CMySQLHandler::Ping() - Connection is still alive.

[16:10:31] >> mysql_query( Connection handle: 1 )

[16:10:32] CMySQLHandler::Query(SELECT * FROM zaidejai WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

[16:10:32] >> mysql_store_result( Connection handle: 1 )

[16:10:32] CMySQLHandler::StoreResult() - Result was stored.

[16:10:32] >> mysql_retrieve_row( Connection handle: 1 )

[16:10:32] >> mysql_num_rows( Connection handle: 1 )

[16:10:32] CMySQLHandler::NumRows() - Returned 0 row(s)

[16:10:32] >> mysql_free_result( Connection handle: 1 )

[16:10:32] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:10:32] >> mysql_query( Connection handle: 1 )

[16:10:32] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Vitalikas_Slimer') - Successfully executed.

[16:10:32] >> mysql_store_result( Connection handle: 1 )

[16:10:32] CMySQLHandler::StoreResult() - Result was stored.

[16:10:32] >> mysql_num_rows( Connection handle: 1 )

[16:10:32] CMySQLHandler::NumRows() - Returned 0 row(s)

[16:10:32] >> mysql_free_result( Connection handle: 1 )

[16:10:32] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:10:34] >> mysql_query( Connection handle: 1 )

[16:10:34] CMySQLHandler::Query(INSERT INTO `zaidejai` (Vardas,Slaptazodis) VALUES ('Vitalikas_Slimer','viskis')) - Successfully executed.

[16:10:35] >> mysql_query( Connection handle: 1 )

[16:10:35] CMySQLHandler::Query(UPDATE `zaidejai` SET `Lytis` = '1' WHERE `Vardas` = 'Vitalikas_Slimer') - Successfully executed.

[16:10:36] >> mysql_query( Connection handle: 1 )

[16:10:36] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE `Vardas` = 'Vitalikas_Slimer' AND `Slaptazodis` = 'viskis') - Successfully executed.

[16:10:36] >> mysql_store_result( Connection handle: 1 )

[16:10:36] CMySQLHandler::StoreResult() - Result was stored.

[16:10:36] >> mysql_num_rows( Connection handle: 1 )

[16:10:36] CMySQLHandler::NumRows() - Returned 1 row(s)

[16:10:36] >> mysql_query( Connection handle: 1 )

[16:10:36] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

[16:10:36] >> mysql_store_result( Connection handle: 1 )

[16:10:36] CMySQLHandler::StoreResult() - Result was stored.

[16:10:36] >> mysql_fetch_row_format( Connection handle: 1 )

[16:10:36] CMySQLHandler::FetchRow() - Return: Vitalikas_Slimer|viskis|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0

[16:10:36] >> mysql_fetch_field_row( Connection handle: 1 )

[16:10:36] CMySQLHandler::FetchField("Adminlvl") -

[16:10:36] >> mysql_fetch_field_row( Connection handle: 1 )

[16:10:36] CMySQLHandler::FetchField("vip") -

[16:10:36] >> mysql_fetch_field_row( Connection handle: 1 )

[16:10:36] CMySQLHandler::FetchField("Vpriziuretojas") - 0

[16:10:36] >> mysql_fetch_field_row( Connection handle: 1 )

[16:10:36] CMySQLHandler::FetchField("Upriziuretojas") - 0

[16:10:36] >> mysql_fetch_field_row( Connection handle: 1 )

[16:10:36] CMySQLHandler::FetchField("Apriziuretojas") - 0

[16:10:36] >> mysql_fetch_field_row( Connection handle: 1 )

[16:10:36] CMySQLHandler::FetchField("Epriziuretojas") - 0

[16:10:36] >> mysql_fetch_field_row( Connection handle: 1 )

[16:10:36] CMySQLHandler::FetchField("Dpriziuretojas") - 0

[16:10:36] >> mysql_free_result( Connection handle: 1 )

[16:10:36] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:10:41] >> mysql_query( Connection handle: 1 )

[16:10:41] CMySQLHandler::Query(UPDATE `zaidejai` SET x = '2485.535400', y = '63.853538', z = '13.906200', Interior = '0' WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

[16:10:41] >> mysql_query( Connection handle: 1 )

[16:10:41] CMySQLHandler::Query(UPDATE `zaidejai` SET Pinigai = '3000', XP = '0', World = '0', Star = '0', Drabuziai = '3', Mute = '0', Admin = '0', Vip = '0', Pgradmin = '0' , Pinkodas = '0' WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

[16:10:41] >> mysql_query( Connection handle: 1 )

[16:10:41] CMySQLHandler::Query(UPDATE `zaidejai` SET Banke = '0', Ipaskola = '0', Uniforma = '-1', Darbas = '0', Namuose = '0', Lytis = '1', Emigruotas = '0', Kreditai = '0' , Telstat = '0' WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

[16:10:41] >> mysql_query( Connection handle: 1 )

[16:10:41] CMySQLHandler::Query(UPDATE `zaidejai` SET Mskill = '0', Saskaita = '0', Psaskaita = '0', Gautos = '0', Direktorius = '0', Pavaduotojas = '0', Lsd = '0', Kokoinas = '0' , Heroinas = '0' WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

[16:10:41] >> mysql_query( Connection handle: 1 )

[16:10:41] CMySQLHandler::Query(UPDATE `zaidejai` SET Prazaide = '0', Ispejimai = '0', Aispejimai = '0', Vispejimai = '0', Dispejimai = '0', Pagarba = '0' , Jaillaikas = '0' WHERE Vardas = '') - Successfully executed.

[16:10:41] >> mysql_query( Connection handle: 1 )

[16:10:41] CMySQLHandler::Query(UPDATE `zaidejai` SET Pdxp = '0', Medxp = '0', Taxixp = '0', Cosaxp = '0', Mechxp = '0', Dylxp = '0', Furxp = '0', Apsauxp = '0' , Alga = '0', BanLaikas = '0' WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

[16:10:41] >> mysql_query( Connection handle: 1 )

[16:10:41] CMySQLHandler::Query(UPDATE `zaidejai` SET Zuvys = '0', Masalas = '0', Bpaskola = '0', Isidarbino = '0', Islaike = '0', Apsilankepd = '0', Isigijotel = '0', Gunlic = '0' , Nupirkocar = '0' WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

[16:10:41] >> mysql_query( Connection handle: 1 )

[16:10:41] CMySQLHandler::Query(UPDATE `zaidejai` SET Nusieme = '0', Butdyr = '0', Butpav = '0', Nupirkobiz = '0', Praleista = '0', Praleistah = '0', PraleistaD = '0', Issiustos = '0' , lockas = '0', lockas2 = '0' WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

[16:10:41] >> mysql_query( Connection handle: 1 )

[16:10:42] CMySQLHandler::Query(UPDATE `zaidejai` SET Bsaskaita = '0', Uniform = '-1', Verslas = '0', Glicenzija = '0', Pakviestas = '0', Aikstele = '0', Cteises = '0', Fteises = '0' , Mteises = '0', Uzbanintas = '0' WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

[16:10:42] >> mysql_query( Connection handle: 1 )

[16:10:42] CMySQLHandler::Query(UPDATE `zaidejai` SET Surakintas = '0', Ikalintas = '0', Vpriziuretojas = '0', Upriziuretojas = '0', Epriziuretojas = '0', Apriziuretojas = '0', Dpriziuretojas = '0', Bakelis = '0' , Meskere = '0', Valas = '0', Telas = '0' WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

[16:10:42] >> mysql_query( Connection handle: 1 )

[16:10:42] CMySQLHandler::Query(UPDATE `zaidejai` SET `Ginklas0` = '0', `Ginklas1` = '0', `Ginklas2` = '0', `Ginklas3` = '0', `Ginklas4` = '0',`Ginklas5` = '0', `Ginklas6` = '0', `Ginklas7` = '0', `Ginklas8` = '0', `Ginklas9` = '0', `Ginklas10` = '0', `Ginklas11` = '0' WHERE (`Vardas` = 'Vitalikas_Slimer')) - Successfully executed.

[16:10:42] >> mysql_query( Connection handle: 1 )

[16:10:42] CMySQLHandler::Query(UPDATE `zaidejai` SET `Ammo0` = '0', `Ammo1` = '0', `Ammo2` = '0', `Ammo3` = '0', `Ammo4` = '0', `Ammo5` = '0',`Ammo6` = '0', `Ammo7` = '0', `Ammo8` = '0', `Ammo9` = '0', `Ammo10` = '0', `Ammo11` = '0' WHERE (`Vardas` = 'Vitalikas_Slimer')) - Successfully executed.

[16:10:48] >> mysql_close( Connection handle: 1 )

[16:10:48] CMySQLHandler::~CMySQLHandler() - deconstructor called.

[16:10:48] CMySQLHandler::FreeResult() - The result is already empty.

[16:10:48] CMySQLHandler::Disconnect() - Connection was closed.

Čia naujai užregistrato nario.

Redaguota Sausio 23, 2014, nario Vitalikas'Slim

[bebras]

Na pirmiausia ši eilutė atrodo baisiai, bet ji veikia ir čia tik šiaip.

Vitalikas_Slimer|viskis|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0

Kaip suprantu išsaugo...

[16:10:41] CMySQLHandler::Query(UPDATE `zaidejai` SET Pinigai = '3000', XP = '0', World = '0', Star = '0', Drabuziai = '3', Mute = '0', Admin = '0', Vip = '0', Pgradmin = '0' , Pinkodas = '0' WHERE Vardas = 'Vitalikas_Slimer') - Successfully executed.

Parodyk krovimą, kad sužinočiau kuri jo užklausa.

[rytukas51]

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

Apie šita kalbėjai? Tika vėl prisijungiau su šitu pat nick ir skin užsidėjo CJ, bet mysl loge rašo jog skin 3 id.

[bebras]

Visą krovimą parodyk.

[rytukas51]

 

 

Redaguota Sausio 25, 2014, nario Vitalikas'Slim

[rytukas51]

Galit rakinti temą. Padėjo Aivaras