February 2007 - Development - lists.drupal.org

Re: [development] No last access?
by Carl Mc Dade 12 Feb '07

12 Feb '07

That sounds like the most logical explaination so far. Trying it now. Carl Mc Dade ____________________________ Web Developer ----- Original Message ---- From: AjK <drupal(a)f2s.com> To: development(a)drupal.org Sent: Monday, February 12, 2007 4:57:43 PM Subject: Re: [development] No last access? > Is there no longer a last access functionality? > using the global user and calling $user->access > gives the value after the database has been updated. > Not the value in the database at the time of login. > Ex. the value in the database table is 0000002. > You will not get this value but the value 0000003 > which is the time of the latest access. The above was your original question..... > No luck with that. Time code shown in > database = 1171293946 timecode called by > using the following <snip> > print $account-access; > 1171294179 Erm, am I missing something here or should you not be doing:- print $account->login; "login" holds the timestamp of the last login, "access" holds the timestamp of the last browser hit for the user. This is from user.module:- // Update the user table timestamp noting user has logged in. db_query("UPDATE {users} SET login = %d WHERE uid = %d", time(), $user->uid); and this is from session.inc:- db_query("UPDATE {users} SET access = %d WHERE uid = %d", time(), $user->uid); regards, --Andy ____________________________________________________________________________________ The fish are biting. Get more visitors on your site using Yahoo! Search Marketing. http://searchmarketing.yahoo.com/arp/sponsoredsearch_v2.php

1 0

Re: [development] No last access?
by Carl Mc Dade 12 Feb '07

12 Feb '07

No luck with that. Time code shown in database = 1171293946 timecode called by using the following global $user; $account = user_load(array((is_numeric($user->uid) ? 'uid' : 'name') => $user->uid, 'status' => 1)); print $account-access; 1171294179 You see the trick here is that to see the printed time you have to login. Since there is no last login stored the $object->access pulls thle only thing available. What I have done in my module is store the time in another field so I have lastaccess and newaccess. Newacess is being constanly updated by the user object. But lastaccess only accepts a value from newaccess. When newaccess is updated the old value goes to lastaccess which is what I want to be able to use. I could not find anything in the present core that does this. Carl Mc Dade ____________________________ Web Developer ----- Original Message ---- From: John VanDyk <jvandyk(a)iastate.edu> To: development(a)drupal.org Sent: Monday, February 12, 2007 3:55:48 PM Subject: Re: [development] No last access? http://drupal.org/node/91786 "user_load() clarification" >I can imagine the the global user might not have >the info in it... but if you do >user_load(array('uid' => $user->uid)); // <-- >$user is global user, you might get a hold of >it. Just shooting from the hip. > >Moshe Weitzman wrote: >>Carl Mc Dade wrote: >>>Well, I spent sunday evening being sick and >>>looking over last access functionality >>>historically as per Bérs advice. I looked back >>>to version 4.4 to 4.7.4. a found surprisingly >>>that Drupal has never really had a last access >>>functionality. It has had calculation code to >>>gather such information but nothing >>>definative. Strangely enough there has not >>>been too much call for this information so no >>>one has noticed. >> >>This is all nonsense. The user admin page shows >>you last access for each user. And that number >>is accurate, so we must be collecting that info >>somewhere. Furthermore, access is easily >>available for all modules in the standard $user >>object. >> >>Fire up your debugger and you will see the >>writing of this infomation in sess_write(). >> > > >-- >* * * * * >Lullabot's First Ever Advanced Workshops Are Here! >Drupal API & Module Building - Advanced Drupal Themeing >April 9th-13th - Providence, RI >Early Bird Discounts Available Now >http://www.lullabot.com/training >* * * * * ____________________________________________________________________________________ Don't pick lemons. See all the new 2007 cars at Yahoo! Autos. http://autos.yahoo.com/new_cars.html

2 1

