Michael Ed wrote:
> 
> Since I force external users to log in to our
> XtraNet there should be a possibility to identify
> and log sessions. In the new agreement with
> our distributors the *must* read news every day.
> (Else I'll send a techie out to spank them.)
> I scanned the documentation on the project site,
> but found nothing pointing towards this (session
> logging - not spanking!).
>
> Please supply me with a hint.
> 
> We do this on the old XtraNet :
> ...
> WHERE
>     Users.username = '$REMOTE_USER'
> AND
> ...

You could store a 'preference' setting holding the last read date
for the user (midgard.user). The page that displays the news section
should update this. You would then write an offline script that
would

# get spank date as YYYYMMDD
$spankdate=...;

SELECT preference.uid, person.firstname, person.lastname, person.email
FROM preference,person
WHERE preference.uid=person.id
  AND domain='newsreading' AND name='lastread'
  AND value<'$spankdate'

Emile

--
This is The Midgard Project's mailing list. For more information,
please visit the project's web site at http://www.midgard-project.org

To unsubscribe the list, send an empty email message to address
[EMAIL PROTECTED]

Reply via email to