<?php
# -- BEGIN LICENSE BLOCK ---------------------------------------
#
# This file is part of Dotclear 2.
#
# Copyright (c) 2003-2013 Olivier Meunier & Association Dotclear
# Licensed under the GPL version 2.0 license.
# See LICENSE file or
# http://www.gnu.org/licenses/old-licenses/gpl-2.0.html
#
# -- END LICENSE BLOCK -----------------------------------------

require dirname(__FILE__).'/../inc/admin/prepend.php';

dcPage::check('media,media_admin');

$tab = empty($_REQUEST['tab']) ? '' : $_REQUEST['tab'];

$post_id = !empty($_REQUEST['post_id']) ? (integer) $_REQUEST['post_id'] : null;
if ($post_id) {
	$post = $core->blog->getPosts(array('post_id'=>$post_id));
	if ($post->isEmpty()) {
		$post_id = null;
	}
	$post_title = $post->post_title;
	unset($post);
}

// Attachement type if any
$link_type = !empty($_REQUEST['link_type']) ? $_REQUEST['link_type'] : null;

$file = null;
$popup = (integer) !empty($_REQUEST['popup']);
$select = !empty($_REQUEST['select']) ? (integer)$_REQUEST['select'] : 0;	// 0 : none, 1 : single media, >1 : multiple medias
$plugin_id = isset($_REQUEST['plugin_id']) ? html::sanitizeURL($_REQUEST['plugin_id']) : '';
$page_url_params = array('popup' => $popup,'select' => $select,'post_id' => $post_id);
$media_page_url_params = array('popup' => $popup,'select' => $select,'post_id' => $post_id,'link_type' => $link_type);

if ($plugin_id != '') {
	$page_url_params['plugin_id'] = $plugin_id;
	$media_page_url_params['plugin_id'] = $plugin_id;
}

$id = !empty($_REQUEST['id']) ? (integer) $_REQUEST['id'] : '';

if ($id != '') {
	$page_url_params ['id'] = $id;
}

if ($popup) {
	$open_f = array('dcPage','openPopup');
	$close_f = array('dcPage','closePopup');
} else {
	$open_f = array('dcPage','open');
	$close_f = create_function('',"dcPage::helpBlock('core_media'); dcPage::close();");
}

$core_media_writable = false;
try
{
	$core->media = new dcMedia($core);

	if ($id) {
		$file = $core->media->getFile($id);
	}

	if ($file === null) {
		throw new Exception(__('Not a valid file'));
	}

	$core->media->chdir(dirname($file->relname));
	$core_media_writable = $core->media->writable();

	# Prepare directories combo box
	$dirs_combo = array();
	foreach ($core->media->getDBDirs() as $v) {
		$dirs_combo['/'.$v] = $v;
	}
	# Add parent and direct childs directories if any
	$core->media->getFSDir();
	foreach ($core->media->dir['dirs'] as $k => $v) {
		$dirs_combo['/'.$v->relname] = $v->relname;
	}
	ksort($dirs_combo);
}
catch (Exception $e)
{
	$core->error->add($e->getMessage());
}

# Upload a new file
if ($file && !empty($_FILES['upfile']) && $file->editable && $core_media_writable)
{
	try {
		files::uploadStatus($_FILES['upfile']);
		$core->media->uploadFile($_FILES['upfile']['tmp_name'],$file->basename,null,false,true);

		dcPage::addSuccessNotice(__('File has been successfully updated.'));
		$core->adminurl->redirect('admin.media.item',$page_url_params);
	} catch (Exception $e) {
		$core->error->add($e->getMessage());
	}
}

# Update file
if ($file && !empty($_POST['media_file']) && $file->editable && $core_media_writable)
{
	$newFile = clone $file;

	$newFile->basename = $_POST['media_file'];

	if ($_POST['media_path']) {
		$newFile->dir = $_POST['media_path'];
		$newFile->relname = $_POST['media_path'].'/'.$newFile->basename;
	} else {
		$newFile->dir = '';
		$newFile->relname = $newFile->basename;
	}
	$newFile->media_title = $_POST['media_title'];
	$newFile->media_dt = strtotime($_POST['media_dt']);
	$newFile->media_dtstr = $_POST['media_dt'];
	$newFile->media_priv = !empty($_POST['media_private']);

	try {
		$core->media->updateFile($file,$newFile);

		dcPage::addSuccessNotice(__('File has been successfully updated.'));
		$page_url_params['tab'] = 'media-details-tab';
		$core->adminurl->redirect('admin.media.item',$page_url_params);
	} catch (Exception $e) {
		$core->error->add($e->getMessage());
	}
}

# Update thumbnails
if (!empty($_POST['thumbs']) && $file->media_type == 'image' && $file->editable && $core_media_writable)
{
	try {
		$foo = null;
		$core->media->mediaFireRecreateEvent($file);

		dcPage::addSuccessNotice(__('Thumbnails have been successfully updated.'));
		$page_url_params['tab'] = 'media-details-tab';
		$core->adminurl->redirect('admin.media.item',$page_url_params);
	} catch (Exception $e) {
		$core->error->add($e->getMessage());
	}
}

# Unzip file
if (!empty($_POST['unzip']) && $file->type == 'application/zip' && $file->editable && $core_media_writable)
{
	try {
		$unzip_dir = $core->media->inflateZipFile($file,$_POST['inflate_mode'] == 'new');

		dcPage::addSuccessNotice(__('Zip file has been successfully extracted.'));
		$media_page_url_params['d'] = $unzip_dir;
		$core->adminurl->redirect('admin.media',$media_page_url_params);
	} catch (Exception $e) {
		$core->error->add($e->getMessage());
	}
}

# Save media insertion settings for the blog
if (!empty($_POST['save_blog_prefs']))
{
	if (!empty($_POST['pref_src'])) {
		foreach (array_reverse($file->media_thumb) as $s => $v) {
			if ($v == $_POST['pref_src']) {
				$core->blog->settings->system->put('media_img_default_size',$s);
				break;
			}
		}
	}
	if (!empty($_POST['pref_alignment'])) {
		$core->blog->settings->system->put('media_img_default_alignment',$_POST['pref_alignment']);
	}
	if (!empty($_POST['pref_insertion'])) {
		$core->blog->settings->system->put('media_img_default_link',($_POST['pref_insertion'] == 'link'));
	}

	dcPage::addSuccessNotice(__('Default media insertion settings have been successfully updated.'));
	$core->adminurl->redirect('admin.media.item',$page_url_params);
}

# Function to get image title based on meta
function dcGetImageTitle($file,$pattern,$dto_first=false,$no_date_alone=false)
{
	$res = array();
	$pattern = preg_split('/\s*;;\s*/',$pattern);
	$sep = ', ';
	$dates = 0;
	$items = 0;

	foreach ($pattern as $v) {
		if ($v == 'Title') {
			if ($file->media_title != '') {
				$res[] = $file->media_title;
			}
			$items++;
		} elseif ($file->media_meta->{$v}) {
			if ((string) $file->media_meta->{$v} != '') {
				$res[] = (string) $file->media_meta->{$v};
			}
			$items++;
		} elseif (preg_match('/^Date\((.+?)\)$/u',$v,$m)) {
			if ($dto_first && ($file->media_meta->DateTimeOriginal != 0)) {
				$res[] = dt::dt2str($m[1],(string) $file->media_meta->DateTimeOriginal);
			} else {
				$res[] = dt::str($m[1],$file->media_dt);
			}
			$items++;
			$dates++;
		} elseif (preg_match('/^DateTimeOriginal\((.+?)\)$/u',$v,$m) && $file->media_meta->DateTimeOriginal) {
			$res[] = dt::dt2str($m[1],(string) $file->media_meta->DateTimeOriginal);
			$items++;
			$dates++;
		} elseif (preg_match('/^separator\((.*?)\)$/u',$v,$m)) {
			$sep = $m[1];
		}
	}
	if ($no_date_alone && $dates == count($res) && $dates < $items) {
		// On ne laisse pas les dates seules, sauf si ce sont les seuls items du pattern (hors séparateur)
		return '';
	}
	return implode($sep,$res);
}

