function arcmaj3_wint()
{
$main_console = new FluidActive('Arcmaj3 statistics web console');
$db = new FractureDB('futuqiur_arcmaj3');
#$main_console->DBTextEntry($db, 'am_urls', 'location', 0);
#$main_console->DBRowEntry($db, 'am_urls', 1);
#$main_console->DBTableEntry($db, 'am_urls');
#$main_console->DBRowEntry($db, 'am_urls', 1);
#$main_console->getQueryCount($db);
$allProjects = $db->getTable('am_projects');
$main_console->append('<small>');
$main_console->append('<big><b>Overall</b></big><br>');
$total = $db->countTable('am_urls');
$total = $total[0];
$total = $total['COUNT(*)'];
#print_r($total);
$crawled = $db->countRows('am_urls', ' WHERE barrel != \'0\'');
$crawled = $crawled[0];
$crawled = $crawled['COUNT(*)'];
#print_r($crawled);
$remaining = $total - $crawled;
if ($total == 0) {
$pcCr = 0;
$pcRm = 0;
} else {
$pcCr = round($crawled / $total * 100, 2);
$pcRm = round($remaining / $total * 100, 2);
}
$main_console->append('Total URLs: ' . $total . '<br>');
$main_console->append('Remaining URLs: ' . $remaining . ' (' . $pcRm . '%)<br>');
$main_console->append('Crawled URLs: ' . $crawled . ' <b>(' . $pcCr . '%)</b><br>');
foreach ($allProjects as $index => $data) {
$main_console->append('<br><br><big><b>Project: ' . $data['urlPattern'] . ' (ID ' . $data['id'] . ')</b></big><br>');
$total = $db->countTable('am_urls', 'project', $data['id']);
$total = $total[0];
$total = $total['COUNT(*)'];
#print_r($total);
$crawled = $db->countTable('am_urls', 'project', $data['id'], ' AND barrel != \'0\'');
$crawled = $crawled[0];
$crawled = $crawled['COUNT(*)'];
#print_r($crawled);
$remaining = $total - $crawled;
if ($total == 0) {
$pcCr = 0;
$pcRm = 0;
} else {
$pcCr = round($crawled / $total * 100, 2);
$pcRm = round($remaining / $total * 100, 2);
}
$main_console->append('Total URLs: ' . $total . '<br>');
$main_console->append('Remaining URLs: ' . $remaining . ' (' . $pcRm . '%)<br>');
$main_console->append('Crawled URLs: ' . $crawled . ' <b>(' . $pcCr . '%)</b><br>');
}
$main_console->append('</small>');
$main_console->close();
$db->close();
}
