summaryrefslogtreecommitdiffstats
path: root/admin
diff options
context:
space:
mode:
authorDominique Martinet <asmadeus@codewreck.org>2014-02-19 07:53:08 +0100
committerDominique Martinet <asmadeus@codewreck.org>2015-11-08 14:27:59 +0100
commit4ebfd5fc8437cae25402f4e86733eadeefe002b6 (patch)
tree91163f126da2488497c38e92b43b80a960d6b8d6 /admin
parentac6a52503fcbfaefcb97fd3d913015abe9666b7f (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.php17
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.'&amp;o='.$current_order['uri']['current'], $total_items, $user->data['user_ilimit'], $start);
+$pagination = generate_pagination('listitems.php'.$SID.'&amp;o='.$current_order['uri']['current'].($filter ? '&amp;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
+?>