93 lines
2.6 KiB
PHP
93 lines
2.6 KiB
PHP
<?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");
|
|
?>
|