Inheritance diagram for BxDolAccountQuery:

Public Member Functions
	__clone ()
	getOperators ()
	getInfoById ( $iID)
	getIdByEmail ($sEmail)
	getIdByPhone ($sPhone)
	getIdById ($iId, $bClearCache=false)
	getStudioOperatorId ()
	getEmail ($iID)
	getPassword ($iID)
	isOnline ($iId)
	updatePassword ($sPasswordHash, $sSalt, $iAccountId)
	logPassword ($iAccountId)
	getLastPasswordChanged ($iAccountId)
	getLastPasswordLog ($iAccountId)
	updateLoggedIn ($iID)
	updateAttemptsCounter ($iID)
	lockAccount ($iID)
	unlockAccount ($iID)
	updateLanguage ($iID, $iLangId)
	updateCurrentProfile ($iID, $iProfileId)
	updateEmailConfirmed ($isConfirmed, $iID)
	updatePhoneConfirmed ($isConfirmed, $iID)
	updatePhone ($sPhone, $iID)
	_updateField ($iId, $sFieldForUpdate, $sValue)
	delete ($iID)
	getAccounts ($aParams)
	searchByTerm ($sTerm, $iLimit)
	getAccountsForPruning ($sMode, $iAdded)
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)
	isValidFieldName ($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)
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 account

Constructor & Destructor Documentation

◆ __construct()

BxDolAccountQuery::__construct ( )

protected

Reimplemented from BxDolFactory.

Member Function Documentation

◆ __clone()

BxDolAccountQuery::__clone ( )

Prevent cloning the instance

Reimplemented from BxDolDb.

◆ _getDataByField()

BxDolAccountQuery::_getDataByField	(		$sField,
			$sValue )

protected

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

Parameters

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

Returns: array with porfile info

◆ _getFieldByField()

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

protected

Get account field by specified field name and value. In most cases it is for internal usage only. Use other funtions to get account 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 account field value

◆ _updateField()

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

Update some field by account id In most cases it is for internal usage only. Use other funtions to get account 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 account field value

◆ delete()

BxDolAccountQuery::delete ( $iID )

Delete account info by id

Parameters

int $iID profile id

Returns: affected rows

◆ getAccounts()

BxDolAccountQuery::getAccounts ( $aParams )

Get account(s) by params

Parameters

array $aParams browse params

Returns: array with account(s)

◆ getEmail()

BxDolAccountQuery::getEmail ( $iID )

Get account email by id

Parameters

string $s search account by this id

Returns: account email

◆ getIdByEmail()

BxDolAccountQuery::getIdByEmail ( $sEmail )

get account id by emial

◆ getIdById()

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

get account id by id

◆ getIdByPhone()

BxDolAccountQuery::getIdByPhone ( $sPhone )

get account id by phone

◆ getInfoById()

BxDolAccountQuery::getInfoById ( $iID )

Get account info by id

Parameters

int $iID account id

Returns: array with account info

◆ getInstance()

BxDolAccountQuery::getInstance ( )

static

Get singleton instance of the class

Reimplemented from BxDolDb.

◆ getPassword()

BxDolAccountQuery::getPassword ( $iID )

Get account password by id

Parameters

string $s search account by this id

Returns: account password

◆ getStudioOperatorId()

BxDolAccountQuery::getStudioOperatorId ( )

get first studio operator id

◆ isOnline()

BxDolAccountQuery::isOnline ( $iId )

Is account online by id

Parameters

int $iId account id

Returns: account online status

◆ lockAccount()

BxDolAccountQuery::lockAccount ( $iID )

Lock account

Parameters

int $iID account id

Returns: number of affected rows

◆ logPassword()

BxDolAccountQuery::logPassword ( $iAccountId )

Save password log

Parameters

$sPasswordHash	- password hash
$sSalt	- pasword salt
$iAccountId	- account id to update password for

Returns: number of affected rows

◆ searchByTerm()

BxDolAccountQuery::searchByTerm	(		$sTerm,
			$iLimit )

Search account profile by keyword

◆ unlockAccount()

BxDolAccountQuery::unlockAccount ( $iID )

Unlock account

Parameters

int $iID account id

Returns: number of affected rows

◆ updateAttemptsCounter()

BxDolAccountQuery::updateAttemptsCounter ( $iID )

Update login attempts counter

Parameters

int $iID account id

Returns: number of affected rows

◆ updateCurrentProfile()

BxDolAccountQuery::updateCurrentProfile	(		$iID,
			$iProfileId )

Update current profile id associated with account

Parameters

int	$iID	account id
int	$iProfileId	set current profile id to this value

Returns: number of affected rows

◆ updateEmailConfirmed()

BxDolAccountQuery::updateEmailConfirmed	(		$isConfirmed,
			$iID )

Update 'email_confirmed' field.

Parameters

int	$isConfirmed	- 0: mark email as unconfirmed, 1: as confirmed
int	$iID	- account id

Returns: number of affected rows

◆ updateLanguage()

BxDolAccountQuery::updateLanguage	(		$iID,
			$iLangId )

Update language

Parameters

int $iID account id

Returns: number of affected rows

◆ updateLoggedIn()

BxDolAccountQuery::updateLoggedIn ( $iID )

Update last logged in time

Parameters

int $iID account id

Returns: number of affected rows

◆ updatePassword()

BxDolAccountQuery::updatePassword	(	$sPasswordHash,
		$sSalt,
		$iAccountId )

Update password

Parameters

$sPasswordHash	- password hash
$sSalt	- pasword salt
$iAccountId	- account id to update password for

Returns: number of affected rows

◆ updatePhone()

BxDolAccountQuery::updatePhone	(		$sPhone,
			$iID )

Update 'phone' field.

Parameters

int	$sPhone	- phone number
int	$iID	- account id

Returns: number of affected rows

◆ updatePhoneConfirmed()

BxDolAccountQuery::updatePhoneConfirmed	(		$isConfirmed,
			$iID )

Update 'phone_confirmed' field.

Parameters

int	$isConfirmed	- 0: mark phone as unconfirmed, 1: as confirmed
int	$iID	- account id

Returns: number of affected rows

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

inc/classes/BxDolAccountQuery.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()

◆ delete()

◆ getAccounts()

◆ getEmail()

◆ getIdByEmail()

◆ getIdById()

◆ getIdByPhone()

◆ getInfoById()

◆ getInstance()

◆ getPassword()

◆ getStudioOperatorId()

◆ isOnline()

◆ lockAccount()

◆ logPassword()

◆ searchByTerm()

◆ unlockAccount()

◆ updateAttemptsCounter()

◆ updateCurrentProfile()

◆ updateEmailConfirmed()

◆ updateLanguage()

◆ updateLoggedIn()

◆ updatePassword()

◆ updatePhone()

◆ updatePhoneConfirmed()