Inheritance diagram for BxDolProfileQuery:

Public Member Functions
	__clone ()

	getProfilesByAccount ($iAccountId)

	getProfiles ($aParams)

	getProfileByContentTypeAccount ($iContentId, $sType, $iAccountId)

	getProfileByContentAndType ($iContentId, $sType, $bClearCache=false)

	getConnectedProfilesByType ($aSqlParts, $sType, $iStart, $iLimit)

	insertProfile ($iAccountId, $iContentId, $sStatus, $sType='system')

	changeAccountId ($iProfileId, $iAccountId)

	changeStatus ($iProfileId, $sStatus)

	changeCfwValue ($iProfileId, $iValue)

	changeCfwItems ($iProfileId, $iValue)

	changeCfuItems ($iProfileId, $iValue)

	getCurrentProfileByAccount ($iAccountId, $bClearCache=false)

	getIdById ($iId, $bClearCache=false)

	getAccountInfoByProfileId ($iId)

	getEmailById ($iId)

	getInfoById ( $iID)

	isOnline ($iId)

	getOnlineCount ()

	getProfileQuota ($iProfileId)

	updateProfileQuota ($iProfileId, $iSize, $iNumber=1)

	delete ($iID)

	processDeletedProfiles ()

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)

Static Public Member Functions
static	getInstance ()

Static Public Member Functions inherited from BxDolDb
static	getInstanceWithConf ($aDbConf, &$sError)

static	getLink ()

Protected Member Functions
	_getDataByField ($sField, $sValue)

	_getFieldByField ($sFieldRequested, $sFieldSearch, $sValue)

	_updateField ($iId, $sFieldForUpdate, $sValue)

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)

Additional Inherited Members
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

All queries related to profiles

Constructor & Destructor Documentation

◆ __construct()

BxDolProfileQuery::__construct ( )

protected

Reimplemented from BxDolFactory.

Member Function Documentation

◆ __clone()

BxDolProfileQuery::__clone ( )

Prevent cloning the instance

Reimplemented from BxDolDb.

◆ _getDataByField()

BxDolProfileQuery::_getDataByField	(		$sField,
			$sValue )

protected

Get profile by specified field name and value. It is for internal usage only. Use other funtions to get profile info, like getInfoById, etc.

Parameters

string	$sField	database field name
mixed	$sValue	database field value

Returns: array with porfile info

◆ _getFieldByField()

BxDolProfileQuery::_getFieldByField	(	$sFieldRequested,
		$sFieldSearch,
		$sValue )

protected

Get profile field by specified field name and value. In most cases it is for internal usage only. Use other funtions to get profile info, like getIdByEmail, etc.

Parameters

string	$sFieldRequested	database field name to return
string	$sFieldSearch	database field name to search for
mixed	$sValue	database field value

Returns: specified profile field value

◆ _updateField()

BxDolProfileQuery::_updateField	(	$iId,
		$sFieldForUpdate,
		$sValue )

protected

Update some field by profile id In most cases it is for internal usage only. Use other funtions to get profile info, like updateLogged, etc.

Parameters

string	$sFieldRequested	database field name to return
string	$sFieldSearch	database field name to search for
mixed	$sValue	database field value

Returns: specified profile field value

◆ changeAccountId()

BxDolProfileQuery::changeAccountId	(		$iProfileId,
			$iAccountId )

Update profile's account id

Parameters

$iProfileId	profile id
$iAccountId	new Account ID

Returns: true on success or false otherwise

◆ changeCfuItems()

BxDolProfileQuery::changeCfuItems	(		$iProfileId,
			$iValue )

Update profile's content filter items (use)

Parameters

$iProfileId	profile id
$iValue	bitmask of available items

Returns: true on success or false otherwise

◆ changeCfwItems()

BxDolProfileQuery::changeCfwItems	(		$iProfileId,
			$iValue )

Update profile's content filter items (watch)

Parameters

$iProfileId	profile id
$iValue	bitmask of available items

Returns: true on success or false otherwise

◆ changeCfwValue()

BxDolProfileQuery::changeCfwValue	(		$iProfileId,
			$iValue )

Update profile's content filter value (watch)

Parameters