Re: [development] No last access?
by Carl Mc Dade 12 Feb '07

12 Feb '07

I will try again using user_load() and comeback. Carl Mc Dade ____________________________ Web Developer ----- Original Message ---- From: John VanDyk <jvandyk(a)iastate.edu> To: development(a)drupal.org Sent: Monday, February 12, 2007 3:55:48 PM Subject: Re: [development] No last access? http://drupal.org/node/91786 "user_load() clarification" >I can imagine the the global user might not have >the info in it... but if you do >user_load(array('uid' => $user->uid)); // <-- >$user is global user, you might get a hold of >it. Just shooting from the hip. > >Moshe Weitzman wrote: >>Carl Mc Dade wrote: >>>Well, I spent sunday evening being sick and >>>looking over last access functionality >>>historically as per Bérs advice. I looked back >>>to version 4.4 to 4.7.4. a found surprisingly >>>that Drupal has never really had a last access >>>functionality. It has had calculation code to >>>gather such information but nothing >>>definative. Strangely enough there has not >>>been too much call for this information so no >>>one has noticed. >> >>This is all nonsense. The user admin page shows >>you last access for each user. And that number >>is accurate, so we must be collecting that info >>somewhere. Furthermore, access is easily >>available for all modules in the standard $user >>object. >> >>Fire up your debugger and you will see the >>writing of this infomation in sess_write(). >> > > >-- >* * * * * >Lullabot's First Ever Advanced Workshops Are Here! >Drupal API & Module Building - Advanced Drupal Themeing >April 9th-13th - Providence, RI >Early Bird Discounts Available Now >http://www.lullabot.com/training >* * * * * ____________________________________________________________________________________ Get your own web address. Have a HUGE year through Yahoo! Small Business. http://smallbusiness.yahoo.com/domains/?p=BESTDEAL

1 0

Re: [development] No last access?
by Carl Mc Dade 12 Feb '07

12 Feb '07

I have a better idea. You fire up your debugger and show me. Every instance I have found is based on code similar to this: $user->access ? t('%time ago', array('%time' => format_interval(time() - $account->access))) : t('never') Tracing $user->access back leads to the same conclusion as I came to in the beginning. The $user-access is being loaded and updated before it is presented. To give another simple example I first looked at the time codes in phpmyadmin. I have a simple php snippet that just sets the $user->access time, time() and login in time to print to screen. I expected to see the differences. which I did. So I thought things were working. But when I refreshed the phpmyadmin browser it showed that calling the snippet had actually updated the database date. So the access time shows the time that the snippet was run. Carl Mc Dade ____________________________ Web Developer ----- Original Message ---- From: Moshe Weitzman <weitzman(a)tejasa.com> To: development(a)drupal.org Sent: Monday, February 12, 2007 3:32:12 PM Subject: Re: [development] No last access? Carl Mc Dade wrote: > Well, I spent sunday evening being sick and looking over last access > functionality historically as per Bérs advice. I looked back to version > 4.4 to 4.7.4. a found surprisingly that Drupal has never really had a > last access functionality. It has had calculation code to gather such > information but nothing definative. Strangely enough there has not been > too much call for this information so no one has noticed. This is all nonsense. The user admin page shows you last access for each user. And that number is accurate, so we must be collecting that info somewhere. Furthermore, access is easily available for all modules in the standard $user object. Fire up your debugger and you will see the writing of this infomation in sess_write(). ____________________________________________________________________________________ Now that's room service! Choose from over 150,000 hotels in 45,000 destinations on Yahoo! Travel to find your fit. http://farechase.yahoo.com/promo-generic-14795097

1 0

Re: [development] No last access?
by Carl Mc Dade 12 Feb '07

12 Feb '07

