Mysql-Gamemode

// Query manuell ausführen
// CREATE TABLE IF NOT EXISTS `accounts` (`id` int(11), `username` varchar(30), `password` varchar(128), `Erfahrung` int(128), `Geld` int(11), `Kills` int(11), `Tode` int(11), `Health` float(20), `Admin` int(11), `Bank` int(11), `Fraktion` int(11), `Rang` int(11),
// `Job` int(11), `Mietid` int(11), `Öl` int(11), `Apfelkern` int(11), `Apfel` int(11), `Hanf` int(11), `JobBusfahrer` int(11), `JobErzsammler` int(11), `JobFarmer` int(11), `JobTrucker` int(11), `JobPilot` int(11), `JobMuelmann` int(11), `JobPizzalieferant` int(11), `JobFischer` int(11), `JobWaffendealer` int(11), `JobReiniger` int(11), `Skin` int(11), `Materialien` int(11), `Pizza` int(11), `Spielminuten` int(11), `Spielstunden` int(11), PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;



#include <a_samp>
#include <a_mysql>

#define dcmd(%1,%2,%3) if ((strcmp((%3)[1], #%1, true, (%2)) == 0) && ((((%3)[(%2) + 1] == 0) && (dcmd_%1(playerid, "")))||(((%3)[(%2) + 1] == 32) && (dcmd_%1(playerid, (%3)[(%2) + 2]))))) return 1

//Mysql
#define SQL_HOST   "127.0.0.1"
#define SQL_USER   "root"
#define SQL_PASS   ""
#define SQL_DATA   "samp_db"

//Timer
forward Save(playerid);
forward Payday(playerid);
forward Ernten();

//Haussystem
forward LoadHouse(number);
forward UpdateHouse(number);

//Text
new Text:Anzeige[MAX_PLAYERS];

//Farben
#define Rot 0xFF0000FF
#define Gelb 0xFFFF00FF
#define Blau 0x0080FFFF
#define Grün 0x00D700FF
#define Orange 0xFF8000FF
#define Weiß 0xFFFFFFFF
#define Schwarz 0xFF000000
#define Lila 0xFF00FFFF
#define Hellblau 0x62B0FFFF
#define Hellgrün 0x00D200FF
#define Dunkelgrün 0x1D5414F
#define Grau 0x808080FF
#define Haut 0xFFD157FF
#define Rosa 0xFF39FFFF
#define COLOR_ATM 0xFFD157FF

//Dialoge
#define DIALOG_REGISTER (1)
#define DIALOG_LOGIN (2)
#define MietCarBuy  3
#define MietcarControl 4
#define Hausmenue   5
#define HausmenueBesucher   6
#define HausmenueBesucherPreis  7
#define HausmenueInteriors  8
#define HausMenueAbgeben    9
#define LoadOel 10
#define SellOel 11
#define Apfelbaumz  12
#define AutohausPreis 13
#define AutohausCreate 14
#define AutohausCreateZ 15
#define AutohausKauf 16
#define AutohausKaufz 17
#define Atmmenue 18
#define AtmmenueEinzahlung 19
#define AtmmenueAuszahlung 20
#define AtmmenueUeberweisung 21
#define AtmmenueKontostand 22
#define AtmmenueUeberweisung2 23
#define AtmmenueEinzahlungText 24
#define AtmmenueAuszahlungText 25
#define UeberweisungText1 26
#define OrdnungsamtTicket 27
#define OrdnungsamtFreikaufen 28
#define RepairAnfrage 29
#define RefillAnfrage 30
#define JobBusfahrer 31
#define JobErzsammler 32
#define JobFarmer 33
#define JobTrucker 34
#define JobPilot 35
#define JobMuelmann 36
#define JobReiniger 37
#define newinterior 38

//MAX
#define MAX_SERVER_CARS 500
#define MAX_FRAKTION_CARS 500
#define MAX_MIET_CARS 500
#define MAX_JOB_CARS 500
#define MAX_SPIELER_CARS 500
#define MAX_PICKUP 500
#define MAX_INTERIOR 500
#define MAX_FRAKTION 500
#define MAX_SPAWN 500
#define MAX_HAUS 500
#define MAX_TANKE 50
#define MAX_ATM 50
#define MAX_APFEL 100
#define MAX_BESTELLUNG 50
#define MAX_CONFIG 20
#define MAX_BOMBE 50

//Jobs
new BusfahrerJob[128];
new ErzsammlerJob[128];
new FarmerJob[128];
new TruckerJob[128];
new PilotJob[128];
new MuelmannJob[128];
new ReinigerJob[128];

//Bank
new Ueberweiser[MAX_PLAYERS] ={-1,...};

//Motor
new enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez;
new bool:Motor[MAX_VEHICLES]=false;

//Tank
#define VERLUST 20000 // Die Zeit, die der Motor braucht um 1 Liter zu verbrennen in Millisekunden (Hier 10 Sekunden)
forward BenzinVerlust(); // Wir forwarden unseren Timer für den Benzinverlust
forward Auftanken(playerid); // Wir forwarden unseren Timer für das Tanken
new Tank[MAX_VEHICLES], bool:TanktGerade[MAX_VEHICLES]=false, tanktimer[MAX_PLAYERS];

//SpielerDaten
enum SpielerDaten
{
    pName[MAX_PLAYER_NAME],
    pAdmin,
    pLevel,
    pSpielminuten,
    pSpielstunden,
    pSpielexp,
    pGeld,
    pBank,
    pKills,
    pTode,
    pAfk,
    pFraktion,
    pFraktionz,
    pRang,
    pJob,
    pJobkling,
    pVehicle,
    pMietid,
    pOel,
    pAutocreate,
    pApfelkern,
    pApfel,
    pKirschkern,
    pKirschen,
    pHanfkern,
    pHanf,
    pBombe,
    pColor[128],
    pJobaktive,
    pJobBusfahrer,
    pJobErzsammler,
    pJobFarmer,
    pJobTrucker,
    pJobPilot,
    pJobMuelmann,
    pJobPizzalieferant,
    pJobPizza,
    pJobFischer,
    pJobWaffendealer,
    pJobMaterialien,
    pJobMaterialienz,
    pJobReiniger,
    pBootschein,
    pTransporterschein,
    pBikeschein,
    pFlugschein,
    pFuehrerschein,
    pSpielerCarStatus,
    Float:pHealth
}
new sSpieler[MAX_PLAYERS][SpielerDaten];

//ServerCars
enum ServerCars
{
    sCarID,
    sModelID,
    Float:sX,
    Float:sY,
    Float:sZ,
    Float:sA,
    sColor1,
    sColor2
}
new ServerVeh[MAX_SERVER_CARS][ServerCars];
new ServerVehIDX=0;

//FraktionCars
enum FraktionCars
{
    fCarID,
    fModelID,
    FrakID,
    Float:sX,
    Float:sY,
    Float:sZ,
    Float:sA,
    sColor1,
    sColor2
}
new FrakCars[MAX_FRAKTION_CARS][FraktionCars];
new FrakVehIDX=0;

//MietCars
enum MietenCars
{
    MietCarID,
    MietModelID,
    Float:mX,
    Float:mY,
    Float:mZ,
    Float:mA,
    mColor1,
    mColor2,
    Preis,
    Besitzer
}
new MietCars[MAX_MIET_CARS][MietenCars];
new MietVehIDX=0;

//JobCars
enum JobenCars
{
    JobCarID,
    JobModelID,
    JobID,
    Float:jX,
    Float:jY,
    Float:jZ,
    Float:jA,
    jColor1,
    jColor2
}
new JobCars[MAX_JOB_CARS][JobenCars];
new JobVehIDX=0;

//SpielerCars
enum SPCars
{
    SpielerCarID,
    SpielerModelID,
    SpielerID[128],
    SpielerPreis,
    SpielerStatus,
    Float:sX,
    Float:sY,
    Float:sZ,
    Float:sA,
    sColor1,
    sColor2
}
new SpielerCars[MAX_SPIELER_CARS][SPCars];
new SpielerVehIDX=0;

//CarConfig
enum config
{
    ConfigCarID,
    ConfigModelID,
    ConfigPreisID,
    ConfigStahlID
}
new CarConfig[MAX_CONFIG][config];
new CarConfigIdIDX=0;

//Pickups
enum Pickup
{
    Pickid,
    Modelid,
    Float:X,
    Float:Y,
    Float:Z
}
new Pickups[MAX_PICKUP][Pickup];
new PickIdIDX=0;

//Interiors
enum Interior
{
    InteriorID,
    InteriorIDs,
    InteriorVW,
    Float:InteriorEinX,
    Float:InteriorEinY,
    Float:InteriorEinZ,
    Float:InteriorAusX,
    Float:InteriorAusY,
    Float:InteriorAusZ
}
new Interiors[MAX_INTERIOR][Interior];
new IntIdIDX=0;

//Häuser
enum house
{
    Hausid,
    Besitzer[128],
    Preis,
    Preisz,
    Interiorz,
    InBesitz,
    Verschlossen,
    Float:hx,
    Float:hy,
    Float:hz,
    Float:hix,
    Float:hiy,
    Float:hiz
}
new Haus[MAX_HAUS][house];
new HausIdIDX=0;
new HausIdIDXz=0;

//Fraktionen
enum fraktion
{
    FraktionID,
    FraktionName[128],
    FraktionKasse,
    FraktionMitglieder
}
new Fraktionen[MAX_FRAKTION][fraktion];
new FrakIdIDX=0;

//FraktionSpawns
enum spawns
{
    FrakID,
    FrakColor[128],
    Float:SX,
    Float:SY,
    Float:SZ
}
new Spawn[MAX_SPAWN][spawns];

//Tankstellen
enum tanke
{
    TankID,
    Notizen,
    Inhalt,
    PreisAN,
    PreisVE,
    Float:TX,
    Float:TY,
    Float:TZ
}
new Tanken[MAX_TANKE][tanke];
new TankIdIDX=0;

//Bankautomaten
enum atm
{
    BankID,
    Notizen,
    Float:BX,
    Float:BY,
    Float:BZ,
    Float:BA
}
new Bank[MAX_ATM][atm];
new BankIdIDX=0;

//Äpfelbäume
enum apfel
{
    ApfelID,
    Wasser,
    Ernte,
    Float:AX,
    Float:AY,
    Float:AZ
}
new Apfelbaum[MAX_APFEL][apfel];
new ApfelIdIDX=0;

//Bombe
enum bombe
{
    BombenID,
    Timer,
    Float:BX,
    Float:BY,
    Float:BZ
}
new Bomben[MAX_BOMBE][bombe];
new BombeIdIDX=0;

//GETFLoatz
stock Float:mysql_GetFloatz(Table[], Field[], Where[], Is[])
{
    new query[128], Float:sqlfloat;
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Is, Is);
    format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%d'", Field, Table, Where, Is);
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_float(sqlfloat);
    mysql_free_result();
    return sqlfloat;
}

main()
{

}

