Changeset 1817 for trunk/action.php


Ignore:
Timestamp:
Feb 14, 2007, 11:53:02 PM (17 years ago)
Author:
plg
Message:

New: history logs high quality access via action.php. A new column
#history.is_high was added. Filter was added on administration history
detail view.

Modification: function get_sql_condition_FandF was slightly refactored for
presentation improvement.

File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/action.php

    r1678 r1817  
    6262
    6363
    64 if ( !isset($_GET['id']) or !is_numeric($_GET['id'])
     64if (!isset($_GET['id'])
     65    or !is_numeric($_GET['id'])
    6566    or !isset($_GET['part'])
    6667    or !in_array($_GET['part'], array('t','e','i','h') ) )
     
    6970}
    7071
    71 $id = $_GET['id'];
    7272$query = '
    7373SELECT * FROM '. IMAGES_TABLE.'
    74   WHERE id='.$id.'
     74  WHERE id='.$_GET['id'].'
    7575;';
    7676
     
    8585// are not used because it's not necessary (filter <> restriction)
    8686$query='
    87 SELECT id FROM '.CATEGORIES_TABLE.'
    88   INNER JOIN '.IMAGE_CATEGORY_TABLE.'
    89   ON category_id=id
    90   WHERE image_id='.$id.'
    91 '.get_sql_condition_FandF(array('forbidden_categories' => 'category_id'), 'AND').'
     87SELECT id
     88  FROM '.CATEGORIES_TABLE.'
     89    INNER JOIN '.IMAGE_CATEGORY_TABLE.' ON category_id = id
     90  WHERE image_id = '.$_GET['id'].'
     91'.get_sql_condition_FandF(
     92  array('forbidden_categories' => 'category_id'),
     93  '    AND'
     94  ).'
    9295  LIMIT 1
    9396;';
     
    124127}
    125128
     129if ($_GET['part'] == 'h') {
     130  $is_high = true;
     131  pwg_log($_GET['id'], $is_high);
     132}
     133
    126134$http_headers = array();
    127135
Note: See TracChangeset for help on using the changeset viewer.