<?php

class ListSystemList
{
  function OnAdd($Parameters)
  {
    global $Database;

    $Database->query('CREATE TABLE IF NOT EXISTS `'.$Parameters['TableName'].'` (
    `Id` int(11) NOT NULL auto_increment,
    PRIMARY KEY  (`Id`)
    ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci;');
    //echo($Database->LastQuery);
  }

  function ListSystemListOnEdit($Parameters)
  {
    global $Database;

    $DbResult = $Database->query('SELECT `TableName` FROM `'.$Parameters['ListTableName'].'` WHERE Id='.$Parameters['Id']);
    $DbRow = $DbResult->fetch_assoc();
    if($DbRow['TableName'] != $Parameters['TableName'])
      $Database->query('RENAME TABLE `'.$DbRow['TableName'].'` TO `'.$Parameters['TableName'].'`');
  }

  function ApplySQLToItems($SQL)
  {
    global $Database;

    $DbResult = $Database->query('SELECT `TableName` FROM `SystemList`');
    while($DbRow = $DbResult->fetch_assoc())
    {
      $Database->query(str_replace('`TableName`', '`'.$DbRow['TableName'].'`', $SQL));
    }
  }
}

?>