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?
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.
(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?
Run that query in PHPMyAdmin or whatever database manager you use.
PHPMYADMIN>databases>the database that you installed mybb on>sql tab>paste this query>execute it>done