function b_system_waiting_show() { global $xoopsDB, $xoopsUser; $block = array(); $block['title'] = _MB_SYSTEM_WCNT; $block['content'] = ""; if (XoopsModule::moduleExists("news")) { $result = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("stories") . " WHERE published=0"); if ($result) { list($num) = $xoopsDB->fetchRow($result); $block['content'] .= "<strong><big>·</big></strong> <a href='" . XOOPS_URL . "/modules/news/admin/index.php?op=newarticle'>" . _MB_SYSTEM_SUBMS . "</a>: {$num}<br />\n"; } } if (XoopsModule::moduleExists("mylinks")) { $result = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("mylinks_links") . " WHERE status=0"); if ($result) { list($num) = $xoopsDB->fetchRow($result); $block['content'] .= "<strong><big>·</big></strong> <a href='" . XOOPS_URL . "/modules/mylinks/admin/index.php?op=listNewLinks'>" . _MB_SYSTEM_WLNKS . "</a>: {$num}<br />\n"; } $result = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("mylinks_broken") . ""); if ($result) { list($totalbrokenlinks) = $xoopsDB->fetchRow($result); $block['content'] .= "<strong><big>·</big></strong> <a href='" . XOOPS_URL . "/modules/mylinks/admin/index.php?op=listBrokenLinks'>" . _MB_SYSTEM_BLNK . "</a>: {$totalbrokenlinks}<br />\n"; } $result = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("mylinks_mod") . ""); if ($result) { list($totalmodrequests) = $xoopsDB->fetchRow($result); $block['content'] .= "<strong><big>·</big></strong> <a href='" . XOOPS_URL . "/modules/mylinks/admin/index.php?op=listModReq'>" . _MB_SYSTEM_MLNKS . "</a>: {$totalmodrequests}<br />\n"; } } if (XoopsModule::moduleExists("mydownloads")) { $result = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("mydownloads_downloads") . " WHERE status=0"); if ($result) { list($num) = $xoopsDB->fetchRow($result); $block['content'] .= "<strong><big>·</big></strong> <a href='" . XOOPS_URL . "/modules/mydownloads/admin/index.php?op=listNewDownloads'>" . _MB_SYSTEM_WDLS . "</a>: {$num}<br />\n"; } $result = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("mydownloads_broken") . ""); if ($result) { list($totalbrokenfiles) = $xoopsDB->fetchRow($result); $block['content'] .= "<strong><big>·</big></strong> <a href='" . XOOPS_URL . "/modules/mydownloads/admin/index.php?op=listBrokenDownloads'>" . _MB_SYSTEM_BFLS . "</a>: {$totalbrokenfiles}<br />\n"; } $result = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("mydownloads_mod") . ""); if ($result) { list($totalmodrequests) = $xoopsDB->fetchRow($result); $block['content'] .= "<strong><big>·</big></strong> <a href='" . XOOPS_URL . "/modules/mydownloads/admin/index.php?op=listModReq'>" . _MB_SYSTEM_MFLS . "</a>: {$totalmodrequests}<br />\n"; } } if (XoopsModule::moduleExists("tutorials")) { $result = $xoopsDB->query("SELECT COUNT(*) FROM " . $xoopsDB->prefix("tutorials") . " WHERE status=0"); if ($result) { list($num) = $xoopsDB->fetchRow($result); $block['content'] .= "<strong><big>·</big></strong> <a href='" . XOOPS_URL . "/modules/tutorials/admin/index.php'>" . _MB_SYSTEM_WTLS . "</a>: {$num}<br />\n"; } } return $block; }