Problem with MySQL registration -
skydux123 - 25.04.2013
Hello I am doing MySQL registration system for my RP server and i have a problem:
When i create new acc server show me log in dialog and the I write password server Kick Me
Code:
Код HTML:
new
Query[ 200 ], fields
;
new rows = cache_get_data(rows,fields);
format( Query,sizeof( Query ),"SELECT * FROM `players` WHERE Vardas = '%s'",GetPlayerNameEx( playerid ) );
mysql_function_query(db,Query,true,"tikrinam","d",playerid);
if( rows == 0 )
{
new
string [ 223 ]
;
format(string, sizeof(string), ""HEX_G"Sveiki "HEX_Y"%s "HEX_G"jūs nesate uћsiregistravęs!\n\nPraљome uћsiregistruoti, įraљę norimą slaptaћodį į duotąjį laukelį.", GetPlayerNameEx(playerid));
ShowPlayerDialog(playerid, 7, DIALOG_STYLE_PASSWORD, ""HEX_Y"Ћaidėjo registracija", string, "Registruotis", "Iљeiti");
}
else
{
new
string [ 223 ];
format(string, sizeof(string), ""HEX_G"Sveiki "HEX_Y"%s "HEX_G"jūs esate uћsiregistravęs!Serveryje dar yra "HEX_Y"%i"HEX_G" laisvų vietų \n\nPraљome prisijungsi, įveskite savo slaptaћodį į duotąjį laukelį.", GetPlayerNameEx(playerid),MAX_PLAYERS-KiekPrisijungusiuZaideju());
ShowPlayerDialog(playerid, 8, DIALOG_STYLE_PASSWORD, ""HEX_Y"Ћaidėjo Prisijungimas", string, "Prisijungti", "Iљeiti");
}
responses
Код HTML:
if( dialogid == 7 ) //Registracija
{
if( response )
{
new query[200],playerName[ MAX_PLAYER_NAME ];
GetPlayerName(playerid,playerName,MAX_PLAYER_NAME);
format(query,200,"INSERT INTO players (Vardas,Slaptazodis) VALUES ('%s','%s')",playerName,inputtext);
mysql_function_query(db,query,false,"SendQuery","");
SendClientMessage(playerid,-1,"Jus uzregistruotas!");
ShowPlayerDialog(playerid,8,DIALOG_STYLE_PASSWORD,"Prisijungimas","Praљome prisijungti","Prisijungti","Atљaukti");
playerDB[playerid][naujokas]=true;
ShowPlayerDialog( playerid, 69, DIALOG_STYLE_MSGBOX, ""HEX_G"Konfiguracijos..."HEX_Y"Lytis", ""HEX_G"Nustatykite savo profilio lyti...", "Vaikinas", "Mergina" );
}
else
{
Kick( playerid );
}
return 1;
}
if( dialogid == 8 ) //Prisijungimas
{
if( response )
{
new
string [ 223 ];
format(string, sizeof(string), ""HEX_G"Sveiki "HEX_Y"%s "HEX_G"jūs esate uћsiregistravęs!Serveryje dar yra "HEX_Y"%i"HEX_G" laisvų vietų \n\nPraљome prisijungsi, įveskite savo slaptaћodį į duotąjį laukelį.", GetPlayerNameEx(playerid),MAX_PLAYERS-KiekPrisijungusiuZaideju());
ShowPlayerDialog(playerid, 1, DIALOG_STYLE_PASSWORD, ""HEX_Y"Ћaidėjo Prisijungimas", string, "Prisijungti", "Iљeiti");
return 1;
}
new
Query[ 250 ], fields
;
new rows = cache_get_data(rows,fields);
format( Query,sizeof( Query ),"SELECT * FROM `players` WHERE Vardas = '%s' AND Slaptazodis = '%s'",GetPlayerNameEx( playerid ),inputtext );
mysql_function_query(db,Query,true,"tikrinam","d",playerid);
if(rows == 0 )
{
if(trylog[playerid] > 2) { SendClientMessage(playerid, 0xFF0000FF, "Norėdamas(-a) atsijungti iљ serverio raљykite /q"); SetTimerEx("KickPlayer", 500, false, "i", playerid); }
trylog[playerid]++;
SendErrorMSG( playerid, " Įvedėte neteisingą slaptaћodį " );
new
string [ 223 ];
format(string, sizeof(string), ""HEX_G"Sveiki "HEX_Y"%s "HEX_G"jūs esate uћsiregistravęs!Serveryje dar yra "HEX_Y"%i"HEX_G" laisvų vietų \n\nPraљome prisijungsi, įveskite savo slaptaћodį į duotąjį laukelį.", GetPlayerNameEx(playerid),MAX_PLAYERS-KiekPrisijungusiuZaideju());
ShowPlayerDialog(playerid, 8, DIALOG_STYLE_PASSWORD, ""HEX_Y"Ћaidėjo Prisijungimas", string, "Prisijungti", "Iљeiti");
}
else
{
SendInfoMSG( playerid, " Prisijungimas sėkmingas" );
playerDB[playerid][authstate]=2;
SetPlayerColor( playerid, 0xFFFFFF00 );
return 1;
}
if( !response )
{
Kick( playerid );
}
return 1;
}
Thanks for help
Re: Problem with MySQL registration -
Ciandlah - 25.04.2013
Seriously, One look at that i knew the answer instantly.
Imma build you a even better system for ya to use, this one is to messy
Re: Problem with MySQL registration -
skydux123 - 25.04.2013
Should I build a new registration system?
Re: Problem with MySQL registration -
skydux123 - 25.04.2013
who can help to do a new registration system?
Re: Problem with MySQL registration -
FunnyBear - 25.04.2013
Did you use that MySQL Tutorial on ******* by xSladeHDx? I tried that, but it messed me all up. So I recommend not to use it, because what he does in the video is wrong.