MySQL login help.
#1

Hi, i try to put my gamemode to mysql, but i have a problem when a player need to register and don't have account.

Code:
new pField[ 19 ], Query[ 300 ];
	
	format( Query, sizeof( Query ), "SELECT IP FROM `accounts` WHERE Name = '%s' LIMIT 1", PlayerName( playerid ) );
	mysql_query( Query );
	mysql_store_result( );
	
	new sqlrows = mysql_num_rows( );
	if ( !sqlrows )
	{
	    format( gsString, sizeof( gsString ), "{00FF00}ENG:\n{FF9900}Hi {33CCFF}%s {FF9900}this server uses an romanian/english gamemode, and are\n\
											   needed to select your language!\n\
											   {33CCFF}NOTE: {FF9900}When you select now language you don't must select it when you spawn.\n\
											   Also, you can change your language by typing {33CCFF}/eng {FF9900}or {33CCFF}/ro\n\n\n", PlayerName( playerid ) );
		format( gsString, sizeof( gsString ), "%s{00FF00}RO:\n{FF9900}Buna {33CCFF}%s {FF9900}acest server foloseste un gamemode facut in 2 limbi, romana si engleza\n\
											   si este nevoie sa selectati limba!\n\
											   {33CCFF}NOTA: {FF9900}Cand iti selectezi limba, nu va mai trebuii sa o faci de fiecare data cand te spawmezi.\n\
											   De asemenea, o poti schimba prin simplele comenzi {33CCFF}/eng {FF9900}sau {33CCFF}/ro\n\n", gsString, PlayerName( playerid ) );
		format( gsString, sizeof( gsString ), "%s{33CCFF}ENG: {FF0000}Please select now your language to we can procced to next steps:\n\
											   {33CCFF}RO: {FF0000}Selecteaza limba care iti este mai usoara:", gsString );
		ShowPlayerDialog( playerid, DIALOG_LANGUAGE, DIALOG_STYLE_MSGBOX, "{FF0000}#1 {FFFFFF}Select Language", gsString, "Romanian", "English" );
	}
	if ( sqlrows == 1 )
	{
		mysql_fetch_field_row( pField, "IP" );
        if ( !strcmp( GetPlayerIPEx( playerid ), pField, true ) )
        {
            LoginPlayer( playerid );

			if ( PlayerInfo[ playerid ][ Level ] > 0 )
	            FormatMSG( playerid, 0x00FF00FF, "ACCOUNT: You have been automatically logged in. (Level {FF9900}%d{00FF00}). For more stats type {FF9900}/stats", PlayerInfo[ playerid ][ Level ] );
           	else
			   	SendClientMessage( playerid, 0x00FF00FF, "ACCOUNT: You have been automatically logged in." );
        }
        else SendClientMessage( playerid, 0x00FF00FF, "ACCOUNT: This nickname is registed, you can now login by typing /login.");
	}
	mysql_free_result( );
I don't have an account, and when i enter the server it type's me to login my account
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)