// - Includes
#include <a_samp>
#include <a_mysql>
// - Variaveis
new connect;
new Query[512];
// - Enum
enum aInfo
{
bool:Logged,
Killed,
Died,
Connections,
Money,
Bank
}
new AccountInfo[MAX_PLAYERS][aInfo];
#define SQL_Host "" // Change to your host
#define SQL_User "" // Change to your use
#define SQL_DataBase "" // Change to your database
#define SQL_Password "" // Change to your password
#define TableName "Accounts" // in my case will be 'Accounts' / no meu caso será 'Accounts'
#define DIALOG_REGISTER 0
#define DIALOG_LOGIN 1
// - Forward's
forward MySQL_CheckAccount(playerid);
forward R_@MySQL_CheckAccount(playerid);
forward MySQL_CheckAccountPass(playerid, password[]);
forward R_@MySQL_CheckAccountPass(playerid);
forward MySQL_LoadAccount(playerid);
forward R_@MySQL_LoadAccount(playerid);
forward MySQL_SaveAccount(playerid);
// - CallBacks
public OnFilterScriptInit()
{
connect = mysql_connect(SQL_Host, SQL_User, SQL_DataBase, SQL_Password);
static x;
x = -1;
for(; ++x ^ 3;)
{
if(!connect)
printf("MySQL connection attempt %d failed!", x);
else break;
}
mysql_debug(1);
return 1;
}
public OnFilterScriptExit()
return mysql_debug(0), mysql_close(connect);
public OnPlayerRequestSpawn(playerid)
return (AccountInfo[playerid][Logged] ? 1 : 0);
public OnPlayerConnect(playerid)
{
AccountInfo[playerid][Logged] = false;
AccountInfo[playerid][Killed] = 0;
AccountInfo[playerid][Died] = 0;
AccountInfo[playerid][Connections] = 0;
AccountInfo[playerid][Money] = 0;
AccountInfo[playerid][Bank] = 0;
return MySQL_CheckAccount(playerid);
}
public OnPlayerDisconnect(playerid, reason)
return MySQL_SaveAccount(playerid);
public MySQL_CheckAccount(playerid)
{
format(Query,sizeof(Query),"SELECT * FROM `%s` WHERE Nick='%s'", TableName, _@PlayerName(playerid));
mysql_function_query(connect, Query, true, "R_@MySQL_CheckAccount", "d", playerid);
return 1;
}
public R_@MySQL_CheckAccount(playerid)
{
static rows,fields;
cache_get_data(rows, fields, connect);
if(rows)
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "Login", "Olá vejo que não é novo por aqui,\ndigite sua senha para continuar:", "Logar", "Sair");
else
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, "Registro", "Olá vejo que é novo por aqui,\ndigite uma senha para continuar", "Registrar", "Sair");
return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
switch(dialogid)
{
case 0:
{
if(response)
{
if(!strlen(inputtext))
{
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Registro", "Você ainda não é registrado, \nPor favor digite uma senha:", "Logar", "Sair");
}
format(Query, sizeof(Query), "INSERT INTO `Contas` VALUES ('%s','%s','%d','%d','0','1500','2000');", _@PlayerName(playerid), inputtext, AccountInfo[playerid][Killed], AccountInfo[playerid][Died]);
mysql_function_query(connect, Query, false, "", "", "");
SendClientMessage(playerid, -1, "Registrado com sucesso!");
SetPlayerHealth(playerid, 100);
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "Login", "Parabéns, conta criada com sucesso! \nAgora digite sua senha para continuar:", "Logar", "Sair");
}
else
Kick(playerid);
return 1;
}
case 1:
{
if(response)
{
if(!strlen(inputtext))
{
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Login", "Você ja é registrado, \nPor favor digite sua senha:", "Logar", "Sair");
SendClientMessage(playerid,0xFF0000AA,"Senha incorreta digite-a novamente");
}
MySQL_CheckAccountPass(playerid, inputtext);
}
else
Kick(playerid);
return 1;
}
}
return 1;
}
public MySQL_CheckAccountPass(playerid, password[])
{
format(Query,sizeof(Query),"SELECT * FROM `%s` WHERE Nick='%s' and Pass='%s'", TableName, _@PlayerName(playerid), password);
mysql_function_query(connect, Query, true, "R_@MySQL_CheckAccountPass", "d", playerid);
return 1;
}
public R_@MySQL_CheckAccountPass(playerid)
{
static rows,fields;
cache_get_data(rows, fields, connect);
if(rows)
{
MySQL_LoadAccount(playerid);
AccountInfo[playerid][Connections]++;
MySQL_SaveAccount(playerid);
SendClientMessage(playerid, -1, "Seja bem vindo novamente ao nosso servidor!");
}
else
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_INPUT, "Login", "Senha errada digite a sua senha novamente:", "Logar", "Sair");
return 1;
}
public MySQL_LoadAccount(playerid)
{
format(Query,sizeof(Query),"SELECT * FROM `%s` WHERE Nick='%s'", TableName, _@PlayerName(playerid));
mysql_function_query(connect,Query,true,"R_@MySQL_LoadAccount", "d", playerid);
return 1;
}
public R_@MySQL_LoadAccount(playerid)
{
static rows,fields;
cache_get_data(rows,fields,connect);
if(rows)
{
cache_get_field_content(0,"Money",Query,connect);
AccountInfo[playerid][Money] = strval(Query);
cache_get_field_content(0,"Bank",Query,connect);
AccountInfo[playerid][Bank] = strval(Query);
cache_get_field_content(0,"Killed",Query,connect);
AccountInfo[playerid][Killed] = strval(Query);
cache_get_field_content(0,"Died",Query,connect);
AccountInfo[playerid][Died] = strval(Query);
}
return 1;
}
public MySQL_SaveAccount(playerid)
{
format(Query,sizeof(Query),"UPDATE `%s` SET Money='%d', Bank='%d', Killed='%d', Died='%d', Connections='%d' WHERE Nick='%s'", AccountInfo[playerid][Money], AccountInfo[playerid][Bank], AccountInfo[playerid][Killed], AccountInfo[playerid][Died], _@PlayerName(playerid));
mysql_function_query(connect,Query,false,"","","");
return 1;
}
// - Stocks
_@PlayerName(playerid)
{
new _@pN[24];
GetPlayerName(playerid, _@pN, sizeof(_@pN));
return _@pN;
}
