[ayuda]sistema de login/registro en Mysql - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Español/Spanish (https://sampforum.blast.hk/forumdisplay.php?fid=29)
+---- Thread: [ayuda]sistema de login/registro en Mysql (/showthread.php?tid=574630)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: Non-English (https://sampforum.blast.hk/forumdisplay.php?fid=9)
+--- Forum: Languages (https://sampforum.blast.hk/forumdisplay.php?fid=33)
+---- Forum: Español/Spanish (https://sampforum.blast.hk/forumdisplay.php?fid=29)
+---- Thread: [ayuda]sistema de login/registro en Mysql (/showthread.php?tid=574630)
[ayuda]sistema de login/registro en Mysql - Okrs - 19.05.2015
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
Re: [ayuda]sistema de login/registro en Mysql - SickAttack - 19.05.2015
Publica tu codigo.
Respuesta: Re: [ayuda]sistema de login/registro en Mysql - Okrs - 19.05.2015
Quote:
|
Originally Posted by SickAttack
 Publica tu codigo.
|
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
Re: [ayuda]sistema de login/registro en Mysql - SickAttack - 19.05.2015
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,"|"))
Respuesta: Re: [ayuda]sistema de login/registro en Mysql - Okrs - 19.05.2015
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,"|")) |
Re: [ayuda]sistema de login/registro en Mysql - SickAttack - 19.05.2015
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;
}
Respuesta: Re: [ayuda]sistema de login/registro en Mysql - Okrs - 19.05.2015
Quote:
|
Originally Posted by SickAttack
Prueba esto:
pawn Код:
|
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