ChAdsDb Class Reference

Inheritance diagram for ChAdsDb:

Public Member Functions
	__construct (&$oConfig)
	getCategoryNameByID ($iID)
	getCategoryNameByUri ($sUri)
	getCatSubCatNameBySubCatID ($iID)
	getCatSubCatNameBySubCatUri ($sUri)
	getMemberAds ($iMemberID)
	getMemberAdsCnt ($iMemberID, $sStatus='', $bTimeCheck=FALSE)
	getOwnerOfAd ($iID)
	getMediaOfAd ($iID)
	getMediaFile ($iID)
	deleteMedia ($iMedId)
	deleteAd ($iID)
	getMediaInfo ($iMedId)
	getCatAndSubInfoBySubID ($iSubCatID)
	getAllCatsInfo ()
	getAllSubCatsInfo ($iID)
	getCountOfAdsInSubCat ($iID)
	getCountOfAdsInCat ($iID)
	insertMedia ($iMemberID, $sBaseName, $sExt)
	getFeaturedStatus ($iID)
	UpdateFeatureStatus ($iID, $iStatus)
	getAdInfo ($iID)
	getAdsByDate ($iCatSubcatID, $sLimitAddon, $bSub=false)
	getAdsByDateCnt ($iCatSubcatID, $bSub=false)
	getAdUriByID ($iID)
	getAdSubjectByID ($iID)
	getAdSubjectByUri ($sUri)
	getMemberAdsRSS ($iPID)
	setPostStatus ($iPostID, $sStatus='inactive')
	updatePostMedia ($iPostID, $sValue)
	getSubsNameIDCountAdsByAdID ($iCategoryID)
	getAdsByMonth ($iYear, $iMonth, $iNextYear, $iNextMonth)
	getSettingsCategory ()
	deleteCat ($iID)
	deleteSubCat ($iID)
	getSubcatInfo ($iID)
	getCatInfo ($iID)
Public Member Functions inherited from ChWsbDb
	setTimezone ($sTimezone)
	getLink ()
	res ($sQuery, $aBindings=[], $bReplaying=false)
	getAll ($sQuery, $aBindings=[], $iFetchType=PDO::FETCH_ASSOC)
	getRow ($sQuery, $aBindings=[], $iFetchStyle=PDO::FETCH_ASSOC)
	getColumn ($sQuery, $aBindings=[])
	getOne ($sQuery, $aBindings=[], $iIndex=0)
	getFirstRow ($sQuery, $aBindings=[], $iFetchStyle=PDO::FETCH_ASSOC)
	getNextRow ()
	getAllWithKey ($sQuery, $sFieldKey, $aBindings=[], $iFetchType=PDO::FETCH_ASSOC)
	getPairs ($sQuery, $sFieldKey, $sFieldValue, $aBindings=[])
	query ($sQuery, $aBindings=[])
	getNumRows ($oStmt=null)
	getAffectedRows ($oStmt=null)
	fillArray ($oStmt, $iFetchType=PDO::FETCH_ASSOC)
	lastId ()
	getParam ($sName, $bCache=true)
	setParam ($sName, $sValue)
	listTables ()
	getFields ($sTable)
	isFieldExists ($sTable, $sFieldName)
	fetchField ($mixedQuery, $iField, $aBindings=[])
	getDbCacheObject ()
	genDbCacheKey ($sName)
	fromCache ($sName, $sFunc)
	cleanCache ($sName)
&	fromMemory ($sName, $sFunc)
	cleanMemory ($sName)
	arrayToSQL ($a, $sDiv=',')
	escape ($sText, $bReal=true)
	implode_escape ($mixed)
	unescape ($mixed)

Public Attributes
	$_oConfig
Public Attributes inherited from ChWsbDb
	$port
	$socket
	$dbname
	$user
	$password
	$oParams = null
	$oDbCacheObject = null

Additional Inherited Members
Static Public Member Functions inherited from ChWsbDb
static	getInstance ()
Protected Member Functions inherited from ChWsbDb
	__construct ()
	connect ()
	disconnect ()
Protected Attributes inherited from ChWsbDb
	$host
	$link
	$oCurrentStmt
	$iCurrentFetchStyle
Static Protected Attributes inherited from ChWsbDb
static	$instance

Detailed Description

Definition at line 10 of file ChAdsDb.php.

Constructor & Destructor Documentation

__construct()

ChAdsDb::__construct

(

&

$oConfig

)

Definition at line 17 of file ChAdsDb.php.

Member Function Documentation

deleteAd()

ChAdsDb::deleteAd

(

$iID

)

Definition at line 126 of file ChAdsDb.php.

deleteCat()

ChAdsDb::deleteCat

(

$iID

)

Definition at line 408 of file ChAdsDb.php.

deleteMedia()

ChAdsDb::deleteMedia

(

$iMedId

)

Definition at line 116 of file ChAdsDb.php.

deleteSubCat()

ChAdsDb::deleteSubCat

(

$iID

)

Definition at line 416 of file ChAdsDb.php.

getAdInfo()

ChAdsDb::getAdInfo

(

$iID

)

Definition at line 237 of file ChAdsDb.php.

getAdsByDate()

ChAdsDb::getAdsByDate	(		$iCatSubcatID,
			$sLimitAddon,
			$bSub = false
	)

