//////////////////////////////////////
///////// MYSQL ENREGISTRATION ///////
//////////////////////////////////////

#include <a_samp>
#include <a_mysql>

#define SQL_HOST "localhost"
#define SQL_USER "root"
#define SQL_PASS ""
#define SQL_DB 	 "comptes"

forward strtok(const string[], &index, const seperator[] = " ");

public OnFilterScriptInit()
{
	MySQLConnect(SQL_HOST,SQL_USER,SQL_PASS,SQL_DB);
	return 1;
}

public OnFilterScriptExit()
{
	return 1;
}


public OnPlayerConnect(playerid)
{
	new query[350] , pNom[25];
    format(query, sizeof(query), "SELECT * FROM  `information_comptes` WHERE nom = '%s' LIMIT 1", pNom);
    mysql_query(query);
    mysql_store_result();
    new existe = mysql_num_rows();
    if(!existe) // Existe pas.
    {
      ShowPlayerDialog(playerid,1, DIALOG_STYLE_INPUT,"Enregistrement", "Salut , vous n'avez pas de compte tappez un mot de passe :", "Enregistrer", "");
    }
    else // Comptes existant.
    {
      ShowPlayerDialog(playerid,2, DIALOG_STYLE_INPUT,"Login", "Salut , Tappez votre mot de passe pour vous login :", "Login", "");
    }
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
	return 1;
}

public OnPlayerSpawn(playerid)
{
	return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
	return 1;
}

public OnVehicleSpawn(vehicleid)
{
	return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
	return 1;
}

public OnPlayerText(playerid, text[])
{
	return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{
	if (strcmp("/mycommand", cmdtext, true, 10) == 0)
	{
		// Do something here
		return 1;
	}
	return 0;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
	return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
	return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
	return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveCheckpoint(playerid)
{
	return 1;
}

public OnPlayerEnterRaceCheckpoint(playerid)
{
	return 1;
}

public OnPlayerLeaveRaceCheckpoint(playerid)
{
	return 1;
}

public OnRconCommand(cmd[])
{
	return 1;
}

public OnPlayerRequestSpawn(playerid)
{
	return 1;
}

public OnObjectMoved(objectid)
{
	return 1;
}

public OnPlayerObjectMoved(playerid, objectid)
{
	return 1;
}

public OnPlayerPickUpPickup(playerid, pickupid)
{
	return 1;
}

public OnVehicleMod(playerid, vehicleid, componentid)
{
	return 1;
}

public OnVehiclePaintjob(playerid, vehicleid, paintjobid)
{
	return 1;
}

public OnVehicleRespray(playerid, vehicleid, color1, color2)
{
	return 1;
}

public OnPlayerSelectedMenuRow(playerid, row)
{
	return 1;
}

public OnPlayerExitedMenu(playerid)
{
	return 1;
}

public OnPlayerInteriorChange(playerid, newinteriorid, oldinteriorid)
{
	return 1;
}

public OnPlayerKeyStateChange(playerid, newkeys, oldkeys)
{
	return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
	return 1;
}

public OnPlayerUpdate(playerid)
{
	return 1;
}

public OnPlayerStreamIn(playerid, forplayerid)
{
	return 1;
}

public OnPlayerStreamOut(playerid, forplayerid)
{
	return 1;
}

public OnVehicleStreamIn(vehicleid, forplayerid)
{
	return 1;
}

public OnVehicleStreamOut(vehicleid, forplayerid)
{
	return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
  if(dialogid == 1)
    {
        if(response)
        {
            if(!strlen(inputtext) || strlen(inputtext) >25)
            {
                ShowPlayerDialog(playerid,1, DIALOG_STYLE_INPUT,"Enregistrement", "vous n'avez pas de compte tappez un mot de passe :", "Enregistrer", "");
            }
            else if(strlen(inputtext) > 0 && strlen(inputtext) < 25)
            {
                new escpass[100];
                mysql_real_escape_string(inputtext, escpass);
                new query[350], pNom[24];
                GetPlayerName(playerid, pNom, 24);
                format(query, sizeof(query), "INSERT INTO information_comptes (nom, password,admin) VALUES('%s' , '%s' , '0')", pNom,inputtext);
                mysql_query(query);

            }
        }
        if(!response)
        {
        		ShowPlayerDialog(playerid,1, DIALOG_STYLE_INPUT,"Enregistrement", "vous n'avez pas de compte tappez un mot de passe :", "Enregistrer", "");
        }
    }
    if(dialogid == 2)
    {
        if(response)
        {
	        new pass[32];
	        new query[250], pNom[24];
            new tmpPass[64],tmp[64],idx;
            GetPlayerName(playerid, pNom, 24);
			mysql_real_escape_string(inputtext,pass);
            tmp = strtok(inputtext, idx);
            strmid(tmpPass, tmp, 0, strlen(inputtext), 255);
            mysql_query(query);
		    mysql_store_result();
	    	format(query, sizeof(query), "SELECT * FROM information_compte WHERE nom = %d LIMIT 1",pNom);
   			mysql_free_result();
        	SpawnPlayer(playerid);
        }
        if(!response)
        {
                ShowPlayerDialog(playerid,2,DIALOG_STYLE_INPUT,"Connexion","Vous avez entré un mauvais mot de passe, merci de réessayer :","Connexion","");
        }
    }
	return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}

public MySQLConnect(sqlhost[], sqluser[], sqlpass[], sqldb[]) // by Luk0r
{
	print("[MYSQL] Welcome ... Connection en cours ...");
	mysql_connect(sqlhost, sqluser, sqldb, sqlpass);
	if(mysql_ping()==1)
	{
		print("[MYSQL] Connection reussie");
		return 1;
	}
	else
	{
		print("[MYSQL] Perte de la connexion, reconnexion en cours ...");
		mysql_connect(sqlhost, sqluser, sqldb, sqlpass);
		if(mysql_ping()==1)
		{
			print("[MYSQL] Reconnexion reussie");
			return 1;
		}
		else
		{
			print("[MYSQL] Impossible de se reconnecter, arret du serveur");
			SendRconCommand("exit");
			return 0;
		}
	}
}
stock strtok(const string[], &index, const seperator[] = " ")
{
	const size = 30;
	new idx = strfind(string, seperator, false, index), result[size];
	if(idx == -1)
	{
		if((idx = strlen(string)) > index)
		strmid(result, string, index, idx, size),index = idx;
	}
	else if(idx > (index + size - 1))
	strmid(result, string, index, (idx = index + size - 1), size), index = idx;
	else strmid(result, string, index, idx, size), index = idx + 1;
	return result;
}