function insertInDb($is_update = false)
{
$database = JFactory::getDBO();
if (!$is_update) {
$queries = array("INSERT INTO `#__modules` SET title='DOCman - Latest docs', ordering=2, position='dmcpanel', published=1, module='mod_docman_latest', access=2, showtitle=1, iscore=2, client_id=1;", "INSERT INTO `#__modules` SET title='DOCman - Top docs', ordering=3, position='dmcpanel', published=1, module='mod_docman_top', access=2, showtitle=1, iscore=2, client_id=1;", "INSERT INTO `#__modules` SET title='DOCman - Latest logs', ordering=4, position='dmcpanel', published=1, module='mod_docman_logs', access=2, showtitle=1, iscore=2, client_id=1;", "INSERT INTO `#__modules` SET title='DOCman - News', ordering=0, position='dmcpanel', published=1, module='mod_docman_news', access=2, showtitle=1, iscore=2, client_id=1;", "INSERT INTO `#__modules` SET title='DOCman - Unapproved', ordering=1, position='dmcpanel', published=1, module='mod_docman_approval', access=2, showtitle=1, iscore=2, client_id=1;");
foreach ($queries as $query) {
$database->setQuery($query);
$database->query();
}
}
// Plugins
$query = "SELECT id FROM #__plugins WHERE element = 'standardbuttons' AND folder='docman'";
$database->setQuery($query);
if (!$database->loadResult()) {
$query = "INSERT INTO `#__plugins` (`name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`)" . "\n VALUES ('DOCman - Standard Buttons', 'standardbuttons', 'docman', '0', '1', '1', '1', '0', '0', '0000-00-00 00:00:00', " . " 'download=1\nview=1\ndetails=1\nedit=1\nmove=1\ndelete=1\nupdate=1\nreset=1\ncheckout=1\napprove=1\npublish=1')";
$database->setQuery($query);
$database->query();
}
$query = "SELECT id FROM #__plugins WHERE element = 'docman.searchbot' AND folder='search'";
$database->setQuery($query);
if (!$database->loadResult()) {
$query = "INSERT INTO `#__plugins` (`name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`)" . "\n VALUES('Search - DOCman', 'docman.searchbot', 'search', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', 'prefix=Download: \nhref=download\nsearch_name=1\nsearch_description=1\n')";
$database->setQuery($query);
$database->query();
}
$query = "SELECT id FROM #__plugins WHERE element = 'doclink' AND folder='editors-xtd'";
$database->setQuery($query);
if (!$database->loadResult()) {
$query = "INSERT INTO `#__plugins` (`name`, `element`, `folder`, `access`, `ordering`, `published`, `iscore`, `client_id`, `checked_out`, `checked_out_time`, `params`)" . "\n VALUES('DOCman - DOCLink', 'doclink', 'editors-xtd', 0, 0, 1, 0, 0, 0, '0000-00-00 00:00:00', '')";
$database->setQuery($query);
$database->query();
}
// Admin modules
$query = "SELECT id FROM #__modules WHERE module = 'mod_docman_latest'";
$database->setQuery($query);
if (!$database->loadResult()) {
DMInstallHelper::_insertModule(array('title' => 'DOCman - Latest docs', 'position' => 'dmcpanel', 'module' => 'mod_docman_latest', 'showtitle' => 1, 'params' => '', 'ordering' => 0, 'published' => 1, 'client_id' => 1));
}
$query = "SELECT id FROM #__modules WHERE module = 'mod_docman_top'";
$database->setQuery($query);
if (!$database->loadResult()) {
DMInstallHelper::_insertModule(array('title' => 'DOCman - Top docs', 'position' => 'dmcpanel', 'module' => 'mod_docman_top', 'showtitle' => 1, 'params' => '', 'ordering' => 1, 'published' => 1, 'client_id' => 1));
}
$query = "SELECT id FROM #__modules WHERE module = 'mod_docman_logs'";
$database->setQuery($query);
if (!$database->loadResult()) {
DMInstallHelper::_insertModule(array('title' => 'DOCman - Latest logs', 'position' => 'dmcpanel', 'module' => 'mod_docman_logs', 'showtitle' => 1, 'params' => '', 'ordering' => 2, 'published' => 1, 'client_id' => 1));
}
$query = "SELECT id FROM #__modules WHERE module = 'mod_docman_approval'";
$database->setQuery($query);
if (!$database->loadResult()) {
DMInstallHelper::_insertModule(array('title' => 'Top docs', 'position' => 'dmcpanel', 'module' => 'mod_docman_top', 'showtitle' => 1, 'params' => '', 'ordering' => 3, 'published' => 1, 'client_id' => 1));
}
$query = "SELECT id FROM #__modules WHERE module = 'mod_docman_news'";
$database->setQuery($query);
if (!$database->loadResult()) {
DMInstallHelper::_insertModule(array('title' => 'DOCman - Top docs', 'position' => 'dmcpanel', 'module' => 'mod_docman_top', 'showtitle' => 1, 'params' => '', 'ordering' => 4, 'published' => 1, 'client_id' => 1));
}
// Frontend modules
$query = "SELECT id FROM #__modules WHERE module = 'mod_docman_catdown'";
$database->setQuery($query);
if (!$database->loadResult()) {
DMInstallHelper::_insertModule(array('title' => 'DOCman - Category', 'position' => 'left', 'module' => 'mod_docman_catdown', 'showtitle' => 1, 'params' => ''));
}
$query = "SELECT id FROM #__modules WHERE module = 'mod_docman_latestdown'";
$database->setQuery($query);
if (!$database->loadResult()) {
DMInstallHelper::_insertModule(array('title' => 'DOCman - Latest Downloads', 'position' => 'left', 'module' => 'mod_docman_latestdown', 'showtitle' => 1, 'params' => ''));
}
$query = "SELECT id FROM #__modules WHERE module = 'mod_docman_lister'";
$database->setQuery($query);
if (!$database->loadResult()) {
DMInstallHelper::_insertModule(array('title' => 'DOCman - Lister', 'position' => 'left', 'module' => 'mod_docman_lister', 'showtitle' => 1, 'params' => ''));
}
$query = "SELECT id FROM #__modules WHERE module = 'mod_docman_mostdown'";
$database->setQuery($query);
if (!$database->loadResult()) {
DMInstallHelper::_insertModule(array('title' => 'DOCman - Most Downloaded', 'position' => 'left', 'module' => 'mod_docman_mostdown', 'showtitle' => 1, 'params' => ''));
}
}
