vBulletin v6.0.4

vB_dB_MYSQL_Query_Method extends vB_dB_Query_Method

in package

• vBDatabase

This is the MySQL-Specific version of the method query processor

Table of Contents

Constants

BITFIELDS_KEY  = '#bitfields'

BITFIELDS_SET  = '#bitset'

BITFIELDS_UNSET  = '#bitunset'

COLUMNS_KEY  = '#columns'

CONDITION_ALL  = '#all'

CONDITIONS_KEY  = '#filters'

This class is called by the new vB_dB_Assertor database class It does the actual execution. See the vB_dB_Assertor class for more information

DEBUG_QUERY  = '#debug'

FIELDS_KEY  = '#fields'

OPERATOR_AND  = '#AND'

OPERATOR_BEGINS  = 'BEGINS'

OPERATOR_ENDS  = 'ENDS'

OPERATOR_EQ  = 'EQ'

OPERATOR_FALSE  = 'FALSE'

OPERATOR_GT  = 'GT'

OPERATOR_GTE  = 'GTE'

OPERATOR_INCLUDES  = 'INCLUDES'

OPERATOR_ISNOTNULL  = 'IS NOT NULL'

OPERATOR_ISNULL  = 'IS NULL'

OPERATOR_KEY  = 'operator'

OPERATOR_LT  = 'LT'

OPERATOR_LTE  = 'LTE'

OPERATOR_NAND  = '#NAND'

OPERATOR_NE  = 'NE'

OPERATOR_OR  = '#OR'

PARAM_LIMIT  = '#limit'

PARAM_LIMITPAGE  = '#limit_page'

PARAM_LIMITSTART  = '#limit_start'

PRIORITY_QUERY  = '#priority'

QUERY_ALTER  = 'a'

QUERY_COUNT  = 'co'

QUERY_CREATE  = 'cr'

QUERY_DELETE  = 'd'

QUERY_DROP  = 'dr'

QUERY_INSERT  = 'i'

QUERY_INSERTIGNORE  = 'ig'

QUERY_METHOD  = 'm'

QUERY_MULTIPLEINSERT  = 'mi'

QUERY_REPLACE  = 'r'

QUERY_SELECT  = 's'

QUERY_STORED  = 'st'

QUERY_SUMMARY  = 'sum'

QUERY_TABLE  = 't'

QUERY_UPDATE  = 'u'

QUERYTYPE_KEY  = '#querytype'

SORT_ASC  = 'ASC'

SORT_DESC  = 'DESC'

TYPE_KEY  = '#type'

VALUE_ISNULL  = '#NULL'

VALUES_KEY  = '#values'

Methods

__construct()  : mixed

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

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

__unserialize()  : void

__wakeup()  : void

debugDisplayNextQuerySql()  : mixed

Causes the SQL for the next query that is exectuted to be displayed for debugging purposes. This only works if debug mode is turned on

execSQL()  : mixed

This function is the public interface to actually execute the SQL.

getQuery()  : mixed

setQuery()  : mixed

This loads and validates the data- ensures we have all we need

setTableQuery()  : mixed

This loads and validates the data for a table. There's some extra work required