[HELP] Problem with MySQL Registration system - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [HELP] Problem with MySQL Registration system (/showthread.php?tid=577734)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: [HELP] Problem with MySQL Registration system (/showthread.php?tid=577734)
[HELP] Problem with MySQL Registration system - dudu.r.oliveira - 13.06.2015
First, sorry my bad english, but help-me, i don't know what i'm doing wrong, i'm using the Overhaul tutorial to make the system and my code don't show erros, the MySql and Whirlpool neither, but when i login i spawn on the void, with any dialog for login or register, look the pawn compiler, code and server.cfg below:
Code:
Код:
#include <a_samp>
#include <sscanf2>
#include <zcmd>
#include <a_mysql>
//-------------[MY SQL - UCP]-------------
#define MYSQL_HOST "localhost"
#define MYSQL_USER "root"
#define MYSQL_DATABASE "beta_ucp"
#define MYSQL_PASSWORD ""
enum
{
LoginDialog,
RegisterDialog
};
new mysql;
native WP_Hash(buffer[], len, const str[]);
enum PlayerData
{
ID,
Nome[MAX_PLAYER_NAME],
Senha[129],
IP[16],
Admin,
VIP,
Dinheiro,
Float:PosX,
Float:PosY,
Float:PosZ,
Float:PosA
};
new Player[MAX_PLAYERS][PlayerData];
//----------------------------------------
public OnGameModeInit()
{
mysql_log(LOG_ALL);
mysql = mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_DATABASE, MYSQL_PASSWORD);
if (mysql_errno() != 0) {
printf("[MySQL] Conexгo falhou!");
}
else {
printf("[MySQL] Conexгo estabelecida!");
}
//AddPlayerClass(20,2035.3422,1326.9642,10.8203,271.0643,0,0,0,0,0,0);
return 1;
}
public OnPlayerConnect(playerid)
{
new query[128], playername[MAX_PLAYER_NAME];
GetPlayerName(playerid, playername, sizeof(playername));
mysql_format(mysql, query, sizeof(query), "SELECT 'Senha', 'ID' FROM 'accounts' WHERE 'Nome' = '%e' LIMIT 1", playername);
mysql_tquery(mysql, query, "OnAccountCheck", "i", playerid);
return 1;
}
public OnPlayerDisconnect(playerid, reason)
{
new query[128], Float:pos[4];
GetPlayerPos(playerid, pos[0], pos[1], pos[2]);
GetPlayerFacingAngle (playerid, pos[3]);
mysql_format(mysql, query, sizeof(query), "UPDATE `accounts` SET `Dinheiro` = %d, `PosX` = %f, `PosY` = %f, `PosZ` = %f, `PosA` = %f WHERE `ID` = %d",
GetPlayerMoney(playerid), pos[0], pos[1], pos[2], pos[3], Player[playerid][ID]);
mysql_tquery(mysql, query, "", "");
return 1;
}
public OnPlayerSpawn(playerid)
{
SendClientMessage(playerid, -1, "Agora vocк esta jogando");
SetPlayerPos(playerid, Player[playerid][PosX], Player[playerid][PosY], Player[playerid][PosZ]);
SetPlayerFacingAngle(playerid, Player[playerid][PosA]);
return 1;
}
forward OnAccountCheck(playerid);
public OnAccountCheck(playerid)
{
new rows, fields;
cache_get_data (rows, fields, mysql);
if(rows)
{
cache_get_field_content(0, "Senha", Player[playerid][Senha], mysql, 129);
Player[playerid][ID] = cache_get_field_content_int(0, "ID");
ShowPlayerDialog (playerid, LoginDialog, DIALOG_STYLE_INPUT, "Login", "Bem vindo!\nSua conta foi encontrada em nosso banco de dados.\nPor Favor coloque sua senha:", "Login", "Quit");
} else
{
ShowPlayerDialog (playerid, RegisterDialog, DIALOG_STYLE_INPUT, "Register", "Bem vindo!\nSua conta ainda nгo esta registrada.\nPor Favor preencha sua senha para criar a conta.", "Register", "Quit");
}
}
forward OnAccountLoad (playerid);
public OnAccountLoad(playerid)
{
Player[playerid][Admin] = cache_get_field_content_int(0, "Admin");
Player[playerid][VIP] = cache_get_field_content_int(0, "VIP");
Player[playerid][Dinheiro] = cache_get_field_content_int(0, "Dinheiro");
Player[playerid][PosX] = cache_get_field_content_float(0, "PosX");
Player[playerid][PosY] = cache_get_field_content_float(0, "PosY");
Player[playerid][PosZ] = cache_get_field_content_float(0, "PosZ");
Player[playerid][PosA] = cache_get_field_content_float(0, "PosA");
ResetPlayerMoney(playerid);
GivePlayerMoney(playerid, Player[playerid][Dinheiro]);
SendClientMessage(playerid, -1, "You have successfully logged in.");
}
forward OnAccountRegister (playerid);
public OnAccountRegister (playerid)
{
Player[playerid][ID] = cache_insert_id();
printf("[Registration] New account registered. Database ID: [%d]", Player[playerid][ID]);
return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid)
{
case LoginDialog:
{
if(!response) Kick(playerid);
new hashpass[129], query[100], playername[MAX_PLAYER_NAME];
GetPlayerName (playerid, playername, sizeof(playername));
WP_Hash (hashpass, sizeof(hashpass), inputtext);
if (!strcmp(hashpass, Player[playerid][Senha]))
{
mysql_format(mysql, query, sizeof(query), "SELECT * FROM `accounts` WHERE `Nome` = '%e' LIMIT 1", playername);
mysql_tquery(mysql, query, "OnAccountLoad", "i", playerid);
}
else
{
SendClientMessage(playerid, -1, "Senha incorreta!");
ShowPlayerDialog(playerid, LoginDialog, DIALOG_STYLE_INPUT, "Login", "Bem Vindo!\nYour account has been found in our database. Please fill in your password:", "Login", "Quit");
}
}
case RegisterDialog:
{
if(!response) return Kick(playerid);
if(strlen(inputtext) < 5)
{
SendClientMessage (playerid, -1, "Sua senha deve ter mais de 4 caracteres!");
return ShowPlayerDialog(playerid, RegisterDialog, DIALOG_STYLE_INPUT, "Register", "Welcome player!\nYour account has not been registered yet. Please fill in your desired password:", "Register", "Quit");
}
new query[512], playername[MAX_PLAYER_NAME], playerip[16];
GetPlayerName(playerid, playername, sizeof(playername));
GetPlayerIp(playerid, playerip, sizeof(playerip));
WP_Hash(Player[playerid][Senha], 129, inputtext);
mysql_format(mysql, query, sizeof(query), "INSERT INTO `accounts` (`Nome`, `Senha`, `IP`, `Admin`, `VIP`, `Dinheiro`, `PosX`, `PosY`, `PosZ`, `PosA`) VALUES ('%e', '%e', '%e', 0, 0, 0, 0.0, 0.0, 0.0, 0.0)", playername, Player[playerid][Senha], playerip);
mysql_tquery(mysql, query, "OnAccountRegister", "i", playerid);
}
}
return 1;
}
Код:
C:\Downloads\samp037_svr_R1_win32\gamemodes\new.pwn(118) : warning 217: loose indentation C:\Downloads\samp037_svr_R1_win32\gamemodes\new.pwn(404) : warning 217: loose indentation Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 2 Warnings.
http://i.imgur.com/CDiqUrY.png
Server
Код:
SA-MP Dedicated Server ---------------------- v0.3.7, ©2005-2015 SA-MP Team [12:17:34] [12:17:34] Server Plugins [12:17:34] -------------- [12:17:34] Loading plugin: sscanf [12:17:34] [12:17:34] =============================== [12:17:34] sscanf plugin loaded. [12:17:34] Version: 2.8.1 [12:17:34] © 2012 Alex "******" Cole [12:17:34] =============================== [12:17:34] Loaded. [12:17:34] Loading plugin: Whirlpool [12:17:34] [12:17:34] ================== [12:17:34] [12:17:34] Whirlpool loaded [12:17:34] [12:17:34] ================== [12:17:34] [12:17:34] Loaded. [12:17:34] Loading plugin: mysql [12:17:34] >> plugin.mysql: R39-3 successfully loaded. [12:17:34] Loaded. [12:17:34] Loaded 3 plugins. [12:17:34] [12:17:34] Filterscripts [12:17:34] --------------- [12:17:34] Loading filterscript '0.amx'... [12:17:34] Unable to load filterscript '0.amx'. [12:17:34] Loaded 0 filterscripts. [12:17:34] [MySQL] Conexгo estabelecida! [12:17:34] -------------------- [12:17:34] Blank Gamemode by Duh [12:17:34] ---------------------- [12:17:34] Number of vehicle models: 0 [12:18:20] [connection] ***.***.***.***:53006 requests connection cookie. [12:18:21] Incoming connection: ***.***.***.***:53006 id: 0 [12:18:22] [join] Ethan_Davis has joined the server (0:***.***.***.***)
Re: [HELP] Problem with MySQL Registration system - MotherDucker - 13.06.2015
Which lines are the errors on?
You need to make sure that you're indenting your script properly.
Re: [HELP] Problem with MySQL Registration system - dudu.r.oliveira - 13.06.2015
Quote:
|
Originally Posted by MotherDucker
 Which lines are the errors on?
You need to make sure that you're indenting your script properly. |
The code is indented
Re: [HELP] Problem with MySQL Registration system - MotherDucker - 13.06.2015
Quote:
|
Originally Posted by dudu.r.oliveira
It's the problem, don't show any error, but don't work
The code is indented |
If everything is fine, try adding this code at the top of your script.
Код:
#pragma tabsize 0
Re: [HELP] Problem with MySQL Registration system - dudu.r.oliveira - 13.06.2015
Quote:
|
Originally Posted by MotherDucker
What do you mean? It won't show an error in the server_log.txt, it is only a warning which means that it wont affect the server too much however it might cause problems in the future, go over your code and check if it all has indentation.
If everything is fine, try adding this code at the top of your script. Код:
#pragma tabsize 0 |
Re: [HELP] Problem with MySQL Registration system - Yashas - 14.06.2015
This happens if the query failed.
Код:
OnQueryFinish( query[], resultid, extraid, connectionHandle ) OnQueryError( errorid, error[], resultid, extraid, callback[], query[], connectionHandle )
Код:
public OnQueryError( errorid, error[], resultid, extraid, callback[], query[], connectionHandle )
{
printf("[SQL-ERR][%s] EID:%d >>%s",callback,errorid,error);
print(query);
}