#include <a_samp>
#include <a_mysql>
#include <zcmd>

//Mysql
new mydb;
#define DIALOG_REGISTER 1
#define DIALOG_LOGIN 2
enum SpielerInfo {
	pLevel,
	pGeld,
	bool:pLogged
}
new pInfo[MAX_PLAYERS][SpielerInfo];
main()
{
	print("\n----------------------------------");
	print(" Blank Gamemode by your name here");
	print("----------------------------------\n");
}



public OnGameModeInit()
{
	mydb = mysql_connect("127.0.0.1","feef","samp2grgr57869_gfeefetfga","caghjn56g1213");
	SetGameModeText("Blank Script");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
	return 1;
}

public OnGameModeExit()
{
	return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
	SetPlayerPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraPos(playerid, 1958.3783, 1343.1572, 15.3746);
	SetPlayerCameraLookAt(playerid, 1958.3783, 1343.1572, 15.3746);
	return 1;
}
forward UserCheck(playerid);
public UserCheck(playerid)
{
	new num_rows,num_fields;
	cache_get_data(num_rows,num_fields,mydb);
	if(num_rows==0)
	{
	     ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "{00FF00}[Passwort Eingabe - Registrierung]","{FFFFFF}Bitte geben Sie Ihr gewünschtes Passwort ein!\n{FF0000}Bitte zwischen 3 & 25 Zeichen!","Register","Abbrechen"); //register
	}else {
 		 ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{00FF00}[Passwort Eingabe - Login]","{FFFFFF}Bitte geben Sie hier Ihr Passwort ein!\n{FF0000}Um sich in ihr Account einzuloggen!","Login","Abbrechen");      //Login
	}
	return 1;
}
public OnPlayerConnect(playerid)
{
	new query[128],name[MAX_PLAYER_NAME];
	GetPlayerName(playerid,name,sizeof(name));
	format(query,128,"SELECT id FROM user WHERE username = '%s'",name);
	mysql_function_query(mydb,query,true,"UserCheck","i",playerid);
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
	SavePlayer(playerid);
	ResetPlayerVariables(playerid);
	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[])
{
	return 1;
}

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;
}
stock ResetPlayerVariables(playerid)
{
    for(new x; SpielerInfo:x < SpielerInfo; ++x) pInfo[playerid][SpielerInfo:x] = 0;
    return 1;
}
stock SavePlayer(playerid)
{
	new query[128],name[MAX_PLAYER_NAME];
	GetPlayerName(playerid,name,sizeof(name));
	format(query,128,"UPDATE user SET Level = '%d' WHERE username = '%s'",pInfo[playerid][pLevel],name);
	mysql_function_query(mydb,query,false,"","");
	return 1;
}
forward LoadPlayer(playerid);
public LoadPlayer(playerid)
{
	new num_rows,num_fields;
	cache_get_data(num_rows,num_fields,mydb);
	if(num_rows == 1)
	{
		pInfo[playerid][pLogged] = true;
	    pInfo[playerid][pLevel] = cache_get_field_content_int(0,"Level",mydb);
	    SetPlayerScore(playerid,pInfo[playerid][pLevel]);
	}else
	{
	    ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "{00FF00}[Passwort Eingabe - Login]","{FFFFFF}Bitte geben Sie hier Ihr Passwort ein!\n{FF0000}Um sich in ihr Account einzuloggen!","Login","Abbrechen");
		SendClientMessage(playerid,0x00FFC8FF,"Passwort falsch!");
	}
	return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	switch(dialogid)
	{
		case DIALOG_REGISTER:
		{
		    if(response)
		    {
		        new name[MAX_PLAYER_NAME],query[128];
				GetPlayerName(playerid,name,sizeof(name));
				format(query,128,"INSERT INTO user (username,password) VALUES ('%s','%s')",name,inputtext);
				mysql_function_query(mydb,query,false,"","");
			}else{
			    Kick(playerid);
			}
		}
		case DIALOG_LOGIN:
		{
			if(response)
			{
				new name[MAX_PLAYER_NAME],query[254];
				GetPlayerName(playerid,name,sizeof(name));
				format(query,254,"SELECT * FROM user WHERE username = '%s' AND password = '%s'",name,inputtext);
				mysql_function_query(mydb,query,true,"LoadPlayer","i",playerid);
			}else{
			    Kick(playerid);
			}
		}
	}
	return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
	return 1;
}
COMMAND:level(playerid,params[])
{
	pInfo[playerid][pLevel] = 50;
	SavePlayer(playerid);
	return 1;
}