Get Some

General => General Chat => Topic started by: Apostrophe Spacemonkey on December 09, 2014, 08:19:05 pm

Title: Winning the monkey race.
Post by: Apostrophe Spacemonkey on December 09, 2014, 08:19:05 pm
There are many inactive users, many who only have a couple of posts and probably haven't posted in ages.

How hard would it be the cull them? Or is that not possible.


(http://iforce.co.nz/i/4gotsggw.43f.png)
Title: Re: Winning the monkey race.
Post by: Lias on December 09, 2014, 08:58:05 pm
I suggested culling everyone inative for X years and under x posts years ago.. still hasn't happened :-P
Title: Re: Winning the monkey race.
Post by: Apostrophe Spacemonkey on December 09, 2014, 09:00:31 pm
I suggested culling everyone inactive for 1 day and under 3000 posts years ago.. still hasn't happened :-P

Please action the above request.
Title: Re: Winning the monkey race.
Post by: Lias on December 09, 2014, 09:07:49 pm
DELETE FROM GetSome.Users WHERE name like '%monkey%';

Actioned...
Title: Genociding the monkey race.
Post by: Tiwaking! on December 10, 2014, 08:48:51 am
DELETE FROM GetSome.Users WHERE name like '%monkey%';

Actioned...
I didnt realize "Winning the monkey race" meant "Genociding the monkey race"
Carry on then. Make sure you dont catch Ebola or something
Title: Re: Genociding the monkey race.
Post by: Apostrophe Spacemonkey on December 10, 2014, 08:58:08 am
DELETE FROM GetSome.Users WHERE name like '%monkey%';

Actioned...
I didnt realize "Winning the monkey race" meant "Genociding the monkey race"
Carry on then. Make sure you dont catch Ebola or something

You only catch Ebola from eating monkeys. Not from being one. Or something...
Title: Re: Winning the monkey race.
Post by: DarkVirus on December 10, 2014, 10:26:35 am
I dont understand why, some accounts are made for things like when XLAN was a thing, and when events eventually come back having an account might be useful.

Its not hard to remove the old accounts, and we removed the ones with 0 posts back when you asked, but the ones with 1 or more posts make the forum messier as you cant retain (from memory) who posted if the account is deleted in a mass delete.
Title: Re: Winning the monkey race.
Post by: Zarkov on December 10, 2014, 04:45:07 pm
Just make sure you get rid of that imposter Spacemonkeyorsarus.

He must have done away with the original Spacemonkey.

Poor little guy, he never did anyone any harm.
Title: Re: Winning the monkey race.
Post by: Xsannz on December 11, 2014, 06:45:00 am
I dont understand why, some accounts are made for things like when XLAN was a thing, and when events eventually come back having an account might be useful.

Its not hard to remove the old accounts, and we removed the ones with 0 posts back when you asked, but the ones with 1 or more posts make the forum messier as you cant retain (from memory) who posted if the account is deleted in a mass delete.

it breaks the foreign key constraint :), nah i don't actually know but i suspect deleting users with a nominal amount of posts who are inactive would do something horrible with the posts that exists for those users... like error out thread pages or error the username section of the posts, probably something you want to try by having a dummy account fire up a few posts and then delete the user and see what happens.
Title: Re: Winning the monkey race.
Post by: Xsannz on December 11, 2014, 06:46:44 am
@ Lias you are the worst, there are reasons we don't let everybody loose in the DB backend, you would just fuck up the backend.. and yes that was an entendre just for you.

for the number of people at work who destroy the DB by just deleting stuff they don't think about and then wonder why they have spectacular untraceable front end errors.
Title: Re: Winning the monkey race.
Post by: Lias on December 11, 2014, 09:05:26 am
Just have a maintenance procedure that assigns any post that doesn't match a valid user ID to a special system user ID that's called "Deleted User" or something.

I've seen other forum software have a generic deleted user showing for posts before, how hard can it be.
Title: Re: Winning the monkey race.
Post by: The Demon Lord on December 11, 2014, 09:19:54 am
@ Lias you are the worst, there are reasons we don't let everybody loose in the DB backend, you would just fuck up the backend.. and yes that was an entendre just for you.

for the number of people at work who destroy the DB by just deleting stuff they don't think about and then wonder why they have spectacular untraceable front end errors.



rm -rf / *

Amidoinitrite?
Title: Re: Winning the monkey race.
Post by: Lias on December 11, 2014, 09:42:11 am
rm -rf / *

Amidoinitrite?

