PageRenderTime 31ms CodeModel.GetById 25ms RepoModel.GetById 0ms app.codeStats 1ms

/root/gallery/image_page.php

https://github.com/grotevoet/phpbb-gallery
PHP | 747 lines | 607 code | 81 blank | 59 comment | 161 complexity | 48d8e2ade424b0c77cf34d6feb41b944 MD5 | raw file
    

  1. <?php
    2. 

  2. /**
    3. 

  3. *
    4. 

  4. * @package phpBB Gallery
    5. 

  5. * @version $Id$
    6. 

  6. * @copyright (c) 2007 nickvergessen nickvergessen@gmx.de http://www.flying-bits.org
    7. 

  7. * @license http://opensource.org/licenses/gpl-license.php GNU Public License
    8. 

  8. *
    9. 

  9. */
    10. 

  10. 

  11. /**
    12. 

  12. * @ignore
    13. 

  13. */
    14. 

  14. 

  15. define('IN_PHPBB', true);
    16. 

  16. $phpEx = substr(strrchr(__FILE__, '.'), 1);
    17. 

  17. include('includes/root_path.' . $phpEx);
    18. 

  18. include($phpbb_root_path . 'common.' . $phpEx);
    19. 

  19. 

  20. phpbb_gallery::setup(array('mods/gallery', 'mods/exif_data'));
    21. 

  21. phpbb_gallery_url::_include('functions_display', 'phpbb');
    22. 

  22. 

  23. /**
    24. 

  24. * Filestructure:
    25. 

  25. *
    26. 

  26. * - Check the request and get image_data
    27. 

  27. * - Check the permissions and approval
    28. 

  28. * - Main work here...
    29. 

  29. * - Exif-Data
    30. 

  30. * - Rating
    31. 

  31. * - Posting comment
    32. 

  32. * - Listing comment
    33. 

  33. *
    34. 

  34. */
    35. 

  35. 

  36. /**
    37. 

  37. * Check the request and get image_data
    38. 

  38. */
    39. 

  39. $image_id = request_var('image_id', 0);
    40. 

  40. $image_data = phpbb_gallery_image::get_info($image_id);
    41. 

  41. 

  42. $album_id = $image_data['image_album_id'];
    43. 

  43. $album_data = phpbb_gallery_album::get_info($album_id);
    44. 

  44. 

  45. $user_id = $image_data['image_user_id'];
    46. 

  46. 

  47. if (!file_exists(phpbb_gallery_url::path('upload') . $image_data['image_filename']))
    48. 

  48. {
    49. 

  49. 	$sql = 'UPDATE ' . GALLERY_IMAGES_TABLE . ' 
    50. 

  50. 		SET image_filemissing = 1
    51. 

  51. 		WHERE image_id = ' . $image_id;
    52. 

  52. 	$db->sql_query($sql);
    53. 

  53. }
    54. 

  54. 

  55. /**
    56. 

  56. * Check the permissions and approval
    57. 

  57. */
    58. 

  58. if (!phpbb_gallery::$auth->acl_check('i_view', $album_id, $album_data['album_user_id']))
    59. 

  59. {
    60. 

  60. 	if (!$user->data['is_registered'])
    61. 

  61. 	{
    62. 

  62. 		login_box(phpbb_gallery_url::append_sid('relative', 'image_page', "album_id=$album_id&amp;image_id=$image_id"), $user->lang['LOGIN_INFO']);
    63. 

  63. 	}
    64. 

  64. 	else
    65. 

  65. 	{
    66. 

  66. 		trigger_error('NOT_AUTHORISED');
    67. 

  67. 	}
    68. 

  68. }
    69. 

  69. if (!phpbb_gallery::$auth->acl_check('m_status', $album_id, $album_data['album_user_id']) && ($image_data['image_status'] == phpbb_gallery_image::STATUS_UNAPPROVED))
    70. 

  70. {
    71. 

  71. 	trigger_error('NOT_AUTHORISED');
    72. 

  72. }
    73. 

  73. 

  74. // Build the navigation
    75. 

  75. phpbb_gallery_album::generate_nav($album_data);
    76. 

  76. // Salting the form...yumyum ...
    77. 

  77. add_form_key('gallery');
    78. 

  78. 

  79. /**
    80. 

  80. * Main work here...
    81. 

  81. */
    82. 

  82. // Increase the counter, as we load the image with increment-blocker from this site it's no problem.
    83. 

  83. // We also copy some parts from topic_views here
    84. 

  84. if (isset($user->data['session_page']) && !$user->data['is_bot'] && (strpos($user->data['session_page'], '&image_id=' . $image_id) === false || isset($user->data['session_created'])))
    85. 

  85. {
    86. 

  86. 	$sql = 'UPDATE ' . GALLERY_IMAGES_TABLE . ' 
    87. 

  87. 		SET image_view_count = image_view_count + 1
    88. 

  88. 		WHERE image_id = ' . $image_id;
    89. 

  89. 	$db->sql_query($sql);
    90. 

  90. }
    91. 

  91. 

  92. $image_approval_sql = ' AND image_status <> ' . phpbb_gallery_image::STATUS_UNAPPROVED;
    93. 

  93. if (phpbb_gallery::$auth->acl_check('m_status', $album_id, $album_data['album_user_id']))
    94. 

  94. {
    95. 

  95. 	$image_approval_sql = '';
    96. 

  96. }
    97. 

  97. 

  98. //$sort_days	= request_var('st', 0);
    99. 

  99. $sort_key	= request_var('sk', ($album_data['album_sort_key']) ? $album_data['album_sort_key'] : phpbb_gallery_config::get('default_sort_key'));
    100. 

  100. $sort_dir	= request_var('sd', ($album_data['album_sort_dir']) ? $album_data['album_sort_dir'] : phpbb_gallery_config::get('default_sort_dir'));
    101. 

  101. 

  102. $sort_by_sql = array('t' => 'image_time', 'n' => 'image_name_clean', 'u' => 'image_username_clean', 'vc' => 'image_view_count', 'ra' => 'image_rate_avg', 'r' => 'image_rates', 'c' => 'image_comments', 'lc' => 'image_last_comment');
    103. 

  103. $sql_sort_by = (isset($sort_by_sql[$sort_key])) ? $sort_by_sql[$sort_key] : $sort_by_sql['t'];
    104. 

  104. if ($sort_dir == 'd')
    105. 

  105. {
    106. 

  106. 	$sql_next_condition = '<';
    107. 

  107. 	$sql_next_ordering = 'DESC';
    108. 

  108. 	$sql_previous_condition = '>';
    109. 

  109. 	$sql_previous_ordering = 'ASC';
    110. 

  110. }
    111. 

  111. else
    112. 

  112. {
    113. 

  113. 	$sql_next_condition = '>';
    114. 

  114. 	$sql_next_ordering = 'ASC';
    115. 

  115. 	$sql_previous_condition = '<';
    116. 

  116. 	$sql_previous_ordering = 'DESC';
    117. 

  117. }
    118. 

  118. // Two sqls now, but much better performance!
    119. 

  119. // As we do not allow to duplicate images, we can relay on the id as second sort parameter
    120. 

  120. $sql = 'SELECT image_id, image_name
    121. 

  121. 	FROM ' . GALLERY_IMAGES_TABLE . '
    122. 

  122. 	WHERE image_album_id = ' . (int) $album_id . $image_approval_sql . "
    123. 

  123. 		AND (($sql_sort_by = '" . $db->sql_escape($image_data[$sql_sort_by]) . "' AND image_id $sql_next_condition {$image_id})
    124. 

  124. 		OR $sql_sort_by $sql_next_condition '" . $db->sql_escape($image_data[$sql_sort_by]) . "')
    125. 

  125. 	ORDER BY $sql_sort_by $sql_next_ordering";
    126. 

  126. $result = $db->sql_query_limit($sql, 1);
    127. 

  127. $next_data = $db->sql_fetchrow($result);
    128. 

  128. $db->sql_freeresult($result);
    129. 

  129. 

  130. $sql = 'SELECT image_id, image_name
    131. 

  131. 	FROM ' . GALLERY_IMAGES_TABLE . '
    132. 

  132. 	WHERE image_album_id = ' . (int) $album_id . $image_approval_sql . "
    133. 

  133. 		AND (($sql_sort_by = '" . $db->sql_escape($image_data[$sql_sort_by]) . "' AND image_id $sql_previous_condition {$image_id})
    134. 

  134. 		OR $sql_sort_by $sql_previous_condition '" . $db->sql_escape($image_data[$sql_sort_by]) . "')
    135. 

  135. 	ORDER BY $sql_sort_by $sql_previous_ordering";
    136. 

  136. $result = $db->sql_query_limit($sql, 1);
    137. 

  137. $previous_data = $db->sql_fetchrow($result);
    138. 

  138. $db->sql_freeresult($result);
    139. 

  139. 

  140. $s_allowed_delete = $s_allowed_edit = $s_allowed_status = false;
    141. 

  141. if ((phpbb_gallery::$auth->acl_check('m_', $album_id, $album_data['album_user_id']) || ($image_data['image_user_id'] == $user->data['user_id'])) && ($user->data['user_id'] != ANONYMOUS))
    142. 

  142. {
    143. 

  143. 	$s_user_allowed = (($image_data['image_user_id'] == $user->data['user_id']) && ($album_data['album_status'] != phpbb_gallery_album::STATUS_LOCKED));
    144. 

  144. 

  145. 	$s_allowed_delete = ((phpbb_gallery::$auth->acl_check('i_delete', $album_id, $album_data['album_user_id']) && $s_user_allowed) || phpbb_gallery::$auth->acl_check('m_delete', $album_id, $album_data['album_user_id']));
    146. 

  146. 	$s_allowed_edit = ((phpbb_gallery::$auth->acl_check('i_edit', $album_id, $album_data['album_user_id']) && $s_user_allowed) || phpbb_gallery::$auth->acl_check('m_edit', $album_id, $album_data['album_user_id']));
    147. 

  147. 	$s_allowed_status = phpbb_gallery::$auth->acl_check('m_status', $album_id, $album_data['album_user_id']);
    148. 

  148. 

  149. 	$s_quick_mod = ($s_allowed_delete || $s_allowed_edit || $s_allowed_status || phpbb_gallery::$auth->acl_check('m_move', $album_id, $album_data['album_user_id']));
    150. 

  150. 

  151. 	$user->add_lang('mods/gallery_mcp');
    152. 

  152. 	$template->assign_vars(array(
    153. 

  153. 		'S_MOD_ACTION'		=> phpbb_gallery_url::append_sid('mcp', "album_id=$album_id&amp;image_id=$image_id&amp;quickmod=1" /*&amp;redirect=" . urlencode(str_replace('&amp;', '&', $viewtopic_url))*/, true, $user->session_id),
    154. 

  154. 		'S_QUICK_MOD'		=> $s_quick_mod,
    155. 

  155. 		'S_QM_MOVE'			=> phpbb_gallery::$auth->acl_check('m_move', $album_id, $album_data['album_user_id']),
    156. 

  156. 		'S_QM_DELETE'		=> $s_allowed_delete,
    157. 

  157. 		'S_QM_REPORT'		=> phpbb_gallery::$auth->acl_check('m_report', $album_id, $album_data['album_user_id']),
    158. 

  158. 		'S_QM_STATUS'		=> phpbb_gallery::$auth->acl_check('m_status', $album_id, $album_data['album_user_id']),
    159. 

  159. 

  160. 		'S_IMAGE_REPORTED'		=> $image_data['image_reported'],
    161. 

  161. 		'U_IMAGE_REPORTED'		=> phpbb_gallery_url::append_sid('mcp', "mode=report_details&amp;album_id=$album_id&amp;option_id=" . $image_data['image_reported']),
    162. 

  162. 		'S_STATUS_APPROVED'		=> ($image_data['image_status'] == phpbb_gallery_image::STATUS_APPROVED),
    163. 

  163. 		'S_STATUS_UNAPPROVED'	=> ($image_data['image_status'] == phpbb_gallery_image::STATUS_UNAPPROVED),
    164. 

  164. 		'S_STATUS_LOCKED'		=> ($image_data['image_status'] == phpbb_gallery_image::STATUS_LOCKED),
    165. 

  165. 	));
    166. 

  166. }
    167. 

  167. 

  168. $template->assign_vars(array(
    169. 

  169. 	'U_VIEW_ALBUM'		=> phpbb_gallery_url::append_sid("album.$phpEx", "album_id=$album_id"),
    170. 

  170. 

  171. 	'UC_PREVIOUS_IMAGE'	=> (!empty($previous_data) && phpbb_gallery_config::get('disp_nextprev_thumbnail')) ? generate_image_link('thumbnail', 'image_page', $previous_data['image_id'], $previous_data['image_name'], $album_id) : '',
    172. 

  172. 	'UC_PREVIOUS'		=> (!empty($previous_data)) ? phpbb_gallery_image::generate_link('image_name_unbold', 'image_page_prev', $previous_data['image_id'], $previous_data['image_name'], $album_id) : '',
    173. 

  173. 	'UC_IMAGE'			=> phpbb_gallery_image::generate_link('medium', phpbb_gallery_config::get('link_imagepage'), $image_id, $image_data['image_name'], $album_id, ((substr($image_data['image_filename'], 0 -3) == 'gif') ? true : false), false),
    174. 

  174. 	'UC_NEXT_IMAGE'		=> (!empty($next_data) && phpbb_gallery_config::get('disp_nextprev_thumbnail')) ? generate_image_link('thumbnail', 'image_page', $next_data['image_id'], $next_data['image_name'], $album_id) : '',
    175. 

  175. 	'UC_NEXT'			=> (!empty($next_data)) ? phpbb_gallery_image::generate_link('image_name_unbold', 'image_page_next', $next_data['image_id'], $next_data['image_name'], $album_id) : '',
    176. 

  176. 

  177. 	'EDIT_IMG'			=> $user->img('icon_post_edit', 'EDIT_IMAGE'),
    178. 

  178. 	'DELETE_IMG'		=> $user->img('icon_post_delete', 'DELETE_IMAGE'),
    179. 

  179. 	'REPORT_IMG'		=> $user->img('icon_post_report', 'REPORT_IMAGE'),
    180. 

  180. 	'STATUS_IMG'		=> $user->img('icon_post_info', 'STATUS_IMAGE'),
    181. 

  181. 	'U_DELETE'			=> ($s_allowed_delete) ? phpbb_gallery_url::append_sid('posting', "mode=image&amp;submode=delete&amp;album_id=$album_id&amp;image_id=$image_id") : '',
    182. 

  182. 	'U_EDIT'			=> ($s_allowed_edit) ? phpbb_gallery_url::append_sid('posting', "mode=image&amp;submode=edit&amp;album_id=$album_id&amp;image_id=$image_id") : '',
    183. 

  183. 	'U_REPORT'			=> (phpbb_gallery::$auth->acl_check('i_report', $album_id, $album_data['album_user_id']) && ($image_data['image_user_id'] != $user->data['user_id'])) ? phpbb_gallery_url::append_sid('posting', "mode=image&amp;submode=report&amp;album_id=$album_id&amp;image_id=$image_id") : '',
    184. 

  184. 	'U_STATUS'			=> ($s_allowed_status) ? phpbb_gallery_url::append_sid('mcp', "mode=queue_details&amp;album_id=$album_id&amp;option_id=$image_id") : '',
    185. 

  185. 

  186. 	'CONTEST_RANK'		=> ($image_data['image_contest_rank']) ? $user->lang['CONTEST_RESULT_' . $image_data['image_contest_rank']] : '',
    187. 

  187. 	'IMAGE_NAME'		=> $image_data['image_name'],
    188. 

  188. 	'IMAGE_DESC'		=> generate_text_for_display($image_data['image_desc'], $image_data['image_desc_uid'], $image_data['image_desc_bitfield'], 7),
    189. 

  189. 	'IMAGE_BBCODE'		=> '[album]' . $image_id . '[/album]',
    190. 

  190. 	'IMAGE_IMGURL_BBCODE'	=> (phpbb_gallery_config::get('disp_image_url')) ? '[url=' . phpbb_gallery_url::path('full') . "image.$phpEx?album_id=$album_id&amp;image_id=$image_id" . '][img]' . generate_board_url(false) . '/' . phpbb_gallery_url::path('relative') . "image.$phpEx?album_id=$album_id&amp;image_id=$image_id&amp;mode=thumbnail" . '[/img][/url]' : '',
    191. 

  191. 	'IMAGE_URL'			=> (phpbb_gallery_config::get('disp_image_url')) ? phpbb_gallery_url::path('full') . "image.$phpEx?album_id=$album_id&amp;image_id=$image_id" : '',
    192. 

  192. 	'IMAGE_TIME'		=> $user->format_date($image_data['image_time']),
    193. 

  193. 	'IMAGE_VIEW'		=> $image_data['image_view_count'],
    194. 

  194. 

  195. 	'L_BOOKMARK_TOPIC'	=> ($image_data['favorite_id']) ? $user->lang['UNFAVORITE_IMAGE'] : $user->lang['FAVORITE_IMAGE'],
    196. 

  196. 	'U_BOOKMARK_TOPIC'	=> ($user->data['user_id'] != ANONYMOUS) ? phpbb_gallery_url::append_sid('posting', "mode=image&amp;submode=" . (($image_data['favorite_id']) ?  'un' : '') . "favorite&amp;album_id=$album_id&amp;image_id=$image_id") : '',
    197. 

  197. 	'L_WATCH_TOPIC'		=> ($image_data['watch_id']) ? $user->lang['UNWATCH_IMAGE'] : $user->lang['WATCH_IMAGE'],
    198. 

  198. 	'U_WATCH_TOPIC'		=> ($user->data['user_id'] != ANONYMOUS) ? phpbb_gallery_url::append_sid('posting', "mode=image&amp;submode=" . (($image_data['watch_id']) ?  'un' : '') . "watch&amp;album_id=$album_id&amp;image_id=$image_id") : '',
    199. 

  199. 	'S_WATCHING_TOPIC'	=> ($image_data['watch_id']) ? true : false,
    200. 

  200. 	'S_ALBUM_ACTION'	=> phpbb_gallery_url::append_sid('image_page', "album_id=$album_id&amp;image_id=$image_id"),
    201. 

  201. 

  202. 	'U_RETURN_LINK'		=> phpbb_gallery_url::append_sid('album', "album_id=$album_id"),
    203. 

  203. 	'S_RETURN_LINK'		=> $album_data['album_name'],
    204. 

  204. 	'S_JUMPBOX_ACTION'	=> phpbb_gallery_url::append_sid('album'),
    205. 

  205. 	'ALBUM_JUMPBOX'		=> phpbb_gallery_album::get_albumbox(false, '', $album_id),
    206. 

  206. ));
    207. 

  207. 

  208. /**
    209. 

  209. * Exif-Data
    210. 

  210. */
    211. 

  211. if (phpbb_gallery_config::get('disp_exifdata') && ($image_data['image_has_exif'] != phpbb_gallery_constants::EXIF_UNAVAILABLE) && (substr($image_data['image_filename'], -4) == '.jpg') && function_exists('exif_read_data') && (phpbb_gallery::$auth->acl_check('m_status', $album_id, $album_data['album_user_id']) || ($image_data['image_contest'] != phpbb_gallery_image::IN_CONTEST)))
    212. 

  212. {
    213. 

  213. 	if ($image_data['image_has_exif'] == phpbb_gallery_constants::EXIF_DBSAVED)
    214. 

  214. 	{
    215. 

  215. 		$exif = unserialize($image_data['image_exif_data']);
    216. 

  216. 	}
    217. 

  217. 	else
    218. 

  218. 	{
    219. 

  219. 		$image_tools = new phpbb_gallery_image_tools();
    220. 

  220. 		$image_tools->set_image_data(phpbb_gallery_url::path('upload') . $image_data['image_filename']);
    221. 

  221. 		$image_tools->read_exif_data();
    222. 

  222. 		$exif = $image_tools->exif_data;
    223. 

  223. 	}
    224. 

  224. 	if (!empty($exif["EXIF"]))
    225. 

  225. 	{
    226. 

  226. 		$exif_data = array();
    227. 

  227. 

  228. 		if (isset($exif["EXIF"]["DateTimeOriginal"]))
    229. 

  229. 		{
    230. 

  230. 			$timestamp_year = substr($exif["EXIF"]["DateTimeOriginal"], 0, 4);
    231. 

  231. 			$timestamp_month = substr($exif["EXIF"]["DateTimeOriginal"], 5, 2);
    232. 

  232. 			$timestamp_day = substr($exif["EXIF"]["DateTimeOriginal"], 8, 2);
    233. 

  233. 			$timestamp_hour = substr($exif["EXIF"]["DateTimeOriginal"], 11, 2);
    234. 

  234. 			$timestamp_minute = substr($exif["EXIF"]["DateTimeOriginal"], 14, 2);
    235. 

  235. 			$timestamp_second = substr($exif["EXIF"]["DateTimeOriginal"], 17, 2);
    236. 

  236. 			$timestamp = (int) @mktime($timestamp_hour, $timestamp_minute, $timestamp_second, $timestamp_month, $timestamp_day, $timestamp_year);
    237. 

  237. 			if ($timestamp)
    238. 

  238. 			{
    239. 

  239. 				$exif_data['exif_date'] = $user->format_date($timestamp + phpbb_gallery_constants::EXIFTIME_OFFSET);
    240. 

  240. 			}
    241. 

  241. 		}
    242. 

  242. 		if (isset($exif["EXIF"]["FocalLength"]))
    243. 

  243. 		{
    244. 

  244. 			list($num, $den) = explode("/", $exif["EXIF"]["FocalLength"]);
    245. 

  245. 			if ($den)
    246. 

  246. 			{
    247. 

  247. 				$exif_data['exif_focal'] = sprintf($user->lang['EXIF_FOCAL_EXP'], ($num / $den));
    248. 

  248. 			}
    249. 

  249. 		}
    250. 

  250. 		if (isset($exif["EXIF"]["ExposureTime"]))
    251. 

  251. 		{
    252. 

  252. 			list($num, $den) = explode("/", $exif["EXIF"]["ExposureTime"]);
    253. 

  253. 			$exif_exposure = '';
    254. 

  254. 			if (($num > $den) && $den)
    255. 

  255. 			{
    256. 

  256. 				$exif_exposure = $num / $den;
    257. 

  257. 			}
    258. 

  258. 			else if ($num)
    259. 

  259. 			{
    260. 

  260. 				$exif_exposure = ' 1/' . $den / $num ;
    261. 

  261. 			}
    262. 

  262. 			if ($exif_exposure)
    263. 

  263. 			{
    264. 

  264. 				$exif_data['exif_exposure'] = sprintf($user->lang['EXIF_EXPOSURE_EXP'], $exif_exposure);
    265. 

  265. 			}
    266. 

  266. 		}
    267. 

  267. 		if (isset($exif["EXIF"]["FNumber"]))
    268. 

  268. 		{
    269. 

  269. 			list($num,$den) = explode("/",$exif["EXIF"]["FNumber"]);
    270. 

  270. 			if ($den)
    271. 

  271. 			{
    272. 

  272. 				$exif_data['exif_aperture'] = "F/" . ($num / $den);
    273. 

  273. 			}
    274. 

  274. 		}
    275. 

  275. 		if (isset($exif["EXIF"]["ISOSpeedRatings"]) && !is_array($exif["EXIF"]["ISOSpeedRatings"]))
    276. 

  276. 		{
    277. 

  277. 			$exif_data['exif_iso'] = $exif["EXIF"]["ISOSpeedRatings"];
    278. 

  278. 		}
    279. 

  279. 		if (isset($exif["EXIF"]["WhiteBalance"]))
    280. 

  280. 		{
    281. 

  281. 			$exif_data['exif_whiteb'] = $user->lang['EXIF_WHITEB_' . (($exif["EXIF"]["WhiteBalance"]) ? 'MANU' : 'AUTO')];
    282. 

  282. 		}
    283. 

  283. 		if (isset($exif["EXIF"]["Flash"]))
    284. 

  284. 		{
    285. 

  285. 			if (isset($user->lang['EXIF_FLASH_CASE_' . $exif["EXIF"]["Flash"]]))
    286. 

  286. 			{
    287. 

  287. 				$exif_data['exif_flash'] = $user->lang['EXIF_FLASH_CASE_' . $exif["EXIF"]["Flash"]];
    288. 

  288. 			}
    289. 

  289. 		}
    290. 

  290. 		if (isset($exif["IFD0"]["Model"]))
    291. 

  291. 		{
    292. 

  292. 			$exif_data['exif_cam_model'] = ucwords($exif["IFD0"]["Model"]);
    293. 

  293. 		}
    294. 

  294. 		if (isset($exif["EXIF"]["ExposureProgram"]))
    295. 

  295. 		{
    296. 

  296. 			if (isset($user->lang['EXIF_EXPOSURE_PROG_' . $exif["EXIF"]["ExposureProgram"]]))
    297. 

  297. 			{
    298. 

  298. 				$exif_data['exif_exposure_prog'] = $user->lang['EXIF_EXPOSURE_PROG_' . $exif["EXIF"]["ExposureProgram"]];
    299. 

  299. 			}
    300. 

  300. 		}
    301. 

  301. 		if (isset($exif["EXIF"]["ExposureBiasValue"]))
    302. 

  302. 		{
    303. 

  303. 			list($num,$den) = explode("/", $exif["EXIF"]["ExposureBiasValue"]);
    304. 

  304. 			if ($den)
    305. 

  305. 			{
    306. 

  306. 				if (($num / $den) == 0)
    307. 

  307. 				{
    308. 

  308. 					$exif_exposure_bias = 0;
    309. 

  309. 				}
    310. 

  310. 				else
    311. 

  311. 				{
    312. 

  312. 					$exif_exposure_bias = $exif["EXIF"]["ExposureBiasValue"];
    313. 

  313. 				}
    314. 

  314. 				$exif_data['exif_exposure_bias'] = sprintf($user->lang['EXIF_EXPOSURE_BIAS_EXP'], $exif_exposure_bias);
    315. 

  315. 			}
    316. 

  316. 		}
    317. 

  317. 		if (isset($exif["EXIF"]["MeteringMode"]))
    318. 

  318. 		{
    319. 

  319. 			if (isset($user->lang['EXIF_METERING_MODE_' . $exif["EXIF"]["MeteringMode"]]))
    320. 

  320. 			{
    321. 

  321. 				$exif_data['exif_metering_mode'] = $user->lang['EXIF_METERING_MODE_' . $exif["EXIF"]["MeteringMode"]];
    322. 

  322. 			}
    323. 

  323. 		}
    324. 

  324. 

  325. 		if (sizeof($exif_data))
    326. 

  326. 		{
    327. 

  327. 			foreach ($exif_data as $exif => $value)
    328. 

  328. 			{
    329. 

  329. 				$template->assign_block_vars('exif_value', array(
    330. 

  330. 					'EXIF_NAME'			=> $user->lang[strtoupper($exif)],
    331. 

  331. 					'EXIF_VALUE'		=> htmlspecialchars($value),
    332. 

  332. 				));
    333. 

  333. 			}
    334. 

  334. 			$template->assign_vars(array(
    335. 

  335. 				'S_EXIF_DATA'	=> true,
    336. 

  336. 				'S_VIEWEXIF'	=> $user->gallery['user_viewexif'],
    337. 

  337. 			));
    338. 

  338. 

  339. 			if ($image_data['image_has_exif'] == phpbb_gallery_constants::EXIF_UNKNOWN)
    340. 

  340. 			{
    341. 

  341. 				$sql = 'UPDATE ' . GALLERY_IMAGES_TABLE . '
    342. 

  342. 					SET image_has_exif = ' . phpbb_gallery_constants::EXIF_AVAILABLE . '
    343. 

  343. 					WHERE image_id = ' . $image_id;
    344. 

  344. 				$db->sql_query($sql);
    345. 

  345. 			}
    346. 

  346. 		}
    347. 

  347. 	}
    348. 

  348. 	else
    349. 

  349. 	{
    350. 

  350. 		$sql = 'UPDATE ' . GALLERY_IMAGES_TABLE . '
    351. 

  351. 			SET image_has_exif = ' . phpbb_gallery_constants::EXIF_UNAVAILABLE . '
    352. 

  352. 			WHERE image_id = ' . $image_id;
    353. 

  353. 		$db->sql_query($sql);
    354. 

  354. 	}
    355. 

  355. }
    356. 

  356. 

  357. /**
    358. 

  358. * Rating
    359. 

  359. */
    360. 

  360. if (phpbb_gallery_config::get('allow_rates'))
    361. 

  361. {
    362. 

  362. 	$allowed_to_rate = $your_rating = $contest_rating_msg = $contest_result_hidden = false;
    363. 

  363. 

  364. 	if ($user->data['is_registered'])
    365. 

  365. 	{
    366. 

  366. 		$sql = 'SELECT *
    367. 

  367. 			FROM ' . GALLERY_RATES_TABLE . '
    368. 

  368. 			WHERE rate_image_id = ' . $image_id . '
    369. 

  369. 				AND rate_user_id = ' . (int) $user->data['user_id'];
    370. 

  370. 		$result = $db->sql_query($sql);
    371. 

  371. 

  372. 		if ($db->sql_affectedrows($result) > 0)
    373. 

  373. 		{
    374. 

  374. 			$rated = $db->sql_fetchrow($result);
    375. 

  375. 			$your_rating = $rated['rate_point'];
    376. 

  376. 		}
    377. 

  377. 		$db->sql_freeresult($result);
    378. 

  378. 	}
    379. 

  379. 	// Hide the result, while still rating on contests
    380. 

  380. 	if ($image_data['image_contest'])
    381. 

  381. 	{
    382. 

  382. 		$contest_result_hidden = sprintf($user->lang['CONTEST_RESULT_HIDDEN'], $user->format_date(($album_data['contest_start'] + $album_data['contest_end']), false, true));
    383. 

  383. 	}
    384. 

  384. 

  385. 	// Check: User didn't rate yet, has permissions, it's not the users own image and the user is logged in
    386. 

  386. 	if (!$your_rating && phpbb_gallery::$auth->acl_check('i_rate', $album_id, $album_data['album_user_id']) && ($user->data['user_id'] != $image_data['image_user_id']) && ($user->data['user_id'] != ANONYMOUS) && ($album_data['album_status'] != phpbb_gallery_album::STATUS_LOCKED) && ($image_data['image_status'] != phpbb_gallery_image::STATUS_LOCKED))
    387. 

  387. 	{
    388. 

  388. 		$hide_rate = false;
    389. 

  389. 		if ($album_data['contest_id'])
    390. 

  390. 		{
    391. 

  391. 			if (time() < ($album_data['contest_start'] + $album_data['contest_rating']))
    392. 

  392. 			{
    393. 

  393. 				$hide_rate = true;
    394. 

  394. 				$contest_rating_msg = sprintf($user->lang['CONTEST_RATING_STARTS'], $user->format_date(($album_data['contest_start'] + $album_data['contest_rating']), false, true));
    395. 

  395. 			}
    396. 

  396. 			if (($album_data['contest_start'] + $album_data['contest_end']) < time())
    397. 

  397. 			{
    398. 

  398. 				$hide_rate = true;
    399. 

  399. 				$contest_rating_msg = sprintf($user->lang['CONTEST_RATING_ENDED'], $user->format_date(($album_data['contest_start'] + $album_data['contest_end']), false, true));
    400. 

  400. 			}
    401. 

  401. 		}
    402. 

  402. 		if (!$hide_rate)
    403. 

  403. 		{
    404. 

  404. 			for ($rate_scale = 1; $rate_scale <= phpbb_gallery_config::get('max_rating'); $rate_scale++)
    405. 

  405. 			{
    406. 

  406. 				$template->assign_block_vars('rate_scale', array(
    407. 

  407. 					'RATE_POINT'	=> $rate_scale,
    408. 

  408. 				));
    409. 

  409. 			}
    410. 

  410. 		}
    411. 

  411. 		$allowed_to_rate = true;
    412. 

  412. 	}
    413. 

  413. 	$template->assign_vars(array(
    414. 

  414. 		'IMAGE_RATING'			=> ($image_data['image_rates'] != 0) ? sprintf((($image_data['image_rates'] == 1) ? $user->lang['RATE_STRING'] : $user->lang['RATES_STRING']), $image_data['image_rate_avg'] / 100, $image_data['image_rates']) : $user->lang['NOT_RATED'],
    415. 

  415. 		'S_YOUR_RATING'			=> $your_rating,
    416. 

  416. 		'S_ALLOWED_TO_RATE'		=> $allowed_to_rate,
    417. 

  417. 		'CONTEST_RATING'		=> $contest_rating_msg,
    418. 

  418. 		'CONTEST_RESULT_HIDDEN'	=> $contest_result_hidden,
    419. 

  419. 		'S_VIEW_RATE'			=> (phpbb_gallery::$auth->acl_check('i_rate', $album_id, $album_data['album_user_id'])) ? true : false,
    420. 

  420. 		'S_COMMENT_ACTION'		=> phpbb_gallery_url::append_sid('posting', "album_id=$album_id&amp;image_id=$image_id&amp;mode=comment&amp;submode=rate"),
    421. 

  421. 	));
    422. 

  422. }
    423. 

  423. 

  424. /**
    425. 

  425. * Posting comment
    426. 

  426. */
    427. 

  427. if (phpbb_gallery_config::get('allow_comments') && phpbb_gallery::$auth->acl_check('c_post', $album_id, $album_data['album_user_id']) && ($album_data['album_status'] != ITEM_LOCKED) && (($image_data['image_status'] != phpbb_gallery_image::STATUS_LOCKED) || phpbb_gallery::$auth->acl_check('m_status', $album_id, $album_data['album_user_id'])))
    428. 

  428. {
    429. 

  429. 	$user->add_lang('posting');
    430. 

  430. 	phpbb_gallery_url::_include('functions_posting', 'phpbb');
    431. 

  431. 

  432. 	$bbcode_status	= ($config['allow_bbcode']) ? true : false;
    433. 

  433. 	$smilies_status	= ($config['allow_smilies']) ? true : false;
    434. 

  434. 	$img_status		= ($bbcode_status) ? true : false;
    435. 

  435. 	$url_status		= ($config['allow_post_links']) ? true : false;
    436. 

  436. 	$flash_status	= false;
    437. 

  437. 	$quote_status	= true;
    438. 

  438. 

  439. 	// Build custom bbcodes array
    440. 

  440. 	display_custom_bbcodes();
    441. 

  441. 

  442. 	// Build smilies array
    443. 

  443. 	generate_smilies('inline', 0);
    444. 

  444. 

  445. 	$s_hide_comment_input = (time() < ($album_data['contest_start'] + $album_data['contest_end'])) ? true : false;
    446. 

  446. 

  447. 	$template->assign_vars(array(
    448. 

  448. 		'S_ALLOWED_TO_COMMENT'	=> true,
    449. 

  449. 		'S_HIDE_COMMENT_INPUT'	=> $s_hide_comment_input,
    450. 

  450. 		'CONTEST_COMMENTS'		=> sprintf($user->lang['CONTEST_COMMENTS_STARTS'], $user->format_date(($album_data['contest_start'] + $album_data['contest_end']), false, true)),
    451. 

  451. 

  452. 		'BBCODE_STATUS'			=> ($bbcode_status) ? sprintf($user->lang['BBCODE_IS_ON'], '<a href="' . phpbb_gallery_url::append_sid('phpbb', 'faq', 'mode=bbcode') . '">', '</a>') : sprintf($user->lang['BBCODE_IS_OFF'], '<a href="' . phpbb_gallery_url::append_sid('phpbb', 'faq', 'mode=bbcode') . '">', '</a>'),
    453. 

  453. 		'IMG_STATUS'			=> ($img_status) ? $user->lang['IMAGES_ARE_ON'] : $user->lang['IMAGES_ARE_OFF'],
    454. 

  454. 		'FLASH_STATUS'			=> ($flash_status) ? $user->lang['FLASH_IS_ON'] : $user->lang['FLASH_IS_OFF'],
    455. 

  455. 		'SMILIES_STATUS'		=> ($smilies_status) ? $user->lang['SMILIES_ARE_ON'] : $user->lang['SMILIES_ARE_OFF'],
    456. 

  456. 		'URL_STATUS'			=> ($bbcode_status && $url_status) ? $user->lang['URL_IS_ON'] : $user->lang['URL_IS_OFF'],
    457. 

  457. 

  458. 		'S_BBCODE_ALLOWED'		=> $bbcode_status,
    459. 

  459. 		'S_SMILIES_ALLOWED'		=> $smilies_status,
    460. 

  460. 		'S_LINKS_ALLOWED'		=> $url_status,
    461. 

  461. 		'S_BBCODE_IMG'			=> $img_status,
    462. 

  462. 		'S_BBCODE_URL'			=> $url_status,
    463. 

  463. 		'S_BBCODE_FLASH'		=> $flash_status,
    464. 

  464. 		'S_BBCODE_QUOTE'		=> $quote_status,
    465. 

  465. 		'L_COMMENT_LENGTH'		=> sprintf($user->lang['COMMENT_LENGTH'], phpbb_gallery_config::get('comment_length')),
    466. 

  466. 	));
    467. 

  467. 

  468. 	if (phpbb_gallery_misc::display_captcha('comment'))
    469. 

  469. 	{
    470. 

  470. 		// Get the captcha instance
    471. 

  471. 		phpbb_gallery_url::_include('captcha/captcha_factory', 'phpbb');
    472. 

  472. 		$captcha =& phpbb_captcha_factory::get_instance($config['captcha_plugin']);
    473. 

  473. 		$captcha->init(CONFIRM_POST);
    474. 

  474. 

  475. 		$template->assign_vars(array(
    476. 

  476. 			'S_CONFIRM_CODE'		=> true,
    477. 

  477. 			'CAPTCHA_TEMPLATE'		=> $captcha->get_template(),
    478. 

  478. 		));
    479. 

  479. 	}
    480. 

  480. 

  481. 	// Different link, when we rate and dont comment
    482. 

  482. 	if (!$s_hide_comment_input)
    483. 

  483. 	{
    484. 

  484. 		$template->assign_var('S_COMMENT_ACTION', phpbb_gallery_url::append_sid('posting', "album_id=$album_id&amp;image_id=$image_id&amp;mode=comment&amp;submode=add"));
    485. 

  485. 	}
    486. 

  486. }
    487. 

  487. 

  488. 

  489. /**
    490. 

  490. * Listing comment
    491. 

  491. */
    492. 

  492. if ((phpbb_gallery_config::get('allow_comments') && phpbb_gallery::$auth->acl_check('c_read', $album_id, $album_data['album_user_id'])) && (time() > ($album_data['contest_start'] + $album_data['contest_end'])))
    493. 

  493. {
    494. 

  494. 	$user->add_lang('viewtopic');
    495. 

  495. 	$start = request_var('start', 0);
    496. 

  496. 	$sort_order = (request_var('sort_order', 'ASC') == 'ASC') ? 'ASC' : 'DESC';
    497. 

  497. 	$template->assign_vars(array(
    498. 

  498. 		'S_ALLOWED_READ_COMMENTS'	=> true,
    499. 

  499. 		'IMAGE_COMMENTS'			=> $image_data['image_comments'],
    500. 

  500. 		'SORT_ASC'					=> ($sort_order == 'ASC') ? true : false,
    501. 

  501. 	));
    502. 

  502. 

  503. 	if ($image_data['image_comments'] > 0)
    504. 

  504. 	{
    505. 

  505. 		if (!class_exists('bbcode'))
    506. 

  506. 		{
    507. 

  507. 			phpbb_gallery_url::_include('bbcode', 'phpbb');
    508. 

  508. 		}
    509. 

  509. 		$bbcode = new bbcode();
    510. 

  510. 

  511. 		$comments = $users = $user_cache = array();
    512. 

  512. 		$users[] = $image_data['image_user_id'];
    513. 

  513. 		$sql = 'SELECT *
    514. 

  514. 			FROM ' . GALLERY_COMMENTS_TABLE . '
    515. 

  515. 			WHERE comment_image_id = ' . $image_id . '
    516. 

  516. 			ORDER BY comment_id ' . $sort_order;
    517. 

  517. 		$result = $db->sql_query_limit($sql, $config['posts_per_page'], $start);
    518. 

  518. 

  519. 		while ($row = $db->sql_fetchrow($result))
    520. 

  520. 		{
    521. 

  521. 			$comments[] = $row;
    522. 

  522. 			$users[] = $row['comment_user_id'];
    523. 

  523. 			if ($row['comment_edit_count'] > 0)
    524. 

  524. 			{
    525. 

  525. 				$users[] = $row['comment_edit_user_id'];
    526. 

  526. 			}
    527. 

  527. 		}
    528. 

  528. 		$db->sql_freeresult($result);
    529. 

  529. 

  530. 		$users = array_unique($users);
    531. 

  531. 		$sql = $db->sql_build_query('SELECT', array(
    532. 

  532. 			'SELECT'	=> 'u.*, gu.personal_album_id, gu.user_images',
    533. 

  533. 			'FROM'		=> array(USERS_TABLE => 'u'),
    534. 

  534. 

  535. 			'LEFT_JOIN'	=> array(
    536. 

  536. 				array(
    537. 

  537. 					'FROM'	=> array(GALLERY_USERS_TABLE => 'gu'),
    538. 

  538. 					'ON'	=> 'gu.user_id = u.user_id'
    539. 

  539. 				),
    540. 

  540. 			),
    541. 

  541. 

  542. 			'WHERE'		=> $db->sql_in_set('u.user_id', $users),
    543. 

  543. 		));
    544. 

  544. 		$result = $db->sql_query($sql);
    545. 

  545. 

  546. 		while ($row = $db->sql_fetchrow($result))
    547. 

  547. 		{
    548. 

  548. 			phpbb_gallery_user::add_user_to_user_cache($user_cache, $row);
    549. 

  549. 		}
    550. 

  550. 		$db->sql_freeresult($result);
    551. 

  551. 

  552. 		if ($config['load_onlinetrack'] && sizeof($users))
    553. 

  553. 		{
    554. 

  554. 			// Load online-information
    555. 

  555. 			$sql = 'SELECT session_user_id, MAX(session_time) as online_time, MIN(session_viewonline) AS viewonline
    556. 

  556. 				FROM ' . SESSIONS_TABLE . '
    557. 

  557. 				WHERE ' . $db->sql_in_set('session_user_id', $users) . '
    558. 

  558. 				GROUP BY session_user_id';
    559. 

  559. 			$result = $db->sql_query($sql);
    560. 

  560. 

  561. 			$update_time = $config['load_online_time'] * 60;
    562. 

  562. 			while ($row = $db->sql_fetchrow($result))
    563. 

  563. 			{
    564. 

  564. 				$user_cache[$row['session_user_id']]['online'] = (time() - $update_time < $row['online_time'] && (($row['viewonline']) || $auth->acl_get('u_viewonline'))) ? true : false;
    565. 

  565. 			}
    566. 

  566. 			$db->sql_freeresult($result);
    567. 

  567. 		}
    568. 

  568. 

  569. 		foreach ($comments as $row)
    570. 

  570. 		{
    571. 

  571. 			$edit_info = '';
    572. 

  572. 			if ($row['comment_edit_count'] > 0)
    573. 

  573. 			{
    574. 

  574. 				$edit_info = ($row['comment_edit_count'] == 1) ? $user->lang['EDITED_TIME_TOTAL'] : $user->lang['EDITED_TIMES_TOTAL'];
    575. 

  575. 				$edit_info = sprintf($edit_info, get_username_string('full', $user_cache[$row['comment_edit_user_id']]['user_id'], $user_cache[$row['comment_edit_user_id']]['username'], $user_cache[$row['comment_edit_user_id']]['user_colour']), $user->format_date($row['comment_edit_time'], false, true), $row['comment_edit_count']);
    576. 

  576. 			}
    577. 

  577. 

  578. 			$user_id = $row['comment_user_id'];
    579. 

  579. 			if ($user_cache[$user_id]['sig'] && empty($user_cache[$user_id]['sig_parsed']))
    580. 

  580. 			{
    581. 

  581. 				$user_cache[$user_id]['sig'] = censor_text($user_cache[$user_id]['sig']);
    582. 

  582. 

  583. 				if ($user_cache[$user_id]['sig_bbcode_bitfield'])
    584. 

  584. 				{
    585. 

  585. 					$bbcode->bbcode_second_pass($user_cache[$user_id]['sig'], $user_cache[$user_id]['sig_bbcode_uid'], $user_cache[$user_id]['sig_bbcode_bitfield']);
    586. 

  586. 				}
    587. 

  587. 

  588. 				$user_cache[$user_id]['sig'] = bbcode_nl2br($user_cache[$user_id]['sig']);
    589. 

  589. 				$user_cache[$user_id]['sig'] = smiley_text($user_cache[$user_id]['sig']);
    590. 

  590. 				$user_cache[$user_id]['sig_parsed'] = true;
    591. 

  591. 			}
    592. 

  592. 

  593. 			$template->assign_block_vars('commentrow', array(
    594. 

  594. 				'U_COMMENT'		=> phpbb_gallery_url::append_sid('image_page', "album_id=$album_id&amp;image_id=$image_id&amp;start=$start&amp;sort_order=$sort_order") . '#' . $row['comment_id'],
    595. 

  595. 				'COMMENT_ID'	=> $row['comment_id'],
    596. 

  596. 				'TIME'			=> $user->format_date($row['comment_time']),
    597. 

  597. 				'TEXT'			=> generate_text_for_display($row['comment'], $row['comment_uid'], $row['comment_bitfield'], 7),
    598. 

  598. 				'EDIT_INFO'		=> $edit_info,
    599. 

  599. 				'U_DELETE'		=> (phpbb_gallery::$auth->acl_check('m_comments', $album_id, $album_data['album_user_id']) || (phpbb_gallery::$auth->acl_check('c_delete', $album_id, $album_data['album_user_id']) && ($row['comment_user_id'] == $user->data['user_id']) && $user->data['is_registered'])) ? phpbb_gallery_url::append_sid('posting', "album_id=$album_id&amp;image_id=$image_id&amp;mode=comment&amp;submode=delete&amp;comment_id=" . $row['comment_id']) : '',
    600. 

  600. 				'U_EDIT'		=> (phpbb_gallery::$auth->acl_check('m_comments', $album_id, $album_data['album_user_id']) || (phpbb_gallery::$auth->acl_check('c_edit', $album_id, $album_data['album_user_id']) && ($row['comment_user_id'] == $user->data['user_id']) && $user->data['is_registered'])) ? phpbb_gallery_url::append_sid('posting', "album_id=$album_id&amp;image_id=$image_id&amp;mode=comment&amp;submode=edit&amp;comment_id=" . $row['comment_id']) : '',
    601. 

  601. 				'U_INFO'		=> ($auth->acl_get('a_')) ? phpbb_gallery_url::append_sid('mcp', 'mode=whois&amp;ip=' . $row['comment_user_ip']) : '',
    602. 

  602. 

  603. 				'POST_AUTHOR_FULL'		=> get_username_string('full', $user_id, $row['comment_username'], $user_cache[$user_id]['user_colour']),
    604. 

  604. 				'POST_AUTHOR_COLOUR'	=> get_username_string('colour', $user_id, $row['comment_username'], $user_cache[$user_id]['user_colour']),
    605. 

  605. 				'POST_AUTHOR'			=> get_username_string('username', $user_id, $row['comment_username'], $user_cache[$user_id]['user_colour']),
    606. 

  606. 				'U_POST_AUTHOR'			=> get_username_string('profile', $user_id, $row['comment_username'], $user_cache[$user_id]['user_colour']),
    607. 

  607. 

  608. 				'SIGNATURE'			=> $user_cache[$user_id]['sig'],
    609. 

  609. 				'RANK_TITLE'		=> $user_cache[$user_id]['rank_title'],
    610. 

  610. 				'RANK_IMG'			=> $user_cache[$user_id]['rank_image'],
    611. 

  611. 				'RANK_IMG_SRC'		=> $user_cache[$user_id]['rank_image_src'],
    612. 

  612. 				'POSTER_JOINED'		=> $user_cache[$user_id]['joined'],
    613. 

  613. 				'POSTER_POSTS'		=> $user_cache[$user_id]['posts'],
    614. 

  614. 				'POSTER_FROM'		=> $user_cache[$user_id]['from'],
    615. 

  615. 				'POSTER_AVATAR'		=> $user_cache[$user_id]['avatar'],
    616. 

  616. 				'POSTER_WARNINGS'	=> $user_cache[$user_id]['warnings'],
    617. 

  617. 				'POSTER_AGE'		=> $user_cache[$user_id]['age'],
    618. 

  618. 

  619. 				'ICQ_STATUS_IMG'	=> $user_cache[$user_id]['icq_status_img'],
    620. 

  620. 				'ONLINE_IMG'		=> ($user_id == ANONYMOUS || !$config['load_onlinetrack']) ? '' : (($user_cache[$user_id]['online']) ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')),
    621. 

  621. 				'S_ONLINE'			=> ($user_id == ANONYMOUS || !$config['load_onlinetrack']) ? false : (($user_cache[$user_id]['online']) ? true : false),
    622. 

  622. 

  623. 				'U_PROFILE'		=> $user_cache[$user_id]['profile'],
    624. 

  624. 				'U_SEARCH'		=> $user_cache[$user_id]['search'],
    625. 

  625. 				'U_PM'			=> ($user_id != ANONYMOUS && $config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_cache[$user_id]['allow_pm'] || $auth->acl_gets('a_', 'm_'))) ? phpbb_gallery_url::append_sid('phpbb', 'ucp', 'i=pm&amp;mode=compose&amp;u=' . $user_id) : '',
    626. 

  626. 				'U_EMAIL'		=> $user_cache[$user_id]['email'],
    627. 

  627. 				'U_WWW'			=> $user_cache[$user_id]['www'],
    628. 

  628. 				'U_ICQ'			=> $user_cache[$user_id]['icq'],
    629. 

  629. 				'U_AIM'			=> $user_cache[$user_id]['aim'],
    630. 

  630. 				'U_MSN'			=> $user_cache[$user_id]['msn'],
    631. 

  631. 				'U_YIM'			=> $user_cache[$user_id]['yim'],
    632. 

  632. 				'U_JABBER'		=> $user_cache[$user_id]['jabber'],
    633. 

  633. 

  634. 				'U_GALLERY'			=> $user_cache[$user_id]['gallery_album'],
    635. 

  635. 				'GALLERY_IMAGES'	=> $user_cache[$user_id]['gallery_images'],
    636. 

  636. 				'U_GALLERY_SEARCH'	=> $user_cache[$user_id]['gallery_search'],
    637. 

  637. 			));
    638. 

  638. 		}
    639. 

  639. 		$db->sql_freeresult($result);
    640. 

  640. 

  641. 		$template->assign_vars(array(
    642. 

  642. 			'DELETE_IMG'		=> $user->img('icon_post_delete', 'DELETE_COMMENT'),
    643. 

  643. 			'EDIT_IMG'			=> $user->img('icon_post_edit', 'EDIT_COMMENT'),
    644. 

  644. 			'INFO_IMG'			=> $user->img('icon_post_info', 'IP'),
    645. 

  645. 			'MINI_POST_IMG'		=> $user->img('icon_post_target_unread', 'COMMENT'),
    646. 

  646. 			'PAGE_NUMBER'		=> sprintf($user->lang['PAGE_OF'], (floor($start / $config['posts_per_page']) + 1), ceil($image_data['image_comments'] / $config['posts_per_page'])),
    647. 

  647. 			'PAGINATION'		=> generate_pagination(phpbb_gallery_url::append_sid('image_page', "album_id=$album_id&amp;image_id=$image_id&amp;sort_order=$sort_order"), $image_data['image_comments'], $config['posts_per_page'], $start),
    648. 

  648. 		));
    649. 

  649. 	}
    650. 

  650. }
    651. 

  651. 

  652. // Get the data of the image-uploader, if we don't have it from the comments anyway.
    653. 

  653. if (!isset($user_cache[$image_data['image_user_id']]))
    654. 

  654. {
    655. 

  655. 	$sql = $db->sql_build_query('SELECT', array(
    656. 

  656. 		'SELECT'	=> 'u.*, gu.personal_album_id, gu.user_images',
    657. 

  657. 		'FROM'		=> array(USERS_TABLE => 'u'),
    658. 

  658. 

  659. 		'LEFT_JOIN'	=> array(
    660. 

  660. 			array(
    661. 

  661. 				'FROM'	=> array(GALLERY_USERS_TABLE => 'gu'),
    662. 

  662. 				'ON'	=> 'gu.user_id = u.user_id'
    663. 

  663. 			),
    664. 

  664. 		),
    665. 

  665. 

  666. 		'WHERE'		=> 'u.user_id = ' . $image_data['image_user_id'],
    667. 

  667. 	));
    668. 

  668. 	$result = $db->sql_query($sql);
    669. 

  669. 

  670. 	$user_cache = array();
    671. 

  671. 	while ($row = $db->sql_fetchrow($result))
    672. 

  672. 	{
    673. 

  673. 		phpbb_gallery_user::add_user_to_user_cache($user_cache, $row);
    674. 

  674. 	}
    675. 

  675. 	$db->sql_freeresult($result);
    676. 

  676. }
    677. 

  677. 

  678. if (phpbb_gallery::$auth->acl_check('m_status', $album_id, $album_data['album_user_id']) || ($image_data['image_contest'] != phpbb_gallery_image::IN_CONTEST))
    679. 

  679. {
    680. 

  680. 	$user_cache[$user_id]['username'] = ($image_data['image_username']) ? $image_data['image_username'] : $user->lang['GUEST'];
    681. 

  681. 	$template->assign_vars(array(
    682. 

  682. 		'POSTER_FULL'		=> get_username_string('full', $user_id, $user_cache[$user_id]['username'], $user_cache[$user_id]['user_colour']),
    683. 

  683. 		'POSTER_COLOUR'		=> get_username_string('colour', $user_id, $user_cache[$user_id]['username'], $user_cache[$user_id]['user_colour']),
    684. 

  684. 		'POSTER_USERNAME'	=> get_username_string('username', $user_id, $user_cache[$user_id]['username'], $user_cache[$user_id]['user_colour']),
    685. 

  685. 		'U_POSTER'			=> get_username_string('profile', $user_id, $user_cache[$user_id]['username'], $user_cache[$user_id]['user_colour']),
    686. 

  686. 

  687. 		'POSTER_SIGNATURE'		=> $user_cache[$user_id]['sig'],
    688. 

  688. 		'POSTER_RANK_TITLE'		=> $user_cache[$user_id]['rank_title'],
    689. 

  689. 		'POSTER_RANK_IMG'		=> $user_cache[$user_id]['rank_image'],
    690. 

  690. 		'POSTER_RANK_IMG_SRC'	=> $user_cache[$user_id]['rank_image_src'],
    691. 

  691. 		'POSTER_JOINED'		=> $user_cache[$user_id]['joined'],
    692. 

  692. 		'POSTER_POSTS'		=> $user_cache[$user_id]['posts'],
    693. 

  693. 		'POSTER_FROM'		=> $user_cache[$user_id]['from'],
    694. 

  694. 		'POSTER_AVATAR'		=> $user_cache[$user_id]['avatar'],
    695. 

  695. 		'POSTER_WARNINGS'	=> $user_cache[$user_id]['warnings'],
    696. 

  696. 		'POSTER_AGE'		=> $user_cache[$user_id]['age'],
    697. 

  697. 

  698. 		'POSTER_ICQ_STATUS_IMG'		=> $user_cache[$user_id]['icq_status_img'],
    699. 

  699. 		'POSTER_ONLINE_IMG'			=> ($user_id == ANONYMOUS || !$config['load_onlinetrack']) ? '' : (($user_cache[$user_id]['online']) ? $user->img('icon_user_online', 'ONLINE') : $user->img('icon_user_offline', 'OFFLINE')),
    700. 

  700. 		'S_POSTER_ONLINE'			=> ($user_id == ANONYMOUS || !$config['load_onlinetrack']) ? false : (($user_cache[$user_id]['online']) ? true : false),
    701. 

  701. 

  702. 		'U_POSTER_PROFILE'		=> $user_cache[$user_id]['profile'],
    703. 

  703. 		'U_POSTER_SEARCH'		=> $user_cache[$user_id]['search'],
    704. 

  704. 		'U_POSTER_PM'			=> ($user_id != ANONYMOUS && $config['allow_privmsg'] && $auth->acl_get('u_sendpm') && ($user_cache[$user_id]['allow_pm'] || $auth->acl_gets('a_', 'm_'))) ? phpbb_gallery_url::append_sid('phpbb', 'ucp', 'i=pm&amp;mode=compose&amp;u=' . $user_id) : '',
    705. 

  705. 		'U_POSTER_EMAIL'		=> $user_cache[$user_id]['email'],
    706. 

  706. 		'U_POSTER_WWW'			=> $user_cache[$user_id]['www'],
    707. 

  707. 		'U_POSTER_ICQ'			=> $user_cache[$user_id]['icq'],
    708. 

  708. 		'U_POSTER_AIM'			=> $user_cache[$user_id]['aim'],
    709. 

  709. 		'U_POSTER_MSN'			=> $user_cache[$user_id]['msn'],
    710. 

  710. 		'U_POSTER_YIM'			=> $user_cache[$user_id]['yim'],
    711. 

  711. 		'U_POSTER_JABBER'		=> $user_cache[$user_id]['jabber'],
    712. 

  712. 

  713. 		'U_POSTER_GALLERY'			=> $user_cache[$user_id]['gallery_album'],
    714. 

  714. 		'POSTER_GALLERY_IMAGES'		=> $user_cache[$user_id]['gallery_images'],
    715. 

  715. 		'U_POSTER_GALLERY_SEARCH'	=> $user_cache[$user_id]['gallery_search'],
    716. 

  716. 	));
    717. 

  717. }
    718. 

  718. else
    719. 

  719. {
    720. 

  720. 	$template->assign_vars(array(
    721. 

  721. 		'POSTER_FULL'	=> sprintf($user->lang['CONTEST_USERNAME_LONG'], $user->format_date(($album_data['contest_start'] + $album_data['contest_end']), false, true)),
    722. 

  722. 	));
    723. 

  723. }
    724. 

  724. 

  725. $template->assign_vars(array(
    726. 

  726. 	'PROFILE_IMG'		=> $user->img('icon_user_profile', 'READ_PROFILE'),
    727. 

  727. 	'SEARCH_IMG' 		=> $user->img('icon_user_search', 'SEARCH_USER_POSTS'),
    728. 

  728. 	'PM_IMG' 			=> $user->img('icon_contact_pm', 'SEND_PRIVATE_MESSAGE'),
    729. 

  729. 	'EMAIL_IMG' 		=> $user->img('icon_contact_email', 'SEND_EMAIL'),
    730. 

  730. 	'WWW_IMG' 			=> $user->img('icon_contact_www', 'VISIT_WEBSITE'),
    731. 

  731. 	'ICQ_IMG' 			=> $user->img('icon_contact_icq', 'ICQ'),
    732. 

  732. 	'AIM_IMG' 			=> $user->img('icon_contact_aim', 'AIM'),
    733. 

  733. 	'MSN_IMG' 			=> $user->img('icon_contact_msnm', 'MSNM'),
    734. 

  734. 	'YIM_IMG' 			=> $user->img('icon_contact_yahoo', 'YIM'),
    735. 

  735. 	'JABBER_IMG'		=> $user->img('icon_contact_jabber', 'JABBER') ,
    736. 

  736. 	'GALLERY_IMG'		=> $user->img('icon_contact_gallery', 'PERSONAL_ALBUM'),
    737. 

  737. ));
    738. 

  738. 

  739. page_header($user->lang['VIEW_IMAGE'] . ' - ' . $image_data['image_name'], false);
    740. 

  740. 

  741. $template->set_filenames(array(
    742. 

  742. 	'body' => 'gallery/viewimage_body.html')
    743. 

  743. );
    744. 

  744. 

  745. page_footer();
    746. 

  746. 

  747. ?>
    748.