1
I want to add AgendaX (Pending Events) to my Waiting Content Block. Therefor i used the following:
$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";
list($block['modules'][8]['pendingnum']) = $xoopsDB->fetchRow($result);
$block['modules'][8]['lang_linkname'] = 'Events';
}
But there is no "Events: xx" in my Block. I think $result is false (i just droped the if part then i saw the Events thing). but why? The SQL String is correct... the table exists
could someone help me plz?
