vBulletin v6.0.4

vB_dB_MYSQL_QueryDefs extends vB_dB_QueryDefs
in package

Table of Contents

Methods

__serialize()  : array<string|int, mixed>
__sleep()  : array<string|int, mixed>
__unserialize()  : void
__wakeup()  : void
addLanguageFromPackage()  : mixed
Add the language columns from a package
addUserField()  : mixed
anyAdminAsSecondaryExists()  : mixed
buildUserInfractions()  : bool
"Magic" Function that builds all the information regarding infractions (only used in Cron)
bulkUpsertBbCodeData()  : mixed
deleteOldPhrases()  : mixed
deleteOrphans()  : mixed
fetchAdminusersFromUsergroup()  : mixed
fetchApiActivity()  : mixed
fetchApiLogs()  : mixed
fetchApiLogsCount()  : mixed
fetchApiLogsCountDatecut()  : mixed
fetchCountInfractionsByCond()  : mixed
fetchCountPhrasesByLang()  : mixed
fetchCronLog()  : mixed
fetchCronLogCount()  : mixed
fetchInfractionsByCondLimit()  : mixed
fetchKeepNames()  : mixed
fetchLanguage()  : mixed
fetchLanguages()  : mixed
fetchMailingList()  : mixed
Fetches the mailing list for users regarding the user adminemail option.
fetchMailingListCount()  : mixed
fetchMemberList()  : mixed
fetchMemberListCount()  : mixed
fetchModlogCount()  : mixed
fetchModlogs()  : mixed
fetchPermsOrdered()  : mixed
fetchPhraseInfo()  : mixed
fetchPhrases()  : mixed
fetchPhrasesForDisplay()  : mixed
fetchPhrasesForExport()  : mixed
fetchPhrasesOrderedPaged()  : mixed
fetchPromotions()  : mixed
fetchPruneUsers()  : mixed
Fetch list of users to prune
fetchSearchTagsForCloud()  : mixed
fetchStylevarsArray()  : mixed
fetchSubs2Del()  : mixed
fetchTagsForCloud()  : mixed
fetchTagsForTagNavigation()  : mixed
fetchUserinfo()  : mixed
fetchUsersForPromotion()  : mixed
fetchUsersFromCriteria()  : mixed
Fetches userlist from a given criteria.
fetchUsersInfractionGroups()  : mixed
fetchUsersSubscriptions()  : mixed
fetchWolAllUsers()  : mixed
fetchWolCount()  : mixed
getChangelogData()  : mixed
getInfractionsByType()  : mixed
getLock()  : mixed
getModeratorInfo()  : mixed
getQueryData()  : array<string|int, mixed>
This returns the query definitions
getSiteThreads()  : mixed
Get all the site threads limitted by the given parentids.
getStyle()  : mixed
getStyleByConds()  : mixed
getTableData()  : array<string|int, mixed>
This returns the table definitions
getUsersForPrivacyDeletion()  : mixed
insertignoreValues()  : mixed
Creates an INSERT IGNORE query based on the params that are passed
isFreeLock()  : mixed
keepOrphans()  : mixed
lockTables()  : mixed
Lock tables
pruneCronLog()  : mixed
releaseLock()  : mixed
removeLanguageFromPackage()  : mixed
Remove the language columns from a package
replaceSetting()  : mixed
replaceTemplates()  : mixed
replaceValues()  : mixed
saveDbCache()  : mixed
saveDbCacheEvents()  : mixed
searchPhrases()  : mixed
searchTemplates()  : mixed
truncateTable()  : mixed
Your basic table truncate
unlockTables()  : mixed
Unlock tables
updateCron()  : mixed
updateCronEnabled()  : mixed
updateHookStatus()  : mixed
updateInvisible()  : mixed
updateMemberForDeletedUsergroup()  : mixed
updateSubscribeEvent()  : mixed
updateUserInfractions()  : mixed
userFind()  : mixed
userFindCount()  : mixed
userInsertSubscribeevent()  : mixed
userReferrers()  : mixed
Generate a report of user referrals for the given time period
userSearchIPUsage()  : mixed
userSearchRegisterIP()  : mixed

Methods

__serialize()

public __serialize() : array<string|int, mixed>
Return values
array<string|int, mixed>

__sleep()

public __sleep() : array<string|int, mixed>
Return values
array<string|int, mixed>

__unserialize()

public __unserialize(array<string|int, mixed> $serialized) : void
Parameters
$serialized : array<string|int, mixed>

addLanguageFromPackage()

Add the language columns from a package

