//
// Display admins tools in block
//

function adminblock() {
    global $admin, $db, $prefix;
    
        if (is_admin($admin)) {
            $result = $db->sql_query("SELECT title, content FROM ".UN_TABLENAME_BLOCKS." WHERE bkey='admin'");
                while ($row = $db->sql_fetchrow($result)) {
                    $content = "<font class=\"content\">".$row['content']."</font>";
                    themesidebox($row['title'], str_replace("admin.php",UN_FILENAME_ADMIN, stripslashes($row['content'])));
                }
            $db->sql_freeresult($result);
            $title = _WAITINGCONT;
            $result1 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_QUEUE);
            $row1 = $db->sql_fetchrow($result1);
            $db->sql_freeresult($result1);
            $num = $row1['numrows'];
            $content = "<font class=\"content\">";
            $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".UN_FILENAME_ADMIN."?op=submissions\">"._SUBMISSIONS."</a>: ".$num."<br>";
            $result2 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_REVIEWS_ADD);
            $row2 = $db->sql_fetchrow($result2);
            $db->sql_freeresult($result2);
            $num = $row2['numrows'];
            $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".UN_FILENAME_ADMIN."?op=reviews\">"._WREVIEWS."</a>: ".$num."<br>";
            $result3 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_LINKS_NEWLINK);
            $row3 = $db->sql_fetchrow($result3);
            $db->sql_freeresult($result3);
            $num = $row3['numrows'];
            $result4 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_LINKS_MODREQUEST." WHERE brokenlink='1'");
            $row4 = $db->sql_fetchrow($result4);
            $db->sql_freeresult($result4);
            $brokenl = $row4['numrows'];
            $result5 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_LINKS_MODREQUEST." WHERE brokenlink='0'");
            $row5 = $db->sql_fetchrow($result5);
            $db->sql_freeresult($result5);
            $modreql = $row5['numrows'];
            $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".UN_FILENAME_ADMIN."?op=Links\">"._WLINKS."</a>: ".$num."<br>";
            $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".UN_FILENAME_ADMIN."?op=LinksListModRequests\">"._MODREQLINKS."</a>: ".$modreql."<br>";
            $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".UN_FILENAME_ADMIN."?op=LinksListBrokenLinks\">"._BROKENLINKS."</a>: ".$brokenl."<br>";
            $result6 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_DOWNLOADS_NEWDOWNLOAD);
            $row6 = $db->sql_fetchrow($result6);
            $db->sql_freeresult($result6);
            $num = $row6['numrows'];
            $result7 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_DOWNLOADS_MODREQUEST." WHERE brokendownload='1'");
            $row7 = $db->sql_fetchrow($result7);
            $db->sql_freeresult($result7);
            $brokend = $row7['numrows'];
            $result8 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".UN_TABLENAME_DOWNLOADS_MODREQUEST." WHERE brokendownload='0'");
            $row8 = $db->sql_fetchrow($result8);
            $db->sql_freeresult($result8);
            $modreqd = $row8['numrows'];;
            $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".UN_FILENAME_ADMIN."?op=downloads\">"._UDOWNLOADS."</a>: ".$num."<br>";
            $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".UN_FILENAME_ADMIN."?op=DownloadsListModRequests\">"._MODREQDOWN."</a>: ".$modreqd."<br>";
            $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".UN_FILENAME_ADMIN."?op=DownloadsListBrokenDownloads\">"._BROKENDOWN."</a>: ".$brokend."<br></font>";

/** BW_Downloads *********************************************/
            $result9 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".$prefix."_downloads_newdownload_bw");
            $row9 = $db->sql_fetchrow($result9);
            $db->sql_freeresult($result9);
            $num = $row9['numrows'];
            $result10 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".$prefix."_downloads_modrequest_bw WHERE brokendownload='1'");
            $row10 = $db->sql_fetchrow($result10);
            $db->sql_freeresult($result10);
            $brokend = $row10['numrows'];
            $result11 = $db->sql_query("SELECT COUNT(*) AS numrows FROM ".$prefix."_downloads_modrequest_bw WHERE brokendownload='0'");
            $row11 = $db->sql_fetchrow($result11);
            $db->sql_freeresult($result11);
            $modreqd = $row11['numrows'];;
            $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".UN_FILENAME_ADMIN."?op=downloads2\">BW:"._UDOWNLOADS."</a>: ".$num."<br>";
            $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".UN_FILENAME_ADMIN."?op=DownloadsListModRequests2\">BW:"._MODREQDOWN."</a>: ".$modreqd."<br>";
            $content .= "<strong><big>&middot;</big></strong>&nbsp;<a href=\"".UN_FILENAME_ADMIN."?op=DownloadsListBrokenDownloads2\">BW:"._BROKENDOWN."</a>: ".$brokend."<br></font>";

            themesidebox($title, $content);
        }
}