eclipse.org-common/system/evt_log.class.php

<?php
/**
 * *****************************************************************************
 * Copyright (c) 2004,2007,2016 Eclipse Foundation and others.
 * All rights reserved. This program and the accompanying materials
 * are made available under the terms of the Eclipse Public License v1.0
 * which accompanies this distribution, and is available at
 * http://www.eclipse.org/legal/epl-v10.html
 *
 * Contributors:
 * Denis Roy (Eclipse Foundation)- initial API and implementation
 * *****************************************************************************
 */

/**
 * Description: Functions and modules related to a modification log entry
 */

define('MAX_LOG_DAYS', 365);
$dblog = "/home/data/httpd/eclipse-php-classes/system/dbconnection_rw.class.php";

if (is_readable($dblog)) {
  require_once ("/home/data/httpd/eclipse-php-classes/system/dbconnection_rw.class.php");
  define('LOG_TO_DB', TRUE);
}
else {
  define('LOG_TO_DB', FALSE);
}

if (!class_exists ("EvtLog")) {
  class EvtLog {

    var $LogID = 0;
    var $LogTable = "";
    var $PK1 = "";
    var $PK2 = "";
    var $LogAction = "";
    var $uid = "";
    var $EvtDateTime = "";

    function getLogID() {
      return $this->LogID;
    }

    function getLogTable() {
      return $this->LogTable;
    }

    function getPK1() {
      return $this->PK1;
    }

    function getPK2() {
      return $this->PK2;
    }

    function getLogAction() {
      return $this->LogAction;
    }

    function getuid() {
      return $this->PersonID;
    }

    function getEvtDateTime() {
      return $this->EvtDateTime;
    }

    function setLogID($_LogID) {
      $this->LogID = $_LogID;
    }

    function setLogTable($_LogTable) {
      $this->LogTable = $_LogTable;
    }

    function setPK1($_PK1) {
      $this->PK1 = $_PK1;
    }

    function setPK2($_PK2) {
      $this->PK2 = $_PK2;
    }

    function setLogAction($_LogAction) {
      $this->LogAction = $_LogAction;
    }

    function setuid($_uid) {
      $this->uid = $_uid;
    }

    function setEvtDateTime($_EvtDateTime) {
      $this->EvtDateTime = $_EvtDateTime;
    }

    function insertModLog($_uid) {
      $uid = $_uid;
      if (LOG_TO_DB) {
        if ($this->getLogTable() != "" && $this->getPK1() != "" && $this->getLogAction() != "" && $uid != "") {

          $App = new App();
          $dbc = new DBConnectionRW();
          $dbh = $dbc->connect();

          $sql = "INSERT INTO SYS_EvtLog (
              LogID,
              LogTable,
              PK1,
              PK2,
              LogAction,
              uid,
              EvtDateTime)
            VALUES (
              NULL,
              " . $App->returnQuotedString($App->sqlSanitize($this->getLogTable(), $dbh)) . ",
              " . $App->returnQuotedString($App->sqlSanitize($this->getPK1(), $dbh)) . ",
              " . $App->returnQuotedString($App->sqlSanitize($this->getPK2(), $dbh)) . ",
              " . $App->returnQuotedString($App->sqlSanitize($this->getLogAction(), $dbh)) . ",
              " . $App->returnQuotedString($App->sqlSanitize($uid), $dbh) . ",
              NOW()
            )";

          mysql_query($sql, $dbh);
          if (mysql_error() != "") {
            echo "An unknown database error has occurred while logging information.  Please contact the System Administrator.";
            echo mysql_error();
            exit();
          }

          $dbc->disconnect();

          // 1% of each hits will perform clean up
          if (rand(0, 100) < 1) {
            $this->cleanup();
          }
        }
        else {
          echo "An unknown system error has occurred while logging information.  Please contact the System Administrator.";
          exit();
        }
      }
      else {
        // TODO: local logging
      }
    }

    function cleanup() {
      $sql = "DELETE FROM SYS_EvtLog WHERE EvtDateTime < " . MAX_LOG_DAYS;

      $dbc = new DBConnectionRW();
      $dbh = $dbc->connect();
      mysql_query($sql, $dbh);
      $dbc->disconnect();
    }

  }
}