I have a mod that changes all purple Policy Cards into green ones and ran into a problem when trying to update the icons displayed in the civipedia. I'd like to change all policy icons with an Index of 3 (purple) to be 2 (green) instead. The issue is that I can't seem to reference the Index column with my Update command. The game just ignores it. I can use the same command to reference the Atlas without issue.
These lines work:
Code:
UPDATE IconDefinitions SET 'Index'=2 WHERE Atlas='ICON_ATLAS_POLICIES';
DELETE FROM IconDefinitions WHERE Atlas='ICON_ATLAS_POLICIES';
These do not:
Code:
UPDATE IconDefinitions SET 'Index'=2 WHERE Atlas='ICON_ATLAS_POLICIES' AND 'Index'=3;
DELETE FROM IconDefinitions WHERE Atlas='ICON_ATLAS_POLICIES' AND 'Index'=3;
DELETE FROM IconDefinitions WHERE 'Index'=3;
Any ideas on how I can get this to work? I considered Updating each individual card, but they are a bit of a pain to hunt down since they appear in multiple files. I'd much rather have a blanket solution that covers all cases and won't need updating.