XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk


« 1 ... 5 6 7 (8) 9 10 11 »


71
kjs222
Re: how to work with _priv_msgs:msg_time in sql

  • 2003/11/14 12:45

  • kjs222

  • Friend of XOOPS

  • Posts: 116

  • Since: 2003/3/1 1


Hey gstarrett

Thanks for the reply; that works perfectly. I just couldn't figure out which function did it.

Again, thanks,
Keith
Topic | Forum


72
kjs222
Re: how to work with _priv_msgs:msg_time in sql

  • 2003/11/13 22:41

  • kjs222

  • Friend of XOOPS

  • Posts: 116

  • Since: 2003/3/1 1


Finally found the answer!!! Thanks for the guidance ackbarr:

Select FROM_UNIXTIME(msg_time);

Note that XOOPS does some extra stuff with it using its functions.. most of these are related to localization. See include/functions.php for details:

function xoops_getUserTimestamp($time, $timeoffset="")
{
    global $xoopsConfig, $xoopsUser;
    if ($timeoffset == '') {
        if ($xoopsUser) {
            $timeoffset = $xoopsUser->getVar("timezone_offset");
        } else {
            $timeoffset = $xoopsConfig['default_TZ'];
        }
    }
    $usertimestamp = intval($time) + (intval($timeoffset) - $xoopsConfig['server_TZ'])*3600;
    return $usertimestamp;
}

from:http://cvs.sourceforge.net/viewcvs.py/*checkout*/xoops/xoops2/include/functions.php?content-type=text%2Fplain&rev=1.64

Hope that helps others!

Keith
Topic | Forum


73
kjs222
how to work with _priv_msgs:msg_time in sql

  • 2003/11/13 18:21

  • kjs222

  • Friend of XOOPS

  • Posts: 116

  • Since: 2003/3/1 1


(Copied from another forum)

Can anyone tell me the SQL statement I could use to select msg_time as an interpretable date from _priv_msgs?

so for instance, something like:

select functionName(msg_time) from _priv_msgs;

Thanks,
keith
Topic | Forum


74
kjs222
how to work with _priv_msgs:msg_time in sql

  • 2003/11/12 22:40

  • kjs222

  • Friend of XOOPS

  • Posts: 116

  • Since: 2003/3/1 1


Can anyone tell me the SQL statement I could use to select msg_time as an interpretable date from _priv_msgs?

so for instance, something like:

select functionName(msg_time) from _priv_msgs;

Thanks,
keith
Topic | Forum


75
kjs222
Project Management... is anyone using something REALLY good?

  • 2003/11/4 12:46

  • kjs222

  • Friend of XOOPS

  • Posts: 116

  • Since: 2003/3/1 1


I've experimented with XTT, I'm not sure about webslave, and there's non-modularized solutions out there... is anyone really happy with their Project Management system?

I need to track bugs in my clients site, and also track categorized working shifts (category, description, time, and possibly billiable/cost).

If anyone is doing this successfully, I'd be interested to hear about it.

Thanks,
Keith
Topic | Forum


76
kjs222
Re: I need Notification Options Help

  • 2003/11/3 18:15

  • kjs222

  • Friend of XOOPS

  • Posts: 116

  • Since: 2003/3/1 1


Thanks a lot,

Keith
Topic | Forum


77
kjs222
Re: I need Notification Options Help

  • 2003/11/3 13:52

  • kjs222

  • Friend of XOOPS

  • Posts: 116

  • Since: 2003/3/1 1


I'm still having this problem (thread other thread), but I'm not sure I'm on Windows. I did your fix, but it didn't work. Is there any way this fix could mess up my site if I'm not on Windows? Mine is broken either way, but I'd hate to get everything "right" and have this be wrong still. Should I un-fix it?

Thanks,
Keith
Topic | Forum


78
kjs222
Re: FW: "Register to Post" Redirect Bug

  • 2003/11/3 13:23

  • kjs222

  • Friend of XOOPS

  • Posts: 116

  • Since: 2003/3/1 1


Nope not using Windows or IIS. Almost certain server is Linux, client is any computer.

I can pinpoint the problem:

a) The "&" that is sent around after a url for URLs such as this message

b) Are sent in the xoops_redirect arguement of the user.php page

c) (I think) are converted to & amp; on user.php form (hidden field)

d) are sent into checkuser.php... and at that point I think something goes wrong.

So, that's all I know. I wish I knew php like I know java, 'cause it doesn't seem like the most difficult problem to solve.

Thanks,
Keith
Topic | Forum


79
kjs222
FW: "Register to Post" Redirect Bug

  • 2003/11/3 3:20

  • kjs222

  • Friend of XOOPS

  • Posts: 116

  • Since: 2003/3/1 1


Just realized this really belongs here:

Thread (from another forum)

Look forward to hearing what the pros have to say!
Topic | Forum


80
kjs222
Re: Notifications Not Working... Where to Start?

  • 2003/11/1 22:45

  • kjs222

  • Friend of XOOPS

  • Posts: 116

  • Since: 2003/3/1 1


More info... I checked in the db;

- all the proper settings seem to be right (newblocks, block_module_links).
- notification block doesn't show up on blocks admin
- notification block DOES show up on groups admin...
- notification block doens't show up on the site (even though I manually set it to visible and set the group permissions to visible).

So... once again, I'd have to conclude I have a problem with my notification files. I think my next step will be waiting for an off-time for my (Live) site, and turning on php debug... is it php debug I need or smarty? Anyways, I won't try that 'till later tonight, if anyone has ideas before then I'd be happy to hear it.

Oh, and just a bit more backround; this is v2.0.3 upgraded from v1... so... I'd guess there's some corruption of file somewhere or something. I've been checking CVS versions of the include/notification*, and I seem to have the most recent. If there's anyone out there who knows the innards of this I'd greatly appreciate a lesson.

Thanks,
Keith
Topic | Forum



TopTop
« 1 ... 5 6 7 (8) 9 10 11 »



[Advanced Search]

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

127 user(s) are online (86 user(s) are browsing Support Forums)

Members: 0

Guests: 127

more...

Donat-O-Meter

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

Latest GitHub Commits