public function deleteSelection($menus) { $return = 1; foreach ($menus as $id_sbmegamenu) { $obj_menu = new Sbmegamenu($id_sbmegamenu); $return &= $obj_menu->delete(); } return $return; }
public function checkVersion($version) { $versions = array('3.0.0'); if ($version && $version == $versions[count($versions) - 1]) { return; } foreach ($versions as $ver) { if (!$version || $version && $version < $ver) { if ($this->checktable()) { $checkcolumn = Db::getInstance()->executeS("\n\t\t\t\t\t\tSELECT * FROM INFORMATION_SCHEMA.COLUMNS\n\t\t\t\t\t\tWHERE TABLE_SCHEMA = '" . _DB_NAME_ . "'\n\t\t\t\t\t\tAND TABLE_NAME='" . _DB_PREFIX_ . "sbmegamenu_lang'\n\t\t\t\t\t\tAND COLUMN_NAME ='url'\n\t\t\t\t"); if (count($checkcolumn) < 1) { Db::getInstance()->execute(' ALTER TABLE `' . _DB_PREFIX_ . 'sbmegamenu_lang` ADD `url` varchar(255) DEFAULT NULL'); $menus = Db::getInstance()->executeS('SELECT `id_sbmegamenu`,`id_parent`,`url` FROM `' . _DB_PREFIX_ . 'sbmegamenu`'); if ($menus) { foreach ($menus as $menu) { if ($menu['id_parent'] != 0) { $sbmegamenu = new Sbmegamenu((int) $menu['id_sbmegamenu']); $sbmegamenu->update(); } } } Db::getInstance()->execute('ALTER TABLE `' . _DB_PREFIX_ . 'sbmegamenu` DROP `url`'); Configuration::updateValue('LEO_MENUSIDEBAR_VERSION', $ver); } } } } }