library/log.inc

   1 <?php
   2         require_once("{$GLOBALS['srcdir']}/sql.inc");
   3
   4         function newEvent($event,$user, $groupname, $comments="")
   5         {
   6                 $adodb = $GLOBALS['adodb']['db'];
   7                 if($event == ("login" || "logout" || "backup" || "view" || "auth" || "upload"))
   8                 {
   9                         $sql = "insert into log (date, event, user, groupname, comments) values (NOW(), " . $adodb->qstr($event) . "," . $adodb->qstr($user) . "," . $adodb->qstr($groupname) . "," .$adodb->qstr($comments) . ")";
  10                         return sqlInsertClean($sql);
  11                 }
  12
  13                 else
  14                 {
  15                         return false;
  16                 }
  17         }
  18
  19 function        getEventByDate($date, $cols = "*")
  20         {
  21                 $res = sqlStatement("select $cols from log where date like '%$date%' order by date DESC");
  22
  23                 for($iter=0; $row=sqlFetchArray($res); $iter++)
  24                 {
  25                         $all[$iter] = $row;
  26                 }
  27
  28                 return $all;
  29         }
  30
  31
  32
  33
  34
  35
  36
  37 ?>