/** * Get Total Advertisements. * * @param string $sTable Default 'Ads' * @return integer */ public function total($sTable = 'Ads') { $this->cache->start(self::CACHE_GROUP, 'total' . $sTable, 604800); if (!($iData = $this->cache->get())) { AdsCore::checkTable($sTable); $rStmt = Db::getInstance()->prepare('SELECT COUNT(adsId) AS totalAds FROM' . Db::prefix($sTable)); $rStmt->execute(); $oRow = $rStmt->fetch(\PDO::FETCH_OBJ); Db::free($rStmt); $iData = (int) $oRow->totalAds; unset($oRow); $this->cache->put($iData); } return $iData; }
/** * Check table. * * @see \PH7\Framework\Mvc\Model\Engine\Util\Various::launchErr() * * @param string $sTable * @return mixed (string | void) Returns the table if it is correct. * @throws \PH7\Framework\Mvc\Model\Engine\Util\Various::launchErr() If the table is not valid. */ public static function checkTable($sTable) { switch ($sTable) { case 'Members': case 'AlbumsPictures': case 'AlbumsVideos': case 'Pictures': case 'Videos': case 'Games': case 'Blogs': case 'Notes': return $sTable; break; /** Check Ads Tables **/ \PH7\AdsCore::checkTable($sTable); default: static::launchErr($sTable); } }