Hey kann mir jemand helfen warum das 2. ADD COLUMN nicht klappt ?
Die Tabellen bis "WaitPerso" werden erstellt.. Aber die anderen leider nicht
Code
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_main` (`id` int(11) NOT NULL AUTO_INCREMENT,`Name` varchar(24) NOT NULL,`Online` int(2) NOT NULL,`Email` varchar(128) NOT NULL,`Passwort` varchar(34) NOT NULL,`IPAdresse` varchar(20) NOT NULL,`Tutorial` int(2) NOT NULL,`Admin` int(2) NOT NULL DEFAULT '0',`Verwarnungen` int(2) NOT NULL DEFAULT '0',`FLeaderRechte` int(2) NOT NULL,`Fraktion` int(2) NOT NULL,`FraktionsRang` int(2) NOT NULL,`FraktionsSperre` int(2) NOT NULL,");
strcat(query,"`FraktionsGehalt` int(6) NOT NULL,`Job` int(3) NOT NULL,");
strcat(query,"`JobWarns` int(2) NOT NULL,`JobSperre` int(128) NOT NULL,`AbgefahreneJobCheckPoints` int(4) NOT NULL,`ArbeitslosenGeld` int(4) NOT NULL,`Geschlecht` int(4) NOT NULL,`SpielerAlter` int(4) NOT NULL,`Level` int(4) NOT NULL,`Geld` int(10) NOT NULL,`GWD` int(3) NOT NULL,`Zivinote` int(3) NOT NULL,`FAbteilung` int(3) NOT NULL,`Bankguthaben` int(10) NOT NULL,`BankPin` int(96) NOT NULL,");
strcat(query,"`WantedSterne` int(2) NOT NULL,`WantedPunkte` int(2) NOT NULL,`Suspects` int(6) NOT NULL,");
strcat(query,"`Wanted_Grund1` varchar(128) NOT NULL,`Wanted_Grund2` varchar(128) NOT NULL,`Wanted_Grund3` varchar(128) NOT NULL,`Wanted_Grund4` varchar(128) NOT NULL,`Wanted_Grund5` varchar(128) NOT NULL,`pWantedDeaths` int(10) NOT NULL,`pBuyTickets` int(10) NOT NULL,`pJailedCount` int(10) NOT NULL,`Crimes` int(3) NOT NULL,`STVOcrimes` int(2) NOT NULL,`KampfStyle` int(2) NOT NULL,`Handy` int(2) NOT NULL,");
strcat(query,"`MobilTelefonFlat` int(2) NOT NULL,`Handycoins` int(3) NOT NULL,`MobilVertragBiz` int(4) NOT NULL,`HandyStatus` int(2) NOT NULL,");
strcat(query,"`HandyAkku` float(4,2) NOT NULL,`HandyNummer` int(20) NOT NULL,`Handyflat` int(3) NOT NULL,`Handyflatbuyinbiz` int(10) NOT NULL,`Letzte_X` float(10,4) NOT NULL,`Letzte_Y` float(10,4) NOT NULL,`Letzte_Z` float(10,4) NOT NULL,`Letzte_Interior` int(3) NOT NULL,`Letzte_VirtualWorld` int(11) NOT NULL,`pSelectHome` int(3) NOT NULL,`HausMieter` int(3) NOT NULL,");
strcat(query,"`Spawn` int(2) NOT NULL,`Hotel` int(2) NOT NULL,`Tod` int(2) NOT NULL,`Tot_X` float(10,4) NOT NULL,`Tot_Y` float(10,4) NOT NULL,`Tot_Z` float(10,4) NOT NULL,`Tot_Interior` int(3) NOT NULL,`Tot_VirtualWorld` int(11) NOT NULL,`TotZeit` int(4) NOT NULL,PRIMARY KEY (`id`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"ALTER TABLE "#SQLTAG"_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,`GangJailed` int(2) NOT NULL,`Muted` int(2) NOT NULL,`MuteZeit` int(4) NOT NULL,`ImPrison` int(2) NOT NULL,`PrisonCPRun` int(6) NOT NULL,");
strcat(query,"`PrisonCPGive` 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,");
strcat(query,"`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,");
strcat(query,"`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(6) NOT NULL,`RespectFromPayday` int(6) NOT NULL,`Heutegezockt` int(2) NOT NULL,`Deckname` varchar(24) NOT NULL DEFAULT '-',`TimeAfterRegister` int(12) NOT NULL,");
strcat(query,"`Time4Payday` int(3) NOT NULL,`HabGeworben` int(2) NOT NULL,`GeworbenerSpieler` varchar(24) NOT NULL,`pPremiumZeit` int(128) NOT NULL,");
strcat(query,"`TimeoutCrashExeorKick` int(3) NOT NULL,`PropertyClearTime` int(128) NOT NULL,`pScheinSperre` int(128) NOT NULL,`PingFPS` int(2) NOT NULL,`DigiHud` int(2) NOT NULL,`DHitsound` int(2) NOT NULL,`WantedHud` int(2) NOT NULL,`Coins` int(6) NOT NULL,`Bonus` int(2) NOT NULL,`pOrgLeader` int(4) NOT NULL,`pOrgMember` int(4) NOT NULL,`pLohn` int(12) NOT NULL,`WaitPerso` int(128) NOT NULL)");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"ALTER TABLE "#SQLTAG"_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL DEFAULT 'Niemand',`pBrille` int(6) NOT NULL,`pTsIdent` varchar(64) 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,");
strcat(query,"`pUpgradePoints` int(6) NOT NULL,`pUpgradeSkill0` int(2) NOT NULL DEFAULT '1',`pUpgradeSkill1` int(2) NOT NULL DEFAULT '1',`pUpgradeSkill2` int(2) NOT NULL DEFAULT '1',`pUpgradeSkill3` int(2) NOT NULL DEFAULT '1',`pUpgradeSkill4` int(2) NOT NULL DEFAULT '1',`pPickWeapons` int(2) NOT NULL,`skill9mm` int(11) NOT NULL,`skilldeagle` int(11) NOT NULL,");
strcat(query,"`skillshotgun` int(11) NOT NULL,`skillmp5` int(11) NOT NULL,`skillak` int(11) NOT NULL,`skillm4` int(11) NOT NULL,`skillsniper` int(11) NOT NULL,`MuellmannSkill` int(10) NOT NULL,`StadtreinigungSkill` int(10) NOT NULL,`FluglieferantSkill` int(10) NOT NULL,`PostboteSkill` int(10) NOT NULL,`DetektivSkill` int(10) NOT NULL,`LandwirtSkill` int(10) NOT NULL,`EisverkauferSkill` int(10) NOT NULL,`BestatterSkill` int(10) NOT NULL,");
strcat(query,"`GeldtransporterSkill` int(10) NOT NULL,`TruckerSkill` int(10) NOT NULL,`BusfahrerSkill` int(10) NOT NULL,`MechanikerSkill` int(10) NOT NULL,`WaffendealerSkill` int(10) NOT NULL,`DrogendealerSkill` int(10) NOT NULL,`AnwaltSkill` int(10) NOT NULL,`TaxifahrerSkill` int(10) NOT NULL,`ImmobilienmaklerSkill` int(10) NOT NULL,`ZigarenhandlerSkill` int(10) NOT NULL,`MinenarbeiterSkill` int(10) NOT NULL,`HohlenforscherSkill` int(10) NOT NULL,PRIMARY KEY (`id`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
Alles anzeigen