MySQL Tabelle im Script erstellen

RedDragon28080 · 3. März 2017

Hallo liebes Breadfish Community

Und war habe ich keine Ahnung wie man eine Neue Tabelle im phpMyAdmin erstellt.
Ich wollte mal fragen ob ihr mir eine tabelle fertig machen kann für die MSQL Version R34

nur ein Beispiel (das ist die version R39-6)

C

mysql_pquery(handle, "ALTER TABLE `users` ADD `Name` varchar(64) NOT NULL DEFAULT '0'");

Hier die Daten dazu

pLevel

ihr seit mir eine große hilfe dabei

Mogly1 · 3. März 2017

wie wäre es mit Navicate Lite?

Jeffry · 3. März 2017

Zitat von RedDragon28080

ch wollte mal fragen ob ihr mir eine tabelle fertig machen kann für die MSQL Version R34

Siehe hier:
[jTuT] Fraktions-Fahrzeug-System mit MySQL R39-5

RedDragon28080 · 3. März 2017

ich hoffe es ist so richtig

Code

Function CreateTabellen() {
	format(query, "CREATE TABLE IF NOT EXISTS `script_spieler` (`id` int(11)  AUTO_INCREMENT, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");
	format(query, sizeof(query), "%s  `Level` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Admin` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `SpawnHealth` float NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `PayDay` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Exp` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Fraktion` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `PBPoints` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Zigaretten` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Bierflaschen` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Ipod` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Tutorial` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Skin` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FrakSkin` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Geschlecht` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Perso` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `CarLicense` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `CarLicensePoints` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Wanteds` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `JobMoney` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `JobCount` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `BusSkill` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `BusSkillEXP` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Tot` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `TotUnix` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `TotX` float NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `TotY` float NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `TotZ` float NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Kills` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Deaths` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Jailed` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `JailTime` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Rank` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Verbrechen` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `JailType` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Banned` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `BanReason` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `BanAdmin` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Erstehilfe` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `GotMD5` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Number` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Handy` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `HandyStatus` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `HandyGuthaben` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Akku` float NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `DetektivSkill` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `DetektivSkillEXP` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `PlayTime` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Warns` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Crimes` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `JailVisits` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Eisen` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `EisenSafe` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Marihuana` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `MarihuanaSafe` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Kanister` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Verheiratet` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `VerheiratetName` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Bank` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Premium` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `SkillPoints` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Lotto` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FlyLicense` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `BoatLicense` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FishLicense` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `GunLicense` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Zollpass` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Job` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Money` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `QuitJob` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Boombox` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `HaveBoombox` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Geschenk` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `GeschenkCount` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Muted` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `MuteReason` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `TruckSkill` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `TruckSkillEXP` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `SpawnChange` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `PremiumZeit` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FishSkill` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FishSkillEXP` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `OrgMember` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Contract` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `ContractCount` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `LastLogin` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `PilotSkill` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `PilotSkillEXP` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `HouseKey` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `TotWorld` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Hitsound` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Messages` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Fished` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FishTime` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FishSperre` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `SkillDrug` float NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Festgeld` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `HatFestgeld` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `BisFestgeld` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FishID1` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FishID2` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FishID3` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FishID4` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `FishID5` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Fishweight1` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Fishweight2` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Fishweight3` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Fishweight4` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `Fishweight5` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `CookID1` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `CookID2` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `CookID3` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `CookID4` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `CookID5CookHP1` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `CookHP1` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `CookHP1` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `CookHP1` int(11) NOT NULL DEFAULT '0',", query);
	format(query, sizeof(query), "%s  `CookHP1` int(11) NOT NULL DEFAULT '0',", query);
	mysql_tquery(handle, query);
	return 1;
}

Alles anzeigen

und was soll ich mit "Name" und "Passwort" machen
so sieht es im MSQL aus

und schon mal ein Danke an Jeffry

Jeffry · 3. März 2017

Die erste Zeile stimmt nicht, der Teil mit der Engine muss in die letzte Zeile.
Vergleiche deinen Code mit dem aus dem Tutorial.

Name und Passwort kannst du auch eintragen.

RedDragon28080 · 3. März 2017

