//Includes
#include <a_samp>
#include <ocmd>
#include <sscanf2>
#include <a_mysql>

//enums
enum playerInfo{
    eingeloggt,
    level,
    id
}

//Globale Variablen
new dbhandle;
new sInfo[MAX_PLAYERS][playerInfo];


//Farben
#define COLOR_RED 0xFF0000FF
#define COLOR_WHITE 0xFFFFFFFF
#define COLOR_YELLOW 0xFFFF00FF
#define COLOR_GREEN 0x1AFF00FF
#define COLOR_PURPEL 0xB933FFFF

//Dialoge
#define DIALOG_TELEPORT 1
#define DIALOG_REGISTER 2
#define DIALOG_LOGIN 3
#define DIALOG_JOBS 4

//MySQL
#define db_host "127.0.0.1"
#define db_user "root"
#define db_pass ""
#define db_db "samp"

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

//Jobs
new LieferantCar[13];

main()
{

}

public OnGameModeInit()
{
    SetGameModeText("Selfmade");
    AddPlayerClass(1,199.0846,-150.0331,1.5781,359.1443,WEAPON_MP5,500,0,0,0,0);
    AddPlayerClass(2,199.0846,-150.0331,1.5781,359.1443,WEAPON_MP5,500,0,0,0,0);
    AddPlayerClass(3,199.0846,-150.0331,1.5781,359.1443,WEAPON_MP5,500,0,0,0,0);

    //Lieferant
      //Jobs
    //Lieferant
    LieferantCar[0] = CreateVehicle(498,2521.8779,-2118.2900,13.6106,359.5249,1,1,-1); // lieferantcar1
    LieferantCar[1] = CreateVehicle(498,2516.7363,-2118.2874,13.6171,0.5532,1,1,-1); // lieferantcar2
    LieferantCar[2] = CreateVehicle(498,2511.5320,-2117.9082,13.6142,1.1086,1,1,-1); // lieferantcar3
    LieferantCar[3] = CreateVehicle(498,2506.4355,-2117.7617,13.6164,359.9575,1,1,-1); // lieferantcar4
    LieferantCar[4] = CreateVehicle(554,2501.2817,-2118.4673,13.6281,358.5197,1,1,-1); // lieferantcar5
    LieferantCar[5] = CreateVehicle(554,2497.1018,-2118.4321,13.6352,357.2826,1,1,-1); // lieferantcar6
    LieferantCar[6] = CreateVehicle(554,2493.2695,-2118.4602,13.6280,358.9049,1,1,-1); // lieferantcar7
    LieferantCar[7] = CreateVehicle(554,2489.7002,-2118.2939,13.6288,356.8214,1,1,-1); // lieferantcar8
    LieferantCar[8] = CreateVehicle(554,2485.6182,-2118.0796,13.6299,356.2841,1,1,-1); // lieferantcar9
    LieferantCar[9] = CreateVehicle(554,2482.0659,-2118.0706,13.6328,358.7651,1,1,-1); // lieferantcar10
    LieferantCar[10] = CreateVehicle(515,2535.9338,-2092.6985,14.5648,90.0324,1,1,-1); // lieferantcar11
    LieferantCar[11] = CreateVehicle(515,2535.9387,-2086.3108,14.6394,90.0187,1,1,-1); // lieferantcar12
    LieferantCar[12] = CreateVehicle(515,2535.8889,-2098.8782,14.5669,89.3127,1,1,-1); // lieferantcar13
    for(new lfcars=0; lfcars<sizeof(LieferantCar); lfcars++)
    {
        new kzzeichen[11];
        format(kzzeichen,11,"LSJOB-%d",LieferantCar[lfcars]);
        SetVehicleNumberPlate(LieferantCar[lfcars],kzzeichen);
        SetVehicleToRespawn(LieferantCar[lfcars]);
        Create3DTextLabel("Lieferanten Fahrzeug",COLOR_RED, 2521.8779,-2118.2900,13.6106,40.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,199.0846,-150.0331,1.5781);
    SetPlayerCameraPos(playerid, 199.2307,-143.8328,1.5781);
    SetPlayerCameraLookAt(playerid, 199.0846,-150.0331,1.5781);
    SetPlayerFacingAngle(playerid,359.1443);
    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,"Registrierung","Gib bitte dein gewünschtes Passwort an:","Okay","Abbrechen");
    }
    else
    {
        //Login
        ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gibt bitte dein Passwort ein:","Okay","Abbrechen");
    }
    return 1;
}

