function controller_plugin_query($controller) { $tables = DB_PLUGINS . ', ' . DB_PLUGINS_LOOKUP; //set variable value to retrieve plugin_id $columns = 'DISTINCT(' . DB_PLUGINS_LOOKUP . '.plugin_id)'; $where = DB_PLUGINS_LOOKUP . '.plugin_id=' . DB_PLUGINS . '.plugin_id AND ' . DB_PLUGINS_LOOKUP . '.plugin_type=?'; $field = array($controller); //build query and return results $db_results = BuildQuery::all_field_query($tables, $columns, $where, $field); self::$db_controller_plugins = $db_results; }
function group_plugin_query($group) { $tables = DB_PLUGINS . ', ' . DB_PLUGINS_LOOKUP; //set variable value to retrieve plugin_id $columns = DB_PLUGINS_LOOKUP . '.plugin_id'; $where = DB_PLUGINS_LOOKUP . '.plugin_id=' . DB_PLUGINS . '.plugin_id AND ' . DB_PLUGINS_LOOKUP . '.content_group=?'; $field = array($group); //build query and return results $db_results = BuildQuery::all_field_query($tables, $columns, $where, $field); self::$db_group_plugins = $db_results; }
private function taxonomy_content_query($controller, $params) { if (isset($params['id'])) { $tables = DB_CONTENT . ', ' . DB_CONTENT_LOOKUP; $columns = DB_CONTENT . '.*'; $where = "content.contentid=content_lookup.content_id and content_lookup.taxa_id=?"; $field = array($params['id']); $db_results = BuildQuery::all_field_query($tables, $columns, $where, $field); self::$db_taxonomy_content = $db_results; } }
private function menu_child_query($menu_id, $parent_id) { if (isset($parent_id)) { $tables = DB_MENU_LOOKUP . ', ' . DB_NODE; $columns = DB_NODE . '.*'; $where = DB_MENU_LOOKUP . '.node_id=' . DB_NODE . '.node_id and ' . DB_MENU_LOOKUP . '.menu_id=? and ' . DB_MENU_LOOKUP . '.parent_id=?'; $fields = array($menu_id, $parent_id); $db_results = BuildQuery::all_field_query($tables, $columns, $where, $fields); } return $db_results; }
private function plugin_query($controller, $format) { $tables = DB_PLUGINS . ', ' . DB_PLUGINS_LOOKUP; //set variable value to retrieve plugin_id $columns = DB_PLUGINS_LOOKUP . '.plugin_id'; $where = DB_PLUGINS_LOOKUP . '.plugin_id=' . DB_PLUGINS . '.plugin_id AND ' . DB_PLUGINS_LOOKUP . '.plugin_type=? AND ' . DB_PLUGINS_LOOKUP . '.content_type=?'; $fields = array($controller, $format); //build query and return results $db_results = BuildQuery::all_field_query($tables, $columns, $where, $fields); self::$db_all_plugins = $db_results; }
private function content_group_query($controller, $format, $group, $params) { if (isset($params['id'])) { $tables = $controller . ', ' . $controller . '_lookup, ' . $controller . '_group, ' . $controller . '_type'; $columns = $controller . '.*'; $where = 'content_lookup.content_id=content.contentid AND content_lookup.content_type_id=content_type.content_type_id AND content_lookup.content_group_id=content_group.content_group_id AND content_type.content_type_name=? AND content_group.content_group_name=? AND content_lookup.taxa_id=?'; $fields = array($format, $group, $params['id']); //build single query from BuildQuery class $db_results = BuildQuery::all_field_query($tables, $columns, $where, $fields); self::$db_content_group = $db_results; } }
private function search_row_query($controller, $params) { if (isset($params['query'])) { $tables = 'content'; $columns = 'content.*'; $where = 'match (content.contenttext) against (? in boolean mode) order by content.contentid'; $fields = array($params['query']); //build query from BuildQuery class $db_results = BuildQuery::all_field_query($tables, $columns, $where, $fields); //print_r($db_results); self::$db_content_rows = $db_results; } }
private function content_group_query($controller, $format, $group, $params) { if (isset($params['id'])) { $tables = $controller . ', ' . $controller . '_lookup, ' . $controller . '_group, ' . $controller . '_type'; $columns = $controller . '.*'; $where = DB_CONTENT_LOOKUP . '.content_id=' . DB_CONTENT . '.contentid AND ' . DB_CONTENT_LOOKUP . '.content_type_id=' . DB_CONTENT_TYPE . '.content_type_id AND ' . DB_CONTENT_LOOKUP . '.content_group_id=' . DB_CONTENT_GROUP . '.content_group_id AND ' . DB_CONTENT_TYPE . '.content_type_name=? AND ' . DB_CONTENT_GROUP . '.content_group_name=? AND ' . DB_CONTENT_LOOKUP . '.taxa_id=? ORDER BY ' . DB_CONTENT . '.contentid'; $fields = array($format, $group, $params['id']); //build single query from BuildQuery class $db_results = BuildQuery::all_field_query($tables, $columns, $where, $fields); self::$db_content_group = $db_results; } }
private function taxonomy_content_query($controller, $params) { if (isset($params['id'])) { $tables = DB_CONTENT . ', ' . DB_CONTENT_LOOKUP; $columns = 'DISTINCT ' . DB_CONTENT . '.*'; $where = DB_CONTENT . '.contentid=' . DB_CONTENT_LOOKUP . '.content_id and ' . DB_CONTENT_LOOKUP . '.taxa_id=?'; $field = array($params['id']); $db_results = BuildQuery::all_field_query($tables, $columns, $where, $field); return $db_results; } }