Well, yes and no. Yes I need the "12 days since" but no I don't want to present it to the user but actually make the unix timestamp available to the module so that actions can be performed base on that timestamp.<br><br><b><i>AjK <drupal@f2s.com></i></b> wrote:<blockquote class="replbq" style="border-left: 2px solid rgb(16, 16, 255); margin-left: 5px; padding-left: 5px;"> I think what Carl want's is a block that says:<br><br> "Hi foo, it's been 12days since you last visited us".<br><br>Correct me if I'm wrong.<br><br>--Andy<br><br><br>> -----Original Message-----<br>> From: development-bounces@drupal.org<br>> [mailto:development-bounces@drupal.org]On Behalf Of Eric Goldhagen<br>> Sent: 12 February 2007 17:39<br>> To: development@drupal.org<br>> Subject: Re: [development] No last access?<br>><br>><br>> At 9:22 AM -0800 2/12/07, Carl Mc Dade wrote:<br>> >Put simply (SQL Server english query style) I need to get<br>> ><br>>
>"how long it has been since the user last visited"<br>> ><br>> >"the time/date of the users last visit"<br>> ><br>> >made available to a module when the user logs in.<br>><br>> by "last visit" do you mean the last time they<br>> filled in the form and logged in, or the time<br>> they last visited a page?<br>><br>> This is an important difference and one that<br>> people have asked you to clarify so they can<br>> assist. For example my last login to drupal.org<br>> was almost 24 hours ago, the last time I visited<br>> a page while logged in was about 30 seconds ago.<br>> Which do you need available to your<br>> function/module?<br>><br>> --Eric<br>><br>> ><br>> >Carl Mc Dade<br>> >____________________________<br>> >Web Developer<br>> ><br>> ><br>> ><br>> ><br>> ><br>> >----- Original Message ----<br>> >From: AjK <drupal@f2s.com><br>>
>To: development@drupal.org<br>> >Sent: Monday, February 12, 2007 6:10:54 PM<br>> >Subject: Re: [development] No last access?<br>> ><br>> >Carl,<br>> ><br>> >> Nope, That is updated first so their is no way of pulling<br>> >> the old time code before the newer on sets. This is the<br>> >> same problem as the access object. As matter of fact the<br>> >> login ia updated a split second before the access time.<br>> >><br>> >> access = 1171296985<br>> >> login= 1171296984<br>> ><br>> >OK, let's go back to basics.... here's your question again:<br>> ><br>> >> Is there no longer a last access functionality?<br>> >> using the global user and calling $user->access<br>> >> gives the value after the database has been updated.<br>> >> Not the value in the database at the time of login.<br>> >> Ex. the value in the
database table is 0000002.<br>> >> You will not get this value but the value 0000003<br>> >> which is the time of the latest access.<br>> ><br>> >The ->login is updated when a user logs in. It's updated<br>> >just once at the login time. So I'm reading your question<br>> >again and, if it's not ->login that you want you'll have<br>> >to rephrase your question to make sense. I read your<br>> >question as "I want the time the user actually logged in".<br>> ><br>> >Also, you might avoid the "confrontational" type responses<br>> >by wording your question in a non-confrontational manner.<br>> >"Is there no longer a last access functionality?" sounds<br>> >like your accusing some Drupal Ninja Squirrel of stealing<br>> >some of your nuts.<br>> ><br>> >How about posting:-<br>> ><br>> > "I want to find the time for this particular event... blah
blah"<br>> ><br>> >Basically, what I want to know is what do you mean by "last access<br>> >functionality"?<br>> ><br>> >We have<br>> > ->login which is timestamp at login<br>> > ->access which is timestamp at last browser hit<br>> ><br>> >You want<br>> > ->something<br>> ><br>> >Define something.<br>> ><br>> >One point; "Nope, That is updated first so their is no way of pulling the<br>> >old time code before the newer on sets". Erm, just how far back<br>> do you want<br>> >to go? You are experimenting on global $user and so I assume you<br>> logged in<br>> >to test, so I would expect recent values for ->login and ->access<br>> ><br>> >Imagine you are using user foo (eg uid = 1234). If you load that<br>> user object<br>> >what you appear to asking for here is "when did that user login the time<br>>
>before the last login?". That's rather odd functionality to expect of any<br>> >system except those that keep a record of every login time, forever.<br>> >->login is "the last time the user logged in" not "the last time the user<br>> >logged in before last".<br>> ><br>> >So, it seems your question and your responses to date have been a little<br>> >unclear.<br>> ><br>> >regards,<br>> >--Andy<br>> ><br>> >(ps, I'm trying to help ;)<br>> ><br>> ><br>> ><br>> ><br>> >Need Mail bonding?<br>> >Go to the<br>> ><http: //answers.yahoo.com/dir/index;_ylc="X3oDMTFvbGNhMGE3BF9TAzM5<br">NjU0NTEwOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=as<br>k&sid=396546091>Yahoo!<br>>Mail Q&A for<br>><http:
//answers.yahoo.com/dir/index;_ylc="X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTEwOA<br">RfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&sid=3965<br>46091>great<br>>tips from Yahoo! Answers users.<br><br><br>--<br>-------------------------------------------<br>Openflows Community Technology Lab, Inc.<br>New York | Toronto | Montreal | Vienna<br>http://openflows.com<br>People are intelligent. Machines are tools.<br><br><br></http:></http:></drupal@f2s.com></blockquote><br><BR><BR><div> <div><font face="Arial" size="2">Carl Mc Dade<br>____________________________<br>Web Developer<br><br></font></div><div><font face="Arial" size="2"><br> </font></div></div><p> 
<hr size=1>8:00? 8:25? 8:40? <a href="
http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&#news"> Find a flick</a> in no time<br> with the<a href="
http://tools.search.yahoo.com/shortcuts/?fr=oni_on_mail&#news">Yahoo! Search movie showtime shortcut.</a>