04.06.2012, 09:34
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.
I don't have an account, and when i enter the server it type's me to login my 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( );
