<?  
class Modules_edit
{
      public $tmpl;
      public $select_default = null;
      public $on_change = "";      
      function __construct($tmpl)
      {
            $this->tmpl = $tmpl;
            if(isset($_GET["id_m"]))
                  $this->tmpl->set_var('cms_back', "location.href='modules.php?".mb_ereg_replace("&amp;","&",path_from_get(array("idd","action")))."';");
            else if(isset($_GET["str"]))
                  $this->tmpl->set_var('cms_back', "location.href='modules.php?str=".$_GET["str"]."';");
            else
                  $this->tmpl->set_var('cms_back', "location.href='modules.php?id=".$_GET["id"]."';");
      }
      
      function add_row_photo($label, $name, $value, $path, $type = 'modul_file')
      {
            $this->tmpl->set_var('row_lab', $name);
            $this->tmpl->set_var('row_name', $label);
            $this->tmpl->set_var('a_target', "");      
      
            if(isset($value))
            {
                  $this->tmpl->set_var('a_href',"javascript:photo_display('war_foto', '".$path.$value."');void(0);");            
                  $this->tmpl->set_var('a_value', "<img src=\"".$path.$value."\" style=\"max-width:100px;\" alt=\"\"/>");
                  $this->tmpl->parse('row_val','modul_a');
            }
            else
                  $this->tmpl->set_var('row_val', "");
            $this->tmpl->parse('tab_rows_',$type,true);
      } 
                  
      function add_row_file($label, $name, $value, $path, $type = 'modul_file')
      {
            $this->tmpl->set_var('row_lab', $name);
            $this->tmpl->set_var('row_name', $label);
            $this->tmpl->set_var('a_target', "");      

            if(isset($value))
            {
                  $this->tmpl->set_var('a_href', $path.$value);            
                  $this->tmpl->set_var('a_value',$value);
                  $this->tmpl->parse('row_val','modul_a');
            }
            else
                  $this->tmpl->set_var('row_val', "");
            $this->tmpl->parse('tab_rows_',$type,true);
      }    

      function add_row_check($label, $name, $value, $ro = null)
      {
            $this->tmpl->set_var('row_lab', $name);
            $this->tmpl->set_var('row_name', $label);
            if($value == "1")
                  $this->tmpl->set_var('inp_checked', " checked=\"true\"");
            else
                  $this->tmpl->set_var('inp_checked', "");
            
            $this->tmpl->parse('tab_rows_','modul_check',true);
      }
               
      function add_row_iframe($label, $idek_r, $id_str)
      {
            $this->tmpl->set_var('row_name', $label);
            $this->tmpl->set_var('inp_str', $id_str);
            $this->tmpl->set_var('inp_id_m', $_GET["id"]."&amp;id_lang=".$_GET["id_lang"]);
            $this->tmpl->set_var('inp_idd_m', $idek_r);
            $db2 = new DB__("select template_menu.id_template from template_menu 
            where template_menu.id_menu='".$_GET["id"]."'");
            if($db2->next_record())
            {
                  $this->tmpl->set_var('inp_id_template', $db2->f('id_template'));
                  $this->tmpl->parse('tab_rows_','modul_iframe',true);
            }
      }
      
      function add_row_select($label, $name, $value, $sql)
      {
            $this->tmpl->set_var('row_lab', $name);
            $this->tmpl->set_var('row_name',$label);
            $this->tmpl->set_var('inp_onchange', $this->on_change);
            $this->tmpl->set_var('inp_options', "");

            $db2 = new DB__($sql);
            while($db2->next_record())
            {
                  if($db2->f('id') == $value || (isset($this->select_default) && !isset($_GET["idd"]) && ($db2->f('id') == $this->select_default)))      
                        $this->tmpl->set_var('inp_selected', " selected=\"true\"");
                  else
                        $this->tmpl->set_var('inp_selected', "");
                  $this->tmpl->set_var('row_val', $db2->f('id'));
                  $this->tmpl->set_var('inp_text', $db2->f('name'));
                  $this->tmpl->parse('inp_options','modul_select_option',true);
            }
            $this->tmpl->parse('tab_rows_','modul_select',true);
      }
      
/*
      $lab = "id_category[]";
      $sql1 = "select category_multi_lang.*, institution_multi_temp.id_institution from category_multi_lang 
      left join institution_multi_temp on institution_multi_temp.id_category=category_multi_lang.id and institution_multi_temp.id_institution='".$_GET["idd"]."'
      where category_multi_lang.id_menu='99' and id_lang='".ID_LANG_MAIN."' and category_multi_lang.id not in (select id_category from institution_multi_temp where id_institution!='".$_GET["idd"]."')
      order by institution_multi_temp.id_institution desc, category_multi_lang.name";      
      $sql2 = "select category_multi_lang.* from category_multi_lang 
      where category_multi_lang.id_menu='99' and id_lang='".ID_LANG_MAIN."'
      order by category_multi_lang.name";
      $me->add_row_select_multi($lab, "Kategoria", "id_institution", $sql1, $sql2);

*/      
      
      function add_row_select_multi($label, $name, $value, $sql1, $sql2, $ro = null)
      {
            if(isset($ro) || isset($this->ro))
                  $this->tmpl->set_var('id_inp', " disabled=\"disabled\"");
            else
                  $this->tmpl->set_var('id_inp', "");
            
            $this->tmpl->set_var('row_lab', $name);
            $this->tmpl->set_var('row_name',$label);
            $this->tmpl->set_var('inp_size', "8");
            $this->tmpl->set_var('inp_onchange', "");
            $this->tmpl->set_var('inp_options', "");

            if(isset($_GET["idd"]))
                  $db2 = new DB__($sql1);
            else
                  $db2 = new DB__($sql2);
            
            while($db2->next_record())
            {
                  if($db2->f($value))      
                        $this->tmpl->set_var('inp_selected', " selected=\"true\"");
                  else
                        $this->tmpl->set_var('inp_selected', "");
                  $this->tmpl->set_var('row_val', $db2->f('id'));
                  $this->tmpl->set_var('inp_text', $db2->f('name'));
                  $this->tmpl->parse('inp_options','modul_select_option',true);
            }
            $this->tmpl->parse('tab_rows_','modul_select_multi',true);
      }

      function add_row_select_refresh($label, $name, $value, $sql, $id_refresh)
      {
            $this->tmpl->set_var('row_lab', $name);
            $this->tmpl->set_var('row_name',$label);
            $this->tmpl->set_var('inp_onchange', "");
            $this->tmpl->set_var('inp_options', "");

            $db2 = new DB__($sql);
            while($db2->next_record())
            {
                  if($db2->f('id') == $value || (isset($this->select_default) && !isset($_GET["idd"]) && ($db2->f('id') == $this->select_default)))      
                        $this->tmpl->set_var('inp_selected', " selected=\"true\"");
                  else
                        $this->tmpl->set_var('inp_selected', "");
                  $this->tmpl->set_var('row_val', $db2->f('id'));
                  $this->tmpl->set_var('inp_text', $db2->f('name'));
                  $this->tmpl->parse('inp_options','modul_select_option',true);
            }
            $this->tmpl->set_var('refresh_id', $id_refresh);
            $this->tmpl->parse('tab_rows_','modul_select_refresh',true);
      }
      
      function add_row($label, $name, $value, $type)
      {
            $this->tmpl->set_var('row_lab', $name);
            $this->tmpl->set_var('row_name',$label);
            $this->tmpl->set_var('row_val', $value);
            $this->tmpl->parse('tab_rows_', $type, true);
      }
      
      function add_row_active($value)
      {
            $lab = "active";
            $this->tmpl->set_var('row_lab',"Widoczny");
            $this->tmpl->set_var('row_name',$lab);
            if($value == "1" || !isset($_GET["idd"]))
                  $this->tmpl->set_var('inp_checked', " checked=\"true\"");
            else
                  $this->tmpl->set_var('inp_checked', "");
            
            $this->tmpl->parse('tab_rows_','modul_check',true);

      }
            
      function add_row_checkbox($label, $name, $value)
      {
            $this->tmpl->set_var('row_lab', $name);
            $this->tmpl->set_var('row_name',$label);
            if($value == "1")
                  $this->tmpl->set_var('inp_checked', " checked=\"true\"");
            else
                  $this->tmpl->set_var('inp_checked', "");
            
            $this->tmpl->parse('tab_rows_','modul_check',true);

      }
            
      function add_row_date_($label, $name, $value, $type)
      {
            $this->tmpl->set_var('row_lab',$name);
            $this->tmpl->set_var('row_name',$label);
            if(isset($_GET["idd"]))
                  $this->tmpl->set_var('row_val', $value);
            else
                  $this->tmpl->set_var('row_val',date("Y-m-d"));
            $this->tmpl->parse('tab_rows_', $type, true);

      }
}


class Baza
{
      public $over_lang = 1;//nadrzedny domyslny ???
      public $filus_adm = 1;
      private $main_roots = array();
      private $main_roots_struct = array();
      public $users_services = array();
      public $users_sites = array();
      public $name = null;
      function __construct()
      {
            $this->authorisation();
            $this->set_user_tabs();
            $this->site_access();
      }
      
