2014-01-12

Tap Paradise Cove: the internals

First, let me give thanks for this: GirlPlaysGame.
Read the site before continuing here. You'll get an idea of what is possible.


At least it got me started. And no, still no JailBreak is needed to do this.


Tap Paradise Cove is an enjoyable game, but it is WAY too greedy!! I mean, you need to spend at least €100 a month to be able to play comfortably... In my opinion: way too much. Plus you can't achieve everything with a lot of patience... Also a bad no no. Ok, make it difficult, but not impossible you know.

Lucky for us most of the information is stored on the iPad (well, their systems would overload I think if everyone logging on needed to download/upload a 1 mega database all the time :)).

Necessary utils: iFunBox, some kind SQLite database utility, PHP or something alike.

This is not a step-by-step guide. Just a brain dump of what I found out and what is working with the most current version as of January 2014.

What did I discover?
- A lot of interesting files are present in \Library\Application Support\resources
- If you want to add something, watch out for the metadata table. See that the Z_PK value of the table you changed (this will likely be zgameobject) match the Z_PRIMARYKEY table. This should contain the maximum value.
- in most tables you'll have a ZWORLD parameter. 0 = main world, 1 = atlantis, 2 = asgard. Watch out. Sometimes it's something like "0;1;2" or with a comma. Just watch out by using an update there.
- Always create a backup of your survivor.sqlite file before you start messing things up! (I generally do copy/paste in the same dir & remove them after a while).

