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;
}
}
