//==============================================================================
//============================> Includes <======================================
#include <a_samp>
#include <a_mysql>
#include <streamer>
#include <sscanf2>
//==============================================================================
//============================> ServerDaten <===================================
#define ServerName "NewLife-Roleplay"
#define ServerMode "German Roleplay"
#define ServerTag "[NLR]"
#define ServerFarbe ""
#define ServerOwner "Buzzy und Saaltofreak"
#define ServerScripter "Buzzy"
#define ServerCopyright"(c) by Buzzy"
//MySQL
#define SQL_HOST "127.0.0.1"
#define SQL_USER "root"
#define SQL_DATA "samp"
#define SQL_PASS ""
//==============================================================================
//============================> Defines <=======================================
//Dialoge
#define DIALOG_REGISTER (1)
#define DIALOG_LOGIN    (2)

//==============================================================================
//============================> Enums <=========================================
enum SpielerDaten {
	pEingeloggt,
	pLevel,
	pGeld
};
//==============================================================================
//============================> Globare Variabeln <=============================
new Handle;
new sInfo[MAX_PLAYERS][SpielerDaten];


//==============================================================================
//============================> ScriptBeginn <==================================
main() {}
public OnGameModeInit()
{
	SetGameModeText(ServerMode);
	//MySQL
	Connect_To_Database();
	return 1;
}

public OnGameModeExit()
{
	//MySQL
	mysql_close(Handle);
	return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
	return 1;
}

public OnPlayerConnect(playerid)
{
	//MySQL Login/Register
	new query[256];
	format(query, sizeof(query), "SELECT id FROM user WHERE username='%s'", SpielerName(playerid));
	mysql_function_query(Handle, query, true, "OnUserCheck", "i", playerid);
	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)
	{
		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 == DIALOG_REGISTER)
	{
	    if(response)
	    {
			if(strlen(inputtext) >= 5)
			{
			    //Regestrierung
				new query[256], passwort[32];
				mysql_escape_string(inputtext, passwort, Handle);
				format(query, sizeof(query), "INSERT INTO user (username, password) VALUES ('%s', '%s')", SpielerName(playerid), passwort);
				mysql_function_query(Handle, query, false, "", "");
			}
			else
			{
			    SendClientMessage(playerid, -1, "Dein Passwort muss mindestens 5 Zeichen lang sein!");
			    ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""ServerTag"Regestrierung", "Bitte gebe ein Passwort ein:", "Anmelden", "Abbrechen");
			    return 1;
			}
	    }
	    else
	    {
            Kick(playerid);
            return 1;
	    }
	    return 1;
	}
	if(dialogid == DIALOG_LOGIN)
	{
	    if(response)
	    {
			new query[128], passwort[32];
			if(strlen(inputtext) > 0)
			{
			    mysql_escape_string(inputtext, passwort, Handle);
				format(query, sizeof(query), "SELECT * FROM user WHERE username='%s' AND password='%s'", SpielerName(playerid), passwort);
				mysql_function_query(Handle, query, true, "OnPasswortResponse", "i", SpielerName(playerid));
			}
			else
			{
			    //Keine Eingabe
				SendClientMessage(playerid, -1, "Gib bitte dein Passwort ein!");
				ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, ""ServerTag"Login", "Bitte gebe ein Passwort ein:", "Login", "Abbrechen");
				return 1;
			}
	    }
	    else
	    {
	        Kick(playerid);
			return 1;
		}
		return 1;
	}
	return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}
//==============================================================================
//============================> Public's <=======================================
forward OnUserCheck(playerid);
public OnUserCheck(playerid)
{
	new num_rows, num_fields;
	cache_get_data(num_rows, num_fields, Handle);
	if(num_fields == 1)
	{
	    //Registrierung
	    ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_INPUT, ""ServerTag"Regestrierung", "Bitte gebe ein Passwort ein:", "Anmelden", "Abbrechen");
	}
	else
	{
		//Login
        ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, ""ServerTag"Login", "Bitte gebe ein Passwort ein:", "Login", "Abbrechen");
	}
	return 1;
}

forward OnPasswortResponse(playerid);
public OnPasswortResponse(playerid)
{
    new num_rows, num_fields;
	cache_get_data(num_rows, num_fields, Handle);
	if(num_rows == 1)
	{
	    //Passwort richtig
		SpielerLaden(playerid);
	}
	else
	{
	    //Passwort falsch
	    SendClientMessage(playerid, -1, "Das eingegebene Passwort ist falsch!");
	    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, ""ServerTag"Login", "Bitte gebe ein Passwort ein:", "Login", "Abbrechen");
	}
	return 1;
}

//==============================================================================
//============================> Stock's <=======================================
stock Connect_To_Database()
{
    Handle = mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
    if(mysql_errno(Handle) == 0)
    {
		printf("|>MySQL<| - Es konnte Verbindung zur der Datenbank "SQL_DATA" aufgebaut werden");
    }
    else
    {
        printf("|>MySQL<| - Es konnte keine Verbindung aufgebaut werden!");
        SendRconCommand("exit");
    }
	return 1;
}

stock SpielerName(playerid)
{
	new name[MAX_PLAYERS];
	GetPlayerName(playerid,name,sizeof(name));
	return name;
}

stock SpielerLaden(playerid)
{
	sInfo[playerid][pEingeloggt] = 1;
	sInfo[playerid][pLevel] = cache_get_field_content_int(0,"Level",Handle);
	printf("Der Spieler %s hat das Level %i", SpielerName(playerid), sInfo[playerid][pLevel]);
	return 1;
}

stock SpielerSpeichern(playerid)
{
	return 1;
}