function generatePagesTree($parentid, $tabs = "", $lang = "", $show_deleted = false, $show_hidden = false, $type = 'text')
{
global $_SERVER, $admin_lang;
$out = '';
$q_lang = '';
$q_visible = '';
if ($lang != '') {
$q_lang = "AND page_lang='" . $lang . "' ";
}
if ($show_deleted == false) {
$q_visible = "AND page_visible!='deleted' ";
}
if ($show_hidden == false) {
$q_visible .= "AND page_visible!='hidden' ";
}
$sql = "SELECT page_parent_id, page_name, page_id, page_title, page_visible\r\n\t\t\tFROM " . DB_PREFIX . "pages_content\r\n\t\t\tWHERE page_parent_id={$parentid} " . $q_lang . $q_visible . " AND page_type='{$type}'\r\n\t\t\tORDER BY page_id ASC";
$sites_result = db_result($sql);
if (mysql_num_rows($sites_result) != 0) {
$out .= "\r\n" . $tabs . "<ol>\r\n";
while ($site_info = mysql_fetch_object($sites_result)) {
$out .= $tabs . "\t<li>";
if ($site_info->page_visible == 'deleted') {
$out .= '<strike>';
}
$out .= '<a href="' . $_SERVER['PHP_SELF'] . '?page=pageeditor&action=info&page_name=' . $site_info->page_name . '">' . $site_info->page_title . '</a> <em>[' . $site_info->page_name . ']</em> <a href="' . $_SERVER['PHP_SELF'] . '?page=pageeditor&action=info&page_name=' . $site_info->page_name . '">[' . $admin_lang['info'] . ']</a>';
if ($site_info->page_visible == 'deleted') {
$out .= '</strike>';
} else {
$out .= ' <a href="' . $_SERVER['PHP_SELF'] . '?page=pageeditor&action=edit&page_name=' . $site_info->page_name . '">[' . $admin_lang['edit'] . ']</a> <a href="' . $_SERVER['PHP_SELF'] . '?page=pageeditor&action=delete&page_name=' . $site_info->page_name . '">[' . $admin_lang['delete'] . ']</a>';
}
$out .= generatePagesTree($site_info->page_id, $tabs . "\t\t", $lang, $show_deleted, $show_hidden, $type) . "</li>\r\n";
}
$out .= $tabs . "</ol>\r\n";
$out .= substr($tabs, 0, -1);
}
return $out;
}
function page_pageeditor()
{
global $admin_lang, $actual_user_lang, $_SERVER, $actual_user_id, $extern_action, $extern_page_name, $extern_page_title, $extern_page_lang, $extern_page_parentid, $extern_page_edit, $extern_page_text, $extern_page_visible, $extern_show_hidden_pages, $extern_show_deleted_pages, $extern_sure;
$out = "\t\t\t<h3>" . $admin_lang['pageeditor'] . "</h3><hr />\r\n";
//$page_name = $extern_page_name;
//$page_title = $extern_page_title;
//$page_lang = $extern_page_lang;
//$page_parentid = '';
if (!isset($extern_page_name)) {
$extern_page_name = '';
}
if (!isset($extern_page_title)) {
$extern_page_title = '';
}
if (!isset($extern_page_lang)) {
$extern_page_lang = '';
}
if (!isset($extern_page_parentid)) {
$extern_page_parentid = '';
}
if (!isset($extern_action)) {
$extern_action = '';
}
if ($extern_action == 'add_new') {
if (!isset($extern_page_edit)) {
$extern_page_edit = '';
}
if (!isset($extern_page_visible)) {
$extern_page_visible = '';
}
if ($extern_page_name != '' && $extern_page_title != '' && $extern_page_lang != '') {
$a_visible = array('public', 'private', 'hidden');
if (!in_array($extern_page_visible, $a_visible)) {
$extern_page_visible = $a_visible[0];
}
$extern_page_name = strtolower($extern_page_name);
$extern_page_name = str_replace(' ', '_', $extern_page_name);
$sql = "SELECT page_name\r\n\t\t\t\t\tFROM " . DB_PREFIX . "pages_content\r\n\t\t\t\t\tWHERE page_name='{$extern_page_name}'";
$page_result = db_result($sql);
if (!($page_data = mysql_fetch_object($page_result))) {
$sql = "INSERT INTO " . DB_PREFIX . "pages_content (page_name, page_type, page_title, page_text, page_lang, page_html, page_parent_id, page_creator, page_created, page_visible)\r\n\t\t\t\t\tVALUES ('{$extern_page_name}', 'text', '{$extern_page_title}', '', '{$extern_page_lang}', '', '{$extern_page_parentid}', '{$actual_user_id}', '" . mktime() . "','{$extern_page_visible}')";
db_result($sql);
}
if ($extern_page_edit == 'on') {
header('Location: ' . $_SERVER['PHP_SELF'] . '?page=pageeditor&action=edit&page_name=' . $extern_page_name);
} else {
header('Location: ' . $_SERVER['PHP_SELF'] . '?page=pageeditor');
}
}
} elseif ($extern_action == 'update') {
if (!isset($extern_page_text)) {
$extern_page_text = '';
}
if ($extern_page_name != '' && $extern_page_title != '' && $extern_page_text != '') {
$html = convertToPreHtml($extern_page_text);
$sql = "SELECT *\r\n\t\t\t\t\tFROM " . DB_PREFIX . "pages_content\r\n\t\t\t\t\tWHERE page_name='{$extern_page_name}'";
$old_result = db_result($sql);
if ($old = mysql_fetch_object($old_result)) {
if ($old->page_text != $extern_page_text || $old->page_title != $extern_page_title) {
if ($old->page_text != '') {
$sql = "INSERT INTO " . DB_PREFIX . "sitedata_history (name, title, text, lang, type, creator, date)\r\n\t\t\t\t\t\t\tVALUES ('{$extern_page_name}', '{$old->page_title}', '{$old->page_text}', '{$old->page_lang}', 'text',{$old->page_creator}, '{$old->page_created}')";
db_result($sql);
}
$sql = "UPDATE " . DB_PREFIX . "pages_content\r\n\t\t\t\t\t\t\tSET page_title= '{$extern_page_title}', page_text='{$extern_page_text}', page_html='{$html}', page_creator='{$actual_user_id}', page_created='" . mktime() . "'\r\n\t\t\t\t\t\t\tWHERE page_name='{$extern_page_name}'";
db_result($sql);
$out = 'Der Eintrag sollte gespeichert sein';
}
}
}
} elseif ($extern_action == 'new') {
$out .= "\t\t\t<form method=\"post\" action=\"" . $_SERVER['PHP_SELF'] . "\">\r\n\t\t\t\t<fieldset>\r\n\t\t\t\t<legend>Neue Seite</legend>\r\n\t\t\t\t<input type=\"hidden\" name=\"page\" value=\"pageeditor\" />\r\n\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"add_new\" />\r\n\t\t\t\t<table>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\tName/Kürzel:\r\n\t\t\t\t\t\t\t<span class=\"info\">Mit diesem Kürzel wird auf die Seite zugegriffen und dient es zur eindeutigen Identifizierung der Seite.</span>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t<input type=\"text\" name=\"page_name\" value=\"" . $extern_page_name . "\" maxlength=\"20\" />\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\tTitel:\r\n\t\t\t\t\t\t\t<span class=\"info\">Der Titel wird später in der Titelleiste des Browsers angezeigt.</span>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t<input type=\"text\" name=\"page_title\" maxlength=\"100\" />\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t" . $admin_lang['language'] . ":\r\n\t\t\t\t\t\t\t<span class=\"info\">Der Text soll in der gewählten Sprache geschrieben werden.</span>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t<select name=\"page_lang\">\r\n\t\t\t\t\t\t\t\t<option value=\"de\">Deutsch</option>\r\n\t\t\t\t\t\t\t\t<option value=\"en\">Englisch</option>\r\n\t\t\t\t\t\t\t</select>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\tZugang:\r\n\t\t\t\t\t\t\t<span class=\"info\">Wer soll sich die Seite später anschauen können?<br />\r\n\t\t\t\t\t\t\tJeder (öffentlich), nur ausgewählte Benutzer (privat) oder soll die Seite nur erstellt werden um sie später zu veröffentlichen (versteckt)?</span>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t<select name=\"page_visible\">\r\n\t\t\t\t\t\t\t\t<option value=\"public\">Öffentlich</option>\r\n\t\t\t\t\t\t\t\t<option value=\"private\">Privat</option>\r\n\t\t\t\t\t\t\t\t<option value=\"hidden\">Versteckt</option>\r\n\t\t\t\t\t\t\t</select>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\tUnterseite von:\r\n\t\t\t\t\t\t\t<span class=\"info\">TODO</span>\t\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t<select name=\"page_parentid\">\r\n\t\t\t\t\t\t\t\t<option value=\"0\">Keiner</option>\r\n";
$sql = "SELECT page_name, page_title, page_id\r\n\t\t\t\tFROM " . DB_PREFIX . "pages_content WHERE page_visible!='deleted'\r\n\t\t\t\tORDER BY page_name ASC";
$pages = db_result($sql);
while ($pageinfo = mysql_fetch_object($pages)) {
$out .= "\t\t\t\t\t\t<option value=\"" . $pageinfo->page_id . "\">" . $pageinfo->page_title . "(" . $pageinfo->page_name . ")</option>\r\n";
}
$out .= "\t\t\t\t\t\t\t</select>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\tBearbeiten?\r\n\t\t\t\t\t\t\t<span class=\"info\">Soll die Seite nach dem Erstellen bearbeitet werden oder soll wieder auf die Übersichtseite zurückgekehrt werden?</span>\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td><input type=\"checkbox\" name=\"page_edit\" checked=\"true\"/></td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t<td colspan=\"2\">\r\n\t\t\t\t\t\t\t<input type=\"reset\" class=\"button\" value=\"Zurücksetzen\" /> \r\n\t\t\t\t\t\t\t<input type=\"submit\" class=\"button\" value=\"Erstellen\" />\r\n\t\t\t\t\t\t</td>\r\n\t\t\t\t\t</tr>\r\n\t\t\t\t</table>\r\n\t\t\t</fieldset>\r\n\t\t\t</form>";
} elseif ($extern_action == 'delete') {
if (!isset($extern_sure)) {
$extern_sure = '';
}
$sql = "SELECT *\r\n\t\t\t\tFROM " . DB_PREFIX . "pages_content\r\n\t\t\t\tWHERE page_name='{$extern_page_name}'";
$exists_result = db_result($sql);
$exists = null;
if (!($exists = mysql_fetch_object($exists_result))) {
$out .= "\t\t\tDer Eintag existiert garnicht, das löschen kann man sich also sparen<br />\r\n\t\t\t<a href=\"" . $PHP_SELF . "?page=pageeditor\">" . $admin_lang['ok'] . "</a>";
return $out;
}
if ($extern_sure == 1) {
$sql = "INSERT INTO " . DB_PREFIX . "sitedata_history (name, title, text, lang, type, creator, date)\r\n\t\t\t\t\tVALUES ('{$extern_page_name}', '{$exists->page_title}', '{$exists->page_text}', '{$exists->page_lang}', 'text', {$exists->page_creator}, '{$exists->page_created}')";
db_result($sql);
$sql = "UPDATE " . DB_PREFIX . "pages_content\r\n\t\t\t\t\tSET page_visible='deleted', page_text='', page_html='', page_creator='{$actual_user_id}', page_created='" . mktime() . "'\r\n\t\t\t\t\tWHERE page_name='{$extern_page_name}'";
db_result($sql);
header("Location: " . $_SERVER['PHP_SELF'] . "?page=pageeditor&action=tree");
} else {
$out .= "\t\t\tMöchten sie die Seite "" . $exists->page_title . " (" . $exists->page_name . ")" wirklich löschen?<br />\r\n\t\t\t\t<a href=\"" . $_SERVER['PHP_SELF'] . "?page=pageeditor&action=delete&sure=1&page_name=" . $extern_page_name . "\">" . $admin_lang['yes'] . "</a> <a href=\"" . $_SERVER['PHP_SELF'] . "?page=pageeditor\">" . $admin_lang['no'] . "</a>";
}
} elseif ($extern_action == 'tree') {
$show_deleted = false;
$show_hidden = false;
if (isset($extern_show_hidden_pages)) {
$show_hidden = $extern_show_hidden_pages == 'on';
}
if (isset($extern_show_deleted_pages)) {
$show_deleted = $extern_show_deleted_pages == 'on';
}
if ($extern_page_lang == '') {
$extern_page_lang = $actual_user_lang;
}
$out .= "\t\t\t<form action=\"" . $_SERVER['PHP_SELF'] . "\" method=\"get\">\r\n\t\t\t\t<input type=\"hidden\" name=\"page\" value=\"pageeditor\" />\r\n\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"tree\" />\r\n\t\t\t\t<select name=\"page_lang\">\r\n\t\t\t\t\t<option value=\"de\"";
if ($extern_page_lang == "de") {
$out .= " selected=\"selected\"";
}
$out .= ">" . $admin_lang['de'] . "</option>\r\n\t\t\t\t\t<option value=\"en\"";
if ($extern_page_lang == "en") {
$out .= " selected=\"selected\"";
}
$out .= ">" . $admin_lang['en'] . "</option>\r\n\t\t\t\t</select><br />\r\n\t\t\t\t<input type=\"checkbox\" name=\"show_hidden_pages\"";
if ($show_hidden) {
$out .= " checked=\"true\"";
}
$out .= "/>" . $admin_lang['show hidden'] . "<br />\r\n\t\t\t\t<input type=\"checkbox\" name=\"show_deleted_pages\"";
if ($show_deleted) {
$out .= " checked=\"true\"";
}
$out .= "/>" . $admin_lang['show deleted'] . "<br />\r\n\t\t\t\t<input type=\"submit\" class=\"button\" value=\"" . $admin_lang['show'] . "\" />\r\n\t\t\t</form>";
$out .= generatePagesTree(0, "\t\t\t", $extern_page_lang, $show_deleted, $show_hidden);
} elseif ($extern_action == 'edit') {
$sql = "SELECT *\r\n\t\t\tFROM " . DB_PREFIX . "pages_content\r\n\t\t\tWHERE page_name='{$extern_page_name}'";
$page_result = db_result($sql);
if ($page_data = mysql_fetch_object($page_result)) {
$out .= "\t\t\t<form action=\"" . $_SERVER['PHP_SELF'] . "\" method=\"post\">\r\n\t\t\t\t<input type=\"hidden\" name=\"page\" value=\"pageeditor\" />\r\n\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"update\" />\r\n\t\t\t\t<input type=\"hidden\" name=\"page_name\" value=\"" . $page_data->page_name . "\" />\r\n\t\t\t\t<input type=\"text\" name=\"page_title\" value=\"" . $page_data->page_title . "\" /><br />\r\n\t\t\t\t<script type=\"text/javascript\" language=\"JavaScript\" src=\"system/functions.js\"></script>\r\n\t\t\t\t<script type=\"text/javascript\" language=\"javascript\">\r\n\t\t\t\t\twriteButton(\"img/button_fett.png\",\"Formatiert Text Fett\",\"**\",\"**\",\"Fetter Text\",\"f\");\r\n\t\t\t\t\twriteButton(\"img/button_kursiv.png\",\"Formatiert Text kursiv\",\"//\",\"//\",\"Kursiver Text\",\"k\");\r\n\t\t\t\t\twriteButton(\"img/button_unterstrichen.png\",\"Unterstreicht den Text\",\"__\",\"__\",\"Unterstrichener Text\",\"u\");\r\n\t\t\t\t\twriteButton(\"img/button_ueberschrift.png\",\"Markiert den Text als Überschrift\",\"=== \",\" ===\",\"Überschrift\",\"h\");\r\n\t\t\t\t</script><br />\r\n\t\t\t\t<textarea id=\"editor\" class=\"edit\" name=\"page_text\">" . $page_data->page_text . "</textarea>\r\n\t\t\t\t<input type=\"reset\" value=\"Zurücksetzten\" />\r\n\t\t\t\t<input type=\"submit\" value=\"Speichern\" />\r\n\t\t\t</form>";
} else {
header("Location: " . $_SERVER['PHP_SELF'] . "?page=pageeditor&action=new&page_name=" . $extern_page_name);
}
} elseif ($extern_action == 'info') {
if ($extern_page_name == '') {
header("Location: " . $_SERVER['PHP_SELF'] . "?page=pageeditor");
}
$sql = "SELECT *\r\n\t\t\t\tFROM " . DB_PREFIX . "pages_content\r\n\t\t\t\tWHERE page_name='{$extern_page_name}'";
$actual_result = db_result($sql);
$sql = "SELECT *\r\n\t\t\t\tFROM " . DB_PREFIX . "sitedata_history\r\n\t\t\t\tWHERE name='{$extern_page_name}'\r\n\t\t\t\tORDER BY id DESC";
$olds_result = db_result($sql);
$actual = mysql_fetch_object($actual_result);
$out .= "\t\t\tName: " . $actual->page_name . "<br />\r\n\t\t\tTitel: " . $actual->page_title . "<br />\r\n\t\t\t<fieldset><legend>Text</legend>" . $actual->page_html . "</fieldset>\r\n\t\t\tLetzte Veränderung von: " . getUserById($actual->page_creator) . "<br />\r\n\t\t\tinsgesamt " . mysql_num_rows($olds_result) . " Veränderungen<br />";
} else {
// home site etc.
$out .= "<a href=\"" . $_SERVER['PHP_SELF'] . "?page=pageeditor&action=new\">Neue Seite</a><br />\r\n";
$out .= "<a href=\"" . $_SERVER['PHP_SELF'] . "?page=pageeditor&action=tree\">Übersicht</a><br />\r\n";
$out .= "<form action=\"" . $_SERVER['PHP_SELF'] . "\" method=\"get\">\r\n\t\t<input type=\"hidden\" name=\"page\" value=\"pageeditor\" />\r\n\t\t<input type=\"hidden\" name=\"action\" value=\"edit\" />\r\n\t\t<select name=\"page_name\">";
$sql = "SELECT page_name, page_title, page_id\r\n\t\t\t\tFROM " . DB_PREFIX . "pages_content\r\n\t\t\t\tWHERE page_visible!='deleted' AND page_type='text'\r\n\t\t\t\tORDER BY page_name ASC";
$sites = db_result($sql);
while ($siteinfo = mysql_fetch_object($sites)) {
$out .= "\t\t\t\t\t\t<option value=\"" . $siteinfo->page_name . "\">" . $siteinfo->page_title . "(" . $siteinfo->page_name . ")</option>\r\n";
}
$out .= "\t\t\t\t\t\t\t</select>\r\n\t\t<input type=\"submit\" class=\"button\" value=\"Öffnen\" /> \r\n\t\t</form>";
}
return $out;
}
function page_gallery_editor()
{
global $admin_lang, $extern_action, $_SERVER, $extern_images, $extern_gallery_name, $extern_gallery_title, $actual_user_id;
if (!isset($extern_action)) {
$extern_action = '';
}
if (!isset($extern_gallery_name)) {
$extern_gallery_name = '';
}
if (!isset($extern_gallery_title)) {
$extern_gallery_title = '';
}
if ($extern_images === null) {
$extern_images = array();
}
$out = "<h3>" . $admin_lang['gallery editor'] . "</h3><hr />\r\n";
if ($extern_action == 'select') {
$out .= "Bilder auswählen\r\n\t\t\t\t<form action=\"" . $_SERVER['PHP_SELF'] . "\" method=\"post\">\r\n\t\t\t\t\t<input type=\"hidden\" name=\"page\" value=\"gallery_editor\"/>\r\n\t\t\t\t\t<input type=\"hidden\" name=\"action\" value=\"new\" />\r\n\t\t\t\t\t<table>\r\n\t\t\t\t\t\t<tr>\r\n\t\t\t\t\t\t\t<td>\r\n\t\t\t\t\t\t\t\tBilder:\r\n\t\t\t\t\t\t\t\t<span class=\"info\">TODO</span>\r\n\t\t\t\t\t\t\t</td>\r\n\t\t\t\t\t\t<td>\r\n\t\t\t\t\t";
$sql = "SELECT *\r\n\t\t\t\t\tFROM " . DB_PREFIX . "files\r\n\t\t\t\t\tWHERE file_type LIKE 'image/%'\r\n\t\t\t\t\tORDER BY file_name ASC";
$images_result = db_result($sql);
while ($image = mysql_fetch_object($images_result)) {
$thumb = str_replace('/upload/', '/thumbnails/', $image->file_path);
preg_match("'^(.*)\\.(gif|jpe?g|png|bmp)\$'i", $thumb, $ext);
//echo $thumb."<br />";
if (strtolower($ext[2]) == 'gif') {
$thumb .= '.png';
}
$succes = true;
$imgmax = 100;
if (!file_exists($thumb)) {
$succes = generateThumb($image->file_path, $imgmax);
}
if (file_exists($thumb) || $succes) {
$sizes = getimagesize($thumb);
$margin_top = round(($imgmax - $sizes[1]) / 2);
$margin_bottom = $imgmax - $sizes[1] - $margin_top;
$out .= "<div class=\"imageblock\">\r\n\t\t\t\t\t\t<a href=\"" . generateUrl($image->file_path) . "\">\r\n\t\t\t\t\t\t<img style=\"margin-top:" . $margin_top . "px;margin-bottom:" . $margin_bottom . "px;width:" . $sizes[0] . "px;height:" . $sizes[1] . "px;\" src=\"" . generateUrl($thumb) . "\" alt=\"{$thumb}\" /></a><br />\r\n\t\t\t\t\t\t<input type=\"checkbox\" name=\"images[]\" value=\"{$image->file_id}\"/>Auswählen</div>";
}
}
$out .= "</td>\r\n\t\t\t\t</tr>\r\n\t\t\t\t<tr>\r\n\t\t\t\t\t<td colspan=\"2\">\r\n\t\t\t\t\t\t<input class=\"button\" type=\"reset\" value=\"Auswahl rückgängig machen\" /> \r\n\t\t\t\t\t\t<input class=\"button\" type=\"Submit\" value=\"Als Gallerie Zusammenfassen\"/>\r\n\t\t\t\t\t</td>\r\n\t\t\t\t</tr>\r\n\t\t\t</table>\r\n\t\t</form>";
return $out;
} elseif ($extern_action == 'add') {
//
// TODO: chekc for correct inputs
//
$page_text = implode(',', $extern_images);
foreach ($extern_images as $id) {
$sql = "SELECT file_path\r\n\t\t\t\t\tFROM " . DB_PREFIX . "files\r\n\t\t\t\t\tWHERE file_id={$id}";
$image_result = db_result($sql);
$image = mysql_fetch_object($image_result);
$page_text .= "\r\n" . $image->file_path;
}
//$out .= $page_text;
$sql = "INSERT INTO " . DB_PREFIX . "pages_content (page_name, page_type, page_title, page_text, page_lang, page_html, page_parent_id, page_creator, page_created, page_visible)\r\n\t\t\t\t\tVALUES ('{$extern_gallery_name}', 'gallery', '{$extern_gallery_title}', '{$page_text}', '', '', '0', '{$actual_user_id}', '" . mktime() . "','public')";
db_result($sql);
} elseif ($extern_action == 'overview') {
$out .= generatePagesTree(0, "\t\t\t", '', true, true, 'gallery');
} elseif ($extern_action == 'new') {
//$images = array();
$out .= "<form method=\"post\" action=\"" . $_SERVER['PHP_SELF'] . "\">\r\n\t\t\t<input type=\"hidden\" name=\"page\" value=\"gallery_editor\" />\r\n\t\t\t<input type=\"hidden\" name=\"action\" value=\"add\" />\r\n\t\t\t<table>\r\n\t\t\t<tr>\r\n\t\t\t\t<td>\r\n\t\t\t\t\tTitel:\r\n\t\t\t\t\t<span class=\"info\">TODO</span>\r\n\t\t\t\t</td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t<input type=\"text\" name=\"gallery_title\"/>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td>\r\n\t\t\t\t\tName:\r\n\t\t\t\t\t<span class=\"info\">TODO</span>\r\n\t\t\t\t</td>\r\n\t\t\t\t<td>\r\n\t\t\t\t\t<input type=\"text\" name=\"gallery_name\"/>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td class=\"topdesc\">\r\n\t\t\t\t\tBilder:\r\n\t\t\t\t\t<span class=\"info\">TODO</span>\r\n\t\t\t\t</td>\r\n\t\t\t\t<td>";
foreach ($extern_images as $id) {
$sql = "SELECT file_path\r\n\t\t\t\t\tFROM " . DB_PREFIX . "files\r\n\t\t\t\t\tWHERE file_id={$id}";
$image_result = db_result($sql);
$image = mysql_fetch_object($image_result);
$thumb = str_replace('/upload/', '/thumbnails/', $image->file_path);
preg_match("'^(.*)\\.(gif|jpe?g|png|bmp)\$'i", $thumb, $ext);
//echo $thumb."<br />";
if (strtolower($ext[2]) == 'gif') {
$thumb .= '.png';
}
$succes = true;
$imgmax = 100;
if (!file_exists($thumb)) {
$succes = generateThumb($image->file_path, $imgmax);
}
if (file_exists($thumb) || $succes) {
$sizes = getimagesize($thumb);
$margin_top = round(($imgmax - $sizes[1]) / 2);
$margin_bottom = $imgmax - $sizes[1] - $margin_top;
$out .= "<div class=\"imageblock\">\r\n\t\t\t\t\t\t\t<a href=\"" . generateUrl($image->file_path) . "\">\r\n\t\t\t\t\t\t\t\t<img style=\"margin-top:" . $margin_top . "px;margin-bottom:" . $margin_bottom . "px;width:" . $sizes[0] . "px;height:" . $sizes[1] . "px;\" src=\"" . generateUrl($thumb) . "\" alt=\"{$thumb}\" />\r\n\t\t\t\t\t\t\t</a>\r\n\t\t\t\t\t\t\t<br />\r\n\t\t\t\t\t\t\t<input type=\"checkbox\" name=\"images[]\" value=\"{$id}\" checked=\"checked\"/>Auswählen\r\n\t\t\t\t\t\t</div>";
}
}
$out .= "</td>\r\n\t\t\t</tr>\r\n\t\t\t<tr>\r\n\t\t\t\t<td colspan=\"2\">\r\n\t\t\t\t\t<a class=\"button\" href=\"" . $_SERVER['PHP_SELF'] . "?page=gallery_editor&action=select\">Zurück</a><input class=\"button\" type=\"submit\" value=\"Erstellen\"/>\r\n\t\t\t\t</td>\r\n\t\t\t</tr>\r\n\t\t</table>\r\n\t\t</form>";
} else {
$out .= "Bilder Verwalten<br />\r\n\t\t\t\t -Hinzufügen/Hochladen<br />\r\n\t\t\t\t -Bearbeiten<br />\r\n\t\t\t\t -Löschen<br />\r\n\t\t\t<a href=\"" . $_SERVER['PHP_SELF'] . "?page=gallery_editor&action=select\">Neue Gallerie</a><br />\r\n\t\t\t<a href=\"" . $_SERVER['PHP_SELF'] . "?page=gallery_editor&action=overview\">Übersicht</a><br />\r\n\t\t\t\t -Infos<br />\r\n\t\t\t\t -Bearbeiten<br />\r\n\t\t\t\t -Löschen";
}
return $out;
}