ich habe es so übernommen wie im Tutorial
Da stand das auch am erster Stelle
Irgendwie sehe ich hier gerade nicht durch

Frage: wenn es bald gehen sollte und ich irgendwann eine Zeile dazu schreibe wird sie dann auch übernommen oder muss ich dann die msql Daten Bank leeren?

Jeffry · 3. März 2017

Zitat von RedDragon28080

Da stand das auch am erster Stelle

Wo hast du das her? In meinem Tutorial steht das nicht an erster Stelle.

Zitat von RedDragon28080

Frage: wenn es bald gehen sollte und ich irgendwann eine Zeile dazu schreibe wird sie dann auch übernommen oder muss ich dann die msql Daten Bank leeren?

Der Code erstellt nur die Tabelle einmalig, wenn sie nicht existiert. Wenn du eine Spalte hinzufügen willst, dann trage es im Code ein und füge die Spalte manuell in der Datenbank hinzu.

RedDragon28080 · 4. März 2017

das ist aber nicht was ich wollte ich wollte mein Bruder hat für ein adnderes script von mir mal eine CreateTabelle erstellt wo immer die neue zeile erstellt worden ist und sowas wollte ich haben wie mache ich das?

hier was mein Bruder für die Version "R39-6"

meine ich genau das nur für die Version "R34"

CSS

//OnGameModeInit
    mysql_pquery(handle, "CREATE TABLE IF NOT EXISTS `users` (`id` int(11)  AUTO_INCREMENT, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;");




Function CreateTabellen() {
	mysql_pquery(handle, "ALTER TABLE `users` ADD `IPAdresse` varchar(16) NOT NULL DEFAULT '0'");
    mysql_pquery(handle, "ALTER TABLE `users` ADD `Name` varchar(64) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Password` varchar(64) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Level` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `AdminLevel` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `DonateRank` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `UpgradePoints` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `ConnectedTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Registered` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Sex` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Age` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Origin` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `CK` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Muted` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Respect` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Money` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Bank` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Kredit` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `KreditDauer` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Kills` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Deaths` int(11) NOT NULL DEFAULT '0'");
    mysql_pquery(handle, "ALTER TABLE `users` ADD `Arrested` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `WantedDeaths` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Phonebook` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Fishes` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `BiggestFish` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Job` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `iJob` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Paycheck` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `HeadValue` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Jailed` int(11) NOT NULL DEFAULT '0'");
    mysql_pquery(handle, "ALTER TABLE `users` ADD `GWD` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `GangJailed` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Mauled` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `JailTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Materials` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Drugs` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FightingStyle` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Leader` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Member` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Rank` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pChar` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FlugSkill` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `TruckSkill` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `MullSkill` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `WaffenSkill` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pSHealth` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pHealth` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pInt` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Local` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Team` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Model` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PhoneNr` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `House` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Bizz` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `HandyGeld` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `HandyVer` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pos_x` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pos_y` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pos_z` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pos_a` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `CarLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `NewLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FlyLic` int(11) NOT NULL DEFAULT '0'");
    mysql_pquery(handle, "ALTER TABLE `users` ADD `BoatLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `GunLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `LKWLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `RollerLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Taxischein` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `MotoLic` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Abschlepperschein` int(11) NOT NULL DEFAULT '0'");
    mysql_pquery(handle, "ALTER TABLE `users` ADD `Zig` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Kekse` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `ZigSucht` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Gun1` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Gun2` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Gun3` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Gun4` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Ammo1` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Ammo2` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Ammo3` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Ammo4` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `CarTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Mulltime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PayDay` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PayDayHad` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `CDPlayer` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Wins` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Loses` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `AlcoholPerk` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `HandyGeld` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `MiserPerk` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PainPerk` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `TraderPerk` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Tutorial` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Warnings` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Adjustable` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Fuel` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Married` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `MarriedTo` VARCHAR(64) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `SpawnChange` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `WantedLevel` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PlayMinutes` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `GesamtMinutes` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `MinutesSinceAn` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `SFPASS` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `LVPASS` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Offflucht` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Knast` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Uhr` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Handy` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `KnastTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Perso` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FrakSperre` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Gehalt` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvWeapon` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvAmmo` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvWeapon2` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvAmmo2` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvMats` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `InvDrugs` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FlugTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FarmTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `GDeaths` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `GKills` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Meldung` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `HatIrgenteinHome` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pin` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `SpawnChange` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Hotel` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `CarPunkt` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `BikePunkt` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Kanister` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `KreditRechnung` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `jobkuendigen` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Tot` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Neulingsvip` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Maske` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `DrugPerk` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Feuerzeug` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `C4` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Drugsamen` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Hotelzimmer` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `lohn` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `KrankenVersicherung` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pHeal` float NOT NULL DEFAULT '51.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `pArmor` float NOT NULL DEFAULT '0.0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Reparaturkit` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Pakete` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `PaketRute` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `FahrschulTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Fraktionlosengeld` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `WaffenMaterialID` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `BusTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Busskill` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `JobTime` int(11) NOT NULL DEFAULT '0'");
	mysql_pquery(handle, "ALTER TABLE `users` ADD `Autogeschenkt` int(11) NOT NULL DEFAULT '0'");
	return 1;
}

