$optionForm->addHTML('<option value="lesenswert">lesenswerte Artikel</option>');
$optionForm->addHTML('<option value="exzellent">exzellente Artikel</option>');
$optionForm->addHTML('<option value="informativ">informative Listen</option>');
$optionForm->addHTML('<option value="portal">informatives Portal</option>');
$optionForm->addHTML('</select>');
$optionForm->addHTML('</td></tr>');
$optionForm->addHTML('<tr><td colspan="2">');
$optionForm->addButton('submit', 'Abgleichen');
$optionForm->addHTML('</td></tr>');
$optionForm->addHTML('</table>');
$optionForm->output();
$page->closeBlock();
if ($rq->allRequiredDefined() == true) {
$page->openBlock('div', 'iw-content');
$page->addInline('h2', 'Ergebnisse');
$db->replicaConnect(Database::getName('de', 'wikipedia'));
$t1 = 'SELECT page_title FROM page, page_props';
switch ($par['mode']) {
case 'lesenswert':
$t1 .= ' WHERE pp_propname = \'wikibase-badge-Q17437798\' AND pp_page = page_id AND page_namespace = 0';
break;
case 'exzellent':
$t1 .= ' WHERE pp_propname = \'wikibase-badge-Q17437796\' AND pp_page = page_id AND page_namespace = 0';
break;
case 'informativ':
$t1 .= ' WHERE pp_propname = \'wikibase-badge-Q17506997\' AND pp_page = page_id AND page_namespace = 0';
break;
case 'portal':
$t1 .= ' WHERE pp_propname = \'wikibase-badge-Q17580674\' AND pp_page = page_id AND page_namespace = 100';
break;
}
$optionForm->addHTML('</td></tr>');
$optionForm->addHTML('<tr><td>');
$optionForm->addLabel('project', 'Project');
$optionForm->addHTML('</td><td>');
$optionForm->addInput('project', $par['project'], 'Project code, e.g wikipedia', 20, true);
$optionForm->addHTML('</td></tr>');
$optionForm->addHTML('<tr><td colspan="2">');
$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();
}
