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 `Crimes` 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 `Job` 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 `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 `BoxMaterials` int(11) NOT NULL DEFAULT '0'");
mysql_pquery(handle, "ALTER TABLE `users` ADD `BoxDrugs` 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 `GWD` int(11) NOT NULL DEFAULT '0'");
mysql_pquery(handle, "ALTER TABLE `users` ADD `FrakSkin` 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 `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 `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 `FishLic` 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 `DrugPerk` 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 ''");
mysql_pquery(handle, "ALTER TABLE `users` ADD `Wanteds` 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 `Handy` 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 `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 `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'");
for(new i = 1;i< 14;i++)
{
new tmpstring[256];
format(tmpstring,sizeof tmpstring, "ALTER TABLE `users` ADD `waffenslot%d` int(11) NOT NULL DEFAULT '0'",i);
mysql_pquery(handle, tmpstring);
format(tmpstring,sizeof tmpstring, "ALTER TABLE `users` ADD `ammoslot%d` int(11) NOT NULL DEFAULT '0'",i);
mysql_pquery(handle, tmpstring);
}
Alles anzeigen