public OnGameModeInit()
{
    SetTimer("BenzinVerlust", VERLUST, true);
    SetTimer("Payday", 1000*60, true);
    SetTimer("Ernten", 1000*60*60*3, true);
    SetTimer("CarBestellungTimer", 1000*60, true);
    SetTimer("Save",60000,1);

    Connect_To_Database();

    for(new h = 0; h<1; h++)
    LoadHouse(h);

    //Motor
    ManualVehicleEngineAndLights(); // Dies muss in OnGameModeInit angegeben werden, damit das ganze System überhaupt funktioniert.
    for (new i=0; i< MAX_VEHICLES; i++)
    {
        GetVehicleParamsEx(i,enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
        SetVehicleParamsEx(i,VEHICLE_PARAMS_OFF,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
        Motor[i] = false;
    }

    //Tank
    for (new i=0; i< MAX_VEHICLES; i++)
    {
        GetVehicleParamsEx(i,enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
        SetVehicleParamsEx(i,VEHICLE_PARAMS_OFF,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
        Motor[i] = false;
        Tank[i] = 70;
    }

    new GZ_ZONE1;
    GZ_ZONE1 = GangZoneCreate(1682.28,1304.7619047619,1893.11859443631,1666.66666666667);
    GangZoneShowForAll(GZ_ZONE1, 0x0000FFFF);

    DisableInteriorEnterExits();
    EnableStuntBonusForAll(0);
    SetGameModeText("Blank Script");
    AddPlayerClass(0, 1958.3783, 1343.1572, 15.3746, 269.1425, 0, 0, 0, 0, 0, 0);
    return 1;
}

public OnGameModeExit()
{
    new engine,lights,alarm,boonet,boot,objective;
    mysql_SetInt("Mietcars","Besitzer",1,"Besitzer","2");
    for(new i; i<MAX_MIET_CARS; i++)
    SetVehicleParamsEx(MietCars[i][MietCarID],engine,lights,alarm,VEHICLE_PARAMS_OFF,boonet,boot,objective);
    return 1;
}

public OnPlayerRequestClass(playerid, classid)
{
    if(GetPVarInt(playerid,"Eingeloggt") == 0) //Als erstes fragen wir ab ob der Spieler schon eingeloggt ist oder nicht, damit wir nicht bei jeder Skin Auswahl uns neu Einloggen müssen.
    {
        if(mysql_CheckAccount(playerid) == 0)//Wir überprüfen ob der Account Existiert, falls nicht Zeigen wir den Dialog zum Registrieren.
        {
            SendClientMessage(playerid, 0xFFFFFFFF,"________-> Willkommen auf auf meinem Server <-________");
            SendClientMessage(playerid, 0xFFFFFFFF,"Dein Account wurde nicht gefunden, bitte Registriere dich!");
            ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Register","Bitte Gib ein Passwort an:","Register","Exit");
        }
        else if(mysql_CheckAccount(playerid) == 1)//Falls doch zeigen wir den Dialog zum Einloggen.
        {
            SendClientMessage(playerid, 0xFFFFFFFF,"________-> Willkommen auf auf meinem Server <-________");
            SendClientMessage(playerid, 0xFFFFFFFF,"Dein Account wurde gefunden, bitte Log dich nun ein!");
            ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Login","Bitte gib dein Passwort ein:","Login","Abbrechen");
        }
    }
    return 1;
}

public OnPlayerConnect(playerid)
{
    sSpieler[playerid][pJobaktive] = 0;
    sSpieler[playerid][pJobMaterialienz] = 0;
    Anzeige[playerid] = TextDrawCreate(630.0,410.0," "); // Erstellt das TextDraw an X|Y-Position 630|410 (unten rechts)
    TextDrawSetOutline(Anzeige[playerid], 1); // Setzt dem TextDraw Outlines
    TextDrawAlignment(Anzeige[playerid], 3); // Macht das TextDraw rechtsbündig
    TextDrawSetShadow(Anzeige[playerid], 0); // Schaltet den Schatten des TextDraws aus
    TextDrawShowForPlayer(playerid,Anzeige[playerid]); // Zeigt das TextDraw dem Spieler
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    sSpieler[playerid][pJobaktive] = 0;
    SavePlayer(playerid);
    DeletePVar(playerid,"Eingeloggt");
    return 1;
}

stock HexToInt(string[]) // By DracoBlue
{
    if (string[0]==0) return 0;
    new i;
    new cur=1;
    new res=0;
    for (i=strlen(string);i>0;i--) {
    if (string[i-1]<58) res=res+cur*(string[i-1]-48); else res=res+cur*(string[i-1]-65+10);
    cur=cur*16;
    }
    return res;
}

//Spawn
public OnPlayerSpawn(playerid)
{
    mysql_query("SELECT * FROM `Spawns`");
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        while(mysql_retrieve_row())
        {
            for(new i;i<MAX_SPAWN;i++)
            {
                new string[512],str[10];
                mysql_fetch_field_row(string,"FrakID");
                Spawn[i][FrakID] = strval(string);
                mysql_fetch_field_row(string,"SX");
                Spawn[i][SX] = floatstr(string);
                mysql_fetch_field_row(string,"SY");
                Spawn[i][SY] = floatstr(string);
                mysql_fetch_field_row(string,"SZ");
                Spawn[i][SZ] = floatstr(string);
                mysql_query(string);
                if(sSpieler[playerid][pFraktion] == Spawn[i][FrakID])
                {
                    sSpieler[playerid][pColor] = mysql_GetStringz("Spawns", "FrakColor", "FrakID", sSpieler[playerid][pFraktion]);

                    SetPlayerPos(playerid,Spawn[i][SX],Spawn[i][SY],Spawn[i][SZ]);
                    SetPlayerInterior(playerid,0);
                    SetPlayerVirtualWorld(playerid,0);
                    format(str,11,"0x%s",sSpieler[playerid][pColor]);
                    SetPlayerColor(playerid,HexToInt(str));
                    SendClientMessage(playerid,Rot,str);
                    return 1;
                }
            }
        }
    }
    mysql_free_result();
    return 1;
}

public OnPlayerDeath(playerid, killerid, reason)
{
    return 1;
}

public OnVehicleSpawn(vehicleid)
{
    GetVehicleParamsEx(vehicleid,enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
    SetVehicleParamsEx(vehicleid,VEHICLE_PARAMS_OFF,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
    Motor[vehicleid] = false;
    return 1;
}

public OnVehicleDeath(vehicleid, killerid)
{
    return 1;
}

public OnPlayerText(playerid, text[])
{
    return 1;
}

//Save
public Save(playerid)
{
    SavePlayer(playerid);
}

//Payday
public Payday(playerid)
{
    if(sSpieler[playerid][pSpielminuten]<60)
    {
        return sSpieler[playerid][pSpielminuten] += 1;
    }
    if(sSpieler[playerid][pSpielminuten]>=60)
    {
        sSpieler[playerid][pSpielminuten] = 0;
        sSpieler[playerid][pSpielstunden] +=1;
    }
    return 1;
}

//BenzinVerlust
public BenzinVerlust()
{
    for(new i=0; i<MAX_VEHICLES; i++)
    {
        if (Motor[i] == true)
        {
            Tank[i] = Tank[i]-1;
            if (Tank[i]<1)
            {
                Tank[i] = 0;
                GetVehicleParamsEx(i,enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                SetVehicleParamsEx(i,VEHICLE_PARAMS_OFF,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                Motor[i] = false;
            }
        }
    }
    return 1;
}

//Ernten
public Ernten()
{
    mysql_query("SELECT * FROM `apfelbaum`");
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        while(mysql_retrieve_row())
        {
            for(new i;i<MAX_APFEL;i++)
            {
                new string[128];
                mysql_fetch_field_row(string,"Ernte");
                Apfelbaum[i][Ernte] = strval(string);
                mysql_fetch_field_row(string,"ApfelID");
                Apfelbaum[i][ApfelID] = strval(string);
                if(Apfelbaum[i][Ernte] >= 5)
                {

                }
                else
                {
                    mysql_SetIntz("Apfelbaum","Ernte",Apfelbaum[i][Ernte]+1,"ApfelID",Apfelbaum[i][ApfelID]);
                }
            }
        }
    }
    mysql_free_result();
    return true;
}

//Auftanken
public Auftanken(playerid)
{
    new car = GetPlayerVehicleID(playerid);
    Tank[car] = Tank[car] +1;
    if(Tank[car] >= 70)
    {
        TanktGerade[car] = false;
        Tank[car] = 70;
        SendClientMessage(playerid, Grün, "Dein Fahrzeug wurde vollgetankt.");
        TogglePlayerControllable(playerid,1);
        KillTimer(tanktimer[playerid]);
    }
    return 1;
}

public OnPlayerCommandText(playerid, cmdtext[])
{

    //DCMD
    dcmd(makeleader,10,cmdtext);
    dcmd(makeadmin,9,cmdtext);
    dcmd(makejob,7,cmdtext);
    dcmd(pickup,6,cmdtext);
    dcmd(delpickup,9,cmdtext);
    dcmd(delpickupid,11,cmdtext);
    dcmd(newscar,7,cmdtext);
    dcmd(spark,5,cmdtext);
    dcmd(delscar,7,cmdtext);
    dcmd(newfcar,7,cmdtext);
    dcmd(fpark,5,cmdtext);
    dcmd(delfcar,7,cmdtext);
    dcmd(newjcar,7,cmdtext);
    dcmd(jpark,5,cmdtext);
    dcmd(deljcar,7,cmdtext);
    dcmd(fnew,4,cmdtext);
    dcmd(fspawn,6,cmdtext);
    dcmd(fdelspawn,9,cmdtext);
    dcmd(newmcar,7,cmdtext);
    dcmd(mpark,5,cmdtext);
    dcmd(delmcar,7,cmdtext);
    dcmd(createhouse,11,cmdtext);
    dcmd(exit,4,cmdtext);
    dcmd(buyhouse,8,cmdtext);
    dcmd(tnew,4,cmdtext);
    dcmd(bnew,4,cmdtext);
    dcmd(delb,4,cmdtext);
    dcmd(newapfelbaum,12,cmdtext);
    dcmd(ad,2,cmdtext);
    dcmd(kick,4,cmdtext);
    dcmd(afk,3,cmdtext);
    dcmd(goto,4,cmdtext);
    dcmd(kill,4,cmdtext);
    dcmd(tphere,6,cmdtext);
    dcmd(setheal,7,cmdtext);
    dcmd(setarmour,9,cmdtext);
    dcmd(me,2,cmdtext);
    dcmd(repair,6,cmdtext);
    dcmd(refill,6,cmdtext);
    dcmd(showfinanzen, 12, cmdtext);
    dcmd(giveweapon, 10, cmdtext);
    dcmd(car, 3, cmdtext);
    dcmd(legen,5,cmdtext);
    dcmd(zuenden,7,cmdtext);


    //Commands
    if (strcmp("/gmx", cmdtext, true, 10) == 0)
    {
        if(sSpieler[playerid][pAdmin] < 10)
        {
            return SendClientMessage(playerid,Rot,"Du bist kein Admin");
        }
        else
        {
            return SendRconCommand("gmx");
        }
    }
    //New Interior
    if (strcmp("/newinterior", cmdtext, true, 10) == 0)
    {
        if(sSpieler[playerid][pAdmin] < 10)
        {
            return SendClientMessage(playerid,Rot,"Du bist kein Admin");
        }
        else
        {
            return ShowPlayerDialog(playerid,newinterior,DIALOG_STYLE_LIST,"Interiors","Bank Interior\nTankstellen Interior\nDisco Interior\nFahrschule Interior\nFriseur Interior","Wählen","Abbrechen");
        }
    }
    //updatejobcar
    if (strcmp("/updatejobcar", cmdtext, true, 10) == 0)
    {
        JobVehIDX = 0;
        mysql_query("CREATE TABLE IF NOT EXISTS `JobCars` (`carID` int(11), `carModel` int(11), `JobID` int(11), `Farbe1` int(11), `Farbe2` int(11), `X` float(20), `Y` float(20), `Z` float(20), `A` float(20), PRIMARY KEY (`carID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `JobCars`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],frakcarid;
                mysql_fetch_field_row(string,"carID");
                JobCars[JobVehIDX][JobCarID] = strval(string);
                mysql_fetch_field_row(string,"carModel");
                JobCars[JobVehIDX][JobModelID] = strval(string);
                mysql_fetch_field_row(string,"JobID");
                JobCars[JobVehIDX][JobID] = strval(string);
                mysql_fetch_field_row(string,"X");
                JobCars[JobVehIDX][jX] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                JobCars[JobVehIDX][jY] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                JobCars[JobVehIDX][jZ] = floatstr(string);
                mysql_fetch_field_row(string,"A");
                JobCars[JobVehIDX][jA] = floatstr(string);
                mysql_fetch_field_row(string,"Farbe1");
                JobCars[JobVehIDX][jColor1] = strval(string);
                mysql_fetch_field_row(string,"Farbe2");
                JobCars[JobVehIDX][jColor2] = strval(string);
                DestroyVehicle(JobCars[JobVehIDX][JobCarID]);
                frakcarid = AddStaticVehicleEx(JobCars[JobVehIDX][JobModelID],JobCars[JobVehIDX][jX],JobCars[JobVehIDX][jY],JobCars[JobVehIDX][jZ],JobCars[JobVehIDX][jA],JobCars[JobVehIDX][jColor1],JobCars[JobVehIDX][jColor2],1000*60*5);
                format(string, sizeof(string),"Job:%d",frakcarid);
                SetVehicleNumberPlate(frakcarid,string);
                format(string, sizeof(string), "UPDATE `JobCars` SET `carID` = %d WHERE `carID` = %d", frakcarid, JobCars[JobVehIDX][JobCarID]);
                JobCars[JobVehIDX][JobCarID] = frakcarid;
                mysql_query(string);
                JobVehIDX++;
            }
        }
        mysql_free_result();
        return true;
    }
    //updateservercar
    if (strcmp("/updateservercar", cmdtext, true, 10) == 0)
    {
        ServerVehIDX = 0;
        mysql_query("CREATE TABLE IF NOT EXISTS `ServerCars` (`carID` int(11), `carModel` int(11), `Farbe1` int(11), `Farbe2` int(11), `X` float(20), `Y` float(20), `Z` float(20), `A` float(20), PRIMARY KEY (`carID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `ServerCars`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],servercarid;
                mysql_fetch_field_row(string,"carID");
                ServerVeh[ServerVehIDX][sCarID] = strval(string);
                mysql_fetch_field_row(string,"carModel");
                ServerVeh[ServerVehIDX][sModelID] = strval(string);
                mysql_fetch_field_row(string,"X");
                ServerVeh[ServerVehIDX][sX] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                ServerVeh[ServerVehIDX][sY] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                ServerVeh[ServerVehIDX][sZ] = floatstr(string);
                mysql_fetch_field_row(string,"A");
                ServerVeh[ServerVehIDX][sA] = floatstr(string);
                mysql_fetch_field_row(string,"Farbe1");
                ServerVeh[ServerVehIDX][sColor1] = strval(string);
                mysql_fetch_field_row(string,"Farbe2");
                ServerVeh[ServerVehIDX][sColor2] = strval(string);
                DestroyVehicle(ServerVeh[ServerVehIDX][sCarID]);
                servercarid = AddStaticVehicleEx(ServerVeh[ServerVehIDX][sModelID],ServerVeh[ServerVehIDX][sX],ServerVeh[ServerVehIDX][sY],ServerVeh[ServerVehIDX][sZ],ServerVeh[ServerVehIDX][sA],ServerVeh[ServerVehIDX][sColor1],ServerVeh[ServerVehIDX][sColor2],1000*60*5);
                format(string, sizeof(string),"SVR:%d",servercarid);
                SetVehicleNumberPlate(servercarid,string);
                format(string, sizeof(string), "UPDATE `ServerCars` SET `carID` = %d WHERE `carID` = %d", servercarid, ServerVeh[ServerVehIDX][sCarID]);
                ServerVeh[ServerVehIDX][sCarID] = servercarid;
                mysql_query(string);
                ServerVehIDX++;
            }
        }
        mysql_free_result();
        return true;
    }
    //updateMietcar
    if (strcmp("/updatemietcar", cmdtext, true, 10) == 0)
    {
        MietVehIDX = 0;
        mysql_query("CREATE TABLE IF NOT EXISTS `mietcars` (`carID` int(11), `carModel` int(11), `Farbe1` int(11), `Farbe2` int(11), `X` float(20), `Y` float(20), `Z` float(20), `A` float(20), `Preis` int(11), `Besitzer` int(11), PRIMARY KEY (`carID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `mietcars`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],mietcarid;
                mysql_fetch_field_row(string,"carID");
                MietCars[MietVehIDX][MietCarID] = strval(string);
                mysql_fetch_field_row(string,"carModel");
                MietCars[MietVehIDX][MietModelID] = strval(string);
                mysql_fetch_field_row(string,"X");
                MietCars[MietVehIDX][mX] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                MietCars[MietVehIDX][mY] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                MietCars[MietVehIDX][mZ] = floatstr(string);
                mysql_fetch_field_row(string,"A");
                MietCars[MietVehIDX][mA] = floatstr(string);
                mysql_fetch_field_row(string,"Farbe1");
                MietCars[MietVehIDX][mColor1] = strval(string);
                mysql_fetch_field_row(string,"Farbe2");
                MietCars[MietVehIDX][mColor2] = strval(string);
                DestroyVehicle(MietCars[MietVehIDX][MietCarID]);
                mietcarid = AddStaticVehicleEx(MietCars[MietVehIDX][MietModelID],MietCars[MietVehIDX][mX],MietCars[MietVehIDX][mY],MietCars[MietVehIDX][mZ],MietCars[MietVehIDX][mA],MietCars[MietVehIDX][mColor1],MietCars[MietVehIDX][mColor2],1000*60*5);
                format(string, sizeof(string),"SVR:%d",mietcarid);
                SetVehicleNumberPlate(mietcarid,string);
                format(string, sizeof(string), "UPDATE `Mietcars` SET `carID` = %d WHERE `carID` = %d", mietcarid, MietCars[MietVehIDX][MietCarID]);
                MietCars[MietVehIDX][MietCarID] = mietcarid;
                mysql_query(string);
                MietVehIDX++;
            }
        }
        mysql_free_result();
        return true;
    }
    //updateFraktioncar
    if (strcmp("/updateFraktioncar", cmdtext, true, 10) == 0)
    {
        FrakVehIDX = 0;
        mysql_query("CREATE TABLE IF NOT EXISTS `FraktionCars` (`carID` int(11), `carModel` int(11), `FrakID` int(11), `Farbe1` int(11), `Farbe2` int(11), `X` float(20), `Y` float(20), `Z` float(20), `A` float(20), PRIMARY KEY (`carID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `FraktionCars`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],frakcarid;
                mysql_fetch_field_row(string,"carID");
                FrakCars[FrakVehIDX][fCarID] = strval(string);
                mysql_fetch_field_row(string,"carModel");
                FrakCars[FrakVehIDX][fModelID] = strval(string);
                mysql_fetch_field_row(string,"FrakID");
                FrakCars[FrakVehIDX][FrakID] = strval(string);
                mysql_fetch_field_row(string,"X");
                FrakCars[FrakVehIDX][sX] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                FrakCars[FrakVehIDX][sY] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                FrakCars[FrakVehIDX][sZ] = floatstr(string);
                mysql_fetch_field_row(string,"A");
                FrakCars[FrakVehIDX][sA] = floatstr(string);
                mysql_fetch_field_row(string,"Farbe1");
                FrakCars[FrakVehIDX][sColor1] = strval(string);
                mysql_fetch_field_row(string,"Farbe2");
                FrakCars[FrakVehIDX][sColor2] = strval(string);
                DestroyVehicle(FrakCars[FrakVehIDX][fCarID]);
                frakcarid = AddStaticVehicleEx(FrakCars[FrakVehIDX][fModelID],FrakCars[FrakVehIDX][sX],FrakCars[FrakVehIDX][sY],FrakCars[FrakVehIDX][sZ],FrakCars[FrakVehIDX][sA],FrakCars[FrakVehIDX][sColor1],FrakCars[FrakVehIDX][sColor2],1000*60*5);
                format(string, sizeof(string),"SVR:%d",frakcarid);
                SetVehicleNumberPlate(frakcarid,string);
                format(string, sizeof(string), "UPDATE `FraktionCars` SET `carID` = %d WHERE `carID` = %d", frakcarid, FrakCars[FrakVehIDX][fCarID]);
                FrakCars[FrakVehIDX][fCarID] = frakcarid;
                mysql_query(string);
                FrakVehIDX++;
            }
        }
        mysql_free_result();
        return true;
    }
    //updateFraktioncar
    if (strcmp("/updatespielercar", cmdtext, true, 10) == 0)
    {
        SpielerVehIDX = 0;
        mysql_query("CREATE TABLE IF NOT EXISTS `SpielerCars` (`carID` int(11), `carModel` int(11), `Status` int(11), `SpielerID` varchar(128), `Preis` int(11), `Farbe1` int(11), `Farbe2` int(11), `X` float(20), `Y` float(20), `Z` float(20), `A` float(20), PRIMARY KEY (`carID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `SpielerCars`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],frakcarid;
                mysql_fetch_field_row(string,"carID");
                SpielerCars[SpielerVehIDX][SpielerCarID] = strval(string);
                mysql_fetch_field_row(string,"carModel");
                SpielerCars[SpielerVehIDX][SpielerModelID] = strval(string);
                mysql_fetch_field_row(string,"Status");
                SpielerCars[SpielerVehIDX][SpielerStatus] = strval(string);
                mysql_fetch_field_row(string,"Preis");
                SpielerCars[SpielerVehIDX][SpielerPreis] = strval(string);
                mysql_fetch_field_row(string,"X");
                SpielerCars[SpielerVehIDX][sX] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                SpielerCars[SpielerVehIDX][sY] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                SpielerCars[SpielerVehIDX][sZ] = floatstr(string);
                mysql_fetch_field_row(string,"A");
                SpielerCars[SpielerVehIDX][sA] = floatstr(string);
                mysql_fetch_field_row(string,"Farbe1");
                SpielerCars[SpielerVehIDX][sColor1] = strval(string);
                mysql_fetch_field_row(string,"Farbe2");
                SpielerCars[SpielerVehIDX][sColor2] = strval(string);
                DestroyVehicle(SpielerCars[SpielerVehIDX][SpielerCarID]);
                frakcarid = AddStaticVehicleEx(SpielerCars[SpielerVehIDX][SpielerModelID],SpielerCars[SpielerVehIDX][sX],SpielerCars[SpielerVehIDX][sY],SpielerCars[SpielerVehIDX][sZ],SpielerCars[SpielerVehIDX][sA],SpielerCars[SpielerVehIDX][sColor1],SpielerCars[SpielerVehIDX][sColor2],1000*60*5);
                format(string, sizeof(string),"Spieler:%d",frakcarid);
                SetVehicleNumberPlate(frakcarid,string);
                format(string, sizeof(string), "UPDATE `SpielerCars` SET `carID` = %d WHERE `carID` = %d", frakcarid, SpielerCars[SpielerVehIDX][SpielerCarID]);
                SpielerCars[SpielerVehIDX][SpielerCarID] = frakcarid;
                mysql_query(string);
                SpielerVehIDX++;
            }
        }
        mysql_free_result();
        return true;
    }
    //Money
    if (strcmp("/money", cmdtext, true, 10) == 0)
    {
        if(sSpieler[playerid][pAdmin] < 10)
        {
            return SendClientMessage(playerid,Rot,"Du bist kein Admin");
        }
        else
        {
            GivePlayerMoney(playerid,50000);
            return 1;
        }
    }
    //Mietcar
    if (strcmp("/mietcar", cmdtext, true, 10) == 0)
    {
        sSpieler[playerid][pMietid] = mysql_GetInt("Accounts","Mietid","username",sSpieler[playerid][pName]);
        if(sSpieler[playerid][pMietid] == 0)
        {
            return SendClientMessage(playerid,Rot,"Du hast derzeit kein Auto gemietet");
        }
        else
        {
            return ShowPlayerDialog(playerid,MietcarControl,DIALOG_STYLE_LIST,"Mietcar","Öffnen\nAbschliessen\nAbgeben","Okay","Abbrechen");
        }
    }
    //TP
    if (strcmp("/tp", cmdtext, true, 10) == 0)
    {
        SetPlayerPos(playerid,272.13,1410.35,10.4604);
    }
    //Loadmats
    if (strcmp("/loadmats", cmdtext, true, 10) == 0)
    {
        if(sSpieler[playerid][pJob] != 9)
        {
            return SendClientMessage(playerid,Rot,"Du bist kein Wafendealer");
        }
        if(!IsPlayerInRangeOfPoint(playerid,6,2207.4402,-2043.9987,13.6392))
        {
            return SendClientMessage(playerid,Rot,"Du bist nicht am Annahmepunkt");
        }
        if(sSpieler[playerid][pJobMaterialienz] == 1)
        {
            return SendClientMessage(playerid,Rot,"Du hast schon Materialien im Inventar");
        }
        if(GetPlayerMoney(playerid)<750)
        {
            return SendClientMessage(playerid,Rot,"Du hast nicht genug Geld für die Mats");
        }
        else
        {
            GivePlayerMoney(playerid,-750);
            SendClientMessage(playerid,Grün,"Du hast dir Materialien gekauft, fahre nun zum Abgabepunkt");
            sSpieler[playerid][pJobMaterialienz] = 1;
            return 1;
        }
    }
    //Sellmats
    if (strcmp("/sellmats", cmdtext, true, 10) == 0)
    {
        if(!IsPlayerInRangeOfPoint(playerid,6,595.3091,-1249.7268,18.2596))
        {
            return SendClientMessage(playerid,Rot,"Du bist nicht am Abgabepunkt");
        }
        if(sSpieler[playerid][pJobMaterialienz] == 1)
        {
            return SendClientMessage(playerid,Rot,"Du hast schon Materialien im Inventar");
        }
        if(sSpieler[playerid][pJob] != 9)
        {
            return SendClientMessage(playerid,Rot,"Du bist kein Wafendealer");
        }
        else
        {
            sSpieler[playerid][pJobMaterialien] += 300;
            sSpieler[playerid][pJobMaterialienz] = 0;
            sSpieler[playerid][pJobWaffendealer] += 1+random(1);
            SendClientMessage(playerid,Grün,"Du hast für deine Lieferung 300 Mats erhalten");
        }
    }
    //Job starten
    if (strcmp("/start", cmdtext, true, 10) == 0)
    {
        new test;
        sSpieler[playerid][pJob] = mysql_GetInt("Accounts","Job","username",sSpieler[playerid][pName]);
        test = mysql_GetIntz("jobcars","JobID","CarID",sSpieler[playerid][pVehicle]);
        if(!IsPlayerInAnyVehicle(playerid))
        {
            return  SendClientMessage(playerid,Rot,"Du bist nicht in einem Fahrzeug");
        }
        if(sSpieler[playerid][pJob] == 0)
        {
            return SendClientMessage(playerid,Rot,"Du hast kein Job");
        }
        if(test != sSpieler[playerid][pJob])
        {
            return SendClientMessage(playerid,Rot,"Das Fahrzug gehört nicht zu deinem Job");
        }
        if(test == 1)
        {
            ShowPlayerDialog(playerid,JobBusfahrer,DIALOG_STYLE_LIST,"Welche Strecke möchten Sie fahren?","Strecke 1\nStrecke 2\nStrecke 3","Start","Abbrechen");
            return 1;
        }
        if(test == 2)
        {
            ShowPlayerDialog(playerid,JobErzsammler,DIALOG_STYLE_LIST,"Welche Strecke möchten Sie fahren?","Strecke 1\nStrecke 2\nStrecke 3","Start","Abbrechen");
            return 1;
        }
        if(test == 3)
        {
            ShowPlayerDialog(playerid,JobFarmer,DIALOG_STYLE_LIST,"Welche Strecke möchten Sie fahren?","Strecke 1\nStrecke 2\nStrecke 3","Start","Abbrechen");
            return 1;
        }
        if(test == 4)
        {
            ShowPlayerDialog(playerid,JobTrucker,DIALOG_STYLE_LIST,"Welche Strecke möchten Sie fahren?","Strecke 1\nStrecke 2\nStrecke 3","Start","Abbrechen");
            return 1;
        }
        if(test == 5)
        {
            ShowPlayerDialog(playerid,JobPilot,DIALOG_STYLE_LIST,"Welche Strecke möchten Sie fahren?","Strecke 1\nStrecke 2\nStrecke 3","Start","Abbrechen");
            return 1;
        }
        if(test == 6)
        {
            ShowPlayerDialog(playerid,JobMuelmann,DIALOG_STYLE_LIST,"Welche Strecke möchten Sie fahren?","Strecke 1\nStrecke 2\nStrecke 3","Start","Abbrechen");
            return 1;
        }
        if(test == 10)
        {
            ShowPlayerDialog(playerid,JobReiniger,DIALOG_STYLE_LIST,"Welche Strecke möchten Sie fahren?","Strecke 1\nStrecke 2\nStrecke 3","Start","Abbrechen");
            return 1;
        }
        else
        {
            return SendClientMessage(playerid,Rot,"Dein Job exestiert nicht");
        }
    }
    //Auto erstellen
    if (strcmp("/acreate", cmdtext, true, 10) == 0)
    {
        if(sSpieler[playerid][pFraktion] != 18)
        {
            return SendClientMessage(playerid,Rot,"Du bist nicht in der Fraktion Autohändler");
        }
        if(IsPlayerInRangeOfPoint(playerid,5,2051.46,1321.19,10.67))
        {
            return SendClientMessage(playerid,Rot,"Du bist nicht am Autohaus");
        }
        else
        {
            return ShowPlayerDialog(playerid,AutohausCreate,DIALOG_STYLE_INPUT,"Autohaus","Geben sie Bitte die Model-ID des Fahrzeugs ein.\nWenn nach eingabe und bestätigung des Dialogs nix passiert,\nexestiert das angegebene Auto nicht","Okay","Abbrechen");
        }
    }
    //Autohaus auto parken
    if (strcmp("/apark", cmdtext, true, 10) == 0)
    {
        new query[128];
        new Float:vehx,Float:vehy,Float:vehz,Float:veha;
        new carid = GetPlayerVehicleID(playerid);
        GetVehiclePos(carid,vehx,vehy,vehz);
        GetVehicleZAngle(carid,veha);
        if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
        {
            for(new i;i<MAX_VEHICLES;i++)
            {
                if(GetPlayerVehicleID(playerid)==SpielerCars[i][SpielerCarID])
                {
                    if(sSpieler[playerid][pFraktion] != 18)
                    {
                        return SendClientMessage(playerid,Rot,"Du gehört dem Autohaus nicht an");
                    }
                    new Status = mysql_GetIntz("Spielercars","Status","CarID",sSpieler[playerid][pVehicle]);
                    if(Status > 1)
                    {
                        SendClientMessage(playerid,Rot,"Das Fahrzeug gehört nicht dem Autohaus");
                        RemovePlayerFromVehicle(playerid);
                        return 1;
                    }
                    format(query, 128, "UPDATE spielercars SET X = '%f' WHERE carID = '%d'", vehx, SpielerCars[i][SpielerCarID]);
                    mysql_query(query);
                    format(query, 128, "UPDATE spielercars SET Y = '%f' WHERE carID = '%d'", vehy, SpielerCars[i][SpielerCarID]);
                    mysql_query(query);
                    format(query, 128, "UPDATE spielercars SET Z = '%f' WHERE carID = '%d'", vehz, SpielerCars[i][SpielerCarID]);
                    mysql_query(query);
                    format(query, 128, "UPDATE spielercars SET A = '%f' WHERE carID = '%d'", veha, SpielerCars[i][SpielerCarID]);
                    mysql_query(query);
                    mysql_free_result();
                    format(query, 128, "Du hast das Autohausfahrzeug mit der ID: %d umgeparkt", SpielerCars[i][SpielerCarID]);
                    SendClientMessage(playerid,0x008000FF,query);
                    return 1;
                }
            }
        }
        else
        {
            SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
        }
    }
    //Auto verkaufen
    if (strcmp("/asell", cmdtext, true, 10) == 0)
    {
        if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
        {
            for(new i;i<MAX_SPIELER_CARS;i++)
            {
                if(GetPlayerVehicleID(playerid)==SpielerCars[i][SpielerCarID])
                {
                    if(sSpieler[playerid][pFraktion] != 18)
                    {
                        return SendClientMessage(playerid,Rot,"Du gehört dem Autohaus nicht an");
                    }

                    new Status = mysql_GetIntz("Spielercars","Status","CarID",sSpieler[playerid][pVehicle]);

                    if(Status == 1 || Status == 0)
                    {
                        ShowPlayerDialog(playerid,AutohausPreis,DIALOG_STYLE_INPUT,"Autohaus","Wie teuer soll dieses Auto kosten?","Okay","Abbrechen");
                        return 1;
                    }

                    SendClientMessage(playerid,Rot,"Das Fahrzeug gehört nicht dem Autohaus");
                    RemovePlayerFromVehicle(playerid);
                    return 1;
                }
            }
        }
        else
        {
            SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
        }
    }

    //Auto Ticket
    if (strcmp("/ticket", cmdtext, true, 10) == 0)
    {
        if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
        {
            for(new i;i<MAX_SPIELER_CARS;i++)
            {
                if(GetPlayerVehicleID(playerid)==SpielerCars[i][SpielerCarID])
                {
                    if(sSpieler[playerid][pFraktion] != 7)
                    {
                        return SendClientMessage(playerid,Rot,"Du gehört dem Ordnungsamt nicht an");
                    }

                    new Status = mysql_GetIntz("Spielercars","Status","CarID",sSpieler[playerid][pVehicle]);

                    if(Status == 4 || Status == 3 || Status == 2)
                    {
                        ShowPlayerDialog(playerid,OrdnungsamtTicket,DIALOG_STYLE_INPUT,"Ordnungsamt-Ticket","Wie teuer soll der Strafzettel sein?","Okay","Abbrechen");
                        return 1;
                    }

                    SendClientMessage(playerid,Rot,"Dieses Fahrzeug kann kein Strafzettel erhalten");
                    RemovePlayerFromVehicle(playerid);
                    return 1;
                }
            }
        }
        else
        {
            SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
        }
    }

    //Auto Parken
    if (strcmp("/parken", cmdtext, true, 10) == 0)
    {
        if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
        {
            for(new i;i<MAX_SPIELER_CARS;i++)
            {
                if(GetPlayerVehicleID(playerid) == SpielerCars[i][SpielerCarID])
                {
                    new Status = mysql_GetIntz("Spielercars","Status","CarID",sSpieler[playerid][pVehicle]);
                    if(Status == 4 || Status == 3)
                    {
                        new string[128];
                        format(string, sizeof(string), "%s", mysql_GetStringz("Spielercars","SpielerID","CarID",sSpieler[playerid][pVehicle]));
                        SendClientMessage(playerid,Rot,string);
                        if(strcmp(sSpieler[playerid][pName], string, false) == 0)
                        {
                            new query[512],Float: vehx,Float: vehy,Float: vehz,Float: veha;
                            GetVehiclePos(GetPlayerVehicleID(playerid),vehx,vehy,vehz);
                            GetVehicleZAngle(GetPlayerVehicleID(playerid),veha);

                            format(query, 128, "UPDATE spielercars SET X = '%f' WHERE carID = '%d'", vehx, SpielerCars[i][SpielerCarID]);
                            mysql_query(query);
                            format(query, 128, "UPDATE spielercars SET Y = '%f' WHERE carID = '%d'", vehy, SpielerCars[i][SpielerCarID]);
                            mysql_query(query);
                            format(query, 128, "UPDATE spielercars SET Z = '%f' WHERE carID = '%d'", vehz, SpielerCars[i][SpielerCarID]);
                            mysql_query(query);
                            format(query, 128, "UPDATE spielercars SET A = '%f' WHERE carID = '%d'", veha, SpielerCars[i][SpielerCarID]);
                            mysql_query(query);
                            mysql_free_result();
                            format(query, 128, "Du hast dein Fahrzeug mit der ID: %d umgeparkt", SpielerCars[i][SpielerCarID]);
                            SendClientMessage(playerid,0x008000FF,query);
                            return 1;
                        }
                        else
                        {
                            return SendClientMessage(playerid,Rot,"Das Fahrzeug gehört dir nicht");
                        }
                    }
                    else
                    {
                        return SendClientMessage(playerid,Rot,"Das Fahrzeug gehört nicht dem Autohaus");
                    }
                }
            }
        }
        else
        {
            SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
        }
    }
    //Loadöl
    if (strcmp("/loadöl", cmdtext, true, 10) == 0)
    {
        if(sSpieler[playerid][pFraktion] == 9)
        {
            if(IsPlayerInRangeOfPoint(playerid,3,272.13,1410.35,10.4604))
            {
                new string[128];
                format(string,sizeof(string),"Wieviel Öl möchten Sie laden?\nDerzeit haben Sie %d Öl\nMaximal können sie 100 Liter Öl laden",sSpieler[playerid][pOel]);
                return ShowPlayerDialog(playerid,LoadOel,DIALOG_STYLE_INPUT,"Raffenerie",string,"Laden","Abbrechen");
            }
            return 1;
        }
        return 1;
    }
    //Sellöl
    if (strcmp("/sellöl", cmdtext, true, 10) == 0)
    {
        mysql_query("SELECT * FROM `Tankstellen`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                for(new i;i<MAX_TANKE;i++)
                {
                    new string[128];
                    mysql_fetch_field_row(string,"TX");
                    Tanken[i][TX] = floatstr(string);
                    mysql_fetch_field_row(string,"TY");
                    Tanken[i][TY] = floatstr(string);
                    mysql_fetch_field_row(string,"TZ");
                    Tanken[i][TZ] = floatstr(string);
                    mysql_fetch_field_row(string,"PreisAN");
                    Tanken[i][PreisAN] = strval(string);
                    mysql_fetch_field_row(string,"Inhalt");
                    Tanken[i][Inhalt] = strval(string);
                    if(IsPlayerInRangeOfPoint(playerid,10,Tanken[i][TX],Tanken[i][TY],Tanken[i][TZ]))
                    {
                        if(sSpieler[playerid][pFraktion] == 9)
                        {
                            new stringz[128];
                            format(stringz,sizeof(stringz),"Wieviel Liter möchten Sie an diese Tankstelle verkaufen?\nDie Tankstelle gibt %d$ pro Liter\nLager %d/5000",Tanken[i][PreisAN],Tanken[i][Inhalt]);
                            ShowPlayerDialog(playerid,SellOel,DIALOG_STYLE_INPUT,"Tankstelle",stringz,"Verkaufen","Abbrechen");
                            return 1;
                        }
                    }
                 }
            }
        }
    }
    //motor
    if(strcmp(cmdtext,"/m", true) == 0)
    {
        if(GetPlayerVehicleSeat(playerid) == 0)
        {
            new car = GetPlayerVehicleID(playerid);

            for(new i; i<MAX_SPIELER_CARS; i++)
            if(car == SpielerCars[i][SpielerCarID])
            {
                new string[128];
                format(string, sizeof(string), "%s", mysql_GetStringz("Spielercars","SpielerID","CarID",sSpieler[playerid][pVehicle]));
                sSpieler[playerid][pSpielerCarStatus] = mysql_GetIntz("Spielercars","Status","CarID",sSpieler[playerid][pVehicle]);
                SendClientMessage(playerid,Rot,string);
                if(strcmp(sSpieler[playerid][pName], string, true) == 0 && sSpieler[playerid][pSpielerCarStatus] == 4)
                {
                    if(GetVehicleModel(car) == 509 || GetVehicleModel(car) == 481 || GetVehicleModel(car) == 510)
                    {
                        return SendClientMessage(playerid, Rot, "Du sitzt auf einem Fahrrad. Das hat keinen Motor!");
                    }
                    else if (Tank[car] < 1)
                    {
                        return SendClientMessage(playerid, Rot, "Der Tank ist leer. Du musst erst /tanken.");
                    }
                    else if (Motor[car] == false )
                    {
                        GetVehicleParamsEx(car,enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                        SetVehicleParamsEx(car,VEHICLE_PARAMS_ON,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                        Motor[car] = true; // Setzt den Bool Motor auf true#
                        return 1;
                    }
                    else
                    {
                        GetVehicleParamsEx(car,enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                        SetVehicleParamsEx(car,VEHICLE_PARAMS_OFF,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                        Motor[car] = false; // Setzt den Bool wieder auf falsch zurück.
                        return 1;
                    }
                }
                if(sSpieler[playerid][pSpielerCarStatus] == 0 || sSpieler[playerid][pSpielerCarStatus] == 1)
                {
                    if(GetVehicleModel(car) == 509 || GetVehicleModel(car) == 481 || GetVehicleModel(car) == 510)
                    {
                        return SendClientMessage(playerid, Rot, "Du sitzt auf einem Fahrrad. Das hat keinen Motor!");
                    }
                    else if (Tank[car] < 1)
                    {
                        return SendClientMessage(playerid, Rot, "Der Tank ist leer. Du musst erst /tanken.");
                    }
                    else if (Motor[car] == false )
                    {
                        GetVehicleParamsEx(car,enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                        SetVehicleParamsEx(car,VEHICLE_PARAMS_ON,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                        Motor[car] = true; // Setzt den Bool Motor auf true#
                        return 1;
                    }
                    else
                    {
                        GetVehicleParamsEx(car,enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                        SetVehicleParamsEx(car,VEHICLE_PARAMS_OFF,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                        Motor[car] = false; // Setzt den Bool wieder auf falsch zurück.
                        return 1;
                    }
                }
                else
                {
                    return SendClientMessage(playerid,Rot,"Das Fahrzeug gehört dir nicht");
                }
            }

            if(GetVehicleModel(car) == 509 || GetVehicleModel(car) == 481 || GetVehicleModel(car) == 510)
            {
                return SendClientMessage(playerid, Rot, "Du sitzt auf einem Fahrrad. Das hat keinen Motor!");
            }
            else if (Tank[car] < 1)
            {
                return SendClientMessage(playerid, Rot, "Der Tank ist leer. Du musst erst /tanken.");
            }
            else if (Motor[car] == false )
            {
                GetVehicleParamsEx(car,enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                SetVehicleParamsEx(car,VEHICLE_PARAMS_ON,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                Motor[car] = true; // Setzt den Bool Motor auf true#
                return 1;
            }
            else
            {
                GetVehicleParamsEx(car,enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                SetVehicleParamsEx(car,VEHICLE_PARAMS_OFF,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez);
                Motor[car] = false; // Setzt den Bool wieder auf falsch zurück.
                return 1;
            }
        }
        return 1;
    }
    //Atm
    if(strcmp(cmdtext, "/atm", true) == 0)
    {
        mysql_query("SELECT * FROM `bankautomaten`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                for(new i;i<MAX_ATM;i++)
                {
                    new string[128];
                    mysql_fetch_field_row(string,"BXz");
                    Bank[i][BX] = floatstr(string);
                    mysql_fetch_field_row(string,"BYz");
                    Bank[i][BY] = floatstr(string);
                    mysql_fetch_field_row(string,"BZz");
                    Bank[i][BZ] = floatstr(string);
                    mysql_fetch_field_row(string,"BankID");
                    Bank[i][BankID] = strval(string);

                    if(IsPlayerInRangeOfPoint(playerid, 3, Bank[i][BX], Bank[i][BY], Bank[i][BZ]))
                    {
                        return ShowPlayerDialog(playerid,Atmmenue,DIALOG_STYLE_LIST,"Bankmenü","Einzahlen\nAuszahlen\nÜberweisen\nKontostand","Okay","Abbrechen");
                    }

                }
            }
        }
        return 1;
    }
    //Tanken
    if(strcmp(cmdtext, "/tanken", true) == 0)
    {
        mysql_query("SELECT * FROM `Tankstellen`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                for(new i;i<MAX_TANKE;i++)
                {
                    new string[128];
                    mysql_fetch_field_row(string,"TX");
                    Tanken[i][TX] = floatstr(string);
                    mysql_fetch_field_row(string,"TY");
                    Tanken[i][TY] = floatstr(string);
                    mysql_fetch_field_row(string,"TZ");
                    Tanken[i][TZ] = floatstr(string);
                    mysql_fetch_field_row(string,"Inhalt");
                    Tanken[i][Inhalt] = strval(string);
                    mysql_fetch_field_row(string,"PreisVE");
                    Tanken[i][PreisVE] = strval(string);
                    mysql_fetch_field_row(string,"TankID");
                    Tanken[i][TankID] = strval(string);

                    new car = GetPlayerVehicleID(playerid),ZuTanken = 70-Tank[car],preis = ZuTanken * Tanken[i][PreisVE];

                    if(IsPlayerInRangeOfPoint(playerid, 3, Tanken[i][TX], Tanken[i][TY], Tanken[i][TZ]))
                    {
                        if(GetPlayerVehicleSeat(playerid) == 0)
                        {
                            if (TanktGerade[car]) return SendClientMessage(playerid,Grün,"Du tankst schon!");
                            if (Motor[car] == true) return SendClientMessage(playerid,Rot,"Du musst vor dem Tanken den Motor ausschalten.");
                            if (GetPlayerMoney(playerid)-preis < 0) return SendClientMessage(playerid,Rot,"Du hast nicht genug Geld!");
                            if(Tanken[i][Inhalt] < ZuTanken) return SendClientMessage(playerid,Rot,"Die Tankstelle ist leer.");

                            mysql_SetIntz("Tankstellen","Inhalt",Tanken[i][Inhalt]-ZuTanken,"TankID",Tanken[i][TankID]);
                            GivePlayerMoney(playerid, -preis);
                            SendClientMessage(playerid, Grün, "Tanken wird gestartet.");
                            SetCameraBehindPlayer(playerid);
                            TogglePlayerControllable(playerid,0);
                            TanktGerade[car] = true;
                            tanktimer[playerid] = SetTimerEx("Auftanken",500,true,"i",playerid);
                            return 1;
                        }
                        return SendClientMessage(playerid,Rot,"Du bist in keinem Fahrzeug (oder kein Fahrer).");
                    }

                }
            }
        }
        return 1;
    }
    //haus
    if (strcmp("/haus", cmdtext, true,10) == 0)
    {
        mysql_query("SELECT * FROM `Haus`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                for(new i;i<MAX_HAUS;i++)
                {
                    new string[128];
                    mysql_fetch_field_row(string,"hx");
                    Haus[i][hx] = floatstr(string);
                    mysql_fetch_field_row(string,"hy");
                    Haus[i][hy] = floatstr(string);
                    mysql_fetch_field_row(string,"hz");
                    Haus[i][hz] = floatstr(string);
                    mysql_fetch_field_row(string,"Hausid");
                    Haus[i][Hausid] = strval(string);
                    if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                    {
                        format(string, sizeof(string), "%s", mysql_GetStringz("Haus","Besitzer","Hausid",Haus[i][Hausid]));
                        SendClientMessage(playerid,Rot,string);
                        if(strcmp(sSpieler[playerid][pName], string, false) == 0)
                        {
                            new str10[128];
                            format(str10,sizeof(str10),"Betreten\nInteriors\nÖffnen/Schließen\nAusziehen");
                            ShowPlayerDialog(playerid,Hausmenue,DIALOG_STYLE_LIST,"Hausmenü",str10,"Wählen","Abbrechen");
                            return 1;

                        }
                        else
                        {
                            new Preisae[120];
                            new str11[128];
                            if(sSpieler[playerid][pAdmin] >= 10)
                            {
                                Preisae="Preis ändern";
                            }
                            else
                            {

                            }
                            format(str11,sizeof(str11),"Besichtigen\n%s",Preisae);
                            ShowPlayerDialog(playerid,HausmenueBesucher,DIALOG_STYLE_LIST,"Besuchermenü",str11,"Wählen","Abbrechen");
                            return 1;
                        }
                    }
                }
            }
        }
        return 1;
    }
    //Rauswerfen
    if (strcmp("/rauswerfen", cmdtext, true,10) == 0)
    {
        mysql_query("SELECT * FROM `Haus`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                for(new i;i<MAX_HAUS;i++)
                {
                    new string[128];
                    mysql_fetch_field_row(string,"hx");
                    Haus[i][hx] = floatstr(string);
                    mysql_fetch_field_row(string,"hy");
                    Haus[i][hy] = floatstr(string);
                    mysql_fetch_field_row(string,"hz");
                    Haus[i][hz] = floatstr(string);
                    mysql_fetch_field_row(string,"Hausid");
                    Haus[i][Hausid] = strval(string);
                    if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                    {
                        if(sSpieler[playerid][pAdmin] >= 1)
                        {
                            mysql_SetIntz("Haus","InBesitz",0,"Hausid",Haus[i][Hausid]);
                            mysql_SetIntz("Haus","Verschlossen",0,"Hausid",Haus[i][Hausid]);
                            mysql_SetStringz("Haus","Besitzer","Niemand","Hausid",Haus[i][Hausid]);
                            SendClientMessage(playerid, Rot, "Du hast das Haus resettet");
                            return 1;
                        }
                    }
                }
            }
        }
        return 1;
    }
    //Apfelbaum
    if (strcmp("/apfelbaum", cmdtext, true,10) == 0)
    {
        mysql_query("SELECT * FROM `apfelbaum`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                for(new i;i<MAX_APFEL;i++)
                {
                    new string[128];
                    mysql_fetch_field_row(string,"AX");
                    Apfelbaum[i][AX] = floatstr(string);
                    mysql_fetch_field_row(string,"AY");
                    Apfelbaum[i][AY] = floatstr(string);
                    mysql_fetch_field_row(string,"AZ");
                    Apfelbaum[i][AZ] = floatstr(string);
                    mysql_fetch_field_row(string,"ApfelID");
                    Apfelbaum[i][ApfelID] = strval(string);
                    if(IsPlayerInRangeOfPoint(playerid, 3, Apfelbaum[i][AX], Apfelbaum[i][AY], Apfelbaum[i][AZ]))
                    {
                        new str11[128];
                        format(str11,sizeof(str11),"Äpfel pflücken\nBewässern\nInfos\nZerstören");
                        ShowPlayerDialog(playerid,Apfelbaumz,DIALOG_STYLE_LIST,"Apfelbaum",str11,"Wählen","Abbrechen");
                        return 1;
                    }
                }
            }
        }
        return 1;
    }
    return 0;
}

//Apfelbaum erstellen
dcmd_newapfelbaum(playerid, params[])
{
    #pragma unused params
    new Float:hxz, Float: hyz, Float:hzz;
    new query[512];
    if(sSpieler[playerid][pAdmin] < 10)
    {
        return SendClientMessage(playerid,Rot,"Du bist kein Admin");
    }
    if(sSpieler[playerid][pApfelkern] <= 0 )
    {
        return SendClientMessage(playerid,Rot,"Du hast keine Apfelbaumsamen");
    }

    GetPlayerPos(playerid ,hxz, hyz, hzz);
    format(query, sizeof(query), "INSERT INTO Apfelbaum (ApfelID, Wasser, Ernte, AX, AY, AZ) VALUES ('%d', '100', '0', '%f', '%f', '%f')",ApfelIdIDX, hxz, hyz, hzz-1.1);
    mysql_query(query);
    mysql_free_result();
    CreateObject(700,hxz,hyz+1.1,hzz-1.1,0.00000000,0.00000000,270.00000000);
    new str[128];
    format(str,sizeof(str),"%d",ApfelIdIDX);
    SendClientMessage(playerid, Rot, str);
    sSpieler[playerid][pApfelkern] -= 1;
    ApfelIdIDX++;
    return 1;
}

//Bankautomat erstellen
dcmd_bnew(playerid, params[])
{
    new Float:hxz, Float: hyz, Float:hzz, Float:haz;
    new query[512],Notiz[128];
    if(sscanf(params,"s",Notiz))
    {
        return SendClientMessage(playerid,Rot,"Verwendung: /bnew [Notiz]");
    }
    if(sSpieler[playerid][pAdmin] < 10)
    {
        return SendClientMessage(playerid,Rot,"Du bist kein Admin");
    }
    GetPlayerPos(playerid ,hxz, hyz, hzz);
    GetPlayerFacingAngle(playerid,haz);
    format(query, sizeof(query), "INSERT INTO Bankautomaten (BankID, Notiz, BXz, BYz, BZz, BAz) VALUES ('%d', '%s', '%f', '%f', '%f', '%f')",BankIdIDX, Notiz, hxz, hyz, hzz-1.1, haz);
    mysql_query(query);
    mysql_free_result();
    CreateObject(2618,hxz,hyz+1.1,hzz-1.1,0.00000000,0.00000000,haz);
    new str[128];
    format(str,sizeof(str),"%d",BankIdIDX);
    SendClientMessage(playerid, Rot, str);
    BankIdIDX++;
    return 1;
}

//Bankautomat löschen
dcmd_delb(playerid, params[])
{
    new query[512],id;
    if(sscanf(params,"d",id))
    {
        return SendClientMessage(playerid,Rot,"Verwendung: /delb [ID]");
    }
    if(sSpieler[playerid][pAdmin] < 10)
    {
        return SendClientMessage(playerid,Rot,"Du bist kein Admin");
    }
    format(query,128,"DELETE FROM `Bankautomaten` WHERE `BankID` = '%d'",id);
    mysql_query(query);
    mysql_free_result();
    DestroyObject(id);
    return 1;
}

//Tankstelle erstellen
dcmd_tnew(playerid, params[])
{
    new Float:hxz, Float: hyz, Float:hzz;
    new lager,query[512],Notiz[512],preisan,preisve;
    if(sscanf(params,"sddd",Notiz,lager,preisan,preisve))
    {
        return SendClientMessage(playerid,Rot,"Verwendung: /tnew [Notiz] [LagerInhalt] [PREIS-Ankauf] [PREIS-Verkauf]");
    }
    if(sSpieler[playerid][pAdmin] < 10)
    {
        return SendClientMessage(playerid,Rot,"Du bist kein Admin");
    }
    GetPlayerPos(playerid ,hxz, hyz, hzz);
    CreatePickup(1239,1,hxz,hyz,hzz,-1);
    format(query, sizeof(query), "INSERT INTO Tankstellen (TankID, Notiz, Inhalt, PreisAN, PreisVE, TX, TY, TZ) VALUES ('%d', '%s', '%d', '%d', '%d', '%f', '%f', '%f')",TankIdIDX, Notiz, lager, preisan, preisve, hxz, hyz, hzz);
    mysql_query(query);
    mysql_free_result();
    new str[128];
    format(str,sizeof(str),"%d",TankIdIDX);
    SendClientMessage(playerid, Rot, str);
    TankIdIDX++;
    return 1;
}

//Haus erstellen
dcmd_createhouse(playerid, params[])
{
    new Float:hxz, Float: hyz, Float:hzz;
    new Preise,query[512];
    if(sscanf(params,"d",Preise))
    {
        return SendClientMessage(playerid,Rot,"Verwendung: /createhouse [Preis]");
    }
    if(sSpieler[playerid][pAdmin] < 10)
    {
        return SendClientMessage(playerid,Rot,"Du bist kein Admin");
    }
    GetPlayerPos(playerid ,hxz, hyz, hzz);
    CreatePickup(1273,1,hxz,hyz,hzz,-1);
    format(query, sizeof(query), "INSERT INTO Haus (Hausid, Besitzer, Preis, Preisz, Interiorz, InBesitz, Verschlossen, hx, hy, hz, hix, hiy, hiz) VALUES ('%d', 'Niemand', '%d', '%d', '1', '0', '0', '%f', '%f', '%f', '244.411987', '305.032989', '999.148437')",HausIdIDXz+PickIdIDX, Preise, Preise, hxz, hyz, hzz);
    mysql_query(query);
    mysql_free_result();
    new str[128];
    format(str,sizeof(str),"%d",HausIdIDXz+PickIdIDX);
    SendClientMessage(playerid, Rot, str);
    HausIdIDXz++;
    return 1;
}

//Haus Ausgang
dcmd_exit(playerid, params[])
{
    #pragma unused params
    mysql_query("SELECT * FROM `Haus`");
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        while(mysql_retrieve_row())
        {
            for(new i;i<MAX_HAUS;i++)
            {
                new string[512];
                mysql_fetch_field_row(string,"Interiorz");
                Haus[i][Interiorz] = strval(string);
                mysql_fetch_field_row(string,"hx");
                Haus[i][hx] = floatstr(string);
                mysql_fetch_field_row(string,"hy");
                Haus[i][hy] = floatstr(string);
                mysql_fetch_field_row(string,"hz");
                Haus[i][hz] = floatstr(string);
                mysql_fetch_field_row(string,"hix");
                Haus[i][hix] = floatstr(string);
                mysql_fetch_field_row(string,"hiy");
                Haus[i][hiy] = floatstr(string);
                mysql_fetch_field_row(string,"hiz");
                Haus[i][hiz] = floatstr(string);
                mysql_fetch_field_row(string,"Hausid");
                Haus[i][Hausid] = strval(string);
                if(IsPlayerInRangeOfPoint(playerid,3,Haus[i][hix],Haus[i][hiy],Haus[i][hiz]))
                {
                    if(Haus[i][Interiorz] == GetPlayerInterior(playerid) && Haus[i][Hausid] == GetPlayerVirtualWorld(playerid))
                    {
                        SetPlayerInterior(playerid, 0);
                        SetPlayerVirtualWorld(playerid, 0);
                        SetPlayerPos(playerid, Haus[i][hx], Haus[i][hy], Haus[i][hz]);
                        return 1;
                    }
                }
            }
        }
    }
    return 1;
}

//Buyhouse
dcmd_buyhouse(playerid, params[])
{
    #pragma unused params
    new string[512];
    mysql_query("SELECT * FROM `Haus`");
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        while(mysql_retrieve_row())
        {
            for(new i = 0; i < MAX_HAUS; i++)
            {
                mysql_fetch_field_row(string,"hx");
                Haus[i][hx] = floatstr(string);
                mysql_fetch_field_row(string,"hy");
                Haus[i][hy] = floatstr(string);
                mysql_fetch_field_row(string,"hz");
                Haus[i][hz] = floatstr(string);
                mysql_fetch_field_row(string,"Preis");
                Haus[i][Preis] = strval(string);
                mysql_fetch_field_row(string,"Hausid");
                Haus[i][Hausid] = strval(string);
                if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                {
                    mysql_fetch_field_row(string,"InBesitz");
                    Haus[i][InBesitz] = strval(string);
                    if(Haus[i][InBesitz] == 0)
                    {
                        if(GetPlayerMoney(playerid) >= Haus[i][Preis])
                        {
                            new test = 2;
                            GivePlayerMoney(playerid, -Haus[i][Preis]);
                            mysql_SetIntz("Haus","InBesitz",test,"Hausid",Haus[i][Hausid]);
                            mysql_SetStringz("Haus","Besitzer",sSpieler[playerid][pName],"Hausid",Haus[i][Hausid]);
                            //Dem Spieler wird das Haus zugeteilt usw..
                            SendClientMessage(playerid, Rot, "Du hast dieses Haus nun erfolgreich gekauft.");
                            return 1;
                        }
                        else
                        {
                            SendClientMessage(playerid, Rot, "Du hast nicht genug Geld um dieses Haus zu kaufen.");
                            return 1;
                        }
                    }
                    else
                    {
                        SendClientMessage(playerid, Rot, "Dieses Haus steht nicht zum Verkauf bereit.");
                        return 1;
                    }
                }
            }
        }
    }
    return 1;
}

//Fraktion New
dcmd_fnew(playerid,params[])
{
    new name[128],kasse,query[512];
    if(sscanf(params,"si",name,kasse))return SendClientMessage(playerid, 0xFF3A3AFF,"/fnew [FrakName] [FrakKasse]");
    if(sSpieler[playerid][pAdmin] < 10)
    {
        return SendClientMessage(playerid,Rot,"Adm: Du bist kein Admin");
    }
    else
    {
        FrakIdIDX++;
        format(query, sizeof(query), "INSERT INTO Fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('%d', '%s', '%d', '0')",FrakIdIDX, name, kasse);
        mysql_query(query);
        mysql_free_result();
        format(query,sizeof(query),"Du hast eine Fraktion mit der ID: %d erstellt. Name: %s",FrakIdIDX,name);
        SendClientMessage(playerid,Grün,query);
        return 1;
    }
}

//Fraktion Spawn
dcmd_fspawn(playerid,params[])
{
    new frak,query[512];
    new Float: SXs, Float: SYs, Float: SZs;
    if(sscanf(params,"i",frak))return SendClientMessage(playerid, 0xFF3A3AFF,"/fspawn [FrakID]");
    if(sSpieler[playerid][pAdmin] < 10)
    {
        return SendClientMessage(playerid,Rot,"Adm: Du bist kein Admin");
    }
    else
    {
        GetPlayerPos(playerid,SXs,SYs,SZs);
        format(query, sizeof(query), "INSERT INTO Spawns (FrakID, SX, SY, SZ) VALUES ('%d', '%f', '%f', '%f')",frak, SXs, SYs, SZs);
        mysql_query(query);
        mysql_free_result();
        format(query,sizeof(query),"Du hast ein Spawn für die Fraktion mit der ID: %d erstellt",frak);
        SendClientMessage(playerid,Grün,query);
        return 1;
    }
}

//Fraktion Spawn
dcmd_fdelspawn(playerid,params[])
{
    new frak,query[512];
    if(sscanf(params,"i",frak))return SendClientMessage(playerid, 0xFF3A3AFF,"/fdelspawn [FrakID]");
    if(sSpieler[playerid][pAdmin] < 10)
    {
        return SendClientMessage(playerid,Rot,"Adm: Du bist kein Admin");
    }
    else
    {

        format(query,128,"DELETE FROM `Spawns` WHERE `FrakID` = '%d'",frak);
        mysql_query(query);
        mysql_free_result();
        format(query,sizeof(query),"Du hast ein Spawn für die Fraktion mit der ID: %d gelöscht",frak);
        SendClientMessage(playerid,Grün,query);
        return 1;
    }
}

//Makeadmin
dcmd_makeadmin(playerid,params[])
{
    new pid,adm;
    if(sscanf(params,"ui",pid,adm))return SendClientMessage(playerid, 0xFF3A3AFF,"/makeadmin [Spieler] [AdminLevel]");
    if(sSpieler[playerid][pAdmin] < 10)
    {
        return SendClientMessage(playerid,Rot,"Adm: Du bist kein Admin");
    }
    sSpieler[pid][pAdmin] = adm;
    return 1;
}

//Makeleader
dcmd_makeleader(playerid,params[])
{
    new pid, frakid;
    if(sscanf(params,"ud",pid,frakid))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung; /makeleader [ID] [FraktionsId]");
    }
    if(frakid > 40)
    {
        return SendClientMessage(playerid,Rot,"So viele Fraktionen gibt es nicht!");
    }
    if(sSpieler[playerid][pAdmin] >= 5)
    {
        if(pid == INVALID_PLAYER_ID)
        {
            return SendClientMessage(playerid,Rot,"Ungültiger Spieler");
        }
        else
        {
            new str[128];
            format(str,sizeof(str),"Admin %s hat dich zum Leader einer Fraktion gemacht.",sSpieler[playerid][pName]);
            sSpieler[pid][pFraktion] = frakid;
            sSpieler[pid][pRang] = 6;
            SendClientMessage(pid,Gelb,str);
            SendClientMessage(playerid,Gelb,"Du hast den angegebenden Spieler in eine Fraktion getan.");
        }
    }
    else
    {
        return SendClientMessage(playerid,Rot,"Du bis kein Admin!");
    }
    return 1;
}

//Makejob
dcmd_makejob(playerid,params[])
{
    new pid, jobid;
    if(sscanf(params,"ud",pid,jobid))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung; /makejob [ID] [JobId]");
    }
    if(jobid > 40)
    {
        return SendClientMessage(playerid,Rot,"So viele Jobs gibt es nicht!");
    }
    if(sSpieler[playerid][pAdmin] >= 5)
    {
        if(pid == INVALID_PLAYER_ID)
        {
            return SendClientMessage(playerid,Rot,"Ungültiger Spieler");
        }
        else
        {
            new str[128];
            format(str,sizeof(str),"Teammitglied %s hat dein Job geändert.",sSpieler[playerid][pName]);
            mysql_SetInt("Accounts","Job",jobid,"username",sSpieler[pid][pName]);
            SendClientMessage(pid,Gelb,str);
            SendClientMessage(playerid,Gelb,"Du hast den angegebenden Spieler einen Job gegeben.");
        }
    }
    else
    {
        return SendClientMessage(playerid,Rot,"Du bis kein Admin!");
    }
    return 1;
}

//Pickup erstellen
dcmd_pickup(playerid,params[])
{
    new Float:vehx,Float:vehy,Float:vehz,Modelpickid,Pickidcreate,query[512];
    if(sscanf(params,"i",Modelpickid))return SendClientMessage(playerid, 0xFF3A3AFF,"/pickup [PICKUP-ID]");
    GetPlayerPos(playerid,vehx,vehy,vehz);
    if(PickIdIDX!=MAX_PICKUPS)
    {
        PickIdIDX++;
        Pickidcreate = CreatePickup(Modelpickid,1,vehx,vehy,vehz,-1);
        format(query, sizeof(query),"SVR:%d",Pickidcreate);
        SetVehicleNumberPlate(Pickidcreate,query);
        Pickups[PickIdIDX][Pickid]=PickIdIDX;
        Pickups[PickIdIDX][Modelid]=Modelpickid;
        Pickups[PickIdIDX][X]=vehx;
        Pickups[PickIdIDX][Y]=vehy;
        Pickups[PickIdIDX][Z]=vehz;
        format(query, sizeof(query), "INSERT INTO Pickups (Pickid, Modelid, X, Y, Z) VALUES ('%d', '%d', '%f', '%f', '%f')",PickIdIDX, Modelpickid, vehx, vehy, vehz);
        mysql_query(query);
        mysql_free_result();
        format(query, 128, "Du hast ein Pickup mit der ID: %d erstellt",Pickidcreate);
        SendClientMessage(playerid,0x008000FF,query);
        return 1;
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Es sind bereits 500 Serverautos eingetragen");
    }
    return 1;
}

//Delpickup
dcmd_delpickup(playerid,params[])
{
    #pragma unused params
    new query[128];
    mysql_query("SELECT * FROM `Pickups`");
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        while(mysql_retrieve_row())
        {
            for(new i;i<MAX_PICKUPS;i++)
            {
                new string[512];
                mysql_fetch_field_row(string,"Pickid");
                Pickups[i][Pickid] = strval(string);
                mysql_fetch_field_row(string,"Modelid");
                Pickups[i][Modelid] = strval(string);
                mysql_fetch_field_row(string,"X");
                Pickups[i][X] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                Pickups[i][Y] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                Pickups[i][Z] = floatstr(string);
                if(IsPlayerInRangeOfPoint(playerid,3,Pickups[i][X],Pickups[i][Y],Pickups[i][Z]))
                {
                    if(sSpieler[playerid][pAdmin] < 10)
                    {
                        return SendClientMessage(playerid,Rot,"Adm: Du bist kein Admin");
                    }
                    DestroyPickup(Pickups[i][Pickid]);
                    format(query,128,"DELETE FROM `pickups` WHERE `Pickid` = '%d'",Pickups[i][Pickid]);
                    mysql_query(query);
                    mysql_free_result();
                    format(query, 128, "Du hast das Pickup gelöscht");
                    SendClientMessage(playerid,0x008000FF,query);
                    return 1;
                }
            }
        }
    }
    return 1;
}

//Delpickupid
dcmd_delpickupid(playerid,params[])
{
    new Modelpickid,query[500];
    if(sscanf(params,"i",Modelpickid))return SendClientMessage(playerid, 0xFF3A3AFF,"/delpickupid [PICKUP-ID]");
    if(sSpieler[playerid][pAdmin] >= 10)
    {
        mysql_query("SELECT * FROM `Pickups`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                if(sSpieler[playerid][pAdmin] < 10)
                {
                    return SendClientMessage(playerid,Rot,"Adm: Du bist kein Admin");
                }
                format(query,128,"DELETE FROM `pickups` WHERE `Pickid` = '%d'",Modelpickid);
                mysql_query(query);
                DestroyPickup(Modelpickid);
                mysql_free_result();
                format(query, 128, "Du hast das Pickup mit der ID: %d vom Server gelöscht", Modelpickid);
                SendClientMessage(playerid,0x008000FF,query);
                return 1;
            }
        }
    }
    return 1;
}

