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' => '')); } }