<?
require_once('data_base.php');

//$dbhost = "darlowo.pl";
$dbhost = "localhost";
$dbuname = "gclsldcp_dlgr";
$dbuser = "gclsldcp_dlgr";
$dbpass = "qSaJqtE{4ShR";
$dbname = "gclsldcp_dlgr_temp";

$db_prefix = "cms_";
$db_strony = $db_prefix."strony";
$db_strony_zdjecia = $db_prefix."strony_zdjecia";
$db_strony_filmy = $db_prefix."strony_filmy";
$db_strony_zalaczniki = $db_prefix."strony_zalaczniki";
$db_fotogaleria_albumy = $db_prefix."fotogaleria_albumy";
$db_fotogaleria_zdjecia = $db_prefix."fotogaleria_zdjecia";
$db_wideogaleria_albumy = $db_prefix."wideogaleria_albumy";
$db_wideogaleria_filmy = $db_prefix."wideogaleria_filmy";
$db_artykuly = $db_prefix."artykuly";
$db_artykuly_zdjecia = $db_prefix."artykuly_zdjecia";
$db_artykuly_filmy = $db_prefix."artykuly_filmy";
$db_artykuly_zalaczniki = $db_prefix."artykuly_zalaczniki";
$db_ogloszenia = $db_prefix."ogloszenia";
$db_ogloszenia_zalaczniki = $db_prefix."ogloszenia_zalaczniki";
$db_nabory = $db_prefix."nabory";
$db_nabory_zalaczniki = $db_prefix."nabory_zalaczniki";
$db_kategorie = $db_prefix."kategorie";
$db_skrypty = $db_prefix."skrypty";
$db_newsletter = $db_prefix."newsletter";
$db_newsletter_odbiorcy = $db_prefix."newsletter_odbiorcy";
$db_newsletter_zalaczniki = $db_prefix."newsletter_zalaczniki";
$db_reklamy = $db_prefix."reklamy";
$db_mapa_punkty = $db_prefix."mapa_punkty";
$db_mapa_rodzaje = $db_prefix."mapa_rodzaje";
$db_redakcja = $db_prefix."redakcja";
$db_banery = $db_prefix."banery";
$db_wydarzenia = $db_prefix."wydarzenia";

$sciezka_prefix = "/home/dlgr/public_html/";
$sciezka_konfiguracja = $sciezka_prefix."include/";
$sciezka_fotogaleria = $sciezka_prefix."files/fotogaleria/";
$sciezka_wideogaleria = $sciezka_prefix."files/wideogaleria/";
$sciezka_strony = $sciezka_prefix."files/strony/";
$sciezka_artykuly = $sciezka_prefix."files/artykuly/";
$sciezka_ogloszenia = $sciezka_prefix."files/ogloszenia/";
$sciezka_nabory = $sciezka_prefix."files/nabory/";
$sciezka_newsletter = $sciezka_prefix."files/newsletter/";
$sciezka_reklamy = $sciezka_prefix."files/reklamy/";
$sciezka_naglowek = $sciezka_prefix."files/naglowek/";
$sciezka_skrypty = $sciezka_prefix."skrypty/";
$sciezka_banery = $sciezka_prefix."banery/";
$sciezka_archiwum = $sciezka_prefix."archive/";

$sciezka_pliki = "/home/dlgr/public_html/userfiles/";
$sciezka_pliki_strona = "/home/dlgr/public_html/";
$sciezka_pliki_krotka = "/userfiles/";

$types_menus = array('menu_top' => 'Menu górne', 'menu_left' => 'Menu lewe', 'menu_right' => 'Menu prawe');

$redakcja_poziom = array(0 => 'administrator', 1 => 'redaktor naczelny', 2 => 'redaktor', 3 => 'korespondent', 4 => 'fotograf', 5 => 'moderator');

$languages = array('pl' => 'polski', 'en' => 'angielski', 'de' => 'niemiecki', 'ru' => 'rosyjski', 'fr' => 'francuski');