- Pirates can be reset (when defeated) by setting ZCURRENTHEALTHPERCENTAGE=1.0, ZTIMEOFLASTDAMAGE=0. If you want to go fast in a quest to defeat someone till level xxx. Just set the ZCURRENTLEVEL to 1 level lower (for example if the quest is to defeat him at level 5, set it at 4, defeat him & you've completed the quest). [Check Fleets.csv for the ZFLEETIDENTIFIER/ZPIRATEIDENTIFIER]
update ZPIRATE
set ZCURRENTHEALTHPERCENTAGE=1.0, ZTIMEOFLASTDAMAGE=0
WHERE ZCURRENTHEALTHPERCENTAGE != 1.0 and zfleetidentifier=299;

- There are some special ruby decorations. Well, if you don't want to pay for them (199 rubies)... Why you don't just make them (well, you don't need them anyhow as I will show you later on)?
Find a good x/y coordinates on the map and place them (my personal favorite is 'sugarplum', it's small and nets 4 rubies in 4 days). [Check Decorations.csv for others, check for 'rubies' - keep in mind the size!]
To fasten ruby generation:
update zgameobject
set ZTIMEATWHICHOBJECTWILLBECOMEHARVESTABLENUM=strftime('%s', 'now')
where z_ent=21 and zcanpayoutnum=1;

- You feel powerless? Like can't beat any pirate? Why don't you just upgrade your ships? Or downgrade them for whatever reason necessary? zupgradecount1 45 means fully upgraded for a ship. For a shop that is zupgradecount (mind the missing 1) 25.
update zgameobject
set zupgradecount1=45
where z_ent=27;
- You've been beaten by a pirate, and just want to repair all your ships? No stress :-)
update zgameobject
set ZREPAIRENDTIMENUM=0, ZISCURRENTLYREPAIREDATDOCKNUM=0,ZCURRENTHEALTHPERCENTAGE=1.0
where z_ent=27;

- Expanding land? Tired of waiting 4 hours, and don't want to waste any rubies?
update ZBUILDABLEAREA
set ZEXPANSIONCOMPLETETIMESTAMP=strftime('%s', 'now')
where ZEXPANSIONSTATE=2;

- Or you just want to expand all the available land at once? Remember, you still got to chop trees/seaweed!
ZEXPANSIONSTATE = 2 means you still got to click yourself to 'finish' the expansion. This is sometimes needed as a trigger for quests. ZEXPANSIONSTATE = 3 means expanded, and 1 means dark/in need of expansion.
  $s = new SQLite3('survivor.sqlite');
  # 0 = main
  # 1 = Atlantis
  # 2 = Asgard
  $zworld = '2';

  $last_expansion = min(time(), $s->querySingle("select max(ZEXPANSIONCOMPLETETIMESTAMP) from ZBUILDABLEAREA where zworld=$zworld"));
  if ( $last_expansion <= 0 ) {
    $last_expansion = time();
  }
  $last_number    = $s->querySingle("select max(ZEXPANSIONPURCHASENUMBER) from ZBUILDABLEAREA where zworld=$zworld");
  $s->query('begin transaction');
  while ( true ) {
    $z_pk = $s->querySingle("SELECT z_pk FROM ZBUILDABLEAREA where zworld=$zworld and ZEXPANSIONCOMPLETETIMESTAMP=0 AND ZEXPANSIONSTATE=1");
    if ( !$z_pk ) {
      break;
    }
    echo $z_pk . "\n";
    $last_expansion++;
    $last_number++;
    $s->query("UPDATE ZBUILDABLEAREA set ZEXPANSIONCOMPLETETIMESTAMP=$last_expansion, ZEXPANSIONPURCHASENUMBER=$last_number, ZEXPANSIONSTATE=2 Where z_pk=$z_pk");
  }
  $s->query('commit');
- Tired of waiting to build your buildings, and don't want to spend rubies? Well... Why not...Watch out here, because the atlantis merchants and the asgard one are a little special. Hence the additional restrictions (or you won't be able to finish that quest).
update zgameobject
set ZCURRENTHEALTHPERCENTAGE=1.0, ZTIMEATWHICHOBJECTWILLFINISHCONSTRUCTIONNUM=strftime('%s', 'now'), zupgradecount=25
where zstatenum=2 and (ZCURRENTHEALTHPERCENTAGE is null or ziscraftingnum=1);
- Want to send ALL your ships on a long voyage to get back a lot of stuff? And without spending coins to do that? This query just enables the voyage, it doesn't finish it necessarily. The additional restrictions is because sometimes you need to go on short/medium voyages, so these will not get erased by the query. Read more below how to finish the voyages immediately.
update zgameobject
set zonvoyagenum=1, zcurrentvoyageindex=2
where (zonvoyagenum != 1 or zonvoyagenum is null) and z_ent=27;
- Next step: finish the voyages instantaneously:
update zgameobject
set zendofvoyagetime=strftime('%s', 'now')
where zonvoyagenum = 1 and z_ent=27 and zendofvoyagetime > strftime('%s', 'now');
- Well, I do have a workshop and I want to build something (I used this hack in fact for Eric. I just couldn't get any map fragments, so I just set the workshop to build me a compass anyhow, without using any resources :-)). This query will not clear out if you already are building something. More information on things you can craft in CraftingRecipes.csv (check for workshop/armorsmith in there).
update zgameobject
set ZRECIPEIDINPROGRESS='Upgrade_Chest'
where zname = 'workshop' and (ZRECIPEIDINPROGRESS is null or ZRECIPEIDINPROGRESS = '');
- Same thing for the armorsmith:
update zgameobject
set ZRECIPEIDINPROGRESS=114
where zname = 'armorsmith' and (ZRECIPEIDINPROGRESS is null or ZRECIPEIDINPROGRESS = '');
- And now to finish these craftings immediately:
update zgameobject
set ZTIMEATWHICHOBJECTWILLBECOMEHARVESTABLENUM1=strftime('%s', 'now')
where zname IN ('workshop', 'armorsmith') and (ZRECIPEIDINPROGRESS is not null or ZRECIPEIDINPROGRESS != '');
- Fasten coin collection from buildings (I generally do this only on 'reward' buildings so I can get more ropes/canvasses etc etc). Just remove the ZNAMEDREWARD restriction if you want everything.
update zgameobject
set ZTIMEATWHICHOBJECTWILLBECOMEHARVESTABLENUM=strftime('%s', 'now'), zupgradecount=25
where ZTIMEATWHICHOBJECTWILLBECOMEHARVESTABLENUM != 0 and z_ent=23 and (ZNAMEDREWARD is not null);
- Fasten coin collection from ruby buildings:
update zgameobject
set ZTIMEATWHICHOBJECTWILLBECOMEHARVESTABLENUM=strftime('%s', 'now')
where ZTIMEATWHICHOBJECTWILLBECOMEHARVESTABLENUM != 0 and z_ent=22 and (ZNAMEDREWARD is not null);
- Another interesting stuff is quests. That can go wrong a lot of times, but just check out the URL on top of this article. You can just skip stuff, or add achievements and so on.

- How to get new ships? Like to top10-pvp Ships? :-). Easy Peasy... What I generally do is export my database. Get in the game & move a few ships. Export the database again & see what coordinates they were BEFORE (watch out, you need to modify 2x the coordinates in the same insert statement!).
Then set Z_PK to null (it will autoincrement that way). Change the ship you want (like pvpShip3 for the midnight ship which is running now). Check that the gameobject identifier in Z_PRIMARYKEY is still ok & you have a freaking new ship :-). For safety reasons I set ZCREWONEFBID/ZCREWTHREEFBID/ZCREWTWOFBID to null and ZEQUIPMENTSDATA=null. But I think the ZEQUIPMENTSDATA can be left as-is, and I believe it will duplicate the equipment into your new ship as well. But didn't bother trying that. It's faster to just re-assign new equipments anyhow than starting the game anew.

- Now what you've all been waiting for... How the **** can I get free rubies/coins? In fact it's fairly simple :-).
Adjust the ZMONEY (anything from cannons to hulls to boosts and ropes etc etc) or the ZUSERMODEL (wood, xp, coins, rubies) table. Well, 1 caveat... The ZROWHASH... Here's how to calculate it:

(PHP code follows)
  $openUDID = '';
  $currency = '';
  $amount = '';
  $wood = '';
  $xp = '';
  $coins = '';
  $gems = '';
  $energy = '';
  # For currency:
  $hash = base64_encode( sha1("$currency,$amount,$openUDID", true) );
  echo "$currency: '$hash'\n";
  # For usermodel:
  $hash = base64_encode( sha1("$wood,$xp,$coins,$gems,$energy,$openUDID", true) );
  echo "user: '$hash'\n";
Or simpler: http://www.salvania.be/calculate.ZROWHASH.php
Where to find the openUDID? Also simple... Once you know it of course :). It's in Library\Preferences\com.pocketgems.paradisecove.plist. It's just an XML file. Just search for OpenUDID, and you'll see something 40 characters long consisting of 0-9a-z. That's the OpenUDID! Now you can update this ZROWHASH whenever and however you want...
Unlimited midnight cannons (+520 attack)? You got it... Unlimited rubies? Sand dollars (atlantis money), silver rings (asgard money)? You got it :-).


And no, I don't feel bad one single bit... Greedy games should be hacked.



Still figuring out how to cheat at the pvp competitions, but I think it's not that difficult :-).

As Finch says in PoI: "If they don't want you to get inside, they ought to build it better."