Well, I spent sunday evening being sick and looking over last access functionality historically as per Bérs advice. I looked back to version 4.4 to 4.7.4. a found surprisingly that Drupal has never really had a last access functionality. It has had calculation code to gather such information but nothing definative. Strangely enough there has not been too much call for this information so no one has noticed. The reason that I was getting a last access previously is because the re was another (ws_auth) module loading the database. This module was only on my 4.7.4 test site not on later versions. So what I did was create a last access routine based on hook_user to satisfy my needs. I will post a feature request on this as there may be a greater need in the future for this to be a part of the API. Carl Mc Dade ____________________________ Web Developer ----- Original Message ---- From: Carl Mc Dade <carl_mcdade(a)yahoo.com> To: development(a)drupal.org Sent: Sunday, February 11, 2007 1:33:27 PM Subject: Re: [development] No last access? Yep, I am digging further. It looks like the order of process has changed. I tried to use hook_user to place my own timestamp in the database. This did not work. It seems that all user functions are after update. I will comeback with more information after more study of the behaviour. Carl Mc Dade ____________________________ Web Developer ----- Original Message ---- From: Bèr Kessels <ber(a)webschuur.com> To: development(a)drupal.org Sent: Sunday, February 11, 2007 12:22:59 PM Subject: Re: [development] No last access? Op zondag 11 februari 2007 10:36, schreef Carl Mc Dade: > This does not seem to be a problem in 4.7.4 but in 4.7.5+ and 5.1 calling > user_load() functions $user->access and $user->login give the updated > values and not the actual value in the database. There were some security related changes made to the user _insert and _update. Maybe thye have to do with this? I suggest you browse through the cvs logs of user module to isolate the cahnges that cause this behaviour. Once identified, and detailed, I am sure there are people willing to help you solve the issue. It hmight have been an intentional change, it might have been a new bug introduced by one of the security fixes. Bèr -- Drupal, Ruby on Rails and Joomla! development: webschuur.com | Drupal hosting: www.sympal.nl Don't get soaked. Take a quick peak at the forecast with theYahoo! Search weather shortcut. ____________________________________________________________________________________ Cheap talk? Check out Yahoo! Messenger's low PC-to-Phone call rates. http://voice.yahoo.com

4 3

Re: [development] No last access?
by Carl Mc Dade 12 Feb '07

12 Feb '07

Dear, explicatives deleted (Karoly Negyesi) Don't step on my thread with your venemous attitude. If you can't help or have anything nice to say then go back to sleep. I asked a simple question in the right area. If you want to go at me then you are welcome to send as much off list mail as you like. Don't use this list as your public soap box. Carl Mc Dade ____________________________ Web Developer ----- Original Message ---- From: Karoly Negyesi <karoly(a)negyesi.net> To: development(a)drupal.org Sent: Sunday, February 11, 2007 10:13:12 AM Subject: Re: [development] No last access? > Is there no longer a last access functionality? using the global user and calling $user->access gives the value after the database has been updated. Not the value in the database at the time of login. Ex. the value in the database table is 0000002. You will not get this value but the value 0000003 which is the time of the latest access. Carl Mc Dade Dear Mr. Mc Dade, Thanks for filing a detailed report -- which included the used Drupal version, whether the user is anonymous or not and all other details that you might find relevant -- in the issue queue as it's proper. Of course, none the less can expected from a long time Drupal contributor whose contributions include one of the most heated threads on drupal.org and some extremely clever use of drupal.org's high Google page rank through the user profile. Kind regards, Karoly Negyesi ____________________________________________________________________________________ Expecting? Get great news right away with email Auto-Check. Try the Yahoo! Mail Beta. http://advision.webevents.yahoo.com/mailbeta/newmail_tools.html

2 1

Release critical bugs for February 11, 2007
by drupal-devel＠drupal.org 11 Feb '07

11 Feb '07