      function authorisation()
      {
            if(isset($_SESSION["id_user"]) && isset($_SESSION["uniq_user"]))
            {
                  $db = new DB__("select users.* from users
                  where users.id='".$_SESSION["id_user"]."' and users.uniq='".$_SESSION["uniq_user"]."' and users.active='1'");
                  if(!$db->next_record())
                        header("Location: index.php");
                  else
                        $this->name = $db->f('name')." ".$db->f('surname');
            }
            else
                  header("Location: index.php");
      }    
       
      function set_user_tabs()
      {
            if($_SESSION["guru"] == 2)
            {
                  $db = new DB__("select users_site.id_menu, menu.id_service from users_site, menu
                  where menu.id=users_site.id_menu and users_site.id_user='".$_SESSION["id_user"]."'");
                  if($db->nf())
                  {
                        while($db->next_record())
                        {
                              $this->users_sites[] = $db->f('id_menu');
                              if(!in_array($db->f('id_service'), $this->users_services))
                                    $this->users_services[] = $db->f('id_service');
                        }
                  }   
                  else
                  {
                        $db2 = new DB__("select users_service.id_service from users_service
                        where users_service.id_user='".$_SESSION["id_user"]."'");
                        if($db2->nf())
                        {
                              while($db2->next_record())
                                    $this->users_services[] = $db2->f('id_service');
                        }                  
                  }  
                  sort($this->users_services);       
            }
      }
                        
      function site_access()
      {
            if(!isset($_GET["id"]))
                  $_GET["id"] = NULL;
            else
            {
                  $_GET["id"] = intval($_GET["id"]);
                  if($_GET["id"] <= 0 || $_GET["id"] == "")
                        $_GET["id"] = NULL;
            }
            
            if($_SESSION["guru"] == 1)
            {
                  if(!isset($_SESSION["lang"]))
                  {
                        $db = new DB__("select menu_service.id from menu_service
                        order by menu_service.id
                        limit 0,1");
                        if($db->next_record())
                              $_SESSION["lang"] = $db->f('id');
                  }            
            }
            else if($_SESSION["guru"] != 1)
            {            
                  if(!isset($_SESSION["lang"]))
                  {
                        $_SESSION["lang"] = $this->users_services[0];
                  }       

                  if(!empty($this->users_services))
                  {
                        if(!in_array($_SESSION["lang"], $this->users_services))
                        {
                              $_SESSION["lang"] = null;
                              header("Location: cms.php");
                        }
                  }   
                  if(!empty($this->users_sites))
                  {
                        if(isset($_GET["id"]))
                        {
                              reset($this->users_sites);
                              while(list($k, $v) = each($this->users_sites))
                              {
                                    if(in_array($_GET["id"], $this->all_childs($v)) || $_GET["id"] == $v)
                                          return true;                 
                              }
                              header("Location: cms.php");
                        }  
                  }
            }        
      }     
      
      function template_access()
      {
            $tab_services = array();
            $db = new DB__("select template_menu.id_menu, menu_lang.name as menu_name, menu.id_service as menu_service, m2.name as m2_name from template_menu 
            left join menu on menu.id=template_menu.id_menu
            left join menu_lang on menu_lang.id_menu=template_menu.id_menu
            left join menu_lang as m2 on m2.id_menu=menu.id_menu
            where template_menu.id_template=
            (select template_menu.id_template from template_menu 
            where template_menu.id_menu='".$_GET["id"]."')
            order by menu_name");
            while($db->next_record())
            {
                  if($_SESSION["guru"] == 1 || in_array($db->f('id_menu'), $this->users_sites) || (empty($this->users_sites) && in_array($db->f('menu_service'), $this->users_services)))
                        $tab_services[$db->f('id_menu')] = $db->f('menu_name')." <= ".$db->f('m2_name');
            }
            return $tab_services;
      }      

      static function search_path($id)
      {
            $str = "";

            $db = new DB__("select menu.id, menu_lang.name from menu_root, menu
            left join menu_lang on menu_lang.id_menu=menu.id and menu_lang.id_lang='".$_SESSION["id_language"]."'
            where menu_root.id_root = menu.id and menu_root.id_menu = '$id' and menu.type in ('1','0')
            order by menu_root.ord desc");
            while($db->next_record())
            {
                  $str .= "<li><a href=\"".File::make_mode_rew($db->f('name'),$db->f('id'))."\">".$db->f('name')."</a></li>";                           
            }
            $db = new DB__("select menu.id, menu_lang.name from menu
            left join menu_lang on menu_lang.id_menu=menu.id and menu_lang.id_lang='".$_SESSION["id_language"]."'
            where menu.id = '$id' and menu.type in ('1','0')");
            if($db->next_record())
                  $str .= "<li><a href=\"".File::make_mode_rew($db->f('name'),$db->f('id'))."\">".$db->f('name')."</a></li>";  
                                           
            return $str;
      }


      static function show_registry($id, $idd = null)
      {
            $text = "";
            $where = "";
            $where2 = "";
            $ider_reg = 209;
            
            if(isset($idd))
                  $where = "and registry.idd = '$idd'";      
            /*
            //Rejestr zmian podstrony
            $db = new DB__("select registry.date_, registry.id, concat(users.name, ' ', users.surname) as name_ from registry, users
            where registry.id_user=users.id and registry.id_menu = '$id' $where and registry.kind in (1,2,3,7,8,9,10,11,12)
            order by registry.date_
            limit 0,1");
            if(0)//$db->next_record())
            {
                  if(isset($idd))
                        $text .= "<a href=\"/index.php?id=$ider_reg&amp;reg_id=$id&amp;reg_idd=$idd\">Rejestr zmian podstrony</a><br/>";
                  else
                        $text .= "<a href=\"/index.php?id=$ider_reg&amp;reg_id=$id\">Rejestr zmian podstrony</a><br/>";
            }
            
            //wprowadzil
            $db = new DB__("select registry.date_, registry.id, concat(users.name, ' ', users.surname) as name_ from registry, users
            where registry.id_user=users.id and registry.id_menu = '$id' $where and registry.kind in (1,2,3,7,8,9,10,11,12)
            order by registry.date_
            limit 0,1");
            if(0)//$db->next_record())
            {
                  $text .= "Informację wprowadził(a): ".$db->f('name_')." (".$db->f('date_').")<br/>";
            }
            
            //zmodyfikował
            $db2 = new DB__("select registry.date_, concat(users.name, ' ', users.surname) as name_ from registry, users
            where registry.id_user=users.id and registry.id_menu = '$id' $where and registry.kind in (1,2,3,7,8,9,10,11,12) and registry.id!='".$db->f('id')."'
            order by registry.date_ desc
            limit 0,1");
            if(0)//$db2->next_record())
            {
                  $text .= "Informację zmodyfikował(a): ".$db2->f('name_')." (".$db2->f('date_').")<br/>";
            }
*/
            //Liczba odwiedzin
            if(isset($idd))
                  $db2 = new DB__("SELECT sum(counter) as amount from stats_site where id_site='".$id."' and idd_site='".$idd."'");
            else 
                  $db2 = new DB__("SELECT sum(counter) as amount from stats_site where id_site='".$id."' and idd_site='0'");

            if($db2->next_record())
            {
                  $text .= "Liczba odwiedzin: ".$db2->f('amount')."<br/>";
            }

            return $text;
      }
      
      
      static function have_children($id)
      {
            $db = new DB__("select menu.id from menu
            where menu.id_menu='".intval($id)."'");
            if($db->next_record())
                  return true;
            else
                  return false;
      }
      
      function have_children_struct($id)
      {
            $db = new DB__("select structure.id from structure
            where structure.root='".intval($id)."'");
            if($db->next_record())
                  return true;
            else
                  return false;
      }
      
      static function have_files($id)
      {
            $db = new DB__("select file.id from file
            where file.idd='".intval($id)."' and file.id_template='0'");
            if($db->nf())
                  return $db->nf();
            else
                  return false;
      }
      
      static function have_photos($id)
      {
            $db = new DB__("select photo.id from photo
            where photo.idd='".intval($id)."' and photo.id_template='0'");
            if($db->nf())
                  return $db->nf();
            else
                  return false;
      }
      
      function get_site_name_www($id)
      {
            $db = new DB__("select menu_lang.name from menu_lang
            where menu_lang.id_menu='".intval($id)."' and menu_lang.id_lang='".$_SESSION["id_language"]."'");
            if($db->next_record())
                  return $db->f('name');
            else
                  return false;
      }
      
      function get_site_name($id)
      {
            $db = new DB__("select menu_lang.name from menu_lang
            where menu_lang.id_menu='".intval($id)."' and menu_lang.id_lang='".$_SESSION["id_lang_cms"]."'");
            if($db->next_record())
                  return $db->f('name');
            else
                  return false;
      }
      
      static function get_service_main_id($id)
      {
            $db = new DB__("select menu.id from menu
            where menu.id_service='".intval($id)."' and menu.type='2'");
            if($db->next_record())
                  return $db->f('id');
            else
                  return false;
      }
      
      function get_root($id)
      {
            $db = new DB__("select menu.id_menu from menu
            where menu.id='".intval($id)."'");
            if($db->next_record())
                  return $db->f('id_menu');
            else
                  return false;
      }
      
      function get_root_struct($id)
      {
            $db = new DB__("select structure.root from structure
            where structure.id='".intval($id)."'");
            if($db->next_record())
                  return $db->f('root');
            else
                  return false;
      }
      
      function main_root($id)
      {
            $db = new DB__("select menu.main_root from menu
            where menu.id='".intval($id)."'");
            if($db->next_record())
                  return $db->f('main_root');
            else
                  return false;
      }
      
      function make_main_roots($id)
      {
            $db = new DB__("select menu.id_menu from menu
            where menu.id='".$id."'");
            if($db->next_record())
            {
                  if($db->f('id_menu') == 0)
                        return $this->main_roots;
                  else
                  {
                        $this->main_roots[] = $db->f('id_menu');
                        $this->make_main_roots($db->f('id_menu'));
                  }
            }
            return $this->main_roots;
      }
      
      function make_main_roots_struct($id)
      {
            $db = new DB__("select structure.root from structure
            where structure.id='".$id."'");
            if($db->next_record())
            {
                  if($db->f('root') == 0)
                        return $this->main_roots_struct;
                  else
                  {
                        $this->main_roots_struct[] = $db->f('root');
                        $this->make_main_roots_struct($db->f('root'));
                  }
            }
            return $this->main_roots_struct;
      }
      
      static function tab_of_roots($id)
      {
            $tab = array();
            $db = new DB__("select menu_root.id_root from menu_root
            where menu_root.id_menu='".intval($id)."'
            order by menu_root.ord");
            while($db->next_record())
            {
                  $tab[] = $db->f('id_root');     
            }
            return $tab;
      }
      
      function tab_of_roots_struct($id)
      {
            $tab = array();
            $db = new DB__("select structure_root.id_root from structure_root
            where structure_root.id_menu='".intval($id)."'
            order by structure_root.ord");
            while($db->next_record())
            {
                  $tab[] = $db->f('id_root');     
            }
            return $tab;
      }
      
      function all_childs($id)
      {
            $tab = array();
            $db = new DB__("select menu_root.id_menu from menu_root
            where menu_root.id_root='".intval($id)."'");
            while($db->next_record())
                  $tab[] = $db->f('id_menu');          
            return $tab;
      }
      
      function all_childs_struct($id)
      {
            $tab = array();
            $db = new DB__("select structure_root.id_menu from structure_root
            where structure_root.id_root='".intval($id)."'");
            while($db->next_record())
                  $tab[] = $db->f('id_menu');          
            return $tab;
      }
      

      function registry($act, $id, $idd = "", $txt = "")
      {
            $in = 1;
            /*
            if($idd && $act >= 7 && $act <= 12)
            {
                  $db = new DB__("select id from registry where id_menu='$id' and idd='$idd'");
                  if(!$db->nf())
                  {
                        $in = null;
                  }            
            }*/
            
            $db = new DB__("select name from menu_lang where id_menu='$id' and id_lang='".$_SESSION["id_lang_cms"]."'");
            if($db->next_record() && isset($in))
            {
                  $txt = str_replace("\r\n", " ", $txt);
                  $txt = str_replace("\n", " ", $txt);
                  if($act == 1)
                        $chan = "Dodanie informacji $txt na stronie - ".$db->f('name');
                  else if($act == 2)
                        $chan = "Edycja informacji ".$txt." na stronie - ".$db->f('name');
                  else if($act == 3)
                        $chan = "Usunięcie informacji $txt na stronie - ".$db->f('name');
                  else if($act == 4)
                        $chan = "Stworzenie strony - ".$db->f('name');
                  else if($act == 5)
                        $chan = "Edycja nazwy strony - ".$db->f('name');
                  else if($act == 6)
                        $chan = "Usunięcie strony - ".$txt;
                  else if($act == 7)
                        $chan = "Dodanie załącznika $txt na stronie - ".$db->f('name');
                  else if($act == 8)
                        $chan = "Edycja załącznika $txt na stronie - ".$db->f('name');
                  else if($act == 9)
                        $chan = "Usunięcie załącznika $txt na stronie - ".$db->f('name');
                  else if($act == 10)
                        $chan = "Dodanie foto $txt na stronie - ".$db->f('name');
                  else if($act == 11)
                        $chan = "Edycja foto $txt na stronie - ".$db->f('name');
                  else if($act == 12)
                        $chan = "Usunięcie fotki na $txt stronie - ".$db->f('name');
                            
                  $datka = date("Y-m-d H:i:s");
                  
                  new DB__("insert into registry (id_user, text, date_, id_menu, idd, kind) values ('".$_SESSION["id_user"]."', '".addslashes($chan)."', '".$datka."', '".$id."', '".$idd."','".$act."')");
            }
      }


      function paste()
      {
            //musimy zmienic inne ordy - najpierw stary ord
            $old_ord = null;
            $dbb = new DB__("select ord, id_menu, id_service from menu where id = '".$_SESSION["cut"]."'");   
            if($dbb->next_record())
            {
                  $old_ord = $dbb->f('ord');
                  new DB__("update menu set ord=ord-1 where ord > '".$dbb->f('ord')."' and id_menu = '".$dbb->f('id_menu')."' and id_service = '".$dbb->f('id_service')."'");                  
            }            

            
            //musimy zmienic inne ordy - potem nowy
            if(isset($old_ord))
                  new DB__("update menu set ord=ord+1 where ord >= '".$old_ord."' and id_menu = '".$_GET["id"]."' and id_service = '".$_SESSION["lang"]."'");                  
                  
            $main_root = $this->main_root($_GET["id"]);
            new DB__("update menu set id_menu='".$_GET["id"]."', id_service='".$_SESSION["lang"]."', main_root='$main_root' 
            where id='".$_SESSION["cut"]."'");
            

            new DB__("delete from menu_root where id_menu='".$_SESSION["cut"]."'");
            $tab_mr = array();
            $tab_mr = $this->tab_of_roots($_GET["id"]);
            array_unshift($tab_mr, $_GET["id"]);
            $i = 0;
            while(list($k, $l)=each($tab_mr))
            {
                  $i++;
                  new DB__("insert into menu_root (id_menu, id_root, ord) values ('".$_SESSION["cut"]."', '$l', '$i')");
            }

            $childs = $this->all_childs($_SESSION["cut"]);
            for($i = 0;$i < sizeof($childs);$i++)
            {
                  new DB__("update menu set id_service='".$_SESSION["lang"]."', main_root='$main_root' where id='".$childs[$i]."'");
                  
                  $db = new DB__("select menu.id_menu from menu where menu.id='".$childs[$i]."'");
                  if($db->next_record())
                  {
                        new DB__("delete from menu_root where id_menu='".$childs[$i]."'");
                        $tab_mr = array();
                        $tab_mr = $this->tab_of_roots($db->f('id_menu'));
                        array_unshift($tab_mr, $db->f('id_menu'));
                        $ii = 0;
                        while(list($k, $l)=each($tab_mr))
                        {
                              $ii++;
                              new DB__("insert into menu_root (id_menu, id_root, ord) values ('".$childs[$i]."', '$l', '$ii')");
                        }
                  }
            }
      }
      function paste_struct()
      {
            new DB__("update structure set root='".$_GET["idd"]."'
            where id='".$_SESSION["cut_struct"]."'");
            
            new DB__("delete from structure_root where id_menu='".$_SESSION["cut_struct"]."'");
            
            $tab_mr = array();
            $tab_mr = $this->tab_of_roots_struct($_GET["idd"]);
            array_unshift($tab_mr, $_GET["idd"]);
            $i = 0;
            while(list($k, $l)=each($tab_mr))
            {
                  $i++;
                  new DB__("insert into structure_root (id_menu, id_root, ord) values ('".$_SESSION["cut_struct"]."', '$l', '$i')");
            }

            $childs = $this->all_childs_struct($_SESSION["cut_struct"]);
            for($i = 0;$i < sizeof($childs);$i++)
            {
                  $db = new DB__("select structure.root from structure where structure.id='".$childs[$i]."'");
                  if($db->next_record())
                  {
                        new DB__("delete from structure_root where id_menu='".$childs[$i]."'");
                        $tab_mr = array();
                        $tab_mr = $this->tab_of_roots_struct($db->f('root'));
                        array_unshift($tab_mr, $db->f('root'));
                        $ii = 0;
                        while(list($k, $l)=each($tab_mr))
                        {
                              $ii++;
                              new DB__("insert into structure_root (id_menu, id_root, ord) values ('".$childs[$i]."', '$l', '$ii')");
                        }
                  }
            }
      }
      function del()
      {
            //kasowanie po nowemu  and id_lang='".$_SESSION["id_lang_cms"]."'
            //niezaleznie od wersji (kazda ma osobne): file, text, link, photo_lang
            // and id_lang='".$_SESSION["id_lang_cms"]."'
            
            //podzielimy na kasowanie all i czyszczenie wersji jęz.
            
            //all
            
            $db = new DB__("select * from file where file.idd='".intval($_GET["id"])."' and file.id_template='0'");
            while($db->next_record())
            {
                  if($db->f('path'))
                        File::file_del(PATH_DOC.$db->f('path'));
            }
            new DB__("delete from file where file.idd='".intval($_GET["id"])."' and file.id_template='0'");
            
            $db = new DB__("select photo.* from photo where photo.idd='".intval($_GET["id"])."' and photo.id_template='0'");
            while($db->next_record())
            {
                  if($db->f('photo_m'))
                        File::file_del(PATH_IMG.$db->f('photo_m'));
                  if($db->f('photo_b'))
                        File::file_del(PATH_IMG.$db->f('photo_b'));
                        
                  new DB__("delete from photo_lang where photo_lang.id_photo='".$db->f('id')."'");
            }
            new DB__("delete from photo where photo.idd='".intval($_GET["id"])."' and photo.id_template='0'");

            new DB__("delete from users_site where id_menu='".$_GET["id"]."'"); 
            new DB__("delete from template_menu where id_menu='".$_GET["id"]."'");
            new DB__("delete from text where id_menu='".$_GET["id"]."'");
            new DB__("delete from link where id_menu='".$_GET["id"]."'");
            new DB__("delete from menu_root where id_menu='".$_GET["id"]."'");
            
            $db2 = new DB__("select id, ord, id_menu, id_service from menu 
            where id='".$_GET["id"]."'");
            if($db2->next_record())
            {
                  //zmiana orda
                  new DB__("update menu set ord=ord-1 where ord > '".$db2->f('ord')."' and id_menu = '".$db2->f('id_menu')."' and id_service = '".$db2->f('id_service')."'");                  
                  $this->registry(6, $_GET["id"], "", $db2->f('id'));
            }

            new DB__("delete from menu where id='".$_GET["id"]."'");
            new DB__("delete from menu_lang where id_menu='".$_GET["id"]."'");
            
            $childs = $this->all_childs($_GET["id"]);
            for($i = 0;$i < sizeof($childs);$i++)
            {
                  $db3 = new DB__("select id from menu where id='".$childs[$i]."'");
                  if($db3->next_record())
                        $this->registry(6, $childs[$i], "", $db3->f('id'));
                  
                  $db = new DB__("select * from file where file.idd='".$childs[$i]."' and file.id_template='0'");
                  while($db->next_record())
                  {
                        if($db->f('path'))
                              File::file_del(PATH_DOC.$db->f('path'));
                  }
                  new DB__("delete from file where file.idd='".$childs[$i]."' and file.id_template='0'");
                  
                  $db = new DB__("select * from photo where photo.idd='".$childs[$i]."' and photo.id_template='0'");
                  while($db->next_record())
                  {
                        if($db->f('photo_m'))
                              File::file_del(PATH_IMG.$db->f('photo_m'));
                        if($db->f('photo_b'))
                              File::file_del(PATH_IMG.$db->f('photo_b'));
                              
                        new DB__("delete from photo_lang where photo_lang.id_photo='".$db->f('id')."'");
                  }
                  new DB__("delete from photo where photo.idd='".$childs[$i]."' and photo.id_template='0'");

                  new DB__("delete from menu where id='".$childs[$i]."'");
                  new DB__("delete from menu_lang where id_menu='".$childs[$i]."'");
                  new DB__("delete from text where id_menu='".$childs[$i]."'");
                  new DB__("delete from link where id_menu='".$childs[$i]."'");
                  new DB__("delete from template_menu where id_menu='".$childs[$i]."'");
                  new DB__("delete from menu_root where id_menu='".$childs[$i]."'");
            }
            $_GET["id"] = $db2->f('id_menu');
      }
      function del_struct()
      {
            $id_temp = "";
            $db = new DB__("select * from file where file.idd='".intval($_GET["idd"])."' and file.id_template=(select id_template from template_menu where template_menu.id_menu='".$_GET["id"]."')");
            while($db->next_record())
            {
                  $id_temp = $db->f('id_template');
                  if($db->f('path'))
                        File::file_del(PATH_DOC.$db->f('path'));
            }
            new DB__("delete from file where file.idd='".intval($_GET["idd"])."' and file.id_template='".$id_temp."'");
            new DB__("delete from structure_root where id_menu='".$_GET["idd"]."'");
            
            $db2 = new DB__("select root, name, id_menu, ord from structure where id='".$_GET["idd"]."'");
            if($db2->next_record())
            {
                  //zmiana orda
                  new DB__("update structure set ord=ord-1 where ord > '".$db2->f('ord')."' and id_menu = '".$db2->f('id_menu')."' and root = '".$db2->f('root')."'");                  
                  $this->registry(3, $_GET["id"], $_GET["idd"], $db2->f('name'));
            }

            new DB__("delete from structure where id='".$_GET["idd"]."'");
            
            $childs = $this->all_childs_struct($_GET["idd"]);
            for($i = 0;$i < sizeof($childs);$i++)
            {
                  $db3 = new DB__("select name from structure where id='".$childs[$i]."'");
                  if($db3->next_record())
                        $this->registry(3, $_GET["id"], $childs[$i], $db3->f('name'));
                  
                  $db3 = new DB__("select * from file where file.idd='".$childs[$i]."' and file.id_template='".$id_temp."'");
                  while($db3->next_record())
                  {
                        if($db3->f('path'))
                              File::file_del(PATH_DOC.$db3->f('path'));
                  }
                  
                  new DB__("delete from file where file.idd='".$childs[$i]."' and file.id_template='".$id_temp."'");
                  
                  new DB__("delete from structure where id='".$childs[$i]."'");
                  new DB__("delete from structure_root where id_menu='".$childs[$i]."'");
            }
            $_GET["idd"] = $db2->f('root');
      }
      
      function order($tab)
      {
            if(list($k, $l) = each($tab))
            {
                  $l = intval($l);
                  if($l == 0)
                        $l = 1;
                        
                  if($k > 0)
                  {
                        //musimy zmienic inne ordy
                        $dbb = new DB__("select ord, id_menu, id_service from menu where id = '$k'");   
                        if($dbb->next_record())
                        {
                              if($l > $dbb->f('ord'))                              
                                    new DB__("update menu set ord=ord-1 where ord <= '".$l."' and ord > '".$dbb->f('ord')."' and id_menu = '".$dbb->f('id_menu')."' and id_service = '".$dbb->f('id_service')."'");   
                              else if($l < $dbb->f('ord'))             
                                    new DB__("update menu set ord=ord+1 where ord >= '".$l."' and ord < '".$dbb->f('ord')."' and id_menu = '".$dbb->f('id_menu')."' and id_service = '".$dbb->f('id_service')."'");   
                        }            
                           
                        new DB__("update menu set ord='$l' where id = '$k'");
                  }
                  
            }            
      }
      
      function order_struct($tab)
      {
            if(list($k, $l) = each($tab))
            {
                  $l = intval($l);
                  if($l == 0)
                        $l = 1;
                        
                  if($k > 0)
                  {
                        //musimy zmienic inne ordy
                        $dbb = new DB__("select ord, id_menu, root from structure where id = '$k'");   
                        if($dbb->next_record())
                        {
                              if($l > $dbb->f('ord'))                              
                                    new DB__("update structure set ord=ord-1 where ord <= '".$l."' and ord > '".$dbb->f('ord')."' and id_menu = '".$dbb->f('id_menu')."' and root = '".$dbb->f('root')."'");   
                              else if($l < $dbb->f('ord'))             
                                    new DB__("update structure set ord=ord+1 where ord >= '".$l."' and ord < '".$dbb->f('ord')."' and id_menu = '".$dbb->f('id_menu')."' and root = '".$dbb->f('root')."'");   
                        }            
                           
                        new DB__("update structure set ord='$l' where id = '$k'");
                  }
                  
            }            
      }
      function update($tab)
      {
            while(list($k,$l)=each($tab))
            {
                  if($l != "")
                  {
                        if($k != "0")
                        {
                              $db = new DB__("select name from menu_lang where id_menu='$k' and id_lang='".$_SESSION["id_lang_cms"]."'");              
                              if($db->nf())
                                    new DB__("update menu_lang set name='$l' where id_menu='$k' and id_lang='".$_SESSION["id_lang_cms"]."'");
                              else
                                    new DB__("insert into menu_lang (id_menu, id_lang, name) values ('$k', '".$_SESSION["id_lang_cms"]."', '$l')");
                              
                              $this->registry("5", $k, "", "");
                              $_GET["id"] = $k;                                                          
                              header("Location: cms.php?id=".$k);
                        }
                        else
                        {
                              if($_POST["menu_go"] > 0)
                              {
                                    
                                    $main_root = $this->main_root($_POST["menu_go"]);                                
                                    $db = new DB__("insert into menu (id_menu, ord, id_service, main_root) VALUES ('".$_POST["menu_go"]."','".$_POST["menu_ord"][0]."','".$_SESSION['lang']."','$main_root')");
                                    $_GET["id"] = $db->maxid();
                                    new DB__("insert into menu_lang (id_menu, id_lang, name) VALUES ('".$_GET["id"]."', '".$_SESSION["id_lang_cms"]."', '$l')");
                                    
                                    //musimy zmienic inne ordy
                                    $dbb = new DB__("select id_menu, id_service from menu where id = '".$_GET["id"]."'");   
                                    if($dbb->next_record())
                                    {
                                          new DB__("update menu set ord=ord+1 where ord >= '".$_POST["menu_ord"][0]."' and id_menu = '".$dbb->f('id_menu')."' and id_service = '".$dbb->f('id_service')."' and id != '".$_GET["id"]."'");                  
                                    }            
                                    
                                    $this->registry("4", $_GET["id"], "", "");
                                    //echo   "reg4".$_GET["id"];
                                      
                                    $tab_mr = array();
                                    $tab_mr = $this->make_main_roots($_GET["id"]);
      
                                    $i = 0;
                                    while(list($k, $l)=each($tab_mr))
                                    {
                                          $i++;
                                          new DB__("insert into menu_root (id_menu, id_root, ord) values ('".$_GET["id"]."', '$l', '$i')");
                                    }                                 
                                    
                                    header("Location: cms.php?id=".$_GET["id"]);
                              }
                              else
                              {
                                    if(isset($this->filus_adm))
                                    {
                                          $db = new DB__("insert into menu (id_menu, ord, id_service, type) VALUES (0, '".$_POST["menu_ord"][0]."','".$_SESSION['lang']."','4')");
                                          $_GET["id"] = $db->maxid();
                                          new DB__("insert into menu_lang (id_menu, id_lang, name) VALUES ('".$_GET["id"]."', '".$_SESSION["id_lang_cms"]."', '$l')");
                                          
                                          new DB__("update menu set main_root='".$_GET["id"]."' where id='".$_GET["id"]."'");
                                          $this->registry("4", $db->maxid(), "", "");
                                          
                                          header("Location: cms.php?id=".$_GET["id"]);
                                    }
                              }
                        }
                        $db3 = new DB__("select name from menu_lang where id_menu='".$_GET["id"]."' and id_lang='".$_SESSION["id_lang_cms"]."'");
                        if($db3->next_record())
                        {
                              $path = "../graph/menu_up/";  
                              $font = "../graph/myriadpro1.ttf";
                              
                              $name = $_SESSION["id_lang_cms"]."menu_up".$_GET["id"];                            
                              $name_ = mb_strtolower($db3->f('name'));              
                              $size = 12;               
                              File::make_menu_img($path, $name_, $name, $font, $size);

                              /*
                              $font = "../graph/myriadpro1.ttf";
                              $size = 14;               
                              $name = $_SESSION["id_lang_cms"]."label".$_GET["id"];                            
                              $name_ = mb_strtoupper($db3->f('name'));              
                              File::make_menu_img2($path, $name_, $name, $font, $size);
                              
                              $size = 18;               
                              $name = $_SESSION["id_lang_cms"]."label_main".$_GET["id"];                            
                              $name_ = mb_strtoupper($db3->f('name'));              
                              File::make_menu_img3($path, $name_, $name, $font, $size);

                              $name = "title".$_GET["id"];                            
                              $name_ = mb_strtoupper($db3->f('name'));              
                              $size = 12;               
                              File::make_menu_img($path, $name_, $name, $font, $size);
                              */
                              //$font = "../graph/shardee.ttf";
                              //$name = "label".$_GET["id"];                            
                              //File::make_menu_img_shardee($path, $name_, $name, $font);
                              
                              
                        }
                  }
            }
      }
      function update_struct($tab)
      {
            while(list($k,$l)=each($tab))
            {
                  if($l != "")
                  {
                        if($k != "0")
                        {
                              new DB__("update structure set name='$l' where id='$k'");
                              $this->registry("2", $_GET["id"], $k, $l);
                                                                                        
                              header("Location: modules.php?id=".$_GET["id"]."&idd=".$k);
                        }
                        else
                        {
                              if($_POST["menu_go"] > 0)
                              {
                                    $db = new DB__("insert into structure (name, id_menu, root, ord) VALUES ('$l','".$_GET["id"]."','".$_POST["menu_go"]."','".$_POST["menu_ord"][0]."')");
                                    $_GET["idd"] = $db->maxid();
                                    
                                    //musimy zmienic inne ordy
                                    $dbb = new DB__("select id_menu, root from structure where id = '".$_GET["id"]."'");   
                                    if($dbb->next_record())
                                    {
                                          new DB__("update menu set ord=ord+1 where ord >= '".$_POST["menu_ord"][0]."' and id_menu = '".$dbb->f('id_menu')."' and root = '".$dbb->f('root')."' and id != '".$_GET["id"]."'");                  
                                    }            
                                    
                                    $this->registry("1", $_GET["id"], $_GET["idd"], $l);
                                      
                                    $tab_mr = array();
                                    $tab_mr = $this->make_main_roots_struct($_GET["idd"]);
      
                                    $i = 0;
                                    while(list($k, $l)=each($tab_mr))
                                    {
                                          $i++;
                                          new DB__("insert into structure_root (id_menu, id_root, ord) values ('".$_GET["idd"]."', '$l', '$i')");
                                    }                                 
                                    
                                    header("Location: modules.php?id=".$_GET["id"]."&idd=".$_GET["idd"]);
                              }
                              else
                              {
                                    if(isset($this->filus_adm))
                                    {
                                          $db = new DB__("insert into structure (name, root, id_menu, ord) VALUES ('$l',0, '".$_GET["id"]."', '".$_POST["menu_ord"][0]."')");
                                          $_GET["idd"] = $db->maxid();
                                          $this->registry("1", $_GET["id"], $_GET["idd"], $l);
                                          
                                          header("Location: modules.php?id=".$_GET["id"]."&idd=".$_GET["idd"]);
                                    }
                              }
                        }
                  }
            }
      }
      function del_content()
      {
            new DB__("delete from text where id_menu='".$_GET["id"]."' and id_lang='".$_SESSION["id_lang_cms"]."'");
            $this->registry("3", $_GET["id"]);
            return 0;
      }
      
      function edit_content()
      {
            new DB__("update menu set level='".intval($_POST["text_level"])."' where id='".$_GET["id"]."'");
            new DB__("update menu set type = '".intval($_POST["text_type"])."' where id = '".$_GET["id"]."'");
            new DB__("update menu_lang set title = '".$_POST["title"]."', keywords = '".$_POST["keywords"]."', description = '".$_POST["description"]."' where id_menu = '".$_GET["id"]."' and id_lang='".$_SESSION["id_lang_cms"]."'");

            if(isset($_POST["text_active"]))
                  $_POST["text_active"] = "1";
            else
                  $_POST["text_active"] = "0";
                  
            $db = new DB__("select text from text 
            where id_menu='".$_GET["id"]."' and id_lang='".$_SESSION["id_lang_cms"]."'");              
            if($db->nf())
            {
                  new DB__("update text set text='".$_POST["text_inp"]."', active='".$_POST["text_active"]."' where id_menu='".$_GET["id"]."' and id_lang='".$_SESSION["id_lang_cms"]."'");
                  $this->registry("2", $_GET["id"]);            
            }
            else
            {
                  new DB__("insert into text (id_menu, id_lang, text, active) values ('".$_GET["id"]."', '".$_SESSION["id_lang_cms"]."', '".$_POST["text_inp"]."', '".$_POST["text_active"]."')");
                  $this->registry("1", $_GET["id"]);            
            }
            return 1;
      }
      
}
class Admin extends Baza
{
      private $tab_roots = array();
      function __construct()
      {
            if(isset($_GET["id"]))
                  if($_GET["id"] != "")
                        $this->tab_roots = $this->tab_of_roots($_GET["id"]);
      }
    
      function show_menu($id = 0, $depth = 0)
      {
            global $tmpl;
            $space = 1;
                       
            if($depth == 0 && $id != 0)
            {
                  $db = new DB__("select menu.id, menu.type, menu.id_menu, if(menu_lang.name is null, concat('<span class=\"menu_unlight\">',ml_main.name,'</span>'), menu_lang.name) as name, if(menu_lang.name is null, 0, 1) as is_name, menu.ord from menu
                  left join menu_lang on menu_lang.id_menu=menu.id and menu_lang.id_lang='".$_SESSION["id_lang_cms"]."'
                  left join menu_lang as ml_main on ml_main.id_menu=menu.id and ml_main.id_lang='".$this->over_lang."'
                  where menu.id='$id' and menu.id_service='".$_SESSION["lang"]."'
                  order by menu.ord");
            }
            else
            {
                  $db = new DB__("select menu.id, menu.type, menu.id_menu, if(menu_lang.name is null, concat('<span class=\"menu_unlight\">',ml_main.name,'</span>'), menu_lang.name) as name, if(menu_lang.name is null, 0, 1) as is_name, menu.ord from menu
                  left join menu_lang on menu_lang.id_menu=menu.id and menu_lang.id_lang='".$_SESSION["id_lang_cms"]."'
                  left join menu_lang as ml_main on ml_main.id_menu=menu.id and ml_main.id_lang='".$this->over_lang."'
                  where menu.id_menu='$id' and menu.id_service='".$_SESSION["lang"]."'
                  order by menu.ord");
            }

            $tmpl->set_var('tree_row_ul', '<ul class="ul_menu">');
            $tmpl->set_var('tree_row_ul_sort', '<ul class="ul_menu" id="sortable">');
            $tmpl->set_var('tree_row_ul_end', '</ul>');
            $tmpl->set_var('tree_row_li', '<li id="{li_idek}">');
            $tmpl->set_var('tree_row_li_end', '</li>');
            
            if($db->nf())
            {
                  //echo $id." => ".$_GET["id"]."<br/>";
                  if($id == $_GET["id"] || ($this->get_root($_GET["id"]) == $id && (!$this->have_children($_GET["id"]))))
                        $tmpl->parse('tree_row_', 'tree_row_ul_sort', true);
                  else
                        $tmpl->parse('tree_row_', 'tree_row_ul', true);
                        
                  while($db->next_record())
                  {
                        $tmpl->set_var('li_idek', "id".$db->f('id'));
                        $tmpl->parse('tree_row_', 'tree_row_li', true);
                        
                        if(in_array($db->f('id'), $this->tab_roots) || $_GET["id"] == $db->f('id'))
                              $inside = 1;
                        else
                              $inside = 0;
                              
                        if($db->f('id_menu') == 0)
                        {
                              $tmpl->set_var('tree_name', "<b>".$db->f('name')."</b>");
                              if($db->f('type') != 2)
                              {
                                    if($inside == 1)
                                          $tmpl->set_var('tree_ico', 'dir_open_blue');
                                    else
                                          $tmpl->set_var('tree_ico', 'dir_close_blue');
                              }
                              else
                                    $tmpl->set_var('tree_ico', 'menu_home');
                        }
                        else
                        {
                              if($db->f('type') == -1)
                              {
                                    $tmpl->set_var('tree_ico_transp', "ico_blocked");
                                    $tmpl->set_var('tree_class', "col_red");
                              }
                              else if($db->f('type') == 0)
                              {
                                    $tmpl->set_var('tree_class', "col_text italic");
                              }
                              else
                              {
                                    $tmpl->set_var('tree_ico_transp', "spacer");
                                    $tmpl->set_var('tree_class', "");
                              }
                              
                              
                              $tmpl->set_var('tree_name', $db->f('name'));
                              if($inside == 1)
                                    $tmpl->set_var('tree_ico', 'dir_open');
                              else
                                    $tmpl->set_var('tree_ico', 'dir_close');                  
                        }
                              
                        
                        $tmpl->set_var('tree_ord', $db->f('ord'));
                        $tmpl->set_var('tree_id', $db->f('id'));
                                          
                        if($_GET["action"] == "edit" && $_GET["id"] == $db->f('id'))
                        {
                              if($db->f('is_name') == 1)
                                    $tmpl->set_var('tree_name', $db->f('name'));
                              else
                                    $tmpl->set_var('tree_name', "");
                              $tmpl->set_var('js_onload', "document.getElementById('menu_name[".$_GET["id"]."]').select();");
                              $tmpl->parse('tree_row_', 'tree_row_edit', true);
                        }
                        else
                              $tmpl->parse('tree_row_', 'tree_row', true);
                        
                        if($_GET["action"] == "unpage" && $_GET["id"] == $db->f('id'))
                        {
                              
                              $tmpl->set_var('tree_id', "0");
                              
                              $db2 = new DB__("select max(menu.ord) as max from menu
                              where menu.id_menu='".$_GET["id"]."'");
                              if($db2->next_record())
                                    $tmpl->set_var('tree_ord', $db2->f('max') + 1);
                              
                              $tmpl->set_var('tree_name', "");
                              $tmpl->set_var('tree_ico', 'dir_open');
                              $tmpl->set_var('js_onload', "document.getElementById('menu_name[0]').focus();");
                              $tmpl->parse('tree_row_', 'tree_row_edit', true);
                        }
                        
                        if($inside == 1)
                              //$tmpl->set_var('li_temp_', $this->show_menu($db->f('id'), $depth + $space));
                              $this->show_menu($db->f('id'), $depth + $space);
                              
                        $tmpl->parse('tree_row_', 'tree_row_li_end', true);
                              
                  }
                  
                  if($_GET["action"] == "page1" && !isset($_GET["id"]))
                  {
                        
                        $tmpl->set_var('tree_margin', $depth);
                        $tmpl->set_var('tree_id', "0");
                        
                        $db2 = new DB__("select (max(menu.ord) + 1) as max from menu
                        where menu.id_menu='0' and menu.id_service='".$_SESSION["lang"]."'");
                        if($db2->next_record())
                              $tmpl->set_var('tree_ord', $db2->f('max'));
                        else
                              $tmpl->set_var('tree_ord', "1");
                        
                        $tmpl->set_var('tree_name', "");
                        $tmpl->set_var('tree_ico', 'dir_open_blue');
                        $tmpl->set_var('js_onload', "document.getElementById('menu_name[0]').focus();");
                        $tmpl->parse('tree_row_', 'tree_row_edit', true);
                  }
                  $tmpl->parse('tree_row_', 'tree_row_ul_end', true);
            }
      }

}

class Structure extends Baza
{
      private $tab_roots = array();
      function __construct()
      {
            if(isset($_GET["idd"]))
                  if($_GET["idd"] != "")
                        $this->tab_roots = $this->tab_of_roots_struct($_GET["idd"]);
            
      }
    
      function show_menu($id = 0, $depth = 0)
      {
            global $tmpl;
            $space = 1;
            $tmpl->set_var('tree_id', $_GET["id"]);
            
            if($depth == 0 && $id != 0)
            {
                  $db = new DB__("select structure.id, structure.root, structure.name, structure.ord from structure
                  where structure.id='$id' and structure.id_menu='".$_GET["id"]."'
                  order by structure.ord");
            }
            else
            {
                  $db = new DB__("select structure.id, structure.root, structure.name, structure.ord from structure
                  where structure.root='$id' and structure.id_menu='".$_GET["id"]."'
                  order by structure.ord");
            }

            $tmpl->set_var('tree_row_ul', '<ul class="ul_menu">');
            $tmpl->set_var('tree_row_ul_sort', '<ul class="ul_menu" id="sortable">');
            $tmpl->set_var('tree_row_ul_end', '</ul>');
            $tmpl->set_var('tree_row_li', '<li id="{li_idek}">');
            $tmpl->set_var('tree_row_li_end', '</li>');
            
            if($db->nf())
            {
                  //echo $id." => ".$_GET["idd"]."<br/>";
                  if($id == $_GET["idd"] || ($this->get_root_struct($_GET["idd"]) == $id && (!$this->have_children_struct($_GET["idd"]))))
                  {
                        $tmpl->parse('tree_row_', 'tree_row_ul_sort', true);
                        //echo 1;
                  }
                  else
                  {
                        $tmpl->parse('tree_row_', 'tree_row_ul', true);
                        //echo 1;
                  }
                        
                  while($db->next_record())
                  {
                        $tmpl->set_var('li_idek', "id".$db->f('id'));
                        $tmpl->parse('tree_row_', 'tree_row_li', true);
                        
                        if(in_array($db->f('id'), $this->tab_roots) || $_GET["idd"] == $db->f('id'))
                              $inside = 1;
                        else
                              $inside = 0;
                              
                        if($db->f('root') == 0)
                        {
                              $tmpl->set_var('tree_name', "<b>".$db->f('name')."</b>");
                              
                              if($inside == 1)
                                    $tmpl->set_var('tree_ico', 'dir_open_blue');
                              else
                                    $tmpl->set_var('tree_ico', 'dir_close_blue');
                        }
                        else
                        {
                              if($db->f('type') == -1)
                                    $tmpl->set_var('tree_ico_transp', "ico_blocked");
                              else
                                    $tmpl->set_var('tree_ico_transp', "spacer");
                              
                              
                              $tmpl->set_var('tree_name', $db->f('name'));
                              if($inside == 1)
                                    $tmpl->set_var('tree_ico', 'dir_open');
                              else
                                    $tmpl->set_var('tree_ico', 'dir_close');                  
                        }
                              
                        
                        $tmpl->set_var('tree_ord', $db->f('ord'));
                        $tmpl->set_var('tree_idd', $db->f('id'));
                                          
                        if($_GET["action"] == "edit_struct" && $_GET["idd"] == $db->f('id'))
                        {
                              //if($db->f('is_name') == 1)
                                    $tmpl->set_var('tree_name', $db->f('name'));
                              //else
                              //      $tmpl->set_var('tree_name', "");
                              $tmpl->set_var('js_onload', "document.getElementById('menu_name[".$_GET["idd"]."]').select();");
                              $tmpl->parse('tree_row_', 'tree_row_edit', true);
                        }
                        else
                              $tmpl->parse('tree_row_', 'tree_row', true);
                        
                        if($_GET["action"] == "unpage" && $_GET["idd"] == $db->f('id'))
                        {
                              
                              $tmpl->set_var('tree_idd', "0");
                              
                              $db2 = new DB__("select max(structure.ord) as max from structure
                              where structure.id_menu='".$_GET["id"]."'");
                              if($db2->next_record())
                                    $tmpl->set_var('tree_ord', $db2->f('max') + 1);
                              
                              $tmpl->set_var('tree_name', "");
                              $tmpl->set_var('tree_ico', 'dir_open');
                              $tmpl->set_var('js_onload', "document.getElementById('menu_name[0]').focus();");
                              $tmpl->parse('tree_row_', 'tree_row_edit', true);
                        }
                        
                        if($inside == 1)
                              //$tmpl->set_var('li_temp_', $this->show_menu($db->f('id'), $depth + $space));
                              $this->show_menu($db->f('id'), $depth + $space);
                              
                        $tmpl->parse('tree_row_', 'tree_row_li_end', true);
                              
                  }
                  if($_GET["action"] == "page1" && !isset($_GET["idd"]))
                  {
                        $tmpl->set_var('tree_margin', $depth);
                        $tmpl->set_var('tree_idd', "0");
                        
                        $db2 = new DB__("select (max(structure.ord) + 1) as max from structure
                        where structure.root='0' and structure.id_menu='".$_GET["id"]."'");
                        if($db2->next_record())
                              $tmpl->set_var('tree_ord', $db2->f('max'));
                        else
                              $tmpl->set_var('tree_ord', "1");
                        
                        $tmpl->set_var('tree_name', "");
                        $tmpl->set_var('tree_ico', 'dir_open_blue');
                        $tmpl->set_var('js_onload', "document.getElementById('menu_name[0]').focus();");
                        $tmpl->parse('tree_row_', 'tree_row_edit', true);
                  }
                  $tmpl->parse('tree_row_', 'tree_row_ul_end', true);
                  
            }

////////////////////////////////////////////////////////////////////////////////////////////////

/*
            global $tmpl;
            $space = 15;
                       
            $tmpl->set_var('tree_ico_transp', "spacer");
            $tmpl->set_var('tree_id', $_GET["id"]);

            $db = new DB__("select structure.id, structure.id_menu, structure.name, structure.ord from structure
            where structure.root='$id' and structure.id_menu='".$_GET["id"]."'
            order by structure.ord");
                  
            $tmpl->set_var('tree_row_ul', '<ul class="ul_menu">');
            $tmpl->set_var('tree_row_ul_end', '</ul>');
            
            $tmpl->parse('tree_row_', 'tree_row_ul', true);
                  
            while($db->next_record())
            {
                  if(in_array($db->f('id'), $this->tab_roots) || $_GET["idd"] == $db->f('id'))
                        $inside = 1;
                  else
                        $inside = 0;
                        
                  $tmpl->set_var('tree_name', $db->f('name'));
                  if($inside == 1)
                        $tmpl->set_var('tree_ico', 'dir_open');
                  else
                        $tmpl->set_var('tree_ico', 'dir_close');                  
                        
                  
                  $tmpl->set_var('tree_margin',$depth);
                  $tmpl->set_var('tree_ord', $db->f('ord'));
                  $tmpl->set_var('tree_idd', $db->f('id'));
                                    
                  if($_GET["action"] == "edit_struct" && $_GET["idd"] == $db->f('id'))
                  {
                        $tmpl->set_var('tree_name', $db->f('name'));
                        $tmpl->set_var('js_onload', "document.getElementById('menu_name[".$_GET["idd"]."]').select();");
                        $tmpl->parse('tree_row_', 'tree_row_edit', true);
                  }
                  else
                        $tmpl->parse('tree_row_', 'tree_row', true);
                  
                  if($_GET["action"] == "unpage" && $_GET["idd"] == $db->f('id'))
                  {
                        
                        $tmpl->set_var('tree_margin',$depth + $space);
                        $tmpl->set_var('tree_idd', "0");
                        
                        $db2 = new DB__("select max(structure.ord) as max from structure
                        where structure.root='".$_GET["idd"]."'");
                        if($db2->next_record())
                              $tmpl->set_var('tree_ord', $db2->f('max') + 1);
                        
                        $tmpl->set_var('tree_name', "");
                        $tmpl->set_var('tree_ico', 'dir_open');
                        $tmpl->set_var('js_onload', "document.getElementById('menu_name[0]').focus();");
                        $tmpl->parse('tree_row_', 'tree_row_edit', true);
                  }
                  
                  if($inside == 1)
                        $this->show_menu($db->f('id'), $depth + $space);
            }
            
            if($_GET["action"] == "page1" && !isset($_GET["idd"]))
            {
                  
                  $tmpl->set_var('tree_margin', $depth);
                  $tmpl->set_var('tree_idd', "0");
                  
                  $db2 = new DB__("select max(structure.ord) as max from structure
                  where structure.root='0' and structure.id_menu='".$_GET["id"]."'");
                  if($db2->next_record())
                        $tmpl->set_var('tree_ord', $db2->f('max') + 1);
                  
                  $tmpl->set_var('tree_name', "");
                  $tmpl->set_var('tree_ico', 'dir_open');
                  $tmpl->set_var('js_onload', "document.getElementById('menu_name[0]').focus();");
                  $tmpl->parse('tree_row_', 'tree_row_edit', true);
            }
            $tmpl->parse('tree_row_', 'tree_row_ul_end', true);
*/
      }      
}


class Modul extends Baza
{
      public $count = 1;
      public $show_del = 1;
      public $show_add = 1;
      public $show_edit = 1;
      public $field_sort = null;
      public $field_asc = null;
      public $table = null;
      public $modul_name = null;
      public $modul_search = array();
      public $swf_mutli_upload_content = null;
      
      public $path_doc = PATH_DOC;
      public $path_img = PATH_IMG;
      
      function __construct()
      {
            if(!isset($_GET["lim"]))
                  $_GET["lim"] = 0;
                  
            if(isset($_GET["id"]))
                  $this->modul_name = $this->get_site_name($_GET["id"]);  
      }
      
      function del_registry($id, $idd, $field)
      {
            $db = new DB__("select ".$this->table.".$field from ".$this->table." where ".$this->table.".id='$idd'");
            if($db->next_record())
                  $this->registry("3", $id, $idd, " (".$db->f($field).")");
      }
    
      function del_rec_temp($idd, $id_field, $table)
      {
            new DB__("delete from $table where $id_field='$idd'");
      }
    
      function del_rec($idd, $id = null, $file = null, $photo = null)
      {
            if(isset($file))
                  $this->del_file($id, $idd);
            if(isset($photo))
                  $this->del_photo($id, $idd);
            new DB__("delete from ".$this->table." where id='$idd'");
      }
    
      function auto_del_rec($id, $date_field, $field, $file = null, $photo = null)
      {
            $db = new DB__("select id from ".$this->table." where $date_field < date_format(adddate(now(),-1),'%Y-%m-%d') and ($field = '' || $field = '-1')");
            while($db->next_record())
            {
                  if(isset($file))
                        $this->del_file($id, $db->f('id'));
                  if(isset($photo))
                        $this->del_photo($id, $db->f('id'));   
                                
                  new DB__("delete from ".$this->table." where id='".$db->f('id')."'");
            }
      }
      
      function auto_del_rec_multi($id, $date_field, $field, $table_temp, $file = null, $photo = null)
      {
            $db = new DB__("select id from ".$this->table." 
            left join $table_temp on ".$table_temp.".".$field."=".$this->table.".id
            where $date_field < date_format(adddate(now(),-1),'%Y-%m-%d') and ".$table_temp.".id_lang is null");
            while($db->next_record())
            {
                  if(isset($file))
                        $this->del_file($id, $db->f('id'));
                  if(isset($photo))
                        $this->del_photo($id, $db->f('id'));   
                                
                  new DB__("delete from ".$this->table." where id='".$db->f('id')."'");
            }
      }
    
      function del_file($id, $idd)
      {                  
            $db2 = new DB__("select template_menu.id_template from template_menu 
            where template_menu.id_menu='$id'");
            if($db2->next_record())
            {
                  $db3 = new DB__("select * from file 
                  where idd='$idd' and id_template='".$db2->f('id_template')."'");
                  while($db3->next_record())
                  {
                        if($db3->f('path'))
                              File::file_del($this->path_doc.$db3->f('path'));
                  }
                  new DB__("delete from file where idd='$idd' and id_template='".$db2->f('id_template')."'");
            }
      }
    
      function del_photo($id, $idd)
      {
                  
            $db2 = new DB__("select template_menu.id_template from template_menu 
            where template_menu.id_menu='$id'");
            if($db2->next_record())
            {
                  $db3 = new DB__("select * from photo 
                  where idd='$idd' and id_template='".$db2->f('id_template')."'");
                  while($db3->next_record())
                  {
                        if($db3->f('photo_m'))
                              File::file_del($this->path_img.$db3->f('photo_m'));
                        if($db3->f('photo_b'))
                              File::file_del($this->path_img.$db3->f('photo_b'));
                              
                        new DB__("delete from photo_lang where id_photo='".$db3->f('id')."'");
                  }
                  new DB__("delete from photo where idd='$idd' and id_template='".$db2->f('id_template')."'");
            }
      }
    
    
      function check_sort($field)
      {
            if(!isset($_GET["sort"]))
            {
                  if(isset($this->field_sort))
                        $_GET["sort"] = $this->field_sort;
                  else
                        $_GET["sort"] = $field;
                        
                  if(isset($this->field_asc))
                        $_GET["asc"] = $this->field_asc;
                  else
                        $_GET["asc"] = "asc";
            }
      }

      function search_sql($search)
      {
            $sql = "";
            if(isset($search))
            {
                  $this->modul_search = $search;
                  while(list($k, $v) = each($search))
                  {
                        if(isset($_GET[$k]))
                              if($_GET[$k] != "" && $_GET[$k] != "-1")
                              {
                                    if(isset($v[4]))
                                          $field = $v[4].".".$v[2];
                                    else
                                          $field = $v[2];
                                    
                                    if(isset($v[3]))
                                          if($v[3] == "date")
                                                $field = "date_format($field, '%Y-%m-%d')";
                                    
                                    
                                    if($v[1] == "like")
                                          $sql .= " and ".$field." ".$v[1]." '%".$_GET[$k]."%'";
                                    else
                                          $sql .= " and ".$field." ".$v[1]." '".$_GET[$k]."'";
                              }
                  }
            }
            return $sql;
      }
      
      function check_active()
      {
            if(isset($this->table))
            {
                  $db = new DB__("show columns from ".$this->table." where Field='active'");
                  if($db->nf())
                        return 1;
                  else
                        return null;
            }
      }

      function swf_mutli_upload($idd, $id_template, $mini_w = null, $mini_h = null)
      {
            $tmpl = new Template("htmls");
            $tmpl->set_file('blocks','modules_edit.html');
            $tmpl->set_block('blocks','modul_swfupload2');
            
            $tmpl->set_var('phpsession', session_id());
            $tmpl->set_var('file_old', $id_template);
            $tmpl->set_var('file_path', $this->path_img);
            $tmpl->set_var('file_div', "photo");      
            $tmpl->set_var('rand_id', $idd);      
            $tmpl->set_var('id_m', $_GET["id_m"]);      
            $tmpl->set_var('mini_w', $mini_w);      
            $tmpl->set_var('mini_h', $mini_h);      
            $tmpl->set_var('inp_name',"");
            $tmpl->set_var('file_size_limit', 20);
            $tmpl->set_var('file_upload_limit',100);
            $tmpl->set_var('file_queue_limit',99);
            $tmpl->set_var('upload_url', "\"../file_upload/upload_multi.php?file_old=\" + file_old + \"&mini_h=\" + mini_h + \"&mini_w=\" + mini_w + \"&rand_id=\" + rand_id + \"&get_id=\" + get_id + \"&file_path=\" + file_path");
            $tmpl->set_var('upload_success_handler',"uploadSuccess2");
            $tmpl->set_var('upload_complete_handler',"uploadComplete2");

            $this->swf_mutli_upload_content = $tmpl->subst('modul_swfupload2');            
      }
      
      function swf_mutli_upload_file($idd, $id_template, $mini_w = null, $mini_h = null, $id_lang)
      {
            $tmpl = new Template("htmls");
            $tmpl->set_file('blocks','modules_edit.html');
            $tmpl->set_block('blocks','modul_swfupload2');
            
            $tmpl->set_var('phpsession', session_id());
            $tmpl->set_var('file_old', $id_template);
            $tmpl->set_var('file_path', $this->path_doc);
            $tmpl->set_var('file_div', "files");      
            $tmpl->set_var('rand_id', $idd);      
            $tmpl->set_var('id_m', $_GET["id_m"]);      
            $tmpl->set_var('mini_w', "");      
            $tmpl->set_var('mini_h', "");      
            $tmpl->set_var('inp_name',"");
            $tmpl->set_var('file_size_limit', 200);
            $tmpl->set_var('file_upload_limit',100);
            $tmpl->set_var('file_queue_limit',99);
            $tmpl->set_var('upload_url', "\"../file_upload/upload_multi.php?type=doc&id_lang=".$id_lang."&file_old=\" + file_old + \"&mini_h=\" + mini_h + \"&mini_w=\" + mini_w + \"&get_id=\" + get_id + \"&rand_id=\" + rand_id + \"&file_path=\" + file_path");
            $tmpl->set_var('upload_success_handler',"uploadSuccess2");
            $tmpl->set_var('upload_complete_handler',"uploadComplete2");

            $this->swf_mutli_upload_content = $tmpl->subst('modul_swfupload2');
            
      }
      
      function swf_mutli_upload_mp3($idd, $id_template, $mini_w = null, $mini_h = null, $id_lang)
      {
            $tmpl = new Template("htmls");
            $tmpl->set_file('blocks','modules_edit.html');
            $tmpl->set_block('blocks','modul_swfupload2');
            
            $tmpl->set_var('phpsession', session_id());
            $tmpl->set_var('file_old', $id_template);
            $tmpl->set_var('file_path', $this->path_doc);
            $tmpl->set_var('file_div', "mp3");      
            $tmpl->set_var('rand_id', $idd);      
            $tmpl->set_var('mini_w', "");      
            $tmpl->set_var('mini_h', "");      
            $tmpl->set_var('inp_name',"");
            $tmpl->set_var('file_size_limit', 200);
            $tmpl->set_var('file_upload_limit',100);
            $tmpl->set_var('file_queue_limit',99);
            $tmpl->set_var('upload_url', "\"../file_upload/upload_multi.php?type=mp3&id_lang=".$id_lang."&file_old=\" + file_old + \"&mini_h=\" + mini_h + \"&mini_w=\" + mini_w + \"&rand_id=\" + rand_id + \"&file_path=\" + file_path");
            $tmpl->set_var('upload_success_handler',"uploadSuccess2");
            $tmpl->set_var('upload_complete_handler',"uploadComplete2");

            $this->swf_mutli_upload_content = $tmpl->subst('modul_swfupload2');
            
      }
      
      function create_table_mod($fields, $modul_sql, $type = "auto")
      {
            if(!isset($_GET["id_template"]))//$_GET["id"] == 323)
            {
                  if(!isset($_GET["no_ref"]))
                  {
                        if(strpos($_SERVER['HTTP_REFERER'], "action") !== false)
                        {
                              header("location: modules.php?".mb_ereg_replace("&amp;","&",$_SESSION["path_from_get"])."&no_ref=1");
                              exit;
                        }
                        else
                        {
                              $_SESSION["path_from_get"] = path_from_get();
                        }
                  }
                  else
                  {
                        $_SESSION["path_from_get"] = path_from_get();
                  }
                  //echo "<br/>".print_r(path_from_get(null, true));
                  
            }
            $tmpl = new Template("htmls");
            $tmpl->set_file('blocks','modules.html');
            $tmpl->set_block('blocks','table');
            $tmpl->set_block('blocks','modul_table');
            $tmpl->set_block('blocks','modul_no_table');
            $tmpl->set_block('blocks','modul_table_head_th');
            $tmpl->set_block('blocks','modul_table_row');
            $tmpl->set_block('blocks','modul_table_row_td');
            $tmpl->set_block('blocks','modul_table_a');
            $tmpl->set_block('blocks','modul_table_arrow');
            $tmpl->set_block('blocks','modul_photo_row');
            $tmpl->set_block('blocks','modul_photo');
           
            
            $tmpl->set_block('blocks','modul_scale');
            $tmpl->set_block('blocks','modul_search');
            $tmpl->set_block('blocks','modul_search_text');
            $tmpl->set_block('blocks','modul_search_date');
            $tmpl->set_block('blocks','modul_search_select');
            $tmpl->set_block('blocks','modul_search_select_option');
            $tmpl->set_block('blocks','modul_search_hidden');
            
            $tmpl->set_var('modul_search_', "");
            $tmpl->set_var('site', SITE_NAME);
            $tmpl->set_var('modul_w', W);
            $tmpl->set_var('modul_h', H);

            if(isset($this->swf_mutli_upload_content))
            {
                  $tmpl->set_var('swf_mutli_upload_content1', $this->swf_mutli_upload_content);  
                  $tmpl->parse('modul_search_', 'swf_mutli_upload_content1');
            }
            
            if(sizeof($this->modul_search))
            {
                  $tab_hidden = array();

                  reset($this->modul_search);
                  while(list($k, $v) = each($this->modul_search))
                  {
                        if(isset($v[3]))
                        {
                              if($v[3] == "date")
                              {
                                    $tmpl->set_var('modul_search_label', $v[0]);     
                                    $tmpl->set_var('modul_search_inp_name', $k); 
                                    if(isset($_GET[$k]))    
                                          $tmpl->set_var('modul_search_value', $_GET[$k]);  
                                    else        
                                          $tmpl->set_var('modul_search_value', "");  
                                    $tmpl->parse('modul_search_inp_', 'modul_search_date', true);                 
                              }
                              else
                              {
                                    $db = new DB__($v[3]);
                                    if($db->nf())
                                    {
                                          $tmpl->set_var('modul_search_label', $v[0]);     
                                          $tmpl->set_var('modul_search_inp_name', $k); 
                                          $tmpl->set_var('modul_search_select_option_', "");                 
                                          while($db->next_record())
                                          {
                                                $tmpl->set_var('modul_search_option_value', $db->f('id')); 
                                                $tmpl->set_var('modul_search_option_text', $db->f('sel_name')); 
                                                if(isset($_GET[$k]))    
                                                      if($db->f('id') == $_GET[$k])
                                                            $tmpl->set_var('modul_search_option_selected', " selected=\"true\""); 
                                                      else
                                                            $tmpl->set_var('modul_search_option_selected', ""); 
                                                else
                                                      $tmpl->set_var('modul_search_option_selected', ""); 
                                                $tmpl->parse('modul_search_select_option_', 'modul_search_select_option', true);                 
                                          }
                                          $tmpl->parse('modul_search_inp_', 'modul_search_select', true);     
                                    }
                              }            
                        }
                        else
                        {
                              $tmpl->set_var('modul_search_label', $v[0]);     
                              $tmpl->set_var('modul_search_inp_name', $k); 
                              if(isset($_GET[$k]))    
                                    $tmpl->set_var('modul_search_value', $_GET[$k]);  
                              else        
                                    $tmpl->set_var('modul_search_value', "");  
                              $tmpl->parse('modul_search_inp_', 'modul_search_text', true);                 
                        }
                        $tab_hidden[] = $k;
                  }
                  $tab_hidden[] = "search_go";
                  $tab_hidden = path_from_get($tab_hidden, 1);


                  while(list($k, $v) = each($tab_hidden))
                  {
                        $tmpl->set_var('modul_search_inp_name', $k);     
                        $tmpl->set_var('modul_search_value', $v);     
                        $tmpl->parse('modul_search_hidden_', 'modul_search_hidden', true);  
                  }
                  
                  $tmpl->parse('modul_search_', 'modul_search',true);        
            }

            if(isset($_GET["id"]))
                  $modul_id_str = "id=".$_GET["id"];
            else if(isset($_GET["str"]))
                  $modul_id_str = "str=".$_GET["str"];
            if(isset($_GET["id_m"]))      
                  $modul_id_str .= "&amp;id_m=".$_GET["id_m"];
            if(isset($_GET["idd_m"]))      
                  $modul_id_str .= "&amp;idd_m=".$_GET["idd_m"];
            if(isset($_GET["id_lang"]))      
                  $modul_id_str .= "&amp;id_lang=".$_GET["id_lang"];
            if(isset($_GET["mini_w"]))      
                  $modul_id_str .= "&amp;mini_w=".$_GET["mini_w"];
            if(isset($_GET["mini_h"]))      
                  $modul_id_str .= "&amp;mini_h=".$_GET["mini_h"];
            if(isset($_GET["id_template"]))      
                  $modul_id_str .= "&amp;id_template=".$_GET["id_template"];
                  
            $tmpl->set_var('modul_id_str', $modul_id_str);     
            $tmpl->set_var('modul_name', $this->modul_name);  
                   
            if(isset($this->show_add))
            {
                  $tmpl->set_var('modul_a_href', "javascript:modules_link('".$modul_id_str."&amp;action=edit', '".W."', '".H."');");  
                  $tmpl->set_var('modul_a_name', "[dodaj nowy]");              
                  $tmpl->parse('modul_new', 'modul_table_a');  
            } 
            else    
                  $tmpl->set_var('modul_new', "[dodaj nowy]");    

            $db = new DB__($modul_sql);
            if($db->nf())
            {
                  $lp = 0; 
                  if(isset($this->count))
                  {
                        if(isset($_GET["search_go"]))
                        {
                              $_GET["lim"] = 0;
                              $_GET["search_go"] = null;
                        }
                        if(!isset($_GET["lim"]) || isset($_GET["search_go"]))
                        {
                              $lp = 0;
                        }
                        else
                              $lp = $_GET["lim"]*LINKS;
                        $db->seek($lp);
                  }
                  
                  $tmpl->set_var('modul_ile', $db->nf());         
                       
                  $modul_tab = array("sort","asc");
                  $modul_path = path_from_get($modul_tab);         
      
                  $active = $this->check_active();
                  if(isset($active))
                  {
                        $fields[0][] = "Aktywny";
                        $fields[1][] = "active";
                        $fields[2][sizeof($fields[1]) - 1] = "1%";
                  }
                  
                  if($type == "auto")
                  {
                        while(list($k, $v) = each($fields[0]))
                        {
                              $tmpl->set_var('modul_th_arrow', ""); 
                              
                              if(!isset($_GET["sort"]))
                                    $_GET["sort"] = null;
                                      
                              if($fields[1][$k] == $_GET["sort"])
                              {
                                    if($_GET["asc"] == "asc")
                                    {
                                          $tmpl->set_var('modul_arrow', "arrow_up.gif"); 
                                          $tmpl->parse('modul_th_arrow', 'modul_table_arrow'); 
                                          $modul_asc = "desc";
                                    }
                                    else
                                    {
                                          $tmpl->set_var('modul_arrow', "arrow_down.gif"); 
                                          $tmpl->parse('modul_th_arrow', 'modul_table_arrow'); 
                                          $modul_asc = "asc";
                                    }
                              }
                              else
                                    $modul_asc = "asc";
                              
                              $tmpl->set_var('modul_a_href', "modules.php?".$modul_path."&amp;sort=".$fields[1][$k]."&amp;asc=".$modul_asc);              
                              $tmpl->set_var('modul_a_name', $v);              
                              $tmpl->parse('modul_th_name', 'modul_table_a');  
      
                              if(isset($fields[2][$k]))
                                    $tmpl->set_var('modul_th_options', " style=\"width:".$fields[2][$k].";\"");              
                              else
                                    $tmpl->set_var('modul_th_options', "");              
                              
                              $tmpl->parse('th_', 'modul_table_head_th',true);  
                        }
                  }
                  else
                        $tmpl->set_var('th_',  "");  
                                  
                  while($db->next_record())
                  {
                        $lp++;
                        
                        if($type != "auto")
                        {
                              $tmpl->set_var('modul_img_id', $db->f('id'));              
                              $tmpl->set_var('modul_img_ord', $db->f('ord'));              
                              $tmpl->set_var('modul_img_src', PATH_IMG.$db->f('photo_m'));              
                              $tmpl->set_var('modul_img_edit', "javascript:modules_link('".$modul_id_str."&amp;idd=".$db->f('id')."&amp;action=edit', '".W."', '".H."');void(0);");              
                              $tmpl->set_var('modul_img_del', "javascript:if(confirm('Jesteś pewien? Kasujesz rekord bezpowrotnie.'))location.href='modules.php?".$modul_id_str."&amp;idd=".$db->f('id')."&amp;action=del';void(0);");       
                              $tmpl->parse('modul_photo_row_', 'modul_photo_row',true);  
                        }
                        else
                        {
      
                              $tmpl->set_var('modul_td_name', $lp);              
                              $tmpl->parse('td_', 'modul_table_row_td');  
                              
                              reset($fields[1]);
                              while(list($kk, $vv) = each($fields[1]))
                              {
                                    if($vv == "active" && 1 == $db->f($vv))
                                          $tmpl->set_var('modul_td_name', "tak");              
                                    else if($vv == "active" && 0 == $db->f($vv))
                                          $tmpl->set_var('modul_td_name', "<b>nie</b>");                                           
                                    else
                                          $tmpl->set_var('modul_td_name', $db->f($vv));   
                                          
                                    if(isset($this->show_edit))  
                                          $tmpl->set_var('modul_td_options', " onclick=\"modules_link('".$modul_id_str."&amp;idd=".$db->f('id')."&amp;action=edit', '".W."', '".H."');\" onmouseover=\"this.style.cursor='pointer';\"");  
                                    else
                                          $tmpl->set_var('modul_td_options', "");       
                  
                                    $tmpl->parse('td_', 'modul_table_row_td',true);  
                              }
      
                              if(isset($this->show_edit))
                              {
                                    $tmpl->set_var('modul_a_href', "javascript:modules_link('".$modul_id_str."&amp;idd=".$db->f('id')."&amp;action=edit', '".W."', '".H."');");  
                                    $tmpl->set_var('modul_a_name', "[edytuj]");              
                                    $tmpl->parse('modul_td_name', 'modul_table_a');  
                                    $tmpl->set_var('modul_td_options', "");       
                                    $tmpl->parse('td_', 'modul_table_row_td',true);  
                              } 
                              else   
                              { 
                                    $tmpl->set_var('modul_td_name', "[edytuj]");              
                                    $tmpl->set_var('modul_td_options', "");       
                                    $tmpl->parse('td_', 'modul_table_row_td',true);  
                              }   
                              
                              if(isset($this->show_del))
                              {
                                    $tmpl->set_var('modul_a_href', "javascript:if(confirm('Jesteś pewien? Kasujesz rekord bezpowrotnie.'))location.href='modules.php?".$modul_id_str."&amp;idd=".$db->f('id')."&amp;action=del';void(0);");  
                                    $tmpl->set_var('modul_a_name', "[usuń]");              
                                    $tmpl->parse('modul_td_name', 'modul_table_a');  
                                    $tmpl->set_var('modul_td_options', "");       
                                    $tmpl->parse('td_', 'modul_table_row_td',true);  
                              } 
                              else   
                              { 
                                    $tmpl->set_var('modul_td_name', "[usuń]");              
                                    $tmpl->set_var('modul_td_options', "");       
                                    $tmpl->parse('td_', 'modul_table_row_td',true);  
                              }   
                                       
                              $tmpl->parse('tr_', 'modul_table_row',true);  
                              
                              if(($lp >= $_GET["lim"]*LINKS + LINKS) && isset($this->count))
                                    break;
                        }
                  }
                  $sc = show_scale_cms($db->nf(), LINKS);
                  if(isset($this->count) && isset($sc))
                  {
                        $tmpl->set_var('scale', $sc);
                        $tmpl->parse('scale_', 'modul_scale');
                  }
                  else
                        $tmpl->set_var('scale_', "");
                                    
                  if($type == "auto")
                        $tmpl->parse('modules_', 'modul_table');
                  else
                        $tmpl->parse('modules_', 'modul_photo');
            }
            else
            {
                  $tmpl->set_var('modul_ile', 0);         
                  $tmpl->parse('modules_', 'modul_no_table');
                  $tmpl->set_var('scale_', "");
            }
            $tmpl->psubst('table');
      }
}

?><?
class File
{
      public $tab_file_ext = array();
      
      private $temp_tab = array();
      public $path;
      function __construct()
      {
            mb_internal_encoding("UTF-8");
            $this->set_file_extensions();
      }
      
      function set_file_extensions()
      {
            $inc = 0;
            $db_f = new DB__("select type.*, type_category.name as rodzaj from type 
            left join type_category on type_category.id=type.id_type 
            group by type.id 
            order by type_category.name, type.name");
            while($db_f->next_record())
            {
                  $this->tab_file_ext[$db_f->f('rodzaj')][0][$inc] = $db_f->f('name');
                  $this->tab_file_ext[$db_f->f('rodzaj')][1][$inc] = $db_f->f('ico');
                  $inc++;           
            }   
      }
   
      function convert($str)
      {
            $str = mb_ereg_replace("А", "A", $str);
            $str = mb_ereg_replace("а", "a", $str);
            $str = mb_ereg_replace("Б", "B", $str);
            $str = mb_ereg_replace("б", "b", $str);
            $str = mb_ereg_replace("В", "W", $str);
            $str = mb_ereg_replace("в", "w", $str);
            $str = mb_ereg_replace("Г", "G", $str);
            $str = mb_ereg_replace("г", "g", $str);
            $str = mb_ereg_replace("Д", "D", $str);
            $str = mb_ereg_replace("д", "d", $str);
            $str = mb_ereg_replace("Е", "Je", $str);
            $str = mb_ereg_replace("е", "je", $str);
            $str = mb_ereg_replace("Ё", "Jo", $str);
            $str = mb_ereg_replace("ё", "jo", $str);
            $str = mb_ereg_replace("Ж", "Z", $str);
            $str = mb_ereg_replace("ж", "z", $str);
            $str = mb_ereg_replace("З", "Z", $str);
            $str = mb_ereg_replace("з", "z", $str);
            $str = mb_ereg_replace("И", "I", $str);
            $str = mb_ereg_replace("и", "i", $str);
            $str = mb_ereg_replace("Й", "J", $str);
            $str = mb_ereg_replace("й", "j", $str);
            $str = mb_ereg_replace("К", "K", $str);
            $str = mb_ereg_replace("к", "k", $str);
            $str = mb_ereg_replace("Л", "L", $str);
            $str = mb_ereg_replace("л", "l", $str);
            $str = mb_ereg_replace("М", "M", $str);
            $str = mb_ereg_replace("м", "m", $str);
            $str = mb_ereg_replace("Н", "N", $str);
            $str = mb_ereg_replace("н", "n", $str);
            $str = mb_ereg_replace("О", "O", $str);
            $str = mb_ereg_replace("о", "o", $str);
            $str = mb_ereg_replace("П", "P", $str);
            $str = mb_ereg_replace("п", "p", $str);
            $str = mb_ereg_replace("Р", "R", $str);
            $str = mb_ereg_replace("р", "r", $str);
            $str = mb_ereg_replace("С", "S", $str);
            $str = mb_ereg_replace("с", "s", $str);
            $str = mb_ereg_replace("Т", "T", $str);
            $str = mb_ereg_replace("т", "t", $str);
            $str = mb_ereg_replace("У", "U", $str);
            $str = mb_ereg_replace("у", "u", $str);
            $str = mb_ereg_replace("ф", "F", $str);
            $str = mb_ereg_replace("Ф", "f", $str);
            $str = mb_ereg_replace("Х", "Ch", $str);
            $str = mb_ereg_replace("х", "ch", $str);
            $str = mb_ereg_replace("Ц", "C", $str);
            $str = mb_ereg_replace("ц", "c", $str);
            $str = mb_ereg_replace("Ч", "Cz", $str);
            $str = mb_ereg_replace("ч", "cz", $str);
            $str = mb_ereg_replace("Ш", "Sz", $str);
            $str = mb_ereg_replace("ш", "sz", $str);
            $str = mb_ereg_replace("Щ", "Szcz", $str);
            $str = mb_ereg_replace("щ", "szcz", $str);
            $str = mb_ereg_replace("Ы", "Y", $str);
            $str = mb_ereg_replace("ы", "y", $str);
            $str = mb_ereg_replace("Э", "E", $str);
            $str = mb_ereg_replace("э", "e", $str);
            $str = mb_ereg_replace("Ю", "Ju", $str);
            $str = mb_ereg_replace("ю", "ju", $str);
            $str = mb_ereg_replace("Я", "Ja", $str);
            $str = mb_ereg_replace("я", "ja", $str);

            $str = mb_ereg_replace("Ä", "A", $str);
            $str = mb_ereg_replace("ä", "a", $str);
            $str = mb_ereg_replace("Ö", "O", $str);
            $str = mb_ereg_replace("ö", "o", $str);
            $str = mb_ereg_replace("Ü", "U", $str);
            $str = mb_ereg_replace("ü", "u", $str);
            $str = mb_ereg_replace("ß", "ss", $str);
            $str = mb_ereg_replace(' ', '_', $str);
            $str = mb_ereg_replace("Ą", "A", $str);
            $str = mb_ereg_replace("ą", "a", $str);
            $str = mb_ereg_replace("Ś", "S", $str);
            $str = mb_ereg_replace("ś", "s", $str);
            $str = mb_ereg_replace("Ń", "N", $str);
            $str = mb_ereg_replace("ń", "n", $str);
            $str = mb_ereg_replace("Ł", "L", $str);
            $str = mb_ereg_replace("ł", "l", $str);
            $str = mb_ereg_replace("Ę", "E", $str);
            $str = mb_ereg_replace("ę", "e", $str);
            $str = mb_ereg_replace("Ó", "O", $str);
            $str = mb_ereg_replace("ó", "o", $str);
            $str = mb_ereg_replace("Ć", "C", $str);
            $str = mb_ereg_replace("ć", "c", $str);
            $str = mb_ereg_replace("Ź", "Z", $str);
            $str = mb_ereg_replace("Ż", "Z", $str);
            $str = mb_ereg_replace("ź", "z", $str);
            $str = mb_ereg_replace("ż", "z", $str);
            
            for($i=0;$i<mb_strlen($str);$i++)
            {
                  if(!($str[$i] == "." || ($str[$i] >= "0" && $str[$i] <= "9") || ($str[$i] >= "A" && $str[$i] <= "Z") || $str[$i] == "_" || ($str[$i] >= "a" && $str[$i] <= "z")))
                  $str[$i] = "x";
            }
            return $str;
      }

      function search_in_arr($ext)
      {
            if(sizeof($this->tab_file_ext))
            {
                  reset($this->tab_file_ext);
                  while(list($k,$l)=each($this->tab_file_ext))
                  {
                        while(list($kk,$ll)=each($this->tab_file_ext[$k]))
                        {
                              if(in_array($ext, $this->tab_file_ext[$k][0]))
                                    return true;
                        }
                  }
            }
            return false;
      }

      static function file_del($file)
      {
            if(file_exists($file))
                  unlink($file);
            else
                  echo "Error";
      }

      function file_upload($file, $file_name, $ext = null)
      {
            if(is_uploaded_file($file))
            {
                  $file_name = mb_strtolower($file_name);
                  $file_name = $this->convert($file_name);
                  
                  $extension = mb_substr($file_name, mb_strrpos($file_name,".")+1);
                  if(!$this->search_in_arr($extension) && isset($ext))
                  {
                        echo "Error";
                        return false;
                  }
                  
                  if(mb_strlen($file_name) > 25)
                        $file_name = mb_substr(mb_substr($file_name,0,mb_strrpos($file_name,".")), 0, 25).".".$extension;

                  $file_name = $this->check_file_exist($file_name, $this->path);                  
                  
                  move_uploaded_file($file, $this->path.$file_name);
                  chmod($this->path.$file_name, 0777);
                  return $file_name;            
            }
            else
                  return null;
      }

      function check_file_exist($file, $path)
      {
            if(file_exists($path.$file))
            {
                  $file_name = $file;
                  while(1)
                  {
                        $handler = file_exists($path.$file_name);
                        if($handler)
                        {
                              $ext = mb_substr($file_name, mb_strrpos($file_name,"."));
                              $ff = mb_substr($file_name, 0, mb_strrpos($file_name,"."));
                              $file_name = $ff.rand(0,9).$ext;
                        }
                        else
                             return $file_name;
                  }
            }
            else
                  return $file;
      }


      function make_menu_img($path, $text, $name, $font, $size)
      {
            $baseline = 4;             
            $test_y_text = '`QWERTYUIOPASDFGHJKLZXCVBNMQYJqyjŃńŚśĆćŹźŻżŁłĘęÓóĄą';
            $font_size = $size;
            
            $bbox_y = imagettfbbox($font_size, 0, $font, $test_y_text);
            $bbox_x = imagettfbbox($font_size, 0, $font, $text);
            
            $w_font = $bbox_x[2] - $bbox_x[0];
            $h_font = ($bbox_y[1] - $bbox_y[5])*2;//podwijne obrazki
            

            $im1 = imagecreatetruecolor($w_font + $baseline/2, $h_font + $baseline + 2);//+2 dwie krechy dla transparenta
            
            $gray = imagecolorallocate($im1, 255, 255, 255);//fuji
            $white = imagecolorallocate($im1, 77, 77, 77);//fuji
            $black = imagecolorallocate($im1, 0, 0, 0);//fuji
            $orange = imagecolorallocate($im1, 0, 115, 41);//#65C9E1
            
            
            imagesavealpha($im1, true);
            imagealphablending($im1, false);
            
            $tlo = imagecolorallocatealpha($im1, 220, 220, 220, 127);
            imagefill($im1, 0, 0, $tlo);
            //imagecolortransparent($im1, $black);//fuji
                
            imagettftext($im1, $font_size, 0, 0, $h_font + 1, $orange, $font, $text);
            imagettftext($im1, $font_size, 0, 0, $h_font/2 - $baseline/2 + 1, $white, $font, $text);
            imageline($im1, 0, 0, 1, 0, $gray);
            imageline($im1, $w_font + $baseline/2 - 1, $h_font + $baseline + 1, $w_font + $baseline/2, $h_font + $baseline + 1, $gray);
            
            $file = File::convert($name);
            $f = array();
            $f[0] = $file.".png";
            imagepng($im1, $path.$f[0]);
            imagedestroy($im1);
            return $f;
      }
      
      function make_menu_img2($path, $text, $name, $font, $size)
      {
            $baseline = 4;             
            $test_y_text = '`QWERTYUIOPASDFGHJKLZXCVBNMQYJqyjŃńŚśĆćŹźŻżŁłĘęÓóĄą';
            $font_size = $size;
            
            $bbox_y = imagettfbbox($font_size, 0, $font, $test_y_text);
            $bbox_x = imagettfbbox($font_size, 0, $font, $text);
            
            $w_font = $bbox_x[2] - $bbox_x[0];
            $h_font = ($bbox_y[1] - $bbox_y[5]);//podwijne obrazki
            

            $im1 = imagecreatetruecolor($w_font + $baseline/2, $h_font + $baseline + 2);//+2 dwie krechy dla transparenta
            
            $gray = imagecolorallocate($im1, 22, 22, 22);//fuji
            $white = imagecolorallocate($im1, 255, 255, 255);//fuji
            $black = imagecolorallocate($im1, 0, 0, 0);//fuji
            $orange = imagecolorallocate($im1, 253, 59, 0);//##4983C5
            
            
            imagesavealpha($im1, true);
            imagealphablending($im1, false);
            
            $tlo = imagecolorallocatealpha($im1, 220, 220, 220, 127);
            imagefill($im1, 0, 0, $tlo);
            //imagecolortransparent($im1, $black);//fuji
                
            imagettftext($im1, $font_size, 0, 0, $h_font + 1, $orange, $font, $text);
            imageline($im1, 0, 0, 1, 0, $white);
            imageline($im1, $w_font + $baseline/2 - 1, $h_font + $baseline + 1, $w_font + $baseline/2, $h_font + $baseline + 1, $white);
            
            $file = File::convert($name);
            $f = array();
            $f[0] = $file.".png";
            imagepng($im1, $path.$f[0]);
            imagedestroy($im1);
            return $f;
      }

      function make_menu_img4($path, $text, $name, $font, $size)
      {
            $baseline = 4;             
            $test_y_text = '`QWERTYUIOPASDFGHJKLZXCVBNMQYJqyjŃńŚśĆćŹźŻżŁłĘęÓóĄą';
            $font_size = $size;
            
            $bbox_y = imagettfbbox($font_size, 0, $font, $test_y_text);
            $bbox_x = imagettfbbox($font_size, 0, $font, $text);
            
            $w_font = $bbox_x[2] - $bbox_x[0];
            $h_font = ($bbox_y[1] - $bbox_y[5]);//podwijne obrazki
            

            $im1 = imagecreatetruecolor($w_font + $baseline/2, $h_font + $baseline + 2);//+2 dwie krechy dla transparenta
            
            $gray = imagecolorallocate($im1, 22, 22, 22);//fuji
            $white = imagecolorallocate($im1, 255, 255, 255);//fuji
            $black = imagecolorallocate($im1, 0, 0, 0);//fuji
            $orange = imagecolorallocate($im1, 252, 214, 001);//##4983C5
            
            
            imagesavealpha($im1, true);
            imagealphablending($im1, false);
            
            $tlo = imagecolorallocatealpha($im1, 220, 220, 220, 127);
            imagefill($im1, 0, 0, $tlo);
            //imagecolortransparent($im1, $black);//fuji
                
            imagettftext($im1, $font_size, 0, 0, $h_font + 1, $orange, $font, $text);
            imageline($im1, 0, 0, 1, 0, $white);
            imageline($im1, $w_font + $baseline/2 - 1, $h_font + $baseline + 1, $w_font + $baseline/2, $h_font + $baseline + 1, $white);
            
            $file = File::convert($name);
            $f = array();
            $f[0] = $file.".png";
            imagepng($im1, $path.$f[0]);
            imagedestroy($im1);
            return $f;
      }

      function make_menu_img3($path, $text, $name, $font, $size)
      {
            $baseline = 4;             
            $test_y_text = '`QWERTYUIOPASDFGHJKLZXCVBNMQYJqyjŃńŚśĆćŹźŻżŁłĘęÓóĄą';
            $font_size = $size;
            
            $bbox_y = imagettfbbox($font_size, 0, $font, $test_y_text);
            $bbox_x = imagettfbbox($font_size, 0, $font, $text);
            
            $w_font = $bbox_x[2] - $bbox_x[0];
            $h_font = ($bbox_y[1] - $bbox_y[5]);//podwijne obrazki
            

            $im1 = imagecreatetruecolor($w_font + $baseline/2, $h_font + $baseline + 2);//+2 dwie krechy dla transparenta
            
            $gray = imagecolorallocate($im1, 22, 22, 22);//fuji
            $white = imagecolorallocate($im1, 255, 255, 255);//fuji
            $black = imagecolorallocate($im1, 0, 0, 0);//fuji
            //$orange = imagecolorallocate($im1, 252, 214, 001);//zolty
            $orange = imagecolorallocate($im1, 40, 94, 45);//#285E2D - zielony
            
            
            imagesavealpha($im1, true);
            imagealphablending($im1, false);
            
            $tlo = imagecolorallocatealpha($im1, 220, 220, 220, 127);
            imagefill($im1, 0, 0, $tlo);
            //imagecolortransparent($im1, $black);//fuji
                
            imagettftext($im1, $font_size, 0, 0, $h_font + 1, $orange, $font, $text);
            imageline($im1, 0, 0, 1, 0, $white);
            imageline($im1, $w_font + $baseline/2 - 1, $h_font + $baseline + 1, $w_font + $baseline/2, $h_font + $baseline + 1, $white);
            
            $file = File::convert($name);
            $f = array();
            $f[0] = $file.".png";
            imagepng($im1, $path.$f[0]);
            imagedestroy($im1);
            return $f;
      }

      function make_menu_img_box($path, $text, $name, $font)
      {
            $baseline = 4; //przesuniecie do gory napisu - zalezne od baseline, dlatego ze wyswietlajac text ustawiamy lewy dolny px
            $test_y_text = '`QWERTYUIOPASDFGHJKLZXCVBNMQYJqyjŃńŚśĆćŹźŻżŁłĘęÓóĄą';
            //$test_y_text = '0123456789/- ';
            $font_size = 18;
            
            //testowy text do okreslenia max. wysokosci
            $bbox_y = imagettfbbox($font_size, 0, $font, $test_y_text);
            $bbox_x = imagettfbbox($font_size, 0, $font, $text);
            
            $w_font = $bbox_x[2] - $bbox_x[0] + 10;
            $h_font = $bbox_y[1] - $bbox_y[5];
            

            $im1 = imagecreatetruecolor($w_font + $baseline/2, $h_font + $baseline/2);
            
            $black = imagecolorallocate($im1, 0, 0, 0);
            imagecolortransparent($im1, $black);
            //#BC9C5E
            $font_color1 = imagecolorallocate($im1, 188, 156, 94);
            
            //imagefilledrectangle($im1, 0, 0, $w_font + $baseline/2, $h_font + $baseline/2, $white1);
            
            imagettftext($im1, $font_size, 0, 0, $h_font - $baseline, $font_color1, $font, $text);
            
            $file = File::convert($name);
            $f = array();
            $f[0] = File::check_file_exist($file.".png", $path);
            imagepng($im1, $path.$f[0]);
            imagedestroy($im1);
            return $f;
      }

/*
      function show_foto($path, $photo, $table = null, $id = null, $w = null, $h = null)
      {
            $photo_div = "war_foto";
            $tmpl = new Template("htmls");
            $tmpl->set_file('blocks','war_photo.html');
            $tmpl->set_block('blocks','table_photo');
            $tmpl->set_block('blocks','table_text');
            $tmpl->set_block('blocks','table_empty');
            $tmpl->set_block('blocks','table_next');
            $tmpl->set_block('blocks','table_left');
            $tmpl->set_block('blocks','table_right');

            $tmpl->set_var('photo_div', $photo_div);
            $tmpl->set_var('photo_path', $path);
            $tmpl->set_var('photo_table', $table);
            $next = 0;
            if(file_exists($path.$photo))
            {
                  //$img_size_main = getImageSize($path.$photo);
                  $tmpl->set_var('photo_img_main', $path.$photo);
                  //$tmpl->set_var('photo_w_main', $img_size_main[0]);
                  //$tmpl->set_var('photo_h_main', $img_size_main[1]);
                  $tmpl->set_var('photo_w_main', $w);
                  $tmpl->set_var('photo_h_main', $h);
                  
                  $tmpl->set_var('photo_nr', 1);
                  $tmpl->set_var('photo_max', 1);
                  $tmpl->set_var('left', "");
                  $tmpl->set_var('right', "");
                  $tmpl->set_var('text_', "");
                  if(isset($table) && isset($id))
                  {
                        $db = new DB__("select $table.*, ".$table."_lang.text from $table 
                        left join ".$table."_lang on ".$table."_lang.id_photo=photo.id and photo_lang.id_lang in (".$_SESSION["id_language"].", 0)
                        where id='$id'");
                        if($db->next_record())
                        {                        
                              $tmpl->set_var('photo_nr', $db->f('ord'));
                              if($db->f('text')) 
                              {
                                    $tmpl->set_var('text', $db->f('text'));
                                    $tmpl->parse('text_', 'table_text',true);
                              }
                              else
                                    $tmpl->set_var('text_', "");
                                    
                              $db2 = new DB__("select $table.id, $table.photo_b, ".$table."_lang.text from $table 
                              left join ".$table."_lang on ".$table."_lang.id_photo=photo.id and photo_lang.id_lang in (".$_SESSION["id_language"].", 0)
                              where $table.id_template='".$db->f('id_template')."' and $table.idd='".$db->f('idd')."' and $table.ord < '".$db->f('ord')."' and $table.photo_b != '' and $table.active='1' 
                              order by $table.ord desc");
                              if($db2->next_record())
                              {
                                    $img_size = getImageSize($path.$db2->f('photo_b'));
                                    $img_h = $img_size[1];
                                    $tmpl->set_var('photo_w', $img_size[0]);
                                    $tmpl->set_var('photo_h', $img_h);
                                    $tmpl->set_var('photo_id', $db2->f('id'));
                                    $tmpl->set_var('photo_img', $db2->f('photo_b'));
                                    $tmpl->parse('left','table_left');
                                    $next++;
                              }
                              else
                                    $tmpl->set_var('left',"");

                              $db2 = new DB__("select $table.id, $table.photo_b, ".$table."_lang.text from $table 
                              left join ".$table."_lang on ".$table."_lang.id_photo=photo.id and photo_lang.id_lang in (".$_SESSION["id_language"].", 0)
                              where $table.id_template='".$db->f('id_template')."' and $table.idd='".$db->f('idd')."' and $table.ord > '".$db->f('ord')."' and $table.photo_b != '' and $table.active='1' 
                              order by $table.ord");
                              if($db2->next_record())
                              {
                                    $img_size = getImageSize($path.$db2->f('photo_b'));
                                    $img_h = $img_size[1];
                                    $tmpl->set_var('photo_w', $img_size[0]);
                                    $tmpl->set_var('photo_h', $img_h);                                    
                                    $tmpl->set_var('photo_id', $db2->f('id'));
                                    $tmpl->set_var('photo_img', $db2->f('photo_b'));
                                    $tmpl->parse('right', 'table_right');
                                    $next++;
                              }
                              else
                                    $tmpl->set_var('right', "");
                                    
                              $db2 = new DB__("select $table.id from $table 
                              left join ".$table."_lang on ".$table."_lang.id_photo=photo.id and photo_lang.id_lang in (".$_SESSION["id_language"].", 0)
                              where $table.id_template='".$db->f('id_template')."' and $table.idd='".$db->f('idd')."' and $table.photo_b != '' and $table.active='1'");

                              if($db2->nf())
                                    $tmpl->set_var('photo_max', $db2->nf());
                        }
                  }
            }
            else
                  $tmpl->parse('photo_', 'table_empty', true);
            
            return $tmpl->psubst('table_photo');
      }
*/
      function show_foto($path, $photo, $table = null, $id = null, $w = null, $h = null, $photo_div = "war_foto")
      {
            $tmpl = new Template("htmls");
            $tmpl->set_file('blocks','war_photo.html');
            $tmpl->set_block('blocks','table_photo');
            $tmpl->set_block('blocks','table_text');
            $tmpl->set_block('blocks','table_empty');
            $tmpl->set_block('blocks','table_next');
            $tmpl->set_block('blocks','table_left');
            $tmpl->set_block('blocks','table_right');

            $tmpl->set_var('photo_div', $photo_div);
            $tmpl->set_var('photo_path', $path);
            $tmpl->set_var('photo_table', $table);
            $next = 0;
            if(file_exists($path.$photo))
            {
                  //$img_size_main = getImageSize($path.$photo);
                  $tmpl->set_var('photo_img_main', $path.$photo);
                  //$tmpl->set_var('photo_w_main', $img_size_main[0]);
                  //$tmpl->set_var('photo_h_main', $img_size_main[1]);
                  $tmpl->set_var('photo_w_main', $w);
                  $tmpl->set_var('photo_h_main', $h);
                  $tmpl->set_var('photo_id', $id);
                  
                  $tmpl->set_var('photo_nr', 1);
                  $tmpl->set_var('photo_max', 1);
                  $tmpl->set_var('left', "");
                  $tmpl->set_var('right', "");
                  $tmpl->set_var('text_', "");
                  if(isset($table) && isset($id))
                  {
                        $db = new DB__("select $table.*, ".$table."_lang.text from $table 
                        left join ".$table."_lang on ".$table."_lang.id_photo=photo.id and photo_lang.id_lang in (".$_SESSION["id_language"].", 0)
                        where id='$id'");
                        if($db->next_record())
                        {                        
                              $tmpl->set_var('photo_nr', $db->f('ord'));
                              if($db->f('text')) 
                              {
                                    $tmpl->set_var('text', $db->f('text'));
                                    $tmpl->set_var('photo_alt', $db->f('text'));
                                    $tmpl->parse('text_', 'table_text',true);
                              }
                              else
                                    $tmpl->set_var('text_', "");
                                    
                              $db2 = new DB__("select $table.id, $table.photo_b, ".$table."_lang.text from $table 
                              left join ".$table."_lang on ".$table."_lang.id_photo=photo.id and photo_lang.id_lang in (".$_SESSION["id_language"].", 0)
                              where $table.id_template='".$db->f('id_template')."' and $table.idd='".$db->f('idd')."' and $table.ord < '".$db->f('ord')."' and $table.photo_b != '' and $table.active='1' 
                              order by $table.ord desc");
                              if($db2->next_record())
                              {
                                    $img_size = getImageSize($path.$db2->f('photo_b'));
                                    $img_h = $img_size[1];
                                    $tmpl->set_var('photo_w', $img_size[0]);
                                    $tmpl->set_var('photo_h', $img_h);
                                    $tmpl->set_var('photo_id', $db2->f('id'));
                                    $tmpl->set_var('photo_img', $db2->f('photo_b'));
                                    $tmpl->set_var('photo_alt', $db2->f('text'));
                                    $tmpl->parse('left','table_left');
                                    $next++;
                              }
                              else
                                    $tmpl->set_var('left',"");

                              $db2 = new DB__("select $table.id, $table.photo_b, ".$table."_lang.text from $table 
                              left join ".$table."_lang on ".$table."_lang.id_photo=photo.id and photo_lang.id_lang in (".$_SESSION["id_language"].", 0)
                              where $table.id_template='".$db->f('id_template')."' and $table.idd='".$db->f('idd')."' and $table.ord > '".$db->f('ord')."' and $table.photo_b != '' and $table.active='1' 
                              order by $table.ord");
                              if($db2->next_record())
                              {
                                    $img_size = getImageSize($path.$db2->f('photo_b'));
                                    $img_h = $img_size[1];
                                    $tmpl->set_var('photo_w', $img_size[0]);
                                    $tmpl->set_var('photo_h', $img_h);                                    
                                    $tmpl->set_var('photo_id', $db2->f('id'));
                                    $tmpl->set_var('photo_img', $db2->f('photo_b'));
                                    $tmpl->set_var('photo_alt', $db2->f('text'));
                                    $tmpl->parse('right', 'table_right');
                                    $next++;
                              }
                              else
                                    $tmpl->set_var('right', "");
                                    
                              $db2 = new DB__("select $table.id from $table 
                              left join ".$table."_lang on ".$table."_lang.id_photo=photo.id and photo_lang.id_lang in (".$_SESSION["id_language"].", 0)
                              where $table.id_template='".$db->f('id_template')."' and $table.idd='".$db->f('idd')."' and $table.photo_b != '' and $table.active='1'");

                              if($db2->nf())
                                    $tmpl->set_var('photo_max', $db2->nf());
                        }
                  }
            }
            else
                  $tmpl->parse('photo_', 'table_empty', true);
            
            return $tmpl->psubst('table_photo');
      }

      function spam_blocker()
      {
            $tab_spam = array();
            $tab_spam[0][0] = "plus";
            $tab_spam[0][1] = "+";
            $tab_spam[1][0] = "minus";
            $tab_spam[1][1] = "-";
            
            $x = 0;
            $y = 0;
            $sign = rand(0,(sizeof($tab_spam)-1));
            if($sign == "0")
            {
                  $x = rand(0, 9);
                  $y = rand(0, 9);
            }
            else
            {
                  while(($x - $y) < 1)
                  {
                        $x = rand(0, 9);
                        $y = rand(0, 9);
                  }
            }
            $_SESSION["text"] = "$x ".$tab_spam[$sign][0]." $y";
            
            if($sign == "0")
                  $_SESSION["result"] = $x + $y;
            else
                  $_SESSION["result"] = $x - $y;
                  
            return "<img src=\"../graph/spam_blocker.php?id=".rand(0, 100)."\" alt=\"\" />";
      }

      static function month($temp, $lang=1)
      {
            if($lang == 1)
            {
                  if($temp == "1")    return 'styczeń';
                  if($temp == "2")    return 'luty';
                  if($temp == "3")    return 'marzec';
                  if($temp == "4")    return 'kwiecień';
                  if($temp == "5")    return 'maj';
                  if($temp == "6")    return 'czerwiec';
                  if($temp == "7")    return 'lipiec';
                  if($temp == "8")    return 'sierpień';
                  if($temp == "9")    return 'wrzesień';
                  if($temp == "10")    return 'październik';
                  if($temp == "11")    return 'listopad';
                  if($temp == "12")    return 'grudzień';
            }
            else if($lang == 2)
            {
                  if($temp == "01")    return 'january';
                  if($temp == "02")    return 'february';
                  if($temp == "03")    return 'march';
                  if($temp == "04")    return 'april';
                  if($temp == "05")    return 'may';
                  if($temp == "06")    return 'june';
                  if($temp == "07")    return 'july';
                  if($temp == "08")    return 'august';
                  if($temp == "09")    return 'september';
                  if($temp == "10")    return 'october';
                  if($temp == "11")    return 'november';
                  if($temp == "12")    return 'december';
            }
      }
      
      static function month2($temp, $lang=1)
      {
            if($lang == 1)
            {
                  if($temp == "1")    return 'stycznia';
                  if($temp == "2")    return 'lutego';
                  if($temp == "3")    return 'marca';
                  if($temp == "4")    return 'kwietnia';
                  if($temp == "5")    return 'maja';
                  if($temp == "6")    return 'czerwca';
                  if($temp == "7")    return 'lipca';
                  if($temp == "8")    return 'sierpnia';
                  if($temp == "9")    return 'września';
                  if($temp == "10")    return 'października';
                  if($temp == "11")    return 'listopada';
                  if($temp == "12")    return 'grudnia';
            }
            else if($lang == 2)
            {
                  if($temp == "01")    return 'january';
                  if($temp == "02")    return 'february';
                  if($temp == "03")    return 'march';
                  if($temp == "04")    return 'april';
                  if($temp == "05")    return 'may';
                  if($temp == "06")    return 'june';
                  if($temp == "07")    return 'july';
                  if($temp == "08")    return 'august';
                  if($temp == "09")    return 'september';
                  if($temp == "10")    return 'october';
                  if($temp == "11")    return 'november';
                  if($temp == "12")    return 'december';
            }
      }
      
      static function date_from_to($date_from, $date_to = null)
      {
            $y1 = mb_substr($date_from, 0, 4);
            $m1 = mb_substr($date_from, 5, 2);
            $d1 = mb_substr($date_from, -2) + 0;
            $y2 = mb_substr($date_to, 0, 4);
            $m2 = mb_substr($date_to, 5, 2);
            $d2 = mb_substr($date_to, -2) + 0;

            if($y1 == "0000") 
                  $y1 = ""; 
            if($y2 == "0000") 
                  $y2 = ""; 

            if($d1 == "0")
            {
                  $date_start = File::month($m1, $_SESSION["id_language"])." ".$y1;
                  $date_end = File::month($m2, $_SESSION["id_language"])." ".$y2;
            }
            else
            {
                  $date_start = $d1." ".File::month2($m1, $_SESSION["id_language"])." ".$y1;
                  $date_end = $d2." ".File::month2($m2, $_SESSION["id_language"])." ".$y2;
            }
            
            if(!isset($date_to))
            {
                  if($d1 == "0")
                        return File::month($m1, $_SESSION["id_language"])." ".$y1;
                  else
                        return $d1." ".File::month2($m1, $_SESSION["id_language"])." ".$y1;
            }
            else
            {
                  if($y1 == $y2)
                  {
                        if($d1 == "0")
                              $date_start = File::month($m1, $_SESSION["id_language"]);
                        else
                              $date_start = $d1." ".File::month2($m1, $_SESSION["id_language"]);
                        if($m1 == $m2)
                        {
                              $date_start = $d1;
                        }
                  }
                  return $date_start." - ".$date_end;
            }
      }

      function date_from_to2($date_from, $date_to = null)
      {
            $y1 = mb_substr($date_from, 0, 4);
            $m1 = mb_substr($date_from, 5, 2);
            $d1 = mb_substr($date_from, -2) + 0;
            $y2 = mb_substr($date_to, 0, 4);
            $m2 = mb_substr($date_to, 5, 2);
            $d2 = mb_substr($date_to, -2) + 0;

            if($y1 == "0000") 
                  $y1 = ""; 
            if($y2 == "0000") 
                  $y2 = ""; 

            if($d1 == "0")
            {
                  $date_start = File::month2($m1, $_SESSION["id_language"])." ".$y1;
                  $date_end = File::month2($m2, $_SESSION["id_language"])." ".$y2;
            }
            else
            {
                  $date_start = $d1." ".File::month2($m1, $_SESSION["id_language"])." ".$y1;
                  $date_end = $d2." ".File::month2($m2, $_SESSION["id_language"])." ".$y2;
            }
            
            if(!isset($date_to))
            {
                  if($d1 == "0")
                        return File::month2($m1, $_SESSION["id_language"])." ".$y1;
                  else
                        return $d1." ".File::month2($m1, $_SESSION["id_language"])." ".$y1;
            }
            else
            {
                  if($y1 == $y2)
                  {
                        if($d1 == "0")
                              $date_start = File::month2($m1, $_SESSION["id_language"]);
                        else
                              $date_start = $d1." ".File::month2($m1, $_SESSION["id_language"]);
                        if($m1 == $m2)
                        {
                              $date_start = $d1;
                        }
                  }
                  return $date_start." - ".$date_end;
            }
      }

      static function time_from_to($time_from, $time_to = null)
      {
            $t1 = mb_substr($time_from, 0, 5);
            $t2 = mb_substr($time_to, 0, 5);

            if(!isset($time_to))
                  return $t1;
            else
                  return $t1." - ".$t2;
      }

      static function get_files_from_dir($dir,$space=0)
      {     
            $temp_tab = array();
            
            if(mb_substr($dir,-1) != "/")
                  $dir .= "/";
            
            if(file_exists($dir))
            {
                  if($dh = opendir($dir))
                  {
                        while(($file = readdir($dh)) !== false)
                        {
                              if($file != "." && $file != ".." && (!is_dir($dir.$file)))
                              {                             
                                    $temp_tab[] = $file;
                              }
                        }
                        closedir($dh);
                  }
            }
            else
                  echo "Katalog nie istnieje !";
                  
            if(sizeof($temp_tab))
                  natcasesort($temp_tab);
            else
                  $temp_tab = NULL;
            return $temp_tab;
      }

      static function make_mode_rew($str, $id, $idd = 0)
      {
            $str = mb_ereg_replace("А", "A", $str);
            $str = mb_ereg_replace("а", "a", $str);
            $str = mb_ereg_replace("Б", "B", $str);
            $str = mb_ereg_replace("б", "b", $str);
            $str = mb_ereg_replace("В", "W", $str);
            $str = mb_ereg_replace("в", "w", $str);
            $str = mb_ereg_replace("Г", "G", $str);
            $str = mb_ereg_replace("г", "g", $str);
            $str = mb_ereg_replace("Д", "D", $str);
            $str = mb_ereg_replace("д", "d", $str);
            $str = mb_ereg_replace("Е", "Je", $str);
            $str = mb_ereg_replace("е", "je", $str);
            $str = mb_ereg_replace("Ё", "Jo", $str);
            $str = mb_ereg_replace("ё", "jo", $str);
            $str = mb_ereg_replace("Ж", "Z", $str);
            $str = mb_ereg_replace("ж", "z", $str);
            $str = mb_ereg_replace("З", "Z", $str);
            $str = mb_ereg_replace("з", "z", $str);
            $str = mb_ereg_replace("И", "I", $str);
            $str = mb_ereg_replace("и", "i", $str);
            $str = mb_ereg_replace("Й", "J", $str);
            $str = mb_ereg_replace("й", "j", $str);
            $str = mb_ereg_replace("К", "K", $str);
            $str = mb_ereg_replace("к", "k", $str);
            $str = mb_ereg_replace("Л", "L", $str);
            $str = mb_ereg_replace("л", "l", $str);
            $str = mb_ereg_replace("М", "M", $str);
            $str = mb_ereg_replace("м", "m", $str);
            $str = mb_ereg_replace("Н", "N", $str);
            $str = mb_ereg_replace("н", "n", $str);
            $str = mb_ereg_replace("О", "O", $str);
            $str = mb_ereg_replace("о", "o", $str);
            $str = mb_ereg_replace("П", "P", $str);
            $str = mb_ereg_replace("п", "p", $str);
            $str = mb_ereg_replace("Р", "R", $str);
            $str = mb_ereg_replace("р", "r", $str);
            $str = mb_ereg_replace("С", "S", $str);
            $str = mb_ereg_replace("с", "s", $str);
            $str = mb_ereg_replace("Т", "T", $str);
            $str = mb_ereg_replace("т", "t", $str);
            $str = mb_ereg_replace("У", "U", $str);
            $str = mb_ereg_replace("у", "u", $str);
            $str = mb_ereg_replace("ф", "F", $str);
            $str = mb_ereg_replace("Ф", "f", $str);
            $str = mb_ereg_replace("Х", "Ch", $str);
            $str = mb_ereg_replace("х", "ch", $str);
            $str = mb_ereg_replace("Ц", "C", $str);
            $str = mb_ereg_replace("ц", "c", $str);
            $str = mb_ereg_replace("Ч", "Cz", $str);
            $str = mb_ereg_replace("ч", "cz", $str);
            $str = mb_ereg_replace("Ш", "Sz", $str);
            $str = mb_ereg_replace("ш", "sz", $str);
            $str = mb_ereg_replace("Щ", "Szcz", $str);
            $str = mb_ereg_replace("щ", "szcz", $str);
            $str = mb_ereg_replace("Ы", "Y", $str);
            $str = mb_ereg_replace("ы", "y", $str);
            $str = mb_ereg_replace("Э", "E", $str);
            $str = mb_ereg_replace("э", "e", $str);
            $str = mb_ereg_replace("Ю", "Ju", $str);
            $str = mb_ereg_replace("ю", "ju", $str);
            $str = mb_ereg_replace("Я", "Ja", $str);
            $str = mb_ereg_replace("я", "ja", $str);

            $str = mb_ereg_replace("Ä", "A", $str);
            $str = mb_ereg_replace("ä", "a", $str);
            $str = mb_ereg_replace("Ö", "O", $str);
            $str = mb_ereg_replace("ö", "o", $str);
            $str = mb_ereg_replace("Ü", "U", $str);
            $str = mb_ereg_replace("ü", "u", $str);
            $str = mb_ereg_replace("ß", "ss", $str);
            
            $str = mb_ereg_replace(' ', '-', $str);            
            $str = mb_ereg_replace("Ą", "A", $str);
            $str = mb_ereg_replace("ą", "a", $str);
            $str = mb_ereg_replace("Ś", "S", $str);
            $str = mb_ereg_replace("ś", "s", $str);
            $str = mb_ereg_replace("Ń", "N", $str);
            $str = mb_ereg_replace("ń", "n", $str);
            $str = mb_ereg_replace("Ł", "L", $str);
            $str = mb_ereg_replace("ł", "l", $str);
            $str = mb_ereg_replace("Ę", "E", $str);
            $str = mb_ereg_replace("ę", "e", $str);
            $str = mb_ereg_replace("Ó", "O", $str);
            $str = mb_ereg_replace("ó", "o", $str);
            $str = mb_ereg_replace("Ć", "C", $str);
            $str = mb_ereg_replace("ć", "c", $str);
            $str = mb_ereg_replace("Ź", "Z", $str);
            $str = mb_ereg_replace("Ż", "Z", $str);
            $str = mb_ereg_replace("ź", "z", $str);
            $str = mb_ereg_replace("ż", "z", $str);
            
            for($i=0;$i<mb_strlen($str);$i++)
            {
                  if(!(($str[$i] >= "0" && $str[$i] <= "9") || ($str[$i] >= "A" && $str[$i] <= "Z") || $str[$i] == "_" || $str[$i] == "-" || ($str[$i] >= "a" && $str[$i] <= "z")))
                        $str[$i] = " ";
            }
            $str = mb_ereg_replace(" ", '', $str);
            $str = substr($str,0,38);
            if($idd != 0)
                  return $str.",".$id.",".$idd;
            else
                  return $str.",".$id;
      }
/*
      function url_to_mod_rewrite()
      {
            $tab_url = path_from_get(array(), true);
            if(is_array($tab_url))
                  if(sizeof($tab_url) >= 1)
                  {
                        if(array_key_exists("id", $tab_url) == true)
                              echo 1;
                        if(array_key_exists("idd", $tab_url) == true)
                              echo 2;                  
                  }    
      }
*/
      static function text_len($l, $text)
      {
            if(mb_strlen($text) >= $l)
            {
                  return mb_substr($text, 0, mb_strrpos(mb_substr($text, 0, $l)," "))." ...";
            }
            else
                  return $text;
      }

      function br_to_nl($text)
      {      
            return mb_ereg_replace("<br *\/{0,1}>(\\r\\n)*", "\r\n", $text);
      }
      
      function nl_to_br($text)
      {      
            return mb_ereg_replace("\r\n", "<br/>", $text);
      }

}

?><?
class Banner
{
      public $banner_as_bckg = null;
      private $banner_site = array();
      function __construct()
      {
            $this->find_banner_site();
      }
      
      function find_banner_site()
      {
            $next = 0;
            if(!isset($_GET["id"]))
            {
                  $db = new DB__("select banner_site.id_banner, banner.id_category from banner_site, banner
                  where banner_site.id_banner=banner.id and banner.active='1' and banner_site.id_service='".$_SESSION["id_service"]."' and banner_site.id_menu='0' and (banner.id_lang='".$_SESSION["id_language"]."' or  banner.id_lang='-1')
                  order by banner.ord"); 
                  while($db->next_record())
                  {
                        $this->banner_site[$db->f('id_category')][] = $db->f('id_banner');
                  }
            }
            else if(isset($_GET["id_category"]))
            {
                  $db = new DB__("select banner_site.id_banner, banner.id_category from banner_site, banner
                  where banner_site.id_banner=banner.id and banner.active='1' and banner_site.id_category='".$_GET["id_category"]."' and (banner.id_lang='".$_SESSION["id_language"]."' or  banner.id_lang='-1')
                  order by banner.ord"); 
                  if($db->nf())
                  {
                        while($db->next_record())
                        {
                              $this->banner_site[$db->f('id_category')][] = $db->f('id_banner');
                        }     
                  }               
            }
            else
            {
                  $db = new DB__("select banner_site.id_banner, banner.id_category from banner_site, banner
                  where banner_site.id_banner=banner.id and banner.active='1' and banner_site.id_menu='".$_GET["id"]."' and (banner.id_lang='".$_SESSION["id_language"]."' or  banner.id_lang='-1')
                  order by banner.ord"); 
                  if($db->nf())
                  {
                        while($db->next_record())
                        {
                              $this->banner_site[$db->f('id_category')][] = $db->f('id_banner');
                        }     
                  }   
                  else
                  {
                        $db = new DB__("select banner_site.id_banner, banner.id_category from banner_site, banner
                        where banner_site.id_banner=banner.id and banner.active='1' and (banner.id_lang='".$_SESSION["id_language"]."' or  banner.id_lang='-1') and banner_site.id_menu=
                        (select menu_root.id_root from menu_root, banner_site, banner
                        where banner_site.id_menu=menu_root.id_root and banner.id=banner_site.id_banner and banner.active='1' and menu_root.id_menu='".$_GET["id"]."' and (banner.id_lang='".$_SESSION["id_language"]."' or  banner.id_lang='-1')
                        order by menu_root.ord
                        limit 0, 1)
                        order by banner.ord"); 
                        while($db->next_record())
                        {
                              $this->banner_site[$db->f('id_category')][] = $db->f('id_banner');
                        }     
                  }   
            }
      }
      
      function show_baner($id_category, $space = 0)
      {
            global $labels;
            $tmpl = new Template("../htmls");
            $tmpl->set_file('blocks','banner.html');
            $tmpl->set_block('blocks','table');
            $tmpl->set_block('blocks','table_swf');
            $tmpl->set_block('blocks','table_img');
            $tmpl->set_block('blocks','table_a');
            $tmpl->set_block('blocks','table_bckg');
            $tmpl->set_block('blocks','table_banner_spacer1');
            $tmpl->set_block('blocks','table_banner_spacer2');
      
            $iff = 0;
            $id_type = null;
      
            $db = new DB__("select banner_category.id_type from banner_category
            where banner_category.id='".$id_category."'"); 
            if($db->next_record())
                  $id_type = $db->f('id_type');
                   
            if(!empty($this->banner_site[$id_category]))
            {
                  $sql_in = "";
                  while(list($k, $v) = each($this->banner_site[$id_category]))
                  {
                        $sql_in = $sql_in.$v.",";          
                  }
                  if($id_type != 1)
                        $db1 = new DB__("select banner.*, if(banner.w is not null, banner.w, banner_category.w) as w, if(banner.h is not null, banner.h, banner_category.h) as h from banner, banner_category 
                        where banner_category.id=banner.id_category and banner.id in (".mb_substr($sql_in, 0, -1).")  and (banner.id_lang='".$_SESSION["id_language"]."' or  banner.id_lang='-1')
                        order by banner.ord");
                  else
                        $db1 = new DB__("select banner.*, if(banner.w is not null, banner.w, banner_category.w) as w, if(banner.h is not null, banner.h, banner_category.h) as h from banner, banner_category 
                        where banner_category.id=banner.id_category and banner.id in (".mb_substr($sql_in, 0, -1).")  and (banner.id_lang='".$_SESSION["id_language"]."' or  banner.id_lang='-1')
                        order by rand() 
                        limit 0,1");
            }
            else
            {
                  if($id_type != 1)
                        $db1 = new DB__("select banner.*, if(banner.w is not null, banner.w, banner_category.w) as w, if(banner.h is not null, banner.h, banner_category.h) as h from banner 
                        left join banner_category on banner_category.id=banner.id_category 
                        left join banner_site on banner_site.id_banner=banner.id
                        where banner_site.id_banner is null and banner.id_category='".$id_category."' and banner.active='1'  and (banner.id_lang='".$_SESSION["id_language"]."' or  banner.id_lang='-1')
                        order by banner.ord");
                  else
                        $db1 = new DB__("select banner.*, if(banner.w is not null, banner.w, banner_category.w) as w, if(banner.h is not null, banner.h, banner_category.h) as h from banner 
                        left join banner_category on banner_category.id=banner.id_category 
                        left join banner_site on banner_site.id_banner=banner.id
                        where banner_site.id_banner is null and banner.id_category='".$id_category."' and banner.active='1'  and (banner.id_lang='".$_SESSION["id_language"]."' or  banner.id_lang='-1')
                        order by rand() 
                        limit 0,1");
            }
            if($db1->nf())
            {
                  while($db1->next_record())
                  {
                        $iff++;
                        $tmpl->set_var('id_ban', "b_".$db1->f('id'));
                        if($db1->f('type') == 0)
                              $obr = getImageSize(PATH_BANNERS.$db1->f('path'));
                        
                        if(!$db1->f('w'))
                              $tmpl->set_var('w', $obr[0]);
                        else
                              $tmpl->set_var('w', $db1->f('w'));
                        
                        if(!$db1->f('h'))
                              $tmpl->set_var('h', $obr[1]);
                        else
                              $tmpl->set_var('h', $db1->f('h'));
                        
                        $tmpl->set_var('path', PATH_BANNERS.$db1->f('path'));
                        
                        $title = "";
                        if($db1->f('link_kind') == "1")
                              $title .= "Link zewnętrzny";
                        if($db1->f('link_target') == "_blank")
                              $title .= " otwierany w nowym oknie";
      
                        
                        $tmpl->set_var('img_alt', $db1->f('alt'));
                        if($db1->f('alt') != "")
                              $tmpl->set_var('alt', $title.": ".$db1->f('alt'));
                        else
                              $tmpl->set_var('alt', "");
                        
                        $tmpl->set_var('margin', "margin:0 auto;");
                        if($iff != $db1->nf())
                        {
                              if($id_type == 2)
                                    $tmpl->set_var('margin', "margin:0 auto ".$space."px;");
                              else if($id_type == 3)
                                    $tmpl->set_var('margin', "margin-right:".$space."px;");
                        }

                        if($db1->f('type') == 1)
                              $tmpl->parse('table_row', 'table_swf', true);
                        else
                        {
                              if($db1->f('link'))
                              {
                                    if($db1->f('link_target') == "_blank")
                                          $tmpl->set_var('target'," onclick=\"window.open(this.href,'_blank');return false;\"");
                                    else
                                          $tmpl->set_var('target',"");
                                    
                                    if($db1->f('link_kind') == "3")
                                          $tmpl->set_var('src', "index.php?id=".$db1->f('link'));
                                    else
                                          $tmpl->set_var('src', htmlentities($db1->f('link')));
                                    
                                    $tmpl->parse('a_','table_img');
                                    $tmpl->parse('table_row', 'table_a', true);
                              }
                              else
                                    $tmpl->parse('table_row', 'table_img', true);
                        }
                        
                  }
                  if(isset($this->banner_as_bckg))
                        return $tmpl->subst('table_bckg');
                  else
                        return $tmpl->subst('table');
            }
      }
}

class Banner_div
{
      private $banner_site = null;
      private $date_now = "";
      function __construct()
      {
            $this->date_now = date("Y-m-d");
            $this->find_banner_site();
      }
      
      function find_banner_site()
      {
            $next = 0;
            if(!isset($_GET["id"]))
            {
                  $db = new DB__("select banner_div_site.id_banner from banner_div_site, banner_div
                  where banner_div_site.id_banner=banner_div.id and banner_div.active='1' and banner_div_site.id_service='".$_SESSION["id_service"]."' and banner_div_site.id_menu='0' and date_format(banner_div.date_from, '%Y-%m-%d') <= '".$this->date_now."' and (date_format(banner_div.date_to, '%Y-%m-%d') >= '".$this->date_now."' or date_to is null)
                  order by rand()"); 
                  if($db->next_record())
                  {
                        $this->banner_site = $db->f('id_banner');
                  }
            }
            else
            {
                  $db = new DB__("select banner_div_site.id_banner from banner_div_site, banner_div
                  where banner_div_site.id_banner=banner_div.id and banner_div.active='1' and banner_div_site.id_menu='".$_GET["id"]."' and date_format(banner_div.date_from, '%Y-%m-%d') <= '".$this->date_now."' and (date_format(banner_div.date_to, '%Y-%m-%d') >= '".$this->date_now."' or date_to is null)
                  order by rand()"); 
                  if($db->nf())
                  {
                        if($db->next_record())
                        {
                              $this->banner_site = $db->f('id_banner');
                        }     
                  }   
                  else
                  {
                        $db = new DB__("select banner_div_site.id_banner from banner_div_site, banner_div
                        where banner_div_site.id_banner=banner_div.id and banner_div.active='1' and banner_div_site.id_menu=
                        (select menu_root.id_root from menu_root, banner_div_site, banner_div
                        where banner_div_site.id_menu=menu_root.id_root and banner_div.id=banner_div_site.id_banner and banner_div.active='1' and menu_root.id_menu='".$_GET["id"]."'
                        order by menu_root.ord
                        limit 0, 1) and date_format(banner_div.date_from, '%Y-%m-%d') <= '".$this->date_now."' and (date_format(banner_div.date_to, '%Y-%m-%d') >= '".$this->date_now."' or date_to is null)
                        order by rand()"); 
                        if($db->next_record())
                        {
                              $this->banner_site = $db->f('id_banner');
                        }     
                  }   
            }
      }
      
      function show_baner()
      {
            $tmpl = new Template("../htmls");
            $tmpl->set_file('blocks','banner.html');
            $tmpl->set_block('blocks','table_banner_div');
            $tmpl->set_block('blocks','table_swf');
            $tmpl->set_block('blocks','table_img_div');
            $tmpl->set_block('blocks','table_img_div_a');
      
            $iff = 0;
                   
            if(isset($this->banner_site))
            {
                  $db1 = new DB__("select banner_div.* from banner_div 
                  where banner_div.id='".$this->banner_site."'");
            }
            else
            {
                  $db1 = new DB__("select banner_div.*, t1.name as close_type, t2.name as link_type from banner_div 
                  left join banner_map_type as t1 on t1.id=banner_div.close_type
                  left join banner_map_type as t2 on t2.id=banner_div.link_type
                  left join banner_div_site on banner_div_site.id_banner=banner_div.id
                  where banner_div_site.id_banner is null and banner_div.active='1' and date_format(banner_div.date_from, '%Y-%m-%d') <= '".$this->date_now."' and (date_format(banner_div.date_to, '%Y-%m-%d') >= '".$this->date_now."' or date_to is null)
                  order by rand()");
            }
            if($db1->nf())
            {
                  if($db1->next_record())
                  {
                        $iff++;
                        $tmpl->set_var('id', $db1->f('id'));
                        if($db1->f('type') == 0)
                              $obr = getImageSize(PATH_BANNERS.$db1->f('path'));
                        
                        if(!$db1->f('w'))
                              $tmpl->set_var('w', $obr[0]);
                        else
                              $tmpl->set_var('w', $db1->f('w'));
                        
                        if(!$db1->f('h'))
                              $tmpl->set_var('h', $obr[1]);
                        else
                              $tmpl->set_var('h', $db1->f('h'));
                        
                        $tmpl->set_var('path', PATH_BANNERS.$db1->f('path'));
                        
                        $tmpl->set_var('margin', "");
                        
                        if($db1->f('type') == 1)
                              $tmpl->parse('table_row', 'table_swf', true);
                        else
                        {

                              if($db1->f('link'))
                              {
                                    $tmpl->set_var('link_type',$db1->f('link_type'));
                                    $tmpl->set_var('link_map',$db1->f('link_map'));
                                    
                                    if($db1->f('link_target') == "_blank")
                                          $tmpl->set_var('target'," onclick=\"window.open(this.href,'_blank');return false;\"");
                                    else
                                          $tmpl->set_var('target',"");
                                    
                                    if($db1->f('link_kind') == "3")
                                          $tmpl->set_var('src', "index.php?id=".$db1->f('link'));
                                    else
                                          $tmpl->set_var('src', htmlentities($db1->f('link'))); 
                                    
                                    
                                    $tmpl->parse('map_', 'table_img_div_map');                                      

                                    $tmpl->parse('table_row', 'table_img_div_a', true);                                    
                              }
                              else
                                    $tmpl->parse('table_row', 'table_img_div', true);
                        }
                  }
                  return $tmpl->subst('table_banner_div');
            }
      }

}

?><?
class RSS
{
      public $left_join = "";
      
      function __construct()
      {
            $this->tmpl = new Template("../htmls");
            $this->tmpl->set_file('blocks','rss.html');
            $this->tmpl->set_block('blocks','main_rss');
            $this->tmpl->set_block('blocks','main_rss_item');
            $this->tmpl->set_block('blocks','main_rss_img');
      }
      
      function do_rss()
      {            
            $file = "../rss.xml";
            $file_temp = "../rss_temp.xml";
/*            
            $db = new DB__("select news.* from news, site_temp
            where news.title != '' and site_temp.id_row=news.id and site_temp.id_template=(select id_template from template_menu where id_menu='11') and site_temp.id_menu='11' and news.active='1'
            order by date_ desc
            limit 0,20");  
*/             
            $db = new DB__("(select '11' as id_main, news.id,  news.title, news.date_, news.subtext, photo.photo_m from news
left join site_temp on site_temp.id_row=news.id and site_temp.id_template=(select id_template from template_menu where id_menu='11') and site_temp.id_menu='11' and news.active='1'
left join photo on photo.idd=news.id and photo.active='1' and photo.ord='1' and photo.id_template=(select id_template from template_menu where template_menu.id_menu='11')
where news.title != '' and news.active='1'
group by news.id)
union
(select '33' as id_main, publications.id,  publications.title, publications.date_, publications.text as subtext, null as photo_m  from publications, site_temp
where publications.title != '' and site_temp.id_row=publications.id and site_temp.id_template=(select id_template from template_menu where id_menu='33') and site_temp.id_menu='33' and publications.active='1')
            order by date_ desc, id desc
            limit 0,20");   
            
/*
            $db = new DB__("select news.* from news
            where news.title != '' and news.active='1' and news.id_menu='11'
            order by date_ desc
            limit 0,20");
            */
            if($db->nf())
            {
                  while($db->next_record())
                  {
                        //$tmpl->set_var("rss_title", htmlspecialchars($db->f('name'), ENT_QUOTES, "UTF-8"));
                        $this->tmpl->set_var("rss_title", $db->f('title'));
                        $this->tmpl->set_var("rss_text", $db->f('subtext'));
                        if($db->f('id_main') == 11)
                              $this->tmpl->set_var("rss_url", "http://www.miekinia.pl/pl/Aktualnosci,11,".$db->f('id'));
                        else
                              $this->tmpl->set_var("rss_url", "http://www.miekinia.pl/pl/Komunikaty,33,".$db->f('id'));
                        $this->tmpl->set_var("rss_date", $db->f('date_'));
                        
                        if($db->f('photo_m') != "")
                        {
                              $this->tmpl->set_var("rss_photo_m", $db->f('photo_m'));
                              $this->tmpl->parse("photo_", "main_rss_img");
                        }
                        else
                              $this->tmpl->set_var("photo_", "");
                        
                        $this->tmpl->parse("items_", "main_rss_item", true);
                        
                  }
                  
                  $fp = fopen($file_temp, 'w');
                  fwrite($fp, $this->tmpl->subst('main_rss'));
                  fclose($fp);
                  //zapisujemy do pliku tymczasowego a potem tylko zmiana nazwy - tworzenie pliku trwa dosyc dlugo
                  rename($file_temp, $file); 
            }                  
      }
}


class Login
{
      public $vars;
      public $login_link;
      private $arr_access;
      private $str_access;
      function __construct()
      {
            global $_services;
            $this->login_link = "index.php";
            $this->vars = array();
            $this->vars["firm"] = "id";
            $this->vars["login"] = "login";
            $this->vars["date_to"] = "date_to";
            
            if(!isset($_SESSION["my_referer"]))
                  $_SESSION["my_referer"] = "";
            
            $this->arr_access = array("6", "9", "14", "11", "8", "10", "12", "52", "32");
            $this->str_access = "6,9,14,11,8,10,12,52,32";
      }
      
      function news_access_ids()
      {
            $db = new DB__("select menu_root.id_root from menu_root
            where menu_root.id_menu='".$_GET["id"]."' and menu_root.id_root in (".$this->str_access.")");
            if($db->next_record() || in_array($_GET["id"], $this->arr_access))
            {
                  return true;
            }
            else
                  return false;

      }
      
      function news_access()
      {
            if($this->news_access_ids())
            {                  
                  if($this->login_exist() && ($_SESSION["date_to"] >= date("Y-m-d")))  
                  {
                        return true;
                  }       
                  else
                  {
                        return false;            
                  }   
            }
            else
                  return true;

      }
      
      function unset_vars()
      {
            while(list($k,$v)=each($this->vars))
            {
                  $_SESSION[$k] = null;    
                  unset($_SESSION[$k]);        
            }
      }
      
      function log_in($login,$pass)
      {
            $db = new DB__("select firm.* from firm
            where firm.login='".$login."' and firm.pass='".$pass."' and firm.active='1'");
            if($db->next_record())
            {
                  while(list($k,$v)=each($this->vars))
                  {
                        $_SESSION[$k] = $db->f($v);    
                  }
                  return true;
            }
            else
                  return false;
            
      }
      
      function login_exist()
      {
            if(isset($_SESSION["firm"]) && isset($_SESSION["login"]))
            {
                  $db = new DB__("select firm.* from firm
                  where firm.id='".$_SESSION["firm"]."' and firm.login='".$_SESSION["login"]."' and firm.active='1'");
                  if($db->next_record())
                        return true;
                  else
                        return false;
            }
            else
                  return false;
      }
      
      function error_location()
      {
            if(isset($_SERVER['QUERY_STRING']))
                  $_SESSION["my_referer"] = $_SERVER['QUERY_STRING'];
            else
                  $_SESSION["my_referer"] = "";
            
            header("Location: ".$this->login_link);
            exit;
      }
      
      function authorisation_record($id, $table)
      {
            if(isset($_SESSION["firm"]) && isset($_SESSION["login"]))
            {
                  $db = new DB__("select $table.id from $table
                  where $table.id_firm='".$_SESSION["firm"]."' and $table.id='".$id."'");
                  if(!$db->next_record())
                  {
                        $this->error_location();
                  }
            }
            else
            {
                  $this->error_location();
            }
            
      }
      
      function authorisation_site()
      {
            if(isset($_SESSION["firm"]) && isset($_SESSION["login"]))
            {
                  if($this->login_exist())
                        return true;
                  else
                  {
                        $this->unset_vars();
                        $this->error_location();
                  }
            }
            else
            {
                  $this->error_location();
            }
            
      }
      
}
      
class Newsletter
{
      public $path_newsletter;
      function __construct()
      {
            $this->path_newsletter = "http://".$_SERVER["HTTP_HOST"]."/newsletter/";
      }
      
      function make_header()
      {
            $header = "";
            $header .= "From: =?UTF-8?B?".base64_encode(strtoupper(SITE_NAME))."?= <".SITE_EMAIL.">\n";            
            $header .= "MIME-Version: 1.0\n";
            $header .= "Content-type: text/html; charset=utf-8\n";
            return $header;
      }
      
      function make_newsletter($sql, $templ)
      {
            $db = new DB__($sql);
            if($db->next_record())
            {
                  $templ_1 = $templ;
                  $templ_1->set_file('blocks', 'newsletter.html');
                  $templ_1->set_block('blocks', 'modul_newsletter');
                  $templ_1->set_block('blocks', 'modul_newsletter_news');
                  $templ_1->set_block('blocks', 'modul_newsletter_news2');
                            
                  $templ_1->set_var('modul_newsletter_news_', '');                     

                  $templ_1->set_var('path_newsletter', $this->path_newsletter);
                  $templ_1->set_var('path_newsletter_main', $this->path_newsletter."../pl/");
                  $templ_1->set_var('path_newsletter_home', "http://".$_SERVER["HTTP_HOST"]);
                  $templ_1->set_var('site_name', SITE_NAME); 
                  
                  //etykiety
                  $db2 = new DB__("select label_lang.* from label_lang
                  where label_lang.id_lang='".$_SESSION["id_language"]."'");
                  while($db2->next_record())
                  {
                        $templ_1->set_var("label".$db2->f('id'), $db2->f('name'));
                  }
                  
                  //news                  
                  $db3 = new DB__("select newsletter_row.* from newsletter_row
                  where newsletter_row.id_newsletter='".$db->f('id')."' and newsletter_row.active='1'
                  order by newsletter_row.ord");
                  while($db3->next_record())
                  {
                        $templ_1->set_var("news_title", $db3->f('title'));
                        $templ_1->set_var("news_text", $db3->f('text'));
                        $templ_1->set_var("news_url", $db3->f('url'));
                        //$templ_1->set_var("news_date_text", $db3->f('date_text'));
                        $templ_1->set_var('news_path', PATH_IMG.$db3->f('path'));   
                        if($db3->f('path') != "")
                              $templ_1->parse('modul_newsletter_news_', 'modul_newsletter_news', true);
                        else    
                              $templ_1->parse('modul_newsletter_news_', 'modul_newsletter_news2', true);
                  }
                  
                  //tresc
                  $templ_1->set_var('newsletter_nr', $db->f('id'));   
                  $templ_1->set_var('newsletter_text', $db->f('text'));   
                  $templ_1->set_var('newsletter_title', $db->f('title'));   
                  
                  $tab_res["title"] = $db->f('title');
                  //$tab_res["text"] = preg_replace("/(<.+>)/U", "\\1\n", $templ_1->subst('modul_newsletter'));
                  $tab_res["text"] = $templ_1->subst('modul_newsletter');
                  $tab_res["id"] = $db->f('id');
                  $tab_res["amount"] = $db->f('amount');
                  $tab_res["id_category"] = $db->f('id_category');
                  
                  return $tab_res;   
            }
            else
            {
                  return null;
            }
      }
}


class Baza_site
{
      function __construct()
      {
      }
      
      static function page_link($sql, $view = null)
      {
            $results = array();
                        
            $file_array = array();
            $file_array["doc"] = "doc.png";
            $file_array["docx"] = "doc.png";
            $file_array["xls"] = "xls.png";
            $file_array["pdf"] = "pdf.png";
            
            $db = new DB__($sql); 
            if($db->nf())
            {
                  $next = 0;
                  while($db->next_record())
                  {
                        $next++;
                        
                        $results[$next]["id"] = $db->f('id');
                        $results[$next]["link_old"] = $db->f('link');
                        $results[$next]["link"] = $db->f('link');
                        $results[$next]["kind"] = $db->f('kind');
                        $results[$next]["path1"] = $db->f('path1');
                        $results[$next]["path2"] = $db->f('path2');
                        $results[$next]["name"] = $db->f('name');
                        $results[$next]["path"] = $db->f('path');
                        $results[$next]["p_path"] = $db->f('p_path');
                        $results[$next]["target"] = null;
                        if($db->f('link'))
                        {
                              $results[$next]["linking"] = "1";
                              
                              if($db->f('kind') == 1)
                              {
                                    $results[$next]["link"] = $db->f('link');
                                    if($db->f('target') == 1)
                                          $results[$next]["target"] = " onclick=\"window.open(this.href,'".$db->f('target')."');return false;\"";
                                    $results[$next]["icon"] = null;
                                    $results[$next]["size"] = null;
                              }
                              else if($db->f('kind') == 2)
                              {
                                    $extension = mb_substr($db->f('link'), mb_strrpos($db->f('link'),".")+1);
                                    
                                    $results[$next]["link"] = PATH_DOC.$db->f('link');
                                    $results[$next]["target"] = " onclick=\"window.open(this.href,'_blank');return false;\"";
                                    
                                    if(array_key_exists($extension, $file_array) == true)
                                          $results[$next]["icon"] = "<img src=\"".PATH_IMG_MAIN.$file_array[$extension]."\" alt=\"\"/>&nbsp;";
                                    else
                                          $results[$next]["icon"] = "<img src=\"".PATH_IMG_MAIN."file.png\" alt=\"\"/>&nbsp;";
                                    $results[$next]["size"] = "&nbsp;(".mb_strtoupper($extension).", ".file_size_mb(PATH_DOC.$db->f('link')).")";
                              }
                              else if($db->f('kind') == 3)
                              {
                                    $results[$next]["link"] = File::make_mode_rew($db->f('name'),$db->f('link'));
                                    $results[$next]["target"] = null;
                                    $results[$next]["icon"] = null;
                                    $results[$next]["size"] = null;
                              }
                        }
                        else
                        {
                              if(isset($view))
                                    $results[$next]["linking"] = null;
                              else
                              {
                                    //if(!$db->f('text') && !$db->f('template') && !Baza::have_children($db->f('id')) && !Baza::have_files($db->f('id')) && !Baza::have_photos($db->f('id')))
                                    //      $results[$next]["linking"] = null;
                                    //else
                                          $results[$next]["linking"] = 1;                                          
                              }
                        
                              $results[$next]["link"] = File::make_mode_rew($db->f('name'),$db->f('id'));
                              $results[$next]["target"] = null;
                              $results[$next]["icon"] = null;
                              $results[$next]["size"] = null;
                        }
                  }
            }               
            return $results;
      }  
}  

class Months
{
      public $type = "month";
      public $auto_select = "m";
      public $where = "";
      public $select = "";
      public $onchange = 1;
      public $cell_link_type = "link";
      public $show_all_select = 1;
      public $get_id = null;
      public $tmpl;
      public $left_join = "";
      public $left_join2 = "";
      
      function __construct()
      {
            $this->tmpl = new Template("../htmls");
            $this->tmpl->set_file('blocks','main.html');
            $this->tmpl->set_file('blocks2','calendar.html');
      }
      
      function show_months($tab, $date_, $sql, $sql_lj="")
      {            
            $this->tmpl->set_block('blocks','table_select');
            $this->tmpl->set_block('blocks','table_option');            

            if(isset($this->onchange))
                  //$this->tmpl->set_var('id_select', "  class=\"input_select\" onchange=\"location.href='index.php?".path_from_get(array("ym"))."&amp;ym=' + this.value ;\"");
                  $this->tmpl->set_var('id_select', "  class=\"input_select\"");
            else
                  $this->tmpl->set_var('id_select', "");
            $this->tmpl->set_var('select_name', "ym");
                  
            $arr_years = array();
            $f_year = 0;
            $f_month = 0;
            
            if(!isset($_GET["ym"])) $_GET["ym"] = null;
            
            $db2 = new DB__("show columns from $tab where field='$date_'");
            if($db2->next_record())
            {
                     if($db2->f('Type') == "year(4)")
                              $tab_date_ = "concat(".$date_.",'-00-00')";
                     else
                              $tab_date_ = $date_;
                        /*
                     if($db2->f('Type') == "year(4)")
                              $tab_date_ = "concat(".$tab.".".$date_.",'-00-00')";
                     else
                              $tab_date_ = $tab.".".$date_;
                        */
            }

            $db = new DB__("select distinct date_format($tab_date_, '%Y-%m') as date_row from $tab
            $sql_lj
            where 1 $sql
            order by date_row desc");
            
            if($db->nf())
            {
                  $this->tmpl->set_var('option_selected', "");
                  if(isset($this->show_all_select))
                  {
                        $this->tmpl->set_var('option_', "[wszystkie]");
                        $this->tmpl->set_var('option_value', "-1");
                        $this->tmpl->parse('select_', 'table_option', true);  
                  }                
                  while($db->next_record())
                  {
                        $year = mb_substr($db->f('date_row'),0,4);
                        $month = mb_substr($db->f('date_row'),-2);
                        if($this->type == "month_year")
                        {
                              if($_GET["ym"] == $db->f('date_row') || (!$_GET["ym"] && $this->auto_select == "m" && $f_month == 1))
                              {
                                    $_GET["ym"] = $db->f('date_row');
                                    $this->tmpl->set_var('option_selected', " selected=\"selected\"");
                              }
                              else      
                                    $this->tmpl->set_var('option_selected', "");
                              $this->tmpl->set_var('option_', $year."&nbsp;".File::month($month, $_SESSION["id_language"]));
                              $this->tmpl->set_var('option_value', $db->f('date_row'));
                              $this->tmpl->parse('select_', 'table_option', true);
                  
                        }
                        else
                        {
                              if(!in_array($year, $arr_years))
                              {
                                    $f_year++;
                                    if($_GET["ym"] == $year || (!$_GET["ym"] && $this->auto_select == "y" && $f_year == 1))
                                    {
                                          $this->tmpl->set_var('option_selected', " selected=\"selected\"");
                                          $_GET["ym"] = $year;
                                    }
                                    else      
                                          $this->tmpl->set_var('option_selected', "");
                                          
                                    $this->tmpl->set_var('option_', $year);
                                    $this->tmpl->set_var('option_value', $year);
                                    
                                    $arr_years[] = $year;
                                    $this->tmpl->parse('select_', 'table_option', true);
                              }
                              
                              if($this->type == "month")
                              {
                                    $f_month++;
                                    if($_GET["ym"] == $db->f('date_row') || (!$_GET["ym"] && $this->auto_select == "m" && $f_month == 1))
                                    {
                                          $_GET["ym"] = $db->f('date_row');
                                          $this->tmpl->set_var('option_selected', " selected=\"selected\"");
                                    }
                                    else      
                                          $this->tmpl->set_var('option_selected', "");
                                    $this->tmpl->set_var('option_', "&nbsp;&bull;&nbsp;".File::month($month, $_SESSION["id_language"]));
                                    $this->tmpl->set_var('option_value', $db->f('date_row'));
                                    $this->tmpl->parse('select_', 'table_option', true);
                              }
                        }
                  }
            }
            if(mb_strlen($_GET["ym"]) == 4)
                  $this->where = " and date_format($tab_date_, '%Y') = '".$_GET["ym"]."'";
            else if(mb_strlen($_GET["ym"]) == 7)
                  $this->where = " and date_format($tab_date_, '%Y-%m') = '".$_GET["ym"]."'";
            else if(mb_strlen($_GET["ym"]) == 10)
                  $this->where = " and date_format($tab_date_, '%Y-%m-%d') = '".$_GET["ym"]."'";
            
            return $this->tmpl->subst('table_select');
      }
      
      function show_months_calendar($tab, $date_from, $date_to, $sql)
      {            
            $this->tmpl->set_block('blocks','table_select');
            $this->tmpl->set_block('blocks','table_option');            

            if(isset($this->onchange))
                  $this->tmpl->set_var('id_select', $this->onchange);                  
            else
                  $this->tmpl->set_var('id_select', "");
                  
            $arr_years = array();
            $f_year = 0;
            $f_month = 0;
            
            if(!isset($_GET["ym"]))
            { 
                  $db = new DB__("select if($tab.$date_to is null or date_format($tab.$date_from,'%Y-%m') > date_format(now(),'%Y-%m'), date_format($tab.$date_from,'%Y-%m'), date_format(now(),'%Y-%m')) as date_row from $tab
                  ".$this->left_join."
                  where (date_format($tab.$date_from,'%Y-%m') >= date_format(now(),'%Y-%m') or date_format($tab.$date_to,'%Y-%m') >= date_format(now(),'%Y-%m')) $sql
                  order by date_row
                  limit 0,1");    
                  if($db->next_record())
                        $_GET["ym"] = $db->f('date_row');
                  else
                        $_GET["ym"] = null;
            }
            
            $db = new DB__("select date_format($tab.$date_from,'%Y-%m') as d_from, date_format($tab.$date_to,'%Y-%m') as d_to from $tab
            ".$this->left_join."
            where 1 $sql
            group by d_from, d_to
            order by d_to desc, d_from desc");
            if($db->nf())
            {
                  $tab_sql = array();
                  while($db->next_record())
                  {
                        if(($db->f('d_to') <= $db->f('d_from')) || ($db->f('d_to') == ""))
                        {
                              if(!in_array($db->f('d_from'),$tab_sql))
                                    $tab_sql[] = $db->f('d_from');
                        }
                        else
                        {
                              $st[0] = substr($db->f('d_from'),0,4);
                              $st[1] = substr($db->f('d_from'),-2);
                              
                              while(1)
                              {
                                    $dd = date("Y-m", mktime(0,0,0,$st[1],1,$st[0]));
                                    if(!in_array($dd,$tab_sql))
                                          $tab_sql[] = $dd;
                                    $st[1] = $st[1] + 1;
                                    if($st[1] == 13)
                                    {
                                          $st[0] = $st[0] + 1;
                                          $st[1] = 1;
                                    }
                                    
                                    if(date("Y-m",mktime(0,0,0,$st[1],1,$st[0])) > $db->f('d_to'))
                                          break;
                              }
                        }
                  }
            }
            if(isset($tab_sql))      
                  arsort($tab_sql);
            
            if(isset($tab_sql))      
            if(sizeof($tab_sql))
            {
                  $this->tmpl->set_var('option_selected', "");
                  $this->tmpl->set_var('select_name', "calendar_select");
                  if(isset($this->show_all_select))
                  {
                        $this->tmpl->set_var('option_', "[wszystkie]");
                        $this->tmpl->set_var('option_value', "-1");
                        $this->tmpl->parse('select_', 'table_option', true);  
                  }                
                  while(list($k, $l)=each($tab_sql))
                  {
                        $year = mb_substr($l, 0, 4);
                        $month = mb_substr($l, -2);
                        if($this->type == "month_year")
                        {
                              $f_month++;
                              if(mb_substr($_GET["ym"], 0, 7) == $l || (!$_GET["ym"] && $this->auto_select == "m" && $f_month == 1))
                              {
                                    $this->tmpl->set_var('option_selected', " selected=\"selected\"");
                              }
                              else      
                                    $this->tmpl->set_var('option_selected', "");
                              $this->tmpl->set_var('option_', File::month($month, $_SESSION["id_language"])."&nbsp;".$year."&nbsp;");
                              $this->tmpl->set_var('option_value', $l);
                              $this->tmpl->parse('select_', 'table_option', true);
                        }
                        else
                        {
                              if(!in_array($year, $arr_years))
                              {
                                    $f_year++;
                                    if(mb_substr($_GET["ym"], 0, 4) == $year || (!$_GET["ym"] && $this->auto_select == "y" && $f_year == 1))
                                    {
                                          $this->tmpl->set_var('option_selected', " selected=\"selected\"");
                                    }
                                    else      
                                          $this->tmpl->set_var('option_selected', "");
                                          
                                    $this->tmpl->set_var('option_', $year);
                                    $this->tmpl->set_var('option_value', $year);
                                    
                                    $arr_years[] = $year;
                                    $this->tmpl->parse('select_', 'table_option', true);
                              }
                              
                              if($this->type == "month")
                              {
                                    $f_month++;
                                    if(mb_substr($_GET["ym"], 0, 7) == $l || (!$_GET["ym"] && $this->auto_select == "m" && $f_month == 1))
                                    {
                                          $this->tmpl->set_var('option_selected', " selected=\"selected\"");
                                    }
                                    else      
                                          $this->tmpl->set_var('option_selected', "");
                                    $this->tmpl->set_var('option_', "&nbsp;&bull;&nbsp;".File::month($month, $_SESSION["id_language"]));
                                    $this->tmpl->set_var('option_value', $l);
                                    $this->tmpl->parse('select_', 'table_option', true);
                              }
                        }
                  }
            }
            $this->where = $this->make_calendar_where($tab, $date_from, $date_to);
            
            return $this->tmpl->subst('table_select');
      }      
      
      function show_months_calendar_union($tab, $date_from, $date_to, $sql, $tab2, $date_from2, $date_to2, $sql2)      {            

            $this->tmpl->set_block('blocks','table_select');
            $this->tmpl->set_block('blocks','table_option');            

            if(isset($this->onchange))
                  $this->tmpl->set_var('id_select', $this->onchange);                  
            else
                  $this->tmpl->set_var('id_select', "");
                  
            $arr_years = array();
            $f_year = 0;
            $f_month = 0;
            if(!isset($_GET["ym"]))
            { 
                  $db = new DB__("select if($tab.$date_to is null or date_format($tab.$date_from,'%Y-%m') > date_format(now(),'%Y-%m'), date_format($tab.$date_from,'%Y-%m'), date_format(now(),'%Y-%m')) as date_row from $tab
                  ".$this->left_join."
                  where (date_format($tab.$date_from,'%Y-%m') >= date_format(now(),'%Y-%m') or date_format($tab.$date_to,'%Y-%m') >= date_format(now(),'%Y-%m')) $sql
                  union
                  select if($tab2.$date_to2 is null or date_format($tab2.$date_from2,'%Y-%m') > date_format(now(),'%Y-%m'), date_format($tab2.$date_from2,'%Y-%m'), date_format(now(),'%Y-%m')) as date_row from $tab2
                  ".$this->left_join2."
                  where (date_format($tab2.$date_from2,'%Y-%m') >= date_format(now(),'%Y-%m') or date_format($tab2.$date_to2,'%Y-%m') >= date_format(now(),'%Y-%m')) $sql2
                  order by date_row
                  limit 0,1");    
                  if($db->next_record())
                        $_GET["ym"] = $db->f('date_row');
                  else
                  {
                        $db = new DB__("select if($tab.$date_to is null, date_format(max($tab.$date_from),'%Y-%m'), date_format(max($tab.$date_to),'%Y-%m')) as date_row from $tab
                        ".$this->left_join."
                        where 1 $sql
                        union
                        select if($tab2.$date_to2 is null, date_format(max($tab2.$date_from2),'%Y-%m'), date_format(max($tab2.$date_to2),'%Y-%m')) as date_row from $tab2
                        ".$this->left_join2."
                        where 1 $sql2
                        order by date_row desc
                        limit 0,1");                        
                        if($db->next_record())
                              $_GET["ym"] = $db->f('date_row');
                        else
                              $_GET["ym"] = null;
                  }
            }

            $db = new DB__("select date_format($tab.$date_from,'%Y-%m') as d_from, date_format($tab.$date_to,'%Y-%m') as d_to from $tab
            ".$this->left_join."
            where 1 $sql
            union
            select date_format($tab2.$date_from2,'%Y-%m') as d_from, date_format($tab2.$date_to2,'%Y-%m') as d_to from $tab2
            ".$this->left_join2."
            where 1 $sql2
            group by d_from, d_to
            order by d_to desc, d_from desc");
            if($db->nf())
            {
                  $tab_sql = array();
                  while($db->next_record())
                  {
                        if(($db->f('d_to') <= $db->f('d_from')) || ($db->f('d_to') == ""))
                        {
                              if(!in_array($db->f('d_from'),$tab_sql))
                                    $tab_sql[] = $db->f('d_from');
                        }
                        else
                        {
                              $st[0] = substr($db->f('d_from'),0,4);
                              $st[1] = substr($db->f('d_from'),-2);
                              
                              while(1)
                              {
                                    $dd = date("Y-m", mktime(0,0,0,$st[1],1,$st[0]));
                                    if(!in_array($dd,$tab_sql))
                                          $tab_sql[] = $dd;
                                    $st[1] = $st[1] + 1;
                                    if($st[1] == 13)
                                    {
                                          $st[0] = $st[0] + 1;
                                          $st[1] = 1;
                                    }
                                    
                                    if(date("Y-m",mktime(0,0,0,$st[1],1,$st[0])) > $db->f('d_to'))
                                          break;
                              }
                        }
                  }
            }
            if(isset($tab_sql))      
                  arsort($tab_sql);
         
            if(isset($tab_sql))      
            if(sizeof($tab_sql))
            {
                  $this->tmpl->set_var('option_selected', "");
                  $this->tmpl->set_var('select_name', "calendar_select");
                  if(isset($this->show_all_select))
                  {
                        $this->tmpl->set_var('option_', "[wszystkie]");
                        $this->tmpl->set_var('option_value', "-1");
                        $this->tmpl->parse('select_', 'table_option', true);  
                  }                
                  while(list($k, $l)=each($tab_sql))
                  {
                        $year = mb_substr($l, 0, 4);
                        $month = mb_substr($l, -2);
                        if($this->type == "month_year")
                        {
                              $f_month++;
                              if(mb_substr($_GET["ym"], 0, 7) == $l || (!$_GET["ym"] && $this->auto_select == "m" && $f_month == 1))
                              {
                                    $this->tmpl->set_var('option_selected', " selected=\"selected\"");
                              }
                              else      
                                    $this->tmpl->set_var('option_selected', "");
                              $this->tmpl->set_var('option_', File::month($month, $_SESSION["id_language"])."&nbsp;".$year."&nbsp;");
                              $this->tmpl->set_var('option_value', $l);
                              $this->tmpl->parse('select_', 'table_option', true);
                        }
                        else
                        {
                              if(!in_array($year, $arr_years))
                              {
                                    $f_year++;
                                    if(mb_substr($_GET["ym"], 0, 4) == $year || (!$_GET["ym"] && $this->auto_select == "y" && $f_year == 1))
                                    {
                                          $this->tmpl->set_var('option_selected', " selected=\"selected\"");
                                    }
                                    else      
                                          $this->tmpl->set_var('option_selected', "");
                                          
                                    $this->tmpl->set_var('option_', $year);
                                    $this->tmpl->set_var('option_value', $year);
                                    
                                    $arr_years[] = $year;
                                    $this->tmpl->parse('select_', 'table_option', true);
                              }
                              
                              if($this->type == "month")
                              {
                                    $f_month++;
                                    if(mb_substr($_GET["ym"], 0, 7) == $l || (!$_GET["ym"] && $this->auto_select == "m" && $f_month == 1))
                                    {
                                          $this->tmpl->set_var('option_selected', " selected=\"selected\"");
                                    }
                                    else      
                                          $this->tmpl->set_var('option_selected', "");
                                    $this->tmpl->set_var('option_', "&nbsp;&bull;&nbsp;".File::month($month, $_SESSION["id_language"]));
                                    $this->tmpl->set_var('option_value', $l);
                                    $this->tmpl->parse('select_', 'table_option', true);
                              }
                        }
                  }
            }
            $this->where = $this->make_calendar_where($tab, $date_from, $date_to);
            
            return $this->tmpl->subst('table_select');
      }      
      
      
      function make_calendar_where($tab, $date_from, $date_to)
      {   
            if(isset($_GET["ym"]))
            {
                  if(mb_strlen($_GET["ym"]) == 4)
                        return " and (date_format($tab.$date_from, '%Y') = '".$_GET["ym"]."' or (date_format($tab.$date_from, '%Y') <= '".$_GET["ym"]."' and date_format($tab.$date_to, '%Y') >= '".$_GET["ym"]."'))";
                  else if(mb_strlen($_GET["ym"]) == 7)
                        return " and (date_format($tab.$date_from, '%Y-%m') = '".$_GET["ym"]."' or (date_format($tab.$date_from, '%Y-%m') <= '".$_GET["ym"]."' and date_format($tab.$date_to, '%Y-%m') >= '".$_GET["ym"]."'))";
                  else if(mb_strlen($_GET["ym"]) == 10)
                        return " and (date_format($tab.$date_from, '%Y-%m-%d') = '".$_GET["ym"]."' or (date_format($tab.$date_from, '%Y-%m-%d') <= '".$_GET["ym"]."' and date_format($tab.$date_to, '%Y-%m-%d') >= '".$_GET["ym"]."'))";
            }
      }
               
      function show_calendar($tab, $date_from, $date_to, $sql)
      {            
            $this->tmpl->set_block('blocks2','calendar');
            $this->tmpl->set_block('blocks2','calendar_row');            
            $this->tmpl->set_block('blocks2','calendar_row_a');            
                  

            if(isset($_GET["ym"]))
            {
                  if(mb_strlen($_GET["ym"]) >= 7)
                  {
                        $month = mb_substr($_GET["ym"], 5, 2);
                        $year = mb_substr($_GET["ym"], 0, 4);
   
                        if(mb_strlen($_GET["ym"]) == 10)
                              $day = mb_substr($_GET["ym"], -2);
                        else
                              $day = null;

                        $last_day = date('d', mktime(0,0,0, $month + 1, 0, $year)); 
                        $tab_sql = array();
                        $tab_sql_h = array();
                        
                        $db = new DB__("select id_category, date_format($tab.$date_from,'%d') as day_from, $tab.$date_from as date_from, date_format($tab.$date_to,'%d') as day_to, $tab.$date_to as date_to from $tab
                        ".$this->left_join."
                        where (date_format($tab.$date_from,'%Y-%m') = '".$year."-".$month."' or (date_format($tab.$date_from,'%Y-%m') <= '".$year."-".$month."' && date_format($tab.$date_to,'%Y-%m') >= '".$year."-".$month."')) $sql");
                        
                        while($db->next_record())
                        {
                              if($db->f('id_category') == 2)
                                    $tab_sql_h[] = $db->f('day_from') + 0;
                              if($db->f('day_to') == "")
                              {
                                    if(!in_array($db->f('day_from'),$tab_sql))
                                          $tab_sql[] = $db->f('day_from') + 0;
                              }
                              else
                              {
                                    if($db->f('date_from') >= $year."-".$month."-"."01")
                                          $d_od = substr($db->f('date_from'),8,2);
                                    else
                                          $d_od = 1;
                              
                                    if($db->f('date_to') <= $year."-".$month."-".$last_day)
                                          $d_do = substr($db->f('date_to'),8,2);
                                    else
                                          $d_do = $last_day + 0;
                                    
                                    for($i = $d_od;$i <= $d_do;$i++)
                                    {
                                          if(!in_array($i,$tab_sql))
                                          $tab_sql[] = $i + 0;
                                    }
                              }
                        }
                        if(date("w",mktime(0,0,0,$month,1,$year)) == 0)
                              $week_day = 6;
                        else
                              $week_day = date("w",mktime(0,0,0,$month,1,$year))-1;
                              
                        $very_last_day = $last_day + $week_day;
                        if($very_last_day > 35)
                              $last_row = 42;
                        else
                              $last_row = 35;
                              
                        for($i = 1;$i <= $last_row;$i++)
                        {
                              $cur_day = $i - $week_day;
                              
                              if($i > $week_day && $i <= $very_last_day)
                                    $this->tmpl->set_var('cal_', $cur_day);
                              else
                                    $this->tmpl->set_var('cal_', "");
                              
                              if(in_array($cur_day, $tab_sql))  
                              {
                                    if(mb_strlen($cur_day) == 1)
                                          $dday = "0".$cur_day;
                                    else
                                          $dday = $cur_day;  
                                                                            
                                    if(in_array($cur_day, $tab_sql_h))
                                          $this->tmpl->set_var('cal_check', "2");
                                    else
                                          $this->tmpl->set_var('cal_check', "");
                                          
                                    $this->tmpl->set_var('cal_id', $this->get_id);
                                    $this->tmpl->set_var('cal_ym', $year."-".$month."-".$dday);
                                          
                                    if($this->cell_link_type == "link")
                                          $this->tmpl->set_var('cal_href', "index.php?id=".$this->get_id."&amp;ym=$year-$month-$dday");
                                    else if($this->cell_link_type == "ajax")
                                    {
                                          if(isset($this->get_id))
                                                $this->tmpl->set_var('cal_href', "javascript:ajax_change_div('../pl/ajax.php','main_calendar_rows','idek=".$this->get_id."&amp;type=calendar_rows&amp;ym=$year-$month-$dday');void(0);");
                                          else
                                                $this->tmpl->set_var('cal_href', "javascript:ajax_change_div('../pl/ajax.php','main_calendar_rows','type=calendar_rows&amp;ym=$year-$month-$dday');void(0);");
                                    }
                                    
                                    $this->tmpl->set_var('cal_date', "$year-$month-$dday");
                                    $this->tmpl->set_var('cal_title', "Kliknij aby zobaczyć wydarzenia z dnia: $year-$month-$dday");
                                    $this->tmpl->parse('calendar_row_','calendar_row_a',true);
                              }
                              else
                              {    
                                    $this->tmpl->set_var('cal_title', "");
                                    $this->tmpl->parse('calendar_row_','calendar_row',true);
                              }
                        }

                        return $this->tmpl->subst('calendar');
                  }
            }
                           
      }
         
      function show_calendar_union($tab, $date_from, $date_to, $sql, $tab2, $date_from2, $date_to2, $sql2)
      {            
            $this->tmpl->set_block('blocks2','calendar');
            $this->tmpl->set_block('blocks2','calendar_row');            
            $this->tmpl->set_block('blocks2','calendar_row_a');            
                  

            if(isset($_GET["ym"]))
            {
                  if(mb_strlen($_GET["ym"]) >= 7)
                  {
                        $month = mb_substr($_GET["ym"], 5, 2);
                        $year = mb_substr($_GET["ym"], 0, 4);
   
                        if(mb_strlen($_GET["ym"]) == 10)
                              $day = mb_substr($_GET["ym"], -2);
                        else
                              $day = null;

                        $last_day = date('d', mktime(0,0,0, $month + 1, 0, $year)); 
                        $tab_sql = array();
                        
                        $db = new DB__("select date_format($tab.$date_from,'%d') as day_from, $tab.$date_from as date_from, date_format($tab.$date_to,'%d') as day_to, $tab.$date_to as date_to from $tab
                        ".$this->left_join."
                        where (date_format($tab.$date_from,'%Y-%m') = '".$year."-".$month."' or (date_format($tab.$date_from,'%Y-%m') <= '".$year."-".$month."' && date_format($tab.$date_to,'%Y-%m') >= '".$year."-".$month."')) $sql
                        union 
                        select date_format($tab2.$date_from2,'%d') as day_from, $tab2.$date_from2 as date_from, date_format($tab2.$date_to2,'%d') as day_to, $tab2.$date_to2 as date_to from $tab2
                        ".$this->left_join2."
                        where (date_format($tab2.$date_from2,'%Y-%m') = '".$year."-".$month."' or (date_format($tab2.$date_from2,'%Y-%m') <= '".$year."-".$month."' && date_format($tab2.$date_to2,'%Y-%m') >= '".$year."-".$month."')) $sql2                        
                        ");
                        
                        while($db->next_record())
                        {
                              if($db->f('day_to') == "")
                              {
                                    if(!in_array($db->f('day_from'),$tab_sql))
                                          $tab_sql[] = $db->f('day_from') + 0;
                              }
                              else
                              {
                                    if($db->f('date_from') >= $year."-".$month."-"."01")
                                          $d_od = substr($db->f('date_from'),8,2);
                                    else
                                          $d_od = 1;
                              
                                    if($db->f('date_to') <= $year."-".$month."-".$last_day)
                                          $d_do = substr($db->f('date_to'),8,2);
                                    else
                                          $d_do = $last_day + 0;
                                    
                                    for($i = $d_od;$i <= $d_do;$i++)
                                    {
                                          if(!in_array($i,$tab_sql))
                                          $tab_sql[] = $i + 0;
                                    }
                              }
                        }
                        if(date("w",mktime(0,0,0,$month,1,$year)) == 0)
                              $week_day = 6;
                        else
                              $week_day = date("w",mktime(0,0,0,$month,1,$year))-1;
                              
                        $very_last_day = $last_day + $week_day;
                        if($very_last_day > 35)
                              $last_row = 42;
                        else
                              $last_row = 35;
                              
                        for($i = 1;$i <= $last_row;$i++)
                        {
                              $cur_day = $i - $week_day;
                              
                              if($i > $week_day && $i <= $very_last_day)
                                    $this->tmpl->set_var('cal_', $cur_day);
                              else
                                    $this->tmpl->set_var('cal_', "");
                              
                              if(in_array($cur_day, $tab_sql))  
                              {
                                    if(mb_strlen($cur_day) == 1)
                                          $dday = "0".$cur_day;
                                    else
                                          $dday = $cur_day;  
                                                                            
                                    if($day == $dday)
                                          $this->tmpl->set_var('cal_check', "2");
                                    else
                                          $this->tmpl->set_var('cal_check', "");
                                          
                                    $this->tmpl->set_var('cal_id', $this->get_id);
                                    $this->tmpl->set_var('cal_ym', $year."-".$month."-".$dday);
                                          
                                    if($this->cell_link_type == "link")
                                          $this->tmpl->set_var('cal_href', "index.php?id=".$this->get_id."&amp;ym=$year-$month-$dday");
                                    else if($this->cell_link_type == "ajax")
                                    {
                                          if(isset($this->get_id))
                                                $this->tmpl->set_var('cal_href', "javascript:ajax_change_div('../pl/ajax.php','main_calendar_rows','idek=".$this->get_id."&amp;type=calendar_rows&amp;ym=$year-$month-$dday');void(0);");
                                          else
                                                $this->tmpl->set_var('cal_href', "javascript:ajax_change_div('../pl/ajax.php','main_calendar_rows','type=calendar_rows&amp;ym=$year-$month-$dday');void(0);");
                                    }
                                    
                                    $this->tmpl->set_var('cal_onclick', "main_calendar_orange_cell();this.className='cell_div main_calendar_bckg2';");
                                    $this->tmpl->parse('calendar_row_','calendar_row_a',true);
                              }
                              else
                              {    
                                    $this->tmpl->parse('calendar_row_','calendar_row',true);
                                    $this->tmpl->set_var('cal_onclick', "");
                              }
                        }

                        return $this->tmpl->subst('calendar');
                  }
            }
                           
      }
         
}

class Site_files
{    
      function __construct()
      {
      }
      
      static function show_files($idd, $id_template, $classname = "ul__")
      {
            global $tmpl;
            $result = array();
            
            $file_array = array();
            $file_array["doc"] = "doc.png";
            $file_array["docx"] = "doc.png";
            $file_array["xls"] = "xls.png";
            $file_array["pdf"] = "pdf.png";
            
            if($id_template == 0)
                  $db = new DB__("select file.id, file.counter, file.title, file.path, file_category.name as label from file
                  left join file_category on file_category.id=file.id_category
                  where file.idd='$idd' and file.id_template='$id_template' and file.active='1' and file.id_lang='".$_SESSION["id_language"]."'
                  order by file.id_category, file.ord");
            else
                  $db = new DB__("select file.id, file.counter, file.title, file.path, file_category.name as label from file
                  left join file_category on file_category.id=file.id_category
                  where file.idd='$idd' and file.id_template=
                  (select id_template from template_menu where template_menu.id_menu='$id_template')
                  and file.active='1' and file.id_lang='".$_SESSION["id_language"]."'
                  order by file.id_category, file.ord");
            if($db->nf())
            {
                  $label = "";
                  $tmpl->set_var("ul_", "");
                  $next = 0;
                  while($db->next_record())
                  {
                        $next++;
                        if($db->f('label') != $label)
                        {
                              $tmpl->set_var('label', "<h3 class=\"col_text marup20\"><strong>".$db->f('label').":</strong></h3>");
                              $label = $db->f('label');
                        }
                        
                        $extension = mb_substr($db->f('path'), mb_strrpos($db->f('path'),".")+1);
                        
                        if($db->f('counter') > 0)
                              $counter = ", ilość pobrań: ".$db->f('counter');
                        else
                              $counter = "";
                                                
                        if(array_key_exists($extension, $file_array) == true)
                              $icon = "<img src=\"".PATH_IMG_MAIN.$file_array[$extension]."\" alt=\"\"/>&nbsp;";
                        else
                              $icon = "<img src=\"".PATH_IMG_MAIN."file.png\" alt=\"\"/>&nbsp;";
                                                
                        $tmpl->set_var("a_", $icon.$db->f('title')."&nbsp;(".mb_strtoupper($extension).", ".file_size_mb(PATH_DOC.$db->f('path')).$counter.")");
                        $tmpl->set_var("id_a", " onclick=\"window.open(this.href,'_blank');return false;\"");                 
                        $tmpl->set_var("a_link", "../pl/download.php?id=".$db->f('id')."&amp;path=".PATH_DOC);                 
                        $tmpl->parse("li_",'table_a');
                        
                        if($next == $db->nf())
                              $tmpl->set_var("id_li", " class=\"_last\"");
                        else
                              $tmpl->set_var("id_li", "");
            
                        $tmpl->parse('ul_','table_li', true);
                  }
                     
                  $tmpl->set_var("id_ul", " class=\"".$classname."\"");
                  $result[0] = $tmpl->subst('table_ul');
                  $result[1] = $tmpl->subst('table_label');       
                                                    
                  return $result;
            }
            else
                  return null;
      }
}
?><?
class Google_map
{
      public $g_width = 400;
      public $g_height = 320;
      private $tmpl;
      function __construct()
      {
            $this->tmpl = new Template("../htmls");
            $this->tmpl->set_file('blocks','google.html');
            $this->tmpl->set_block('blocks','google_main');
            $this->tmpl->set_block('blocks','google_main_cms');
            $this->tmpl->set_block('blocks','google_add_new_point');
            $this->tmpl->set_block('blocks','google_add_point');
            $this->tmpl->set_block('blocks','auction_table_row_float');
            $this->tmpl->set_var('google_points', "");
            $this->tmpl->set_var('GOOGLE_Y', GOOGLE_Y);
            $this->tmpl->set_var('GOOGLE_X', GOOGLE_X);
            $this->tmpl->set_var('google_zoom', 17);
      }
      
      function google_make_description($category, $street, $city, $code, $phone, $fax, $email, $www, $link = null)
      {   
            $this->tmpl->set_var('desc_', '');            
            if($category != "")
            {
                  $this->tmpl->set_var('form_label', "");
                  $this->tmpl->set_var("form_text", $category);
                  $this->tmpl->parse('desc_', 'auction_table_row_float', true);            
            }
            $address = "";
            if($street != "")
            {
                  $this->tmpl->set_var("form_label", $street);
                  $this->tmpl->set_var("form_text", "");
                  $this->tmpl->parse('desc_', 'auction_table_row_float', true);            
            }
            if($city != "")
            {
                  if($code != "")
                        $address .= $code." ".$city;
                  else
                        $address .= $city;
            }     
            if($address != "")
            {
                  $this->tmpl->set_var("form_label", $address);
                  $this->tmpl->set_var("form_text", "");
                  $this->tmpl->parse('desc_', 'auction_table_row_float', true);            
            }
            
                   
            if($phone != "")
            {
                  $this->tmpl->set_var("form_label", "Nr telefonu: ");
                  $this->tmpl->set_var("form_text", $phone);
                  $this->tmpl->parse('desc_', 'auction_table_row_float', true);
            }
            
            if($link != "")
            {
                  $this->tmpl->set_var("form_label", $link);
                  $this->tmpl->set_var("form_text", "");
                  $this->tmpl->parse('desc_', 'auction_table_row_float', true);
            }

            if($fax != "")
            {
                  $this->tmpl->set_var("form_label", "Nr faksu: ");
                  $this->tmpl->set_var("form_text", $fax);
                  $this->tmpl->parse('desc_', 'auction_table_row_float', true);
            }
            if($www != "")
            {
                  $this->tmpl->set_var("form_label", "WWW: ");
                  
                        $email_arr = explode(",", $www);
                        while(list($kk, $vv)=each($email_arr))
                        {
                              $this->tmpl->set_var("a_", $vv);
                              $this->tmpl->set_var("br", ", ");                 
                              $this->tmpl->set_var("id_a", "");   
                              if(mb_strpos($vv, "http://") === false)              
                                    $this->tmpl->set_var("a_link", "http://".trim($vv));  
                              else
                                    $this->tmpl->set_var("a_link", trim($vv));  
                                             
                              $this->tmpl->parse("www_",'table_a',true);
                              if(sizeof($email_arr) > ($kk + 1))
                                    $this->tmpl->parse("www_",'br',true);
                        }

                  $this->tmpl->parse("form_text", 'www_');
                  $this->tmpl->parse('desc_', 'auction_table_row_float', true);
            }
            if($email != "")
            {
                  $this->tmpl->set_var("form_label", "E-mail: ");
                  
                        $email_arr = explode(",", $email);
                        while(list($kk, $vv)=each($email_arr))
                        {
                              $this->tmpl->set_var("a_", $vv);
                              $this->tmpl->set_var("br", ", ");                 
                              $this->tmpl->set_var("id_a", "");                 
                              $this->tmpl->set_var("a_link", "mailto:".$vv);                 
                              $this->tmpl->parse("email_",'table_a',true);
                              if(sizeof($email_arr) > ($kk + 1))
                                    $this->tmpl->parse("email_",'br',true);
                        }

                  $this->tmpl->parse("form_text", 'email_');
                  $this->tmpl->parse('desc_', 'auction_table_row_float', true);
            }

            return $this->tmpl->subst('desc_');                     
      }

      function google_calc_zoom($min_x, $max_x, $min_y, $max_y)
      {                        
            $this->google_calc_center($min_x, $max_x, $min_y, $max_y);
            
            $dist_x = floatval($max_x - $min_x);
            $dist_y = floatval($max_y - $min_y);
            $this->tmpl->set_var('google_zoom', "google_calc_zoom($dist_x, $dist_y)");
      }

      function google_calc_center($min_x, $max_x, $min_y, $max_y)
      {                        
            $c_x = floatval(($max_x + $min_x)/2);
            $c_y = floatval(($max_y + $min_y)/2);
            $this->tmpl->set_var('GOOGLE_X', $c_x);
            $this->tmpl->set_var('GOOGLE_Y', $c_y);
      }

      function google_add_new_point($x, $y, $center = 0)
      {                        
            $this->tmpl->set_var('n_y', $y);
            $this->tmpl->set_var('n_x', $x);
            $this->tmpl->set_var('n_center', $center);
            $this->tmpl->parse('google_points', 'google_add_new_point', true);
      }

      function google_add_point($x, $y, $id, $n_address, $n_info, $n_photo, $n_image, $n_id_category, $n_show, $n_ico = null)
      {                        
            $this->tmpl->set_var('n_y', $y);
            $this->tmpl->set_var('n_x', $x);
            $this->tmpl->set_var('n_id', $id);
            $this->tmpl->set_var('n_show', $n_show);
            $this->tmpl->set_var('n_address', $this->google_del_apostrof($n_address));
            $this->tmpl->set_var('n_info', $this->google_del_apostrof($n_info));
            $this->tmpl->set_var('n_photo', $n_photo);
            $this->tmpl->set_var('n_image', $n_image);
            $this->tmpl->set_var('n_ico', $n_ico);
            $this->tmpl->set_var('n_id_category', $n_id_category);
            $this->tmpl->parse('google_points', 'google_add_point', true);
      }
      
      function google_del_apostrof($str)
      {                        
            $str = mb_ereg_replace("\r", "", $str);
            $str = mb_ereg_replace("\n", "", $str);
            $str = mb_ereg_replace("\"","\\\"",$str);
            $str = mb_ereg_replace("\'","\\\'",$str);
            
            return $str;
      }
      
      function create_google_map()
      {                        
            $this->tmpl->set_var('g_width', $this->g_width);
            $this->tmpl->set_var('g_height', $this->g_height);
            return $this->tmpl->subst('google_main');
      }
      
      function create_google_map_cms()
      {                        
            $this->tmpl->set_var('g_width', $this->g_width);
            $this->tmpl->set_var('g_height', $this->g_height);
            return $this->tmpl->subst('google_main_cms');
      }
}
?><?
class Offer
{
      private $main_roots = array();
      
      function __construct($id = null)
      {
      }
      
      function make_category_roots($id)
      {
            $db = new DB__("select category_multi.id, category_multi.root, category_multi_lang.name from category_multi, category_multi_lang
            where category_multi_lang.id_category=category_multi.id and category_multi_lang.id_lang='".$_SESSION["id_language"]."' and category_multi.id='".$id."'");
            if($db->next_record())
            {
                  $this->main_roots[] = array($db->f('id'), $db->f('name'));
                  
                  if($db->f('root') == '-1')
                        return $this->main_roots;
                        
                  $this->make_category_roots($db->f('root'));
            }
            return $this->main_roots;
      }
      function make_category_roots_arr($id)
      {
            $db = new DB__("select category_multi.id, category_multi.root, category_multi_lang.name from category_multi, category_multi_lang
            where category_multi_lang.id_category=category_multi.id and category_multi_lang.id_lang='".$_SESSION["id_language"]."' and category_multi.id='".$id."'");
            if($db->next_record())
            {
                  $this->main_roots[] = $db->f('id');
                  
                  if($db->f('root') == '-1')
                        return $this->main_roots;
                        
                  $this->make_category_roots_arr($db->f('root'));
            }
            return $this->main_roots;
      }
      function make_category_idek($id)
      {
            $str_cat = "";
            $db = new DB__("select id from category_multi, category_multi_lang where category_multi_lang.id_category=category_multi.id and category_multi_lang.id_lang='".$_SESSION["id_language"]."' and (category_multi.id='".$id."' or (category_multi.id in (select id from category_multi where category_multi.root='".$id."')) or (category_multi.id in (select id from category_multi where category_multi.root in (select id from category_multi where category_multi.root='".$id."'))))");
            if($db->nf())
            {
                  while($db->next_record())
                  {
                        $str_cat .= $db->f('id').",";
                  }
                  return substr($str_cat,0,-1);
            }
            else
                  return false;
      }
      function make_category_arr($id)
      {
            $str_cat = array();
            $db = new DB__("select id from category_multi where (category_multi.id='".$id."' or (category_multi.id in (select id from category_multi where category_multi.root='".$id."')) or (category_multi.id in (select id from category_multi where category_multi.root in (select id from category_multi where category_multi.root='".$id."'))))");
            if($db->nf())
            {
                  while($db->next_record())
                  {
                        $str_cat[] = $db->f('id');
                  }
                  return $str_cat;
            }
            else
                  return false;
      }
}

class Video_YT
{
      //Sabatoni
      
      //<iframe width="420" height="315" src="http://www.youtube.com/embed/epeQwq-aYV0" frameborder="0" allowfullscreen></iframe>
      //http://www.youtube.com/watch?v=0yFt-ZGeeWQ&feature=related
      //http://www.youtube.com/watch?v=epeQwq-aYV0
      //http://www.youtu.be/vNjKEUjSpMI
      
      //Vimeo tesst <iframe src="http://player.vimeo.com/video/30409329" width="400" height="225" frameborder="0"></iframe>
      //http://vimeo.com/musicstore/track/23161
      //http://vimeo.com/track/23161/hd#30409329
      //http://vimeo.com/7809605
      
      public $player_w = VIDEO_W;
      public $player_h = VIDEO_H;
      public $v_type = null;
      public $v_str = null;
      private $video_types = array('1'=>'youtu','2'=>'vimeo.com');
      
      function __construct($str)
      {
            $this->v_str = $str;
            $this->check_type();
      }
      
      function check_type()
      {
            while(list($k, $l) = each($this->video_types))
            {
                  if(mb_strpos($this->v_str, $l) !== false)
                  {
                        $this->v_type = $k;
                        break;
                  }
            }   
            if(!isset($this->v_type))
                  return false;
            else
                  return true;
                           
      }
      
      function get_id()
      {
            if($this->v_type == 1)//YT
            {
                  //http://www.youtube.com/watch?v=0yFt-ZGeeWQ&feature=related
                  //http://www.youtube.com/KreatywniLDZ#p/a/f/0/vNjKEUjSpMI
                  //http://www.youtu.be/vNjKEUjSpMI
                  $str_temp = mb_substr($this->v_str, (mb_strrpos($this->v_str, "/") + 1));
                  
                  if(mb_strpos($str_temp, "v=") !== false)
                        $start_temp = mb_strpos($str_temp, "v=") + 2;
                  else
                        $start_temp = 0;
                        
                  $length_temp = (mb_strpos($str_temp, "&") - mb_strpos($str_temp, "v=") - 2);
                  
                  if(mb_strpos($str_temp, "&") !== false)
                        return mb_substr($str_temp, $start_temp, $length_temp);       
                  else     
                        return mb_substr($str_temp, $start_temp);       
            }
            else if($this->v_type == 2)//Vimeo
            {
                  //http://vimeo.com/track/23161/hd#30409329
                  return ereg_replace("hd#", "", mb_substr($this->v_str, (mb_strrpos($this->v_str, "/") + 1)));                         
            }
      }
      
      function get_video_html()
      {
            if($this->v_type == 1)//YT
            {
                  return "<iframe id=\"flv_player\" width=\"".$this->player_w."\" height=\"".$this->player_h."\" src=\"http://www.youtube-nocookie.com/embed/".$this->get_id()."?wmode=transparent\" frameborder=\"0\" style=\"z-index:1;\" wmode=\"Opaque\" allowfullscreen></iframe>";       
            }
            else if($this->v_type == 2)//Vimeo
            {
                  return "<iframe id=\"flv_player\" src=\"http://player.vimeo.com/video/".$this->get_id()."\" width=\"".$this->player_w."\" height=\"".$this->player_h."\" frameborder=\"0\"></iframe>";                         
            }
      }     
}
      
class Announcement_add
{
      private $tmpl;
      public $id_template = null;
      
      function __construct($id = null)
      {
            $this->tmpl = new Template("../htmls");
            $this->tmpl->set_file('blocks','main.html');
            
            if(isset($id))
            {
                  $db = new DB__("select id_template from template_menu where id_menu='".$id."'");
                  if($db->next_record())
                        $this->id_template = $db->f('id_template');      
            }
      }
      
      function set_params_form_registry($arr_select, $tab_inp, $form)
      {
            $db = new DB__("select category_multi_lang.id, category_multi_lang.name from category_multi_lang
where category_multi_lang.id_lang='".$_SESSION["id_language"]."' and category_multi_lang.id_menu='46'
order by category_multi_lang.id");
            if($db->nf())
                  while($db->next_record())
                        $arr_select["id_kind"][] = array($db->f('id'), $db->f('name'));
/*
            $db = new DB__("select category_multi_lang.id, category_multi_lang.name from category_multi_lang
where category_multi_lang.id_lang='".$_SESSION["id_language"]."' and category_multi_lang.id_menu='39'
order by category_multi_lang.id");
            if($db->nf())
                  while($db->next_record())
                        $arr_select["id_degree"][] = array($db->f('id'), $db->f('name'));
*/

            if(!isset($_SESSION["firm"]))
                  $db = new DB__("select category_multi_lang.* from category_multi_lang 
                  where category_multi_lang.id_menu='42' and id_lang='".$_SESSION["id_language"]."'
                  order by category_multi_lang.name");
            else
                  $db = new DB__("select category_multi_lang.*, firm_specialization_temp.id_firm from category_multi_lang 
                  left join firm_specialization_temp on firm_specialization_temp.id_specialization=category_multi_lang.id and firm_specialization_temp.id_firm='".$_SESSION["firm"]."'
                  where category_multi_lang.id_menu='42' and id_lang='".$_SESSION["id_language"]."'
                  order by firm_specialization_temp.id_firm desc, category_multi_lang.name");

            if($db->nf())
                  while($db->next_record())
                        $arr_select["id_specialization[]"][] = array($db->f('id'), $db->f('name'), $db->f('id_firm'));
                        
            $db = new DB__("select category_multi_lang.id, category_multi_lang.name from category_multi_lang
where category_multi_lang.id_lang='".$_SESSION["id_language"]."' and category_multi_lang.id_menu='41'
order by category_multi_lang.id");
            if($db->nf())
                  while($db->next_record())
                        $arr_select["id_school"][] = array($db->f('id'), $db->f('name'));
/*
            $db = new DB__("select voivodeship.id, voivodeship.name from voivodeship
order by voivodeship.name");
            if($db->nf())
                  while($db->next_record())
                        $arr_select["id_voivodeship"][] = array($db->f('id'), $db->f('name'));
*/                        
                        
            $db = new DB__("select city.* from city 
            order by city.name");
            if($db->nf())
                  while($db->next_record())
                  {
                        $arr_select["id_city"][] = array($db->f('id'), $db->f('name'));
                        $arr_select["id_city_patient"][] = array($db->f('id'), $db->f('name'));
                  }
            $tab_index = 0;
            //$tab_inp = array();
            
            if(!isset($_SESSION["firm"]))
            {
                  $tab_inp[++$tab_index]["f_name"] = "id_kind";
                  $tab_inp[$tab_index]["f_label"] = "Rodzaj rejestracji:*";
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_select";    
                  //$tab_inp[$tab_index]["f_onchange"] = " onchange=\"if(this.value == '21'){document.getElementById('id_degree').disabled=true;document.getElementById('id_degree').className='input_select_gray';document.getElementById('address_cor').disabled=true;document.getElementById('address_cor').className='input_form_textarea_gray';document.getElementById('work').disabled=true;document.getElementById('work').className='input_form_gray';}else{document.getElementById('id_degree').disabled=false;document.getElementById('id_degree').className='input_select';document.getElementById('address_cor').disabled=false;document.getElementById('address_cor').className='input_form_textarea';document.getElementById('work').disabled=false;document.getElementById('work').className='input_form';}\"";   
                  $tab_inp[$tab_index]["f_onchange"] = " onchange=\"if(this.value == '21'){document.getElementById('work').disabled=true;document.getElementById('work').className='input_form_gray';}else{document.getElementById('work').disabled=false;document.getElementById('work').className='input_form';}\"";   
                  //21 - dostep 
                  //22 - czlonek       
                  $tab_inp[++$tab_index]["f_name"] = "login";
                  $tab_inp[$tab_index]["f_label"] = "Login:*{label103}";
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            }
            $tab_inp[++$tab_index]["f_name"] = "pass";
            $tab_inp[$tab_index]["f_label"] = "{label102}:*{label103}";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_pass";
            $tab_inp[++$tab_index]["f_name"] = "passw2";
            $tab_inp[$tab_index]["f_label"] = "{label104}:*";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_pass";
            $tab_inp[$tab_index]["f_no_display"] = "1";//czy pobierac z bazy
            
            
            $tab_inp[++$tab_index]["f_name"] = "name";
            $tab_inp[$tab_index]["f_label"] = "{label105}:*";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            $tab_inp[++$tab_index]["f_name"] = "surname";
            $tab_inp[$tab_index]["f_label"] = "{label106}:*";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            
            $tab_inp[++$tab_index]["f_name"] = "id_city";
            $tab_inp[$tab_index]["f_label"] = "Miasto:*";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_select";
            if(!isset($_SESSION["firm"]))
            {
                  $tab_inp[++$tab_index]["f_name"] = "city";
                  $tab_inp[$tab_index]["f_label"] = "Inne miasto (jeśli nie ma na liście):";
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            }
            //if($form->row_sql["id_kind"] != 21)
            //{
                  //$tab_inp[++$tab_index]["f_name"] = "id_degree";
                  //$tab_inp[$tab_index]["f_label"] = "Stopień naukowy:*";
                  //$tab_inp[$tab_index]["f_type"] = "new_form_row_select";
                  $tab_inp[++$tab_index]["f_name"] = "street";
                  $tab_inp[$tab_index]["f_label"] = "Ulica:";
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
                  $tab_inp[++$tab_index]["f_name"] = "code";
                  $tab_inp[$tab_index]["f_label"] = "Kod pocztowy:";
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            //}
            $tab_inp[++$tab_index]["f_name"] = "pesel";
            $tab_inp[$tab_index]["f_label"] = "Data urodzenia:<br/>(rrrr-mm-dd)";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            
                  
            if($form->row_sql["id_kind"] != 21)
            {
                  $tab_inp[++$tab_index]["f_name"] = "work";
                  $tab_inp[$tab_index]["f_label"] = "Miejsce pracy:";
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            }
            $tab_inp[++$tab_index]["f_name"] = "id_city_patient";
            $tab_inp[$tab_index]["f_label"] = "Adres przyjmowania pacjentów - miasto:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_select";
            
            if(!isset($_SESSION["firm"]))
            {
                  $tab_inp[++$tab_index]["f_name"] = "city_patient";
                  $tab_inp[$tab_index]["f_label"] = "Inne miasto (jeśli nie ma na liście):";
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            }
            
            $tab_inp[++$tab_index]["f_name"] = "street_patient";
            $tab_inp[$tab_index]["f_label"] = "Adres przyjmowania pacjentów - ulica:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            
            $tab_inp[++$tab_index]["f_name"] = "code_patient";
            $tab_inp[$tab_index]["f_label"] = "Adres przyjmowania pacjentów - kod pocztowy:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            
            $tab_inp[++$tab_index]["f_name"] = "id_school";
            $tab_inp[$tab_index]["f_label"] = "Wykształcenie:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_select";
            
            $tab_inp[++$tab_index]["f_name"] = "trening";
            $tab_inp[$tab_index]["f_label"] = "Dodatkowe szkolenia:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_textarea";
            
            $tab_inp[++$tab_index]["f_name"] = "exp";
            $tab_inp[$tab_index]["f_label"] = "Doświadczenie:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_textarea";
      
            $tab_inp[++$tab_index]["f_name"] = "visit";
            $tab_inp[$tab_index]["f_label"] = "Sposób umawiania wizyt:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_textarea";
/*      
            $tab_inp[++$tab_index]["f_name"] = "id_specialization";
            $tab_inp[$tab_index]["f_label"] = "Specjalizacja:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_select";
*/            
            $tab_inp[++$tab_index]["f_name"] = "id_specialization[]";
            $tab_inp[$tab_index]["f_name2"] = "id_specialization";
            $tab_inp[$tab_index]["f_label"] = "Specjalizacja:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_select_multi";
            
            $tab_inp[++$tab_index]["f_name"] = "photo_m";
            $tab_inp[$tab_index]["f_label"] = "Zdjęcie profilowe:";       
                
            if($form->row_sql["photo_m"] != "")
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_file_edit";
            else
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_file";
            
            if(!isset($_SESSION["firm"]))
            {
                  $tab_inp[++$tab_index]["f_name"] = "email";
                  $tab_inp[$tab_index]["f_label"] = "E-mail:*";
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            }
            $tab_inp[++$tab_index]["f_name"] = "phone";
            $tab_inp[$tab_index]["f_label"] = "Nr telefonu:*";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            $tab_inp[++$tab_index]["f_name"] = "www";
            $tab_inp[$tab_index]["f_label"] = "Strona WWW:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";

            
            if(!isset($_SESSION["firm"]))
            {
                  $tab_inp[++$tab_index]["f_name"] = "regulamin";
                  $tab_inp[$tab_index]["f_label"] = "Akceptuję <a href=\"Regulamin,48\" onclick=\"window.open(this.href,'_blank');return false;\">regulamin</a>:*";
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_check";
                  
                  $tab_inp[++$tab_index]["f_name"] = "zgoda";
                  $tab_inp[$tab_index]["f_label"] = "{label256}:*";
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_check";
                  //capcha
                  $tab_inp[++$tab_index]["f_name"] = "spam";
                  $tab_inp[$tab_index]["f_label"] = "{label16}";
                  $tab_inp[$tab_index]["f_type"] = "new_form_row_capcha";
            }
            
            $form->f_action = "";
            $form->f_method = "post";
            $form->f_width = null;
            $form->f_max_photo = 1;
            $form->f_form_submit = "new_form_submit";
            $form->f_input_class = "f_input_class";
            $form->f_label_class = "f_label_class";    
            $form->f_add_clear = "1";         
            //$form->f_onsubmit = "if(check_mail('email')){if(!check_form('firm_name','id_base_firm_category','text','street','city','code','form_form'))return false;}else{return false;}";
      }
      
      function set_params_form_conference($arr_select, $tab_inp, $form)
      {
            $db = new DB__("select category_multi_lang.id, category_multi_lang.name from category_multi_lang
where category_multi_lang.id_lang='".$_SESSION["id_language"]."' and category_multi_lang.id_menu='50'
order by category_multi_lang.id");
            if($db->nf())
                  while($db->next_record())
                        $arr_select["id_univ"][] = array($db->f('id'), $db->f('name'));

            $db = new DB__("select category_multi_lang.id, category_multi_lang.name from category_multi_lang
where category_multi_lang.id_lang='".$_SESSION["id_language"]."' and category_multi_lang.id_menu='49'
order by category_multi_lang.id");
            if($db->nf())
                  while($db->next_record())
                        $arr_select["id_status"][] = array($db->f('id'), $db->f('name'));

            $tab_index = 0;
            //$tab_inp = array();
            
            $tab_inp[++$tab_index]["f_name"] = "name";
            $tab_inp[$tab_index]["f_label"] = "{label105}:*";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            $tab_inp[++$tab_index]["f_name"] = "surname";
            $tab_inp[$tab_index]["f_label"] = "{label106}:*";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";

            $tab_inp[++$tab_index]["f_name"] = "email";
            $tab_inp[$tab_index]["f_label"] = "E-mail:*";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
        
            $tab_inp[++$tab_index]["f_name"] = "city";
            $tab_inp[$tab_index]["f_label"] = "Miasto:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            
            $tab_inp[++$tab_index]["f_name"] = "street";
            $tab_inp[$tab_index]["f_label"] = "Ulica:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            
            $tab_inp[++$tab_index]["f_name"] = "code";
            $tab_inp[$tab_index]["f_label"] = "Kod pocztowy:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_text";
            
            $tab_inp[++$tab_index]["f_name"] = "id_univ";
            $tab_inp[$tab_index]["f_label"] = "Uczelnia:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_select";
            
            $tab_inp[++$tab_index]["f_name"] = "id_status";
            $tab_inp[$tab_index]["f_label"] = "Status:";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_select";
            
            $tab_inp[++$tab_index]["f_name"] = "regulamin";
            $tab_inp[$tab_index]["f_label"] = "Akceptuję <a href=\"Regulamin,48\" onclick=\"window.open(this.href,'_blank');return false;\">regulamin</a>:*";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_check";
            
            $tab_inp[++$tab_index]["f_name"] = "zgoda";
            $tab_inp[$tab_index]["f_label"] = "{label256}:*";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_check";
            //capcha
            $tab_inp[++$tab_index]["f_name"] = "spam";
            $tab_inp[$tab_index]["f_label"] = "{label16}";
            $tab_inp[$tab_index]["f_type"] = "new_form_row_capcha";
      
            $form->f_action = "";
            $form->f_method = "post";
            $form->f_width = null;
            $form->f_max_photo = 1;
            $form->f_form_submit = "new_form_submit";
            $form->f_input_class = "f_input_class";
            $form->f_label_class = "f_label_class";    
            $form->f_add_clear = "1";         
            //$form->f_onsubmit = "if(check_mail('email')){if(!check_form('firm_name','id_base_firm_category','text','street','city','code','form_form'))return false;}else{return false;}";
      }
      
      function update_record($sql, $site_id = null, $mode = "edit")
      {
            $tab_ret = array();
            $tab_ret["photo_ord"] = 0;
            if($mode == "edit")//edit
            {
                  new DB__($sql);
                  $tab_ret["max_id"] = $_GET["idd"];
                  
                  $db = new DB__("select max(ord) as max from photo where photo.idd='".$tab_ret["max_id"]."' and photo.id_template='".$this->id_template."'");
                  if($db->next_record())
                        $tab_ret["photo_ord"] = $db->f('max');
            }
            else //add
            {
                  $db = new DB__($sql);
                  $tab_ret["max_id"] = $db->maxid();
                  
                  mb_send_mail(SITE_EMAIL, "Nowa informacja na stronie: ".SITE_NAME, "Dodano informację na stronie: ".Baza::get_site_name($site_id), "From: ".SITE_EMAIL);
                  
            }   
            return $tab_ret;    
      }
      
      function add_record_photos($max_id, $photo_ord, $arr = array())
      {
            ///fotki//////////////////      
            $f2 = null;
            $f = new File;
            $f->path = PATH_IMG;
            
            while(list($k, $l)=each($_FILES))  
            {
                  if($_FILES[$k]["name"] != "")
                  {                      
                        if(!in_array($k, $arr))
                        {
                              $f2 = $f->file_upload($_FILES[$k]["tmp_name"], $_FILES[$k]["name"],1);
                              File::foto_maxi($f2, $f->path, PHOTO_MAX_W, PHOTO_MAX_H);                 
                              
                              if(isset($f2)) // miniaturke robimy z nowej fotki duzej
                                    $f1 = File::foto_mini($f2, $f->path, PHOTO_M_W, PHOTO_M_H, 0);  
                                      
                              $photo_ord++;      
                              $db = new DB__("insert into photo (idd, photo_m, photo_b, text, id_template, active, ord) values ('$max_id', '$f1', '$f2', '','".$this->id_template."', '1', '$photo_ord')");
                        }
                  }    
            }                  
            // 
      }
      
      function delete_record_photos($id)
      {
            $db = new DB__("select photo.* from photo 
            where photo.id='".$id."'");
            if($db->next_record())
            {
                  if($db->f('photo_m'))
                        File::file_del(PATH_IMG.$db->f('photo_m'));
                  if($db->f('photo_b'))
                        File::file_del(PATH_IMG.$db->f('photo_b'));
      
                  new DB__("delete from photo 
                  where photo.id='".$db->f('id')."'");
            }
      }
      
      function delete_record($id, $table)
      {
            $db = new DB__("select * from photo 
            where photo.idd='".$id."' and photo.id_template='".$this->id_template."'");
            while($db->next_record())
            {
                  if($db->f('photo_m'))
                        File::file_del(PATH_IMG.$db->f('photo_m'));
                  if($db->f('photo_b'))
                        File::file_del(PATH_IMG.$db->f('photo_b'));
      
                  new DB__("delete from photo 
                  where photo.id='".$db->f('id')."'");
            }
            
            new DB__("delete from $table 
            where id='".$id."'");
      }
      
      function show_record_table($book_arr, $table_record_sql, $title_field = "title")
      {
            $this->tmpl->set_block('blocks','table_table');
            $this->tmpl->set_block('blocks','table_tr');
            $this->tmpl->set_block('blocks','table_th');
            $this->tmpl->set_block('blocks','table_td');
            $this->tmpl->set_block('blocks','scale');
                             
            $db = new DB__($table_record_sql);
            if($db->nf())
            {
                  $count = 1;
                  $links = 20;
                  if(!isset($_GET["lim"]))//przy wyszukiwaniu zerujemy
                  {
                        $_GET["lim"] = 0;
                        $iff = 0;
                  }
                  else
                        $iff = $_GET["lim"] * $links;
                        
                  $db->seek($iff);
            
                  $this->tmpl->set_var("id_table", " class=\"table_border\"");
                  $this->tmpl->set_var('nf', $db->nf()); 
                  
                  //LP
                  $this->tmpl->set_var('id_th', "");
                  $this->tmpl->set_var('th_', "Lp.");
                  $this->tmpl->parse('tr_', 'table_th', true);
                  
                  while(list($k, $v)=each($book_arr))
                  {
                        $this->tmpl->set_var('id_th', "");
                        $this->tmpl->set_var('th_', $v[0]);
                        $this->tmpl->parse('tr_', 'table_th', true);
                  }
                  $this->tmpl->parse('table_', 'table_tr', true);
            
                  while($db->next_record())
                  {
                        $iff++;
                        $link_offer = File::make_mode_rew($db->f($title_field), $_GET["id"], $db->f('id'));
                        $this->tmpl->set_var("id_tr", " onmouseover=\"this.style.backgroundColor='#eeeeee';this.style.cursor='pointer';\" onmouseout=\"this.style.backgroundColor='';\"");
            
                        $this->tmpl->set_var('tr_', "");
                        //LP
                        $this->tmpl->set_var('id_td', "");
                        $this->tmpl->set_var('td_', $iff.".");
                        $this->tmpl->parse('tr_', 'table_td', true);
                        reset($book_arr);
                        while(list($k, $v)=each($book_arr))
                        {
                              $this->tmpl->set_var('id_td', "");
                              $this->tmpl->set_var("td_",'');
                              if($v[1] == "edit")
                                    $this->tmpl->set_var("td_", "<a href=\"".File::make_mode_rew($db->f($title_field), $_GET["id"], $db->f('id'))."\">[edytuj]</a>");
                              else if($v[1] == "del")
                                    $this->tmpl->set_var("td_", "<a href=\"javascript:if(confirm('Jesteś pewien? Kasujesz dane bezpowrotnie.'))location.href='index.php?id=".$_GET["id"]."&amp;del=".$db->f('id')."';\">[usuń]</a>");
                              else
                                    $this->tmpl->set_var("td_", $db->f($v[1]));
                              $this->tmpl->parse('tr_', 'table_td', true);
                        }
                        $this->tmpl->parse('table_', 'table_tr', true);
            
                        if(($iff >= $links * ($_GET["lim"] + 1)) && isset($count))
                              break;
                  }
                  $this->tmpl->parse('modul_x', 'table_table', true);

                  $sc = show_scale($db->nf(), $links, "index.php");
                  if(isset($count) && isset($sc))
                  {
                        $this->tmpl->set_var('scale_', $sc);
                        $this->tmpl->parse('modul_x', 'scale', true);
                  }  
                  
                  return $this->tmpl->subst('modul_x');
            } 
            else
                  return null;           
      
      }
}
    
class Comment
{
      private $tmpl;
      
      function __construct()
      {
            $this->tmpl = new Template("../htmls");
            $this->tmpl->set_file('blocks','comment.html');
            $this->tmpl->set_block('blocks','main_comment');      
            $this->tmpl->set_block('blocks','main_comment_block');      
            $this->tmpl->set_block('blocks','comment_row');      
            $this->tmpl->set_block('blocks','comment_add');      
            $this->tmpl->set_block('blocks','comment_add_gray');      
            $this->tmpl->set_block('blocks','comment_nick');   
               
            $this->tmpl->set_file('block12','main.html');
            $this->tmpl->set_block('blocks12','scale');
            
            $this->tmpl->set_file('blocks13','form.html');
            $this->tmpl->set_block('blocks13','form_comment');
      }
      
      function show_info()
      {
            if($_GET["comment"] == "c1")//dodany komentarz
            {
                  if(COMMENT_ADMIN == 1)
                        $this->tmpl->set_var("cmnt", "{label95}");   
                  else   
                        $this->tmpl->set_var("cmnt", "{label93}");   
                  $this->tmpl->parse("comment_add_new", 'form_comment', true); 
            }
            else if($_GET["comment"] == "c2")//nie dodany
            {
                  $this->tmpl->set_var("cmnt", "{label94}");      
                  $this->tmpl->parse("comment_add_new", 'form_comment', true); 
            }
      }
      
      function add_comment()
      {
            //if(isset($_SESSION["firm"]) && $_POST["comment_add_text"] != "")//dodajemy komentarz
            if($_POST["comment_add_text"] != "")//dodajemy komentarz
            {
                  if(COMMENT_ADMIN == 1)
                        $active = 0;
                  else
                        $active = 1;
                        
                  if(!isset($_POST["comment_add_nick"])) 
                        $_POST["comment_add_nick"] = null;     
                  if(!isset($_POST["comment_add_email"])) 
                        $_POST["comment_add_email"] = null;     
                        
                  new DB__("insert into offer_comment (id_offer, text, nick, email, id_user, date_, active) values ('".$_GET["idd"]."', '".$_POST["comment_add_text"]."','".$_POST["comment_add_nick"]."','".$_POST["comment_add_email"]."', '".isset($_SESSION["firm"])."', now(), '$active')");
                  if($active == 0)
                        mb_send_mail(SITE_EMAIL, "Dodano nowy komentarz w portalu: ".SITE_NAME, $_POST["comment_add_text"], "From: ".SITE_EMAIL);
                        
                  header("location: index.php?".mb_ereg_replace("&amp;","&",path_from_get(array('comment')))."&comment=c1#a_comment");
                  exit;
            }
            else
            {
                  header("location: index.php?".mb_ereg_replace("&amp;","&",path_from_get(array('comment')))."&comment=c2#a_comment");      
                  exit;
            }
      }
      
      function show_comment()
      {
            $this->tmpl->set_var('comment_add_new', "");  
            $this->tmpl->set_var('comment_amount', 0);
            $this->tmpl->set_var('comment_nick_', "");  
                  
            if(isset($_GET["comment"]))//wyswietlamy info
                  $this->show_info();
            
            
            if(isset($_POST["send_form_comment"]))//dodajemy komentarz
            
                  $this->add_comment();
            
            if(COMMENT_LOGIN == 0 && !isset($_SESSION["firm"]))
                  $this->tmpl->parse('comment_nick_', 'comment_nick');  
                  
            if(isset($_SESSION["firm"]) || COMMENT_LOGIN == 0)
            {
                  $this->tmpl->parse('main_comment_block_', 'main_comment_block');  
                  $this->tmpl->parse('comment_add_', 'comment_add');  
            }
            else
            {
                  $this->tmpl->set_var('main_comment_block_', '');  
                  $this->tmpl->parse('comment_add_', 'comment_add_gray');  
            }
                  
            $db2 = new DB__("select offer_comment.*, if(offer_comment.id_user != '-1', firm.login, offer_comment.nick) as firm from offer_comment 
            left join firm on firm.id=offer_comment.id_user
            where offer_comment.id_offer='".$_GET["idd"]."' and offer_comment.active='1'
            order by offer_comment.date_ desc");  
            if($db2->nf())
            {
                  $count = 1;
                  $links = 10;
                  if(!isset($_GET["lim"]))//przy wyszukiwaniu zerujemy
                  {
                        $_GET["lim"] = 0;
                        $iff = 0;
                  }
                  else
                        $iff = $_GET["lim"] * $links;
                     
                  $db2->seek($iff);
                  
                  $this->tmpl->set_var('comment_amount', $db2->nf());
                  while($db2->next_record())
                  {
                        $iff++;
                        $this->tmpl->set_var('comment_date', File::date_from_to(mb_substr($db2->f('date_'),0,10)).", ".mb_substr($db2->f('date_'),11));
                        $this->tmpl->set_var('comment_text', $db2->f('text'));
                        $this->tmpl->set_var('comment_firm', $db2->f('firm'));
                        $this->tmpl->parse('comment_', 'comment_row', true);  

                        if(($iff >= $links * ($_GET["lim"] + 1)) && isset($count))
                              break;
                  }
                  $sc = show_scale($db2->nf(), $links, "index.php");
                  if(isset($count) && isset($sc))
                  {
                        $this->tmpl->set_var('cmnt', $sc);
                        $this->tmpl->parse('comment_', 'form_comment', true);
                  }                        
            }
            else
            {
                  $this->tmpl->set_var("cmnt", "{label96}");      
                  $this->tmpl->parse("comment_", 'form_comment', true); 
            }
                     
            return $this->tmpl->subst('main_comment');  
      }
}
/*
class Firm
{
      private $tmpl;
      
      function __construct()
      {
      }
      
      function check_uniq($id)
      {
            $db = new DB__("select * from firm where uniq='".$id."'");
            if($db->next_record())
            {
                  $tab = array();
                  $tab["id"] = $db->f('id');
                  $tab["name"] = $db->f('name')." ".$db->f('surname');
                  return $tab;
            }
            else
                  return false;
      }
      
      function activate_firm($id)
      {
            new DB__("update firm set uniq=null, active='1' where id='".$id["id"]."' and uniq is not null");
            
            mb_send_mail(SITE_EMAIL, "Rejestracja w portalu: ".SITE_NAME, "Użytkownik ".$id["name"]." zarejestrował się w portalu.", "From: ".SITE_EMAIL);

      }
      
      function check_email_login($email, $login)
      {
            if(isset($_SESSION["firm"]))
                  $db = new DB__("select firm.email, firm.login , firm.id from firm 
                  where (firm.email='".$email."' and firm.id != '".$_SESSION["firm"]."') or (firm.login='".$login."' and firm.id != '".$_SESSION["firm"]."')");
            else
                  $db = new DB__("select firm.email, firm.login from firm 
                  where firm.email='".$email."' or firm.login='".$login."'");
            if($db->next_record())
            {
                  if($db->f('login') == $login)
                  {
                        $tmpl->set_var('cmnt',"Taki login już istnieje!");
                        $tmpl->parse('comment_','form_comment_red',true);
                  }
                  if($db->f('email') == $email)
                  {
                        $tmpl->set_var('cmnt',"Taki e-mail już istnieje!");
                        $tmpl->parse('comment_','form_comment_red',true);
                  }
            }      
      }
}
*/
class Scale
{
      private $tmpl;
      private $url = "index.php";
      private $offset = 9;
      public $version = "down";//czy podzialka na gorze czy dole - inny margin
      
      
      function __construct()
      {
      }
      
      function get_path()
      {
            return path_from_get(array("lim","action"));
      }
      
      function show_scale($max, $scale)
      {
            $i = 0;
            $linki = null;
            
            $lim = $_GET["lim"]*$scale;
            
            $scale_path = $this->get_path()."&amp;";         
            
            if($max > $scale)
            {
                  $back = $_GET["lim"] - 1;
                  if($back >= 0)
                        $linki = "<a href=\"".$this->url."?".$scale_path."lim=".$back."\"><img src=\"../images/img/scale_left.gif\" alt=\"poprzednia\" title=\"poprzednia\"/>&nbsp;&nbsp;poprzednia</a><img src=\"../images/img/scale_mid.gif\" alt=\"\" title=\"\"/>";
                  
                  for($i = 0;$i < ($max/$scale);$i++)
                  {
                        $lit = $i + 1;
                        
                        if(intval($max/$scale) == $max/$scale) // problem jesli max byl podzielny przez ile_linki
                              $max_val = $max/$scale;
                        else
                              $max_val = intval($max/$scale + 1);
                        
                        if(($i >= ($_GET["lim"] - $this->offset) && $i <= ($_GET["lim"] + $this->offset)) || $lit == $max_val || $lit == 1)
                        {
                              if($lit == $max_val && $_GET["lim"] + $this->offset + 2 < ($max/$scale))// 1 i ostatni zawsze na ekranie
                                    $lit = "...".$lit;
                              if($lit == 1 && $_GET["lim"] - $this->offset > 1)
                                    $lit = $lit."...";
                              
                              if($i == $_GET["lim"])
                                    $linki .= "<span><b>$lit</b></span><img src=\"../images/img/scale_mid.gif\" alt=\"\" title=\"\"/>";
                              else
                                    $linki .= "<a href=\"".$this->url."?".$scale_path."lim=".$i."\">$lit</a><img src=\"../images/img/scale_mid.gif\" alt=\"\" title=\"\"/>";
                        }
                  }
                  $back = $_GET["lim"] + 1;
                  if($back < $i)
                        $linki = $linki."<a href=\"".$this->url."?".$scale_path."lim=".$back."\">następna&nbsp;&nbsp;<img src=\"../images/img/scale_right.gif\" alt=\"następna\" title=\"następna\"/></a> ";
                  
                  //if($i == ($lim + $scale)/$scale)
                  //      $linki = substr($linki,0,-3);
                        
                  if($this->version == "down")
                        $class = "f11 f_tahoma center mar10 marup20";
                  else
                        $class = "f11 f_tahoma center mar20 marup10";
                  
                  if(isset($linki))
                        return "<div class=\"$class\">".$linki."</div>";
            }
            else
                  return null;
      }
}

class Calendar
{
      private $tmpl;
      
      function __construct()
      {
            $this->tmpl = new Template("../htmls");
            $this->tmpl->set_file('blocks','main.html');
            $this->tmpl->set_block('blocks','main_cal_row');             
      }
      
      function main_page($where1)
      {
            $_services = array();            
            $_services['idek_calendar'][1] = 28;
            //$_services['idek_calendar'][2] = 8;
            
            $idek = $_services['idek_calendar'][$_SESSION['id_service']];
            
            //ostatnie wpisy
            $db2 = new DB__("select '$idek' as idek, calendar_multi.id, calendar_multi.time_from, calendar_multi.time_to, calendar_multi.date_, calendar_multi.date_to, calendar_multi_lang.title, calendar_multi_lang.place, if(calendar_multi.date_to is null or calendar_multi.date_ > now(), calendar_multi.date_, date_format(now(),'%Y-%m-%d')) as date_temp from calendar_multi
            left join calendar_multi_lang on calendar_multi_lang.id_calendar=calendar_multi.id and calendar_multi_lang.id_lang='".$_SESSION["id_language"]."'
            where calendar_multi_lang.title != '' and calendar_multi.active='1' ".$where1."
            order by date_temp");
            
            if($db2->nf())
            {
                  $next = 0;
                  while($db2->next_record())
                  {            
                        $next++;
                        $this->tmpl->set_var('n_href', File::make_mode_rew($db2->f('title'), $db2->f('idek'), $db2->f('id')));
                        $this->tmpl->set_var('n_date', File::date_from_to($db2->f('date_'), $db2->f('date_to')));
                        
                        if($db2->f('time_from'))
                              $this->tmpl->set_var('c_time', ", godz. ".File::time_from_to($db2->f('time_from'),$db2->f('time_to')));
                        else
                              $this->tmpl->set_var('c_time', "");
                        $this->tmpl->set_var('n_title', mb_ereg_replace("\"", "'", $db2->f('title')));
                        //$this->tmpl->set_var('n_text', File::text_len(130, strip_tags($db2->f('text'))));
                        
                        if($db2->f('place'))
                              $this->tmpl->set_var('n_place', "miejsce: <b>".$db2->f('place')."</b>");
                        else
                              $this->tmpl->set_var('n_place', "");

                        $this->tmpl->parse('temp', 'main_cal_row', true);            
                        
                        if($next >= 3)
                              break;                        
                  }
                  
                  return $this->tmpl->subst('temp');
            }
      }
}

class Sonda
{
      private $tmpl;
      private $sonda_amount = 0;
      public $idek = null;
      public $sub_idek = null;
      
      function __construct($sub_idek)
      {
            if(!isset($sub_idek))
                  $this->sub_idek = 3;
            else
                  $this->sub_idek = $sub_idek;
            
            $this->find_sonda_id();
            $this->tmpl = new Template("../htmls");
            $this->tmpl->set_file('blocks','main.html');
            $this->tmpl->set_block('blocks','sub_ankieta_ajax');
            $this->tmpl->set_block('blocks','sub_ankieta_row');
            $this->tmpl->set_block('blocks','sub_ankieta_row_answer');      
            $this->tmpl->set_block('blocks','sub_ankieta_down');      
            $this->tmpl->set_block('blocks','sub_ankieta_down2');        
           
            if(!isset($_SESSION["sonda"]))
            {
                  $_SESSION["sonda"] = array();

            }
      }
      
      function sonda_update($id_answer)
      {
            if(!isset($_SESSION["sonda"][$this->idek]))//glosujemy raz
            {
                  new DB__("update questionnaire_answer set vote=vote+1
                  where questionnaire_answer.id='".$id_answer."'");
                  $_SESSION["sonda"][$this->idek] = 1;
            }
      }
      
      function find_sonda_amount()
      {
            $db2 = new DB__("select sum(questionnaire_answer.vote) as amount from questionnaire_answer
            where questionnaire_answer.id_questionnaire='".$this->idek."' and questionnaire_answer.active='1'");
            if($db2->next_record())
            {
                  $this->sonda_amount = $db2->f('amount');
            }
      }
      
      function find_sonda_id()
      {            
            //questionnaire.id_site='".$this->sub_idek."' and 
            //szukamy ankiety powiazanej z zakladka - jesli brak to id_menu=-1 (finished=0 i active=1)
            $db2 = new DB__("select questionnaire.id from questionnaire 
            where questionnaire.question != '' and questionnaire.active='1' and questionnaire.finished='0' 
            order by rand()");
            if($db2->next_record())
                 $this->idek = $db2->f('id');
            else
                  return false;
            /*
            else
            {
                  $db2 = new DB__("select questionnaire.id from questionnaire 
                  where questionnaire.id_menu = '-1' and questionnaire.question != '' and questionnaire.active='1' and questionnaire.finished='0' 
                  order by rand()");
                  if($db2->next_record())
                        $this->idek = $db2->f('id');
            }
            */
      }
      
      
      function main_sonda_table()
      {
            $db2 = new DB__("select questionnaire.*, questionnaire_answer.answer, questionnaire_answer.id as s_id from questionnaire, questionnaire_answer
            where questionnaire.id='".$this->idek."' and questionnaire.id=questionnaire_answer.id_questionnaire and questionnaire_answer.active='1'
            order by questionnaire_answer.ord");
            if($db2->nf())
            {
                  $this->sub_idek;
                  $this->tmpl->set_var('sub_idek', $this->sub_idek);
                  $next = 0;
                  while($db2->next_record())
                  {
                        $this->tmpl->set_var('s_value', $db2->f('s_id'));
                        $this->tmpl->set_var('s_question', $db2->f('question'));
                        $this->tmpl->set_var('s_next', $next++);
                        $this->tmpl->set_var('s_answer', $db2->f('answer'));            
                        $this->tmpl->parse('sub_ankieta_row_', 'sub_ankieta_row', true);
                  }
                  $this->tmpl->parse('sub_ankieta_row_', 'sub_ankieta_down', true);
                  $this->tmpl->parse('temp', 'sub_ankieta_ajax', true);
                  return $this->tmpl->subst('temp');
            }
            else
                  return false;
      }
      
      function main_sonda_result()
      {
            $db2 = new DB__("select questionnaire.*, questionnaire_answer.answer, questionnaire_answer.vote, questionnaire_answer.id as s_id from questionnaire, questionnaire_answer
            where questionnaire.id='".$this->idek."' and questionnaire.id=questionnaire_answer.id_questionnaire and questionnaire_answer.active='1'
            order by questionnaire_answer.vote desc");
            if($db2->nf())
            {
                  $next = 0;
                  $this->tmpl->set_var('sub_idek', $this->sub_idek);
                  while($db2->next_record())
                  {
                        $this->tmpl->set_var('s_value', $db2->f('s_id'));
                        $this->tmpl->set_var('s_question', $db2->f('question'));
                        $this->tmpl->set_var('s_next', $next++);
                        $this->tmpl->set_var('s_answer', $db2->f('answer'));            
                        $this->tmpl->set_var('s_vote', $db2->f('vote'));      
                        if($this->sonda_amount == 0)      
                              $this->tmpl->set_var('s_procent', 0);            
                        else
                              $this->tmpl->set_var('s_procent', number_format(($db2->f('vote')/$this->sonda_amount) * 100, 0));            
                        $this->tmpl->parse('sub_ankieta_row_', 'sub_ankieta_row_answer', true);
                  }
                  if(!isset($_SESSION["sonda"][$this->idek]))//glosujemy raz
                        $this->tmpl->parse('sub_ankieta_row_', 'sub_ankieta_down2', true);
                  $this->tmpl->parse('temp', 'sub_ankieta_ajax', true);
                  return $this->tmpl->subst('temp');
            }
            else
                  return false;
      }
}
?><?
class Form
{
      private $tmpl;
      public $f_class = "input_form";
      public $f_input_class = "mar10";
      public $f_label_class = "bold mar2";
      public $f_width = "210";
      public $f_require = null;//null - true
      public $f_onsubmit;
      public $f_action;
      public $f_method = "get";
      public $f_id = "form_form";
      public $f_hidden = "send_form";
      public $f_form_submit = "new_form_search_clear";///new_form_submit
      public $f_max_photo = "1";///ilosc dodawancyh fotek
      public $f_start_photo = "1";///ilosc poczatkowa wyswietlanych fotek
      public $f_max_order = "1";///ilosc dodawancyh fotek
      public $f_start_order = "1";///ilosc poczatkowa wyswietlanych fotek
      public $f_add_clear = null;///ilosc poczatkowa wyswietlanych fotek
      public $f_row_sql = null;///sql przy edycji
      public $row_sql = null;
      public $f_id_template = null;///sql przy edycji
      
      function __construct()
      {
            $this->tmpl = new Template("../htmls");
            $this->tmpl->set_file('blocks','form.html');
            $this->tmpl->set_block('blocks','new_form');
            $this->tmpl->set_block('blocks','new_form_row_pass');
            $this->tmpl->set_block('blocks','new_form_row_text');
            $this->tmpl->set_block('blocks','new_form_row_capcha');
            $this->tmpl->set_block('blocks','new_form_row_textarea');
            $this->tmpl->set_block('blocks','new_form_row_select');
            $this->tmpl->set_block('blocks','new_form_row_select_multi');
            $this->tmpl->set_block('blocks','new_form_row_option');
            $this->tmpl->set_block('blocks','new_form_row_check');
            $this->tmpl->set_block('blocks','new_form_row_file');
            $this->tmpl->set_block('blocks','new_form_row_file_edit');
            $this->tmpl->set_block('blocks','new_form_row_photo_add');
            $this->tmpl->set_block('blocks','new_form_row_photo_edit');
            $this->tmpl->set_block('blocks','new_form_row_photo_add_div');
            $this->tmpl->set_block('blocks','new_form_row_photo_add_button');
            
            $this->tmpl->set_block('blocks','new_form_row_table_rows');
            $this->tmpl->set_block('blocks','new_form_row_table_rows_add_button');
            $this->tmpl->set_block('blocks','new_form_row_table_rows_del_button');
            $this->tmpl->set_block('blocks','new_form_row_table_rows_add');
            $this->tmpl->set_block('blocks','new_form_row_table_rows_edit');

            
            $this->tmpl->set_block('blocks','new_form_row_date');
            $this->tmpl->set_block('blocks','new_form_row_date_from');
            $this->tmpl->set_block('blocks','new_form_row_date_to');
            $this->tmpl->set_block('blocks','new_form_row_hidden');
            $this->tmpl->set_block('blocks','new_form_search_clear');
            $this->tmpl->set_block('blocks','new_form_submit');
            $this->tmpl->set_block('blocks','new_form_back');
            
            $this->tmpl->set_file('blocks2','main.html');
            $this->tmpl->set_block('blocks2','table_div');
            $this->tmpl->set_block('blocks2','table_clear');
            
      }
      
      
      function add_photos()
      {
            $db = new DB__("select * from photo 
            where photo.idd='".$_GET["idd"]."' and photo.id_template='".$this->f_id_template."'
            order by photo.ord");
            while($db->next_record())
            {
                  $this->tmpl->set_var('f_img_src', PATH_IMG.$db->f('photo_m'));
                  $this->tmpl->set_var('f_img_del', "javascript:if(confirm('Jesteś pewien? Kasujesz dane bezpowrotnie.'))location.href='index.php?id=".$_GET["id"]."&amp;idd=".$_GET["idd"]."&amp;del=".$db->f('id')."';");
                  $this->tmpl->parse('add_photos_', 'new_form_row_photo_edit',true);
            }
            return $db->nf();
      }
      
      function do_sql()
      {
            if(isset($_SESSION["firm"]) && isset($this->f_row_sql))
            {
                  $dbx = new DB__($this->f_row_sql);
                  if($dbx->next_record())
                        $this->row_sql = $dbx->Record;
            }              
      }
      
      function create_form($tab, $tab_select = null)
      {
            $this->tmpl->set_var('f_action', $this->f_action);
            $this->tmpl->set_var('f_method', $this->f_method);
            $this->tmpl->set_var('f_id', $this->f_id);
            $this->tmpl->set_var('f_onsubmit', $this->f_onsubmit);
            $this->tmpl->set_var('f_hidden', $this->f_hidden);
            $this->tmpl->set_var('spam_', File::spam_blocker());
            
            
            $this->tmpl->parse('form_submit_', $this->f_form_submit);

            if($this->f_method == "get")
            {
                  $this->tmpl->set_var('f_name', "id");
                  $this->tmpl->set_var('f_val', $_GET["id"]);
                  $this->tmpl->parse('form_', 'new_form_row_hidden');
            }
            

            reset($tab);
            while(list($k, $v)=each($tab))
            {
                  if(!isset($_POST[$v["f_name"]]))
                        $_POST[$v["f_name"]] = null;
                  if(!isset($_GET[$v["f_name"]]))
                        $_GET[$v["f_name"]] = null;
                        
                  if(isset($v["f_class"]))
                        $this->tmpl->set_var('f_class', $v["f_class"]);
                  else
                        $this->tmpl->set_var('f_class', $this->f_class);
                        
                  if(isset($v["f_width"]))
                        $this->f_width = $v["f_width"];

                  $this->tmpl->set_var('f_more', " style=\"width:".$this->f_width."px;\"");
                        
                  $this->tmpl->set_var('f_name', $v["f_name"]);
                  
                  if(isset($v["f_onchange"]))
                        $this->tmpl->set_var('f_onchange', $v["f_onchange"]);
                  else
                        $this->tmpl->set_var('f_onchange', "");
                  
                  if($v["f_type"] == "new_form_row_select")
                  {
                        $this->tmpl->set_var('form_row_option_', "");

                              
                        if(isset($tab_select[$v["f_name"]]))
                              while(list($kk, $vv) = each($tab_select[$v["f_name"]]))
                              {
                                    $this->tmpl->set_var('f_val', $vv[0]);
                                    $this->tmpl->set_var('f_text', $vv[1]);
                                    
                                    
                                    if(isset($_SESSION["firm"]) && isset($this->f_row_sql))
                                    {
                                          if(isset($v["f_name_temp"]))
                                                $f_name = $v["f_name_temp"];
                                          else
                                                $f_name = $v["f_name"];
                                          
                                          if($this->row_sql[$f_name] == $vv[0])
                                                $this->tmpl->set_var('f_selected', " selected=\"selected\"");
                                          else
                                                $this->tmpl->set_var('f_selected', "");                              
                                    }
                                    else
                                    {
                                          if($this->f_method == "get")
                                          {
                                                if($_GET[$v["f_name"]] == $vv[0])
                                                      $this->tmpl->set_var('f_selected', " selected=\"selected\"");
                                                else
                                                      $this->tmpl->set_var('f_selected', "");                              
                                          }
                                          else
                                          {
                                                if($_POST[$v["f_name"]] == $vv[0])
                                                      $this->tmpl->set_var('f_selected', " selected=\"selected\"");
                                                else
                                                      $this->tmpl->set_var('f_selected', "");                              
                                          }
                                     }     
                                    $this->tmpl->parse('form_row_option_', 'new_form_row_option', true);                  
                              }
                  }
                  else if($v["f_type"] == "new_form_row_select_multi")
                  {
                        $this->tmpl->set_var('form_row_option_', "");

                        $tab_post = array();
                        if(isset($_POST[$v["f_name2"]]))
                        {
                              reset($_POST[$v["f_name2"]]);
                                    while(list($key, $line)=each($_POST[$v["f_name2"]]))
                                          $tab_post[] = $line;
                        }    
                                                           
                        if(isset($tab_select[$v["f_name"]]))
                              while(list($kk, $vv) = each($tab_select[$v["f_name"]]))
                              {
                                    $this->tmpl->set_var('f_val', $vv[0]);
                                    $this->tmpl->set_var('f_text', $vv[1]);
                                    
                                    
                                    if(isset($_SESSION["firm"]) && isset($this->f_row_sql))
                                    {
                                          if(isset($v["f_name_temp"]))
                                                $f_name = $v["f_name_temp"];
                                          else
                                                $f_name = $v["f_name"];
                                          
                                          if($vv[2] != "")
                                                $this->tmpl->set_var('f_selected', " selected=\"selected\"");
                                          else
                                                $this->tmpl->set_var('f_selected', "");                              
                                    }
                                    else
                                    {
                                          if($this->f_method == "get")
                                          {
                                                if($_GET[$v["f_name"]] == $vv[0])
                                                      $this->tmpl->set_var('f_selected', " selected=\"selected\"");
                                                else
                                                      $this->tmpl->set_var('f_selected', "");                              
                                          }
                                          else
                                          {
                                                //echo "<pre>".print_r($_POST[$v["f_name2"]])."</pre>";
                                                /*
                                                reset($_POST[$v["f_name2"]]);
                                                      while(list($key, $line)=each($_POST[$v["f_name2"]]))
                                                            echo $key."=>".$line."<br/>";
*/
                                                if(in_array($vv[0], $tab_post))
                                                      $this->tmpl->set_var('f_selected', " selected=\"selected\"");
                                                else
                                                      $this->tmpl->set_var('f_selected', "");                              
                                          }
                                     }     
                                    $this->tmpl->parse('form_row_option_', 'new_form_row_option', true);                  
                              }
                  }
                  else if($v["f_type"] == "new_form_row_check")
                  {
                        if($this->f_method == "get")
                        {
                              if($_GET[$v["f_name"]] == "on")                             
                                    $this->tmpl->set_var('f_selected', " checked=\"checked\"");
                              else if($this->row_sql[$v["f_name"]] == "1")
                                    $this->tmpl->set_var('f_selected', " checked=\"checked\"");
                              else
                                    $this->tmpl->set_var('f_selected', "");
                        }
                        else
                        {
                              if($_POST[$v["f_name"]] == "on")                             
                                    $this->tmpl->set_var('f_selected', " checked=\"checked\"");
                              else if($this->row_sql[$v["f_name"]] == "1")
                                    $this->tmpl->set_var('f_selected', " checked=\"checked\"");
                              else
                                    $this->tmpl->set_var('f_selected', "");
                        }
                  }
                  else if($v["f_type"] != "new_form_row_photo_add_div")
                  {
                        if($this->f_method == "get")
                        {
                              if($_GET[$v["f_name"]])
                                    $this->tmpl->set_var('f_val', $_GET[$v["f_name"]]);
                              else
                                    $this->tmpl->set_var('f_val', $this->row_sql[$v["f_name"]]);
                        }
                        else if($v["f_name"] != "")
                        {
                              if($_POST[$v["f_name"]])
                                    $this->tmpl->set_var('f_val', $_POST[$v["f_name"]]);
                              else if(!isset($v["f_no_display"]))
                                    $this->tmpl->set_var('f_val', $this->row_sql[$v["f_name"]]);
                        }
                  }      
                  //label   
                  if($v["f_type"] == "new_form_row_label")
                  {   
                        $this->tmpl->set_var('div_', $v["f_label"]);
                        $this->tmpl->set_var('id_div', " class=\"bold\"");
                        $this->tmpl->parse('form_', 'table_div', true);
                  }
                  else if($v["f_type"] != "new_form_row_date_to")
                  {   
                        $this->tmpl->set_var('div_', $v["f_label"]);
                        $this->tmpl->set_var('id_div', " class=\"".$this->f_label_class."\"");
                        $this->tmpl->parse('form_', 'table_div', true);
                  }
                  
                  //dodawanie fotki pojedynczej
                  /*
                  if($v["f_type"] == "new_form_row_file")
                  {   
                        //if(isset($_GET["idd"]))
                        //{
                              //$v["f_type"] = "new_form_row_file_edit";
                              $this->tmpl->set_var('f_img_src', PATH_IMG.$this->row_sql[$v["f_name"]]);
                        //}
                  }                 
                  */
                  if($v["f_type"] == "new_form_row_file_edit")
                  {   
                        //if(isset($_GET["idd"]))
                        //{
                              //$v["f_type"] = "new_form_row_file_edit";
                              $this->tmpl->set_var('f_img_src', PATH_IMG.$this->row_sql[$v["f_name"]]);
                        //}
                  }                 
                  //input
                  if($v["f_type"] != "new_form_row_date_from" && $v["f_type"] != "new_form_row_date_to")
                  {   
                        $this->tmpl->parse('div_', $v["f_type"]);
                        $this->tmpl->set_var('id_div', " class=\"".$this->f_input_class."\"");
                        $this->tmpl->parse('form_', 'table_div', true);
                  }
                  else
                  {
                        $this->tmpl->parse('form_', $v["f_type"], true);
                        
                        if($v["f_type"] == "new_form_row_date_to")
                        {
                              $this->tmpl->set_var('div_', "");
                              $this->tmpl->set_var('id_div', " class=\"mar10\"");
                              $this->tmpl->parse('form_', 'table_div', true);
                        }
                  }
                  
                  if(isset($this->f_add_clear) && ($v["f_type"] != "new_form_row_label"))
                        $this->tmpl->parse('form_', 'table_clear', true);
            }
            return $this->tmpl->subst('new_form');                  
      }
}
?><?
class Photo_mini
{
      private $file_name; // z File - ?
      public $img_w = PHOTO_M_W;//szer. miniaturki
      public $img_h = PHOTO_M_H;//wys. miniaturki
      public $img_w_max = PHOTO_MAX_W;//szer. miniaturki
      public $img_h_max = PHOTO_MAX_H;//wys. miniaturki
      public $jpg_quality = 90;
      public $png_quality = 0;
      public $position = 0;//domyslne kadrowanie
      public $error;//komunikat bledu
      public $img_bckg = 0x00FFFFFF;//kolor tla przy wypelnianiu 
      public $cut_type = "crop";//crop - wykadruj, mini - zmniejsz proporcjonalnie, mini_bckg - zmniejsz proporcjonalnie i oblej
      public $override = null;//true - nadpisz, null - stworz osobny obrazek
      
      //zmienne lokalne obrazka
      private $path_img;  // 
      private $dir;  //
      private $w;//szerokość zaladowanego obrazka
      private $h;//szerokość zaladowanego obrazka
      private $type;//typ zaladowanego obrazka
      private $img_exist = null;
      private $w_resamle_new;
      private $h_resamle_new;
      private $w_new;
      private $h_new;
      private $x0 = 0; 
      private $y0 = 0;      
      private $x1 = 0; 
      private $y1 = 0;      
      
      static function rotate_photo($path_img, $dir, $deg)
      {
            if(file_exists($dir.$path_img))
            {
                  $size = getimagesize($dir.$path_img);

                  if($size[2] == 2)
                  {
                        $source = imagecreatefromjpeg($dir.$path_img);
                        $rotate = imagerotate($source, $deg, 0);
                        
                        imagejpeg($rotate, $dir.$path_img, 85);   
                        // Free the memory
                        imagedestroy($source);
                        imagedestroy($rotate);  
                  } 
            }
      }
      
      function __construct($path_img, $dir)
      {
            if(file_exists($dir.$path_img))
            {
                  $this->img_exist = true;
                  //parametry obrazka
                  $size = getimagesize($dir.$path_img);
                  $this->w = $size[0];
                  $this->h = $size[1];
                  $this->type = $size[2];//1 - gif, 2 - jpg, jpeg, 3 - png
                  $this->path_img = $path_img;
                  $this->dir = $dir;
            }
      }
      
      function cut_photo()
      {
            if($this->img_exist)
            {                  
                  //przy mini okrelamy bierzemy max w i h
                  if($this->cut_type == "mini")//testowane i dziala raczej ok!!!
                  {
                        //jesli fotka mniejsza od maxow to nic nie robimy
                        if(($this->img_w_max > $this->w) && ($this->img_h_max > $this->h))
                        {                             
                              //dla oblewania nie ma false
                              //return false;
                              $this->w_resamle_new = $this->w_new = $this->w;
                              $this->h_resamle_new = $this->h_new = $this->h;
                              $this->error = "Zbyt mały rozmiar fotki!";
                        }
                        else
                        {
                                    
                              //ratio
                              $r = min(($this->img_w_max/$this->w), ($this->img_h_max/$this->h));
                                          
                              //modyfikujemy rozmiar nowej duzej foty w zaleznosci od mniejszego ratio
                              $this->w_resamle_new = $this->w_new = round($this->w*$r);
                              $this->h_resamle_new = $this->h_new = round($this->h*$r);
                        }
                  }          
                  else if($this->cut_type == "crop")//kadrowanie
                  {
                        $photo_false = null;
                        if(($this->img_w > $this->w) || ($this->img_h > $this->h))
                              $photo_false = true;
                        //jesli kadrujemy i fotka za mala to oblewamy i srodkujemy
                        if(isset($photo_false))
                        {    
                              //ratio
                              $r = min(($this->img_w/$this->w), ($this->img_h/$this->h), 1);
                              //jesli ktorys rozmiar wiekszy modyfikujemy rozmiar nowej duzej foty w zaleznosci od mniejszego ratio
                              $this->w_resamle_new = round($this->w*$r);
                              $this->h_resamle_new = round($this->h*$r);
                              $this->w_new = $this->img_w;
                              $this->h_new = $this->img_h;
                              
                              //wspolrzedne do wysrodkowania miniaturki
                              $this->x0 = ($this->img_w - $this->w_resamle_new)/2; 
                              $this->y0 = ($this->img_h - $this->h_resamle_new)/2;      
                        }  
                        else
                        {    
                              //ratio
                              $r = $this->w/$this->h;
                              $r_min = $this->img_w/$this->img_h;
                              
                              $w_old = $this->w;
                              $h_old = $this->h;
                              
                              //modyfikujemy rozmiar duzej foty w zaleznosci od ratio miniatury
                              if($r_min > $r)
                                    $this->h = round($this->w/$r_min);
                              else if($r_min < $r)
                                    $this->w = round($this->h*$r_min);
                              
                              //nowe wielkosci fotki
                              $this->w_resamle_new = $this->w_new = $this->img_w;
                              $this->h_resamle_new = $this->h_new = $this->img_h;
                        
                              //wspolrzedne do wysrodkowania miniaturki
                              if($this->position == 0)
                              {
                                    $this->x1 = ($w_old - $this->w)/2;
                                    $this->y1 = ($h_old - $this->h)/2;
                              }
                              else if($this->position == 1)
                              {
                                    $this->x1 = ($w_old - $this->w)/2;
                              }
                              else if($this->position == 2)
                              {
                                    $this->x1 = $w_old - $this->w;
                                    $this->y1 = ($h_old - $this->h)/2;
                              }
                              else if($this->position == 3)
                              {
                                    $this->x1 = ($w_old - $this->w)/2;
                                    $this->y1 = $h_old - $this->h;
                              }
                              else if($this->position == 4)
                              {
                                    $this->y1 = ($h_old - $this->h)/2;
                              }
                        }
                  }       
                  else if($this->cut_type == "mini_bckg")//kadrowanie
                  {
                        //ratio
                        $r = min(($this->img_w/$this->w), ($this->img_h/$this->h), 1);
                        //jesli ktorys rozmiar wiekszy modyfikujemy rozmiar nowej duzej foty w zaleznosci od mniejszego ratio
                        $this->w_resamle_new = round($this->w*$r);
                        $this->h_resamle_new = round($this->h*$r);
                        $this->w_new = $this->img_w;
                        $this->h_new = $this->img_h;
                        
                        //wspolrzedne do wysrodkowania miniaturki
                        $this->x0 = ($this->img_w - $this->w_resamle_new)/2; 
                        $this->y0 = ($this->img_h - $this->h_resamle_new)/2;      
                  }       
      
                  if($this->type != 1 && $this->type != 2 && $this->type != 3) //nieobslugiwany format
                  {
                        $this->error = "Format nie obsługiwany!";
                        return false;
                  }
                  else
                  {
                        if($this->type == 1)
                              $image1 = imagecreatefromgif($this->dir.$this->path_img);
                        else if($this->type == 2)
                              $image1 = imagecreatefromjpeg($this->dir.$this->path_img);
                        else if($this->type == 3)
                              $image1 = imagecreatefrompng($this->dir.$this->path_img);
                        
                        //Resize
                        $image2 = imagecreatetruecolor($this->w_new, $this->h_new);
                        
                        //jesli za mala fotka i oblewamy kolorem
                        if(($this->cut_type == "crop" && isset($photo_false)) || ($this->cut_type == "mini_bckg"))
                              imagefilledrectangle($image2, 0, 0, $this->w_new, $this->h_new, $this->img_bckg);

                        //dziala->
                        //imagecopyresampled($image2, $image1, 50, 0, 0, 0, 100, 100, 100, 100);
                        //imagecopyresampled($image2, $image1, 0, 20, 0, 0, 200, 33, 300, 50);
                        
                        imagecopyresampled($image2, $image1, $this->x0, $this->y0, $this->x1, $this->y1, $this->w_resamle_new, $this->h_resamle_new, $this->w, $this->h);
                        
                        //czy nadpisujemy czy tworzymy nowy plik
                        $ff = new File;
                        if(!isset($this->override))
                              $mini_name = $ff->check_file_exist('m_'.$this->path_img, $this->dir);
                        else
                              $mini_name = $this->path_img;
                        
                        
                        if($this->type == 1)
                              imagegif($image2, $this->dir.$mini_name);
                        else if($this->type == 2)
                              imagejpeg($image2, $this->dir.$mini_name, $this->jpg_quality);
                        else if($this->type == 3)
                              imagepng($image2, $this->dir.$mini_name, $this->png_quality);
                        
                        imagedestroy($image1);
                        imagedestroy($image2);
                        return $mini_name;
                  }
            }
            else
            {
                  $this->error = "Plik nie istnieje!";
                  return false;
            }
      }  

}
?><?
class Weather
{
      //public $amount = 3;
      function __construct()
      {
      }
      
      function str_no_pol($str)
      {
            
            $str = mb_ereg_replace(' ', '_', $str);
            $str = mb_ereg_replace("Ą", "A", $str);
            $str = mb_ereg_replace("ą", "a", $str);
            $str = mb_ereg_replace("Ś", "S", $str);
            $str = mb_ereg_replace("ś", "s", $str);
            $str = mb_ereg_replace("Ń", "N", $str);
            $str = mb_ereg_replace("ń", "n", $str);
            $str = mb_ereg_replace("Ł", "L", $str);
            $str = mb_ereg_replace("ł", "l", $str);
            $str = mb_ereg_replace("Ę", "E", $str);
            $str = mb_ereg_replace("ę", "e", $str);
            $str = mb_ereg_replace("Ó", "O", $str);
            $str = mb_ereg_replace("ó", "o", $str);
            $str = mb_ereg_replace("Ć", "C", $str);
            $str = mb_ereg_replace("ć", "c", $str);
            $str = mb_ereg_replace("Ź", "Z", $str);
            $str = mb_ereg_replace("Ż", "Z", $str);
            $str = mb_ereg_replace("ź", "z", $str);
            $str = mb_ereg_replace("ż", "z", $str);
            return mb_strtolower($str);
      }

      function get_weather($city)
      {
            
            $path = "http://fast4net.home.pl/weather/";
            $xml = simplexml_load_file($path.$this->str_no_pol(trim($city)).".xml");
            //echo "http://www.google.com/ig/api?weather=".$this->str_no_pol(trim($city)).",polska";
            
            $tab_weather = array();
            //$date_ = "<table class=\"table_border\">";
            //$date_ .= "<tr><th>Dzień</th><th>Min. Temp.</th><th>Max. Temp.</th><th colspan=\"2\">Zachmurzenie</th></tr>";
            $next = 0;
            foreach($xml->weather as $item) 
            {
                  foreach($item->item_weather as $new) 
                  {
                        $tab_weather[$next]["day_of_week"] = $new->day['val'];
                        $tab_weather[$next]["low"] = $new->low_temp['val'];
                        $tab_weather[$next]["high"] = $new->high_temp['val'];
                        $tab_weather[$next]["icon"] = $path."img/".$new->icon['val'];
                        $tab_weather[$next]["condition"] = $new->condition['val'];
                        $next++;
                  }
            }
            if($next > 0)
                  return $tab_weather;
            else
                  return false;
      }
      
      function str_no_pol_google($str)
      {
            
            $str = mb_ereg_replace(' ', '+', $str);
            $str = mb_ereg_replace("Ą", "A", $str);
            $str = mb_ereg_replace("ą", "a", $str);
            $str = mb_ereg_replace("Ś", "S", $str);
            $str = mb_ereg_replace("ś", "s", $str);
            $str = mb_ereg_replace("Ń", "N", $str);
            $str = mb_ereg_replace("ń", "n", $str);
            $str = mb_ereg_replace("Ł", "L", $str);
            $str = mb_ereg_replace("ł", "l", $str);
            $str = mb_ereg_replace("Ę", "E", $str);
            $str = mb_ereg_replace("ę", "e", $str);
            $str = mb_ereg_replace("Ó", "O", $str);
            $str = mb_ereg_replace("ó", "o", $str);
            $str = mb_ereg_replace("Ć", "C", $str);
            $str = mb_ereg_replace("ć", "c", $str);
            $str = mb_ereg_replace("Ź", "Z", $str);
            $str = mb_ereg_replace("Ż", "Z", $str);
            $str = mb_ereg_replace("ź", "z", $str);
            $str = mb_ereg_replace("ż", "z", $str);
            return $str;
      }

      function get_weather_google($city)
      {
            $xml = simplexml_load_file("http://www.google.com/ig/api?weather=".$this->str_no_pol(trim($city)).",polska&hl=pl&oe=utf-8");
            //echo "http://www.google.com/ig/api?weather=".$this->str_no_pol(trim($city)).",polska";
            
            $tab_weather = array();
            //$date_ = "<table class=\"table_border\">";
            //$date_ .= "<tr><th>Dzień</th><th>Min. Temp.</th><th>Max. Temp.</th><th colspan=\"2\">Zachmurzenie</th></tr>";
            /*
echo "<pre>";
print_r($xml);
echo "</pre>";
*/  
            $next = 0;
            foreach($xml->weather as $item) 
            {
                  foreach($item->forecast_conditions as $new) 
                  {
                        $tab_weather[$next]["day_of_week"] = $new->day_of_week['data'];
                        $tab_weather[$next]["low"] = $new->low['data'];
                        $tab_weather[$next]["high"] = $new->high['data'];
                        $tab_weather[$next]["icon"] = "http://google.pl".$new->icon['data'];
                        $tab_weather[$next]["condition"] = $new->condition['data'];
                        $next++;
                  }
            }
            if($next > 0)
                  return $tab_weather;
            else
                  return false;
      }
}
?><?
//include("../_cms/classes/phplib/prepend.php");
//include("../_cms/classes/functions.inc");
//include("../_cms/classes/class/baza.inc");
//include("../_cms/classes/class/file.inc");
//include("../_cms/classes/class/graph.inc");
//include("../_cms/classes/class/site.inc");
//include("../_cms/classes/class/google.inc");

//ustawiamy lang
if(isset($_GET["id_language"]))
{
      $_SESSION["id_language"] = $_GET["id_language"]; 
      
      //File::url_to_mod_rewrite();
      //if()
      if(mb_ereg_replace("&amp;","&",path_from_get(array('id_language'))) == "")
            header("Location: index.php");
      else
            header("Location: index.php?".mb_ereg_replace("&amp;","&",path_from_get(array('id_language'))));
                  
      //else
      //      header("Location: /");
}

if(!isset($_SESSION["id_language"]))
{
      $db = new DB__("select menu_service.id_lang from menu_service 
      where menu_service.id='".$_SESSION['id_service']."'");
      if($db->next_record())
            $_SESSION["id_language"] = $db->f('id_lang'); 
}

if(!isset($_GET["id"]))
      $_GET["id"] = null;
if(!isset($_GET["str"]))
      $_GET["str"] = null;
      
check_get_values();
$onload = "if(document.getElementById('war_google')){google_load();}";

$db = new DB__("select link.* from link 
where link.id_menu='".$_GET["id"]."' and link.kind='3'");
if($db->next_record())
      $_GET["id"] = $db->f('link');      

$active_site = null;
if(isset($_GET["search"]) || !isset($_GET["id"]))
      $active_site = "1";
else
{
      $db = new DB__("select menu.main_root from menu 
      where menu.id='".$_GET["id"]."' and menu.type in ('0','1') and menu.main_root in 
      (select id from menu where type='2')");
      if($db->next_record())
            $active_site = "1";
}

$tmpl->set_file('blocks','main_new.html');
$tmpl->set_block('blocks','service');
$tmpl->set_block('blocks','service_bw');
$tmpl->set_block('blocks','table_ul');
$tmpl->set_block('blocks','table_li');
$tmpl->set_block('blocks','table_a');
$tmpl->set_block('blocks','table_span');
$tmpl->set_block('blocks','table_img');
$tmpl->set_block('blocks','table_h1');
$tmpl->set_block('blocks','table_option');
$tmpl->set_block('blocks','table_div');
$tmpl->set_block('blocks','gallery_img_row');
$tmpl->set_block('blocks','banner_downx');
$tmpl->set_block('blocks','html_css');

$tmpl->set_var('css', time());

//cookiessssss
$tmpl->set_var('cookie_d_none', " d_none");
if(!isset($_COOKIE["cooki_2"]))
{
      setcookie("cooki_2", "1", time()+3600*24*365, "/", $_SERVER["SERVER_NAME"]);
      $tmpl->set_var('cookie_d_none', "");
}

$tmpl->set_var('meta_', '');   
$tmpl->set_var('n_nf_news', 0);   
$tmpl->set_var('n_nf_amount', 0);   
$tmpl->set_var('n_sum', 0);   
$tmpl->set_var('sub', "");
$tmpl->set_var('sub_mar', "-230px");
if(!isset($_SESSION['id_service_bw']))
      $tmpl->set_var('bw', "");
else
      $tmpl->set_var('bw', "_bw");

$labels = array();

$db = new DB__("select label_lang.* from label_lang
where label_lang.id_lang='".$_SESSION["id_language"]."'");
while($db->next_record())
{
      $labels[$db->f('id')] = $db->f('name');
      $tmpl->set_var("label".$db->f('id'), $db->f('name'));
}


//
$google_add = "";

if($_SERVER['QUERY_STRING'] == "")
{
      //echo "1".$_SERVER['QUERY_STRING'];
      $tmpl->set_var('path_lang1', "index.php?id_language=1");
      $tmpl->set_var('path_lang2', "index.php?id_language=2");
}
else
{
      //echo "=".$_SERVER['QUERY_STRING']."=";
      $tmpl->set_var('path_lang1', "index.php?".path_from_get(array('comment'))."&amp;id_language=1");
      $tmpl->set_var('path_lang2', "index.php?".path_from_get(array('comment'))."&amp;id_language=2");
}
///wrzucenie etykiet do tablicy

$_services = array();
$_services['idek_home'] = 1;
$_services['idek_home_page'] = 82;
$_services['idek_news'] = 48;
$_services['idek_gallery'] = 29;
$_services['idek_ogl'] = 26;
$_services['idek_inw'] = 27;
$_services['idek_calendar'] = 47;
$_services['idek_foot'] = 81;
$_services['idek_foot2'] = 171;

$_langs = array();
$_langs[1] = "";
$_langs[2] = "_en";

$tmpl->set_var("langs", $_langs[$_SESSION["id_language"]]);
$tmpl->set_var("id_language", $_SESSION["id_language"]);


///zmienne serwisowe do htmla
while(list($k,$v)=each($_services))
{
      $tmpl->set_var($k, $v);
}

$tmpl->set_var('path', "");
$tmpl->set_var('div_war', "");
$tmpl->set_var('id', $_GET["id"]);
$tmpl->set_var('n_w', PHOTO_M_W);
$tmpl->set_var('n_h', PHOTO_M_H);

$is_title = null;
$tmpl->set_var('TITLE_SITE', SITE_NAME);
//keywords %& description - nadrzędne
$db = new DB__("select menu_lang.title, menu_lang.keywords, menu_lang.description from menu_lang 
where menu_lang.id_menu='".$_services['idek_home_page']."' and menu_lang.id_lang='".$_SESSION["id_language"]."'");
if($db->next_record())
{
      $tmpl->set_var('DESCRIPTION_SITE', $db->f('description'));
      $tmpl->set_var('KEYWORDS_SITE', $db->f('keywords'));
      if($db->f('title') != "")
      {
            $tmpl->set_var('TITLE_SITE', substr($db->f('title'),0,64));
            $is_title = true;
      }
}

/*
$b = new Banner;
$tmpl->set_var('banner_foot', $b->show_baner(1));
$tmpl->set_var('banner_right', $b->show_baner(2));
$b->banner_as_bckg = 1;
$tmpl->set_var('banner_main', $b->show_baner(3));
$tmpl->set_var('data', (date("d") + 0)." ".File::month2(date("m"), $_SESSION["id_language"])." ".date("Y"));
$tmpl->set_var('godz', date("H:i"));
 */

if(isset($active_site))
{
      if(!isset($_SESSION["counter_site"]))
            $_SESSION["counter_site"] = null;      
      if(!isset($_SESSION["counter_site_idd"]))
            $_SESSION["counter_site_idd"] = null;      
      
      if(!isset($_SESSION["counter"][$_SESSION["id_service"]]))
      {
            $_SESSION["counter"] = array();
            $_SESSION["counter"][$_SESSION["id_service"]] = 1;
            $db = new DB__("select * from stats where id_service='".$_SESSION['id_service']."'");
            if($db->nf())
                  new DB__("update stats set counter=counter+1 where id_service='".$_SESSION['id_service']."'");
            else
                  new DB__("insert into stats (counter, id_service) values ('1','".$_SESSION['id_service']."')");
      }

      if(isset($_GET["id"]))
      {
            if($_GET["id"] != $_SESSION["counter_site"] && !isset($_GET["idd"]))
            {
                  $_SESSION["counter_site"] = $_GET["id"];
                  $db = new DB__("select * from stats_site where id_site='".$_GET["id"]."' and idd_site='0'");
                  if($db->next_record())
                        new DB__("update stats_site set counter=counter+1 where id_site='".$_GET["id"]."' and idd_site='0'");
                  else
                        new DB__("insert into stats_site (id_site, idd_site, counter) values ('".$_GET["id"]."','0','1')");
            }
      }    
      if(isset($_GET["idd"]))
      {
            if($_GET["id"] != $_SESSION["counter_site"] || $_GET["idd"] != $_SESSION["counter_site_idd"])
            {
                  $_SESSION["counter_site_idd"] = $_GET["idd"];
                  $db = new DB__("select * from stats_site where id_site='".$_GET["id"]."' and idd_site='".$_GET["idd"]."'");
                  if($db->next_record())
                        new DB__("update stats_site set counter=counter+1 where id_site='".$_GET["id"]."' and idd_site='".$_GET["idd"]."'");
                  else
                        new DB__("insert into stats_site (id_site, idd_site, counter) values ('".$_GET["id"]."','".$_GET["idd"]."','1')");
            }
      }    
}

$idek = 23;

$sql = "select menu.*, menu_lang.name, link.link, link.kind, link.target, text.text, template_menu.id_template as template from menu
left join menu_lang on menu_lang.id_menu=menu.id and menu_lang.id_lang='".$_SESSION["id_language"]."'
left join link on link.id_menu=menu.id and link.id_lang='".$_SESSION["id_language"]."'
left join text on text.id_menu=menu.id and text.id_lang='".$_SESSION["id_language"]."'
left join template_menu on template_menu.id_menu=menu.id
where menu.id_menu='".$idek."' and menu_lang.name != '' and menu.type='1'
group by menu.id
order by menu.ord";
$tab_menu = Baza_site::page_link($sql, 1);

if(!empty($tab_menu))
{
      $tab_roots = Baza::tab_of_roots($_GET["id"]);
      $tmpl->set_var("ul_", "");
      $tmpl->set_var("ul_temp","");
      $next = 0;
      
      while(list($k, $v) = each($tab_menu))
      {
            $next++;
            $tmpl->set_var("id_a", "");
            $tmpl->set_var("id_li", "");
            $tmpl->set_var("li_temp", "");
            
            if(!isset($v["linking"]))
            {
                  $tmpl->set_var("span_", $v["name"]);
                  $tmpl->parse("li_temp", "table_span");
            }
            else
            {                          
                  $tmpl->set_var("a_", $v["name"]);
                  $tmpl->set_var("id_a", " id=\"a_li$next\" ".$v["target"]);                 
                  $tmpl->set_var("a_link", $v["link"]);                 
                  $tmpl->parse("li_temp",'table_a');
            }
            
            /////submenu
            //$id_li = "";
            if(1)//($_GET["id"] == $v["id"]) || (in_array($v["id"], $tab_roots)))//3 - str gl
            {
                  $sql2 = "select menu.*, menu_lang.name, link.link, link.kind, link.target, text.text, template_menu.id_template as template from menu
left join menu_lang on menu_lang.id_menu=menu.id and menu_lang.id_lang='".$_SESSION["id_language"]."'
left join link on link.id_menu=menu.id and link.id_lang='".$_SESSION["id_language"]."'
left join text on text.id_menu=menu.id and text.id_lang='".$_SESSION["id_language"]."'
left join template_menu on template_menu.id_menu=menu.id
where menu.id_menu='".$v["link_old"]."' and menu_lang.name != '' and menu.type='1'
group by menu.id
order by menu.ord";
                  $tab_menu2 = Baza_site::page_link($sql2);
                  
                  if(!empty($tab_menu2))
                  {
                        $tmpl->set_var("id_ul", " class=\"d_none\" id=\"idek".$next."\"");
                        $tmpl->set_var("ul_", "");
                        $next2 = 0;
                        while(list($kk, $vv) = each($tab_menu2))
                        {                        
                              $next2++;
                              if($next2 == sizeof($tab_menu2))
                                    $tmpl->set_var("id_li", " class=\"_last\"");
                              else
                                    $tmpl->set_var("id_li", "");
                              if(!isset($vv["linking"]))
                              {
                                    $tmpl->set_var("span_", $vv["name"]);
                                    $tmpl->parse("li_", "table_span");
                              }
                              else
                              {                          
                                    //$tmpl->set_var("a_", $vv["name"]);
                                    $tmpl->set_var("a_", $vv["icon"].$vv["name"].$vv["size"]);
                                    $tmpl->set_var("a_link", $vv["link"]);
                                    $tmpl->set_var("id_a", $vv["target"]);  
                                    $tmpl->parse("li_", 'table_a');                              
                              }
                              $tmpl->parse("ul_", 'table_li',true);
                        }
                        $tmpl->parse("li_temp", 'table_ul', true);
                  }
                  //$id_li .= " class=\"m_sel\"";
            }
            
            $id_li = "";
            if(($v["id"] == $_GET["id"]) || (in_array($v["id"], $tab_roots)) || (($v["id"] == $_services['idek_home_page']) && !isset($_GET["id"])))
                  $id_li .= "m_sel";
            else
                  $id_li .= "";
                  
            //if($next == sizeof($tab_menu))      
            //      $id_li .= " m_last";
                             
            $tmpl->set_var("id_li", " id=\"li$next\" class=\"$id_li\"");
            
            $tmpl->parse("li_","li_temp");            
            $tmpl->parse("ul_temp", 'table_li',true);   
      }
      $tmpl->set_var("id_ul", "");

      $tmpl->parse("ul_",'ul_temp');
      $tmpl->set_var("id_ul", "");
      $tmpl->parse("ul_hor", 'table_ul');     
}

else
{
      $tmpl->set_var("ul_hor", '');   
}
      
$sql = "select menu.*, menu_lang.name, link.link, link.kind, link.target, text.text, template_menu.id_template as template from menu
left join menu_lang on menu_lang.id_menu=menu.id and menu_lang.id_lang='".$_SESSION["id_language"]."'
left join link on link.id_menu=menu.id and link.id_lang='".$_SESSION["id_language"]."'
left join text on text.id_menu=menu.id and text.id_lang='".$_SESSION["id_language"]."'
left join template_menu on template_menu.id_menu=menu.id
where menu.id_menu='".$idek."' and menu_lang.name != '' and menu.type='1'
group by menu.id
order by menu.ord";
$tab_menu = Baza_site::page_link($sql, 1);

if(!empty($tab_menu))
{
      $tab_roots = Baza::tab_of_roots($_GET["id"]);
      $tmpl->set_var("ul_", "");
      $tmpl->set_var("ul_temp","");
      $next = 0;
      
      while(list($k, $v) = each($tab_menu))
      {
            $next++;
            $tmpl->set_var("id_a", "");
            $tmpl->set_var("id_li", "");
            $tmpl->set_var("li_temp", "");
            
            if(!isset($v["linking"]))
            {
                  $tmpl->set_var("span_", $v["name"]);
                  $tmpl->parse("li_temp", "table_span");
            }
            else
            {                          
                  $tmpl->set_var("a_", $v["name"]);
                  $tmpl->set_var("id_a", " title=\"".$v["name"]."\"".$v["target"]);                 
                  $tmpl->set_var("a_link", $v["link"]);                 
                  $tmpl->parse("li_temp",'table_a');
            }
            
            $id_li = "";
            if((($v["link_old"] == $_GET["id"]) && isset($_GET["id"])) || (in_array($v["link_old"], $tab_roots)) || (!isset($_GET["id"]) && $next == 1))
                  $id_li .= " class=\"m_sel$next\"";
            else
                  $id_li .= "";
            
            $tmpl->set_var("id_li", $id_li);
            
            $tmpl->parse("li_","li_temp");            
            $tmpl->parse("ul_temp", 'table_li',true);   
      }
      $tmpl->set_var("id_ul", "");

      $tmpl->parse("ul_",'ul_temp');
      $tmpl->set_var("id_ul", " class=\"f_left\"");
      $tmpl->parse("ul_foot1", 'table_ul');     
}
else
{
      $tmpl->set_var("ul_foot1", '');   
}

$idek = $_services['idek_foot'];

$sql = "select menu.*, menu_lang.name, link.link, link.kind, link.target, text.text, template_menu.id_template as template from menu
left join menu_lang on menu_lang.id_menu=menu.id and menu_lang.id_lang='".$_SESSION["id_language"]."'
left join link on link.id_menu=menu.id and link.id_lang='".$_SESSION["id_language"]."'
left join text on text.id_menu=menu.id and text.id_lang='".$_SESSION["id_language"]."'
left join template_menu on template_menu.id_menu=menu.id
where menu.id_menu='".$idek."' and menu_lang.name != '' and menu.type='1'
group by menu.id
order by menu.ord";
$tab_menu = Baza_site::page_link($sql, 1);

if(!empty($tab_menu))
{
      $tmpl->set_var("ul_", "");
      $tmpl->set_var("ul_temp","");
      $next = 0;
      
      while(list($k, $v) = each($tab_menu))
      {
            $next++;
            $tmpl->set_var("id_a", "");
            $tmpl->set_var("id_li", "");
            $tmpl->set_var("li_temp", "");
            
            if(!isset($v["linking"]))
            {
                  $tmpl->set_var("span_", $v["name"]);
                  $tmpl->parse("li_temp", "table_span");
            }
            else
            {                          
                  $tmpl->set_var("a_", $v["name"]);
                  $tmpl->set_var("id_a", " title=\"".$v["name"]."\"".$v["target"]);                 
                  $tmpl->set_var("a_link", $v["link"]);                 
                  $tmpl->parse("li_temp",'table_a');
            }
            
            /////submenu
            $id_li = " class=\"_red\"";
            $tmpl->set_var("id_li", $id_li);
            
            $tmpl->parse("li_","li_temp");            
            $tmpl->parse("ul_temp", 'table_li',true);   
      }
      $tmpl->set_var("id_ul", " ");

      $tmpl->parse("ul_",'ul_temp');
      $tmpl->set_var("id_ul", "");
      $tmpl->parse("ul_foot2", 'table_ul');     
}
else
{
      $tmpl->set_var("ul_foot2", '');   
}
$idek = $_services['idek_foot2'];

$sql = "select menu.*, menu_lang.name, link.link, link.kind, link.target, text.text, template_menu.id_template as template from menu
left join menu_lang on menu_lang.id_menu=menu.id and menu_lang.id_lang='".$_SESSION["id_language"]."'
left join link on link.id_menu=menu.id and link.id_lang='".$_SESSION["id_language"]."'
left join text on text.id_menu=menu.id and text.id_lang='".$_SESSION["id_language"]."'
left join template_menu on template_menu.id_menu=menu.id
where menu.id_menu='".$idek."' and menu_lang.name != '' and menu.type='1'
group by menu.id
order by menu.ord";
$tab_menu = Baza_site::page_link($sql, 1);

if(!empty($tab_menu))
{
      $tmpl->set_var("ul_", "");
      $tmpl->set_var("ul_temp","");
      $next = 0;
      
      while(list($k, $v) = each($tab_menu))
      {
            $next++;
            $tmpl->set_var("id_a", "");
            $tmpl->set_var("id_li", "");
            $tmpl->set_var("li_temp", "");
            
            if(!isset($v["linking"]))
            {
                  $tmpl->set_var("span_", $v["name"]);
                  $tmpl->parse("li_temp", "table_span");
            }
            else
            {                          
                  $tmpl->set_var("a_", $v["name"]);
                  $tmpl->set_var("id_a", " title=\"".$v["name"]."\"".$v["target"]);                 
                  $tmpl->set_var("a_link", $v["link"]);                 
                  $tmpl->parse("li_temp",'table_a');
            }
            
            /////submenu
            $id_li = " class=\"_green\"";
            $tmpl->set_var("id_li", $id_li);
            
            $tmpl->parse("li_","li_temp");            
            $tmpl->parse("ul_temp", 'table_li',true);   
      }
      $tmpl->set_var("id_ul", "");

      $tmpl->parse("ul_",'ul_temp');
      $tmpl->set_var("id_ul", "");
      $tmpl->parse("ul_foot3", 'table_ul');     
}
else
{
      $tmpl->set_var("ul_foot3", '');   
}
     

if(A_MAIN_NEWS != "")
{
      $tmpl->set_var('main_news_bar_d_none', "");
      $tmpl->set_var('A_MAIN_NEWS', A_MAIN_NEWS);
}
else
      $tmpl->set_var('main_news_bar_d_none', "d_none");
            
      
if(!isset($_GET["id"]) && !isset($_GET["search"]))
         include("../pl/inc/page.inc");
else
         include("../pl/inc/site.inc");

$tmpl->set_var('body_js'," onload=\"".$onload."\" onkeydown=\"close_war(event);\" onmousemove=\"get_x_mouse(event);\"");


if(isset($_SESSION['id_service_bw']))
{
      $tmpl->set_var('styl_bw', "<link rel=\"stylesheet\" href=\"/styl_bw.css?rand=".time()."\" type=\"text/css\"/>");
      $tmpl->set_var('skip_bw', "<li><a href=\"/\">Przejdź do wersji klasycznej serwisu</a></li>");
      $tmpl->set_var('ico_bw', "<a href=\"/\"><img src=\"../images/img/spacer.gif\" class=\"spacer\" alt=\"Przejdź do: Wersja klasyczna serwisu\"/>");
}
else                                         
{
      $tmpl->set_var('styl_bw', "");
      $tmpl->set_var('skip_bw', "<li><a href=\"/bw\">Przejdź do wersji kontrastowej serwisu</a></li>");
      $tmpl->set_var('ico_bw', "<a href=\"../bw\"><img src=\"../images/img/spacer.gif\" class=\"spacer\" alt=\"Przejdź do: Wersja kontrastowa serwisu\"/>");
}

//if(!isset($_SESSION['id_service_bw']))
      $tmpl->psubst('service'); 
//else
//      $tmpl->psubst('service_bw'); 

//echo $sql_am;
//new DB__("insert into stats_x (date_, ip, site, amount) values (now(),'".getClientIp()."', '".$_SERVER['REQUEST_URI']."', '$sql_am')");


?>