Išsijungia serveris kai pradeda krauti žaidėjo informaciją

[Elas]

Sveiki, nesuprantu kodėl pradėjus krauti žaidėjo informaciją serveris išsijungia, printinau, tai serveris nulūžta iškart pradedant krauti pinigus.
 

stock loadPlayer( pid )
{
new Buffer[ 300 ], Info[ 32 ], Float:Koord[ 3 ];
 
format( Buffer,sizeof( Buffer ),"SELECT * FROM "MySQL_PLAYERS_TABLE" WHERE Vardas = '%s'", getPlayerName( pid ) );
mysql_query( Buffer );
mysql_store_result();
print("mysql_store_result();");
 
if( mysql_retrieve_row() )
{
print("if( mysql_retrieve_row() )");
 
mysql_fetch_field_row( Info,"Pinigai" ); setPlayerMoney( pid, strval( Info ) );
print("Pinigai");
mysql_fetch_field_row( Info,"XP" ); setPlayerXp( pid, strval( Info ) );
print("xp");
mysql_fetch_field_row( Info,"Lygis" ); setPlayerLvl( pid, strval( Info ) );
print("lvl");
mysql_fetch_field_row( Info,"Admin" ); setPlayerAdmin( pid, strval( Info ) );
print("admin");
mysql_fetch_field_row( Info,"ID" ); setPlayerSqlID( pid, strval( Info ) );
mysql_fetch_field_row( Info,"Skin" ); SetPlayerSkin( pid, strval( Info ) );
 
print("IDAS");
 
mysql_fetch_field_row( Info,"Pos_X"); Koord[ 0 ] = floatstr( Info );
mysql_fetch_field_row( Info,"Pos_Y"); Koord[ 1 ] = floatstr( Info );
mysql_fetch_field_row( Info,"Pos_Z"); Koord[ 2 ] = floatstr( Info );
SetPlayerPos( pid, Koord[ 0 ], Koord[ 1 ], Koord[ 2 ] );
}
 
mysql_free_result();
return 1;
}

[Andrius P.]

Gal durnas pastebėjimas ir nežinau ar veiks bet pas tave yra setPlayerMoney bet tu pabandyk SetPlayerMoney

[Bicas_Biciuks]

Gal durnas pastebėjimas ir nežinau ar veiks bet pas tave yra setPlayerMoney bet tu pabandyk SetPlayerMoney

Jei nebūtų tokios funkcijos, tiesiog kompiliuojant modifikaciją mestu "Undefined symbol setPlayerMoney bla bla bla"

[Elas]

Čia stockas pas mane setPlayerMoney, čia man nebūtinai su pinigais, kai bet ką pradeda kraut išsijungia.

UP

[bebras]

Įsikelk "crashdetect" ir po sekančio išsijungimo parodyk log.

 

Kurie iš tų print išprintinami?

[Elas]

[20:34:35] [debug] Server crashed while executing Modification.amx
[20:34:35] [debug] AMX backtrace:
[20:34:35] [debug] #0 native mysql_fetch_field_row () from mysql.DLL
[20:34:35] [debug] #1 00015cd8 in ?? (0) from Modification.amx
[20:34:35] [debug] #2 00016e10 in public OnPlayerLogIn (0) from Modification.amx
[20:34:35] [debug] #3 00016bf0 in ?? (0) from Modification.amx
[20:34:35] [debug] #4 00011d44 in ?? (16958060, 16958088, 16958092, 16958096, 16958100, 16941772) from Modification.amx
[20:34:35] [debug] #5 00014cd4 in ?? (0, 0, 1, -1, 16941772) from Modification.amx
[20:34:35] [debug] #6 0000e46c in public OnDialogResponse (0, 0, 1, -1, 16941772) from Modification.amx
[20:34:35] [debug] Native backtrace:
[20:34:35] [debug] #0 62ceb9f0 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.8387_none_5094ca96bcb6b2bb\MSVCR90.dll
[20:34:35] [debug] #1 10009abe in ?? () from plugins\mysql.DLL
[20:34:35] [debug] #2 100067e3 in ?? () from plugins\mysql.DLL
[20:34:35] [debug] #3 004010b6 in ?? () from samp-server.exe
[20:34:35] [debug] #4 6eff62da in ?? () from plugins\crashdetect.DLL
[20:34:35] [debug] #5 6eff8b38 in ?? () from plugins\crashdetect.DLL
[20:34:35] [debug] #6 6eff09c7 in ?? () from plugins\crashdetect.DLL
[20:34:35] [debug] #7 6eff632a in ?? () from plugins\crashdetect.DLL
[20:34:35] [debug] #8 0046e161 in ?? () from samp-server.exe
[20:34:35] [debug] #9 004529e0 in ?? () from samp-server.exe
[20:34:35] [debug] #10 0049a6f9 in ?? () from samp-server.exe

Man išprintina tik šitą: print("if( mysql_retrieve_row() )");, iki tol kol pradedu imt informaciją iš mysql. Palūžta iškart loadinant pinigus ar bet ką kita.

[bebras]

mysql_fetch_field_row crashina kažkodėl. R6 ar R5 yra tokia problema kad kažkodėl kartais jis crashina. Jei nori žinot tiksliau būtent kuris crash'ina, sukurk pawno direktorijoje failą "pawn.cfg" ir į jį įrašyk "-d3". Tada perkompiliuok modifikaciją ir vėl priversk crashinti.

[Elas]

Nelabai čia įmatau tiksliau kur...

 

[20:49:33] [debug] Server crashed while executing Modification.amx
[20:49:33] [debug] AMX backtrace:
[20:49:33] [debug] #0 native mysql_fetch_field_row () from mysql.DLL
[20:49:33] [debug] #1 00015cd8 in ?? (0) from Modification.amx
[20:49:33] [debug] #2 00016e10 in public OnPlayerLogIn (0) from Modification.amx
[20:49:33] [debug] #3 00016bf0 in ?? (0) from Modification.amx
[20:49:33] [debug] #4 00011d44 in ?? (16958060, 16958088, 16958092, 16958096, 16958100, 16941772) from Modification.amx
[20:49:33] [debug] #5 00014cd4 in ?? (0, 0, 1, -1, 16941772) from Modification.amx
[20:49:33] [debug] #6 0000e46c in public OnDialogResponse (0, 0, 1, -1, 16941772) from Modification.amx
[20:49:33] [debug] Native backtrace:
[20:49:33] [debug] #0 62ceb9f0 in ?? () from C:\Windows\WinSxS\x86_microsoft.vc90.crt_1fc8b3b9a1e18e3b_9.0.30729.8387_none_5094ca96bcb6b2bb\MSVCR90.dll
[20:49:33] [debug] #1 10009abe in ?? () from plugins\mysql.DLL
[20:49:33] [debug] #2 100067e3 in ?? () from plugins\mysql.DLL
[20:49:33] [debug] #3 004010b6 in ?? () from samp-server.exe
[20:49:33] [debug] #4 6eff62da in ?? () from plugins\crashdetect.DLL
[20:49:33] [debug] #5 6eff8b38 in ?? () from plugins\crashdetect.DLL
[20:49:33] [debug] #6 6eff09c7 in ?? () from plugins\crashdetect.DLL
[20:49:33] [debug] #7 6eff632a in ?? () from plugins\crashdetect.DLL
[20:49:33] [debug] #8 0046e161 in ?? () from samp-server.exe
[20:49:33] [debug] #9 004529e0 in ?? () from samp-server.exe
[20:49:33] [debug] #10 0049a6f9 in ?? () from samp-server.exe
[20:49:33] [debug] Server crashed while executing Modification.amx
[20:49:33] [debug] AMX backtrace:
[20:49:33] [debug] #0 native mysql_fetch_field_row () from mysql.DLL
[20:49:33] [debug] #1 00015cd8 in ?? (0) from Modification.amx
[20:49:33] [debug] #2 00016e10 in public OnPlayerLogIn (0) from Modification.amx
[20:49:33] [debug] #3 00016bf0 in ?? (0) from Modification.amx
[20:49:33] [debug] #4 00011d44 in ?? (16958060, 16958088, 16958092, 16958096, 16958100, 16941772) from Modification.amx
[20:49:33] [debug] #5 00014cd4 in ?? (0, 0, 1, -1, 16941772) from Modification.amx
[20:49:33] [debug] #6 0000e46c in public OnDialogResponse (0, 0, 1, -1, 16941772) from Modification.amx
[20:49:33] [debug] Native backtrace:
[20:49:33] [debug] #0 77a1ed5b in ?? () from C:\Windows\SYSTEM32\ntdll.dll
[20:49:33] [debug] #1 77a1eb7e in ?? () from C:\Windows\SYSTEM32\ntdll.dll
[20:49:33] [debug] #2 00494611 in ?? () from samp-server.exe
[20:49:33] [debug] #3 0044e0d9 in ?? () from samp-server.exe
[20:49:33] [debug] #4 00458cfc in ?? () from samp-server.exe
[20:49:33] [debug] #5 0045b4ca in ?? () from samp-server.exe
[20:49:33] [debug] #6 1000168f in ?? () from plugins\mysql.DLL
[20:49:33] [debug] #7 10008742 in ?? () from plugins\mysql.DLL
[20:49:33] [debug] #8 0048816b in ?? () from samp-server.exe
[20:49:33] [debug] #9 5c8b01f8 in ?? () from samp-server.exe
[20:49:33] [debug] #10 61750824 in ?? () from samp-server.exe