SQL Get all Advertisement data, units take into mind LifeDate of Adv

Parameters

$iClsID
$sAddon	- string addon of Limits (for pagination)
$bSub	- present that current ID is SubCategory

Returns

SQL data

Definition at line 266 of file ChAdsDb.php.

getAdsByDateCnt()

ChAdsDb::getAdsByDateCnt	(		$iCatSubcatID,
			$bSub = false
	)

Definition at line 285 of file ChAdsDb.php.

getAdsByMonth()

ChAdsDb::getAdsByMonth	(		$iYear,
			$iMonth,
			$iNextYear,
			$iNextMonth
	)

Definition at line 386 of file ChAdsDb.php.

getAdSubjectByID()

ChAdsDb::getAdSubjectByID

(

$iID

)

Definition at line 312 of file ChAdsDb.php.

getAdSubjectByUri()

ChAdsDb::getAdSubjectByUri

(

$sUri

)

Definition at line 322 of file ChAdsDb.php.

getAdUriByID()

ChAdsDb::getAdUriByID

(

$iID

)

Definition at line 301 of file ChAdsDb.php.

getAllCatsInfo()

ChAdsDb::getAllCatsInfo

(

)

SQL Get all Categories

Returns

SQL data

Definition at line 161 of file ChAdsDb.php.

getAllSubCatsInfo()

ChAdsDb::getAllSubCatsInfo

(

$iID

)

Definition at line 172 of file ChAdsDb.php.

getCatAndSubInfoBySubID()

ChAdsDb::getCatAndSubInfoBySubID

(

$iSubCatID

)

Definition at line 142 of file ChAdsDb.php.

getCategoryNameByID()

ChAdsDb::getCategoryNameByID

(

$iID

)

Definition at line 24 of file ChAdsDb.php.

getCategoryNameByUri()

ChAdsDb::getCategoryNameByUri

(

$sUri

)

Definition at line 29 of file ChAdsDb.php.

getCatInfo()

ChAdsDb::getCatInfo

(

$iID

)

Definition at line 428 of file ChAdsDb.php.

getCatSubCatNameBySubCatID()

ChAdsDb::getCatSubCatNameBySubCatID

(

$iID

)

Definition at line 36 of file ChAdsDb.php.

getCatSubCatNameBySubCatUri()

ChAdsDb::getCatSubCatNameBySubCatUri

(

$sUri

)

Definition at line 47 of file ChAdsDb.php.

getCountOfAdsInCat()

ChAdsDb::getCountOfAdsInCat

(

$iID

)

Definition at line 198 of file ChAdsDb.php.

getCountOfAdsInSubCat()

ChAdsDb::getCountOfAdsInSubCat

(

$iID

)

Definition at line 182 of file ChAdsDb.php.

getFeaturedStatus()

ChAdsDb::getFeaturedStatus

(

$iID

)

Definition at line 221 of file ChAdsDb.php.

getMediaFile()

ChAdsDb::getMediaFile

(

$iID

)

Definition at line 106 of file ChAdsDb.php.

getMediaInfo()

ChAdsDb::getMediaInfo

(

$iMedId

)

Definition at line 136 of file ChAdsDb.php.

getMediaOfAd()

ChAdsDb::getMediaOfAd

(

$iID

)

Definition at line 96 of file ChAdsDb.php.

getMemberAds()

ChAdsDb::getMemberAds

(

$iMemberID

)

Definition at line 60 of file ChAdsDb.php.

getMemberAdsCnt()

ChAdsDb::getMemberAdsCnt	(		$iMemberID,
			$sStatus = '',
			$bTimeCheck = FALSE
	)

Definition at line 69 of file ChAdsDb.php.

getMemberAdsRSS()

ChAdsDb::getMemberAdsRSS

(

$iPID

)

Definition at line 333 of file ChAdsDb.php.

getOwnerOfAd()

ChAdsDb::getOwnerOfAd

(

$iID

)

Definition at line 86 of file ChAdsDb.php.

getSettingsCategory()

ChAdsDb::getSettingsCategory

(

)

Definition at line 403 of file ChAdsDb.php.

getSubcatInfo()

ChAdsDb::getSubcatInfo

(

$iID

)

Definition at line 423 of file ChAdsDb.php.

getSubsNameIDCountAdsByAdID()

ChAdsDb::getSubsNameIDCountAdsByAdID

(

$iCategoryID

)

Definition at line 372 of file ChAdsDb.php.

insertMedia()

ChAdsDb::insertMedia	(		$iMemberID,
			$sBaseName,
			$sExt
	)

Definition at line 210 of file ChAdsDb.php.

setPostStatus()

ChAdsDb::setPostStatus	(		$iPostID,
			$sStatus = 'inactive'
	)

Definition at line 354 of file ChAdsDb.php.

UpdateFeatureStatus()

ChAdsDb::UpdateFeatureStatus	(		$iID,
			$iStatus
	)

Definition at line 227 of file ChAdsDb.php.

updatePostMedia()

ChAdsDb::updatePostMedia	(		$iPostID,
			$sValue
	)

Definition at line 364 of file ChAdsDb.php.

Member Data Documentation

$_oConfig

ChAdsDb::$_oConfig

Definition at line 12 of file ChAdsDb.php.

---

The documentation for this class was generated from the following file:

• modules/cheetah/ads/classes/ChAdsDb.php