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

[Jason Flatt]

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/