//Mietauto erstellen
dcmd_newmcar(playerid,params[])
{
    new carid,c1,c2,query[512],mietcarid, preis;
    new Float:vehx,Float:vehy,Float:vehz,Float:veha;
    if(sscanf(params,"iiii",carid,c1,c2,preis))return SendClientMessage(playerid, 0xFF3A3AFF,"/nemfcar [CAR-ID] [COLOR1] [COLOR-2] [PREIS]");
    if(carid < 400 || carid > 610 ) return SendClientMessage(playerid,0xFF3A3AFF,"Bitte wähle ein Fahrzeug zwischen 400 und 610");
    GetPlayerPos(playerid,vehx,vehy,vehz);
    GetPlayerFacingAngle(playerid,veha);
    if(FrakVehIDX!=MAX_FRAKTION_CARS)
    {
        MietVehIDX++;
        mietcarid = CreateVehicle(carid,vehx,vehy,vehz,veha,c1,c2,1000*60*5);
        PutPlayerInVehicle(playerid, mietcarid, 0);
        format(query, sizeof(query),"SVR:%d",mietcarid);
        SetVehicleNumberPlate(mietcarid,query);
        MietCars[MietVehIDX][MietCarID]=GetPlayerVehicleID(playerid);
        MietCars[MietVehIDX][MietModelID]=carid;
        MietCars[MietVehIDX][mX]=vehx;
        MietCars[MietVehIDX][mY]=vehy;
        MietCars[MietVehIDX][mZ]=vehz;
        MietCars[MietVehIDX][mA]=veha;
        MietCars[MietVehIDX][mColor1]=c1;
        MietCars[MietVehIDX][mColor2]=c2;
        format(query, sizeof(query), "INSERT INTO mietcars (carID, carModel, Farbe1, Farbe2, X, Y, Z, A, Preis, Besitzer) VALUES ('%d', '%d', '%d', '%d', '%f', '%f', '%f', '%f', '%d', '1')", GetPlayerVehicleID(playerid), carid, c1, c2, vehx, vehy, vehz, veha, preis);
        mysql_query(query);
        mysql_free_result();
        format(query, 128, "Du hast ein Car mit der ID: %d erstellt", MietCars[MietVehIDX][MietCarID]);
        SendClientMessage(playerid,0x008000FF,query);
        return 1;
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Es sind bereits 500 Mietautos eingetragen");
    }
    return 1;
}

//(M)Auto Parken
dcmd_mpark(playerid,params[])
{
    #pragma unused params
    new query[128];
    new Float:vehx,Float:vehy,Float:vehz,Float:veha;
    new carid = GetPlayerVehicleID(playerid);
    GetVehiclePos(carid,vehx,vehy,vehz);
    GetVehicleZAngle(carid,veha);
    if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
    {
        for(new i;i<MAX_MIET_CARS;i++)
        {
            if(GetPlayerVehicleID(playerid)==MietCars[i][MietCarID])
            {
                if(sSpieler[playerid][pAdmin] < 10)
                {
                    return SendClientMessage(playerid,Rot,"Adm: Du bist kein Admin");
                }
                format(query, 128, "UPDATE mietcars SET X = '%f' WHERE carID = '%d'", vehx, MietCars[i][MietCarID]);
                mysql_query(query);
                format(query, 128, "UPDATE mietcars SET Y = '%f' WHERE carID = '%d'", vehy, MietCars[i][MietCarID]);
                mysql_query(query);
                format(query, 128, "UPDATE mietcars SET Z = '%f' WHERE carID = '%d'", vehz, MietCars[i][MietCarID]);
                mysql_query(query);
                format(query, 128, "UPDATE mietcars SET A = '%f' WHERE carID = '%d'", veha, MietCars[i][MietCarID]);
                mysql_query(query);
                mysql_free_result();
                format(query, 128, "Du hast das Mietfahrzeug mit der ID: %d umgeparkt", MietCars[i][MietCarID]);
                SendClientMessage(playerid,0x008000FF,query);
                return 1;
            }
        }
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
    }
    return 1;
}

//(M)Auto Löschen
dcmd_delmcar(playerid,params[])
{
    #pragma unused params
    new query[128];
    if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
    {
        for(new i;i<MAX_MIET_CARS;i++)
        {
            if(GetPlayerVehicleID(playerid)==MietCars[i][MietCarID])
            {
                if(sSpieler[playerid][pAdmin] < 10)
                {
                    return SendClientMessage(playerid,Rot,"Adm: Du bist kein Admin");
                }
                format(query,128,"DELETE FROM `mietcars` WHERE `carID` = '%d'",MietCars[i][MietCarID]);
                mysql_query(query);
                DestroyVehicle(MietCars[i][MietCarID]);
                mysql_free_result();
                format(query, 128, "Du hast das Mietfahrzeug mit der ID: %d vom Server gelöscht", MietCars[i][MietCarID]);
                SendClientMessage(playerid,0x008000FF,query);
                return 1;
            }
        }
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
    }
    return 1;
}

//Job erstellen
dcmd_newjcar(playerid,params[])
{
    new carid,c1,c2,query[512],frakcarid, frakid;
    new Float:vehx,Float:vehy,Float:vehz,Float:veha;
    if(sscanf(params,"iiii",carid,frakid,c1,c2))return SendClientMessage(playerid, 0xFF3A3AFF,"/newjcar [CAR-ID] [JOB-ID] [COLOR1] [COLOR-2]");
    if(carid < 400 || carid > 610 ) return SendClientMessage(playerid,0xFF3A3AFF,"Bitte wähle ein Fahrzeug zwischen 400 und 610");
    GetPlayerPos(playerid,vehx,vehy,vehz);
    GetPlayerFacingAngle(playerid,veha);
    if(JobVehIDX!=MAX_JOB_CARS)
    {
        JobVehIDX++;
        frakcarid = CreateVehicle(carid,vehx,vehy,vehz,veha,c1,c2,1000*60*5);
        PutPlayerInVehicle(playerid, frakcarid, 0);
        format(query, sizeof(query),"Job:%d",frakcarid);
        SetVehicleNumberPlate(frakcarid,query);
        JobCars[JobVehIDX][JobCarID]=GetPlayerVehicleID(playerid);
        JobCars[JobVehIDX][JobModelID]=carid;
        JobCars[JobVehIDX][JobID]=frakid;
        JobCars[JobVehIDX][jX]=vehx;
        JobCars[JobVehIDX][jY]=vehy;
        JobCars[JobVehIDX][jZ]=vehz;
        JobCars[JobVehIDX][jA]=veha;
        JobCars[JobVehIDX][jColor1]=c1;
        JobCars[JobVehIDX][jColor2]=c2;
        format(query, sizeof(query), "INSERT INTO jobcars (carID, carModel, JobID, Farbe1, Farbe2, X, Y, Z, A) VALUES ('%d', '%d', '%d', '%d', '%d', '%f', '%f', '%f', '%f')", GetPlayerVehicleID(playerid), carid, frakid, c1, c2, vehx, vehy, vehz, veha);
        mysql_query(query);
        mysql_free_result();
        format(query, 128, "Du hast ein Car mit der ID: %d erstellt", JobCars[JobVehIDX][JobCarID]);
        SendClientMessage(playerid,0x008000FF,query);
        return 1;
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Es sind bereits 500 Jobcars eingetragen");
    }
    return 1;
}

//(J)Auto Parken
dcmd_jpark(playerid,params[])
{
    #pragma unused params
    new query[128];
    new Float:vehx,Float:vehy,Float:vehz,Float:veha;
    new carid = GetPlayerVehicleID(playerid);
    GetVehiclePos(carid,vehx,vehy,vehz);
    GetVehicleZAngle(carid,veha);
    if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
    {
        for(new i;i<MAX_JOB_CARS;i++)
        {
            if(GetPlayerVehicleID(playerid)==JobCars[i][JobCarID])
            {
                if(sSpieler[playerid][pAdmin] < 10)
                {
                    SendClientMessage(playerid,Rot,"Du bist kein Admin");
                    RemovePlayerFromVehicle(playerid);
                    return 1;
                }
                format(query, 128, "UPDATE jobcars SET X = '%f' WHERE carID = '%d'", vehx, JobCars[i][JobCarID]);
                mysql_query(query);
                format(query, 128, "UPDATE jobcars SET Y = '%f' WHERE carID = '%d'", vehy, JobCars[i][JobCarID]);
                mysql_query(query);
                format(query, 128, "UPDATE jobcars SET Z = '%f' WHERE carID = '%d'", vehz, JobCars[i][JobCarID]);
                mysql_query(query);
                format(query, 128, "UPDATE jobcars SET A = '%f' WHERE carID = '%d'", veha, JobCars[i][JobCarID]);
                mysql_query(query);
                mysql_free_result();
                format(query, 128, "Du hast das Jobfahrzeug mit der ID: %d umgeparkt", JobCars[i][JobCarID]);
                SendClientMessage(playerid,0x008000FF,query);
                return 1;
            }
        }
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
    }
    return 1;
}

//(J)Auto Löschen
dcmd_deljcar(playerid,params[])
{
    #pragma unused params
    new query[128];
    if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
    {
        for(new i;i<MAX_JOB_CARS;i++)
        {
            if(GetPlayerVehicleID(playerid)==JobCars[i][JobCarID])
            {
                if(sSpieler[playerid][pAdmin] < 10)
                {
                    return SendClientMessage(playerid,Rot,"Adm: Du bist kein Admin");
                }
                format(query,128,"DELETE FROM `jobcars` WHERE `carID` = '%d'",JobCars[i][JobCarID]);
                mysql_query(query);
                DestroyVehicle(JobCars[i][JobCarID]);
                mysql_free_result();
                format(query, 128, "Du hast das Jobfahrzeug mit der ID: %d vom Server gelöscht", JobCars[i][JobCarID]);
                SendClientMessage(playerid,0x008000FF,query);
                return 1;
            }
        }
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
    }
    return 1;
}

//Frakauto erstellen
dcmd_newfcar(playerid,params[])
{
    new carid,c1,c2,query[512],frakcarid, frakid;
    new Float:vehx,Float:vehy,Float:vehz,Float:veha;
    if(sscanf(params,"iiii",carid,frakid,c1,c2))return SendClientMessage(playerid, 0xFF3A3AFF,"/newfcar [CAR-ID] [FRAK-ID] [COLOR1] [COLOR-2]");
    if(carid < 400 || carid > 610 ) return SendClientMessage(playerid,0xFF3A3AFF,"Bitte wähle ein Fahrzeug zwischen 400 und 610");
    GetPlayerPos(playerid,vehx,vehy,vehz);
    GetPlayerFacingAngle(playerid,veha);
    if(FrakVehIDX!=MAX_FRAKTION_CARS)
    {
        FrakVehIDX++;
        frakcarid = CreateVehicle(carid,vehx,vehy,vehz,veha,c1,c2,1000*60*5);
        PutPlayerInVehicle(playerid, frakcarid, 0);
        format(query, sizeof(query),"SVR:%d",frakcarid);
        SetVehicleNumberPlate(frakcarid,query);
        FrakCars[FrakVehIDX][fCarID]=GetPlayerVehicleID(playerid);
        FrakCars[FrakVehIDX][fModelID]=carid;
        FrakCars[FrakVehIDX][FrakID]=frakid;
        FrakCars[FrakVehIDX][sX]=vehx;
        FrakCars[FrakVehIDX][sY]=vehy;
        FrakCars[FrakVehIDX][sZ]=vehz;
        FrakCars[FrakVehIDX][sA]=veha;
        FrakCars[FrakVehIDX][sColor1]=c1;
        FrakCars[FrakVehIDX][sColor2]=c2;
        format(query, sizeof(query), "INSERT INTO fraktioncars (carID, carModel, FrakID, Farbe1, Farbe2, X, Y, Z, A) VALUES ('%d', '%d', '%d', '%d', '%d', '%f', '%f', '%f', '%f')", GetPlayerVehicleID(playerid), carid, frakid, c1, c2, vehx, vehy, vehz, veha);
        mysql_query(query);
        mysql_free_result();
        format(query, 128, "Du hast ein Car mit der ID: %d erstellt", FrakCars[FrakVehIDX][fCarID]);
        SendClientMessage(playerid,0x008000FF,query);
        return 1;
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Es sind bereits 500 Serverautos eingetragen");
    }
    return 1;
}

//(F)Auto Parken
dcmd_fpark(playerid,params[])
{
    #pragma unused params
    new query[128];
    new Float:vehx,Float:vehy,Float:vehz,Float:veha;
    new carid = GetPlayerVehicleID(playerid);
    GetVehiclePos(carid,vehx,vehy,vehz);
    GetVehicleZAngle(carid,veha);
    if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
    {
        for(new i;i<MAX_VEHICLES;i++)
        {
            if(GetPlayerVehicleID(playerid)==FrakCars[i][fCarID])
            {
                if(sSpieler[playerid][pFraktion] != FrakCars[i][FrakID])
                {
                    SendClientMessage(playerid,Rot,"Das Fahrzeug gehört nicht zu deiner Fraktion");
                    RemovePlayerFromVehicle(playerid);
                    return 1;
                }
                format(query, 128, "UPDATE fraktioncars SET X = '%f' WHERE carID = '%d'", vehx, FrakCars[i][fCarID]);
                mysql_query(query);
                format(query, 128, "UPDATE fraktioncars SET Y = '%f' WHERE carID = '%d'", vehy, FrakCars[i][fCarID]);
                mysql_query(query);
                format(query, 128, "UPDATE fraktioncars SET Z = '%f' WHERE carID = '%d'", vehz, FrakCars[i][fCarID]);
                mysql_query(query);
                format(query, 128, "UPDATE fraktioncars SET A = '%f' WHERE carID = '%d'", veha, FrakCars[i][fCarID]);
                mysql_query(query);
                mysql_free_result();
                format(query, 128, "Du hast das Fraktionsfahrzeug mit der ID: %d umgeparkt", FrakCars[i][fCarID]);
                SendClientMessage(playerid,0x008000FF,query);
                return 1;
            }
        }
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
    }
    return 1;
}

//(F)Auto Löschen
dcmd_delfcar(playerid,params[])
{
    #pragma unused params
    new query[128];
    if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
    {
        for(new i;i<MAX_VEHICLES;i++)
        {
            if(GetPlayerVehicleID(playerid)==FrakCars[i][fCarID])
            {
                if(sSpieler[playerid][pAdmin] < 10)
                {
                    return SendClientMessage(playerid,Rot,"Adm: Du bist kein Admin");
                }
                format(query,128,"DELETE FROM `fraktioncars` WHERE `carID` = '%d'",FrakCars[i][fCarID]);
                mysql_query(query);
                DestroyVehicle(FrakCars[i][fCarID]);
                mysql_free_result();
                format(query, 128, "Du hast das Fraktionsfahrzeug mit der ID: %d vom Server gelöscht", FrakCars[i][fCarID]);
                SendClientMessage(playerid,0x008000FF,query);
                return 1;
            }
        }
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
    }
    return 1;
}

