BxDolCmtsQuery Class Reference

Inheritance diagram for BxDolCmtsQuery:

Public Member Functions
	__construct (&$oMain)
	getTableName ()
	setTableNameFiles ($sTable)
	setTableNameFiles2Entries ($sTable)
	getCommentsCountAll ($iId, $iAuthorId=0, $bForceCalculate=false)
	getCommentsCount ($iId, $iCmtVParentId=-1, $iAuthorId=0, $sFilter='')
	getStructure ($iObjectId, $iAuthorId=0, $iParentId=0, $sFilter='', $aOrder=array())
	getComments ($iId, $iCmtVParentId=0, $iAuthorId=0, $sFilter='', $aOrder=array(), $iStart=0, $iCount=-1)
	getCommentsBy ($aParams=array())
	getComment ($iId, $iCmtId)
	getCommentSimple ($iId, $iCmtId)
	removeComment ($iId, $iCmtId, $iCmtParentId)
	saveImages ($iSystemId, $iCmtId, $iImageId)
	getFiles ($iSystemId, $iCmtId, $iId=false)
	getFileInfoById ($iFileId)
	deleteImages ($iSystemId, $iCmtId, $iImageId=false)
	updateComments ($aSetClause, $aWhereClause)
	updateRepliesCount ($iCmtId, $iCount)
	deleteAuthorComments ($iAuthorId, &$aFiles=null, &$aCmtIds=null)
	deleteObjectComments ($iObjectId, &$aFilesReturn=null, &$aCmtIds=null)
	deleteAll ($iSystemId, &$aFiles=null, &$aCmtIds=null)
	deleteCmtIds ($iSystemId, $iCmtId)
	getObjectAuthorId ($iId)
	getObjectTitle ($iId)
	getObjectPrivacyView ($iId, $sField='')
	updateTriggerTable ($iId, $iCount)
	getUniqId ($iSystemId, $iCmtId, $aData=[])
	updateUniqId ($aSetClause, $aWhereClause)
