Old aRO Forums

Server Updates & Info => Announcements => Topic started by: Linus on September 29, 2014, 03:57:12 pm

Title: Please clean your Forum PMs
Post by: Linus on September 29, 2014, 03:57:12 pm

We are trying to finalize the migration to the new host, but need to do a little house cleaning before we complete the move. It appears that the majority of the forum members (myself included) never delete their forum PMs and over time... these messages have consumed a massive amount of space which is making it difficult to transfer to the new host.

I would like to ask for everyone's help, if you have any messages (inbox, sent, archived, etc) that you can live without, please delete them. If there are messages that you're only keeping for one or two small pieces of information, please write down what you need and delete the rest.

I am going to clean the inboxes for the inactive forum accounts over the last x number of years to try and reduce the size and make our database easier to import to the new host. I will make a backup beforehand so I can restore any messages that may have been deleted accidentally. However I only plan to remove messages sent to those inactive players, not from. So any messages you may have from previous players shouldn't be affected. If you notice any messages you may have needed are no longer there, please reply to this thread. Do not PM me! I'm trying to clean inboxes, the last thing I need is mine being flooded.

Title: Re: Please clean your Forum PMs
Post by: Kyubey on September 29, 2014, 04:06:54 pm

oh okay no one PMs me anyways ._.

Title: Re: Please clean your Forum PMs
Post by: Lavitiz on September 29, 2014, 04:25:28 pm

191 -> 0

/sob

Title: Re: Please clean your Forum PMs
Post by: Jumbo Bear on September 29, 2014, 05:34:34 pm

Quote from: Kyubey on September 29, 2014, 04:06:54 pm

oh okay no one PMs me anyways ._.

pm joo :angel:

Title: Re: Please clean your Forum PMs
Post by: Kerax on September 29, 2014, 06:22:27 pm

I'm too lazy to delete my PMs though.

Title: Re: Please clean your Forum PMs
Post by: Haruu on September 29, 2014, 08:31:07 pm

Quote from: Kerax on September 29, 2014, 06:22:27 pm

I'm too lazy to delete my PMs though.

^

We have to do it Kerax! WE HAVE TO!  :(

Title: Re: Please clean your Forum PMs
Post by: Aena on September 29, 2014, 08:45:26 pm

...
*looks at message count*
Oh gods.......
/sob

Title: Re: Please clean your Forum PMs
Post by: Salamander on September 29, 2014, 09:26:31 pm

i only have a few message but i look into trimming them sometime tomorrow.  :)

edit.
so the ones we sent to inactive people that we archive will be erase too? i.e. sent items

Title: Re: Please clean your Forum PMs
Post by: Kerax on September 29, 2014, 09:56:03 pm

Quote from: Haruu on September 29, 2014, 08:31:07 pm

Quote from: Kerax on September 29, 2014, 06:22:27 pm

I'm too lazy to delete my PMs though.

^

