and validate_state = 1";
*/
$conn = mysql_connect("localhost", "USERNAME", "PASSWORD");
mysql_select_db("DATABASE");
$result = mysql_query($getfiles, $conn);
$i = 0;
while ($row = mysql_fetch_array($result)) {
$results[$i++] = $row;
}
echo "Got " . count($results) . " results to go through...\n";
for ($i = 0; $i < count($results); $i++) {
if ($i % 10 == 0) {
echo ".";
}
$results[$i]['linesinfile'] = coalesce(linesInFile(ROOT . '../wordlists/categorized/special/' . $results[$i]['wordlist']), linesInFile(ROOT . '../wordlists/categorized/foreign/' . $results[$i]['wordlist']), linesInFile(ROOT . '../wordlists/categorized/uppercase/' . $results[$i]['wordlist']), linesInFile(ROOT . '../wordlists/categorized/english/' . $results[$i]['wordlist']), linesInFile(ROOT . 'wordlists/extralarge/' . $results[$i]['wordlist']), linesInFile(ROOT . 'markovlists/lvl123/' . $results[$i]['wordlist']), 0);
$results[$i]['cracked'] = linesInFile(ROOT . 'sample_results/' . $results[$i]['potfile']);
$results[$i]['cracks/sec'] = getCryptsec(ROOT . 'sample_results/' . $results[$i]['logfile']);
$results[$i]['time'] = getTimeRun(ROOT . 'sample_results/' . $results[$i]['logfile']);
}
echo "\n";
$sql = "INSERT INTO result_cudaparsed ";
for ($i = 0; $i < count($results); $i++) {
$sql .= $i != 0 ? " UNION ALL\nSELECT " : "\nSELECT ";
$sql .= $results[$i]['id'] . " as id, ";
$sql .= $results[$i]['linesinfile'] . " as linesinfile, ";
$sql .= $results[$i]['cracked'] . " as cracked, ";
$sql .= $results[$i]['cracks/sec'] . " as cryptsec, ";
$sql .= $results[$i]['time'] . " as total_sec, '";
$sql .= $results[$i]['wordlist'] . "' as wordlist ";
}
echo $sql . "\n\n";
function createParameters($app, $params, &$fpops)
{
global $rulesfile_stamped, $configfile_stamped, $wordlist_stamped, $user_john_options, $user_hashcat_options, $user_cudahashcat_plus_options, $wordlistFlags, $resource_allocation, $hashformat;
$d = "";
$fpops = getFactorOfApp();
if ($app == "john") {
$configFlags = JOHN_HEADER;
$d .= " --format=" . $hashformat[getAppSubType() . '-format'];
$d .= " " . $user_john_options . " ";
if (isset($params['wordlist'])) {
$d .= " --wordlist=<<WORDLIST>> ";
if (isset($params['rules'])) {
$d .= " --rules ";
$configFlags |= JOHN_WORDLISTRULES;
$configFlags |= $params['wordlist-flags'];
$fpops *= getWLRuleMultiplicationFactor($params['wordlist-flags']);
}
$fpops *= linesInFile($params['wordlist']);
} else {
if (isset($params['bruteforce'])) {
$fpops = 0;
$i = $params['max-length'];
while ($i > $params['min-length']) {
$fpops += getFactorOfApp() * pow(strlen($params['charset']), $i);
$i--;
}
if (stristr($params['charset'], "a") === false) {
$d .= " --incremental=digits ";
$configFlags |= JOHN_INCREMENTAL_DIGITS_6;
} else {
$d .= " --incremental=all ";
switch ($params['max-length']) {
case 4:
$configFlags |= JOHN_INCREMENTAL_ALL_4;
break;
case 5:
$configFlags |= JOHN_INCREMENTAL_ALL_5;
break;
case 6:
$configFlags |= JOHN_INCREMENTAL_ALL_6;
break;
case 7:
$configFlags |= JOHN_INCREMENTAL_ALL_7;
break;
default:
$configFlags |= JOHN_INCREMENTAL_ALL_3;
break;
}
}
}
}
$configfile_stamped = makeConfigFile($configFlags);
} else {
if (getAppType() == "hashcat") {
if (getAppSubType() == "hashcat") {
$d .= " -m " . $hashformat[getAppSubType() . '-format'];
$d .= " " . $user_hashcat_options . " ";
} else {
if (getAppSubType() == "cudahashcat+") {
$d .= " -m " . $hashformat[getAppSubType() . '-format'];
$d .= " " . $user_cudahashcat_plus_options . " ";
} else {
die("unrecognized app\n");
}
}
if ($params['bruteforce'] && $app != "hashcat") {
echo "ERROR: Tried to use cudahashcat+ with brute-force, application doesn't support that\n";
exit;
} else {
if ($params['bruteforce']) {
$d .= " -a 3 ";
if (isset($params['charset'])) {
$d .= " --bf-cs-buf=\"" . $params['charset'] . "\" ";
}
if (isset($params['min-length'])) {
$d .= " --bf-pw-min=" . $params['min-length'] . " ";
}
if (isset($params['max-length'])) {
$d .= " --bf-pw-max=" . $params['max-length'] . " ";
}
$fpops = 0;
$i = $params['max-length'];
while ($i > $params['min-length']) {
$fpops += getFactorOfApp() * pow(strlen($params['charset']), $i);
$i--;
}
}
}
$d .= " passwordlist ";
//Matches the template file
if (!$params['bruteforce'] && $params['wordlist']) {
$d .= " wordlist ";
$fpops *= linesInFile($params['wordlist']);
if (isset($params['rules'])) {
$d .= " --rules-file=wordlist-rules";
$fpops *= getWLRuleMultiplicationFactor($params['wordlist-flags']);
$rulesfile_stamped = makeRulesFile($params['wordlist-flags']);
}
}
} else {
die("WTF?");
}
}
if ($resource_allocation != "intelligent") {
$hours = str_replace("H", "", $resource_allocation);
$tmpfpops = $hours * 60 * 60 * ONESECOND_ON_A_FAST_MACHINE / 10;
$fpops = max($fpops, $tmpfpops);
} else {
if (getAppSubType() == "cudahashcat+") {
die("Tried to use intelligent resource estimate on cudahashcat+ - not really possible.\n");
}
}
return $d;
}
and validate_state = 1";
*/
$conn = mysql_connect("localhost", "USERNAME", "PASSWORD");
mysql_select_db("DATABASE");
$result = mysql_query($getfiles, $conn);
$i = 0;
while ($row = mysql_fetch_array($result)) {
$results[$i++] = $row;
}
echo "Got " . count($results) . " results to go through...\n";
for ($i = 0; $i < count($results); $i++) {
if ($i % 10 == 0) {
echo ".";
}
if ($results[$i]['linesinfile'] < 0 && $results[$i]['wordlist'] != "bruteforce") {
$results[$i]['linesinfile'] = coalesce(linesInFile(ROOT . 'wordlists/categorized/special/' . $results[$i]['wordlist']), linesInFile(ROOT . 'wordlists/categorized/foreign/' . $results[$i]['wordlist']), linesInFile(ROOT . 'wordlists/categorized/uppercase/' . $results[$i]['wordlist']), linesInFile(ROOT . 'wordlists/categorized/english/' . $results[$i]['wordlist']), linesInFile(ROOT . 'wordlists/extralarge/' . $results[$i]['wordlist']), linesInFile(ROOT . 'markovlists/lvl123/' . $results[$i]['wordlist']));
}
if ($results[$i]['linesinfile'] < 0 || empty($results[$i]['linesinfile'])) {
$results[$i]['linesinfile'] = 0;
}
//$results[$i]['cracked'] = linesInFile(ROOT . 'sample_results/' . $results[$i]['potfile']);
//$results[$i]['cracks/sec'] = getCryptsec(ROOT . 'sample_results/' . $results[$i]['logfile']);
//$results[$i]['time'] = getTimeRun(ROOT . 'sample_results/' . $results[$i]['logfile']);
}
echo "\n";
$sql = "INSERT INTO result_johnparsed ";
for ($i = 0; $i < count($results); $i++) {
$sql .= $i != 0 ? " UNION ALL\nSELECT " : "\nSELECT ";
$sql .= $results[$i]['id'] . " as id, ";
$sql .= $results[$i]['linesinfile'] . " as linesinfile, '";
$sql .= $results[$i]['wordlist'] . "' as wordlist ";