Update @ 2014-03-20:
What is the name of that ship again? Or that nifty cannon? Don't know it? Well, quite easy to get it...
Go to Library\Application Support\resources. You'll see a lot of CSV files.
* Shipnames are in ... Ships.csv (duh ;)). The first entry is the name in the database, the second the name in the game. Easy.
* Cannons and stuff is in ... Money.csv (remember the database table is ZMONEY?) Again, the first entry is the name in the database, the second the name in the game...


Have fun!

146 comments:

gpg said...

This is great stuff - mind if I feature it on my blog and link back? ~girlplaysgame.com

Steven said...

That would create a circular dependency i guess 😉. Feel free to feature it. Once i figure out the pvp ill post it here as well here. Have fun!!

gpg said...

Haha, I prefer the term "partnership" :P

John said...

For the ships, do I change the old ships to new ships I want like pvp
or do I add new row and put the old coordinates so it generates a new ship for me?

Steven said...

@John: If you change the old name to the pvp ship, you will loose your old ship and get the new one instead.
What I did was see what the coordinates were of 1 particular ship. Go into the game, move it.
Then export that line from the database and fill in the old coordinates and the new name (remember, the old ship has been moved to another location).
So: add a new row, but don't put ontop of other ships... Don't know what will happen then. If you do, please tell me :-)

John said...

Ah thanks, I found the openudid, now what do I do with that number? Do I have to change the zrowhash if I change the number of cannons?

John said...

Thanks, Also didn't know if this posted, when I change the ammount of cannons, do I have to change zrowhash? How is the calculation done once I find the openudid? Thanks in advance

Matt said...

Steven,

I attempted to change the amount of sand dollars I had in ZMONEY, and now my game will not start. It says that my database is corrupted. Is there any way I can fix this?

David Bobker said...

Steve, can u assist me? I have a 620 blaster and a 720 warmer (def). How do I multiply them?? I know u explained this a bit in your post, but I need a bit more help or explanation.

Steven said...

Yes, check the code i posted in the blogpost. That gives you an id of what needs to be done with the zrowhash. Its not as simple as copy paste. But with the hints i added here above, you should be able to manage :).

Steven said...

@Matt. Yes, check the text in my post how to change it.

Steven said...

@David. Im happy to help, but i wouldnt know how to explain it? What part is unclear?

David Bobker said...


Can u please detail :
Step one - do this on this screen

Step two do this ...

Etc...

What code do I use for each weapon and where?

Thank u!!

David

Steven said...

@David: I think I did already pretty well. My guide is not a step-by-step guide. More a braindump of what I found out during my investigations.

Anyway, I made a PHP script which can calculate this hash. Its link is added into the post.

You're of course welcome to make a proper how-to guide with screenshots and everything. But where is the fun in that?

Now you just change the values in the database, go to the link, enter all the same values as in the database, enter your OpenUDID and you're set for unlimited resources...

Lobna Kata said...

can you please hack secret passages hidden objects too? thanks

Steven said...
This comment has been removed by the author.
Pakistani said...

btw, could you explain the "top10-pvp Ships" I really don't know about this term. What are those ships?

Steven said...

@Pakistani: What I meant is that you have those competitions, and the top-10 get really good ships (and top100 or so get really good equipment). Well, just figure out the name of the ship & set it up. I believe it was something like pvpShip1/2/3/4/... Bang, free ships :-).

Steven said...

@Lobna Kata: I did figure it out how to get everything for free, but the next time I started up the application I was 'banned for cheating'. So I did not post the way how to do it... Maybe it's because I gave myself 10 million rubies or so, or maybe they have some server-side control over it... I don't know. I don't care too much anymore about their applications to test it out :).

Pakistani said...

I'm trying to understand the steps I need to perform in survivor.sqlite to get the pvpShip. But I don't get it really, I mean the procedure is too complicated. Do I have to change one of my existing Ship name to pvpShip3 (for example)? In this case the existing ship will be replaced with new ship, right? would not this be a problem?

David Bobker said...


Hi, I tried this tonight looking for the open udid code and the system did not accept the modification. It told me the data base was corrupted. I assume the Zgems is rubies?also I seem to have 2 different udids listed - one called open udid and one called:OpenUDID.slot.4

PGID

David Bobker said...

Steven,

I am going to try to find my real udid by connecting the phone and looking for it in iTunes. apparently since iOS 7.0 all the udid apps send out the wrong udid id.

Will try to use that number in your pgm to generate the zhash for 9999 rubies and see if it works.

Does your pgm also have the ability to make more of the weapons and shields that I already have? I have the new green clover shield (810) and the 710 cannon.

Want to equip all my ships with it.

Lastly, how do I code the system so that my ships repair instantly instead of taking hours and having to spend 14 rubies each time to speed up the repair?

Thanks!

Unknown said...

thank you or/of dank u

hint for storing more unwanted stuff: in game object put a 1 in the zisstored. i have stored 600 items already

Unknown said...

Lastly, how do I code the system so that my ships repair instantly instead of taking hours and having to spend 14 rubies each time to speed up the repair?
if you set health to 1000 you hardly need to repair

Unknown said...

i added the pvpships in zcountedevents by adding a new line 8-1-1-prize pvpShip6

Unknown said...

when the quest wants u to buy this and that. dont buy its free

in zcountedevents ad a new line 8-8-1-PCGOT loveseat or whatever you need (you find it in csv. merchants/houses/decorations)

got to the menu and its there unlocked to be placed

Unknown said...

bored of doing weekly quest? that will be next tip my english is not that good i post it next time

Davide Marchese said...

