class vB_dB_MYSQL_QueryDefs extends vB_dB_QueryDefs

Traits

Properties

protected $db_type
protected $table_data This is the definition for tables we will process through. It saves a database query to put them here.
protected $query_data This is the definition for queries we will process through. We could also put them in the database, but this eliminates a query.
protected bool $saveDbCacheErrorState Flag to determine if we are in a state of database error. Used by saveDbCache method.

Methods

__sleep()

No description

__wakeup()

No description

mixed
getTableData()

This returns the table definitions

mixed
getQueryData()

This returns the query definitions

getResultSet(object $db, string $sql)

Returns the resultset for a particular query string

getModeratorInfo($params, $db, $check_only = false)

No description

getChangelogData($params, $db, $check_only = false)

No description

getStyle($params, $db, $check_only = false)

No description

searchTemplates($params, $db, $check_only = false)

No description

getStyleByConds($params, $db, $check_only = false)

No description

fetchUserinfo($params, $db, $check_only = false)

No description

fetchLanguage($params, $dbobject, $check_only = false)

No description

userFind($params, $db, $check_only = false)

No description

userFindCount($params, $db, $check_only = false)

No description

userInsertSubscribeevent($params, $db, $check_only = false)

No description

userInsertAnnouncementread($params, $db, $check_only = false)

No description

userDeleteUsergrouprequest($params, $db, $check_only = false)

No description

userSearchRegisterIP($params, $db, $check_only = false)

No description

userSearchIPUsage($params, $db, $check_only = false)

No description

userReferrers($params, $db, $check_only = false)

No description

fetchPhraseInfo($params, $db, $check_only = false)

No description

updateInvisible($params, $db, $check_only = false)

No description

disableProducts($params, $db, $check_only = false)

No description

updateMemberForDeletedUsergroup($params, $db, $check_only = false)

No description

fetchPromotions($params, $db, $check_only = false)

No description

deleteOrphans($params, $db, $check_only = false)

No description

keepOrphans($params, $db, $check_only = false)

No description

searchPhrases($params, $db, $check_only = false)

No description

deleteOldPhrases($params, $db, $check_only = false)

No description

fetchLanguages($params, $db, $check_only = false)

No description

fetchPhrasesForExport($params, $db, $check_only = false)

No description

updateLanguagePhrases($params, $db, $check_only = false)

No description

updateCronEnabled($params, $db, $check_only = false)

No description

fetchCronLogCount($params, $db, $check_only = false)

No description

fetchCronLog($params, $db, $check_only = false)

No description

pruneCronLog($params, $db, $check_only = false)

No description

fetchWolAllUsers($params, $db, $check_only = false)

No description

fetchWol($params, $db, $check_only = false)

No description

fetchWolCount($params, $db, $check_only = false)

No description

fetchTagsForCloud($params, $db, $check_only = false)

No description

fetchSearchTagsForCloud($params, $db, $check_only = false)

No description

fetchTagsForTagNavigation($params, $db, $check_only = false)

No description

fetchCountInfractionsByCond($params, $db, $check_only = false)

No description

fetchInfractionsByCondLimit($params, $db, $check_only = false)

No description

boolean
buildUserInfractions(array $params, array $db, array $check_only = false)

"Magic" Function that builds all the information regarding infractions (only used in Cron)

fetchUsersInfractionGroups($params, $db, $check_only = false)

No description

fetchModlogCount($params, $db, $check_only = false)

No description

fetchModlogs($params, $db, $check_only = false)

No description

getModLogsByConds($params, $db, $check_only = false)

No description

fetchApiLogs($params, $db, $check_only = false)

No description

fetchApiLogsCount($params, $db, $check_only = false)

No description

fetchApiLogsSqlconds($params, $db)

No description

fetchApiLogsCountDatecut($params, $db, $check_only = false)

No description

fetchApiActivity($params, $db, $check_only = false)

No description

fetchStylevarsArray($params, $db, $check_only = false)

No description

isFreeLock($params, $db, $check_only = false)

No description

getLock($params, $db, $check_only = false)

No description

releaseLock($params, $db, $check_only = false)

No description

lockTables($params, $db, $check_only = false)

Lock tables

unlockTables($params, $db, $check_only = false)

Unlock tables

updateCron($params, $db, $check_only = false)

No description

fetchPhrasesForDisplay($params, $db, $check_only = false)

No description

fetchPhrases($params, $db, $check_only = false)

No description

fetchKeepNames($params, $db, $check_only = false)

No description

fetchCountPhrasesByLang($params, $db, $check_only = false)

No description

fetchPhrasesOrderedPaged($params, $db, $check_only = false)

