[PROBLEM]Mit MYSQL

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
  • Guten Abend,


    Undzwar habe ich folgendes Problem, wenn ich ins Game reingehe und mir ein Account erstelle, wird es nicht gespeichert.
    Sobald ich raus gehe und wieder rein Ingame muss ich mich von vorne Registrieren.
    Zudem habe ich noch ein Problem, wenn ich bestimmte Zeilen aus dem Script nicht Deaktiviere kann ich garnicht rein
    sonder ich bekomme die ganze Zeit eine Meldung das der Account gespeert sei (retsälhaft denn es werden keine Accounts erstellt.)


    Kann mir bitte jemand Weiterhelfen??


    Ich bedanke mich für jede Naricht im vorraus.






    Mfg


    Denis_Denovski

  • Zeige uns mal deine mysql.log, sofern vorhanden.
    Nützlich wären auch die Codes vom Registrieren, wo du versuchst den Spieler in die Datenbank einzutragen.

  • Lade doch mal die mysql.log bei Pastebin rauf und poste den Link hier.
    Alternativ die letzten paar hundert Zeilen.



    Und dann auch mal den Code vom Registrieren / Login, sowie den Code vom mysql_connect (Passwörter bitte mit * ersetzen)

    Mit freundlichem Gruß
    Weper

  • public OnPlayerConnect(playerid)
    {
    L_AntiWeaponHack(playerid);
    PlayAudioStreamForPlayer(playerid, "http://www.gdr-rp.de/Musik/Startscreen.mp3");
    Load_Player(playerid);
    if(ServerStarterBots == 0 && !IsPlayerNPC(playerid))
    {
    SendClientMessage(playerid, COLOR_YELLOW, "Die Serverbots sind noch nicht geladen! Bitte warten Sie bis alle Bots verbunden sind!");
    SendClientMessage(playerid, COLOR_YELLOW, "Du wurdest nun vom Server getrennt!");
    SetTimerEx("ConnectKick", 10,0,"i",playerid);
    return 1;
    }
    return 1;
    }

  • stock Load_Player(playerid) {
    SetPlayerColor(playerid, COLOR_GRAD1);
    new playername[MAX_PLAYER_NAME];
    GetPlayerName(playerid, playername, sizeof(playername));
    PlayerInfo[playerid][pModel] = 264;
    SetPlayerSkillLevel(playerid, WEAPONSKILL_PISTOL_SILENCED, 500);
    SetPlayerSkillLevel(playerid, WEAPONSKILL_PISTOL, 500);
    SetPlayerSkillLevel(playerid, WEAPONSKILL_MICRO_UZI, 1);
    //SetPlayerSkillLevel(playerid, WEAPONSKILL_DESERT_EAGLE, 1);
    AddPlayer(playerid);
    gPlayerLogged[playerid] = 0;
    new playerip[256];
    GetPlayerIp(playerid,playerip,sizeof(playerip));
    strmid(PlayerInfo[playerid][pUserIP], playerip, 0, strlen(playerip), 255);
    Logintime[playerid] = -1;
    Streamer_OnPlayerConnect(playerid);
    if(!IsPlayerNPC(playerid))
    {
    UsersOnline++;
    }
    TextDrawHideForPlayer(playerid,DrawMaske);
    TextDrawHideForPlayer(playerid,Adminduty);
    TextDrawShowForPlayer(playerid, Text:UhrzeitStundeMinute);
    TextDrawShowForPlayer(playerid, Text:DatumTagMonat);
    TextDrawHideForPlayer(playerid,NODMZoneTextdraw);
    TextDrawHideForPlayer(playerid,TicketsTextdraw);
    TextDrawHideForPlayer(playerid,TeamDMDraw);
    TextDrawShowForPlayer(playerid,Website);
    TextDrawShowForPlayer(playerid,Version);
    TextDrawHideForPlayer(playerid,SpawnKill);
    MaxVeh[playerid] = 3;
    CarKey[playerid] = 0;
    for(new i = 0; i < MAX_PLAYERS; i++)
    {
    WantedLabel[playerid][i] = -1;
    }
    gPlayerUsingLoopingAnim[playerid] = 0;
    gPlayerAnimLibsPreloaded[playerid] = 0;
    PortedTimer[playerid] = 0;


    SetPVarInt(playerid, "PVTeam", -1);
    SetPVarInt(playerid, "PVAdmin", 0);
    SetPVarInt(playerid, "PVJob", 0);
    for(new i = 0; i < 47; i++)
    {
    BuyedWeapons[playerid][i] = 0;
    }
    BuyedWeapons[playerid][0] = 50;
    BuyedWeapons[playerid][2] = 50;
    BuyedWeapons[playerid][46] = 50;
    //UserHealth[playerid] = 0.0;
    //UserArmour[playerid] = 0.0;
    FirstSpawnAfterLogin[playerid] = 0; PlayerInfo[playerid][pIsearch] = 0;
    SetPlayerWorldBounds(playerid, 20000.0000,-20000.0000,20000.0000,-20000.0000);
    CellTime[playerid] = 0; Mobile[playerid] = -1; RingTone[playerid] = 0; Uberweisungsid[playerid] = -1; Tot[playerid] = 0; SelectChar[playerid] = 0; HidePM[playerid] = 0; PhoneOnline[playerid] = 0;
    SelectCharID[playerid] = 0; SelectCharPlace[playerid] = 0; ChosenSkin[playerid] = 0; GettingJob[playerid] = 0; AllowTune[playerid] = -1;
    RobTimer[playerid] = -1; AntiRobTimer[playerid] = 0; TeamRadar[playerid] = 0; BNDRadar[playerid] = 0; MullManOwned[playerid] = -1; ServerTutCP[playerid] = 0;
    CallLawyer[playerid] = 0; WantLawyer[playerid] = 0; NoDmTimer[playerid] = 0; NoDmWarnungen[playerid] = 0; UsedFind[playerid] = 0; Eisgekauft[playerid] = 0;
    CP[playerid] = 0; MoneyMessage[playerid] = 0; Condom[playerid] = 0; HitSound[playerid] = 1; //ACode[playerid] = 0;
    STDPlayer[playerid] = 0; SexOffer[playerid] = 999; SexPrice[playerid] = 0; SexOn[playerid] = -1; SexTime[playerid] = -1; RepairOffer[playerid] = -1; RepairPrice[playerid] = 0;
    VertragOffer[playerid] = -1; Supportercar[playerid] = -1; TalkingLive[playerid] = 255; LiveOffer[playerid] = 999; HealProds[playerid] = 0; KitPrice[playerid] = -1;
    LessonOffer[playerid] = -1; LessonPrice[playerid] = 0; TakingLesson[playerid] = 0; Bergwerkarbeit[playerid] = 0; RefillOffer[playerid] = -1; RefillPrice[playerid] = 0; MapIconsShown[playerid] = 0;
    HotdogOffer[playerid] = -1; HotdogPrice[playerid] = 0; HealPrice[playerid] = -1; PlayerHeal[playerid] = -1; HealOffer[playerid] = -1; BlowJob[playerid] = -1; KitOffer[playerid] = -1;
    UnDrugs[playerid] = 0; PlayerCuffed[playerid] = 0; PlayerCuffedTime[playerid] = 0; PlayerTied[playerid] = 0; Detektivschutz[playerid] = 0;
    RegistrationStep[playerid] = 0; ConnectedToPC[playerid] = 0; JailPrice[playerid] = 0; MedicBill[playerid] = -1; MedicBillTimer[playerid] = -1; LoginTimer[playerid] = -1; Handyraubtimer[playerid] = -1; GoChase[playerid] = -1; ContractTaked[playerid] = 0; Maske[playerid] = 0; OrderReady[playerid] = 0; PlacedNews[playerid] = 0; OnDuty[playerid] = 0; TestFishes[playerid] = 0; EventEingeladen[playerid] = 0; TransportDuty[playerid] = 0;
    BusCallTime[playerid] = 0; TaxiCallTime[playerid] = 0; MedicAccepted[playerid] = -1; WhelAccepted[playerid] = -1; MechanicCallTime[playerid] = 0; JulianPoints[playerid] = 0; FindTimePoints[playerid] = 0; JulianTime[playerid] = 0; FindTime[playerid] = 0; JobDuty[playerid] = 0; Mobile[playerid] = -1; Music[playerid] = 0;
    Spectate[playerid] = -1; PlayerDrunkTime[playerid] = 0; WheelmanAccepted[playerid] = -1; HaveDonuts[playerid] = 0; EatDonutAktive[playerid] = 0; PilotenDuty[playerid] = 0;
    gLastCar[playerid] = 0; WantedLoseAllow[playerid] = 0; SpawnKillAktiv[playerid] = 0; gOoc[playerid] = 0; gNews[playerid] = 0; BigEar[playerid] = 0; gDice[playerid] = 0; gFam[playerid] = 0; TogAdminChat[playerid] = 0; TogLoginLogout[playerid] = 1; TogAdminMessage[playerid] = 1;
    gPlayerLogTries[playerid] = 0; gPlayerAccount[playerid] = 0; PlayerKarting[playerid] = 0; PlayerInKart[playerid] = 0; PlayerTazeTime[playerid] = 0; PlayerStoned[playerid] = 0; PlayerStonedTime[playerid] = 0;
    TicketOffer[playerid] = 999; TicketMoney[playerid] = 0; CodesHolding[playerid] = 0; TazerCan[playerid] = 0;
    MatsHolding[playerid] = 0; gPlayerMission[playerid] = 0; TaxiAccepted[playerid] = 999; BusAccepted[playerid] = 999; PlayerInfo[playerid][pCash] = 0; Blitzed[playerid] = 0;
    TransportValue[playerid] = 0; TransportMoney[playerid] = 0; WTransportMoney[playerid] = 0; TransportTime[playerid] = 0; TransportCost[playerid] = 0; TransportDriver[playerid] = 999;
    PlayerPaintballing[playerid] = 0; PlayerTeamPaintballing[playerid] = 0; PlayerPaintballKills[playerid] = 0; Fishes[playerid][pLastFish] = 0; Fishes[playerid][pFishID] = 0;
    FallAngenommen[playerid] = -1; FallAngenommenTimer[playerid] = 0; FallAngenommenAnwalt[playerid] = -1;
    ProposeOffer[playerid] = 999; MarryWitness[playerid] = 999; MarryWitnessOffer[playerid] = 999; MarriageCeremoney[playerid] = 0; ProposedTo[playerid] = 999; GotProposedBy[playerid] = 999; DivorceOffer[playerid] = 999; TotenOffer[playerid] = 999; InviteOffer[playerid] = -1; InviteTeam[playerid] = -1;
    AntiAFKCode[playerid] = 0; AntiAFKTime[playerid] = 0; AntiAFKTimer[playerid] = 0; AFKChecker[playerid] = -1; InviteOrgOffer[playerid] = -1; InviteOrgTeam[playerid] = -1;
    Kleidungsshop[playerid] = -1; AFKKick[playerid] = 0; PlayerInfo[playerid][pJoinhaben] = 0;
    AFKModus[playerid] = 0; AntiSpamWarns[playerid] = 0; AntiSpamTime[playerid] = 0;
    JobFreeze[playerid] = 300; Weedkaufen[playerid] = 500; HotdogTime[playerid] = 0; //HotdogLager[playerid] = 0;
    TicketSys[playerid][TSAdminID] = -1; PlayerInfo[playerid][pLKWLic] = 0;
    TicketSys[playerid][TSUserID] = -1; PlayerInfo[playerid][CurrentPos][0] = 0; PlayerInfo[playerid][CurrentPos][1] = 0; PlayerInfo[playerid][CurrentPos][2] = 0;
    strmid(TicketSys[playerid][TSText], "------", 0, strlen("------"), 255);
    WantedHackZeit[playerid] = -1; HackArt[playerid] = 0; WantedHackKunde[playerid] = -1;


    HackAnzahl[playerid] = 0;
    DrugOffer[playerid] = 999;
    DrugPrice[playerid] = 0;
    DrugGram[playerid] = 0;
    bietetAn[playerid]={-1,0};
    GivePlayerMoneys(playerid,PlayerInfo[playerid][pCash]); PlayerInfo[playerid][pBerg] = 0; PlayerInfo[playerid][pWarimVersteck] = 0; PlayerInfo[playerid][pAufgabe1] = 0; PlayerInfo[playerid][pHatschon] = 0; PlayerInfo[playerid][pSchongeandert] = 0;
    PlayerInfo[playerid][pKrankenkasse] = 0; PlayerInfo[playerid][pKrankenkasseTime] = 0; PlayerInfo[playerid][pZigarette] = 0; PlayerInfo[playerid][pHatschon1] = 0;
    PlayerInfo[playerid][pAuftrag1] = 0; PlayerInfo[playerid][pAuftrag2] = 0; PlayerInfo[playerid][pAuftrag3] = 0; PlayerInfo[playerid][pAuftrag4] = 0; PlayerInfo[playerid][pAuftrag5] = 0; PlayerInfo[playerid][pAuftrag6] = 0; PlayerInfo[playerid][pAuftrag7] = 0; PlayerInfo[playerid][pAuftrag8] = 0; PlayerInfo[playerid][pAuftrag9] = 0;
    PlayerInfo[playerid][pLevel] = 0; PlayerInfo[playerid][pAdmin] = 0; PlayerInfo[playerid][pStartbonus] = 0; PlayerInfo[playerid][pKreditkartebenutzen] = 0; PlayerInfo[playerid][pKreditkarte] = 0; PlayerInfo[playerid][pGebDatum] = 0; PlayerInfo[playerid][pPersonalausweis] = 0;
    PlayerInfo[playerid][pGewaschen] = 0; PlayerInfo[playerid][pAndreasLohn] = 0; PlayerInfo[playerid][pKartoffelnhaben] = 0; PlayerInfo[playerid][pKartoffelwaschen] = 0; PlayerInfo[playerid][pGehalt] = 0; PlayerInfo[playerid][pBanned] = 0; PlayerInfo[playerid][pGeldsack] = 0; PlayerInfo[playerid][pSchwul] = 0; PlayerInfo[playerid][pVerwarnung] = 0;
    PlayerInfo[playerid][sPfandflaschen] = 0; PlayerInfo[playerid][pJonnysagt] = 0; PlayerInfo[playerid][pAlexsagt] = 0; PlayerInfo[playerid][pGuntersagt] = 0; PlayerInfo[playerid][pDrogenSamen] = 0;
    PlayerInfo[playerid][pSchlagen] = 0; PlayerInfo[playerid][pBrecheisen] = 0; PlayerInfo[playerid][pReingegangen] = 0; PlayerInfo[playerid][pRausgegangen] = 0; PlayerInfo[playerid][pWheelmangerufen] = 0; PlayerInfo[playerid][pMedickit] = 0;
    PlayerInfo[playerid][pDonatorRank] = 0; PlayerInfo[playerid][gPupgrade] = 0; PlayerInfo[playerid][pConnectTime] = 0; PlayerInfo[playerid][pReg] = 0; PlayerInfo[playerid][pSex] = 0; PlayerInfo[playerid][pMeldunggekommen] = 0;
    PlayerInfo[playerid][pAlter] = 0; PlayerInfo[playerid][pOrigin] = 0; PlayerInfo[playerid][pRespekt] = 0; PlayerInfo[playerid][pBank] = 0; PlayerInfo[playerid][pCrimes] = 0;
    PlayerInfo[playerid][pDeaths] = 0; PlayerInfo[playerid][pArrested] = 0; PlayerInfo[playerid][pArrestTime] = 0; PlayerInfo[playerid][pPhoneBook] = 0;
    PlayerInfo[playerid][pLottoNr] = 0; PlayerInfo[playerid][pFishes] = 0; PlayerInfo[playerid][pBiggestFish] = 0; PlayerInfo[playerid][pJob] = 0; PlayerInfo[playerid][pPayCheck] = 0; PlayerInfo[playerid][pHeadValue] = 0;
    PlayerInfo[playerid][pJailed] = 0; PlayerInfo[playerid][pJailTime] = 0; PlayerInfo[playerid][pMats] = 0; PlayerInfo[playerid][pCodes] = 0; PlayerInfo[playerid][pSaveMats] = 0; PlayerInfo[playerid][pSaveCodes] = 0;
    PlayerInfo[playerid][pDrugs] = 0;PlayerInfo[playerid][pSaveDrugs] = 0; PlayerInfo[playerid][pLeader] = -1; PlayerInfo[playerid][pMember] = -1; PlayerInfo[playerid][pRank] = 0;
    PlayerInfo[playerid][pVertragszeit] = 5; PlayerInfo[playerid][pDetSkill] = 0; PlayerInfo[playerid][pSexSkill] = 0; PlayerInfo[playerid][pAnwaltSkill] = 0;
    PlayerInfo[playerid][pMechSkill] = 0; PlayerInfo[playerid][pJackSkill] = 0; PlayerInfo[playerid][pCarSkill] = 0; PlayerInfo[playerid][pNewsSkill] = 0; PlayerInfo[playerid][pDrugsSkill] = 0;
    PlayerInfo[playerid][pCookSkill] = 0; PlayerInfo[playerid][pFishSkill] = 0; PlayerInfo[playerid][pSHealth] = 50.0; PlayerInfo[playerid][pLocal] = -1; PlayerInfo[playerid][pMuted] = 0; PlayerInfo[playerid][pCoints] = 0; PlayerInfo[playerid][pGeiselnahme] = 0; Geiselnahme[playerid] = -1;
    PlayerInfo[playerid][pBoatLic] = 0; PlayerInfo[playerid][pFishLic] = 0; PlayerInfo[playerid][pGunLic] = 0;
    PlayerInfo[playerid][pCarLicPoints] = 0; PlayerInfo[playerid][pBikeLicPoints] = 0; PlayerInfo[playerid][pZollpass] = 0; PlayerInfo[playerid][pGun1] = 0; PlayerInfo[playerid][pGun2] = 0; PlayerInfo[playerid][pGun3] = 0;
    PlayerInfo[playerid][pGun4] = 0; PlayerInfo[playerid][pAmmo1] = 0; PlayerInfo[playerid][pAmmo2] = 0; PlayerInfo[playerid][pAmmo3] = 0; PlayerInfo[playerid][pAmmo4] = 0;
    PlayerInfo[playerid][pCarTime] = 0; PlayerInfo[playerid][pPayDay] = 0; PlayerInfo[playerid][pPayDayHad] = 0; PlayerInfo[playerid][pCDPlayer] = 0; PlayerInfo[playerid][pAlcoholPerk] = 0; PlayerInfo[playerid][pTeam] = -1; PlayerInfo[playerid][pNummer] = 0; PlayerInfo[playerid][pPhousekey] = -1;
    PlayerInfo[playerid][pPhotelkey] = -1; PlayerInfo[playerid][pBizKey] = -1; PlayerInfo[playerid][pCarLic] = 0; PlayerInfo[playerid][pFlyLic] = 0;
    PlayerInfo[playerid][pPainKillerPerk] = 0; PlayerInfo[playerid][pDrugPerk] = 0; PlayerInfo[playerid][pMiserPerk] = 0; PlayerInfo[playerid][pTraderPerk] = 0;
    PlayerInfo[playerid][pWarns] = 0;PlayerInfo[playerid][pFuel] = 0; PlayerInfo[playerid][pWantedLevel] = 0; PlayerInfo[playerid][pAdminOnDuty] = 0; PlayerInfo[playerid][pHurensohn] = 0; PlayerInfo[playerid][pHandyRob] = 0; PlayerInfo[playerid][pBankrob] = 0;
    PlayerInfo[playerid][pInviteSperre] = 0; PlayerInfo[playerid][pWarnTime1] = 0; PlayerInfo[playerid][pWarnTime2] = 0; PlayerInfo[playerid][pImRaub] = 0; PlayerInfo[playerid][pTicketsopen] = 0; PlayerInfo[playerid][pSQLID] = -1;
    PlayerInfo[playerid][pRolex] = 0; PlayerInfo[playerid][pSwissonic] = 0; PlayerInfo[playerid][pCasio] = 0; PlayerInfo[playerid][pBreitling] = 0; PlayerInfo[playerid][pNixon] = 0; PlayerInfo[playerid][pIceWatch] = 0;
    strmid(PlayerInfo[playerid][pWerberName], "Niemand", 0, strlen("Niemand"), 255);
    strmid(PlayerInfo[playerid][pNODMKiller], "Niemand", 0, strlen("Niemand"), 255);
    strmid(PlayerInfo[playerid][pForceName], "Niemand", 0, strlen("Niemand"), 255);
    strmid(PlayerInfo[playerid][pOldName], "Niemand", 0, strlen("Niemand"), 255);
    strmid(PlayerInfo[playerid][pOrgaName], "Keine", 0, strlen("Keine"), 255);
    PlayerInfo[playerid][pOrgaID] = -1;
    PlayerInfo[playerid][pOrgaLeader] = -1;
    PlayerInfo[playerid][pOrgaManager] = -1;
    PlayerInfo[playerid][pTut] = 0;
    PlayerInfo[playerid][pTruckHaengerID] = -1;
    PlayerInfo[playerid][pTHProdukte] = 0;
    PlayerInfo[playerid][pDonatorZeit] = 0;
    PlayerInfo[playerid][pFightingStyle] = 0;
    PlayerInfo[playerid][pHandy] = 0;
    PlayerInfo[playerid][pStartCoints] = 0;
    PlayerInfo[playerid][pOnDutySkin] = 60;
    PlayerInfo[playerid][pAllowed] = 0;
    PlayerInfo[playerid][pSpawnheal] = 0;
    PlayerInfo[playerid][pDeaglespawn] = 0;
    PlayerInfo[playerid][pM4Spawn] = 0;
    PlayerInfo[playerid][pMP5Spawn] = 0;
    PlayerInfo[playerid][pArmorSpawn] = 0;
    PlayerInfo[playerid][pMehrZinsen] = 0;
    PlayerInfo[playerid][pSpawnhealZeit] = 0;
    PlayerInfo[playerid][pDeaglespawnZeit] = 0;
    PlayerInfo[playerid][pM4SpawnZeit] = 0;
    PlayerInfo[playerid][pMP5SpawnZeit] = 0;
    PlayerInfo[playerid][pArmorSpawnZeit] = 0;
    PlayerInfo[playerid][pMehrZinsenZeit] = 0;


    ClearCrime(playerid);
    ClearFishes(playerid);
    ClearCooking(playerid);
    ClearGroceries(playerid);
    Santa[playerid] = 0;
    ClearMarriage(playerid);
    //Car System//
    for(new h = 0; h < MaxVeh[playerid]; h++){
    Carlist[playerid][h][Typ]=-1;
    Carlist[playerid][h][pos_x]=0.0;
    Carlist[playerid][h][pos_y]=0.0;
    Carlist[playerid][h][pos_z]=0.0;
    Carlist[playerid][h][z_angle]=0.0;
    Carlist[playerid][h][Status]=0;
    Carlist[playerid][h][Lock]=0;
    Carlist[playerid][h][Carid]=-1;
    Carlist[playerid][h][Farbe1]=-1;
    Carlist[playerid][h][Farbe2]=-1;
    Carlist[playerid][h][mod1]=-1;
    Carlist[playerid][h][mod2]=-1;
    Carlist[playerid][h][mod3]=-1;
    Carlist[playerid][h][mod4]=-1;
    Carlist[playerid][h][mod5]=-1;
    Carlist[playerid][h][mod6]=-1;
    Carlist[playerid][h][mod7]=-1;
    Carlist[playerid][h][mod8]=-1;
    Carlist[playerid][h][mod9]=-1;
    Carlist[playerid][h][mod10]=-1;
    Carlist[playerid][h][mod11]=-1;
    Carlist[playerid][h][mod12]=-1;
    Carlist[playerid][h][mod13]=-1;
    Carlist[playerid][h][mod14]=-1;
    Carlist[playerid][h][mod15]=-1;
    Carlist[playerid][h][mod16]=-1;
    Carlist[playerid][h][mod17]=-1;
    Carlist[playerid][h][Paintjob]=-1;
    Carlist[playerid][h][OwnerID] = playerid;
    Carlist[playerid][h][SpawnSaveX]=0.0;
    Carlist[playerid][h][SpawnSaveY]=0.0;
    Carlist[playerid][h][SpawnSaveZ]=0.0;
    Carlist[playerid][h][SpawnSaveRot]=0.0;
    Carlist[playerid][h][TankVolumen]=0;
    Carlist[playerid][h][RepairTime] = 0;
    Carlist[playerid][h][Versicherung] = 0;
    Carlist[playerid][h][StandTime] = 0;
    Carlist[playerid][h][Meter] = 0;
    Spectating[playerid] = -1;
    }
    for(new i = 0; i < MaxUberweisung; i++)
    {
    strmid(Uberweisungen[playerid][i], "Keine Überweisung Vorhanden", 0, strlen("Keine Überweisung Vorhanden"), 255);
    }
    if(IsPlayerNPC(playerid))
    {
    gPlayerAccount[playerid] = 1;
    gPlayerLogged[playerid] = 1;
    if(strcmp(playername, "Hartmut", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 5;
    SetPlayerSkin(playerid, 5);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "Alex", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 159;
    SetPlayerSkin(playerid, 159);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "Roberto", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 28;
    SetPlayerSkin(playerid, 28);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "Jonny", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 33;
    SetPlayerSkin(playerid, 33);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "Stadthalle", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 11;
    SetPlayerSkin(playerid, 11);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "Andreas", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 158;
    SetPlayerSkin(playerid, 158);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "MrHillman", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 294;
    SetPlayerSkin(playerid, 294);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "Mitarbeiter", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 187;
    SetPlayerSkin(playerid, 187);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "Gunter", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 29;
    SetPlayerSkin(playerid, 29);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "Busbot", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 6;
    SetPlayerSkin(playerid, 6);
    SpawnPlayer(playerid);
    }
    /*if(strcmp(playername, "Prodbot", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 6;
    SetPlayerSkin(playerid, 6);
    SpawnPlayer(playerid);
    }*/
    if(strcmp(playername, "Eiswagenbot", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 264;
    SetPlayerSkin(playerid, 264);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "DrogenBot", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 6;
    SetPlayerSkin(playerid, 6);
    SpawnPlayer(playerid);
    }
    /*if(strcmp(playername, "TruckerBot", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 6;
    SetPlayerSkin(playerid, 6);
    SpawnPlayer(playerid);
    }*/
    if(strcmp(playername, "BusStadtBot", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 6;
    SetPlayerSkin(playerid, 6);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "BusbotBank", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 6;
    SetPlayerSkin(playerid, 6);
    SpawnPlayer(playerid);
    }
    /*if(strcmp(playername, "Penner1", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 79;
    SetPlayerSkin(playerid, 79);
    SpawnPlayer(playerid);
    }
    if(strcmp(playername, "Penner2", true) == 0)
    {
    PlayerInfo[playerid][pChar] = 137;
    SetPlayerSkin(playerid, 137);
    SpawnPlayer(playerid);
    }*/
    return 1;
    }
    new plrIP[16];
    GetPlayerIp(playerid, plrIP, sizeof(plrIP));
    if(strcmp(plrIP, "Bald verfügbar", false) != 0)
    {
    PlayerInfo[playerid][pChar] = 101;
    }
    if(strcmp(plrIP, "Bald verfügbar", true) == 0)
    {
    new string[258];
    if(!mysql_CheckAccount(playerid))
    {
    format(string, sizeof(string), "INSERT INTO `users` (`Name`) VALUES ('%s')", playername);
    self_mysql_queryEx(string);
    }
    PlayerInfo[playerid][pChar] = 1;
    new Level = random(20) + 1;
    SpawnPlayer(playerid);
    SetPlayerScore(playerid, Level);
    format(string, sizeof(string), " %s [ID: %d] hat den Server betreten.",playername, playerid);
    ForAllPlayers(i){
    if(IsPlayerConnected(i)){
    if(TogLoginLogout[i] == 0){
    SendClientMessage(i, COLOR_LIGHTGREEN, string); //Connect message
    }}}
    if(AdminIPClose == 0 || TogAdminMessage[playerid] == 0)
    {
    new test = random(20);
    if(test == 1)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 89.245.118.196 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 2)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 84.46.53.82 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 3)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 93.230.37.105 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 4)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 91.13.195.216 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 5)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 178.3.201.88 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 6)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 188.100.136.156 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 7)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 93.229.252.22 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 8)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 92.106.154.84 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 9)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 87.163.107.168 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 10)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 88.76.228.87 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 11)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 91.96.54.80 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 12)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 178.10.34.72 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 13)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 87.187.88.45 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 14)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 93.229.252.22 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 15)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 91.97.87.229 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 16)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 91.97.87.229 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 17)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 79.224.170.37 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 18)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 87.187.88.45 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 19)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 109.192.194.5 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    if(test == 20)
    {
    format(string, sizeof(string), "AdmCmd: Spieler %s hat sich mit der IP: 79.245.131.65 eingeloggt!",playername);
    SendAdminMessage(COLOR_LIGHTRED, 1, string);
    }
    }
    }
    // Check beim beim Connecten
    new str[256], name[MAX_PLAYER_NAME], hwd[128];
    gpci(playerid, hwd, sizeof hwd);
    GetPlayerName(playerid, name, sizeof name);
    mysql_real_escape_string(name, name);
    format(str, sizeof str, "SELECT * FROM `hwdban` WHERE `Hardware`='%s'", hwd);
    mysql_query(str);
    mysql_store_result();
    if(mysql_num_rows())
    {
    //Hardware Ban ist aktiv
    ShowPlayerMarkers(400);
    SetSpawnInfo(playerid,0,299,0,0,0,0,0,0,0,0,0,0);
    LoginTimer[playerid] = SetTimerEx("julianistgeil",20000,0,"i",playerid);
    TogglePlayerControllable(playerid,0);
    SetTimerEx("SetConnectHWDBan",200,0,"i",playerid);
    StopAudioStreamForPlayer(playerid);
    }
    new VAR = 0,TextString[123];
    new BanHammer[128], BanReason[128], BPZeit;
    SetPlayerColor(playerid, COLOR_GRAD2);
    format(TextString, sizeof(TextString), "SELECT * FROM `bannedplayers` WHERE `Name`='%s'", playername);
    self_mysql_queryEx(TextString);
    mysql_store_result(MySQLConnection);
    if(mysql_num_rows(MySQLConnection) != 0)
    {
    mysql_fetch_row_format(TextString);
    new val[256];
    self_mysql_get_field("Reason", val); strmid(BanReason, val, 0, strlen(val), 255);
    self_mysql_get_field("Hammer", val); strmid(BanHammer, val, 0, strlen(val), 255);
    self_mysql_get_field("Time", val); BPZeit = strval( val );
    if(BPZeit != -1)
    {
    if(BPZeit > Time())
    {
    VAR = 1;
    }
    else
    {
    format(TextString, sizeof(TextString), "DELETE FROM `bannedplayers` WHERE `Name`='%s'", playername);
    self_mysql_queryEx(TextString);
    VAR = 0;
    }
    }
    else
    {
    VAR = 1;
    }
    if(VAR == 1)
    {
    if(BPZeit == -1)
    {
    ShowPlayerMarkers(400);
    SetSpawnInfo(playerid,0,299,0,0,0,0,0,0,0,0,0,0);
    LoginTimer[playerid] = SetTimerEx("julianistgeil",20000,0,"i",playerid);
    TogglePlayerControllable(playerid,0);
    SetTimerEx("SetConnectBan",200,0,"i",playerid);
    StopAudioStreamForPlayer(playerid);
    return 1;
    }
    else
    {
    ShowPlayerMarkers(400);
    SetSpawnInfo(playerid,0,299,0,0,0,0,0,0,0,0,0,0);
    LoginTimer[playerid] = SetTimerEx("julianistgeil",20000,0,"i",playerid);
    TogglePlayerControllable(playerid,0);
    SetTimerEx("SetConnectTimeBan",200,0,"i",playerid);
    StopAudioStreamForPlayer(playerid);
    return 1;
    }
    }
    }
    return 1;
    }

  • Ich suche eigentlich den Teil, welcher ausgeführt wird, wenn du dich registriert hast ;)
    Ggf. deine MySQL-log posten ;)