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@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/ ]