No description

updatePhraseDefLanguage($params, $db, $check_only = false)

No description

updatePhraseByProduct($params, $db, $check_only = false)

No description

updatePhraseLanguage($params, $db, $check_only = false)

No description

fetchPruneUsers(mixed $params, mixed $db, bool $check_only = false)

Fetch list of users to prune

replaceSetting($params, $db, $check_only = false)

No description

replaceTemplates($params, $db, $check_only = false)

No description

fetchSubs2Del($params, $db, $check_only = false)

No description

fetchUsersSubscriptions($params, $db, $check_only = false)

No description

fetchUsersForPromotion($params, $db, $check_only = false)

No description

updateUserInfractions($params, $db, $check_only = false)

No description

updateSubscribeEvent($params, $db, $check_only = false)

No description

replaceValues($params, $db, $check_only = false)

No description

insertignoreValues(mixed $params, mixed $db, bool $check_only = false)

Creates an INSERT IGNORE query based on the params that are passed

fetchMailingList(mixed $params, mixed $db, bool $check_only = false)

Fetches the mailing list for users regarding the user adminemail option.

fetchMailingListCount($params, $db, $check_only = false)

No description

updateHookStatus(mixed $params, mixed $db, bool $check_only = false)

Updates the plugin active status

removeLanguageFromPackage(mixed $params, mixed $db, bool $check_only = false)

Remove the language columns from a package

addLanguageFromPackage(mixed $params, mixed $db, bool $check_only = false)

Add the language columns from a package

fetchUsersFromCriteria(mixed $params, mixed $db, bool $check_only = false)

Fetches userlist from a given criteria.

userReferrals(mixed $params, mixed $db, bool $check_only = false)

Get referrals from a userid.

truncateTable(mixed $params, mixed $db, bool $check_only = false)

Your basic table truncate

getFiledataBatch($params, $db, $check_only = false)

No description

getNodePermTerms($excludeUserSpecific = false, $userid = null)

Composes the terms for the flags to enforce the starter-node-specific permissions.

saveDbCache($params, $db, $check_only = false)

No description

saveDbCacheEvents($params, $db, $check_only = false)

No description

getSiteThreads(mixed $params, mixed $db, bool $check_only = false)

Get all the site threads limitted by the given parentids.

fetchPermsOrdered($params, $db, $check_only = false)

No description

nodeMarkread($params, $db, $check_only = false)

No description

getInfractionsByType($params, $db, $check_only = false)

No description

fetchMemberList($params, $db, $check_only = false)

No description

fetchAdminusersFromUsergroup($params, $db, $check_only = false)

No description

Details

in vB_Trait_NoSerialize at line 15
__sleep()

in vB_Trait_NoSerialize at line 20
__wakeup()

in vB_dB_QueryDefs at line 87
mixed getTableData()

This returns the table definitions

Return Value

mixed

in vB_dB_QueryDefs at line 97
mixed getQueryData()

This returns the query definitions

Return Value

mixed

in vB_dB_QueryDefs at line 111
protected getResultSet(object $db, string $sql)

Returns the resultset for a particular query string

Intend for use by method queries to reduce repetative code and increase standardization

Parameters

object $db -- the internal db connection object for this DB type
string $sql -- the query string for this DB type.

