So I deleted Everything...

[Pezman]

Well, I accidently deleted this forum today. I was trying to add wabisabi as your new moderator and remove myself and accidently removed the forum instead.

I've spoken with my All-Star programmer and he thinks he can restore "most" of the posts, so we'll see what is possible.

Sorry about that.

[Dreadnaught]

:eek: Alright, well as long as we don't lose everything I don't suppose it's too bad. Good luck with the recovery!

[Ranger]

For one thing, who's Wasabi? Not sure if I'd feel comfortable with an unknown moderating this place of honor.

And the other thing: aah! What the <rest of message lost due to some internet error>

[Rurouni Storm]

Oh well, sh*t happens I guess.

[jessica00]

on the plus side, the forum is BLAZING fast

[cwm]

Originally posted by Pezman
I've spoken with my All-Star programmer and he thinks he can restore "most" of the posts, so we'll see what is possible.

I prefer "Crack programmer," and I'm not yours anymore, PDzman

[Red_Hex]

lame

ranger... since pezman is only our mod because every forum has to have one nominally, and only ever pokes his head in here personally to apologise for a new screwup or warn of the next liberty hes preparing to take... how exactly is he our "familiar" moderator, and what difference does it make?

im more interested in why we need a new mod. we never needed one before. whats the new guy do thats so special?

[Parias]

Easy guys, we don't need to give the admins extra grief over this. Stuff happens, and they're doing everything they can to get everything back to status quo. Patience.

[cwm]

Give pez as much grief as humanly possible

[Ranger]

Originally posted by cwm
Give pez as much grief as humanly possible

I second that motion. Grief in droves.

[MajorTom]

Is there an explanation why our avatars are still there but the posts are all gone?

[Parias]

Originally posted by MajorTom
Is there an explanation why our avatars are still there but the posts are all gone?

Zuh? I'm not following you - how do avatars have any connection whatsoever with existing posts?

[arrrse]

MajorTom, the user accounts & avatars are kept in the main user list for the whole Atari games forums.
I think if Pezman had deleted that, then he'd be in really serious poop.


Do we get some favours from the mods/admins for this?

I've been meaning to get my nick changed to Hoom for a while...

[sauron1]

That would be cool - I'd rather like to be Sh0dan, heh heh.

[Dreadnaught]

I'd like may post count to finally cross 10000. I 've crossed it so many times, but just before it happens they clean out whatever forum I'm in and I don't get there.

Sporry for drunkpost, I'm gonna go see what's happenin at Columbia.

[Parias]

Originally posted by Dreadnaught
I'd like may post count to finally cross 10000. I 've crossed it so many times, but just before it happens they clean out whatever forum I'm in and I don't get there.

Poor Dreaddie :( Every time you say "I'll never get over 10k!", I keep thinking "nonsense, you worry for nothing!"

And yet, somehow, something always happens...

[Nanoprobe]

I'd probably be near there now but everyone suddenly wanting a great postcount made that dream burst.

[MajorTom]

Originally posted by Parias
Zuh? I'm not following you - how do avatars have any connection whatsoever with existing posts?

To be honest I was just being obnoxious and trying to add some grief to the thread for the mods.

Theoretically though, User data could be part of the Forum ID structure and not in a serarate glob somewheres.

Anyhow, a new nick for our Mod could be something like
"ReniVePlu"

[greengrass]

Pezman, you rule man ;)

anyway i doubt forum can be restored if it's not backed up

Theoretically though, User data could be part of the Forum ID structure and not in a serarate glob somewheres.
- these days users are ALWAYS in a separate table so no worries about that :) but theoretically yes you can put them together with the forums ( if you are looking for trouble:) )

[sauron1]

Yep, Dreadie's definitely jinxed - we need to call the Santero for a cleansing. Now, where did I put that vial of rooster blood? :p

ReniVePlu? I don't get it..., can you give me a clue?

[Indictus Ira]

Smooth, now, I have no past and I have no future. And my present is an accident. :weird:

You sure this is not some master plan to kill IW forums all togehter? You not far off with 'accidents' like this.

Er, Gunboat, you know, this post count thing is getting to be, a wee bit, predictable, just spam some porn. If I did it, why not you. :D

*Its these jeans man, I swear, the pants make me do... things...* :bulb:

[Stone]

Poor Dread? What about me? Crud I've been posting here for 4 years or so and I have yet to get over the 600 mark!! Every time I get close to it, we merge forums or get pruned or something! I'm back down to .20 posts per day! :mad: ;)

[Karthik]

Damn, how come IG/IG2 forums don't have any mods, Pezzy?:sour:

[sauron1]

Hey kr4z3d/Indictus, long time no see. :)

[MajorTom]

Originally posted by sauron1


ReniVePlu? I don't get it..., can you give me a clue?

A shortform american pronounciation for "rien ne va plus"

Bablefish says: Forum rien ne va plus = Forum nothing no longer goes

[Indictus Ira]

