Wednesday, April 8, 2015

The Purge

Want to get the Shiny Starters? Shiny Zorua? Shiny legendary dogs? Shiny Mew? or any other shiny pokemon in the game? Adopt them today using SnD coins! Click here for more info.

Visit the PTD: Pokemon Center - a place to trade pokemon, get your Daily Code, adopt Pokemon, view your items and change your avatar!

Welcome to the Sam and Dan Games Developer Blog!

PTD2 Trainer Pass! Get it today!

A great way to support us while getting amazing rewards!

So let's talk about what you get:
  • Increased chance for Shiny/Shadow pokemon to appear in the wild
  • No ads while you play the game
  • Get a copy of shiny giveaway pokemon automatically every week
  • Faster Breeding - Breed with only one visit instead of 2, essentially breed something everyday!
  • Faster Leveling - Get twice the experience on every battle!
  • Giveaways for pass holders only
You get all of this for only $1.99! One time payment! Get it today!

The Purge
Why can't I play the game? What is this purge that Sam keeps talking about in Twitter? Is my account going to be purged? Will you purge my account? Those are the questions on everybody's mind.

I'm here to answer. For years now the PTD1 and 2 database (where all the user accounts, pokemon, trading information are stored) has been pilling up without any sort of maintenance done on them. The result is databases FULL of data that is no longer used and all it does is slow everything down.

A week ago the servers just couldn't handle it anymore and strange problems started occurring in the game. After talking to my webhost's support team. They told me the problem resided in my side, it was not a hardware issue, and so the PURGE started.

