Note: I have added this to the bug list.
if ($module_handler->getCount(new Criteria('dirname', 'agendax')))
{
$result = $xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("agendax_events")." WHERE approved=0");
if ($result)
{
$block['modules'][8]['adminlink'] = XOOPS_URL."/modules/agendax/admin/index.php?op=listNewLinks";
list($block['modules'][8]['pendingnum']) = $xoopsDB->fetchRow($result);
$block['modules'][8]['lang_linkname'] = _MB_SYSTEM_WADRESS;
}
}
if ($module_handler->getCount(new Criteria('dirname', 'xdirectory')))
{
$result = $xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("xdir_links")." WHERE status=0");
if ($result)
{
$block['modules'][9]['adminlink'] = XOOPS_URL."/modules/xdirectory/admin/index.php?op=listNewLinks";
list($block['modules'][9]['pendingnum']) = $xoopsDB->fetchRow($result);
$block['modules'][9]['lang_linkname'] = _MB_SYSTEM_WADRESS;
}
$result = $xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("xdir_broken"));
if ($result)
{
$block['modules'][10]['adminlink'] = XOOPS_URL."/modules/xdirectory/admin/index.php?op=listBrokenLinks";
list($block['modules'][10]['pendingnum']) = $xoopsDB->fetchRow($result);
$block['modules'][10]['lang_linkname'] = _MB_SYSTEM_BADRESS;
}
$result = $xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("xdir_mod"));
if ($result)
{
$block['modules'][11]['adminlink'] = XOOPS_URL."/modules/xdirectory/admin/index.php?op=listModReq";
list($block['modules'][11]['pendingnum']) = $xoopsDB->fetchRow($result);
$block['modules'][11]['lang_linkname'] = _MB_SYSTEM_MADRESS;
}
}