Zaloguj się by uzyskać pełen dostęp. Nie masz jeszcze konta? Założ je już teraz w kilka sekund.

Wysłany: 2014-10-11, 09:53


kazami

Pawner/PTG






Wiek: 27
Na forum: 4596 dni
Posty: 405
Nick w MP: adi888

Piwa: 43

Respekt: 76,3

Ostrzeżeń: 80%
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(querysizeof(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(playeridreason)
{
    GetPlayerPos(playeriddane[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(playerid101010);
            if(vdane[playerid][plec] == 1) return SetPlayerSkin(playerid1);
            else SetPlayerSkin(playerid12);
        }    
        else 
        {
            SetPlayerPos(playeriddane[playerid][posX], dane[playerid][posY], dane[playerid][posZ]);
        }
    }


Postaw piwo autorowi tego posta
 

 
Wysłany: 2014-10-11, 09:56


IgrexolonO







Wiek: 34
Na forum: 6809 dni
Posty: 1386

Piwa: 1062

Respekt: 651,8
Respekt: 651,8Respekt: 651,8

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;
}


Postaw piwo autorowi tego posta
 

 
Wysłany: 2014-10-11, 14:15


kazami

Pawner/PTG






Wiek: 27
Na forum: 4596 dni
Posty: 405
Nick w MP: adi888

Piwa: 43

Respekt: 76,3

Ostrzeżeń: 80%
okey dzi?ki temat do zamkni?cia.

Postaw piwo autorowi tego posta
 

 
Tagi: brak :: zapisu :: restarcie :: serwera
Anonymous





Na forum: 245 dni
Posty: 1



Anonymous Koniecznie zajrzyj na:






Skocz do:  
Wyświetl posty z ostatnich:   
GTAONLINE.PL » JĘZYKI PROGRAMOWANIA » PAWN Ten temat jest zablokowany bez możliwości zmiany postów lub pisania odpowiedzi

Nie możesz pisać nowych tematów
Nie możesz odpowiadać w tematach
Nie możesz zmieniać swoich postów
Nie możesz usuwać swoich postów
Nie możesz głosować w ankietach
Dodaj temat do Ulubionych
Wersja do druku