\n";
echo "![](\"img/leer.gif\") |
\n";
//Prüfen, für welche User überhaupt Public Files vorhanden sind
$sql = "SELECT DISTINCT ".DB_PREPEND."phpwcms_file.f_uid, ".DB_PREPEND."phpwcms_user.usr_login, ".DB_PREPEND."phpwcms_user.usr_name ".
"FROM ".DB_PREPEND."phpwcms_file INNER JOIN ".DB_PREPEND."phpwcms_user ON ".DB_PREPEND."phpwcms_file.f_uid=".DB_PREPEND."phpwcms_user.usr_id ".
"WHERE ".DB_PREPEND."phpwcms_file.f_public=1 AND ".DB_PREPEND."phpwcms_file.f_aktiv=1 AND ".DB_PREPEND."phpwcms_file.f_trash=0 ".
"ORDER BY ".DB_PREPEND."phpwcms_user.usr_name, ".DB_PREPEND."phpwcms_user.usr_login;";
if($result = mysql_query($sql, $db) or die ("error while browsing user's public files")) {
$user_counter=0;
while($row = mysql_fetch_array($result)) {
//Prüfen
$pklapp_status = isset($pklapp[ "u".$row["f_uid"] ]) ? true_false($pklapp[ "u".$row["f_uid"] ]) : 1;
$root_user_id = intval($row["f_uid"]);
$user_naming = html_specialchars($row["usr_name"]." (".$row["usr_login"].")");
$count = "".
"".on_off($pklapp_status, "\n".$BL['be_fpublic_user'].": ".$user_naming, 0)."";
//Aufbau der Zeile mit den Benutzerinfos
if($user_counter) {
//Trennende blaue Tabellen-Zeile zwischen unterschiedlicghen Public Users
echo "![](\"img/lines/line-lightgrey-dotted-538.gif\") |
\n";
echo " |
\n";
}
echo " |
\n"; //Abstand vor
echo "\n"; //Einleitung Tabellenzeile
echo ""; //Einleiten der Tabellenzelle
echo $count."![](\"img/icons/user_zu.gif\") ";
echo "".$user_naming." | \n"; //Schließen Zelle 1. Spalte
echo ""; //Zelle 2. Spalte - vorgesehen für Buttons/Tasten Edit etc.
echo ""; //Spacer
echo " | \n";
echo "
\n"; //Abschluss Tabellenzeile
//Aufbau trennende Tabellen-Zeile bgcolor:#EBF2F4
echo " |
\n"; //Abstand nach
echo " |
\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_specialchars($file_row["f_name"]);
if(!$file_durchlauf) { //Aufbau der Zeile zum Einfließen der Filelisten-Tabelle
echo "\n";
} else {
echo " | \n";
}
echo "\n";
echo " | \n";
echo "";
echo "![](\"img/icons/small_".extimg($file_row["f_ext"])."\") | \n";
echo ""; //438-$vor
//echo "";
echo $filename."";
echo " | \n";
echo "";
echo "";
echo "![](\"img/button/download_disc.gif\") "; //target='_blank'
echo ""; //Spacer
echo " | \n";
//Ende Aufbau
echo " \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"])
)
);
if($thumb_image != false) {
echo "\n";
echo " | \n";
echo " | \n";
echo ' | \n";
echo " | \n \n";
echo " | \n \n";
}
}
/*
if($file_row["f_thumb_list"] && $_SESSION["wcs_user_thumb"]) { //Wenn List Preview Image verfügbar
echo "\n";
echo " | \n";
echo " | \n";
echo "![](\"".$phpwcms["file_tmp"].$phpwcms["dir_thlist"].$file_row["f_thumb_list"]."\") | \n";
echo " | \n \n";
echo " | \n \n";
}
*/
$file_durchlauf++;
}
if($file_durchlauf) { //Abschluss der Filelisten-Tabelle
echo " \n";
echo " |
|
\n";
}
} //Ende Liste Dateien
//Ende Anzeige root files public
}
$user_counter++;
}
}
echo "\n"; //Ende Tabelle
} else { //Wenn keinerlei Datensatz innerhalb Files durchlaufen wurde, dann
echo "
".$BL['be_fpublic_nofiles']." ";
echo "[".$BL['be_fpriv_button']."]";
echo "
";
}
?>