261 lines
8.0 KiB
PHP
261 lines
8.0 KiB
PHP
<?php
|
|
/*
|
|
# Fuer debugging
|
|
error_reporting(E_ALL);
|
|
ini_set('display_errors', 1);
|
|
#echo __LINE__."<br>";
|
|
*/
|
|
|
|
include_once 'classes/lg-on_Smarty.class.php';
|
|
$smarty = new lgon_Smarty();
|
|
require_once("config.inc.php");
|
|
require_once("func_rollenrechte.php");
|
|
$templatename = substr(basename($_SERVER['PHP_SELF']),0,-3)."html";
|
|
require_once "language/german.inc.php";
|
|
|
|
require_once("func_htmlclean.php");
|
|
|
|
// Rechteüberprüfung
|
|
$db = dbconnect();
|
|
if ($user_admin == ""){ require("index.php"); exit;} //Wenn man nicht angemeldet ist, darf man nicht auf die Seite
|
|
if(!rore($user_admin,'a_change','RE')){require("lib/rechte.php");exit;}
|
|
// Rechteüberprüfung ende
|
|
|
|
|
|
if(isset($_GET['action'])){
|
|
$action = $_GET['action'];
|
|
}else{
|
|
$action = '';
|
|
}
|
|
|
|
if($action == ''){
|
|
|
|
$query_kat = "SELECT ckid, bezeichnung
|
|
FROM changelog_kat
|
|
ORDER BY ckid ASC";
|
|
$result_kat = $db->query( $query_kat )
|
|
or die ("Cannot execute query");
|
|
|
|
while ($row_kat = $result_kat->fetch_array()){
|
|
$value_kat[] = $row_kat;
|
|
}
|
|
$smarty->assign('table_data_kat', $value_kat);
|
|
|
|
$query = "SELECT id, date_format(datum, '%d.%m.%Y, %H:%i') datum,date_format(datum, '%d.%m.%Y') datum_kurz, ueberschrift, aenderung, art, freigabe, link
|
|
FROM changelog
|
|
ORDER BY id DESC
|
|
LIMIT 10";
|
|
$result = $db->query( $query )
|
|
or die ("Cannot execute query");
|
|
|
|
while ($row = $result->fetch_array()){
|
|
|
|
$titel = htmlspecialchars($row['ueberschrift']); // Damit " angeigt werden können
|
|
$text = strip_tags($row['aenderung'], '<br>,<strong>');
|
|
$text = str_replace("\n","",$row['aenderung']);
|
|
$text = $db->real_escape_string(str_replace(chr(13),"",$row['aenderung']));
|
|
switch($row['art'])
|
|
{
|
|
case 1:
|
|
$art = "Datenbestand";
|
|
break;
|
|
case 2:
|
|
$art = "System";
|
|
break;
|
|
default:
|
|
$art = "undefiniert";
|
|
break;
|
|
}
|
|
|
|
switch($row['freigabe'])
|
|
{
|
|
case 1:
|
|
$freigabe = "Administratoren";
|
|
break;
|
|
case 2:
|
|
$freigabe = "Standardanwender";
|
|
break;
|
|
default:
|
|
$freigabe = "undefiniert";
|
|
break;
|
|
}
|
|
|
|
$row['titel'] = $titel;
|
|
$row['text'] = $text;
|
|
$row['art'] = $art;
|
|
$row['freigabe'] = $freigabe;
|
|
$value[] = $row;
|
|
}
|
|
$smarty->assign('table_data', $value);
|
|
|
|
}
|
|
|
|
|
|
if($action == 'change_erfassen'){
|
|
|
|
$link = $_POST['link'];
|
|
$aenderung = htmlclean($_POST['aenderung'],$db);
|
|
setcookie("ck_ueberschrift",$_POST['ueberschrift']);
|
|
setcookie("ck_ueberschrift_kat",$_POST['ueberschrift_kat']);
|
|
setcookie("ck_aenderung",$aenderung);
|
|
setcookie("ck_art",$_POST['art']);
|
|
setcookie("ck_freigabe",$_POST['freigabe']);
|
|
setcookie("ck_link",$link);
|
|
|
|
// Textwort: Leitgedanken, Gottesdienstberichte
|
|
if($_POST['ueberschrift_kat'] == 2){
|
|
$smarty->assign('changelog_textwortwahl', "1");
|
|
|
|
$db = dbconnect();
|
|
$query = "SELECT DISTINCT lid, DATE_Format(datum, '%d.%m.%Y')AS datum, DATE_Format(datum, '%Y%m%d')AS datum_sort, ueberschrift, DATE_Format(datum, '%d') tag, DATE_Format(datum, '%m') monat, DATE_Format(datum, '%Y') jahr, kid, ukid
|
|
FROM quelle
|
|
ORDER BY datum_sort DESC
|
|
";
|
|
$result = $db->query( $query )
|
|
or die ("Cannot execute query");
|
|
|
|
$result_gd = $db->query("SELECT wgd FROM profil WHERE user = '$user_admin'");
|
|
$row_gd = $result_gd->fetch_array();
|
|
|
|
while ($row = $result->fetch_array()){
|
|
|
|
$wochentag = date("l", mktime(0,0,0,$row['monat'],$row['tag'],$row['jahr']));
|
|
|
|
if($wochentag == 'Wednesday' AND $row_gd['wgd'] != '0' AND ($row['ukid'] != "25" AND $row['ukid'] != "26" AND $row['ukid'] != "22" )){
|
|
$datum = date("d.m.Y", mktime(0,0,0,$row['monat'],$row['tag']+$row_gd['wgd'],$row['jahr']));
|
|
}else{
|
|
$datum = date("d.m.Y", mktime(0,0,0,$row['monat'],$row['tag'],$row['jahr']));
|
|
}
|
|
|
|
$row['datum'] = $datum;
|
|
$row['wochentag'] = $wochentag;
|
|
$value1[] = $row;
|
|
}
|
|
$smarty->assign('table_data1', $value1);
|
|
}
|
|
|
|
// Lehre Erkenntnis: Lehre leicht gemacht, Bibelkunde für alle
|
|
if($_POST['ueberschrift_kat'] == 3 OR $_POST['ueberschrift_kat'] == 4 OR $_POST['ueberschrift_kat'] == 6 OR $_POST['ueberschrift_kat'] == 7 OR $_POST['ueberschrift_kat'] == 8 OR $_POST['ueberschrift_kat'] == 10 OR $_POST['ueberschrift_kat'] == 11){
|
|
$smarty->assign('changelog_luewahl', "1");
|
|
|
|
$db = dbconnect();
|
|
$query = "SELECT DISTINCT eid, thema
|
|
FROM lue_quelle
|
|
ORDER BY eid DESC
|
|
";
|
|
$result = $db->query( $query )
|
|
or die ("Cannot execute query");
|
|
|
|
while ($row = $result->fetch_array()){
|
|
$value1[] = $row;
|
|
}
|
|
$smarty->assign('table_data1', $value1);
|
|
}
|
|
|
|
// Lehre Erkenntnis: Lehre leicht gemacht, Bibelkunde für alle
|
|
if($_POST['ueberschrift_kat'] == 9){
|
|
$smarty->assign('changelog_ohnekat', "1");
|
|
}
|
|
|
|
|
|
// Gruppen: Leitgedanken, Sonderausgabe
|
|
|
|
if($_POST['ueberschrift_kat'] == 1){
|
|
$datum=date("Y-m");
|
|
$smarty->assign('changelog_datum', $datum);
|
|
$smarty->assign('changelog_sql', "1");
|
|
}elseif($_POST['ueberschrift_kat'] == 5){
|
|
$datum=date("m / Y");
|
|
$smarty->assign('changelog_datum', $datum);
|
|
$smarty->assign('changelog_sql', "2");
|
|
}
|
|
|
|
|
|
|
|
}
|
|
|
|
if($action == 'change_erfassen2'){
|
|
$ueberschrift = $_COOKIE['ck_ueberschrift'];
|
|
$ueberschrift_kat = $_COOKIE['ck_ueberschrift_kat'];
|
|
|
|
|
|
$result_bezkat = $db->query("SELECT bezeichnung FROM changelog_kat WHERE ckid = '$ueberschrift_kat'");
|
|
$row_bezkat = $result_bezkat->fetch_array();
|
|
$ueberschrift_combi = $row_bezkat['bezeichnung'].": ".$ueberschrift;
|
|
|
|
$aenderung = $_COOKIE['ck_aenderung'];
|
|
$art = $_COOKIE['ck_art'];
|
|
$freigabe = $_COOKIE['ck_freigabe'];
|
|
|
|
if($ueberschrift_kat == 2){
|
|
$link="ausgabe.php?lid=$_POST[wort]";
|
|
}
|
|
if($ueberschrift_kat == 3 or $ueberschrift_kat == 4 or $ueberschrift_kat == 6 or $ueberschrift_kat == 7 or $ueberschrift_kat == 8 or $ueberschrift_kat == 10 or $ueberschrift_kat == 11){
|
|
$link="lue_ansicht.php?eid=$_POST[lue]";
|
|
}
|
|
|
|
if($ueberschrift_kat == 9){
|
|
$link="";
|
|
$sql_ch="";
|
|
}
|
|
|
|
if($ueberschrift_kat == 1 or $ueberschrift_kat == 5){
|
|
# SQL ohne doppelte Leerzeichen abspeichern
|
|
$sql_ch = trim(preg_replace('/ {2,}/', ' ', $_POST['sql']));
|
|
}
|
|
|
|
|
|
|
|
$datum=date("Y-m-d H:i:s");
|
|
|
|
## Prüfen, ob es das Thema schon gibt
|
|
|
|
$sql1 = $db->query("INSERT INTO changelog ( ueberschrift
|
|
, aenderung
|
|
, art
|
|
, freigabe
|
|
, datum
|
|
, link
|
|
, sql_change
|
|
)
|
|
VALUES
|
|
( '$ueberschrift_combi'
|
|
, '$aenderung'
|
|
, '$art'
|
|
, '$freigabe'
|
|
, '$datum'
|
|
, '$link'
|
|
, '$sql_ch'
|
|
)"
|
|
);
|
|
|
|
if($ueberschrift_kat == 1 or $ueberschrift_kat == 5){
|
|
$id = $db->insert_id;
|
|
$sql1 = $db->query("UPDATE changelog
|
|
SET link = 'suche_change.php?id=$id'
|
|
WHERE id = '$id'"
|
|
);
|
|
}
|
|
|
|
if (!$sql1){
|
|
$smarty->assign('changelog_sql_err1', "1");
|
|
$fehler = TRUE;
|
|
}
|
|
|
|
|
|
if(!isset($fehler)){
|
|
$smarty->assign('changelog_success', "1");
|
|
}
|
|
|
|
}
|
|
|
|
if($action == 'del'){
|
|
$id = $_GET["id"];
|
|
$sql = $db->query("DELETE FROM changelog WHERE id=$id");
|
|
echo "<meta http-equiv=\"refresh\" content=\"0; URL=changelog.php\">";
|
|
}
|
|
|
|
|
|
$smarty->assign('action', "$action");
|
|
$smarty->display("$template/$templatename");
|
|
?>
|