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