Line | |
---|
1 | <?php |
---|
2 | if (!$id = intval($_GET['id'])) |
---|
3 | { |
---|
4 | $page = new Page('Error'); |
---|
5 | $page->setContent('No valid ID specified.'); |
---|
6 | $page->generate(); |
---|
7 | exit; |
---|
8 | } |
---|
9 | |
---|
10 | $sql = 'SELECT * FROM kb3_item_types d |
---|
11 | WHERE d.itt_id = '.$id; |
---|
12 | $qry = new DBQuery(); |
---|
13 | $qry->execute($sql); |
---|
14 | $row = $qry->getRow(); |
---|
15 | |
---|
16 | $page = new Page('Item Database - '.$row['itt_name'].' Index'); |
---|
17 | |
---|
18 | $sql = 'SELECT * FROM kb3_invtypes d |
---|
19 | WHERE d.groupID = '.$id.' |
---|
20 | ORDER BY d.typeName ASC'; |
---|
21 | $qry = new DBQuery(); |
---|
22 | $qry->execute($sql); |
---|
23 | $html .= "<table class=kb-table cellspacing=1>"; |
---|
24 | $html .= "<tr class=kb-table-header><td width=400>Item Name</td></tr>"; |
---|
25 | while ($row = $qry->getRow()) |
---|
26 | { |
---|
27 | $html .= '<tr class=kb-table-row-odd><td><a href="?a=invtype&id='.$row['typeID'].'">'.$row['typeName'].'</a></td></tr>'; |
---|
28 | } |
---|
29 | $html .= "</table>"; |
---|
30 | |
---|
31 | $page->setContent($html); |
---|
32 | $page->generate(); |
---|
33 | ?> |
---|