Jump to the post that solved this thread.
Thread Rating:
  • 2 Vote(s) - 3 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 12 Years, 2 Months, 3 Weeks ago Change joined date
#1
Solved: 12 Years, 2 Months, 3 Weeks ago
Is there a way to change the date you joined, and change other users date joined also? Also is there a way to change UID's with out merging other users?
#2
Solved: 12 Years, 2 Months, 3 Weeks ago
You can change a user's joined date using this query:

UPDATE `mybb_users` SET `regdate`='X' WHERE `uid`='Y'

X = UNIX TimeStamp of your chosen join date
Y = UID of user whose joined date your changing

As far as changing a users ID without merging, I strongly advise against it as you'll likely run into complications.
[Image: information.gif] MyBB Support Technician
Please do not PM me for support.


MyBBatically - A quick and easy way to update your board!
#3
Solved: 12 Years, 2 Months, 3 Weeks ago
(2012-08-12, 07:21 PM)Vernier Wrote: You can change a user's joined date using this query:

UPDATE `mybb_users` SET `regdate`='X' WHERE `uid`='Y'

X = UNIX TimeStamp of your chosen join date
Y = UID of user whose joined date your changing

As far as changing a users ID without merging, I strongly advise against it as you'll likely run into complications.
where would we add this code?
#4
Solved: 12 Years, 2 Months, 3 Weeks ago
Run that query in PHPMyAdmin or whatever database manager you use. Smile
[Image: information.gif] MyBB Support Technician
Please do not PM me for support.


MyBBatically - A quick and easy way to update your board!
#5
Solved: 12 Years, 2 Months, 3 Weeks ago
PHPMYADMIN>databases>the database that you installed mybb on>sql tab>paste this query>execute it>done
<snip - images exceed maximum total dimensions (see the rules)>
Jump to the post that solved this thread.


Forum Jump:


Users browsing this thread: 1 Guest(s)