Wysłany: 2014-10-11, 09:53
kazami
Pawner/PTG
Wiek: 27 Na forum: 4596 dni Posty: 405
Nick w MP: adi888
Piwa : 43
Witam mam taki problem ot??: pisz? serwer w mysql wszystko ?adnie zapisuje si? i w czytuje gdy wychodze i wchodze na serwer. ale gdy jestem na serwerze i tam w konsoli "gmx" - restart serwera to gdy sie zaloguje wywala mnie na srodek mapy .
help
logi
Kod:
[09:49]
[09:49] ---------------------------
[09:49] MySQL Debugging activated (10/11/14)
[09:49] ---------------------------
[09:49]
[09:49] >> mysql_ping( Connection handle: 1 )
[09:49] CMySQLHandler::Ping() - Connection is still alive.
[09:49] >> mysql_query( Connection handle: 1 )
[09:49] CMySQLHandler::Query(SELECT * FROM `user` WHERE `username`='adi131') - Successfully executed.
[09:49] >> mysql_store_result( Connection handle: 1 )
[09:49] CMySQLHandler::StoreResult() - Result was stored.
[09:49] >> mysql_num_rows( Connection handle: 1 )
[09:49] CMySQLHandler::NumRows() - Returned 1 row(s)
[09:49] >> mysql_free_result( Connection handle: 1 )
[09:49] CMySQLHandler::FreeResult() - Result was successfully free'd.
[09:49] >> mysql_query( Connection handle: 1 )
[09:49] CMySQLHandler::Query(SELECT `id`, `haslo`, `kasa`, `posx`, `posy`, `posz`, `skin`, `score` FROM `user` WHERE `username`='adi131') - Successfully executed.
[09:49] >> mysql_store_result( Connection handle: 1 )
[09:49] CMySQLHandler::StoreResult() - Result was stored.
[09:49] >> mysql_fetch_row_format( Connection handle: 1 )
[09:49] CMySQLHandler::FetchRow() - Return: 6|adamosek|0|127.394|-75.7764|1.57812|0|0
[09:49] >> mysql_free_result( Connection handle: 1 )
[09:49] CMySQLHandler::FreeResult() - Result was successfully free'd.
[09:50] >> mysql_query( Connection handle: 1 )
[09:50] CMySQLHandler::Query(UPDATE `user` SET kasa = 0, score = 0, posx = 114.855049, posy = -24.300003, posz = 1.469105, skin = 0) - Successfully executed.
[09:50] >> mysql_free_result( Connection handle: 1 )
[09:50] CMySQLHandler::FreeResult() - The result is already empty.
[09:50] >> mysql_close( Connection handle: 1 )
[09:50] CMySQLHandler::~CMySQLHandler() - deconstructor called.
[09:50] CMySQLHandler::FreeResult() - The result is already empty.
[09:50] CMySQLHandler::Disconnect() - Connection was closed.
[09:50] >> mysql_connect( )
[09:50] CMySQLHandler::CMySQLHandler() - constructor called.
[09:50] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "ptg" | Username: "adi888" ...
[09:50] CMySQLHandler::Connect() - Connection was successful.
[09:50] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[09:50]
[09:50] ---------------------------
[09:50] MySQL Debugging activated (10/11/14)
[09:50] ---------------------------
[09:50]
[09:50] >> mysql_ping( Connection handle: 1 )
[09:50] CMySQLHandler::Ping() - Connection is still alive.
[09:50] >> mysql_query( Connection handle: 1 )
[09:50] CMySQLHandler::Query(SELECT * FROM `user` WHERE `username`='adi131') - Successfully executed.
[09:50] >> mysql_store_result( Connection handle: 1 )
[09:50] CMySQLHandler::StoreResult() - Result was stored.
[09:50] >> mysql_num_rows( Connection handle: 1 )
[09:50] CMySQLHandler::NumRows() - Returned 1 row(s)
[09:50] >> mysql_free_result( Connection handle: 1 )
[09:50] CMySQLHandler::FreeResult() - Result was successfully free'd.
[09:50] >> mysql_query( Connection handle: 1 )
[09:50] CMySQLHandler::Query(SELECT `id`, `haslo`, `kasa`, `posx`, `posy`, `posz`, `skin`, `score` FROM `user` WHERE `username`='adi131') - Successfully executed.
[09:50] >> mysql_store_result( Connection handle: 1 )
[09:50] CMySQLHandler::StoreResult() - Result was stored.
[09:50] >> mysql_fetch_row_format( Connection handle: 1 )
[09:50] CMySQLHandler::FetchRow() - Return: 6|adamosek|0|114.855|-24.3|1.46911|0|0
[09:50] >> mysql_free_result( Connection handle: 1 )
[09:50] CMySQLHandler::FreeResult() - Result was successfully free'd.
[09:50] >> mysql_query( Connection handle: 1 )
[09:50] CMySQLHandler::Query(UPDATE `user` SET kasa = 0, score = 0, posx = 0.000000, posy = 0.000000, posz = -38.707542, skin = 0) - Successfully executed.
[09:50] >> mysql_free_result( Connection handle: 1 )
[09:50] CMySQLHandler::FreeResult() - The result is already empty.
Pawn
stock ZapiszGracza ( playerid )
{
new query [ 1024 ];
format ( query , sizeof ( query ), "UPDATE `user` SET kasa = %d, score = %d, posx = %f, posy = %f, posz = %f, skin = %d" ,
GetPlayerMoney ( playerid ), GetPlayerScore ( playerid ), dane [ playerid ][ posX ], dane [ playerid ][ posY ], dane [ playerid ][ posZ ], GetPlayerSkin ( playerid ));
mysql_query ( query );
mysql_free_result ();
return 1 ;
}
Pawn
public OnPlayerDisconnect ( playerid , reason )
{
GetPlayerPos ( playerid , dane [ playerid ][ posX ], dane [ playerid ][ posY ], dane [ playerid ][ posZ ]);
if( GetPVarInt ( playerid , "WszedlNaSerwer" ) == 1 ){ ZapiszGracza ( playerid );}
return 1 ;
}
Pawn
UkryjTextDrawy ( playerid );
if( GetPVarInt ( playerid , "WszedlNaSerwer" ) == 1 )
{
if( vdane [ playerid ][ register ] == true )
{
SetPlayerPos ( playerid , 10 , 10 , 10 );
if( vdane [ playerid ][ plec ] == 1 ) return SetPlayerSkin ( playerid , 1 );
else SetPlayerSkin ( playerid , 12 );
}
else
{
SetPlayerPos ( playerid , dane [ playerid ][ posX ], dane [ playerid ][ posY ], dane [ playerid ][ posZ ]);
}
}
Wysłany: 2014-10-11, 09:56
IgrexolonO
Wiek: 34 Na forum: 6809 dni Posty: 1386
Piwa : 1062
Nic z tym nie zrobisz, umia?by? korzysta? z google, to wiedzia?by? ?e to przeci?tny problem w SRAMPIE.
Napisz w?asn? komende rcon, kt?ra zapisze wszystkie dane i dopiero p??niej zrestartuje serwer. W ko?cu ejste? taki pro elo i lubisz trudne rozwi?zania, prawda?
protip:
Kod: CMD:biedak(playerid, p[])
{
//zapisanie guwien
SendRconCommand("gmx");
return true;
}
Wysłany: 2014-10-11, 14:15
kazami
Pawner/PTG
Wiek: 27 Na forum: 4596 dni Posty: 405
Nick w MP: adi888
Piwa : 43
okey dzi?ki temat do zamkni?cia.
Tagi: brak :: zapisu :: restarcie :: serwera
Anonymous
Na forum: 245 dni
Posty: 1
Anonymous Koniecznie zajrzyj na: