Beiträge von [DT]Nightstr3am

    Guten Tag Community,


    Ich habe grad ein kleines Problem mit dem Autohaus ich habe es auf MYsql umgeschrieben und jetzt werden aber irgendwie die Autos
    nicht erstellt.


    Hier der Code :



    //Oben im Script
    enum buycarinfo
    {
    carmid, //eigentlich modelid aber sonst gibt es min. 17 Warnings weil modelid so oft im SCript verwendet wird
    Preis,
    Float:XKoord,
    Float:YKoord,
    Float:ZKoord,
    Float:AKoord
    }
    #define MAX_BUYCAR 39
    new BuyCar[MAX_BUYCAR][buycarinfo]=
    {
    //==== LUXUS - GROTTI's ====///
    {411, 336799, 563.4000244,-1291.0000000,17.0000000,12.0000000},
    {402, 113500, 558.5996094,-1290.1992188,17.2000008,10.0000000},
    {415, 275000, 554.0000000,-1290.5000000,17.1000004,8.0000000},
    {429, 115000, 549.7999878,-1290.8000488,17.0000000,8.0000000},
    {451, 370999, 545.2000122,-1291.0000000,17.0000000,8.0000000},
    {506, 210500, 540.9000244,-1291.1999512,17.0000000,8.0000000},
    {541, 244000, 536.5999756,-1291.5000000,16.8999996,8.0000000},
    {562, 95000, 532.2999878,-1291.5999756,17.0000000,6.0000000},
    {587, 105799, 527.5996094,-1291.0996094,17.1000004,3.9990234},
    {560, 200000, 522.7000122,-1291.5000000,17.0000000,2.0000000},


    //==== BIKE COUT AND SCHUTzz ===//
    {461,25000, 2137.1999512,-1127.0999756,25.2999992,92.0000000},
    {462,1500, 2118.1000977,-1131.5000000,25.0000000,268.0000000},
    {463,45000, 2137.3999023,-1130.0999756,25.0000000,92.0000000},
    {468,11000, 2118.3999023,-1133.8000488,25.2000008,268.0000000},
    {471,21500, 2118.1999512,-1136.5999756,24.7999992,270.0000000},
    {521,35000, 2137.1000977,-1132.6999512,25.2999992,84.0000000},
    {522, 145000, 2136.8999023,-1135.5999756,25.3999996,86.0000000},
    {581,66000, 2137.0000000,-1138.1999512,25.2999992,80.0000000},
    {586, 45000, 2118.1000977,-1129.0000000,24.7999992,266.0000000},


    //=== NORMAL WANG_CARS ===//


    {603,34500, -1945.0999756,274.5000000,35.5000000,110.0000000},
    {474,24000, -1945.1999512,270.1000061,35.4000015,106.0000000},
    {496,4000,-1944.5999756,265.8999939,35.2999992,106.0000000},
    {535,14499, -1944.9000244,261.0000000,35.2999992,104.0000000},
    {567,29899, -1949.5000000,256.7999878,35.4000015,28.0000000},
    {426,27000, -1955.0999756,257.1000061,35.2999992,20.0000000},
    {551,19587, -1960.0999756,257.2999878,35.4000015,16.0000000},
    {409,1000000, -1955.6999512,303.8999939,41.0000000,180.0000000},
    {421,45500, -1944.9000244,274.8999939,41.0000000,105.9998779},
    {418,12000, -1945.0000000,270.3999939,41.2000008,108.0000000},
    {554,55000, -1945.5000000,266.2000122,41.2000008,110.0000000},
    {489,56000, -1944.9000244,261.5000000,41.4000015,102.0000000},
    {561,31000, -1956.5999756,257.0000000,41.0000000,0.0000000},
    {579,67000, -1952.5000000,257.5000000,41.0999985,0.0000000},
    {424,33699,-1953.5999756,304.6000061,35.2999992,142.0000000},


    //=== FLUGZEUG AUtOHAUS ====//
    {469,300500,1342.5000000,1292.8000488,10.8999996,0.0000000},
    {487,850000,1343.0000000,1305.5000000,11.1000004,0.0000000},
    {513,1200500,1281.5999756,1355.5999756,11.6000004,266.0000000},
    {519,2550350,1280.8000488,1324.6999512,11.8000002,270.0000000},
    {593,469000,1280.8000488,1366.9000244,11.3999996,274.0000000}


    };
    // Bei OnGameModeINit
    Connect_To_Database();
    for(new j = 0; j < sizeof BuyCar; j++)
    {
    kaufauto[j] = CreateVehicle(BuyCar[j][carmid],BuyCar[j][XKoord],BuyCar[j][YKoord],BuyCar[j][ZKoord],BuyCar[j][AKoord],1,1,-1);
    SetVehicleNumberPlate(kaufauto[j],"Autohaus");
    }
    SetTimer("BuyCarRespawn",180000,true);



    Ich hoffe ihr könnt mir irgendwie helfne

    traxx du bist ja nur Deko also seid wann kann "Deko" reden xD :D


    Tim, wo hast du den Server gehostet ? Vll stellt dir dieser zuwenig MB zu verfügung und/oder es wird ja auch angezeigt bei manchen Hostern ob man zuviele Ressourcen verbraucht

    Öhm ya, alles schön und gut gemappt aber sehr viele Befehle gehen nicht und ich komm nicht ausm hitman dings raus :S :D


    Sollte ein wenig übersichtlicher werden bzw wie gewohnt. Dazu haben paar Fraktionen keine Basen


    Ja da manche Fraktion ja auch rausgenommen wurden mach /fl und du siehst welche Fraktionen es ursprünglich gibt.


    Aus der Hitman Base kommst du glaube ich soweit ich mich erinnern kann mit /hlift raus..

    Guten Tag Community,


    ICh habe ein großes Problem mit Mysql xD . Vorhin wurde alles gespeichert ausser Geld Skin.


    Jetzt habe ich mal alles umgeschrieben von mysql_SetInt auf querys und jetzt wird zwar das Geld Skin gespeichert aber viele andere Sachen wie z.B Level nicht.


    Hier die stock SpielerSpeichern



    stock SpielerSpeichern(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    if(gPlayerLogged[playerid] == 1)
    {
    new query[2048];
    PlayerInfo[playerid][pCash] = GetPlayerMoney(playerid);

    format(query, sizeof(query), "UPDATE `accounts` SET Level = '%d',AdminLevel = '%d',Supporter = '%d',DonateRank = '%d',UpgradePoints = '%d',ConnectedTime = '%d',Registered = '%d',Sex = '%d',Alter = '%d',Origin = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pAdmin],PlayerInfo[playerid][pSupporter],PlayerInfo[playerid][pDonateRank],PlayerInfo[playerid][gPupgrade],
    PlayerInfo[playerid][pConnectTime],PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],PlayerInfo[playerid][pAge],PlayerInfo[playerid][pOrigin],PlayerInfo[playerid][pName]);
    mysql_query(query);

    format(query, sizeof(query), "UPDATE `accounts` SET CK = '%d',Muted = '%d',Respekt = '%d',Geld = '%d',Bank = '%d',Kredit = '%d',KreditDauer = '%d',Verbrechen = '%d',Kills = '%d',Deaths = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pCK],PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pCash],PlayerInfo[playerid][pAccount],
    PlayerInfo[playerid][pPlayerKredit],PlayerInfo[playerid][pPlayerKreditDauer],PlayerInfo[playerid][pCrimes],PlayerInfo[playerid][pKills],PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pName]);
    mysql_query(query);

    format(query, sizeof(query), "UPDATE `accounts` SET WantedDeaths = '%d',Telefonbuch = '%d',LottoNr = '%d',Fische = '%d',BiggestFish = '%d',Job = '%d',PayCheck = '%d',Jailed = '%d',GangJailed = '%d',Mauled = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pWantedDeaths],PlayerInfo[playerid][pPhoneBook],PlayerInfo[playerid][pLottoNr],PlayerInfo[playerid][pFishes],PlayerInfo[playerid][pBiggestFish],
    PlayerInfo[playerid][pJob],PlayerInfo[playerid][pPayCheck],PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pGangJailed],PlayerInfo[playerid][pMauled],PlayerInfo[playerid][pName]);
    mysql_query(query);

    format(query, sizeof(query), "UPDATE `accounts` SET JailTime = '%d',Material = '%d',Drogen = '%d',BMaterial = '%d',BDrogen = '%d',Leader = '%d',Member = '%d',FMember = '%d',Rank = '%d',Char = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pJailTime],PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrugs],PlayerInfo[playerid][pBoxMats],PlayerInfo[playerid][pBoxDrugs],
    PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],PlayerInfo[playerid][pFMember],PlayerInfo[playerid][pRank],PlayerInfo[playerid][pChar],PlayerInfo[playerid][pName]);
    mysql_query(query);

    format(query, sizeof(query), "UPDATE `accounts` SET ContractTime = '%d',Contract = '%d',DetSkill = '%d',LawSkill = '%d',PilotSkill = '%d',BusSkill = '%d',MechSkill = '%d',JackSkill = '%d',CarSkill = '%d',DrugsSkill = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pContractTime],PlayerInfo[playerid][pContract],PlayerInfo[playerid][pDetSkill],PlayerInfo[playerid][pLawSkill],PlayerInfo[playerid][pPilotSkill],
    PlayerInfo[playerid][pBusSkill],PlayerInfo[playerid][pMechSkill],PlayerInfo[playerid][pJackSkill],PlayerInfo[playerid][pCarSkill],PlayerInfo[playerid][pDrugsSkill],PlayerInfo[playerid][pName]);
    mysql_query(query);


    format(query, sizeof(query), "UPDATE `accounts` SET CookSkill = '%d',SHealth = '%d',Health = '%d',Interior = '%d',Local = '%d',Team = '%d',Model = '%d',pPNumber = '%d',House = '%d',Bizz = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pCookSkill],PlayerInfo[playerid][pSHealth],PlayerInfo[playerid][pHealth],PlayerInfo[playerid][pInt],PlayerInfo[playerid][pLocal],
    PlayerInfo[playerid][pTeam],PlayerInfo[playerid][pModel],PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pPbiskey],PlayerInfo[playerid][pName]);
    mysql_query(query);


    format(query, sizeof(query), "UPDATE `accounts` SET HandyGeld = '%d',HandyVer = '%d',pPos_x = '%d',pPos_y = '%d',pPos_z = '%d',CarLic = '%d',NewLic = '%d',FlyLic = '%d',BoatLic = '%d',FishLic = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pHandyGeld],PlayerInfo[playerid][pHandyVer],PlayerInfo[playerid][pPos_x],PlayerInfo[playerid][pPos_y],PlayerInfo[playerid][pPos_z],
    PlayerInfo[playerid][pCarLic],PlayerInfo[playerid][pNewLic],PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pName]);
    mysql_query(query);


    format(query, sizeof(query), "UPDATE `accounts` SET GunLic = '%d',LKWLic = '%d',RollerLic = '%d',MotoLic = '%d',Zig = '%d',Kekse = '%d',ZigSucht = '%d',CarTime = '%d',MullTime = '%d',PayDay = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pGunLic],PlayerInfo[playerid][pLKWLic],PlayerInfo[playerid][pRollerLic],PlayerInfo[playerid][pMotoLic],PlayerInfo[playerid][pZig],
    PlayerInfo[playerid][pKekse],PlayerInfo[playerid][pZigSucht],PlayerInfo[playerid][pCarTime],PlayerInfo[playerid][pMulltime],PlayerInfo[playerid][pPayDay],PlayerInfo[playerid][pName]);
    mysql_query(query);

    format(query, sizeof(query), "UPDATE `accounts` SET PayDayHad = '%d',CDPlayer = '%d',Wins = '%d',Loses = '%d',AlcoholPerk = '%d',DrugPerk = '%d',MiserPerk = '%d',PainPerk = '%d',TraderPerk = '%d',Tutorial = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pPayDayHad],PlayerInfo[playerid][pCDPlayer],PlayerInfo[playerid][pWins],PlayerInfo[playerid][pLoses],PlayerInfo[playerid][pAlcoholPerk],
    PlayerInfo[playerid][pDrugPerk],PlayerInfo[playerid][pPainPerk],PlayerInfo[playerid][pMiserPerk],PlayerInfo[playerid][pTraderPerk],PlayerInfo[playerid][pTut],PlayerInfo[playerid][pName]);
    mysql_query(query);


    format(query, sizeof(query), "UPDATE `accounts` SET Warns = '%d',Adjustable = '%d',Fuel = '%d',Married = '%d',MarriedTo = '%d',SpawnChange = '%d',WantedLevel = '%d',WantedPoints = '%d',PlayMinutes = '%d',GesamtMinutes = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pWarns],PlayerInfo[playerid][pAdjustable],PlayerInfo[playerid][pFuel],PlayerInfo[playerid][pMarried],PlayerInfo[playerid][pMarriedTo],
    SpawnChange[playerid],WantedLevel[playerid],WantedPoints[playerid],PlayerInfo[playerid][pPlayMinutes],PlayerInfo[playerid][pGesamtMinutes],PlayerInfo[playerid][pName]);
    mysql_query(query);

    format(query, sizeof(query), "UPDATE `accounts` SET MinutesSinceAn = '%d',SFPass = '%d',LVPASS = '%d',OffFlucht = '%d',Knast = '%d',KnastTime = '%d',Handy = '%d',Uhr = '%d',Perso = '%d',FrakSperre = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pMinutesSinceAn],PlayerInfo[playerid][pSFPASS],PlayerInfo[playerid][pLVPASS],OfflineFlucht[playerid],Knast[playerid],
    KnastTime[playerid],PlayerInfo[playerid][pHandyID],PlayerInfo[playerid][pUhrID],PlayerInfo[playerid][pOwnPerso],PlayerInfo[playerid][pFrakSperre],PlayerInfo[playerid][pName]);
    mysql_query(query);

    format(query, sizeof(query), "UPDATE `accounts` SET Gehalt = '%d',InvWeapon = '%d',InvAmmo = '%d',InvWeapon2 = '%d',InvAmmo2 = '%d',InvMats = '%d',InvDrugs = '%d',gDeaths = '%d',gKills = '%d',Meldung = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pGehalt],PlayerInfo[playerid][pInvWeapon],PlayerInfo[playerid][pInvAmmo],PlayerInfo[playerid][pInvWeapon2],PlayerInfo[playerid][pInvAmmo2],
    PlayerInfo[playerid][pInvMats],PlayerInfo[playerid][pInvDrugs],PlayerInfo[playerid][pGDeaths],PlayerInfo[playerid][pGKills],PlayerInfo[playerid][pMeldung],PlayerInfo[playerid][pName]);
    mysql_query(query);


    format(query, sizeof(query), "UPDATE `accounts` SET Tanke = '%d',Zollpass = '%d',Zollpasstime = '%d',Banned = '%d' WHERE `Name` = '%s'",
    PlayerInfo[playerid][pGehalt],PlayerInfo[playerid][pPtankekey],PlayerInfo[playerid][pZollPass],PlayerInfo[playerid][pZollPassTime],PlayerInfo[playerid][pGesperrt],PlayerInfo[playerid][pName]);
    mysql_query(query);

    printf("Spielerdaten vom Spieler %s erfolgreich in der Datenbank gespeichert.",SpielerName(playerid));
    }
    }
    return 1;
    }