l10n('Delete Hit/Rate'),
'URL' => PDHR_ADMIN,
);
return $menu;
}
//add prefiltre photo
add_event_handler('loc_begin_admin', 'plugdphrPf',60);
add_event_handler('loc_begin_admin_page', 'plugdphrPf2',60);
function plugdphrPf()
{
global $template;
$admin_base_url = $_SERVER['REQUEST_URI'];
$template->set_prefilter('picture_modify', 'plugdphrPT');
$template->assign(
array(
'U_DELETEPHIT' => $admin_base_url . '&deletephit',
'U_DELETEPRATE' => $admin_base_url . '&deleteprate',
));
}
function plugdphrPT($content, &$smarty)
{
load_language('plugin.lang', PDHR_PATH);
$search = '#
#';
$replacement = '
{\'Purge hit of the photo\'|@translate}
{\'Purge rate of the photo\'|@translate}
';
return preg_replace($search, $replacement, $content);
}
function plugdphrPf2()
{
if (isset($_GET['deletephit'])) {
$admin_base_url=explode('&deletephit', $_SERVER['REQUEST_URI']);
$photoid = explode('photo-', $_SERVER['REQUEST_URI']);
if(strstr($photoid[1], '-properties')){$photoid = explode('-properties', $photoid[1]);}
else if(strstr($photoid[1], '&cat')){$photoid = explode('&cat', $photoid[1]);}
else{
$_SESSION['page_infos'] = array('error');
redirect($_SERVER['REQUEST_URI']);
}
$query = 'UPDATE ' . IMAGES_TABLE . ' SET hit= \'0\' WHERE id = '.$photoid[0].';';
$result = pwg_query($query);
redirect($admin_base_url[0]);
}
if (isset($_GET['deleteprate'])) {
$admin_base_url=explode('&deleteprate', $_SERVER['REQUEST_URI']);
$photoid = explode('photo-', $_SERVER['REQUEST_URI']);
if(strstr($photoid[1], '-properties')){$photoid = explode('-properties', $photoid[1]);}
else if(strstr($photoid[1], '&cat')){$photoid = explode('&cat', $photoid[1]);}
else{
$_SESSION['page_infos'] = array('error');
redirect($_SERVER['REQUEST_URI']);
}
$query = 'UPDATE ' . IMAGES_TABLE . ' SET rating_score = \'NULL\' WHERE id = '.$photoid[0].';';
$result = pwg_query($query);
$query = 'DELETE FROM ' . RATE_TABLE . ' WHERE element_id = '.$photoid[0].';';
$result = pwg_query($query);
redirect($admin_base_url[0]);
}
}
//add prefiltre album
add_event_handler('loc_end_cat_modify', 'plugdphrAf');
add_event_handler('loc_end_cat_modify', 'plugdphrAf2');
function plugdphrAf()
{
global $template;
$admin_base_url = $_SERVER['REQUEST_URI'];
$template->set_prefilter('album_properties', 'plugdphrAT');
$template->assign(
array(
'U_DELETEAHIT' => $admin_base_url . '&deleteahit',
'U_DELETEARATE' => $admin_base_url . '&deletearate',
));
}
function plugdphrAT($content, &$smarty)
{
load_language('plugin.lang', PDHR_PATH);
$search = '#
#';
$replacement = '
{\'Purge hits on all pictures album\'|@translate}
{\'Purge rates on all pictures album\'|@translate}
';
return preg_replace($search, $replacement, $content);
}
function plugdphrAf2()
{
if (isset($_GET['deleteahit'])) {
$admin_base_url=explode('&deleteahit', $_SERVER['REQUEST_URI']);
$albumid = explode('album-', $_SERVER['REQUEST_URI']);
if(strstr($albumid[1], '-properties')){
$albumid = explode('-properties', $albumid[1]);
$albumid = $albumid[0];
} else if(strstr($albumid[1], '&deleteahit')){
$albumid = explode('&deleteahit', $albumid[1]);
$albumid = $albumid[0];
}
else{
$_SESSION['page_infos'] = array('error');
redirect($_SERVER['REQUEST_URI']);
}
$query = 'select image_id FROM ' . IMAGE_CATEGORY_TABLE . ' WHERE category_id = '.$albumid.';';
$result = pwg_query($query);
$delval = array();
while($row = pwg_db_fetch_assoc($result))
{
array_push($delval, $row['image_id']);
}
foreach ($delval as $delrate)
{
$query = 'UPDATE ' . IMAGES_TABLE . ' SET hit= \'0\' WHERE id = \''.$delrate.'\';';
$result = pwg_query($query);
}
redirect($admin_base_url[0]);
}
if (isset($_GET['deletearate'])) {
$admin_base_url=explode('&deletearate', $_SERVER['REQUEST_URI']);
$albumid = explode('album-', $_SERVER['REQUEST_URI']);
if(strstr($albumid[1], '-properties')){
$albumid = explode('-properties', $albumid[1]);
$albumid = $albumid[0];
} else if(strstr($albumid[1], '&deletearate')){
$albumid = explode('&deletearate', $albumid[1]);
$albumid = $albumid[0];
}
else{
$_SESSION['page_infos'] = array('error');
redirect($_SERVER['REQUEST_URI']);
}
$query = 'select image_id FROM ' . IMAGE_CATEGORY_TABLE . ' WHERE category_id = '.$albumid.';';
$result = pwg_query($query);
$delval = array();
while($row = pwg_db_fetch_assoc($result))
{
array_push($delval, $row['image_id']);
}
foreach ($delval as $delrate)
{
$query = 'UPDATE ' . IMAGES_TABLE . ' SET rating_score = \'NULL\' WHERE id = \''.$delrate.'\';';
$result = pwg_query($query);
$query = 'DELETE FROM ' . RATE_TABLE . ' WHERE element_id = \''.$delrate.'\';';
$result = pwg_query($query);
}
redirect($admin_base_url[0]);
}
}
?>