function related_pages($quantum = 0)
{
global $db, $environment, $pathvars, $cfg, $debugging;
// seiten mit gleichen schlagwoertern finden
if ($environment["ebene"] == "") {
$tname = $environment["kategorie"];
} else {
$tname = eCRC($environment["ebene"]) . "." . $environment["kategorie"];
}
$sql = "SELECT *\n FROM " . $cfg["keyworded"]["db"]["keyword"]["entries"] . "\n WHERE " . $cfg["keyworded"]["db"]["keyword"]["keyword"] . "\n IN (SELECT " . $cfg["keyworded"]["db"]["keyword"]["keyword"] . "\n FROM " . $cfg["keyworded"]["db"]["keyword"]["entries"] . "\n WHERE " . $cfg["keyworded"]["db"]["keyword"]["tname"] . "='" . $tname . "'\n )\n AND " . $cfg["keyworded"]["db"]["keyword"]["tname"] . " != '" . $tname . "'\n ORDER BY " . $cfg["keyworded"]["db"]["keyword"]["keyword"];
$result = $db->query($sql);
$pages = array();
while ($data = $db->fetch_array($result, 1)) {
$url = $data[$cfg["keyworded"]["db"]["keyword"]["ebene"]] . "/" . $data[$cfg["keyworded"]["db"]["keyword"]["kategorie"]];
$tname = $data[$cfg["keyworded"]["db"]["keyword"]["tname"]];
$keywords = $pages[$tname]["keywords"];
if ($keywords != "") {
$keywords .= ", ";
}
$keywords .= $data[$cfg["keyworded"]["db"]["keyword"]["keyword"]];
$index = $pages[$tname]["index"] + 1;
$mid = make_id($url);
$sql = "SELECT *\n FROM site_menu_lang\n WHERE mid=" . $mid["mid"] . "\n AND lang='" . $environment["language"] . "'";
$res_menu = $db->query($sql);
$dat_menu = $db->fetch_array($res_menu, 1);
$title = $dat_menu["label"];
// zus. titel aus content holen
if ($specialvars["content_release"] == -1 && $version == "") {
$content_release = "AND status>0";
} else {
$content_release = "";
}
$sql = "SELECT *\n FROM site_text\n WHERE tname='" . $tname . "'\n AND lang='" . $environment["language"] . "'\n AND label='inhalt'\n " . $content_release . "\n ORDER BY version DESC\n LIMIT 0,1";
$res_content = $db->query($sql);
$dat_content = $db->fetch_array($res_content, 1);
preg_match("/\\[H1\\](.*)\\[\\/H1\\]/U", $dat_content["content"], $match);
if ($match[1] != "") {
$title_content = $match[1];
} else {
$title_content = $title;
}
if ($title == "") {
continue;
}
$pages[$tname] = array("index" => $index, "url" => $pathvars["virtual"] . $url . ".html", "mid" => $mid["mid"], "title" => $title, "title_content" => $title_content, "keywords" => $keywords);
}
usort($pages, "sort_pages");
if ($quantum > 0) {
$pages = array_slice($pages, 0, $quantum);
}
return $pages;
}
function show_blog($url, $tags, $right = "", $limit = "", $kategorie = "", $future = "")
{
global $db, $pathvars, $ausgaben, $mapping, $hidedata, $environment, $cfg, $specialvars;
// parameter-erklaerung
// 1: vorgesehen fuer inhalt_selector
// 2: aufruf eines einzigen contents
// 3: anzeige als faq
// unzugaengliche #(marken) sichtbar machen
if (isset($HTTP_GET_VARS["edit"])) {
$ausgaben["inaccessible"] = "inaccessible values:<br />";
$ausgaben["inaccessible"] .= "# (error1) #(error1)<br />";
} else {
$ausgaben["inaccessible"] = "";
}
// label bearbeitung aktivieren
if (isset($_GET["edit"])) {
$specialvars["editlock"] = 0;
} else {
$specialvars["editlock"] = -1;
}
// aus der url eine id machen
$id = make_id($url);
$new = $id["mid"];
$where = "";
// manipulation verhindern
if ($environment["parameter"][2] != "" && !preg_match("/^[0-9]*\$/", $environment["parameter"][2])) {
header('Location: /index.html');
exit;
}
$sort_len = strlen($cfg["bloged"]["blogs"][$url]["sort"][0]) + 2;
// hier erfolgt der rechte-check
$check_url = $url;
if ($kategorie != "") {
$check_url = $kategorie;
}
$status = "status=1";
$order = "";
$wizard_right = "";
// falls der der content bei dem der blog eingebunden ist, zur Freigabe angefordert ist, darf hier nichts mehr passieren
if ($kategorie == tname2path($environment["parameter"][2]) && !priv_check($check_url, "publish")) {
$sql = "SELECT status from site_text WHERE tname='" . $environment["parameter"][2] . "' AND label='" . $environment["parameter"][3] . "' ORDER by version DESC";
$result = $db->query($sql);
$data = $db->fetch_array($result, 1);
if ($data["status"] == -2) {
$wizard_right = "NO";
}
}
if ($right == "" || priv_check($check_url, $right) && $wizard_right == "") {
$hidedata["new"]["link"] = $url;
$hidedata["new"]["kategorie"] = $kategorie;
if ($environment["ebene"] == "/wizard") {
$status = "(status=1 OR status = -1)";
$order = " DESC ,changed";
}
}
// erster test einer suchanfrage per kalender
//
if ($environment["parameter"][4] && $environment["kategorie"] != "delete") {
$parameter = ",,," . $environment["parameter"][4] . "," . $environment["parameter"][5] . "," . $environment["parameter"][6];
if ($cfg["bloged"]["blogs"][$url]["sort"][1] != -1) {
$heute = getdate(mktime(0, 0, 0, $environment["parameter"][5] + 1, 0, $environment["parameter"][4]));
if ($environment["parameter"][5] == "") {
$month2 = "1";
$month1 = "12";
} else {
$month1 = $environment["parameter"][5];
$month2 = $environment["parameter"][5];
}
if (!$environment["parameter"][6]) {
$day1 = $heute["mday"];
$day2 = "1";
} else {
$day1 = $environment["parameter"][6];
$day2 = $environment["parameter"][6];
}
// parameter - check
$preg_error = "";
if (!preg_match("/^[0-9]{4}\$/", $environment["parameter"][4])) {
$preg_error = -1;
}
if ($environment["parameter"][5] != "" && !preg_match("/^[0-9]{1,2}\$/", $environment["parameter"][5])) {
$preg_error = -1;
}
if ($environment["parameter"][6] != "" && !preg_match("/^[0-9]{1,2}\$/", $environment["parameter"][6])) {
$preg_error = -1;
}
if ($preg_error == -1) {
header('Location: /index.html');
exit;
}
$environment["parameter"][4] = min($environment["parameter"][4], '2035');
$environment["parameter"][4] = max($environment["parameter"][4], '1970');
if ($cfg["bloged"]["blogs"][$url]["ext_sort"] == "") {
$where .= " AND Cast(SUBSTRING(content,POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)+" . $sort_len . ",POSITION('[/" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-" . $sort_len . ") as DATETIME) < '" . $environment["parameter"][4] . "-" . $month1 . "-" . $day1 . " 23:59:59' AND Cast(SUBSTRING(content,POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)+" . $sort_len . ",POSITION('[/" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-" . $sort_len . ") as DATETIME) > '" . $environment["parameter"][4] . "-" . $month2 . "-" . $day2 . " 00:00:00'";
} else {
$where .= " AND (( Cast(SUBSTRING(content,POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)+" . $sort_len . ",POSITION('[/" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-" . $sort_len . ") as DATETIME) < '" . $environment["parameter"][4] . "-" . $month1 . "-" . $day1 . " 23:59:59' AND Cast(SUBSTRING(content,POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)+" . $sort_len . ",POSITION('[/" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-" . $sort_len . ") as DATETIME) >= '" . $environment["parameter"][4] . "-" . $month2 . "-" . $day2 . " 00:00:00')";
$sort_len2 = strlen($cfg["bloged"]["blogs"][$url]["ext_sort"]) + 2;
$where .= " OR ( Cast(SUBSTRING(content,POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)+" . $sort_len . ",POSITION('[/" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-" . $sort_len . ") as DATETIME) <= '" . $environment["parameter"][4] . "-" . $month1 . "-" . $day2 . " 00:00:00' AND Cast(SUBSTRING(content,POSITION('[" . $cfg["bloged"]["blogs"][$url]["ext_sort"] . "]' IN content)+" . $sort_len2 . ",POSITION('[/" . $cfg["bloged"]["blogs"][$url]["ext_sort"] . "]' IN content)-POSITION('[" . $cfg["bloged"]["blogs"][$url]["ext_sort"] . "]' IN content)-" . $sort_len2 . ") as DATETIME) >= '" . $environment["parameter"][4] . "-" . $month2 . "-" . $day2 . " 00:00:00'))";
}
}
}
//
// erster test einer suchanfrage per kalender
// falls kategorie , werden nur diese angezeigt
if ($kategorie != "") {
$cat_len = strlen($cfg["bloged"]["blogs"][$url]["category"]) + 2;
$where .= " AND SUBSTRING(content,POSITION('[" . $cfg["bloged"]["blogs"][$url]["category"] . "]' IN content),POSITION('[/" . $cfg["bloged"]["blogs"][$url]["category"] . "]' IN content)-POSITION('[" . $cfg["bloged"]["blogs"][$url]["category"] . "]' IN content)) ='[" . $cfg["bloged"]["blogs"][$url]["category"] . "]" . $kategorie . "'";
}
if ($future == -1) {
$where .= " AND Cast(SUBSTRING(content,POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)+" . $sort_len . ",POSITION('[/" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-" . $sort_len . ") as DATETIME) < '" . date('Y-m-d') . " 23:59:59'";
}
$tname = eCRC($url) . ".%";
// falls parameter 2 gesetzt, wird nur dieser content geholt
if ($environment["parameter"][2] != "" && $environment["ebene"] != "/wizard") {
$tname = eCRC($url) . "." . $environment["parameter"][2];
}
// falls sort auf -1 wird anstatt ein datum ein integer als sortiermerkmal gesetzt um ein manuelles sortieren zu ermoeglichen
if ($cfg["bloged"]["blogs"][$url]["sort"][1] == "-1") {
$art = "SIGNED";
} else {
$art = "DATETIME";
}
// hier der endgueltige sql !!
$sql = "SELECT Cast(SUBSTRING(content,POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)+" . $sort_len . ",POSITION('[/" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-POSITION('[" . $cfg["bloged"]["blogs"][$url]["sort"][0] . "]' IN content)-" . $sort_len . ") AS " . $art . ") AS date,status,content,tname from site_text WHERE " . $status . " AND tname like '" . $tname . "'" . $where . " order by date" . $order . " DESC";
// damit kann man beliebig viele blogs manuell holen
$ausgaben["inhalt_selector"] = "";
if (strpos($limit, ",")) {
$sql = $sql . " LIMIT " . $limit;
} else {
if ($limit != "") {
$hidedata["inhalt_selector"]["on"] = "on";
$p = $environment["parameter"][1] + 0;
// seiten umschalter
$inhalt_selector = inhalt_selector($sql, $p, $limit, $parameter, 1, 10, $getvalues);
$ausgaben["inhalt_selector"] = $inhalt_selector[0] . "<br />";
$sql = $inhalt_selector[1];
$ausgaben["anzahl"] = $inhalt_selector[2];
$ausgaben["sel_hit"] = $inhalt_selector[3];
}
}
$counter = 0;
$result = $db->query($sql);
$preg1 = "\\.([0-9]*)\$";
// evtl wizard einbinden
if ($cfg["bloged"]["blogs"][$url]["wizard"] != "") {
$editlink = "/wizard/show,";
} else {
$editlink = "/admin/contented/edit,";
}
while ($data = $db->fetch_array($result, 1)) {
$tag_parameter = "";
$counter++;
// im wizard wird der content aus der SESSION-Variablen genommen
if ($_SESSION["wizard_content"][DATABASE . "," . $data["tname"] . ",inhalt"] && $environment["ebene"] == "/wizard") {
$test = preg_replace("|\r\n|", "\\r\\n", $_SESSION["wizard_content"][DATABASE . "," . $data["tname"] . ",inhalt"]);
} else {
$test = preg_replace("|\r\n|", "\\r\\n", $data["content"]);
}
foreach ($tags as $key => $value) {
// finden der parameter sowie begin und endtag
$invisible = "";
if (is_array($value)) {
$tag_parameter = $value["parameter"];
$invisible = $value["invisible"];
$show = $value["show"];
$value = $value["tag"];
}
if (strpos($value, "=")) {
$endtag = substr($value, 0, strpos($value, "="));
if ($value == "IMG=") {
$value .= ".*";
} else {
$value = $value . $tag_parameter;
}
} else {
$endtag = $value;
}
// preg nach den tags in der config
$preg = "(\\[" . addcslashes($value, "/") . "\\])(.*)\\[\\/" . $endtag . "\\]";
if (preg_match("/{$preg}/Us", $test, $regs)) {
$rep_tag = str_replace('\\r\\n', "<br />", $regs[0]);
$org_tag = str_replace('\\r\\n', "<br />", $regs[2]);
} else {
$rep_tag = "";
$org_tag = "";
}
// gefundene werte in array schreiben
if ($invisible != -1) {
$array[$counter][$key . "_wizard_edit_link"] = $pathvars["virtual"] . "/wizard/editor," . DATABASE . "," . $data["tname"] . ",inhalt," . $value . ":0,,,.html";
$array[$counter][$key . "_org"] = str_replace("\"", "'", $org_tag);
$array[$counter][$key . "_org_tag"] = $value;
$array[$counter][$key] = tagreplace($rep_tag);
if ($org_tag == "") {
$array[$counter][$key] = "";
}
if (preg_match("/^\\[IMG/", $rep_tag, $regs_img)) {
$image_para = explode("/", $rep_tag);
$array[$counter][$key . "_img_art"] = $image_para[2];
$array[$counter][$key . "_img_id"] = $image_para[3];
$array[$counter][$key . "_img_size"] = $image_para[4];
$sql_img = "SELECT * FROM site_file WHERE fid='" . $image_para[3] . "'";
$result_img = $db->query($sql_img);
$data_img = $db->fetch_array($result_img, 1);
$array[$counter][$key . "_img_desc"] = $data_img["fdesc"];
$array[$counter][$key . "_img_under"] = $data_img["funder"];
$array[$counter][$key . "_img_fname"] = $data_img["ffname"];
if ($show != "") {
$rep_tag = str_replace("/" . $image_para[4] . "/", "/" . $show . "/", $rep_tag);
}
}
} else {
if (preg_match("/^\\[IMG/", $rep_tag, $reg_img)) {
$image_para = explode("/", $rep_tag);
$invisible_array[$counter][$key . "_img_art"] = $image_para[2];
$invisible_array[$counter][$key . "_img_id"] = $image_para[3];
$invisible_array[$counter][$key . "_img_size"] = $image_para[4];
if ($show != "") {
$rep_tag = str_replace("/" . $image_para[4] . "/", "/" . $show . "/", $rep_tag);
}
}
$invisible_array[$counter][$key . "_org"] = str_replace("\"", "'", $org_tag);
$invisible_array[$counter][$key] = tagreplace($rep_tag);
$array[$counter][$key . "_org"] = "";
$array[$counter][$key] = "";
}
}
preg_match("/{$preg1}/", $data["tname"], $regs);
if ($environment["parameter"][2] != "" && $environment["ebene"] != "/wizard") {
$array[$counter]["all"] = tagreplace($data["content"]);
$array[$counter]["id"] = $regs[1];
} else {
$array[$counter]["datum"] = substr($data["date"], 8, 2) . "." . substr($data["date"], 5, 2) . "." . substr($data["date"], 0, 4);
$array[$counter]["detaillink"] = $pathvars["virtual"] . $url . "/" . $regs[1] . ".html";
if ($environment["ebene"] == "") {
$faq_url = "/" . $environment["kategorie"];
} else {
$faq_url = $environment["ebene"] . "/" . $environment["kategorie"];
}
$array[$counter]["faqlink"] = $pathvars["virtual"] . $faq_url . ",,," . $regs[1] . ".html#faq_" . $regs[1];
$array[$counter]["faqanker"] = "faq_" . $regs[1];
$array[$counter]["allink"] = $pathvars["virtual"] . $faq_url . ",," . $regs[1] . ".html";
$array[$counter]["id"] = $regs[1];
$array[$counter]["status"] = $data["status"];
// Sortierung ausgeben
// ausgabe der aktions-buttons
if ($right == "" || priv_check($check_url, $right) && $wizard_right == "") {
if ($cfg["bloged"]["blogs"][$url]["sort"][1] == "-1") {
$sort_kat = "";
if ($kategorie != "") {
$id = make_id($kategorie);
$sort_kat = $id["mid"];
}
$array[$counter]["sort_up"] = $pathvars["virtual"] . "/admin/bloged/sort,up," . $regs[1] . "," . $sort_kat . "," . $new . ".html";
$array[$counter]["sort_down"] = $pathvars["virtual"] . "/admin/bloged/sort,down," . $regs[1] . "," . $sort_kat . "," . $new . ".html";
} else {
$array[$counter]["sort_up"] = "";
$array[$counter]["sort_down"] = "";
}
$array[$counter]["wizard_delete_link"] = $pathvars["virtual"] . "/wizard/delete," . DATABASE . "," . $data["tname"] . ",inhalt.html\"";
$array[$counter]["deletelink"] = "<a href=\"" . $pathvars["virtual"] . "/admin/bloged/delete,," . $regs[1] . "," . $sort_kat . "," . $new . ".html\">g(blog_delete)</a>";
$array[$counter]["editlink"] = "<a href=\"" . $pathvars["virtual"] . $editlink . DATABASE . "," . $data["tname"] . ",inhalt.html\">g(blog_edit)</a>";
$array[$counter]["tname"] = eCrc($url);
} else {
$array[$counter]["editlink"] = "";
$array[$counter]["deletelink"] = "";
$array[$counter]["sort"] = "";
}
}
if ($environment["parameter"][3] == $regs[1]) {
if (is_array($invisible_array)) {
foreach ($invisible_array[$counter] as $key => $value) {
$array[$counter][$key] = $value;
}
}
}
}
// was anzeigen
if ($environment["ebene"] == "") {
$templ = $environment["kategorie"];
} else {
$templ = eCRC($environment["ebene"]) . "." . $environment["kategorie"];
}
if (file_exists($pathvars["templates"] . $templ . ".tem.html")) {
$mapping["main"] = $templ;
} elseif ($cfg["bloged"]["blogs"][$url]["own_list_template"] != "") {
$mapping["main"] = "-2051315182." . $cfg["bloged"]["blogs"][$url]["own_list_template"];
} elseif ($cfg["bloged"]["blogs"][$url]["sort"][1] != "") {
$mapping["main"] = "-2051315182.faq";
} else {
$mapping["main"] = "-2051315182.list";
}
return $array;
}
$ausgaben["form_error"] = "#(error_right)";
}
// schlagwoerter fuer die seite holen
$sql = "SELECT *\n FROM " . $cfg["keyworded"]["db"]["keyword"]["entries"] . "\n WHERE " . $cfg["keyworded"]["db"]["keyword"]["tname"] . "='" . $environment["parameter"][1] . "'";
if ($debugging["sql_enable"]) {
$debugging["ausgabe"] .= "sql: " . $sql . $debugging["char"];
}
$result = $db->query($sql);
$keywords = array();
while ($data = $db->fetch_array($result, 1)) {
$keywords[] = $data[$cfg["keyworded"]["db"]["keyword"]["keyword"]];
}
$ausgaben["keywords"] = implode(", ", $keywords);
}
// in der site_menu nach titel suchen
$menu_item = make_id(str_replace(".html", "", $ausgaben["path"]));
if ($menu_item["mid"] != 0) {
$sql = "SELECT *\n FROM site_menu_lang\n WHERE mid=" . $menu_item["mid"] . "\n AND lang='" . $environment["language"] . "'";
$result = $db->query($sql);
$data = $db->fetch_array($result, 1);
$ausgaben["title"] = $data["label"];
} else {
$ausgaben["title"] = "";
}
// alle schlagwoerter holen
$dataloop["tags_all"] = cloud_loop("all", "", $keywords);
if (count($dataloop["tags_all"]) > 0) {
$hidedata["tags_all"] = array();
}
### put your code here ###
// +++
$display_stamp = local_timestamp($row['timestamp']);
$time = date($timefmt, $display_stamp);
$date = date($datefmt, $display_stamp);
} else {
// New employees do not have timestamp to display yet.
$time = $date = '';
}
$u_empfullname = urlencode($row['empfullname']);
$h_name = htmlentities($show_display_name == 'yes' ? $row['displayname'] : $row['empfullname']);
$h_color = htmlentities($row['color']);
$h_inout = htmlentities($row['inout']);
$h_office = htmlentities($row['office']);
$h_groups = htmlentities($row['groups']);
$h_notes = htmlentities($row['notes']);
// Make DOM id out of employee fullname column (which is assumed to be their employee id).
$id = htmlentities(make_id($row['empfullname']));
print <<<End_Of_HTML
<tr class="display_row {$row_class}" id="{$id}">
<td align="left"><a href="entry.php?emp={$u_empfullname}">{$h_name}</a></td>
<td align="left" style="color:{$h_color}">{$h_inout}</td>
<td align="right">{$time}</td>
<td align="right">{$date}</td>
End_Of_HTML;
if ($display_office_name == "yes") {
print <<<End_Of_HTML
<td align="left">{$h_office}</td>
End_Of_HTML;
}
if ($display_group_name == "yes") {
$insert_query = <<<End_Of_SQL
insert into {$db_prefix}info (fullname, `inout`, timestamp, notes, ipaddress)
values ('{$q_empfullname}', '{$q_inout}', '{$tz_stamp}', '{$q_notes}', {$ip})
End_Of_SQL;
$update_query = <<<End_Of_SQL
update {$db_prefix}employees
set tstamp = '{$tz_stamp}'
where empfullname = '{$q_empfullname}'
End_Of_SQL;
if (mysql_query($insert_query)) {
mysql_query($update_query) or trigger_error('punchclock: cannot update tstamp in employee record. ' . mysql_error(), E_USER_WARNING);
} else {
trigger_error('punchclock: cannot insert timestamp into info record. ' . mysql_error(), E_USER_WARNING);
}
// Update display line on punchclock list and close form.
$id = make_id($empfullname);
$display_stamp = local_timestamp($tz_stamp);
$time = date($timefmt, $display_stamp);
$date = date($datefmt, $display_stamp);
# Note nyroModal 1.6.2: must have LF (IE needs characters) outside of <script> otherwise nyroModal window does not close.
print <<<End_Of_HTML
<p>stupid text to get this to work in IE</p>
<script type="text/javascript">
//<![CDATA[
// Post results to main page employee list
\$('#{$id} td').each(function(index){
\tif (index == 1) {
\t\tthis.innerHTML = "{$h_inout}";
\t\tthis.style.color = "{$inout_color}";
\t}
\tif (index == 2) this.innerHTML = "{$time}";
if ($environment["parameter"][1]) {
$ebe = make_ebene($environment["parameter"][1]);
$tn = eCrc(substr($ebe, 0, strrpos($ebe, "/"))) . "." . substr($ebe, strrpos($ebe, "/") + 1);
$sql = "Select * from site_text where tname = '" . $tn . "' and status = 1 and label = 'inhalt'";
$result = $db->query($sql);
$data = $db->fetch_array($result, 1);
preg_match_all("/\\[LIST=DEF\\](.*)\\[\\/LIST\\]/Us", $data["content"], $match);
foreach ($match[0] as $key => $value) {
$buffer .= tagreplace($value);
}
$buffer = str_replace("<dl>", "", $buffer);
$ausgaben["faq"] = str_replace("</dl>", "", $buffer);
}
// LISTE
$sql = "Select * from site_text where content like '%[LIST=DEF]%' and status = 1";
$result = $db->query($sql);
while ($data = $db->fetch_array($result, 1)) {
$id = make_id(tname2path($data["tname"]));
$name = "";
foreach (url2Loop(tname2path($data["tname"])) as $value) {
$name .= "|" . $value["label"];
}
$dataloop["faq_sites"][$id["mid"]]["id"] = $id["mid"];
$dataloop["faq_sites"][$id["mid"]]["name"] = $name;
}
// was anzeigen
$mapping["main"] = "faq-library";
if ($debugging["html_enable"]) {
$debugging["ausgabe"] .= "[ ++ " . $script["name"] . " ++ ]" . $debugging["char"];
}
////////////////////////////////////////////////////////////////////////////////////////////////////////////////
$regs[1] = "unknown";
}
$dataloop["blogs"][$counter]["name"] = $regs[1];
preg_match("/{$preg1}/", $data_in["tname"], $regs);
$dataloop["blogs"][$counter]["link"] = $pathvars["virtual"] . make_ebene($environment["parameter"][1]) . "/" . $regs[1] . ",v" . $data["version"] . ".html";
$dataloop["blogs"][$counter]["anzahl1"] = "<a href=\"list," . $environment["parameter"][1] . ",recover," . $regs[1] . ".html\">wiederherstellen</a>";
$dataloop["blogs"][$counter]["anzahl2"] = "<a href=\"list," . $environment["parameter"][1] . ",delete," . $regs[1] . ".html\">loeschen</a>";
}
}
} else {
// uebersicht ueber alle blogs
$hidedata["admin"]["beschriftung1"] = "Pfad";
$hidedata["admin"]["beschriftung2"] = "sichtbare Einträge";
$hidedata["admin"]["beschriftung3"] = "alle Einträge";
foreach ($cfg["bloged"]["blogs"] as $key => $value) {
$id = make_id($key);
$counter++;
$dataloop["blogs"][$counter]["link"] = "list," . $id["mid"] . ".html";
$dataloop["blogs"][$counter]["name"] = $key;
$sql = "SELECT content,tname from site_text WHERE content REGEXP '^\\\\[!\\\\]'AND status = '1' AND tname like '" . eCRC($key) . ".%'";
$result = $db->query($sql);
$dataloop["blogs"][$counter]["anzahl1"] = $db->num_rows($result);
$sql = "SELECT content,tname from site_text WHERE content REGEXP '^\\\\[!\\\\]' AND tname like '" . eCRC($key) . ".%'";
$result = $db->query($sql);
$dataloop["blogs"][$counter]["anzahl2"] = $db->num_rows($result);
}
$ausgaben["anzahl"] = count($cfg["bloged"]["blogs"]);
}
// seiten umschalter
#$inhalt_selector = inhalt_selector( $sql, $environment["parameter"][1], $cfg["bloged"]["db"]["bloged"]["rows"], $parameter, 1, 4, $getvalues );
$ausgaben["inhalt_selector"] = "";
/**
* Cache data, instead of text output
* @param $var is filled with the data if cache is found. otherwise it is set to NULL
* @return bool boolean false if cache exists, otherwise the ID of the cache (to use with data_stop)
*/
function data(&$var, $id = false, $timeout = false)
{
if ($id === false) {
$id = make_id();
}
if (isset($_GET['nocache']) && $_GET['nocache'] == \ui\config('nocache_code')) {
return FALSE;
}
if ($timeout === FALSE) {
$timeout = \ui\config('cache_timeout', 3600);
}
$fname = \ui\config('cache_path') . $id . \ui\config('cache_file_suffix');
$fs = @fopen($fname, 'rb', FALSE);
if ($fs !== FALSE) {
flock($fs, LOCK_SH | LOCK_NB);
$time = fread($fs, 4);
if (!isset($time[3])) {
fclose($fs);
unlink($fname);
} else {
$time = unpack('N', $time);
$time = array_pop($time);
if (time() - $time < $timeout) {
$data = '';
while (!feof($fs)) {
$data .= fread($fs, 1024 * 1024);
}
//read in 1 MB blocks
flock($fs, LOCK_UN | LOCK_NB);
fclose($fs);
$var = unserialize($data);
return FALSE;
}
fclose($fs);
unlink($fname);
}
}
return $id;
}
You may contact the author/development team at:
Chaos Networks
c/o Werner Ammon
Lerchenstr. 11c
86343 K�nigsbrunn
URL: http://www.chaos.de
*/
////////////////////////////////////////////////////////////////////////////////////////////////////////////////
if ($environment["ebene"] == "/admin" && $environment["kategorie"] == "site_counting") {
if ($_SESSION["uid"] != "") {
if ($_GET["path"] != "") {
include_once $pathvars["moduleroot"] . "libraries/function_menu_convert.inc.php";
$menu = make_id(str_replace("www.vermessung.bayern.de", "", urldecode($_GET["path"])));
if ($menu["mid"] != 0) {
$sql = "SELECT *\n FROM site_menu_lang\n WHERE mid=" . $menu["mid"] . "\n AND lang='" . $environment["language"] . "'";
$result = $db->query($sql);
$data = $db->fetch_array($result, 1);
$title = $data["label"] . " (" . urldecode($_GET["path"]) . ")";
} else {
$title = urldecode($_GET["path"]);
}
$hidedata["detail"]["title"] = $title;
$hidedata["detail"]["back"] = $pathvars["requested"];
// monats-auswertung
$sql = "SELECT *\n FROM db_count_sites\n WHERE path='" . urldecode($_GET["path"]) . "'\n ORDER BY month DESC";
$result = $db->query($sql);
while ($data = $db->fetch_array($result, 1)) {
$dataloop["monthly"][] = array("month" => $data["month"], "hits" => $data["count"]);
$date = $match[1];
} else {
$date = $data["changed"];
}
$pubDate = date("r", mktime(substr($date, 11, 2), substr($date, 14, 2), substr($date, 17, 2), substr($date, 5, 2), substr($date, 8, 2), substr($date, 0, 4)));
// lastBuildDate
if ($pubDate > $hidedata["rss"]["lastBuildDate"]) {
$hidedata["rss"]["lastBuildDate"] = $pubDate;
}
$dataloop["items"][$date . " - " . $data["ebene"] . "/" . $data["kategorie"]] = array("title" => $title, "teaser" => $teaser, "link" => $link, "guid" => $link, "pubDate" => $pubDate);
}
if (is_array($dataloop["items"])) {
krsort($dataloop["items"]);
}
}
$menu_item = make_id($path);
// aktuellen menue-punkt holen
$mid = $menu_item["mid"];
$sql = "SELECT *\n FROM " . $cfg["rss"]["db"]["lang"]["entries"] . "\n WHERE " . $cfg["rss"]["db"]["menu"]["key"] . "=" . $mid;
$result = $db->query($sql);
$data = $db->fetch_array($result, 1);
if (preg_match("/^\\/aemter/", $environment["ebene"] . "/" . $environment["kategorie"]) || strstr($_SERVER["SERVER_NAME"], "vermessungsamt-")) {
$link = "http://" . str_replace(array(".int-dmz.bayern"), array(""), $_SERVER["SERVER_NAME"]);
} else {
$link = "http://www.geodaten.bayern.de";
}
$hidedata["rss"] = array("lang" => $environment["language"], "link" => $link, "label" => $data["label"], "pubDate" => date("r"));
rss_walk_path($menu_item["mid"]);
// anzahl der eintraege limitieren
if ($cfg["rss"]["max_items"] != "" && count($dataloop["items"]) > 0) {
$dataloop["items"] = array_slice($dataloop["items"], 0, $cfg["rss"]["max_items"]);
// naechste nicht versteckte versions-nummer finden
$sql = "SELECT max(version) as max_version\n FROM " . SITETEXT . "\n WHERE lang = '" . $environment["language"] . "'\n AND label ='" . $environment["parameter"][3] . "'\n AND tname ='" . $environment["parameter"][2] . "'\n AND status>=0";
$result = $db->query($sql);
$data = $db->fetch_array($result, 1);
$next_version = $data["max_version"] + 1;
// alle "unnoetigen" versionen loeschen
$sql = "DELETE\n FROM " . SITETEXT . "\n WHERE lang = '" . $environment["language"] . "'\n AND label ='" . $environment["parameter"][3] . "'\n AND tname ='" . $environment["parameter"][2] . "'\n AND status<0\n AND version<>" . $environment["parameter"][5];
$result = $db->query($sql);
// bisher aktuelle inhalte historisieren
$sql = "UPDATE " . SITETEXT . " SET\n status=0\n WHERE lang = '" . $environment["language"] . "'\n AND label ='" . $environment["parameter"][3] . "'\n AND tname ='" . $environment["parameter"][2] . "'\n AND status>=0";
$result = $db->query($sql);
// freigegebenen Datensatz aktualisieren
$sql = "UPDATE " . SITETEXT . "\n SET version=" . $next_version . ",\n status=1\n WHERE lang = '" . $environment["language"] . "'\n AND label ='" . $environment["parameter"][3] . "'\n AND tname ='" . $environment["parameter"][2] . "'\n AND version=" . $environment["parameter"][5];
$result = $db->query($sql);
// checken, ob menuepunkt aktivert ist
$menu_entry = make_id(tname2path($environment["parameter"][2]));
$sql = "UPDATE site_menu\n SET hide=NULL\n WHERE mid=" . $menu_entry["mid"];
$result = $db->query($sql);
} elseif ($environment["parameter"][4] == "unlock") {
// version wird wieder entsperrt
$sql = "UPDATE " . SITETEXT . "\n SET status=-1\n WHERE lang = '" . $environment["language"] . "'\n AND label ='" . $environment["parameter"][3] . "'\n AND tname ='" . $environment["parameter"][2] . "'\n AND version=" . $environment["parameter"][5];
$result = $db->query($sql);
}
if ($_SESSION["form_referer"] != "") {
$header = $_SESSION["form_referer"];
unset($_SESSION["form_referer"]);
} else {
$header = $_SERVER["HTTP_REFERER"];
}
header("Location: " . $header);
}
} else {
$hidedata["all_tags_show"] = array();
}
}
if (count($tags) > 0) {
$sql = "SELECT " . $cfg["keyworded"]["db"]["keyword"]["tname"] . ",\n " . $cfg["keyworded"]["db"]["keyword"]["ebene"] . ",\n " . $cfg["keyworded"]["db"]["keyword"]["kategorie"] . ",\n count(" . $cfg["keyworded"]["db"]["keyword"]["keyword"] . ") as anzahl\n FROM " . $cfg["keyworded"]["db"]["keyword"]["entries"] . "\n WHERE " . $cfg["keyworded"]["db"]["keyword"]["keyword"] . " IN ('" . implode("','", $tags) . "')\n AND " . $cfg["keyworded"]["db"]["keyword"]["lang"] . "='" . $environment["language"] . "'\n GROUP BY " . $cfg["keyworded"]["db"]["keyword"]["tname"] . ",\n " . $cfg["keyworded"]["db"]["keyword"]["ebene"] . ",\n " . $cfg["keyworded"]["db"]["keyword"]["kategorie"];
$result = $db->query($sql);
$pages = array();
while ($data = $db->fetch_array($result, 1)) {
if ($data["anzahl"] != count($tags)) {
continue;
}
$tname = $data[$cfg["keyworded"]["db"]["keyword"]["tname"]];
$url = $data[$cfg["keyworded"]["db"]["keyword"]["ebene"]] . "/" . $data[$cfg["keyworded"]["db"]["keyword"]["kategorie"]];
// versuch den seitentitel aus menu-tabelle zu holen
$mid = make_id($url);
$sql = "SELECT *\n FROM site_menu_lang\n WHERE mid=" . $mid["mid"] . "\n AND lang='" . $environment["language"] . "'";
$res_menu = $db->query($sql);
$dat_menu = $db->fetch_array($res_menu, 1);
// alle schlagwoerter der seite finden
$sql = "SELECT *\n FROM " . $cfg["keyworded"]["db"]["keyword"]["entries"] . "\n WHERE " . $cfg["keyworded"]["db"]["keyword"]["tname"] . "='" . $tname . "'\n AND " . $cfg["keyworded"]["db"]["keyword"]["lang"] . "='" . $environment["language"] . "'\n ORDER BY " . $cfg["keyworded"]["db"]["keyword"]["keyword"];
$res_key = $db->query($sql);
$keyword = array();
while ($dat_key = $db->fetch_array($res_key, 1)) {
$keyword[] = $dat_key[$cfg["keyworded"]["db"]["keyword"]["keyword"]];
}
$img = "pos.png";
if (priv_check($url, $cfg["keyworded"]["right"]["content"])) {
$img = "edit.png";
}
$dataloop["pages"][$tname] = array("index" => 0, "url" => $pathvars["virtual"] . $url . ".html", "mid" => $mid["mid"], "title" => $dat_menu["label"], "keywords" => implode(",", $keyword), "link_edit" => $cfg["keyworded"]["basis"] . "/edit_page," . $tname . ".html", "img" => $img);
}
}
// rausfinden, welcher menupunkt einen unterpunkt bekommen soll
if ($environment["parameter"][2] != "") {
$url = tname2path($environment["parameter"][2]);
$point = make_id($url);
$_SESSION["REFERER"] = $url;
$_SESSION["form_referer"] = $pathvars["webroot"] . $pathvars["virtual"] . "/login.html";
} else {
if ($_SESSION["REFERER"] != "" && preg_match("/wizard\$/", dirname($_SESSION["REFERER"]))) {
$url = str_replace(array($pathvars["virtual"], ".html"), "", $_SESSION["REFERER"]);
} else {
$url = str_replace(array($pathvars["webroot"] . $pathvars["virtual"], ".html"), "", $_SERVER["HTTP_REFERER"]);
$_SESSION["REFERER"] = $pathvars["virtual"] . $url;
}
$point = make_id($url);
#$mid = $point["mid"];
}
$ausgaben["form_referer"] = $_SESSION["form_referer"];
if ($cfg["wizard"]["right"]["add"] == "" || priv_check($url, $cfg["wizard"]["right"]["add"]) || priv_check(tname2path($environment["parameter"][2]), $cfg["wizard"]["right"]["add"]) || priv_check_old("", $cfg["wizard"]["right"]) || $rechte["administration"] == -1 || $erlaubnis == -1) {
// unzugaengliche #(marken) sichtbar machen
// ***
if (isset($_GET["edit"])) {
$ausgaben["inaccessible"] = "inaccessible values:<br />";
$ausgaben["inaccessible"] .= "# (error_result) #(error_result)<br />";
$ausgaben["inaccessible"] .= "# (error_dupe) #(error_dupe)<br />";
} else {
$ausgaben["inaccessible"] = "";
}
if ($environment["parameter"][2] == "" || $environment["parameter"][3] == "") {
$hidedata["add_menu"] = array();
