public function __construct() { //query the users table $this->logged = false; $this->admin = false; $this->super_user = false; $this->db = AdaptorMysql::getInstance(); //get all tables and such }
public function getCustomHeaders() { $r = ''; if ($q = AdaptorMysql::query("SELECT * FROM `" . BLACKBIRD_TABLE_PREFIX . "headers`")) { foreach ($q as $row) { $r .= $row['javascript'] . "\t\t\n" . $row['css'] . "\t\t\n"; } } return $r; }
public function Getimage() { $this->layout_view = null; $id = $_POST['id']; $table = $_POST['table']; $table_parent = $_POST['table_parent']; $name_space = $_POST['name_space']; $q_relation = AdaptorMysql::queryRow("SELECT * FROM " . BLACKBIRD_TABLE_PREFIX . "relations WHERE table_parent = '{$table_parent}' AND table_child = '{$table}'"); $config = _ControllerFront::parseConfig($q_relation['config']); $this->view(array('view' => '_image', 'data' => array('id' => $id, 'table' => $table, 'config' => $config, 'name_space' => $name_space))); }
public function __construct($database) { if (!isset($database)) { $this->db = AdaptorMysql::getInstance(); } else { $this->db = $database; } if (isset($_REQUEST['debug']) && isset($_REQUEST['action'])) { $this->action = $_REQUEST['action']; header('Content-Type: text'); } else { $this->dom = new DomDocument(); $this->dom->preserveWhiteSpace = false; $inputSocket = fopen('php://input', 'rb'); $contents = stream_get_contents($inputSocket); fclose($inputSocket); //GLOBALS['HTTP_RAW_POST_DATA'] - does not work without php.ini tweaking $this->dom->loadXML($contents); $this->response = array(); $this->errors = array(); //action $this->action = $this->dom->firstChild->getAttribute('Type'); //payload if ($this->payload = $this->dom->getElementsByTagName('Payload')->item(0)) { } else { $this->payload = null; } //params if ($params = $this->dom->getElementsByTagName('Param')) { $this->params = array(); foreach ($params as $param) { $t = $param->getAttribute('Name'); if ($param->hasChildNodes()) { $this->params[$t] = $param->firstChild->nodeValue; } else { $this->params[$t] = ''; } } } } }
function plugin__format_column($col_name, $col_value, $table) { $boolSet = array("admin"); if (in_array($col_name, $boolSet)) { if ($col_value == 0) { return "false"; } if ($col_value == 1) { return "true"; } } if ($col_name == 'active') { if ($col_value == 1) { return 'Active'; } if ($col_value == 0) { return 'Inactive'; } } if ($col_name == 'groups') { //split list $tA = explode(',', $col_value); $r = array(); foreach ($tA as $item) { $q = AdaptorMysql::queryRow("SELECT name FROM " . BLACKBIRD_TABLE_PREFIX . "groups WHERE id = '{$item}'"); $r[] = $q['name']; } return join(', ', $r); } if ($col_name == 'user_id' && $table == BLACKBIRD_TABLE_PREFIX . 'history') { $q = AdaptorMysql::queryRow("SELECT email FROM " . BLACKBIRD_USERS_TABLE . " WHERE id = '{$col_value}'"); return $q['email']; } if (strlen($col_value) > 100) { $data = substr($col_value, 0, 100) . "..."; return strip_tags($data); } return $col_value; }
public static function update($table, $row_data, $k, $v) { if (array_key_exists(0, $row_data)) { $row_data = self::formatRows($row_data); } $columns = array(); foreach ($row_data as $key => $value) { if (is_null($value)) { if (AdaptorMysql::isNullable($table, $key)) { $columns[] = '`' . $key . '` = NULL'; } else { $columns[] = '`' . $key . '` = \'\''; } } else { $columns[] = '`' . $key . '` = \'' . mysql_real_escape_string(stripslashes($value)) . '\''; } } $sql = "UPDATE `{$table}` SET " . implode(',', $columns) . " WHERE `{$k}` = '{$v}'"; mysql_query($sql, self::$connection) or die(mysql_error() . "<p class=\"error\">{$sql}</p>"); return $sql; }
//explode right on = $v = explode('=',$value); //explode left on -- $k = explode('--',$v[0]); $myA[$k[1]] = $v[1]; } $i++; } */ define('LIB', $base . 'cms/bobolink/'); require LIB . 'database/Db.interface.php'; require LIB . 'database/AdaptorMysql.class.php'; require LIB . 'utils/Utils.class.php'; require $base . 'cms/_version.php'; $db = new AdaptorMysql(); // Check to see if we have a sufficient schema installed if ($db->query("SHOW TABLES LIKE 'cms_info'")) { if ($q = $db->queryRow("SELECT * FROM cms_info WHERE name = 'schema_version'")) { if ($q['value'] >= REQUIRED_SCHEMA_VERSION) { die('You have an up to date schema'); } } } //run schema patch $sql = "alter table `cms_cols` change column `edit_channel` `edit_channel` varchar(20) not null default '' after `default_value`;\nalter table `cms_cols` change column `edit_module` `edit_module` varchar(20) not null default '' after `edit_channel`;\nalter table `cms_cols` change column `edit_mode` `edit_mode` varchar(20) not null default '' after `edit_module`;\nalter table `cms_cols` change column `process_channel` `process_channel` varchar(20) not null default '' after `edit_config`;\nalter table `cms_cols` change column `process_mode` `process_mode` varchar(20) not null default '' after `process_module`;\nalter table `cms_headers` change column `mode` `mode` varchar(255) not null default '' after `table_name`;\nalter table `cms_relations` change column `display` `display` varchar(255) not null default '' after `column_child`;\nalter table `cms_tables` change column `display_mode` `display_mode` varchar(20) not null default '' after `sort_default`;\nCREATE TABLE `cms_info` (\n `name` varchar(40) NOT NULL default '',\n `value` varchar(255) NOT NULL default '',\n PRIMARY KEY (`name`)\n) ENGINE=MyISAM DEFAULT CHARSET=utf8;\ninsert into `cms_info` values('schema_version','1.0.14');"; $schema = explode(';', $sql); array_pop($schema); foreach ($schema as $row) { $db->sql($row); }
public function getData($table = '') { if ($table != '') { $this->table = $table; } //set necessary variables $table_parent = Utils::setVar("table_parent", ''); $id_parent = Utils::setVar("id_parent", ''); $this->sql = ''; //these should be mapped in from the controller - not set here $sort_dir = Utils::setVar("sort_dir", "DESC"); $offset = Utils::setVar("offset", "0"); $limit = Utils::setVar("limit", "100"); $search = Utils::setVar("search"); $mode = Utils::setVar("mode", "main"); //get table description data $this->tableMeta = AdaptorMysql::query("SHOW COLUMNS FROM {$this->table}", MYSQL_BOTH); $this->key = AdaptorMysql::getPrimaryKey($this->table); $sort_col = Utils::setVar("sort_col", $this->key); //check for config info here $q_col = false; //get configuration data for form $q_c = array(); //get all the base config $tA = Utils::checkArray(_ControllerFront::$config['tables'], array('table_name' => $this->table), true); if (is_array($tA)) { $q_c = $tA; } if ($q_sql = $this->db->query("SELECT * FROM " . BLACKBIRD_TABLE_PREFIX . "tables WHERE table_name = '{$this->table}' ORDER BY table_name,display_mode")) { $q_c = array_merge($q_c, $q_sql); } if (!$q_col) { if ($mode == 'main') { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'display_mode' => 'main')); if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'display_mode' => '')); } } if ($mode == 'related') { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'display_mode' => 'related')); if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'display_mode' => '')); } } } //column description information $fields = array(); if ($q_col['cols_default'] == "") { $select_cols = '*'; } else { $select_cols = $q_col['cols_default']; $fields = explode(",", $select_cols); } if ($select_cols == "*") { $fields = array(); for ($i = 0; $i < count($this->tableMeta); $i++) { $row = $this->tableMeta[$i]; $fields[] = $row[0]; } } //filters and WHERE $filterA = array(); $this->filtersA = array(); $whereA = array(); $where = 'WHERE '; $where .= $this->sql; $filterWhere = ''; if ($table == BLACKBIRD_TABLE_PREFIX . 'history') { $filterWhere = $this->sql; $label = '_History_'; } else { if ($table_parent != '') { $relation = AdaptorMysql::queryRow("SELECT * FROM " . BLACKBIRD_TABLE_PREFIX . "relations WHERE table_parent = '{$table_parent}' AND table_child = '{$table}'"); $q_parent = AdaptorMysql::queryRow("SELECT * FROM {$table_parent} WHERE id = {$id_parent}"); $sql_val = $q_parent[$relation['column_parent']]; $whereA[] = "{$relation['column_child']} = '{$sql_val}'"; $filterWhere = "{$relation['column_child']} = '{$sql_val}'"; //from build in a page if (isset($this->config['sql_where'])) { $whereA[] = $this->config['sql_where']; $filterWhere .= ' AND ' . $this->config['sql_where']; } //from build in remote if (isset($_REQUEST['sql_where'])) { $whereA[] = stripslashes($_REQUEST['sql_where']); $filterWhere .= ' AND ' . stripslashes($_REQUEST['sql_where']); } $label = $relation['label']; } else { $label = $table; } } if ($search != "") { $q = $this->db->query("SHOW COLUMNS FROM {$this->table}", MYSQL_BOTH); $search_fields = array(); for ($i = 0; $i < count($q); $i++) { $row = $q[$i]; $search_fields[] = $row[0]; } //Generate search $mySearch = "'%" . mysql_real_escape_string(stripslashes(trim($search))) . "%'"; $rSearch = AdaptorMysql::generateSearch($search_fields, $mySearch); } $q_filters = AdaptorMysql::query("SELECT column_name FROM " . BLACKBIRD_TABLE_PREFIX . "cols WHERE (table_name = '*' OR table_name = '{$table}') AND filter != ''"); if ($q_filters) { //loop through and find intersections foreach ($q_filters as $filter) { $col = $filter['column_name']; if (in_array($col, $fields)) { $filterA[] = $col; $_filter = array(); if (isset($_REQUEST['filter_' . $col])) { if ($_REQUEST['filter_' . $col] != '') { $t = $_REQUEST['filter_' . $col]; $whereA[] = "{$col} = '{$t}'"; //$this->filtersA[] = array('col'=>$col,'value'=>$t); $_filter['col'] = $col; $_filter['value'] = $t; } } //query up option data $filterWhere != '' ? $w = 'WHERE ' . $filterWhere : ($w = ''); $optionA = array(); $field = $col; if ($q_select = AdaptorMysql::query("SELECT DISTINCT `{$field}` FROM `{$table}` {$w} ORDER BY `{$field}`")) { foreach ($q_select as $row) { $sel = ''; if (isset($_REQUEST['filter_' . $field])) { if ($_REQUEST['filter_' . $field] == $row[$field]) { $sel = 'selected="selected"'; } } $tv = _ControllerFront::formatCol($field, $row[$field], $table); $q_c = AdaptorMysql::query("SELECT * FROM " . BLACKBIRD_TABLE_PREFIX . "cols WHERE column_name = '{$field}'"); if ($q_c) { $q_col = Utils::checkArray($q_c, array('table_name' => $table)); if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => '*')); } if ($q_col) { if ($q_col['filter'] != '') { $tA = _ControllerFront::parseConfig($q_col['filter']); if (isset($tA['filter_length'])) { if (strlen(strip_tags($tv)) > $tA['filter_length']) { $tv = substr(strip_tags($tv), 0, $tA['filter_length']) . '...'; } } } } } $optionA[] = array('value' => $row[$field], 'label' => $tv, 'selected' => $sel); } } //sort it $optionA = Utils::arraySort($optionA, 'label'); $_filter['options'] = $optionA; $this->filtersA[$field] = $_filter; } } } if (count($whereA) > 0) { if ($where != 'WHERE ') { $where .= ' AND '; } $where .= join($whereA, ' AND '); } else { if ($where == 'WHERE ') { $where = ''; } } if ($search == '') { $query_data = AdaptorMysql::query("SELECT {$select_cols} FROM `{$table}` {$where} ORDER BY `{$sort_col}` {$sort_dir} LIMIT {$limit} OFFSET {$offset}"); if ($query_data) { $rT = count($query_data); } else { $rT = 0; } $q2 = AdaptorMysql::query("SELECT * FROM {$table} {$where}"); if ($q2) { $rows_total = count($q2); } else { $rows_total = 0; } } else { if ($where == '') { $where = 'WHERE '; } if ($where != 'WHERE ' && $rSearch != '') { $where .= ' AND ('; $rSearch = $rSearch . ')'; } $query_data = AdaptorMysql::query("SELECT {$select_cols} FROM `{$table}` {$where} {$rSearch} ORDER BY `{$sort_col}` LIMIT {$limit} OFFSET {$offset}"); $rT = count($query_data); $q2 = AdaptorMysql::query("SELECT * FROM `{$table}` {$where} {$rSearch}"); if ($q2) { $rows_total = count($q2); } else { $rows_total = 0; } } $this->recordSet = array(); //build recordSet if ($query_data) { foreach ($query_data as $row) { $tA = array(); for ($j = 0; $j < count($fields); $j++) { $data = _ControllerFront::formatCol($fields[$j], $row[$fields[$j]], $table); $tA[$fields[$j]] = array('col' => $fields[$j], 'value' => $data); } //convert to the key $this->recordSet[$row[$this->key]] = _ControllerFront::injectData($tA, $table, 'body'); } } //headerData $tA = array(); for ($j = 0; $j < count($fields); $j++) { isset($row[$j]) ? $value = $row[$j] : ($value = ''); $data = _ControllerFront::formatCol($fields[$j], $value, $table); $tA[$fields[$j]] = array('col' => $fields[$j], 'value' => $data); } $this->headerData = _ControllerFront::injectData($tA, $table, 'head'); $delete_allowed = false; //if($this->cms->session->privs("delete",$table)){ // $delete_allowed = true; //} return array('headerData' => $this->headerData, 'rowData' => $this->recordSet, 'sort_col' => $sort_col, 'sort_dir' => $sort_dir, 'table' => $this->table, 'rows_total' => $rows_total, 'limit' => $limit, 'offset' => $offset, 'mode' => $mode, 'filtersA' => $this->filtersA, 'filterA' => $filterA, 'search' => $search); }
public static function setTimezone($timezone = null) { date_default_timezone_set($timezone = $timezone ? $timezone : self::getTimezone()); //die(timezone_offset_get()); $offset = substr(strftime('%z', time()), 0, 3) . ':' . substr(strftime('%z', time()), 3); //die(date_default_timezone_get() .' : ' . $offset); // Set timezone for database connection (if a connection exists) if (class_exists('AdaptorMysql')) { AdaptorMysql::sql("SET time_zone = '{$offset}'"); } }
public function getData($config = null) { //needs to function in both edit and insert modes, obviously $this->table = $config['table']; $this->id = $config['id']; $this->channel = $config['channel']; if ($config['query_action'] == 'insert') { $this->mode = 'add'; } else { $this->mode = 'edit'; } //get table description data $this->tableMeta = AdaptorMysql::query("SHOW COLUMNS FROM {$this->table}", MYSQL_BOTH); //get key //default, set as first column $this->key = $this->tableMeta[0]['Field']; //find real primary key foreach ($this->tableMeta as $column) { if ($column['Key'] == 'PRI') { $this->key = $column['Field']; } } $q = $this->db->queryRow("SELECT * FROM `" . $this->table . "` WHERE " . $this->key . " = '" . $this->id . "'"); $this->data = array(); $this->col_config = false; foreach ($this->tableMeta as $col) { //check for config info here $q_col = false; //get configuration data for form $q_c = array(); //get all the base config $tA = Utils::checkArray(_ControllerFront::$config['cols'], array('column_name' => $col['Field']), true); if (is_array($tA)) { $q_c = $tA; } //get anything from the blackbird_cols if ($q_sql = $this->db->query("SELECT * FROM " . BLACKBIRD_TABLE_PREFIX . "cols WHERE column_name = '{$col['Field']}' ORDER BY table_name,edit_mode,edit_channel")) { $q_c = array_merge($q_c, $q_sql); } if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'edit_mode' => $this->mode, 'edit_channel' => $this->channel)); if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'edit_mode' => $this->mode, 'edit_channel' => '')); } } if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'edit_mode' => '', 'edit_channel' => $this->channel)); if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => $this->table, 'edit_mode' => '', 'edit_channel' => '')); } } if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => '*', 'edit_mode' => $this->mode, 'edit_channel' => $this->channel)); if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => '*', 'edit_mode' => $this->mode, 'edit_channel' => '')); } } if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => '*', 'edit_mode' => '', 'edit_channel' => $this->channel)); if (!$q_col) { $q_col = Utils::checkArray($q_c, array('table_name' => '*', 'edit_mode' => '', 'edit_channel' => '')); } } $value = $q[$col['Field']]; $config = $q_col; //flow in the default value only if creating a new record if ($q_col && $this->mode == 'add') { if ($q_col['default_value'] != '') { $value = $q_col['default_value']; } } if ($this->mode == 'edit' && !_ControllerFront::$session->getPermissions('update', $this->table)) { //turn to readonly - check on foreign keys later if (is_array($config)) { $config['edit_module'] = 'readonly'; } else { $config = array('table_name' => $this->table, 'column_name' => $col['Field'], 'validate' => '', 'default_value' => '', 'edit_module' => 'readonly', 'edit_config' => '', 'display_name' => '', 'help' => ''); } } $this->data[$col['Field']] = array('name' => $col['Field'], 'value' => $value, 'type' => $col['Type'], 'config' => $config); } return $this->data; }
private function setConfig() { self::$config = array(); $tA = array(); $tA[] = array('table_name' => '*', 'column_name' => 'id', 'edit_module' => 'readonly', 'edit_mode' => 'edit'); $tA[] = array('table_name' => '*', 'column_name' => 'active', 'edit_module' => 'boolean', 'filter' => '<config><filter>1</filter></config>'); $tA[] = array('table_name' => '*', 'column_name' => 'created', 'edit_module' => 'readonly', 'edit_mode' => 'edit', 'process_module' => 'timestamp'); $tA[] = array('table_name' => '*', 'column_name' => 'modified', 'edit_module' => 'readonly', 'edit_mode' => 'edit', 'process_module' => 'timestamp'); $tA[] = array('table_name' => '*', 'column_name' => 'date', 'edit_module' => 'selectDate'); $tA[] = array('table_name' => '*', 'column_name' => 'state', 'edit_module' => 'selectState'); $tA[] = array('table_name' => '*', 'column_name' => 'country', 'edit_module' => 'selectCountry'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'groups', 'column_name' => 'admin', 'edit_module' => 'boolean', 'filter' => '<config><filter>1</filter></config>', 'help' => 'Admin users are able to manage users and groups. Limited access to Blackbird configuration is also available.'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'groups', 'column_name' => 'tables', 'edit_module' => 'plugin', 'process_module' => 'plugin'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'users', 'column_name' => 'password', 'display_name' => 'Password Reset', 'edit_module' => 'plugin', 'edit_mode' => 'edit', 'process_module' => 'plugin', 'process_mode' => 'update'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'users', 'column_name' => 'password', 'edit_module' => 'plugin', 'edit_mode' => 'add', 'process_module' => 'plugin', 'process_mode' => 'insert'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'users', 'column_name' => 'groups', 'edit_module' => 'plugin', 'process_module' => 'plugin'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'users', 'column_name' => 'super_user', 'edit_module' => 'hidden'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'history', 'column_name' => 'table_name', 'filter' => '<config><filter>1</filter></config>'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'history', 'column_name' => 'action', 'filter' => '<config><filter>1</filter></config>'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'history', 'column_name' => 'user_id', 'filter' => '<config><filter>1</filter></config>'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'cols', 'column_name' => 'edit_channel', 'edit_module' => 'selectStatic', 'edit_config' => ' <config><data_csv>main,related</data_csv></config>'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'cols', 'column_name' => 'edit_mode', 'edit_module' => 'selectStatic', 'edit_config' => ' <config><data_csv>edit,insert</data_csv></config>'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'cols', 'column_name' => 'process_channel', 'edit_module' => 'selectStatic', 'edit_config' => ' <config><data_csv>main,related</data_csv></config>'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'cols', 'column_name' => 'process_mode', 'edit_module' => 'selectStatic', 'edit_config' => ' <config><data_csv>update,insert</data_csv></config>'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'cols', 'column_name' => 'edit_module', 'edit_module' => 'selectStatic', 'edit_config' => ' <config><data_csv>plugin,boolean,hidden,readonly,checkbox,fileField,selectDefault,selectParent,selectFiles,selectStatic,selectDate,selectDateTime,selectState,selectCountry,text,textarea,listManager</data_csv></config>'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'cols', 'column_name' => 'process_module', 'edit_module' => 'selectStatic', 'edit_config' => ' <config><data_csv>plugin,position,file</data_csv></config>'); /* $tA[] = array('table_name'=>BLACKBIRD_TABLE_PREFIX . 'cols','column_name'=>'table_name','edit_module'=>'selectDefault','edit_config'=>' <config><select_sql>SHOW TABLES</select_sql><col_value>0</col_value><col_display>0</col_display><allow_null>false</allow_null></config>'); */ $q = AdaptorMysql::query("SHOW COLUMNS FROM `" . BLACKBIRD_TABLE_PREFIX . "cols`"); self::$config['cols'] = self::normalizeArray($tA, $q); $tA = array(); //need to add active to user $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'users', 'cols_default' => 'id,firstname,lastname,email,groups', 'in_nav' => 1); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'groups', 'cols_default' => 'id,active,name,admin', 'in_nav' => 1); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'history', 'cols_default' => '*', 'in_nav' => 1); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'cols', 'cols_default' => 'id,table_name,column_name,edit_module,edit_mode,process_module,process_mode,validate,filter,help'); $tA[] = array('table_name' => BLACKBIRD_TABLE_PREFIX . 'tags', 'cols_default' => 'id,name', 'in_nav' => 1); $q = AdaptorMysql::query("SHOW COLUMNS FROM `" . BLACKBIRD_TABLE_PREFIX . "tables`"); self::$config['tables'] = self::normalizeArray($tA, $q); }
require_once LIB . 'Bobolink' . DS . 'database' . DS . 'AdaptorMysql.class.php'; // Bobolink classes (load any you want to use) //require_once LIB . 'Bobolink' . DS . 'email' . DS . 'EmailProtector.class.php'; //require_once LIB . 'Bobolink' . DS . 'forms' . DS . 'Forms.class.php'; //require_once LIB . 'Bobolink' . DS . 'session' . DS . 'Session.class.php'; //require_once LIB . 'Bobolink' . DS . 'utils' . DS . 'Utils.class.php'; //require_once LIB . 'Bobolink' . DS . 'xml' . DS . 'FlashMW.class.php'; //require_once LIB . 'Bobolink' . DS . 'xml' . DS . 'XmlToArray.class.php'; /* LOAD PLUGINS ---------------------------------------------------------- */ require_once APP . 'plugins' . DS . 'pre_render.php'; require_once APP . 'plugins' . DS . 'post_render.php'; //require_once LIB . 'Brickhouse' . DS . 'plugins' . DS . 'sitemap.php'; /* CONTROLLER/ROUTER ----------------------------------------------------- */ //error handling //$error = ErrorHandler::getInstance(); set_error_handler(array("ErrorHandler", "capture")); // Only connect to the database if it is configured if (isset($GLOBALS['DATABASE'])) { $db = AdaptorMysql::getInstance(); } // Controller $controller = _ControllerFront::getInstance(); // Router //needs to follow the Front Controller so we can utilize the pre-parsed URI $uA = $controller->getUri(); $uri = $uA['array']; $routes = array(); //pull in predefined routes require_once CONFIG . 'routes.php'; /* DISPATCH -------------------------------------------------------------- */ $controller->dispatch($routes);
private function _buildForm() { //the master loopage //do a few things different if we're editing vs inserting a new record.. however not much //use output buffering to feed this to the view... this is a unique controller driven situation //since it's almost entirely logic based and presentation uses markup snippets from the Forms library ob_start(); $_name_space = $this->name_space . '_'; //processing instructions Forms::hidden('name_space', $this->name_space, array('omit_id' => true)); Forms::hidden('mode', $this->mode, array('omit_id' => true)); Forms::hidden('channel', $this->channel, array('omit_id' => true)); Forms::hidden('table', $this->table, array('omit_id' => true)); Forms::hidden('query_action', $this->query_action, array('omit_id' => true)); $recordData = $this->model->data; $row_data = $recordData; //Relation fields if ($this->channel == "related") { $sql = "SELECT * FROM " . BLACKBIRD_TABLE_PREFIX . "relations WHERE table_parent = '" . $_POST['table_parent'] . "' AND table_child = '{$this->table}'"; if ($q_relation = AdaptorMysql::queryRow($sql)) { $i = 0; foreach ($recordData as $column) { if ($column['name'] == $q_relation['column_child']) { array_splice($recordData, $i, 1); break; } $i++; } $q_parent = AdaptorMysql::queryRow("SELECT * FROM " . $_POST['table_parent'] . " WHERE id = " . $_POST['id_parent']); Forms::hidden($_name_space . $q_relation['column_child'], $q_parent[$q_relation['column_parent']]); Forms::hidden('table_parent', $_POST['table_parent'], array('omit_id' => true)); Forms::hidden('id_parent', $q_parent[$q_relation['column_parent']], array('omit_id' => true)); } } //loop items foreach ($recordData as $column) { $options = array(); $col_type = strtolower($column['type']); $value = $column['value']; $col_ready = false; $display_name = Utils::titleCase(str_replace('_', ' ', $column['name'])); $options['label'] = $display_name; $options['name_space'] = $_name_space; $options['db'] = AdaptorMysql::getInstance(); $options['nullable'] = AdaptorMysql::isNullable($this->table, $column['name']); //For primary key that's autoincrementing if ($column['name'] == 'id') { if ($this->query_action == "update") { Forms::hidden($_name_space . $column['name'], $value, $options); } $col_ready = true; } //plugins //col_config needs to be created for each column in the model = FAIL if ($column['config'] && !$col_ready) { $q_col = $column['config']; if ($q_col['default_value'] != '' && $this->mode == "insert") { $value = $q_col['default_value']; } if (strlen($q_col['help']) > 1) { $options['tip'] = $q_col['help']; } if ($q_col['display_name'] != '') { $display_name = $q_col['display_name']; } $options['label'] = $display_name; $module = $q_col['edit_module']; if (strlen($q_col['edit_config']) > 1) { $config = _ControllerFront::parseConfig($q_col['edit_config']); $options = array_merge($options, $config); } if ($q_col['validate'] != '') { $options = array_merge($options, _ControllerFront::parseConfig($q_col['validate'])); } if ($module != "") { switch ($module) { case "module": break; case "plugin": $options['table'] = $this->table; $options['mode'] = $this->mode; $options['row_data'] = $row_data; $options['id'] = $this->id; $options['col_name'] = $column['name']; _ControllerFront::pluginColumnEdit($_name_space . $column['name'], $value, $options); $col_ready = true; break; case "position": //build a selectDefault but with special options ehh $options['col_display'] = $column['name']; $options['col_value'] = $column['name']; //do it manual style, to accomodate constraint change or late entries //do a relative selection of position, based upon existing list.. oh! //factor in the contraint if set //factor in null if (isset($config['col_constraint'])) { //check if we're nullable if (AdaptorMysql::isNullable($this->table, $config['col_constraint']) && Utils::isNull($row_data[$config['col_constraint']]['value'])) { $_v = "IS NULL"; } else { $_v = ' = \'' . $row_data[$config['col_constraint']]['value'] . '\''; } $options['select_sql'] = "SELECT * FROM `{$this->table}` WHERE `{$config['col_constraint']}` " . $_v . " ORDER BY `{$column['name']}`"; } else { $options['select_sql'] = "SELECT * FROM `{$this->table}` ORDER BY `{$column['name']}`"; } $options['table'] = $this->table; $options['col_name'] = $column['name']; $options['id'] = $this->id; $options['name_space'] = $_name_space; $options['label'] = $display_name; $options['allow_null'] = false; Forms::selectDefault($_name_space . $column['name'], $value, $options); $col_ready = true; break; case "slug": $source = isset($config['col_source']) ? $_name_space . $config['col_source'] : null; Forms::text($_name_space . $column['name'], $value, $options); print ' <script type="text/javascript"> Event.observe(window,\'load\', function(){createSlug(\'' . $_name_space . $column['name'] . '\',\'' . $source . '\')}, true); </script> '; $col_ready = true; break; case "disabled": $col_ready = true; break; default: $options['table'] = $this->table; $options['col_name'] = $column['name']; $options['id'] = $this->id; $options['name_space'] = $_name_space; $options['label'] = $display_name; //add database datasource for countries and states if ($module == 'selectState') { $options['datasource'] = BLACKBIRD_TABLE_PREFIX . 'states'; } if ($module == 'selectCountry') { $options['datasource'] = BLACKBIRD_TABLE_PREFIX . 'countries'; } Forms::$module($_name_space . $column['name'], $value, $options); $col_ready = true; break; } } } //defaults if (!$col_ready) { switch (true) { case $col_type == 'datetime' || $col_type == 'timestamp': Forms::selectDateTime($_name_space . $column['name'], $value, $options); break; case $col_type == 'date': Forms::selectDate($_name_space . $column['name'], $value, $options); break; case $col_type == 'time': Forms::selectTime($_name_space . $column['name'], $value, $options); break; case $col_type == 'text' || $col_type == 'longtext' || $col_type == 'tinytext' || $col_type == 'mediumtext': Forms::textarea($_name_space . $column['name'], $value, $options); break; default: Forms::text($_name_space . $column['name'], $value, $options); break; } } } $r = ob_get_contents(); ob_end_clean(); return $r; }
public function __construct() { $this->db = AdaptorMysql::getInstance(); }