/* DISPLAY Main page
-------------------------------------------------------- */
$starting_scripts =
	'<script type="text/javascript">'."\n".
	"//<![CDATA["."\n".
	dcPage::jsVar('dotclear.msg.confirm_delete_media',__('Are you sure to delete this media?'))."\n".
	"//]]>".
	"</script>".
	dcPage::jsLoad('js/_media_item.js');
if ($popup && !empty($plugin_id)) {
	$starting_scripts .= $core->callBehavior('adminPopupMedia', $plugin_id);
}
$temp_params = $media_page_url_params;
$temp_params['d']='%s';
$bc_template = $core->adminurl->get('admin.media',$temp_params,'&amp;',true);
$temp_params['d']='';
$home_url=$core->adminurl->get('admin.media',$temp_params);
call_user_func($open_f,__('Media manager'),
	$starting_scripts.
	dcPage::jsDatePicker().
	($popup ? dcPage::jsPageTabs($tab) : ''),
	dcPage::breadcrumb(
		array(
			html::escapeHTML($core->blog->name) => '',
			__('Media manager') => $home_url,
			$core->media->breadCrumb($bc_template).'<span class="page-title">'.$file->basename.'</span>' => ''
		),
		array(
			'home_link' => !$popup,
			'hl' => false
		)
	)
);

if ($popup) {
	// Display notices
	echo dcPage::notices();
}

if ($file === null) {
	call_user_func($close_f);
	exit;
}

if (!empty($_GET['fupd']) || !empty($_GET['fupl'])) {
	dcPage::success(__('File has been successfully updated.'));
}
if (!empty($_GET['thumbupd'])) {
	dcPage::success(__('Thumbnails have been successfully updated.'));
}
if (!empty($_GET['blogprefupd'])) {
	dcPage::success(__('Default media insertion settings have been successfully updated.'));
}

# Get major file type (first part of mime type)
$file_type = explode('/',$file->type);

# Selection mode
if ($select) {
	// Let user choose thumbnail size if image
	$media_desc = $file->media_title;

	echo
	'<div id="media-select" class="multi-part" title="'.__('Select media item').'">'.
	'<h3>'.__('Select media item').'</h3>'.
	'<form id="media-select-form" action="" method="get">';

	$media_img_default_size = $core->blog->settings->system->media_img_default_size;
	if ($media_img_default_size == '') {
		$media_img_default_size = 'm';
	}
	$media_img_default_alignment = $core->blog->settings->system->media_img_default_alignment;
	if ($media_img_default_alignment == '') {
		$media_img_default_alignment = 'none';
	}
	$media_img_default_link = (boolean)$core->blog->settings->system->media_img_default_link;

	if ($file->media_type == 'image')
	{
		$media_type = 'image';
		$media_desc = dcGetImageTitle($file,
			$core->blog->settings->system->media_img_title_pattern,
			$core->blog->settings->system->media_img_use_dto_first,
			$core->blog->settings->system->media_img_no_date_alone);
		if ($media_desc == $file->basename) {
			$media_desc = '';
		}

		echo
		'<h3>'.__('Image size:').'</h3> ';

		$s_checked = false;
		echo '<p>';
		foreach (array_reverse($file->media_thumb) as $s => $v) {
			$s_checked = ($s == $media_img_default_size);
			echo '<label class="classic">'.
			form::radio(array('src'),html::escapeHTML($v),$s_checked).' '.
			$core->media->thumb_sizes[$s][2].'</label><br /> ';
		}
		$s_checked = (!isset($file->media_thumb[$media_img_default_size]));
		echo '<label class="classic">'.
		form::radio(array('src'),$file->file_url,$s_checked).' '.__('original').'</label><br /> ';
		echo '</p>';

	} elseif ($file_type[0] == 'audio') {
		$media_type = 'mp3';
	} elseif ($file_type[0] == 'video') {
		$media_type = 'flv';
	} else {
		$media_type = 'default';
	}

	echo
	'<p>'.
	'<a id="media-select-ok" class="button submit" href="#">'.__('Select').'</a> '.
	'<a id="media-select-cancel" class="button" href="#">'.__('Cancel').'</a>'.
	form::hidden(array('type'),html::escapeHTML($media_type)).
	form::hidden(array('title'),html::escapeHTML($file->media_title)).
	form::hidden(array('description'),html::escapeHTML($media_desc)).
	form::hidden(array('url'),$file->file_url).
	'</p>';

	echo '</form>';
	echo '</div>';
}

