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

[Jean Gazis]

How long will it be between logins for any user? If it is very long, all
content since last login would be impractical anyway - there would be too
much new content for such a feature to be useful. If it isn't long, you can
just delete log entries older than, say, twice the average time between
logins or something like that.

On 5/3/07, Jason Flatt <drupal at oadaeh.net> wrote:
>
> 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/
> --
> [ Drupal support list | http://lists.drupal.org/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20070504/227eae47/attachment-0001.htm