Užkrovimas iš MySQL

[MrMou6]

Sveiki, kodėl pawno neparsisiunčia informacijos iš duombazės su tokiu kodu:

    new Query[128];
    new result[128];
	format(Query,sizeof(Query),"SELECT * FROM `players` WHERE `Vardas` = '%s'",GetPlayerNameEx(playerid));
	mysql_query(Query);
	mysql_store_result();
	mysql_fetch_field_row(result, "pinigai");
	GivePlayerMoney(playerid, strval(result));
	mysql_free_result();

Štai ką rodo logas:
 

[12:22:49] CMySQLHandler::Query(SELECT * FROM `players` WHERE `Vardas` = 'Cristiano_Fernandes') - Successfully executed.

[12:22:49] >> mysql_store_result( Connection handle: 1 )

[12:22:49] CMySQLHandler::StoreResult() - Result was stored.

[12:22:49] >> mysql_fetch_field_row( Connection handle: 1 )

[12:22:49] CMySQLHandler::FetchField(pinigai) - You cannot call this function now. (Reason: Fields/Rows are empty.)

Naudoju MySQL R5

Redaguota Rugpjūčio 14, 2014, nario MrMou6

[Kesa]

new Query[128];

format(Query,sizeof(Query),"SELECT * FROM `players` WHERE `Vardas` = '%s'",GetPlayerNameEx(playerid));

mysql_query(Query);

mysql_store_result();

if(mysql_retrieve_row())

{

new result[50];

mysql_fetch_field_row(result, "pinigai");

GivePlayerMoney(playerid, strval(result));

}

mysql_free_result();

[MrMou6]

Tipo privaloma patikrint ar mysql kažką davė?

if(mysql_retrieve_row()) ?

[Kesa]

Nu tai tarkim jei duomenų bazėj nebus įrašytas žaidėjas(kaip pas tave), tuomet mysql mes error, nes bandys užkrauti tą, ko nėra.

Redaguota Rugpjūčio 14, 2014, nario _kRego

[Tomas]

Nebūtina...

    new Query[128];
    new result[128];
	format(Query,sizeof(Query),"SELECT * FROM `players` WHERE `Vardas` = '%s'",GetPlayerNameEx(playerid));
	mysql_query(Query);
	mysql_store_result();
        mysql_retrieve_row();
	mysql_fetch_field_row(result, "pinigai");
	GivePlayerMoney(playerid, strval(result));
	mysql_free_result();

[MrMou6]

Dabar su mysql viskas gerai:

 

[12:59:40] CMySQLHandler::Query(SELECT * FROM `players` WHERE `Vardas` = 'Cristiano_Fernandes' AND `Slaptazodis` = 'savizudis1') - Successfully executed.

[12:59:40] >> mysql_store_result( Connection handle: 1 )

[12:59:40] CMySQLHandler::StoreResult() - Result was stored.

[12:59:40] >> mysql_num_rows( Connection handle: 1 )

[12:59:40] CMySQLHandler::NumRows() - Returned 1 row(s)

[12:59:40] >> mysql_free_result( Connection handle: 1 )

[12:59:40] CMySQLHandler::FreeResult() - Result was successfully free'd.

 Bet pinigų vistiek neduoda :/

[Kesa]

Duomenų bazėj yra pinigų?

Redaguota Rugpjūčio 14, 2014, nario _kRego

[MrMou6]

kaltas.

 

Bet dabar išviso kai suveikia šitas kodas išsijunge servas, o logas nieko blogo nerodo...

[Kesa]

Įsidėk crashdetect plugin ir parodyk server log.

[MrMou6]

Prisegiau failą, nes ten labai daug teksto

crashinfo.txt

Redaguota Rugpjūčio 14, 2014, nario MrMou6

[Kesa]

ne crashinfo o server log rodyk.

[MrMou6]

[13:24:25] [debug] Server crashed while executing xzx.amx

[13:24:25] [debug] AMX backtrace:

[13:24:25] [debug] #0 native mysql_fetch_field_row () [100065e0] from mysql.dll

[13:24:25] [debug] #1 00001b1c in public LData (0x00000000) from xzx.amx

[13:24:25] [debug] #2 000016bc in public OnDialogResponse (0x00000000, 0x00000001, 0x00000001, 0xffffffff, 0x00001528) from xzx.amx

[13:24:26] [debug] Native backtrace:

[13:24:26] [debug] #0 6fe3b9f0 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.4940_none_50916076bcb9a742\MSVCR90.dll

[13:24:26] [debug] #1 100090b4 in ?? () from plugins\mysql.dll

[13:24:26] [debug] #2 100066b3 in ?? () from plugins\mysql.dll

[13:24:26] [debug] #3 004010b6 in ?? () from samp-server.exe

[13:24:26] [debug] #4 63cf543a in ?? () from plugins\crashdetect.DLL

[13:24:26] [debug] #5 63cf728f in ?? () from plugins\crashdetect.DLL

[13:24:26] [debug] #6 63ce9d54 in ?? () from plugins\crashdetect.DLL

[13:24:26] [debug] #7 63cf548a in ?? () from plugins\crashdetect.DLL

[13:24:26] [debug] #8 0046de11 in ?? () from samp-server.exe

[13:24:26] [debug] #9 00452970 in ?? () from samp-server.exe

[13:24:26] [debug] #10 778d2ce8 in ?? () from C:\Windows\SYSTEM32\ntdll.dll

[13:24:26] [debug] #11 76a170d6 in ?? () from C:\Windows\system32\USER32.dll

[13:24:26] [debug] #12 00499cd9 in ?? () from samp-server.exe

[13:24:26] [debug] #13 0045b39a in ?? () from samp-server.exe

[13:24:26] [debug] #14 1000167f in ?? () from plugins\mysql.dll

[13:24:26] [debug] #15 10007fe8 in ?? () from plugins\mysql.dll

[13:24:26] [debug] #16 004877cb in ?? () from samp-server.exe

[13:24:26] [debug] #17 5c8b01f8 in ?? () from samp-server.exe

[13:24:26] [debug] #18 61750824 in ?? () from samp-server.exe

[Kesa]

Atsisiūsk šitą failą: http://files.g-stylezzz.com/libmySQL.dll Ir įkelk į serverio aplanką.

Redaguota Rugpjūčio 14, 2014, nario _kRego

[MrMou6]

Pas mane buvo libmysql, bet speju kad blogas Dekui