Article / bug reports Multiple Pages Do Not Work age: 1 week 4 days url: http://drupal.org/node/114595 4.7 Beta/ CVS Errors assigned: msameer age: 46 weeks 2 days url: http://drupal.org/node/55533 CVS management/tracker / feature requests enforce sequential release tags in xcvs-taginfo assigned: dww age: 15 weeks 5 days url: http://drupal.org/node/90968 Event / bug reports Event module needs to know about the new DST rules starting on March 11, 2007 age: 5 weeks 2 days url: http://drupal.org/node/107011 [php5, clone] end-start-ongoing attribute does not ripple through age: 19 weeks 5 days url: http://drupal.org/node/85972 Major timezone bug in event module age: 25 weeks 6 days url: http://drupal.org/node/78572 event_start not being set age: 37 weeks 2 days url: http://drupal.org/node/65609 Fatal Error After activating "Browse Scheduled Events" in modules age: 40 weeks 2 days url: http://drupal.org/node/61920 INSTALL.txt incorrect age: 42 weeks 6 days url: http://drupal.org/node/59019 event calendars off by day/not respecting timezones - fix? age: 45 weeks 5 days url: http://drupal.org/node/56189 Flexinode generates an error age: 46 weeks 4 days url: http://drupal.org/node/55135 Calendar subscribing not working age: 47 weeks 4 days url: http://drupal.org/node/54036 Problem Selecting Event by Type age: 48 weeks 4 days url: http://drupal.org/node/52883 Event start and end times not getting saved in database age: 1 year 8 weeks url: http://drupal.org/node/41300 Issues with list view for events age: 1 year 9 weeks url: http://drupal.org/node/39943 Database error keeps popping up age: 1 year 10 weeks url: http://drupal.org/node/39396 Date problem on calendar, off by GMT offset age: 1 year 10 weeks url: http://drupal.org/node/39193 Events module bugs adding and changeing events age: 1 year 10 weeks url: http://drupal.org/node/39016 gmdate() warnings on windows install assigned: Omar Abdel-Wahab age: 1 year 32 weeks url: http://drupal.org/node/26140 Event / feature requests Javascript calendar control and all day events age: 38 weeks 1 day url: http://drupal.org/node/64490 Event / support requests How to display small calendar on homepage? assigned: dada78 age: 3 weeks 5 days url: http://drupal.org/node/109630 Help!!! Site Broken!! age: 5 weeks 1 day url: http://drupal.org/node/107239 Blank Page After Submit age: 43 weeks 20 hours url: http://drupal.org/node/58918 Can't Administer Event Module age: 1 year 5 weeks url: http://drupal.org/node/43509 displaying event start info in flexinode tabular view? age: 1 year 18 weeks url: http://drupal.org/node/33019 Event block missing content of many fields age: 1 year 20 weeks url: http://drupal.org/node/31532 Gallery / bug reports IE error using embed not error with none-embed... when navigation block on right age: 40 weeks 1 day url: http://drupal.org/node/62119 Gallery / support requests Gallery2 grants access without proper permission age: 6 weeks 4 days url: http://drupal.org/node/105418 Glossary / feature requests po files and other language support age: 1 year 2 weeks url: http://drupal.org/node/46313 Goofy / feature requests Goofy Forum UI age: 1 year 19 weeks url: http://drupal.org/node/32294 Listhandler / bug reports user lookup on name only assigned: zeroj age: 45 weeks 8 hours url: http://drupal.org/node/56936 Link to mailhandler does not use l() function age: 1 year 4 weeks url: http://drupal.org/node/44599 Listhandler caused error in "comment.module on line 996" ? age: 1 year 14 weeks url: http://drupal.org/node/36244 Listhandler 4.6.0 fails to send emails at all age: 1 year 29 weeks url: http://drupal.org/node/27095 Listhandler / tasks Correct/Complete Documentation age: 1 year 15 weeks url: http://drupal.org/node/34909 Mailhandler / bug reports mailhandler requiring mailbox domain field despite using folder view age: 1 week 1 day url: http://drupal.org/node/115472 Mailhandler / support requests Creating a page using mailhandler age: 34 weeks 4 days url: http://drupal.org/node/68947 Mail Body not downloaded age: 1 year 5 weeks url: http://drupal.org/node/43374 Members / bug reports foreach() assigned: neablo age: 1 year 6 weeks url: http://drupal.org/node/42350 Meta tags / bug reports Internal HTTP 500 Server Error age: 2 days 17 hours url: http://drupal.org/node/117329 Database structure age: 1 week 6 days url: http://drupal.org/node/113833 can't use php functions in body of nodes assigned: Robrecht Jacques age: 25 weeks 2 days url: http://drupal.org/node/79315 Meta tags / feature requests Enable nodewords for node type? age: 1 year 17 hours url: http://drupal.org/node/48869 Node Aggregator / bug reports nodes are being created with no body age: 1 year 9 weeks url: http://drupal.org/node/40373 missing promote column assigned: Bèr Kessels age: 1 year 11 weeks url: http://drupal.org/node/38836 Naming issues with files and DB tables age: 1 year 16 weeks url: http://drupal.org/node/34298 RSS "no element found at line 1" age: 1 year 32 weeks url: http://drupal.org/node/26185 Outdated help texts age: 2 years 27 weeks url: http://drupal.org/node/9692 Import doesn't like XML/RSS feeds with no Title element age: 2 years 36 weeks url: http://drupal.org/node/8128 Node Aggregator / tasks move XML-parser into an inclde file. age: 1 year 33 weeks url: http://drupal.org/node/25439 Path / bug reports aliases that start with same string as other aliases age: 2 weeks 5 days url: http://drupal.org/node/111775 Login as an alias gets cached age: 1 year 20 weeks url: http://drupal.org/node/31699 Path / feature requests Admin created list of URL's to ignore age: 3 weeks 23 hours url: http://drupal.org/node/111171 Pdfview / bug reports custom fields not displayed age: 3 weeks 7 hours url: http://drupal.org/node/111340 Poormanscron / bug reports cron somehow interrupts MySql connection age: 4 weeks 2 days url: http://drupal.org/node/108676 Privatemsg / bug reports Impossible to clean-up database after uninstalling privatemsg age: 4 weeks 9 hours url: http://drupal.org/node/109206 When enableing the module, Drupal tries to update instead of install age: 19 weeks 21 hours url: http://drupal.org/node/86830 privatemsg module: - database error - incompatibility with relationship module age: 1 year 18 hours url: http://drupal.org/node/48866 Remindme / bug reports Argument #1 is not an array age: 34 weeks 2 days url: http://drupal.org/node/69286 Cron job creates SQL error age: 36 weeks 5 days url: http://drupal.org/node/66202 Subscriptions / bug reports Unpublished nodes and comments age: 3 weeks 5 days url: http://drupal.org/node/109755 Subscribe/Unsubscribe does not work on node form update age: 4 weeks 5 days url: http://drupal.org/node/107907 Subscriptions remain active when access control maintain subscriptions is disabled age: 18 weeks 3 days url: http://drupal.org/node/87625 Taxonomy dhtml / bug reports IE 7 javascript errors on the page that display the categories age: 10 weeks 2 hours url: http://drupal.org/node/101100 Disabling Teasers (Trimmed Posts) Not working when set to Unlimited assigned: samdeskin age: 15 weeks 3 days url: http://drupal.org/node/91299 doesn't work with taxonomy_access? age: 20 weeks 3 days url: http://drupal.org/node/85355 Error on Page with Internet Explorer 6 age: 34 weeks 4 days url: http://drupal.org/node/68906 Taxonomy DHTML's cache ignores user privileges age: 38 weeks 1 day url: http://drupal.org/node/64532 Does not work correctly in Internet Explorer age: 1 year 18 weeks url: http://drupal.org/node/33354 javascrip downloads square.gif for every category age: 1 year 51 weeks url: http://drupal.org/node/17366 Taxonomy dhtml / feature requests A unique page for each category group? age: 1 year 16 weeks url: http://drupal.org/node/34610 Taxonomy navigation / bug reports Taxonomy links only work for the first line of links assigned: PierreFWalter age: 50 weeks 2 days url: http://drupal.org/node/51149 TrackBack / bug reports install script does not put curly braces around table name age: 10 weeks 3 days url: http://drupal.org/node/100634 Sends trackbacks for unpublished nodes assigned: ankur age: 2 years 2 weeks url: http://drupal.org/node/16239 User experience / bug reports password keeps getting lost for logins requiring me to request a new password age: 1 week 2 days url: http://drupal.org/node/115055 Verification Active assigned: maverickvarun age: 9 weeks 5 days url: http://drupal.org/node/101384 User experience / support requests 403 Forbidden error age: 6 days 3 hours url: http://drupal.org/node/116090 Wiki / bug reports the wiki module can't work with HTML age: 1 year 1 week url: http://drupal.org/node/47124

