Problem with MySQL registration
#1

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
Reply
#2

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
Reply
#3

Should I build a new registration system?
Reply
#4

who can help to do a new registration system?
Reply
#5

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)