95 lines
3.0 KiB
PHP
95 lines
3.0 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'];
|
|
$fragenr = $_GET['knksub'];
|
|
if($fragenr == ''){
|
|
$fragenr = $kapitel;
|
|
}
|
|
$db = dbconnect();
|
|
|
|
$result_hist = $db->query("SELECT number
|
|
FROM knk_fa
|
|
WHERE number = '$fragenr'
|
|
");
|
|
$row_hist = $result_hist->fetch_array();
|
|
|
|
if($row_hist['number'] > 0){
|
|
$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', 'KFA', '$row_hist[number]')" );
|
|
}
|
|
|
|
#}else{
|
|
# $kapitel = "vum";
|
|
#}
|
|
|
|
$db = dbconnect();
|
|
|
|
$result_link_bibel = $db->query("SELECT bibellink
|
|
FROM profil
|
|
WHERE user='$user_admin'");
|
|
$row_link_bibel = $result_link_bibel->fetch_array();
|
|
|
|
|
|
|
|
if(is_numeric(substr($kapitel,0,1))){
|
|
if($row_link_bibel['bibellink'] == 'lokal'){
|
|
$query = "SELECT number, number number1, question, answer_lokal answer, reference_lokal reference, description_lokal description, description2_lokal description2
|
|
FROM knk_fa
|
|
WHERE headline = $kapitel
|
|
ORDER BY number ASC
|
|
";
|
|
}else{
|
|
$query = "SELECT number, number number1, question, answer_bibleserver answer, reference_bibleserver reference, description_bibleserver description, description2_bibleserver description2
|
|
FROM knk_fa
|
|
WHERE headline = $kapitel
|
|
ORDER BY number ASC
|
|
";
|
|
}
|
|
}else{
|
|
# wenn knk ein Character hat "vorwort"
|
|
|
|
if($row_link_bibel['bibellink'] == 'lokal'){
|
|
$query = "SELECT knk number, ueberschrift question, text_lokal answer
|
|
FROM knk
|
|
WHERE knk = '$kapitel'
|
|
OR knk LIKE '$kapitel.%'
|
|
ORDER BY knkid ASC
|
|
";
|
|
}else{
|
|
$query = "SELECT knk number, ueberschrift question, text_bibleserver answer
|
|
FROM knk
|
|
WHERE knk = '$kapitel'
|
|
OR knk LIKE '$kapitel.%'
|
|
ORDER BY knkid ASC
|
|
";
|
|
}
|
|
};
|
|
|
|
|
|
$result = $db->query( $query)
|
|
or die ("Cannot execute query1");
|
|
while ($row = $result->fetch_array()){
|
|
$value[] = $row;
|
|
}
|
|
// Assign this array to smarty...
|
|
$smarty->assign('table_data1', $value);
|
|
$smarty->display("$template/$templatename");
|
|
?>
|