Moodleko ariketak dituzten akatsak
Lotutako hitzak berbaren dagokion sarreran erantsita azalduko dira.
array('data' => 'Akatsa', 'field' => 'pn.title', 'sort' => 'asc'),
'Arloa' => array('data' => 'Arloa', 'field' => 'td.name', 'sort' => 'asc'),
'Ariketa' => array('data' => 'Ariketa', 'field' => 'n.title', 'sort' => 'asc'),
'',
);
$order = isset($_GET['order']) ? $headers[$_GET['order']]['field'] : 'pn.title';
$sort = isset($_GET['sort']) ? $_GET['sort'] : 'asc';
$order_by = " ORDER BY $order $sort";
$result = db_query('SELECT n.nid, n.title, a.moodle, nr.pnid, nr.type, pn.title akats, td.name FROM node n
LEFT JOIN ariketa a ON n.nid = a.nid
LEFT JOIN node_relations nr ON n.nid = nr.nid AND nr.type = "509"
LEFT JOIN node pn ON nr.pnid = pn.nid
LEFT JOIN term_node tn ON pn.nid = tn.nid
LEFT JOIN term_data td ON tn.tid = td.tid
WHERE a.moodle != "" AND (td.vid = 11 OR ISNULL(td.vid))'.$order_by);
while($row = db_fetch_object($result)){
$title = l($row->title, "node/$row->nid");
$ariketa = 'Ikusi';
$akatsa = l($row->akats, "node/$row->pnid");
$arloa = $row->name;
$rows[] = array($akatsa, $arloa, $title, $ariketa);
}
print theme('table', $headers, $rows);
?>