1
MS-2001
Waiting Content + new Query
  • 2004/9/21 16:37

  • MS-2001

  • Quite a regular

  • Posts: 204

  • Since: 2004/7/27


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?

2
DonXoop
Re: Waiting Content + new Query

You might try a Waiting Block replacement: Extensible Waiting Block Module. Already set-up for your module and has an On/Off option so the block only shows when there is waiting content.

3
MS-2001
Re: Waiting Content + new Query
  • 2004/9/22 14:11

  • MS-2001

  • Quite a regular

  • Posts: 204

  • Since: 2004/7/27


ok, i'll try. but i still wonder why my method isn't working :-/

Login

Who's Online

240 user(s) are online (144 user(s) are browsing Support Forums)


Members: 0


Guests: 240


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Mar 31
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits