Wednesday, July 25, 2012

"Where's my water?": unlock "Cranky's Story", "Mystery Duck" and "The Lost Levels" on Android


It's easy to overlook "Where's My Water?". On the surface, the game looks too simple, too cute, and maybe even a bit too child-oriented. When you play it, though, you'll quickly realize it has a lot to offer even the sophisticated adult!

These days I was feeding the cute alligator with water, when I asked myself if it was possible to make all levels available.

Needs

  • rooted Android device (smartphone, tablet, whatever)
  • Windows PC (Windows XP or newer)
  • Root Explorer (Android app) / Droid Explorer (Windows)
  • SQLite Editor (Android app) / SQLite Database Browser (Windows)
In this tutorials I will focus on how to do it on a Windows machine and not how to do it directly on the Android OS. So you will not need to buy and install the Android apps listed. But you still need to download and install the two Windows applications listed.

How To

on Android device

  1. install "Where's My Water? Free" / "Where's My Water?"
  2. open the app, and when on the main screen, totally close it again
  3. connect the device to your PC

on Windows PC

  1. start Droid Explorer
  2. goto /data/data/com.disney.WMWLite/files/data/
    (/data/data/com.disney.WMW/files/data/ for paid version)
  3. copy the file water-Lite.db (water.db for paid version) to your desktop
  4. make a backup of this file
  5. start SQLite Database Browser
  6. open the copied file water-Lite.db / water.db
  7. switch to the "Execute SQL" tab and enter the following SQL commands:
    UPDATE LevelInfo SET available=1 ;
    UPDATE LevelPackInfo SET Bought=1 WHERE (IAP_item_id="crankypack01" OR IAP_item_id="mysteryduck01") ;
    UPDATE CrankyChallengeInfo SET available=1 ;
    UPDATE HubInfo SET Bought=1 WHERE (IAP_item_id="crankypack01" OR IAP_item_id="mysteryduck01") ;
  8. click "Execute query"
  9. save the database
  10. copy the file back to the Android device

 again on Android device

  1. restart the app
  2. select the first level of "Swampy" and finish it
  3. now the other levels should be available

That's it!
Let me know if it worked for you.

Supplement

This tutorials is also fully compatible with the paid version of "Where's my Water?".

11 comments:

  1. Cool blog. Check out my "free psychic reading" blog.
    The best sitedata

    ReplyDelete
  2. I don't have the water.db archive in this route:
    Data / data / com.disney.WMW / archive / data /
    I have a Samsung Galaxy SII and the route only goes to the first Data.

    Any solution??

    ReplyDelete
  3. Are you using Droid Explorer? Then check the logfiles placed at C:\Users\\AppData\Roaming\DroidExplorer\Logs.

    If there is something like ls: can't open '/data/': Permission denied
    then this could be your solution http://de.codeplex.com/discussions/230317.

    Or try using the Root Explorer App on your SII

    ReplyDelete
  4. please can you upload your own file, i really try but i can't do it.

    ReplyDelete
  5. worked perfectly if some one is unable to do it I can share titanuim backup archive of this.

    ReplyDelete
    Replies
    1. hi Annon ! You really want to do that ? please do
      that for me. Sent it on my e-mail bagasade11@
      gmail.com
      Thanks before !

      Delete
  6. hi Annon ! You really want to do that ? please do that for me. Sent it on my e-mail bagasade11@gmail.com
    Thanks before !

    ReplyDelete
  7. Hi . annon can you sent for me too? send it to karanramnath@hotmail.com thanks for helping cause its kinda hard BTW this is my first post

    ReplyDelete
  8. Nervermind i manged to do it

    ReplyDelete
  9. use this to unlock Allie's story as well.

    UPDATE LevelInfo SET available=1 ;
    UPDATE LevelPackInfo SET Bought=1 WHERE (IAP_item_id="crankypack01" OR IAP_item_id="mysteryduck01" OR IAP_item_id="alliepack01") ;
    UPDATE CrankyChallengeInfo SET available=1 ;
    UPDATE AllieChallengeInfo SET available=1 ;
    UPDATE HubInfo SET Bought=1 WHERE (IAP_item_id="crankypack01" OR IAP_item_id="mysteryduck01" OR IAP_item_id="alliepack01") ;

    ReplyDelete
  10. Allie's Story seems to be locked or stucked because it doesn't unlock the number 6th game.

    ReplyDelete