IR Script Buggy

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • Hey,
    Ich habe 2x Probleme mit dem IR Script, das 1 Problem ist das wenn ich mich einlogge i.wie die ganze Zeit sterbe obwohl ich alles versucht habe, es zu ändern mit SetPlayerHea.. 100. Das 2te Problem ist, wenn ich mir alle Scheine und mich dann auslogge und wieder einlogge habe ich nur Bike Schein und LKW die anderen sind weg :o


    Welcher kennt jemand das Problem, wenn nicht poste ich den Code.


    mfg

  • Poste doch gleich den Code um so schneller geht es.


    public OnPlayerLogin(playerid)
    {
    RemoveBuildings(playerid);
    new tmp[256],
    string[450],
    sendername[MAX_PLAYER_NAME];
    new Beschwerden = 0;
    //new LoginChecker;
    getdate(Jahr, Monat, Tag);
    gettime(Stunde, Minute, Sekunde);
    GetPlayerName(playerid, sendername, sizeof(sendername)); //Wir Speichern den Namen des Spielers in der Variable [i]SpielerInfo[playerid][pName][/i]
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))//Wir fragen ab ob der angegebene Spieler auch Online ist, und kein NPC ist (nur zur sicherhheit)
    {
    format(string, sizeof(string),"SELECT * FROM `users` WHERE `Name` = '%s'", sendername);
    mysql_query(string);//wir holen uns alles aus der tabelle "tabelle_mit_den_haeusern"
    mysql_store_result();//speichern dann das ergebniss
    new val[ 256 ];
    while(mysql_fetch_row_format(string,"|"))
    {
    self_mysql_get_field("Level", val); PlayerInfo[playerid][pLevel] = strval( val );
    self_mysql_get_field("AdminLevel", val); PlayerInfo[playerid][pAdmin] = strval( val );
    self_mysql_get_field("DonateRank", val); PlayerInfo[playerid][pDonatorRank] = strval( val );
    self_mysql_get_field("UpgradePoints", val); PlayerInfo[playerid][gPupgrade] = strval( val );
    self_mysql_get_field("ConnectedTime", val); PlayerInfo[playerid][pConnectTime] = strval( val );
    self_mysql_get_field("Registered", val); PlayerInfo[playerid][pReg] = strval( val );
    self_mysql_get_field("Sex", val); PlayerInfo[playerid][pSex] = strval( val );
    self_mysql_get_field("Age", val); PlayerInfo[playerid][pAlter] = strval( val );
    self_mysql_get_field("Origin", val); PlayerInfo[playerid][pOrigin] = strval( val );
    self_mysql_get_field("Muted", val); PlayerInfo[playerid][pMuted] = strval( val );
    self_mysql_get_field("Respect", val); PlayerInfo[playerid][pRespekt] = strval( val );
    self_mysql_get_field("Money", val); PlayerInfo[playerid][pCash] = strval( val );
    self_mysql_get_field("Bank", val); PlayerInfo[playerid][pBank] = strval( val );
    self_mysql_get_field("Allowed", val); PlayerInfo[playerid][pAllowed] = strval( val );
    self_mysql_get_field("bankfach1", val); PlayerInfo[playerid][pBankFach1] = strval( val );
    self_mysql_get_field("bankfach2", val); PlayerInfo[playerid][pBankFach2] = strval( val );
    self_mysql_get_field("bankfach3", val); PlayerInfo[playerid][pBankFach3] = strval( val );
    self_mysql_get_field("bankfach4", val); PlayerInfo[playerid][pBankFach4] = strval( val );
    self_mysql_get_field("wgs", val); PlayerInfo[playerid][pwgs] = strval( val );
    self_mysql_get_field("facherlaubis", val); PlayerInfo[playerid][pfacherlaubis] = strval( val );
    self_mysql_get_field("Crimes", val); PlayerInfo[playerid][pCrimes] = strval( val );
    self_mysql_get_field("Kills", val); PlayerInfo[playerid][pKills] = strval( val );
    self_mysql_get_field("sKills", val); PlayerInfo[playerid][psKills] = strval( val );
    self_mysql_get_field("Deaths", val); PlayerInfo[playerid][pDeaths] = strval( val );
    self_mysql_get_field("Arrested", val); PlayerInfo[playerid][pArrested] = strval( val );
    self_mysql_get_field("ArrestTime", val); PlayerInfo[playerid][pArrestTime] = strval( val );
    self_mysql_get_field("PhoneBook", val); PlayerInfo[playerid][pPhoneBook] = strval( val );
    self_mysql_get_field("LottoNr", val); PlayerInfo[playerid][pLottoNr] = strval( val );
    self_mysql_get_field("Fishes", val); PlayerInfo[playerid][pFishes] = strval( val );
    self_mysql_get_field("BiggestFish", val); PlayerInfo[playerid][pBiggestFish] = strval( val );
    self_mysql_get_field("Job", val); PlayerInfo[playerid][pJob] = strval( val );
    self_mysql_get_field("Paycheck", val); PlayerInfo[playerid][pPayCheck] = strval( val );
    self_mysql_get_field("HeadValue", val); PlayerInfo[playerid][pHeadValue] = strval( val );
    self_mysql_get_field("Jailed", val); PlayerInfo[playerid][pJailed] = strval( val );
    self_mysql_get_field("JailTime", val); PlayerInfo[playerid][pJailTime] = strval( val );
    self_mysql_get_field("Leader", val); PlayerInfo[playerid][pLeader] = strval( val );
    self_mysql_get_field("Member", val); PlayerInfo[playerid][pMember] = strval( val );
    self_mysql_get_field("Rank", val); PlayerInfo[playerid][pRank] = strval( val );
    self_mysql_get_field("Skin", val); PlayerInfo[playerid][pChar] = strval( val );
    self_mysql_get_field("Vertragszeit", val); PlayerInfo[playerid][pVertragszeit] = strval( val );
    self_mysql_get_field("DetSkill", val); PlayerInfo[playerid][pDetSkill] = strval( val );
    self_mysql_get_field("SexSkill", val); PlayerInfo[playerid][pSexSkill] = strval( val );
    self_mysql_get_field("LawSkill", val); PlayerInfo[playerid][pAnwaltSkill] = strval( val );
    self_mysql_get_field("MechSkill", val); PlayerInfo[playerid][pMechSkill] = strval( val );
    self_mysql_get_field("JackSkill", val); PlayerInfo[playerid][pJackSkill] = strval( val );
    self_mysql_get_field("CarSkill", val); PlayerInfo[playerid][pCarSkill] = strval( val );
    self_mysql_get_field("NewsSkill", val); PlayerInfo[playerid][pNewsSkill] = strval( val );
    self_mysql_get_field("DrugsSkill", val); PlayerInfo[playerid][pDrugsSkill] = strval( val );
    self_mysql_get_field("CookSkill", val); PlayerInfo[playerid][pCookSkill] = strval( val );
    self_mysql_get_field("FishSkill", val); PlayerInfo[playerid][pFishSkill] = strval( val );
    self_mysql_get_field("pSHealth", val); PlayerInfo[playerid][pSHealth] = floatstr( val );
    self_mysql_get_field("PhoneNr", val); PlayerInfo[playerid][pNummer] = strval( val );
    self_mysql_get_field("House", val); PlayerInfo[playerid][pPhousekey] = strval( val );
    self_mysql_get_field("Biz", val); PlayerInfo[playerid][pBizKey] = strval( val );
    self_mysql_get_field("CarLic", val); PlayerInfo[playerid][pCarLic] = strval( val );
    self_mysql_get_field("FlyLic", val); PlayerInfo[playerid][pFlyLic] = strval( val );
    self_mysql_get_field("BoatLic", val); PlayerInfo[playerid][pBoatLic] = strval( val );
    self_mysql_get_field("FishLic", val); PlayerInfo[playerid][pFishLic] = strval( val );
    self_mysql_get_field("GunLic", val); PlayerInfo[playerid][pGunLic] = strval( val );
    self_mysql_get_field("Gun1", val); PlayerInfo[playerid][pGun1] = strval( val );
    self_mysql_get_field("Gun2", val); PlayerInfo[playerid][pGun2] = strval( val );
    self_mysql_get_field("Gun3", val); PlayerInfo[playerid][pGun3] = strval( val );
    self_mysql_get_field("Gun4", val); PlayerInfo[playerid][pGun4] = strval( val );
    self_mysql_get_field("Ammo1", val); PlayerInfo[playerid][pAmmo1] = strval( val );
    self_mysql_get_field("Ammo2", val); PlayerInfo[playerid][pAmmo2] = strval( val );
    self_mysql_get_field("Ammo3", val); PlayerInfo[playerid][pAmmo3] = strval( val );
    self_mysql_get_field("Ammo4", val); PlayerInfo[playerid][pAmmo4] = strval( val );
    self_mysql_get_field("CarTime", val); PlayerInfo[playerid][pCarTime] = strval( val );
    self_mysql_get_field("PayDay", val); PlayerInfo[playerid][pPayDay] = strval( val );
    self_mysql_get_field("PayDayHad", val); PlayerInfo[playerid][pPayDayHad] = strval( val );
    self_mysql_get_field("CDPlayer", val); PlayerInfo[playerid][pCDPlayer] = strval( val );
    self_mysql_get_field("AlcoholPerk", val); PlayerInfo[playerid][pAlcoholPerk] = strval( val );
    self_mysql_get_field("DrugPerk", val); PlayerInfo[playerid][pDrugPerk] = strval( val );
    self_mysql_get_field("MiserPerk", val); PlayerInfo[playerid][pMiserPerk] = strval( val );
    self_mysql_get_field("TraderPerk", val); PlayerInfo[playerid][pTraderPerk] = strval( val );
    self_mysql_get_field("PainKillerPerk", val); PlayerInfo[playerid][pPainKillerPerk] = strval( val );
    self_mysql_get_field("Tutorial", val); PlayerInfo[playerid][pTut] = strval( val );
    self_mysql_get_field("Warnings", val); PlayerInfo[playerid][pWarns] = strval( val );
    self_mysql_get_field("Fuel", val); PlayerInfo[playerid][pFuel] = strval( val );
    self_mysql_get_field("Married", val); PlayerInfo[playerid][pMarried] = strval( val );
    self_mysql_get_field("MarriedTo", val); strmid(PlayerInfo[playerid][pMarriedTo], val, 0, strlen(val), 255);
    self_mysql_get_field("WantedLevel", val); PlayerInfo[playerid][pWantedLevel] = strval( val );
    self_mysql_get_field("Spawn", val); PlayerInfo[playerid][pSpawn] = strval( val );
    self_mysql_get_field("SavedMaterials", val); PlayerInfo[playerid][pSaveMats] = strval( val );
    self_mysql_get_field("SavedDrugs", val); PlayerInfo[playerid][pSaveDrugs] = strval( val );
    self_mysql_get_field("SaveCodes", val); PlayerInfo[playerid][pSaveCodes] = strval( val );
    self_mysql_get_field("BikeLic", val); PlayerInfo[playerid][pBikeLic] = strval( val );
    self_mysql_get_field("LKWLic", val); PlayerInfo[playerid][pLKWLic] = strval( val );
    self_mysql_get_field("DonatorTime", val); PlayerInfo[playerid][pDonatorZeit] = strval( val );
    self_mysql_get_field("WerberName", val); strmid(PlayerInfo[playerid][pWerberName], val, 0, strlen(val), 255);
    self_mysql_get_field("FightingStyle", val); PlayerInfo[playerid][pFightingStyle] = strval( val );
    self_mysql_get_field("Handy", val); PlayerInfo[playerid][pHandy] = strval( val );
    self_mysql_get_field("OnDutySkin", val); PlayerInfo[playerid][pOnDutySkin] = strval( val );
    self_mysql_get_field("CarLicPoints", val); PlayerInfo[playerid][pCarLicPoints] = strval( val );
    self_mysql_get_field("BikeLicPoints", val); PlayerInfo[playerid][pBikeLicPoints] = strval( val );
    self_mysql_get_field("InviteSperre", val); PlayerInfo[playerid][pInviteSperre] = strval( val );
    self_mysql_get_field("warntime1", val); PlayerInfo[playerid][pWarnTime1] = strval( val );
    self_mysql_get_field("warntime2", val); PlayerInfo[playerid][pWarnTime2] = strval( val );
    self_mysql_get_field("Ticketsopen", val); PlayerInfo[playerid][pTicketsopen] = strval( val );
    self_mysql_get_field("OldName", val); strmid(PlayerInfo[playerid][pOldName], val, 0, strlen(val), 255);
    self_mysql_get_field("OrgMember", val); PlayerInfo[playerid][pOrgaID] = strval( val );
    self_mysql_get_field("OrgLeader", val); PlayerInfo[playerid][pOrgaLeader] = strval( val );
    self_mysql_get_field("OrgName", val); strmid(PlayerInfo[playerid][pOrgaName], val, 0, strlen(val), 255);
    self_mysql_get_field("SQLid", val); PlayerInfo[playerid][pSQLID] = strval( val );
    self_mysql_get_field("OPBeschwerden", val); Beschwerden = strval( val );
    mysql_free_result();
    }

    }



    public OnPlayerRegister(playerid, password[])
    {
    StuffInfo[sNeuUser] += 1;
    if(IsPlayerConnected(playerid))
    {
    new string[128],
    playername[MAX_PLAYER_NAME];


    GetPlayerName(playerid, playername, sizeof(playername));


    format(string, sizeof(string), "%s", password);
    strmid(PlayerInfo[playerid][pKey], string, 0, strlen(string), 255);
    //PlayerInfo[playerid][pCash] = PlayerInfo[playerid][pCash];
    //#if defined MySQLSpeicherung
    format(string, sizeof(string), "INSERT INTO `users` (`Name`, `Key`) VALUES ('%s', '%s')", playername, PlayerInfo[playerid][pKey]);
    self_mysql_query(string);
    format(string, sizeof(string), "UPDATE `users` SET `RegisterDatum`='%d' WHERE `Name`='%s'", Time(), playername);
    self_mysql_query(string);
    PlayerUpdate(playerid);
    //PlayerCarUpdate(playerid);
    //#else
    format(string, sizeof(string), "user/%s.ini", playername);
    new File: hFile = fopen(string, io_write);
    if (hFile)
    {
    new var[32];
    format(var, 32, "Key=%s\n", PlayerInfo[playerid][pKey]);fwrite(hFile, var);
    format(var, 32, "Level=%d\n",PlayerInfo[playerid][pLevel]);fwrite(hFile, var);
    format(var, 32, "AdminLevel=%d\n",PlayerInfo[playerid][pAdmin]);fwrite(hFile, var);
    format(var, 32, "DonateRank=%d\n",PlayerInfo[playerid][pDonatorRank]);fwrite(hFile, var);
    format(var, 32, "UpgradePoints=%d\n",PlayerInfo[playerid][gPupgrade]);fwrite(hFile, var);
    format(var, 32, "ConnectedTime=%d\n",PlayerInfo[playerid][pConnectTime]);fwrite(hFile, var);
    format(var, 32, "Registered=%d\n",PlayerInfo[playerid][pReg]);fwrite(hFile, var);
    format(var, 32, "Sex=%d\n",PlayerInfo[playerid][pSex]);fwrite(hFile, var);
    format(var, 32, "Age=%d\n",PlayerInfo[playerid][pAlter]);fwrite(hFile, var);
    format(var, 32, "Origin=%d\n",PlayerInfo[playerid][pOrigin]);fwrite(hFile, var);
    format(var, 32, "Muted=%d\n",PlayerInfo[playerid][pMuted]);fwrite(hFile, var);
    format(var, 32, "Respect=%d\n",PlayerInfo[playerid][pRespekt]);fwrite(hFile, var);
    format(var, 32, "Money=%d\n",PlayerInfo[playerid][pCash]);fwrite(hFile, var);
    format(var, 32, "Bank=%d\n",PlayerInfo[playerid][pBank]);fwrite(hFile, var);

    format(var, 32, "Allowed=%d\n",PlayerInfo[playerid][pAllowed]);fwrite(hFile, var);
    format(var, 32, "bankfach1=%d\n",PlayerInfo[playerid][pBankFach1]);fwrite(hFile, var);
    format(var, 32, "bankfach2=%d\n",PlayerInfo[playerid][pBankFach2]);fwrite(hFile, var);
    format(var, 32, "bankfach3=%d\n",PlayerInfo[playerid][pBankFach3]);fwrite(hFile, var);
    format(var, 32, "bankfach4=%d\n",PlayerInfo[playerid][pBankFach4]);fwrite(hFile, var);
    format(var, 32, "wgs=%d\n",PlayerInfo[playerid][pwgs]);fwrite(hFile, var);
    format(var, 32, "facherlaubis=%d\n",PlayerInfo[playerid][pfacherlaubis]);fwrite(hFile, var);


    format(var, 32, "Crimes=%d\n",PlayerInfo[playerid][pCrimes]);fwrite(hFile, var);
    format(var, 32, "Kills=%d\n",PlayerInfo[playerid][pKills]);fwrite(hFile, var);
    format(var, 32, "sKills=%d\n",PlayerInfo[playerid][psKills]);fwrite(hFile, var);
    format(var, 32, "Deaths=%d\n",PlayerInfo[playerid][pDeaths]);fwrite(hFile, var);
    format(var, 32, "Arrested=%d\n",PlayerInfo[playerid][pArrested]);fwrite(hFile, var);
    format(var, 32, "ArrestTime=%d\n",PlayerInfo[playerid][pArrestTime]);fwrite(hFile, var);
    format(var, 32, "PhoneBook=%d\n",PlayerInfo[playerid][pPhoneBook]);fwrite(hFile, var);
    format(var, 32, "LottoNr=%d\n",PlayerInfo[playerid][pLottoNr]);fwrite(hFile, var);
    format(var, 32, "Fishes=%d\n",PlayerInfo[playerid][pFishes]);fwrite(hFile, var);
    format(var, 32, "BiggestFish=%d\n",PlayerInfo[playerid][pBiggestFish]);fwrite(hFile, var);
    format(var, 32, "Job=%d\n",PlayerInfo[playerid][pJob]);fwrite(hFile, var);
    format(var, 32, "Paycheck=%d\n",PlayerInfo[playerid][pPayCheck]);fwrite(hFile, var);
    format(var, 32, "HeadValue=%d\n",PlayerInfo[playerid][pHeadValue]);fwrite(hFile, var);
    format(var, 32, "Jailed=%d\n",PlayerInfo[playerid][pJailed]);fwrite(hFile, var);
    format(var, 32, "JailTime=%d\n",PlayerInfo[playerid][pJailTime]);fwrite(hFile, var);
    format(var, 32, "Materials=%d\n",PlayerInfo[playerid][pMats]);fwrite(hFile, var);
    format(var, 32, "Drugs=%d\n",PlayerInfo[playerid][pDrugs]);fwrite(hFile, var);
    format(var, 32, "Leader=%d\n",PlayerInfo[playerid][pLeader]);fwrite(hFile, var);
    format(var, 32, "Member=%d\n",PlayerInfo[playerid][pMember]);fwrite(hFile, var);
    format(var, 32, "Rank=%d\n",PlayerInfo[playerid][pRank]);fwrite(hFile, var);
    format(var, 32, "Skin=%d\n",PlayerInfo[playerid][pChar]);fwrite(hFile, var);
    format(var, 32, "Vertragszeit=%d\n",PlayerInfo[playerid][pVertragszeit]);fwrite(hFile, var);
    format(var, 32, "DetSkill=%d\n",PlayerInfo[playerid][pDetSkill]);fwrite(hFile, var);
    format(var, 32, "SexSkill=%d\n",PlayerInfo[playerid][pSexSkill]);fwrite(hFile, var);
    format(var, 32, "LawSkill=%d\n",PlayerInfo[playerid][pAnwaltSkill]);fwrite(hFile, var);
    format(var, 32, "MechSkill=%d\n",PlayerInfo[playerid][pMechSkill]);fwrite(hFile, var);
    format(var, 32, "JackSkill=%d\n",PlayerInfo[playerid][pJackSkill]);fwrite(hFile, var);
    format(var, 32, "CarSkill=%d\n",PlayerInfo[playerid][pCarSkill]);fwrite(hFile, var);
    format(var, 32, "NewsSkill=%d\n",PlayerInfo[playerid][pNewsSkill]);fwrite(hFile, var);
    format(var, 32, "DrugsSkill=%d\n",PlayerInfo[playerid][pDrugsSkill]);fwrite(hFile, var);
    format(var, 32, "CookSkill=%d\n",PlayerInfo[playerid][pCookSkill]);fwrite(hFile, var);
    format(var, 32, "FishSkill=%d\n",PlayerInfo[playerid][pFishSkill]);fwrite(hFile, var);
    format(var, 32, "pSHealth=%.1f\n",PlayerInfo[playerid][pSHealth]);fwrite(hFile, var);
    format(var, 32, "Local=%d\n",PlayerInfo[playerid][pLocal]);fwrite(hFile, var);
    format(var, 32, "PhoneNr=%d\n",PlayerInfo[playerid][pNummer]);fwrite(hFile, var);
    format(var, 32, "House=%d\n",PlayerInfo[playerid][pPhousekey]);fwrite(hFile, var);
    format(var, 32, "Biz=%d\n",PlayerInfo[playerid][pBizKey]);fwrite(hFile, var);
    format(var, 32, "CarLic=%d\n",PlayerInfo[playerid][pCarLic]);fwrite(hFile, var);
    format(var, 32, "FlyLic=%d\n",PlayerInfo[playerid][pFlyLic]);fwrite(hFile, var);
    format(var, 32, "BoatLic=%d\n",PlayerInfo[playerid][pBoatLic]);fwrite(hFile, var);
    format(var, 32, "FishLic=%d\n",PlayerInfo[playerid][pFishLic]);fwrite(hFile, var);
    format(var, 32, "GunLic=%d\n",PlayerInfo[playerid][pGunLic]);fwrite(hFile, var);
    format(var, 32, "Gun1=%d\n",PlayerInfo[playerid][pGun1]);fwrite(hFile, var);
    format(var, 32, "Gun2=%d\n",PlayerInfo[playerid][pGun2]);fwrite(hFile, var);
    format(var, 32, "Gun3=%d\n",PlayerInfo[playerid][pGun3]);fwrite(hFile, var);
    format(var, 32, "Gun4=%d\n",PlayerInfo[playerid][pGun4]);fwrite(hFile, var);
    format(var, 32, "Ammo1=%d\n",PlayerInfo[playerid][pAmmo1]);fwrite(hFile, var);
    format(var, 32, "Ammo2=%d\n",PlayerInfo[playerid][pAmmo2]);fwrite(hFile, var);
    format(var, 32, "Ammo3=%d\n",PlayerInfo[playerid][pAmmo3]);fwrite(hFile, var);
    format(var, 32, "Ammo4=%d\n",PlayerInfo[playerid][pAmmo4]);fwrite(hFile, var);
    format(var, 32, "CarTime=%d\n",PlayerInfo[playerid][pCarTime]);fwrite(hFile, var);
    format(var, 32, "PayDay=%d\n",PlayerInfo[playerid][pPayDay]);fwrite(hFile, var);
    format(var, 32, "PayDayHad=%d\n",PlayerInfo[playerid][pPayDayHad]);fwrite(hFile, var);
    format(var, 32, "CDPlayer=%d\n",PlayerInfo[playerid][pCDPlayer]);fwrite(hFile, var);
    format(var, 32, "AlcoholPerk=%d\n",PlayerInfo[playerid][pAlcoholPerk]);fwrite(hFile, var);
    format(var, 32, "PainKillerPerk=%d\n",PlayerInfo[playerid][pPainKillerPerk]);fwrite(hFile,var);
    format(var, 32, "DrugPerk=%d\n",PlayerInfo[playerid][pDrugPerk]);fwrite(hFile, var);
    format(var, 32, "MiserPerk=%d\n",PlayerInfo[playerid][pMiserPerk]);fwrite(hFile, var);
    format(var, 32, "TraderPerk=%d\n",PlayerInfo[playerid][pTraderPerk]);fwrite(hFile, var);
    format(var, 32, "Tutorial=%d\n",PlayerInfo[playerid][pTut]);fwrite(hFile, var);
    format(var, 32, "Warnings=%d\n",PlayerInfo[playerid][pWarns]);fwrite(hFile, var);
    format(var, 32, "Fuel=%d\n",PlayerInfo[playerid][pFuel]);fwrite(hFile, var);
    format(var, 32, "Married=%d\n",PlayerInfo[playerid][pMarried]);fwrite(hFile, var);
    format(var, 32, "MarriedTo=%s\n",PlayerInfo[playerid][pMarriedTo]);fwrite(hFile, var);
    format(var, 32, "WantedLevel=%d\n",PlayerInfo[playerid][pWantedLevel]);fwrite(hFile, var);
    format(var, 32, "Spawn=%d\n",PlayerInfo[playerid][pSpawn]);fwrite(hFile, var);
    format(var, 32, "SavedMaterials=%d\n",PlayerInfo[playerid][pSaveMats]);fwrite(hFile, var);
    format(var, 32, "SavedDrugs=%d\n",PlayerInfo[playerid][pSaveDrugs]);fwrite(hFile, var);
    format(var, 32, "BikeLic=%d\n",PlayerInfo[playerid][pBikeLic]);fwrite(hFile, var);
    format(var, 32, "LKWLic=%d\n",PlayerInfo[playerid][pLKWLic]);fwrite(hFile, var);
    format(var, 32, "DonatorTime=%d\n",PlayerInfo[playerid][pDonatorZeit]);fwrite(hFile, var);
    format(var, 32, "WerberName=%s\n",PlayerInfo[playerid][pWerberName]);fwrite(hFile, var);
    format(var, 32, "FightingStyle=%d\n",PlayerInfo[playerid][pFightingStyle]);fwrite(hFile, var);
    format(var, 32, "Handy=%d\n",PlayerInfo[playerid][pHandy]);fwrite(hFile, var);
    format(var, 32, "OnDutySkin=%d\n",PlayerInfo[playerid][pOnDutySkin]);fwrite(hFile, var);
    format(var, 32, "CarLicPoints=%d\n",PlayerInfo[playerid][pCarLicPoints]);fwrite(hFile, var);
    format(var, 32, "BikeLicPoints=%d\n",PlayerInfo[playerid][pBikeLicPoints]);fwrite(hFile, var);
    format(var, 32, "InviteSperre=%d\n",PlayerInfo[playerid][pInviteSperre]);fwrite(hFile, var);
    format(var, 32, "wartime1=%d\n",PlayerInfo[playerid][pWarnTime1]);fwrite(hFile, var);
    format(var, 32, "warntime2=%d\n",PlayerInfo[playerid][pWarnTime2]);fwrite(hFile, var);
    format(var, 32, "Ticketsopen=%d\n",PlayerInfo[playerid][pTicketsopen]);fwrite(hFile, var);

    fclose(hFile);
    }
    format(string,sizeof(string),"%s(%d) hat sich soebend mit der IP [%s] Registriert.", playername, playerid, PlayerInfo[playerid][pUserIP]);
    EnterToLog("ip",string);
    }
    return 1;
    }



    //Nur ein Auschnitt
    public PlayerUpdate(playerid)
    {
    if(IsPlayerConnected(playerid))
    {
    if(IsPlayerNPC(playerid))
    {
    return 1;
    }
    new playername[MAX_PLAYER_NAME];
    GetPlayerName(playerid, playername, sizeof(playername));
    new endstring[1600];
    new var[129];
    format(endstring, sizeof(endstring), "UPDATE `users` SET ");
    format(var, sizeof(var), "`Key`='%s', ", PlayerInfo[playerid][pKey]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Level`='%d', ", PlayerInfo[playerid][pLevel]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`AdminLevel`='%d', ", PlayerInfo[playerid][pAdmin]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`DonateRank`='%d', ", PlayerInfo[playerid][pDonatorRank]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`UpgradePoints`='%d', ", PlayerInfo[playerid][gPupgrade]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`ConnectedTime`='%d', ", PlayerInfo[playerid][pConnectTime]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Registered`='%d', ", PlayerInfo[playerid][pReg]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Sex`='%d', ", PlayerInfo[playerid][pSex]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Age`='%d', ", PlayerInfo[playerid][pAlter]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Origin`='%d', ", PlayerInfo[playerid][pOrigin]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Muted`='%d', ", PlayerInfo[playerid][pMuted]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Respect`='%d', ", PlayerInfo[playerid][pRespekt]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Money`='%d', ", PlayerInfo[playerid][pCash]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Bank`='%d', ", PlayerInfo[playerid][pBank]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Allowed`='%d', ", PlayerInfo[playerid][pAllowed]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`bankfach1`='%d', ", PlayerInfo[playerid][pBankFach1]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`bankfach2`='%d', ", PlayerInfo[playerid][pBankFach2]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`bankfach3`='%d', ", PlayerInfo[playerid][pBankFach3]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`bankfach4`='%d', ", PlayerInfo[playerid][pBankFach4]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`wgs`='%d', ", PlayerInfo[playerid][pwgs]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`facherlaubis`='%d', ", PlayerInfo[playerid][pfacherlaubis]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Crimes`='%d', ", PlayerInfo[playerid][pCrimes]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Kills`='%d', ", PlayerInfo[playerid][pKills]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`sKills`='%d', ", PlayerInfo[playerid][psKills]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Deaths`='%d', ", PlayerInfo[playerid][pDeaths]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Arrested`='%d', ", PlayerInfo[playerid][pArrested]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`ArrestTime`='%d', ", PlayerInfo[playerid][pArrestTime]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`PhoneBook`='%d', ", PlayerInfo[playerid][pPhoneBook]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`LottoNr`='%d', ", PlayerInfo[playerid][pLottoNr]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Fishes`='%d', ", PlayerInfo[playerid][pFishes]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`BiggestFish`='%d', ", PlayerInfo[playerid][pBiggestFish]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Job`='%d', ", PlayerInfo[playerid][pJob]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Paycheck`='%d'", PlayerInfo[playerid][pPayCheck]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), " WHERE `Name`='%s'", playername);
    strcat(endstring, var, sizeof(endstring));
    self_mysql_query(endstring);



    format(endstring, sizeof(endstring), "UPDATE `users` SET ");
    format(var, sizeof(var), "`HeadValue`='%d', ", PlayerInfo[playerid][pHeadValue]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Jailed`='%d', ", PlayerInfo[playerid][pJailed]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`JailTime`='%d', ", PlayerInfo[playerid][pJailTime]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Leader`='%d', ", PlayerInfo[playerid][pLeader]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Member`='%d', ", PlayerInfo[playerid][pMember]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Rank`='%d', ", PlayerInfo[playerid][pRank]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Skin`='%d', ", PlayerInfo[playerid][pChar]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Vertragszeit`='%d', ", PlayerInfo[playerid][pVertragszeit]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`DetSkill`='%d', ", PlayerInfo[playerid][pDetSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`SexSkill`='%d', ", PlayerInfo[playerid][pSexSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`LawSkill`='%d', ", PlayerInfo[playerid][pAnwaltSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`MechSkill`='%d', ", PlayerInfo[playerid][pMechSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`JackSkill`='%d'", PlayerInfo[playerid][pJackSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), " WHERE `Name`='%s'", playername);
    strcat(endstring, var, sizeof(endstring));
    self_mysql_query(endstring);


    format(endstring, sizeof(endstring), "UPDATE `users` SET ");
    format(var, sizeof(var), "`CarSkill`='%d', ", PlayerInfo[playerid][pCarSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`NewsSkill`='%d', ", PlayerInfo[playerid][pNewsSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`DrugsSkill`='%d', ", PlayerInfo[playerid][pDrugsSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`CookSkill`='%d', ", PlayerInfo[playerid][pCookSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`FishSkill`='%d', ", PlayerInfo[playerid][pFishSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`pSHealth`='%.1f', ", PlayerInfo[playerid][pSHealth]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`PhoneNr`='%d', ", PlayerInfo[playerid][pNummer]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`House`='%d', ", PlayerInfo[playerid][pPhousekey]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Biz`='%d', ", PlayerInfo[playerid][pBizKey]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`CarLic`='%d', ", PlayerInfo[playerid][pCarLic]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`FlyLic`='%d', ", PlayerInfo[playerid][pFlyLic]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`BoatLic`='%d', ", PlayerInfo[playerid][pBoatLic]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`FishLic`='%d', ", PlayerInfo[playerid][pFishLic]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`GunLic`='%d', ", PlayerInfo[playerid][pGunLic]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), " WHERE `Name`='%s'", playername);
    strcat(endstring, var, sizeof(endstring));
    self_mysql_query(endstring);

  • ...
    MySQL-Speicherung? Ja, oder?


    format(endstring, sizeof(endstring), "UPDATE `users` SET ");
    format(var, sizeof(var), "`CarSkill`='%d', ", PlayerInfo[playerid][pCarSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`NewsSkill`='%d', ", PlayerInfo[playerid][pNewsSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`DrugsSkill`='%d', ", PlayerInfo[playerid][pDrugsSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`CookSkill`='%d', ", PlayerInfo[playerid][pCookSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`FishSkill`='%d', ", PlayerInfo[playerid][pFishSkill]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`pSHealth`='%.1f', ", PlayerInfo[playerid][pSHealth]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`PhoneNr`='%d', ", PlayerInfo[playerid][pNummer]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`House`='%d', ", PlayerInfo[playerid][pPhousekey]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`Biz`='%d', ", PlayerInfo[playerid][pBizKey]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`CarLic`='%d', ", PlayerInfo[playerid][pCarLic]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`FlyLic`='%d', ", PlayerInfo[playerid][pFlyLic]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`BoatLic`='%d', ", PlayerInfo[playerid][pBoatLic]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`FishLic`='%d', ", PlayerInfo[playerid][pFishLic]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), "`GunLic`='%d', ", PlayerInfo[playerid][pGunLic]);
    strcat(endstring, var, sizeof(endstring));
    format(var, sizeof(var), " WHERE `Name`='%s'", playername);
    strcat(endstring, var, sizeof(endstring));
    self_mysql_query(endstring);


    Finde den Fehler in Zeile 28.
    Oder hast du da aufgehört mit dem Posten? (Hast ja geschrieben, dass das nur teilweise rauskopiert wurde)


    Schon einmal mit mysql_debug probiert?


    Existieren diese Felder in der Datenbank?
    self_mysql_get_field("CarLic", val); PlayerInfo[playerid][pCarLic] = strval( val );
    self_mysql_get_field("FlyLic", val); PlayerInfo[playerid][pFlyLic] = strval( val );
    self_mysql_get_field("BoatLic", val); PlayerInfo[playerid][pBoatLic] = strval( val );
    self_mysql_get_field("FishLic", val); PlayerInfo[playerid][pFishLic] = strval( val );
    self_mysql_get_field("GunLic", val); PlayerInfo[playerid][pGunLic] = strval( val );
    self_mysql_get_field("BikeLic", val); PlayerInfo[playerid][pBikeLic] = strval( val );
    self_mysql_get_field("LKWLic", val); PlayerInfo[playerid][pLKWLic] = strval( val );


    Mit freundlichen Grüßen
    Kevin


    :) Der Fehler in Zeile 28 erklärt auch das Biz-Problem. (Anderer Thread von dir!)


  • Ich dank dir ehrlichen, das du uns so behilflich bist <3. Das Script ist echt komisch (Sricpttechnisch). Doch nur ein Problem noch, man stirbt wenn man am Spawn spawnt obwohl ich den Spawn jetzt geändert habe, stirbt man trotzdem

  • Deinem Kollegen habe Ich schon etwas zu dem Problem mit dem Sterben geschrieben.


    Mit freundlichen Grüßen
    Kevin