private function map_row_query($controller, $params)
{
if (isset($params['id'])) {
$table = DB_CONTENT;
$where = "contentid";
$field = array($params['id']);
//build single query from BuildQuery class
$db_results = BuildQuery::single_row_query($table, $where, $field);
self::$db_content_row = $db_results;
}
}
private function taxonomy_row_query($params)
{
if (isset($params['id'])) {
$table = DB_TAXONOMY;
$where = "taxa_id";
$field = array($params['id']);
//build single query from BuildQuery class
$db_results = BuildQuery::single_row_query($table, $where, $field);
self::$db_taxonomy_row = $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;
}
function plugin_details($plugin_id)
{
if (isset($plugin_id)) {
$table = DB_PLUGINS;
//set variable value to retrieve all columns
$column = '*';
$where = 'plugin_id';
$field = array($plugin_id);
//build single query from BuildQuery class
$db_results = BuildQuery::single_field_query($table, $column, $where, $field);
self::$db_plugin_details = $db_results;
}
}
private function meta_row_query($controller, $params)
{
if (isset($params['id'])) {
$tables = $controller . '_meta, ' . $controller . '_lookup';
//set variable value to retrieve all columns
$columns = $controller . '_meta.*';
$where = $controller . '_lookup.meta_id=' . $controller . '_meta.meta_id AND ' . $controller . '_lookup.' . $controller . '_id';
$field = array($params['id']);
//build single query from BuildQuery class
$db_results = BuildQuery::single_field_query($tables, $columns, $where, $field);
self::$db_meta_row = $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 meta_row_query($controller, $format, $params)
{
if (isset($params['id'])) {
$tables = $controller . '_meta, ' . $controller . '_lookup';
//set variable value to retrieve all columns
$columns = $controller . '_meta.*';
if (!empty($format)) {
$type_id = ContentController::get_content_type($controller, $format);
}
$where = $controller . '_lookup.meta_id=' . $controller . '_meta.meta_id AND ' . $controller . '_lookup.' . $controller . '_type_id=? AND ' . $controller . '_lookup.' . $controller . '_id=?';
$field = array($type_id, $params['id']);
//build single query from BuildQuery class
$db_results = BuildQuery::single_lookup_query($tables, $columns, $where, $field);
self::$db_meta_row = $db_results;
}
}
private function content_type_query($controller, $format)
{
$table = $controller . '_type';
$column = $controller . '_type_id';
$where = $controller . "_type_name";
$field = array($format);
//build single query from BuildQuery class
$db_results = BuildQuery::single_field_query($table, $column, $where, $field);
$db_result = $db_results[$column];
self::$db_content_type = $db_result;
}
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;
}
}
