Re: [support] how to get the list of new nodes since last login?

3 May 2007


      On Thursday May 3 2007 10:23 am, Haisam K. Ido wrote:
...
uid=$uid
$sql = "SELECT node.uid,watchdog.timestamp, node.changed FROM
`watchdog`,node where watchdog.message like \'Session closed for%\' AND
node.changed >= watchdog.timestamp and node.uid=watchdog.uid and
node.uid=$uid";
I believe that the above query returns all nodes which have changed
since $uid's last login.
So I guess you have your site configured to never delete any log entries?

admin/settings/error-reporting

-- 
Jason Flatt
http://www.oadaeh.net/
Father of Six:  http://www.flattfamily.com/ (Joseph, 13; Cramer, 11; Travis, 
9; Angela; Harry, 5; and William, 12:04 am, 12-29-2005)
Linux User:     http://www.kubuntu.org/
Drupal Fanatic: http://drupal.org/