<?php

class DatabaseList extends Module
{
  var $Dependencies = array('Log', 'User');

  function AddItem($TableId, $Values)
  {
    $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
    $DbRow = $DbResult->fetch_assoc();

    $this->Database->insert(array('Table' => $DbRow['TableName'], 'Database' => $DbRow['Database']), $Values);
    return($this->Database->insert_id);
  }

  function DeleteItem($TableId, $ItemId)
  {
    $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
    $DbRow = $DbResult->fetch_assoc();
    $this->Database->delete(array('Table' => $DbRow['TableName'], 'Database' => $DbRow['Database'], 'Condition' => 'Id='.$ItemId), array('DeletionTime' => 'NOW()'));
  }

  function EditItem($TableId, $Values, $ItemId)
  {
    $DbResult = $this->Database->query('SELECT `TableName`, `Database` FROM `SystemList` WHERE `Id`='.$TableId);
    $DbRow = $DbResult->fetch_assoc();
    $this->DeleteItem($TableId, $ItemId);
    $Values['Id'] = $ItemId;
    $this->Database->replace(array('Table' => $DbRow['TableName'], 'Database' => $DbRow['Database']), $Values);
  }
}

?>