$panele = array(
'strona_startowa' => 'Strona startowa'
);

$salt = 'GCL.pl - dlgr.pl';

$ilosc_artykulow_na_strone = 20;

$miesiace_m= array('', 'styczeń', 'luty', 'marzec', 'kwiecień', 'maj', 'czerwiec', 'lipiec', 'sierpień', 'wrzesień', 'październik', 'listopad', 'grudzień');
$miesiace_d = array('', 'stycznia', 'lutego', 'marca', 'kwietnia', 'maja', 'czerwca', 'lipca', 'sierpnia', 'września', 'października', 'listopada', 'grudnia');

// laczenie z baza
//$db = mysql_connect("$dbhost", "$dbuname", "$dbpass") or Die(gcl_mysql_error());
//mysql_select_db("$dbname");
//mysql_query("SET NAMES 'utf8'");
//mysql_query('SET CHARACTER SET utf8;');

/*
$mysql = new MySQL($dbhost, $dbuser, $dbpass, $dbname);
if ($mysql->connect_error) {
			die('Failed to connect to MySQL - ' . $mysql->connect_error);
		}
$mysql->set_charset('utf8');
*/
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
try {
    $mysql = new MySQL($dbhost, $dbuser, $dbpass, $dbname);
    if ($mysql->connect_errno) {
        throw new Exception("Failed to connect: " . $mysql->connect_error);
    }
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
    exit();
    //Die("Error: " . $e->getMessage());
}
$mysql->set_charset('utf8');


function utf8_substr($str,$from,$len){
# utf8 substr
# www.yeap.lv
  return preg_replace('#^(?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.$from.'}'.
                       '((?:[\x00-\x7F]|[\xC0-\xFF][\x80-\xBF]+){0,'.$len.'}).*#s',
                       '$1',$str);
}

