Beiträge von Crocky

stock CreateTables()
{
new query[4000];
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SERVERTAG"_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 "#SERVERTAG"_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,");
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,`TimeAfterRegister` int(12) NOT NULL,");
strcat(query,"`Time4Payday` int(3) NOT NULL,`HabGeworben` int(2) NOT NULL,`pPremium` 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,`DigiHud` int(2) 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 "#SERVERTAG"_account_main ADD COLUMN (`pMarried` varchar(24) NOT NULL,`pBuyClothes` 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 `"#SERVERTAG"_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 `"#SERVERTAG"_properties` (`id` int(12) 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(8) 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(12) NOT NULL,`haus_level` int(4) NOT NULL,`haus_geldkasse` int(12) NOT NULL,`haus_Opium` int(12) NOT NULL,");
strcat(query,"`haus_c4` int(12) NOT NULL,`haus_Ganja` int(12) NOT NULL,`haus_Kokain` int(12) NOT NULL,`haus_materials` int(12) NOT NULL,`haus_heal` int(12) NOT NULL,`haus_armour` int(12) NOT NULL,`haus_hatheal` int(12) NOT NULL,`haus_hatarmour` int(12) NOT NULL,`hausgundumper` int(2) NOT NULL,");
strcat(query,"`hausgun0` int(3) NOT NULL,`hausgun1` int(3) NOT NULL,`hausgun2` int(3) NOT NULL,`hausgun3` int(3) NOT NULL,`hausgun4` int(3) NOT NULL,`hausgun5` int(3) NOT NULL,`hausgun6` int(3) NOT NULL,`hausgun7` int(3) NOT NULL,`hausgun8` int(3) NOT NULL,`hausgun9` int(3) NOT NULL,`hausgun10` int(3) NOT NULL,`hausgun11` int(3) NOT NULL,`hausgun12` int(3) NOT NULL,");
strcat(query,"`hausgunammo0` int(8) NOT NULL,`hausgunammo1` int(8) NOT NULL,`hausgunammo2` int(8) NOT NULL,`hausgunammo3` int(8) NOT NULL,`hausgunammo4` int(8) NOT NULL,`hausgunammo5` int(8) NOT NULL,`hausgunammo6` int(8) NOT NULL,`hausgunammo7` int(8) NOT NULL,`hausgunammo8` int(8) NOT NULL,`hausgunammo9` int(8) NOT NULL,`hausgunammo10` int(8) NOT NULL,`hausgunammo11` int(8) NOT NULL,`hausgunammo12` int(8) NOT NULL,`hausmull` int(3) NOT NULL,`haus_msg` varchar(150) NOT NULL,PRIMARY KEY (`id`))");
mysql_function_query(MySqlConnection,query,false,"","");
strdel(query,0,sizeof(query));
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SERVERTAG"_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_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 `"#SERVERTAG"_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,"","");
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SERVERTAG"_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 `"#SERVERTAG"_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 `"#SERVERTAG"_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 `"#SERVERTAG"_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 `"#SERVERTAG"_gangwar` (`GangZoneID` int(3) NOT NULL,`GangWarZoneOwner` int(5) NOT NULL,`GangWarZoneAttacker` int(5) NOT NULL,`War_OwnerPoints` int(4) NOT NULL,`War_AttackerPoints` int(4) NOT NULL,`War_Started` int(2) NOT NULL,`War_Time` int(12) NOT NULL,`War_Sperre` int(20) NOT NULL,PRIMARY KEY (`GangZoneID`))",false,"","");
mysql_function_query(MySqlConnection,"CREATE TABLE IF NOT EXISTS `"#SERVERTAG"_fraktion_motd` (`fID` int(12) NOT NULL,`Text` varchar(128) NOT NULL,PRIMARY KEY (`fID`))",false,"","");
strcat(query,"CREATE TABLE IF NOT EXISTS `"#SERVERTAG"_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,`Kirchensteuer` 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,`TerrorContractRang` 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,`SAFDpay` 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 `"#SERVERTAG"_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(3) NOT NULL,`GFDEATHS` int(3) 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 `"#SERVERTAG"_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 `"#SERVERTAG"_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 `"#SERVERTAG"_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,");
...