<?php
session_start();

include_once 'classes/lg-on_Smarty.class.php';
$smarty = new lgon_Smarty();
require_once("config.inc.php");
$templatename = substr(basename($_SERVER['PHP_SELF']),0,-3)."html";
require_once "language/german.inc.php";
require_once("func_ansicht.php");

##### ÄNDERUNG NEUE LUTHERBIBEL ########
if(date("Y") < 2019){
  require("bibellookup_1984.php");
}else{
  require("bibellookup_2017.php");
}


#if(isset($_GET['knk']) AND $_GET['knk'] > 0){
  $kapitel = $_GET['knk'];
  $kapitelsub = $_GET['knksub'];
  if($kapitelsub == ''){
    $kapitelsub = $kapitel;
  }
  $db = dbconnect();
  
  $result_hist = $db->query("SELECT knkid
                                FROM knk
                               WHERE knk = '$kapitelsub'
                            ");
  $row_hist = $result_hist->fetch_array();
  
  $sid = session_id();
  $datum=date("Y-m-d H:i:s");
  $result_1 = $db->query( "INSERT INTO historie (vaid, datum, session_id, art, art_id) VALUES ('$user_vaid;', '$datum', '$sid', 'K', '$row_hist[knkid]')" );

  
#}else{
#  $kapitel = "vum";
#}


$result0 = $db->query("SELECT min(knkid) mind, max(knkid) maxi
                          FROM knk
                         WHERE knk = '$kapitel'
                            OR knk like '$kapitel.%'
                       ");
$row0 = $result0->fetch_array();

$result1 = $db->query("SELECT 1
                          FROM knk
                         WHERE knkid =$row0[maxi]+1
                           AND art = 'E'
                       ");
$row1 = $result1->fetch_array();


if($row1[0]){
  # Extrakt am Ende des kapitels vorhanden
  $maxi = $row0['maxi']+1;
}else{
  $maxi = $row0['maxi'];
}
    $db = dbconnect();

    $result_link_bibel = $db->query("SELECT bibellink
                                         FROM profil
                                        WHERE user='$user_admin'");
    $row_link_bibel = $result_link_bibel->fetch_array();
    if($row_link_bibel['bibellink'] == 'lokal'){
      $query = "SELECT ueberschrift, text_lokal text, art, knk
                  FROM knk
                 WHERE knkid between $row0[mind] and $maxi
                 ORDER BY knkid ASC
               ";
    }else{
      $query = "SELECT ueberschrift, text_bibleserver text, art, knk
                  FROM knk
                 WHERE knkid between $row0[mind] and $maxi
                 ORDER BY knkid ASC
               ";
    
    }

   $result = $db->query( $query)
             or die ("Cannot execute query");
   while ($row = $result->fetch_array()){    
      $value[] = $row;
    }
    // Assign this array to smarty...
    $smarty->assign('table_data1', $value);
$smarty->display("$template/$templatename");
?>