Change "Joined"date or "Registered" date
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=25613
Printed Date: 03 April 2026 at 7:09pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Change "Joined"date or "Registered" date
Posted By: sinus
Subject: Change "Joined"date or "Registered" date
Date Posted: 17 April 2008 at 9:34pm
My forum has been around since 2001 and recently switched to WebWiz.
I'd like all my users to retain their original Join date.
How can I change the "join" date of my members?
Thanks!
|
Replies:
Posted By: michael
Date Posted: 18 April 2008 at 1:56pm
Do you still have a copy of the original tables? If it is access, it might be more tricky as you'd have to export the original users table to the wwf one but basically you can do something like (pseudo)
Update usertable set joindate = (Select oldjoindate from olddatabase.oldusertable where oldusername = username)
Be careful, this naturally will not work like this but might put you on the right track.
-------------
http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker
|
Posted By: sinus
Date Posted: 18 April 2008 at 2:11pm
Hi Michael,
Thanks for your reply.
Unfortunately I don't have a database from the previous incarnations of my forum -
I just have a simple list of users and the dates they joined.
My old members need to re-register on my new WebWiz forum (hosted by WebWiz).
I'd like to be able to change the "join" date for each member, as they join.
If someone joins today, is there something I can edit,
so that their join date displays as an earlier date?
If so, I'd appreciate if you could tell me specifically which file to edit and what lines to change - this is new to me.
thanks!
|
Posted By: billd3
Date Posted: 18 April 2008 at 2:41pm
Is this something where a person could poke into the SQL tables and manually make a change?
We do that sort of thing at work with other SQL applications where we can make changes - our DBA knows how to modify things directly in SQL.
I'm not saying to try it with the forums, that's a Bruce question, but it seems that someone with some SQL abilities could indeed make manual, one at a time changes, or create a SQL script to run.
-------------
BillD
http://theamcpages.com
http://theamcforum.com
|
|