Chi mi spiega una volto aperto il database con sqrtel dove devo modificare per avere molti rubini?

David Bobker said...

Thank u. Was that the newest and latest ship with the 3,750 / 3,750??

David Bobker said...


Can u please explain what u mean by setting the health to 1,000?? I want all my 25 ships especially my top 5 to repair completely as soon as I click on repair and not have to wait hours to do it. Also, I don't always want to be logged in or tethered to Ifunbox. Is there a way to recode the ships to auto repair or something like that?? Without having to spend rubies to repair them quickly?

Unknown said...

mean by setting the health to 1000?
that means that i used 1 ship during the battle. did over 1200 battles and still doesnt need to be repaired. it 1000x stronger

when a ship needs to be repaired the value =-<0
if you make that value 1 its repaired in a sec, without spending rubies

if you make it 1000 you van battle almost unlimited with that ship

Unknown said...

maybe steven can explain it a better way

David Bobker said...


Thank u. And this health field is also in zobject or zmoney? How do u know which ship to change the health to? What screen do u use?

David Bobker said...


ok I have tried this every which way and filled in all fields and even tried to recreate the zrohash that is there using my exact numbers and something is off - either by the generator or my udid or something - bc I can not get this to work correctly. Help!!!

lolmynameisdan said...

Tried doing the rubies thing. I did the simple link thing and changed it to a bunch of rubies and a bunch of coins, hit calculate user hash, then copy and pasted that in the correct spot. When I tried to load my game, it said it was corrupted. What did I do wrong? Is it because I'm on v5.7 of the game?

Davide Marchese said...

How do I calculate my OpenUDID?

Davide Marchese said...

I can not! We'll explain all my steps. I have a ipod touch generation 5. I downloaded an application that I have emailed my openUDID. I opened the file survivor that I find in Library/Application support. I opened this file with sqlite. I open the browse data area, I tried ZUSERMODEL, simultaneously I linked on http://www.salvania.be/calculate.ZROWHASH.php?OpenUDID=1df67c311a92902edeaeb0820859f313aa65d7cb&CurrencyType=&Amount=&Wood=&XP=&Coins=&Rubies=585830&Energy=&calc=Calculate+User+Hash
and I entered my opnenUDID. As with the old trick of the siren I still 58583 rubies, I entered a 0 then 585830 rubies, so I pressed on calculate user hash. It gave me a code of numbers and letters that I went to insert the file string ZROWASH survivor. I saved and reinserted the edited file in Library/application, I ravviato the game and it says corrupted file. Where I'm wrong?

Unknown said...

usefull hint
try this and use the amounts stated in the db
if the answer is the same as in the db its oke
if not you entered something wrong
as i can say its works great both the equipment and the rubies :)

Unknown said...

my info in zusermodel
Amount of wood: 4041
XP: 20036
Coins: 4401877879014
Rubies: 570
Energy: 15
this is the calulation
pIWePdPTzvMYEC81jHcRYMfkqrs=
and its the same as in zusermodel

David Bobker said...

Unknown - you need to tell us who u are..
How did u get your udid? Did u use it in your calculations?

David Bobker said...

Hot damn! it works!! You need to find the udid that is specific for the game - in the file that Steven mentions - not the open udid which you can find in Itunes.

Then match up all 4 fields: zgems, zwood, zxp and zenergy with what you have in the Zusermodel and click "calculate hash" using Steven's link.

Once that matches up with what is listed in zusermodel under zhash.. Then and only then can you begin to change the values in both Steven's link calculator and on Zusermodel. Then when you have everything matched up again with the new values, click on "calculate hash" and copy that new hash into your zhash. Save the pgm, copy it back to the game using Ifunbox and enjoy!

David Bobker said...

This also works perfectly to add in add'l cannons or shields. Find the newest or highest one that there is, they may not be the same name as in the game, change the amount and generate the new hash, and tada - more of everything!

Davide Marchese said...

We'll explain all the steps that I did. Tell me where I'm wrong. I funbox, I go to Paradise cove/library/preference and I open the come.pocket.gems file and I get my OenUDID. Open the calculator by Adam and I add my userUDID. Then I open the other file with sqlite, I go to Zusermodel, I get all values for the XP, woods, rubies, coins and energy. I am the same, i.e. zhash match. Then I go to the top of Jyoti and Calculator where it says Type of currency I write ZGEMS; then below, where it says amount: I carry the number of jewels that I would find (in the game I 58,300 rubies so write 158300 amount). I then click calculate currency and gives me a hash value that I go to open the first file with sqlite. Save, move files and tells me file is corrupt. Where I'm wrong? Thanks in advance to anyone who helps me.

David Bobker said...



David, you are using the wrong part of the calculator.

The same part (bottom calculator) that you used to make sure you match up, is the one you now use when you change your gems or rubies. So change the zgems in zusermodel to whatever number you want, and then use that number -KEEPING ALL OTHER FIELDS FILLED IN WITH YOUR REAL NUMBERS THAT YOU USED BEFORE, to calculate for you a new zhash. Then plug that zhash into the field in usermodel and save the SQLite file and then upload using ifun back to the game file... When you load / start the game again, if you did it correctly, the game should load properly and your new ruby (zgems) number should a appear. Keep us posted. David B

David Bobker said...

The top "currency" calculator is only to be used for the zmoney part of SQLite. There you can modify individual items like "heart attack" cannon (710), shamrock hull (810). The only thing is: the names in the game do NOT match up with the names in the file - so you need to carefully play around and save save save back up the file, before you start poking and changing info in this part of the SQLite file..

Davide Marchese said...
This comment has been removed by the author.
Davide Marchese said...

I still haven't figured out how to deal with i heart cannon (720) and shamrock hull (810) because the names do not match. You are able to multiply?

Davide Marchese said...

Tank you David Bobker, I have succefull with rubies ;)

Unknown said...

Hi everyone and specially the creator of this blogg, it is really good. I'm trying to do your suggestions although I'm not that skillful.

But I have 1 suggest/question, have you explore the mermaidrewardpriority file? I think this could be usefull in order to get mainly rubys.

David Bobker said...

Yes I was able to multiply. 1st thing to do - is if you have any of these take them off your ship(s) so that it will be listed in the zmoney data base. Look for how many you have under zamount. The names are NOT the same. I did it by figuring out what changed (what item went from 0 to however many I truly had)...

Once you figure out which one is for what - change the amount to what you want in the data base and also calculate the new hash value - USING THE NAME IN THE DATABASE - AND NOT THE NAME FROMBTHE GAME - and the new amount. That will give u the hash to use and then save and upload. When u go back into the game, your new amount should be visible.

Steven said...

Ok people. I updated my post (at the end) on how to get the names more easy than what you are doing here.

Have fun!

Unknown said...

i'm chico2608 on gamecenter
i can only choose unknown or sign out sorry

David Bobker said...


Welcome Chico and thank you Steven. Your input is invaluable and helped meals the zmoney changes much easier and faster. FYI, to all the stpattys hull, cannon and cannonballs - are the shamrock hull, cannon and boosts - which as far as I know - are the strongest ones currently available.

Much easier to now change the zhash.

Next challenge - figure out the strongest ship in the csv file and see if I can magically make it appear in the game .

Davide Marchese said...

Some tips for those who want to play guns and shields: stpattyscannon (820); stpattyshull (810); stpattyscannonballs (850x850 for 1 use).
But for the super ships what should I do? The 3750x3750 ship?

Davide Marchese said...

In addition, to have the ship repaired immediately in which field should I enter? Thanks in advance to anyone who helps me! You are great!

Steven said...

Search for 'ZREPAIRENDTIMENUM' in my post.

Davide Marchese said...
This comment has been removed by the author.
Davide Marchese said...

Also this works!! Ehehehe!

Davide Marchese said...

When returning to improve another ship, the first loses. Why?

Thora said...

Fantastic stuff! Thanks so much Steven and everyone else! I've done the rubies, I've stored a bunch of useless stuff, I've even added the latest cannon, which I DIDN'T have (it's there, you just don't see a picture of it) - has anyone found the straightforward and simple way of adding a ship? Like one of the top pvp ships? I didn't quite understand it. Thanks all!

Davide Marchese said...

According to you, Steve, objects that give 4 rubies can be multiplied? Also, can I decrease the amount of time (usually of 4 days) under 2 minutes at a time? Thank you.

Davide Marchese said...

Dear David Bobker, do you have the Green Fall ship (3750x3750)? Can you tell me what I must to do for? Thank you :)

David B said...


Chico, I followed your durections but the pvp 3750 ship did not appear. Did it work for you?

Steven, Is there a way for us to add in the latest pvpShip6?

Rubies and cannons hack works great!

Thank You!

David

ScubaDubba said...

Do you know how to open up a land quest without the quest being available? Specifically I'm talking about "Complete achievement 'Find Scrapes with Erik to make a compass!' to unlock!"

Thanks for the page!

Steven said...

@Scuba: Why would you want to do that? You can simply create Erik's boat by finding it in the CSV file and creating the object in the database... No need to complete the quest.
I think you might be able to re-activate the quest by playing around with the CSV files and adjusting timings in there, but I wouldn't really bother with that. Just create the object and be done with it :-).

ScubaDubba said...

@Steven: I have the boat and it's maxed out, what I need is the land covered in fog associated with that quest. All other fog land says "hidden area" but this one piece at the top center is associated with the quest that is no longer available. I'm just trying to figure out how to unlock the fog to get to that land at this point.

David B said...

Would live to know that too - as it's my last land area that I can't unlock.

Also, can anyone (Steven?) tell us how to add in the pvp6 ship from the last event? It was never in the screen, only listed as a prize.

Do u create it somehow in zobject, or change some numbers - like for zmoney and zusermodel?

Or even is it as simple as changing something in the ship csv file (vs changing something in the SQLite file)?

Any help would be appreciated.

Would love to know how to make ships "magically" appear.

Lastly, do u have to keep resetting the zenergy to 1,000 for every battle or two? Mine keeps going down to 0 and all I am doing is fighting a few of the regular pirates.

David B said...

Steven, how can we code and add in the pvp6 ship? Any ideas for us lay people?

Also, how do U execute (run) your pgms for SQLite? Is there a run box or command prompt?

Unknown said...


Or even is it as simple as changing something in the ship csv file
doesnt workthe file will be reloaded from server to original
i tried it before

Unknown said...

zcountedevents
8-1-prize pvpShip6

i had a little vacation ;)

Unknown said...

do u have to keep resetting the zenergy to 1,000 for every battle or two? Mine keeps going down to 0 and all I am doing is fighting a few of the regular pirates.

in zgameobject set zcurrenthealthpercentage to 1000
you can do the pvp battle with one ship

there are in the update some modifications made to the db i see

David B said...


Thank you both for your replies . I tried the 8-1-1 in counted events and my pvp ship never showed up. Where and how would it appear??

Unknown said...

