$optionForm->addButton('submit', 'View useless defaultsorts'); $optionForm->addHTML('</td></tr>'); $optionForm->addHTML('</table>'); $optionForm->output(); $page->closeBlock(); if ($rq->allRequiredDefined() == true) { $page->openBlock('div', 'iw-content'); $page->addInline('h2', 'Results'); $db->replicaConnect(Database::getName($par['lang'], $par['project'])); $t1 = 'SELECT page_title, page_namespace, pp_value FROM page, page_props'; $t1 .= ' WHERE pp_propname = \'defaultsort\' AND pp_page = page_id AND REPLACE(page_title, \'_\', \' \') = pp_value'; $t1 .= ' ORDER BY page_namespace, page_title;'; $q1 = $db->query($t1); if ($q1->num_rows === 0) { $page->addInline('p', 'there were no results for this query', 'iw-info'); } else { $page->openBlock('table', 'iw-table'); $page->addInline('tr', '<th>Page</th><th>Defaultsort</th>'); while ($l1 = $q1->fetch_assoc()) { $page->openBlock('tr'); $page->addInline('td', Hgz::buildWikilink($par['lang'], $par['project'], Database::getNsNameFromNr($l1['page_namespace']) . $l1['page_title'], Database::getNsNameFromNr($l1['page_namespace'], false) . str_replace('_', ' ', $l1['page_title']))); $page->addInline('td', $l1['pp_value']); $page->closeBlock(); } $page->closeBlock(); } $q1->close(); $page->closeBlock(); } $db->close(); $page->output();