/** * Returns the number of spam messages */ public function getNumberSpamToBeChecked() { /* TODO: I am abusing layoutbits as a storage to cut database queries, I am certain there is a nicer way of doing this. */ $layoutbits = MOD_layoutbits::get(); if (!isset($layoutbits->numberSpamToBeChecked)) { $query = ' SELECT COUNT(*) AS cnt FROM messages, members AS mSender, members AS mReceiver WHERE mSender.id=IdSender AND messages.SpamInfo=\'SpamSayMember\' AND mReceiver.id=IdReceiver AND ( mSender.Status=\'Active\' OR mSender.Status=\'Pending\' ) '; $result = $this->dao->query($query); $record = $result->fetch(PDB::FETCH_OBJ); $layoutbits->numberSpamToBeChecked = $record->cnt; } return $layoutbits->numberSpamToBeChecked; }