xsL33 scriptt

#include <a_samp>
#include <a_mysql>
#include <ocmd>
#include <sscanf2>
#define Rot 0xC30000FF

//enums
enum playerInfo{
	eingeloggt,
	level
}
new sInfo[MAX_PLAYERS][playerinfo];
//Globale Variablen
new dbhandle;




//Dialoge
#define DIALOG_REGISTER 1
#define DIALOG_LOGIN 2

//MySQL
#define db_host "*zensiert*"
#define db_user "*zensiert*"
#define db_pass "*zensiert*"
#define db_db "*zensiert*

//Forwards
forward OnUserCheck(playerid);
forward OnPasswordResponse(playerid);

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


public OnGameModeInit()
{
	SetGameModeText("Blank Script");
	AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);

	//MYSQL
	dbhandle = mysql_connect(db_host,db_user,db_db,db_pass);
	return 1;
}

public OnGameModeExit()
{
	mysql_close(dbhandle);
	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;
}

public OnPlayerConnect(playerid)
{
	new name[MAX_PLAYER_NAME],query[128];
	GetPlayerName(playerid,name,sizeof(name));
	format(query,sizeof(query),"SELECT id FROM user WHERE username='%s'",name);
	mysql_function_query(dbhandle,query,true,"OnUserCheck","i",playerid);

	return 1;
}
public OnUserCheck(playerid)
{
	new num_rows,num_fields;
	cache_get_data(num_rows,num_fields,dbhandle);
	if(num_rows==0)
	{
	    //Registrierung
	    ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Regstrierung","Gib bitte dein gewünschtes Passwort an:","OK","Abbrechen");
	}
	else
	 	//Login
	 	ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login Vorgang","Gib bitte dein Passwort ein:","OK","Abbrechen");
	}
	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 OnPasswordResponse(playerid)
{
	new num_fields,num_rows;
	chache_get_data(num_rows,num_fields,dbhandle);
	if(num_rows==1)
	{
	    //Passwort richtig
	    sInfo[playerid][eingeloggt] = 1;
	    sInfo[playerid][level] = chache_get_field_content_int(0,"level",dbhandle);
	}
	else
	{
	    //Passwort falsch
	    SendClientMessage(playerid,Rot,"Das eingegebene Passwort ist falsch");
    	ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login Vorgang","Gib bitte dein Passwort ein:","OK","Abbrechen");
	}
	return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
	if(dialogid==DIALOG_LOGIN)
	{
	    if(response)
	    {
	        new name[MAX_PLAYER_NAME],query[128],passwort[25];
	        GetPlayerName(playerid,name,sizeof(name));
	        if(strlen(inputtext)>0)
	        {
	            mysql_escape_string(inputtext,passwort,dbhandle);
	            format(query,sizeof(query),"SELECT * FROM user WHERE username:'%s' AND password='%s'",name,passwort);
	            mysql_function_query(dbhandle,query,true,"OnPasswordResponse","i",playerid);
	        {
	        else
		 	{
	            SendClientMessage(playerid,Rot,"Gib bitte dein Passwort ein!");
	            ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login Vorgang","Gib bitte dein Passwort ein:","OK","Abbrechen");
		 	}
	    }
	    else
	 	{
	        Kick(playerid);
	 	}
	    return 1;
	}
	if(dialogid==DIALOG_REGISTER)
	{
	    if(response)
	    {
		 new name[MAX_PLAYER_NAME],query[128],passwort[25];
		 GetPlayerName(playerid,name,sizeof(name));
		 if(strlen(inputtext)>4)
		 {
		    //registrierungsfunktion
		    mysql_escape_string(inputtext,passwort,dbhandle);
		    format(query,sizeof(query),"INSERT INTO user (username,password) VALUES ('%s','%s' ",name,passwort);
		    mysql_function_query(dbhandle,query,false,"","");
		 }
		 else
		 {
		    //kleiner als 3Zeichen
		    SendClientMessage(playerid,Rot,"Dein Passwort muss mindenstens 5 Zeichen haben!");
		    ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Regstrierung","Gib bitte dein gewünschtes Passwort an:","OK","Abbrechen");

		 }
	    }
	    else
	    {
	        Kick(playerid);
	    }
	    return 1;
	}
	return 1;
}

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