[bebras]

Hm. Turėjo pasakyt kurioj eilutėj... nebent kažką netaip padarei arba kokį nors seną crashdetect naudoji.

[Elas]

https://github.com/Zeex/samp-plugin-crashdetect/releases naudoju tą naujausia

[bebras]

https://github.com/Zeex/samp-plugin-crashdetect/releases naudoju tą naujausia

Oh well, reiškia kad negerai sekei mano instrukcijas arba tiesiog šį kartą neveikia(dar gali būti dėl to nes crash detect kraunamas vėliau nei MySQL).

 

O kad išspręst problemą, turi pasirinkimą:

• Pereik į normalią MySQL versiją
• Krauk kitaip, pvz su mysql_fetch_row_format

[Elas]

Persidariau ant naujausios mysql versijos, tačiau nepakrauna plugino....
 

SA-MP Dedicated Server
----------------------
v0.3z-R4, (C)2005-2014 SA-MP Team


[16:35:42] filterscripts = ""  (string)
[16:35:42] 
[16:35:42] Server Plugins
[16:35:42] --------------
[16:35:42]  Loading plugin: mysql
[16:35:42]   Failed.
[16:35:42]  Loading plugin: sscanf
[16:35:42] 


[16:35:42]  ===============================


[16:35:42]       sscanf plugin loaded.     


[16:35:42]          Version:  2.8.1        


[16:35:42]    (c) 2012 Alex "Y_Less" Cole  


[16:35:42]  ===============================


[16:35:42]   Loaded.
[16:35:42]  Loading plugin: nativechecker
[16:35:42]   Loaded.
[16:35:42]  Loading plugin: crashdetect
[16:35:42]   CrashDetect v4.15 is OK.
[16:35:42]   Loaded.
[16:35:42]  Loaded 3 plugins.


[16:35:42] 
[16:35:42] Filterscripts
[16:35:42] ---------------
[16:35:42]   Loaded 0 filterscripts.


[16:35:42]    Error: Function not registered: 'orm_create'
[16:35:42]    Error: Function not registered: 'orm_addvar'
[16:35:42]    Error: Function not registered: 'orm_setkey'
[16:35:42]    Error: Function not registered: 'orm_update'
[16:35:42]    Error: Function not registered: 'orm_select'
[16:35:42]    Error: Function not registered: 'orm_errno'
[16:35:42]    Error: Function not registered: 'orm_insert'
[16:35:42]    Error: Function not registered: 'mysql_log'
[16:35:42]    Error: Function not registered: 'mysql_connect'
[16:35:42]    Error: Function not registered: 'mysql_close'
[16:35:42] [debug] Run time error 19: "File or function is not found"
[16:35:42] [debug]  orm_create
[16:35:42] [debug]  orm_addvar
[16:35:42] [debug]  orm_setkey
[16:35:42] [debug]  orm_update
[16:35:42] [debug]  orm_select
[16:35:42] [debug]  orm_errno
[16:35:42] [debug]  orm_insert
[16:35:42] [debug]  mysql_log
[16:35:42] [debug]  mysql_connect
[16:35:42] [debug]  mysql_close
[16:35:42] [debug] Run time error 19: "File or function is not found"
[16:35:42] [debug]  orm_create
[16:35:42] [debug]  orm_addvar
[16:35:42] [debug]  orm_setkey
[16:35:42] [debug]  orm_update
[16:35:42] [debug]  orm_select
[16:35:42] [debug]  orm_errno
[16:35:42] [debug]  orm_insert
[16:35:42] [debug]  mysql_log
[16:35:42] [debug]  mysql_connect
[16:35:42] [debug]  mysql_close
[16:35:42] Script[gamemodes/Modification.amx]: Run time error 19: "File or function is not found"
[16:35:42] Number of vehicle models: 0

UP