Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Advice on resetting membership each year
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Advice on resetting membership each year

 Post Reply Post Reply
Author
aussiem8 View Drop Down
Groupie
Groupie


Joined: 23 February 2012
Status: Offline
Points: 55
Post Options Post Options   Thanks (0) Thanks(0)   Quote aussiem8 Quote  Post ReplyReply Direct Link To This Post Topic: Advice on resetting membership each year
    Posted: 22 January 2013 at 2:37pm
Hi guys

After your thoughts on the best way to tackle this, and what impact it would have on existing threads.

I run a social rugby league tipping comp here in Australia with 200 members (maybe more this year).  I've been using the webwiz forum as part of the site and have put some minor mods in the forum then align the tipster login details between the forum and tipping sections of the site (basically, I use common usernames and userid numbers). 

Each year with the tipping comp, I clear out all the previous years players and then setup new ones for the next year when people register so the tipster numbers start again from #1 through to #200.  I was planning to do the same with the forum by removing all members, then adding them back in like I did the first time.   I can automate this with MySQL, so that's not the issue but I'm wondering what impact this would have on existing posts.

Specifically, if I were to remove all the current forum members and create new ones, would the existing posts screw up by replacing the new user's username against those posts?

eg.
Old Year
Member 100 = Fred Smith
Member 101 = John Brown
Member 102 = Billy Bloggs

New Year
Member 100 = Silly Sausage
Member 101 = Fred Smith
Member 102 = Johnny Rotten

If old member John Brown (#101) posted a topic last year and I reset the membership (using the same userid number range as before), would that topic then appear as posted by Fred Smith (who is now member #101 this year)?  

If this happens, then my thoughts are to leave last years membership as is (and make them inactive members) then change my mod slightly to identify what years comp is active.  Once I know this, I could then re-number the tipping userid (eg. this year, start members from #1100 so when I login and go to the tipping, I just deduct 1000 from the userid which will then align with the correct tipping id).

Another idea was to add a 'year' and 'tippingno' column to 'tblAuthor' then send this to the tipping pages.

Any suggestions/thoughts/comments are welcomed.








Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 23 January 2013 at 9:36am
If you change the username then the username next who made the post would also be changed.
Back to Top
aussiem8 View Drop Down
Groupie
Groupie


Joined: 23 February 2012
Status: Offline
Points: 55
Post Options Post Options   Thanks (0) Thanks(0)   Quote aussiem8 Quote  Post ReplyReply Direct Link To This Post Posted: 23 January 2013 at 9:57am
Not quite understanding you there Bruce. Confused

Are you saying that the original posts/threads will retain the original username, and any future posts after changing the name will have the new username?  If so, that's exactly what I want to happen.
Back to Top
aussiem8 View Drop Down
Groupie
Groupie


Joined: 23 February 2012
Status: Offline
Points: 55
Post Options Post Options   Thanks (0) Thanks(0)   Quote aussiem8 Quote  Post ReplyReply Direct Link To This Post Posted: 23 January 2013 at 12:17pm
I did a test and removed all members from tblAuthor (except Admin and Guest) and it didn't like it, so I think the answer to my question is NO!

I'll go with the other option and leave the old members there (making them inactive) and add the new ones.  I will have to rename the old usernames (say by adding "_2012")  to the end otherwise
there will be duplicate names which is likely to cause other issues.

Bruce - you should probably move this to the modifications forum :-)
Back to Top
aussiem8 View Drop Down
Groupie
Groupie


Joined: 23 February 2012
Status: Offline
Points: 55
Post Options Post Options   Thanks (0) Thanks(0)   Quote aussiem8 Quote  Post ReplyReply Direct Link To This Post Posted: 23 January 2013 at 2:01pm
Just in case anyone else is looking at doing the same as me:

This is what I did:
1. Created a new Group in Group Admin with zero access to all functions
2. Renamed all users (except Admin and Guest) with leading or trailing text.  In my case, I added the year afterwards so existing users could re-register with their original username
3. Moved all those users into the new 'no access' group
4. Banned all users in the 'no access' group
5. Disabled PM's for users in the 'no access' group

This basically achieves what I want and that is to retain old posts/threads but allow members to re-register under their old usernames.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.