Skip to content

Instantly share code, notes, and snippets.

@ego-lay-atman-bay
Last active September 20, 2024 15:52
Show Gist options
  • Select an option

  • Save ego-lay-atman-bay/ccb276ac2df07aa622da76b8da4e302a to your computer and use it in GitHub Desktop.

Select an option

Save ego-lay-atman-bay/ccb276ac2df07aa622da76b8da4e302a to your computer and use it in GitHub Desktop.
Unlock Where's My Water? paid content for free

Here is a SQL script to unlock all the paid content in Where's My Water? for free.

All you need to do is open water.db in a SQL editor, like DB Browser, then run this script.

-- Buy all the stories
UPDATE HubInfo SET Bought = 1;
-- Make every level available
UPDATE LevelInfo SET Available = 1;
-- Buy all the level packs
UPDATE LevelPackInfo SET Bought = 1;
-- Make all the challenges available
UPDATE AllieChallengeInfo SET Available = 1;
UPDATE CrankyChallengeInfo SET Available = 1;
-- Set some player data for convenience
---- EDOB - Age
UPDATE PlayerData SET EventValue = 1 WHERE EventName IN ('EDOB','AlliePackViewed');
---- RateMePromptEligible (to remove the annoying rate me prompt)
UPDATE PlayerData SET EventValue = 0 WHERE EventName = 'RateMePromptEligible';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment