diff options
author | Dominique Martinet <asmadeus@codewreck.org> | 2014-02-19 07:53:08 +0100 |
---|---|---|
committer | Dominique Martinet <asmadeus@codewreck.org> | 2015-11-08 14:27:59 +0100 |
commit | 4ebfd5fc8437cae25402f4e86733eadeefe002b6 (patch) | |
tree | 91163f126da2488497c38e92b43b80a960d6b8d6 /admin | |
parent | ac6a52503fcbfaefcb97fd3d913015abe9666b7f (diff) |
admin/listitem: eqdkp apparently uses the same template for this than regular listitem, might as well use the filter...
Also makes column width a bit less rigid, better for smaller screens
Diffstat (limited to 'admin')
-rw-r--r-- | admin/listitems.php | 17 |
1 files changed, 13 insertions, 4 deletions
diff --git a/admin/listitems.php b/admin/listitems.php index 8acf0b5..afb24c8 100644 --- a/admin/listitems.php +++ b/admin/listitems.php @@ -18,6 +18,13 @@ include_once($eqdkp_root_path . 'common.php'); $user->check_auth('a_item_');
+$filter = "";
+
+if (isset($_GET['filter']))
+{
+ $filter = "item_name like '%" . $db->escape($_GET['filter']) . "%'";
+}
+
$sort_order = array(
0 => array('item_date desc', 'item_date'),
1 => array('item_buyer', 'item_buyer desc'),
@@ -28,17 +35,17 @@ $sort_order = array( $current_order = switch_order($sort_order);
-$total_items = $db->query_first('SELECT count(*) FROM ' . ITEMS_TABLE);
+$total_items = $db->query_first('SELECT count(*) FROM ' . ITEMS_TABLE . ($filter ? " WHERE $filter" : ''));
$start = ( isset($_GET['start']) ) ? $_GET['start'] : 0;
$sql = 'SELECT i.item_id, i.item_name, i.item_buyer, i.item_date, i.raid_id, i.item_value, r.raid_name
FROM ' . ITEMS_TABLE . ' i, ' . RAIDS_TABLE . ' r
- WHERE r.raid_id=i.raid_id
+ WHERE r.raid_id=i.raid_id' . ($filter ? " AND $filter" : '') . '
ORDER BY '.$current_order['sql']. '
LIMIT '.$start.','.$user->data['user_ilimit'];
$listitems_footcount = sprintf($user->lang['listpurchased_footcount'], $total_items, $user->data['user_ilimit']);
-$pagination = generate_pagination('listitems.php'.$SID.'&o='.$current_order['uri']['current'], $total_items, $user->data['user_ilimit'], $start);
+$pagination = generate_pagination('listitems.php'.$SID.'&o='.$current_order['uri']['current'].($filter ? '&filter='.$_GET['filter']:''), $total_items, $user->data['user_ilimit'], $start);
if ( !($items_result = $db->query($sql)) )
{
@@ -62,6 +69,8 @@ while ( $item = $db->fetch_record($items_result) ) $db->free_result($items_result);
$tpl->assign_vars(array(
+ 'V_FILTER' => $_GET['filter'],
+ 'L_FILTER' => $user->lang['filter'],
'L_DATE' => $user->lang['date'],
'L_BUYER' => $user->lang['buyer'],
'L_ITEM' => $user->lang['item'],
@@ -87,4 +96,4 @@ $eqdkp->set_vars(array( 'template_file' => 'listitems.html',
'display' => true)
);
-?>
\ No newline at end of file +?>
|