it shows up in the ships menu
i have the 3 new ships today already
8-1-1-PCGOTglowinthedarkblue
8-1-1-PCGOT glowinthedarkblue
8-1-1-PCGOT glowinthedarkred

Steven said...

@Scubba: I don't really know. I haven't played around too much with this.
And actually I was stuck there too with a quest (something about torches). But by that time I hacked the game and got bored of it, so I didn't bother.

I do believe however that you can check in 'ZPGACHIEVEMENTREQUIREMENTSCOMPLETED' or any other table in the database where something about Erik is stored. At least you should find an event that it is started.

Or maybe you're out of luck and can only find it in the CSV file with an end-date in the past?

I honestly don't know, but beside my post and the one on GirlPlaysGame, you should be able to figure things out :-).

I'd be happy to include any success you have with your quest in my post however, so please report back if you get it!

Unknown said...

zpgachievementsrequirmentscompleted:
put in the line

44-1-ExpandErikPop,ExpandErikPop
then it shows up
you can also add:

44-1-ExpandErik,ExpandErik
ExpandErikfinale,ExpandErikfinale
ExpandGetErik1,ExpandGetErik
ExpandGetErik2,ExpandGetErik,
ExpandGetErik3,ExpandGetErik
ExpandErikCraft,ExpandErikCraft

hope it workes, it did here

Thora said...

Wowza. It worked, adding to ZCOUNTEDEVENTS just like Chico said, I just added The Green Glower! Building now - AWESOME stuff!!!

David B said...

I am sooo confused!! Are you guys adding in 8-1-1 prize pvpShip6 as a new record in zcountedevents? Am I spelling it correctly? What am I doing wrong? I do not see this new ship/ ships in my game screen!!

Help!!

Is it pvpShip6, or pvpship6, or does it not make a difference? Also, are you making the change - saving it back to the game, loading the game, and then looking in zgameobject for the new ships??

Help!! Really want to figure this out.

Thank you!!

David

David B said...

Or do I just type 8-1 and leave out the 3rd 1??

Thora said...

David, I went to ZCOUNTEDEVENTS and added a new record - then I put 8-1-1 in each column (ZENT, ZOPT, ZEVENTCOUNT) and in the final column I typed
PCGOT glowinthedarkgreen (I think the space in between was important, I looked at other rows to see if there was a space). Uploaded, went in and it was in the ships menu to place.

WARNING: I went back in to add more rubies and when I went back, the ship was back in the ship menu to place although I had already built it (expedited build with rubies) and upgraded some with golden pearls (hope I didn't waste those! I haven't checked) so if you play around with the file again I assume this will happen? Think I'll leave it alone for a bit, although I did want to add some more boosts for this weekends battle! That's why it would be nice to win a ship or two as wouldn't have that problem.

Thora said...

Hope that helps, let me know!

Davide Marchese said...

What are the objects that give rubies plus these: blarney stone, Thanksgiving tree, halloween shop, ruby mountain, sugarplum?

Unknown said...

dont do this I had already built it (expedited build with rubies) and upgraded some with golden pearls
just go to zgameobject >>zupgradecount1 make it 45

Unknown said...

in zgameobject >>> zstate to 5 is no waiting time for building the ship/ merchant/decoration/house

Unknown said...

correction zstate1 is for ships

Davide Marchese said...

Dear guys, I managed to do everything. But I was wondering if it was possible to reduce the wait time (4 days) for objects that give rubies (4 rubies every 4 days). If you can, tell me the what field do I intervene and what number I have to put in place what is there? Thanks in advance to anyone who answered me.

Steven said...

@Davide: read the blog post again (search for ZTIMEATWHICHOBJECTWILLBECOMEHARVESTABLENUM)

Pakistani said...

I have 1 ruby mountain and if I had rubies that time then I'd have bought 4 more ruby mountain. Now the time is gone but I guess I can still add 4 more ruby mountains. Could you guide this please? thanks.

Davide Marchese said...

@ Pakistani I have duplicated 5 blarney stone, tree, 5 Thanksgiving, 5 halloween shop, 5 ruby mountain, and 5 sugarplum.
@ Steven In the ZTIMEATWHICHOBJECTWILLBECOMEHARVESTABLENUM string I have this number:1396427060 and when I enter 0 I take the 4 rubies; soon after, however, tells me that I have to wait 4 days again. I would always take them immediately without intervening every time in the file. Is it possible to do this?

Steven said...

@Davide: not that I know of. Once you collect, the next timestamp when all rubies can be collected is entered in the database. So you'll need to do this every time.
Anyway, just give yourself a million rubies or so (read the blogpost and its comments on how to do it). Then you don't need these sugarplums anymore ;)

Davide Marchese said...

Thank you Steven

Pakistani said...

@Davide Marchese, How did you duplicated the stuff like ruby mountain? Could you explain a bit in detail please! thanks.

Davide Marchese said...

@ Pakistano: When you open the file squirtel, and go to ZGAMEOBJECT, sign on a sheet of paper all entries that are compiled on a ship that you already have your choice, making sure the fields ZLOWESTGRIDPOINTX and ZLOWESTGRIDPOINTY which are the coordinates in which the ship concerned. When you've written everything on the sheet, enter the game and move the ship. Reopen the file with squirtel and you'll see that the ZLOWESTGRIDPOINTX and ZLOWESTGRIDPOINTY fields will have two different numbers because the coordinates are changed. At this point click on new records and filled in all the fields that you've marked the first time on the sheet of paper, under the name of the ship ZNAME you'd like to have.

David B said...


