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 content_field_query($controller, $format, $params)
{
if (isset($params['id'])) {
$table = $controller;
$column = $controller . $format;
$where = "contentid";
$field = array($params['id']);
//build single query from BuildQuery class
$db_results = BuildQuery::single_field_query($table, $column, $where, $field);
$db_result = $db_results[$column];
self::$db_content_field = $db_result;
}
}
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;
}