Alles anzeigen

**XeroX** · 4. März 2017

Anstatt hundert queries abzusetzen solltest du alles zusammen in einem query packen und dann abschicken.

RedDragon28080 · 4. März 2017

so habe es fast geschaft ich habe es jetzt so gemacht es wird auch erstellt aber bei nicht abgespeichert

hier der msql_log

C

[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Name'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Passwort'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Level'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Admin'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'SpawnHealth'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PayDay'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Exp'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fraktion'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Tutorial'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Skin'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FrakSkin'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Geschlecht'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Perso'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CarLicense'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CarLicensePoints'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FlyLicense'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BoatLicense'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishLicense'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'GunLicense'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Zollpass'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Job'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Wanteds'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Money'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'QuitJob'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'JobMoney'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'JobCount'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BusSkill'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BusSkillEXP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'DetektivSkill'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'DetektivSkillEXP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Tot'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TotUnix'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TotX'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TotY'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TotZ'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Kills'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Deaths'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Jailed'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'JailTime'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Rank'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Verbrechen'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'JailType'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Banned'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BanReason'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BanAdmin'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'HouseKey'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Erstehilfe'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Number'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Bank'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Handy'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'HandyStatus'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'HandyGuthaben'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Akku'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PlayTime'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Warns'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Crimes'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'JailVisits'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Eisen'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'EisenSafe'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Marihuana'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'MarihuanaSafe'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Kanister'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Verheiratet'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'VerheiratetName'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Premium'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'MuteTime'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'MuteReason'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'SkillPoints'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TruckSkill'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TruckSkillEXP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Muted'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'SpawnChange'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'TotWorld'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Hitsound'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Messages'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fishweight'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Fished'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishTime'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookID'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'CookHP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishSperre'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'SkillDrug'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PremiumZeit'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishSkill'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'FishSkillEXP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'OrgMember'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Contract'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'ContractCount'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'LastLogin'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'IsEhrenhaft'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Online'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Lotto'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PilotSkill'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PilotSkillEXP'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'playerOnline'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Email'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'PBPoints'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'NewPasswort'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'GotMD'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Zigaretten'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Bierflaschen'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Ipod'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Boombox'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'HaveBoombox'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Festgeld'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'HatFestgeld'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'BisFestgeld'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'Geschenk'
[16:39:06] [ERROR] CMySQLQuery::Execute[()] - (error #1060) Duplicate column name 'GeschenkCount'

Alles anzeigen

Ich sehe da nicht de Fehler aber vieleicht sieht ihr den Fehler

Ich brauche dringend Hilfe

Jeffry · 5. März 2017

Zitat von RedDragon28080

Ich sehe da nicht de Fehler aber vieleicht sieht ihr den Fehler

Da das ALTER TABLE jedes mal aufgerufen wird, wenn der Server gestartet wird, wird jedes mal versucht die Spalten (alle) hinzuzufügen.
Für die bereits existierenden Spalten wird dann natürlich der Fehler ausgegeben.
Daher sollte man das so nicht machen, sondern wie ich beschrieben habe.

RedDragon28080 · 5. März 2017

achso oky

breadfish.de 12. März 2022