# Insertion popup
if ($popup && !$select)
{
	$media_desc = $file->media_title;

	echo
	'<div id="media-insert" class="multi-part" title="'.__('Insert media item').'">'.
	'<h3>'.__('Insert media item').'</h3>'.
	'<form id="media-insert-form" action="" method="get">';

	$media_img_default_size = $core->blog->settings->system->media_img_default_size;
	if ($media_img_default_size == '') {
		$media_img_default_size = 'm';
	}
	$media_img_default_alignment = $core->blog->settings->system->media_img_default_alignment;
	if ($media_img_default_alignment == '') {
		$media_img_default_alignment = 'none';
	}
	$media_img_default_link = (boolean)$core->blog->settings->system->media_img_default_link;

	if ($file->media_type == 'image')
	{
		$media_type = 'image';
		$media_desc = dcGetImageTitle($file,
			$core->blog->settings->system->media_img_title_pattern,
			$core->blog->settings->system->media_img_use_dto_first,
			$core->blog->settings->system->media_img_no_date_alone);
		if ($media_desc == $file->basename) {
			$media_desc = '';
		}

		echo
		'<h3>'.__('Image size:').'</h3> ';

		$s_checked = false;
		echo '<p>';
		foreach (array_reverse($file->media_thumb) as $s => $v) {
			$s_checked = ($s == $media_img_default_size);
			echo '<label class="classic">'.
			form::radio(array('src'),html::escapeHTML($v),$s_checked).' '.
			$core->media->thumb_sizes[$s][2].'</label><br /> ';
		}
		$s_checked = (!isset($file->media_thumb[$media_img_default_size]));
		echo '<label class="classic">'.
		form::radio(array('src'),$file->file_url,$s_checked).' '.__('original').'</label><br /> ';
		echo '</p>';

		echo
		'<div class="two-boxes">'.
		'<h3>'.__('Image alignment').'</h3>';
		$i_align = array(
			'none' => array(__('None'),($media_img_default_alignment == 'none' ? 1 : 0)),
			'left' => array(__('Left'),($media_img_default_alignment == 'left' ? 1 : 0)),
			'right' => array(__('Right'),($media_img_default_alignment == 'right' ? 1 : 0)),
			'center' => array(__('Center'),($media_img_default_alignment == 'center' ? 1 : 0))
		);

		echo '<p>';
		foreach ($i_align as $k => $v) {
			echo '<label class="classic">'.
			form::radio(array('alignment'),$k,$v[1]).' '.$v[0].'</label><br /> ';
		}
		echo '</p>';
		echo '</div>';

		echo
		'<div class="two-boxes">'.
		'<h3>'.__('Image insertion').'</h3>'.
		'<p>'.
		'<label for="insert1" class="classic">'.form::radio(array('insertion','insert1'),'simple',!$media_img_default_link).
		__('As a single image').'</label><br />'.
		'<label for="insert2" class="classic">'.form::radio(array('insertion','insert2'),'link',$media_img_default_link).
		__('As a link to the original image').'</label>'.
		'</p>'.
		'</div>';
	}
	elseif ($file_type[0] == 'audio')
	{
		$media_type = 'mp3';

		echo
		'<div class="two-boxes">'.
		'<h3>'.__('MP3 disposition').'</h3>';
		dcPage::message(__("Please note that you cannot insert mp3 files with visual editor."),false);

		$i_align = array(
			'none' => array(__('None'),($media_img_default_alignment == 'none' ? 1 : 0)),
			'left' => array(__('Left'),($media_img_default_alignment == 'left' ? 1 : 0)),
			'right' => array(__('Right'),($media_img_default_alignment == 'right' ? 1 : 0)),
			'center' => array(__('Center'),($media_img_default_alignment == 'center' ? 1 : 0))
		);

		echo '<p>';
		foreach ($i_align as $k => $v) {
			echo '<label class="classic">'.
			form::radio(array('alignment'),$k,$v[1]).' '.$v[0].'</label><br /> ';
		}

		$public_player_style = unserialize($core->blog->settings->themes->mp3player_style);
		$public_player = dcMedia::audioPlayer($file->type,$file->file_url,$core->blog->getQmarkURL().'pf=player_mp3.swf',$public_player_style,$core->blog->settings->system->media_flash_fallback);
		echo form::hidden('public_player',html::escapeHTML($public_player));
		echo '</p>';
		echo '</div>';
	}
	elseif ($file_type[0] == 'video')
	{
		$media_type = 'flv';

		dcPage::message(__("Please note that you cannot insert video files with visual editor."),false);

		echo
		'<div class="two-boxes">'.
		'<h3>'.__('Video size').'</h3>'.
		'<p><label for="video_w" class="classic">'.__('Width:').'</label> '.
		form::field('video_w',3,4,$core->blog->settings->system->media_video_width).'  '.
		'<label for="video_h" class="classic">'.__('Height:').'</label> '.
		form::field('video_h',3,4,$core->blog->settings->system->media_video_height).
		'</p>'.
		'</div>';


		echo
		'<div class="two-boxes">'.
		'<h3>'.__('Video disposition').'</h3>';

		$i_align = array(
			'none' => array(__('None'),($media_img_default_alignment == 'none' ? 1 : 0)),
			'left' => array(__('Left'),($media_img_default_alignment == 'left' ? 1 : 0)),
			'right' => array(__('Right'),($media_img_default_alignment == 'right' ? 1 : 0)),
			'center' => array(__('Center'),($media_img_default_alignment == 'center' ? 1 : 0))
		);

		echo '<p>';
		foreach ($i_align as $k => $v) {
			echo '<label class="classic">'.
			form::radio(array('alignment'),$k,$v[1]).' '.$v[0].'</label><br /> ';
		}

		$public_player_style = unserialize($core->blog->settings->themes->flvplayer_style);
		$public_player = dcMedia::videoPlayer($file->type,$file->file_url,$core->blog->getQmarkURL().'pf=player_flv.swf',$public_player_style,$core->blog->settings->system->media_flash_fallback);
		echo form::hidden('public_player',html::escapeHTML($public_player));
		echo '</p>';
		echo '</div>';
	}
	else
	{
		$media_type = 'default';
		echo '<p>'.__('Media item will be inserted as a link.').'</p>';
	}

	echo
	'<p>'.
	'<a id="media-insert-ok" class="button submit" href="#">'.__('Insert').'</a> '.
	'<a id="media-insert-cancel" class="button" href="#">'.__('Cancel').'</a>'.
	form::hidden(array('type'),html::escapeHTML($media_type)).
	form::hidden(array('title'),html::escapeHTML($file->media_title)).
	form::hidden(array('description'),html::escapeHTML($media_desc)).
	form::hidden(array('url'),$file->file_url).
	'</p>';

	echo '</form>';

	if ($media_type != 'default') {
		echo
		'<div class="border-top">'.
		'<form id="save_settings" action="'.$core->adminurl->getBase('admin.media.item').'" method="post">'.
		'<p>'.__('Make current settings as default').' '.
		'<input class="reset" type="submit" name="save_blog_prefs" value="'.__('OK').'" />'.
		form::hidden(array('pref_src'),'').
		form::hidden(array('pref_alignment'),'').
		form::hidden(array('pref_insertion'),'').
		$core->adminurl->getHiddenFormFields('admin.media.item',$page_url_params).
		$core->formNonce().'</p>'.
		'</form>'.'</div>';
	}

	echo '</div>';
}

