source: extensions/delete_hit_rate/initadmin.php @ 12999

<?php
if (!defined('PHPWG_ROOT_PATH')) die('Hacking attempt!');

define('PDHR_DIR' , basename(dirname(__FILE__)));
define('PDHR_PATH' , PHPWG_PLUGINS_PATH . PDHR_DIR . '/');
load_language('plugin.lang', PDHR_PATH);

add_event_handler('get_admin_plugin_menu_links', 'dphr_admin_menu');
function dphr_admin_menu($menu)
{
  array_push($menu, array(
        'NAME' => 'Delete Hit Rate',
    'URL' => get_admin_plugin_menu_link(PDHR_PATH . 'admin/admin.php')));
  return $menu;
}


//add prefiltre photo
add_event_handler('loc_begin_admin', 'plugdphrPf',60);

function plugdphrPf()
        {
        global $template;
        $template->set_prefilter('picture_modify', 'plugdphrPT');
        }

function plugdphrPT($content, &$smarty)
        {
load_language('plugin.lang', PDHR_PATH);
  $search = '#<form id="associations"#';
  
  $replacement = '
        <div>
                <form method="post" >
                        <fieldset>
                                <legend>{\'Purge - Plugin Delete Hit/Rate\'|@translate}</legend>
                                        <div style="text-align:center;">
                                        <input class="submit" name="plugdphphoto" type="submit" onclick="return confirm(\'{\'Are you sure?\'|@translate|@escape:\'javascript\'}\');" value="{\'Purge hit of the photo\'|@translate}" {$TAG_INPUT_ENABLED} />
                                        <input class="submit" name="plugdprphoto" type="submit" onclick="return confirm(\'{\'Are you sure?\'|@translate|@escape:\'javascript\'}\');" value="{\'Purge rate of the photo\'|@translate}" {$TAG_INPUT_ENABLED} />
                                        </div>
                        </fieldset>
                </form>
        </div>
  <form id="associations"';

  return preg_replace($search, $replacement, $content);
        }
 
if (isset($_POST['plugdphphoto']))
 {
        $query = '
UPDATE ' . IMAGES_TABLE . '
  SET hit= \'0\'
  WHERE id = '.$_GET['image_id'].'
    ;';
$result = pwg_query($query);
  }

if (isset($_POST['plugdprphoto']))
 {
        $query = '
UPDATE ' . IMAGES_TABLE . '
  SET rating_score = \'NULL\'
  WHERE id = '.$_GET['image_id'].'
    ;';
$result = pwg_query($query);

        $query = '
  DELETE FROM ' . RATE_TABLE . '
  WHERE element_id = '.$_GET['image_id'].'
    ;';
$result = pwg_query($query);
  }
  
  
//add prefiltre album
add_event_handler('loc_end_cat_modify', 'plugdphrAf');

function plugdphrAf()
 {
        global $template;
        $template->set_prefilter('categories', 'plugdphrAT');
 }

function plugdphrAT($content, &$smarty)
 {
load_language('plugin.lang', PDHR_PATH);
  $search = '#name="reset">
</p>#';
  
  $replacement = 'name="reset">
</p>

        <div>
                <form method="post" >
                        <fieldset>
                                <legend>{\'Purge - Plugin Delete Hit/Rate\'|@translate}</legend>
                                        <div style="text-align:center;">
                                        <input class="submit" name="plugdphA" type="submit" onclick="return confirm(\'{\'Are you sure?\'|@translate|@escape:\'javascript\'}\');" value="{\'Purge hits on all pictures album\'|@translate}" {$TAG_INPUT_ENABLED} />
                                        <input class="submit" name="plugdprA" type="submit" onclick="return confirm(\'{\'Are you sure?\'|@translate|@escape:\'javascript\'}\');" value="{\'Purge rates on all pictures album\'|@translate}" {$TAG_INPUT_ENABLED} />
                                        </div>
                        </fieldset>
                </form>
        </div>
  ';

  return preg_replace($search, $replacement, $content);
 }
 
 
if (isset($_POST['plugdphA']))
 {
        $query = '
select image_id
  FROM ' . IMAGE_CATEGORY_TABLE . '
  WHERE category_id = '.$_GET['cat_id'].'
  ;';
$result = pwg_query($query);

$delval = array();
while($row = mysql_fetch_array($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);
        }
 }

if (isset($_POST['plugdprA']))
 {
        $query = '
select image_id
  FROM ' . IMAGE_CATEGORY_TABLE . '
  WHERE category_id = '.$_GET['cat_id'].'
  ;';
$result = pwg_query($query);

$delval = array();
while($row = mysql_fetch_array($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);
        }
 } 

?>