PageRenderTime 23ms CodeModel.GetById 18ms RepoModel.GetById 0ms app.codeStats 0ms

/fileinfo.php

http://phpwcms.googlecode.com/
PHP | 212 lines | 178 code | 22 blank | 12 comment | 23 complexity | 84bd6fd34849b1d7b82c11f9cd2313a7 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. session_start();
    13. 

  13. 

  14. $phpwcms = array();
    15. 

  15. require_once ('config/phpwcms/conf.inc.php');
    16. 

  16. 

  17. if(empty($_SESSION["wcs_user_lang"])) {
    18. 

  18. 	session_destroy();
    19. 

  19. 	headerRedirect($phpwcms['site'].$phpwcms["root"]);
    20. 

  20. 

  21. } else {
    22. 

  22. 	require('include/inc_lang/backend/en/lang.ext.inc.php');
    23. 

  23. 	$cust_lang = 'include/inc_lang/backend/'.substr($_SESSION["wcs_user_lang"],0,2).'/lang.ext.inc.php';
    24. 

  24. 	if(is_file($cust_lang)) include($cust_lang);
    25. 

  25. }
    26. 

  26. require_once ('include/inc_lib/default.inc.php');
    27. 

  27. require_once (PHPWCMS_ROOT.'/include/inc_lib/dbcon.inc.php');
    28. 

  28. 

  29. require_once ("include/inc_lib/general.inc.php");
    30. 

  30. checkLogin();
    31. 

  31. require_once ("include/inc_lib/backend.functions.inc.php");
    32. 

  32. require_once ("include/inc_lib/imagick.convert.inc.php");
    33. 

  33. require_once ("include/inc_lib/autolink.inc.php");
    34. 

  34. 

  35. $file_id	= (isset($_GET["fid"])) ? intval($_GET["fid"]) : 0;
    36. 

  36. $public		= (isset($_GET["public"])) ? true : false;
    37. 

  37. 

  38. if($file_id) {
    39. 

  39. 

  40. 	$file_key = get_list_of_file_keywords();
    41. 

  41. 

  42. 	if($public) {
    43. 

  43. 		//public file
    44. 

  44. 		$sql  = "SELECT * FROM ".DB_PREPEND."phpwcms_file WHERE f_id=".$file_id." ";
    45. 

  45. 		$sql .= "AND f_kid=1 AND f_trash=0 AND f_aktiv=1 AND (f_public=1";
    46. 

  46. 		if(empty($_SESSION["wcs_user_admin"])) {
    47. 

  47. 			$sql .= " OR f_uid=".intval($_SESSION["wcs_user_id"]);
    48. 

  48. 		}
    49. 

  49. 		$sql .= ") LIMIT 1";
    50. 

  50. 	} else {
    51. 

  51. 		//private file
    52. 

  52. 		$sql  = "SELECT * FROM ".DB_PREPEND."phpwcms_file WHERE f_id=".$file_id.' AND ';
    53. 

  53. 		$sql .= "f_kid=1 AND f_trash IN (0, 1) ";
    54. 

  54. 		if(empty($_SESSION["wcs_user_admin"])) {
    55. 

  55. 			$sql .= "AND f_uid=".intval($_SESSION["wcs_user_id"]).' ';
    56. 

  56. 		}
    57. 

  57. 		$sql .= "LIMIT 1";
    58. 

  58. 	}
    59. 

  59. 	if($result = mysql_query($sql, $db) or die("error")) {
    60. 

  60. 		if($row = mysql_fetch_assoc($result)) {
    61. 

  61. 			$filename = html_specialchars($row["f_name"]);
    62. 

  62. 			
    63. 

  63. 			
    64. 

  64. 			$thumb_image = get_cached_image(
    65. 

  65. 					array(	"target_ext"	=>	$row["f_ext"],
    66. 

  66. 							"image_name"	=>	$row["f_hash"] . '.' . $row["f_ext"],
    67. 

  67. 							"thumb_name"	=>	md5($row["f_hash"].'538538'.$phpwcms["sharpen_level"]),
    68. 

  68. 							"max_width"		=>	538,
    69. 

  69. 							"max_height"	=>	538
    70. 

  70.         			)
    71. 

  71. 				);
    72. 

  72. 		
    73. 

  73. ?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
    74. 

  74. <html xmlns="http://www.w3.org/1999/xhtml">
    75. 

  75. <head>
    76. 

  76. 	<title><?php echo $BL['FILEINFO_TITLE'] ?>: <?php echo $filename ?></title>
    77. 

  77. 	<meta http-equiv="Content-Type" content="text/html; charset=<?php echo PHPWCMS_CHARSET ?>" />
    78. 

  78. 	<meta http-equiv="Expires" content="0" />
    79. 

  79. 	<meta http-equiv="Pragma" content="no-cache" />
    80. 

  80. 	<meta http-equiv="cache-control" content="no-cache" />
    81. 

  81. 	<meta name="robots" content="noindex, nofollow" />
    82. 

  82. 	<script src="include/inc_js/phpwcms.js" type="text/javascript"></script>
    83. 

  83. <?php
    84. 

  84. 	echo '	<script type="text/javascript">
    85. 

  85. 	function ResizeAndCenter(){
    86. 

  86. 		var width = 590;
    87. 

  87. 	';
    88. 

  88. 	if($thumb_image != false) {
    89. 

  89. 		echo '
    90. 

  90. 		var height = screen.availHeight;
    91. 

  91. 		if(height < 490) {
    92. 

  92. 			height=420;
    93. 

  93. 		} else {
    94. 

  94. 			height=570;
    95. 

  95. 		}
    96. 

  96. 	';
    97. 

  97. 	} else {
    98. 

  98. 		echo '	var height = 300;';
    99. 

  99. 	}
    100. 

  100. 	
    101. 

  101. 	echo '
    102. 

  102. 		window.moveTo(5,5);
    103. 

  103. 		window.resizeTo(width,height);
    104. 

  104. 	}
    105. 

  105. 		</script>
    106. 

  106. 	';
    107. 

    108. 

  108. ?>
    109. 

  109. 	
    110. 

  110. 	<link href="include/inc_css/phpwcms.css" rel="stylesheet" type="text/css" />
    111. 

  111. </head>
    112. 

  112. 

  113. <body onload="ResizeAndCenter();">
    114. 

  114. <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#C1D2E2" summary="">
    115. 

  115.   <tr bgcolor="#C1D2E2"><td colspan="4"><img src="img/leer.gif" alt="" width="1" height="8" /></td></tr>
    116. 

  116.   <tr bgcolor="#C1D2E2">
    117. 

  117.     <td width="10"><img src="img/leer.gif" alt="" width="10" height="1" /></td>
    118. 

  118.     <td width="20"><img src='img/icons/small_<?php echo extimg($row["f_ext"]) ?>' alt="" border="0" /></td>
    119. 

  119.     <td width="518" class="h14b"><strong><?php echo $filename ?></strong></td>
    120. 

  120.     <td width="10"><img src="img/leer.gif" alt="" width="10" height="1" /></td>
    121. 

  121.   </tr>
    122. 

  122.   <tr bgcolor="#C1D2E2"><td colspan="4"><img src="img/leer.gif" alt="" width="10" height="6" /></td></tr>
    123. 

  123.   <tr bgcolor="#363E57"><td colspan="4"><img src="img/leer.gif" alt="" width="1" height="1" /></td></tr>
    124. 

  124.   <tr><td colspan="4" bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
    125. 

  125.   <tr>
    126. 

  126.     <td bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="1" /></td>
    127. 

  127.     <td bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="1" /></td>
    128. 

  128.     <td bgcolor="#F5F8F9"><table width="518" border="0" cellpadding="0" cellspacing="0" summary="">
    129. 

  129.       <tr>
    130. 

  130.         <td width="422" class="v10"><?php echo $BL['CREATED'] ?>: <strong><?php echo date($BL['DATE_FORMAT'], intval($row["f_created"])) ?></strong>&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $BL['SIZE'] ?>: <strong><?php echo fsizelong($row["f_size"]) ?></strong></td>
    131. 

  131.         <td width="96" align="right"><?php 
    132. 

  132. 		if(!$row["f_trash"]) {
    133. 

  133. 		?><a href="include/inc_act/act_download.php?dl=<?php 
    134. 

  134. 		
    135. 

  135. 		echo $row["f_id"];
    136. 

  136. 		//download public file too
    137. 

  137. 		if($public) echo '&amp;pl=1';
    138. 

  138. 		
    139. 

  139. 		?>" target="_blank" title="<?php echo $BL['DOWNLOAD_FILE'].": ".$filename ?>"><img src="img/button/download_disc_large.gif" alt="" width="61" height="13" border="0" /></a><?php 
    140. 

  140. 		} else {
    141. 

  141. 		 echo "<img src=\"img/button/file_in_trash.gif\" width=\"61\" height=\"13\" border=\"0\" title=\"".$BL['FILE_IN_TRASH']."\">";
    142. 

  142. 		}
    143. 

  143. 		?><img src="img/leer.gif" alt="" width="9" height="1" /><img src="img/button/aktiv_12x13_<?php echo $row["f_aktiv"] ?>.gif" alt="" width="12" height="13" /><img src="img/button/public_12x13_<?php echo $row["f_public"] ?>.gif" alt="" width="12" height="13" /></td>
    144. 

  144.       </tr>
    145. 

  145.     </table></td>
    146. 

  146.     <td bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="1" /></td>
    147. 

  147.   </tr>
    148. 

  148.   <tr><td colspan="4" bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
    149. 

  149.   <tr><td colspan="4" bgcolor="#CDDEE4"><img src="img/leer.gif" alt="" width="1" height="1" /></td></tr>
    150. 

  150.   <tr><td colspan="4"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
    151. 

  151.   <tr>
    152. 

  152.     <td><img src="img/leer.gif" alt="" width="1" height="5" /></td>
    153. 

  153.     <td><img src="img/leer.gif" alt="" width="1" height="5" /></td>
    154. 

  154.     <td class="v10"><?php echo $BL['KEYWORDS'].": ".html_specialchars($row["f_shortinfo"].add_keywords_to_search ($file_key, $row["f_keywords"])) ?></td>
    155. 

  155.     <td><img src="img/leer.gif" alt="" width="1" height="5" /></td>
    156. 

  156.   </tr>
    157. 

  157.   <tr><td colspan="4"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
    158. 

  158. <?php
    159. 

  159. 

  160. 	if($thumb_image != false) {
    161. 

  161. ?>
    162. 

  162.   <tr><td colspan="4" bgcolor="#CDDEE4"><img src="img/leer.gif" alt="" width="1" height="1" /></td></tr>
    163. 

  163.   <tr><td colspan="4" bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
    164. 

  164.   <tr>
    165. 

  165.     <td bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="1" /></td>
    166. 

  166.     <td colspan="2" align="center" bgcolor="#F5F8F9"><?php
    167. 

  167. 	
    168. 

  168. 	echo '<img src="'.PHPWCMS_IMAGES . $thumb_image[0] .'" border="0" '.$thumb_image[3].'>';
    169. 

  169. 

  170. 	?></td>
    171. 

  171.     <td bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="5" /></td>
    172. 

  172.   </tr>
    173. 

  173.   <tr><td colspan="4" bgcolor="#F5F8F9"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
    174. 

  174. <?php 
    175. 

  175. 	} 
    176. 

  176. 	if($row["f_longinfo"]) {
    177. 

  177. ?>
    178. 

  178.   <tr><td colspan="4" bgcolor="#CDDEE4"><img src="img/leer.gif" alt="" width="1" height="1" /></td></tr>
    179. 

  179.   <tr><td colspan="4"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
    180. 

  180.   <tr>
    181. 

  181.     <td><img src="img/leer.gif" alt="" width="1" height="5" /></td>
    182. 

  182.     <td><img src="img/leer.gif" alt="" width="1" height="5" /></td>
    183. 

  183.     <td class="v10"><?php echo nl2br(auto_link(html_specialchars($row["f_longinfo"]))) ?></td>
    184. 

  184.     <td><img src="img/leer.gif" alt="" width="1" height="5" /></td>
    185. 

  185.   </tr>
    186. 

  186.   <tr><td colspan="4"><img src="img/leer.gif" alt="" width="1" height="5" /></td></tr>
    187. 

  187.   <?php } ?>
    188. 

  188.   <tr><td colspan="4" bgcolor="#CDDEE4"><img src="img/leer.gif" alt="" width="1" height="1" /></td></tr>
    189. 

  189.   <tr bgcolor="#EBF2F4">
    190. 

  190.     <td><img src="img/leer.gif" alt="" width="10" height="10" /></td>
    191. 

  191.     <td><img src="img/leer.gif" alt="" width="20" height="1" /></td>
    192. 

  192.     <td><img src="img/leer.gif" alt="" width="518" height="1" /></td>
    193. 

  193.     <td><img src="img/leer.gif" alt="" width="10" height="10" /></td>
    194. 

  194.   </tr>
    195. 

  195. </table>
    196. 

  196. </body>
    197. 

  197. </html>
    198. 

  198. <?php
    199. 

  199. 		} else {
    200. 

  200. 			$fehler = 1;
    201. 

  201. 		}
    202. 

  202. 	} else {
    203. 

  203. 		$fehler = 1;
    204. 

  204. 	}
    205. 

  205. } else {
    206. 

  206. 	$fehler = 1;
    207. 

  207. }
    208. 

  208. 

  209. if(isset($fehler)) {
    210. 

  210. 	echo $BL['DOWNLOAD_ERR3'];
    211. 

  211. }
    212. 

  212. ?>
    213.