if ($popup || $select) {
	echo
	'<div class="multi-part" title="'.__('Media details').'" id="media-details-tab">';
} else {
	echo '<h3 class="out-of-screen-if-js">'.__('Media details').'</h3>';
}
echo
'<p id="media-icon"><img src="'.$file->media_icon.'?'.time()*rand().'" alt="" /></p>';

echo
'<div id="media-details">'.
'<div class="near-icon">';

if ($file->media_image)
{
	$thumb_size = !empty($_GET['size']) ? $_GET['size'] : 's';

	if (!isset($core->media->thumb_sizes[$thumb_size]) && $thumb_size != 'o') {
		$thumb_size = 's';
	}

	if (isset($file->media_thumb[$thumb_size])) {
		echo '<p><img src="'.$file->media_thumb[$thumb_size].'?'.time()*rand().'" alt="" /></p>';
	} elseif ($thumb_size == 'o') {
		$S = getimagesize($file->file);
		$class = ($S[1] > 500) ? ' class="overheight"' : '';
		unset($S);
		echo '<p id="media-original-image"'.$class.'><img src="'.$file->file_url.'?'.time()*rand().'" alt="" /></p>';
	}

	echo '<p>'.__('Available sizes:').' ';
	foreach (array_reverse($file->media_thumb) as $s => $v)
	{
		$strong_link = ($s == $thumb_size) ? '<strong>%s</strong>' : '%s';
		printf($strong_link,'<a href="'.$core->adminurl->get('admin.media.item',array_merge($page_url_params,
			array("size" => $s,'tab' => 'media-details-tab'))).'">'.$core->media->thumb_sizes[$s][2].'</a> | ');
	}
	echo '<a href="'.$core->adminurl->get('admin.media.item',array_merge($page_url_params,array("size" => "o","tab"=>"media-details-tab"))).'">'.__('original').'</a>';
	echo '</p>';

	if ($thumb_size != 'o' && isset($file->media_thumb[$thumb_size])) {
		$p = path::info($file->file);
		$alpha = ($p['extension'] == 'png') || ($p['extension'] == 'PNG');
		$thumb = sprintf(($alpha ? $core->media->thumb_tp_alpha : $core->media->thumb_tp),$p['dirname'],$p['base'],'%s');
		$thumb_file = sprintf($thumb,$thumb_size);
		$T = getimagesize($thumb_file);
		$stats = stat($thumb_file);
		echo
		'<h3>'.__('Thumbnail details').'</h3>'.
		'<ul>'.
		'<li><strong>'.__('Image width:').'</strong> '.$T[0].' px</li>'.
		'<li><strong>'.__('Image height:').'</strong> '.$T[1].' px</li>'.
		'<li><strong>'.__('File size:').'</strong> '.files::size($stats[7]).'</li>'.
		'<li><strong>'.__('File URL:').'</strong> <a href="'.$file->media_thumb[$thumb_size].'">'.
			$file->media_thumb[$thumb_size].'</a></li>'.
		'</ul>';
	}
}