$iProfileId	profile id
$iValue	bitmask of selected items

Returns: true on success or false otherwise

◆ changeStatus()

BxDolProfileQuery::changeStatus	(		$iProfileId,
			$sStatus )

Update profile's status

Parameters

$iProfileId	profile id
$sStatus	profile status

Returns: true on success or false otherwise

◆ delete()

BxDolProfileQuery::delete ( $iID )

Delete profile info by id

Parameters

int $iID profile id

Returns: affected rows

◆ getAccountInfoByProfileId()

BxDolProfileQuery::getAccountInfoByProfileId ( $iId )

get account info by profile id

◆ getCurrentProfileByAccount()

BxDolProfileQuery::getCurrentProfileByAccount	(		$iAccountId,
			$bClearCache = false )

Get current account profile.

Parameters

string $iAccountId account id

Returns: current account's profile id

◆ getEmailById()

BxDolProfileQuery::getEmailById ( $iId )

get account email by profile id

◆ getIdById()

BxDolProfileQuery::getIdById	(		$iId,
			$bClearCache = false )

get profile id by id

◆ getInfoById()

BxDolProfileQuery::getInfoById ( $iID )

Get profile info by id

Parameters

int $iID profile id

Returns: array with profile info

◆ getInstance()

static BxDolProfileQuery::getInstance ( )

static

Get singleton instance of the class

Reimplemented from BxDolDb.

◆ getOnlineCount()

BxDolProfileQuery::getOnlineCount ( )

Get online profiles count

Returns: online profiles count

◆ getProfileByContentAndType()

BxDolProfileQuery::getProfileByContentAndType	(	$iContentId,
		$sType,
		$bClearCache = false )

Get profile by content id and type.

Parameters

string $iAccountId account id

Returns: array if aprofile ids, key is profile id

◆ getProfileByContentTypeAccount()

BxDolProfileQuery::getProfileByContentTypeAccount	(	$iContentId,
		$sType,
		$iAccountId )

Get profile by content id, type and account.

Parameters

string $iAccountId account id

Returns: array if aprofile ids, key is profile id

◆ getProfiles()

BxDolProfileQuery::getProfiles ( $aParams )

Get profile(s) by params

Parameters

array $aParams browse params

Returns: array with profile(s)

◆ getProfilesByAccount()

BxDolProfileQuery::getProfilesByAccount ( $iAccountId )

Get all account profiles.

Parameters

string $iAccountId account id

Returns: profile array

◆ insertProfile()

BxDolProfileQuery::insertProfile	(	$iAccountId,
		$iContentId,
		$sStatus,
		$sType = 'system' )

Insert account and content id association. Also if currect profile id is not defined - it updates current profile id in account.

Parameters

$iAccountId	account id
$iContentId	content id
$sStatus	profile status
$sType	profile content type

Returns: inserted profile's id

◆ isOnline()

BxDolProfileQuery::isOnline ( $iId )

Is profile online by id

Parameters

int $iId profile id

Returns: profile online status

◆ processDeletedProfiles()

BxDolProfileQuery::processDeletedProfiles ( )

Reset deleted profile ids and assign system profile ids. Should be called after profiles module deletion. It can be called automatically if

'process_deleted_profiles' => 1

is specified in module config.php file in 'uninstall' section.

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

inc/classes/BxDolProfileQuery.php

Public Member Functions

Static Public Member Functions

Protected Member Functions

Additional Inherited Members

Detailed Description

Constructor & Destructor Documentation

◆ __construct()

Member Function Documentation

◆ __clone()

◆ _getDataByField()

◆ _getFieldByField()

◆ _updateField()

◆ changeAccountId()

◆ changeCfuItems()

◆ changeCfwItems()

◆ changeCfwValue()

◆ changeStatus()

◆ delete()

◆ getAccountInfoByProfileId()

◆ getCurrentProfileByAccount()

◆ getEmailById()

◆ getIdById()

◆ getInfoById()

◆ getInstance()

◆ getOnlineCount()

◆ getProfileByContentAndType()

◆ getProfileByContentTypeAccount()

◆ getProfiles()

◆ getProfilesByAccount()

◆ insertProfile()

◆ isOnline()

◆ processDeletedProfiles()