//Auto erstellen
dcmd_newscar(playerid,params[])
{
    new carid,c1,c2,query[512],serverid;
    new Float:vehx,Float:vehy,Float:vehz,Float:veha;
    if(sscanf(params,"iii",carid,c1,c2))return SendClientMessage(playerid, 0xFF3A3AFF,"/newscar [CAR-ID] [COLOR11] [COLOR-2]");
    if(carid < 400 || carid > 610 ) return SendClientMessage(playerid,0xFF3A3AFF,"Bitte wähle ein Fahrzeug zwischen 400 und 610");
    GetPlayerPos(playerid,vehx,vehy,vehz);
    GetPlayerFacingAngle(playerid,veha);
    if(ServerVehIDX!=MAX_SERVER_CARS)
    {
        ServerVehIDX++;
        serverid=CreateVehicle(carid,vehx,vehy,vehz,veha,c1,c2,1000*60*5);
        PutPlayerInVehicle(playerid, serverid, 0);
        format(query, sizeof(query),"SVR:%d",serverid);
        SetVehicleNumberPlate(serverid,query);
        ServerVeh[ServerVehIDX][sCarID]=GetPlayerVehicleID(playerid);
        ServerVeh[ServerVehIDX][sModelID]=carid;
        ServerVeh[ServerVehIDX][sX]=vehx;
        ServerVeh[ServerVehIDX][sY]=vehy;
        ServerVeh[ServerVehIDX][sZ]=vehz;
        ServerVeh[ServerVehIDX][sA]=veha;
        ServerVeh[ServerVehIDX][sColor1]=c1;
        ServerVeh[ServerVehIDX][sColor2]=c2;
        format(query, sizeof(query), "INSERT INTO ServerCars (carID, carModel, Farbe1, Farbe2, X, Y, Z, A) VALUES ('%d', '%d', '%d', '%d', '%f', '%f', '%f', '%f')", GetPlayerVehicleID(playerid), carid, c1, c2, vehx, vehy, vehz, veha);
        mysql_query(query);
        mysql_free_result();
        format(query, 128, "Du hast ein Car mit der ID: %d erstellt", ServerVeh[ServerVehIDX][sCarID]);
        SendClientMessage(playerid,0x008000FF,query);
        return 1;
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Es sind bereits 500 Serverautos eingetragen");
    }
    return 1;
}

//Auto Parken
dcmd_spark(playerid,params[])
{
    #pragma unused params
    new query[128];
    new Float:vehx,Float:vehy,Float:vehz,Float:veha;
    new carid = GetPlayerVehicleID(playerid);
    GetVehiclePos(carid,vehx,vehy,vehz);
    GetVehicleZAngle(carid,veha);
    if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
    {
        for(new i;i<MAX_VEHICLES;i++)
        {
            if(GetPlayerVehicleID(playerid)==ServerVeh[i][sCarID])
            {
                  format(query, 128, "UPDATE ServerCars SET X = '%f' WHERE carID = '%d'", vehx, ServerVeh[i][sCarID]);
                  mysql_query(query);
                  format(query, 128, "UPDATE ServerCars SET Y = '%f' WHERE carID = '%d'", vehy, ServerVeh[i][sCarID]);
                  mysql_query(query);
                  format(query, 128, "UPDATE ServerCars SET Z = '%f' WHERE carID = '%d'", vehz, ServerVeh[i][sCarID]);
                  mysql_query(query);
                  format(query, 128, "UPDATE ServerCars SET A = '%f' WHERE carID = '%d'", veha, ServerVeh[i][sCarID]);
                  mysql_query(query);
                  mysql_free_result();
                  format(query, 128, "Du hast das Car mit der ID: %d umgeparkt", ServerVeh[i][sCarID]);
                  SendClientMessage(playerid,0x008000FF,query);
                  return 1;
            }
        }
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
    }
    return 1;
}

//Bombe erstellen
dcmd_legen(playerid,params[])
{
    #pragma unused params
    new query[512];
    new Float:vehx,Float:vehy,Float:vehz;
    GetPlayerPos(playerid,vehx,vehy,vehz);
    if(BombeIdIDX!=MAX_BOMBE)
    {
        if(sSpieler[playerid][pBombe] >0)
        {
            return SendClientMessage(playerid,Rot,"Du hast schon eine Bombe gelegt");
        }
        BombeIdIDX++;
        Bomben[BombeIdIDX][BX]=vehx;
        Bomben[BombeIdIDX][BY]=vehy;
        Bomben[BombeIdIDX][BZ]=vehz;
        format(query, sizeof(query), "INSERT INTO bomben (BombenID, Timer, BXz, BYz, BZz) VALUES ('%d', '5', '%f', '%f', '%f')", BombeIdIDX, vehx, vehy, vehz);
        mysql_query(query);
        mysql_free_result();
        sSpieler[playerid][pBombe] = BombeIdIDX;
        return 1;
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Es sind bereits genug bomben eingetragen");
    }
    return 1;
}

//Bombe zünden
dcmd_zuenden(playerid,params[])
{
    #pragma unused params
    new query[512];
    new Float:vehx,Float:vehy,Float:vehz;
    if(sSpieler[playerid][pBombe] == 0)
    {
        return SendClientMessage(playerid,Rot,"Du hast noch keine Bombe gelegt");
    }
    vehx = Float:mysql_GetFloatz("bomben","BXz","BombenID",sSpieler[playerid][pBombe]);
    vehy = Float:mysql_GetFloatz("bomben","BYz","BombenID",sSpieler[playerid][pBombe]);
    vehz = Float:mysql_GetFloatz("bomben","BZz","BombenID",sSpieler[playerid][pBombe]);

    CreateExplosion(vehx,vehy,vehz,10,10);
    CreateExplosion(vehx,vehy+8,vehz,10,10);
    CreateExplosion(vehx+8,vehy,vehz,10,10);
    CreateExplosion(vehx,vehy-8,vehz,10,10);
    CreateExplosion(vehx-8,vehy,vehz,10,10);

    format(query,128,"DELETE FROM `bomben` WHERE `BombenID` = '%d'",sSpieler[playerid][pBombe]);
    mysql_query(query);
    mysql_free_result();
    sSpieler[playerid][pBombe] = 0;
    return 1;
}

//AdPoint
dcmd_ad(playerid,params[])
{
    new str1[128];
    new Grund;
    if(sscanf(params,"s",Grund))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /ad [Werbung]");
    }
    if(GetPlayerMoney(playerid) < 1000)
    {
        SendClientMessage(playerid,Rot,"Du hast nicht genug Geld");
        return 1;
    }
    else
    {
        GivePlayerMoney(playerid, -1000);
        format(str1,sizeof(str1),"Werbung: %s. Absender: %s",Grund,sSpieler[playerid][pName]);
        SendClientMessageToAll(Grün,str1);
    }
    return 1;
}

//Afk
dcmd_afk(playerid,params[])
{
    new str1[128];
    new Grund;
    if(sscanf(params,"s",Grund))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /afk [Grund]");
    }
    if(sSpieler[playerid][pAfk] == 0)
    {
        format(str1,sizeof(str1),"{ff0000}%s {ffd700}ist nun Afk  Grund: %s",sSpieler[playerid][pName],Grund);
        sSpieler[playerid][pAfk] = 1;
        SendClientMessageToAll(Gelb,str1);
        SendClientMessage(playerid,Gelb,"Benutze /back wenn du wieder da bist");
    }
    else
    {
        SendClientMessage(playerid,Rot,"Du bist schon Afk");
    }
    return 1;
}

//Setheal
dcmd_setheal(playerid,params[])
{
    new Float:health; GetPlayerHealth(playerid, health);
    new str1[128];
    new str2[128];
    new pid,zahl;
    if(sscanf(params,"ud",pid,zahl))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /setheal [Spieler] [Heal]");
    }
    if(sSpieler[playerid][pAdmin] >=5)
    {
        format(str1,sizeof(str1),"{ffd700}Du hast {ff0000}%s {ffd700}gehealt",sSpieler[pid][pName]);
        format(str2,sizeof(str2),"{ff0000}%s {ffd700}hat dich gehealt",sSpieler[playerid][pName]);
        SendClientMessage(playerid,Gelb,str1);
        SetPlayerHealth(pid, zahl);
        SendClientMessage(pid,Gelb,str2);
        return 1;
    }
    else
    {
        SendClientMessage(playerid,Rot,"Du bist kein Admin");
    }
    return 1;
}

//Setarmour
dcmd_setarmour(playerid,params[])
{
    new str1[128];
    new str2[128];
    new pid;
    if(sscanf(params,"u",pid))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /setarmour [Spieler]");
    }
    if(sSpieler[playerid][pAdmin] >=5)
    {
        format(str1,sizeof(str1),"Du hast {ff0000}%s {ffd700}eine Rüssi gegeben",sSpieler[pid][pName]);
        format(str2,sizeof(str2),"{ff0000}%s {ffd700}hat dir eine Rüssi gegeben",sSpieler[playerid][pName]);
        SendClientMessage(playerid,Gelb,str1);
        SetPlayerArmour(pid, 100);
        SendClientMessage(pid,Gelb,str2);
        return 1;
    }
    else
    {
        SendClientMessage(playerid,Rot,"Du bist kein Admin");
    }
    return 1;
}

//me
dcmd_me(playerid,params[])
{
    new Grund[128];
    new Grundz[128];
    if(sscanf(params,"s",Grund))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /me [Nachricht]");
    }
    else
    {
        format(Grundz,sizeof(Grundz),"{ff0000}*%s{ffd700} %s",sSpieler[playerid][pName],Grund);
        SendClientMessageToAll(Gelb,Grundz);
        return 1;
    }
}

//Goto
dcmd_goto(playerid,params[])
{
    new pid;
    new str[128];
    new Float: hxz, Float: yxz, Float: zxz;
    if(sscanf(params,"u",pid))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /goto [Spieler]");
    }
    if(pid == INVALID_PLAYER_ID)
    {
        return SendClientMessage(playerid,Rot,"Ungültiger Spieler");
    }
    if(sSpieler[playerid][pAdmin] >=5)
    {
        new vw = GetPlayerVirtualWorld(pid);
        new Int = GetPlayerInterior(pid);
        format(str,sizeof(str),"{ffff00}Du hast dich zu {ff0000}%s {ffff00}telepotiert",sSpieler[playerid][pName]);
        SendClientMessage(playerid,Gelb,str);
        GetPlayerPos(pid, hxz, yxz, zxz);
        SetPlayerPos(playerid, hxz, yxz, zxz);
        SetPlayerVirtualWorld(playerid,vw);
        SetPlayerInterior(playerid,Int);
        return 1;
    }
    else
    {
        return SendClientMessage(playerid,Rot,"Du bist kein Admin");
    }
}

//Tphere
dcmd_tphere(playerid,params[])
{
    new pid;
    new str[128], str2[128];
    new Float: hxz, Float: yxz, Float: zxz;
    if(sscanf(params,"u",pid))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /tphere [Spieler]");
    }
    if(pid == INVALID_PLAYER_ID)
    {
        return SendClientMessage(playerid,Rot,"Ungültiger Spieler");
    }
    if(sSpieler[playerid][pAdmin] >=5)
    {
        new vw = GetPlayerVirtualWorld(playerid);
        new Int = GetPlayerInterior(playerid);
        format(str2,sizeof(str2),"{ffff00}Du hast {ff0000}%s {ffff00}zu dir telepotiert", sSpieler[pid][pName]);
        format(str,sizeof(str),"{ff0000}%s {ffff00}hat dich telepotiert",sSpieler[playerid][pName]);
        SendClientMessage(pid,Gelb,str);
        SendClientMessage(playerid,Rot,str2);
        GetPlayerPos(playerid, hxz, yxz, zxz);
        SetPlayerPos(pid, hxz, yxz, zxz);
        SetPlayerVirtualWorld(pid,vw);
        SetPlayerInterior(pid,Int);
        return 1;
    }
    else
    {
        return SendClientMessage(playerid,Rot,"Du bist kein Admin");
    }
}

//Kicken
dcmd_kick(playerid,params[])
{
    new pid;
    new str1[64];
    new Grund[128];
    if(sscanf(params,"uz",pid,Grund))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /kicken [Spieler] [Grund]");
    }
    if(pid == INVALID_PLAYER_ID)
    {
        return SendClientMessage(playerid,Rot,"Ungültiger Spieler");
    }
    if(sSpieler[playerid][pAdmin] >=5)
    {
        format(str1,sizeof(str1),"{ff0000}%s {ffd700}wurde gekickt  Grund: %s",sSpieler[playerid][pName],Grund);
        SendClientMessageToAll(Gelb,str1);
        SendClientMessage(pid,Rot,"Du wurdest gekickt");
        Kick(pid);
        return 1;
    }
    else
    {
        SendClientMessage(playerid,Rot,"Du bist kein Admin");
        return 1;
    }

}

//Kill
dcmd_kill(playerid,params[])
{
    new pid;
    if(sscanf(params,"u",pid))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /kill [Spieler]");
    }
    if(pid == INVALID_PLAYER_ID)
    {
        return SendClientMessage(playerid,Rot,"Ungültiger Spieler");
    }
    if(sSpieler[playerid][pAdmin] >=5)
    {
        new str[128];
        new str1[128];
        format(str,sizeof(str),"Du hast %s gekillt",sSpieler[pid][pName]);
        format(str1,sizeof(str1),"Du wurdest von %s gekillt",sSpieler[playerid][pName]);
        SendClientMessage(playerid,Blau,str);
        SendClientMessage(pid,Rot,str1);
        SetPlayerHealth(pid, 0);
        return 1;
    }
    else
    {
        SendClientMessage(playerid,Rot,"Du bist kein Admin");
        return 1;
    }
}

//Auto Löschen
dcmd_delscar(playerid,params[])
{
    #pragma unused params
    new query[128];
    if(GetPlayerState(playerid)==PLAYER_STATE_DRIVER)
    {
        for(new i;i<MAX_VEHICLES;i++)
        {
            if(GetPlayerVehicleID(playerid)==ServerVeh[i][sCarID])
            {
                format(query,128,"DELETE FROM `ServerCars` WHERE `carID` = '%d'",ServerVeh[i][sCarID]);
                mysql_query(query);
                DestroyVehicle(ServerVeh[i][sCarID]);
                mysql_free_result();
                format(query, 128, "Du hast das Car mit der ID: %d vom Server gelöscht", ServerVeh[i][sCarID]);
                SendClientMessage(playerid,0x008000FF,query);
                return 1;
            }
        }
    }
    else
    {
        SendClientMessage(playerid,0xFF3A3AFF,"Du musst der Fahrer des Wagens sein");
    }
    return 1;
}

//Repair
dcmd_repair(playerid,params[])
{
    new pID,PreisRepair,string[128];
    new Float:x,Float:y,Float:z;
    if(sSpieler[playerid][pFraktion] == 7)
    {
        if(sscanf(params,"ui",pID,PreisRepair)) return SendClientMessage(playerid,Blau,"Benutze: /repair [ID/Name] [Preis]");
        GetPlayerPos(playerid,x,y,z);
        if(IsPlayerInRangeOfPoint(pID,5,x,y,z))//Ob der Spieler in der Nähe des Mechanikers ist
        {
        if(pID == playerid)
        {
            return SendClientMessage(playerid,Rot,"Du kannst dein Auto nicht selber reparieren");
        }
        if(!IsPlayerInAnyVehicle(pID))
        {
            return SendClientMessage(playerid,Rot,"Der Spieler muss in einem Auto sitzen");
        }
        else
        {
            SetPVarInt(pID,"MechaPerson",playerid);
            SetPVarInt(pID,"MechaPreis",PreisRepair);
            format(string,sizeof(string),"%s möchte dein Auto reaprieren.\nDer Preis beträgt %i $.",sSpieler[playerid][pName],PreisRepair);
            ShowPlayerDialog(pID,RepairAnfrage,DIALOG_STYLE_MSGBOX,"Repair-Anfrage",string,"Annehmen","Ablehnen");
        }
        }
        else SendClientMessage(playerid,Rot,"Der Spieler ist nicht in deiner Nähe.");
    }
    else SendClientMessage(playerid,Rot,"Du bist kein Mechaniker!");
    return 1;
}

//Refill
dcmd_refill(playerid,params[])
{
    new pID,PreisRefill,string[128];
    new Float:x,Float:y,Float:z;
    if(sSpieler[playerid][pFraktion] == 7)
    {
        if(sscanf(params,"ui",pID,PreisRefill)) return SendClientMessage(playerid,Blau,"Verwendung: /refill [ID/Name] [Preis]");
        GetPlayerPos(playerid,x,y,z);
        if(IsPlayerInRangeOfPoint(pID,5,x,y,z))//Ob der Spieler in der Nähe des Mechanikers ist
        {
        if(pID == playerid)
        {
            return SendClientMessage(playerid,Rot,"Du kannst dein Auto nicht selber reparieren");
        }
        if(!IsPlayerInAnyVehicle(pID))
        {
            return SendClientMessage(playerid,Rot,"Der Spieler muss in einem Auto sitzen");
        }
        else
        {
            SetPVarInt(pID,"MechaPerson",playerid);
            SetPVarInt(pID,"MechaPreis",PreisRefill);
            format(string,sizeof(string),"%s möchte dein Auto auffüllen.\nDer Preis beträgt %i $.",sSpieler[playerid][pName],PreisRefill);
            ShowPlayerDialog(pID,RefillAnfrage,DIALOG_STYLE_MSGBOX,"Refill-Anfrage",string,"Annehmen","Ablehnen");
        }
        }
        else SendClientMessage(playerid,Rot,"Der Spieler ist nicht in deiner Nähe.");
    }
    else SendClientMessage(playerid,Rot,"Du bist kein Mechaniker!");
    return 1;
}

//Giveweapon
dcmd_giveweapon(playerid,params[])
{
    new Wid, pid;
    if(sscanf(params,"ud",pid,Wid))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /giveweapon [Spieler] [Waffen ID]");
    }
    if(sSpieler[playerid][pAdmin] < 5)
    {
        return SendClientMessage(playerid,Rot,"Du bist kein Admin");
    }
    if(pid == INVALID_PLAYER_ID)
    {
        return SendClientMessage(playerid,Rot,"Ungültiger Spieler");
    }
    else
    {
        GivePlayerWeapon(pid, Wid, 999);
        SendClientMessage(playerid,Grau,"Du hast eine Waffe erstellt");
        return 1;
    }

}

//Showfinanzen
dcmd_showfinanzen(playerid,params[])
{
    new pid;
    if(sscanf(params,"u",pid))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /showfinanzen [ID/Name]");
    }
    new Float:x,Float:y,Float:z;
    GetPlayerPos(playerid,x,y,z);
    if(IsPlayerInRangeOfPoint(pid,10,x,y,z))//Ob der Spieler in der Nähe des Mechanikers ist
    {
        new str[128];
        new str1[128];
        new str2[128];

        format(str,sizeof(str),"Du zeigst %s, deine Finanzen",sSpieler[pid][pName]);
        format(str1,sizeof(str1),"%s, zeigt dir seine Finanzen",sSpieler[playerid][pName]);
        format(str2,sizeof(str2),"Auf der Hand:[%d$] Konto[%d$]",GetPlayerMoney(playerid),sSpieler[playerid][pBank]);

        SendClientMessage(playerid,Blau,str);

        SendClientMessage(pid,Gelb,str1);
        SendClientMessage(pid,Gelb,str2);
        return 1;
    }
    else
    {
        SendClientMessage(playerid,Rot,"Der Spieler ist nicht in deiner Nähe");
        return 1;
    }
}

//Car
dcmd_car(playerid,params[])
{
    new carid;
    if(sscanf(params,"d",carid))
    {
        return SendClientMessage(playerid,Gelb,"Verwendung: /car [ID]");
    }
    if(sSpieler[playerid][pAdmin] < 5)
    {
        return SendClientMessage(playerid,Rot,"Du bist kein Admin");
    }
    else
    {
        new Float:x,Float:y,Float:z;
        GetPlayerPos(playerid,x,y,z);

        AddStaticVehicle(carid,x+4,y,z,180,-1,-1);
    }
    return 1;
}

public OnPlayerEnterVehicle(playerid, vehicleid, ispassenger)
{
    sSpieler[playerid][pVehicle] = vehicleid;
    if(GetVehicleModel(vehicleid) == 509 || GetVehicleModel(vehicleid) == 481 || GetVehicleModel(vehicleid) == 510) // Überprüft ob das Fahrzeug ein Fahrrad ist (wie im Command oben)
    {
        GetVehicleParamsEx(vehicleid,enginez,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez); // Speichere den derzeitigen Status
        SetVehicleParamsEx(vehicleid,VEHICLE_PARAMS_ON,lightsz,alarmz,doorsz,bonnetz,bootz,objectivez); // Behalte alles bei, aber starte den Motor.
    }
    return 1;
}

public OnPlayerExitVehicle(playerid, vehicleid)
{
    sSpieler[playerid][pVehicle] = 0;
    return 1;
}

public OnPlayerStateChange(playerid, newstate, oldstate)
{
    new FahrzeugID = GetVehicleModel(GetPlayerVehicleID(playerid));
    if(GetPlayerState(playerid) == PLAYER_STATE_DRIVER)
    {
        if(FahrzeugID == 472 || FahrzeugID == 473 || FahrzeugID == 493 || FahrzeugID == 595 || FahrzeugID == 484 || FahrzeugID == 430 || FahrzeugID == 453 || FahrzeugID == 452 || FahrzeugID == 446 || FahrzeugID == 454)
        {
            if(sSpieler[playerid][pBootschein] == 0)
            {
                SendClientMessage(playerid, Rot, "Du hast kein Bootschein und fährst 'ILLEGAL'!");
            }
        }
        else if(FahrzeugID == 592 || FahrzeugID == 577 || FahrzeugID == 511 || FahrzeugID == 512 || FahrzeugID == 593 || FahrzeugID == 520 || FahrzeugID == 553 || FahrzeugID == 476 || FahrzeugID == 519 || FahrzeugID == 460 || FahrzeugID == 513 || FahrzeugID == 548 || FahrzeugID == 425 || FahrzeugID == 417 || FahrzeugID == 487 || FahrzeugID == 488 || FahrzeugID == 497 || FahrzeugID == 563 || FahrzeugID == 447 || FahrzeugID == 469)
        {
            if(sSpieler[playerid][pFlugschein] == 0)
            {
                SendClientMessage(playerid, Rot, "Du hast kein Flugschein und fliegst 'ILLEGAL'!");
            }
        }
        else if(FahrzeugID == 448 || FahrzeugID == 461 || FahrzeugID == 462 || FahrzeugID == 471 || FahrzeugID == 463 || FahrzeugID == 468 || FahrzeugID == 521 || FahrzeugID == 522 || FahrzeugID == 523 || FahrzeugID == 581 || FahrzeugID == 586)
        {
            if(sSpieler[playerid][pBikeschein] == 0)
            {
                SendClientMessage(playerid, Rot, "Du hast kein Bikeschein und fährst 'ILLEGAL'!");
            }
        }
        else if(FahrzeugID == 478 || FahrzeugID == 403 || FahrzeugID == 524 || FahrzeugID == 515 || FahrzeugID == 514 || FahrzeugID == 456 || FahrzeugID == 455 || FahrzeugID == 443 || FahrzeugID == 433 || FahrzeugID == 414 || FahrzeugID == 408 || FahrzeugID == 406 || FahrzeugID == 403 || FahrzeugID == 428 || FahrzeugID == 440 || FahrzeugID == 459 || FahrzeugID == 499 || FahrzeugID == 573 || FahrzeugID == 609)
        {
            if(sSpieler[playerid][pTransporterschein] == 0)
            {
                SendClientMessage(playerid, Rot, "Du hast kein Transporterschein und fährst 'ILLEGAL'!");
            }
        }
        else if(FahrzeugID == 509 || FahrzeugID == 481 || FahrzeugID == 510){}
        else
        {
            if(sSpieler[playerid][pFuehrerschein] == 0)
            {
                SendClientMessage(playerid, Rot, "Du hast kein Führerschein und fährst 'ILLEGAL'!");
                SendClientMessage(playerid, Rot, "Du musst aufpassen nicht erwischt zu werden :D");
            }
        }
    }
    if(newstate == PLAYER_STATE_DRIVER)
    for(new i;i<MAX_VEHICLES;i++)
    {
        //SERVER
        if(GetPlayerVehicleID(playerid) == ServerVeh[i][sCarID])
        {
            return 1;
        }
        if(GetPlayerVehicleID(playerid) == FrakCars[i][fCarID])
        {
            if(sSpieler[playerid][pFraktion] != FrakCars[i][FrakID])
            {
                SendClientMessage(playerid,Rot,"Das Fahrzeug gehört nicht zu deiner Fraktion");
                RemovePlayerFromVehicle(playerid);
                return 1;
            }
            else
            {
                return 1;
            }
        }
        //MIET
        if(GetPlayerVehicleID(playerid) == MietCars[i][MietCarID])
        {
            new str[128],name[MAX_PLAYER_NAME];
            GetPlayerName(playerid, name, sizeof(name));

            MietCars[i][Besitzer] = mysql_GetIntz("Mietcars", "Besitzer", "CarID", sSpieler[playerid][pVehicle]);
            format(str,sizeof(str),"%d",MietCars[i][Besitzer]);
            SendClientMessage(playerid,Rot,str);

            if(MietCars[i][Besitzer] == 2)
            {
                SendClientMessage(playerid,Rot,"Das gehört schon jemandem.");
                return 1;
            }
            else
            {
                new sstring[512];
                MietCars[i][Preis] = mysql_GetIntz("Mietcars", "Preis", "CarID", sSpieler[playerid][pVehicle]);
                format(sstring,sizeof(sstring),"Möchtest du dieses Auto mieten?\n\nPreis: %d$",MietCars[i][Preis]);
                SendClientMessage(playerid,Rot,"Gehört Niemandem");
                ShowPlayerDialog(playerid,MietCarBuy,DIALOG_STYLE_MSGBOX,"Autovermietung",sstring,"Mieten","Abbrechen");
                return 1;
            }
        }
        //JOB
        if(GetPlayerVehicleID(playerid) == JobCars[i][JobCarID])
        {
            sSpieler[playerid][pJob] = mysql_GetInt("Accounts","Job","username",sSpieler[playerid][pName]);
            if(sSpieler[playerid][pJob] != JobCars[i][JobID])
            {
                SendClientMessage(playerid,Rot,"Das Fahrzeug gehört nicht zu deinem Job");
                RemovePlayerFromVehicle(playerid);
                return 1;
            }
            else
            {
                return 1;
            }
        }
        //SPIELER
        if(GetPlayerVehicleID(playerid) == SpielerCars[i][SpielerCarID])
        {
            new Status = mysql_GetIntz("Spielercars","Status","CarID",sSpieler[playerid][pVehicle]);
            if(Status == 1)
            {
                new Geld = mysql_GetIntz("Spielercars","Preis","CarID",sSpieler[playerid][pVehicle]);
                if(sSpieler[playerid][pFraktion] == 18)
                {
                    new str[128];
                    format(str,sizeof(str),"Möchtest du dieses Auto kaufen?\n\nPreis: %d",Geld);
                    return ShowPlayerDialog(playerid,AutohausKaufz,DIALOG_STYLE_MSGBOX,"Autohändler",str,"Kaufen","Abbrechen");
                }
                else
                {
                    new str[128];
                    format(str,sizeof(str),"Möchtest du dieses Auto kaufen?\n\nPreis: %d",Geld);
                    return ShowPlayerDialog(playerid,AutohausKauf,DIALOG_STYLE_MSGBOX,"Autohändler",str,"Kaufen","Abbrechen");
                }
            }
            if(Status == 2)
            {
                new str[128];

                new Geld = mysql_GetIntz("Spielercars","Preis","CarID",sSpieler[playerid][pVehicle]);

                format(str,sizeof(str),"Möchtest du dieses Auto freikaufen?\n\nBesitzer: %s\nPreis: %d",mysql_GetStringz("Spielercars","SpielerID","CarID",sSpieler[playerid][pVehicle]),Geld);
                return ShowPlayerDialog(playerid,OrdnungsamtFreikaufen,DIALOG_STYLE_MSGBOX,"Ordnungsamt-Ticket",str,"Freikaufen","Abbrechen");
            }
            if(SpielerCars[i][SpielerStatus] == 0)
            {
                if(sSpieler[playerid][pFraktion] == 18)
                {
                    return 1;
                }
                else
                {
                    SendClientMessage(playerid,Rot,"Dieses Fahrzeug ist eigentum der Autohändler");
                    RemovePlayerFromVehicle(playerid);
                    return 1;
                }
            }
        }
    }
    return 1;
}

