20.07.2014, 18:39
(
Последний раз редактировалось AlexJuanpere; 22.07.2014 в 19:42.
)
Buenas a todos, mi problema es el siguiente, tengo un sistema de registro Mysql y cuando un usuario se registra, al desconectarse y volver a entrar, pone la contraseсa y aun estando correcta la contraseсa, la toma como incorrecta y tambiйn los usuarios siempre aparecen con 0 de vida, espero que puedan ayudarme, gracias desde ya.
Код HTML:
#include <a_samp> #include <a_mysql> #define MySQL_Servidor "localhost" #define MySQL_Usuario "root" #define MySQL_BD "bdw" #define MySQL_Clave "" #define LOGIN 1 #define REGISTRO 2 main() { } enum pInfo { pPassword[128], pAdmin, pScore, Float:pVida, Float:pChaleco, Float:pPosx, Float:pPosy, Float:pPosz }; new PlayerInfo[MAX_PLAYERS][pInfo]; new Conecction; public OnGameModeInit() { printf("Iniciando conexiуn MySQL: (Servidor: '%s', Usuario: '%s', Clave: '%s', Base de Datos: '%s')", MySQL_Servidor, MySQL_Usuario, MySQL_Clave, MySQL_BD); Conecction = mysql_connect(MySQL_Servidor, MySQL_Usuario, MySQL_BD,MySQL_Clave); if(mysql_ping() == 1) //Comprobamos si se conectу { printf("Conexiуn a la base de datos realizada correctamente."); } else //Caso contrario: { print("Conexiуn a la base de datos no realizada."); mysql_close(); //Cerramos la conexiуn SendRconCommand("exit"); //Cerramos la consola para evitar bug's } return 1; } public OnPlayerConnect(playerid) { CheckPlayer(playerid); return 1; } public OnQueryError(errorid, error[], callback[], query[], connectionHandle ) { printf("[ERROR] ID: %d - Error: %s - Callback - %s - Query: %s", errorid, error, callback, query); //Imprimimos el mensaje en la consola return 1; } forward CheckPlayer(playerid); public CheckPlayer(playerid) { new pName[24], Query[256]; GetPlayerName(playerid, pName, 24); format(Query, sizeof(Query), "SELECT * FROM `usuarios` WHERE Nombre='%s'", pName); mysql_function_query(Conecction, Query, true, "OnQueryFinish", "ii",2, playerid); return 1; } forward OnQueryFinish(resultid, extraid, ConnectionHandle); public OnQueryFinish(resultid, extraid, ConnectionHandle) { new Rows, Field, string[256]; if(resultid != 0) { cache_get_data(Rows, Field); } switch(resultid) { case 1: { if(Rows == 1) { new content[20]; cache_get_field_content(0, "Password", PlayerInfo[extraid][pPassword]); cache_get_field_content(0, "Score", content); PlayerInfo[extraid][pScore] = strval(content); cache_get_field_content(0, "Vida", content); PlayerInfo[extraid][pVida] = floatstr(content); cache_get_field_content(0, "Chaleco", content); PlayerInfo[extraid][pChaleco] = floatstr(content); cache_get_field_content(0, "posX", content); PlayerInfo[extraid][pPosx] = floatstr(content); cache_get_field_content(0, "posY", content); PlayerInfo[extraid][pPosy] = floatstr(content); cache_get_field_content(0, "posZ", content); PlayerInfo[extraid][pPosz] = floatstr(content); SetPlayerPos(extraid,PlayerInfo[extraid][pPosx],PlayerInfo[extraid][pPosy],PlayerInfo[extraid][pPosz]); SetPlayerScore(extraid, PlayerInfo[extraid][pScore]); SetPlayerArmour(extraid, PlayerInfo[extraid][pChaleco]); } else if(!Rows) { // } } case 2: { if(Rows == 1) { new pName[24]; GetPlayerName(extraid, pName, 24); cache_get_field_content(0, "Password", PlayerInfo[extraid][pPassword]); format(string, sizeof(string), "El personaje %s estб registrado en la base de datos. Pon los datos para iniciar sesiуn:", pName); ShowPlayerDialog(extraid, LOGIN, DIALOG_STYLE_PASSWORD,"Login",string,"Enviar","Salir"); } else if(!Rows) { new pName[24]; GetPlayerName(extraid, pName, 24); format(string, sizeof(string), "El jugador %s no estб registrado en el servidor, pon aquн la contraseсa para registrarlo:", pName); ShowPlayerDialog(extraid, REGISTRO, DIALOG_STYLE_PASSWORD,"Registro:",string,"Enviar","Salir"); } } } return 1; } public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[]) { new string[256]; new pName[24], Query[256]; GetPlayerName(playerid, pName, 24); switch(dialogid) { case LOGIN: { if(!response) { Kick(playerid); } if(strcmp(PlayerInfo[playerid][pPassword], inputtext, true, 128) == 0) { format(Query, sizeof(Query), "SELECT * FROM `usuarios` WHERE `Nombre` = '%s'", pName); mysql_function_query(Conecction, Query, true, "OnQueryFinish", "ii", 1, playerid); SetSpawnInfo(playerid,0,0,PlayerInfo[playerid][pPosx], PlayerInfo[playerid][pPosy], PlayerInfo[playerid][pPosz],0,0,0,0,0,0,0); SetPlayerHealth(playerid, PlayerInfo[playerid][pVida]); SetPlayerArmour(playerid, PlayerInfo[playerid][pChaleco]); SetPlayerScore(playerid, PlayerInfo[playerid][pScore]); SpawnPlayer(playerid); } else { SendClientMessage(playerid, -1, "CONTRASEСA INCORRECTA"); Kick(playerid); } } case REGISTRO: { if(!response) { SendClientMessage(playerid, -1, "Kicked"); Kick(playerid); } if(response) { if(!strlen(inputtext)) { Kick(playerid); } new string2[128]; format(string2, sizeof(string2), "%s", inputtext); PlayerInfo[playerid][pPassword] = string2; format(Query, sizeof(Query), "INSERT INTO `usuarios` (Nombre, Contraseсa) VALUES ('%s', '%s')",pName, PlayerInfo[playerid][pPassword]); mysql_function_query(Conecction, Query, true, "OnQueryFinish", "ii", 0, playerid); format(string, sizeof(string), "Has registrado el personaje %s en nuestro servidor.\n\nAhora inicia sesiуn", pName); ShowPlayerDialog(playerid, LOGIN, DIALOG_STYLE_PASSWORD,"Iniciar sesiуn",string,"Enviar","Salir"); } } } return 1; } public OnPlayerDisconnect(playerid, reason) { SaveAccount(playerid); return 1; } forward SaveAccount(playerid);public SaveAccount(playerid) { new query[200];GetPlayerPos(playerid, PlayerInfo[playerid][pPosx], PlayerInfo[playerid][pPosy], PlayerInfo[playerid][pPosz]); new pName[24]; GetPlayerName(playerid, pName, 24); GetPlayerHealth(playerid, PlayerInfo[playerid][pVida]), GetPlayerArmour(playerid, PlayerInfo[playerid][pChaleco]); format(query, 200, "UPDATE `usuarios` SET `Vida`='%f', `Chaleco`='%f', `Admin`='%d', `Score`='%d', `Posx`='%f', `Posy`='%f', `Posz`='%f' WHERE `Nombre`='%s'", PlayerInfo[playerid][pVida], PlayerInfo[playerid][pChaleco], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pScore], PlayerInfo[playerid][pPosx], PlayerInfo[playerid][pPosy], PlayerInfo[playerid][pPosz], pName); mysql_function_query(Conecction, query, true, "OnQueryFinish", "ii", 0, playerid); return 1; }
