#include <a_samp>
#include <sscanf2>
#include <a_mysql>

main()
{

	print("GM -> Loaded");

}

enum playerInfo {

	pName[MAX_PLAYER_NAME],
	password[126]

}

new pInfo[MAX_PLAYERS][playerInfo];

public OnGameModeInit()
{

	/* SQL CONNECTION INITIATED */
	mysql_connect( "localhost", "root", "adv-cnr", "" );

	/* SERVER SETUP BEGIN */
	SetGameModeText("GameMode");
	ShowPlayerMarkers(1);
	ShowNameTags(1);

	AddPlayerClass(265,1958.3783,1343.1572,15.3746,270.1425,0,0,0,0,-1,-1);

	return 1;
}

public OnPlayerConnect(playerid)
{
	
	new query[126], playerName[MAX_PLAYER_NAME];

	GetPlayerName( playerid, playerName, sizeof( playerName ) );

	format( query, sizeof( query ), "SELECT * FROM accounts WHERE name = '%s'", playerName );

	mysql_query( query );
	mysql_store_result();

	if ( mysql_num_rows() == 1 ) {

		SendClientMessage( playerid, -1, "That username is registered." );

		ShowPlayerDialog( playerid, 0, DIALOG_STYLE_INPUT, "Login", "Please login with the password you made.", "Login", "Cancel" );

	} else {

		SendClientMessage( playerid, -1, "That username is not registered. You may register it." );

		ShowPlayerDialog( playerid, 1, DIALOG_STYLE_INPUT, "Register", "Please enter a password you will remember for your account.", "Register", "Cancel" );

	}

	return 1;
}

public OnPlayerDisconnect( playerid, reason ) {

	SavePlayer( playerid );

	return 1;

}

public OnPlayerSpawn(playerid)
{

	SetPlayerInterior(playerid,0);
	TogglePlayerClock(playerid,0);
	return 1;

}

public OnPlayerDeath(playerid, killerid, reason)
{

   	return 1;

}

SetupPlayerForClassSelection(playerid)
{

 	SetPlayerInterior(playerid,14);
	SetPlayerPos(playerid,258.4893,-41.4008,1002.0234);
	SetPlayerFacingAngle(playerid, 270.0);
	SetPlayerCameraPos(playerid,256.0815,-43.0475,1004.0234);
	SetPlayerCameraLookAt(playerid,258.4893,-41.4008,1002.0234);

}

public OnPlayerRequestClass(playerid, classid)
{

	SetupPlayerForClassSelection(playerid);
	return 1;

}

public OnDialogResponse( playerid, dialogid, response, listitem, inputtext[] ) {

	switch(dialogid) {

		case 0 : {

			if ( response ) {

				new query[126], playerName[MAX_PLAYER_NAME];

				GetPlayerName( playerid, playerName, sizeof( playerName ) );

				format ( query, sizeof( query ), "SELECT * FROM accounts WHERE name = '%' AND password = '%s'", playerName, inputtext );

				mysql_query( query );
				mysql_store_result();

				if ( mysql_num_rows() == 1 ) {

					LoginPlayer( playerid );

					SendClientMessage( playerid, -1, "You have successfully signed in." );

				} else {

					SendClientMessage( playerid, -1, "The password you have entered is not correct." );

					ShowPlayerDialog( playerid, 0, DIALOG_STYLE_INPUT, "Login", "Please login with the password you made.", "Login", "Cancel" );

				}

			}

		}

		case 1 : {

			if ( response ) {

				new query[126], playerName[MAX_PLAYER_NAME];

				GetPlayerName( playerid, playerName, sizeof( playerName ) );

				format ( query, sizeof( query ), "INSERT INTO accounts VALUES ('%s', '%s')", playerName, inputtext );

				mysql_query( query );

				SendClientMessage( playerid, -1, "You have successfully registered your account." );

				SpawnPlayer( playerid );

			}

		}

	}

	return 1;

}

stock LoginPlayer( playerid ) {

	new query[126], playerName[MAX_PLAYER_NAME];

	GetPlayerName( playerid, playerName, sizeof( playerName ) );

	format ( query, sizeof( query ), "SELECT * FROM accounts WHERE playerName = '%s'", playerName );

	mysql_query( query );
	mysql_store_result();

	while( mysql_fetch_row_format( query, "|" ) ) {

		mysql_fetch_field_row( pInfo[playerid][pName], "playerName" );
		mysql_fetch_field_row( pInfo[playerid][password], "password" );

	}

	SpawnPlayer( playerid );

}

stock SavePlayer( playerid ) {

	new query[126], playerName[MAX_PLAYER_NAME];

	GetPlayerName( playerid, playerName, sizeof( playerName ) );

	format ( query, sizeof( query ), "UPDATE accounts SET playerName = '%s', password = '%s' WHERE playerName = '%s'", playerName, pInfo[playerid][password], playerName );

	mysql_query( query );
	
	printf( "Player - %s (%d) has been saved.", playerName, playerid );

}