public OnPlayerEnterCheckpoint(playerid)
{
    if(GetVehicleModel(GetPlayerVehicleID(playerid)) == 431)
    {
        //Linie1
        if(BusfahrerJob[playerid] == 1)
        {
            SetPlayerCheckpoint(playerid,1478.7867,-1735.1417,13.4752,3);
            BusfahrerJob[playerid] = 2;
            return 1;
        }
        if(BusfahrerJob[playerid] == 2)
        {
            SetPlayerCheckpoint(playerid,1531.5760,-1676.7528,13.4751,3);
            BusfahrerJob[playerid] = 3;
            return 1;
        }
        if(BusfahrerJob[playerid] == 3)
        {
            SetPlayerCheckpoint(playerid,1853.8455,-1382.1174,13.4831,3);
            BusfahrerJob[playerid] = 4;
            return 1;
        }
        if(BusfahrerJob[playerid] == 4)
        {
            SetPlayerCheckpoint(playerid,1462.0549,-1029.2559,23.8287,3);
            BusfahrerJob[playerid] = 5;
            return 1;
        }
        if(BusfahrerJob[playerid] == 5)
        {
            SetPlayerCheckpoint(playerid,1315.6366,-921.1036,38.0680,3);
            BusfahrerJob[playerid] = 6;
            return 1;
        }
        if(BusfahrerJob[playerid] == 6)
        {
            SetPlayerCheckpoint(playerid,1202.3909,-933.9491,42.8269,3);
            BusfahrerJob[playerid] = 7;
            return 1;
        }
        if(BusfahrerJob[playerid] == 7)
        {
            SetPlayerCheckpoint(playerid,1034.2843,-1699.0520,13.4752,3);
            BusfahrerJob[playerid] = 8;
            return 1;
        }
        if(BusfahrerJob[playerid] == 8)
        {
            SetPlayerCheckpoint(playerid,1034.8008,-1747.8031,13.4712,3);
            BusfahrerJob[playerid] = 9;
            return 1;
        }
        if(BusfahrerJob[playerid] == 9)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobBuslinieEins");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobBuslinieEins");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobBuslinieEins");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            BusfahrerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobBusfahrer] += job_exp;
            return 1;
        }
        //Linie2
        if(BusfahrerJob[playerid] == 20)
        {
            SetPlayerCheckpoint(playerid,1262.7377,-1337.9662,13.2947,3);
            BusfahrerJob[playerid] = 21;
            return 1;
        }
        if(BusfahrerJob[playerid] == 21)
        {
            SetPlayerCheckpoint(playerid,1361.0779,-1263.0623,13.4751,3);
            BusfahrerJob[playerid] = 22;
            return 1;
        }
        if(BusfahrerJob[playerid] == 22)
        {
            SetPlayerCheckpoint(playerid,794.1648,-1170.0269,22.8456,3);
            BusfahrerJob[playerid] = 23;
            return 1;
        }
        if(BusfahrerJob[playerid] == 23)
        {
            SetPlayerCheckpoint(playerid,820.1573,-1602.8109,13.4750,3);
            BusfahrerJob[playerid] = 24;
            return 1;
        }
        if(BusfahrerJob[playerid] == 24)
        {
            SetPlayerCheckpoint(playerid,1040.1401,-1761.9094,13.4746,3);
            BusfahrerJob[playerid] = 25;
            return 1;
        }
        if(BusfahrerJob[playerid] == 25)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobBuslinieZwei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobBuslinieZwei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobBuslinieZwei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            BusfahrerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobBusfahrer] += job_exp;
            return 1;
        }
        //Linie3
        if(BusfahrerJob[playerid] == 40)
        {
            SetPlayerCheckpoint(playerid,1077.5217,-1849.4672,13.4827,3);
            BusfahrerJob[playerid] = 41;
            return 1;
        }
        if(BusfahrerJob[playerid] == 41)
        {
            SetPlayerCheckpoint(playerid,1681.9626,-2321.4343,13.4749,3);
            BusfahrerJob[playerid] = 42;
            return 1;
        }
        if(BusfahrerJob[playerid] == 42)
        {
            SetPlayerCheckpoint(playerid,2645.2878,-1673.1014,10.8470,3);
            BusfahrerJob[playerid] = 43;
            return 1;
        }
        if(BusfahrerJob[playerid] == 43)
        {
            SetPlayerCheckpoint(playerid,2384.0845,-1253.7316,23.9150,3);
            BusfahrerJob[playerid] = 44;
            return 1;
        }
        if(BusfahrerJob[playerid] == 44)
        {
            SetPlayerCheckpoint(playerid,2242.1809,-1297.7378,23.9206,3);
            BusfahrerJob[playerid] = 45;
            return 1;
        }
        if(BusfahrerJob[playerid] == 45)
        {
            SetPlayerCheckpoint(playerid,1426.6814,-1705.9109,13.4751,3);
            BusfahrerJob[playerid] = 46;
            return 1;
        }
        if(BusfahrerJob[playerid] == 46)
        {
            SetPlayerCheckpoint(playerid,1110.8900,-1709.1727,13.4751,3);
            BusfahrerJob[playerid] = 47;
            return 1;
        }
        if(BusfahrerJob[playerid] == 47)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobBuslinieDrei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobBuslinieDrei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobBuslinieDrei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            BusfahrerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobBusfahrer] += job_exp;
            return 1;
        }
    }
    //Erzsammler
    if(GetVehicleModel(GetPlayerVehicleID(playerid)) == 406)
    {
        //ErzSkill1 Kurz
        if(ErzsammlerJob[playerid] == 1)
        {
            ErzsammlerJob[playerid] = 2;
            SetPlayerCheckpoint(playerid,723.0106,885.3636,-24.9490, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 2)
        {
            ErzsammlerJob[playerid] = 3;
            SetPlayerCheckpoint(playerid,677.1761,963.9152,-11.1301, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 3)
        {
            ErzsammlerJob[playerid] = 4;
            SetPlayerCheckpoint(playerid,516.3797,942.7792,-24.3080, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 4)
        {
            ErzsammlerJob[playerid] = 5;
            SetPlayerCheckpoint(playerid,545.0698,862.3168,-41.1737, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 5)
        {
            ErzsammlerJob[playerid] = 6;
            SetPlayerCheckpoint(playerid,648.5865,897.3669,-40.5432, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 6)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobErzsammlerEins");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobErzsammlerEins");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobErzsammlerEins");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            ErzsammlerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobErzsammler] += job_exp;
            return 1;
        }
        //ErzSkill1 Normal
        if(ErzsammlerJob[playerid] == 30)
        {
            ErzsammlerJob[playerid] = 31;
            SetPlayerCheckpoint(playerid,531.6806,936.1737,-22.7628, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 31)
        {
            ErzsammlerJob[playerid] = 32;
            SetPlayerCheckpoint(playerid,533.0536,936.4252,-22.6866, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 32)
        {
            ErzsammlerJob[playerid] = 33;
            SetPlayerCheckpoint(playerid,533.6370,808.5016,-24.3636, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 33)
        {
            ErzsammlerJob[playerid] = 34;
            SetPlayerCheckpoint(playerid,722.3696,879.0033,-25.0582, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 34)
        {
            ErzsammlerJob[playerid] = 35;
            SetPlayerCheckpoint(playerid,683.3754,967.9835,-11.1662, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 35)
        {
            ErzsammlerJob[playerid] = 36;
            SetPlayerCheckpoint(playerid,543.1956,989.7905,-5.3103, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 36)
        {
            ErzsammlerJob[playerid] = 37;
            SetPlayerCheckpoint(playerid,766.1772,890.5868,0.2700, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 37)
        {
            ErzsammlerJob[playerid] = 38;
            SetPlayerCheckpoint(playerid,683.1826,973.8038,-11.1883, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 38)
        {
            ErzsammlerJob[playerid] = 39;
            SetPlayerCheckpoint(playerid,524.5831,939.6925,-23.1512, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 39)
        {
            ErzsammlerJob[playerid] = 40;
            SetPlayerCheckpoint(playerid,635.1860,944.2022,-34.1672, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 40)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobErzsammlerZwei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobErzsammlerZwei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobErzsammlerZwei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            ErzsammlerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobErzsammler] += job_exp;
            return 1;
        }
        //ErzSkill4 Lang
        if(ErzsammlerJob[playerid] == 60)
        {
            ErzsammlerJob[playerid] = 61;
            SetPlayerCheckpoint(playerid,716.6572,887.5162,-25.2928, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 61)
        {
            ErzsammlerJob[playerid] = 62;
            SetPlayerCheckpoint(playerid,684.4241,965.8170,-11.1591, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 62)
        {
            ErzsammlerJob[playerid] = 63;
            SetPlayerCheckpoint(playerid,489.6639,879.5734,-29.5460, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 63)
        {
            ErzsammlerJob[playerid] = 64;
            SetPlayerCheckpoint(playerid,528.5927,789.2516,-19.2953, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 64)
        {
            ErzsammlerJob[playerid] = 65;
            SetPlayerCheckpoint(playerid,715.0552,744.2470,-4.8261, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 65)
        {
            ErzsammlerJob[playerid] = 66;
            SetPlayerCheckpoint(playerid,776.2513,879.6917,0.2245, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 66)
        {
            ErzsammlerJob[playerid] = 67;
            SetPlayerCheckpoint(playerid,554.1863,990.3110,-3.6187, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 67)
        {
            ErzsammlerJob[playerid] = 68;
            SetPlayerCheckpoint(playerid,681.5529,972.9430,-11.1825, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 68)
        {
            ErzsammlerJob[playerid] = 69;
            SetPlayerCheckpoint(playerid,728.3738,891.0007,-24.9528, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 69)
        {
            ErzsammlerJob[playerid] = 70;
            SetPlayerCheckpoint(playerid,538.6752,811.4194,-25.4088, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 70)
        {
            ErzsammlerJob[playerid] = 71;
            SetPlayerCheckpoint(playerid,497.3418,907.0801,-29.9159, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 71)
        {
            ErzsammlerJob[playerid] = 72;
            SetPlayerCheckpoint(playerid,516.4897,935.3059,-24.7539, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 72)
        {
            ErzsammlerJob[playerid] = 73;
            SetPlayerCheckpoint(playerid,677.5456,972.1356,-11.1721, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 73)
        {
            ErzsammlerJob[playerid] = 74;
            SetPlayerCheckpoint(playerid,548.1978,979.6911,-5.5347, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 74)
        {
            ErzsammlerJob[playerid] = 75;
            SetPlayerCheckpoint(playerid,767.9565,897.5013,0.2613, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 75)
        {
            ErzsammlerJob[playerid] = 76;
            SetPlayerCheckpoint(playerid,682.9688,971.7172,-11.1833, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 76)
        {
            ErzsammlerJob[playerid] = 77;
            SetPlayerCheckpoint(playerid,528.4431,940.4650,-22.6173, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 77)
        {
            ErzsammlerJob[playerid] = 78;
            SetPlayerCheckpoint(playerid,615.6399,949.9113,-32.3696, 8);
            return 1;
        }
        if(ErzsammlerJob[playerid] == 78)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobErzsammlerDrei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobErzsammlerDrei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobErzsammlerDrei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            ErzsammlerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobErzsammler] += job_exp;
            return 1;
        }
    }
    //Farmer
    if(GetVehicleModel(GetPlayerVehicleID(playerid)) == 531)
    {
        //Farmer Strecke 1
        if(FarmerJob[playerid] == 1)
        {
            FarmerJob[playerid] = 2;
            SetPlayerCheckpoint(playerid,-1355.3414,-1469.3197,102.8471, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 2)
        {
            FarmerJob[playerid] = 3;
            SetPlayerCheckpoint(playerid,-1353.2224,-1444.5835,103.2499, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 3)
        {
            FarmerJob[playerid] = 4;
            SetPlayerCheckpoint(playerid,-1404.9928,-1437.8131,102.3035, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 4)
        {
            FarmerJob[playerid] = 5;
            SetPlayerCheckpoint(playerid,-1418.2976,-1601.8889,101.8654, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 5)
        {
            FarmerJob[playerid] = 6;
            SetPlayerCheckpoint(playerid,-1343.9657,-1601.4160,102.3639, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 6)
        {
            FarmerJob[playerid] = 7;
            SetPlayerCheckpoint(playerid,-1341.8356,-1489.9415,103.0563, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 7)
        {
            FarmerJob[playerid] = 8;
            SetPlayerCheckpoint(playerid,-1436.8752,-1482.6348,101.6828, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 8)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobFarmerEins");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobFarmerEins");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobFarmerEins");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            FarmerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobFarmer] += job_exp;
            return 1;
        }
        //Farmer Strecke 2
        if(FarmerJob[playerid] == 20)
        {
            FarmerJob[playerid] = 21;
            SetPlayerCheckpoint(playerid,-1408.8671,-1445.9031,100.7273, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 21)
        {
            FarmerJob[playerid] = 22;
            SetPlayerCheckpoint(playerid,-1333.4447,-1444.5815,103.6304, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 22)
        {
            FarmerJob[playerid] = 23;
            SetPlayerCheckpoint(playerid,-1329.2349,-1474.9166,103.6295, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 23)
        {
            FarmerJob[playerid] = 24;
            SetPlayerCheckpoint(playerid,-1344.3958,-1601.6996,102.3639, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 24)
        {
            FarmerJob[playerid] = 25;
            SetPlayerCheckpoint(playerid,-1464.8121,-1601.4569,101.8627, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 25)
        {
            FarmerJob[playerid] = 26;
            SetPlayerCheckpoint(playerid,-1398.3950,-1584.2383,102.0684, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 26)
        {
            FarmerJob[playerid] = 27;
            SetPlayerCheckpoint(playerid,-1373.3792,-1475.7804,102.0249, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 27)
        {
            FarmerJob[playerid] = 28;
            SetPlayerCheckpoint(playerid,-1435.9052,-1481.8514,101.6715, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 28)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobFarmerZwei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobFarmerZwei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobFarmerZwei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            FarmerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobFarmer] += job_exp;
            return 1;
        }
        //Farmer Strecke 3
        if(FarmerJob[playerid] == 40)
        {
            FarmerJob[playerid] = 41;
            SetPlayerCheckpoint(playerid,-1423.3472,-1603.4211,101.7764, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 41)
        {
            FarmerJob[playerid] = 42;
            SetPlayerCheckpoint(playerid,-1464.2532,-1440.0972,101.1151, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 42)
        {
            FarmerJob[playerid] = 43;
            SetPlayerCheckpoint(playerid,-1171.0289,-1474.7991,123.9971, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 43)
        {
            FarmerJob[playerid] = 44;
            SetPlayerCheckpoint(playerid,-1172.7844,-1465.9604,124.0910, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 44)
        {
            FarmerJob[playerid] = 45;
            SetPlayerCheckpoint(playerid,-1333.4502,-1472.1586,103.6296, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 45)
        {
            FarmerJob[playerid] = 46;
            SetPlayerCheckpoint(playerid,-1436.0062,-1480.7115,101.6659, 3);
            return 1;
        }
        if(FarmerJob[playerid] == 46)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobFarmerDrei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobFarmerDrei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobFarmerDrei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            FarmerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobFarmer] += job_exp;
            return 1;
        }
    }
    //Trucker
    if(GetVehicleModel(GetPlayerVehicleID(playerid)) == 456)
    {
        //Trucker Strecke 1
        if(TruckerJob[playerid] == 1)
        {
            TruckerJob[playerid] = 2;
            SetPlayerCheckpoint(playerid,-81.5497,-1127.4506,1.1703, 3);
            SendClientMessage(playerid,Grau,"Du hast deine Fracht erfolgreich abgegeben. Fahre nun zurück zum Depot");
            return 1;
        }
        if(TruckerJob[playerid] == 2)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobTruckerEins");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobTruckerEins");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobTruckerEins");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            FarmerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobTrucker] += job_exp;
            return 1;
        }
        //Trucker Strecke 2
        if(TruckerJob[playerid] == 20)
        {
            TruckerJob[playerid] = 21;
            SetPlayerCheckpoint(playerid,-81.5497,-1127.4506,1.1703, 3);
            SendClientMessage(playerid,Grau,"Du hast deine Fracht erfolgreich abgegeben. Fahre nun zurück zum Depot");
            return 1;
        }
        if(TruckerJob[playerid] == 21)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobTruckerZwei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobTruckerZwei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobTruckerZwei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            FarmerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobTrucker] += job_exp;
            return 1;
        }
        //Trucker Strecke 3
        if(TruckerJob[playerid] == 40)
        {
            TruckerJob[playerid] = 41;
            SetPlayerCheckpoint(playerid,-81.5497,-1127.4506,1.1703, 3);
            SendClientMessage(playerid,Grau,"Du hast deine Fracht erfolgreich abgegeben. Fahre nun zurück zum Depot");
            return 1;
        }
        if(TruckerJob[playerid] == 41)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobTruckerDrei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobTruckerDrei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobTruckerDrei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            FarmerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobTrucker] += job_exp;
            return 1;
        }
    }
    //Pilot
    if(GetVehicleModel(GetPlayerVehicleID(playerid)) == 593)
    {
        //Pilot Strecke 1
        if(PilotJob[playerid] == 1)
        {
            PilotJob[playerid] = 2;
            SetPlayerCheckpoint(playerid,1929.6232,-2317.6631,13.5469, 3);
            SendClientMessage(playerid,Grau,"Du hast deine Fracht erfolgreich abgegeben. Fliege nun zurück zum Flughafen");
            return 1;
        }
        if(PilotJob[playerid] == 2)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobPilotEins");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobPilotEins");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobPilotEins");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            PilotJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobPilot] += job_exp;
            return 1;
        }
        //Pilot Strecke 2
        if(PilotJob[playerid] == 20)
        {
            PilotJob[playerid] = 21;
            SetPlayerCheckpoint(playerid,1929.6232,-2317.6631,13.5469, 3);
            SendClientMessage(playerid,Grau,"Du hast deine Fracht erfolgreich abgegeben. Fliege nun zurück zum Flughafen");
            return 1;
        }
        if(PilotJob[playerid] == 21)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobPilotZwei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobPilotZwei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobPilotZwei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            PilotJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobPilot] += job_exp;
            return 1;
        }
        //Pilot Strecke 3
        if(PilotJob[playerid] == 40)
        {
            PilotJob[playerid] = 41;
            SetPlayerCheckpoint(playerid,1929.6232,-2317.6631,13.5469, 3);
            SendClientMessage(playerid,Grau,"Du hast deine Fracht erfolgreich abgegeben. Fliege nun zurück zum Flughafen");
            return 1;
        }
        if(PilotJob[playerid] == 41)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobPilotDrei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobPilotDrei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobPilotDrei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            PilotJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobPilot] += job_exp;
            return 1;
        }
    }
    //Müllmann
    if(GetVehicleModel(GetPlayerVehicleID(playerid)) == 408)
    {
        //Müllamnn Strecke 1
        if(MuelmannJob[playerid] == 1)
        {
            MuelmannJob[playerid] = 2;
            SetPlayerCheckpoint(playerid,2509.4788,-1728.6539,13.4751, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 2)
        {
            MuelmannJob[playerid] = 3;
            SetPlayerCheckpoint(playerid,2078.1924,-1796.1040,13.4754, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 3)
        {
            MuelmannJob[playerid] = 4;
            SetPlayerCheckpoint(playerid,1936.8962,-1928.3093,13.4775, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 4)
        {
            MuelmannJob[playerid] = 5;
            SetPlayerCheckpoint(playerid,1824.9268,-1843.2529,13.5064, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 5)
        {
            MuelmannJob[playerid] = 6;
            SetPlayerCheckpoint(playerid,2010.8678,-1264.2795,23.9127, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 6)
        {
            MuelmannJob[playerid] = 7;
            SendClientMessage(playerid,Rot,"Du hast alles aufgeladen, dein Wagen ist voll");
            SetPlayerCheckpoint(playerid,2817.9341,-1569.8052,10.9219, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 7)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobMuelmannEins");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobMuelmannEins");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobMuelmannEins");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            MuelmannJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobMuelmann] += job_exp;
            return 1;
        }
        //Müllamnn Strecke 2
        if(MuelmannJob[playerid] == 20)
        {
            MuelmannJob[playerid] = 21;
            SetPlayerCheckpoint(playerid,2857.0938,-1485.6090,10.8517, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 21)
        {
            MuelmannJob[playerid] = 22;
            SetPlayerCheckpoint(playerid,2575.1721,-1044.3644,69.5063, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 22)
        {
            MuelmannJob[playerid] = 23;
            SetPlayerCheckpoint(playerid,2249.1213,-1040.4711,54.0581, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 23)
        {
            MuelmannJob[playerid] = 24;
            SetPlayerCheckpoint(playerid,1933.3403,-1132.3480,25.2410, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 24)
        {
            MuelmannJob[playerid] = 25;
            SetPlayerCheckpoint(playerid,1339.7354,-1377.3607,13.5726, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 25)
        {
            MuelmannJob[playerid] = 26;
            SetPlayerCheckpoint(playerid,1409.4773,-1875.6910,13.4750, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 26)
        {
            MuelmannJob[playerid] = 27;
            SendClientMessage(playerid,Rot,"Du hast alles aufgeladen, dein Wagen ist voll");
            SetPlayerCheckpoint(playerid,2815.9514,-1570.5831,10.9219, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 27)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobMuelmannZwei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobMuelmannZwei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobMuelmannZwei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            MuelmannJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobMuelmann] += job_exp;
            return 1;
        }
        //Müllamnn Strecke 3
        if(MuelmannJob[playerid] == 40)
        {
            MuelmannJob[playerid] = 41;
            SetPlayerCheckpoint(playerid,2815.2048,-1382.2217,19.6003, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 41)
        {
            MuelmannJob[playerid] = 42;
            SetPlayerCheckpoint(playerid,2532.5337,-1253.4938,37.9684, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 42)
        {
            MuelmannJob[playerid] = 43;
            SetPlayerCheckpoint(playerid,2233.2000,-1297.8330,23.9176, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 43)
        {
            MuelmannJob[playerid] = 44;
            SetPlayerCheckpoint(playerid,1815.8110,-1259.2152,13.5612, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 44)
        {
            MuelmannJob[playerid] = 45;
            SetPlayerCheckpoint(playerid,1457.1914,-1030.2664,23.7486, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 45)
        {
            MuelmannJob[playerid] = 46;
            SetPlayerCheckpoint(playerid,1026.0299,-1036.9919,31.6251, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 46)
        {
            MuelmannJob[playerid] = 47;
            SetPlayerCheckpoint(playerid,913.4730,-1376.2986,13.3634, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 47)
        {
            MuelmannJob[playerid] = 48;
            SetPlayerCheckpoint(playerid,1325.4602,-1408.6050,13.4099, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 48)
        {
            MuelmannJob[playerid] = 49;
            SetPlayerCheckpoint(playerid,2816.6362,-1568.3977,10.9219, 3);
            return 1;
        }
        if(MuelmannJob[playerid] == 49)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobMuelmannDrei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobMuelmannDrei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobMuelmannDrei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            MuelmannJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobMuelmann] += job_exp;
            return 1;
        }
    }
    //Reiniger
    if(GetVehicleModel(GetPlayerVehicleID(playerid)) == 574)
    {
        //Reiniger Strecke 1
        if(ReinigerJob[playerid] == 1)
        {
            ReinigerJob[playerid] = 2;
            SetPlayerCheckpoint(playerid,2109.6814,-1558.5919,25.3023, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 2)
        {
            ReinigerJob[playerid] = 3;
            SetPlayerCheckpoint(playerid,2078.5835,-1879.3073,13.4217, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 3)
        {
            ReinigerJob[playerid] = 4;
            SetPlayerCheckpoint(playerid,2192.0537,-1897.1768,13.7518, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 4)
        {
            ReinigerJob[playerid] = 5;
            SetPlayerCheckpoint(playerid,2311.4819,-1958.1953,13.4690, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 5)
        {
            ReinigerJob[playerid] = 6;
            SetPlayerCheckpoint(playerid,2415.9724,-1907.5884,13.4558, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 6)
        {
            ReinigerJob[playerid] = 7;
            SetPlayerCheckpoint(playerid,2403.3755,-1729.5826,13.4819, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 7)
        {
            ReinigerJob[playerid] = 8;
            SetPlayerCheckpoint(playerid,2235.4263,-1729.6934,13.4752, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 8)
        {
            ReinigerJob[playerid] = 9;
            SetPlayerCheckpoint(playerid,1965.9762,-1748.5653,13.4752, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 9)
        {
            ReinigerJob[playerid] = 10;
            SetPlayerCheckpoint(playerid,1835.6267,-1609.4905,13.4751, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 10)
        {
            ReinigerJob[playerid] = 11;
            SetPlayerCheckpoint(playerid,1906.6068,-1467.1130,13.4752, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 11)
        {
            ReinigerJob[playerid] = 12;
            SetPlayerCheckpoint(playerid,2130.7498,-1444.6740,23.9205, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 12)
        {
            ReinigerJob[playerid] = 13;
            SetPlayerCheckpoint(playerid,2101.2368,-1363.8303,24.0768, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 13)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobReinigerEins");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobReinigerEins");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobReinigerEins");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            ReinigerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobReiniger] += job_exp;
            return 1;
        }
        //Reiniger Strecke 2
        if(ReinigerJob[playerid] == 20)
        {
            ReinigerJob[playerid] = 21;
            SetPlayerCheckpoint(playerid,1935.2902,-1338.7269,18.5039, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 21)
        {
            ReinigerJob[playerid] = 22;
            SetPlayerCheckpoint(playerid,1730.0781,-1438.1356,13.4669, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 22)
        {
            ReinigerJob[playerid] = 23;
            SetPlayerCheckpoint(playerid,1468.2589,-1438.4678,13.4752, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 23)
        {
            ReinigerJob[playerid] = 24;
            SetPlayerCheckpoint(playerid,1473.7627,-1306.2396,13.5818, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 24)
        {
            ReinigerJob[playerid] = 25;
            SetPlayerCheckpoint(playerid,1832.5286,-1263.8159,13.5612, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 25)
        {
            ReinigerJob[playerid] = 26;
            SetPlayerCheckpoint(playerid,2051.5144,-1263.5925,23.9127, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 26)
        {
            ReinigerJob[playerid] = 27;
            SetPlayerCheckpoint(playerid,2100.3965,-1363.1802,24.0767, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 27)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobReinigerZwei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobReinigerZwei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobReinigerZwei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            ReinigerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobReiniger] += job_exp;
            return 1;
        }
        //Reiniger Strecke 3
        if(ReinigerJob[playerid] == 40)
        {
            ReinigerJob[playerid] = 41;
            SetPlayerCheckpoint(playerid,2073.5249,-1106.8038,24.6957, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 41)
        {
            ReinigerJob[playerid] = 42;
            SetPlayerCheckpoint(playerid,1848.0250,-1177.6375,23.7359, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 42)
        {
            ReinigerJob[playerid] = 43;
            SetPlayerCheckpoint(playerid,1495.4492,-1158.6027,24.0062, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 43)
        {
            ReinigerJob[playerid] = 44;
            SetPlayerCheckpoint(playerid,1165.4773,-1124.1022,24.0179, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 44)
        {
            ReinigerJob[playerid] = 45;
            SetPlayerCheckpoint(playerid,1164.5198,-965.8602,42.2624, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 45)
        {
            ReinigerJob[playerid] = 46;
            SetPlayerCheckpoint(playerid,1351.0321,-943.9324,34.5466, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 46)
        {
            ReinigerJob[playerid] = 47;
            SetPlayerCheckpoint(playerid,1402.3993,-1037.8427,24.5101, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 47)
        {
            ReinigerJob[playerid] = 48;
            SetPlayerCheckpoint(playerid,1591.7600,-1163.4535,23.9987, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 48)
        {
            ReinigerJob[playerid] = 49;
            SetPlayerCheckpoint(playerid,1887.8276,-1138.4104,24.0996, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 49)
        {
            ReinigerJob[playerid] = 50;
            SetPlayerCheckpoint(playerid,2064.7966,-1159.4681,23.7837, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 50)
        {
            ReinigerJob[playerid] = 51;
            SetPlayerCheckpoint(playerid,2099.4285,-1363.3593,24.0767, 3);
            return 1;
        }
        if(ReinigerJob[playerid] == 51)
        {
            new str[128],test,job_min,job_max,job_exp;
            job_min = mysql_GetInt("jobconfig","Min_Lohn","Name","JobReinigerDrei");
            job_max = mysql_GetInt("jobconfig","Max_Lohn","Name","JobReinigerDrei");
            job_exp = mysql_GetInt("jobconfig","Job_Exp","Name","JobReinigerDrei");
            test = job_min+random(job_max);
            format(str,sizeof(str),"Du hast dein Job erfolgreich beendet. Lohn: %d$",test);
            SendClientMessage(playerid,Grau,str);
            ReinigerJob[playerid] = 0;
            DisablePlayerCheckpoint(playerid);
            GivePlayerMoney(playerid, test);
            sSpieler[playerid][pJobReiniger] += job_exp;
            return 1;
        }
    }
    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)
{
    if(newkeys == 16 && !IsPlayerInAnyVehicle(playerid))
    {
        new query[128];
        mysql_query("SELECT * FROM `Interiors`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                for(new i;i<MAX_INTERIOR;i++)
                {
                    new string[512];
                    mysql_fetch_field_row(string,"InteriorIDs");
                    Interiors[i][InteriorIDs] = strval(string);
                    mysql_fetch_field_row(string,"InteriorID");
                    Interiors[i][InteriorID] = strval(string);
                    mysql_fetch_field_row(string,"InteriorEinX");
                    Interiors[i][InteriorEinX] = floatstr(string);
                    mysql_fetch_field_row(string,"InteriorEinY");
                    Interiors[i][InteriorEinY] = floatstr(string);
                    mysql_fetch_field_row(string,"InteriorEinZ");
                    Interiors[i][InteriorEinZ] = floatstr(string);
                    mysql_fetch_field_row(string,"InteriorAusX");
                    Interiors[i][InteriorAusX] = floatstr(string);
                    mysql_fetch_field_row(string,"InteriorAusY");
                    Interiors[i][InteriorAusY] = floatstr(string);
                    mysql_fetch_field_row(string,"InteriorAusZ");
                    Interiors[i][InteriorAusZ] = floatstr(string);
                    if(IsPlayerInRangeOfPoint(playerid,3,Interiors[i][InteriorEinX],Interiors[i][InteriorEinY],Interiors[i][InteriorEinZ]))
                    {
                        SetPlayerPos(playerid,Interiors[i][InteriorAusX],Interiors[i][InteriorAusY],Interiors[i][InteriorAusZ]);
                        SetPlayerInterior(playerid,Interiors[i][InteriorIDs]);
                        SetPlayerVirtualWorld(playerid,Interiors[i][InteriorID]);
                        format(query, 128, "Gehts?");
                        SendClientMessage(playerid,0x008000FF,query);
                        return 1;
                    }
                    if(IsPlayerInRangeOfPoint(playerid,3,Interiors[i][InteriorAusX],Interiors[i][InteriorAusY],Interiors[i][InteriorAusZ]) && GetPlayerVirtualWorld(playerid) == Interiors[i][InteriorID])
                    {
                        SetPlayerPos(playerid,Interiors[i][InteriorEinX],Interiors[i][InteriorEinY],Interiors[i][InteriorEinZ]);
                        SetPlayerInterior(playerid,0);
                        SetPlayerVirtualWorld(playerid,0);
                        format(query, 128, "Gehts?");
                        SendClientMessage(playerid,0x008000FF,query);
                        return 1;
                    }
                }
            }
        }
    }
    return 1;
}

public OnRconLoginAttempt(ip[], password[], success)
{
    return 1;
}

public OnPlayerUpdate(playerid)
{
    if(GetPlayerVehicleSeat(playerid) == 0)
    {
        new vehicleid;
        vehicleid = GetPlayerVehicleID(playerid);
        if(GetVehicleModel(vehicleid) != 509 && GetVehicleModel(vehicleid) != 481 && GetVehicleModel(vehicleid) != 510)
        {
            new string[125];
            if(Tank[vehicleid] < 10) format(string,sizeof string,"~w~Tank: ~r~%i",Tank[vehicleid]);
            else if(Tank[vehicleid] < 30) format(string,sizeof string,"~w~Tank: ~y~%i",Tank[vehicleid]);
            else if(Tank[vehicleid] <= 100) format(string,sizeof string,"~w~Tank: ~g~%i",Tank[vehicleid]);
            TextDrawSetString(Anzeige[playerid],string);
        }
    }
    else
    {
        TextDrawSetString(Anzeige[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 DIALOG_REGISTER:
        {
            if(response)
            {
                if(strlen(inputtext) == 0) // Wenn kein Passwort angegebene wurde
                {
                    ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_INPUT,"Register","Das angegebene Passwort war zu Kurz...\nBitte Registrier dich jetzt mit einem Passwort:","Register","Abbrechen");
                    return 1;
                }
                else
                {
                    CreateAccount(playerid, inputtext);
                    GivePlayerMoney(playerid,10000);
                    SetPVarInt(playerid,"Eingeloggt",1); //Die variable wird auf 1 gesetzt, damit wir nun die Skin Auswahl benutzen können ohne wieder nach unserem Passwort gefragt zu werden.
                    SpawnPlayer(playerid); //Wir lassen den Spieler Spawnen
                    return 1;
                }
            }
            else
            {
                Kick(playerid); //Wenn auf Abbrechen geklickt wurde, wird der Spieler gekickt damit man ohne Account nicht Spielen kann.
            }
        }
        case DIALOG_LOGIN:
        {
            if(response)
            {
                if(strlen(inputtext) == 0)  // Wenn kein Passwort angegebene wurde
                {
                    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Login","Das Angegebene Passwort war Falsch.\nBitte log dich jetzt mit dem richtigen Passwort ein:","Login","Abbrechen");
                    return 1;
                }
                else
                {
                    new SpielerName[MAX_PLAYER_NAME];
                    GetPlayerName(playerid, SpielerName, MAX_PLAYER_NAME);
                    if(!strcmp(inputtext, mysql_ReturnPasswort(SpielerName), true)) // Wir holen uns das Passwort aus der MySQL Datenbank und überprüfen es mit dem angegebenen passwort.
                    {
                        SetPVarInt(playerid,"Eingeloggt",1); //Falls beide passwörter übereinstimmen wird die Variable auf 1 gesetzt damit wir die Skin auswahl benutzen können.
                        LoadPlayer(playerid); //Der Spieler wird "geladen", speich es werden seine Daten aus der Datenbank geholt und in variablen gespeichert um diese im Skript zu verwenden.
                        SpawnPlayer(playerid); //Wir lassen den Spieler Spawnen
                        return 1;
                    }
                    else
                    {
                        //Wenn das Passwort falsch war, lassen wir erneut das Login fenster erscheinen damit der Spieler das Richtige Passwort eingibt.
                        ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_INPUT,"Login","Das war das Falsche Passwort.\nBitte log dich jetzt mit dem richtigen Passwort ein:","Login","Abbrechen");
                        return 1;
                    }
                }
            }
            else
            {
                Kick(playerid); //Wenn auf Abbrechen geklickt wurde, wird der Spieler gekickt damit man ohne Account nicht Spielen kann.
            }
        }
    }
    //Autovermietung
    if(dialogid == MietCarBuy)
    {
        if(response == 0)
        {
            RemovePlayerFromVehicle(playerid);
            return 1;
        }
        if(response == 1)
        {
            for(new i; i<MAX_MIET_CARS; i++)
            {
                MietCars[i][Preis] = mysql_GetIntz("Mietcars", "Preis", "CarID", sSpieler[playerid][pVehicle]);
                if(MietCars[i][Preis] > GetPlayerMoney(playerid))
                {
                    SendClientMessage(playerid,Rot,"Du hast nicht genug Geld");
                    RemovePlayerFromVehicle(playerid);
                    return 1;
                }
                if(sSpieler[playerid][pMietid] != 0)
                {
                    SendClientMessage(playerid,Rot,"Du kannst dir nur ein Auto mieten");
                    RemovePlayerFromVehicle(playerid);
                    return 1;
                }
                else
                {
                    MietCars[i][Besitzer] = mysql_SetIntz("Mietcars", "Besitzer", 2, "CarID", sSpieler[playerid][pVehicle]);
                    sSpieler[playerid][pMietid] = mysql_SetInt("Accounts", "Mietid", GetPlayerVehicleID(playerid), "username", sSpieler[playerid][pName]);
                    SendClientMessage(playerid,Rot,"Du hast dieses Auto gemietet");
                    GivePlayerMoney(playerid,-MietCars[i][Preis]);
                    return 1;
                }
            }
        }
    }
    //MietcarControl
    if(dialogid == MietcarControl)
    {
        if(response == 0)
        {
            return 1;
        }
        if(response == 1)
        {
            sSpieler[playerid][pMietid] = mysql_GetInt("Accounts","Mietid","username",sSpieler[playerid][pName]);
            if(listitem == 0)
            {
                new engine,lights,alarm,boonet,boot,objective;
                SetVehicleParamsEx(sSpieler[playerid][pMietid],engine,lights,alarm,VEHICLE_PARAMS_OFF,boonet,boot,objective);
                SendClientMessage(playerid,Grün,"Du hast dein Mietfahrzeug aufgeschlossen");
                return 1;
            }
            if(listitem == 1)
            {
                new engine,lights,alarm,boonet,boot,objective;
                SetVehicleParamsEx(sSpieler[playerid][pMietid],engine,lights,alarm,VEHICLE_PARAMS_ON,boonet,boot,objective);
                SendClientMessage(playerid,Rot,"Du hast dein Mietfahrzeug abgeschlossen");
                return 1;
            }
            if(listitem == 2)
            {
                for(new i;i<MAX_MIET_CARS; i++)
                {
                    new engine,lights,alarm,boonet,boot,objective;
                    mysql_SetIntz("Mietcars","Besitzer",1,"Carid",sSpieler[playerid][pMietid]);
                    SetVehicleParamsEx(sSpieler[playerid][pMietid],engine,lights,alarm,VEHICLE_PARAMS_OFF,boonet,boot,objective);
                    sSpieler[playerid][pMietid] = 0;
                    SendClientMessage(playerid,Rot,"Du hast dein Mietfahrzeug abgegeben");
                    return 1;
                }
            }
        }
    }
    //Hausmenü
    if(dialogid == Hausmenue)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            if(listitem == 0)
            {
                new string[200];
                mysql_query("SELECT * FROM `Haus`");
                mysql_store_result();
                if(mysql_num_rows() != 0)
                {
                    while(mysql_retrieve_row())
                    {
                        for(new i; i<MAX_HAUS; i++)
                        {
                            mysql_fetch_field_row(string,"hx");
                            Haus[i][hx] = floatstr(string);
                            mysql_fetch_field_row(string,"hy");
                            Haus[i][hy] = floatstr(string);
                            mysql_fetch_field_row(string,"hz");
                            Haus[i][hz] = floatstr(string);
                            mysql_fetch_field_row(string,"Verschlossen");
                            Haus[i][Verschlossen] = strval(string);
                            if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                            {
                                if(Haus[i][Verschlossen] == 0)
                                {
                                    mysql_fetch_field_row(string,"hix");
                                    Haus[i][hix] = floatstr(string);
                                    mysql_fetch_field_row(string,"hiy");
                                    Haus[i][hiy] = floatstr(string);
                                    mysql_fetch_field_row(string,"hiz");
                                    Haus[i][hiz] = floatstr(string);
                                    mysql_fetch_field_row(string,"Hausid");
                                    Haus[i][Hausid] = strval(string);
                                    mysql_fetch_field_row(string,"Interiorz");
                                    Haus[i][Interiorz] = strval(string);
                                    SetPlayerVirtualWorld(playerid, Haus[i][Hausid]);
                                    SetPlayerInterior(playerid, Haus[i][Interiorz]);
                                    SetPlayerPos(playerid, Haus[i][hix], Haus[i][hiy], Haus[i][hiz]);
                                    SendClientMessage(playerid, Rot, "Tippe /exit um das Haus wieder zu verlassen.");
                                    return 1;
                                }
                                else
                                {
                                    return SendClientMessage(playerid, Rot, "Du kannst dieses Haus nicht besichtigen.");
                                }
                            }
                         }
                    }
                }
            }
            if(listitem == 1)
            {
                ShowPlayerDialog(playerid,HausmenueInteriors,DIALOG_STYLE_LIST,"Möchtest du Renovieren","Interior1 10000$\nInterior2 25000$\nInterior3 50000$\nInterior4 75000$\nInterior5 125000$","Kaufen","Abbrechen");
            }
            if(listitem == 2)
            {
                new string[200];
                mysql_query("SELECT * FROM `Haus`");
                mysql_store_result();
                if(mysql_num_rows() != 0)
                {
                    while(mysql_retrieve_row())
                    {
                        for(new i; i<MAX_HAUS; i++)
                        {
                            mysql_fetch_field_row(string,"hx");
                            Haus[i][hx] = floatstr(string);
                            mysql_fetch_field_row(string,"hy");
                            Haus[i][hy] = floatstr(string);
                            mysql_fetch_field_row(string,"hz");
                            Haus[i][hz] = floatstr(string);
                            mysql_fetch_field_row(string,"Hausid");
                            Haus[i][Hausid] = strval(string);
                            mysql_fetch_field_row(string,"Verschlossen");
                            Haus[i][Verschlossen] = strval(string);
                            if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                            {
                                format(string, sizeof(string), "%s", mysql_GetStringz("Haus","Besitzer","Hausid",Haus[i][Hausid]));
                                if(strcmp(sSpieler[playerid][pName], string, false) == 0)
                                {
                                    if(Haus[i][Verschlossen] == 0)
                                    {
                                        mysql_SetIntz("Haus","Verschlossen",1,"Hausid",Haus[i][Hausid]);
                                        SendClientMessage(playerid,Rot,"Abgeschlossen");
                                        return 1;
                                    }
                                    else
                                    {
                                        mysql_SetIntz("Haus","Verschlossen",0,"Hausid",Haus[i][Hausid]);
                                        SendClientMessage(playerid,Gelb,"Aufgeschlossen");
                                        return 1;
                                    }
                                }
                            }
                        }

                    }

                }
            }
            if(listitem == 3)
            {
                new str[128];
                format(str,sizeof(str),"Hallo %s\nMöchtest du wirklich ausziehen?",sSpieler[playerid][pName]);
                ShowPlayerDialog(playerid,HausMenueAbgeben,DIALOG_STYLE_MSGBOX,"Ausziehen",str,"Nein","Ja");
            }
        }
    }

    //HausMenueAbgeben
    if(dialogid == HausMenueAbgeben)
    {
        if(response == 0)
        {
            new string[200];
            mysql_query("SELECT * FROM `Haus`");
            mysql_store_result();
            if(mysql_num_rows() != 0)
            {
                while(mysql_retrieve_row())
                {
                    for(new i; i<MAX_HAUS; i++)
                    {
                        mysql_fetch_field_row(string,"hx");
                        Haus[i][hx] = floatstr(string);
                        mysql_fetch_field_row(string,"hy");
                        Haus[i][hy] = floatstr(string);
                        mysql_fetch_field_row(string,"hz");
                        Haus[i][hz] = floatstr(string);
                        mysql_fetch_field_row(string,"Hausid");
                        Haus[i][Hausid] = strval(string);
                        if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                        {
                            format(string, sizeof(string), "%s", mysql_GetStringz("Haus","Besitzer","Hausid",Haus[i][Hausid]));
                            if(strcmp(sSpieler[playerid][pName], string, false) == 0)
                            {
                                mysql_SetIntz("Haus","InBesitz",0,"Hausid",Haus[i][Hausid]);
                                mysql_SetStringz("Haus","Besitzer","Niemand","Hausid",Haus[i][Hausid]);
                                return 1;
                            }
                        }
                    }
                }
            }
        }
        if(response == 1)
        return 1;
    }

    //HausmenueInteriors
    if(dialogid == HausmenueInteriors)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            if(listitem == 0)
            {
                new string[200];
                mysql_query("SELECT * FROM `Haus`");
                mysql_store_result();
                if(mysql_num_rows() != 0)
                {
                    while(mysql_retrieve_row())
                    {
                        for(new i; i<MAX_HAUS; i++)
                        {
                            mysql_fetch_field_row(string,"hx");
                            Haus[i][hx] = floatstr(string);
                            mysql_fetch_field_row(string,"hy");
                            Haus[i][hy] = floatstr(string);
                            mysql_fetch_field_row(string,"hz");
                            Haus[i][hz] = floatstr(string);
                            mysql_fetch_field_row(string,"Hausid");
                            Haus[i][Hausid] = strval(string);
                            if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                            {
                                format(string, sizeof(string), "%s", mysql_GetStringz("Haus","Besitzer","Hausid",Haus[i][Hausid]));
                                if(strcmp(sSpieler[playerid][pName], string, false) == 0)
                                {
                                    if(GetPlayerMoney(playerid) < 10000)
                                    {
                                        SendClientMessage(playerid,Rot,"Du hast nicht genug Geld");
                                        return 1;
                                    }
                                    else
                                    {
                                        GivePlayerMoney(playerid, -10000);
                                        mysql_SetIntz("Haus","Interiorz",1,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hix",223.04,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hiy",1287.26,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hiz",1081.8,"Hausid",Haus[i][Hausid]);
                                        SendClientMessage(playerid,Gelb,"Glückwunsch");
                                    }
                                }
                            }
                        }
                    }
                }
            }
            if(listitem == 1)
            {
                new string[200];
                mysql_query("SELECT * FROM `Haus`");
                mysql_store_result();
                if(mysql_num_rows() != 0)
                {
                    while(mysql_retrieve_row())
                    {
                        for(new i; i<MAX_HAUS; i++)
                        {
                            mysql_fetch_field_row(string,"hx");
                            Haus[i][hx] = floatstr(string);
                            mysql_fetch_field_row(string,"hy");
                            Haus[i][hy] = floatstr(string);
                            mysql_fetch_field_row(string,"hz");
                            Haus[i][hz] = floatstr(string);
                            mysql_fetch_field_row(string,"Hausid");
                            Haus[i][Hausid] = strval(string);
                            if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                            {
                                format(string, sizeof(string), "%s", mysql_GetStringz("Haus","Besitzer","Hausid",Haus[i][Hausid]));
                                if(strcmp(sSpieler[playerid][pName], string, false) == 0)
                                {
                                    if(GetPlayerMoney(playerid) < 10000)
                                    {
                                        SendClientMessage(playerid,Rot,"Du hast nicht genug Geld");
                                        return 1;
                                    }
                                    else
                                    {
                                        GivePlayerMoney(playerid, -25000);
                                        mysql_SetIntz("Haus","Interiorz",10,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hix",2270.39,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hiy",-1210.45,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hiz",1047,"Hausid",Haus[i][Hausid]);
                                        SendClientMessage(playerid,Gelb,"Glückwunsch");
                                    }
                                }
                            }
                        }
                    }
                }
            }
            if(listitem == 2)
            {
                new string[200];
                mysql_query("SELECT * FROM `Haus`");
                mysql_store_result();
                if(mysql_num_rows() != 0)
                {
                    while(mysql_retrieve_row())
                    {
                        for(new i; i<MAX_HAUS; i++)
                        {
                            mysql_fetch_field_row(string,"hx");
                            Haus[i][hx] = floatstr(string);
                            mysql_fetch_field_row(string,"hy");
                            Haus[i][hy] = floatstr(string);
                            mysql_fetch_field_row(string,"hz");
                            Haus[i][hz] = floatstr(string);
                            mysql_fetch_field_row(string,"Hausid");
                            Haus[i][Hausid] = strval(string);
                            if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                            {
                                format(string, sizeof(string), "%s", mysql_GetStringz("Haus","Besitzer","Hausid",Haus[i][Hausid]));
                                if(strcmp(sSpieler[playerid][pName], string, false) == 0)
                                {
                                    if(GetPlayerMoney(playerid) < 10000)
                                    {
                                        SendClientMessage(playerid,Rot,"Du hast nicht genug Geld");
                                        return 1;
                                    }
                                    else
                                    {
                                        GivePlayerMoney(playerid, -50000);
                                        mysql_SetIntz("Haus","Interiorz",6,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hix",2196.799,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hiy",-1204.355,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hiz",1048.6,"Hausid",Haus[i][Hausid]);
                                        SendClientMessage(playerid,Gelb,"Glückwunsch");
                                    }
                                }
                            }
                        }
                    }
                }
            }
            if(listitem == 3)
            {
                new string[200];
                mysql_query("SELECT * FROM `Haus`");
                mysql_store_result();
                if(mysql_num_rows() != 0)
                {
                    while(mysql_retrieve_row())
                    {
                        for(new i; i<MAX_HAUS; i++)
                        {
                            mysql_fetch_field_row(string,"hx");
                            Haus[i][hx] = floatstr(string);
                            mysql_fetch_field_row(string,"hy");
                            Haus[i][hy] = floatstr(string);
                            mysql_fetch_field_row(string,"hz");
                            Haus[i][hz] = floatstr(string);
                            mysql_fetch_field_row(string,"Hausid");
                            Haus[i][Hausid] = strval(string);
                            if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                            {
                                format(string, sizeof(string), "%s", mysql_GetStringz("Haus","Besitzer","Hausid",Haus[i][Hausid]));
                                if(strcmp(sSpieler[playerid][pName], string, false) == 0)
                                {
                                    if(GetPlayerMoney(playerid) < 10000)
                                    {
                                        SendClientMessage(playerid,Rot,"Du hast nicht genug Geld");
                                        return 1;
                                    }
                                    else
                                    {
                                        GivePlayerMoney(playerid, -75000);
                                        mysql_SetIntz("Haus","Interiorz",9,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hix",2317.82,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hiy",-1026.75,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hiz",1049.8,"Hausid",Haus[i][Hausid]);
                                        SendClientMessage(playerid,Gelb,"Glückwunsch");
                                    }
                                }
                            }
                        }
                    }
                }
            }
            if(listitem == 4)
            {
                new string[200];
                mysql_query("SELECT * FROM `Haus`");
                mysql_store_result();
                if(mysql_num_rows() != 0)
                {
                    while(mysql_retrieve_row())
                    {
                        for(new i; i<MAX_HAUS; i++)
                        {
                            mysql_fetch_field_row(string,"hx");
                            Haus[i][hx] = floatstr(string);
                            mysql_fetch_field_row(string,"hy");
                            Haus[i][hy] = floatstr(string);
                            mysql_fetch_field_row(string,"hz");
                            Haus[i][hz] = floatstr(string);
                            mysql_fetch_field_row(string,"Hausid");
                            Haus[i][Hausid] = strval(string);
                            if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                            {
                                format(string, sizeof(string), "%s", mysql_GetStringz("Haus","Besitzer","Hausid",Haus[i][Hausid]));
                                if(strcmp(sSpieler[playerid][pName], string, false) == 0)
                                {
                                    if(GetPlayerMoney(playerid) < 10000)
                                    {
                                        SendClientMessage(playerid,Rot,"Du hast nicht genug Geld");
                                        return 1;
                                    }
                                    else
                                    {
                                        GivePlayerMoney(playerid, -125000);
                                        mysql_SetIntz("Haus","Interiorz",5,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hix",140.18,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hiy",1366.585,"Hausid",Haus[i][Hausid]);
                                        mysql_SetFloatz("Haus","hiz",1083.5,"Hausid",Haus[i][Hausid]);
                                        SendClientMessage(playerid,Gelb,"Glückwunsch");
                                    }
                                }
                            }
                        }
                    }
                }
            }
        }
    }
    //HausmenueBesucher
    if(dialogid == HausmenueBesucher)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            if(listitem == 0)
            {
                new string[200];
                mysql_query("SELECT * FROM `Haus`");
                mysql_store_result();
                if(mysql_num_rows() != 0)
                {
                    while(mysql_retrieve_row())
                    {
                        for(new i; i<MAX_HAUS; i++)
                        {
                            mysql_fetch_field_row(string,"hx");
                            Haus[i][hx] = floatstr(string);
                            mysql_fetch_field_row(string,"hy");
                            Haus[i][hy] = floatstr(string);
                            mysql_fetch_field_row(string,"hz");
                            Haus[i][hz] = floatstr(string);
                            mysql_fetch_field_row(string,"Verschlossen");
                            Haus[i][Verschlossen] = strval(string);
                            if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                            {
                                if(Haus[i][Verschlossen] == 0)
                                {
                                    mysql_fetch_field_row(string,"hix");
                                    Haus[i][hix] = floatstr(string);
                                    mysql_fetch_field_row(string,"hiy");
                                    Haus[i][hiy] = floatstr(string);
                                    mysql_fetch_field_row(string,"hiz");
                                    Haus[i][hiz] = floatstr(string);
                                    mysql_fetch_field_row(string,"Hausid");
                                    Haus[i][Hausid] = strval(string);
                                    mysql_fetch_field_row(string,"Interiorz");
                                    Haus[i][Interiorz] = strval(string);
                                    SetPlayerVirtualWorld(playerid, Haus[i][Hausid]);
                                    SetPlayerInterior(playerid, Haus[i][Interiorz]);
                                    SetPlayerPos(playerid, Haus[i][hix], Haus[i][hiy], Haus[i][hiz]);
                                    SendClientMessage(playerid, Rot, "Tippe /exit um das Haus wieder zu verlassen.");
                                    return 1;
                                }
                                else
                                {
                                    return SendClientMessage(playerid, Rot, "Du kannst dieses Haus nicht besichtigen.");
                                }
                            }
                         }
                    }
                }
            }
            if(listitem == 1)
            {
                ShowPlayerDialog(playerid,HausmenueBesucherPreis,DIALOG_STYLE_INPUT,"Preis","Wieviel soll das Haus kosten?","Okay","Abbrechen");
            }
        }
    }
    //HausmenueBesucherPreis
    if(dialogid == HausmenueBesucherPreis)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            new string[200];
            mysql_query("SELECT * FROM `Haus`");
            mysql_store_result();
            if(mysql_num_rows() != 0)
            {
                while(mysql_retrieve_row())
                {
                    for(new i; i<MAX_HAUS; i++)
                    {
                        mysql_fetch_field_row(string,"hx");
                        Haus[i][hx] = floatstr(string);
                        mysql_fetch_field_row(string,"hy");
                        Haus[i][hy] = floatstr(string);
                        mysql_fetch_field_row(string,"hz");
                        Haus[i][hz] = floatstr(string);
                        mysql_fetch_field_row(string,"Hausid");
                        Haus[i][Hausid] = strval(string);
                        if(IsPlayerInRangeOfPoint(playerid, 3, Haus[i][hx], Haus[i][hy], Haus[i][hz]))
                        {
                            if(strval(inputtext) > 25000000)
                            {
                                SendClientMessage(playerid,Rot,"Häuser dürfen nur 2500000$ kosten");
                                return 1;
                            }
                            else
                            {
                                mysql_SetIntz("Haus","Preis",strval(inputtext),"Hausid",Haus[i][Hausid]);
                                return 1;
                            }
                        }
                    }
                }
            }
        }
    }
    //LoadÖl
    if(dialogid == LoadOel)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            if(sSpieler[playerid][pOel]+strval(inputtext) > 100)
            {
                return SendClientMessage(playerid,Rot,"Du kannst dein Fahrzeug nur mit 100 Liter Öl beladen");
            }
            if(GetPlayerMoney(playerid) < strval(inputtext)*5)
            {
                new string[128];
                format(string,sizeof(string),"Du hast nicht genug Geld. Benötigt %d$",strval(inputtext)*5);
                return SendClientMessage(playerid,Rot,string);
            }
            else
            {
                new string[128];
                format(string,sizeof(string),"Du hast %d Liter Öl für %d$ gekauft",strval(inputtext),strval(inputtext)*5);
                sSpieler[playerid][pOel]+= strval(inputtext);
                SendClientMessage(playerid,Rot,string);
                GivePlayerMoney(playerid, -strval(inputtext)*5);
                return 1;
            }
        }
    }
    //SellÖl
    if(dialogid == SellOel)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            new string[200];
            mysql_query("SELECT * FROM `Tankstellens`");
            mysql_store_result();
            if(mysql_num_rows() != 0)
            {
                while(mysql_retrieve_row())
                {
                    for(new i; i<MAX_TANKE; i++)
                    {
                        mysql_fetch_field_row(string,"TX");
                        Tanken[i][TX] = floatstr(string);
                        mysql_fetch_field_row(string,"TY");
                        Tanken[i][TY] = floatstr(string);
                        mysql_fetch_field_row(string,"TZ");
                        Tanken[i][TZ] = floatstr(string);
                        mysql_fetch_field_row(string,"PreisAN");
                        Tanken[i][PreisAN] = strval(string);
                        mysql_fetch_field_row(string,"Inhalt");
                        Tanken[i][Inhalt] = strval(string);
                        mysql_fetch_field_row(string,"TankID");
                        Tanken[i][TankID] = strval(string);


                        if(strval(inputtext) > sSpieler[playerid][pOel])
                        {
                            return SendClientMessage(playerid,Rot,"Du hast nicht soviel Öl bei dir");
                        }
                        if(Tanken[i][Inhalt] + strval(inputtext) > 5000)
                        {
                            new stringz[128];
                            format(stringz,sizeof(stringz),"Die Tankstele ist leider schon voll",strval(inputtext)*5);
                            return SendClientMessage(playerid,Rot,stringz);
                        }
                        else
                        {
                            new stringz[128];
                            format(stringz,sizeof(stringz),"Du hast %d Liter Öl für %d$ verkauft.",strval(inputtext),strval(inputtext)*Tanken[i][PreisAN]);
                            sSpieler[playerid][pOel]-= strval(inputtext);
                            SendClientMessage(playerid,Rot,stringz);
                            mysql_SetIntz("Tankstellen","Inhalt",Tanken[i][Inhalt]+strval(inputtext),"TankID",Tanken[i][TankID]);
                            GivePlayerMoney(playerid, strval(inputtext)*Tanken[i][PreisAN]);
                            return 1;
                        }
                    }
                }
            }
        }
    }
    //Apfelbaum
    if(dialogid == Apfelbaumz)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            new string[200];
            mysql_query("SELECT * FROM `Apfelbaum`");
            mysql_store_result();
            if(mysql_num_rows() != 0)
            {
                while(mysql_retrieve_row())
                {
                    for(new i; i<MAX_APFEL; i++)
                    {
                        mysql_fetch_field_row(string,"AX");
                        Apfelbaum[i][AX] = floatstr(string);
                        mysql_fetch_field_row(string,"AY");
                        Apfelbaum[i][AY] = floatstr(string);
                        mysql_fetch_field_row(string,"AZ");
                        Apfelbaum[i][AZ] = floatstr(string);
                        mysql_fetch_field_row(string,"ApfelID");
                        Apfelbaum[i][ApfelID] = strval(string);
                        mysql_fetch_field_row(string,"Wasser");
                        Apfelbaum[i][Wasser] = strval(string);
                        mysql_fetch_field_row(string,"Ernte");
                        Apfelbaum[i][Ernte] = strval(string);

                        if(IsPlayerInRangeOfPoint(playerid,3,Apfelbaum[i][AX],Apfelbaum[i][AY],Apfelbaum[i][AZ]))
                        {
                            if(listitem == 0)
                            {
                                if(Apfelbaum[i][Ernte] == 0)
                                {
                                    return SendClientMessage(playerid,Rot,"Dieser Baum hat leider noch keine Äpfel");
                                }
                                else
                                {
                                    new str[128];
                                    sSpieler[playerid][pApfel] += Apfelbaum[i][Ernte];
                                    format(str,sizeof(str),"Du hast %d Äpfel von diesem Baum gepflückt",Apfelbaum[i][Ernte]);
                                    SendClientMessage(playerid,Gelb,str);
                                    mysql_SetIntz("Apfelbaum","Ernte",0,"ApfelID",Apfelbaum[i][ApfelID]);
                                    return 1;
                                }
                            }
                            if(listitem == 3)
                            {
                                new query[512];
                                DestroyObject(Apfelbaum[i][ApfelID]+BankIdIDX+1);
                                format(query,128,"DELETE FROM `Apfelbaum` WHERE `ApfelID` = '%d'",Apfelbaum[i][ApfelID]);
                                ApfelIdIDX = Apfelbaum[i][ApfelID] ;
                                mysql_query(query);
                            }
                        }
                    }
                }
            }
        }
    }
    //AutohausCreate
    if(dialogid == AutohausCreate)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            new string[200];
            mysql_query("SELECT * FROM `autoconfig`");
            mysql_store_result();
            if(mysql_num_rows() != 0)
            {
                while(mysql_retrieve_row())
                {
                    for(new i; i<MAX_CONFIG; i++)
                    {
                        mysql_fetch_field_row(string,"Carid");
                        CarConfig[i][ConfigCarID] = strval(string);
                        mysql_fetch_field_row(string,"Modelid");
                        CarConfig[i][ConfigModelID] = strval(string);
                        mysql_fetch_field_row(string,"Preis");
                        CarConfig[i][ConfigPreisID] = strval(string);
                        mysql_fetch_field_row(string,"Stahl");
                        CarConfig[i][ConfigStahlID] = strval(string);

                        if(CarConfig[i][ConfigModelID] == strval(inputtext))
                        {
                            new str[128], Geld, Lager;
                            Lager = mysql_GetInt("Lager","Inhalt","Name","AutohausStahl");
                            Geld = mysql_GetIntz("Fraktionen","FraktionKasse","FraktionID",sSpieler[playerid][pFraktion]);

                            if(CarConfig[i][ConfigPreisID] > Geld)
                            {
                                return SendClientMessage(playerid,Rot,"Deine Fraktion hat nicht genug Geld in Der Fraktionskasse");
                            }
                            if(CarConfig[i][ConfigStahlID] > Lager)
                            {
                                return SendClientMessage(playerid,Rot,"Deine Fraktion hat nicht genug Stahl im Lager");
                            }

                            format(str,sizeof(str),"Model: %d\nPreis: %d\nStahl: %d",strval(inputtext),CarConfig[i][ConfigPreisID],CarConfig[i][ConfigStahlID]);
                            ShowPlayerDialog(playerid,AutohausCreateZ,DIALOG_STYLE_MSGBOX,"Autohaus",str,"Bestellen","Abbrechen");
                            sSpieler[playerid][pAutocreate] = strval(inputtext);
                            mysql_SetInt("Lager","Inhalt",Lager-CarConfig[i][ConfigStahlID],"Name","AutohausStahl");
                            mysql_SetIntz("Fraktionen","FraktionKasse",Geld-CarConfig[i][ConfigPreisID],"FraktionID",sSpieler[playerid][pFraktion]);
                            return 1;
                        }
                        else
                        {

                        }
                    }
                }
            }
        }
    }
    //AutohausCreate
    if(dialogid == AutohausCreateZ)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            new Float:vehx, Float:vehy, Float:vehz, Float:veha;
            new query[512];
            new spielercarid;
            GetPlayerPos(playerid,vehx,vehy,vehz);
            SpielerVehIDX++;
            spielercarid = CreateVehicle(sSpieler[playerid][pAutocreate],vehx,vehy,vehz,veha,1,1,1000*60*5);
            PutPlayerInVehicle(playerid, spielercarid, 0);
            format(query, sizeof(query),"SVR:%d",spielercarid);
            SetVehicleNumberPlate(spielercarid,query);
            SpielerCars[SpielerVehIDX][SpielerCarID]=GetPlayerVehicleID(playerid);
            SpielerCars[SpielerVehIDX][SpielerModelID]=sSpieler[playerid][pAutocreate];
            SpielerCars[SpielerVehIDX][SpielerStatus]=0;
            SpielerCars[SpielerVehIDX][sX]=vehx;
            SpielerCars[SpielerVehIDX][sY]=vehy;
            SpielerCars[SpielerVehIDX][sZ]=vehz;
            SpielerCars[SpielerVehIDX][sA]=veha;
            format(query, sizeof(query), "INSERT INTO spielercars (carID, carModel, Status, SpielerID, Preis, Farbe1, Farbe2, X, Y, Z, A) VALUES ('%d', '%d', '0', 'UNVERKAUFT', '0', '1', '1', '%f', '%f', '%f', '%f')",GetPlayerVehicleID(playerid), sSpieler[playerid][pAutocreate], vehx, vehy, vehz, veha);
            mysql_query(query);

            format(query, 128, "Du hast ein Car mit der ID: %d erstellt", SpielerCars[SpielerVehIDX][SpielerCarID]);
            SendClientMessage(playerid,0x008000FF,query);
        }
    }
    //AutohausPreis
    if(dialogid == AutohausPreis)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            if(strval(inputtext) < 0)
            {
                return SendClientMessage(playerid,Rot,"Das Auto kann nicht -$ kosten");
            }
            if(strval(inputtext) > 250000000)
            {
                return SendClientMessage(playerid,Rot,"Das Auto kann  nicht mehr als 250 Millionen kosten");
            }
            else
            {
                new str[128];
                format(str,sizeof(str),"Info-Vehicleid: %d, Preis: %d",GetPlayerVehicleID(playerid),strval(inputtext));
                mysql_SetIntz("spielercars","Status",1,"CarID",sSpieler[playerid][pVehicle]);
                mysql_SetIntz("spielercars","Preis",strval(inputtext),"CarID",sSpieler[playerid][pVehicle]);
                SendClientMessage(playerid,Rot,str);
                return 1;
            }
        }
    }
    //AutohausPreis
    if(dialogid == OrdnungsamtTicket)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            if(strval(inputtext) <= 0)
            {
                return SendClientMessage(playerid,Rot,"Das Ticket kann nicht 0$ kosten kosten");
            }
            if(strval(inputtext) > 2000000)
            {
                return SendClientMessage(playerid,Rot,"Das Ticket kann  nicht mehr als 2 Millionen kosten");
            }
            else
            {
                new str[128];
                format(str,sizeof(str),"Info-Vehicleid: %d, Preis: %d",GetPlayerVehicleID(playerid),strval(inputtext));
                mysql_SetIntz("spielercars","Status",2,"CarID",sSpieler[playerid][pVehicle]);
                mysql_SetIntz("spielercars","Preis",strval(inputtext),"CarID",sSpieler[playerid][pVehicle]);
                SendClientMessage(playerid,Rot,str);
                return 1;
            }
        }
    }
    //AutohausKauf
    if(dialogid == AutohausKauf)
    {
        if(response == 0)
        return RemovePlayerFromVehicle(playerid);
        if(response == 1)
        {
            sSpieler[playerid][pFraktionz] = 18;
            new Frakgeld = mysql_GetIntz("Fraktionen","FraktionKasse","FraktionID",sSpieler[playerid][pFraktionz]);

            new Geld = mysql_GetIntz("Spielercars","Preis","CarID",sSpieler[playerid][pVehicle]);
            if(GetPlayerMoney(playerid) < Geld )
            {
                SendClientMessage(playerid,Rot,"Du hast nicht genug Geld");
                RemovePlayerFromVehicle(playerid);
                return 1;
            }
            else
            {
                new str[128];
                format(str,sizeof(str),"Du hast ein Auto für %d$ gekauft",Geld);
                SendClientMessage(playerid,Gelb,str);
                mysql_SetIntz("Fraktionen","FraktionKasse",Frakgeld+Geld,"FraktionID",sSpieler[playerid][pFraktionz]);
                mysql_SetIntz("Spielercars","Status",4,"CarID",sSpieler[playerid][pVehicle]);
                mysql_SetStringz("Spielercars","SpielerID",sSpieler[playerid][pName],"CarID",sSpieler[playerid][pVehicle]);
                GivePlayerMoney(playerid, -Geld);
            }
            return 1;
        }
    }
    //OrdnungsamtFreikaufen
    if(dialogid == OrdnungsamtFreikaufen)
    {
        if(response == 0)
        return RemovePlayerFromVehicle(playerid);
        if(response == 1)
        {
            sSpieler[playerid][pFraktionz] = 7;
            new Frakgeld = mysql_GetIntz("Fraktionen","FraktionKasse","FraktionID",sSpieler[playerid][pFraktionz]);
            new Geld = mysql_GetIntz("Spielercars","Preis","CarID",sSpieler[playerid][pVehicle]);

            if(GetPlayerMoney(playerid) < Geld )
            {
                return SendClientMessage(playerid,Rot,"Du hast nicht genug Geld");
            }
            else
            {
                new str[128];
                format(str,sizeof(str),"Du hast ein Auto für %d$ freigekauft",Geld);
                SendClientMessage(playerid,Gelb,str);
                mysql_SetIntz("Fraktionen","FraktionKasse",Frakgeld+Geld,"FraktionID",sSpieler[playerid][pFraktionz]);
                mysql_SetIntz("Spielercars","Status",4,"CarID",sSpieler[playerid][pVehicle]);
                GivePlayerMoney(playerid, -Geld);
                sSpieler[playerid][pFraktionz] = 0;
            }
            return 1;
        }
    }
    //AutohausKaufz
    if(dialogid == AutohausKaufz)
    {
        if(response == 0)
        return 1;
        if(response == 1)
        {
            sSpieler[playerid][pFraktionz] = 18;
            new Frakgeld = mysql_GetIntz("Fraktionen","FraktionKasse","FraktionID",sSpieler[playerid][pFraktionz]);

            new Geld = mysql_GetIntz("Spielercars","Preis","CarID",sSpieler[playerid][pVehicle]);
            if(GetPlayerMoney(playerid) < Geld )
            {
                return SendClientMessage(playerid,Rot,"Du hast nicht genug Geld");
            }
            else
            {
                new str[128];
                format(str,sizeof(str),"Du hast ein Auo für %d$ gekauft,%d",Geld);
                SendClientMessage(playerid,Gelb,str);
                mysql_SetIntz("Fraktionen","FraktionKasse",Frakgeld+Geld,"FraktionID",sSpieler[playerid][pFraktionz]);
                mysql_SetIntz("Spielercars","Status",4,"CarID",sSpieler[playerid][pVehicle]);
                mysql_SetStringz("Spielercars","SpielerID",sSpieler[playerid][pName],"CarID",sSpieler[playerid][pVehicle]);
                GivePlayerMoney(playerid, -Geld);
                return 1;
            }
        }
    }
    //Bankkontoerstellt
    if(dialogid == Atmmenue)
    {
        if(response == 0)
        return 1;
        if(response == 1)
            {
            if(listitem == 0)
            {
                ShowPlayerDialog(playerid,AtmmenueEinzahlung,DIALOG_STYLE_INPUT,"Einzahlung","Summe eingeben:","Einzahlen","Verlassen");
            }
            if(listitem == 1)
            {
                ShowPlayerDialog(playerid,AtmmenueAuszahlung,DIALOG_STYLE_INPUT,"Auszahlung","Summe eingeben:","Auszahlen","Verlassen");
            }
            if(listitem == 2)
            {
                ShowPlayerDialog(playerid,AtmmenueUeberweisung,DIALOG_STYLE_INPUT,"Überweisung","Name des Empfängers:","Bestätigen","Verlassen");
            }
            if(listitem == 3)
            {
                new str[128]; //Neuer string [128] definiert die Länge. "str" ist hierbei nur der Name. Könnte auch asdf heißen.
                format(str,sizeof(str),"Kontostand: %d$",sSpieler[playerid][pBank]);
                ShowPlayerDialog(playerid,AtmmenueKontostand,DIALOG_STYLE_MSGBOX,"Kontostand",str,"Schließen",""); //"DIALOG_STYLE_MSGBOX" gibt an, dass eine Nachrichtenbox erscheinen soll.
            }
        }
    }

    //BankkontoEinzahlung
    if(dialogid == AtmmenueEinzahlung)
    {
        new str[128]; //Wieder ein neuer string.
        if(response == 0)
        {
        }
        else
        {
            if(GetPlayerMoney(playerid) < strval(inputtext))return SendClientMessage(playerid,0xC8C8C8FF,"Du hast nicht genug Geld dabei!"); //Wenn das Geld auf der Hand des Spielers nicht ausreicht, erscheint diese Nachricht. Der inputtext dient hierbei als Abfrage dafür. Das Zeichen < müsstest du aus dem Mathematikunterricht kennen.
            GivePlayerMoney(playerid, - strval(inputtext)); //Hier wird dem Spieler das Geld abgezogen, was er einzahlt. Da es kein Befehl zum abziehen von Geld gibt, arbeitet man mit Minus.
            sSpieler[playerid][pBank] += strval(inputtext); //Hier wird das Geld dann auf das Bankkonto addiert.
            format(str,sizeof(str),"Sie haben %d$ auf ihr Konto eingezahlt",strval(inputtext)); //Jetzt kommt der string (str) zum Einsatz.
            ShowPlayerDialog(playerid,AtmmenueEinzahlungText,DIALOG_STYLE_MSGBOX,"Transaktion",str,"Schließen",""); //und als Dialog ausgegeben
            Save(playerid);
        }
    }

    //Bankkontoauszahlung
    if(dialogid == AtmmenueAuszahlung)
    {
        new str[128]; //Wieder ein neuer string.
        if(response == 0)
        {
        }
        else
        {
            if(sSpieler[playerid][pBank] < strval(inputtext))return SendClientMessage(playerid,0xC8C8C8FF,"Du hast nicht genug auf dem Konto!"); //Das Selbe wie eben, nur wird das Geld auf der Bank abgefragt.
            GivePlayerMoney(playerid,strval(inputtext)); //Hier wird dem Spieler das Geld abgezogen, was er einzahlt. Da es kein Befehl zum abziehen von Geld gibt, arbeitet man mit Minus.
            sSpieler[playerid][pBank] -= strval(inputtext); //Hier wird das Geld dann auf das Bankkonto addiert.
            format(str,sizeof(str),"Sie haben %d$ von ihrem Konto ausgezahlt",strval(inputtext)); //Jetzt kommt der string (str) zum Einsatz.
            ShowPlayerDialog(playerid,AtmmenueAuszahlungText,DIALOG_STYLE_MSGBOX,"Transaktion",str,"Schließen",""); //und als Dialog ausgegeben

        }
    }

    //BankÜberweisung
    if(dialogid == AtmmenueUeberweisung)
    {
        new pID;
        if(!response)return SendClientMessage(playerid,Rot,"Bitte gebe einen Namen an");
        if(sscanf(inputtext,"u",pID))return SendClientMessage(playerid,Rot,"Bitte gebe einen Namen an"); //Falls ihr mit sscanf nicht umgehen könnt, nutzt euere Variante um Parameter abzufragen oder ladet euch die Include runter.
        if(!IsPlayerConnected(pID))return SendClientMessage(playerid,Rot,"Ungültiger Spieler"); //Hier wird, wie über dieser Zeile der Dialog "UeberweisungText1" nochmals verwendet. Das macht bei Texten nichts, diese könnt ihr so oft wie ihr wollt verwenden.
        if (pID == playerid)return SendClientMessage(playerid,Rot,"Du kanst dir kein Geld überweisen");
        ShowPlayerDialog(playerid,AtmmenueUeberweisung2,DIALOG_STYLE_INPUT,"Überweisung","Summe eingeben:","Überweisen","Verlassen");
        Ueberweiser[playerid] = pID; //Unsere Variable kommt zum Einsatz
        Ueberweiser[pID] = playerid; // same here
    }
    if(dialogid == AtmmenueUeberweisung2)
    {
        new pID = Ueberweiser[playerid]; //Jetzt können wir ganz einfach den Namen nutzen
        new str[128],str2[128];
        if(!response)return SendClientMessage(playerid,Rot,"Bitte gebe einen Betrag an");
        if(sSpieler[playerid][pBank] < strval(inputtext))return SendClientMessage(playerid,0xC8C8C8FF,"Du hast nicht genug Geld auf dem Konto!"); //Wenn nicht genug Geld auf dem Konto ist, wird diese Nachricht versendet. Man kann dies natürlich auch durch einen Dialog ersetzen.
        sSpieler[playerid][pBank] -= strval(inputtext); //Geld wird vom Konto abgezogen
        sSpieler[pID][pBank] += strval(inputtext); //und hier auf das Konto des Anderen addiert.
        format(str,sizeof(str),"Sie haben %d$ auf das Konto von %s überwiesen",strval(inputtext));
        ShowPlayerDialog(playerid,UeberweisungText1,DIALOG_STYLE_MSGBOX,"Transaktion",str,"Schließen","");
        format(str2,sizeof(str2),"ihnen wurde %d$ auf ihr Konto überwiesen",strval(inputtext));
        SendClientMessage(pID,0xC8C8C8FF,str2);
    }
    //RefillAnfrage
    if(dialogid == RefillAnfrage)
    {
        new pID = GetPVarInt(playerid,"MechaPerson");
        new PreisRefill = GetPVarInt(playerid,"MechaPreis");
        if(response==0)
        {
            SendClientMessage(playerid,Blau,"Du hast das Angebot abgelehnt.");
            SendClientMessage(pID,Blau,"Der Spieler hat dein Angebot abgelehnt.");
            DeletePVar(playerid,"MechaPerson");
            DeletePVar(playerid,"MechaPreis");
        }
        if(response==1)
        {
            new car = GetPlayerVehicleID(playerid);
            SendClientMessage(playerid,Grün,"Du hast das Angebot angenommen.");
            SendClientMessage(pID,Grün,"Der Spieler hat dein Angebot angenommen.");
            Tank[car] = 100;
            GivePlayerMoney(playerid,-PreisRefill);
            GivePlayerMoney(pID,PreisRefill);
            DeletePVar(playerid,"MechaPerson");
            DeletePVar(playerid,"MechaPreis");
        }
    }
    //PepairAnfrage
    if(dialogid == RepairAnfrage)
    {
        new pID = GetPVarInt(playerid,"MechaPerson");
        new Preisrepair = GetPVarInt(playerid,"MechaPreis");
        if(response==0)
        {
            SendClientMessage(playerid,Blau,"Du hast das Angebot abgelehnt.");
            SendClientMessage(pID,Blau,"Der Spieler hat dein Angebot abgelehnt.");
            DeletePVar(playerid,"MechaPerson");
            DeletePVar(playerid,"MechaPreis");
        }
        if(response==1)
        {
            new vehid = GetPlayerVehicleID(playerid);
            SendClientMessage(playerid,Grün,"Du hast das Angebot angenommen.");
            SendClientMessage(pID,Grün,"Der Spieler hat dein Angebot angenommen.");
            SetVehicleHealth(vehid,1000);
            RepairVehicle(vehid);
            GivePlayerMoney(playerid,-Preisrepair);
            GivePlayerMoney(pID,Preisrepair);
            DeletePVar(playerid,"MechaPerson");
            DeletePVar(playerid,"MechaPreis");
        }
    }
    //Job Busfahrer
    if(dialogid == JobBusfahrer)
    {
        if(response==0)
        return 1;
        if(response==1)
        {
            if(listitem == 0)
            {
                BusfahrerJob[playerid] = 1;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zur ersten Haltestelle");
                SetPlayerCheckpoint(playerid,1109.2239,-1742.9210,13.4907,3);
                return 1;
            }
            if(listitem == 1)
            {
                BusfahrerJob[playerid] = 20;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zur ersten Haltestelle");
                SetPlayerCheckpoint(playerid,1109.2239,-1742.9210,13.4907,3);
                return 1;
            }
            if(listitem == 2)
            {
                BusfahrerJob[playerid] = 40;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zur ersten Haltestelle");
                SetPlayerCheckpoint(playerid,1109.2239,-1742.9210,13.4907,3);
                return 1;
            }
        }
    }
    //ErzJobwahlSkill1
    if(dialogid == JobErzsammler)
    {
        if(response == 0)
        return 1;
        if(response == 1)
            {
            if(listitem == 0)
            {
                ErzsammlerJob[playerid] = 1;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten Checkpoint");
                SetPlayerCheckpoint(playerid,641.8652,940.7026,-34.4812,8);
                return 1;
            }
            if(listitem == 1)
            {
                ErzsammlerJob[playerid] = 30;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten Checkpoint");
                SetPlayerCheckpoint(playerid,641.8652,940.7026,-34.4812,8);
                return 1;
            }
            if(listitem == 2)
            {
                ErzsammlerJob[playerid] = 60;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten Checkpoint");
                SetPlayerCheckpoint(playerid,641.8652,940.7026,-34.4812,8);
                return 1;
            }
        }
    }
    //Job Busfahrer
    if(dialogid == JobFarmer)
    {
        if(response==0)
        return 1;
        if(response==1)
        {
            if(listitem == 0)
            {
                FarmerJob[playerid] = 1;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten Checkpoint");
                SetPlayerCheckpoint(playerid,-1414.9473,-1471.0012,101.6032,3);
                return 1;
            }
            if(listitem == 1)
            {
                FarmerJob[playerid] = 20;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten Checkpoint");
                SetPlayerCheckpoint(playerid,-1414.9473,-1471.0012,101.6032,3);
                return 1;
            }
            if(listitem == 2)
            {
                FarmerJob[playerid] = 40;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten Checkpoint");
                SetPlayerCheckpoint(playerid,-1414.9473,-1471.0012,101.6032,3);
                return 1;
            }
        }
    }
    //Job Trucker
    if(dialogid == JobTrucker)
    {
        if(response==0)
        return 1;
        if(response==1)
        {
            if(listitem == 0)
            {
                TruckerJob[playerid] = 1;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, begebe dich nun zum Abgabepunkt");
                SetPlayerCheckpoint(playerid,785.4728,-1612.3879,13.4772,3);
                return 1;
            }
            if(listitem == 1)
            {
                TruckerJob[playerid] = 20;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, begebe dich nun zum Abgabepunkt");
                SetPlayerCheckpoint(playerid,1910.8138,-1765.5759,13.4751,3);
                return 1;
            }
            if(listitem == 2)
            {
                TruckerJob[playerid] = 40;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, begebe dich nun zum Abgabepunkt");
                SetPlayerCheckpoint(playerid,2687.1335,-1687.6971,9.5332,3);
                return 1;
            }
        }
    }
    //Job Pilot
    if(dialogid == JobPilot)
    {
        if(response==0)
        return 1;
        if(response==1)
        {
            if(listitem == 0)
            {
                PilotJob[playerid] = 1;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fliege nun zum Abgabepunkt");
                SetPlayerCheckpoint(playerid,1336.0438,1595.8184,11.2778,3);
                return 1;
            }
            if(listitem == 1)
            {
                PilotJob[playerid] = 20;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fliege nun zum Abgabepunkt");
                SetPlayerCheckpoint(playerid,377.9998,2535.8989,17.0249,3);
                return 1;
            }
            if(listitem == 2)
            {
                PilotJob[playerid] = 40;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fliege nun zum Abgabepunkt");
                SetPlayerCheckpoint(playerid,-1302.1427,35.0560,14.6096,3);
                return 1;
            }
        }
    }
    //Job Muelmann
    if(dialogid == JobMuelmann)
    {
        if(response==0)
        return 1;
        if(response==1)
        {
            if(listitem == 0)
            {
                MuelmannJob[playerid] = 1;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten CheckPoint");
                SetPlayerCheckpoint(playerid,2830.4729,-1591.7631,11.0141,3);
                return 1;
            }
            if(listitem == 1)
            {
                MuelmannJob[playerid] = 20;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten CheckPoint");
                SetPlayerCheckpoint(playerid,2830.4729,-1591.7631,11.0141,3);
                return 1;
            }
            if(listitem == 2)
            {
                MuelmannJob[playerid] = 40;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten CheckPoint");
                SetPlayerCheckpoint(playerid,2830.4729,-1591.7631,11.0141,3);
                return 1;
            }
        }
    }
    //Job Reiniger
    if(dialogid == JobReiniger)
    {
        if(response==0)
        return 1;
        if(response==1)
        {
            if(listitem == 0)
            {
                ReinigerJob[playerid] = 1;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten CheckPoint");
                SetPlayerCheckpoint(playerid,2109.6086,-1396.4316,23.9204,3);
                return 1;
            }
            if(listitem == 1)
            {
                ReinigerJob[playerid] = 20;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten CheckPoint");
                SetPlayerCheckpoint(playerid,2085.3677,-1380.9993,23.9218,3);
                return 1;
            }
            if(listitem == 2)
            {
                ReinigerJob[playerid] = 40;
                SendClientMessage(playerid,Grau,"Du hast eine Strecke gewählt, fahre nun zum ersten CheckPoint");
                SetPlayerCheckpoint(playerid,2086.7979,-1381.1920,23.9218,3);
                return 1;
            }
        }
    }
    //New Interior
    if(dialogid == newinterior)
    {
        if(response==0)
        return 1;
        if(response==1)
        {
            new Float:x, Float:y, Float:z;
            GetPlayerPos(playerid,x,y,z);

            if(listitem == 0)
            {
                new query[512];
                format(query, sizeof(query), "INSERT INTO interiors (InteriorID, InteriorIDs, InteriorEinX, InteriorEinY, InteriorEinZ, InteriorAusX, InteriorAusY, InteriorAusZ) VALUES ('%d', '0', '%f', '%f', '%f', '2305.0593', '-15.9743', '26.7422')",IntIdIDX, x, y, z);
                mysql_query(query);
                IntIdIDX++;
                return 1;
            }
            if(listitem == 1)
            {
                new query[512];
                format(query, sizeof(query), "INSERT INTO interiors (InteriorID, InteriorIDs, InteriorEinX, InteriorEinY, InteriorEinZ, InteriorAusX, InteriorAusY, InteriorAusZ) VALUES ('%d', '0', '%f', '%f', '%f', '663.836242', '-575.605407', '16.343263')",IntIdIDX, x, y, z);
                mysql_query(query);
                IntIdIDX++;
                return 1;
            }
            if(listitem == 2)
            {
                new query[512];
                format(query, sizeof(query), "INSERT INTO interiors (InteriorID, InteriorIDs, InteriorEinX, InteriorEinY, InteriorEinZ, InteriorAusX, InteriorAusY, InteriorAusZ) VALUES ('%d', '3', '%f', '%f', '%f', '-2640.762939', '1406.682006', '906.460937')",IntIdIDX, x, y, z);
                mysql_query(query);
                IntIdIDX++;
                return 1;
            }
            if(listitem == 3)
            {
                new query[512];
                format(query, sizeof(query), "INSERT INTO interiors (InteriorID, InteriorIDs, InteriorEinX, InteriorEinY, InteriorEinZ, InteriorAusX, InteriorAusY, InteriorAusZ) VALUES ('%d', '3', '%f', '%f', '%f', '-2029.798339', '-106.675910', '1035.171875')",IntIdIDX, x, y, z);
                mysql_query(query);
                IntIdIDX++;
                return 1;
            }
            if(listitem == 4)
            {
                new query[512];
                format(query, sizeof(query), "INSERT INTO interiors (InteriorID, InteriorIDs, InteriorEinX, InteriorEinY, InteriorEinZ, InteriorAusX, InteriorAusY, InteriorAusZ) VALUES ('%d', '2', '%f', '%f', '%f', '411.625976', '-21.433298', '1001.804687')",IntIdIDX, x, y, z);
                mysql_query(query);
                IntIdIDX++;
                return 1;
            }
        }
    }
    return 1;
}

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

//Stock Mysql
stock Connect_To_Database()
{
    mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS); //Wir versuchen mit den Angaben die wir oben im Script gemacht haben uns mit dem MySQL Server zu verbinden.
    if(mysql_ping() == 1) //Es wird überprüft ob die Verbindung steht.
    {
        //Falls ja wird das in die Console geschrieben und die Funktion wird beendet.
        print("<-| [MYSQL] Verbindung zur Datenbank wurde erfolgreich hergestellt!");

        //Spieler Autos
        mysql_query("CREATE TABLE IF NOT EXISTS `SpielerCars` (`carID` int(11), `carModel` int(11), `Status` int(11), `SpielerID` varchar(128), `Preis` int(11), `Farbe1` int(11), `Farbe2` int(11), `X` float(20), `Y` float(20), `Z` float(20), `A` float(20), PRIMARY KEY (`carID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `SpielerCars`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],stringz[512],frakcarid;
                mysql_fetch_field_row(string,"carID");
                SpielerCars[SpielerVehIDX][SpielerCarID] = strval(string);
                mysql_fetch_field_row(string,"carModel");
                SpielerCars[SpielerVehIDX][SpielerModelID] = strval(string);
                mysql_fetch_field_row(string,"Status");
                SpielerCars[SpielerVehIDX][SpielerStatus] = strval(string);
                mysql_fetch_field_row(string,"Preis");
                SpielerCars[SpielerVehIDX][SpielerPreis] = strval(string);
                mysql_fetch_field_row(string,"X");
                SpielerCars[SpielerVehIDX][sX] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                SpielerCars[SpielerVehIDX][sY] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                SpielerCars[SpielerVehIDX][sZ] = floatstr(string);
                mysql_fetch_field_row(string,"A");
                SpielerCars[SpielerVehIDX][sA] = floatstr(string);
                mysql_fetch_field_row(string,"Farbe1");
                SpielerCars[SpielerVehIDX][sColor1] = strval(string);
                mysql_fetch_field_row(string,"Farbe2");
                SpielerCars[SpielerVehIDX][sColor2] = strval(string);
                frakcarid = AddStaticVehicleEx(SpielerCars[SpielerVehIDX][SpielerModelID],SpielerCars[SpielerVehIDX][sX],SpielerCars[SpielerVehIDX][sY],SpielerCars[SpielerVehIDX][sZ],SpielerCars[SpielerVehIDX][sA],SpielerCars[SpielerVehIDX][sColor1],SpielerCars[SpielerVehIDX][sColor2],1000*60*5);

                format(stringz, sizeof(stringz),"Spielercar");
                SetVehicleNumberPlate(frakcarid,stringz);
                format(string, sizeof(string), "UPDATE `SpielerCars` SET `carID` = %d WHERE `carID` = %d", frakcarid, SpielerCars[SpielerVehIDX][SpielerCarID]);
                SpielerCars[SpielerVehIDX][SpielerCarID] = frakcarid;
                mysql_query(string);
                SpielerVehIDX++;
            }
        }
        //Autos
        mysql_query("CREATE TABLE IF NOT EXISTS `ServerCars` (`carID` int(11), `carModel` int(11), `Farbe1` int(11), `Farbe2` int(11), `X` float(20), `Y` float(20), `Z` float(20), `A` float(20), PRIMARY KEY (`carID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `ServerCars`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],servercarid;
                mysql_fetch_field_row(string,"carID");
                ServerVeh[ServerVehIDX][sCarID] = strval(string);
                mysql_fetch_field_row(string,"carModel");
                ServerVeh[ServerVehIDX][sModelID] = strval(string);
                mysql_fetch_field_row(string,"X");
                ServerVeh[ServerVehIDX][sX] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                ServerVeh[ServerVehIDX][sY] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                ServerVeh[ServerVehIDX][sZ] = floatstr(string);
                mysql_fetch_field_row(string,"A");
                ServerVeh[ServerVehIDX][sA] = floatstr(string);
                mysql_fetch_field_row(string,"Farbe1");
                ServerVeh[ServerVehIDX][sColor1] = strval(string);
                mysql_fetch_field_row(string,"Farbe2");
                ServerVeh[ServerVehIDX][sColor2] = strval(string);
                servercarid = AddStaticVehicleEx(ServerVeh[ServerVehIDX][sModelID],ServerVeh[ServerVehIDX][sX],ServerVeh[ServerVehIDX][sY],ServerVeh[ServerVehIDX][sZ],ServerVeh[ServerVehIDX][sA],ServerVeh[ServerVehIDX][sColor1],ServerVeh[ServerVehIDX][sColor2],1000*60*5);
                format(string, sizeof(string),"SVR:%d",servercarid);
                SetVehicleNumberPlate(servercarid,string);
                format(string, sizeof(string), "UPDATE `ServerCars` SET `carID` = %d WHERE `carID` = %d", servercarid, ServerVeh[ServerVehIDX][sCarID]);
                ServerVeh[ServerVehIDX][sCarID] = servercarid;
                mysql_query(string);
                ServerVehIDX++;
            }
        }
        //Miet Autos
        mysql_query("CREATE TABLE IF NOT EXISTS `mietcars` (`carID` int(11), `carModel` int(11), `Farbe1` int(11), `Farbe2` int(11), `X` float(20), `Y` float(20), `Z` float(20), `A` float(20), `Preis` int(11), `Besitzer` int(11), PRIMARY KEY (`carID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `mietcars`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],mietcarid;
                mysql_fetch_field_row(string,"carID");
                MietCars[MietVehIDX][MietCarID] = strval(string);
                mysql_fetch_field_row(string,"carModel");
                MietCars[MietVehIDX][MietModelID] = strval(string);
                mysql_fetch_field_row(string,"X");
                MietCars[MietVehIDX][mX] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                MietCars[MietVehIDX][mY] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                MietCars[MietVehIDX][mZ] = floatstr(string);
                mysql_fetch_field_row(string,"A");
                MietCars[MietVehIDX][mA] = floatstr(string);
                mysql_fetch_field_row(string,"Farbe1");
                MietCars[MietVehIDX][mColor1] = strval(string);
                mysql_fetch_field_row(string,"Farbe2");
                MietCars[MietVehIDX][mColor2] = strval(string);
                mietcarid = AddStaticVehicleEx(MietCars[MietVehIDX][MietModelID],MietCars[MietVehIDX][mX],MietCars[MietVehIDX][mY],MietCars[MietVehIDX][mZ],MietCars[MietVehIDX][mA],MietCars[MietVehIDX][mColor1],MietCars[MietVehIDX][mColor2],1000*60*5);
                format(string, sizeof(string),"SVR:%d",mietcarid);
                SetVehicleNumberPlate(mietcarid,string);
                format(string, sizeof(string), "UPDATE `Mietcars` SET `carID` = %d WHERE `carID` = %d", mietcarid, MietCars[MietVehIDX][MietCarID]);
                MietCars[MietVehIDX][MietCarID] = mietcarid;
                mysql_query(string);
                MietVehIDX++;
            }
        }
        //Fraktion Autos
        mysql_query("CREATE TABLE IF NOT EXISTS `FraktionCars` (`carID` int(11), `carModel` int(11), `FrakID` int(11), `Farbe1` int(11), `Farbe2` int(11), `X` float(20), `Y` float(20), `Z` float(20), `A` float(20), PRIMARY KEY (`carID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `FraktionCars`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],frakcarid;
                mysql_fetch_field_row(string,"carID");
                FrakCars[FrakVehIDX][fCarID] = strval(string);
                mysql_fetch_field_row(string,"carModel");
                FrakCars[FrakVehIDX][fModelID] = strval(string);
                mysql_fetch_field_row(string,"FrakID");
                FrakCars[FrakVehIDX][FrakID] = strval(string);
                mysql_fetch_field_row(string,"X");
                FrakCars[FrakVehIDX][sX] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                FrakCars[FrakVehIDX][sY] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                FrakCars[FrakVehIDX][sZ] = floatstr(string);
                mysql_fetch_field_row(string,"A");
                FrakCars[FrakVehIDX][sA] = floatstr(string);
                mysql_fetch_field_row(string,"Farbe1");
                FrakCars[FrakVehIDX][sColor1] = strval(string);
                mysql_fetch_field_row(string,"Farbe2");
                FrakCars[FrakVehIDX][sColor2] = strval(string);
                frakcarid = AddStaticVehicleEx(FrakCars[FrakVehIDX][fModelID],FrakCars[FrakVehIDX][sX],FrakCars[FrakVehIDX][sY],FrakCars[FrakVehIDX][sZ],FrakCars[FrakVehIDX][sA],FrakCars[FrakVehIDX][sColor1],FrakCars[FrakVehIDX][sColor2],1000*60*5);
                format(string, sizeof(string),"SVR:%d",frakcarid);
                SetVehicleNumberPlate(frakcarid,string);
                format(string, sizeof(string), "UPDATE `FraktionCars` SET `carID` = %d WHERE `carID` = %d", frakcarid, FrakCars[FrakVehIDX][fCarID]);
                FrakCars[FrakVehIDX][fCarID] = frakcarid;
                mysql_query(string);
                FrakVehIDX++;
            }
        }
        //Job Autos
        mysql_query("CREATE TABLE IF NOT EXISTS `JobCars` (`carID` int(11), `carModel` int(11), `JobID` int(11), `Farbe1` int(11), `Farbe2` int(11), `X` float(20), `Y` float(20), `Z` float(20), `A` float(20), PRIMARY KEY (`carID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `JobCars`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],frakcarid;
                mysql_fetch_field_row(string,"carID");
                JobCars[JobVehIDX][JobCarID] = strval(string);
                mysql_fetch_field_row(string,"carModel");
                JobCars[JobVehIDX][JobModelID] = strval(string);
                mysql_fetch_field_row(string,"JobID");
                JobCars[JobVehIDX][JobID] = strval(string);
                mysql_fetch_field_row(string,"X");
                JobCars[JobVehIDX][jX] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                JobCars[JobVehIDX][jY] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                JobCars[JobVehIDX][jZ] = floatstr(string);
                mysql_fetch_field_row(string,"A");
                JobCars[JobVehIDX][jA] = floatstr(string);
                mysql_fetch_field_row(string,"Farbe1");
                JobCars[JobVehIDX][jColor1] = strval(string);
                mysql_fetch_field_row(string,"Farbe2");
                JobCars[JobVehIDX][jColor2] = strval(string);
                frakcarid = AddStaticVehicleEx(JobCars[JobVehIDX][JobModelID],JobCars[JobVehIDX][jX],JobCars[JobVehIDX][jY],JobCars[JobVehIDX][jZ],JobCars[JobVehIDX][jA],JobCars[JobVehIDX][jColor1],JobCars[JobVehIDX][jColor2],1000*60*5);
                format(string, sizeof(string),"Job:%d",frakcarid);
                SetVehicleNumberPlate(frakcarid,string);
                format(string, sizeof(string), "UPDATE `JobCars` SET `carID` = %d WHERE `carID` = %d", frakcarid, JobCars[JobVehIDX][JobCarID]);
                JobCars[JobVehIDX][JobCarID] = frakcarid;
                mysql_query(string);
                JobVehIDX++;
            }
        }
        //Haus
        mysql_query("CREATE TABLE IF NOT EXISTS `Haus` (`Hausid` int(11),`Besitzer` varchar(128), `Preis` int(11), `Preisz` int(11), `Interiorz` int(11), `InBesitz` int(11), `Verschlossen` int(11), `hx` float(11), `hy` float(11), `hz` float(11), `hix` float(11), `hiy` float(11), `hiz` float(11),PRIMARY KEY (`Hausid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `Haus`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512];
                mysql_fetch_field_row(string,"hiz");
                Haus[HausIdIDX][hiz] = floatstr(string);
                mysql_fetch_field_row(string,"Hausid");
                Haus[HausIdIDX][Hausid] = strval(string);

                mysql_query(string);
                HausIdIDX++;
            }
        }
        //Pickups
        mysql_query("CREATE TABLE IF NOT EXISTS `Pickups` (`Pickid` int(11), `Modelid` int(11), `X` float(20), `Y` float(20), `Z` float(20),PRIMARY KEY (`Pickid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `Pickups`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],Pickidcreate,stringzz[128];
                mysql_fetch_field_row(string,"Modelid");
                Pickups[PickIdIDX][Modelid] = strval(string);
                mysql_fetch_field_row(string,"Pickid");
                Pickups[PickIdIDX][Pickid] = strval(string);
                mysql_fetch_field_row(string,"X");
                Pickups[PickIdIDX][X] = floatstr(string);
                mysql_fetch_field_row(string,"Y");
                Pickups[PickIdIDX][Y] = floatstr(string);
                mysql_fetch_field_row(string,"Z");
                Pickups[PickIdIDX][Z] = floatstr(string);
                Pickidcreate = CreatePickup(Pickups[PickIdIDX][Modelid],1,Pickups[PickIdIDX][X],Pickups[PickIdIDX][Y],Pickups[PickIdIDX][Z],-1);

                format(stringzz, sizeof(stringzz), "UPDATE `Pickups` SET `Pickid` = %d WHERE `Pickid` = %d", PickIdIDX, Pickups[PickIdIDX][Pickid]);
                Pickups[PickIdIDX][Pickid] = Pickidcreate;
                mysql_query(stringzz);

                mysql_query(string);
                PickIdIDX++;
            }
        }
        //Interiors
        mysql_query("CREATE TABLE IF NOT EXISTS `Interiors` (`InteriorID` int(11), `InteriorIDs` int(11), `InteriorEinX` float(11), `InteriorEinY` float(11), `InteriorEinZ` float(11), `InteriorAusX` float(11), `InteriorAusY` float(11), `InteriorAusZ` float(11),PRIMARY KEY (`InteriorID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `Interiors`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512];
                mysql_fetch_field_row(string,"InteriorIDs");
                Interiors[IntIdIDX][InteriorIDs] = strval(string);
                mysql_fetch_field_row(string,"InteriorEinX");
                Interiors[IntIdIDX][InteriorEinX] = floatstr(string);
                mysql_fetch_field_row(string,"InteriorEinY");
                Interiors[IntIdIDX][InteriorEinY] = floatstr(string);
                mysql_fetch_field_row(string,"InteriorEinZ");
                Interiors[IntIdIDX][InteriorEinZ] = floatstr(string);
                mysql_fetch_field_row(string,"InteriorAusX");
                Interiors[IntIdIDX][InteriorAusX] = floatstr(string);
                mysql_fetch_field_row(string,"InteriorAusY");
                Interiors[IntIdIDX][InteriorAusY] = floatstr(string);
                mysql_fetch_field_row(string,"InteriorAusZ");
                Interiors[IntIdIDX][InteriorAusZ] = floatstr(string);
                mysql_fetch_field_row(string,"InteriorVW");
                Interiors[IntIdIDX][InteriorVW] = strval(string);
                mysql_query(string);
                IntIdIDX++;
            }
        }
        //Fraktionen
        mysql_query("CREATE TABLE IF NOT EXISTS `Fraktionen` (`FraktionID` int(11), `FraktionName` varchar(24), `FraktionKasse` int(11), `FraktionMitglieder` int(11),PRIMARY KEY (`FraktionID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `Fraktionen`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512];
                mysql_fetch_field_row(string,"FraktionID");
                Fraktionen[FrakIdIDX][FraktionID] = strval(string);
                mysql_fetch_field_row(string,"FraktionName");
                Fraktionen[FrakIdIDX][FraktionName] = strval(string);
                mysql_fetch_field_row(string,"FraktionKasse");
                Fraktionen[FrakIdIDX][FraktionKasse] = strval(string);
                mysql_fetch_field_row(string,"FraktionMitglieder");
                Fraktionen[FrakIdIDX][FraktionMitglieder] = strval(string);
                mysql_query(string);
                FrakIdIDX++;
            }
        }
        if(mysql_num_rows() == 0)
        {
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('1', 'LSPD', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('2', 'SFPD', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('3', 'LVPD', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('4', 'Bundeswehr', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('5', 'SWAT', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('6', 'Medic', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('7', 'Ordnungsamt', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('8', 'Staat', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('9', 'Transport', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('10', 'Grovestreet', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('11', 'Vagos', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('12', 'Rifa', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('13', 'Yakuza', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('14', 'Bikers', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('15', 'Russenmafia', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('16', 'HellsAngels', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('17', 'Terroristen', '200000', '0')");
            mysql_query("INSERT INTO fraktionen (FraktionID, FraktionName, FraktionKasse, FraktionMitglieder) VALUES ('18', 'Autohändler', '200000', '0')");
        }
        //Spawns
        mysql_query("CREATE TABLE IF NOT EXISTS `Spawns` (`FrakID` int(11), `FrakColor` varchar(128), `SX` float(20), `SY` float(20), `SZ` float(20),PRIMARY KEY (`FrakID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `Spawns`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                for(new i;i<MAX_SPAWN; i++)
                {
                    new string[512];
                    mysql_fetch_field_row(string,"FrakID");
                    Spawn[i][FrakID] = strval(string);
                    mysql_fetch_field_row(string,"SX");
                    Spawn[i][SX] = floatstr(string);
                    mysql_fetch_field_row(string,"SY");
                    Spawn[i][SY] = floatstr(string);
                    mysql_fetch_field_row(string,"SZ");
                    Spawn[i][SZ] = floatstr(string);
                    mysql_query(string);
                }
            }
        }
        //Tanke
        mysql_query("CREATE TABLE IF NOT EXISTS `Tankstellen` (`TankID` int(11), `Notiz` varchar(128), `Inhalt` int(11), `PreisAN` int(11), `PreisVE` int(11), `TX` float(20), `TY` float(20), `TZ` float(20),PRIMARY KEY (`TankID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `Tankstellen`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],Pickidcreate,stringzz[128];
                mysql_fetch_field_row(string,"TankID");
                Tanken[TankIdIDX][TankID] = strval(string);
                mysql_fetch_field_row(string,"TX");
                Tanken[TankIdIDX][TX] = floatstr(string);
                mysql_fetch_field_row(string,"TY");
                Tanken[TankIdIDX][TY] = floatstr(string);
                mysql_fetch_field_row(string,"TZ");
                Tanken[TankIdIDX][TZ] = floatstr(string);
                Pickidcreate = CreatePickup(1239,1,Tanken[TankIdIDX][TX],Tanken[TankIdIDX][TY],Tanken[TankIdIDX][TZ],-1);

                format(stringzz, sizeof(stringzz), "UPDATE `Tankstellen` SET `TankID` = %d WHERE `TankID` = %d", TankIdIDX, Tanken[TankIdIDX][TankID]);
                Tanken[TankIdIDX][TankID] = Pickidcreate;
                mysql_query(stringzz);

                mysql_query(string);
                TankIdIDX++;
            }
        }
        //Bankautomaten
        mysql_query("CREATE TABLE IF NOT EXISTS `Bankautomaten` (`BankID` int(11), `Notiz` varchar(128), `BXz` float(20), `BYz` float(20), `BZz` float(20), `BAz` float(20),PRIMARY KEY (`BankID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `Bankautomaten`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],Pickidcreate,stringzz[128];
                mysql_fetch_field_row(string,"BankID");
                Bank[BankIdIDX][BankID] = strval(string);
                mysql_fetch_field_row(string,"BXz");
                Bank[BankIdIDX][BX] = floatstr(string);
                mysql_fetch_field_row(string,"BYz");
                Bank[BankIdIDX][BY] = floatstr(string);
                mysql_fetch_field_row(string,"BZz");
                Bank[BankIdIDX][BZ] = floatstr(string);
                mysql_fetch_field_row(string,"BAz");
                Bank[BankIdIDX][BA] = floatstr(string);

                Pickidcreate = CreateObject(2618,Bank[BankIdIDX][BX],Bank[BankIdIDX][BY],Bank[BankIdIDX][BZ],0.00000000,0.00000000,Bank[BankIdIDX][BA]);

                format(stringzz, sizeof(stringzz), "UPDATE `Bankautomaten` SET `BankID` = %d WHERE `BankID` = %d", BankIdIDX, Bank[BankIdIDX][BankID]);
                Bank[BankIdIDX][BankID] = Pickidcreate;
                mysql_query(stringzz);

                mysql_query(string);
                BankIdIDX++;
            }
        }
        //Apfelbäume
        mysql_query("CREATE TABLE IF NOT EXISTS `Apfelbaum` (`ApfelID` int(11), `Wasser` int(11), `Ernte` int(11), `AX` float(20), `AY` float(20), `AZ` float(20),PRIMARY KEY (`ApfelID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `Apfelbaum`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512],Pickidcreate,stringzz[128];
                mysql_fetch_field_row(string,"ApfelID");
                Apfelbaum[ApfelIdIDX][ApfelID] = strval(string);
                mysql_fetch_field_row(string,"AX");
                Apfelbaum[ApfelIdIDX][AX] = floatstr(string);
                mysql_fetch_field_row(string,"AY");
                Apfelbaum[ApfelIdIDX][AY] = floatstr(string);
                mysql_fetch_field_row(string,"AZ");
                Apfelbaum[ApfelIdIDX][AZ] = floatstr(string);

                Pickidcreate = CreateObject(700,Apfelbaum[ApfelIdIDX][AX],Apfelbaum[ApfelIdIDX][AY],Apfelbaum[ApfelIdIDX][AZ],0.00000000,0.00000000,270.00000000);

                format(stringzz, sizeof(stringzz), "UPDATE `Apfelbaum` SET `ApfelID` = %d WHERE `ApfelID` = %d", ApfelIdIDX, Apfelbaum[ApfelIdIDX][ApfelID]);
                Apfelbaum[ApfelIdIDX][ApfelID] = Pickidcreate;
                mysql_query(stringzz);

                mysql_query(string);
                ApfelIdIDX++;
            }
        }
        //autoconfig
        mysql_query("CREATE TABLE IF NOT EXISTS `autoconfig` (`Carid` int(11), `Modelid` int(11), `Preis` int(11), `Stahl` int(11),PRIMARY KEY (`Carid`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `autoconfig`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512];
                mysql_fetch_field_row(string,"Carid");
                CarConfig[CarConfigIdIDX][ConfigCarID] = strval(string);
                mysql_fetch_field_row(string,"Modelid");
                CarConfig[CarConfigIdIDX][ConfigModelID] = strval(string);
                mysql_fetch_field_row(string,"Preis");
                CarConfig[CarConfigIdIDX][ConfigPreisID] = strval(string);
                mysql_fetch_field_row(string,"Stahl");
                CarConfig[CarConfigIdIDX][ConfigStahlID] = strval(string);

                CarConfigIdIDX++;
            }
        }
        //Lager
        mysql_query("CREATE TABLE IF NOT EXISTS `Lager` (`Name` varchar(128), `Inhalt` int(11),PRIMARY KEY (`Name`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `Lager`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {

            }
        }
        if(mysql_num_rows() == 0)
        {
            mysql_query("INSERT INTO Lager (Name, Inhalt) VALUES ('AutohausStahl', '1000')");
        }
        //Bomben
        mysql_query("CREATE TABLE IF NOT EXISTS `bomben` (`BombenID` int(11), `Timer` int(11), `BXz` float(20), `BYz` float(20), `BZz` float(20),PRIMARY KEY (`BombenID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `bomben`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {
                new string[512];
                mysql_fetch_field_row(string,"BombenID");
                Bomben[BombeIdIDX][BombenID] = strval(string);
                mysql_fetch_field_row(string,"Timer");
                Bomben[BombeIdIDX][Timer] = strval(string);
                mysql_fetch_field_row(string,"BXz");
                Bomben[BombeIdIDX][BX] = floatstr(string);
                mysql_fetch_field_row(string,"BYz");
                Bomben[BombeIdIDX][BY] = floatstr(string);
                mysql_fetch_field_row(string,"BZz");
                Bomben[BombeIdIDX][BZ] = floatstr(string);

                BombeIdIDX++;
            }
        }
        //Jobconfig
        mysql_query("CREATE TABLE IF NOT EXISTS `Jobconfig` (`Name` varchar(128), `Min_Lohn` int(11), `Max_Lohn` int(11), `Job_Exp` int(11),PRIMARY KEY (`Name`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
        mysql_query("SELECT * FROM `Jobconfig`");
        mysql_store_result();
        if(mysql_num_rows() != 0)
        {
            while(mysql_retrieve_row())
            {

            }
        }
        if(mysql_num_rows() == 0)
        {
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobBuslinieEins', '1000', '200', '2')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobBuslinieZwei', '1000', '200', '3')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobBuslinieDrei', '1000', '200', '4')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobErzsammlerEins', '2000', '200', '4')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobErzsammlerZwei', '3000', '200', '5')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobErzsammlerDrei', '4000', '200', '6')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobFarmerEins', '4000', '200', '7')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobFarmerZwei', '4000', '200', '8')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobFarmerDrei', '4000', '200', '9')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobTruckerEins', '4000', '200', '10')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobTruckerZwei', '4000', '200', '11')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobTruckerDrei', '4000', '200', '12')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobPilotEins', '4000', '200', '10')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobPilotZwei', '4000', '200', '11')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobPilotDrei', '4000', '200', '12')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobMuelmannEins', '4000', '200', '10')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobMuelmannZwei', '4000', '200', '10')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobMuelmannDrei', '4000', '200', '10')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobFischerEins', '4000', '200', '10')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobFischerZwei', '4000', '200', '10')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobFischerDrei', '4000', '200', '10')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobReinigerEins', '4000', '200', '10')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobReinigerZwei', '4000', '200', '10')");
            mysql_query("INSERT INTO Jobconfig (Name, Min_Lohn, Max_Lohn, Job_Exp) VALUES ('JobReinigerDrei', '4000', '200', '10')");
        }
        mysql_free_result();
        return true;
    }
    else
    {
        //Falls nicht wird erneut versucht eine Verbindung aufzubauen.
        print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
        print("<-| [MYSQL] Es wird erneut versucht eine Verbindung zur Datenbank herzustellen!");
        mysql_connect(SQL_HOST, SQL_USER, SQL_DATA, SQL_PASS);
        if(mysql_ping() == 1)
        {
            print("<-| [MYSQL] Es konnte im 2 Versuch eine Verbindung hergestellt werden!");
            return true;
        }
        else
        {
            //Falls das auch nicht Funktioniert wird der Server zur Sicherheit wieder heruntergefahren.
            print("<-| [MYSQL] Es konnte keine Verbindung zur Datenbank hergestellt werden!");
            print("<-| [MYSQL] Der Server wird nun beendet!");
            SendRconCommand("exit");
            return true;
        }
    }
}

//GETFLoat
stock Float:mysql_GetFloat(Table[], Field[], Where[], Is[])
{
    new query[128], Float:sqlfloat;
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Is, Is);
    format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_float(sqlfloat);
    mysql_free_result();
    return sqlfloat;
}

//Stock Mysql
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 `username` = '%s'", Name);
    mysql_query(Query);
    mysql_store_result();
    count = mysql_num_rows();
    mysql_free_result();
    return count;
}

//Stock CreateAccount
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` (`username`, `password`) VALUES ('%s', '%s')", Name, pass);
    mysql_query(query);
    return true;
}

//Stock Passwort
stock mysql_ReturnPasswort(Name[])
{
    new query[130], Get[130];
    mysql_real_escape_string(Name, Name);
    format(query, 128, "SELECT `password` FROM `Accounts` WHERE `username` = '%s'", Name);
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_row(Get);
    mysql_free_result();
    return Get;
}

//StockGetInt
stock mysql_GetInt(Table[], Field[], Where[], Is[])
{
    new query[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Is, Is);
    format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
    mysql_query(query);
    mysql_store_result();
    new sqlint = mysql_fetch_int();
    mysql_free_result();
    return sqlint;
}

//StockGetIntz
stock mysql_GetIntz(Table[], Field[], Where[], Is[])
{
    new query[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Is, Is);
    format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%d'", Field, Table, Where, Is);
    mysql_query(query);
    mysql_store_result();
    new sqlint = mysql_fetch_int();
    mysql_free_result();
    return sqlint;
}

stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
{
    new query[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Where2, Where2);
    format(query, 128, "UPDATE `%s` SET `%s` = '%d' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
    mysql_query(query);
    return true;
}

stock mysql_SetIntz(Table[], Field[], To, Where[], Where2[])
{
    new query[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Where2, Where2);
    format(query, 128, "UPDATE `%s` SET `%s` = '%d' WHERE `%s` = '%d'", Table, Field, To, Where, Where2);
    mysql_query(query);
    return true;
}

stock mysql_SetFloat(Table[], Field[], Float:To, Where[], Where2[])
{
    new query[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Where2, Where2);
    format(query, 128, "UPDATE `%s` SET `%s` = '%f' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
    mysql_query(query);
    return true;
}

stock mysql_SetFloatz(Table[], Field[], Float:To, Where[], Where2[])
{
    new query[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Where2, Where2);
    format(query, 128, "UPDATE `%s` SET `%s` = '%f' WHERE `%s` = '%d'", Table, Field, To, Where, Where2);
    mysql_query(query);
    return true;
}

stock mysql_SetString(Table[], Field[], To[], Where[], Where2[])
{
    new query[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(To, To);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Where2, Where2);
    format(query, 128, "UPDATE `%s` SET `%s` = '%s' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
    mysql_query(query);
    return true;
}

stock mysql_SetStringz(Table[], Field[], To[], Where[], Where2[])
{
    new query[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(To, To);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Where2, Where2);
    format(query, 128, "UPDATE `%s` SET `%s` = '%s' WHERE `%s` = '%d'", Table, Field, To, Where, Where2);
    mysql_query(query);
    return true;
}

stock mysql_GetString(Table[], Field[], Where[], Is[])
{
    new query[128], Get[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Is, Is);
    format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%s'", Field, Table, Where, Is);
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_row(Get);
    mysql_free_result();
    return Get;
}

stock mysql_GetStringz(Table[], Field[], Where[], Is[])
{
    new query[128], Get[128];
    mysql_real_escape_string(Table, Table);
    mysql_real_escape_string(Field, Field);
    mysql_real_escape_string(Where, Where);
    mysql_real_escape_string(Is, Is);
    format(query, 128, "SELECT `%s` FROM `%s` WHERE `%s` = '%d'", Field, Table, Where, Is);
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_row(Get);
    mysql_free_result();
    return Get;
}

//Stock LoadPlayer
stock LoadPlayer(playerid)
{
    if(!IsPlayerNPC(playerid))//Wir fragen ab ob der angegebene Spieler auch Online ist, und kein NPC ist (nur zur sicherhheit)
    {
        GetPlayerName(playerid, sSpieler[playerid][pName], MAX_PLAYER_NAME); //Wir Speichern den Namen des Spielers in der Variable [i]SpielerInfo[playerid][pName][/i]
        sSpieler[playerid][pLevel] = mysql_GetInt("Accounts", "Erfahrung", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pAdmin] = mysql_GetInt("Accounts", "Admin", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pGeld] = mysql_GetInt("Accounts", "Geld", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pBank] = mysql_GetInt("Accounts", "Bank", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pKills] = mysql_GetInt("Accounts", "Kills", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pTode] = mysql_GetInt("Accounts", "Tode", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pFraktion] = mysql_GetInt("Accounts", "Fraktion", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pRang] = mysql_GetInt("Accounts", "Rang", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobkling] = mysql_GetInt("Accounts", "Jobkling", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pApfelkern] = mysql_GetInt("Accounts", "Apfelkern", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pApfel] = mysql_GetInt("Accounts", "Apfel", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pKirschkern] = mysql_GetInt("Accounts", "Kirschkern", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pKirschen] = mysql_GetInt("Accounts", "Kirschen", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pHanfkern] = mysql_GetInt("Accounts", "Hanfkern", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pHanf] = mysql_GetInt("Accounts", "Hanf", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobBusfahrer] = mysql_GetInt("Accounts", "JobBusfahrer", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobErzsammler] = mysql_GetInt("Accounts", "JobErzsammler", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobFarmer] = mysql_GetInt("Accounts", "JobFarmer", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobTrucker] = mysql_GetInt("Accounts", "JobTrucker", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobPilot] = mysql_GetInt("Accounts", "JobPilot", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobMuelmann] = mysql_GetInt("Accounts", "JobMuelmann", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobPizzalieferant] = mysql_GetInt("Accounts", "JobPizzalieferant", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobPizza] = mysql_GetInt("Accounts", "Pizza", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobFischer] = mysql_GetInt("Accounts", "JobFischer", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobWaffendealer] = mysql_GetInt("Accounts", "JobWaffendealer", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobMaterialien] = mysql_GetInt("Accounts", "Materialien", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pJobReiniger] = mysql_GetInt("Accounts", "JobReiniger", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pSpielminuten] = mysql_GetInt("Accounts", "Spielminuten", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pSpielstunden] = mysql_GetInt("Accounts", "Spielstunden", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pSpielexp] = mysql_GetInt("Accounts", "Erfahrung", "username", sSpieler[playerid][pName]);
        sSpieler[playerid][pMietid] = 0;
        GivePlayerMoney(playerid, sSpieler[playerid][pGeld]);
        SetPlayerScore(playerid, sSpieler[playerid][pLevel]);
    }
    return 1;
}

//Stock SavePlayer
stock SavePlayer(playerid)
{
    if(!IsPlayerNPC(playerid)) //wir überprüfen ob der Spieler überhaupt noch Connected ist und ob er nicht ein NPC ist.
    {
        if(GetPVarInt(playerid,"Eingeloggt") == 1) //Und hier ob er noch eingeloggt ist.
        {
            //Nun speichern wir die Daten in der Datenbank.
            mysql_SetInt("Accounts", "Erfahrung", sSpieler[playerid][pLevel], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Admin", sSpieler[playerid][pAdmin], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Geld", GetPlayerMoney(playerid), "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Bank", sSpieler[playerid][pBank], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Kills", sSpieler[playerid][pKills], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Tode", sSpieler[playerid][pTode], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Fraktion", sSpieler[playerid][pFraktion], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Rang", sSpieler[playerid][pRang], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Jobkling", sSpieler[playerid][pJobkling], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Apfelkern", sSpieler[playerid][pApfelkern], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Apfel", sSpieler[playerid][pApfel], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Kirschkern", sSpieler[playerid][pKirschkern], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Kirschen", sSpieler[playerid][pKirschen], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Hanfkern", sSpieler[playerid][pHanfkern], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Hanf", sSpieler[playerid][pHanf], "username", sSpieler[playerid][pName]);
            mysql_SetFloat("Accounts", "Health", sSpieler[playerid][pHealth], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "JobBusfahrer",sSpieler[playerid][pJobBusfahrer], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "JobErzsammler",sSpieler[playerid][pJobErzsammler], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "JobFarmer",sSpieler[playerid][pJobFarmer], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "JobTrucker",sSpieler[playerid][pJobTrucker], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "JobPilot",sSpieler[playerid][pJobPilot], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "JobMuelmann",sSpieler[playerid][pJobMuelmann], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "JobPizzalieferant",sSpieler[playerid][pJobPizzalieferant], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Pizza",sSpieler[playerid][pJobPizza], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "JobFischer",sSpieler[playerid][pJobFischer], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "JobWaffendealer",sSpieler[playerid][pJobWaffendealer], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Materialien",sSpieler[playerid][pJobMaterialien], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "JobReiniger",sSpieler[playerid][pJobReiniger], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Spielminuten",sSpieler[playerid][pSpielminuten], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Spielstunden",sSpieler[playerid][pSpielstunden], "username", sSpieler[playerid][pName]);
            mysql_SetInt("Accounts", "Erfahrung",sSpieler[playerid][pSpielexp], "username", sSpieler[playerid][pName]);
        }
    }
    return 1;
}

//Loadhouse
public LoadHouse(number)
{
    new string[200];
    mysql_query("SELECT * FROM `Haus`");
    mysql_store_result();
    if(mysql_num_rows() != 0)
    {
        while(mysql_retrieve_row())
        {
            //TextLabel
            new Text3D:HouseLabel[10];
            new Pickidcreate,stringg[128];
            mysql_fetch_field_row(string,"hx");
            Haus[HausIdIDXz][hx] = floatstr(string);
            mysql_fetch_field_row(string,"hy");
            Haus[HausIdIDXz][hy] = floatstr(string);
            mysql_fetch_field_row(string,"hz");
            Haus[HausIdIDXz][hz] = floatstr(string);
            mysql_fetch_field_row(string,"InBesitz");
            Haus[HausIdIDXz][InBesitz] = strval(string);
            mysql_fetch_field_row(string,"Hausid");
            Haus[HausIdIDXz][Hausid] = strval(string);
            mysql_fetch_field_row(string,"Preis");
            Haus[HausIdIDXz][Preis] = strval(string);

            Pickidcreate = CreatePickup(1273,1,Haus[HausIdIDXz][hx],Haus[HausIdIDXz][hy],Haus[HausIdIDXz][hz],-1);

            new stringzz[128];
            format(stringzz, sizeof(stringzz), "UPDATE `Haus` SET `Hausid` = %d WHERE `Hausid` = %d", HausIdIDXz, Haus[HausIdIDXz][Hausid]);
            Haus[HausIdIDXz][Hausid] = Pickidcreate;
            mysql_query(stringzz);

            if(Haus[HausIdIDXz][InBesitz] == 0)
            {
                format(stringg,sizeof(stringg),"Diese Haus ist zu Verkaufen\nPreis: %d$\n/buyhouse zum kaufen\nHausnummer: %d", Haus[HausIdIDXz][Preis],Haus[HausIdIDXz][Hausid]);
            }
            else if(Haus[HausIdIDXz][InBesitz] == 1)
            {
                format(stringg,sizeof(stringg),"Dieses Haus ist verkauft\nMiete: %d$\nTippe: /rentroom", Haus[HausIdIDXz][Preis]);
            }
            else if(Haus[HausIdIDXz][InBesitz] == 2)
            {
                format(stringg,sizeof(stringg),"Dieses Haus ist verkauft\nCommand /haus\nHausnummer: %d",Haus[HausIdIDXz][Hausid]);
            }
            HouseLabel[9] = Create3DTextLabel(stringg, Blau, Haus[HausIdIDXz][hx], Haus[HausIdIDXz][hy], Haus[HausIdIDXz][hz], 10, 0, 1);
            mysql_query(string);
            HausIdIDXz++;
        }
    }
    mysql_free_result();
    return true;
}

//sscanf Befehle mit parameter
stock sscanf(string[], format[], {Float,_}:...)
{
    #if defined isnull
        if (isnull(string))
    #else
        if (string[0] == 0 || (string[0] == 1 && string[1] == 0))
    #endif
        {
            return format[0];
        }
    #pragma tabsize 4
    new
        formatPos = 0,
        stringPos = 0,
        paramPos = 2,
        paramCount = numargs(),
        delim = ' ';
    while (string[stringPos] && string[stringPos] <= ' ')
    {
        stringPos++;
    }
    while (paramPos < paramCount && string[stringPos])
    {
        switch (format[formatPos++])
        {
            case '\0':
            {
                return 0;
            }
            case 'i', 'd':
            {
                new
                    neg = 1,
                    num = 0,
                    ch = string[stringPos];
                if (ch == '-')
                {
                    neg = -1;
                    ch = string[++stringPos];
                }
                do
                {
                    stringPos++;
                    if ('0' <= ch <= '9')
                    {
                        num = (num * 10) + (ch - '0');
                    }
                    else
                    {
                        return -1;
                    }
                }
                while ((ch = string[stringPos]) > ' ' && ch != delim);
                setarg(paramPos, 0, num * neg);
            }
            case 'h', 'x':
            {
                new
                    num = 0,
                    ch = string[stringPos];
                do
                {
                    stringPos++;
                    switch (ch)
                    {
                        case 'x', 'X':
                        {
                            num = 0;
                            continue;
                        }
                        case '0' .. '9':
                        {
                            num = (num << 4) | (ch - '0');
                        }
                        case 'a' .. 'f':
                        {
                            num = (num << 4) | (ch - ('a' - 10));
                        }
                        case 'A' .. 'F':
                        {
                            num = (num << 4) | (ch - ('A' - 10));
                        }
                        default:
                        {
                            return -1;
                        }
                    }
                }
                while ((ch = string[stringPos]) > ' ' && ch != delim);
                setarg(paramPos, 0, num);
            }
            case 'c':
            {
                setarg(paramPos, 0, string[stringPos++]);
            }
            case 'f':
            {

                new changestr[16], changepos = 0, strpos = stringPos;
                while(changepos < 16 && string[strpos] && string[strpos] != delim)
                {
                    changestr[changepos++] = string[strpos++];
                    }
                changestr[changepos] = '\0';
                setarg(paramPos,0,_:floatstr(changestr));
            }
            case 'p':
            {
                delim = format[formatPos++];
                continue;
            }
            case '\'':
            {
                new
                    end = formatPos - 1,
                    ch;
                while ((ch = format[++end]) && ch != '\'') {}
                if (!ch)
                {
                    return -1;
                }
                format[end] = '\0';
                if ((ch = strfind(string, format[formatPos], false, stringPos)) == -1)
                {
                    if (format[end + 1])
                    {
                        return -1;
                    }
                    return 0;
                }
                format[end] = '\'';
                stringPos = ch + (end - formatPos);
                formatPos = end + 1;
            }
            case 'u':
            {
                new
                    end = stringPos - 1,
                    id = 0,
                    bool:num = true,
                    ch;
                while ((ch = string[++end]) && ch != delim)
                {
                    if (num)
                    {
                        if ('0' <= ch <= '9')
                        {
                            id = (id * 10) + (ch - '0');
                        }
                        else
                        {
                            num = false;
                        }
                    }
                }
                if (num && IsPlayerConnected(id))
                {
                    setarg(paramPos, 0, id);
                }
                else
                {
                    #if !defined foreach
                        #define foreach(%1,%2) for (new %2 = 0; %2 < MAX_PLAYERS; %2++) if (IsPlayerConnected(%2))
                        #define __SSCANF_FOREACH__
                    #endif
                    string[end] = '\0';
                    num = false;
                    new
                        name[MAX_PLAYER_NAME];
                    id = end - stringPos;
                    foreach (Player, playerid)
                    {
                        GetPlayerName(playerid, name, sizeof (name));
                        if (!strcmp(name, string[stringPos], true, id))
                        {
                            setarg(paramPos, 0, playerid);
                            num = true;
                            break;
                        }
                    }
                    if (!num)
                    {
                        setarg(paramPos, 0, INVALID_PLAYER_ID);
                    }
                    string[end] = ch;
                    #if defined __SSCANF_FOREACH__
                        #undef foreach
                        #undef __SSCANF_FOREACH__
                    #endif
                }
                stringPos = end;
            }
            case 's', 'z':
            {
                new
                    i = 0,
                    ch;
                if (format[formatPos])
                {
                    while ((ch = string[stringPos++]) && ch != delim)
                    {
                        setarg(paramPos, i++, ch);
                    }
                    if (!i)
                    {
                        return -1;
                    }
                }
                else
                {
                    while ((ch = string[stringPos++]))
                    {
                        setarg(paramPos, i++, ch);
                    }
                }
                stringPos--;
                setarg(paramPos, i, '\0');
            }
            default:
            {
                continue;
            }
        }
        while (string[stringPos] && string[stringPos] != delim && string[stringPos] > ' ')
        {
            stringPos++;
        }
        while (string[stringPos] && (string[stringPos] == delim || string[stringPos] <= ' '))
        {
            stringPos++;
        }
        paramPos++;
    }
    do
    {
        if ((delim = format[formatPos++]) > ' ')
        {
            if (delim == '\'')
            {
                while ((delim = format[formatPos++]) && delim != '\'') {}
            }
            else if (delim != 'z')
            {
                return delim;
            }
        }
    }
    while (delim > ' ');
    return 0;
}