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