Originally posted by sauron1
Hey kr4z3d/Indictus, long time no see. :)

AII-OOH! Off to work we go, with a bucket and spade and hand grenade...

G'day ta ya'z. (=8}

[arrrse]

Why hasn't our forum reappeared yet?

[Rurouni Storm]

It may NEVER come back :cry:

[arrrse]

Why wouldn't they?

The Atari forums are like the biggest forums on the net & are running on really serious kit, I can't see how they could do that & not have backups.

Mind you I can't see how the administrator could accidentally destroy the whole forum when trying to simply swap moderators...:bulb:

[ShaggyMoose]

I was just trying to tie my shoes the other day and I nuked east Sydney! Anyone see the parallel I am trying to draw here?:weird:

[Hotfoot]

Originally posted by arrrse
Why hasn't our forum reappeared yet? Probably because all this managed to happen on a weekend. We'll likely see results come monday or tuesday.

[arrrse]

Yeah, I guess...
It is monday evening here now :confused:

[Dreadnaught]

By US Pacific Time (what Pezman is using), it's still 7:30AM at this moment :)

[WetWired]

Well, I've had an admin try to remove a moderator on my forums and accidentally delete the user, so... I'd have to say, though, that undeleting a user is a bigger mess than replacing deleted posts when you have a propper backup. I don't really see what's so hard about it. Just create a new mySQL database, load the backup into the database, come back in 3-4 hours when it's done, then run a short little script something like:
<?php
$connection=mysql_connect('localhost','username','password');
mysql_select_db('databasename',$connection);
$result=mysql_query('SELECT threadid FROM thread WHERE forumid=137');
$threadids='0';
while($thread=mysql_fetch_assoc($result)){
$threadids.=','.$thread['threadid'];
}//endwhile($thread=mysql_fetch_assoc($result))
mysql_freeresult($result);
$result=mysql_query('SELECT postid FROM post WHERE postid IN ('.$threadids.')');
$postids='0';
while($post=mysql_fetch_assoc($result)){
$postids.=','.$post['postid'];
}//endwhile($post=mysql_fetch_assoc($result))
mysql_freeresult($result);
mysql_query('DELETE FROM post WHERE NOT postid IN ('.$postids.')');
mysql_query('DELETE FROM thread WHERE NOT threadid IN ('.$threadids.')');
?>
Then, delete all the other tables, do a mysql dump, delete the part where it makes the tables, then import it into the real DB.

[Jelly]

Just kidding....but he is no longer in the online group...he has been promoted to Associate Producer in Product Development and will be a tremendous asset there. We will miss him, except for these random forum deletions :)

[Parias]

Congrats, Pez... now, fix our forums already :)

[Rurouni Storm]

Originally posted by Jelly
Just kidding....but he is no longer in the online group...he has been promoted to Associate Producer in Product Development and will be a tremendous asset there. We will miss him, except for these random forum deletions :)

I wonder how much of a promition an admin could get for deleting the WoT forums? *hint hint* ;)

j/k, congrats Pez.

[sauron1]

The heck with that, just go for broke and 'accidentally' nuke the UT2003/4 forum. They'll probably make you Atari CEO. :p

[Nightwatch]

Hell he'd get my vote for sure.

GO ON PEZ! SPREAD THE LOVE! YOU KNOW YOU WANT TO!!!

[Red_Hex]

does nothing slow the man down? i remember him being a small time gaming hack, barely any more than... parias, really. and what friends he made along the way...

[Parias]

Originally posted by Red_Hex
i remember him being a small time gaming hack, barely any more than... parias, really

:(

[sauron1]

Don't worry - World Domination surely awaits. The Illuminati look after their own, after all. ;)

[Red_Hex]

hehe, sorry parias, not an insult, it just illustrates that everyone starts somewhere

[Dreadnaught]

So are there other forums that have been nuked?

[Rurouni Storm]

Originally posted by Dreadnaught
So are there other forums that have been nuked?

Nope, we're the only one. We were but one tiny island in a fairly large chain, but the nuke tests just happened to hit us.

[Dreadnaught]

Yeah, I'm beginning to feel like Bikini :rolleyes: :cry:

[MarauderD]

Originally posted by sauron1
nuke the UT2003/4 forum.

NOOOOOO! They haven't even posted a fix for their hard-lock problem! (Despite the fact it's been occurring since 2k3Demo.)

Wow, it's a lot...smaller in here now. :rolleyes:

[Indictus Ira]

Originally posted by MarauderD
Wow, it's a lot...smaller in here now. :rolleyes:

Well, nukeing would create radioactive fallout, and I am sure in some cases this would lead to impotence of some sort, but shrinkage? Perhaps a case of severe leprosy?

It's not how big you are, or how beautiful you are, it is what you do with it that matters the most... :bulb:

Oh and big D, leave the cross dresser hunting to the 'professional-freaks annoymous soscietial treckies' P-FAST for short, seriously, you don't wanna know... :o

[Ironside]

Don't keep your nukes near your lace up shoes?