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; }