function cleanString($string, $toLower = true, $space = '_'){
    $chars=array(
        chr(195).chr(128) => 'A', chr(195).chr(129) => 'A',
        chr(195).chr(130) => 'A', chr(195).chr(131) => 'A',
        chr(195).chr(132) => 'A', chr(195).chr(133) => 'A',
        chr(195).chr(135) => 'C', chr(195).chr(136) => 'E',
        chr(195).chr(137) => 'E', chr(195).chr(138) => 'E',
        chr(195).chr(139) => 'E', chr(195).chr(140) => 'I',
        chr(195).chr(141) => 'I', chr(195).chr(142) => 'I',
        chr(195).chr(143) => 'I', chr(195).chr(145) => 'N',
        chr(195).chr(146) => 'O', chr(195).chr(147) => 'O',
        chr(195).chr(148) => 'O', chr(195).chr(149) => 'O',
        chr(195).chr(150) => 'O', chr(195).chr(153) => 'U',
        chr(195).chr(154) => 'U', chr(195).chr(155) => 'U',
        chr(195).chr(156) => 'U', chr(195).chr(157) => 'Y',
        chr(195).chr(159) => 's', chr(195).chr(160) => 'a',
        chr(195).chr(161) => 'a', chr(195).chr(162) => 'a',
        chr(195).chr(163) => 'a', chr(195).chr(164) => 'a',
        chr(195).chr(165) => 'a', chr(195).chr(167) => 'c',
        chr(195).chr(168) => 'e', chr(195).chr(169) => 'e',
        chr(195).chr(170) => 'e', chr(195).chr(171) => 'e',
        chr(195).chr(172) => 'i', chr(195).chr(173) => 'i',
        chr(195).chr(174) => 'i', chr(195).chr(175) => 'i',
        chr(195).chr(177) => 'n', chr(195).chr(178) => 'o',
        chr(195).chr(179) => 'o', chr(195).chr(180) => 'o',
        chr(195).chr(181) => 'o', chr(195).chr(182) => 'o',
        chr(195).chr(182) => 'o', chr(195).chr(185) => 'u',
        chr(195).chr(186) => 'u', chr(195).chr(187) => 'u',
        chr(195).chr(188) => 'u', chr(195).chr(189) => 'y',
        chr(195).chr(191) => 'y',
        chr(196).chr(128) => 'A', chr(196).chr(129) => 'a',
        chr(196).chr(130) => 'A', chr(196).chr(131) => 'a',
        chr(196).chr(132) => 'A', chr(196).chr(133) => 'a',
        chr(196).chr(134) => 'C', chr(196).chr(135) => 'c',
        chr(196).chr(136) => 'C', chr(196).chr(137) => 'c',
        chr(196).chr(138) => 'C', chr(196).chr(139) => 'c',
        chr(196).chr(140) => 'C', chr(196).chr(141) => 'c',
        chr(196).chr(142) => 'D', chr(196).chr(143) => 'd',
        chr(196).chr(144) => 'D', chr(196).chr(145) => 'd',
        chr(196).chr(146) => 'E', chr(196).chr(147) => 'e',
        chr(196).chr(148) => 'E', chr(196).chr(149) => 'e',
        chr(196).chr(150) => 'E', chr(196).chr(151) => 'e',
        chr(196).chr(152) => 'E', chr(196).chr(153) => 'e',
        chr(196).chr(154) => 'E', chr(196).chr(155) => 'e',
        chr(196).chr(156) => 'G', chr(196).chr(157) => 'g',
        chr(196).chr(158) => 'G', chr(196).chr(159) => 'g',
        chr(196).chr(160) => 'G', chr(196).chr(161) => 'g',
        chr(196).chr(162) => 'G', chr(196).chr(163) => 'g',
        chr(196).chr(164) => 'H', chr(196).chr(165) => 'h',
        chr(196).chr(166) => 'H', chr(196).chr(167) => 'h',
        chr(196).chr(168) => 'I', chr(196).chr(169) => 'i',
        chr(196).chr(170) => 'I', chr(196).chr(171) => 'i',
        chr(196).chr(172) => 'I', chr(196).chr(173) => 'i',
        chr(196).chr(174) => 'I', chr(196).chr(175) => 'i',
        chr(196).chr(176) => 'I', chr(196).chr(177) => 'i',
        chr(196).chr(178) => 'IJ',chr(196).chr(179) => 'ij',
        chr(196).chr(180) => 'J', chr(196).chr(181) => 'j',
        chr(196).chr(182) => 'K', chr(196).chr(183) => 'k',
        chr(196).chr(184) => 'k', chr(196).chr(185) => 'L',
        chr(196).chr(186) => 'l', chr(196).chr(187) => 'L',
        chr(196).chr(188) => 'l', chr(196).chr(189) => 'L',
        chr(196).chr(190) => 'l', chr(196).chr(191) => 'L',
        chr(197).chr(128) => 'l', chr(197).chr(129) => 'L',
        chr(197).chr(130) => 'l', chr(197).chr(131) => 'N',
        chr(197).chr(132) => 'n', chr(197).chr(133) => 'N',
        chr(197).chr(134) => 'n', chr(197).chr(135) => 'N',
        chr(197).chr(136) => 'n', chr(197).chr(137) => 'N',
        chr(197).chr(138) => 'n', chr(197).chr(139) => 'N',
        chr(197).chr(140) => 'O', chr(197).chr(141) => 'o',
        chr(197).chr(142) => 'O', chr(197).chr(143) => 'o',
        chr(197).chr(144) => 'O', chr(197).chr(145) => 'o',
        chr(197).chr(146) => 'OE',chr(197).chr(147) => 'oe',
        chr(197).chr(148) => 'R', chr(197).chr(149) => 'r',
        chr(197).chr(150) => 'R', chr(197).chr(151) => 'r',
        chr(197).chr(152) => 'R', chr(197).chr(153) => 'r',
        chr(197).chr(154) => 'S', chr(197).chr(155) => 's',
        chr(197).chr(156) => 'S', chr(197).chr(157) => 's',
        chr(197).chr(158) => 'S', chr(197).chr(159) => 's',
        chr(197).chr(160) => 'S', chr(197).chr(161) => 's',
        chr(197).chr(162) => 'T', chr(197).chr(163) => 't',
        chr(197).chr(164) => 'T', chr(197).chr(165) => 't',
        chr(197).chr(166) => 'T', chr(197).chr(167) => 't',
        chr(197).chr(168) => 'U', chr(197).chr(169) => 'u',
        chr(197).chr(170) => 'U', chr(197).chr(171) => 'u',
        chr(197).chr(172) => 'U', chr(197).chr(173) => 'u',
        chr(197).chr(174) => 'U', chr(197).chr(175) => 'u',
        chr(197).chr(176) => 'U', chr(197).chr(177) => 'u',
        chr(197).chr(178) => 'U', chr(197).chr(179) => 'u',
        chr(197).chr(180) => 'W', chr(197).chr(181) => 'w',
        chr(197).chr(182) => 'Y', chr(197).chr(183) => 'y',
        chr(197).chr(184) => 'Y', chr(197).chr(185) => 'Z',
        chr(197).chr(186) => 'z', chr(197).chr(187) => 'Z',
        chr(197).chr(188) => 'z', chr(197).chr(189) => 'Z',
        chr(197).chr(190) => 'z', chr(197).chr(191) => 's',
        chr(226).chr(130).chr(172) => 'E',
        chr(194).chr(163) => '',
        "~" => '', "`" => '', "!" => '', "@" => '', "#" => '', 
        "$" => '', "%" => '', "^" => '', "&" => '', "*" => '', 
        "(" => '', ")" => '', "+" => '', "=" => '', "<" => '', 
        ">" => '', "," => '', "." => '', ";" => '', ":" => '', 
        "'" => '', "\"" => '', "[" => '', "]" => '', "{" => '', 
        "}" => '', "\\" => '', "|" => '', "/" => '_', "?" => '',
        "„" => '', "”" => '',
        //"„" => '&bdquo;', "”" => '&rdquo;',
        "й"=>"i","ц"=>"c","у"=>"u","к"=>"k","е"=>"e","н"=>"n",
        "г"=>"g","ш"=>"sh","щ"=>"sh","з"=>"z","х"=>"x","ъ"=>"\'",
        "ф"=>"f","ы"=>"i","в"=>"v","а"=>"a","п"=>"p","р"=>"r",
        "о"=>"o","л"=>"l","д"=>"d","ж"=>"zh","э"=>"ie","ё"=>"e",
        "я"=>"ya","ч"=>"ch","с"=>"c","м"=>"m","и"=>"i","т"=>"t",
        "ь"=>"\'","б"=>"b","ю"=>"yu",
        "Й"=>"I","Ц"=>"C","У"=>"U","К"=>"K","Е"=>"E","Н"=>"N",
        "Г"=>"G","Ш"=>"SH","Щ"=>"SH","З"=>"Z","Х"=>"X","Ъ"=>"\'",
        "Ф"=>"F","Ы"=>"I","В"=>"V","А"=>"A","П"=>"P","Р"=>"R",
        "О"=>"O","Л"=>"L","Д"=>"D","Ж"=>"ZH","Э"=>"IE","Ё"=>"E",
        "Я"=>"YA","Ч"=>"CH","С"=>"C","М"=>"M","И"=>"I","Т"=>"T",
        "Ь"=>"\'","Б"=>"B","Ю"=>"YU",
        ' ' => $space
  );

    $string = strtr($string, $chars);
   if ($toLower && function_exists('mb_strtolower')) {
     return mb_strtolower(trim($string, $space));
   } else {
     return strtolower(trim($string, $space));
   }

}

