" . translate("Activity Log") . "\n";
echo "« " . translate("Admin") . "
\n";
echo "
\n";
echo "| \n" .
translate("User") . " | \n" .
translate("Calendar") . " | \n" .
translate("Date") . "/" . translate("Time") . " | \n" .
translate("Event") . " | \n" .
translate("Action") . "\n |
\n";
$sql = "SELECT webcal_entry_log.cal_login, webcal_entry_log.cal_user_cal, " .
"webcal_entry_log.cal_type, webcal_entry_log.cal_date, " .
"webcal_entry_log.cal_time, webcal_entry.cal_id, " .
"webcal_entry.cal_name, webcal_entry_log.cal_log_id " .
"FROM webcal_entry_log, webcal_entry " .
"WHERE webcal_entry_log.cal_entry_id = webcal_entry.cal_id ";
$startid = getIntValue ( 'startid', true );
if ( ! empty ( $startid ) )
$sql .= "AND webcal_entry_log.cal_log_id <= $startid ";
$sql .= "ORDER BY webcal_entry_log.cal_log_id DESC";
$res = dbi_query ( $sql );
$nextpage = "";
if ( $res ) {
$num = 0;
while ( $row = dbi_fetch_row ( $res ) ) {
$num++;
if ( $num > $PAGE_SIZE ) {
$nextpage = $row[7];
break;
} else {
echo "| \n" .
$row[0] . " | \n" .
$row[1] . " | \n" .
date_to_str ( $row[3] ) . " " .
display_time ( $row[4] ) . " | \n" .
"" .
htmlspecialchars($row[6]) . " | \n";
if ( $row[2] == $LOG_CREATE )
etranslate("Event created");
else if ( $row[2] == $LOG_APPROVE )
etranslate("Event approved");
else if ( $row[2] == $LOG_REJECT )
etranslate("Event rejected");
else if ( $row[2] == $LOG_UPDATE )
etranslate("Event updated");
else if ( $row[2] == $LOG_DELETE )
etranslate("Event deleted");
else if ( $row[2] == $LOG_NOTIFICATION )
etranslate("Notification sent");
else if ( $row[2] == $LOG_REMINDER )
etranslate("Reminder sent");
else
echo "???";
echo "\n |
\n";
}
}
dbi_free_result ( $res );
} else {
echo translate("Database error") . ": " . dbi_error ();
}
?>
" .
translate("Previous") . " $PAGE_SIZE " .
translate("Events") . "\n";
}
if ( ! empty ( $startid ) ) {
$previd = $startid + $PAGE_SIZE;
$res = dbi_query ( "SELECT MAX(cal_log_id) FROM " .
"webcal_entry_log" );
if ( $res ) {
if ( $row = dbi_fetch_row ( $res ) ) {
if ( $row[0] <= $previd ) {
$prevarg = '';
} else {
$prevarg = "?startid=$previd";
}
//go FORWARD in time
echo "
" .
translate("Next") . " $PAGE_SIZE " .
translate("Events") . "\n";
}
dbi_free_result ( $res );
}
}
?>