function updateAllCourthouses($jconfig)
{
$dbCon = connectTo($jconfig, "Justice", TRUE, FALSE);
$sqlAllCourthouses = "SELECT `address`,`port`,`username`,`userpass` FROM Courthouses;";
$allCH = $dbCon->query($sqlAllCourthouses);
$sqlAllWords = "SELECT * from Words ORDER BY `id`;";
echo "Retrieving all words...\n";
$allWords = $dbCon->query($sqlAllWords);
// Convert the words to a suitable insertion statement
$sqlInsertWords = "INSERT IGNORE INTO `Words` (`id`, `word`) VALUES ";
while ($wordRecord = $allWords->fetch_row()) {
$wid = $wordRecord[0];
$word = $wordRecord[1];
$sqlInsertWords .= "( '" . $wid . "', '" . $word . "' ),";
}
$sqlInsertWords = substr($sqlInsertWords, 0, -1) . ";";
$sqlAllTargets = "SELECT * from `Targets` ORDER BY `id`;";
echo "Retrieving all unsolved targets...\n";
$allTargets = $dbCon->query($sqlAllTargets);
// Convert the targets to a suitable insertion statement
$sqlInsertTargets = "TRUNCATE TABLE `Targets`; INSERT IGNORE INTO `Targets` (`id`, `ishash`, `isbenchmark`, `hashtype_id`, `hash_value`, `confidence` ) VALUES ";
while ($targetRecord = $allTargets->fetch_row()) {
if (is_null($targetRecord[5])) {
$tID = $targetRecord[0];
$tIH = $targetRecord[1];
$tBM = $targetRecord[2];
$tHI = $targetRecord[3];
$tHV = $targetRecord[4];
$tCF = $targetRecord[6];
$sqlInsertTargets .= "( '" . $tID . "', '" . $tIH . "', '" . $tBM . "', '" . $tHI . "', '" . $tHV . "', '" . $tCF . "' ),";
}
}
$sqlInsertTargets = substr($sqlInsertTargets, 0, -1) . ";";
while ($chRecord = $allCH->fetch_row()) {
$chAddress = $chRecord[0];
$chPort = $chRecord[1];
$chUser = $chRecord[2];
$chPass = $chRecord[3];
$chCon = connectManual($chAddress, $chUser, $chPort, $chPass, "Courthouse", FALSE);
echo "Pushing updated wordlist to " . $chAddress . ":" . $chPort . "\n";
$pushWords = $chCon->query($sqlInsertWords);
echo "Pushing updated targets to " . $chAddress . ":" . $chPort . "\n";
$pushTargets = $chCon->multi_query($sqlInsertTargets);
$chCon->close();
}
$dbCon->close();
userAck();
}
public function showAllSettings()
{
foreach ($this->settings as $section => $setting) {
echo $section . "\n";
echo "-----------------------\n";
foreach ($setting as $key => $value) {
echo " " . $key . " : " . $value . "\n";
}
}
userAck();
}
function showCourthouseStatus($chConfig)
{
$dbCon = connectTo($chConfig, "Courthouse", TRUE, FALSE);
$tempWordResults = $dbCon->query("SELECT COUNT(*) FROM Words");
$tempWord = $tempWordResults->fetch_row();
if (is_null($tempWord)) {
$wordCount = 0;
} else {
$wordCount = $tempWord[0];
}
$tempTargetResults = $dbCon->query("SELECT COUNT(*) FROM Targets");
$tempTarget = $tempTargetResults->fetch_row();
if (is_null($tempTarget)) {
$targetCount = 0;
} else {
$targetCount = $tempTarget[0];
}
$tempWordResults->close();
$tempTargetResults->close();
$dbCon->close();
echo "Statistics:\n";
echo "Words: " . $wordCount . "\n";
echo "Targets: " . $targetCount . "\n";
userAck();
}
