Beiträge von firestormZ

    Teste das mal, ist bisschen aufgeräumt, kann sein das was mit den <= < >= etc nicht stimmt, schrieb dann einfach ne pn :)



    if (strcmp(cmd, "/buygun", true) == 0)
    {
    new gun,gunid[16],gunstring1[256],gunstring2[256],gunstring3[256],gunstring4[256],gunstring5[256],infostring[256],guncharge,ammocharge,local = PlayerInfo[playerid][pLocal];
    if(IsPlayerConnected(playerid)) return SendClientMessage(playerid, COLOR_RED, "Du bist nicht online!");
    if(!IsPlayerInRangeOfPoint(playerid,3.0,290.2523,-106.7863,1001.5156)||
    !IsPlayerInRangeOfPoint(playerid,3.0,295.4237,-38.1667,1001.5156)) return SendClientMessage(playerid, COLOR_WHITE,"Du bist in keinem Laden.");
    //IsPlayerInRangeOfPoint(playerid,10.0,295.1371,-80.8117,1001.5156))
    if(PlayerInfo[playerid][pLevel] <= 5) return SendClientMessage(playerid, COLOR_RED, "Du musst mindestens Level 5 sein um hier einzukaufen");
    if(GetPlayerMoney(playerid) < 1) return SendClientMessage(playerid, COLOR_RED, "Du hat nicht genug Geld dabei.");
    if(PlayerInfo[playerid][pGunLic] != 0) return SendClientMessage(playerid, COLOR_RED, "Du hast kein Waffenschein !");
    if(GetPlayerInterior(playerid) == 1||GetPlayerInterior(playerid) == 6) return 1;
    //PlayerInfo[playerid][pLocal] == 101 || PlayerInfo[playerid][pLocal] == 102 || PlayerInfo[playerid][pLocal] == 103)
    //if(BizzInfo[location-99][bProducts] <= 0) return GameTextForPlayer(playerid, "~r~Ausverkauft", 5000, 1);
    new modsss = 200;
    tmp = strtok(cmdtext, idx);
    if(!strlen(tmp))
    {
    format(string, sizeof(string), "Benutze: /buygun [waffenname] [munition]");
    SendClientMessage(playerid, COLOR_GREEN,"_______________________________________");
    SendClientMessage(playerid, COLOR_WHITE,"*** Waffen & Munition ***");
    SendClientMessage(playerid, COLOR_GRAD2,string);
    format(gunstring1, 256, "Waffen: Fallschirm ($%d) Golfschläger ($%d) Schlagstock ($%d) Baseballschläger ($%d) Schaufel ($%d) PoolCue ($%d)",
    GunPrice[0][0]/100*modsss,GunPrice[1][0]/100*modsss,GunPrice[2][0]/100*modsss,GunPrice[3][0]/100*modsss,GunPrice[4][0]/100*modsss,GunPrice[5][0]/100*modsss,GunPrice[6][0]/100*modsss);
    SendClientMessage(playerid, COLOR_GRAD3, gunstring1);
    format(gunstring2, 256, "Waffen: VioletterDildo ($%d) WeißerDildo ($%d) LangerweißerDildo ($%d) WeißerDildo2 ($%d) Blumen ($%d) cane",
    GunPrice[7][0]/100*modsss,GunPrice[8][0]/100*modsss,GunPrice[9][0]/100*modsss,GunPrice[10][0]/100*modsss,GunPrice[11][0]/100*modsss,GunPrice[12][0]/100*modsss);
    SendClientMessage(playerid, COLOR_GRAD3, gunstring2);
    format(gunstring3, 256, "Waffen: SD-Pistole ($%d) DesertEagle ($%d) MP5 ($%d)",
    GunPrice[13][0]/100*modsss,GunPrice[14][0]/100*modsss,GunPrice[15][0]/100*modsss,GunPrice[16][0]/100*modsss,GunPrice[17][0]/100*modsss,GunPrice[18][0]/100*modsss);
    SendClientMessage(playerid, COLOR_GRAD3, gunstring3);
    format(gunstring4, 256, "Waffen: Shotgun ($%d) AK47 ($%d) M4 ($%d) Sniper ($%d)",
    GunPrice[19][0]/100*modsss,GunPrice[20][0]/100*modsss,GunPrice[21][0]/100*modsss,GunPrice[22][0]/100*modsss,GunPrice[23][0]/100*modsss,GunPrice[24][0]/100*modsss);
    SendClientMessage(playerid, COLOR_GRAD3, gunstring4);
    format(gunstring5, 256, "Waffen: Pistolen Munition ($%d) Shotgun Munition ($%d) MP5 Munition ($%d) AK47/M4 Munition ($%d) Sniper Munition ($%d)",
    GunPrice[25][0],GunPrice[26][0],GunPrice[27][0],GunPrice[28][0],GunPrice[29][0]);
    SendClientMessage(playerid, COLOR_GRAD3, gunstring5);
    SendClientMessage(playerid, COLOR_GREEN,"_______________________________________");
    return 1;
    }
    strmid(gunid, tmp, 0, strlen(cmdtext), 255);
    tmp = strtok(cmdtext, idx);
    if(strlen(tmp)) return format(string, sizeof(string), "Benutze: /buygun [Waffe] [Munition]");
    new ammo = strval(tmp);
    if(ammo < 1 || ammo > 999) { SendClientMessage(playerid, COLOR_RED, " Die Munition muss zwischen 1 und 999 sein !"); return 1; }
    if (strcmp(gunid, "Fallschirm", true, strlen(gunid)) == 0)
    {
    gun = 46;
    guncharge = GunPrice[0][0]/100*modsss;
    ammocharge = 0;
    }
    else if (strcmp(gunid, "Golfschläger", true, strlen(gunid)) == 0)
    {
    gun = 2; guncharge = GunPrice[1][0]/100*modsss; ammocharge = 0;
    PlayerInfo[playerid][pGun1] = 2; PlayerInfo[playerid][pAmmo1] = 1;
    }
    else if (strcmp(gunid, "Schlagstock", true, strlen(gunid)) == 0)
    {
    gun = 3; guncharge = GunPrice[2][0]/100*modsss; ammocharge = 0;
    PlayerInfo[playerid][pGun1] = 3; PlayerInfo[playerid][pAmmo1] = 1;
    }
    else if (strcmp(gunid, "Baseballschläger", true, strlen(gunid)) == 0)
    {
    gun = 5; guncharge = GunPrice[4][0]/100*modsss; ammocharge = 0;
    PlayerInfo[playerid][pGun1] = 5; PlayerInfo[playerid][pAmmo1] = 1;
    }
    else if (strcmp(gunid, "Schaufel", true, strlen(gunid)) == 0)
    {
    gun = 6; guncharge = GunPrice[5][0]/100*modsss; ammocharge = 0;
    PlayerInfo[playerid][pGun1] = 6; PlayerInfo[playerid][pAmmo1] = 1;
    }
    else if (strcmp(gunid, "poolcue", true, strlen(gunid)) == 0)
    {
    gun = 7; guncharge = GunPrice[6][0]/100*modsss; ammocharge = 0;
    PlayerInfo[playerid][pGun1] = 7; PlayerInfo[playerid][pAmmo1] = 1;
    }
    else if (strcmp(gunid, "VioletterDildo", true, strlen(gunid)) == 0)
    {
    gun = 10; guncharge = GunPrice[7][0]/100*modsss; ammocharge = 0;
    PlayerInfo[playerid][pGun1] = 10; PlayerInfo[playerid][pAmmo1] = 1;
    }
    else if (strcmp(gunid, "Weißerdildo", true, strlen(gunid)) == 0)
    {
    gun = 11; guncharge = GunPrice[8][0]/100*modsss; ammocharge = 0;
    PlayerInfo[playerid][pGun1] = 11; PlayerInfo[playerid][pAmmo1] = 1;
    }
    else if (strcmp(gunid, "langerweißerdildo", true, strlen(gunid)) == 0)
    {
    gun = 12; guncharge = GunPrice[9][0]/100*modsss; ammocharge = 0;
    PlayerInfo[playerid][pGun1] = 12; PlayerInfo[playerid][pAmmo1] = 1;
    }
    else if (strcmp(gunid, "weißerdildo2", true, strlen(gunid)) == 0)
    {
    gun = 13; guncharge = GunPrice[10][0]/100*modsss; ammocharge = 0;
    PlayerInfo[playerid][pGun1] = 13; PlayerInfo[playerid][pAmmo1] = 1;
    }
    else if (strcmp(gunid, "Blumen", true, strlen(gunid)) == 0)
    {
    gun = 14; guncharge = GunPrice[11][0]/100*modsss; ammocharge = 0;
    PlayerInfo[playerid][pGun1] = 14; PlayerInfo[playerid][pAmmo1] = 1;
    }
    else if (strcmp(gunid, "cane", true, strlen(gunid)) == 0)
    {
    gun = 15; guncharge = GunPrice[12][0]/100*modsss; ammocharge = 0;
    PlayerInfo[playerid][pGun1] = 15; PlayerInfo[playerid][pAmmo1] = 1;
    }
    else if (strcmp(gunid, "SD-Pistole", true, strlen(gunid)) == 0)
    {
    gun = 23; guncharge = GunPrice[13][0]/100*modsss; ammocharge = GunPrice[25][0]*ammo;
    PlayerInfo[playerid][pGun2] = 23; PlayerInfo[playerid][pAmmo2] = ammo;
    }
    else if (strcmp(gunid, "DesertEagle", true, strlen(gunid)) == 0)
    {
    gun = 24; guncharge = GunPrice[15][0]/100*modsss; ammocharge = GunPrice[25][0]*ammo;
    PlayerInfo[playerid][pGun2] = 24; PlayerInfo[playerid][pAmmo2] = ammo;
    }
    else if (strcmp(gunid, "MP5", true, strlen(gunid)) == 0)
    {
    gun = 29; guncharge = GunPrice[18][0]/100*modsss; ammocharge = GunPrice[27][0]*ammo;
    PlayerInfo[playerid][pGun3] = 29; PlayerInfo[playerid][pAmmo3] = ammo;
    }
    else if (strcmp(gunid, "Shotgun", true, strlen(gunid)) == 0)
    {
    gun = 25; guncharge = GunPrice[19][0]/100*modsss; ammocharge = GunPrice[26][0]*ammo;
    PlayerInfo[playerid][pGun3] = 25; PlayerInfo[playerid][pAmmo3] = ammo;
    }
    else if (strcmp(gunid, "AK47", true, strlen(gunid)) == 0)
    {
    gun = 30; guncharge = GunPrice[22][0]/100*modsss; ammocharge = GunPrice[28][0]*ammo;
    PlayerInfo[playerid][pGun4] = 30; PlayerInfo[playerid][pAmmo4] = ammo;
    }
    else if (strcmp(gunid, "M4", true, strlen(gunid)) == 0)
    {
    gun = 31; guncharge = GunPrice[23][0]/100*modsss; ammocharge = GunPrice[28][0]*ammo;
    PlayerInfo[playerid][pGun4] = 31; PlayerInfo[playerid][pAmmo4] = ammo;
    }
    else if (strcmp(gunid, "Sniper", true, strlen(gunid)) == 0)
    {
    gun = 34; guncharge = GunPrice[24][0]/100*modsss; ammocharge = GunPrice[29][0]*ammo;
    PlayerInfo[playerid][pGun4] = 34; PlayerInfo[playerid][pAmmo4] = ammo;
    }
    else SendClientMessage(playerid, COLOR_GRAD6, "Ladenbesitzer: Ich habe noch nie von dieser Waffe gehört.");
    if((guncharge+ammocharge) > GetPlayerMoney(playerid))
    {
    format(infostring, 256, " Du hast keine $%d !",guncharge+ammocharge);
    SendClientMessage(playerid, COLOR_GRAD3, infostring);
    return 1;
    }
    if(GetPlayerMoney(playerid) < (guncharge+ammocharge)) return SendClientMessage(playerid, COLOR_RED, "Geht nicht !");
    new payout = guncharge + ammocharge;
    format(infostring, 256, "Du hast eine %s mit %d Munition für $%d erworben",gunid,ammo,payout);
    SendClientMessage(playerid, COLOR_GRAD3, infostring);
    GivePlayerMoney(playerid, -payout);
    BizzInfo[local-99][bTill] += payout/3;
    ExtortionBiz(local-99, payout);
    BizzInfo[local-99][bProducts]--;
    PlayerPlaySound(playerid, 1052, 0.0, 0.0, 0.0);
    GivePlayerWeapon(playerid, gun, ammo);
    GetPlayerName(playerid, sendername, sizeof(sendername));
    format(string, sizeof(string), "%s hat Waffen für $%d eingekauft im BIZ: %d", sendername, payout, local-99);
    printf("%s", string);
    PayLog(string);
    return 1;
    }

    so, er speichert nichts mehr, selbst den namen nicht.er lädt es aber, da wenn ich von hand in der datenbank nen wert eintrage und mein namen etc. geht alles.
    kann mal einer drüber schuen?

    stock Register(playerid,key[])
    {
    new query[1024];
    SendClientMessage(playerid,BLAU,"Erfolgreich registriert.");
    SetPlayerSkin(playerid,79);
    SetPVarInt(playerid,"Skin",79);
    SetPlayerScore(playerid,0);
    GivePlayerMoney(playerid,30000);
    SetPVarInt(playerid,"loggedin",1);
    format(query,sizeof(query),"INSERT INTO `Accounts` (`Name`,`Passwort`,`Geld`,`Rang`,`Banned`,`Handy`,`Skin`,`KaempferSkin`,`Jail`,`JailTime`,`Chef`,`GangChef`,`Hoehenmessgeraet`,`Job`,`Gang`,`TimeOut`,`Leben`,`Ruestung`,`Wanted`,`FightStyle`,`TimeOutInteriorID`,`TimeOutWorldID`,`TimeOutPosX`,`TimeOutPosY`,`TimeOutPosZ`,`TimeOutPosA`) VALUES ('%s','%s','%d','0','0','0','0','0','0','0','0','0','0','0','0','0','100.0000','100.0000','0','0','0','0','0.0000','0.0000','0.0000','0.0000')",
    SpielerName(playerid),key,GetPlayerMoney(playerid));
    db_query(Accounts,query);
    return 1;
    }


    stock Login(playerid,key[])
    {
    new query[128];
    format(query, sizeof(query), "SELECT * FROM `Accounts` WHERE `Name` = '%s' AND `Passwort` = '%s'",SpielerName(playerid),key);
    new DBResult:Result = db_query(Accounts, query);
    if(db_num_rows(Result)!=0)
    {
    LoadAccount(playerid);
    SendClientMessage(playerid,BLAU,"Erfolgreich eingeloggt!");
    }
    else
    {
    SendClientMessage(playerid,BLAU,"Falsches Passwort!");
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Bitte gebe dein Passwort ein!","Login","Abbrechen");
    }
    db_free_result(Result);
    return 1;
    }


    stock LoadAccount(playerid)
    {
    new DBResult:Result, query[128];
    format(query, sizeof(query), "SELECT * FROM `Accounts` WHERE `Name` = '%s'",SpielerName(playerid));
    Result = db_query(Accounts,query);
    if(db_num_rows(Result) > 0)
    {
    db_get_field_assoc(Result,"Geld",query,sizeof(query));
    GivePlayerMoney(playerid,strval(query));
    db_get_field_assoc(Result,"Rang",query,sizeof(query));
    SetPVarInt(playerid,"Rang",strval(query));
    db_get_field_assoc(Result,"Banned",query,sizeof(query));
    SetPVarInt(playerid,"Banned",strval(query));
    db_get_field_assoc(Result,"Handy",query,sizeof(query));
    SetPVarInt(playerid,"Handy",strval(query));
    db_get_field_assoc(Result,"Skin",query,sizeof(query));
    SetPVarInt(playerid,"Skin",strval(query));
    db_get_field_assoc(Result,"Kaempferskin",query,sizeof(query));
    SetPVarInt(playerid,"Kämpferskin",strval(query));
    db_get_field_assoc(Result,"Jail",query,sizeof(query));
    SetPVarInt(playerid,"Jail",strval(query));
    db_get_field_assoc(Result,"JailTime",query,sizeof(query));
    SetPVarInt(playerid,"JailTime",strval(query));
    db_get_field_assoc(Result,"Chef",query,sizeof(query));
    SetPVarInt(playerid,"Chef",strval(query));
    db_get_field_assoc(Result,"GangChef",query,sizeof(query));
    SetPVarInt(playerid,"GangChef",strval(query));
    db_get_field_assoc(Result,"Hoehenmessgeraet",query,sizeof(query));
    SetPVarInt(playerid,"Höhenmessgerät",strval(query));
    db_get_field_assoc(Result,"Job",query,sizeof(query));
    SetPVarInt(playerid,"Job",strval(query));
    db_get_field_assoc(Result,"Gang",query,sizeof(query));
    SetPVarInt(playerid,"Gang",strval(query));
    db_get_field_assoc(Result,"TimeOut",query,sizeof(query));
    SetPVarInt(playerid,"TimeOut",strval(query));
    db_get_field_assoc(Result,"Leben",query,sizeof(query));
    SetPlayerHealth(playerid, floatstr(query));
    db_get_field_assoc(Result,"Ruestung",query,sizeof(query));
    SetPlayerArmour(playerid, floatstr(query));
    db_get_field_assoc(Result,"Wanted",query,sizeof(query));
    SetPlayerWantedLevel(playerid,strval(query));
    db_get_field_assoc(Result,"FightStyle",query,sizeof(query));
    SetPlayerFightingStyle(playerid,strval(query));
    db_get_field_assoc(Result,"TimeOutInteriorID",query,sizeof(query));
    SetPVarInt(playerid,"TimeOutInteriorID",strval(query));
    db_get_field_assoc(Result,"TimeOutWorldID",query,sizeof(query));
    SetPVarInt(playerid,"TimeOutWorldID",strval(query));
    db_get_field_assoc(Result,"TimeOutPosX",query,sizeof(query));
    SetPVarFloat(playerid,"TimeOutPosX",floatstr(query));
    db_get_field_assoc(Result,"TimeOutPosY",query,sizeof(query));
    SetPVarFloat(playerid,"TimeOutPosY",floatstr(query));
    db_get_field_assoc(Result,"TimeOutPosZ",query,sizeof(query));
    SetPVarFloat(playerid,"TimeOutPosZ",floatstr(query));
    db_get_field_assoc(Result,"TimeOutPosA",query,sizeof(query));
    SetPVarFloat(playerid,"TimeOutPosA",floatstr(query));
    }
    db_free_result(Result);
    return 1;
    }
    stock SpielerSpeichern(playerid)
    {
    if(GetPVarInt(playerid,"loggedin")!=1) return 1;
    new query[1024],Float:health, Float:ruestung;
    GetPlayerHealth(playerid,health);
    GetPlayerArmour(playerid,ruestung);
    format(query,sizeof(query), "UPDATE `Accounts` SET `Geld` = '%d', `Rang` = '%d', `Banned` = '%d',`Handy` = '%d', `Skin` = '%d', `Kaempferskin` = '%d', `Jail` = '%d',`JailTime` = '%d', `Chef` = '%d',`GangChef` = '%d',`Hoehenmessgeraet` = '%d',`Job` = '%d',`Gang` = '%d',`FightStyle` = '%d',`Wanted` = '%d',`Leben` = '%f',`Ruestung` = '%f',`TimeOutInteriorID` = '%d',`TimeOutWorldID` = '%d',`TimeOutPosX` = '%f',`TimeOutPosY` = '%f',`TimeOutPosZ` = '%f',`TimeOutPosA` = '%f' WHERE `NAME` = '%s'",
    GetPlayerMoney(playerid),GetPVarInt(playerid,"Rang"),GetPVarInt(playerid,"Banned"),GetPVarInt(playerid,"Handy"),GetPVarInt(playerid,"Skin"),GetPVarInt(playerid,"Kämpferskin"),GetPVarInt(playerid,"Jail"),GetPVarInt(playerid,"JailTime"),
    GetPVarInt(playerid,"Chef"),GetPVarInt(playerid,"GangChef"),GetPVarInt(playerid,"Höhenmessgerät"),GetPVarInt(playerid,"Job"),GetPVarInt(playerid,"Gang"),GetPVarInt(playerid,"TimeOut"),GetPlayerWantedLevel(playerid),health,ruestung,
    GetPlayerFightingStyle(playerid),GetPVarInt(playerid,"TimeOutInteriorID"),GetPVarInt(playerid,"TimeOutWorldID"),GetPVarFloat(playerid,"TimeOutPosX"),GetPVarFloat(playerid,"TimeOutPosY"),GetPVarFloat(playerid,"TimeOutPosZ"),GetPVarFloat(playerid,"TimeOutPosA"),SpielerName(playerid));
    db_query(Accounts,query);
    return 1;
    }


    stock LoadAccount(playerid)
    {
    new DBResult:Result, query[128]/*,waffe,ammox,form[32]*/;
    format(query, sizeof(query), "SELECT * FROM `Accounts` WHERE `Name` = '%s'",SpielerName(playerid));
    Result = db_query(Accounts,query);
    if(db_num_rows(Result) > 0)
    {
    db_get_field_assoc(Result,"Geld",query,sizeof(query));
    GivePlayerMoney(playerid,strval(query));
    db_get_field_assoc(Result,"Rang",query,sizeof(query));
    SetPVarInt(playerid,"Rang",strval(query));
    db_get_field_assoc(Result,"Banned",query,sizeof(query));
    SetPVarInt(playerid,"Banned",strval(query));
    db_get_field_assoc(Result,"Skin",query,sizeof(query));
    SetPVarInt(playerid,"Skin",strval(query));
    db_get_field_assoc(Result,"Kaempferskin",query,sizeof(query));
    SetPVarInt(playerid,"Kämpferskin",strval(query));
    db_get_field_assoc(Result,"Jail",query,sizeof(query));
    SetPVarInt(playerid,"Jail",strval(query));
    db_get_field_assoc(Result,"JailTime",query,sizeof(query));
    SetPVarInt(playerid,"JailTime",strval(query));
    db_get_field_assoc(Result,"Chef",query,sizeof(query));
    SetPVarInt(playerid,"Chef",strval(query));
    db_get_field_assoc(Result,"GangChef",query,sizeof(query));
    SetPVarInt(playerid,"GangChef",strval(query));
    db_get_field_assoc(Result,"Hoehenmessgeraet",query,sizeof(query));
    SetPVarInt(playerid,"Höhenmessgerät",strval(query));
    db_get_field_assoc(Result,"Job",query,sizeof(query));
    SetPVarInt(playerid,"Job",strval(query));
    db_get_field_assoc(Result,"Gang",query,sizeof(query));
    SetPVarInt(playerid,"Gang",strval(query));
    db_get_field_assoc(Result,"TimeOut",query,sizeof(query));
    SetPVarInt(playerid,"TimeOut",strval(query));
    db_get_field_assoc(Result,"Leben",query,sizeof(query));
    SetPlayerHealth(playerid, floatstr(query));
    db_get_field_assoc(Result,"Ruestung",query,sizeof(query));
    SetPlayerArmour(playerid, floatstr(query));
    db_get_field_assoc(Result,"Wanted",query,sizeof(query));
    SetPlayerWantedLevel(playerid,strval(query));
    db_get_field_assoc(Result,"FightStyle",query,sizeof(query));
    SetPlayerFightingStyle(playerid,strval(query));
    db_get_field_assoc(Result,"TimeOutInteriorID",query,sizeof(query));
    SetPVarInt(playerid,"TimeOutInteriorID",strval(query));
    db_get_field_assoc(Result,"TimeOutWorldID",query,sizeof(query));
    SetPVarInt(playerid,"TimeOutWorldID",strval(query));
    db_get_field_assoc(Result,"TimeOutPosX",query,sizeof(query));
    SetPVarFloat(playerid,"TimeOutPosX",floatstr(query));
    db_get_field_assoc(Result,"TimeOutPosY",query,sizeof(query));
    SetPVarFloat(playerid,"TimeOutPosY",floatstr(query));
    db_get_field_assoc(Result,"TimeOutPosZ",query,sizeof(query));
    SetPVarFloat(playerid,"TimeOutPosZ",floatstr(query));
    db_get_field_assoc(Result,"TimeOutPosA",query,sizeof(query));
    SetPVarFloat(playerid,"TimeOutPosA",floatstr(query));
    }
    db_free_result(Result);
    return 1;
    }


    PS: Danke schonmal für deine Hilfe

    Tag freunde, schreib grad mein script von dini auf sqllite um und brauch mal hilfe.
    er erkennt alles bei onplayerconnect, doch wenn diese funktion aufgerufen wird crasht der server:
    @BlackAce:
    habe dein Tutorial genutzt, soweit funzt auch alles, nur dort crasht halt der server..


    stock Login(playerid,key[])
    {
    new query[128];
    format(query, sizeof(query), "SELECT * FROM `Accounts` WHERE `Name` = '%s' AND `Passwort` = '%s'",SpielerName(playerid),key);
    new DBResult:Result = db_query(Accounts, query);
    if(db_num_rows(Result)==1)
    {
    LoadAccount(playerid);
    SendClientMessage(playerid,BLAU,"Erfolgreich eingeloggt!");
    }
    else if(db_num_rows(Result)==0)
    {
    SendClientMessage(playerid,BLAU,"Falsches Passwort!");
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Bitte gebe dein Passwort ein!","Login","Abbrechen");
    }
    db_free_result(Result);
    return 1;
    }


    //unter deinen Includes
    new CD=8, CDTimer[MAX_PLAYERS];
    forward CountDown(playerid);
    //außerhalb eines publics im script
    public CountDown(playerid)
    {
    CD--;
    new Float:Pos[3], str[32];
    for(new i;i<MAX_PLAYERS;i++)
    {
    GetPlayerPos(i, Pos[0], Pos[1], Pos[2]);
    if(CD == 0)
    {
    if(IsPlayerInRangeOfPoint(playerid, 60, Pos[0], Pos[1], Pos[2]))
    {
    format(str, sizeof(str), "Count Down: %d", CD);
    GameTextForPlayer(i, str, 1000, 6);
    KillTimer(CDTimer[playerid]);
    CD = 8;
    }
    }
    else
    {
    if(IsPlayerInRangeOfPoint(playerid, 60, Pos[0], Pos[1], Pos[2]))
    {
    format(str, sizeof(str), "Count Down: %d", CD);
    GameTextForPlayer(i, str, 1000, 6);
    }
    }
    }
    return 1;
    }
    ocmd:cd(playerid) //Der Befehl zum starten des countdowns
    {
    CDTimer[playerid] = SetTimerEx("CountDown", 1000, true, "i", playerid);
    return 1;
    }

    if (PlayerToPoint(2.0,playerid,-224.4697,1411.0306,27.7734) || PlayerToPoint(2.0,playerid,1712.4611,-1640.0770,20.2239) || PlayerToPoint(2.0,playerid,1277.5029,-808.4862,1089.9375) || PlayerToPoint(2.0,playerid,2580.4900,2328.9592,17.8222) || PlayerToPoint(2.0,playerid, 1939.4677,982.8486,992.4688) || IsPlayerInRangeOfPoint(playerid, 5.0, 231.5756,1067.9391,1084.2061) || IsPlayerInRangeOfPoint(playerid, 3.0, 2819.4785,-1169.4138,1025.5703) || IsPlayerInRangeOfPoint(playerid, 3.0, -2642.2175,1419.0121,906.4609))
    ändern in:

    if(PlayerToPoint(2.0,playerid,-224.4697,1411.0306,27.7734) || PlayerToPoint(2.0,playerid,1712.4611,-1640.0770,20.2239) || PlayerToPoint(2.0,playerid,1277.5029,-808.4862,1089.9375)
    || PlayerToPoint(2.0,playerid,2580.4900,2328.9592,17.8222) || PlayerToPoint(2.0,playerid, 1939.4677,982.8486,992.4688) || IsPlayerInRangeOfPoint(playerid, 5.0, 231.5756,1067.9391,1084.2061)
    || IsPlayerInRangeOfPoint(playerid, 3.0, 2819.4785,-1169.4138,1025.5703) || IsPlayerInRangeOfPoint(playerid, 3.0, -2642.2175,1419.0121,906.4609))

    public OnPlayerDeath(playerid, killerid, reason)
    {
    if(isPlayerAnCop(killerid))
    {
    if(!havePlayerWanteds(playerid),1) return SendClientMessage(playerid,DROT,"Du bist gestorben. Du wirst nun an deinem Standart Spawnpunkt wiederbelebt.");
    SetPlayerPos(playerid,215.7065,109.8553,999.0156);
    SendClientMessage(playerid,ROT,"Da du von der Polizei gesucht wurdest und dich ein Polizist getötet hat, wanderst du in den Knast!");
    SetPlayerInterior(playerid,10);
    return 1;
    }
    return 1;

    }


    stock havePlayerWanteds(playerid,wanteds)
    {
    if(GetPVarInt(playerid,"Wanteds")>=wanteds)return 1;
    return 0;
    }

    Der Stock ist jetzt so, wenn der spieler über 1 wanted hat passiert der code :)