95 lines
4.8 KiB
PHP
95 lines
4.8 KiB
PHP
<?php
|
|
#error_reporting(E_ALL);
|
|
require_once("config.inc.php");
|
|
require_once("func_ansicht.php");
|
|
require_once("bibellookup_2017.php");
|
|
#require_once("func_htmlclean.php");
|
|
echo "
|
|
<script type='text/javascript' src='overlib/overlib.js'></script>
|
|
";
|
|
$bibellink = $_GET["bibellink"];
|
|
$spalte = $_GET["spalte"];
|
|
|
|
#$bibellink = 'bibleserver';
|
|
#$bibellink = 'lokal';
|
|
$lid="";
|
|
$db = dbconnect();
|
|
|
|
$db->query("SET NAMES 'utf8'");
|
|
|
|
# Die Prozedur gilt für die Erstellung der Spalten description_lokal, description2_lokal, answer_lokal.
|
|
# Außerdem für die Erstellung der Spalte reference_lokal bei Frage 745. Dort kommt als einziges ein Bibellink vor
|
|
|
|
if($spalte == "reference_lokal" or $spalte == "reference_bibleserver"){
|
|
$query = "SELECT description, description2, answer, knkfa_id, reference
|
|
FROM knk_fa
|
|
WHERE number=745
|
|
ORDER BY knkfa_id ASC";
|
|
}else{
|
|
$query = "SELECT description, description2, answer, knkfa_id, reference
|
|
FROM knk_fa
|
|
ORDER BY knkfa_id ASC";
|
|
}
|
|
$result = $db->query($query);
|
|
|
|
|
|
while ($row = $result->fetch_array()){
|
|
|
|
$jahr="2020"; # Neue Lutherbibel 2017, wird ab 1.1.19 im GDs verwendet
|
|
if($spalte == "description_lokal" or $spalte == "description_bibleserver" ){
|
|
$text = str_replace(' "', ' \"', $row['description']);
|
|
}
|
|
if($spalte == "description2_lokal" or $spalte == "description2_bibleserver" ){
|
|
$text = str_replace(' "', ' \"', $row['description2']);
|
|
}
|
|
if($spalte == "answer_lokal" or $spalte == "answer_bibleserver" ){
|
|
$text = str_replace(' "', ' \"', $row['answer']);
|
|
}
|
|
if($spalte == "reference_lokal" or $spalte == "reference_bibleserver" ){
|
|
$text = str_replace(' "', ' \"', $row['reference']); # WHERE number=745
|
|
}
|
|
$text=preg_replace_callback("/([0-9]\s*)?()?(Sir|Mo|Jos|Ri|Rut|Sam|Kön|Chr|Esr|Neh|Est|Hiob|Ps|Spr|Pred|Hld|Jes|Jer|Kla|Klgl|Hes|St zu Dan|Dan|Hos|Joel|Am|Obd|Jona|Mi|Nah|Hab|Zef|Hag|Sach|Weish|Mal|Tob|Mt|Mk|Lk|Luk|Joh|Jh|Apg|Röm|Rom|Kor|Gal|Eph|Phil|Kol|Thess|Tim|Tit|Phlm|Ptr|Petr|Joh|Hbr|Hebr|Jak|Jk|Jud|Offb|Off)(\s*)".
|
|
"([0-9]{1,3})(\,\s*)?(aus\s*)?([0-9]{0,3})/", function($m) use (&$lid) { return refill($m[1], $m[2], $m[3], $m[4], $m[5], $m[6], $m[7], $m[8], $m[9], $lid);}, $text);
|
|
|
|
$text=preg_replace_callback("/([0-9][0-9]?\.\s*)?(Makkabäer|Johannes|Mose|Könige|Chronik|Korinther|Samuel|Thessalonicher|Timotheus|Petrus|Gebet Manasses|Stücke zu Daniel|Stücke zu Ester|Baruch|Weisheit|Judit|Judith|Sirach|Josua|Richter|Rut|Ruth|Esra|Nehemia|Esther|Ester|Hiob|Ijob|Psalm|Sprüche|Prediger|Hoheslied|Jesaja|Jeremia|Klagelieder|Hesekiel|Ezechiel|Daniel|Hosea|Joel|Amos|Tobias|Obadja|Jona|Micha|Nahum|Habakuk|Zefanja|Haggai|Sacharja|Maleachi|Matthäus|Markus|Lukas|Apostelgeschichte|Römer|Galater|Epheser|Philipper|Kolosser|Titus|Hebräer|Jakobus|Offenbarung|Philemon|Judas)(\s*[0-9]{1,3})(,\s*)?(\s*aus\s*|\s*Verse\s*|\s*Vers\s*)?([0-9]{0,3})?(\s*\-\s*|\s*\.\s*)?([0-9]{0,3})?/", function($m) use (&$lid,&$bibellink,&$jahr) { return makeLink($m[1], $m[2], $m[3], $m[4], $m[5], $m[6], $m[7], $m[8], $lid, $bibellink,$jahr);}, $text);
|
|
$suchmuster = '/(\(|\s)(siehe|siehe auch)?(\s)?(([0-9\.]{1,2}){1,5})(\)|;)/';
|
|
$text=preg_replace_callback($suchmuster, function($m) { return makeKNK2($m[1],$m[2],$m[3],$m[4],$m[5],$m[6]);}, $text);
|
|
$text = $db->real_escape_string($text);
|
|
|
|
if($bibellink == 'lokal'){
|
|
if($spalte == "description_lokal"){
|
|
$sql1 = $db->query("UPDATE knk_fa SET description_lokal='$text' WHERE knkfa_id='$row[knkfa_id]'");
|
|
}
|
|
if($spalte == "description2_lokal"){
|
|
$sql1 = $db->query("UPDATE knk_fa SET description2_lokal='$text' WHERE knkfa_id='$row[knkfa_id]'");
|
|
}
|
|
if($spalte == "answer_lokal"){
|
|
$sql1 = $db->query("UPDATE knk_fa SET answer_lokal='$text' WHERE knkfa_id='$row[knkfa_id]'");
|
|
}
|
|
if($spalte == "reference_lokal"){
|
|
$sql1 = $db->query("UPDATE knk_fa SET reference_lokal='$text' WHERE knkfa_id='$row[knkfa_id]'");
|
|
}
|
|
|
|
}
|
|
|
|
if($bibellink == 'bibleserver'){
|
|
#echo "$row[knkfa_id]<br>";
|
|
if($spalte == "description_bibleserver"){
|
|
$sql = $db->query ("UPDATE knk_fa SET description_bibleserver='$text' WHERE knkfa_id='$row[knkfa_id]'");
|
|
}
|
|
if($spalte == "description2_bibleserver"){
|
|
$sql = $db->query ("UPDATE knk_fa SET description2_bibleserver='$text' WHERE knkfa_id='$row[knkfa_id]'");
|
|
}
|
|
if($spalte == "answer_bibleserver"){
|
|
$sql = $db->query ("UPDATE knk_fa SET answer_bibleserver='$text' WHERE knkfa_id='$row[knkfa_id]'");
|
|
}
|
|
if($spalte == "reference_bibleserver"){
|
|
$sql = $db->query ("UPDATE knk_fa SET reference_bibleserver='$text' WHERE knkfa_id='$row[knkfa_id]'");
|
|
}
|
|
|
|
}
|
|
|
|
}
|
|
|
|
|
|
?>
|