https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Fri, 03 Apr 2026 19:17:37 +0000 Fri, 18 Apr 2008 14:41:06 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=25613 https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ https://forums.webwiz.net/change-joineddate-or-registered-date_topic25613_post132812.html#132812 Author: billd3
Subject: 25613
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.
]]> Fri, 18 Apr 2008 14:41:06 +0000 https://forums.webwiz.net/change-joineddate-or-registered-date_topic25613_post132812.html#132812 https://forums.webwiz.net/change-joineddate-or-registered-date_topic25613_post132809.html#132809 Author: sinus
Subject: 25613
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!]]> Fri, 18 Apr 2008 14:11:28 +0000 https://forums.webwiz.net/change-joineddate-or-registered-date_topic25613_post132809.html#132809 https://forums.webwiz.net/change-joineddate-or-registered-date_topic25613_post132806.html#132806 Author: michael
Subject: 25613
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.
]]> Fri, 18 Apr 2008 13:56:08 +0000 https://forums.webwiz.net/change-joineddate-or-registered-date_topic25613_post132806.html#132806 https://forums.webwiz.net/change-joineddate-or-registered-date_topic25613_post132793.html#132793 Author: sinus
Subject: 25613
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!


]]> Thu, 17 Apr 2008 21:34:59 +0000 https://forums.webwiz.net/change-joineddate-or-registered-date_topic25613_post132793.html#132793