Author |
Message |
Joey Rear Admiral
Joined: 13 Jul 2001 Posts: 4708
|
Tue Dec 11, 2007 1:21 pm Unused Accounts |
|
I really feel the the registered memebers is inaccurate on this forum, there are a TON of members "registered" but with 0 post count even from the day after the site was made, In order to correct this, I think maybe we should attempt to contact these memebers and try to bring them back to "to stv" rather as they never really came here anyway and/or delete them.
and Its not a little thing like 5-6 people, the first 3 pages have over 40 people who have 0 posts. and then there are those with 1-10 posts, and so on
I know this takes time and a little effort but I think its helpful to new users who might want a name taken by a user who has not been on once.
anybody else like that idea?
|
|
|
Tyvek Rear Admiral
Joined: 11 Jul 2001 Posts: 2821 Location: Mississippi, USA
|
Tue Dec 11, 2007 3:37 pm Re: Unused Accounts |
|
harrykim234 wrote: | I really feel the the registered memebers is inaccurate on this forum, there are a TON of members "registered" but with 0 post count even from the day after the site was made, In order to correct this, I think maybe we should attempt to contact these memebers and try to bring them back to "to stv" rather as they never really came here anyway and/or delete them.
and Its not a little thing like 5-6 people, the first 3 pages have over 40 people who have 0 posts. and then there are those with 1-10 posts, and so on
I know this takes time and a little effort but I think its helpful to new users who might want a name taken by a user who has not been on once.
anybody else like that idea? |
I tend to agree, What is the reasoning behind keeping the old unused names with less than 10 posts?
|
|
|
squiggy Stooge Two
Joined: 09 Mar 2004 Posts: 3007 Location: Messing with the fabric of Video Game realities. I'll summon Shiva on you! I SWEAR!
|
Tue Dec 11, 2007 4:30 pm |
|
The fact that it would take literally HOURS combing through to find said accounts.
((I spent a few one night, and I got up to M... and that's the lighter half of the alphabet. You start adding in S's, and T's, and V's, and it triples.))
|
|
|
Joey Rear Admiral
Joined: 13 Jul 2001 Posts: 4708
|
Tue Dec 11, 2007 4:34 pm |
|
I supose that the said accounts could be deleted through the database (less time consuming)
|
|
|
anywaythewindblows Lieutenant, Junior Grade
Joined: 01 Apr 2005 Posts: 74
|
Fri Mar 14, 2008 2:02 am |
|
I had that done to me. I go back to the site and my account wasn't there. it does not feel all that great.
|
|
|
Lord Borg Fleet Admiral
Joined: 27 May 2003 Posts: 11214 Location: Vulcan Capital City, Vulcan
|
Fri Mar 14, 2008 3:28 pm |
|
It all depends on how things are done. While I personally agree with what harrykim234 is saying, I'd imagine this has come up before. How long it would take varies, depending on how things are set up on the forum. I'd bet it would take a while, though.
-------signature-------
When you cried I'd wipe away all of your tears
When you'd scream I'd fight away all of your fears
And I held your hand through all of these years
But you still have
All of me
|
|
|
robbiewebster Rear Admiral
Joined: 27 Apr 2004 Posts: 2594 Location: Rochester, New York
|
Fri Mar 14, 2008 6:50 pm |
|
anywaythewindblows wrote: | I had that done to me. I go back to the site and my account wasn't there. it does not feel all that great. |
Well it's a little different if its been 5 years since the person was on the site and they've never posted.
|
|
|
Joey Rear Admiral
Joined: 13 Jul 2001 Posts: 4708
|
Sat Mar 15, 2008 9:59 pm |
|
like a perfect example :
"janeway_pie_one"
Third ever user.
0 Posts
|
|
|
Kyle Reese Cadet Gunnery Sergeant
Joined: 21 Apr 2003 Posts: 5672 Location: The United States of America
|
Wed Mar 19, 2008 6:26 pm |
|
Yeah, removing �ber-old accounts with 0 posts makes sense, but what's the motivation? Most of those accounts' names are very original and unlikely to be duplicated by any newcomers, most of whom don't post either.
(God, who joins and never posts? Losers. )
Last edited by Kyle Reese on Thu Apr 24, 2008 6:25 pm; edited 1 time in total
|
|
|
squiggy Stooge Two
Joined: 09 Mar 2004 Posts: 3007 Location: Messing with the fabric of Video Game realities. I'll summon Shiva on you! I SWEAR!
|
Sun Apr 13, 2008 12:23 am |
|
Kyle Reese wrote: | Yeah, removing �ber-old accounts with 0 posts makes sense, but what's the motivation? Most of those accounts' names are very original and unlikely to be duplicated by any newcomers, most of whom don't post either.
(God, who joins and never posts? Losers. ) |
Almost as annoying as those people who join, post a single post in the Web-link forum, and never come back.
|
|
|
mr_glyn Lieutenant Commander
Joined: 16 Apr 2002 Posts: 253 Location: Kent, UK
|
Wed Apr 16, 2008 6:02 am |
|
Actually to remove Hundreds or thousands of accounts. Morphy must have database access so a simple DB command like...
Code: | DELETE * FROM [table] WHERE post_count = "0"; |
This will delete all accounts from the database with 0 post counts.
However this will need to be adapted to fit the database.
I'll accept payment later lol
|
|
|
Joey Rear Admiral
Joined: 13 Jul 2001 Posts: 4708
|
Wed Apr 16, 2008 8:44 pm |
|
Keeping in mind how huge the DB really is That could potentially put a big strain on the server to remove all of those accounts, slowing STV down
Along with that, it would take some time i imagine to do that
But as its up to M anyways.....
|
|
|
mr_glyn Lieutenant Commander
Joined: 16 Apr 2002 Posts: 253 Location: Kent, UK
|
Thu Apr 17, 2008 6:49 am |
|
Proberly take about 10 mins?
And as for a strain on the server? No chance.
As for a big Database with MySql try one with several million entries.!!!
You may think I have no idea that I am on about but.
I Manage
7 Webservers
3 MySql servers + 5 with load balancing.
2 Mail Servers POP3 + 2 Mailservers SMTP
adding to that 2 File servers and 3 in house servers.
I know a thing or two about them!
Oh and I am the Technical manager.!
|
|
|
Joey2 Guest
|
Thu Apr 17, 2008 10:19 am |
|
(Harrkim234>I did not feel like logging in...)
(lets not turn this into a big old argument, K?)
Look, Im not saying I know more than You,
I was just saying I know the server STV is located on.
Occasionally it gets testy about mySQL processes. Thank you for sharing your abilties,
But If M wants to do that he can. Its his website ater all
It might take ten minutes, sure. we can monitor the load. It may do nothing at all to it. but sometimes it likes to hate the mySQL processes.
So maybe M will do it, maybe he wont. ask him?
|
|
|
|