/* This will tell the header to include WYSIWYG editor Javascript */
define('WYSIWYG', 1);
/* What should we do? */
if ($action = hesk_REQUEST('a')) {
if ($action == 'add_article') {
add_article();
} elseif ($action == 'add_category') {
add_category();
} elseif ($action == 'manage_cat') {
manage_category();
} elseif ($action == 'edit_article') {
edit_article();
} elseif ($action == 'import_article') {
import_article();
} elseif ($action == 'list_private') {
list_private();
} elseif ($action == 'list_draft') {
list_draft();
} elseif (defined('HESK_DEMO')) {
hesk_process_messages($hesklang['ddemo'], 'manage_knowledgebase.php', 'NOTICE');
} elseif ($action == 'new_article') {
new_article();
} elseif ($action == 'new_category') {
new_category();
} elseif ($action == 'remove_article') {
remove_article();
} elseif ($action == 'save_article') {
save_article();
} elseif ($action == 'order_article') {
order_article();
} elseif ($action == 'order_cat') {
if (!$klapp_value) {
unset($_SESSION["klapp"][$klapp_id]);
}
}
mysql_query("UPDATE " . DB_PREPEND . "phpwcms_user SET usr_var_privatefile=" . _dbEscape(serialize($_SESSION["klapp"])) . " WHERE usr_id=" . $_SESSION["wcs_user_id"], $db);
}
//Zähler für die Listenfunktion setzen
$_SESSION["list_zaehler"] = 0;
//Feststellen, ob überhaupt Dateien/Ordner vorhanden sind
$sql = "SELECT COUNT(f_id) FROM " . DB_PREPEND . "phpwcms_file WHERE f_trash=0";
if (empty($_SESSION["wcs_user_admin"])) {
$sql .= " AND f_uid=" . $_SESSION["wcs_user_id"];
}
$sql .= " LIMIT 1";
$count_user_files = _dbCount($sql);
//Wenn überhaupt Dateien für User vorhanden, dann Listing
if ($count_user_files) {
//Beginn Tabelle für Dateilisting
echo "<table width=\"538\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
echo "<tr><td colspan=\"2\"><img src=\"img/leer.gif\" width=\"1\" height=\"1\"></td></tr>\n";
list_private(0, $db, 0, "phpwcms.php?do=files&f=0", $_SESSION["wcs_user_id"], $cutID, $_SESSION["wcs_user_thumb"], $phpwcms);
include_once PHPWCMS_ROOT . "/include/inc_lib/files.private-filelist.inc.php";
echo "</table>\n";
//Ende Tabelle
} else {
//Wenn keinerlei Datensatz innerhalb Files durchlaufen wurde, dann
echo "<img src=\"img/leer.gif\" width=\"1\" height=\"6\"><br />";
echo $BL['be_fprivadd_nofolders'] . " ";
echo "[<a href=\"phpwcms.php?do=files&f=0&mkdir=0\">" . $BL['be_fpriv_button'] . "</a>]";
echo "<br /><img src=\"img/leer.gif\" width=\"1\" height=\"6\">";
}
function list_private($pid, $dbcon, $vor, $zieldatei, $userID, $cutID = 0, $show_thumb = 1, $phpwcms)
{
$cutID = intval($cutID);
$pid = intval($pid);
$sql = "SELECT * FROM " . DB_PREPEND . "phpwcms_file f ";
$sql .= "LEFT JOIN " . DB_PREPEND . "phpwcms_user u ON u.usr_id=f.f_uid ";
$sql .= "WHERE ";
$sql .= "f.f_pid=" . intval($pid) . " AND ";
if (empty($_SESSION["wcs_user_admin"])) {
$sql .= "f.f_uid=" . intval($userID) . " AND ";
}
$sql .= "f.f_kid=0 AND f.f_trash=0 ORDER BY f_sort, f_name";
$result = mysql_query($sql, $dbcon);
while ($row = mysql_fetch_array($result)) {
$dirname = html($row["f_name"]);
if ($_SESSION["wcs_user_id"] != $row["f_uid"]) {
$dirname .= ' (' . html($row["usr_login"]) . ')';
}
//Ermitteln des Aufklappwertes
$klapp_status = empty($_SESSION["klapp"][$row["f_id"]]) ? 1 : 0;
//Ermitteln, ob überhaupt abhängige Dateien/Ordner existieren
$count_sql = "SELECT COUNT(f_id) FROM " . DB_PREPEND . "phpwcms_file WHERE ";
$count_sql .= "f_pid=" . $row["f_id"] . " AND ";
if (empty($_SESSION["wcs_user_admin"])) {
$count_sql .= "f_uid=" . intval($userID) . " AND ";
}
$count_sql .= "f_trash=0 LIMIT 1";
if ($count_result = mysql_query($count_sql, $dbcon)) {
if ($count_row = mysql_fetch_row($count_result)) {
$count = '<img src="img/leer.gif" width="2" height="1">' . '<a href="' . $zieldatei . "&klapp=" . $row["f_id"] . '%7C' . $klapp_status . '">' . on_off($klapp_status, $dirname, 0) . "</a>";
// | = %7C
$count_wert = $count_row[0];
}
mysql_free_result($count_result);
}
//Aufbau der Zeile
echo '<tr bgcolor="#EBF2F4"><td colspan="2"><img src="img/leer.gif" height="1" width="1" alt="" /></td></tr>' . "\n";
//Abstand vor
echo "<tr bgcolor=\"#EBF2F4\">\n";
//Einleitung Tabellenzeile
echo "<td width=\"438\" class=\"msglist\">";
//Einleiten der Tabellenzelle
echo $count . "<img src=\"img/leer.gif\" height=\"1\" width=\"" . ($vor + 6) . "\" border=\"0\">";
// Gallery status
switch ($row["f_gallerystatus"]) {
case 2:
// gallery root dir
echo '<img src="img/icons/folder_galleryroot.gif" border="0" alt="' . $GLOBALS['BL']['be_gallery_root'] . '" title="' . $GLOBALS['BL']['be_gallery_root'] . '" />';
break;
case 3:
// gallery subdir
echo '<img src="img/icons/folder_gallerysub.gif" border="0" alt="' . $GLOBALS['BL']['be_gallery_directory'] . '" title="' . $GLOBALS['BL']['be_gallery_directory'] . '" />';
break;
default:
echo "<img src=\"img/icons/folder_zu.gif\" border=\"0\" alt=\"\" />";
}
echo "<img src=\"img/leer.gif\" height=\"1\" width=\"5\"><strong>" . $dirname;
//Zellinhalt 1. Spalte Fortsetzung
echo "</strong></td>\n";
//Schließen Zelle 1. Spalte
//Zelle 2. Spalte - vorgesehen für Buttons/Tasten Edit etc.
echo "<td width=\"100\" align=\"right\" class=\"msglist\">";
//Button zum Uploaden einer Datei in dieses Verzeichnisses
echo "<a href=\"" . $zieldatei . "&upload=" . $row["f_id"] . "\" title=\"" . $GLOBALS['BL']['be_fprivfunc_upload'] . ": " . $dirname . "\">";
echo "<img src=\"img/button/upload_13x13.gif\" border=\"0\" alt=\"\" /></a>";
if (!$cutID) {
//Button zum Erzeugen eines Neuen Unterverzeichnisses
echo "<a href=\"" . $zieldatei . "&mkdir=" . $row["f_id"] . "\" title=\"" . $GLOBALS['BL']['be_fprivfunc_makenew'] . ": " . $dirname . "\">";
echo "<img src=\"img/button/add_13x13.gif\" border=\"0\" alt=\"\" /></a>";
} else {
//Button zum Einfügen der Clipboard-Datei in das Verzeichnis
echo "<a href=\"include/inc_act/act_file.php?paste=" . $cutID . '%7C' . $row["f_id"] . "\" title=\"" . $GLOBALS['BL']['be_fprivfunc_paste'] . ": " . $dirname . "\">";
echo "<img src=\"img/button/paste_13x13.gif\" border=\"0\" alt=\"\" /></a>";
}
//Button zum Bearbeiten des Verzeichnisses
echo "<a href=\"" . $zieldatei . "&editdir=" . $row["f_id"] . "\" title=\"" . $GLOBALS['BL']['be_fprivfunc_edit'] . ": " . $dirname . "\">";
echo "<img src=\"img/button/edit_22x13.gif\" border=\"0\" alt=\"\" /></a>";
//Button zum Umschalten zwischen Aktiv/Inaktiv
echo "<a href=\"include/inc_act/act_file.php?aktiv=" . $row["f_id"] . '%7C' . true_false($row["f_aktiv"]) . "\" title=\"" . $GLOBALS['BL']['be_fprivfunc_cactive'] . ": " . $dirname . "\">";
echo "<img src=\"img/button/aktiv_12x13_" . $row["f_aktiv"] . ".gif\" border=\"0\" alt=\"\" /></a>";
//Button zum Umschalten zwischen Public/Non-Public
echo "<a href=\"include/inc_act/act_file.php?public=" . $row["f_id"] . '%7C' . true_false($row["f_public"]) . "\" title=\"" . $GLOBALS['BL']['be_fprivfunc_cpublic'] . ": " . $dirname . "\">";
echo "<img src=\"img/button/public_12x13_" . $row["f_public"] . ".gif\" border=\"0\" alt=\"\" /></a>";
echo "<img src=\"img/leer.gif\" width=\"5\" height=\"1\">";
//Spacer
//Button zum Löschen des Verzeichnisses, wenn leer
if (!$count_wert) {
echo "<a href=\"include/inc_act/act_file.php?delete=" . $row["f_id"] . '%7C' . "9" . "\" title=\"" . $GLOBALS['BL']['be_fprivfunc_deldir'] . ": " . $dirname . "\" onclick=\"return confirm('" . $GLOBALS['BL']['be_fprivfunc_jsdeldir'] . " \\n[" . $dirname . "]? ');\">";
echo "<img src=\"img/button/trash_13x13_1.gif\" border=\"0\" alt=\"\" /></a>";
} else {
echo "<img src=\"img/button/trash_13x13_0.gif\" title=\"";
echo str_replace('{VAL}', $dirname, $GLOBALS['BL']['be_fprivfunc_notempty']) . '" border="0" alt="" />';
}
echo "<img src=\"img/leer.gif\" width=\"2\" height=\"1\" border=\"0\" alt=\"\" />";
//Spacer
echo "</td>\n";
echo "</tr>\n";
//Abschluss Tabellenzeile
//Aufbau trennende Tabellen-Zeile
echo "<tr bgcolor=\"#EBF2F4\"><td colspan=\"2\"><img src=\"img/leer.gif\" border=\"0\" alt=\"\" /></td></tr>\n";
//Abstand nach
echo "<tr><td colspan=\"2\"><img src=\"img/leer.gif\" border=\"0\" alt=\"\" /></td></tr>\n";
//Trennlinie<img src='img/lines/line-lightgrey-dotted-538.gif'>
//Weiter, wenn Unterstruktur
if (!$klapp_status && $count_wert) {
//$vor."<img src='img/leer.gif' height=1 width=18 border=0>"
list_private($row["f_id"], $dbcon, $vor + 18, $zieldatei, $userID, $cutID, $show_thumb, $phpwcms);
//Listing eventuell im Verzeichnis enthaltener Dateien
$file_sql = "SELECT * FROM " . DB_PREPEND . "phpwcms_file WHERE f_pid=" . $row["f_id"];
if (empty($_SESSION["wcs_user_admin"])) {
$file_sql .= " AND f_uid=" . $userID;
}
$file_sql .= " AND f_kid=1 AND f_trash=0 ORDER BY f_sort, f_name";
if ($file_result = mysql_query($file_sql, $dbcon) or die("error while listing files")) {
$file_durchlauf = 0;
while ($file_row = mysql_fetch_array($file_result)) {
$filename = html($file_row["f_name"]);
$file_row["edit"] = '<a href="' . $zieldatei . "&editfile=" . $file_row["f_id"] . '" title="' . $GLOBALS['BL']['be_fprivfunc_editfile'] . ": " . $filename . '">';
if (!$file_durchlauf) {
//Aufbau der Zeile zum Einfließen der Filelisten-Tavbelle
echo "<tr bgcolor=\"#F5F8F9\"><td colspan=\"2\"><table width=\"538\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";
echo "<!-- start file list: private-functions //-->\n";
} else {
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"5\"><img src=\"img/leer.gif\" border=\"0\" alt=\"\" /></td></tr>\n";
}
echo "<tr>\n";
echo "<td width=\"" . ($vor + 37) . "\" class=\"msglist\"><img src=\"img/leer.gif\" height=\"1\" width=\"" . ($vor + 37) . "\" border=\"0\" alt=\"\" /></td>\n";
echo "<td width=\"13\" class=\"msglist\">";
echo "<img src=\"img/icons/small_" . extimg($file_row["f_ext"]) . "\" border=\"0\" ";
echo 'onmouseover="Tip(\'ID: ' . $file_row["f_id"] . '<br>Sort: ' . $file_row["f_sort"];
echo '<br>Name: ' . html($file_row["f_name"]);
if ($file_row["f_copyright"]) {
echo '<br>©: ' . html($file_row["f_copyright"]);
}
echo '\');" onmouseout="UnTip()" alt=""';
echo " /></td>\n";
echo "<td width=\"" . (388 - $vor) . "\" class=\"msglist\"><img src=\"img/leer.gif\" height=\"1\" width=\"5\" border=\"0\" alt=\"\" />";
//echo "<a href=\"fileinfo.php?fid=".$file_row["f_id"];
//echo "\" target=\"_blank\" onclick=\"flevPopupLink(this.href,'filedetail','scrollbars=yes,resizable=yes,width=500,height=400',1);return document.MM_returnValue;\">";
echo $file_row["edit"] . $filename . "</a></td>\n";
//Aufbauen Buttonleiste für jeweilige Datei
echo "<td width=\"100\" align=\"right\" class=\"msglist\">";
//Button zum Downloaden der Datei
echo "<a href=\"include/inc_act/act_download.php?dl=" . $file_row["f_id"] . "\" target=\"_blank\" title=\"" . $GLOBALS['BL']['be_fprivfunc_dlfile'] . ": " . $filename . "\">" . "<img src=\"img/button/download_disc.gif\" border=\"0\" alt=\"\" /></a>";
//target='_blank'
//Button zum Erzeugen eines Neuen Unterverzeichnisses
if ($cutID == $file_row["f_id"]) {
echo "<img src=\"img/button/cut_13x13_1.gif\" border=\"0\" title=\"" . $GLOBALS['BL']['be_fprivfunc_clipfile'] . ": " . $filename . "\" alt=\"\" />";
} else {
echo "<a href=\"" . $zieldatei . "&cut=" . $file_row["f_id"] . "\" title=\"" . $GLOBALS['BL']['be_fprivfunc_cutfile'] . ": " . $filename . "\">";
echo "<img src=\"img/button/cut_13x13_0.gif\" border=\"0\" alt=\"\" /></a>";
}
//Button zum Bearbeiten der Dateiinformationn
echo $file_row["edit"];
echo "<img src=\"img/button/edit_22x13.gif\" border=\"0\" alt=\"\" /></a>";
//Button zum Umschalten zwischen Aktiv/Inaktiv
echo "<a href=\"include/inc_act/act_file.php?aktiv=" . $file_row["f_id"] . '%7C' . true_false($file_row["f_aktiv"]) . "\" title=\"" . $GLOBALS['BL']['be_fprivfunc_cactivefile'] . ": " . $filename . "\">";
echo "<img src=\"img/button/aktiv_12x13_" . $file_row["f_aktiv"] . ".gif\" border=\"0\" alt=\"\" /></a>";
//Button zum Umschalten zwischen Public/Non-Public
echo "<a href=\"include/inc_act/act_file.php?public=" . $file_row["f_id"] . '%7C' . true_false($file_row["f_public"]) . "\" title=\"" . $GLOBALS['BL']['be_fprivfunc_cpublicfile'] . ": " . $filename . "\">";
echo "<img src=\"img/button/public_12x13_" . $file_row["f_public"] . ".gif\" border=\"0\" alt=\"\" /></a>";
echo "<img src=\"img/leer.gif\" width=\"5\" height=\"1\">";
//Spacer
//Button zum Löschen der Datei
if ($file_row["f_uid"] == intval($_SESSION["wcs_user_id"])) {
//if user is owner then delete button is active
echo "<a href=\"include/inc_act/act_file.php?trash=" . $file_row["f_id"] . '%7C' . "1" . "\" title=\"" . $GLOBALS['BL']['be_fprivfunc_movetrash'] . ": " . $filename . "\" onclick=\"return confirm('" . $GLOBALS['BL']['be_fprivfunc_jsmovetrash1'] . "\\n[" . $filename . "]\\n" . $GLOBALS['BL']['be_fprivfunc_jsmovetrash2'] . "');\">" . "<img src=\"img/button/trash_13x13_1.gif\" border=\"0\" alt=\"\" /></a>";
} else {
echo "<img src=\"img/button/trash_13x13_0.gif\" border=\"0\">";
}
echo "<img src=\"img/leer.gif\" width=\"2\" height=\"1\" border=\"0\" alt=\"\" />";
//Spacer
echo "</td>\n";
//Ende Aufbau
echo "</tr>\n";
if ($_SESSION["wcs_user_thumb"]) {
// now try to get existing thumbnails or if not exists
// build new based on default thumbnail listing sizes
// build thumbnail image name
$thumb_image = get_cached_image(array("target_ext" => $file_row["f_ext"], "image_name" => $file_row["f_hash"] . '.' . $file_row["f_ext"], "thumb_name" => md5($file_row["f_hash"] . $phpwcms["img_list_width"] . $phpwcms["img_list_height"] . $phpwcms["sharpen_level"] . $phpwcms['colorspace'])));
if ($thumb_image != false) {
echo "<tr>\n";
echo "<td width=\"" . ($vor + 37) . "\"><img src=\"img/leer.gif\" height=\"1\" width=\"" . ($vor + 37) . "\" border=\"0\" alt=\"\" /></td>\n";
echo "<td width=\"13\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\" border=\"0\" alt=\"\" /></td>\n<td width=\"";
echo 388 - $vor . "\"><img src=\"img/leer.gif\" height=\"1\" width=\"6\" border=\"0\" alt=\"\" />";
//<a href=\"fileinfo.php?fid=";
//echo $file_row["f_id"]."\" target=\"_blank\" onclick=\"flevPopupLink(this.href,'filedetail','scrollbars=";
//echo "yes,resizable=yes,width=500,height=400',1); return document.MM_returnValue;\">";
echo $file_row["edit"];
echo '<img src="' . PHPWCMS_IMAGES . $thumb_image[0] . '" border="0" ' . $thumb_image[3] . ' ';
echo 'onmouseover="Tip(\'ID: ' . $file_row["f_id"] . '<br>Sort: ' . $file_row["f_sort"];
echo '<br>Name: ' . html($file_row["f_name"]);
if ($file_row["f_copyright"]) {
echo '<br>©: ' . html($file_row["f_copyright"]);
}
echo '\');" onmouseout="UnTip()" alt=""';
echo " /></a></td>\n";
echo "<td width=\"100\"><img src=\"img/leer.gif\" border=\"0\" alt=\"\" /></td>\n</tr>\n";
echo "<tr><td colspan=\"4\"><img src=\"img/leer.gif\" height=\"2\" width=\"1\" border=\"0\" alt=\"\" /></td>\n</tr>\n";
}
}
$file_durchlauf++;
}
if ($file_durchlauf) {
//Abschluss der Filelisten-Tabelle
echo "</table>\n<!-- end file list: private-functions //-->\n";
echo "<tr><td colspan=\"2\"><img src=\"img/leer.gif\" border=\"0\" alt=\"\" /></td></tr>\n";
}
}
//Ende Liste Dateien
}
//Zaehler mitführen
$_SESSION["list_zaehler"]++;
}
mysql_free_result($result);
return $vor;
}