1 0

Re: [development] No last access?
by Carl Mc Dade 11 Feb '07

11 Feb '07

Yep, I am digging further. It looks like the order of process has changed. I tried to use hook_user to place my own timestamp in the database. This did not work. It seems that all user functions are after update. I will comeback with more information after more study of the behaviour. Carl Mc Dade ____________________________ Web Developer ----- Original Message ---- From: Bèr Kessels <ber(a)webschuur.com> To: development(a)drupal.org Sent: Sunday, February 11, 2007 12:22:59 PM Subject: Re: [development] No last access? Op zondag 11 februari 2007 10:36, schreef Carl Mc Dade: > This does not seem to be a problem in 4.7.4 but in 4.7.5+ and 5.1 calling > user_load() functions $user->access and $user->login give the updated > values and not the actual value in the database. There were some security related changes made to the user _insert and _update. Maybe thye have to do with this? I suggest you browse through the cvs logs of user module to isolate the cahnges that cause this behaviour. Once identified, and detailed, I am sure there are people willing to help you solve the issue. It hmight have been an intentional change, it might have been a new bug introduced by one of the security fixes. Bèr -- Drupal, Ruby on Rails and Joomla! development: webschuur.com | Drupal hosting: www.sympal.nl ____________________________________________________________________________________ Any questions? Get answers on any topic at www.Answers.yahoo.com. Try it now.