public OnPlayerConnect(playerid)
{
    new nachricht[128];
    format(nachricht,sizeof(nachricht),"Du bist mit der ID %i verbunden.",playerid);
    SendClientMessage(playerid,COLOR_RED,nachricht);

    //Login/Register
    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;
}

savePlayer(playerid)
{
    if(sInfo[playerid][eingeloggt]==0)return 1;
    //Speichern level,money
    new query[128];
    format(query,sizeof(query),"UPDATE user SET level='%i',money='%i' WHERE id='%i'",sInfo[playerid][level],GetPlayerMoney(playerid),sInfo[playerid][id]);
    mysql_function_query(dbhandle,query,false,"","");
    return 1;
}

resetPlayer(playerid)
{
    sInfo[playerid][level]=0;
    sInfo[playerid][eingeloggt]=0;
    sInfo[playerid][id]=0;
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    savePlayer(playerid);
    resetPlayer(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;
}

//Befehle

ocmd:teleport(playerid,params[])
{
    ShowPlayerDialog(playerid,DIALOG_TELEPORT,DIALOG_STYLE_LIST,"Teleport","Spawn\nFarm","Teleport","Abbrechen");
    return 1;
}

ocmd:pn(playerid,params[])
{
    new pID,text[128];
    if(sscanf(params,"us[128]",pID,text))return SendClientMessage(playerid,COLOR_RED,"INFO: /pn [playerid] [text]");
    SendClientMessage(pID,COLOR_RED,text);
    return 1;
}

ocmd:restart(playerid,params[])
{
    SendRconCommand("gmx");
    return 1;
}

ocmd:test(playerid,params[])
{
    SendClientMessage(playerid,COLOR_RED,"Du hast /test eingegeben.");
    return 1;
}

ocmd:help(playerid,params[])
{
   SendClientMessage(playerid,COLOR_RED,"zu Faul um ein Helpsystem zu erstellen");


}


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;
}

SetPlayerMoney(playerid,money)
{
    ResetPlayerMoney(playerid);
    GivePlayerMoney(playerid,money);
    return 1;
}

public OnPasswordResponse(playerid)
{
    new num_fields,num_rows;
    cache_get_data(num_rows,num_fields,dbhandle);
    if(num_rows==1)
    {
        //Passwort richtig
        sInfo[playerid][eingeloggt] = 1;
        sInfo[playerid][level] = cache_get_field_content_int(0,"level",dbhandle);
        SetPlayerScore(playerid,sInfo[playerid][level]);
        sInfo[playerid][id] = cache_get_field_content_int(0,"id",dbhandle);
        SetPlayerMoney(playerid,cache_get_field_content_int(0,"money",dbhandle));
    }
    else
    {
        //Passwort falsch
        SendClientMessage(playerid,COLOR_RED,"Das eingegebene Passwort ist falsch.");
        ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gibt bitte dein Passwort ein:","Okay","Abbrechen");
    }
    return 1;
}

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
    if(dialogid==DIALOG_LOGIN)
    {
        if(response)
        {
            new name[MAX_PLAYER_NAME],query[128],passwort[35];
            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
            {
                //Keine Eingabe
                SendClientMessage(playerid,COLOR_RED,"Gibt bitte dein Passwort ein.");
                ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gibt bitte dein Passwort ein:","Okay","Abbrechen");
            }
        }
        else
        {
            Kick(playerid);
        }
        return 1;
    }
    if(dialogid==DIALOG_REGISTER)
    {
        if(response)
        {
            new name[MAX_PLAYER_NAME],query[128],passwort[35];
            GetPlayerName(playerid,name,sizeof(name));
            if(strlen(inputtext)>3)
            {
                //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 4 Zeichen
                SendClientMessage(playerid,COLOR_RED,"Dein Passwort muss mindestens 4 Zeichen lang sein.");
                ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Registrierung","Gib bitte dein gewünschtes Passwort an:","Okay","Abbrechen");
            }
        }
        else
        {
            Kick(playerid);
        }
        return 1;
    }
    if(dialogid==DIALOG_TELEPORT)
    {
        if(response)
        {
            if(listitem==0)
            {
                //Spawn
                SetPlayerPos(playerid,199.0846,-150.0331,1.5781);
            }
            if(listitem==1)
            {
                //Farm
                SetPlayerPos(playerid,0.0,0.0,6.0);
            }
        }
        else
        {
            SendClientMessage(playerid,COLOR_RED,"Vorgang abgebrochen.");
        }
        return 1;
    }
    return 1;
}

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