So phpnuke just a a string representation...
As far as I know, It's not possible to do it with just MySQL, though
there may be some function I'm not aware of.
The Unix binary `strtotime`, used to convert a multitude of readable
date formats into a Unix timestamp, should be able to do that. So yo
> > I am testing moving from a phpnuke site to a xoops site. In doing so, I
> > am trying to get the user table moved over.
> >
> > I see in the phpnuke tables (which a similar table exists in xoops)
> > that the users have a sign up date. The date in phpnuke is the
> > calendar day, May 1, 2004,
In the last episode (Nov 28), Eric Wagar said:
> I am testing moving from a phpnuke site to a xoops site. In doing so, I am
> trying to get the user table moved over.
>
> I see in the phpnuke tables (which a similar table exists in xoops)
> that the users have a sign up date. The date in phpnuk
Looking at the structure of xoops.users shows the users_regdate as int(10),
and phpnuke.users is varchar(20).
This means that phpnuke.users would need to be ||UNIX_TIMESTAMP(). And, I see
in the MySQL book (2nd ed., pg 828) that UNIX_TIMESTAMP works with date-time
or timestamp format of ccyymm
I don't have experience with either of those programs, but I think you
can convert them.
It looks like phpnuke is keeping the date in a DATE (or maybe a DATETIME
or TIMESTAMP) column and xoops is keeping the date in an INTEGER column
in Unix timestamp format.
If both of those are true then you
I am testing moving from a phpnuke site to a xoops site. In doing so, I am
trying to get the user table moved over.
I see in the phpnuke tables (which a similar table exists in xoops) that the
users have a sign up date. The date in phpnuke is the calendar day, May 1,
2004, for example. In xo
