26.12.2015, 12:24
I am having issues on creating a table, I have tried using strcat and everything works fine (the debug_fcrp.txt returns an executable query) but for SQLite Application it doesn't, The query is not processed due to the massive amount of columns to be created. I have tried executing the debug results on the application as well and it crashes the application, any idea how i can resolve this issue? I have tried creating them one by one by repeating use of CREATE TABLE but ehh it doesn't work
Code:
( THAT STRING SIZE DOE! )
Code:
( THAT STRING SIZE DOE! )
Код:
new query_string[13950];
Database = db_open("fc-rp.db");
// users
strcat(query_string, "CREATE TABLE IF NOT EXISTS `users` ");
strcat(query_string, "(`Key` STR, `AdminLevel` INT, `Band` INT, `PermBand` INT, `Warnings` INT, `LogWarnings` INT, `Disabled` INT, `DonateRank` INT, `BanAppealer` INT, `ShopTech` INT, `VehModder` INT, `CarInsurance` INT, `Undercover` INT, `TogReports` INT, `Radio` INT, `RadioFreq` INT, `UpgradePoints` INT, `ConnectedTime` INT, `Registered` INT, `Sex` INT, `Age` INT, `Origin` INT,");
strcat(query_string, " `Muted` INT, `Money` INT, `Bank` INT, `Crimes` INT, `Accent` INT, `CHits` INT, `FHits` INT, `Arrested` INT, `Phonebook` INT, `LottorNr` INT, Fishes` INT, `BiggestFish` INT, `Job` INT, `Job2` INT, `Paycheck` INT, `HeadValue` INT, `Jailed` INT, `JailTime` INT, `WRestricted` INT, `Materials` INT, `Packages` INT, `Crates` INT, `Pot` INT, `Heroin` INT, `Crack` INT,");
strcat(query_string, " `Meth` INT, `BatteryAcid` INT, `CrackStuff` INT, `ColdMeds` INT, `Leader` INT, `Member` INT, `Division` INT, `FMember` INT, `Rank` INT, `LawSkill` INT, `MechSkill` INT, `DrugsSkill` INT, `SmuggerSkill` INT, `FishSkill` INT, `FightingStyle` INT, `pHealth` FLOAT, `pArmor` FLOAT, `pSHealth` FLOAT, `Int` INT, `Local` INT, `VirtualWorld` INT, `HouseInvite` INT,");
strcat(query_string, " `Model` INT, `Clothes` INT, `PhoneNr` INT, `Apartment` INT, `Apartment2` INT, `Apartment3` INT, `Renting` INT, `CarLic` INT, `CarLicP` INT, `FlyLic` INT, `BoatLic` INT, `FishLic` INT, `CheckCash` INT, `Checks` INT, `GunLic` INT, `WeedLic` INT, `Gun0` INT, `GunAmmo0` INT, `Gun1` INT, `GunAmmo1` INT, `Gun2` INT, `GunAmmo2` INT, `Gun3` INT, `GunAmmo3` INT,");
strcat(query_string, " `Gun4` INT, `GunAmmo4` INT, `Gun5` INT, `GunAmmo5` INT, `Gun6` INT, `GunAmmo6` INT, `Gun7` INT, `GunAmmo7` INT, `Gun8` INT, `GunAmmo8` INT, `Gun9` INT, `GunAmmo9` INT, `Gun10` INT, `GunAmmo10` INT, `Gun11` INT, `GunAmmo11` INT, `DrugsTime` INT, `LawyerTime` INT, `LawyerFreeTime` INT, `MechTime` INT, `PayDay` INT, `PayDayHad` INT, `CDPlayer` INT, `Dice` INT");
strcat(query_string, " `Spraycan` INT, `Rope` INT, `Rag` INT, `FuelCan` INT, `Cigars` INT, `Sprunk` INT, `Mask` INT, `Bombs` INT, `Tutorial` INT, `OnDuty` INT, `Hospital` INT, `Adjustable` INT, `Married` INT, `MarriedTo` STR, `ContractBy` STR, `ContractDetail` STR, `IP` STR, `WantedLevel` INT, `9mmsSkill` INT, `SilencedSkill` INT, `DeagleSkill` INT, `ShotgunSkill` INT, `SawnoffSkill` INT");
strcat(query_string, " `SpasSkill` INT, `UziSkill` INT, `Mp5Skill` INT, `AKSkill` INT, `M4Skill` INT, `Insurance` INT, `NewMuted` INT, `NewMutedTotal` INT, `AdMuted` INT, `AdMutedTotal` INT, `OOCMuted` INT, `OOCMutedTotal` INT, `AMMuted` INT, `AMMutedTotal` INT, `CMuted` INT, `SPos_x` FLOAT, `SPos_y` FLOAT, `SPos_z` FLOAT, `SPos_r` FLOAT, `Helper` INT, `ReportMuted` INT, `ReportMutedTotal` INT,");
strcat(query_string, " `ReportMutedTime` INT, `VIPMuted` INT, `VIPMutedTime` INT, `GiftTime` INT, `RobTime` INT, `WepTime` INT, `AcceptedHelp` INT, `AcceptReport` INT, `TrashReport` INT, `FactionModerator` INT, `GangModerator` INT, `GangWarn` INT, `FactionBanned` INT, `CSFBanned` INT, `Dispatch` INT");
strcat(query_string, ")");
db_query(Database, query_string);
format(query_string, sizeof(query_string), "");
// DO NOT CHANGE THE BELOWS CODE UNLESS YOU KNOW WHAT YOU ARE DOING - JAKE
// Player Vehicles
strcat(query_string, "CREATE TABLE IF NOT EXISTS `users` ");
strcat(query_string, "(`pv0PosX` FLOAT, `pv0PosY` FLOAT, `pv0PosZ` FLOAT, `pv0PosAngle` FLOAT, `pv0ModelId` INT, `pv0Lock` INT, `pv0Locked` INT, `pv0Insurance` INT, `pv0PaintJob` INT, `pv0Color1` INT, `pv0Color2` INT,");
strcat(query_string, " `pv0Price` INT, `pv0Ticket` INT, `pv0Weapon0` INT, `pv0Weapon1` INT, `pv0Weapon2` INT, `pv0WepAmmo0` INT, `pv0WepAmmo1` INT, `pv0WepAmmo2` INT, `pv0WepUpgrade` INT, `pv0Fuel` FLOAT, `pv0Impound` INT, `pv0Plate` STR, `pv0BLock` INT, `pv0BLocked` INT, `pv0EZPass` INT, `pv0TicketReason STR,");
strcat(query_string, " `pv1PosX` FLOAT, `pv1PosY` FLOAT, `pv1PosZ` FLOAT, `pv1PosAngle` FLOAT, `pv1ModelId` INT, `pv1Lock` INT, `pv1Locked` INT, `pv1Insurance` INT, `pv1PaintJob` INT, `pv1Color1` INT, `pv1Color2` INT,");
strcat(query_string, " `pv1Price` INT, `pv1Ticket` INT, `pv1Weapon0` INT, `pv1Weapon1` INT, `pv1Weapon2` INT, `pv1WepAmmo0` INT, `pv1WepAmmo1` INT, `pv1WepAmmo2` INT, `pv1WepUpgrade` INT, `pv1Fuel` FLOAT, `pv1Impound` INT, `pv1Plate` STR, `pv1BLock` INT, `pv1BLocked` INT, `pv1EZPass` INT, `pv1TicketReason STR,");
strcat(query_string, " `pv2PosX` FLOAT, `pv2PosY` FLOAT, `pv2PosZ` FLOAT, `pv2PosAngle` FLOAT, `pv2ModelId` INT, `pv2Lock` INT, `pv2Locked` INT, `pv2Insurance` INT, `pv2PaintJob` INT, `pv2Color1` INT, `pv2Color2` INT,");
strcat(query_string, " `pv2Price` INT, `pv2Ticket` INT, `pv2Weapon0` INT, `pv2Weapon1` INT, `pv2Weapon2` INT, `pv2WepAmmo0` INT, `pv2WepAmmo1` INT, `pv2WepAmmo2` INT, `pv2WepUpgrade` INT, `pv2Fuel` FLOAT, `pv2Impound` INT, `pv2Plate` STR, `pv2BLock` INT, `pv2BLocked` INT, `pv2EZPass` INT, `pv2TicketReason STR,");
strcat(query_string, " `pv3PosX` FLOAT, `pv3PosY` FLOAT, `pv3PosZ` FLOAT, `pv3PosAngle` FLOAT, `pv3ModelId` INT, `pv3Lock` INT, `pv3Locked` INT, `pv3Insurance` INT, `pv3PaintJob` INT, `pv3Color1` INT, `pv3Color2` INT,");
strcat(query_string, " `pv3Price` INT, `pv3Ticket` INT, `pv3Weapon0` INT, `pv3Weapon1` INT, `pv3Weapon2` INT, `pv3WepAmmo0` INT, `pv3WepAmmo1` INT, `pv3WepAmmo2` INT, `pv3WepUpgrade` INT, `pv3Fuel` FLOAT, `pv3Impound` INT, `pv3Plate` STR, `pv3BLock` INT, `pv3BLocked` INT, `pv3EZPass` INT, `pv3TicketReason STR,");
strcat(query_string, " `pv4PosX` FLOAT, `pv4PosY` FLOAT, `pv4PosZ` FLOAT, `pv4PosAngle` FLOAT, `pv4ModelId` INT, `pv4Lock` INT, `pv4Locked` INT, `pv4Insurance` INT, `pv4PaintJob` INT, `pv4Color1` INT, `pv4Color2` INT,");
strcat(query_string, " `pv4Price` INT, `pv4Ticket` INT, `pv4Weapon0` INT, `pv4Weapon1` INT, `pv4Weapon2` INT, `pv4WepAmmo0` INT, `pv4WepAmmo1` INT, `pv4WepAmmo2` INT, `pv4WepUpgrade` INT, `pv4Fuel` FLOAT, `pv4Impound` INT, `pv4Plate` STR, `pv4BLock` INT, `pv4BLocked` INT, `pv4EZPass` INT, `pv4TicketReason STR,");
strcat(query_string, " `pv5PosX` FLOAT, `pv5PosY` FLOAT, `pv5PosZ` FLOAT, `pv5PosAngle` FLOAT, `pv5ModelId` INT, `pv5Lock` INT, `pv5Locked` INT, `pv5Insurance` INT, `pv5PaintJob` INT, `pv5Color1` INT, `pv5Color2` INT,");
strcat(query_string, " `pv5Price` INT, `pv5Ticket` INT, `pv5Weapon0` INT, `pv5Weapon1` INT, `pv5Weapon2` INT, `pv5WepAmmo0` INT, `pv5WepAmmo1` INT, `pv5WepAmmo2` INT, `pv5WepUpgrade` INT, `pv5Fuel` FLOAT, `pv5Impound` INT, `pv5Plate` STR, `pv5BLock` INT, `pv5BLocked` INT, `pv5EZPass` INT, `pv5TicketReason STR,");
strcat(query_string, " `pv6PosX` FLOAT, `pv6PosY` FLOAT, `pv6PosZ` FLOAT, `pv6PosAngle` FLOAT, `pv6ModelId` INT, `pv6Lock` INT, `pv6Locked` INT, `pv6Insurance` INT, `pv6PaintJob` INT, `pv6Color1` INT, `pv6Color2` INT,");
strcat(query_string, " `pv6Price` INT, `pv6Ticket` INT, `pv6Weapon0` INT, `pv6Weapon1` INT, `pv6Weapon2` INT, `pv6WepAmmo0` INT, `pv6WepAmmo1` INT, `pv6WepAmmo2` INT, `pv6WepUpgrade` INT, `pv6Fuel` FLOAT, `pv6Impound` INT, `pv6Plate` STR, `pv6BLock` INT, `pv6BLocked` INT, `pv6EZPass` INT, `pv6TicketReason STR");
strcat(query_string, ")");
db_query(Database, query_string);
// Player Toys
format(query_string, sizeof(query_string), "");
strcat(query_string, "CREATE TABLE IF NOT EXISTS `users` ");
strcat(query_string, "(`pt0ModelID` INT, `pt0Bone` INT, `pt0PosX` FLOAT, `pt0PosY` FLOAT, `pt0PosZ` FLOAT, `pt0RotX` FLOAT, `pt0RotY` FLOAT, `pt0RotZ` FLOAT, `pt0ScaleX` FLOAT, `pt0ScaleY` FLOAT, `pt0ScaleZ` FLOAT,");
strcat(query_string, " `pt1ModelID` INT, `pt1Bone` INT, `pt1PosX` FLOAT, `pt1PosY` FLOAT, `pt1PosZ` FLOAT, `pt1RotX` FLOAT, `pt1RotY` FLOAT, `pt1RotZ` FLOAT, `pt1ScaleX` FLOAT, `pt1ScaleY` FLOAT, `pt1ScaleZ` FLOAT,");
strcat(query_string, " `pt2ModelID` INT, `pt2Bone` INT, `pt2PosX` FLOAT, `pt2PosY` FLOAT, `pt2PosZ` FLOAT, `pt2RotX` FLOAT, `pt2RotY` FLOAT, `pt2RotZ` FLOAT, `pt2ScaleX` FLOAT, `pt2ScaleY` FLOAT, `pt2ScaleZ` FLOAT,");
strcat(query_string, " `pt3ModelID` INT, `pt3Bone` INT, `pt3PosX` FLOAT, `pt3PosY` FLOAT, `pt3PosZ` FLOAT, `pt3RotX` FLOAT, `pt3RotY` FLOAT, `pt3RotZ` FLOAT, `pt3ScaleX` FLOAT, `pt3ScaleY` FLOAT, `pt3ScaleZ` FLOAT,");
strcat(query_string, " `pt4ModelID` INT, `pt4Bone` INT, `pt4PosX` FLOAT, `pt4PosY` FLOAT, `pt4PosZ` FLOAT, `pt4RotX` FLOAT, `pt4RotY` FLOAT, `pt4RotZ` FLOAT, `pt4ScaleX` FLOAT, `pt4ScaleY` FLOAT, `pt4ScaleZ` FLOAT,");
strcat(query_string, " `pt5ModelID` INT, `pt5Bone` INT, `pt5PosX` FLOAT, `pt5PosY` FLOAT, `pt5PosZ` FLOAT, `pt5RotX` FLOAT, `pt5RotY` FLOAT, `pt5RotZ` FLOAT, `pt5ScaleX` FLOAT, `pt5ScaleY` FLOAT, `pt5ScaleZ` FLOAT,");
strcat(query_string, " `pt6ModelID` INT, `pt6Bone` INT, `pt6PosX` FLOAT, `pt6PosY` FLOAT, `pt6PosZ` FLOAT, `pt6RotX` FLOAT, `pt6RotY` FLOAT, `pt6RotZ` FLOAT, `pt6ScaleX` FLOAT, `pt6ScaleY` FLOAT, `pt6ScaleZ` FLOAT,");
strcat(query_string, " `pt7ModelID` INT, `pt7Bone` INT, `pt7PosX` FLOAT, `pt7PosY` FLOAT, `pt7PosZ` FLOAT, `pt7RotX` FLOAT, `pt7RotY` FLOAT, `pt7RotZ` FLOAT, `pt7ScaleX` FLOAT, `pt7ScaleY` FLOAT, `pt7ScaleZ` FLOAT,");
strcat(query_string, " `pt8ModelID` INT, `pt8Bone` INT, `pt8PosX` FLOAT, `pt8PosY` FLOAT, `pt8PosZ` FLOAT, `pt8RotX` FLOAT, `pt8RotY` FLOAT, `pt8RotZ` FLOAT, `pt8ScaleX` FLOAT, `pt8ScaleY` FLOAT, `pt8ScaleZ` FLOAT,");
strcat(query_string, " `pt9ModelID` INT, `pt9Bone` INT, `pt9PosX` FLOAT, `pt9PosY` FLOAT, `pt9PosZ` FLOAT, `pt9RotX` FLOAT, `pt9RotY` FLOAT, `pt9RotZ` FLOAT, `pt9ScaleX` FLOAT, `pt9ScaleY` FLOAT, `pt9ScaleZ` FLOAT");
strcat(query_string, ")");
db_query(Database, query_string);
//
format(query_string, sizeof(query_string), "");
strcat(query_string, "CREATE TABLE IF NOT EXISTS `users` ");
strcat(query_string, "(`VIPInviteDay` INT, `TempVIP` INT, `BuddyInvite` INT, `Tokens` INT, `TriageTime` INT, `PrisonedBy` STR, `PrisonReason` STR, `Flag` STR, `TaxiLicense` INT, `TicketTime` INT, `Screwdriver` INT, `Smslog` INT, `Wristwatch` INT, `Surveillance` INT, `Tire` INT, `Firstaid` INT, `Receiver` INT, `GPS` INT, `Sweep` INT, `SweepLeft` INT, `Bugged` INT, `Smslog0` STR, `Smslog1` STR, `Smslog2` STR,");
strcat(query_string, " `Smslog3` STR, `Smslog4` STR, `Smslog5` STR, `Smslog6` STR, `Smslog7` STR, `Smslog8` STR, `Smslog9` STR, `KillLog0` STR, `KillLog1` STR, `KillLog2` STR, `KillLog3` STR, `KillLog4` STR, `KillLog5` STR, `KillLog6` STR, `KillLog7` STR, `KillLog8` STR, `KillLog9` STR,");
strcat(query_string, " `Hospital` INT, `pWExists` INT, `pWX` FLOAT, `pWY` FLOAT, `pWZ` FLOAT, `pWVW` INT, `pWInt` INT, `pWValue` INT, `pWSeeds` INT, `pRawOpium` INT, `Syringes` INT, `SpeedTickets` INT, `Warrants` STR, `JudgeJailTime` INT, `JudgeJailType` INT, `BeingSentenced` INT, `ProbationTime` INT, `OBlocked` INT,");
strcat(query_string, " `CallsAccepted` INT, `PatientsDelivered` INT, `LiveBanned` INT, `FreezeBank` INT, `pHasStereo` INT, `pTogRadio` INT, `pHasGPS` INT, `pUnListed` INT, `pHasCarJack` INT, `pJackAttempts` INT, `pReportsAccepted` INT, `pAMSSent` INT, `pBadgeNum` INT, `pEmail` STR, `p911sAccepted` INT, `pArrestsMade` INT, `pInfractionsIssued` INT,");
strcat(query_string, " `Vmsg1` STR, `Vmsg2` STR, `Vmsg3` STR, `Vmsg4` STR, `Vmsg5` STR, `Vnum1` STR, `Vnum2` STR, `Vnum3` STR, `VNum4` STR, `Vnum5` STR, `EnrolledEZPass` INT, `Statch` STR, `ChopShopped` STR, `Deported` INT, `AMuteTime` INT, `CMuteTime` INT, `AdMuteTime` INT, `NMuteTime` INT, `DeportTime` INT, `pOOCMuteTime` INT, `handleName` STR");
strcat(query_string, ")");
db_query(Database, query_string);