Thank you Thank You!!! The PCGOT trick worked perfectly and so does changing the health of the ship! Than you Steven for putting up this blog and helping us all!!! Thank you all for your very helpful input!!!

David B said...

Question for all: any idea what happens if we already have the "glow in the dark green" pvp ship, and we win another?

Does the game give us a 2nd ship, or should I switch the name (how??) or my green ship before I lose it?

Suggestions?

@Steven?? This is not copying a ship, it's one that I already have in the game, and want to figure out if I can have 2??

Thanks!!

Unknown said...

Does the game give us a 2nd ship, or should I switch the name (how??) or my green ship before I lose it?

Suggestions?
as i did it many times it does not give a sec one. and you wont loose it too.
only thing is you dont have to do all the work for it ;)

Unknown said...

zachievemntsrequirementscompleted


44
1
LTQanimalhabitat1 LTQanimalhabitat1_1 -BEGIN 2 voyages-
44
1
LTQanimalhabitat1
LTQanimalhabitat1_2 -Build Birdhouse Tree-
44
1
LTQanimalhabitat1
LTQanimalhabitat1_3 -Collect,bakery-
44
1
LTQanimalhabitat2
LTQanimalhabitat2_1
=Build Caretaker's home-
44
1
LTQanimalhabitat2
LTQanimalhabitat2_2 -tapSeaCreature,2,dolphin-44
1
LTQanimalhabitat2
LTQanimalhabitat2_3 -Collect,watermill-
44
1
LTQanimalhabitat3
LTQanimalhabitat3_1 -Build Animal Conservatory
44
1
LTQanimalhabitat3
LTQanimalhabitat3_2 -Collect,wheatfarmer-

and tomorow is completed, all you have to do is tap to complete

Pakistani said...

The new versus fight event doesn't let me fight. When I click on "Fight" button, nothing happens. What could be the reason? Even I deleted and reinstalled the game, but same issue.

Unknown said...

it didnt show up here, but i added in zachievementrequirementcompleted
a new line 44-1-LVLDdarklightpop-LVLDdarklightpop
i completed it in 2 hrs

Unknown said...

the animal habitat ltq will show up monday 9:00CET until then nothing will happen if you put the lines in they become active from that moment

David B said...

Chico, confused what are you talking about and where are we typing in all this info??

Davide Marchese said...

@ Pakistano: I also didn't fight maybe because I had already taken all ships (7 green, 2 red, 2 blue) and many other :P ;)

Davide Marchese said...
This comment has been removed by the author.
Davide Marchese said...

I added a new record but has not begun the mission

Pakistani said...

A Question: Does this app also up-to-date for Android? anyone playing it on Android or just iOS.

Matt Shell said...
This comment has been removed by the author.
Matt Shell said...

Hey Steven can you make a PHP code calculator for campus life and send me the link please? It would help a lot because I couldn't figure out how to get the code manually.

Pakistani said...
This comment has been removed by the author.
Pakistani said...
This comment has been removed by the author.
Davide Marchese said...

What do you call the name of the file to find out the name of the missions?

David B said...


Got Erik to Expand. Thank you!!!

Davide Marchese said...

It's no work. Why?

Pakistani said...

@Steven did you know how to get the green color "Profile" button? I have started the game from level-1 and completed 60 levels, completed all achievements, defeated more than 300 pirates already. Don't know when Profile button will appear, any idea?

Unknown said...

you know how to get the green color "Profile" button? I have started the game from level-1 and completed 60 levels, completed all achievements, defeated more than 300 pirates already. Don't know when Profile button will appear, any idea?
its part of the pvp battles, this weekend will start another one.

lolmynameisdan said...

Can anyone confirm if this still works with v5.8?

CiaCiaChii said...

hi.. i did this cheat and did get almost ullimited ruby and gems, however in the latest update the changes will revert to before you did the cheat, so somehow it is working, but its not.. anyone had the same thing? im in ver 5.8

Unknown said...

no problems here, v5.8

Greg1001 said...

Soooo, applying the same idea to Campus life, seeing as it has an exact same kind of UDID.

And it has a ZPERSISTANT USER with similar fields/setup…

I was wondering if someone has applied the same thing to campus life?

The zpersistentuser has a database cell for zcoins, zgems, and zxp just like paradise. But there is no zwood or zenergy. There is however zknowledge, znumberofthoughts, zsocialxp, and zvotes, and of course plenty of other cells. Those seemed to me to be the most likely candidates though. But despite how I switched the numbers back and forth, I could not get the right hash to create.

The great unknown of course is if the hash is created from 5 variables like paradise, or 4, or even 3…

If one of you super brains out there figures it out, my girlfriend and I would appreciate the help!

Steven said...

@Greg1001: Well, if they have the same protection as the did for "Secret", then you're likely to be banned on the spot... Or not... I don't know, but I'll check it out in a yiffy and maybe post it in another blogpost.

Steven said...

@Greg1001. I checked this, but you'll need to search a little yourself.

What I know for certain:
sha256(coinsFromExternalSources,gems+gemsFromExternalSources,knowledge,socialXp,,pgid)

The 'something', I've no idea... But what you can test is also if you remove it altogether.

Watch out as I hit the same thing with 'Secret', that my game was banned immediately upon re-entry.
So if it's dear to you, try with another device and another GameCenter account to test! And don't be greedy like me (adding million gems or so :)).

For figuring out the 'something', just try anything else you find in the database and maybe just run a loop over any value you find in there and check it against the hash. Hopefully it's not a server-provided seed!

Davide Marchese said...

