XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Beginner's Corner 
  4.  / date of joinng
Register
1
katalina
date of joinng

  • 2006/6/15 9:16

  • katalina

  • Just popping in

  • Posts: 26

  • Since: 2006/4/23


My date is wrong, seems I have had XOOPS since 1970/1/1...whaaaaaaaaaaaaa I never had my computer since before my son was born...lmaooooo

Ok serious now. Where to change and find the correct date I installed Xoops?

Thanks

2
katalina
Re: date of joinng

  • 2006/6/18 8:26

  • katalina

  • Just popping in

  • Posts: 26

  • Since: 2006/4/23


Anyone please

3
scoobster
Re: date of joinng

  • 2006/6/20 14:47

  • scoobster

  • Just popping in

  • Posts: 28

  • Since: 2005/2/5 1


I assume you are referring to the 'Member Since' date in your user profile. This is held in the 'users' table in the field 'user_regdate'. You'll have to work out what date you want and change the value accordingly.

As a help, 2006/6/20 15:51 is 1150815114, I believe this is the UNIX time, see UNIX time on Wikipedia.

It may take a bit of working out but you need to add/subtract the number of seconds to get your desired date.
4
christian
Re: date of joinng

  • 2006/6/20 15:55

  • christian

  • Just can't stay away

  • Posts: 401

  • Since: 2002/2/24


you can execute this query in phpMyAdmin :

update xoops_users set user_regdate=unix_timestamp('AAAA-MM-DD') where id=1;
5
scoobster
Re: date of joinng

  • 2006/6/20 16:49

  • scoobster

  • Just popping in

  • Posts: 28

  • Since: 2005/2/5 1


Much easier, should have thought of that! Thanks.
6
katalina
Re: date of joinng

  • 2006/6/22 7:30

  • katalina

  • Just popping in

  • Posts: 26

  • Since: 2006/4/23


Thanks to both of you,

Christian, I have this in that area: 1149678191

Not sure how to alter, or if I am seeing the wrong area in PHPmyadmin.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

333 user(s) are online (227 user(s) are browsing Support Forums)

Members: 0

Guests: 333

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits