public function checkInstall(){
$sql = " SHOW TABLES LIKE '".DB_PREFIX."blog_blog'";
$query = $this->db->query( $sql );
if( count($query->rows) <=0 ){
$file = (DIR_APPLICATION).'model/sample/module.php';
if( file_exists($file) ){
require_once( $file );
$sample = new ModelSampleModule( $this->registry );
$result = $sample->installSampleQuery( $this->config->get('config_template'),'blog', true );
$result = $sample->installSample( $this->config->get('config_template'),'blogcategory', true );
$result = $sample->installSample( $this->config->get('config_template'),'blogcomment', true );
$result = $sample->installSample( $this->config->get('config_template'),'bloglatest', true );
}
}
$sql = " SHOW TABLES LIKE '".DB_PREFIX."blog_blog'";
$query = $this->db->query( $sql );
if( count($query->rows) <=0 ){
$this->createTables();
$this->createDataSample();
$this->createDefaultConfig();
}
$sql = " SELECT * FROM ".DB_PREFIX."extension WHERE `code` IN('blogcategory','blogcomment','bloglatest')";
$query = $this->db->query( $sql );
if($query->num_rows <= 0){
$this->installModules();
}
}
/**
* check installed
*/
public function isInstalled()
{
$sql = " SHOW TABLES LIKE '" . DB_PREFIX . "pavnewsletter_email'";
$query = $this->db->query($sql);
if (count($query->rows) <= 0) {
$file = dirname(DIR_APPLICATION) . '/admin/model/sample/module.php';
if (file_exists($file)) {
require_once $file;
$sample = new ModelSampleModule($this->registry);
$result = $sample->installSampleQuery($this->config->get('config_template'), 'pavnewsletter', true);
}
return false;
}
return true;
}
public function checkInstall()
{
$sql = " SHOW TABLES LIKE '" . DB_PREFIX . "pavoslidergroups'";
$query = $this->db->query($sql);
if (count($query->rows) <= 0) {
$file = DIR_APPLICATION . 'model/sample/module.php';
if (file_exists($file)) {
require_once $file;
$sample = new ModelSampleModule($this->registry);
$result = $sample->installSampleQuery($this->config->get('config_template'), 'pavsliderlayer', true);
$result = $sample->installSample($this->config->get('config_template'), 'pavsliderlayer', true);
}
}
$query = $this->db->query($sql);
if (count($query->rows) <= 0) {
$this->createTables();
$this->createDataSample();
$this->createDefaultConfig();
}
}
/**
* Automatic checking installation to whethere creating tables and data sample, configuration of modules.
*/
public function install()
{
$sql = " SHOW TABLES LIKE '" . DB_PREFIX . "verticalmenu'";
$query = $this->db->query($sql);
if (count($query->rows) <= 0) {
$file = DIR_APPLICATION . 'model/sample/module.php';
if (file_exists($file)) {
require_once $file;
$sample = new ModelSampleModule($this->registry);
$result = $sample->installSampleQuery($this->config->get('config_template'), 'pavverticalmenu', true);
$result = $sample->installSample($this->config->get('config_template'), 'pavverticalmenu', true);
}
} else {
$sql = " SHOW TABLES LIKE '" . DB_PREFIX . "verticalmenu_widgets'";
$query = $this->db->query($sql);
$sql = array();
if (count($query->rows) <= 0) {
$sql[] = "\t\r\n\t\t\t\tCREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "verticalmenu_widgets` (\r\n\t\t\t\t `id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t `name` varchar(250) NOT NULL,\r\n\t\t\t\t `type` varchar(255) NOT NULL,\r\n\t\t\t\t `params` text NOT NULL,\r\n\t\t\t\t `store_id` int(11) NOT NULL,\r\n\t\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 ; ";
$sql[] = "INSERT INTO `" . DB_PREFIX . "verticalmenu_widgets` VALUES (1, 'Video Opencart Installation', 'video_code', 'a:1:{s:10:\"video_code\";s:168:\"<iframe width="300" height="315" src="//www.youtube.com/embed/cUhPA5qIxDQ" frameborder="0" allowfullscreen></iframe>\";}', 0);";
$sql[] = "INSERT INTO `" . DB_PREFIX . "verticalmenu_widgets` VALUES (2, 'Dermo HTML Sample', 'html', 'a:1:{s:4:\"html\";a:1:{i:1;s:275:\"Dorem ipsum dolor sit amet consectetur adipiscing elit congue sit amet erat roin tincidunt vehicula lorem in adipiscing urna iaculis vel. Dorem ipsum dolor sit amet consectetur adipiscing elit congue sit amet erat roin tincidunt vehicula lorem in adipiscing urna iaculis vel.\";}}', 0);";
$sql[] = "INSERT INTO `" . DB_PREFIX . "verticalmenu_widgets` VALUES (3, 'Products Latest', 'product_list', 'a:4:{s:9:\"list_type\";s:6:\"newest\";s:5:\"limit\";s:1:\"6\";s:11:\"image_width\";s:3:\"120\";s:12:\"image_height\";s:3:\"120\";}', 0);";
$sql[] = "INSERT INTO `" . DB_PREFIX . "verticalmenu_widgets` VALUES (4, 'Products In Cat 20', 'product_category', 'a:4:{s:11:\"category_id\";s:2:\"20\";s:5:\"limit\";s:1:\"6\";s:11:\"image_width\";s:3:\"120\";s:12:\"image_height\";s:3:\"120\";}', 0);";
$sql[] = "INSERT INTO `" . DB_PREFIX . "verticalmenu_widgets` VALUES (5, 'Manufactures', 'banner', 'a:4:{s:8:\"group_id\";s:1:\"8\";s:11:\"image_width\";s:2:\"80\";s:12:\"image_height\";s:2:\"80\";s:5:\"limit\";s:2:\"12\";}', 0);";
$sql[] = "INSERT INTO `" . DB_PREFIX . "verticalmenu_widgets` VALUES (6, 'PavoThemes Feed', 'feed', 'a:1:{s:8:\"feed_url\";s:55:\"http://www.pavothemes.com/opencart-themes.feed?type=rss\";}', 0);";
foreach ($sql as $q) {
$query = $this->db->query($q);
}
}
$sql = " SHOW TABLES LIKE '" . DB_PREFIX . "verticalmenu'";
$query = $this->db->query($sql);
if (count($query->rows) <= 0) {
$sql = array();
$sql[] = "\t\r\n\t\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "verticalmenu` (\r\n\t\t\t\t\t\t\t\t `verticalmenu_id` int(11) unsigned NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t `image` varchar(255) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t `parent_id` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t `is_group` smallint(6) NOT NULL DEFAULT '2',\r\n\t\t\t\t\t\t\t\t `width` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t `submenu_width` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t `colum_width` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t `submenu_colum_width` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t `item` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t `colums` varchar(255) DEFAULT '1',\r\n\t\t\t\t\t\t\t\t `type` varchar(255) NOT NULL,\r\n\t\t\t\t\t\t\t\t `is_content` smallint(6) NOT NULL DEFAULT '2',\r\n\t\t\t\t\t\t\t\t `show_title` smallint(6) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t `type_submenu` varchar(10) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t `level_depth` smallint(6) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t `published` smallint(6) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t `store_id` smallint(5) unsigned NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t `position` int(11) unsigned NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t `show_sub` smallint(6) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t `url` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t `target` varchar(25) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t `privacy` smallint(5) unsigned NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t `position_type` varchar(25) DEFAULT 'top',\r\n\t\t\t\t\t\t\t\t `menu_class` varchar(25) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t `description` text,\r\n\t\t\t\t\t\t\t\t `content_text` text,\r\n\t\t\t\t\t\t\t\t `submenu_content` text,\r\n\t\t\t\t\t\t\t\t `level` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t `left` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t `right` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t `widget_id` int(11) DEFAULT '0', \r\n\t\t\t\t\t\t\t\t PRIMARY KEY (`verticalmenu_id`)\r\n\t\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=41 ;\r\n\t\t\t\t\t\t\t";
$sql[] = "\t\r\n\t\t\t\t\t\t\t\t\t\tCREATE TABLE IF NOT EXISTS `" . DB_PREFIX . "verticalmenu_description` (\r\n\t\t\t\t\t\t\t\t\t\t `verticalmenu_id` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `language_id` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `title` varchar(255) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t `description` text NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`verticalmenu_id`,`language_id`),\r\n\t\t\t\t\t\t\t\t\t\t KEY `name` (`title`)\r\n\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8;\t\t\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\r\n\t\t\t\t\t\t\t";
$sql[] = " \r\n\t\t\t\t\t\t\t\r\n\t\t\t\tINSERT INTO `" . DB_PREFIX . "verticalmenu` (`verticalmenu_id`, `image`, `parent_id`, `is_group`, `width`, `submenu_width`, `colum_width`, `submenu_colum_width`, `item`, `colums`, `type`, `is_content`, `show_title`, `type_submenu`, `level_depth`, `published`, `store_id`, `position`, `show_sub`, `url`, `target`, `privacy`, `position_type`, `menu_class`, `description`, `content_text`, `submenu_content`, `level`, `left`, `right`) VALUES\r\n\t\t\t\t(1, '', 0, 2, NULL, NULL, NULL, NULL, NULL, '1', '', 2, 1, '1', 0, 1, 0, 0, 0, NULL, NULL, 0, 'top', NULL, NULL, NULL, NULL, -5, 34, 47),\r\n\t\t\t\t(2, '', 1, 0, NULL, NULL, NULL, 'col1=3, col2=3, col3=6', '20', '3', 'category', 0, 1, 'menu', 0, 1, 0, 2, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(3, '', 1, 0, NULL, NULL, NULL, '', '18', '1', 'category', 0, 1, 'menu', 0, 1, 0, 5, 0, '', NULL, 0, 'top', 'pav-parrent', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(4, '', 3, 0, NULL, NULL, NULL, '', '25', '1', 'category', 0, 1, 'menu', 0, 1, 0, 1, 0, '', NULL, 0, 'top', 'pav-parrent', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(5, '', 1, 0, NULL, NULL, NULL, '', '17', '1', 'category', 0, 1, 'menu', 0, 1, 0, 3, 0, '', NULL, 0, 'top', 'pav-parrent', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(7, '', 1, 0, NULL, NULL, NULL, '', '33', '1', 'category', 0, 1, 'menu', 0, 1, 0, 4, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(8, '', 2, 1, NULL, NULL, NULL, '', '27', '1', 'category', 0, 1, 'menu', 0, 1, 0, 1, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '<p>test</p>\r\n', 0, 0, 0),\r\n\t\t\t\t(9, '', 2, 1, NULL, NULL, NULL, '', '26', '1', 'category', 0, 1, 'menu', 0, 1, 0, 2, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(10, '', 8, 0, NULL, NULL, NULL, '', '59', '1', 'category', 0, 1, 'menu', 0, 1, 0, 1, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(11, '', 8, 0, NULL, NULL, NULL, '', '60', '1', 'category', 0, 1, 'menu', 0, 1, 0, 2, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(12, '', 8, 0, NULL, NULL, NULL, '', '61', '1', 'category', 0, 1, 'menu', 0, 1, 0, 3, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(13, '', 8, 0, NULL, NULL, NULL, '', '62', '1', 'category', 0, 1, 'menu', 0, 1, 0, 4, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(14, '', 8, 0, NULL, NULL, NULL, '', '63', '1', 'category', 0, 1, 'menu', 0, 1, 0, 5, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(15, '', 8, 0, NULL, NULL, NULL, '', '64', '1', 'category', 0, 1, 'menu', 0, 1, 0, 6, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(16, '', 8, 0, NULL, NULL, NULL, '', '65', '1', 'category', 0, 1, 'menu', 0, 1, 0, 7, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(17, '', 9, 0, NULL, NULL, NULL, '', '66', '1', 'category', 0, 1, 'menu', 0, 1, 0, 1, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(18, '', 9, 0, NULL, NULL, NULL, '', '67', '1', 'category', 0, 1, 'menu', 0, 1, 0, 2, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(19, '', 9, 0, NULL, NULL, NULL, '', '68', '1', 'category', 0, 1, 'menu', 0, 1, 0, 3, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(20, '', 9, 0, NULL, NULL, NULL, '', '71', '1', 'category', 0, 1, 'menu', 0, 1, 0, 4, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(21, '', 9, 0, NULL, NULL, NULL, '', '72', '1', 'category', 0, 1, 'menu', 0, 1, 0, 5, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(22, '', 9, 0, NULL, NULL, NULL, '', '69', '1', 'category', 0, 1, 'menu', 0, 1, 0, 6, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(23, '', 9, 0, NULL, NULL, NULL, '', '70', '1', 'category', 0, 1, 'menu', 0, 1, 0, 7, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(24, '', 2, 0, NULL, NULL, NULL, '', '', '1', 'html', 1, 1, 'menu', 0, 1, 0, 3, 0, '', NULL, 0, 'top', 'pav-menu-child', NULL, '<div class="pav-menu-video"><iframe allowfullscreen="" frameborder="0" height="157" src="http://www.youtube.com/embed/NBuLeA7nNFk" width="279"></iframe>\r\n<h3>Lorem ipsum dolor sit</h3>\r\n\r\n<p>Dorem ipsum dolor sit amet consectetur adipiscing elit congue sit amet erat roin tincidunt vehicula lorem in adipiscing urna iaculis vel.</p>\r\n</div>\r\n', '', 0, 0, 0),\r\n\t\t\t\t(25, '', 3, 0, NULL, NULL, NULL, '', '79', '1', 'category', 0, 1, 'menu', 0, 1, 0, 2, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(26, '', 3, 0, NULL, NULL, NULL, '', '74', '1', 'category', 0, 1, 'menu', 0, 1, 0, 3, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(27, '', 3, 0, NULL, NULL, NULL, '', '73', '1', 'category', 0, 1, 'menu', 0, 1, 0, 4, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(28, '', 3, 0, NULL, NULL, NULL, '', '80', '1', 'category', 0, 1, 'menu', 0, 1, 0, 5, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(29, '', 3, 0, NULL, NULL, NULL, '', '', '1', 'category', 0, 1, 'menu', 0, 1, 0, 6, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(30, '', 3, 0, NULL, NULL, NULL, '', '46', '1', 'category', 0, 1, 'menu', 0, 1, 0, 7, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(31, '', 3, 0, NULL, NULL, NULL, '', '75', '1', 'category', 0, 1, 'menu', 0, 1, 0, 8, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(32, '', 3, 0, NULL, NULL, NULL, '', '78', '1', 'category', 0, 1, 'menu', 0, 1, 0, 9, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(33, '', 3, 0, NULL, NULL, NULL, '', '77', '1', 'category', 0, 1, 'menu', 0, 1, 0, 10, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(34, '', 3, 0, NULL, NULL, NULL, '', '77', '1', 'category', 0, 1, 'menu', 0, 1, 0, 11, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(35, '', 3, 0, NULL, NULL, NULL, '', '45', '1', 'category', 0, 1, 'menu', 0, 1, 0, 12, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(36, '', 3, 0, NULL, NULL, NULL, '', '45', '1', 'category', 0, 1, 'menu', 0, 1, 0, 13, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(37, '', 1, 0, NULL, NULL, NULL, '', '25', '1', 'category', 0, 1, 'menu', 0, 1, 0, 6, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(38, '', 1, 0, NULL, NULL, NULL, '', '57', '1', 'category', 0, 1, 'menu', 0, 1, 0, 7, 0, '', NULL, 0, 'top', '', NULL, '', '', 0, 0, 0),\r\n\t\t\t\t(40, '', 1, 0, NULL, NULL, NULL, '', '', '1', 'url', 0, 1, 'menu', 0, 1, 0, 1, 0, '?route=common/home', NULL, 0, 'top', 'home', NULL, '', '', 0, 0, 0);\r\n\r\n\r\n\t\t\t\t";
$sql[] = "\r\n\t\t\t\tINSERT INTO `" . DB_PREFIX . "verticalmenu_description` (`verticalmenu_id`, `language_id`, `title`, `description`) VALUES\r\n\t\t\t\t(2, 2, 'Electronics', ''),\r\n\t\t\t\t(3, 1, 'Digital', ''),\r\n\t\t\t\t(3, 2, 'Digital', ''),\r\n\t\t\t\t(4, 2, 'Watches', ''),\r\n\t\t\t\t(2, 1, 'Electronics', ''),\r\n\t\t\t\t(4, 1, 'Watches', ''),\r\n\t\t\t\t(5, 2, 'Books', ''),\r\n\t\t\t\t(5, 1, 'Books', ''),\r\n\t\t\t\t(37, 2, 'Watches', ''),\r\n\t\t\t\t(7, 2, 'Office', ''),\r\n\t\t\t\t(7, 1, 'Office', ''),\r\n\t\t\t\t(8, 1, 'Computers', ''),\r\n\t\t\t\t(9, 1, 'Printer', ''),\r\n\t\t\t\t(8, 2, 'Computers', ''),\r\n\t\t\t\t(10, 2, 'Duis tempor', ''),\r\n\t\t\t\t(10, 1, 'Duis tempor', ''),\r\n\t\t\t\t(11, 2, 'Pellentesque eget', ''),\r\n\t\t\t\t(11, 1, 'Pellentesque eget ', ''),\r\n\t\t\t\t(12, 2, 'Nam nunc ante', ''),\r\n\t\t\t\t(12, 1, 'Nam nunc ante', ''),\r\n\t\t\t\t(13, 2, 'Condimentum eu', ''),\r\n\t\t\t\t(13, 1, 'Condimentum eu', ''),\r\n\t\t\t\t(14, 2, 'Lehicula lorem', ''),\r\n\t\t\t\t(14, 1, 'Lehicula lorem', ''),\r\n\t\t\t\t(15, 2, 'Integer semper', ''),\r\n\t\t\t\t(15, 1, 'Integer semper', ''),\r\n\t\t\t\t(16, 2, 'Sollicitudin lacus', ''),\r\n\t\t\t\t(16, 1, 'Sollicitudin lacus', ''),\r\n\t\t\t\t(9, 2, 'Mobiles', ''),\r\n\t\t\t\t(17, 2, 'Nam ipsum ', ''),\r\n\t\t\t\t(17, 1, 'Nam ipsum ', ''),\r\n\t\t\t\t(18, 2, 'Curabitur turpis ', ''),\r\n\t\t\t\t(18, 1, 'Curabitur turpis ', ''),\r\n\t\t\t\t(19, 1, 'Molestie eu mattis ', ''),\r\n\t\t\t\t(19, 2, 'Molestie eu mattis ', ''),\r\n\t\t\t\t(20, 1, 'Suspendisse eu ', ''),\r\n\t\t\t\t(20, 2, 'Suspendisse eu ', ''),\r\n\t\t\t\t(21, 1, 'Nunc imperdiet ', ''),\r\n\t\t\t\t(21, 2, 'Nunc imperdiet ', ''),\r\n\t\t\t\t(22, 1, 'Mauris mattis', ''),\r\n\t\t\t\t(22, 2, 'Mauris mattis', ''),\r\n\t\t\t\t(23, 1, 'Lacus sed iaculis ', ''),\r\n\t\t\t\t(23, 2, 'Lacus sed iaculis ', ''),\r\n\t\t\t\t(24, 2, 'Lorem ipsum dolor sit ', ''),\r\n\t\t\t\t(24, 1, 'Lorem ipsum dolor sit ', ''),\r\n\t\t\t\t(37, 1, 'Watches', ''),\r\n\t\t\t\t(25, 1, 'Aliquam', ''),\r\n\t\t\t\t(25, 2, 'Aliquam', ''),\r\n\t\t\t\t(26, 1, 'Claritas', ''),\r\n\t\t\t\t(26, 2, 'Claritas', ''),\r\n\t\t\t\t(27, 2, 'Consectetuer', ''),\r\n\t\t\t\t(27, 1, 'Consectetuer', ''),\r\n\t\t\t\t(28, 1, 'Hendrerit', ''),\r\n\t\t\t\t(28, 2, 'Hendrerit', ''),\r\n\t\t\t\t(29, 1, 'Litterarum', ''),\r\n\t\t\t\t(29, 2, 'Litterarum', ''),\r\n\t\t\t\t(30, 1, 'Macs', ''),\r\n\t\t\t\t(30, 2, 'Macs', ''),\r\n\t\t\t\t(31, 1, 'Sollemnes', ''),\r\n\t\t\t\t(31, 2, 'Sollemnes', ''),\r\n\t\t\t\t(32, 1, 'Tempor', ''),\r\n\t\t\t\t(32, 2, 'Tempor', ''),\r\n\t\t\t\t(33, 1, 'Vulputate', ''),\r\n\t\t\t\t(33, 2, 'Vulputate', ''),\r\n\t\t\t\t(34, 1, 'Vulputate', ''),\r\n\t\t\t\t(34, 2, 'Vulputate', ''),\r\n\t\t\t\t(35, 1, 'Windows', ''),\r\n\t\t\t\t(35, 2, 'Windows', ''),\r\n\t\t\t\t(36, 1, 'Windows', ''),\r\n\t\t\t\t(36, 2, 'Windows', ''),\r\n\t\t\t\t(38, 1, 'Tablets', ''),\r\n\t\t\t\t(38, 2, 'Tablets', ''),\r\n\t\t\t\t(40, 2, 'Home', ''),\r\n\t\t\t\t(40, 1, 'Home', '');\r\n\t\t\t\t";
foreach ($sql as $q) {
$query = $this->db->query($q);
}
}
}
}