Server Registrierungs problem

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
  • Also ich habe da so ein Problem wenn man sich ein account erstellt funktioniert alles password usw
    Aber nachdem Restart wenn ich mich versuche einzuloggen steht da password falsch und wenn ich account.sql Öffne und dort pw anschaue hat sich das password irgendwie geändert in dem logs seh ich keine errors woran kann das Liegen?

  • Also ich habe es mal getestet habe nochmal das selbe vorgang gemacht und danach bin ich in die account.sql und habe das hash password kopiert und das hash password hat danach funktioniert D27A22EBBCD7129BA2A4790ADB47CCB6E2812C840FB0FDC61588FFB69DBC262D7244CDE2A4638377B6849AE41F86297915E29EB1EF889E19E6B547C2BAE363FA das alles oO? aber wenn ich change pass mache und normal einlogge geht das nach restart wird das wieder zur hash passwort und das hash passwort funktioniert dann als normales passwort normal gemeint so
    D27A22EBBCD7129BA2A4790ADB47CCB6E2812C840FB0FDC61588FFB69DBC262D7244CDE2A4638377B6849AE41F86297915E29EB1EF889E19E6B547C2BAE363FA


    ja und ich möchte das iwi nicht wie kann ich das hier weg machen bitte kann mir jemand per Team wiver helfen mein skype adde
    shadowchaos9

  • stock CreateAccount(playerid, pass[])
    {
    new Name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
    mysql_real_escape_string(Name,Name);
    mysql_real_escape_string(pass,pass);
    format(query, sizeof(query), "INSERT INTO accounts (Name, Passwort) VALUES ('%s', '%s')", Name, pass);
    mysql_query(query);
    //mysql_query(query,-1,0,connection); mysql_query(query,-1,0,connection1);
    //print("account in der funktion erstellt");
    return true;
    }



    stock mysql_CheckAccount(playerid)
    {
    new Name[MAX_PLAYER_NAME];
    GetPlayerName(playerid, Name, MAX_PLAYER_NAME);
    mysql_real_escape_string(Name, Name);
    format(query, sizeof(query), "SELECT * FROM accounts WHERE Name = '%s' ORDER BY `id` DESC LIMIT 1", Name);
    mysql_query(query);
    //mysql_query(query,-1,0,connection); mysql_query(query,-1,0,connection1);
    mysql_store_result();
    return mysql_num_rows();
    }





    stock mysql_ReturnPasswort(Name[])
    {
    new Get[130];
    mysql_real_escape_string(Name, Name);
    format(query, 128, "SELECT Passwort FROM accounts WHERE Name = '%s'", Name);
    //mysql_query(query,-1,0,connection); mysql_query(query,-1,0,connection1);
    mysql_query(query);
    mysql_store_result();
    mysql_fetch_row(Get,"|");
    mysql_free_result();
    return Get;
    }




    ocmd:changepass(playerid, params[])
    {
    if(PlayerInfo[playerid][pAdjustable] == 1)
    {
    ShowPlayerDialog(playerid, DIALOG_CHANGEPASS, DIALOG_STYLE_PASSWORD, "Passwort ändern","Hier kannst du dein Passwort ändern.\n\n{FF8C00}Tipps für ein sicheres Passwort:\n1. Länger als 8 Zeichen lang sollte es ein!\n2. Es sollte groß und kleinbuchstaben enthalten!\n3. Es sollte Sonderzeichen und Zahlen enthalten!", "Ausführen", "Abbruch");
    }
    else
    {
    SendClientMessage(playerid,COLOR_RED,"Du kannst dein Passwort nicht ändern, da du nicht eingeloggt bist.");
    }
    return 1;
    }




    }
    if(dialogid == DIALOG_REG)
    {
    if(response)
    {
    new MeinName[MAX_PLAYER_NAME];
    GetPlayerName(playerid,MeinName,sizeof MeinName);
    ShowPlayerDialog(playerid,DIALOG_REG2,DIALOG_STYLE_PASSWORD,"Account erstellen","Gib das Passwort für deinen Account ein:","OK","Abbrechen");
    }
    else
    {
    ShowPlayerDialog(playerid,DIALOG_REG,DIALOG_STYLE_MSGBOX,"Account","Du benötigst einen Account, um auf diesem Server zu spielen!","Erstellen","Abbrechen");
    }
    }
    if(dialogid == DIALOG_REG2)
    {
    if(response && strlen(inputtext) > 3)
    {
    OnPlayerRegister(playerid, inputtext);
    }
    else
    {
    ShowPlayerDialog(playerid,DIALOG_REG2,DIALOG_STYLE_PASSWORD,"Account erstellen","[FEHLER] Das Passwort muss min. 4 Zeichen haben.\nGib das Passwort für deinen Account ein:","OK","Abbrechen");
    }
    }




    if(dialogid == DIALOG_CHANGEPASS)
    {
    if(response)
    {
    if(PlayerInfo[playerid][pAdjustable] == 1)
    {
    if(strlen(inputtext) > 3)
    {
    new string22[128];
    format(string22, 128, "Du hast dein Passwort zu {FF1E00} %s {FFFFFF} geändert", inputtext);
    SendClientMessage(playerid, 0xFFFFFFFF, string22);
    mysql_SetString("accounts", "Passwort", inputtext, "Name", PlayerInfo[playerid][pIngameName]);
    mysql_SetInt("accounts", "PasswordHashed", 0, "Name", PlayerInfo[playerid][pIngameName]);
    return 1;
    }
    else SendClientMessage(playerid, 0xFFFFFFFF, "Dein Passwort muss mindestens 4 Zeichen lang sein.");
    }
    else
    {
    SendClientMessage(playerid,COLOR_RED,"Du kannst dein Passwort nicht ändern, da du nicht eingeloggt bist.");
    }
    }
    }





    public OnPlayerLogin(playerid,password[])
    {
    new string2[500];
    if(IsPlayerConnected(playerid))
    {
    GetPlayerName(playerid, PlayerInfo[playerid][pIngameName], 24);
    mysql_real_escape_string(PlayerInfo[playerid][pIngameName],PlayerInfo[playerid][pIngameName]);
    if(PlayerInfo[playerid][pPasswordHashed])
    {
    WP_Hash(string2,129,password);
    if(!strcmp(string2, mysql_ReturnPasswort(PlayerInfo[playerid][pIngameName]), true))
    {
    // Wird weiter ausgeführt
    }
    else
    {
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gebe dein Passwort bitte erneut ein:","Login","Abbrechen");
    gPlayerLogTries[playerid] += 1;
    if(gPlayerLogTries[playerid] == 4) { SetTimerEx("KickPublic", 500, 0, "d", playerid); }
    mysql_free_result();
    return 1;
    }
    }
    else if(!PlayerInfo[playerid][pPasswordHashed])
    {
    if(!strcmp(password, mysql_ReturnPasswort(PlayerInfo[playerid][pIngameName]), true))
    {
    // Wird weiter ausgeführt
    WP_Hash(PlayerInfo[playerid][pKey],129,password);
    mysql_SetString("accounts", "Passwort", PlayerInfo[playerid][pKey], "Name", PlayerInfo[playerid][pIngameName]);
    mysql_SetInt("accounts", "PasswordHashed", 1 , "Name", PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPasswordHashed] = 1;
    }
    else
    {
    ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Login","Gebe dein Passwort bitte erneut ein:","Login","Abbrechen");
    gPlayerLogTries[playerid] += 1;
    if(gPlayerLogTries[playerid] == 4) { SetTimerEx("KickPublic", 500, 0, "d", playerid); }
    mysql_free_result();
    return 1;
    }
    }
    else
    {
    return 1;
    }
    StopAudioStreamForPlayer(playerid);
    TextDrawHideForPlayer(playerid, newlogin0);
    TextDrawHideForPlayer(playerid, newlogin1);
    TextDrawHideForPlayer(playerid, newlogin2);
    TextDrawHideForPlayer(playerid, newlogin3);
    TextDrawHideForPlayer(playerid, newlogin4);
    TextDrawHideForPlayer(playerid, newlogin5);
    TextDrawHideForPlayer(playerid, newlogin6);
    TextDrawHideForPlayer(playerid, newlogin7);
    TextDrawHideForPlayer(playerid, newlogin8);
    TextDrawHideForPlayer(playerid, newlogin9);
    TextDrawHideForPlayer(playerid, newlogin10);
    format(query, sizeof(query),"SELECT * FROM `accounts` WHERE `Name` = '%s'", PlayerInfo[playerid][pIngameName]);
    mysql_query(query);
    mysql_store_result();
    PlayerInfo[playerid][pMySQLID] = mysql_GetIntByString("accounts", "id", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLevel] = mysql_GetIntByString("accounts", "Level", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLastMyCar] = mysql_GetIntByString("accounts", "LastMyCar", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pAdmin] = mysql_GetIntByString("accounts", "AdminLevel", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pMapper] = mysql_GetIntByString("accounts", "Mapper", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pSupporter] = mysql_GetIntByString("accounts", "Supporter", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pDonateRank] = mysql_GetIntByString("accounts", "DonatorRank", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pDonateZeit] = mysql_GetIntByString("accounts", "Donatorzeit", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][gPupgrade] = mysql_GetIntByString("accounts", "UpgradePunkte", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pReg] = mysql_GetIntByString("accounts", "Registriert", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pSex] = mysql_GetIntByString("accounts", "Geschlecht", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pOrigin] = mysql_GetIntByString("accounts", "Herkunft", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pMuted] = mysql_GetIntByString("accounts", "Gemuted", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pExp] = mysql_GetIntByString("accounts", "Respekt", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pCash] = mysql_GetIntByString("accounts", "Geld", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pAccount] = mysql_GetIntByString("accounts", "BankGeld", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pCrimes] = mysql_GetIntByString("accounts", "Verbrechen", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pKills] = mysql_GetIntByString("accounts", "Kills", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pDeaths] = mysql_GetIntByString("accounts", "Tode", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pArrested] = mysql_GetIntByString("accounts", "Eingesperrt", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pWantedDeaths] = mysql_GetIntByString("accounts", "WantedTode", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPhoneBook] = mysql_GetIntByString("accounts", "Telefonbuch", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pNavi] = mysql_GetIntByString("accounts", "Navi", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pBonusZeit] = mysql_GetIntByString("accounts", "BonusZeit", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pWerkzeugkasten] = mysql_GetIntByString("accounts", "Werkzeugkasten", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pBrille] = mysql_GetIntByString("accounts", "Brille", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLottoNr] = mysql_GetIntByString("accounts", "LottoNr", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pFishes] = mysql_GetIntByString("accounts", "Fische", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pBiggestFish] = mysql_GetIntByString("accounts", "GroeßterFisch", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pJob] = mysql_GetIntByString("accounts", "Job", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPayCheck] = mysql_GetIntByString("accounts", "PaydayCheck", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pJailed] = mysql_GetIntByString("accounts", "Jailed", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pJailTime] = mysql_GetIntByString("accounts", "Jailtime", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pATime] = mysql_GetIntByString("accounts", "Anwalttime", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pAR] = mysql_GetIntByString("accounts", "AnwaltReady", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLeader] = mysql_GetIntByString("accounts", "Leader", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pMember] = mysql_GetIntByString("accounts", "Member", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pFMember] = mysql_GetIntByString("accounts", "FMember", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pRank] = mysql_GetIntByString("accounts", "Rang", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pChar] = mysql_GetIntByString("accounts", "Skin", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pContractTime] = mysql_GetIntByString("accounts", "ContractZeit", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pDetSkill] = mysql_GetIntByString("accounts", "DetSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pSexSkill] = mysql_GetIntByString("accounts", "SexSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pBoxSkill] = mysql_GetIntByString("accounts", "BoxSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLawSkill] = mysql_GetIntByString("accounts", "AnwSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pMechSkill] = mysql_GetIntByString("accounts", "MechSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pJackSkill] = mysql_GetIntByString("accounts", "JackSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pCarSkill] = mysql_GetIntByString("accounts", "CarSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pDrugsSkill] = mysql_GetIntByString("accounts", "DrogenSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pCookSkill] = mysql_GetIntByString("accounts", "KochSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pFishSkill] = mysql_GetIntByString("accounts", "FischSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pFarmerSkill] = mysql_GetIntByString("accounts", "FarmerSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pTaschendiebSkill] = mysql_GetIntByString("accounts", "TaschendiebSkill", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][TDCooldown] = mysql_GetIntByString("accounts", "TDCooldown", "Name", PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pSHealth] = mysql_GetFloatByString("accounts", "pSHealth", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pHealth] = mysql_GetFloatByString("accounts", "pHealth", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pInt] = mysql_GetIntByString("accounts", "Interior", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLocal] = mysql_GetIntByString("accounts", "Local", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pTeam] = mysql_GetIntByString("accounts", "Team", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pModel] = mysql_GetIntByString("accounts", "Model", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPnumber] = mysql_GetIntByString("accounts", "TelefonNr", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPhousekey] = mysql_GetIntByString("accounts", "Haus", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPbiskey] = mysql_GetIntByString("accounts", "Biz", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pHandyGeld] = mysql_GetIntByString("accounts", "HandyGeld", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pHandyVer] = mysql_GetIntByString("accounts", "HandyVer", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pHartzIV] = mysql_GetIntByString("accounts", "ArbeitsGeld", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPos_x] = mysql_GetFloatByString("accounts", "Pos_x", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPos_y] = mysql_GetFloatByString("accounts", "Pos_y", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPos_z] = mysql_GetFloatByString("accounts", "Pos_z", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pCarLic] = mysql_GetIntByString("accounts", "AutoLizenz", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pFlyLic] = mysql_GetIntByString("accounts", "FlugLizenz", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pBoatLic] = mysql_GetIntByString("accounts", "BootLizenz", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pFishLic] = mysql_GetIntByString("accounts", "FischLizenz", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pGunLic] = mysql_GetIntByString("accounts", "WaffenLizenz", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLKWLic] = mysql_GetIntByString("accounts", "LKWLizenz", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pMotoLic] = mysql_GetIntByString("accounts", "MotorradLizenz", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pZig] = mysql_GetIntByString("accounts", "Zig", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPayDay] = mysql_GetIntByString("accounts", "PayDay", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPayDayHad] = mysql_GetIntByString("accounts", "PayDayHad", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pWins] = mysql_GetIntByString("accounts", "Wins", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLoses] = mysql_GetIntByString("accounts", "Loses", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pAlcoholPerk] = mysql_GetIntByString("accounts", "AlcoholPerk", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pDrugPerk] = mysql_GetIntByString("accounts", "DrugPerk", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pMiserPerk] = mysql_GetIntByString("accounts", "MiserPerk", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPainPerk] = mysql_GetIntByString("accounts", "PainPerk", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pTraderPerk] = mysql_GetIntByString("accounts", "TraderPerk", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pTut] = mysql_GetIntByString("accounts", "Tutorial", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pWarns] = mysql_GetIntByString("accounts", "Warnings", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pAdjustable] = mysql_GetIntByString("accounts", "Adjustable", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pFuel] = mysql_GetIntByString("accounts", "Fuel", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pMarried] = mysql_GetIntByString("accounts", "Verheiratet", "Name",PlayerInfo[playerid][pIngameName]);
    strmid(PlayerInfo[playerid][pMarriedTo], mysql_GetStringByString("accounts","MarriedTo","Name",PlayerInfo[playerid][pIngameName]), 0, 32, 255);
    SpawnChange[playerid] = mysql_GetIntByString("accounts", "SpawnChange", "Name",PlayerInfo[playerid][pIngameName]);
    WantedLevel[playerid] = mysql_GetIntByString("accounts", "WantedLevel", "Name",PlayerInfo[playerid][pIngameName]);
    WantedPoints[playerid] = mysql_GetIntByString("accounts", "WantedPoints", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPlayMinutes] = mysql_GetIntByString("accounts", "PlayMinutes", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pGesamtMinutes] = mysql_GetIntByString("accounts", "GesamtMinutes", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pSFPASS] = mysql_GetIntByString("accounts", "SFPASS", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLVPASS] = mysql_GetIntByString("accounts", "LVPASS", "Name",PlayerInfo[playerid][pIngameName]);
    OfflineFlucht[playerid] = mysql_GetIntByString("accounts", "Offflucht", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLPRunden] = mysql_GetIntByString("accounts", "LaufPrisonRunden", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pHandyID] = mysql_GetIntByString("accounts", "Handy", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pUhrID] = mysql_GetIntByString("accounts", "Uhr", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pOwnPerso] = mysql_GetIntByString("accounts", "Perso", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pFrakSperre] = mysql_GetIntByString("accounts", "FrakSperre", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pEventSperre] = mysql_GetIntByString("accounts", "EventSperre", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pHausWaffe] = mysql_GetIntByString("accounts", "HausWaffe", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pHausAmmu] = mysql_GetIntByString("accounts", "HausAmmu", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLaptop] = mysql_GetIntByString("accounts", "Laptop", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pBankkarte] = mysql_GetIntByString("accounts", "Bankkarte", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pBlacklist] = mysql_GetIntByString("accounts", "BlackFrak", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pMuteTime] = mysql_GetIntByString("accounts", "MuteTime", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pTimeBan] = mysql_GetIntByString("accounts", "TimeBan", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pStyle] = mysql_GetIntByString("accounts", "FightStyle", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pDutymarke] = mysql_GetIntByString("accounts", "Dutymarke", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pCoins] = mysql_GetIntByString("accounts", "Coins", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pGebannt] = mysql_GetIntByString("accounts", "Gebannt", "Name",PlayerInfo[playerid][pIngameName]);
    strmid(PlayerInfo[playerid][pBangrund], mysql_GetStringByString("accounts","Bangrund","Name",PlayerInfo[playerid][pIngameName]), 0, 128, 255);
    strmid(PlayerInfo[playerid][pPrisongrund], mysql_GetStringByString("accounts","Prisongrund","Name",PlayerInfo[playerid][pIngameName]), 0, 128, 255);
    strmid(PlayerInfo[playerid][pPrisonvon], mysql_GetStringByString("accounts","Prisonvon","Name",PlayerInfo[playerid][pIngameName]), 0, 32, 255);
    strmid(PlayerInfo[playerid][pGebanntvon], mysql_GetStringByString("accounts","Gebanntvon","Name",PlayerInfo[playerid][pIngameName]), 0, 32, 255);
    strmid(PlayerInfo[playerid][pKontack], mysql_GetStringByString("accounts","Kontackt","Name",PlayerInfo[playerid][pIngameName]), 0, 128, 255);
    PlayerInfo[playerid][pSavedDrugs] = mysql_GetIntByString("accounts", "SavedDrugs", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pSavedMats] = mysql_GetIntByString("accounts", "SavedMats", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPunkteLKW] = mysql_GetIntByString("accounts", "LKWPunkte", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPunkteAuto] = mysql_GetIntByString("accounts", "AutoPunkte", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPunkteBike] = mysql_GetIntByString("accounts", "BikePunkte", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPunkteSegel] = mysql_GetIntByString("accounts", "SegelPunkte", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPunkteFlug] = mysql_GetIntByString("accounts", "FlugPunkte", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPunkteGun] = mysql_GetIntByString("accounts", "GunPunkte", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPunktePBike] = mysql_GetIntByString("accounts", "PPaydayBike", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPunktePLKW] = mysql_GetIntByString("accounts", "PPaydayLKW", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPunktePAuto] = mysql_GetIntByString("accounts", "PPaydayAuto", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPunktePFlug] = mysql_GetIntByString("accounts", "PPaydayFlug", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPunktePSegel] = mysql_GetIntByString("accounts", "PPaydaySegel", "Name",PlayerInfo[playerid][pIngameName]);
    //PlayerInfo[playerid][pBomb] = mysql_GetIntByString("accounts", "Bomben", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pCodes] = mysql_GetIntByString("accounts", "HackerCodes", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pHelm] = mysql_GetIntByString("accounts", "Helm", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pPIN] = mysql_GetIntByString("accounts", "PINCode", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pNamechange] = mysql_GetIntByString("accounts", "Namechange", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pVersicherung] = mysql_GetIntByString("accounts", "Versicherung", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pKlingelTon] = mysql_GetIntByString("accounts", "KlingelTon", "Name",PlayerInfo[playerid][pIngameName]);

    PlayerInfo[playerid][pCarBuy] = mysql_GetIntByString("accounts", "CarBuy", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pFlyBuy] = mysql_GetIntByString("accounts", "FlyBuy", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pBoatBuy] = mysql_GetIntByString("accounts", "BoatBuy", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pFishBuy] = mysql_GetIntByString("accounts", "FishBuy", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pGunBuy] = mysql_GetIntByString("accounts", "GunBuy", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pLKWBuy] = mysql_GetIntByString("accounts", "LKWBuy", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pMotoBuy] = mysql_GetIntByString("accounts", "MotoBuy", "Name",PlayerInfo[playerid][pIngameName]);

    PlayerInfo[playerid][pHandyTalk] = mysql_GetIntByString("accounts", "HandyTalk", "Name",PlayerInfo[playerid][pIngameName]);
    PlayerInfo[playerid][pAdminAufgabe] = mysql_GetIntByString("accounts", "pAdminAufgabe", "Name",PlayerInfo[playerid][pIngameName]);
    //Hut System
    HutGekauft[playerid] = mysql_GetIntByString("accounts", "HutGekauft", "Name",PlayerInfo[playerid][pIngameName]);
    if(HutGekauft[playerid] == 1)
    {
    HutPos[playerid][3][hut] = mysql_GetIntByString("accounts", "Hut", "Name",PlayerInfo[playerid][pIngameName]);
    HutPos[playerid][3][hutX] = mysql_GetFloatByString("accounts","HutPosX", "Name",PlayerInfo[playerid][pIngameName]);
    HutPos[playerid][3][hutY] = mysql_GetFloatByString("accounts","HutPosY", "Name",PlayerInfo[playerid][pIngameName]);
    HutPos[playerid][3][hutZ] = mysql_GetFloatByString("accounts","HutPosZ", "Name",PlayerInfo[playerid][pIngameName]);
    HutPos[playerid][3][hutRotX] = mysql_GetFloatByString("accounts","HutRotX", "Name",PlayerInfo[playerid][pIngameName]);
    HutPos[playerid][3][hutRotY] = mysql_GetFloatByString("accounts","HutRotY", "Name",PlayerInfo[playerid][pIngameName]);
    HutPos[playerid][3][hutRotZ] = mysql_GetFloatByString("accounts","HutRotZ", "Name",PlayerInfo[playerid][pIngameName]);
    }


    // LoadUser(playerid);
    PlayerInfo[playerid][pAfk] = 0;
    warrived[playerid] = 0;
    mask[playerid] = 0;
    if(PlayerInfo[playerid][pSpeedoAktiv] == 0||PlayerInfo[playerid][pSpeedoAktiv] == 1){PlayerInfo[playerid][pSpeedoAktiv] = mysql_GetIntByString("accounts", "SpeedoAktiv", "Name",PlayerInfo[playerid][pIngameName]);}
    mysql_free_result();

    SetPlayerFightingStyle(playerid, PlayerInfo[playerid][pStyle]);



    {
    GetPlayerName(playerid, PlayerInfo[playerid][pIngameName],MAX_PLAYER_NAME);
    mysql_real_escape_string(PlayerInfo[playerid][pIngameName],PlayerInfo[playerid][pIngameName]);

    format(query, sizeof(query),"SELECT * FROM `accounts` WHERE `Name` = '%s'", PlayerInfo[playerid][pIngameName]);
    mysql_query(query);
    mysql_store_result();

    strmid(PlayerInfo[playerid][pKontack], mysql_GetStringByString("accounts","Kontackt","Name",PlayerInfo[playerid][pIngameName]), 0, 128, 255);
    PlayerInfo[playerid][pPasswordHashed] = mysql_GetIntByString("accounts", "PasswordHashed", "Name",PlayerInfo[playerid][pIngameName]);
    mysql_free_result();
    }

    15 Mal editiert, zuletzt von ShadowSura ()

  • Dann beschreibe bitte Schritt für Schritt was du eingibst bzw. machst.


    Wenn du nicht machst was man dir sagt kann man dir nicht helfen, und das Ganze verzögert sich. Du solltest schon zu dem Code sagen, was du machst und ab wann der Fehler auftritt.



    EDIT: Post unten:
    ShadowSura: Das ist schon gut so, das war was ich wollte. Den Code brauchst du nicht zu erklären, daß ist ja sinnlos. Ich werde mir es anschauen sobald ich Zeit habe (heute eher nicht).


    EDIT2:
    ShadowSura: Wird Sonntag oder Montag.






    EDIT3:
    User bekommt keine Hilfe mehr. Grund:
    http://pokit.org/get/img/47230…357e78846f8d1c498aac9.jpg

    3HZXdYd.png

    3 Mal editiert, zuletzt von Jeffry ()

  • Ja also
    Schritt
    1.Wenn ich account erstelle
    2.Danach wenn ich server neustarte
    3.Wird das passwort einfach so geändert
    4.Das passwort wird zur NULL in mysql
    5.Wenn ich in game ein loggen will steht da falsches passwort wo ich mein account erstellt habe danach hab ich es mit NULL versucht dann hat es geklappt aber wenn jetzt jeder user sowas macht hat ja jeder das passwort NULL aber das will ich ja ebend nicht ich will das es zb shadow123 wird und nicht so ein gehashdes oder NULL


  • NEIN, NEIN, NEIN..!
    Du hast es falsch verstanden.. Deinen InGame Ablauf haben wir ja schon im großen und ganzen verstanden, aber deinen Scripting Ablauf sollst du genau beschreiben, damit wir z.B. wissen, wann was aufgerufen wird.


    LG lolcooper

  • do.de - Domain-Offensive - Domains für alle und zu super Preisen