Beiträge von Jenny_Dream


    COMMAND:duty(playerid,params[])//normales duty für sapd,San Andreas Rettungsdienst/feuewehr,fbi,army,ordnungsamt,san andreas news
    {
    #pragma unused params
    if(ImTutorial[playerid] != 0)return SendClientMessage(playerid,GRAU,"Du kannst keine Befehle nutzen,da du im Tutorial bist.");
    if(GetPVarInt(playerid,"Eingeloggt") == 0)return SendClientMessage(playerid,GRAU,"Du bist nicht eingeloggt!");
    if(Spieler[playerid][pAWAYFROMKEYBOARD] == 1)return SendClientMessage(playerid,WRONGCMD,"Du bist im AFK-Modus und kannst somit keine Befehle nutzen."),SendClientMessage(playerid,WRONGCMD,"BENUTZE: /back");
    if(Spieler[playerid][pInPrison] == 1)return SendClientMessage(playerid,GRAU,"Du bist im Prison.");
    if(Spieler[playerid][pFriedhof] == 1)return SendClientMessage(playerid,GRAU,"Du bist Tot.");
    if(Spieler[playerid][pDeath] == 1)return SendClientMessage(playerid,GRAU,"Du bist verletzt.");
    if(Spieler[playerid][pJailed] != 0)return SendClientMessage(playerid,GRAU,"Du bist im Gefängnis.");
    if(Spieler[playerid][pTazerd] == 1)return SendClientMessage(playerid,GRAU,"Du bist K.O/getazert.");
    if(Spieler[playerid][pCuffed] == 1)return SendClientMessage(playerid,GRAU,"Du bist gefesselt.");
    new string[128];
    if(isPlayerInFrakt(playerid,1) || isPlayerInFrakt(playerid,2) || isPlayerInFrakt(playerid,3) || isPlayerInFrakt(playerid,6) || isPlayerInFrakt(playerid,10) || isPlayerInFrakt(playerid,11) || isPlayerInFrakt(playerid,14) || isPlayerInFrakt(playerid,15))
    {
    if(!IsPlayerAtDUTY(playerid))return SendClientMessage(playerid,GRAU,"Du kannst hier nicht in/aus den Dienst gehen.");
    if(Spieler[playerid][pDuty] > 1)return SendClientMessage(playerid,GRAU,"Du musst erst Offduty sein.");
    if(Spieler[playerid][pDuty] == 0)
    {
    if(isPlayerInFrakt(playerid,1))
    {
    SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);
    SetPlayerColor(playerid,SAPDDUTY);
    SendClientMessage(playerid,SORBLAU,"Du bist nun im Dienst.");
    Spieler[playerid][pDuty] = 1;
    format(string,sizeof(string),"** %s zieht seine Dienstkleidung an und geht in den Dienst **",SpielerName(playerid));
    PlayerTalkPublic(playerid,MEFARBE,string,10);
    SendClientMessage(playerid,GELB,"Info: Der Staat übernimmt den Preis für das waschen deiner Kleidung. ( 50$ pro Kleidungswechsel. )");
    fverwaltungen[16][Geld] -= 50;
    }
    if(isPlayerInFrakt(playerid,2))
    {
    SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);
    SetPlayerColor(playerid,FBIDUTY);
    SendClientMessage(playerid,SORBLAU,"Du bist nun im Dienst.");
    Spieler[playerid][pDuty] = 1;
    format(string,sizeof(string),"** %s zieht seine Dienstkleidung an und geht in den Dienst **",SpielerName(playerid));
    PlayerTalkPublic(playerid,MEFARBE,string,10);
    SendClientMessage(playerid,GELB,"Info: Der Staat übernimmt den Preis für das waschen deiner Kleidung. ( 50$ pro Kleidungswechsel. )");
    fverwaltungen[16][Geld] -= 50;
    }
    if(isPlayerInFrakt(playerid,3))
    {
    Spieler[playerid][pFunkgeraet] = 1;
    SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);
    SetPlayerColor(playerid,MEDICDUTY);
    SendClientMessage(playerid,SORBLAU,"Du bist nun im Dienst.");
    ResetWeapons(playerid,false);
    Spieler[playerid][pDuty] = 1;
    format(string,sizeof(string),"** %s zieht seine Dienstkleidung an und geht in den Dienst **",SpielerName(playerid));
    PlayerTalkPublic(playerid,MEFARBE,string,10);
    SendClientMessage(playerid,GELB,"Info: Der Staat übernimmt den Preis für das waschen deiner Kleidung. ( 50$ pro Kleidungswechsel. )");
    fverwaltungen[16][Geld] -= 50;
    }
    if(isPlayerInFrakt(playerid,6))
    {
    SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);
    SetPlayerColor(playerid,ARMYDUTY);
    SendClientMessage(playerid,SORBLAU,"Du bist nun im Dienst.");
    Spieler[playerid][pDuty] = 1;
    format(string,sizeof(string),"** %s zieht seine Dienstkleidung an und geht in den Dienst **",SpielerName(playerid));
    PlayerTalkPublic(playerid,MEFARBE,string,10);
    SendClientMessage(playerid,GELB,"Info: Der Staat übernimmt den Preis für das waschen deiner Kleidung. ( 50$ pro Kleidungswechsel. )");
    fverwaltungen[16][Geld] -= 50;
    }
    if(isPlayerInFrakt(playerid,10))
    {
    SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);
    SetPlayerColor(playerid,SANEWSAGDUTY);
    SendClientMessage(playerid,SORBLAU,"Du bist nun im Dienst.");
    Spieler[playerid][pDuty] = 1;
    ResetWeapons(playerid,false);
    format(string,sizeof(string),"** %s zieht seine Dienstkleidung an und geht in den Dienst **",SpielerName(playerid));
    PlayerTalkPublic(playerid,MEFARBE,string,10);
    }
    if(isPlayerInFrakt(playerid,11))
    {
    Spieler[playerid][pFunkgeraet] = 1;
    SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);
    SetPlayerColor(playerid,OAMTDUTY);
    SendClientMessage(playerid,SORBLAU,"Du bist nun im Dienst.");
    Spieler[playerid][pDuty] = 1;
    ResetWeapons(playerid,false);
    GiveWeapon(playerid,41,500,false);
    GiveWeapon(playerid,3,1,false);
    format(string,sizeof(string),"** %s zieht seine Dienstkleidung an und geht in den Dienst **",SpielerName(playerid));
    PlayerTalkPublic(playerid,MEFARBE,string,10);
    SendClientMessage(playerid,GELB,"Info: Der Staat übernimmt den Preis für das waschen deiner Kleidung. ( 50$ pro Kleidungswechsel. )");
    SendClientMessage(playerid,GELB,"Mit dem Pfefferspray kannst du Spraytags von Gangs/Mafien entfernen,indem du diese eine Zeit lang ansprühst.");
    fverwaltungen[16][Geld] -= 50;
    }
    if(isPlayerInFrakt(playerid,14))
    {
    SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);
    format(string,sizeof(string),"** Fahrlehrer %s ist nun im Dienst (/fahrlehrer) **",SpielerName(playerid));
    SendClientMessageToAll(FAHRSCHULEDUTY,string);
    SetPlayerColor(playerid,FAHRSCHULEDUTY);
    SendClientMessage(playerid,SORBLAU,"Du bist nun im Dienst.");
    ResetWeapons(playerid,false);
    GiveWeapon(playerid,41,500,false);
    Spieler[playerid][pDuty] = 1;
    format(string,sizeof(string),"** %s zieht seine Dienstkleidung an und geht in den Dienst **",SpielerName(playerid));
    PlayerTalkPublic(playerid,MEFARBE,string,10);
    fSCHULleher[playerid] = Create3DTextLabel("Fahrlehrer",FAHRSCHULEDUTY,30.0,40.0,50.0,MAX_STREAM_NAME_DISTANCE,0,1);
    Attach3DTextLabelToPlayer(fSCHULleher[playerid],playerid,0.0,0.0,0.4);
    }
    if(isPlayerInFrakt(playerid,15))
    {
    SetPlayerSkin(playerid,Spieler[playerid][pFraktSkin]);
    SetPlayerColor(playerid,SAELEKTRONIKGmBhDUTY);
    SendClientMessage(playerid,SORBLAU,"Du bist nun im Dienst.");
    Spieler[playerid][pDuty] = 1;
    ResetWeapons(playerid,false);
    format(string,sizeof(string),"** %s zieht seine Dienstkleidung an und geht in den Dienst **",SpielerName(playerid));
    PlayerTalkPublic(playerid,MEFARBE,string,10);
    }
    return 1;
    }
    else if(Spieler[playerid][pDuty] == 1)
    {
    if(isPlayerInFrakt(playerid,14))
    {
    format(string,sizeof(string),"** Fahrlehrer %s ist nun nicht mehr im Dienst **",SpielerName(playerid));
    SendClientMessageToAll(FAHRSCHULEDUTY,string);
    Delete3DTextLabel(fSCHULleher[playerid]);
    }
    ResetWeapons(playerid,false);
    for(new slot=0;slot<13;slot++)
    {
    if(Spieler[playerid][pPlayerWeapon][slot] != 0 && Spieler[playerid][pPlayerWeaponAmmo][slot] != 0)
    {
    GiveWeapon(playerid,Spieler[playerid][pPlayerWeapon][slot],Spieler[playerid][pPlayerWeaponAmmo][slot],false);
    }
    }
    Spieler[playerid][pTazer] = 0;
    Spieler[playerid][pTazerAkku] = 0;
    Spieler[playerid][pTazerInorOutbag] = 0;
    KillTimer(Spieler[playerid][pTazerTimer]);
    Spieler[playerid][pTazerAkku] = 0;
    Spieler[playerid][pTazerInorOutbag] = 0;
    Spieler[playerid][pOrtungsgeraet] = 0;
    Spieler[playerid][pFunkgeraet] = 0;
    Spieler[playerid][pMegaphon] = 0;
    Spieler[playerid][pArmouredbyASchild] = 0;
    SetPlayerColor(playerid,WEISS);
    RemovePlayerAttachedObject(playerid,4);
    SetPlayerSkin(playerid,Spieler[playerid][pSkin]);
    format(string,sizeof(string),"** %s zieht seine Dienstkleidung aus und geht aus dem Dienst **",SpielerName(playerid));
    PlayerTalkPublic(playerid,MEFARBE,string,10);
    Spieler[playerid][pDuty] = 0;
    return 1;
    }
    }
    return SendClientMessage(playerid,GRAU,"Du bist nicht in der jeweiligen Fraktion.");
    }

    • cache_get_field_content(fvr,"Geld",result);


    [10:50:59] [debug] Run time error 4: "Array index out of bounds"
    [10:50:59] [debug] Accessing element at index 10 past array upper bound 9
    [10:50:59] [debug] AMX backtrace:
    [10:50:59] [debug] #0 00639340 in public LoadAccountBlacklists (playerid=14) at C:\Users\Server\Desktop\Server\Server\Server\gamemodes\GeTmyselfmade.pwn:74040
    [10:53:24] [debug] Run time error 4: "Array index out of bounds"
    [10:53:24] [debug] Accessing element at negative index -400
    [10:53:24] [debug] AMX backtrace:
    [10:53:24] [debug] #0 0050cb78 in public Tachometer (playerid=14) at C:\Users\Server\Desktop\Server\Server\Server\gamemodes\GeTmyselfmade.pwn:56515




    //EDIT
    Hab jetzt soweit alles behoben.
    Man bekommt nur noch Verbindungsabbrüche!
    Aber sonst geht alles.

    Ja poste ich gleich außerdem hab ich noch das Problem das der Server nach ner Zeit crasht.
    Die letzten Zeilen vorm crash:
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.223 milliseconds
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.204 milliseconds
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.768 milliseconds
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.197 milliseconds
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.221 milliseconds
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.322 milliseconds
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.257 milliseconds
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.192 milliseconds
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.718 milliseconds
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - starting query execution
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.683 milliseconds
    [17:29:43] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

    case _SQL_FVERWALTUNG_LOAD:
    {
    cache_get_data(rows,fields);
    new fvr = 0;
    if(rows)
    {
    while(fvr<rows)
    {
    cache_get_field_content(fvr,"Geld",result);
    fverwaltungen[fvr][Geld] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"Opium",result);
    fverwaltungen[fvr][Opium] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"Ganja",result);
    fverwaltungen[fvr][Ganja] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"Kokain",result);
    fverwaltungen[fvr][Kokain] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"C4",result);
    fverwaltungen[fvr][C4] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"Materials",result);
    fverwaltungen[fvr][Materials] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"WaffenPack",result);
    fverwaltungen[fvr][WaffenPack] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"WaffenSlots",result);
    fverwaltungen[fvr][WaffenSlots] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"Heal",result);
    fverwaltungen[fvr][Heal] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"HealSlots",result);
    fverwaltungen[fvr][HealSlots] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"Armour",result);
    fverwaltungen[fvr][Armour] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"ArmourSlots",result);
    fverwaltungen[fvr][ArmourSlots] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"HaveVBInvite",result);
    fverwaltungen[fvr][HaveVBInvite] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"VBFraktion",result);
    fverwaltungen[fvr][VBFraktion] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"F0",result);
    format(frank0[fvr],32,"%s",result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"F1",result);
    format(frank1[fvr],32,"%s",result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"F2",result);
    format(frank2[fvr],32,"%s",result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"F3",result);
    format(frank3[fvr],32,"%s",result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"F4",result);
    format(frank4[fvr],32,"%s",result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"F5",result);
    format(frank5[fvr],32,"%s",result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"F6",result);
    format(frank6[fvr],32,"%s",result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"GFFID",result);
    fverwaltungen[fvr][GangFightfID] = strval(result);
    strdel(result,0,sizeof(result));
    cache_get_field_content(fvr,"GFOWNER",result);
    fverwaltungen[fvr][GangFightOwner] = strval(result);
    cache_get_field_content(fvr,"GSKILLS",result);
    strdel(result,0,sizeof(result));
    fverwaltungen[fvr][GangFightKills] = strval(result);
    cache_get_field_content(fvr,"GFDEATHS",result);
    strdel(result,0,sizeof(result));
    fverwaltungen[fvr][GangFightDeaths] = strval(result);
    fvr++;
    }
    }
    printf("- Fraktionsvewaltungen geladen %i/%i -",rows,MAX_FRAKTIONNEN);
    return 1;
    }

    [09:54:31] [debug] Run time error 4: "Array index out of bounds"
    [09:54:31] [debug] Accessing element at index 18 past array upper bound 17
    [09:54:31] [debug] AMX backtrace:
    [09:54:31] [debug] #0 0064b7a0 in public OnQueryFinish (index[]=@0153e760 "SELECT * FROM prp_fraktion_verwaltung", sqlresultid=14, extraid=0, SconnectionHandle=1) at C:\Users\Server\Desktop\Server\Server\Server\gamemodes\GeTmyselfmade.pwn:74975

    Server crasht dauernt!



    [21:04:00] Number of vehicle models: 87
    [21:04:00] - Gangzonen geladen 14/14 -
    [21:04:00] - Blitzer geladen 0/50 -
    [21:04:00] - Minen geladen 0/20 -
    [21:04:00] - XmasObject geladen 0/100 -
    [21:04:00] - Drogenpflanzen geladen 0/50 -
    [21:04:00] - Funkmasten geladen 0/20 -
    [21:04:00] - Werbetafeln geladen 22/22 -
    [21:04:00] - Rennen geladen 0/20 -
    [21:04:00] - Schwarzmärkte geladen 0/20 -
    [21:04:00] - Stuff wurde geladen -
    [21:04:00] [connection] 127.0.0.1:63030 requests connection cookie.
    [21:04:00] [connection] 127.0.0.1:63031 requests connection cookie.
    [21:04:00] [debug] Run time error 4: "Array index out of bounds"
    [21:04:00] [debug] Accessing element at index 18 past array upper bound 17
    [21:04:00] [debug] AMX backtrace:
    [21:04:00] [debug] #0 0064b7a0 in public OnQueryFinish (0x0153e760, 0x0000000e, 0x00000000, 0x00000001) from GeTmyselfmade.amx
    [21:04:00] - Häuser geladen 0/300 -
    [21:04:00] - Aktivität der Hausbesitzer kontrolliert -
    [21:04:00] - Fraktionsfahrzeuge geladen 0/400 -
    [21:04:00] - Businesse geladen 0/100 -
    [21:04:00] - Aktivität der Businessbesitzer kontrolliert -
    [21:04:00] - Organisationen geladen 0/10 -



    Kann mir jemand sagen was das bedeuten soll?

    Jetzt kommt nach ner Zeit you are banned!


    [19:17:13] Passing query SELECT * FROM prp_account_main WHERE | siii
    [19:17:13] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()