Halo Wars leaderboards wiped News

Aside from validating the amount of time gamers sunk into the title, what else did this data provide and is there any serious side-effect of losing it?

Alot of players at the top of the boards will be greetin' in there cheerios.

Ooops!

What, no backups?

DELETE * from GAMES_LEADERBOARD WHERE NAME='Halo Wars'

/oops

I guess we are lucky they didn't use LIKE '%Halo%', *that* would have caused WW3.

Major fuck up.

"any serious side-effect of losing it? "
Disregarding the fact that it'll completly mess up the matchmaking - for a loooong time! - puting vets against new comers, and screwing up the insane amount of points needed for a certain Achievement ?

"I guess we are lucky they didn't use LIKE '%Halo%', *that* would have caused WW3. "

and some light entertainment.

"Aside from validating the amount of time gamers sunk into the title, what else did this data provide and is there any serious side-effect of losing it?"

It's like using scissors on your E-Penis. ;)

Miiguel, i don't think that the matchmaking system is related to the scoreboard system. Iirc, they keep track of their own dataset.

Gamers to find excuse for returning to the real world?

*remembers all the other games with online features*

Face sinks.

@ Xerx3s:
I thought they mentioned TruSkill data was also erased, and the system is more accurate the more it gathers data: http://research.microsoft.com/en-us/proj...

Pity about the matchmaking data. The leader boards are no big loss except to those who were in, say, the top 200 or so.

lolololol

I never understand how stuff like this can happen. They don't make any backups?

Hm, those quotation marks were never closed. That means Robot Entertainment is still talking!

"not sure if data can be restored" = "we're running SQL Server"

huahua

Unacceptible. Every database must have a backup! If you have a system that stores user data the way they have it cannot be that there is no daily backup!

I don't buy this as being an 'accident' at all. As has been mentioned above, there has to be systems in place to back up the data. Persoally I think it was done on purpose. After all, it may make a lot of sense. The game's been altered recently to balance out the battles, and cut down on formulaic wins. And what better way to give newcomers or those previously lacking behind in the leaderboards a chance to fight for a better rating than to reset the leaderboards.

I wish they'd 'accidentally' reset Gamerscores! Imagine how upset the gamers would be who purely play to increase their score.

It would of been hilarious if this happened to Halo 3.

The internet would explode in l337 speak.

@Dizzy:

One the developers at my work managed to run a query along the lines of

UPDATE table SET field1 = 1; field2 = 2; WHERE condition;

on a system a few months back. Restoring that one was a laugh.

Hopefully this will provide some people with a little perspective about what REALLY matters in this world.

@Dizzy - "DELETE * FROM YOURTABLE WHERE ..." is incorrect syntax - it wouldn't matter if they did use like '%Halo%'. Phew.

i agree, sounds like bollocks to me

maybe it ran on a 360 and the machine RROD'd?! :huh:

^ i'm with stupid.

@BabyJesus - You've now got me secretly hoping it does! ;)

I don't buy this as being an 'accident' at all. As has been mentioned above, there has to be systems in place to back up the data.
Not always. backing data up (especially a lot of data) on a system you can't periodically take offline is a very expensive process and requires a lot of technical support. If you're offering something for free, often you don't have the budget to do that. Neither windows live mail (hotmail) or google mail for example are backed up. They are replicated i.e. copied 'live' to a second machine but there is no copy on tape. If you actually read the agreements when you sign up for an account with those two, they specifically say something along the lines of 'we will not back up your data. We will make reasonable efforts to ensure your data is not lost but if it is tough luck'.

if they then have a major failure at the hosting datacentre and both copies get taken out for some reason, then the data is gone. if there's been some nasty corruption - or some does the whole 'drop table' thing - and they didn't catch it before it was replicated to the second copy, then the data is gone.

This is what you get for what you pay for. I'm fairly sure MS do have a backup copy of everyone's gamertags and passwords and points but I doubt very much if they have backups of the individual leaderboards for all the game that may use them on XBox live. That's just not 'mission critical' enough data. if they lose it you can still play the game.

Jon

I bought this and never played it

Haha :)

"@Dizzy - "DELETE * FROM YOURTABLE WHERE ..." is incorrect syntax - it wouldn't matter if they did use like '%Halo%'. Phew. "

Ha yes true... the * shouldn't be there. You can see I am not a SQL guru ;)

Nooooooooooooooooooooooooooo-one cares.

I played a good deal of this online, but as far as I knew there wasn't any online stat tracking like Halo 3. If there was I certainly couldn't (be arsed to) find it. I just played random 3v3 multiplayer games, never worrying about rank or stats. Don't see them as a big deal in games like this. I'd be pissed if it happened in Battlefield 1943 though!

Maybe this will balance out the playing field, since a recent update nerfs/boosts certain units that may or may not have helped top players get there. Now they have to start again without their warthog spamming and hawk rushes.

@jonbwfc

Good post.

@bratmandu: I amazes me why you bother to comment on this then - then again if you're wiling to backup that pseudo-witty of yesterday comment of "no one cares" take a look at halowars.com site and community.

To all the ppl talking about backups (and the lack of it), although there's technology to do backups of 24/7 systems it is not trivial or inexpensive for that matter. The restore process of such data is even more complex and requires efective downtime.

edit: err... now that I've read all the comments, what jon said, though it's a subject that is particulary dear to me as do that stuff for a living. Thankfully we never had to do a full restore of a buisness copy though we did, once, had to recover the all main database to a clone system to recover a few corrupt tables - and that was *expensive*.

What jolly bad news!!

MAYBE THEY SHOULDN'T BE ASKING THE BLOODY ROBOT THEN, EH?! NAY-SAYING PIECE OF JUNK

"If you're offering something for free, often you don't have the budget to do that."
XBox Live isn't free though.

Shit happens, I guess, but when you pay for the service it's not quite as acceptable for stuff like this to happen.

Maybe if they used Oracle instead of SQL Server they would be okay? ;)

big who cares!

problem is that a lot of people just will give up on the game, picture if this had happened on COD4 though...

"You TALKED to it?" exclaimed Ford. "What do you mean you talked to it?"

"Simple. I got very bored and depressed, so I went and plugged myself
into it's external computer feed. I talked to the computer at great length,
and explained my view of the universe to it, " said Marvin.

"And what happened? " pressed Ford.

"It committed suicide, " said Marvin,

LOL

pwned