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