Winning the monkey race.

[Apostrophe Spacemonkey]

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.

[Lias]

I suggested culling everyone inative for X years and under x posts years ago.. still hasn't happened :-P

[Apostrophe Spacemonkey]

I suggested culling everyone inactive for 1 day and under 3000 posts years ago.. still hasn't happened :-P

Please action the above request.

[Lias]

DELETE FROM GetSome.Users WHERE name like '%monkey%';

Actioned...

[Tiwaking!]

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

[Apostrophe Spacemonkey]

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...

[DarkVirus]

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.

[Zarkov]

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.

[Xsannz]

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.

[Xsannz]

@ 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.

[Lias]

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.

[The Demon Lord]

@ 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?

[Lias]

rm -rf / *

Amidoinitrite?

Very right

[Xenolightning]

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.

[Xsannz]

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

[Craigor]

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.

[Xsannz]

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

[Xenolightning]

Stop flapping about it, and do it yo!

[trololololo]

Just randomly assign the orphaned posts to users your going to retain; and do it on the production DB, what could go wrong.

[Xsannz]

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...

[Apostrophe Spacemonkey]

Remember to not take a backup, and do it during the busiest time of the day.

[The Demon Lord]

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.....

[Xsannz]

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

[trololololo]

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.

[Xsannz]

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