UNA
|
Public Member Functions | |
__construct (&$oConfig) | |
searchByTermForParentSpace ($iProfileId, $iContentId, $iLevelsLimit, $sTerm, $iLimit) | |
getCountEntriesByParent ($iParent) | |
getLevelById ($iContentId) | |
getChildEntriesIdByProfileId ($iParent) | |
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 |
Copyright (c) UNA, Inc - https://una.io MIT License - https://opensource.org/licenses/MIT
@defdroup Spaces Spaces @indroup UnaModules Spaces module database queries
BxSpacesDb::__construct | ( | & | $oConfig | ) |
Reimplemented from BxBaseModGroupsDb.