PHP Database::getNsNameFromNr Examples

Example #1

File: index.php Project: hgzh/hgztools

$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();