// Show player if relevant
if ($file_type[0] == 'audio')
{
	echo dcMedia::audioPlayer($file->type,$file->file_url,$core->adminurl->get("admin.home",array('pf' => 'player_mp3.swf')),
		null,$core->blog->settings->system->media_flash_fallback);
}
if ($file_type[0] == 'video')
{
	echo dcMedia::videoPlayer($file->type,$file->file_url,$core->adminurl->get("admin.home",array('pf' => 'player_flv.swf')),
		null,$core->blog->settings->system->media_flash_fallback);
}

echo
'<h3>'.__('Media details').'</h3>'.
'<ul>'.
	'<li><strong>'.__('File owner:').'</strong> '.$file->media_user.'</li>'.
	'<li><strong>'.__('File type:').'</strong> '.$file->type.'</li>';
if ($file->media_image)
{
	$S = getimagesize($file->file);
	echo
	'<li><strong>'.__('Image width:').'</strong> '.$S[0].' px</li>'.
	'<li><strong>'.__('Image height:').'</strong> '.$S[1].' px</li>';
	unset($S);
}
echo
	'<li><strong>'.__('File size:').'</strong> '.files::size($file->size).'</li>'.
	'<li><strong>'.__('File URL:').'</strong> <a href="'.$file->file_url.'">'.$file->file_url.'</a></li>'.
