/** * install sample query */ public function installSampleQuery($theme, $module) { if (is_file(dirname(__FILE__) . '/' . $theme . '/sample.php')) { require dirname(__FILE__) . '/' . $theme . '/sample.php'; $dir = dirname(__FILE__) . '/' . $theme . '/'; $this->load->model('setting/extension'); /* execute SQL queries */ $query = ModuleSample::getModulesQuery(); $modules = array(); if (isset($query[$module])) { foreach ($query[$module] as $query) { $this->db->query($query); } } $this->load->model('localisation/language'); $languages = $this->model_localisation_language->getLanguages(); if (method_exists("ModuleSample", "getTables")) { $tables = ModuleSample::getTables(); if (is_file(dirname(__FILE__) . '/' . $theme . '/query-data.php')) { $query = array(); require dirname(__FILE__) . '/' . $theme . '/query-data.php'; if (isset($tables[$module]) && !empty($query)) { foreach ($tables[$module] as $table => $info) { if (isset($query[$table])) { $sql = ' SELECT * FROM ' . DB_PREFIX . $table . ''; $sq = $this->db->query($sql); if (count($sq->rows) <= 0) { if (isset($info['lang']) && (int) $info['lang']) { foreach ($languages as $language) { foreach ($query[$table] as $s) { $this->db->query(str_replace('LANGUAGEID', $language['language_id'], $s)); } } } else { foreach ($query[$table] as $s) { $this->db->query($s); } } } } } } } } return 'done'; } return 'could not install data sample for this'; }