Script

#include <a_samp>
#include <a_mysql>
#include <ocmd>

//========Zugang========\\
#define My_Host "HOST"
#define My_User "USERNAME"
#define MyPass  "PASSWORT"
#define My_DB   "DATENBANKNAME"


//========Farben========\\
#define COLOR_GRUEN 0x00FF1EFF
#define COLOR_ROT 0xFF0005FF
#define COLOR_BLAU 0x0037FFFF
#define COLOR_GELB 0xF5FF00FF
#define COLOR_WEIß 0xFFFFFFE0


//========enums========\\
enum PlayerDaten
{
	pLevel,
	pAdmin,
	pKills
}
new Playerinfo[MAX_PLAYERS][PlayerDaten];

enum
{
	D_REGISTER,
	D_LOGIN
}


#if defined FILTERSCRIPT

public OnFilterScriptInit()
{
	print("\n--------------------------------------");
	print(" Blank Filterscript by your name here");
	print("--------------------------------------\n");
	return 1;
}

public OnFilterScriptExit()
{
	return 1;
}

#else

main()
{
	print("\n----------------------------------");
	print(" Blank Gamemode by your name here");
	print("----------------------------------\n");
}

#endif

public OnGameModeInit()
{
	// Don't use these lines if it's a filterscript
	SetGameModeText("Blank Script");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);



	new query [275];
	format(query,sizeof(query),"CREATE TABLE IF NOT EXISTS 'accounts' ('id' int(11) NOT FULL AUTO INCREMENT, 'Name' varcher(24),'Passwort' varcher(24),'Level' int(11),'Admin' int(11), 'Kills' int(11),PRIMARY KEY ('id')) ENGINE=MyISAM DEFAULT CHARSET=latin1");
	mysql_query(query);

	return 1;
}

public OnGameModeExit()
{
	return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
	if(GetPVarInt(playerid,"logged") == 0)
	{
	    if(mysql_CheckAccount(playerid) == 0)
	    {
			ShowPlayerDialog(playerid,D_REGISTER,DIALOG_STYLE_PASSWORD,"Register","Bitte registriere dich nun!\n","Register","Abbrechen");
	    }
	    else if(mysql_CheckAccount(playerid) == 1)
	    {
	    	ShowPlayerDialog(playerid,D_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Bitte Logge dich ein!","Login","Abbrechen");
	    }
	}
	return 1;
}

public OnPlayerConnect(playerid)
{
	return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
	SpielerSpeichern(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[])
{
	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[])
{
	switch(dialogid)
	{
	    case D_REGISTER:
	    {
	        if(response)
	        {
	            if(strlen(inputtext) == 0)
	            {
	                ShowPlayerDialog(playerid,D_REGISTER,DIALOG_STYLE_PASSWORD,"Register","FEHLER: GEBEN SIE EIN PASSWORT EIN!","Register","Abbrechen");
	            }
	            else
	            {
	                CreateAccount(playerid,inputtext);
	                SetPVarInt(playerid,"logged",1);
	                SpawnPlayer(playerid);
	                return 1;
	            }
	        }
	        else Kick(playerid);
	    }
	    case D_LOGIN:
	    {
	        if(response)
	        {
	            if(strlen(inputtext) == 0)
	            {
	                ShowPlayerDialog(playerid,D_LOGIN,DIALOG_STYLE_PASSWORD,"Login","FEHLER: GEBEN SIE EIN PASSWORT EIN!","Login","Abbrechen");
	            }
	            else
	            {
	                if(!strcmp(inputtext, mysql_ReturnPasswort(SpielerName(playerid)), true))
	                {
	                    SetPVarInt(playerid,"logged",1);
	                    LoadPlayer(playerid);
	                    SpawnPlayer(playerid);
	                    return 1;
	                }
	                else Kick(playerid);
	            }
	        }
	    }
	}
	return 1;
}

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

//========Stocks========\\
Stock C_T_D
{
	mysql_connect(My_Host, My_User, My_DB, My_Pass);
	if(mysql_ping() == 1)
	{
	    print("Mysql konnte sich ERFOLGREICH mit der Datenbank verbinden!");

	}
	else
	{
	    print("Mysql konnte sich NICHT mit der Datenbank verbinden!");
	    mysql_connect(My_Host, My_User, My_DB, MyPass);
		if(mysql_ping() == 1)
		{
		    print("Mysql konnte sich ERFOLGREICH mit der Datenbank verbinden!");
		    return true;
		}
		else
		{
		    print("Mysql fährt den Server herunter!");
		    SendRconCommand("exit");
		    return true;
		}


	}
}

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

stock mysql_CheckAccount(playerid)
{
	new query[128],name[MAX_PLAYER_NAME],count;
	GetPlayerName(playerid,name, MAX_PLAYER_NAME);
	mysql_real_escape_string(name,name);
	format(query,sizeof(query),"SELECT * FROM 'accounts' WHERE 'Name' = '%s'",name);
	mysql_query(query);
	myql_store_result();
	count = mysql_num_rows();
	mysql_free_result();
	return count;
}

stock CreateAccount(playerid,pass[])
{
	new query[256],name[MAX_PLAYER_NAME];
	GetPlayerName(playerid,name, MAX_PLAYER_NAME);
	mysql_real_escape_string(name,name);
	mysql_real_escape_string(pass,pass);
	format(query,sizeof(query),"INSERT INTO 'accounts' ('Name', 'Passwort') VALUES ('%s','%s')",name,pass);
	mysql_query(query);
	return true;
}

stock mysql_ReturnPasswort(Name[])
{
	new query[130];
	mysql_real_escape_string(name,name);
	format(query,sizeof(query),"SELECT 'passwort' FROM 'accounts' WHERE = '%s'",Name);
	mysql_query(query);
	mysql_store_result();
	mysql_fetch_row(get);
	mysql_free_result();
	return get;
}

stock LoadPlayer(playerid)
{
	if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid)
	{
	    new query[500],val[128];
	    format(query,sizeof(query),"SELECT * FROM 'accounts' WHERE 'Name' = '%s'",SpielerName(playerid));
	    mysql_query(query);
	    mysql_store_result();
	    if(mysql_num_rows())
	    {
	        mysql_fetch_field_row("Level",val); PlayerInfo[playerid][pLevel] = strval(val);
	        mysql_fetch_field_row("Admin",val); PlayerInfo[playerid][pAdmin] = strval(val);
	        mysql_fetch_field_row("Kills",val); PlayerInfo[playerid][pKills] = strval(val);

	        SetPlayerScore(playerid,SpielerInfo[playerid][pLevel]);
	    }
	}
	return 1;
}

stock SpielerSpeichern(playerid)
{
	if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid)
	{
		if(GetPVarInt(playerid,"logged") == 1)
	 	{
	        new query[500];
	        format(query,sizeof(query),"UPDATE 'accounts' SET 'Level' = '%d', 'Admin' = '%d', 'Kills' = '%d' WHERE 'Name' = '%s'",PlayerInfo(playerid)[pLevel],PlayerInfo[playerid][pAdmin]
	        PlayerInfo[playerid][pKills],SpielerName(playerid));
	        mysql_query(query);
	 	}
	}
	return 1;
}