Cheetah
Public Member Functions | Public Attributes | List of all members
ChWsbCmtsQuery Class Reference
Inheritance diagram for ChWsbCmtsQuery:
ChWsbDb

Public Member Functions

 __construct (&$aSystem)
 
 getTableName ()
 
 getComments ($iId, $iCmtParentId=0, $iAuthorId=0, $sCmtOrder='ASC', $iStart=0, $iCount=-1)
 
 getComment ($iId, $iCmtId, $iAuthorId=0)
 
 getCommentSimple ($iId, $iCmtId)
 
 addComment ($iId, $iCmtParentId, $iAuthorId, $sText, $iMood)
 
 removeComment ($iId, $iCmtId, $iCmtParentId)
 
 updateComment ($iId, $iCmtId, $sText, $iMood)
 
 rateComment ($iSystemId, $iCmtId, $iRate, $iAuthorId, $sAuthorIp)
 
 deleteAuthorComments ($iAuthorId)
 
 deleteObjectComments ($iObjectId)
 
 getObjectCommentsCount ($iObjectId, $iParentId=-1)
 
 updateTriggerTable ($iId, $iCount)
 
 maintenance ()
 
- 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

 $_aSystem
 
 $_sTable
 
 $_sTableTrack
 
- 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

See also
ChWsbCmts

Definition at line 13 of file ChWsbCmtsQuery.php.

Constructor & Destructor Documentation

◆ __construct()

ChWsbCmtsQuery::__construct ( $aSystem)

Definition at line 19 of file ChWsbCmtsQuery.php.

Member Function Documentation

◆ addComment()

ChWsbCmtsQuery::addComment (   $iId,
  $iCmtParentId,
  $iAuthorId,
  $sText,
  $iMood 
)

Definition at line 128 of file ChWsbCmtsQuery.php.

◆ deleteAuthorComments()

ChWsbCmtsQuery::deleteAuthorComments (   $iAuthorId)

Definition at line 182 of file ChWsbCmtsQuery.php.

◆ deleteObjectComments()

ChWsbCmtsQuery::deleteObjectComments (   $iObjectId)

Definition at line 205 of file ChWsbCmtsQuery.php.

◆ getComment()

ChWsbCmtsQuery::getComment (   $iId,
  $iCmtId,
  $iAuthorId = 0 
)

Definition at line 78 of file ChWsbCmtsQuery.php.

◆ getComments()

ChWsbCmtsQuery::getComments (   $iId,
  $iCmtParentId = 0,
  $iAuthorId = 0,
  $sCmtOrder = 'ASC',
  $iStart = 0,
  $iCount = -1 
)

Definition at line 32 of file ChWsbCmtsQuery.php.

◆ getCommentSimple()

ChWsbCmtsQuery::getCommentSimple (   $iId,
  $iCmtId 
)

Definition at line 117 of file ChWsbCmtsQuery.php.

◆ getObjectCommentsCount()

ChWsbCmtsQuery::getObjectCommentsCount (   $iObjectId,
  $iParentId = -1 
)

Definition at line 211 of file ChWsbCmtsQuery.php.

◆ getTableName()

ChWsbCmtsQuery::getTableName ( )

Definition at line 27 of file ChWsbCmtsQuery.php.

◆ maintenance()

ChWsbCmtsQuery::maintenance ( )

Definition at line 223 of file ChWsbCmtsQuery.php.

◆ rateComment()

ChWsbCmtsQuery::rateComment (   $iSystemId,
  $iCmtId,
  $iRate,
  $iAuthorId,
  $sAuthorIp 
)

Definition at line 164 of file ChWsbCmtsQuery.php.

◆ removeComment()

ChWsbCmtsQuery::removeComment (   $iId,
  $iCmtId,
  $iCmtParentId 
)

Definition at line 149 of file ChWsbCmtsQuery.php.

◆ updateComment()

ChWsbCmtsQuery::updateComment (   $iId,
  $iCmtId,
  $sText,
  $iMood 
)

Definition at line 159 of file ChWsbCmtsQuery.php.

◆ updateTriggerTable()

ChWsbCmtsQuery::updateTriggerTable (   $iId,
  $iCount 
)

Definition at line 216 of file ChWsbCmtsQuery.php.

Member Data Documentation

◆ $_aSystem

ChWsbCmtsQuery::$_aSystem

Definition at line 15 of file ChWsbCmtsQuery.php.

◆ $_sTable

ChWsbCmtsQuery::$_sTable

Definition at line 16 of file ChWsbCmtsQuery.php.

◆ $_sTableTrack

ChWsbCmtsQuery::$_sTableTrack

Definition at line 17 of file ChWsbCmtsQuery.php.


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