Change "Joined"date or "Registered" date

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
sinus Members Profile Find Members Posts Newbie Joined: 04 April 2008 Status: Offline Points: 14	Post Options Post Reply Quote sinus Report Post Thanks(0) Quote Reply Topic: Change "Joined"date or "Registered" 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!

michael Members Profile Find Members Posts Senior Member Joined: 08 April 2002 Location: United States Status: Offline Points: 4670	Post Options Post Reply Quote michael Report Post Thanks(0) Quote Reply 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.
	Blog \| MPG Tracker

sinus Members Profile Find Members Posts Newbie Joined: 04 April 2008 Status: Offline Points: 14	Post Options Post Reply Quote sinus Report Post Thanks(0) Quote Reply 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!

billd3 Members Profile Find Members Posts Senior Member Joined: 19 February 2003 Location: United States Status: Offline Points: 530	Post Options Post Reply Quote billd3 Report Post Thanks(0) Quote Reply 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

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum