root/dev/common/groupdb.php

Revision 343, 0.9 KB (checked in by beans, 14 years ago)

A lot of updates done by Karbowiak (LaMaH).
See them here:  http://eve-id.net/forum/viewtopic.php?f=503&t=13204&p=15284#p15284

Highlights:
* Integrated feed fetcher & API Mod into the core
* memcached support in core

Line 
1<?php
2if (!$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?>
Note: See TracBrowser for help on using the browser.