We have to do it Kerax! WE HAVE TO!  :(

But.... Lazy. :|

Title: Re: Please clean your Forum PMs
Post by: Haruu on September 29, 2014, 11:31:05 pm

Quote from: Kerax on September 29, 2014, 09:56:03 pm

Quote from: Haruu on September 29, 2014, 08:31:07 pm

Quote from: Kerax on September 29, 2014, 06:22:27 pm

I'm too lazy to delete my PMs though.

^

We have to do it Kerax! WE HAVE TO!  :(

But.... Lazy. :|

But you're not doing Linus a favor. I already did him a favor the other day on the new TeamSpeak. So I'm an exception  ::)

Title: Re: Please clean your Forum PMs
Post by: Shekki. on September 29, 2014, 11:33:52 pm

34 -> 0 There you go!

Title: Re: Please clean your Forum PMs
Post by: Kerax on September 29, 2014, 11:36:47 pm

Quote from: Haruu on September 29, 2014, 11:31:05 pm

Quote from: Kerax on September 29, 2014, 09:56:03 pm

Quote from: Haruu on September 29, 2014, 08:31:07 pm

Quote from: Kerax on September 29, 2014, 06:22:27 pm

I'm too lazy to delete my PMs though.

^

We have to do it Kerax! WE HAVE TO!  :(

But.... Lazy. :|

But you're not doing Linus a favor. I already did him a favor the other day on the new TeamSpeak. So I'm an exception  ::)

But I'd actually have to sort out all the PMs I want to keep, and godddddddd...

Title: Re: Please clean your Forum PMs
Post by: Haruu on September 30, 2014, 03:44:41 am

Quote from: Kerax on September 29, 2014, 11:36:47 pm

Quote from: Haruu on September 29, 2014, 11:31:05 pm

Quote from: Kerax on September 29, 2014, 09:56:03 pm

Quote from: Haruu on September 29, 2014, 08:31:07 pm

Quote from: Kerax on September 29, 2014, 06:22:27 pm

I'm too lazy to delete my PMs though.

^

We have to do it Kerax! WE HAVE TO!  :(

But.... Lazy. :|

But you're not doing Linus a favor. I already did him a favor the other day on the new TeamSpeak. So I'm an exception  ::)

But I'd actually have to sort out all the PMs I want to keep, and godddddddd...

But I was supposed to delete the unwanted PMs, end up reading them all 34 pages instead of deleting it..................................

Title: Re: Please clean your Forum PMs
Post by: Najara on September 30, 2014, 07:19:36 am

SMF goes per SQL, so why don't you just truncate the private messages table?

This will not only greatly benefit the staff to speed up the migration, but also saves forum users that need to go through 100+ pages of PMs lot of time. Worth considering.

Title: Re: Please clean your Forum PMs
Post by: Johnsu on September 30, 2014, 07:53:36 am

106 pages of pm's.


Oh lord.

Title: Re: Please clean your Forum PMs
Post by: Pillowgirl on September 30, 2014, 10:43:55 am

Deleted 30~/inbox 25~/sent pm's, kept 4 total.

Title: Re: Please clean your Forum PMs
Post by: Lavitiz on September 30, 2014, 06:13:19 pm

Quote from: Najara on September 30, 2014, 07:19:36 am

SMF goes per SQL, so why don't you just truncate the private messages table?

This will not only greatly benefit the staff to speed up the migration, but also saves forum users that need to go through 100+ pages of PMs lot of time. Worth considering.

I had assumed Linus knew this already. My guess was he made the post so that active players would help to free up a little bit more space and that he'd be truncating messages from inactive users.

Title: Re: Please clean your Forum PMs
Post by: Tavo on September 30, 2014, 06:19:39 pm

i got 551 pm's can you do it for me lol?

Title: Re: Please clean your Forum PMs
Post by: Mal on September 30, 2014, 09:54:27 pm

This was a painful experience for me.

Title: Re: Please clean your Forum PMs
Post by: Brainfog on September 30, 2014, 10:32:27 pm

deleted them all!

heres a walkthrough picture on how to do it fast, for all you lazy pplz:

(http://i.imgur.com/JtLSREh.png)

Title: Re: Please clean your Forum PMs
Post by: Noobie-Won on September 30, 2014, 10:39:25 pm

Quote from: Brainfog on September 30, 2014, 10:32:27 pm

deleted them all!

heres a walkthrough picture on how to do it fast, for all you lazy pplz:

(http://i.imgur.com/JtLSREh.png)

That advice was useful, I had never considered it could hurt till you put it into perspective with that advice.  Thanks you just saved me a lot of pain!

Title: Re: Please clean your Forum PMs
Post by: ~Axle~ on October 01, 2014, 01:46:14 am

There goes 100+ pages of penis and fart jokes.


And the world is a better place.

Title: Re: Please clean your Forum PMs
Post by: Johnsu on October 01, 2014, 02:38:13 am

Ill do this at work tomorrow, Since there are some PMs from old oldfags.

Title: Re: Please clean your Forum PMs
Post by: ~Axle~ on October 01, 2014, 05:45:16 am

Just purge them all.

Who needs PM's from years ago?

Title: Re: Please clean your Forum PMs
Post by: Johnsu on October 01, 2014, 08:07:07 am

A bunch of them are convos from guild mates that include login info, addresses, and such. Id gladly purge them all, I just don't know exactly where they exist.

Title: Re: Please clean your Forum PMs
Post by: Mal on October 01, 2014, 08:38:31 am

Quote from: Johnsu on October 01, 2014, 08:07:07 am

A bunch of them are convos from guild mates that include login info, addresses, and such. Id gladly purge them all, I just don't know exactly where they exist.

I too have been so far as decided.

Title: Re: Please clean your Forum PMs
Post by: singer of strange songs on October 02, 2014, 03:28:10 pm

Character CP is malfunctioning again.

Title: Re: Please clean your Forum PMs
Post by: GM Ai on October 02, 2014, 04:12:00 pm

Nyx was fiddling with it earlier to try to get it to stop showing the old Valkyrie Helm sprite in place of certain headgear sprites.  I'll let her know.

Follow-up:  Nyx updated the CP sprites, so everything should work right now.  I hope that helps!  If you run into any further errors, try to narrow it down to a specific headgear so Nyx can check its sprite.  Thanks for the heads up on this one.

Title: Re: Please clean your Forum PMs
Post by: yamirichard on October 02, 2014, 11:18:45 pm

there goes all my wolf game memories  :'(

Title: Re: Please clean your Forum PMs
Post by: MaO on October 03, 2014, 09:53:57 am

Done

Title: Re: Please clean your Forum PMs
Post by: Kaeri on October 04, 2014, 12:27:26 am

1276 PMs... I know there's some old stuff i could archive elsewhere or just get rid of entirely. Perhaps i'll take a look this weekend.

For those of you who are lazy: http://www.anesisro.com/forums/index.php?action=pm;sa=prune (http://www.anesisro.com/forums/index.php?action=pm;sa=prune)
(you get to type in a number for "Delete all personal messages older than ___ days.")

Title: Re: Please clean your Forum PMs
Post by: Tibetan_Empress on October 05, 2014, 08:38:13 pm

question,,, sorry not sure where to post this.. on voting I had + bonus points and now they aren't there.. Also when you change over server I want to make sure I dont lose some of my purchases that I still haven't picked up out of storage. Its been close to a yr since I've been able to actually get onto play, and don't want to lose my un-used items. Thx..cant wait til I can get back..

Title: Re: Please clean your Forum PMs
Post by: singer of strange songs on October 05, 2014, 09:00:16 pm

Quote from: Tibetan_Empress on October 05, 2014, 08:38:13 pm

question,,, sorry not sure where to post this.. on voting I had + bonus points and now they aren't there.. Also when you change over server I want to make sure I dont lose some of my purchases that I still haven't picked up out of storage. Its been close to a yr since I've been able to actually get onto play, and don't want to lose my un-used items. Thx..cant wait til I can get back..

Vote and then press the reimburse button. You should get your voting point back.

Title: Re: Please clean your Forum PMs
Post by: Pixie~Stick on October 05, 2014, 09:30:50 pm

over the years ive deleted 5k+ messeges

i aint doing that shit again

*sits on my pm's*

Title: Re: Please clean your Forum PMs
Post by: Pixie~Stick on October 05, 2014, 09:31:52 pm

Quote from: Kaeri on October 04, 2014, 12:27:26 am

For those of you who are lazy: http://www.anesisro.com/forums/index.php?action=pm;sa=prune (http://www.anesisro.com/forums/index.php?action=pm;sa=prune)
(you get to type in a number for "Delete all personal messages older than ___ days.")

.....you win this round

edit: wow i kept only messeges from this year, hardly any left, like 380 pages deleted

Title: Re: Please clean your Forum PMs
Post by: Tibetan_Empress on October 06, 2014, 01:22:58 am

 :-\ MEH   didnt work,,, thats ok you have bigger things to focus on..