MySQL login help. -
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