function install() { global $application; loadCoreFile('csv_parser.php'); $csv_parser = new CSV_Parser(); $tables = Banner::getTables(); $query = new DB_Table_Create($tables); $table_banners_settings = 'banners_settings'; $columns = $tables[$table_banners_settings]['columns']; list($flt, $Default_Settings) = $csv_parser->parse_file(dirname(__FILE__) . "/includes/default_settings.csv"); foreach ($Default_Settings as $key => $setting) { $query = new DB_Insert($table_banners_settings); $query->addInsertValue($setting["key"], $columns['setting_key']); $query->addInsertValue($setting["value"], $columns['setting_value']); $application->db->getDB_Result($query); } }
function initQuery($params) { $tables = Banner::getTables(); $tr = $tables['banners_images']['columns']; $this->addInsertValue($params[0]['bannerid'], $tr['bannerid']); $this->addInsertValue($params[0]['image_path'], $tr['image_path']); $this->addInsertValue($params[0]['image_type'], $tr['image_type']); $this->addInsertValue($params[0]['image_x'], $tr['image_x']); $this->addInsertValue($params[0]['image_y'], $tr['image_y']); $this->addInsertValue($params[0]['image_size'], $tr['image_size']); $this->addInsertValue($params[0]['filename'], $tr['filename']); $this->addInsertValue($params[0]['date'], $tr['date']); $this->addInsertValue($params[0]['alt'], $tr['alt']); $this->addInsertValue($params[0]['url'], $tr['url']); $this->addInsertValue($params[0]['type'], $tr['type']); }