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