Detaljan opis problema: Ja sam pokusao napraviti da se igrac moze registrirati preko servera, ali nikako da mi uspije, pa ako mi netko moze pomoci oko toga.
Dio skripte:
new Pname;
GetPlayerName(playerid, Pname, 24);
new escpname;
mysql_real_escape_string(Pname, escpname);
format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s'", escpname);
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows() != 0)
{
new PIP;
GetPlayerIp(playerid, PIP, 56);
format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s' AND `IP` = '%s'", escpname, PIP);
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows() != 0)
{
new line;
SetPVarInt(playerid, "Logged", 1);
SendClientMessage(playerid, 0x009600AA, "Automatsko logiranje");
if(mysql_fetch_row(line))
{
new data;
new data2;
sscanf(line, "p|ssdddds", data, data, data2, data2, data2, data2, data);
SetPVarInt(playerid, "Kills", data2);
SetPVarInt(playerid, "Logged", 1);
SetPVarInt(playerid, "Deaths", data2);
SetPlayerScore(playerid, data2);
GivePlayerMoney(playerid, data2);
mysql_free_result();
}
}
if(!mysql_num_rows())
{
SendClientMessage(playerid, 0x009600AA, "Ovaj acc je registriran, ulogiraj se");
ShowPlayerDialog(playerid, 14601, DIALOG_STYLE_PASSWORD , "Login", "Acc je registriran logiraj se!, Ulogiraj se", "OK", "Cancel");
}
}
else
{
ShowPlayerDialog(playerid, 14600, DIALOG_STYLE_PASSWORD , "Register", "Ovaj acc nije registriran, Registriraj se!", "OK", "Cancel");
SendClientMessage(playerid, 0x009600AA, "Ovaj acc nije registriran, Registriraj se!");
}
mysql_free_result(); //Frees the result :)if(dialogid == 14600)
{
if(response)
{
if(!strlen(inputtext))
{
ShowPlayerDialog(playerid, 14600, DIALOG_STYLE_PASSWORD , "Register", "Ovaj acc nije registriran, Registriraj se!", "OK", "Cancel");
SendClientMessage(playerid, 0x009600AA, "Ovaj acc nije registriran, Registriraj se!");
}
new PIP;
new Pname;
GetPlayerName(playerid, Pname, 24); //Players name
new escpname;
new escpass;
mysql_real_escape_string(inputtext, escpass);
mysql_real_escape_string(Pname, escpname); //escapes the string so you cant MySQL inject
GetPlayerIp(playerid, PIP, 50); //Players IP
format(Query, sizeof(Query), "INSERT INTO `playerinfo` (`user`, `password`, `kills`, `deaths`, `score`, `money`, IP) VALUES ('%s', '%s', 0, 0, 0, 0, '%s')", escpname, escpass, PIP); //Insert string
mysql_query(Query); //Queries
GameTextForPlayer(playerid, "~g~Registriranje", 2000, 3);
SendClientMessage(playerid, 0x0000D9AA, "Registriran i logiran u acc!");
SetPVarInt(playerid, "Logged", 1);
}
}
if(dialogid == 14601)
{
if(response)
{
new Pname;
GetPlayerName(playerid, Pname, 24);
new escpname;
mysql_real_escape_string(Pname, escpname);
format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s' AND `password` = '%s'", escpname, inputtext);
mysql_query(Query);
mysql_store_result();
if(!mysql_num_rows())
{
SendClientMessage(playerid, 0xF60000AA, "Netocna lozinka!");
SetPVarInt(playerid, "WrongPass", GetPVarInt(playerid, "WrongPass") + 1);
ShowPlayerDialog(playerid, 14601, DIALOG_STYLE_INPUT , "Login", "Acc je registriran logiraj se!, Ulogiraj se", "OK", "Cancel");
if(GetPVarInt(playerid, "WrongPass") == 3)
{
SendClientMessage(playerid, 0xF60000AA, "Pogrijesno si napisao lozinku 3 pita kick!!");
Kick(playerid);
}
}
else
{
new line;
if(mysql_fetch_row(line))
{
new data;
new data2;
sscanf(line, "p|ssdddds", data, data, data2, data2, data2, data2, data);
SetPVarInt(playerid, "Kills", data2);
SetPVarInt(playerid, "Logged", 1);
SetPVarInt(playerid, "Deaths", data2);
SetPlayerScore(playerid, data2);
SetPVarInt(playerid, "MoneyGiven", data2);
SendClientMessage(playerid, 0x0000D9AA, "Logged in!");
mysql_free_result();
}
}
}
}public OnPlayerRequestSpawn(playerid)
{
if(GetPVarInt(playerid, "Logged") == 0)
{
new Pname;
GetPlayerName(playerid, Pname, 24);
new escpname;
mysql_real_escape_string(Pname, escpname);
format(Query, sizeof(Query), "SELECT * FROM `playerinfo` WHERE `user` = '%s'" , escpname);
mysql_query(Query); //Queries
mysql_store_result(); //Stores
if(!mysql_num_rows()) ShowPlayerDialog(playerid, 14600, DIALOG_STYLE_PASSWORD , "Register", "Ovaj acc nije registriran, Registriraj se!", "OK", "Cancel");
else ShowPlayerDialog(playerid, 14601, DIALOG_STYLE_PASSWORD , "Login", "Acc je registriran logiraj se!, Ulogiraj se", "OK", "Cancel");
return 0; //Player won't spawn
}
return 1;
}Neke slike/video za lakse dobivanje pomoci(neobavezno): /