Over 6 months ago I created a code that will write down everybody who logged in ptd2 and stored it in a list. The purpose was that after 6 months we would purge out any other inactive accounts. After talking it over with Dan we decided to also save accounts that had bought the trainer pass or had snd coins (even if they hadn't played for 6 months.)

This would ensure that players that are active can have an even faster experience and all server problems can be resolved a lot quicker.

However one does not simply purge millions upon millions of pokemon in one day. It is a process that takes planning and more importantly TIME.

So I set about creating a script that would automate the whole process. My first attempt could only delete 10 accounts every 20 seconds. We have 7 million account! Lets do the math!

First lets figure out how many attempts it would take if you only do 10 at a time. So 7million divided by 10 = 700,000. That's 700,000 attempts at 20 seconds per attempt. How many seconds is that?

700,000 times 20 = 14,000,000 seconds! Now how many days is that? 14,000,000 seconds / 60 (seconds per minute) /60 (minutes per hour)/24 (hours per day) = about 162 days!

So at that rate the whole purge would take about 162 days!!!!!!

So I worked on making the whole thing faster, instead of deleting a whole account at once I would go thru each database and delete each one individually. This turned out to be a much faster method (can handle over 3000 entries per 10 seconds and many times even more!), but it will still take some time.

So what I will do is update you on how many databases are left to purge that way we can keep track and see how close we are getting. Please not that some databases are smaller than others so some will go a lot faster, some might take a whole day.

So please bare with me and give a moment of silence to all the purge pokemon. Thank you!

Until then I will be working on Designing Champions TD, that means figuring the game out so that we have a clear idea of how long it will take to finish. My hope is that we can finish Champions in 6 months! What do you think?

PTD 2 - Trainer VS Complete!
  • Pick your avatar (100%) - from the ones you have unlocked
  • See more opponent info (100%) - See their wins and their trainer ID
  • Win Streak Mechanic (100%) - Win 7 battles before losing 3 to win a random TM from 10!
  • Win Streak TM Rewards (100%) - Win one of the following Hone Claws, Dragon Claw, Psyshock, Calm Mind, Toxic, Bulk Up, Venoshock, Sunny Day, Rain Dance, Earthquake
Purge Progress Complete!

(Most PTD2 Data is finished, except for trading data which will be last and shouldn't take very long, because all data is held at one server I can't re enable PTD2 until everything is done.)

Complete PTD1 Pokemon Storage Database 5 - about 25 million entries
Complete PTD1 Pokemon Storage Database 6
Complete PTD1 Pokemon Storage Database 7
Complete PTD1 Pokemon Storage Database 8
Complete PTD1 Pokemon Storage Database 9
Complete PTD1 Player's Items Database
Complete PTD1 Player's Achievements Database - about 200k entries
Complete PTD1 Player's Game Corner Database - about 546k entries
Complete PTD1 Player's Daily Codes Database - about 549k entries
Complete PTD1 Player's Pokedex Database - about 4 million entries
Complete PTD Player Account's Database - about 7 million entries
Complete PTD1 Trading Center Database - about 211k entries
Complete PTD2 Trading Center Database - about 600k entries

I'll be updating this during the day as the process moves from database to database. Thank you for your support!

628 comments:

  1. but the important questions is not contest:
    When will finish the purge? 3 days, 1 week, 1 month, etc...
    And pokemon breeding is lost?
    For example: I put 2 shiny pans (panpour female and pansage male shinies), for breed: I lost this pokemon? I look the final time and this pokemon finish breed (and i have luck and obtained shadow panpour), and i look in my profile and dissapear the shinies and shadow. Why? Is lost?
    Thanks for contest ^^

    ReplyDelete
  2. And other questions: Is posible lost database pokedex and hof? It's necesary obtain again this pokemons and register in pokedex and hof (final evolutions, and pre-evolutions).

    ReplyDelete
  3. after 6-7 months will CTD just finish? Or the IU or other programming things will just end but the game will continiously get level and item updates?

    ReplyDelete
  4. Hmm, I would agree, it is important to know how long the purge will roughly last.
    If they are using the code that deletes 3000 accounts every 10 seconds, then in theory, 7 million accounts should only take 6.5 hours to delete? Am I missing something?

    ReplyDelete
  5. Can you update the trading in PTD2 after that? I mean one to be able to edit his trade requests somehow without calling back the pokemon.

    ReplyDelete
  6. it really depends, if enough people want more then we will work on expansions

    ReplyDelete
  7. Nop, for example put 10 hours purge are finish (approximately, need more less time)... But game down 1 week no?

    And ok: The 3000 accounts used today: Tomorrow servers are restart?

    And interest other questions: If you lost breed pokemons, or hof, or pokedex, for example...

    Sincerly, i wait for more information: In twitter this informations appears, but not appears important questions and responses...

    ReplyDelete
  8. if you account is purged then all data from it is gone, but I'm thinking if you had hof data then your account should be safe

    ReplyDelete
  9. it's possible some breeding pokemon were lost before the purge started and those I will replace when possible, but during the purge nothing that was there should be lost


    as far as how long it will last, I don't know for sure since some database will take longer than others

    ReplyDelete
  10. it deletes 3000 entries in one database at a time, accounts are compromised of many data in different databases. by my estimates going database by database is faster than doing a whole account 10 at a time

    ReplyDelete
  11. Sam I might have a idea that might help with the accounts. Maybe you
    could possibly add an option to have the player delete their own
    account instead of not going on for many months and it also might make
    it easier on you too so you dont have to go searching and deleting all
    those accounts.

    ReplyDelete
  12. but for example if i lose my shiny panpour and pansage.... i catch again? Not get back? :(

    ReplyDelete
  13. I hope it doesnt last for more than a month according to those calculations.
    Are you really a mathmagician?

    ReplyDelete
  14. But there are maybe 24 million entries that are not in use, have u tougth about that? then it is only a serten amount that will be deleted..

    ReplyDelete
  15. Sam, what if I won the trainer pass and has not logged in for 6 months? (Lucky me, I won it)

    ReplyDelete
  16. This only helps by an amount. Trainers who really want to delete it will only do it.

    ReplyDelete
  17. Thanks for the update, I'm glad it's going relatively quickly. Hopefully it will feel smoother :)

    ReplyDelete
  18. Yeah that what I was hoping for its the only thing we could do if Sam enables it.

    ReplyDelete
  19. Thats true but it would still help a little bit by putting it in.

    ReplyDelete
  20. I appreciate it :)

    ReplyDelete
  21. then you are good to go

    ReplyDelete
  22. Joel's blog has a giveaway every week

    ReplyDelete
  23. would be cool to allow a way to completely wipe an account but in this case it is faster to just automate it like I have

    ReplyDelete
  24. Don't feel negative, people. Sam is doing this for PTD's good.

    ReplyDelete
  25. What if one never logged into ptd2 but logs into ptd1 quite a bit?

    ReplyDelete
  26. Yeah. I thought it would a good idea for future use so the chances of the purge happening again is lower.

    ReplyDelete
  27. Then ur ptd1 would be saved only

    ReplyDelete
  28. It would still be saved

    ReplyDelete
  29. Yea but doing tho would be finished at apt 2016

    ReplyDelete
  30. The servers are way too complicated to understand its not just one click I recommend an engineer or a person that's good at electronics

    ReplyDelete
  31. Spt 1 0r 2016 unless Sam finds a bye faster way of the purge and no the breeding will not be gone unless you have not bought and coins a trainer pass or logged a lot

    ReplyDelete
  32. Like sam said 6 months or if he finishes the purge he will do cats faster

    ReplyDelete
  33. You would to have to ask my "bro" sam about that he likes feedback

    ReplyDelete
  34. Let me make sure I am getting this. If ! DON'T have a trainer pass or snd coins. It is likely my account will be delete or am I becoming negative? Sorry if I am. I just wanted to make sure what would happen to the people with no trainer's pass or snd coins.

    ReplyDelete
  35. if you haven't logged in ptd2 for 6 months then yes

    ReplyDelete
  36. in never at all to ptd2 in the last six months? then it would be lost

    ReplyDelete
  37. Oh good. at least I have been checking in to ptd2 for less than 6months. say about a week. :)

    ReplyDelete
  38. Thank you And good luck with the challenge ahead.

    ReplyDelete
  39. my account will be deleted? if i dont have snd coins or trainer pass.

    ReplyDelete
  40. Everyone should stop bothering Sam! Let him work!

    ReplyDelete
  41. if you haven't logged in since 6 months, probably, yes.

    ReplyDelete
  42. Is there any way to play PTD 1 or 2 currently without having to connect to the servers? I would love to just play through the story, even if my progress won't be saved, of PTD 1 or 2, since I just discovered the games when the purge happened. So far I've only been able to play PTD 1 (V3.1 Alpha) which doesn't require a server connection. Are there any other alternatives whilst we wait?

    ReplyDelete
  43. I'm hoping my account and the 3 accounts im helping survives. but I think I'm all good and worried for no reason

    ReplyDelete
  44. ven if we looged onlly in pokemon center in 6 months and not in the game will our account be deleted??

    ReplyDelete
  45. Oh no...I haven't been on for a long time and NOW I'M PANICKED! All my progress....my hardwork...if my account is deleted....arg!

    ReplyDelete
  46. I used to love this game...better go back to school of dragons instead...SUCKERS

    ReplyDelete
  47. Why the hell are you people complaining? If you haven't logged on for 6 months then you have obviously stopped caring about the game and aren't going to keep playing. If you cared so much about your account then you should have logged in once in a while. Now shut up and let Sam work.

    ReplyDelete
  48. It might not have been deleted.

    ReplyDelete
  49. yeah thats my feeling too

    ReplyDelete
  50. When is it done!!!!!

    ReplyDelete
  51. i used to love this then i got a lot of others things to do and now i just felt: i feel like playing PTD it was my favourite game i really hope my acount doesnt get lost

    ReplyDelete
  52. Go here if you want to play the game without under the maintance http://toptowerdefensegames.com/pokemon-tower-defense

    ReplyDelete
  53. Go here http://toptowerdefensegames.com/pokemon-tower-defense

    ReplyDelete
  54. well i guess ill have to restart then

    ReplyDelete
  55. I didn't do it, but this is good for the people.

    ReplyDelete
  56. Your probably right that is what I didnt think about.

    ReplyDelete
  57. But its not like its too common.

    ReplyDelete
  58. How would I play the second one though?

    ReplyDelete
  59. If it's really that complex then you shouldn't even bother. But at least I now know not to keep on pushing Sam for the idea. Also thanks for answering. Are we going to hear more of you from now or is it just this once.

    ReplyDelete
  60. I also have a favor to ask if you don't mind. I lost my email address from my PTD 1 account in 2011 and now I finally found it after all those years do you think you could maybe ask Sam to see if he could maybe recover or maybe see if he could somehow check if its still there if its not too late. Thanks.

    ReplyDelete
  61. Also sorry if you arent actually related to Sam I just assumed cause of the name.

    ReplyDelete
  62. i dont wanna lose my account! :,(

    ReplyDelete
  63. Actually I do care about this game except I was banned from using the computer for a while so please STOP MAKING ME FEEL BAD!!!

    ReplyDelete
  64. I got around the thing on PTD 1 by using an older version of the game, but on PTD 2 the version now is the only one (from what i know) if you know an older version please reply.

    ReplyDelete
  65. Same here im so worried i think i have been online in like 6 months but imnot sure i dont want too lose my account that i used for a really long time

    ReplyDelete
  66. If i haven't log in to my account, will my account be deleted?

    ReplyDelete
  67. If i didn't log in for 6 months, will my account be deleted?

    ReplyDelete
  68. http://www.humorsharing.com/pokemon-tower-defense-v3-1/2411
    Version 3.1 of PTD is here, I think it's the latest version that you can play whilst servers are down.

    ReplyDelete
  69. what happens when we dont have snd coins or trainer pass?

    ReplyDelete
  70. hey sam you need to hurry and finish the new update for ptd2

    ReplyDelete
  71. Don't rush him, he is going as fast as he can.

    ReplyDelete
  72. taniabunny72@yahoo.comApril 9, 2015 at 8:47 PM

    i logged in last week will my account be deleted

    ReplyDelete
  73. taniabunny72@yahoo.comApril 9, 2015 at 8:51 PM

    please tell me
    im only nine

    ReplyDelete
  74. taniabunny72@yahoo.comApril 9, 2015 at 8:56 PM

    anyone

    ReplyDelete
  75. taniabunny72@yahoo.comApril 9, 2015 at 8:58 PM

    sam plz anwser i logged on last week will my acount be delete

    ReplyDelete
  76. taniabunny72@yahoo.comApril 9, 2015 at 9:21 PM

    plz

    ReplyDelete
  77. Then like you said before if you didnt log in for 6 month your account will get purged unfortunately.

    ReplyDelete
  78. Pleasedon'tspamthecommentsApril 9, 2015 at 10:15 PM

    No, your account is safe. Only accounts which haven't been logged into over 6 months will be deleted. Accounts which have coins, regardless of inactivity will also remain untouched.

    ReplyDelete
  79. depends in how long. if the last time you logged in was before 6 months ago, your account will be safe

    ReplyDelete
  80. 6 Moths taniabunny, se the realistic that if you haven't logged on for a week your accont will be deleted? Rly? It was just easter people where gone from civilization weeks.

    ReplyDelete
  81. Sorry about the wait and don't worry because you logged last week you are safe.

    ReplyDelete
  82. OK 6 months until I can finally defeat the world tournament and complete this game! Never would of got this far without the help of my PTD pokemon such as: legendary birds, charizard, cloyster, seadra, vileplume, gloom (who is now a bellosom) my number one Pokémon: fearow! Many thanks to them! I also have 2 rapidash... Oh how I go on! Anyway, 6 months until I defeat cilan and get the new moves for my Pokémon when they get to level 110.

    ReplyDelete
  83. If you have logged in in the nearest six months your fine everybody understand please.

    ReplyDelete
  84. Wanna play on my ipadApril 10, 2015 at 4:40 AM

    Anyone knows an version for ios please reply.

    ReplyDelete
  85. well sorry i dont know

    ReplyDelete
  86. sam please do purging much faster

    ReplyDelete
  87. Pretty sure its only if you havent logged on for 6 months which is plenty of time.

    ReplyDelete
  88. is sam almost done with ptd2 purge?

    ReplyDelete
  89. to beat him i used shiny kyogre and groudon, typhlosion, feraligatr, clefable, and haracross all lvl 100

    ReplyDelete
  90. how can i beat darkness? He is SO hard!

    ReplyDelete
  91. Use a team of ominous wind and stored power Xatu. I beat him with two level 70 Xatu.

    ReplyDelete
  92. guys look at castform it looks inappropriate

    ReplyDelete
  93. thank you so much for the info now i don't have to worry:)

    ReplyDelete
  94. Yeah its good when you don't have so much weight on your shoulders. I think it said it on the blog.

    ReplyDelete
  95. Its good the purge is almost over. Pretty fast.

    .

    ReplyDelete
  96. i logged in last week plz tell me i am fine ( ͡° ͜ʖ ͡°)

    ReplyDelete
  97. go on youtube and watch smile hd by misterdavie

    ReplyDelete
  98. how do u do that emoticon?

    ReplyDelete
  99. So much idiots that post a comment "WILL MY ACCOUNT BE DELETED? I USED IT YESTERDAY" before reading the new...

    ReplyDelete
  100. after purge is done, the servers will be on right away? or is there something to do first?

    ReplyDelete
  101. you account wont be deleted

    ReplyDelete
  102. i copyed it off someones comment in a vid

    ReplyDelete
  103. it is done on monday idiot

    ReplyDelete
  104. did you just say april 10 ,2016

    ReplyDelete
  105. How dare you insulting me? :(

    ReplyDelete
  106. How about a free shiny Pokemon of your choice for the accounts that still remained? As a compensation for the purge? I mean the game was offline for the whole week so... ^^

    ReplyDelete
  107. i think hes or shes rightApril 11, 2015 at 2:55 PM

    thats an good idea

    ReplyDelete
  108. i saw it kind of fun

    ReplyDelete
  109. Sam, with the purge ending by monday latest, can you still do the the giveaway the week after, I still haven't got the shadow skelp I have been waiting for

    ReplyDelete
  110. use anything with a move that boosts all stats like ominous wind, ancient power, and the bug type one ( I think it's silver wind). Make sure they are high levels and can heal themselves. I beat this numerous times with different pokemons.

    ReplyDelete
  111. yes, UNLESS you have snd coins or a trainer pass.

    ReplyDelete
  112. It will if u haven't been on in 6 months and if u don't have either the coins or the trainer pass.

    ReplyDelete
  113. But aren't the two accounts the same account?

    ReplyDelete
  114. That would make the trading process easier.

    ReplyDelete
  115. That is a good idea but I think that will take him to long because everyone wants a different pokemon.

    ReplyDelete
  116. always kill lugia last :)

    ReplyDelete
  117. It's only been like a week.

    ReplyDelete
  118. Anyone need help with anything... I'm really bored.

    ReplyDelete
  119. you never told us which date it will be finish sam

    ReplyDelete
  120. stop fighting each other

    ReplyDelete
  121. The purge should be over Monday but if your asking for the actual and last update for PTD 2 ever than that I assume will be close by if I were to take an estimated guess maybe around 2 to 3 months.

    ReplyDelete
  122. Hey I am having the same question

    ReplyDelete
  123. I want my account for both ptd1 and ptd2 fully safe!!!!!!!!!

    ReplyDelete
  124. i know right, but the rainbow dash part grossed me out...

    ReplyDelete
  125. and yes, i am a brony. SO DON'T HATE ON ME!

    ReplyDelete
  126. yes it will so u are SCREWED!!!!!!!!!

    ReplyDelete
  127. That could happen Ash.

    ReplyDelete
  128. I'd just like to confirm. As long as you played PTD1 or 2 between six months ago and April 8, your account won't be purged. What I am not sure about is if you are required to have played /both/ PTD games, because I have barely touched PTD1. I don't remember if I played it within six months of now

    ReplyDelete
  129. if you logged in ptd2 between six months ago you are safe

    ReplyDelete
  130. Ooooh, troll's community, i understand now. Seems funny :D

    ReplyDelete
  131. well it's a good thing that a lot of us did

    ReplyDelete
  132. Exactly, but remember when in PTD1 he gave everyone shiny and shadow like oddish and growlithe and stuff.
    Well he could do something like that, but only aloud to pick 1 poke, and u get 1 M 1 F

    ReplyDelete
  133. i was playing the game when it said my magikarp evolved into ivysaur so now i have an ivysaur

    ReplyDelete
  134. Not rlly man its been 4 days most of the date is done it should be done be Wednesday 15.

    ReplyDelete
  135. The games wasnt off foe the whole week.

    ReplyDelete
  136. Allowed (not aloud)

    ReplyDelete
  137. Just because your an idiot doesnt mean anyone else is

    ReplyDelete
  138. Anyone online ??

    ReplyDelete
  139. I though about something along the lines of maybe free 800 Daily Coins for everyone to convert one Pokemon they want to shiny form.

    ReplyDelete
  140. Yeah you're right, last time I was on was Thursday 2.04, on Friday I couldn't login because of the servers and now we have Sunday 12.04. So it's been 10 days till now, not just a week :P

    ReplyDelete
  141. maybe some kind of quiz with a lot of diferent pokemons and you chosee one, and the "winner" is the one who is everyone gettin or something like that

    ReplyDelete
  142. how do i finish the gym of grass type pokemons the last time i tried to did it, all my pokemons died and the rare candys were stoled, how i keep them alive and keep the rare candys?

    ReplyDelete
  143. hi anyone connected?

    ReplyDelete
  144. to do this ( ͡° ͜ʖ ͡°) you need an arabic keyboard

    ReplyDelete
  145. magikarp in ivysaur right big fun

    ReplyDelete
  146. u will get them safely your account is just purging

    ReplyDelete
  147. Do you really think PTD will be finished by Wednesday.

    ReplyDelete
  148. But if it gets purged doesnt that mean its gone?

    ReplyDelete
  149. finally almost doneeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee

    ReplyDelete
  150. natan kedzierski thebestyodaApril 13, 2015 at 5:40 AM

    ALMSOT FRICKIN DONE COME ON MAN FINISH IT NOOOOOW PLZ . hope my account didnt get deleted and if it did then im not getting a trainer pass AT ALL!!!!!

    ReplyDelete
  151. Sam after the purge is done what will you work on? ctd's update or ptd 2's new verson?I am looking forward to ctd because i liked it more than ptd 2 for some reasons.

    ReplyDelete
  152. Hopefully he will add egg moves sometime in the near future that will make trading much more interesting.

    ReplyDelete
  153. Yep, slowing down Sam.

    ReplyDelete
  154. Is anyone here from Australia and watches Sleepy Hollow or have seen the Channel 11 trailer for it?

    ReplyDelete
  155. will the game be on today sam?

    ReplyDelete
  156. Finally almost done i really hope my ptd 1 account is not deleted =)

    ReplyDelete
  157. Thats what was said but it could change and be post poned.

    ReplyDelete
  158. even though i don't have trainer pass or snd coins but i hope the profile doesn't get deleted along with everyone else's

    ReplyDelete
  159. that's what i'm asking xD if it was post poned or not

    ReplyDelete
  160. i won today's xD but my account is lost already

    ReplyDelete
  161. no one knows

    ReplyDelete
  162. it's over peoplle :D

    ReplyDelete
  163. dude, i am not kidding

    ReplyDelete
  164. its only me that my account was deleted? i used like 3 days before the purge started so i dont understand

    ReplyDelete
  165. it says that my email hasn´t ever been used in this page so please explain to me :(((((

    ReplyDelete
  166. maybe you typed something in wrong

    ReplyDelete
  167. you can email or tweet sam your problem

    ReplyDelete
  168. Your account is deleted unfurtunaly.

    ReplyDelete
  169. YES!!!!!!!!!!!!!!!!!!!!!!April 14, 2015 at 12:37 AM

    IM NOT DELETED YES IM SOO FREAKING HAPPY YEAHA

    ReplyDelete
  170. Any advice on cinnabar gym?

    ReplyDelete
  171. Oh ok sorry bout the misunderstanding but yes it won't be postponed and it on right now as you already know just to answer your question.

    ReplyDelete
  172. Trainer ID: 1177479
    please trade with me :3 Need Shiny Bagon/ Shiny Rayquaza

    ReplyDelete
  173. Or anything good

    ReplyDelete
  174. Finally purging is done, and my all pokemon are safe!!!

    ReplyDelete
  175. Finally purging is done, and my all pokemon are safe!!!!

    ReplyDelete
  176. Finally purging is done, and my all pokemon are safe!!!

    ReplyDelete
  177. Hey Sam what about clear accounts or removing one type individual pokemon??!!!

    ReplyDelete