mambax7 / XoopsCore25

    }

    // waiting content for mylinks

    if (xoops_isActiveModule('mylinks') && $module_handler->getCount(new Criteria('dirname', 'mylinks'))) {

        $result = $xoopsDB->query('SELECT COUNT(*) FROM ' . $xoopsDB->prefix('mylinks_links') . ' WHERE status=0');

        if ($result) {

            $block['modules'][1]['adminlink'] = XOOPS_URL . '/modules/mylinks/admin/index.php?op=listNewLinks';

            list($block['modules'][1]['pendingnum']) = $xoopsDB->fetchRow($result);

            $block['modules'][1]['lang_linkname'] = _MB_SYSTEM_WLNKS;

        }

        $result = $xoopsDB->query('SELECT COUNT(*) FROM ' . $xoopsDB->prefix('mylinks_broken'));

        if ($result) {

            $block['modules'][2]['adminlink'] = XOOPS_URL . '/modules/mylinks/admin/index.php?op=listBrokenLinks';

            list($block['modules'][2]['pendingnum']) = $xoopsDB->fetchRow($result);

            $block['modules'][2]['lang_linkname'] = _MB_SYSTEM_BLNK;

        }

        $result = $xoopsDB->query('SELECT COUNT(*) FROM ' . $xoopsDB->prefix('mylinks_mod'));

        if ($result) {

            $block['modules'][3]['adminlink'] = XOOPS_URL . '/modules/mylinks/admin/index.php?op=listModReq';

            list($block['modules'][3]['pendingnum']) = $xoopsDB->fetchRow($result);

            $block['modules'][3]['lang_linkname'] = _MB_SYSTEM_MLNKS;

        }

    }

    // waiting content for mydownloads

    if (xoops_isActiveModule('mydownloads') && $module_handler->getCount(new Criteria('dirname', 'mydownloads'))) {

    }

    // waiting content for mydownloads

    if (xoops_isActiveModule('mydownloads') && $module_handler->getCount(new Criteria('dirname', 'mydownloads'))) {

        $result = $xoopsDB->query('SELECT COUNT(*) FROM ' . $xoopsDB->prefix('mydownloads_downloads') . ' WHERE status=0');

        if ($result) {

            $block['modules'][4]['adminlink'] = XOOPS_URL . '/modules/mydownloads/admin/index.php?op=listNewDownloads';

            list($block['modules'][4]['pendingnum']) = $xoopsDB->fetchRow($result);

            $block['modules'][4]['lang_linkname'] = _MB_SYSTEM_WDLS;

        }

        $result = $xoopsDB->query('SELECT COUNT(*) FROM ' . $xoopsDB->prefix('mydownloads_broken') . '');

        if ($result) {

            $block['modules'][5]['adminlink'] = XOOPS_URL . '/modules/mydownloads/admin/index.php?op=listBrokenDownloads';

            list($block['modules'][5]['pendingnum']) = $xoopsDB->fetchRow($result);

            $block['modules'][5]['lang_linkname'] = _MB_SYSTEM_BFLS;

        }

        $result = $xoopsDB->query('SELECT COUNT(*) FROM ' . $xoopsDB->prefix('mydownloads_mod') . '');

        if ($result) {

            $block['modules'][6]['adminlink'] = XOOPS_URL . '/modules/mydownloads/admin/index.php?op=listModReq';

            list($block['modules'][6]['pendingnum']) = $xoopsDB->fetchRow($result);

            $block['modules'][6]['lang_linkname'] = _MB_SYSTEM_MFLS;

        }

    }

    // waiting content for xoops comments

    $result = $xoopsDB->query('SELECT COUNT(*) FROM ' . $xoopsDB->prefix('xoopscomments') . ' WHERE com_status=1');