at line 3016
getModeratorInfo($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3043
getChangelogData($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3151
getStyle($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3195
searchTemplates($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3241
getStyleByConds($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3266
fetchUserinfo($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3386
fetchLanguage($params, $dbobject, $check_only = false)

Parameters

$params
$dbobject
$check_only

at line 3455
userFind($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3622
userFindCount($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3704
userInsertSubscribeevent($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3749
userInsertAnnouncementread($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3792
userDeleteUsergrouprequest($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3820
userSearchRegisterIP($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3859
userSearchIPUsage($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3900
userReferrers($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3945
fetchPhraseInfo($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 3970
updateInvisible($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4006
disableProducts($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4040
updateMemberForDeletedUsergroup($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4121
fetchPromotions($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4144
deleteOrphans($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4170
keepOrphans($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4213
searchPhrases($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4361
deleteOldPhrases($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4387
fetchLanguages($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4416
fetchPhrasesForExport($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4450
updateLanguagePhrases($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4511
updateCronEnabled($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4549
fetchCronLogCount($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4580
fetchCronLog($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4640
pruneCronLog($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4672
fetchWolAllUsers($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4773
fetchWol($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4805
fetchWolCount($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4850
fetchTagsForCloud($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4873
fetchSearchTagsForCloud($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4900
fetchTagsForTagNavigation($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4936
fetchCountInfractionsByCond($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 4959
fetchInfractionsByCondLimit($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5104
boolean buildUserInfractions(array $params, array $db, array $check_only = false)

"Magic" Function that builds all the information regarding infractions (only used in Cron)

Parameters

array $params Infraction Points Array
array $db Infractions Array
array $check_only Warnings Array

Return Value

boolean Whether infractions info was updated.

at line 5215
fetchUsersInfractionGroups($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5240
fetchModlogCount($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5294
fetchModlogs($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5372
getModLogsByConds($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5393
fetchApiLogs($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5429
fetchApiLogsCount($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5449
protected fetchApiLogsSqlconds($params, $db)

Parameters

$params
$db

at line 5491
fetchApiLogsCountDatecut($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5512
fetchApiActivity($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5567
fetchStylevarsArray($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5606
isFreeLock($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5628
getLock($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5649
releaseLock($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5674
lockTables($params, $db, $check_only = false)

Lock tables

Parameters

$params
$db
$check_only

at line 5709
unlockTables($params, $db, $check_only = false)

Unlock tables

Parameters

$params
$db
$check_only

at line 5722
updateCron($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5768
fetchPhrasesForDisplay($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5815
fetchPhrases($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5852
fetchKeepNames($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5873
fetchCountPhrasesByLang($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5893
fetchPhrasesOrderedPaged($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5921
updatePhraseDefLanguage($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5953
updatePhraseByProduct($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 5996
updatePhraseLanguage($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 6036
fetchPruneUsers(mixed $params, mixed $db, bool $check_only = false)

Fetch list of users to prune

Parameters

mixed $params
mixed $db a db pointer
bool $check_only

at line 6136
replaceSetting($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 6207
replaceTemplates($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 6294
fetchSubs2Del($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 6321
fetchUsersSubscriptions($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 6357
fetchUsersForPromotion($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 6383
updateUserInfractions($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 6435
updateSubscribeEvent($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 6467
replaceValues($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 6535
insertignoreValues(mixed $params, mixed $db, bool $check_only = false)

Creates an INSERT IGNORE query based on the params that are passed

Parameters

mixed $params
mixed $db a db pointer
bool $check_only

at line 6605
fetchMailingList(mixed $params, mixed $db, bool $check_only = false)

Fetches the mailing list for users regarding the user adminemail option.

Parameters

mixed $params
mixed $db a db pointer
bool $check_only

at line 6643
fetchMailingListCount($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 6755
updateHookStatus(mixed $params, mixed $db, bool $check_only = false)

Updates the plugin active status

Parameters

mixed $params
mixed $db a db pointer
bool $check_only

at line 6808
removeLanguageFromPackage(mixed $params, mixed $db, bool $check_only = false)

Remove the language columns from a package

Parameters

mixed $params
mixed $db a db pointer
bool $check_only

at line 6848
addLanguageFromPackage(mixed $params, mixed $db, bool $check_only = false)

Add the language columns from a package

Parameters

mixed $params
mixed $db a db pointer
bool $check_only

at line 6878
fetchUsersFromCriteria(mixed $params, mixed $db, bool $check_only = false)

Fetches userlist from a given criteria.

Parameters

mixed $params
mixed $db a db pointer
bool $check_only

at line 6941
userReferrals(mixed $params, mixed $db, bool $check_only = false)

Get referrals from a userid.

This can be also limited startdate and enddate (datelines).

Parameters

mixed $params
mixed $db a db pointer
bool $check_only

at line 6984
truncateTable(mixed $params, mixed $db, bool $check_only = false)

Your basic table truncate

Parameters

mixed $params
mixed $db a db pointer
bool $check_only

at line 7003
getFiledataBatch($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 7040
protected getNodePermTerms($excludeUserSpecific = false, $userid = null)

Composes the terms for the flags to enforce the starter-node-specific permissions.

Parameters

$excludeUserSpecific bool Exclude user specific queries. Used for precaching
$userid bool User whose context will be used. If not set, it'll be the current user.

at line 7173
saveDbCache($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 7341
saveDbCacheEvents($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 7393
getSiteThreads(mixed $params, mixed $db, bool $check_only = false)

Get all the site threads limitted by the given parentids.

Parameters

mixed $params
mixed $db a db pointer
bool $check_only

at line 7446
fetchPermsOrdered($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 7475
nodeMarkread($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 7509
getInfractionsByType($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 7554
fetchMemberList($params, $db, $check_only = false)

Parameters

$params
$db
$check_only

at line 7660
fetchAdminusersFromUsergroup($params, $db, $check_only = false)

Parameters

$params
$db
$check_only