public Plante_load()
{
	new Requete[504], fields[57][MAX_PLAYER_NAME], row[320], total_plante=0;

	format(Requete, sizeof(Requete), "SELECT COUNT(*) FROM therp_plantes");
	mysql_query(Requete);
	mysql_store_result();
	mysql_fetch_row(row);
	total_plante = strval(row);
	mysql_free_result();

	for (new i=1; i<=total_plante; i++)
	{
		format(Requete, sizeof(Requete), "SELECT * FROM therp_plantes WHERE id=%d", i);
		//format(Requete, sizeof(Requete), "SELECT * FROM therp_plantes LIMIT %d,%d", i-1,i);
		mysql_query(Requete);
		mysql_store_result();
		mysql_fetch_row(row);
		split(row, fields, '|');
	    Plante_infos[i][Plante_type] = strval(fields[1]);
		printf(">	%d plantes Plante_type		!", Plante_infos[i][Plante_type]);

		Plante_infos[i][Plante_variete] = strval(fields[2]);
		printf(">	%d plantes Plante_variete		!", Plante_infos[i][Plante_variete]);

		Plante_infos[i][Plante_sexe] = strval(fields[3]);
		printf(">	%d plantes Plante_sexe		!", Plante_infos[i][Plante_sexe]);

		Plante_infos[i][Plante_recolte] = strval(fields[4]);
		printf(">	%d plantes Plante_recolte		!", Plante_infos[i][Plante_recolte]);

		Plante_infos[i][Plante_temps] = strval(fields[5]);
		printf(">	%d plantes Plante_temps		!", Plante_infos[i][Plante_temps]);

		Plante_infos[i][Plante_X] = floatstr(fields[6]);
		printf(">	%d plantes Plante_X		!", Plante_infos[i][Plante_X]);

		Plante_infos[i][Plante_Y] = floatstr(fields[7]);
		printf(">	%d plantes Plante_Y		!", Plante_infos[i][Plante_Y]);

		Plante_infos[i][Plante_Z] = floatstr(fields[8]);
		printf(">	%d plantes Plante_Z		!", Plante_infos[i][Plante_Z]);
		mysql_free_result();

	}

	printf(">	%d Plantes chargés		!", total_plante);
	return 1;
}

public Plante_add(playerid)
{
	new Float:X, Float:Y, Float:Z;
	new Requete[MAX_STRING], result[LITTLE_STRING], newId, string[MAX_STRING];
	new Type, Variete, Sexe, Recolte, Temps;

	GetPlayerPos(playerid, X, Y, Z);

	format(Requete, sizeof(Requete), "SELECT COUNT(*) FROM therp_plantes");
	mysql_query(Requete);

	mysql_store_result();
	mysql_fetch_row(result);

	newId = strval(result) + 1;
	mysql_free_result();

	if(newId >= MAX_PLANTES)
	{
		format(string, sizeof(string), "Vous ne pouvez plus planter, le maxinum de plantes à était atteind ! (Max: %d)", MAX_DROP_GUN);
		SendClientMessage(playerid, COLOR_ERREUR, string);
		return 1;
	}

	format(Requete, sizeof(Requete), "INSERT INTO therp_plantes SET `Type`='%d', `Variete`='%d', `Sexe`='%d', `Recolte`='%d', `Temps`='%d', `X`='%f', `Y`='%f', `Z`='%f' ", Type, Variete, Sexe, Recolte, Temps, X, Y, Z);
	mysql_query(Requete);

	Debug_message(playerid, Requete);

	Plante_infos[newId][Plante_type] = Type;
	Plante_infos[newId][Plante_variete] = Variete;
	Plante_infos[newId][Plante_sexe] = Sexe;
	Plante_infos[newId][Plante_recolte] = Recolte;
	Plante_infos[newId][Plante_temps] = Temps;
	Plante_infos[newId][Plante_X] = X;
	Plante_infos[newId][Plante_Y] = Y;
	Plante_infos[newId][Plante_Z] = Z;

	Total_plante++;
	Plante_anti_flood[playerid] += 1;
	return 1;
}

public PlanteDrogueMature(i)
{
	new Requete[1024], Recolte[16], Sexe[16], Texte[128];

	Plante_infos[i][Plante_recolte] = 1;
	Plante_infos[i][Plante_temps] = 0;
	Delete3DTextLabel(Plante_infos[i][Plante_texte]);

	if(Plante_infos[i][Plante_recolte] == 0) { Recolte = "Non mature"; }
	else if(Plante_infos[i][Plante_recolte] == 1) { Recolte = "Mature"; }

	if(Plante_infos[i][Plante_sexe] == 0) { Sexe = "Mâle"; }
	else if(Plante_infos[i][Plante_sexe] == 1) { Sexe = "Femelle"; }


	if(Plante_infos[i][Plante_type] == 0)
	{
		if(Plante_infos[i][Plante_recolte] == 0)
		{

			format(Texte,sizeof(Texte),"{FFFFFF}(%d){00A400}Plant de cannabis\n{FFFFFF}%s\n{FFFFFF}%s",i,Recolte,Sexe);
			Plante_infos[i][Plante_texte] = Create3DTextLabel(Texte, 0xFFFFFFAA, Plante_infos[i][Plante_X],Plante_infos[i][Plante_Y],Plante_infos[i][Plante_Z], 5.0, 0,0);
		}
		else
		{
  			format(Texte,sizeof(Texte),"{FFFFFF}(%d){00A400}Plant de cannabis\n{FFFFFF}%s\n{FFFFFF}%s",i,Recolte,Sexe);
			Plante_infos[i][Plante_texte] = Create3DTextLabel(Texte, 0xFFFFFFAA, Plante_infos[i][Plante_X],Plante_infos[i][Plante_Y],Plante_infos[i][Plante_Z], 5.0, 0,0);
		}
	}
	else
	{
		if(Plante_infos[i][Plante_recolte] == 0)
	  	{
			format(Texte,sizeof(Texte),"{FFFFFF}(%d){F6E497}Plant de coca\n{FFFFFF}%s\n{FFFFFF}%s",i,Recolte,Sexe);
			Plante_infos[i][Plante_texte] = Create3DTextLabel(Texte, 0xFFFFFFAA, Plante_infos[i][Plante_X],Plante_infos[i][Plante_Y],Plante_infos[i][Plante_Z], 5.0, 0,0);
		}
		else
		{
			format(Texte,sizeof(Texte),"{FFFFFF}(%d){F6E497}Plant de coca\n{FFFFFF}%s\n{FFFFFF}%s",i,Recolte,Sexe);
			Plante_infos[i][Plante_texte] = Create3DTextLabel(Texte, 0xFFFFFFAA, Plante_infos[i][Plante_X],Plante_infos[i][Plante_Y],Plante_infos[i][Plante_Z], 5.0, 0,0);
		}
	}
	//
	format(Requete, sizeof(Requete),"UPDATE therp_plantes SET `Recolte`='%d', `Temps`='%d' WHERE id=%d",

	Plante_infos[i][Plante_recolte],
	Plante_infos[i][Plante_temps],
	i);
	mysql_query(Requete);
	//
	return 1;
}