1
I want to query the database (for how many messages there are in my inbox), so I can add it to my theme.
I have the ipboard module so the answer on the FAQ doesnt work. Heres the query:
Quote:
//<<<--------------------------------------------
//-+- IPB messages new -- Koudadnshi
//<<<--------------------------------------------
if ($isbb)
{
list($new_messages) = $xoopsDB->fetchRow($xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("ipb_messages")." WHERE recipient_id = '".$xoopsUser->getVar("uid")."' AND vid='in' AND read_state='0' "));
$block['new_messages'] = $new_messages;
}
else
$block['new_messages'] = $pm_handler->getCount($criteria);
//>>>--------------------------------------------
Now, how do I get that query ...
($xoopsDB->fetchRow($xoopsDB->query("SELECT COUNT(*) FROM ".$xoopsDB->prefix("ipb_messages")." WHERE recipient_id = '".$xoopsUser->getVar("uid")."' AND vid='in' AND read_state='0' "));)
...to display the count of messages
eg Inbox (
1)
??
