Someone set up us the bomb (ap I’m looking @ you)

Posted in Flash Flash Revolution on November 21st, 2010

Jonathan | Velocity: Tyler broke shit, others failed at fixing, wild synth appeared. Shit fixed, Vet Alive, MP updates coming.
Amy: The database housing FFR got into a wizard-of-oz like mess. It had to find its way to the wonderful wizard of oz to get its brain back. Along the way it met Synthlight, aperson and Sprite-. The end.
Amy: and yes… aperson is the cowardly lion.
Dom: tl;dr: verify yo backups
Dom: -FFR Staff

aperson’s Lesson of the day: If you’re going to restore from a backup make sure the backup itself isn’t corrupt.
That’s a tough lesson to learn. We lost our master VBulletin User table after aperson tried to roll back the user table to a backup he had just made that was corrupt.

The next morning, Synth got the user table from his backup that he used to bring the site back up in October. Lightdarkness patched in the new userids from our game statistics, and then Sprite and aperson went through and updated all of the table information to be coherent with the other tables. Fortunately, lots of the information was stored elsewhere. We were able to update the passwords that were changed during this period because VBulletin is nice enough to store every password ever used.

There were a few things we were not able to restore however. Custom Avatar information has become corrupted due to a mismatch in where the avatar is linking to for any users that changed their avatars since October 10. In the restore process, we have lost approximately 0.05% of the userbase on FFR. However, we will be glad to work with any of the affected accounts to restore them or transfer their stats to a new account. You may PM an admin for assistance if you have created a new account since the site came back online on October 10.

For some good news, we are rolling out veteran status. Initially, this will be set for users who have both 3 years since their join date and 3 billion grand total points. This limit is subject to opening up, but not becoming more restrictive. We will be changing the word ‘Subscriber’ to the word ‘Veteran’ over & over shortly, as well.

Also!
Expect some MP updates coming soon :-)

89 Responses to “Someone set up us the bomb (ap I’m looking @ you)”

  1. Also the database did this:
    http://www.youtube.com/watch?v=FEgGE81joB8
    before dieing.

  2. verify yo backups
    -FFR Staff

  3. tail -5 theshitujustdumped.sql

  4. yall should update yall V bulletins to 4.0 i have it here what it look like its easy an sorted an easy to navigate tass also has it http://nightrider001.com/forum/index.php

  5. Welcome back guys ;)

  6. Up for 5 mins and 100 people are already logged in…I like

  7. Post of the year

  8. Uhm, how is the Veteran status working exactly? I’ve been on this site for 3.4 years. And I don’t see it anywhere..Help?

  9. Your grandtotal is less than 3 billion points

  10. And this is why we can’t have nice things.

  11. How to become a veteran? i was already a subscriber.

  12. I like this “Veteran” idea :) )

  13. aPerson, it said either OR. It didn’t say you needed both. Either 3 years+ OR 3bill score. =/. You guys lied..D:

  14. nice to be back. Hope FFR stops having major issues ;)

  15. I don’t like the idea of having to have both a 3 year old account and 3 billion points, having either or is perfectly fine

  16. I don’t have veteran status currently but I have both a 3+ year old account and 3 billion+ points.

    And I was a subscriber before.

  17. Welcome back, FFR =P

  18. nice token graphics guys

  19. im over 5 years. lets make a “senior veteran” bracket

  20. This is gay. Make me a veteran

  21. My account MrShermanboy I think was one of the accounts affected andi would really like it restored!

  22. leonid at least you are still blue. And lol i lost a bunch of forum posts.

  23. It wont let me log into MrShermanboy and it also says the email cannot be reconized… :(

  24. agree with Nytmares_R_Real im a 6.54 years an thats a good idea ppl over 4 yrs like 5/6/7 the beginning of the website should have that

  25. i lost about 350 forum posts rofl

  26. leonid thats not as bad as not being able to log into an account. >.>

  27. Well if you stay patient maybe youll get your account back huh? Or have your stats transferred?

  28. I lost 700 forum posts and my avatar. My new one is cooler anyway and my picture dictionary is still up so… I don’t care. :) Loving the veteran status btw ;)

  29. Good game AP.

  30. Boo. I’ve been on the site for 5.35 years but I don’t have 3 billion points :( Only 1.3 Billion…

  31. sooooooo close to 3 years :\

  32. I PITY THE FOOL

  33. Thanks for lettin us knoww hat’s goin on, guys. Lovin the new management.

  34. Is Veteran = Elite FFR Supporter? Because since today i’m the one of the elite supporters, lol.

  35. I’ve heard that at one point, the site crash was so dire as to Sprite predicting that we might’ve had to work our way from 2004 data – which meant that many users could’ve potentially been lost from existence. I am so glad that the site is almost perfectly intact. Great job guys.

  36. Maybe I don’t understand, but those who are/were subscribers are having FFR Elite Supporter changed to Veteran even if they have less than 3 years and 3 bill? I think old and current subs should get a bonus title or keep Elite Supporter :P

  37. Well, it’s good to see FFR running again. =) Great job, guys.
    Can’t wait for MP. :)

  38. lolwut

  39. Wasn’t anticipating any of that to be the reason why FFR was down longer than expected. Glad to see the site is back up with fairly minimal losses!
    So are FFR subscribers technically veterans at the moment? I still have all of my subby features still so I’m just wondering. Also, those who have subby time at the moment…are they going to have this time converted into veteran time or something if they don’t currently meet the requirements?

  40. I just lost like 1300 forum posts what just happened?

  41. lol I have 2.92 years/18.5Bil and I have Veteran Status ;P

  42. 2.94 years*

  43. I lost a tenth of my forum posts. A.K.A. 1 forum post. Life didn’t change much for me.

  44. a wild derpachu appeared. ofuc

  45. I’m with leonid on this. :P

  46. I propose a case by case basis for users who have like 5+ years in and have under 3 billion. Because otherwise I wouldn’t qualify. Ain’t that some shit. :V

  47. Just got 3 years a couple days gao : 3.01 years actually and over 4.7 billion, but I don’t have the veteran status :’(

  48. Cool beans!

  49. I lost about 500 forum posts.

  50. I have 5.7 years and 1.04 billion score…

    I play often enough though :( So what can you do to help me out?

  51. play more.

  52. i have just about a year, and my grand total is almost 4 billion….

  53. well, im one of the ones who lost their avatar…go figure it would be me, as if i havnt had enough problems with computer related stuff lately

  54. okay then let just have a good FFR Thanksgiving everyone since we are back online for now….and someone pass me the cranberries plz

  55. What happened to all the songs, lol just out of curiosity there is none when I load up the game to play, and my new account is vanquished hehe, love that word…im some glad i still remember this password xD

  56. Nvm excuse that last post about the songs not on..they seem to be on now xP maybe im losing my mind haha.

  57. I have a question are the FFR staff gonna count the yr you guys were offline and add that to our veteran status or no?

  58. blue?

  59. @aperson…
    BUSTED!:D
    People make mistakes haha(:

  60. multiplayer updates! yes!

  61. So nothing that was made or done before 11-16-2010 (the end of FFRs long downtime) aren’t affected?

  62. Which is to say I’m not going to find a bunch of weird or missing stuff around here, which may or may not have been indirectly affected by this…..right?

  63. It’s been a while since I’ve seen my account as Subscriber! Really happy :D

  64. (BTW….the end of the downtime was 10-16-2010 IIRC, not 11-16-2010!)

  65. This is awesome :D

  66. Now, for some reason, I have an unread PM (even though I don’t).

  67. i have yet to revieve any help from an admin on trying to get my account MrShermanboy restored..

  68. let alone any responses to my PMs

  69. Patience shammy.

  70. Sorry shamwow I’ve been at work all day because I actually have a fucking job. I’m going to go read your PM titled “URGENT!! PLEASE READ ASAP!” now….

  71. kekeke

  72. emerald, I’ve had the same problem for over a year now. Even deleted every single post in my inbox and still had 1 unread message.

    Also, I still think there should be separate brackets for veteran status >_>

    3 year+ member time = FFR “resident” veteran
    5bil+ GTS = FFR “gaming” veteran
    1.5k+ forum posts = FFR “community” veteran

    And maybe find some way to tag each user as a “resident/gamer/prolific poster”?

    And just add each new title amendment as the qualifications are achieved.

    I know I already suggested it before, but veteran status based primarily on member time is just… idk.

  73. yeah I have 2 unread PMs for some reason, was thinking it was something to do with the veteran status but no.

  74. admin have job = take awhile to restore an fix things on website i have also a job an i’m working on my own site. job = pay = pay the server to stay on line.Synthlight works alot also that’s why he ant on alot so new crew come on board an help out which speed the process 10x fast an better approve! ^.^

  75. 5 years or more with under 3 billion since i dont play the game. lets think about it

  76. I LOVE TROLLS! <3
    ^
    U
    U
    U
    U

  77. Nytmares_R_Real,
    You and me are in the same-ish boat, 5.7 years, 2.3 bil, so apparently I’m not a veteran . . .

    apparently . . .
    -.-

  78. Well, then all you have to do is play a little more of the game. You know, the whole purpose of the site in the first place.

  79. I’ve been here 4.3 or so years and I’m at like 600mil grand total so I’ve got a way to go MrPoptart.

  80. Thx for the veteran! I’m checking if my comment is gonna show blue here.

  81. Guess not

  82. Hey,every time i FC a song it doesn’t show up on the actual game saying FC.
    only some of the songs do.
    (BEFORE FFR DIED,The site>.<)
    but is it just me or i am i doing something Wrong?

  83. And i need Veteran been here for 3 years lol.

  84. color test?

  85. Color Test?

  86. Wait so, I basically have the same status as a subscriber, and didn’t pay a penny?

  87. Ah.. I was already wondering why I was suddenly a veteran and why my name was suddenly blue in the chat.. :P

  88. I wholeheartedly agree. Verify yo backups!

    One mistake too many people probably make…..they don’t back up frequently enough. Another thing to take to heart.

    And keep numerous backups, just incase one of them corrupts.

    Also, one should keep a backup of the site before it went down (as close to Dec 20th as possible) for nostalgia purposes.

Leave a Reply

You must be logged in or registered to post a comment.