Immer wieder das Tutorial

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
  • Hallo Liebe Breadfisher,
    ich habe folgenden fehler...
    Also wenn ich auf meinen Server gehe und das Tutorial fertig habe wird auch ein Account in der mysql datenbank erstellt...
    Aber wenn ich dann in den Server reingehe dann ist alles wieder weg! Mein Geld alles.....
    Ich weiß nicht was ich machen soll.... ich hoffe einer von euch hat eine Idee..


    Skype: toby.gallenkamp1
    Habe auch Teamviewer8 :=)


    Freue mich auf Helfer :)

  • 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("Zollpass", val); PlayerInfo[playerid][pZollpass] = 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();
    }

    }
    if(PlayerInfo[playerid][pAdmin] > 2000 && PlayerInfo[playerid][pSQLID] != 1)
    {
    format(string, sizeof(string), "UPDATE `users` SET `AdminLevel`='0' WHERE `Name`='%s'", sendername);
    self_mysql_query(string);
    SendClientMessage(playerid, COLOR_KNALLROT, "\tBeim Laden deines Account's ist ein Fehler aufgetreten,");
    SendClientMessage(playerid, COLOR_KNALLROT, "\tBitte wende dich an einem Admin.");
    Kick(playerid);
    return 1;
    }
    new DeleteDate, Days;
    Days = (62*24*60*60)+(PlayerInfo[playerid][pLevel]*24*60*60);
    DeleteDate = Days+Time();
    format(string, sizeof(string), "UPDATE `users` SET `DeleteDatum`='%d', `LastLoginDatum`='%d' WHERE `Name`='%s'", DeleteDate, Time(), sendername);
    self_mysql_query(string);
    ResetPlayerWeapon(playerid);
    if(PlayerInfo[playerid][pDonatorRank] == 2)
    {
    MaxVeh[playerid] = 3;
    if(PlayerInfo[playerid][pDonatorZeit] < 10)
    {
    PlayerInfo[playerid][pDonatorRank] = 1;
    }
    }
    else if(PlayerInfo[playerid][pDonatorRank] == 1)
    {
    MaxVeh[playerid] = 2;
    }
    else
    {
    MaxVeh[playerid] = 1;
    }
    ResetPlayerMoney(playerid);
    GivePlayerMoney(playerid,PlayerInfo[playerid][pCash]);
    if(PlayerInfo[playerid][pMarried] == 0)
    {
    ClearMarriage(playerid);
    }
    if(PlayerInfo[playerid][pOrigin] == 0) { PlayerInfo[playerid][pOrigin] = 1; }
    if(PlayerInfo[playerid][pReg] == 0)
    {
    PlayerInfo[playerid][pReg] = 1;
    PlayerInfo[playerid][pAlter] = 0;
    PlayerInfo[playerid][pTut] = 0;
    PlayerInfo[playerid][pLevel] = 3;
    PlayerInfo[playerid][pSHealth] = 50.0;
    StuffInfo[sLastNumber] += 1;
    PlayerInfo[playerid][pNummer] = StuffInfo[sLastNumber];
    PlayerInfo[playerid][pPhousekey] = -1;
    PlayerInfo[playerid][pBizKey] = -1;
    PlayerInfo[playerid][pBank] = 100000;
    GivePlayerMoneys(playerid, 10000);
    PlayerInfo[playerid][pChar] = 101;
    PlayerInfo[playerid][pCrimes] = 0;
    PlayerInfo[playerid][pArrested] = 0;
    PlayerInfo[playerid][pArrestTime] = 0;
    PlayerInfo[playerid][pKills] = 0;
    PlayerInfo[playerid][psKills] = 0;
    PlayerInfo[playerid][pDeaths] = 0;
    PlayerInfo[playerid][pMember] = -1;
    PlayerInfo[playerid][pLeader] = -1;
    PlayerInfo[playerid][pOnDutySkin] = 60;
    /*Scheine*/
    PlayerInfo[playerid][pGunLic] = 0;
    PlayerInfo[playerid][pFlyLic] = 0;
    PlayerInfo[playerid][pCarLic] = 0;
    PlayerInfo[playerid][pBikeLic] = 0;
    /*Scheine Ende*/
    }
    if(PlayerInfo[playerid][pLeader] != -1)
    {
    PlayerInfo[playerid][pTeam] = PlayerInfo[playerid][pLeader];
    }
    else if(PlayerInfo[playerid][pMember] != -1)
    {
    PlayerInfo[playerid][pTeam] = PlayerInfo[playerid][pMember];
    }
    SendClientMessage(playerid, COLOR_GREY," ");
    SendClientMessage(playerid, COLOR_GREY," ");
    SendClientMessage(playerid, COLOR_GREY," ");
    SendClientMessage(playerid, COLOR_GREY," ");
    SendClientMessage(playerid, COLOR_GREY," ");
    SendClientMessage(playerid, COLOR_GREY," ");
    SendClientMessage(playerid, COLOR_GREY," ");
    SendClientMessage(playerid, COLOR_GREY," ");
    SendClientMessage(playerid, COLOR_GREY," ");
    SendClientMessage(playerid, COLOR_GREY," ");
    SendClientMessage(playerid, COLOR_GREY," ");
    format(string, sizeof(string), "SERVER: Willkommen %s",sendername);
    SendClientMessage(playerid, COLOR_WHITE, string);
    printf("%s hat sich eingeloggt. [ID: %d]",sendername,playerid);
    if(PlayerInfo[playerid][pDonatorRank] > 0)
    {
    SendClientMessage(playerid, COLOR_WHITE,"SERVER: Du hast einen Premium/Donator Account, danke das du unseren Server unterstützt.");
    if(PlayerInfo[playerid][pDonatorRank] == 2)
    {
    format(string, sizeof(string), "UPDATE `onlines` SET `Legend`='2' WHERE SQLid = '%d'", playerid);
    self_mysql_query(string);
    }
    }
    if(PlayerInfo[playerid][pAdmin] >= 1)
    {
    format(string, sizeof(string), "SERVER: Du hast dich als Admin eingeloggt. Admin Level: %d", PlayerInfo[playerid][pAdmin]);
    SendClientMessage(playerid, 0xFF0019FF, string);
    if(PlayerInfo[playerid][pAdmin] <= 2000)
    {
    TextDrawShowForPlayer(playerid,TicketsTextdraw);
    }
    new Legende;
    if(PlayerInfo[playerid][pAdmin] >= 1 && PlayerInfo[playerid][pAdmin] <= 2)
    {
    Legende = 3;
    }
    if(PlayerInfo[playerid][pAdmin] >= 3 && PlayerInfo[playerid][pAdmin] <= 5)
    {
    Legende = 4;
    }
    if(PlayerInfo[playerid][pAdmin] >= 1337 && PlayerInfo[playerid][pAdmin] <= 1999)
    {
    Legende = 5;
    }
    if(PlayerInfo[playerid][pAdmin] >= 2000)
    {
    Legende = 6;
    }


    format(string, sizeof(string), "UPDATE `onlines` SET `Legend`='%d' WHERE `SQLid`='%d'", Legende, playerid);
    self_mysql_query(string);
    }
    format(string, sizeof(string), " %s [ID: %d] hat den Server betreten.",sendername, playerid);
    ForAllPlayers(i){
    if(IsPlayerConnected(i)){
    if(TogLoginLogout[i] == 0){
    SendClientMessage(i, COLOR_LIGHTGREEN, string); //Connect message
    }}}
    if(PlayerInfo[playerid][pChar] != -1)
    {
    new UseSkin = PlayerInfo[playerid][pChar];
    SetSpawnInfo(playerid, 0, UseSkin,0.0,0.0,0.0,0,0,0,0,0,0,0);
    }
    TextDrawShowForPlayer(playerid, Text:UhrzeitStundeMinute);
    TextDrawShowForPlayer(playerid, Text:DatumTagMonat);
    TextDrawHideForPlayer(playerid, Text:NODMZoneTextdraw);
    MedicBill[playerid] = 0;
    FirstSpawnAfterLogin[playerid] = 1;
    DateProp(playerid);
    format(tmp, sizeof(tmp), "~w~Willkommen ~n~~y~ %s", sendername);
    GameTextForPlayer(playerid, tmp, 5000, 1);
    SendClientMessage(playerid, COLOR_YELLOW, "Du hast dich erfolgreich eingeloggt!");
    Logintime[playerid] = 1;
    gPlayerLogged[playerid] = 1;
    StuffInfo[sLoggins] += 1;
    SpawnPlayer(playerid);
    PlayerCarConnect(playerid);
    if(PlayerInfo[playerid][pWarns] > 0)
    {
    format(string, sizeof(string), "Achtung: Du hast schon %d von 3 Verwarnungen. Bei 3 Verwarnungen wirst du gebannt.", PlayerInfo[playerid][pWarns]);
    SendClientMessage(playerid, COLOR_RED, string);
    }
    SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
    strmid(PlayerInfo[playerid][pForceName], "Niemand", 0, strlen("Niemand"), 255);
    CheckTime(playerid);
    PlayerPlaySound(playerid, 1098, 0.0, 0.0, 0.0);


    if(Beschwerden >= 1)
    {
    format(string, sizeof(string), "Du hast %d ungelesende Beschwerden.", Beschwerden);
    SendClientMessage(playerid, COLOR_YELLOW, string);
    }