Friendly Star Trek Discussions Fri Nov 22, 2024 2:34 am  
  SearchSearch   FAQFAQ   Log inLog in   
Unused Accounts
View: previous topic :: next topic

stv-archives.com Forum Index -> Suggestions, Feedback, & Help This topic is locked: you cannot edit posts or make replies.   This forum is locked: you cannot post, reply to, or edit topics.
Author Message
Joey
Rear Admiral


Joined: 13 Jul 2001
Posts: 4708

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


View user's profile Send private message Send e-mail  
Reply with quote Back to top
Tyvek
Rear Admiral


Joined: 11 Jul 2001
Posts: 2821
Location: Mississippi, USA

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


View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger MSN Messenger 
Reply with quote Back to top
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!

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


View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger 
Reply with quote Back to top
Joey
Rear Admiral


Joined: 13 Jul 2001
Posts: 4708

PostTue Dec 11, 2007 4:34 pm    

I supose that the said accounts could be deleted through the database (less time consuming)

View user's profile Send private message Send e-mail  
Reply with quote Back to top
anywaythewindblows
Lieutenant, Junior Grade


Joined: 01 Apr 2005
Posts: 74

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

View user's profile Send private message Send e-mail  
Reply with quote Back to top
Lord Borg
Fleet Admiral


Joined: 27 May 2003
Posts: 11214
Location: Vulcan Capital City, Vulcan

PostFri 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


View user's profile Send private message  
Reply with quote Back to top
robbiewebster
Rear Admiral


Joined: 27 Apr 2004
Posts: 2594
Location: Rochester, New York

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


View user's profile Send private message Send e-mail Visit poster's website AIM Address  
Reply with quote Back to top
Joey
Rear Admiral


Joined: 13 Jul 2001
Posts: 4708

PostSat Mar 15, 2008 9:59 pm    

like a perfect example :


"janeway_pie_one"

Third ever user.

0 Posts


View user's profile Send private message Send e-mail  
Reply with quote Back to top
Kyle Reese
Cadet Gunnery Sergeant


Joined: 21 Apr 2003
Posts: 5672
Location: The United States of America

PostWed 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


View user's profile Send private message Send e-mail Visit poster's website  
Reply with quote Back to top
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!

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


View user's profile Send private message Send e-mail Visit poster's website AIM Address Yahoo Messenger MSN Messenger 
Reply with quote Back to top
mr_glyn
Lieutenant Commander


Joined: 16 Apr 2002
Posts: 253
Location: Kent, UK

PostWed 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


View user's profile Send private message Send e-mail Visit poster's website MSN Messenger 
Reply with quote Back to top
Joey
Rear Admiral


Joined: 13 Jul 2001
Posts: 4708

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


View user's profile Send private message Send e-mail  
Reply with quote Back to top
mr_glyn
Lieutenant Commander


Joined: 16 Apr 2002
Posts: 253
Location: Kent, UK

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


View user's profile Send private message Send e-mail Visit poster's website MSN Messenger 
Reply with quote Back to top
Joey2
Guest





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


 
Reply with quote Back to top
Display posts from previous:   
This topic is locked: you cannot edit posts or make replies.   This forum is locked: you cannot post, reply to, or edit topics.



Jump to:  
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
Powered by phpBB © 2001, 2002 phpBB Group
Star Trek �, in all its various forms, are trademarks & copyrights of Paramount Pictures
This site has no official connection with Star Trek or Paramount Pictures
Site content/Site design elements owned by Morphy and is meant to only be an archive/Tribute to STV.com