04.08.2015, 16:32
Hello guys, i've start working on my server and i began by doing a Login and Register system, i heard that doing it by mySQL was the best way, but i have no mySQL knowledge so i decided to follow a tutorial and i did so
i followed this tutorial: https://sampforum.blast.hk/showthread.php?tid=305994
I've done everything it was said to do, and i ended up having some errors, i fixed some but now i have some errors that i can't fix
which are:
That's why i would like to ask you for help, and help me fixing the bug!
Here is the code:
Hope you can help me out with this, Thank you !
i followed this tutorial: https://sampforum.blast.hk/showthread.php?tid=305994
I've done everything it was said to do, and i ended up having some errors, i fixed some but now i have some errors that i can't fix
which are:
pawn Код:
C:\Users\xxx\Desktop\SAMP Server\My SAMP Server\gamemodes\Server.pwn(164) : error 017: undefined symbol "mysql_query"
C:\Users\xxx\Desktop\SAMP Server\My SAMP Server\gamemodes\Server.pwn(352) : error 017: undefined symbol "Query"
C:\Users\xxx\Desktop\SAMP Server\My SAMP Server\gamemodes\Server.pwn(352) : error 017: undefined symbol "Query"
C:\Users\xxx\Desktop\SAMP Server\My SAMP Server\gamemodes\Server.pwn(352) : error 029: invalid expression, assumed zero
C:\Users\xxx\Desktop\SAMP Server\My SAMP Server\gamemodes\Server.pwn(352) : fatal error 107: too many error messages on one line
Here is the code:
pawn Код:
#include <a_mysql>
#define mysql_host "localhost"
#define mysql_user "MyUsername"
#define mysql_password "MyPassword"
#define mysql_database "MyDatabase"
#define Regdialog 0
#define Logindialog 1
pawn Код:
enum PlayerInfo
{
Username[23],
Password[24],
Money
}
new pInfo[MAX_PLAYERS][PlayerInfo];
pawn Код:
public OnGameModeInit()
{
SetGameModeText("NFS BETA V0.1.0");
SetTimer("SendMessages", RANDOM_MESSAGE_TIMER, true);
mysql_connect(mysql_host,mysql_user,mysql_database ,mysql_password);
return 1;
}
pawn Код:
public OnPlayerConnect(playerid)
{
new Query[80],pName[24],string[164];
GetPlayerName(playerid,pName,24);
format(Query,sizeof(Query),"SELECT `Username` FROM `Users` WHERE `Username` = '%s' LIMIT 1;",pName);
mysql_query(Query); // line 164
mysql_store_result();
if(mysql_num_rows() != 0)
{
format(string,sizeof(string),"Hey, %s! \nYour account is registered.\nPlease enter the password to log in!",pName);
ShowPlayerDialog(playerid,1,DIALOG_STYLE_INPUT,"Login",string,"Login","");
}
else
{
format(string,sizeof(string),"Hey, %s! \nYour account is not registered. \nPlease register to continue!",pName);
ShowPlayerDialog(playerid,0,DIALOG_STYLE_INPUT,"Register",string,"Register","");
}
mysql_free_result();
return 1;
}
pawn Код:
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
if(dialogid == Regdialog)
{
if(strlen(inputtext) == 0)
{
ShowPlayerDialog(playerid,0,DIALOG_STYLE_INPUT,"Register - Enter your password","You are about to register a new account! \nPlease choose the password for it! \n","Register!","");
}
else
{
new EscapedText[60];
mysql_real_escape_string(inputtext, EscapedText);
format(Query,sizeof(Query),"INSERT INTO `Users` (Username,Password,Money) VALUES ('%s','%s,'0')",GetPName(playerid),EscapedText); // line 352
mysql_query(Query);
SendClientMessage(playerid,COLOR_GREEN,"You have been successfully registered!");
}
}
if(dialogid == Logindialog)
{
if(strlen(inputtext) == 0)
{
ShowPlayerDialog(playerid,0,DIALOG_STYLE_INPUT,"Register - Enter your password","You are about to register a new account! \nPlease choose the password for it! \n","Register!","");
}
else
{
LoginPlayer(playerid,inputtext);
}
}
return 1;
}
pawn Код:
stock LoginPlayer(playerid, const password[])
{
new EscapedText[60];
mysql_real_escape_string(password, EscapedText);
format(Query,sizeof(Query),"SELECT * FROM `Users` WHERE `Username` = '%s' AND `Password` = '%s'",GetPName(playerid),EscapedText);
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows() != 0)
{
SendClientMessage(playerid,green,"You have been logged in!");
LoadStats(playerid);
}
else
{
SendClientMessage(playerid,red,"Wrong password!");
Kick(playerid);
}
mysql_free_result();
return 1;
}
stock LoadStats(playerid)
{
new pName[24],Query[80];
GetPlayerName(playerid,pName,24);
format(Query, sizeof(Query), "SELECT * FROM `Users` WHERE `Username` = '%s' ", pName);
mysql_query(Query);
mysql_store_result();
mysql_fetch_row_format(Query, "|");
sscanf(Query, "e<p<|>s[24]s[23]i>", PlayerInfo[playerid]);
mysql_free_result();
GivePlayerMoney(playerid,PlayerInfo[playerid][Money]);
return 1;
}