'</ul>';

if (empty($_GET['find_posts']))
{
	echo
	'<p><a class="button" href="'.$core->adminurl->get('admin.media.item',array_merge($page_url_params,array("find_posts"=>1,"tab"=>"media-details-tab"))).'">'.
	__('Show entries containing this media').'</a></p>';
}
else
{
	echo '<h3>'.__('Entries containing this media').'</h3>';
	$params = array(
		'post_type' => '',
		'from' => 'LEFT OUTER JOIN '.$core->prefix.'post_media PM ON P.post_id = PM.post_id ',
		'sql' => 'AND ('.
			'PM.media_id = '.(integer) $id.' '.
			"OR post_content_xhtml LIKE '%".$core->con->escape($file->relname)."%' ".
			"OR post_excerpt_xhtml LIKE '%".$core->con->escape($file->relname)."%' "
	);

	if ($file->media_image)
	{ # We look for thumbnails too
		if (preg_match('#^http(s)?://#',$core->blog->settings->system->public_url)) {
			$media_root = $core->blog->settings->system->public_url;
		} else {
			$media_root = $core->blog->host.path::clean($core->blog->settings->system->public_url).'/';
		}
		foreach ($file->media_thumb as $v) {
			$v = preg_replace('/^'.preg_quote($media_root,'/').'/','',$v);
			$params['sql'] .= "OR post_content_xhtml LIKE '%".$core->con->escape($v)."%' ";
			$params['sql'] .= "OR post_excerpt_xhtml LIKE '%".$core->con->escape($v)."%' ";
		}
	}

	$params['sql'] .= ') ';

	$rs = $core->blog->getPosts($params);

	if ($rs->isEmpty())
	{
		echo '<p>'.__('No entry seems contain this media.').'</p>';
	}
	else
	{
		echo '<ul>';
		while ($rs->fetch()) {
			$img = '<img alt="%1$s" title="%1$s" src="images/%2$s" />';
			switch ($rs->post_status) {
				case 1:
					$img_status = sprintf($img,__('published'),'check-on.png');
					break;
				case 0:
					$img_status = sprintf($img,__('unpublished'),'check-off.png');
					break;
				case -1:
					$img_status = sprintf($img,__('scheduled'),'scheduled.png');
					break;
				case -2:
					$img_status = sprintf($img,__('pending'),'check-wrn.png');
					break;
			}
			echo '<li>'.$img_status.' '.'<a href="'.$core->getPostAdminURL($rs->post_type,$rs->post_id).'">'.
				$rs->post_title.'</a>'.
				($rs->post_type != 'post' ? ' ('.html::escapeHTML($rs->post_type).')' : '').
				' - '.dt::dt2str(__('%Y-%m-%d %H:%M'),$rs->post_dt).'</li>';
		}
		echo '</ul>';
	}
}

if ($file->type == 'image/jpeg')
{
	echo '<h3>'.__('Image details').'</h3>';

	$details = '';
	if (count($file->media_meta) > 0)
	{
		foreach ($file->media_meta as $k => $v)
		{
			if ((string) $v) {
				$details .= '<li><strong>'.$k.':</strong> '.html::escapeHTML($v).'</li>';
			}
		}
	}
	if ($details) {
		echo '<ul>'.$details.'</ul>';
	} else {
		echo '<p>'.__('No detail').'</p>';
	}
}

echo '</div>';

echo '<h3>'.__('Updates and modifications').'</h3>';

