Probleme bei einem Script

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 Tag liebes Breadfish!
    Ich hab 3 Probleme bei dem Script Pure Roleplay :)
    Hoffe ihr könnt mir Helfen. :/


    Das erste wäre das wenn ein User reloggt oder nächsten Tag auf den Server kommt das da steht: "Er besitzt kein Konto mehr" er hatte aber eins


    Das zweite wäre das wenn man reloggt der Payday wieder auf 0 steht.


    Das dritte wäre wenn man reloggt dann hat man ein CJ Skin und eine BHD mütze auf :D


    if(strcmp(text,"Bankkonto",true) == 0)
    {
    new bankpin = random(8000) + random(1000);
    if(!IsPlayerInRangeOfPoint(playerid,2,1482.3273,-1005.3770,26.8159) && GetPlayerVirtualWorld(playerid) == 1)
    {
    SendClientMessage(playerid,GRAU,"Nicht in der Los Santos Zentralbank.");
    return 0;
    }
    if(Spieler[playerid][pPersoLic] == 0)
    {
    SendClientMessage(playerid,GRAU,"{FF6666}Bankangestellte:{FFFFFF} Sie besitzen keinen Personalausweis.");
    return 0;
    }
    if((GetACMoney(playerid) - 25) < 0)
    {
    SendClientMessage(playerid,GRAU,"{FF6666}Bankangestellte:{FFFFFF} Sie haben nicht genug Geld.");
    return 0;
    }
    if(Spieler[playerid][pBankkonto] == 0)
    {
    SendClientMessage(playerid,GRAU,"{FF6666}Bankangestellte:{FFFFFF} Sie haben sich erfolgreich ein Bankkonto zugelegt.");
    Spieler[playerid][pBankkonto] = 1;
    Spieler[playerid][pBankPin] = bankpin;
    format(string,sizeof(string),"{FF6666}Bankangestellte:{FFFFFF} Ihr Pin lautet %i.",Spieler[playerid][pBankPin]);
    SendClientMessage(playerid,GRAU,string);
    SendClientMessage(playerid,GRAU,"{FF6666}Bankangestellte:{FFFFFF} Ihren Bankpin können Sie über den Befehl '/bankpin' aufrufen.");
    ApplyAnimation(GetPlayerID("[BOT]Bank"),"PED","IDLE_CHAT",4.0,0,0,0,0,0,1);
    ACMoney(playerid,-25);
    StopAudioStreamForPlayer(playerid);
    PlayAudioStreamForPlayer(playerid,ServerSounds[2],0.0,0.0,0.0);
    return 0;
    }
    if(Spieler[playerid][pWrongBankPinEntry] >= 3)
    {
    SendClientMessage(playerid,GRAU,"{FF6666}Bankangestellte:{FFFFFF} Ihr Konto wurde entsperrt.");
    Spieler[playerid][pBankPin] = bankpin;
    Spieler[playerid][pWrongBankPinEntry] = 0;
    format(string,sizeof(string),"{FF6666}Bankangestellte:{FFFFFF} Ihr neuer Pin lautet %i.",Spieler[playerid][pBankPin]);
    SendClientMessage(playerid,GRAU,string);
    ApplyAnimation(GetPlayerID("[BOT]Bank"),"PED","IDLE_CHAT",4.0,0,0,0,0,0,1);
    Spieler[playerid][pBank] -= 25;
    StopAudioStreamForPlayer(playerid);
    PlayAudioStreamForPlayer(playerid,ServerSounds[2],0.0,0.0,0.0);
    return 0;
    }
    SendClientMessage(playerid,GRAU,"{FF6666}Bankangestellte:{FFFFFF} Sie haben bereits ein Bankkonto./Ihr Bankkonto wurde nicht gesperrt.");
    return 0;
    }
    if(strcmp(text,"Banksafe",true) == 0)
    {
    if(!IsPlayerInRangeOfPoint(playerid,2,1482.3273,-1005.3770,26.8159) && GetPlayerVirtualWorld(playerid) == 1)
    {
    SendClientMessage(playerid,GRAU,"Nicht in der Los Santos Zentralbank.");
    return 0;
    }
    if(Spieler[playerid][pBankSafeSafe] == 1)
    {
    SendClientMessage(playerid,GRAU,"{FF6666}Bankangestellte:{FFFFFF} Sie haben bereits ein Bankschließfach.");
    return 0;
    }
    if(Spieler[playerid][pPersoLic] == 0)
    {
    SendClientMessage(playerid,GRAU,"{FF6666}Bankangestellte:{FFFFFF} Sie besitzen keinen Personalausweis.");
    return 0;
    }
    if((GetACMoney(playerid) - 125) < 0)
    {
    SendClientMessage(playerid,GRAU,"{FF6666}Bankangestellte:{FFFFFF} Sie haben nicht genug Geld.");
    return 0;
    }
    SendClientMessage(playerid,GRAU,"{FF6666}Bankangestellte:{FFFFFF} Sie haben sich erfolgreich ein Schließfach zugelegt.");
    Spieler[playerid][pBankSafeSafe] = 1;
    ApplyAnimation(GetPlayerID("[BOT]Bank"),"PED","IDLE_CHAT",4.0,0,0,0,0,0,1);
    ACMoney(playerid,-125);
    StopAudioStreamForPlayer(playerid);
    PlayAudioStreamForPlayer(playerid,ServerSounds[2],0.0,0.0,0.0);
    return 0;
    }
    if(strcmp(text,"Tschüss",true) == 0)
    {
    SetCameraBehindPlayer(playerid);
    TogglePlayerControllable(playerid,1);
    Spieler[playerid][pTalkwithBankbitch] = 0;
    PlayerPlaySound(playerid,5453,0.0,0.0,0.0);
    format(string,sizeof(string),"{FF6666}Bankangestellte:{FFFFFF} Auf Wiedersehen %s,ich wünsche Ihnen noch einen schönen Tag.",SpielerName(playerid));
    SendClientMessage(playerid,GRAU,string);
    return 0;
    }
    return 0;
    }

  • Speichert es, wenn du den Server verlässt, korrekt in der Datenbank / Datei, dass du ein Bankkonto hast?
    Falls ja, poste den Code mit dem du die Statistiken des Spielers lädst, falls nicht, poste den Code mit dem du den Spieler speicherst. Möglicherweise wird Spieler[playerid][pBankkonto] nicht gespeichert, oder nicht geladen.


    Gleiches wird wohl auch beim PayDay so sein.


    Das dritte Problem schauen wir uns an, wenn Problem 1 und 2 behoben sind.

  • Ich habs nochmal als Dateianhang gemacht weil das nicht alles reinpasst, wenn das das nich is was ihr braucht downloadet es euch da unten :) Oder sagt mir was ihr noch braucht.


    07/05/2015-12:30:34 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
    07/05/2015-12:30:34 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,blacklist18,blacklistreason18,PRIMARY KEY (`Nam
    07/05/2015-12:30:34 | errorid=1146,error=Table 'samp5225_2552.G4L_races' doesn't exist,query=SELECT * FROM G4L_races
    07/05/2015-12:30:34 | errorid=1146,error=Table 'samp5225_2552.G4L_gutscheine' doesn't exist,query=SELECT * FROM G4L_gutscheine
    07/05/2015-12:30:34 | errorid=1146,error=Table 'samp5225_2552.G4L_partei' doesn't exist,query=SELECT * FROM G4L_partei
    07/05/2015-12:30:34 | errorid=1054,error=Unknown column 'wHackPrice' in 'field list',query=INSERT INTO `G4L_stuff` (ADPreis,PlayerRekord,Lottojackpot,RentVehsPreis,TerrorSpawn,Lohnsteuer,Kirchensteuer,Mwst,Grundsteuer,OamtStandGebuer,Solidsteuer,PreisLicCar,PreisLicBike,PreisLicRoller,PreisLicPlane,PreisLicHeli,PreisLicBoat,TerrorContractRang,FMeldePreis,NewspaperPreis,NewspaperText1,NewspaperText2,NewspaperText3,NewspaperText4,NewspaperText5,NewspaperText6,NewspaperText7,NewspaperText8,NewsPaperRealeased,NewsPaperLager1,NewsPaperLager2,EisenLagger1,EisenLagger2,Kartfahrer1,KartTime1,FreemanPrice,wHackPrice,SAPDpay,FBIpay,SAFDpay,ARMYpay,OAMTpay,GOVpay,WorkLessMoney,BlitzerToleranz,Reichensteuer,JobSperreFree,AngelLicPrice,PersoLicPrice,WeapPrice,ParkPrice) VALUES ('250','0','100000','50','0','2.2','1.4','19','2.6','150','1.2','1350','2000','500','10000','6750','4500','2','100','5','NO-ONE','NO-ONE','NO-ONE'
    07/05/2015-12:30:34 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE G4L_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCheckPointsAbgelaufen` int(6) NOT NULL,`PrisonCheckPointsGegeben` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int
    07/05/2015-12:30:34 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE G4L_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)
    07/05/2015-12:30:34 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
    07/05/2015-12:30:34 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,blacklist18,blacklistreason18,PRIMARY KEY (`Nam
    07/05/2015-12:36:59 | errorid=1146,error=Table 'samp5225_2552.G4L_account_blacklist' doesn't exist,query=SELECT * FROM G4L_account_blacklist WHERE Name = 'Notice'
    07/05/2015-12:42:56 | errorid=1054,error=Unknown column 'Slot10' in 'field list',query=UPDATE G4L_account_koffer SET Slot0='0',Slot1='0',Slot2='0',Slot3='0',Slot4='0',Slot5='0',Slot6='0',Slot7='0',Slot8='0',Slot9='0',Slot10='0' WHERE Name='Notice'
    07/05/2015-12:42:56 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE G4L_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCheckPointsAbgelaufen` int(6) NOT NULL,`PrisonCheckPointsGegeben` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int
    07/05/2015-12:42:56 | errorid=1054,error=Unknown column 'Gutschein' in 'field list',query=UPDATE G4L_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='7',FraktionSkinID='0',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='0',AngenommeneReports='0',KopfGeld='0',pWantedDeaths='0',pBuyTickets='0',pJailedCount='0',Bankkonto='0',pArmyPlaneOrder='0',pArmyHeliOrder='0',pArmyWaffenOrder='0',LevelUPKosten='800',RespectForLevelUp='3',RespectFromPayday='0',TimeAfterRegister='0',Time4Payday='0',TimeoutCrashExeorKick='0',HabGeworben='0',RpChat='0',pPremium='1',GeworbenerSpieler='Niemand',pScheinSperre='0',DigiHud='1',pDHitsound='0',Bonus='0',Gutschein='0',pCoins='0',pFirmaLeader='0',pFirmaMember='0',pOrgLeader='0',pOrgMember='0',pParteiLeader='0',pParteiMember='0',pLohn='0',WaitPerso='0',pMarried='Niemand',p
    07/05/2015-12:42:56 | errorid=1146,error=Table 'samp5225_2552.G4L_account_blacklist' doesn't exist,query=UPDATE G4L_account_blacklist SET blacklist0='0',blacklistreason0='Keinen',blacklist1='0',blacklistreason1='Keinen',blacklist2='0',blacklistreason2='Keinen',blacklist3='0',blacklistreason3='Keinen',blacklist4='0',blacklistreason4='Keinen',blacklist5='0',blacklistreason5='Keinen',blacklist6='0',blacklistreason6='Keinen',blacklist7='0',blacklistreason7='Keinen',blacklist8='0',blacklistreason8='Keinen',blacklist9='0',blacklistreason9='Keinen',blacklist10='0',blacklistreason10='Keinen',blacklist11='0',blacklistreason11='Keinen',blacklist12='0',blacklistreason12='Keinen',blacklist13='0',blacklistreason13='Keinen',blacklist14='0',blacklistreason14='Keinen',blacklist15='0',blacklistreason15='Keinen',blacklist16='0',blacklistreason16='Keinen',blacklist17='0',blacklistreason17='Keinen',blacklist18='0',blacklistreas
    07/05/2015-12:42:56 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE G4L_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)
    07/05/2015-12:42:56 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,blacklist18,blacklistreason18,PRIMARY KEY (`Nam
    07/05/2015-12:42:56 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
    07/05/2015-12:42:56 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE G4L_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCheckPointsAbgelaufen` int(6) NOT NULL,`PrisonCheckPointsGegeben` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int
    07/05/2015-12:42:56 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
    07/05/2015-12:42:56 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,blacklist18,blacklistreason18,PRIMARY KEY (`Nam
    07/05/2015-12:42:56 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE G4L_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)
    07/05/2015-12:46:01 | errorid=1054,error=Unknown column 'Gutschein' in 'field list',query=UPDATE G4L_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='7',FraktionSkinID='0',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='0',AngenommeneReports='0',KopfGeld='0',pWantedDeaths='0',pBuyTickets='0',pJailedCount='0',Bankkonto='0',pArmyPlaneOrder='0',pArmyHeliOrder='0',pArmyWaffenOrder='0',LevelUPKosten='800',RespectForLevelUp='3',RespectFromPayday='0',TimeAfterRegister='0',Time4Payday='0',TimeoutCrashExeorKick='0',HabGeworben='1',RpChat='0',pPremium='1',GeworbenerSpieler='Niemand',pScheinSperre='0',DigiHud='1',pDHitsound='0',Bonus='0',Gutschein='0',pCoins='0',pFirmaLeader='0',pFirmaMember='0',pOrgLeader='0',pOrgMember='0',pParteiLeader='0',pParteiMember='0',pLohn='0',WaitPerso='0',pMarried='Niemand',p
    07/05/2015-12:46:01 | errorid=1054,error=Unknown column 'Slot10' in 'field list',query=UPDATE G4L_account_koffer SET Slot0='0',Slot1='0',Slot2='0',Slot3='0',Slot4='0',Slot5='0',Slot6='0',Slot7='0',Slot8='0',Slot9='0',Slot10='0' WHERE Name='Notice'
    07/05/2015-12:46:01 | errorid=1146,error=Table 'samp5225_2552.G4L_account_blacklist' doesn't exist,query=UPDATE G4L_account_blacklist SET blacklist0='0',blacklistreason0='Keinen',blacklist1='0',blacklistreason1='Keinen',blacklist2='0',blacklistreason2='Keinen',blacklist3='0',blacklistreason3='Keinen',blacklist4='0',blacklistreason4='Keinen',blacklist5='0',blacklistreason5='Keinen',blacklist6='0',blacklistreason6='Keinen',blacklist7='0',blacklistreason7='Keinen',blacklist8='0',blacklistreason8='Keinen',blacklist9='0',blacklistreason9='Keinen',blacklist10='0',blacklistreason10='Keinen',blacklist11='0',blacklistreason11='Keinen',blacklist12='0',blacklistreason12='Keinen',blacklist13='0',blacklistreason13='Keinen',blacklist14='0',blacklistreason14='Keinen',blacklist15='0',blacklistreason15='Keinen',blacklist16='0',blacklistreason16='Keinen',blacklist17='0',blacklistreason17='Keinen',blacklist18='0',blacklistreas
    07/05/2015-12:46:01 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE G4L_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCheckPointsAbgelaufen` int(6) NOT NULL,`PrisonCheckPointsGegeben` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int
    07/05/2015-12:46:01 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE G4L_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)
    07/05/2015-12:46:01 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
    07/05/2015-12:46:01 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,blacklist18,blacklistreason18,PRIMARY KEY (`Nam
    07/05/2015-12:46:01 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE G4L_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCheckPointsAbgelaufen` int(6) NOT NULL,`PrisonCheckPointsGegeben` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int
    07/05/2015-12:46:01 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE G4L_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)
    07/05/2015-12:46:01 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
    07/05/2015-12:46:01 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,blacklist18,blacklistreason18,PRIMARY KEY (`Nam
    07/05/2015-12:49:42 | errorid=1054,error=Unknown column 'Slot10' in 'field list',query=UPDATE G4L_account_koffer SET Slot0='0',Slot1='0',Slot2='0',Slot3='0',Slot4='0',Slot5='0',Slot6='0',Slot7='0',Slot8='0',Slot9='0',Slot10='0' WHERE Name='Notice'
    07/05/2015-12:49:42 | errorid=1146,error=Table 'samp5225_2552.G4L_account_blacklist' doesn't exist,query=UPDATE G4L_account_blacklist SET blacklist0='0',blacklistreason0='Keinen',blacklist1='0',blacklistreason1='Keinen',blacklist2='0',blacklistreason2='Keinen',blacklist3='0',blacklistreason3='Keinen',blacklist4='0',blacklistreason4='Keinen',blacklist5='0',blacklistreason5='Keinen',blacklist6='0',blacklistreason6='Keinen',blacklist7='0',blacklistreason7='Keinen',blacklist8='0',blacklistreason8='Keinen',blacklist9='0',blacklistreason9='Keinen',blacklist10='0',blacklistreason10='Keinen',blacklist11='0',blacklistreason11='Keinen',blacklist12='0',blacklistreason12='Keinen',blacklist13='0',blacklistreason13='Keinen',blacklist14='0',blacklistreason14='Keinen',blacklist15='0',blacklistreason15='Keinen',blacklist16='0',blacklistreason16='Keinen',blacklist17='0',blacklistreason17='Keinen',blacklist18='0',blacklistreas
    07/05/2015-12:49:42 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE G4L_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCheckPointsAbgelaufen` int(6) NOT NULL,`PrisonCheckPointsGegeben` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int
    07/05/2015-12:49:42 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE G4L_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)
    07/05/2015-12:49:42 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
    07/05/2015-12:49:42 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,blacklist18,blacklistreason18,PRIMARY KEY (`Nam
    07/05/2015-12:49:42 | errorid=1054,error=Unknown column 'Gutschein' in 'field list',query=UPDATE G4L_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='7',FraktionSkinID='0',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='0',AngenommeneReports='0',KopfGeld='0',pWantedDeaths='0',pBuyTickets='0',pJailedCount='0',Bankkonto='0',pArmyPlaneOrder='0',pArmyHeliOrder='0',pArmyWaffenOrder='0',LevelUPKosten='800',RespectForLevelUp='3',RespectFromPayday='0',TimeAfterRegister='0',Time4Payday='0',TimeoutCrashExeorKick='0',HabGeworben='1',RpChat='0',pPremium='1',GeworbenerSpieler='Niemand',pScheinSperre='0',DigiHud='1',pDHitsound='0',Bonus='0',Gutschein='0',pCoins='0',pFirmaLeader='0',pFirmaMember='0',pOrgLeader='0',pOrgMember='0',pParteiLeader='0',pParteiMember='0',pLohn='0',WaitPerso='0',pMarried='Niemand',p
    07/05/2015-12:49:42 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
    07/05/2015-12:49:42 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,blacklist18,blacklistreason18,PRIMARY KEY (`Nam
    07/05/2015-12:49:42 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE G4L_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)
    07/05/2015-12:49:42 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE G4L_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCheckPointsAbgelaufen` int(6) NOT NULL,`PrisonCheckPointsGegeben` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int
    07/05/2015-12:50:24 | errorid=1054,error=Unknown column 'Slot10' in 'field list',query=UPDATE G4L_account_koffer SET Slot0='0',Slot1='0',Slot2='0',Slot3='0',Slot4='0',Slot5='0',Slot6='0',Slot7='0',Slot8='0',Slot9='0',Slot10='0' WHERE Name='Notice'
    07/05/2015-12:50:24 | errorid=1146,error=Table 'samp5225_2552.G4L_account_blacklist' doesn't exist,query=UPDATE G4L_account_blacklist SET blacklist0='0',blacklistreason0='Keinen',blacklist1='0',blacklistreason1='Keinen',blacklist2='0',blacklistreason2='Keinen',blacklist3='0',blacklistreason3='Keinen',blacklist4='0',blacklistreason4='Keinen',blacklist5='0',blacklistreason5='Keinen',blacklist6='0',blacklistreason6='Keinen',blacklist7='0',blacklistreason7='Keinen',blacklist8='0',blacklistreason8='Keinen',blacklist9='0',blacklistreason9='Keinen',blacklist10='0',blacklistreason10='Keinen',blacklist11='0',blacklistreason11='Keinen',blacklist12='0',blacklistreason12='Keinen',blacklist13='0',blacklistreason13='Keinen',blacklist14='0',blacklistreason14='Keinen',blacklist15='0',blacklistreason15='Keinen',blacklist16='0',blacklistreason16='Keinen',blacklist17='0',blacklistreason17='Keinen',blacklist18='0',blacklistreas
    07/05/2015-12:50:24 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE G4L_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCheckPointsAbgelaufen` int(6) NOT NULL,`PrisonCheckPointsGegeben` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int
    07/05/2015-12:50:24 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE G4L_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)
    07/05/2015-12:50:24 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
    07/05/2015-12:50:24 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistreason11,blacklist12,blacklistreason12,blacklist13,blacklistreason13,blacklist14,blacklistreason14,blacklist15,blacklistreason15,blacklist16,blacklistreason16,blacklist17,blacklistreason17,blacklist18,blacklistreason18,PRIMARY KEY (`Nam
    07/05/2015-12:50:24 | errorid=1054,error=Unknown column 'Gutschein' in 'field list',query=UPDATE G4L_account_main SET Muted='0',MuteZeit='0',ImPrison='0',PrisonCheckPointsAbgelaufen='0',PrisonCheckPointsGegeben='0',Morde='0',Tode='0',SkinID='7',FraktionSkinID='0',PaintBallKills='0',PaintBallTode='0',PaintBallRang='0',PaintBallBesuche='0',AngenommeneReports='0',KopfGeld='0',pWantedDeaths='0',pBuyTickets='0',pJailedCount='0',Bankkonto='0',pArmyPlaneOrder='0',pArmyHeliOrder='0',pArmyWaffenOrder='0',LevelUPKosten='800',RespectForLevelUp='3',RespectFromPayday='3',TimeAfterRegister='40',Time4Payday='40',TimeoutCrashExeorKick='0',HabGeworben='1',RpChat='0',pPremium='1',GeworbenerSpieler='Niemand',pScheinSperre='0',DigiHud='1',pDHitsound='0',Bonus='0',Gutschein='0',pCoins='0',pFirmaLeader='0',pFirmaMember='0',pOrgLeader='0',pOrgMember='0',pParteiLeader='0',pParteiMember='0',pLohn='0',WaitPerso='0',pMarried='Niemand'
    07/05/2015-12:50:24 | errorid=1060,error=Duplicate column name 'Friedhof',query=ALTER TABLE G4L_account_main ADD COLUMN (`Friedhof` int(2) NOT NULL,`FriedhofZeit` int(4) NOT NULL,`ImKnast` int(2) NOT NULL,`KnastZeit` int(4) NOT NULL,`KnastKaution` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCheckPointsAbgelaufen` int(6) NOT NULL,`PrisonCheckPointsGegeben` int(6) NOT NULL,`Morde` int(4) NOT NULL,`Tode` int(4) NOT NULL,`SkinID` int(3) NOT NULL,`FraktionSkinID` int(3) NOT NULL,`PaintBallKills` int(10) NOT NULL,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,`AngenommeneReports` int(6) NOT NULL,`KopfGeld` int(10) NOT NULL,`Bankkonto` int(2) NOT NULL,`pArmyPlaneOrder` int(2) NOT NULL,`pArmyHeliOrder` int(2) NOT NULL,`pArmyWaffenOrder` int(2) NOT NULL,`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int
    07/05/2015-12:50:24 | errorid=1060,error=Duplicate column name 'pMarried',query=ALTER TABLE G4L_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` int(6) NOT NULL,`pIll` int(10) NOT NULL,`pConterminatedTime` int(10) NOT NULL,`pBitchSkill` int(10) NOT NULL,`pBitchFuckCount` int(10) NOT NULL,`pMedicHealplayerSkill` int(10) NOT NULL,`pMedicHealCount` int(10) NOT NULL)
    07/05/2015-12:50:24 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL, `rmode` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`CP_TYP1` int(3) NOT NULL,`CP_SIZE1` float (10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`CP_TYP2` int(3) NOT NULL,`CP_SIZE2` float (10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`CP_TYP3` int(3) NOT NULL,`CP_SIZE3` float (10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`CP_TYP4` int(3) NOT NULL,`CP_SIZE4` float (10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(
    07/05/2015-12:50:24 | errorid=1064,error=You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blackli' at line 1,query=CREATE TABLE IF NOT EXISTS `G4L_account_blacklist` (`Name` varchar(24) NOT NULL,blacklist0,blacklistreason0,blacklist1,blacklistreason1,blacklist2,blacklistreason2,blacklist3,blacklistreason3,blacklist4,blacklistreason4,blacklist5,blacklistreason5,blacklist6,blacklistreason6,blacklist7,blacklistreason7,blacklist8,blacklistreason8,blacklist9,blacklistreason9,blacklist10,blacklistreason10,blacklist11,blacklistre

  • [Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '--------------------------------------------


    --
    -- Tabellenstruktur für Tabell' at line 3
    [Err] --
    -- Daten für Tabelle `complains`
    --------------------------------------------


    --
    -- Tabellenstruktur für Tabelle `news`
    --


    CREATE TABLE IF NOT EXISTS `news` (
    `ID` int(11) NOT NULL AUTO_INCREMENT,
    `Titel` varchar(32) COLLATE utf8_swedish_ci NOT NULL,
    `Message` varchar(999) COLLATE utf8_swedish_ci NOT NULL,
    `ErstelltVon` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
    `ErstelltAm` varchar(20) COLLATE utf8_swedish_ci NOT NULL,
    `Bedankt` int(10) NOT NULL DEFAULT '0',
    PRIMARY KEY (`ID`)
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_swedish_ci AUTO_INCREMENT=1 ;
    [Msg] Finished - Unsuccessfully
    --------------------------------------------------