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