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]