UNA
BxDolCmtsQuery Class Reference
UNA Core
Inheritance diagram for BxDolCmtsQuery:
BxDolDb BxDolFactory iBxDolSingleton BxDolCmtsReviewsQuery

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()

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:

◆ getCommentsCountAll()

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

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