Very right
Title: Re: Winning the monkey race.
Post by: Xenolightning on December 11, 2014, 09:48:52 am
1) Identify old users
2) Create "Archive" user
3) Assign all references from old shitty users to new "Archive" user
4) Delete all old shitty users

/Clean.
Title: Re: Winning the monkey race.
Post by: Xsannz on December 11, 2014, 11:40:57 am
1) Identify old users
2) Create "Archive" user
3) Assign all references from old shitty users to new "Archive" user
4) Delete all old shitty users

/Clean.

I never said it couldn't be done, only half the world doesn't and then breaks something.

I better do it since my day job is this, better not let DV or Craig do it..  or we will all get a 404 error and be plunged into  darkness
Title: Re: Winning the monkey race.
Post by: Craigor on December 15, 2014, 09:52:50 am
i suspect deleting users with a nominal amount of posts who are inactive would do something horrible with the posts that exists for those users... like error out thread pages or error the username section of the posts


That doesn't happen, their username is also recorded in the posts table against the post, so if the user ID cannot be found, their historical name is still displayed, but there is no link to their profile and it shows up as a 'guest' user.
Title: Re: Winning the monkey race.
Post by: Xsannz on December 15, 2014, 10:25:08 am
i suspect deleting users with a nominal amount of posts who are inactive would do something horrible with the posts that exists for those users... like error out thread pages or error the username section of the posts


That doesn't happen, their username is also recorded in the posts table against the post, so if the user ID cannot be found, their historical name is still displayed, but there is no link to their profile and it shows up as a 'guest' user.

then we could then remove nominal fringe users..  such as LIAS
Title: Re: Winning the monkey race.
Post by: Xenolightning on December 15, 2014, 11:00:41 am
Stop flapping about it, and do it yo!
Title: Re: Winning the monkey race.
Post by: trololololo on December 15, 2014, 12:55:12 pm
Just randomly assign the orphaned posts to users your going to retain; and do it on the production DB, what could go wrong.
Title: Re: Winning the monkey race.
Post by: Xsannz on December 15, 2014, 01:32:06 pm
Just randomly assign the orphaned posts to users your going to retain; and do it on the production DB, what could go wrong.

Oh you, your the reason i have a job where i do...
Title: Re: Winning the monkey race.
Post by: Apostrophe Spacemonkey on December 15, 2014, 02:09:56 pm
Remember to not take a backup, and do it during the busiest time of the day.
Title: Re: Winning the monkey race.
Post by: The Demon Lord on December 15, 2014, 02:20:35 pm
Remember to not take a backup, and do it during the busiest time of the day.

the scary part is - I do that alot because we have to.....
Title: Re: Winning the monkey race.
Post by: Xsannz on December 16, 2014, 07:12:46 am
Remember to not take a backup, and do it during the busiest time of the day.

or provide an out of date 6 month old backup when you do go to restore it after a fuckup
Title: Re: Winning the monkey race.
Post by: trololololo on December 16, 2014, 08:10:39 am
Just randomly assign the orphaned posts to users your going to retain; and do it on the production DB, what could go wrong.

Oh you, your the reason i have a job where i do...

Not a problem, How's those recent HCS releases going there Xsannz.
Title: Re: Winning the monkey race.
Post by: Xsannz on December 16, 2014, 08:59:10 am
Just randomly assign the orphaned posts to users your going to retain; and do it on the production DB, what could go wrong.

Oh you, your the reason i have a job where i do...

Not a problem, How's those recent HCS releases going there Xsannz.

Cough.. yeah about that check your PM, to much detail to be on here
Title: Happy Birthdays!
Post by: Tiwaking! on December 16, 2014, 09:09:06 am
Happy Birthday  AstroApe (27), CosmoChimp (29), and MilkyWayMarsupial (30)!!
Title: Re: Winning the monkey race.
Post by: Apostrophe Spacemonkey on December 16, 2014, 09:20:59 am
Too many monkey birthdays today.
Title: Re: Winning the monkey race.
Post by: Xsannz on December 16, 2014, 09:32:47 am
Monkey see monkey do
Title: Re: Winning the monkey race.
Post by: Apostrophe Spacemonkey on December 16, 2014, 10:29:10 am
Monkey see monkey do


(http://iforce.co.nz/i/rysepytp.rkq.jpg)
Title: Re: Winning the monkey race.
Post by: Xsannz on December 16, 2014, 10:49:15 am
i was thinking more

http://youtu.be/0_lc81P-R8k (http://youtu.be/0_lc81P-R8k)