BxCoursesDb Class Reference
Inheritance diagram for BxCoursesDb:
Public Member Functions | |
| __construct (&$oConfig) | |
| getContentNodes ($aParams) | |
| updateContentNodes ($aParamsSet, $aParamsWhere) | |
| deleteContentNodes ($aParamsWhere) | |
| deleteContentNodesWithTracks ($iEntryId) | |
| insertContentNodes2Users ($aParamsSet) | |
| deleteContentNodes2Users ($aParamsWhere) | |
| getContentStructure ($aParams) | |
| getContentStructureOrderMax ($iEntryId, $iParentId) | |
| insertContentStructureNode ($aParamsSet) | |
| updateContentStructureNode ($aParamsSet, $aParamsWhere) | |
| updateContentStructureCounters ($iParentId, $iLevel, $iAdd) | |
| deleteContentStructureNode ($aParamsWhere) | |
| getContentData ($aParams) | |
| getContentDataOrderMax ($iEntryId, $iNodeId) | |
| insertContentData ($aParamsSet) | |
| deleteContentData ($aParamsWhere) | |
| deleteContentDataWithTracks ($iEntryId) | |
| insertContentData2Users ($aParamsSet) | |
| deleteContentData2Users ($aParamsWhere) | |
| Public Member Functions inherited from BxBaseModGroupsDb | |
| updateAuthorById ($iContentId, $iProfileId) | |
| toAdmins ($iGroupProfileId, $mixedFansIds) | |
| fromAdmins ($iGroupProfileId, $mixedFansIds) | |
| deleteAdminsByGroupId ($iGroupProfileId, $iProfileId=0) | |
| deleteAdminsByProfileId ($iProfileId) | |
| isAdmin ($iGroupProfileId, $iFanId, $aDataEntry=array()) | |
| getAdmin ($iGroupProfileId, $iProfileId, $bRoleOnly=false) | |
| getAdmins ($iGroupProfileId, $iStart=0, $iLimit=0) | |
| getRole ($iGroupProfileId, $iProfileId) | |
| getRoles ($aParams) | |
| updateRoles ($aSet, $aWhere) | |
| deleteRoles ($aWhere) | |
| setRole ($iGroupProfileId, $iProfileId, $mixedRole, $mixedPeriod=false, $sOrder='') | |
| unsetRole ($iGroupProfileId, $iProfileId) | |
| getPrices ($aParams) | |
| getPriceOrderMax ($iRoleId) | |
| deletePrices ($aWhere) | |
| insertInvite ($sKey, $sGroupProfileId, $iAuthorProfileId, $iInvitedProfileId) | |
| getInviteByKey ($sKey, $iGroupProfileId) | |
| getInviteByInvited ($iInvitedProfileId, $iGroupProfileId) | |
| isInviteByInvited ($iInvitedProfileId, $iGroupProfileId) | |
| updateInviteByKey ($sKey, $iGroupProfileId, $sColumn, $sValue) | |
| deleteInviteByKey ($sKey, $iGroupProfileId) | |
| deleteInvite ($iId) | |
| getQuestions ($aParams=[]) | |
| hasQuestions ($iContentId) | |
| areQuestionsAnswered ($iContentId, $iProfileId) | |
| getQuestionOrderMax ($iContentId) | |
| insertAnswer ($iQuestionId, $iProfileId, $sAnswer) | |
| deleteAnswersProfileId ($iContentId, $iProfileId) | |
| deleteQuestionnaires ($iContentId) | |
| Public Member Functions inherited from BxBaseModProfileDb | |
| getContentInfoById ($iContentId) | |
| getContentInfoByProfileId ($iProfileId) | |
| resetContentPictureByFileId ($iFileId, $sFieldPicture) | |
| updateContentPictureById ($iContentId, $iProfileId, $iPictureId, $sFieldPicture) | |
| searchByTerm ($sTerm, $iLimit) | |
| getEntriesNumByParams ($aParams=[]) | |
| Public Member Functions inherited from BxBaseModGeneralDb | |
| getEntriesBy ($aParams=array()) | |
| getEntriesNumByContext ($iProfileId) | |
| getEntriesByAuthor ($iProfileId) | |
| getEntriesNumByAuthor ($iProfileId) | |
| updateEntriesBy ($aParamsSet, $aParamsWhere) | |
| updateStatusAdmin ($iContentId, $isActive) | |
| publishEntries () | |
| alterFulltextIndex () | |
| deleteNestedById ($iNestedId, $sTableKey, $sTableName) | |
| getNestedBy ($aParams, $sTableName) | |
| getStatByProfile ($iAuthorId) | |
| Public Member Functions inherited from BxDolModuleDb | |
| __construct ($oConfig) | |
| getPrefix () | |
| Public Member Functions inherited from BxDolModuleQuery | |
| __clone () | |
| getModuleById ($iId, $bFromCache=true) | |
| getModuleByName ($sName, $bFromCache=true) | |
| getModuleByUri ($sUri, $bFromCache=true) | |
| enableModuleByUri ($sUri) | |
| disableModuleByUri ($sUri) | |
| setModulePendingUninstall ($sUri, $bPendingUninstall) | |
| isModule ($sUri) | |
| isModuleByName ($sName) | |
| isModuleParamsUsed ($sName, $sUri, $sPath, $sPrefixDb, $sPrefixClass) | |
| isEnabled ($sUri) | |
| isEnabledByName ($sName) | |
| getModules () | |
| getModulesBy ($aParams=array(), $bFromCache=true) | |
| isModuleContent ($sName) | |
| isModuleContext ($sName) | |
| isModuleProfile ($sName) | |
| getModulesUri () | |
| getDependent ($sName, $sUri) | |
| updateModule ($aParamsSet, $aParamsWhere=array()) | |
| checkModulesSubtypes () | |
| Public Member Functions inherited from BxDolDb | |
| 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) | |
Additional Inherited Members | |
| Static Public Member Functions inherited from BxDolModuleQuery | |
| static | getInstance () |
| Static Public Member Functions inherited from BxDolDb | |
| static | getInstanceWithConf ($aDbConf, &$sError) |
| static | getLink () |
| Protected Member Functions inherited from BxBaseModGroupsDb | |
| _getEntriesBySearchIds ($aParams, &$aMethod, &$sSelectClause, &$sJoinClause, &$sWhereClause, &$sOrderClause, &$sLimitClause) | |
| Protected Member Functions inherited from BxBaseModGeneralDb | |
| _addCustomConditions ($aParams, &$aMethod, &$sSelectClause, &$sJoinClause, &$sWhereClause, &$sOrderClause, &$sLimitClause) | |
| _addConditionsForAuthorStatus ($aParams, &$aMethod, &$sSelectClause, &$sJoinClause, &$sWhereClause, &$sOrderClause, &$sLimitClause) | |
| _addConditionsForCf ($aParams, &$aMethod, &$sSelectClause, &$sJoinClause, &$sWhereClause, &$sOrderClause, &$sLimitClause) | |
| _getEntriesBySearchIdsOrder ($aParams, &$sOrderClause) | |
| _getEbsiLike ($sValue) | |
| Protected Member Functions inherited from BxDolDb | |
| 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 inherited from BxBaseModGeneralDb | |
| $_oConfig | |
| Protected Attributes inherited from BxDolModuleDb | |
| $_sPrefix | |
| Protected Attributes inherited from BxDolDb | |
| $_bPdoPersistent | |
| $_iPdoFetchType | |
| $_iPdoErrorMode | |
| $_bErrorChecking | |
| $_aError | |
| $_sHost | |
| $_sPort | |
| $_sSocket | |
| $_sDbname | |
| $_sUser | |
| $_sPassword | |
| $_sCharset | |
| $_sStorageEngine | |
| $_oStatement = null | |
| $_oDbCacheObject = null | |
| 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
Courses module database queries
Constructor & Destructor Documentation
◆ __construct()
| BxCoursesDb::__construct | ( | & | $oConfig | ) |
Reimplemented from BxBaseModGroupsDb.
The documentation for this class was generated from the following file:
- modules/boonex/courses/classes/BxCoursesDb.php
