[Okrs]

Hola a todos lo que pasa es que tengo mi server con login y registro Mysql Todo esta bien me registro bien pero cuando me voy a loguear se cierra mi samp-server.exe ayuda pls. gracias

[SickAttack]

Publica tu codigo.

[Okrs]

Quote:

Originally Posted by SickAttack Publica tu codigo.

hola bro muchas gracias por contestarme

stock MySQL_Login(playerid)
{
new query[300], pname[24], savingstring[20];
GetPlayerName(playerid, pname, 24);
format(query, sizeof(query), "SELECT * FROM playerdata WHERE user = '%s'", pname);
mysql_query(query);
mysql_store_result();
while(mysql_fetch_row_format(query,"|"))
{
mysql_fetch_field_row(savingstring, "scores"); SetPlayerScore(playerid, strval(savingstring));
mysql_fetch_field_row(savingstring, "money"); GivePlayerMoney(playerid, strval(savingstring));
mysql_fetch_field_row(savingstring, "adminlevel"); PlayerInfo[playerid][pAdmin] = strval(savingstring);
mysql_fetch_field_row(savingstring, "helperlevel"); PlayerInfo[playerid][pHelper] = strval(savingstring);
mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][pKills] = strval(savingstring);
mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][pDeaths] = strval(savingstring);
}
mysql_free_result();
MySQL_vLogin(playerid); //vip log in
PlayerInfo[playerid][pLogged] = 1;
return 1;
}

No se si esto tenga que ver, este es el mysql.log del WAMPSERVER

2015-05-11 14:43:57 5844 [Note] Plugin 'FEDERATED' is disabled.
2015-05-11 14:43:57 5844 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-11 14:43:57 5844 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-11 14:43:57 5844 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-11 14:43:57 5844 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-11 14:43:57 5844 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-11 14:43:57 5844 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-11 14:43:57 5844 [Note] InnoDB: Completed initialization of buffer pool
2015-05-11 14:43:57 5844 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-11 14:43:58 5844 [Note] InnoDB: 128 rollback segment(s) are active.
2015-05-11 14:43:58 5844 [Note] InnoDB: Waiting for purge to start
2015-05-11 14:43:58 5844 [Note] InnoDB: 5.6.17 started; log sequence number 2417873
2015-05-11 14:43:58 5844 [Note] Server hostname (bind-address): '*'; port: 3306
2015-05-11 14:43:58 5844 [Note] IPv6 is available.
2015-05-11 14:43:58 5844 [Note] - '::' resolves to '::';
2015-05-11 14:43:58 5844 [Note] Server socket created on IP: '::'.
2015-05-11 14:43:59 5844 [Note] Event Scheduler: Loaded 0 events
2015-05-11 14:43:59 5844 [Note] wampmysqld: ready for connections.
Version: '5.6.17' socket: '' port: 3306 MySQL Community Server (GPL)

Muchas gracias

[SickAttack]

Mira, esto te servira: https://sampwiki.blast.hk/wiki/MySQL#mysql_fetch_row_format

Creo que el problema es con: while(mysql_fetch_row_format(query,"|"))

[Okrs]

Quote:

Originally Posted by SickAttack Mira, esto te servira: https://sampwiki.blast.hk/wiki/MySQL#mysql_fetch_row_format Creo que el problema es con: while(mysql_fetch_row_format(query,"|"))

Bro gracias pero no he podido solucionar ese problema

[SickAttack]

Prueba esto:

pawn Код:

stock MySQL_Login(playerid)
{
    new query[300], pname[24], savingstring[256];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT * FROM playerdata WHERE user = '%s'", pname);
    mysql_query(query);
    mysql_store_result();

    mysql_fetch_field_row(savingstring, "scores"); SetPlayerScore(playerid, strval(savingstring));
    mysql_fetch_field_row(savingstring, "money"); GivePlayerMoney(playerid, strval(savingstring));
    mysql_fetch_field_row(savingstring, "adminlevel"); PlayerInfo[playerid][pAdmin] = strval(savingstring);
    mysql_fetch_field_row(savingstring, "helperlevel"); PlayerInfo[playerid][pHelper] = strval(savingstring);
    mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][pKills] = strval(savingstring);
    mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][pDeaths] = strval(savingstring);

    mysql_free_result();
    MySQL_vLogin(playerid); //vip log in
    PlayerInfo[playerid][pLogged] = 1;
    return 1;
}

[Okrs]

Quote:

Originally Posted by SickAttack Prueba esto: pawn Код: stock MySQL_Login(playerid) {     new query[300], pname[24], savingstring[256];     GetPlayerName(playerid, pname, 24);     format(query, sizeof(query), "SELECT * FROM playerdata WHERE user = '%s'", pname);     mysql_query(query);     mysql_store_result();     mysql_fetch_field_row(savingstring, "scores"); SetPlayerScore(playerid, strval(savingstring));     mysql_fetch_field_row(savingstring, "money"); GivePlayerMoney(playerid, strval(savingstring));     mysql_fetch_field_row(savingstring, "adminlevel"); PlayerInfo[playerid][pAdmin] = strval(savingstring);     mysql_fetch_field_row(savingstring, "helperlevel"); PlayerInfo[playerid][pHelper] = strval(savingstring);     mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][pKills] = strval(savingstring);     mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][pDeaths] = strval(savingstring);     mysql_free_result();     MySQL_vLogin(playerid); //vip log in     PlayerInfo[playerid][pLogged] = 1;     return 1; }

Sos un duro bro! MUCHAS GRACIAS de verdad! ya se arreglo ! muchas gracias! fuiste el unico que pudo solucionar el problema! estamos en contacto por si algo

Ahora ya m epuedo loguear pero cuando hago cambios en la database en el juego no se guardan los cambios que he hecho en la database