Class: TeraWurflDatabase_MySQL5_NestedSet

Class: TeraWurflDatabase_MySQL5

TeraWurflDatabase_MySQL5::$CACHE_STORAGE_ENGINE

TeraWurflDatabase_MySQL5::$connected

TeraWurflDatabase_MySQL5::$dbcon

TeraWurflDatabase_MySQL5::$db_implements_fallback

TeraWurflDatabase_MySQL5::$db_implements_ld

TeraWurflDatabase_MySQL5::$db_implements_ris

TeraWurflDatabase_MySQL5::$DB_MAX_INSERTS

TeraWurflDatabase_MySQL5::$errors

TeraWurflDatabase_MySQL5::$hostPrefix

TeraWurflDatabase_MySQL5::$maxquerysize

TeraWurflDatabase_MySQL5::$numQueries

TeraWurflDatabase_MySQL5::$PERSISTENT_CONNECTION

TeraWurflDatabase_MySQL5::$STORAGE_ENGINE

TeraWurflDatabase_MySQL5::$WURFL_ID_COLUMN_TYPE

TeraWurflDatabase_MySQL5::$WURFL_ID_MAX_LENGTH

Class: TeraWurflDatabase

TeraWurflDatabase::$DB_TEMP_EXT

TeraWurflDatabase::$tablename

Class: TeraWurflDatabase_MySQL5

TeraWurflDatabase_MySQL5::__construct()

TeraWurflDatabase_MySQL5::cleanConnection()

TeraWurflDatabase_MySQL5::clearMatcherTables()

Drops then creates all the UserAgentMatcher device tables

TeraWurflDatabase_MySQL5::clearTable()

TeraWurflDatabase_MySQL5::connect()

Establishes connection to database (does not check for DB sanity)

TeraWurflDatabase_MySQL5::createCacheTable()

TeraWurflDatabase_MySQL5::createGenericDeviceTable()

Drops and creates the given device table

TeraWurflDatabase_MySQL5::createIndexTable()

Drops and creates the index table

TeraWurflDatabase_MySQL5::createMergeTable()

Drops and creates the MERGE table

TeraWurflDatabase_MySQL5::createProcedures()

TeraWurflDatabase_MySQL5::createSettingsTable()

Creates the settings table if it does not already exist

TeraWurflDatabase_MySQL5::createTempCacheTable()

TeraWurflDatabase_MySQL5::getActualDeviceAncestor()

TeraWurflDatabase_MySQL5::getCachedUserAgents()

TeraWurflDatabase_MySQL5::getDeviceFallBackTree()

TeraWurflDatabase_MySQL5::getDeviceFallBackTree_NS()

Returns an Array containing the complete capabilities array for each

TeraWurflDatabase_MySQL5::getDeviceFromCache()

TeraWurflDatabase_MySQL5::getDeviceFromID()

TeraWurflDatabase_MySQL5::getDeviceFromUA()

TeraWurflDatabase_MySQL5::getDeviceFromUA_LD()

TeraWurflDatabase_MySQL5::getDeviceFromUA_RIS()

TeraWurflDatabase_MySQL5::getFullDeviceList()

TeraWurflDatabase_MySQL5::getMatcherTableList()

TeraWurflDatabase_MySQL5::getServerVersion()

TeraWurflDatabase_MySQL5::getSetting()

TeraWurflDatabase_MySQL5::getTableList()

TeraWurflDatabase_MySQL5::getTableStats()

TeraWurflDatabase_MySQL5::loadDevices()

TeraWurflDatabase_MySQL5::rebuildCacheTable()

TeraWurflDatabase_MySQL5::saveDeviceInCache()

TeraWurflDatabase_MySQL5::SQLPrep()

TeraWurflDatabase_MySQL5::updateSetting()

TeraWurflDatabase_MySQL5::verifyConfig()

TeraWurflDatabase_MySQL5::__destruct()

Destructor, disconnect from database

Class: TeraWurflDatabase

TeraWurflDatabase::__construct()

TeraWurflDatabase::clearTable()

Truncate or drop+create the given table

TeraWurflDatabase::connect()

Establishes a database connection and stores connection in $this->dbcon

TeraWurflDatabase::createCacheTable()

Creates the cache table

TeraWurflDatabase::createGenericDeviceTable()

Creates a table capable of holding devices (WURFL ID, User Agent and Capabilities)

TeraWurflDatabase::createIndexTable()

Creates the index table

TeraWurflDatabase::createProcedures()

Creates supporting stored procedures

TeraWurflDatabase::createSettingsTable()

Creates the settings table

TeraWurflDatabase::getActualDeviceAncestor()

Returns the WURFL ID for the Actual Device Root in the given device's fall back tree. This can be null if it does not exist.

TeraWurflDatabase::getCachedUserAgents()

Returns and array of the cached User Agents

TeraWurflDatabase::getDeviceFallBackTree()

Find the matching Device ID for a given User Agent using LD (Leveshtein Distance)

TeraWurflDatabase::getDeviceFromCache()

Return capabilities array for the given User Agent, or null if not found

TeraWurflDatabase::getDeviceFromID()

Returns the capabilities array from a given WURFL Device ID

TeraWurflDatabase::getDeviceFromUA()

Returns the WURFL ID from a raw User Agent if an exact match is found

TeraWurflDatabase::getDeviceFromUA_LD()

Find the matching Device ID for a given User Agent using LD (Leveshtein Distance)

TeraWurflDatabase::getDeviceFromUA_RIS()

Find the matching Device ID for a given User Agent using RIS (Reduction in String)

TeraWurflDatabase::getFullDeviceList()

Returns an associative array of all the data from the given table in the form [WURFL ID] => [User Agent]

TeraWurflDatabase::getLastError()

Returns the most recent error message

TeraWurflDatabase::getMatcherTableList()

Returns an array of the User Agent Matcher tables in the database

TeraWurflDatabase::getServerVersion()

Returns the version string of the database server

TeraWurflDatabase::getSetting()

Get setting from settings table by a given key

TeraWurflDatabase::getTableList()

Returns an array of all the tables in the database

TeraWurflDatabase::getTableStats()

Returns an associative array of statistics from given table

TeraWurflDatabase::initializeDB()

Creates and prepares the database

TeraWurflDatabase::loadDevices()

Loads the pre-processed WURFL tables into the database

TeraWurflDatabase::rebuildCacheTable()

Rebuilds the cache table by redetecting the cached devices against the loaded WURFL

TeraWurflDatabase::saveDeviceInCache()

Save the given User Agent and Device capabilities array to the database

TeraWurflDatabase::SQLPrep()

Prepares raw text for use in queries (adding quotes and escaping characters if necessary)

TeraWurflDatabase::updateSetting()

Adds/updates a key=>value pair in the settings table

TeraWurflDatabase::verifyConfig()

Checks if the database configuration is correct and that all required permissions