I added some useful sql statements. Save them into a .txt file and rename to .sql, then load the sql file in the table's sql execute interface.
Code: Select all
-- Game Data -- \nselect * from GameData;
-- Game Character List -- \nselect * from GameCharacter;
-- Columns in Game Character Table -- \nPRAGMA table_info(GameCharacter);
-- Character List --\nselect gc.displayName, c.* from GameCharacter gc, Character c where c._id = gc.gameCharacterId;
-- Set Health to 200 --\nupdate Character set health=200, spirit=100;
-- Pay Crew --\nupdate GameCharacter set payTurn = (select turn from GameData limit 1);
-- Refuel Ship --\nUpdate GameShip set fuel = 600 where mapZoneId = -1;
-- Clear Last Talents Used --\nupdate GameTalent set talentUsedTurn=0;
-- Set Max Contact Influence --\nupdate GameContact set influenceScore = influenceScoreMax where influenceScore < influenceScoreMax;
-- Set Contact Reputation to 50 --\nupdate GameContact set contactRep = 50 where contactRep < 50;
-- Clear Ship Component Damage--\nupdate GameContact set contactRep = 50 where contactRep < 50;
-- Table List -- \nselect name, tbl_name from sqlite_master where type = 'table';
-- Character List --\nselect gc.displayName, c.* from GameCharacter gc, Character c where c._id = gc.gameCharacterId;
--Update JobLevel--\nupdate gamejob set joblevel = 15 where gamecharacterid = 1;\nselect * from gamejob;
-- Faction Reputation --\nupdate characterrank set rep = 300 where rep > 0;\nselect * from characterrank;
-- True Insert Trait -- \ninsert into gamecharactertrait (gamecharacterid, traitid, characterknows, optionid) select 1, (select t._id from Trait t where t._id not in (select traitid from gamecharactertrait where gamecharacterid = 1) and t._id not in (4,7,11,22,28,29,30,31,33,36,42,45,59,78,79,81,85,86,87,89,90,92,93,94,95,96,97,98,103,105,108,110,111,112,113,114,115,116,117,118,119,120,124,125,126,127,128,129,130,131,132,133,139,145,146,152,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182)), 1, 0;\n\ndelete from gamecharactertrait where gamecharacterid = 1 and traitid is null;\n\n-- Select Trait -- \n--select * from gamecharactertrait;\n\n--select t._id from Trait t where t._id not in (select traitid from gamecharactertrait where gamecharacterid = 1) and t.traitdesc is not null and t._id not in ();\n\n--select * from trait t where t._id not in (4,7,11,22,28,29,30,31,33,36,42,45,59,78,79,81,85,86,87,89,90,92,93,94,95,96,97,98,103,105,108,110,111,112,113,114,115,116,117,118,119,120,124,125,126,127,128,129,130,131,132,133,139,145,146,152,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,175,176,177,178,179,180,181,182); \n\n
-- Update Credits -- \nupdate GameData set money=99999990;\nselect * from gamedata;\n
-- Attribute 30--\nupdate GameCharacter set attQuickness = 30, attStrength = 30, attFortitude = 30, attWisdom = 30, attCharisma = 30, attResilience = 30 where gamecharacterid = 1;\nselect * from GameCharacter;
-- Skill 10 -- \nupdate GameCharacter set skLightFirearms = 10, skHeavyFirearms = 10, skMelee = 10, skEvasion = 10, skTactics = 10, skStealth = 10, skGunnery = 10, skPilot = 10, skShipOps = 10, skRepair = 10, skElectronics = 10, skNavigation = 10, skDoctor = 10, skCommand = 10, skNegotiate = 10, skIntimidate = 10, skExplorer = 10 where gamecharacterid = 1;\nselect * from GameCharacter;\n
-- Full Talent --\ninsert into gametalent (gamecharacterid,talenttype,talentlevel,talentusedturn,ext1,ext2,ext3) select 1, (select talenttype from talent where jobtype in (select jobtype from gamejob where gamecharacterid = 1) and talenttype not in (select talenttype from gametalent where gamecharacterid = 1)) ,1,0,0,0,0;\ndelete from gametalent where talenttype is null;\n--select talenttype from talent where jobtype in (select jobtype from gamejob where gamecharacterid = 1) and talenttype not in (select talenttype from gametalent where gamecharacterid = 1);--order by joblevel desc;\n--select * from gamejob where gamecharacterid = 1;\nselect * from gametalent where gamecharacterid = 1;\n--select * from talent where talenttype = 329;\n
--Update Character Experience--\n--update Character set experience = 90000 where characterid = 1;\nupdate Character set experience = 90000 where experience < 90000;\nselect * from character;\n\n\n