Public Member Functions inherited from BxDolDb
	__clone ()
	setReadOnlyMode ($b)
	connect ()
	disconnect ()
	ping ()
	pdoExec ($sQuery)
	pdoQuery ($sQuery)
	pdoExceptionHandler ($oException)
	getOption ($sName)
	getOne ($oStatement, $aBindings=array(), $iIndex=0)
	getRow ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	getColumn ($oStatement, $aBindings=array(), $iFetchColumnNumber=0)
	getFirstRow ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	getNextRow ($iFetchType=PDO::FETCH_ASSOC)
	getAll ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	fillArray ($oStatement, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	getAllWithKey ($oStatement, $sFieldKey, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	getPairs ($oStatement, $sFieldKey, $sFieldValue, $aBindings=array(), $iFetchType=PDO::FETCH_ASSOC)
	getNumRows ($oStatement=null)
	getAffectedRows ($oStatement=null)
	lastId ()
	query ($oStatement, $aBindings=array(), $bVerbose=null)
	res ($oStatement, $aBindings=array(), $bVerbose=null)
	getServerInfo ()
	getVersion ()
	listTables ()
	getFields ($sTable)
	fetchField ($oStatement, $iField, $aBindings=array())
	isTableExists ($sTable)
	isFieldExists ($sTable, $sFieldName)
	isIndexExists ($sTable, $sIndexName)
	error ($aError)
	cacheParams ($bForceCacheInvalidate=false, $bForceCacheInvalidateMixed=false)
	cacheParamsClear ($sCacheName='')
	isParam ($sKey, $bFromCache=true)
	addParam ($sName, $sValue, $iKateg, $sDesc, $sType)
	getParam ($sKey, $bFromCache=true)
	setParam ($sKey, $mixedValue, $iMixId=0)
	getParamsMix ($iId)
	getParamsMixActive ($sType)
	getParamsMixes ($sType, $mixedPublished=false)
	setTimezone ($sTimezone)
	getEncoding ()
	setErrorChecking ($b)
	getDbCacheObject ()
	genDbCacheKey ($sName)
	getCache ($sName, $sFunc)
	setCache ($sName, $mData)
	fromCache ($sName, $sFunc)
	cleanCache ($sName)
&	fromMemory ($sName, $sFunc)
	cleanMemory ($sName)
	cleanMemoryAll ()
	escape ($s)
	implode_escape ($mixed)
	unescape ($mixed)
	prepare ($sQuery)
	prepareAsString ($sQuery)
	arrayToSQL ($a, $sDiv=',', $sOperator='=', $bWildcardSpaceChars=false)
	executeSQL ($sPath, $aReplace=array(), $isBreakOnError=true)

Static Public Member Functions
static	getSystemBy ($aParams)
static	getInfoBy ($aParams)
static	getInfoByUniqId ($iUniqId)
static	getCommentByUniq ($iUnicId)
static	getCommentSimpleByUniqId ($iUniqId)
static	getCommentExtendedByUniqId ($iUniqId)
Static Public Member Functions inherited from BxDolDb
static	getInstance ()
static	getInstanceWithConf ($aDbConf, &$sError)
static	getLink ()

Protected Member Functions
	getCommentsCheckStatus ($iAuthorId, $sStatus=BX_CMT_STATUS_ACTIVE)
	convertImagesArray ($a)
Protected Member Functions inherited from BxDolDb
	__construct ($aDbConf=false)
	balancer ()
	isParamInCache ($sKey)
	log ($s)
	executeStatement ($oStatement, $aBindings=array(), $bVerbose=null, &$iErrorCode=null)
	executeStatementException ($oStatement, $aBindings=array(), $bVerbose=null)
	executeStatementSilent ($oStatement, $aBindings=array(), $bVerbose=null)
	errorOutput ($aError)

Protected Attributes
	$_oMain
	$_sTable
	$_sTriggerTable
	$_sTriggerFieldId
	$_sTriggerFieldAuthor
	$_sTriggerFieldTitle
	$_sTriggerFieldComments
	$_sTableFiles
	$_sTableFiles2Entries
	$_sTableSystems
	$_sTableIds
Protected Attributes inherited from BxDolDb
	$_bPdoPersistent
	$_iPdoFetchType
	$_iPdoErrorMode
	$_bErrorChecking
	$_aError
	$_sHost
	$_sPort
	$_sSocket
	$_sDbname
	$_sUser
	$_sPassword
	$_sCharset
	$_sStorageEngine
	$_oStatement = null
	$_oDbCacheObject = null

Additional Inherited Members
Static Protected Attributes inherited from BxDolDb
static	$_rLink
static	$_aDbCacheData
static	$_aParams
static	$_sParamsCacheName = 'sys_options'
static	$_sParamsCacheNameMixed = 'sys_options_mixed_'
static	$_sParamsCacheNameMix = 'sys_options_mix_'
static	$_sErrorKey = 'bx_db_error'
static	$_aErrors
static	$_bReadOnlyMode = true
static	$_bMultuServersMode = false

Detailed Description

See also

BxDolCmts

Member Function Documentation

getCommentByUniq()

static BxDolCmtsQuery::getCommentByUniq ( $iUnicId )

static

getComments()

BxDolCmtsQuery::getComments	(		$iId,
			$iCmtVParentId = 0,
			$iAuthorId = 0,
			$sFilter = '',
			$aOrder = array(),
			$iStart = 0,
			$iCount = -1 )

Hooks:

'comment', 'get_comments' - hook to override comments list. Is used during comments count retrieving.

• $unit_name - equals comment
• $action - equals get_comments
• $object_id - not used
• $sender_id - profile id
• $extra_params - array of additional params with the following array keys:
  • system - [string] comment object name
  • select_clause - [string] by ref, 'select' part of SQL query, can be overridden in hook processing
  • join_clause - [string] by ref, 'join' part of SQL query, can be overridden in hook processing
  • where_clause - [string] by ref, 'where' part of SQL query, can be overridden in hook processing
  • order_clause - [string] by ref, 'order' part of SQL query, can be overridden in hook processing
  • limit_clause - [string] by ref, 'limit' part of SQL query, can be overridden in hook processing
  • params - [array] by ref, SQL query bindings array as key&value pairs, can be overridden in hook processing

    HOOKS

    'comment', 'get_comments' - hook to override comments list. Is used during comments count retrieving.

getCommentsCount()

BxDolCmtsQuery::getCommentsCount	(		$iId,
			$iCmtVParentId = -1,
			$iAuthorId = 0,
			$sFilter = '' )

Hooks:

'comment', 'get_comments' - hook to override comments list. Is used during comments count retrieving.

• $unit_name - equals comment
• $action - equals get_comments
• $object_id - not used
• $sender_id - currently logged in profile id
• $extra_params - array of additional params with the following array keys:
  • system - [string] comment object name
  • join_clause - [string] by ref, 'join' part of SQL query, can be overridden in hook processing
  • where_clause - [string] by ref, 'where' part of SQL query, can be overridden in hook processing
  • params - [array] by ref, SQL query bindings array as key&value pairs, can be overridden in hook processing

    HOOKS

    'comment', 'get_comments' - hook to override comments list. Is used during comments count retrieving.

getCommentsCountAll()

BxDolCmtsQuery::getCommentsCountAll	(		$iId,
			$iAuthorId = 0,
			$bForceCalculate = false )

Hooks:

'comment', 'get_comments_count' - hook to override number of comments for commented object

• $unit_name - equals comment
• $action - equals get_comments_count
• $object_id - not used
• $sender_id - profile id
• $extra_params - array of additional params with the following array keys:
  • system - [string] comment object name
  • object_id - [int] commented object id
  • result - [int] by ref, number of comments, can be overridden in hook processing

    HOOKS

    'comment', 'get_comments_count' - hook to override number of comments for commented object

setTableNameFiles()

BxDolCmtsQuery::setTableNameFiles

(

$sTable

)

setTableNameFiles2Entries()

BxDolCmtsQuery::setTableNameFiles2Entries

(

$sTable

)

---

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

• inc/classes/BxDolCmtsQuery.php