echo htmlencode(subString($result[$j][$headers[$z]]));
}
echo "</td>";
}
echo "</tr>";
}
echo "</table><br/><br/>";
}
}
}
} else {
$delimiter = ";";
$queryStr = "SELECT * FROM " . $db->quote_id($target_table) . " WHERE 1";
}
echo "<fieldset>";
echo "<legend><b>" . sprintf($lang['run_sql'], htmlencode($db->getName())) . "</b></legend>";
echo "<form action='?table=" . urlencode($target_table) . "&action=table_sql' method='post'>";
if (isset($_SESSION['query_history']) && sizeof($_SESSION['query_history']) > 0) {
echo "<b>" . $lang['recent_queries'] . "</b><ul>";
foreach ($_SESSION['query_history'] as $key => $value) {
echo "<li><a onclick='document.getElementById(\"queryval\").value = this.textContent' href='#'>" . htmlencode($value) . "</a></li>";
}
echo "</ul><br/><br/>";
}
echo "<div style='float:left; width:70%;'>";
echo "<textarea style='width:97%; height:300px;' name='queryval' id='queryval' cols='50' rows='8'>" . htmlencode($queryStr) . "</textarea>";
echo "</div>";
echo "<div style='float:left; width:28%; padding-left:10px;'>";
echo $lang['fields'] . "<br/>";
echo "<select multiple='multiple' style='width:100%;' id='fieldcontainer'>";
$query = "PRAGMA table_info(" . $db->quote_id($target_table) . ")";
echo $result[$j][$headers[$z]];
echo "</td>";
}
echo "</tr>";
}
echo "</table><br/><br/>";
}
}
}
}
} else {
$delimiter = ";";
$queryStr = "SELECT * FROM " . $_GET['table'] . " WHERE 1";
}
echo "<fieldset>";
echo "<legend><b>Run SQL query/queries on database '" . $db->getName() . "'</b></legend>";
echo "<form action='" . PAGE . "?table=" . $_GET['table'] . "&action=table_sql' method='post'>";
echo "<div style='float:left; width:70%;'>";
echo "<textarea style='width:97%; height:300px;' name='queryval' id='queryval'>" . $queryStr . "</textarea>";
echo "</div>";
echo "<div style='float:left; width:28%; padding-left:10px;'>";
echo "Fields<br/>";
echo "<select multiple='multiple' style='width:100%;' id='fieldcontainer'>";
$query = "PRAGMA table_info('" . $_GET['table'] . "')";
$result = $db->selectArray($query);
for ($i = 0; $i < sizeof($result); $i++) {
echo "<option value='" . $result[$i][1] . "'>" . $result[$i][1] . "</option>";
}
echo "</select>";
echo "<input type='button' value='<<' onclick='moveFields();' class='btn'/>";
echo "</div>";
$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;
}
echo "class='tab_pressed'";
} else {
echo "class='tab'";
}
echo ">Structure</a>";
echo "<a href='" . PAGE . "?view=sql' ";
if ($view == "sql") {
echo "class='tab_pressed'";
} else {
echo "class='tab'";
}
echo ">SQL</a>";
echo "<div style='clear:both;'></div>";
echo "<div id='main'>";
if ($view == "structure") {
echo "<b>Database name</b>: " . $db->getName() . "<br/>";
echo "<b>Path to database</b>: " . $db->getPath() . "<br/>";
echo "<b>Size of database</b>: " . $db->getSize() . "<br/>";
echo "<b>Database last modified</b>: " . $db->getDate() . "<br/>";
echo "<b>SQLite version of database</b>: " . $db->getVersion() . "<br/>";
echo "<b>PHP extension used</b>: " . $db->getType() . "<br/><br/>";
$query = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name";
$result = $db->selectArray($query);
$j = 0;
for ($i = 0; $i < sizeof($result); $i++) {
if (substr($result[$i]['name'], 0, 7) != "sqlite_" && $result[$i]['name'] != "") {
$j++;
}
}
if ($j == 0) {
echo "No tables in database.<br/><br/>";
$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();
}
echo $result[$j][$headers[$z]];
echo "</td>";
}
echo "</tr>";
}
echo "</table><br/><br/>";
}
}
}
}
} else {
$delimiter = ";";
$queryStr = "SELECT * FROM `" . $_GET['table'] . "` WHERE 1";
}
echo "<fieldset>";
echo "<legend><b>Run SQL query/queries on database '" . $db->getName() . "'</b></legend>";
echo "<form action='" . PAGE . "?table=" . $_GET['table'] . "&action=table_sql' method='post'>";
echo "<div style='float:left; width:70%;'>";
echo "<textarea style='width:97%; height:300px;' name='queryval' id='queryval'>" . $queryStr . "</textarea>";
echo "</div>";
echo "<div style='float:left; width:28%; padding-left:10px;'>";
echo "Fields<br/>";
echo "<select multiple='multiple' style='width:100%;' id='fieldcontainer'>";
$query = "PRAGMA table_info('" . $_GET['table'] . "')";
$result = $db->selectArray($query);
for ($i = 0; $i < sizeof($result); $i++) {
echo "<option value='" . $result[$i][1] . "'>" . $result[$i][1] . "</option>";
}
echo "</select>";
echo "<input type='button' value='<<' onclick='moveFields();'/>";
echo "</div>";
/**
* Add a database to the list and sets the AppData property to this
* AppData
*
* @param Database|string $db the database to add
*
* @return Database
*/
public function addDatabase($db)
{
if ($db instanceof Database) {
$db->setAppData($this);
if ($db->getPlatform() === null) {
if ($config = $this->getGeneratorConfig()) {
$pf = $config->getConfiguredPlatform(null, $db->getName());
$db->setPlatform($pf ? $pf : $this->platform);
} else {
$db->setPlatform($this->platform);
}
}
$this->dbList[] = $db;
return $db;
} else {
// XML attributes array / hash
$d = new Database();
$d->setAppData($this);
$d->loadFromXML($db);
return $this->addDatabase($d);
// calls self w/ different param type
}
}
echo "class='tab_pressed'";
} else {
echo "class='tab'";
}
echo ">Structure</a>";
echo "<a href='" . PAGE . "?view=sql' ";
if ($view == "sql") {
echo "class='tab_pressed'";
} else {
echo "class='tab'";
}
echo ">SQL</a>";
echo "<div style='clear:both;'></div>";
echo "<div id='main'>";
if ($view == "structure") {
echo "<b>Database Name</b>: " . $db->getName() . "<br/>";
echo "<b>Path to Database</b>: " . $db->getPath() . "<br/>";
echo "<b>Database Version</b>: " . $db->getVersion() . "<br/>";
echo "<b>PHP Extension Used</b>: " . $db->getType() . "<br/><br/>";
$dbView->generateTableList();
} else {
if ($view == "sql") {
$dbView->generateSQL();
}
}
echo "</div>";
}
}
}
}
echo "</div>";
