echo "<img src=\"img/leer.gif\" height=\"1\" width=\"5\"><strong>" . $user_naming . "</strong></td>\n";
//Schließen Zelle 1. Spalte
echo "<td width=\"50\" align=\"right\" class=\"msglist\">";
//Zelle 2. Spalte - vorgesehen für Buttons/Tasten Edit etc.
echo "<img src=\"img/leer.gif\" width=\"50\" height=\"1\">";
//Spacer
echo "</td>\n";
echo "</tr>\n";
//Abschluss Tabellenzeile
//Aufbau trennende Tabellen-Zeile bgcolor:#EBF2F4
echo "<tr bgcolor=\"#D8E4E9\"><td colspan=\"2\"><img src=\"img/leer.gif\" height=\"2\" width=\"1\"></td></tr>\n";
//Abstand nach
echo "<tr><td colspan=\"2\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\"></td></tr>\n";
//Trennlinie
if (!$pklapp_status) {
list_public(0, $db, 18, "phpwcms.php?do=files&f=1", $row["f_uid"], $_SESSION["wcs_user_thumb"], $phpwcms);
//Root files anzeigen
$file_sql = "SELECT * FROM " . DB_PREPEND . "phpwcms_file WHERE f_pid=0 AND f_uid=" . $root_user_id . " AND f_public=1 AND f_aktiv=1 AND f_kid=1 AND f_trash=0 ORDER BY f_name;";
if ($file_result = mysql_query($file_sql, $db) or die("error while listing files")) {
$file_durchlauf = 0;
while ($file_row = mysql_fetch_array($file_result)) {
$filename = html($file_row["f_name"]);
if (!$file_durchlauf) {
//Aufbau der Zeile zum Einfließen der Filelisten-Tabelle
echo "<tr bgcolor=\"#F5F8F9\"><td colspan=\"2\"><table width=\"538\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";
} else {
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"5\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\"></td></tr>\n";
}
echo "<tr>\n";
echo "<td width=\"37\" class=\"msglist\"><img src=\"img/leer.gif\" height=\"1\" width=\"37\" border=\"0\"></td>\n";
echo "<td width=\"13\" class=\"msglist\">";
function list_public($pid, $dbcon, $vor, $zieldatei, $userID, $show_thumb = 1, $phpwcms)
{
$pid = intval($pid);
//Folder Listing für Public files
$sql = "SELECT f_id, f_name FROM " . DB_PREPEND . "phpwcms_file WHERE " . "f_pid=" . intval($pid) . " AND " . "f_public=1 AND f_aktiv=1 AND " . "f_uid=" . intval($userID) . " AND " . "f_kid=0 AND 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"]);
//Ermitteln des Aufklappwertes
$klapp_status = empty($_SESSION["pklapp"][$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 " . "f_pid=" . $row["f_id"] . " AND " . "f_uid=" . intval($userID) . " AND " . "f_public=1 AND f_aktiv=1 AND " . "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 . "&pklapp=" . $row["f_id"] . "|" . $klapp_status . "\">" . on_off($klapp_status, $dirname, 0) . "</a>";
$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\"></td></tr>\n";
//Abstand vor
echo "<tr bgcolor=\"#EBF2F4\">\n";
//Einleitung Tabellenzeile
echo "<td width=\"488\" class='msglist'>";
//Einleiten der Tabellenzelle
echo $count . "<img src=\"img/leer.gif\" height=\"1\" width=\"" . ($vor + 6) . "\" border=\"0\"><img src=\"img/icons/folder_zu.gif\" border=\"0\">";
//Zellinhalt 1. Spalte
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=\"50\" align=\"right\" class=\"msglist\">";
echo "<img src=\"img/leer.gif\" width=\"50\" height=\"1\">";
//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\" height=\"1\" width=\"1\"></td></tr>\n";
//Abstand nach
echo "<tr><td colspan=\"2\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\"></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_public($row["f_id"], $dbcon, $vor + 18, $zieldatei, $userID, $show_thumb, $phpwcms);
//Listing eventuell im Verzeichnis enthaltener Dateien
$file_sql = "SELECT * FROM " . DB_PREPEND . "phpwcms_file WHERE f_pid=" . $row["f_id"] . " AND f_uid=" . intval($userID) . " AND f_public=1 AND f_aktiv=1 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"]);
if (!$file_durchlauf) {
//Aufbau der Zeile zum Einfließen der Filelisten-Tabelle
echo "<tr bgcolor=\"#F5F8F9\"><td colspan=\"2\"><table width=\"538\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n";
} else {
echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"5\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\"></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\"></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"] . '\');" onmouseout="UnTip()" alt=""';
echo "></td>\n";
echo "<td width=\"" . (473 - $vor) . "\" class=\"msglist\"><img src=\"img/leer.gif\" height=\"1\" width=\"5\">";
//438-$vor
echo "<a href=\"fileinfo.php?public&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 $filename . "</a>";
echo "</td>\n";
echo "<td width=\"15\" align=\"right\" class=\"msglist\">";
echo "<a href=\"include/inc_act/act_download.php?pl=1&dl=" . $file_row["f_id"];
echo "\" target=\"_blank\" title=\"" . $GLOBALS['BL']['be_fprivfunc_dlfile'] . ": " . $filename . "\">";
echo "<img src=\"img/button/download_disc.gif\" border=0></a>";
//target='_blank'
echo "<img src=\"img/leer.gif\" width=\"2\" height=\"1\">";
//Spacer
echo "</td>\n";
//Ende Aufbau
echo "</tr>\n";
if ($_SESSION["wcs_user_thumb"]) {
$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\"></td>\n";
echo "<td width=\"13\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\" border=\"0\"></td>\n<td width=\"";
echo 473 - $vor . "\"><img src=\"img/leer.gif\" height=\"1\" width=\"6\"><a href=\"fileinfo.php?public&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 '<img src="' . PHPWCMS_IMAGES . $thumb_image[0] . '" border="0" ' . $thumb_image[3];
echo ' onmouseover="Tip(\'ID: ' . $file_row["f_id"] . '\');" onmouseout="UnTip()" alt=""';
echo "></a></td>\n";
echo "<td width=\"15\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\" border=\"0\"></td>\n</tr>\n";
echo "<tr><td colspan=\"4\"><img src=\"img/leer.gif\" height=\"2\" width=\"1\" border=\"0\"></td>\n</tr>\n";
}
}
$file_durchlauf++;
}
if ($file_durchlauf) {
//Abschluss der Filelisten-Tabelle
echo "</table>\n";
echo "<tr><td colspan=\"2\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\"></td></tr>\n";
}
}
//Ende Liste Dateien
}
//Zaehler mitführen
$_SESSION["list_zaehler"]++;
}
mysql_free_result($result);
return $vor;
}