Das problem ist wenn wir bei der Tabelle etwas neues hinzufügen, dann taucht wieder das Problem auf.. Und ich wollte mal nachfragen woran es liegt ? Ist etwa die Struktur zu viel oder zu kurz ?
Code
stock CreateTables()
{
new query[4000];
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,`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,`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,`PaintBallTode` int(10) NOT NULL,`PaintBallRang` int(3) NOT NULL,`PaintBallBesuche` int(8) NOT NULL,");
strcat(query,"`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,`TimeAfterRegister` int(12) NOT NULL,`Time4Payday` int(3) NOT NULL,");
strcat(query,"`LevelUPKosten` int(10) NOT NULL,`RespectForLevelUp` int(6) NOT NULL,`RespectFromPayday` int(6) NOT NULL,`HabGeworben` int(2) NOT NULL,`pPremiumZeit` int(128) NOT NULL,`GeworbenerSpieler` varchar(24) 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,`pDHitsound` int(2) NOT NULL,`Bonus` int(2) NOT NULL,`Coins` int(6) NOT NULL,`pUpgradePoints` int(6) NOT NULL,`pUpgradeSkill0` int(2) NOT NULL DEFAULT '1',`pUpgradeSkill1` int(2) NOT NULL DEFAULT '1',");
strcat(query,"`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,`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',`pBuyClothes` int(6) NOT NULL,`pBrille` int(6) NOT NULL,`pTsIdent` varchar(32) 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)");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_bans` (`IP` varchar(16) NOT NULL,`Grund` varchar(128) NOT NULL,`Name` varchar(24) NOT NULL,`Admin` varchar(24) NOT NULL,`Zeit` int(128) NOT NULL,`Uhrzeit` time NOT NULL,`Datum` date NOT NULL,PRIMARY KEY (`IP`))",false,"","");
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_properties` (`id` int(4) NOT NULL,`haus_besitzer` varchar(24) NOT NULL");
strcat(query,",`haus_Owned` int(2) NOT NULL,`haus_innenraum` int(2) NOT NULL,`haus_miete` int(11) NOT NULL,`haus_beschreibung` varchar(150) NOT NULL,`haus_locked` int(2) NOT NULL,`haus_slots` int(3) NOT NULL,`haus_eingemitetenzaehler` int(3) NOT NULL,`haus_x` float(10,4) NOT NULL,");
strcat(query,"`haus_y` float(10,4) NOT NULL,`haus_z` float(10,4) NOT NULL,`haus_preis` int(11) NOT NULL,`haus_level` int(4) NOT NULL,`haus_geldkasse` int(11) NOT NULL");
for(new i=0;i<MAX_HAUSSAFEINV;i++)
{
strcat(query,",");
format(query,sizeof(query),"%s`haus_inv%i` int(11) NOT NULL",query,i);
}
strcat(query,",`haus_heal` int(4) NOT NULL,`haus_armour` int(4) NOT NULL,`haus_hatheal` int(2) NOT NULL,`haus_hatarmour` int(2) NOT NULL,`hausgundumper` int(2) NOT NULL");
for(new i=0;i<13;i++)
{
strcat(query,",");
format(query,sizeof(query),"%s`hausgun%i` int(3) NOT NULL,",query,i);
format(query,sizeof(query),"%s`hausgunammo%i` int(6) NOT NULL",query,i);
}
strcat(query,",`hausmull` int(3) NOT NULL,`haus_msg` varchar(64) NOT NULL,`haus_garagepos_x` float(10,4) NOT NULL,`haus_garagepos_y` float(10,4) NOT NULL,`haus_garagepos_z` float(10,4) NOT NULL,`haus_garagevehspawn_x` float(10,4) NOT NULL,`haus_garagevehspawn_y` float(10,4) NOT NULL,`haus_garagevehspawn_z` float(10,4) NOT NULL,`haus_garagevehspawn_a` float(10,4) NOT NULL,`haus_havegarage` int(2) NOT NULL,`haus_garagelocked` int(2) NOT NULL,PRIMARY KEY (`id`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_pns` (`id` int(4) NOT NULL,`pns_fraktid` int(3) NOT NULL,`pns_kasse` int(11) NOT NULL");
for(new i=0;i<PNS_ARTIKEL_SLOTS;i++)
{
strcat(query,",");
format(query,sizeof(query),"%s`pns_a%i` int(11) NOT NULL",query,i);
}
strcat(query,",PRIMARY KEY (`id`))ENGINE=INNODB;");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_businesses` (`id` int(12) NOT NULL,`biz_Owned` int(2) NOT NULL,`biz_art` varchar(50) NOT NULL,`biz_preis` int(12) NOT NULL,`biz_level` int(12) NOT NULL,`biz_geldkasse` int(12) NOT NULL,");
strcat(query,"`biz_locked` int(2) NOT NULL,`biz_besitzer` varchar(24) NOT NULL,`biz_teilhaber` varchar(24) NOT NULL,`biz_beschreibung` varchar(150) NOT NULL,`biz_artikel0` int(12) NOT NULL,`biz_artikel1` int(12) NOT NULL,`biz_artikel2` int(12) NOT NULL,");
strcat(query,"`biz_artikel3` int(12) NOT NULL,`biz_artikel4` int(12) NOT NULL,`biz_artikel5` int(12) NOT NULL,`biz_artikel6` int(12) NOT NULL,`biz_artikel7` int(12) NOT NULL,`biz_artikel8` int(12) NOT NULL,`biz_artikel9` int(12) NOT NULL,`biz_artikel10` int(12) NOT NULL,");
strcat(query,"`biz_artikel11` int(12) NOT NULL,`biz_artikel12` int(12) NOT NULL,`biz_artikel13` int(12) NOT NULL,`biz_artikel14` int(12) NOT NULL,`biz_x` float(10,4) NOT NULL,`biz_y` float(10,4) NOT NULL,`biz_z` float(10,4) NOT NULL,");
strcat(query,"`biz_sobjp0` float(10,4) NOT NULL,`biz_sobjp1` float(10,4) NOT NULL,`biz_sobjp2` float(10,4) NOT NULL,`biz_sobjp3` float(10,4) NOT NULL,`biz_sobjp4` float(10,4) NOT NULL,`biz_sobjp5` float(10,4) NOT NULL,`biz_interior` int(4) NOT NULL,`rentbizvehiclemodelid` int(4) NOT NULL,`tPos0` float(10,4) NOT NULL,`tPos1` float(10,4) NOT NULL,`tPos2` float(10,4) NOT NULL,`tPos3` float(10,4) NOT NULL,`tPos4` float(10,4) NOT NULL,`tPos5` float(10,4) NOT NULL,PRIMARY KEY (`id`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_blitzer` (`id` int(10) NOT NULL,`sperreX` float(10,4) NOT NULL,`sperreY` float(10,4) NOT NULL,`sperreZ` float(10,4) NOT NULL,`BlitzerGeschwindigkeit` int(10) NOT NULL,`BlitzerOrt` varchar(128) NOT NULL,`HP` int(4) NOT NULL,PRIMARY KEY (`id`))",false,"","");
for(new i=0;i<sizeof(LogTable);i++)
{
format(query,sizeof(query),"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_logs_%s` (`id` int(11) NOT NULL AUTO_INCREMENT,`Uhrzeit` time NOT NULL,`Datum` date NOT NULL",LogTable[i][Logname]);
if(strlen(LogTable[i][Column1]) > 0) format(query,sizeof(query),"%s,`%s` varchar(128) NOT NULL",query,LogTable[i][Column1]);
if(strlen(LogTable[i][Column2]) > 0) format(query,sizeof(query),"%s,`%s` varchar(128) NOT NULL",query,LogTable[i][Column2]);
if(strlen(LogTable[i][Column3]) > 0) format(query,sizeof(query),"%s,`%s` varchar(128) NOT NULL",query,LogTable[i][Column3]);
if(strlen(LogTable[i][Column4]) > 0) format(query,sizeof(query),"%s,`%s` varchar(128) NOT NULL",query,LogTable[i][Column4]);
strcat(query,",PRIMARY KEY (`id`))ENGINE=INNODB;");
mysql_function_query(MySqlConnection,query,false,"","");
}
strdel(query,0,sizeof(query));
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_minen` (`id` int(10) NOT NULL,`sperreX` float(10,4) NOT NULL,`sperreY` float(10,4) NOT NULL,`sperreZ` float(10,4) NOT NULL,PRIMARY KEY (`id`))",false,"","");
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_xmasobjects` (`id` int(10) NOT NULL,`ObjectID` int(10) NOT NULL,`sperreX` float(10,4) NOT NULL,`sperreY` float(10,4) NOT NULL,`sperreZ` float(10,4) NOT NULL,PRIMARY KEY (`id`))",false,"","");
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_eastereggs` (`id` int(4) NOT NULL,`ObjectID` int(6) NOT NULL,`sperreX` float(10,4) NOT NULL,`sperreY` float(10,4) NOT NULL,`sperreZ` float(10,4) NOT NULL,`obj_world` int(11) NOT NULL,`foundenby` varchar(24) NOT NULL,PRIMARY KEY (`id`))",false,"","");
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_drugs` (`pflanze` int(12) NOT NULL,`drgfraktid` int(3) NOT NULL,`drgArt` int(3) NOT NULL,`drgXpos` float(10,4) NOT NULL,`drgYpos` float(10,4) NOT NULL,`drgZpos` float(10,4) NOT NULL,`drginterior` int(5) NOT NULL,`drgvirtualworld` int(5) NOT NULL,`drgProduceDrugs` int(10) NOT NULL,`drgNextDrugsIn` int(128) NOT NULL,`drgWasserzustand` int(6) NOT NULL,`drgOwner` varchar(24) NOT NULL,PRIMARY KEY (`pflanze`))",false,"","");
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_fraktion_vehicles` (`id` int(12) NOT NULL,`Fraktion` int(4) NOT NULL,`Rang` int(2) NOT NULL,`modelid` int(4) NOT NULL,`Farbe1` int(5) NOT NULL,`Farbe2` int(5) NOT NULL,`Paintjob` int(5) NOT NULL,`HP` float(10,4) NOT NULL,`posx` float(10,4) NOT NULL,");
strcat(query,"`posy` float(10,4) NOT NULL,`posz` float(10,4) NOT NULL,`posa` float(10,4) NOT NULL,`Interior` int(3) NOT NULL,`VirtualWorld` int(6) NOT NULL,`Abgeschlossen` int(2) NOT NULL,`Abgeschleppt` int(2) NOT NULL,`AbgeschlepptPreis` int(8) NOT NULL,`AbgeschlepptGrund` varchar(128) NOT NULL,`Nummernschild` varchar(64) NOT NULL,`Neon` int(5) NOT NULL,`Spoiler` int(10) NOT NULL,`Hood` int(10) NOT NULL,");
strcat(query,"`Roof` int(10) NOT NULL,`Sideskirt` int(10) NOT NULL,`Lamps` int(10) NOT NULL,`Nitro` int(10) NOT NULL,`Exhaust` int(10) NOT NULL,`Wheels` int(10) NOT NULL,`Stereo` int(10) NOT NULL,`Hydraulics` int(10) NOT NULL,`FrontBumper` int(10) NOT NULL,`RearBumper` int(10) NOT NULL,`VentRight` int(10) NOT NULL,`VentLeft` int(10) NOT NULL,`KaufPreis` int(10) NOT NULL,`FraktionsRang` int(10) NOT NULL,`Motorschaden` int(2) NOT NULL,`FailGas` int(2) NOT NULL,");
strcat(query,"`Tank` float(10,4) NOT NULL,`Kilometerstand` int(64) NOT NULL,`KofferraumGanja` int(10) NOT NULL,`KofferraumKokain` int(10) NOT NULL,`KofferraumMaterials` int(10) NOT NULL,`KofferraumOpium` int(10) NOT NULL,`KofferraumLunchpakete` int(10) NOT NULL,`KofferraumC4` int(10) NOT NULL,`KofferraumWerkzeugkasten` int(10) NOT NULL,`KofferraumBenzinkanister` int(10) NOT NULL,`Handbremse` int(2) NOT NULL,PRIMARY KEY (`id`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_gangwar2` (`GangZoneID` int(4) NOT NULL,`GangWarZoneOwner` int(3) NOT NULL,`GangWarZoneAttacker` int(3) NOT NULL,`EZ_OwnerFactionPoints` int(4) NOT NULL,`EZ_AttackFactionPoints` int(4) NOT NULL,`EZ_Started` int(2) NOT NULL,`EZ_FightTime` int(11) NOT NULL,PRIMARY KEY (`GangZoneID`))",false,"","");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_fraktion_motd` (`fID` int(12) NOT NULL,`Text` varchar(128) NOT NULL,PRIMARY KEY (`fID`))",false,"","");
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_stuff` (`id` int(1) NOT NULL,`ADPreis` int(20) NOT NULL,`Lottojackpot` int(20) NOT NULL,`RentVehsPreis` int(20) NOT NULL,`TerrorSpawn` int(3) NOT NULL,`Lohnsteuer` float(10,4) NOT NULL,`Mwst` float(10,4) NOT NULL,`Grundsteuer` float(10,4) NOT NULL,`OamtStandGebuer` int(20) NOT NULL,`Solidsteuer` float(10,4) NOT NULL,`Reichensteuer` float(10,4) NOT NULL,`WLS` int(3) NOT NULL,`WSF` int(3) NOT NULL,");
strcat(query,"`WLV` int(3) NOT NULL,`PreisLicCar` int(20) NOT NULL,`PreisLicBike` int(20) NOT NULL,`PreisLicRoller` int(20) NOT NULL,`PreisLicPlane` int(20) NOT NULL,`PreisLicHeli` int(20) NOT NULL,`PreisLicBoat` int(20) NOT NULL,`HitmanContractRang` int(2) NOT NULL,`FMeldePreis` int(20) NOT NULL,`NewspaperPreis` int(4) NOT NULL,`NewspaperText1` varchar(256) NOT NULL,`NewspaperText2` varchar(256) NOT NULL,`NewspaperText3` varchar(256) NOT NULL,`NewspaperText4` varchar(256) NOT NULL,");
strcat(query,"`NewspaperText5` varchar(256) NOT NULL,`NewspaperText6` varchar(256) NOT NULL,`NewspaperText7` varchar(256) NOT NULL,`NewspaperText8` varchar(256) NOT NULL,`NewsPaperRealeased` int(12) NOT NULL,`NewsPaperLager1` int(12) NOT NULL,`NewsPaperLager2` int(12) NOT NULL,`EisenLagger1` int(12) NOT NULL,`EisenLagger2` int(12) NOT NULL,`Kartfahrer1` varchar(24) NOT NULL,`KartTime1` int(28) NOT NULL,`FreemanPrice` int(6) NOT NULL,");
strcat(query,"`SAPDpay` int(6) NOT NULL,`FBIpay` int(6) NOT NULL,`SAEDpay` int(6) NOT NULL,`ARMYpay` int(6) NOT NULL,`OAMTpay` int(6) NOT NULL,`GOVpay` int(6) NOT NULL,`WorkLessMoney` int(6) NOT NULL,`BlitzerToleranz` int(6) NOT NULL,`JobSperreFree` int(20) NOT NULL,`AngelLicPrice` int(20) NOT NULL,`PersoLicPrice` int(20) NOT NULL,`WeapPrice` int(20) NOT NULL,`ParkPrice` int(20) NOT NULL,PRIMARY KEY (`id`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_fraktion_verwaltung` (`fID` int(5) NOT NULL,`Geld` int(100) NOT NULL,`Opium` int(100) NOT NULL,`Ganja` int(100) NOT NULL,`Kokain` int(100) NOT NULL,`C4` int(100) NOT NULL,`Materials` int(100) NOT NULL,`WaffenPack` int(100) NOT NULL,`WaffenSlots` int(100) NOT NULL,`Heal` int(100) NOT NULL,`HealSlots` int(100) NOT NULL,`Armour` int(100) NOT NULL,`ArmourSlots` int(100) NOT NULL,`HaveVBInvite` int(5) NOT NULL,`VBFraktion` int(5) NOT NULL,");
strcat(query,"`F0` varchar(32) NOT NULL,`F1` varchar(32) NOT NULL,`F2` varchar(32) NOT NULL,`F3` varchar(32) NOT NULL,`F4` varchar(32) NOT NULL,`F5` varchar(32) NOT NULL,`F6` varchar(32) NOT NULL,`GFFID` int(3) NOT NULL,`GFOWNER` int(3) NOT NULL,`GFKILLS` int(5) NOT NULL,`GFDEATHS` int(5) NOT NULL,`Influence` int(11) NOT NULL,`InfluenceWinner` int(11) NOT NULL,PRIMARY KEY (`fID`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_multiaccounts` (`Name` varchar(24) NOT NULL,`Datum` date NOT NULL,`Uhrzeit` time NOT NULL,`Admin` varchar(24) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_weapons` (`Name` varchar(24) NOT NULL,`Waffen0` int(3) NOT NULL,`Waffen1` int(3) NOT NULL,`Waffen2` int(3) NOT NULL,`Waffen3` int(3) NOT NULL,`Waffen4` int(3) NOT NULL,`Waffen5` int(3) NOT NULL,`Waffen6` int(3) NOT NULL,`Waffen7` int(3) NOT NULL,`Waffen8` int(3) NOT NULL,`Waffen9` int(3) NOT NULL,`Waffen10` int(3) NOT NULL,`Waffen11` int(3) NOT NULL,`Waffen12` int(3) NOT NULL,");
strcat(query,"`Ammo0` int(10) NOT NULL,`Ammo1` int(10) NOT NULL,`Ammo2` int(10) NOT NULL,`Ammo3` int(10) NOT NULL,`Ammo4` int(10) NOT NULL,`Ammo5` int(10) NOT NULL,`Ammo6` int(10) NOT NULL,`Ammo7` int(10) NOT NULL,`Ammo8` int(10) NOT NULL,`Ammo9` int(10) NOT NULL,`Ammo10` int(10) NOT NULL,`Ammo11` int(10) NOT NULL,`Ammo12` int(10) NOT NULL,PRIMARY KEY (`Name`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_races` (`race` varchar(32) NOT NULL,`fID` int(3) NOT NULL,`X1` float(10,4) NOT NULL,`Y1` float(10,4) NOT NULL,`Z1` float(10,4) NOT NULL,`X2` float(10,4) NOT NULL,`Y2` float(10,4) NOT NULL,`Z2` float(10,4) NOT NULL,`X3` float(10,4) NOT NULL,`Y3` float(10,4) NOT NULL,`Z3` float(10,4) NOT NULL,`X4` float(10,4) NOT NULL,`Y4` float(10,4) NOT NULL,`Z4` float(10,4) NOT NULL,`X5` float(10,4) NOT NULL,`Y5` float(10,4) NOT NULL,`Z5` float(10,4) NOT NULL,");
strcat(query,"`X6` float(10,4) NOT NULL,`Y6` float(10,4) NOT NULL,`Z6` float(10,4) NOT NULL,`X7` float(10,4) NOT NULL,`Y7` float(10,4) NOT NULL,`Z7` float(10,4) NOT NULL,`X8` float(10,4) NOT NULL,`Y8` float(10,4) NOT NULL,`Z8` float(10,4) NOT NULL,`X9` float(10,4) NOT NULL,`Y9` float(10,4) NOT NULL,`Z9` float(10,4) NOT NULL,`X10` float(10,4) NOT NULL,`Y10` float(10,4) NOT NULL,`Z10` float(10,4) NOT NULL,`X11` float(10,4) NOT NULL,`Y11` float(10,4) NOT NULL,`Z11` float(10,4) NOT NULL,");
strcat(query,"`X12` float(10,4) NOT NULL,`Y12` float(10,4) NOT NULL,`Z12` float(10,4) NOT NULL,`X13` float(10,4) NOT NULL,`Y13` float(10,4) NOT NULL,`Z13` float(10,4) NOT NULL,`X14` float(10,4) NOT NULL,`Y14` float(10,4) NOT NULL,`Z14` float(10,4) NOT NULL,`X15` float(10,4) NOT NULL,`Y15` float(10,4) NOT NULL,`Z15` float(10,4) NOT NULL,`X16` float(10,4) NOT NULL,`Y16` float(10,4) NOT NULL,`Z16` float(10,4) NOT NULL,`X17` float(10,4) NOT NULL,`Y17` float(10,4) NOT NULL,`Z17` float(10,4) NOT NULL,");
strcat(query,"`X18` float(10,4) NOT NULL,`Y18` float(10,4) NOT NULL,`Z18` float(10,4) NOT NULL,`X19` float(10,4) NOT NULL,`Y19` float(10,4) NOT NULL,`Z19` float(10,4) NOT NULL,`X20` float(10,4) NOT NULL,`Y20` float(10,4) NOT NULL,`Z20` float(10,4) NOT NULL,`X21` float(10,4) NOT NULL,`Y21` float(10,4) NOT NULL,`Z21` float(10,4) NOT NULL,`X22` float(10,4) NOT NULL,`Y22` float(10,4) NOT NULL,`Z22` float(10,4) NOT NULL,`X23` float(10,4) NOT NULL,`Y23` float(10,4) NOT NULL,`Z23` float(10,4) NOT NULL,");
strcat(query,"`X24` float(10,4) NOT NULL,`Y24` float(10,4) NOT NULL,`Z24` float(10,4) NOT NULL,`X25` float(10,4) NOT NULL,`Y25` float(10,4) NOT NULL,`Z25` float(10,4) NOT NULL,`X26` float(10,4) NOT NULL,`Y26` float(10,4) NOT NULL,`Z26` float(10,4) NOT NULL,`X27` float(10,4) NOT NULL,`Y27` float(10,4) NOT NULL,`Z27` float(10,4) NOT NULL,`X28` float(10,4) NOT NULL,`Y28` float(10,4) NOT NULL,`Z28` float(10,4) NOT NULL,`X29` float(10,4) NOT NULL,`Y29` float(10,4) NOT NULL,`Z29` float(10,4) NOT NULL,");
strcat(query,"`X30` float(10,4) NOT NULL,`Y30` float(10,4) NOT NULL,`Z30` float(10,4) NOT NULL,`X31` float(10,4) NOT NULL,`Y31` float(10,4) NOT NULL,`Z31` float(10,4) NOT NULL,`X32` float(10,4) NOT NULL,`Y32` float(10,4) NOT NULL,`Z32` float(10,4) NOT NULL,`X33` float(10,4) NOT NULL,`Y33` float(10,4) NOT NULL,`Z33` float(10,4) NOT NULL,`X34` float(10,4) NOT NULL,`Y34` float(10,4) NOT NULL,`Z34` float(10,4) NOT NULL,`X35` float(10,4) NOT NULL,`Y35` float(10,4) NOT NULL,`Z35` float(10,4) NOT NULL,");
strcat(query,"PRIMARY KEY (`race`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_vehicle` (`id` int(11) NOT NULL AUTO_INCREMENT,`name` varchar(24) NOT NULL,`slot` int(2) NOT NULL,`modelid` int(4) NOT NULL,`x` float(10,4) NOT NULL,`y` float(10,4) NOT NULL,");
strcat(query,"`z` float(10,4) NOT NULL,`a` float(10,4) NOT NULL,`interior` int(4) NOT NULL,`world` int(11) NOT NULL,`cc1` int(4) NOT NULL,`cc2` int(4) NOT NULL,`paintjob` int(2) NOT NULL,`vehhp` float(10,4) NOT NULL,`abgeschlossen` int(2) NOT NULL,`t1` int(4) NOT NULL,`t2` int(4) NOT NULL,`t3` int(4) NOT NULL,`t4` int(4) NOT NULL,`t5` int(4) NOT NULL,`t6` int(4) NOT NULL,`t7` int(4) NOT NULL,");
strcat(query,"`t8` int(4) NOT NULL,`t9` int(4) NOT NULL,`t10` int(4) NOT NULL,`t11` int(4) NOT NULL,`t12` int(4) NOT NULL,`t13` int(4) NOT NULL,`t14` int(4) NOT NULL,`Armourplating` int(2) NOT NULL,`TrackingDevice` int(2) NOT NULL,`angemeldet` int(2) NOT NULL,`atime` int(18) NOT NULL,`atanmeldung` int(2) NOT NULL,`preis` int(11) NOT NULL,`nummernschild` varchar(32) NOT NULL,`neon` int(2) NOT NULL,`motordown` int(2) NOT NULL,`failgas` int(2) NOT NULL,`tank` float(10,4) NOT NULL,");
strcat(query,"`km` int(11) NOT NULL,`towed` int(2) NOT NULL,`towedfreeprice` int(11) NOT NULL,`towedreason` varchar(32) NOT NULL,`kganja` int(11) NOT NULL,");
strcat(query,"`kkokain` int(11) NOT NULL,`kopium` int(11) NOT NULL,`kmats` int(11) NOT NULL,`klunch` int(11) NOT NULL,`kc4` int(11) NOT NULL,`kwkanister` int(11) NOT NULL,`kkanister` int(11) NOT NULL,`handbrake` int(2) NOT NULL,`InGarage` int(4) NOT NULL,PRIMARY KEY (`id`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_licenses` (`Name` varchar(24) NOT NULL,`car` int(2) NOT NULL,`bike` int(2) NOT NULL,`roller` int(2) NOT NULL,`boat` int(2) NOT NULL,`plane` int(2) NOT NULL,`helicopter` int(2) NOT NULL,`weapon` int(2) NOT NULL,`fishing` int(2) NOT NULL,`personality` int(2) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_fish` (`Name` varchar(24) NOT NULL,`FishID0` int(3) NOT NULL,`FishID1` int(3) NOT NULL,`FishID2` int(3) NOT NULL,`FishID3` int(3) NOT NULL,`FishID4` int(3) NOT NULL,`FishID5` int(3) NOT NULL,`Fishweight0` int(10) NOT NULL,`Fishweight1` int(10) NOT NULL,`Fishweight2` int(10) NOT NULL,`Fishweight3` int(10) NOT NULL,`Fishweight4` int(10) NOT NULL,`Fishweight5` int(10) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
strcat(query,"ALTER TABLE `"#SQLTAG"_account_licenses` ADD COLUMN (`pArchs0` int(2) NOT NULL");
for(new i=1;i<MAX_ARCHIVMENTS;i++)
{
format(query,sizeof(query),"%s, `pArchs%i` int(2) NOT NULL",query,i);
}
strcat(query,")");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_koffer` (`Name` varchar(24) NOT NULL,`Slot0` int(10) NOT NULL,`Slot1` int(10) NOT NULL,`Slot2` int(10) NOT NULL,`Slot3` int(10) NOT NULL,`Slot4` int(10) NOT NULL,`Slot5` int(10) NOT NULL,`Slot6` int(10) NOT NULL,`Slot7` int(10) NOT NULL,`Slot8` int(10) NOT NULL,`Slot9` int(10) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_blacklist` (`Name` varchar(24) NOT NULL");
for(new fID=0;fID<MAX_FRAKTIONNEN;fID++)
{
strcat(query,",");
mysql_format(MySqlConnection,query,sizeof(query),"%s`blacklist%i` varchar(32) NOT NULL",query,fID);
strcat(query,",");
mysql_format(MySqlConnection,query,sizeof(query),"%s`blacklistreason%i` int(2) NOT NULL",query,fID);
}
strcat(query,",PRIMARY KEY (`Name`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_inventar` (`Name` varchar(24) NOT NULL,`c4` int(10) NOT NULL,`bomben` int(10) NOT NULL,`materials` int(10) NOT NULL,`material_packs` int(10) NOT NULL,`lunchpakets` int(10) NOT NULL,`navi` int(10) NOT NULL,`helm` int(10) NOT NULL,`angel` int(10) NOT NULL,`angelkoeder` int(10) NOT NULL,`repairboxxes` int(10) NOT NULL,`refillgalons` int(10) NOT NULL,`koffer` int(10) NOT NULL,");
strcat(query,"`zigarrets` int(10) NOT NULL,`alcohol` int(10) NOT NULL,`pfandflaschen` int(10) NOT NULL,`ganja` int(10) NOT NULL,`kokain` int(10) NOT NULL,`opium` int(10) NOT NULL,`ganjaseats` int(10) NOT NULL,`kokainseats` int(10) NOT NULL,`opiumseats` int(10) NOT NULL,`callbook` int(10) NOT NULL,`condoms` int(10) NOT NULL,`brecheisen` int(10) NOT NULL,`duenger` int(10) NOT NULL,PRIMARY KEY (`Name`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_banksafe` (`Name` varchar(24) NOT NULL,`safetresor` int(2) NOT NULL,`ganja` int(10) NOT NULL,`kokain` int(10) NOT NULL,`opium` int(10) NOT NULL,`materials` int(10) NOT NULL,`c4` int(10) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_networktowers` (`id` int(12) NOT NULL,`X` float(10,4) NOT NULL,`Y` float(10,4) NOT NULL,`Z` float(10,4) NOT NULL,`HP` int(4) NOT NULL,PRIMARY KEY (`id`))",false,"","");
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_advertismentboards` (`id` int(3) NOT NULL,`Text` varchar(64) NOT NULL,PRIMARY KEY (`id`))",false,"","");
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_whitelist` (`Name` varchar(24) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_blackmarket` (`id` int(12) NOT NULL,`sfraktid` int(4) NOT NULL,`sbdfraktid` int(4) NOT NULL,`sx` float(10,4) NOT NULL,`sy` float(10,4) NOT NULL,`sz` float(10,4) NOT NULL,`slocked` int(2) NOT NULL,`smaterials` int(18) NOT NULL,`swerbetext` varchar(128) NOT NULL,`sprice` int(18) NOT NULL,`skasse` int(18) NOT NULL,");
strcat(query,"`sartikel0` int(18) NOT NULL,`sartikel1` int(18) NOT NULL,`sartikel2` int(18) NOT NULL,`sartikel3` int(18) NOT NULL,`sartikel4` int(18) NOT NULL,`sartikel5` int(18) NOT NULL,`sartikel6` int(18) NOT NULL,`sartikel7` int(18) NOT NULL,`sartikel8` int(18) NOT NULL,`sartikel9` int(18) NOT NULL,`sartikel10` int(18) NOT NULL,`sartikel11` int(18) NOT NULL,`sartikel12` int(18) NOT NULL,`sartikel13` int(18) NOT NULL,");
strcat(query,"`sattackerfraktid` int(4) NOT NULL,`swarownerpoints` int(8) NOT NULL,`swarattackerpoints` int(8) NOT NULL,`swartime` int(128) NOT NULL,`swarsleep` int(128) NOT NULL,PRIMARY KEY (`id`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_account_autologin` (`Name` varchar(24) NOT NULL,`IP` varchar(16) NOT NULL,PRIMARY KEY (`Name`))",false,"","");
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_bugs` (`id` int(100) NOT NULL AUTO_INCREMENT,`Writer` varchar(30) NOT NULL,`Text` varchar(256) NOT NULL,`Priorität` varchar(64) NOT NULL,`Tick` varchar(12) NOT NULL,`Uhrzeit` time NOT NULL,`Datum` date NOT NULL,PRIMARY KEY (`id`))",false,"","");
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SQLTAG"_organisations` (`id` int(11) NOT NULL,`OrgName` varchar(64) NOT NULL,`OrgOwner` varchar(24) NOT NULL,`OrgMotto` varchar(128) NOT NULL,PRIMARY KEY (`id`))",false,"","");
return 1;
}
Alles anzeigen