MyBB Community Forums

So my join date says I signed up in 2014 but I made the forum in January 2016. The join date works fine for everyone else just not for my admin account.
Where can I edit my join date?

(2016-03-11, 05:41 PM).m. Wrote: [ -> ]http://community.mybb.com/thread-188911.html

Do you know where I would edit this? ACP? FTP?

(2016-03-11, 05:50 PM)rarefk Wrote: [ -> ]

(2016-03-11, 05:41 PM).m. Wrote: [ -> ]http://community.mybb.com/thread-188911.html

Do you know where I would edit this? ACP? FTP?

PhpMyAdmin, so MySQL. See here: http://community.mybb.com/thread-124288.html

(2016-03-11, 06:04 PM)grork Wrote: [ -> ]

(2016-03-11, 05:50 PM)rarefk Wrote: [ -> ]

(2016-03-11, 05:41 PM).m. Wrote: [ -> ]http://community.mybb.com/thread-188911.html

Do you know where I would edit this? ACP? FTP?

PhpMyAdmin, so MySQL. See here: http://community.mybb.com/thread-124288.html

In the code: UPDATE [/font][/size][/color][color=#dd0000][size=small][font=Monaco, Consolas, Courier, monospace]mybb_users[/font][/size][/color][color=#007700][size=small][font=Monaco, Consolas, Courier, monospace] SET [/font][/size][/color][color=#dd0000][size=small][font=Monaco, Consolas, Courier, monospace]regdate[/font][/size][/color][color=#007700][size=small][font=Monaco, Consolas, Courier, monospace]='X' WHERE [/font][/size][/color][color=#dd0000][size=small][font=Monaco, Consolas, Courier, monospace]uid[/font][/size][/color][color=#007700][size=small][font=Monaco, Consolas, Courier, monospace]='Y' 
How would I set the date? 1/1/16? I tried changing it but now I signed up in December of 1969.

(2016-03-11, 06:11 PM)rarefk Wrote: [ -> ]

(2016-03-11, 06:04 PM)grork Wrote: [ -> ]

(2016-03-11, 05:50 PM)rarefk Wrote: [ -> ]

(2016-03-11, 05:41 PM).m. Wrote: [ -> ]http://community.mybb.com/thread-188911.html

Do you know where I would edit this? ACP? FTP?

PhpMyAdmin, so MySQL. See here: http://community.mybb.com/thread-124288.html

In the code: UPDATE [/font][/size][/color][color=#dd0000][size=small][font=Monaco, Consolas, Courier, monospace]mybb_users[/font][/size][/color][color=#007700][size=small][font=Monaco, Consolas, Courier, monospace] SET [/font][/size][/color][color=#dd0000][size=small][font=Monaco, Consolas, Courier, monospace]regdate[/font][/size][/color][color=#007700][size=small][font=Monaco, Consolas, Courier, monospace]='X' WHERE [/font][/size][/color][color=#dd0000][size=small][font=Monaco, Consolas, Courier, monospace]uid[/font][/size][/color][color=#007700][size=small][font=Monaco, Consolas, Courier, monospace]='Y' 
How would I set the date? 1/1/16? I tried changing it but now I signed up in December of 1969.

X = UNIX TimeStamp of your chosen join date

Y = UID of user whose joined date your changing

Example | x = 1457721946 = Fri, 11 Mar 2016 18:45:46 GMT

(2016-03-11, 06:45 PM)mssushii Wrote: [ -> ]

(2016-03-11, 06:11 PM)rarefk Wrote: [ -> ]

(2016-03-11, 06:04 PM)grork Wrote: [ -> ]

(2016-03-11, 05:50 PM)rarefk Wrote: [ -> ]

(2016-03-11, 05:41 PM).m. Wrote: [ -> ]http://community.mybb.com/thread-188911.html

Do you know where I would edit this? ACP? FTP?

PhpMyAdmin, so MySQL. See here: http://community.mybb.com/thread-124288.html

In the code: UPDATE [/font][/size][/color][color=#dd0000][size=small][font=Monaco, Consolas, Courier, monospace]mybb_users[/font][/size][/color][color=#007700][size=small][font=Monaco, Consolas, Courier, monospace] SET [/font][/size][/color][color=#dd0000][size=small][font=Monaco, Consolas, Courier, monospace]regdate[/font][/size][/color][color=#007700][size=small][font=Monaco, Consolas, Courier, monospace]='X' WHERE [/font][/size][/color][color=#dd0000][size=small][font=Monaco, Consolas, Courier, monospace]uid[/font][/size][/color][color=#007700][size=small][font=Monaco, Consolas, Courier, monospace]='Y' 
How would I set the date? 1/1/16? I tried changing it but now I signed up in December of 1969.

X = UNIX TimeStamp of your chosen join date

Y = UID of user whose joined date your changing

Example | x = 1457721946 = Fri, 11 Mar 2016 18:45:46 GMT

Could you give me x for january 1st 2016 at any time please

There was already a link included you can use
But try if this works

Epoch timestamp: 1451606400 <--- You want this
Timestamp in milliseconds: 1451606400000
Human time (GMT): Fri, 01 Jan 2016 00:00:00 GMT

(2016-03-11, 06:53 PM)mssushii Wrote: [ -> ]There was already a link included you can use
But try if this works

Epoch timestamp: 1451606400 <--- You want this
Timestamp in milliseconds: 1451606400000
Human time (GMT): Fri, 01 Jan 2016 00:00:00 GMT

Was able to get this fixed, thanks a ton!