PageRenderTime 42ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

/include/inc_tmpl/files.public.list.tmpl.php

http://phpwcms.googlecode.com/
PHP | 181 lines | 149 code | 16 blank | 16 comment | 16 complexity | 3f6c72c22e1e0758c0997ab6e8000f69 MD5 | raw file
Possible License(s): AGPL-1.0, LGPL-2.1, ISC, MIT, LGPL-3.0, GPL-2.0, MPL-2.0-no-copyleft-exception, LGPL-2.0, BSD-3-Clause 
    

  1. <?php
    2. 

  2. /**
    3. 

  3.  * phpwcms content management system
    4. 

  4.  *
    5. 

  5.  * @author Oliver Georgi <oliver@phpwcms.de>
    6. 

  6.  * @copyright Copyright (c) 2002-2013, Oliver Georgi
    7. 

  7.  * @license http://opensource.org/licenses/GPL-2.0 GNU GPL-2
    8. 

  8.  * @link http://www.phpwcms.de
    9. 

  9.  *
    10. 

  10.  **/
    11. 

  11. 

  12. 

  13. // ----------------------------------------------------------------
    14. 

  14. // obligate check for phpwcms constants
    15. 

  15. if (!defined('PHPWCMS_ROOT')) {
    16. 

  16.    die("You Cannot Access This Script Directly, Have a Nice Day.");
    17. 

  17. }
    18. 

  18. // ----------------------------------------------------------------
    19. 

  19. 

  20. 

  21. //Default for listing public files
    22. 

  22. $vor = 0;
    23. 

  23. 

  24. if(!isset($_SESSION["pklapp"]) || (isset($_GET["all"]) && $_GET["all"] == "close")) {
    25. 

  25. 	$_SESSION["pklapp"] = array();
    26. 

  26. }
    27. 

  27. 

  28. if(isset($_GET["pklapp"])) {
    29. 

  29. 	
    30. 

  30. 	list($pklapp_id, $pklapp_value) = explode("|", $_GET["pklapp"]);
    31. 

  31. 		
    32. 

  32. 	if(intval($pklapp_value)) {
    33. 

  33. 		$_SESSION["pklapp"][$pklapp_id] = 1;
    34. 

  34. 	} else {
    35. 

  35. 		unset($_SESSION["pklapp"][$pklapp_id]);
    36. 

  36. 	}
    37. 

  37. 	
    38. 

  38. 	foreach($_SESSION["pklapp"] as $pklapp_id => $pklapp_value) {
    39. 

  39. 		if(!$pklapp_value) {
    40. 

  40. 			unset($_SESSION["pklapp"][$pklapp_id]);
    41. 

  41. 		}
    42. 

  42. 	}
    43. 

  43. 	
    44. 

  44. 	mysql_query("UPDATE ".DB_PREPEND."phpwcms_user SET usr_var_publicfile="._dbEscape(serialize($_SESSION["pklapp"]))." WHERE usr_id=".$_SESSION["wcs_user_id"], $db);
    45. 

  45. 

  46. }
    47. 

  47. 

  48. $_SESSION["list_zaehler"] = 0; //Zähler für die Public-Listenfunktion setzen
    49. 

  49. 			
    50. 

  50. //Feststellen, ob überhaupt Dateien/Ordner des Users vorhanden sind
    51. 

  51. $sql = "SELECT COUNT(f_id) FROM ".DB_PREPEND."phpwcms_file WHERE f_public=1 AND f_aktiv=1 AND f_trash=0 LIMIT 1;";
    52. 

  52. if($result = mysql_query($sql, $db) or die ("error while counting user files")) {
    53. 

  53. 	if($row = mysql_fetch_row($result)) {
    54. 

  54. 		$count_user_files = $row[0];
    55. 

  55. 	}
    56. 

  56. 	mysql_free_result($result);
    57. 

  57. }
    58. 

  58. 

  59. if(isset($count_user_files) && $count_user_files) { //Wenn überhaupt Public-Dateien vorhanden, dann Listing
    60. 

  60. 	//Beginn Tabelle für Public Dateilisting
    61. 

  61. 	echo "<table width=\"538\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
    62. 

  62. 	echo "<tr><td colspan=\"2\"><img src=\"img/leer.gif\" width=\"1\" height=\"1\"></td></tr>\n";
    63. 

  63. 

  64. 	//Prüfen, für welche User überhaupt Public Files vorhanden sind
    65. 

  65. 	$sql = "SELECT DISTINCT ".DB_PREPEND."phpwcms_file.f_uid, ".DB_PREPEND."phpwcms_user.usr_login, ".DB_PREPEND."phpwcms_user.usr_name ".
    66. 

  66. 		   "FROM ".DB_PREPEND."phpwcms_file INNER JOIN ".DB_PREPEND."phpwcms_user ON ".DB_PREPEND."phpwcms_file.f_uid=".DB_PREPEND."phpwcms_user.usr_id ".
    67. 

  67. 		   "WHERE ".DB_PREPEND."phpwcms_file.f_public=1 AND ".DB_PREPEND."phpwcms_file.f_aktiv=1 AND ".DB_PREPEND."phpwcms_file.f_trash=0 ".
    68. 

  68. 		   "ORDER BY ".DB_PREPEND."phpwcms_user.usr_name, ".DB_PREPEND."phpwcms_user.usr_login;";
    69. 

  69. 

  70. 	if($result = mysql_query($sql, $db) or die ("error while browsing user's public files")) {
    71. 

  71. 		$user_counter=0;
    72. 

  72. 		while($row = mysql_fetch_array($result)) {
    73. 

  73. 			//Prüfen
    74. 

  74. 			$pklapp_status = empty($_SESSION["pklapp"][ "u".$row["f_uid"] ]) ? 1 : 0;
    75. 

  75. 			$root_user_id = intval($row["f_uid"]);
    76. 

  76. 			$user_naming = html_specialchars($row["usr_name"]." (".$row["usr_login"].")");
    77. 

  77. 			$count = "<img src=\"img/leer.gif\" width=\"2\" height=\"1\">".
    78. 

  78. 					 "<a href=\"phpwcms.php?do=files&f=1&pklapp=u".$row["f_uid"].
    79. 

  79. 					 "|".$pklapp_status."\">".on_off($pklapp_status, "\n".$BL['be_fpublic_user'].": ".$user_naming, 0)."</a>";
    80. 

  80. 

  81. 			//Aufbau der Zeile mit den Benutzerinfos
    82. 

  82. 			if($user_counter) {
    83. 

  83. 				//Trennende blaue Tabellen-Zeile zwischen unterschiedlicghen Public Users
    84. 

  84. 				echo "<tr><td colspan=\"2\"><img src=\"img/lines/line-lightgrey-dotted-538.gif\" height=\"1\" width=\"538\"></td></tr>\n";
    85. 

  85. 				echo "<tr><td colspan=\"2\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\"></td></tr>\n";
    86. 

  86. 			}
    87. 

  87. 			echo "<tr bgcolor=\"#D8E4E9\"><td colspan=\"2\"><img src=\"img/leer.gif\" height=\"2\" width=\"1\"></td></tr>\n"; //Abstand vor
    88. 

  88. 			echo "<tr bgcolor=\"#D8E4E9\">\n"; //Einleitung Tabellenzeile
    89. 

  89. 			echo "<td width=\"488\" class=\"msglist\">"; //Einleiten der Tabellenzelle
    90. 

  90. 			echo $count."<img src=\"img/leer.gif\" height=\"1\" width=\"".($vor+6)."\" border=\"0\"><img src=\"img/icons/user_zu.gif\" border=\"0\">";
    91. 

  91. 			echo "<img src=\"img/leer.gif\" height=\"1\" width=\"5\"><strong>".$user_naming."</strong></td>\n"; //Schließen Zelle 1. Spalte
    92. 

  92. 			echo "<td width=\"50\" align=\"right\" class=\"msglist\">"; //Zelle 2. Spalte - vorgesehen für Buttons/Tasten Edit etc.
    93. 

  93. 			echo "<img src=\"img/leer.gif\" width=\"50\" height=\"1\">"; //Spacer
    94. 

  94. 			echo "</td>\n"; 
    95. 

  95. 			echo "</tr>\n"; //Abschluss Tabellenzeile
    96. 

  96. 			//Aufbau trennende Tabellen-Zeile  bgcolor:#EBF2F4
    97. 

  97. 			echo "<tr bgcolor=\"#D8E4E9\"><td colspan=\"2\"><img src=\"img/leer.gif\" height=\"2\" width=\"1\"></td></tr>\n"; //Abstand nach
    98. 

  98. 			echo "<tr><td colspan=\"2\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\"></td></tr>\n"; //Trennlinie
    99. 

  99. 

  100. 			if(!$pklapp_status) {
    101. 

  101. 				list_public(0, $db, 18, "phpwcms.php?do=files&f=1", $row["f_uid"], $_SESSION["wcs_user_thumb"], $phpwcms);
    102. 

  102. 

  103. 				//Root files anzeigen
    104. 

  104. 				$file_sql = "SELECT * FROM ".DB_PREPEND."phpwcms_file WHERE f_pid=0 AND f_uid=".$root_user_id.
    105. 

  105. 							" AND f_public=1 AND f_aktiv=1 AND f_kid=1 AND f_trash=0 ORDER BY f_name;";
    106. 

  106. 				if($file_result = mysql_query($file_sql, $db) or die ("error while listing files")) {
    107. 

  107. 					$file_durchlauf = 0;
    108. 

  108. 					while($file_row = mysql_fetch_array($file_result)) {
    109. 

  109. 						$filename = html_specialchars($file_row["f_name"]);
    110. 

  110. 						if(!$file_durchlauf) { //Aufbau der Zeile zum Einfließen der Filelisten-Tabelle
    111. 

  111. 							echo "<tr bgcolor=\"#F5F8F9\"><td colspan=\"2\"><table width=\"538\" border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\n"; 
    112. 

  112. 						} else {
    113. 

  113. 							echo "<tr bgcolor=\"#FFFFFF\"><td colspan=\"5\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\"></td></tr>\n";
    114. 

  114. 						}
    115. 

  115. 						echo "<tr>\n";
    116. 

  116. 						echo "<td width=\"37\" class=\"msglist\"><img src=\"img/leer.gif\" height=\"1\" width=\"37\" border=\"0\"></td>\n";
    117. 

  117. 						echo "<td width=\"13\" class=\"msglist\">";
    118. 

  118. 						echo "<img src=\"img/icons/small_".extimg($file_row["f_ext"])."\" border=\"0\"";
    119. 

  119. 						echo ' onmouseover="Tip(\'ID: '.$file_row["f_id"].'\');" onmouseout="UnTip()" alt=""';
    120. 

  120. 						echo "></td>\n";
    121. 

  121. 						echo "<td width=\"473\" class=\"msglist\"><img src=\"img/leer.gif\" height=\"1\" width=\"5\">"; //438-$vor
    122. 

  122. 						//echo "<a href=\"fileinfo_public.php?fid=".$file_row["f_id"];
    123. 

  123. 						echo "<a href=\"fileinfo.php?public&amp;fid=".$file_row["f_id"];
    124. 

  124. 						echo "\" target=\"_blank\" onclick=\"flevPopupLink(this.href,'filedetail','scrollbars=yes,resizable=yes,width=500,height=400',1);return document.MM_returnValue;\">";
    125. 

  125. 						echo $filename."</a>";
    126. 

  126. 

  127. 						echo "</td>\n";
    128. 

  128. 						echo "<td width=\"15\" align=\"right\" class=\"msglist\">";
    129. 

  129. 						echo "<a href=\"include/inc_act/act_download.php?pl=1&dl=".$file_row["f_id"];
    130. 

  130. 				 		echo "\" target=\"_blank\" title=\"".$BL['be_fprivfunc_dlfile'].": ".$filename."\">";
    131. 

  131. 	 					echo "<img src=\"img/button/download_disc.gif\" border=\"0\"></a>"; //target='_blank'
    132. 

  132. 						echo "<img src=\"img/leer.gif\" width=\"2\" height=\"1\">"; //Spacer
    133. 

  133. 						echo "</td>\n";
    134. 

  134. 						//Ende Aufbau
    135. 

  135. 						echo "</tr>\n";
    136. 

  136. 						
    137. 

  137. 						if($_SESSION["wcs_user_thumb"]) {
    138. 

  138. 			
    139. 

  139. 							$thumb_image = get_cached_image(
    140. 

  140. 			 					array(	"target_ext"	=>	$file_row["f_ext"],
    141. 

  141. 										"image_name"	=>	$file_row["f_hash"] . '.' . $file_row["f_ext"],
    142. 

  142. 										"thumb_name"	=>	md5($file_row["f_hash"].$phpwcms["img_list_width"].$phpwcms["img_list_height"].$phpwcms["sharpen_level"])
    143. 

  143.         							  )
    144. 

  144. 								);
    145. 

  145. 

  146. 							if($thumb_image != false) {
    147. 

  147. 							
    148. 

  148. 								echo "<tr>\n";
    149. 

  149. 								echo "<td width=\"37\"><img src=\"img/leer.gif\" height=\"1\" width=\"37\" border=\"0\"></td>\n";
    150. 

  150. 								echo "<td width=\"13\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\" border=\"0\"></td>\n<td width=\"";
    151. 

  151. 								echo "473\"><img src=\"img/leer.gif\" height=\"1\" width=\"6\"><a href=\"fileinfo.php?public&amp;fid=";
    152. 

  152. 								echo $file_row["f_id"]."\" target=\"_blank\" onclick=\"flevPopupLink(this.href,'filedetail','scrollbars=";
    153. 

  153. 								echo "yes,resizable=yes,width=500,height=400',1); return document.MM_returnValue;\">";
    154. 

  154. 								echo '<img src="'.PHPWCMS_IMAGES . $thumb_image[0] .'" border="0" '.$thumb_image[3]."></a></td>\n";	
    155. 

  155. 								echo "<td width=\"15\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\" border=\"0\"></td>\n</tr>\n";
    156. 

  156. 								echo "<tr><td colspan=\"4\"><img src=\"img/leer.gif\" height=\"2\" width=\"1\" border=\"0\"></td>\n</tr>\n";
    157. 

  157. 		
    158. 

  158. 							}
    159. 

  159. 				
    160. 

  160. 						}
    161. 

  161. 

  162. 						$file_durchlauf++;
    163. 

  163. 					}
    164. 

  164. 					if($file_durchlauf) { //Abschluss der Filelisten-Tabelle
    165. 

  165. 						echo "</table>\n";
    166. 

  166. 						echo "<tr><td colspan=\"2\"><img src=\"img/leer.gif\" height=\"1\" width=\"1\"></td></tr>\n";
    167. 

  167. 					}
    168. 

  168. 				} //Ende Liste Dateien
    169. 

  169. 

  170. 				//Ende Anzeige root files public
    171. 

  171. 			}
    172. 

  172. 			$user_counter++;
    173. 

  173. 		}
    174. 

  174. 	}
    175. 

  175. 	echo "</table>\n"; //Ende Tabelle
    176. 

  176. } else { //Wenn keinerlei Datensatz innerhalb Files durchlaufen wurde, dann
    177. 

  177. 	echo "<img src=\"img/leer.gif\" width=\"1\" height=\"6\"><br />".$BL['be_fpublic_nofiles']."&nbsp;&nbsp;";
    178. 

  178. 	echo "[<a href=\"phpwcms.php?do=files&f=0&mkdir=0\">".$BL['be_fpriv_button']."</a>]";
    179. 

  179. 	echo "<br /><img src=\"img/leer.gif\" width=\"1\" height=\"6\">";
    180. 

  180. }
    181. 

  181. ?>
    182.