public addLanguageFromPackage(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

addUserField()

public addUserField(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

anyAdminAsSecondaryExists()

public anyAdminAsSecondaryExists(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

buildUserInfractions()

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

public buildUserInfractions(mixed $params, mixed $db[, mixed $check_only = false ]) : bool
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false
Return values
bool —

Whether infractions info was updated.

bulkUpsertBbCodeData()

public bulkUpsertBbCodeData(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

deleteOldPhrases()

public deleteOldPhrases(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

deleteOrphans()

public deleteOrphans(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchAdminusersFromUsergroup()

public fetchAdminusersFromUsergroup(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchApiActivity()

public fetchApiActivity(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchApiLogs()

public fetchApiLogs(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchApiLogsCount()

public fetchApiLogsCount(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchApiLogsCountDatecut()

public fetchApiLogsCountDatecut(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchCountInfractionsByCond()

public fetchCountInfractionsByCond(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchCountPhrasesByLang()

public fetchCountPhrasesByLang(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchCronLog()

public fetchCronLog(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchCronLogCount()

public fetchCronLogCount(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchInfractionsByCondLimit()

public fetchInfractionsByCondLimit(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchKeepNames()

public fetchKeepNames(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchLanguage()

public fetchLanguage(mixed $params, mixed $dbobject[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$dbobject : mixed
$check_only : mixed = false

fetchLanguages()

public fetchLanguages(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchMailingList()

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

public fetchMailingList(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false
Tags
result

mixed

fetchMailingListCount()

public fetchMailingListCount(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchMemberList()

public fetchMemberList(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchMemberListCount()

public fetchMemberListCount(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchModlogCount()

public fetchModlogCount(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchModlogs()

public fetchModlogs(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchPermsOrdered()

public fetchPermsOrdered(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchPhraseInfo()

public fetchPhraseInfo(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchPhrases()

public fetchPhrases(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchPhrasesForDisplay()

public fetchPhrasesForDisplay(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchPhrasesForExport()

public fetchPhrasesForExport(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchPhrasesOrderedPaged()

public fetchPhrasesOrderedPaged(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchPromotions()

public fetchPromotions(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchPruneUsers()

Fetch list of users to prune

public fetchPruneUsers(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false
Tags
result

mixed

fetchSearchTagsForCloud()

public fetchSearchTagsForCloud(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchStylevarsArray()

public fetchStylevarsArray(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchSubs2Del()

public fetchSubs2Del(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchTagsForCloud()

public fetchTagsForCloud(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchTagsForTagNavigation()

public fetchTagsForTagNavigation(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchUserinfo()

public fetchUserinfo(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchUsersForPromotion()

public fetchUsersForPromotion(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchUsersFromCriteria()

Fetches userlist from a given criteria.

public fetchUsersFromCriteria(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false
Tags
result

mixed

fetchUsersInfractionGroups()

public fetchUsersInfractionGroups(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchUsersSubscriptions()

public fetchUsersSubscriptions(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchWolAllUsers()

public fetchWolAllUsers(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

fetchWolCount()

public fetchWolCount(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

getChangelogData()

public getChangelogData(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

getInfractionsByType()

public getInfractionsByType(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

getLock()

public getLock(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

getModeratorInfo()

public getModeratorInfo(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

getQueryData()

This returns the query definitions

public getQueryData() : array<string|int, mixed>
Return values
array<string|int, mixed>

getSiteThreads()

Get all the site threads limitted by the given parentids.

public getSiteThreads(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false
Tags
result

mixed

getStyle()

public getStyle(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

getStyleByConds()

public getStyleByConds(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

getTableData()

This returns the table definitions

public getTableData() : array<string|int, mixed>
Return values
array<string|int, mixed>

getUsersForPrivacyDeletion()

public getUsersForPrivacyDeletion(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

insertignoreValues()

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

public insertignoreValues(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false
Tags
result

mixed

isFreeLock()

public isFreeLock(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

keepOrphans()

public keepOrphans(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

lockTables()

Lock tables

public lockTables(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

pruneCronLog()

public pruneCronLog(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

releaseLock()

public releaseLock(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

removeLanguageFromPackage()

Remove the language columns from a package

public removeLanguageFromPackage(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false
Tags
result

mixed

replaceSetting()

public replaceSetting(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

replaceTemplates()

public replaceTemplates(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

replaceValues()

public replaceValues(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

saveDbCache()

public saveDbCache(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

saveDbCacheEvents()

public saveDbCacheEvents(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

searchPhrases()

public searchPhrases(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

searchTemplates()

public searchTemplates(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

truncateTable()

Your basic table truncate

public truncateTable(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false
Tags
result

mixed

unlockTables()

Unlock tables

public unlockTables(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

updateCron()

public updateCron(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

updateCronEnabled()

public updateCronEnabled(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

updateHookStatus()

public updateHookStatus(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

updateInvisible()

public updateInvisible(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

updateMemberForDeletedUsergroup()

public updateMemberForDeletedUsergroup(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

updateSubscribeEvent()

public updateSubscribeEvent(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

updateUserInfractions()

public updateUserInfractions(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

userFind()

public userFind(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

userFindCount()

public userFindCount(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

userInsertSubscribeevent()

public userInsertSubscribeevent(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

userReferrers()

Generate a report of user referrals for the given time period

public userReferrers(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

userSearchIPUsage()

public userSearchIPUsage(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false

userSearchRegisterIP()

public userSearchRegisterIP(mixed $params, mixed $db[, mixed $check_only = false ]) : mixed
Parameters
$params : mixed
$db : mixed
$check_only : mixed = false 

        

        
    




    

    

                                

                

                                
    

        On this page

        
    


                

                            

            

    

        

            
Search results