<?php 
  session_start(); $session = session_id('PHPSESSID'); 
  $session_id = $_GET['PHPSESSID']; 
  if( !empty($session_id) ){ $session = $session_id; }; 

/* =========== Config aj. =========== */
  if( !file_exists('./config.php') ){ exit; };
  require_once './config.php';
  require_once "./menu.php";

  require_once "./language/".$Config['DB_read']['language'].".php";

/* =========== Připojení k Databázi =========== */

  @mysql_connect( $Config['DB_read']['Database']['Host'], $Config['DB_read']['Database']['User'], $Config['DB_read']['Database']['Password'] ) 
    OR DIE("<p>Vyskytla se chyba a nelze se připojit k databázi.<br> Zkuste to později.</p>"); 
  $DB_mangos = mysql_select_db($Config['DB_read']['DB_read']['Database_mangos']);
    if( !$DB_mangos ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_mangos']."!</p>"); };
/*  $DB_realmd = mysql_select_db($Config['DB_read']['DB_read']['Database_realmd']);
    if( !$DB_realmd ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_realmd']."!</p>"); };
  $DB_web = mysql_select_db($Config['DB_read']['DB_read']['Database_web']);
    if( !$DB_web ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>"); }; */
  @mysql_query("SET NAMES ".$Config['DB_read']['DB_read']['Charset']); 

/* =========== Speciální FCE =========== */
  function DelNl($str){ 
    $str = @str_replace("\n","",$str);
    $str = @str_replace("\r","",$str);
    return $str;
    };

  function AbsCheck($int){ return (abs($int)==$int)? true : false; };
  
  function CheckQuestRace(){
    
    };

  function StranovaniVypisu($sql, $limit, $nastranu, $adresa, $SID){ 
    global $text;
    $pocet_radku = @mysql_num_rows(mysql_query($sql)); 
    if( $pocet_radku > 0 ) { 
      $listovani = $pocet_radku/10; 
      $listovani = ceil($listovani); 
      $listovani = $listovani/($nastranu/10);
      $listovani = ceil($listovani); 

      if( $listovani == 1 ){ 
        $navigace = "&lt;&lt; &nbsp; &lt; <b>1</b> &gt; &nbsp; &gt;&gt;";
        }
      elseif( $listovani > 1 ){ 
        $predchozi = $limit-1;
        $dalsi = $limit+1;
        $posledni = $listovani;
        if( $predchozi < 1 ){ $predchozi = 1; };

        if( $listovani <= 10 ){ 
          for( $i=1; ($i<=10)AND($i<=$listovani) ;$i++ ){ 
            if($i==$limit){$navigace['cisla'] .= " <b title=\"".$text['navigation']['onpage'].$text['navigation']['number']." $i\">".$i."</b>\n";}
            else{$navigace['cisla'] .= " <a href=\"index.php".$adresa."&amp;list=".$i.$SID."\" title=\"".$text['navigation']['page'].$text['navigation']['number']." $i\">".$i."</a>\n";};
            };

          $navigace['zacatek'] = "<a href=\"index.php".$adresa."&amp;list=1".$SID."\" title=\"".$text['navigation']['start']."\">&lt;&lt;</a>"." &nbsp; ";
          $navigace['zacatek'] .= "<a href=\"index.php".$adresa."&amp;list=".$predchozi.$SID."\" title=\"".$text['navigation']['previous']."\">&lt;</a> ";
          $navigace['konec'] = " <a href=\"index.php".$adresa."&amp;list=".$dalsi.$SID."\" title=\"".$text['navigation']['next']."\">&gt;</a>"." &nbsp; ";
          $navigace['konec'] .= "<a href=\"index.php".$adresa."&amp;list=".$posledni.$SID."\" title=\"".$text['navigation']['end']."\">&gt;&gt;</a>";

          if( $limit == 1 ){ $navigace['zacatek'] = "&lt;&lt;"." &nbsp; &lt; "; };
          if( $limit == $listovani ){ $navigace['konec'] = " &gt; &nbsp; &gt;&gt;"; };
          } 
        else{
          if( $limit <= 6 ){ 
            for( $i=1; ($i<=10) ;$i++ ){ 
              if($i==$limit){$navigace['cisla'] .= " <b title=\"".$text['navigation']['onpage'].$text['navigation']['number']." $i\">".$i."</b>\n";}
              else{$navigace['cisla'] .= " <a href=\"index.php".$adresa."&amp;list=".$i.$SID."\" title=\"".$text['navigation']['page'].$text['navigation']['number']." $i\">".$i."</a>\n";};
              }; $navigace['cisla'] .= " ... ";
            } 
          elseif( $limit >= 6 AND (($limit+6) <= $listovani) ){ 
            $navigace['cisla'] .= " ... ";
            
            for( $i=$limit-5; ($i<=$limit+5) ;$i++ ){ 
  
              if($i==$limit){$navigace['cisla'] .= " <b title=\"".$text['navigation']['onpage'].$text['navigation']['number']." $i\">".$i."</b>\n";}
              else{$navigace['cisla'] .= " <a href=\"index.php".$adresa."&amp;list=".$i.$SID."\" title=\"".$text['navigation']['page'].$text['navigation']['number']." $i\">".$i."</a>\n";};
  
              }; $navigace['cisla'] .= " ... ";
            } 
          elseif( ($limit+6) >= $listovani ){ 
            $navigace['cisla'] .= " ... ";
            for( $i=$listovani-10; ($i<=$listovani) ;$i++ ){ 
              if($i==$limit){$navigace['cisla'] .= " <b title=\"".$text['navigation']['onpage'].$text['navigation']['number']." $i\">".$i."</b>\n";}
              else{$navigace['cisla'] .= " <a href=\"index.php".$adresa."&amp;list=".$i.$SID."\" title=\"".$text['navigation']['page'].$text['navigation']['number']." $i\">".$i."</a>\n";};
              }; 
            }; 

          $navigace['zacatek'] = "<a href=\"index.php".$adresa."&amp;list=1".$SID."\" title=\"".$text['navigation']['start']."\">&lt;&lt;</a>"." &nbsp; ";
          $navigace['zacatek'] .= "<a href=\"index.php".$adresa."&amp;list=".$predchozi.$SID."\" title=\"".$text['navigation']['previous']."\">&lt;</a> ";
          $navigace['konec'] = " <a href=\"index.php".$adresa."&amp;list=".$dalsi.$SID."\" title=\"".$text['navigation']['next']."\">&gt;</a>"." &nbsp; ";
          $navigace['konec'] .= "<a href=\"index.php".$adresa."&amp;list=".$posledni.$SID."\" title=\"".$text['navigation']['end']."\">&gt;&gt;</a>";


          if( $limit == 1 ){ $navigace['zacatek'] = "&lt;&lt;"." &nbsp; &lt; "; };
          if( $limit == $listovani ){ $navigace['konec'] = " &gt; &nbsp; &gt;&gt;"; };
          };
        $navigace = $navigace['zacatek'].$navigace['cisla'].$navigace['konec'];
        };
      
      return $navigace;
      }
    else{ return FALSE; };
    };

  function SQLselect_Strankovani($dotaz, $limit, $nastranu, $adresa, $SID){ 
    $navigace = StranovaniVypisu($dotaz, $limit, $nastranu, $adresa, $SID);
    $dotaz =  @mysql_query($dotaz." LIMIT ".(--$limit*10*($nastranu/10)).", $nastranu "); 
    $vysledek = array( '1'           => $dotaz, 
                       'strankovani' => $navigace );
    return $vysledek;
    };

/* =========== END_TOP =========== */
  $vlozeni_souboru = "OK";


    /* =========== GET hodnoty =========== */
    $id = $_GET['id']; // tady získá id z adresy
    $q = addslashes($_GET['q']); 
    $limit = $_GET['list']; // tady získá list z adresy
      if( is_numeric($limit) == FALSE ){ unset($limit); };
      if( $limit < 1 OR empty($limit) ){ $limit = 1; };
    $bug = addslashes($_GET['bug']); 
      if( is_numeric($bug) == FALSE ){ unset($bug); }; 
    $quest = addslashes($_GET['quest']);
      if( is_numeric($quest) == FALSE ){ unset($quest); };
    $creature = addslashes($_GET['creature']);
      if( is_numeric($creature) == FALSE ){ unset($creature); };
    $lvl_d = addslashes($_GET['lvl_d']);
      if( is_numeric($lvl_d) == FALSE ){ unset($lvl_d); };
    $lvl_h = addslashes($_GET['lvl_h']);
      if( is_numeric($lvl_h) == FALSE ){ unset($lvl_h); };

    /* =========== Vložení základního souboru =========== */ 
    require_once "post_read.php";
    require_once "hlavni.php";
          

  mysql_close(); // odpojíme se od databáze 
  unset($vlozeni_souboru); 
/* =========== END_scritps =========== */
?>
