<?php

  function AdminLevel()
  { // BEGIN function AdminLevel
      $Result = -1;
      global $db;
  if (isset($_SESSION['ID'])) {
    if ($_SESSION['ID'] <> '') {
      $ID = $_SESSION['ID'];
      $Name = $_SESSION['User'];
      $Pass = $_SESSION['Pass'];

      $sql = "SELECT * FROM user WHERE ID = '$ID' AND Name = '$Name' AND Pass = '$Pass'";
//      echo $sql;
      $ID = $db->SQLCommand($sql);
      while($Line = mysql_fetch_array($ID)) {
        $Result = $Line['Level'];
  	  }
  	}
  }
  	return $Result;
  } // END function AdminLevel

  function WriteLog($Text, $Type)
  { // BEGIN function Log
  	global $db;
  	
  	$Text = mysql_escape_string($Text);
  	
  	if (isset($_SESSION['ID']))
  	  $User = $_SESSION['ID'];
  	else
  	  $User = 0;

    $IP = $_SERVER['REMOTE_ADDR'];    
  	
    $sql = "SELECT max(ID) FROM log";
    $ID = $db->SQLCommand($sql);
    $Line = mysql_fetch_row($ID);
    $ID = $Line[0]+1;
    
    $sql = "INSERT log VALUE('$ID',now(),'$Text','$Type','$User','$IP')";
    $db->SQLCommand($sql);
  } // END function Log

  function ReadLog($NumberLines, $Type) //0 = všechno
  { // BEGIN function ReadLog  	
	global $db;
	global $Color;

  if ($Type <> '0')
    $sql = "SELECT * FROM log WHERE Type = $Type order by 1 DESC LIMIT $NumberLines";
  else
    $sql = "SELECT * FROM log order by 1 DESC LIMIT $NumberLines";
    $ID = $db->SQLCommand($sql);
    
    while ($Line = mysql_fetch_array($ID)) {
    	echo '<span style="color: '.$Color[$Line['Type']].'">'.$Line['Date'].': '.strip_tags($Line['Text']).' ('.$Line['UserID'].')</span><br />';
    }
  } // END function ReadLog

  function TestLicence($security)
  { // BEGIN function TestLicence
    global $AdminLevel;
    global $NotLicence;
    if ($AdminLevel < $security) { //level $security
      echo $NotLicence;
      include 'FormLogin.php';    
      ShowFooter();
      die();
    }   	
  } // END function TestLicence

  function IconDownload($Name)
  { // BEGIN function Icon
    global $Icons;
    
    if (isset($Icons[$Name]))
	    return $Icons[$Name];
	  else {
	    WriteLog('Neznámý formát souboru: '.$Name,'5');
	    return $Icons['Unknow'];
	  }
  } // END function Icon

  function JavaQuestionDel()
  { // BEGIN function JavaQuestionDel
  	return 'onclick="if (window.confirm(\'Opravdu smazat?\')) {} else {
return false;
}"';
  } // END function JavaQuestionDel

  //funkce na vypsání souborů podle ID složky
  function WriteFiles($Dir)
  { // BEGIN function WriteFiles
    global $db;
    global $Icons;
    global $UploadDirDownload;

    echo '<DL>';
        $sql = "SELECT * FROM downloadfile WHERE Dir = '$Dir' order by 2 DESC";
        $IDFiles = $db->SQLCommand($sql);
        while($LineFile = mysql_fetch_array($IDFiles)) {
          $Type = $LineFile['Type'];
          echo '<DD><a href="/'.$UploadDirDownload.'/'.$LineFile['FileName'].'" title="'.$LineFile['Description'].' ('.$LineFile['Date'].')">'.IconDownload($Type).' '.$LineFile['Name'].'</a>';
        }
    echo '</DL>';
  	
  } // END function WriteFiles



?>








