From ed59e1b3c6ebf1b4fb114264db19b7b21eb54468 Mon Sep 17 00:00:00 2001 From: raylu Date: Wed, 23 Oct 2013 01:16:34 -0700 Subject: ship as item on kill, hide cents also, set height on kill page so loading images doesn't adjust heights and fix firefox kill_list ellipsis --- db/queries.py | 9 +++++++-- 1 file changed, 7 insertions(+), 2 deletions(-) (limited to 'db') diff --git a/db/queries.py b/db/queries.py index a4605e8..a1963bf 100644 --- a/db/queries.py +++ b/db/queries.py @@ -92,6 +92,13 @@ def kill(kill_id): else: attackers.append(char) + try: + ship_cost = db.get(c, 'SELECT cost FROM item_costs WHERE type_id = ?', + victim['ship_type_id']) + victim['ship_cost'] = ship_cost['cost'] + except db.NoRowsException: + victim['ship_cost'] = 0 + item_rows = db.query(c, ''' SELECT items.type_id, flag, dropped, destroyed, singleton, cost, typeName AS item_name, capacity @@ -169,8 +176,6 @@ def top_cost(): ORDER BY cost DESC LIMIT 25 ''') - #for kill in kills: - # kill['kill_time'] = _format_kill_time(kill['kill_time']) return kills def _format_kill_time(kill_time): -- cgit v1.2.3