Hi Guys, in Montezuma are stuck at 39%, will not unlock the Ballcourt mission. There are suggestions to make it go?

Pakistani said...

@Davide Marchese, that's all for now. we'll have to wait for another episode.

Davide Marchese said...

@Pakistani: Thank you.
There is a cheat for the game Clash of clans?

Ben Paquette said...

hello i really only want "ruby" gems and im not sure how to get them. and i dont even know what a UDID is

Pakistani said...

@Steven, can you also try to hack Clash of Clans, please? to get the gems.

suaku said...

Hi Steven, any idea on how to add the new fusable equipment into your inventory. I tried editing the ZMONEY but these new equipment are not showing up. Thanks.

Davide Marchese said...

I do not know how to do the fusion Cannon and Crystal shield from 950 to 1560

Davide Marchese said...

Someone managed to get guns and shields (strum hull and chord cannon x1680) by merger or otherwise? I'm not there. Who help me?

crystalzelda said...

fyi - this hack doesn't work anymore in v6.0, at least for the rubies. I did everything in the instructions, even checked to see that the zrowhash from the calculator matched my current zrowhash before making changes, and it doesn't register in the game, so I'm guessing the new update broke it.

ScubaDubba said...

I'm on v6.0, made changes this morning and all changes (including Rubies) updated fine for me.

Neno Onen said...

Yeah, I also made some major changes on all currencies this morning plus rubies, and all of it worked perfect. Thanx, my girlfriend loves the game, and the extra help on currency helps so much. Just wish you could find a way to edit the android client as well.

Davide Marchese said...

@Steven, can you also try to hack Clash of Clans, please? to get the gems.

Dracos1775 said...

Great hack. Unfortunately the ZROMHASH calculator no longer matches the latest Paradise Cove update.

Steven said...

@Dracos: I just checked it & nothing seems to be changed? Can you please elaborate about your point?

Dracos1775 said...

What I am seeing is:
I open my SQL editor and input the existing data into the ZROMHASH calculator (wood, coin, gem,...) and use the UDID (the same one that worked before the update. I also verified that it has not changed), the calculated ZROMHASH (calculated) does not match the existing ZROMHASH from the game. To me this indicates that something has changed in the calculation.
Am I missing something? I have made successful adjustments before.

Steven said...

@Dracos: Then you are doing everything right yes. And they likely changed it... But I can't find out the new methods. So for now this hack is blocked. Once I find out how it should work, I'll update the script.

Unknown said...

nothing has changed here

Dracos1775 said...

I tried again today. I ended up with the same result with the old UDID and went to the plist to confirm the UDID was the same. This time the UDID was different. I don't know if this is due to the update or I "fat fingered" from the previous UDID used. It appears to be working as advertised. My apologies for the confusion.
Others that I checked are using the same UDID,...no explanation.

Richard Sedgewick said...

Rubies hack still working here

Unknown said...

some1 knows how o fix the vs event to come back again?

MrHapple said...

Uhh, I messed up and I left the "Zero Wait Time" cheat on when I went into Montezuma. BIIIG mistake! Now I can't go back in because the merchant I built in there won't stop giving medallions!

Where do I edit the payout time so I can go back in?

This issue is for Atlantis and Asgard worlds as well.

The cheat I used can be found in cydia.myrepospace.com/macrat - it is to be used ONLY in the main Paradise Cove area, NOT the other worlds. If you must, use it ONLY for clearing debris, NOT for harvesting.

MrHapple said...

I found out how to unblock all on my own.

You have to change the ZSTATENUM data of the offending buildings to -1.

This will reset the offending buildings' state, and you will be allowed to travel offworlds. If you mess around with the values of the buildings, they will get reset to what they are supposed to be in the transit there.

David B said...

Hi, can anyone tell me how to max upgrade or fuse the new weapons without going through the fuse process? Is there some code in the survivor SQLite file that we can change?

Greg1001 said...

Steven,

Greg1001 here. Was wondering if you could point me in the right direction with quest jumpstarting.

I have been trying to get "Lost Land Of The Black Pearl Diver " quest to start, seeing as game producer folks failed to accomplish the push for both me and my wife. We are both lvl 64, and we have accomplished to trigger the quest.

I have been playing around in the ZPGACHIEVEMENTREQUIREMENTSCOMPLETED and ZPGACHIEVEMENTSCOMPLETED trying to add lines like "lv63landexpandpop,lv63landexpandpop" and or "lv63landexpand01,lv63landexpand0" trying to bump the quest, and cause a second step to start. No joy so far. Can you suggest some place so start, as I am just shooting in the dark at the moment.

And a huge thankyou for having the hask calu., and for keeping it online. I use it a lot. Me and my lady both appreciate the time you took to share you findings with all of us.

If you want to ping me direct, you can use my spam email address which is not connected to any game: promethius00 at hotmail dot com

Thanks again!

greg1001

Greg1001 said...

opps, that should have read, "have not".

Fat fingers...

wackplayer said...
This comment has been removed by the author.
wackplayer said...

Okay, I found out what was going on with my game. Simply put my iPhone 4 is getting too old. Graphic glitches are appearing more often.


I want to try building a "super save game" out of save game files. This idea will only work with World 0 and 4 easily because those things can be docked. Asgard (World1), Atlantis (World2), and Montezuma (World3) objects do not yet have the ability to store. I think PG is reluctant to allow that to encourage the chopping of wood to find places for everything.

Anyhoo, anyone know of a site where I can drop off and pick up SQLite files to copy ZGAMEOBJECTS items from?