if ($file->editable && $core_media_writable)
{
	if ($file->media_type == 'image')
	{
		echo
		'<form class="clear fieldset" action="'.$core->adminurl->get("admin.media.item").'" method="post">'.
		'<h4>'.__('Update thumbnails').'</h4>'.
		'<p>'.__('This will create or update thumbnails for this image.').'</p>'.
		'<p><input type="submit" name="thumbs" value="'.__('Update thumbnails').'" />'.
		$core->adminurl->getHiddenFormFields('admin.media',$page_url_params).
		$core->formNonce().'</p>'.
		'</form>';
	}

	if ($file->type == 'application/zip')
	{
		$inflate_combo = array(
			__('Extract in a new directory') => 'new',
			__('Extract in current directory') => 'current'
		);

		echo
		'<form class="clear fieldset" id="file-unzip" action="'.$core->adminurl->get("admin.media.item").'" method="post">'.
		'<h4>'.__('Extract archive').'</h4>'.
		'<ul>'.
		'<li><strong>'.__('Extract in a new directory').'</strong> : '.
		__('This will extract archive in a new directory that should not exist yet.').'</li>'.
		'<li><strong>'.__('Extract in current directory').'</strong> : '.
		__('This will extract archive in current directory and will overwrite existing files or directory.').'</li>'.
		'</ul>'.
		'<p><label for="inflate_mode" class="classic">'.__('Extract mode:').'</label> '.
		form::combo('inflate_mode',$inflate_combo,'new').
		'<input type="submit" name="unzip" value="'.__('Extract').'" />'.
		$core->adminurl->getHiddenFormFields('admin.media',$page_url_params).
		$core->formNonce().'</p>'.
		'</form>';
	}

	echo
	'<form class="clear fieldset" action="'.$core->adminurl->get("admin.media.item").'" method="post">'.
	'<h4>'.__('Change media properties').'</h4>'.
	'<p><label for="media_file">'.__('File name:').'</label>'.
	form::field('media_file',30,255,html::escapeHTML($file->basename)).'</p>'.
	'<p><label for="media_title">'.__('File title:').'</label>'.
	form::field('media_title',30,255,html::escapeHTML($file->media_title)).'</p>'.
	'<p><label for="media_dt">'.__('File date:').'</label>'.
	form::field('media_dt',16,16,html::escapeHTML($file->media_dtstr)).'</p>'.
	'<p><label for="media_private" class="classic">'.form::checkbox('media_private',1,$file->media_priv).' '.
	__('Private').'</label></p>'.
	'<p><label for="media_path">'.__('New directory:').'</label>'.
	form::combo('media_path',$dirs_combo,dirname($file->relname)).'</p>'.
	'<p><input type="submit" accesskey="s" value="'.__('Save').'" />'.
	$core->adminurl->getHiddenFormFields('admin.media.item',$page_url_params).
	$core->formNonce().'</p>'.
	'</form>';

	echo
	'<form class="clear fieldset" action="'.$core->adminurl->get("admin.media.item").'" method="post" enctype="multipart/form-data">'.
	'<h4>'.__('Change file').'</h4>'.
	'<div>'.form::hidden(array('MAX_FILE_SIZE'),DC_MAX_UPLOAD_SIZE).'</div>'.
	'<p><label for="upfile">'.__('Choose a file:').
	' ('.sprintf(__('Maximum size %s'),files::size(DC_MAX_UPLOAD_SIZE)).') '.
	'<input type="file" id="upfile" name="upfile" size="35" />'.
	'</label></p>'.
	'<p><input type="submit" value="'.__('Send').'" />'.
	$core->adminurl->getHiddenFormFields('admin.media',$page_url_params).
	$core->formNonce().'</p>'.
	'</form>';

	if ($file->del) {
		echo
		'<form id="delete-form" method="post" action="'.$core->adminurl->getBase("admin.media").'">'.
		'<p><input name="delete" type="submit" class="delete" value="'.__('Delete this media').'" />'.
		form::hidden('remove',rawurlencode($file->basename)).
		form::hidden('rmyes',1).
		$core->adminurl->getHiddenFormFields('admin.media',$media_page_url_params).
		$core->formNonce().'</p>'.
		'</form>';
	}


	# --BEHAVIOR-- adminMediaItemForm
	$core->callBehavior('adminMediaItemForm',$file);
}

echo
'</div>';
if ($popup || $select) {
	echo
	'</div>';
}

call_user_func($close_f);
