|
|
Joined: Apr 2003
Posts: 359
Enthusiast
|
Enthusiast
Joined: Apr 2003
Posts: 359 |
I'd like to change a member's registration date....how can I go about that?
I logged into phpMyAdmin and found U_Registered in the w3t_Users table....but the numbers in the U_Registered field are in some other format: 1105061020
Any help on this is appreciated, Gonzo
|
|
|
|
Joined: Oct 2003
Posts: 2,305
Old Hand
|
Old Hand
Joined: Oct 2003
Posts: 2,305 |
its in unix time.. MOST numbers in MOST databases are in Unix time.. http://us3.php.net/manual/en/function.time.phpto change between a date quickly.. in a php file put and load that file in a browser print_r(mktime(hr,min,sec,month,day,year)); or print_r(mktime(0,0,0,12,25,2001)); for midnite on Dec 25th 2001 or go here http://www.onlineconversion.com/unix_time.htm
|
|
|
|
Joined: Apr 2003
Posts: 359
Enthusiast
|
Enthusiast
Joined: Apr 2003
Posts: 359 |
Thanks Scroungr...
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
Posts: 5,833
Joined: January 2000
|
|
Forums63
Topics37,573
Posts293,925
Members13,849
|
Most Online5,166 Sep 15th, 2019
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|