function makeUrl($table, $language, $title, $treshold = 0) {
  global $mysql;
  
  $url = cleanString(html_entity_decode($title));
  $sql = $mysql->query("SELECT * FROM $table WHERE jezyk='$language' AND url LIKE '$url%'") or Die(gcl_mysql_error());
  if ($sql->num_rows > $treshold) { 
    $urls = array();
    while ($wiersz = $sql->fetch_array()) {
      //MessageDialog($wiersz['url']);
      $urls[] = str_replace($url, '', $wiersz['url']);
    }
    //MessageDialog(implode(', ', $urls));
    foreach($urls as &$item)
      $item = trim($item, "_ \t\n\r\0\x0B");
    $url = $url.'_'.(max($urls) + 1);
    //MessageDialog($url);
  }
  return $url;
}

function text_conjunction($text) {
  $text = str_replace(' i ', ' i&nbsp;', $text);
  $text = str_replace(' w ', ' w&nbsp;', $text);
  $text = str_replace(' z ', ' z&nbsp;', $text);
  $text = str_replace(' u ', ' u&nbsp;', $text);
  $text = str_replace(' o ', ' o&nbsp;', $text);
  return $text;
}


function pasek_stron($ilosc_stron, $strona, $ilosc_wierszy, $ilosc_wierszy_na_stronie, $ilosc_w_pasku, $query){
	if ($ilosc_stron > 1) {
		if ($strona > 1) $poprzednia = '<a href="'.$query.',p'.($strona - 1).'.html"><span class="btn_prev">nowsze wpisy</span></a>&nbsp;&nbsp;';
		else $poprzednia = '<span class="btn_prev">nowsze wpisy</span>&nbsp;&nbsp;';
		if ($ilosc_stron > $strona) $nastepna = '&nbsp;&nbsp;<a href="'.$query.',p'.($strona + 1).'.html"><span class="btn_next">starsze wpisy</span></a>';
		else $nastepna = '&nbsp;&nbsp;<span class="btn_next">starsze wpisy</span>';
		if ($ilosc_stron <= $ilosc_w_pasku * 2 +1) {
			$ilosc_w_pasku = $ilosc_w_pasku * 2 +1;
			if ($ilosc_w_pasku > $ilosc_stron) $ilosc_w_pasku = $ilosc_stron;
			$pasek = '';
			for ($i = 1; $i <= $ilosc_w_pasku; $i++) {
				$aa = ($i-1)*$ilosc_wierszy_na_stronie;
				$aap = $aa + 1;
				$aak = $aa + $ilosc_wierszy_na_stronie;
				if ($aak > $ilosc_wierszy) $aak = $ilosc_wierszy;
				if ($i == $strona) $pasek .= ' <span class="btn_page_this">'.$i.'</span>';
				else $pasek .= ' <a href="'.$query.',p'.$i.'.html"><span class="btn_page">'.$i.'</span></a>';
			}
		}
		if ($ilosc_stron > $ilosc_w_pasku * 2 +1) {
			$pasek = '';
			$start = $strona - $ilosc_w_pasku;
			if ($start < 1) $start = 1;
			$koniec = $start + $ilosc_w_pasku * 2;
			if ($koniec > $ilosc_stron) $koniec = $ilosc_stron;
			$start = $koniec - $ilosc_w_pasku * 2;
			if ($start < 1) $start = 1;
				
			for ($i = $start; $i <= $koniec; $i++) {
				$aa = ($i-1)*$ilosc_wierszy_na_stronie;
				$aap = $aa + 1;
				$aak = $aa + $ilosc_wierszy_na_stronie;
				if ($aak > $ilosc_wierszy) $aak = $ilosc_wierszy;
				if ($i == $strona) $pasek .= ' <span class="btn_page">'.$i.'</span>';
				else $pasek .= ' <a href="'.$query.',p'.$i.'.html"><span class="btn_page_this">'.$i.'</span></a>';
			}
		}
		return '<div class="nawigacja"><p>'.$poprzednia.' '.$pasek.' '.$nastepna.'</p></div>';
		} else return '';
		
}

function gcl_mysql_error() {
	global $mysql;
	return $mysql->error;
}


?>