/**
* 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';
}
