[PROBLEM]Mit MYSQL

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

Was genau soll ich Hochladen?? Da steht zu viel drinn

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;
}

Manne habe dir mein Skype namen geschrieben, adde mich mal bitte und du kannst es dir ankucken ich komme mit mysql echt nicht so gut klaar^^

Zitat von [NGD]Manne

Poste den Code lieber hier, http://pastebin.com/ .
So können andere Personen dir hier auch helfen

Das Problem ist, ich weiss nicht genau was ich Posten soll das ich mein Problem ...

Hat sich erledigt

//close