public static function Install_Db()
{
//Check data exists
$db = JFactory::getDBO();
if (JAVoiceHelpers::table_exists('#__jav_configs')) {
$path = JPATH_ADMINISTRATOR . '/components/com_javoice/installer/sql/install.javoice.sql';
$error = null;
if (file_exists($path)) {
JAVoiceHelpers::populateDB($path, $db, $error);
if ($error) {
$error = implode("<br/>", $error);
return JError::raiseError(1, $error);
}
} else {
JError::raiseWarning(1, JText::_('SQL_FILE_NOT_FOUND_ERROR') . '<br /><br />');
}
}
$q = "SELECT data FROM #__jav_configs";
$db->setQuery($q);
$data = $db->loadResult();
if (!$data) {
//Install sample data
$path_sample = JPATH_ADMINISTRATOR . '/components/com_javoice/installer/sql/install.configData.sql';
$error = null;
if (file_exists($path_sample)) {
JAVoiceHelpers::populateDB($path_sample, $db, $error);
if ($error) {
$error = implode("<br/>", $error);
return JError::raiseError(1, $error);
}
} else {
JError::raiseWarning(1, JText::_('SQL_FILE_NOT_FOUND_ERROR') . '<br /><br />');
}
}
/*
$lis_sql_path = JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_javoice' . DS . 'installer' . DS . 'sql';
$regex = '/upgrade_(.*?)(\.sql)$/i';
$dk = opendir($lis_sql_path);
while (false !== ($filename = readdir($dk))) {
if (preg_match($regex, $filename)) {
if (JAVoiceHelpers::table_exists('#__jav_email_templates') && $filename == 'upgrade_v1.0.0.sql') {
JAVoiceHelpers::populateDB(JPATH_ADMINISTRATOR . DS . 'components' . DS . 'com_javoice' . DS . 'installer' . DS . 'sql' . DS . $filename, $db, $error);
}
}
}
*/
}
