source: database_list.php@ 19

<?php

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

  function AddItem($TableName, $Values)
  {
    $Values['Author'] = $this->System->Modules['User']->User['ItemId'];
    $Values['CreationTime'] = 'NOW()';
    $Values['ValidTimeFrom'] = 'NOW()';
    $DbResult = $this->Database->select($TableName, 'MAX(ItemId)');
    $DbRow = $DbResult->fetch_row();
    $AutoincrementId = $DbRow[0];
    $Values['ItemId'] = $AutoincrementId + 1; 
    $this->Database->insert($TableName, $Values);
    return($Values['ItemId']);
  }

  function DeleteItem($TableName, $Id)
  {
    $DbResult = $this->Database->select($TableName, 'Id', 'ItemId='.$Id.' ORDER BY Id DESC LIMIT 1');
    $DbRow = $DbResult->fetch_assoc();
    $this->Database->update($TableName, 'Id='.$DbRow['Id'], array('DeletionTime' => 'NOW()'));
  }

  function EditItem($TableName, $Values, $Id)
  {
    $this->DeleteItem($TableName, $Id);
    $Values['ItemId'] = $Id;
    $Values['Author'] = $this->System->Modules['User']->User['ItemId'];
    $Values['CreationTime'] = 'NOW()';
    $Values['ValidTimeFrom'] = 'NOW()';
    $this->Database->insert($TableName, $Values);
  }
}

?>