1 0

Re: [development] No last access?
by Carl Mc Dade 11 Feb '07

11 Feb '07

This does not seem to be a problem in 4.7.4 but in 4.7.5+ and 5.1 calling user_load() functions $user->access and $user->login give the updated values and not the actual value in the database. Carl Mc Dade ____________________________ Web Developer ----- Original Message ---- From: Carl Mc Dade <carl_mcdade(a)yahoo.com> To: development(a)drupal.org Sent: Sunday, February 11, 2007 9:43:37 AM Subject: [development] No last access? Is there no longer a last access functionality? using the global user and calling $user->access gives the value after the database has been updated. Not the value in the database at the time of login. Ex. the value in the database table is 0000002. You will not get this value but the value 0000003 which is the time of the latest access. Carl Mc Dade ____________________________ Web Developer It's here! Your new message! Get new email alerts with the free Yahoo! Toolbar. ____________________________________________________________________________________ We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. http://tv.yahoo.com/collections/265

2 1

Broken links to source pages at Drupal api's documentation
by Zohar Stolar 11 Feb '07

11 Feb '07

All source pages on http://api.drupal.org (links to see source code) show a "Page not found" message. There's an unanswered issue about it: http://drupal.org/node/111718 I have a feeling the question was already answered, or at least asked, but I didn't find any record of (beside that issue above). It seems to me that the problem started with the update to D5, but I'm not sure about it. Does anyone know what happened to those links? Zohar

1 0