Share mod quản lý menu johncms fix lỗi

[Admin]

Dán code này vào mainmenu.php

// MainMenu Extended
$m_set = mysql_query("SELECT * FROM `cms_menu_settings` WHERE `key`='enabled' LIMIT 1;");
$m_set_n = mysql_fetch_array($m_set);
echo '<!-- MainMenu Extended 0.5 -->';
if ($m_set_n['val'] == 1) {
$m_group = mysql_query("select * from cms_menu_group mode ORDER BY pos;");
if ($m_group) {
while ($m_group_n = mysql_fetch_array($m_group)) {
if ($m_group_n['show'] == 1) {
echo '<div class="phdr">';


$filename = '';
$m_set = mysql_query("SELECT * FROM `cms_menu_settings` WHERE `key`='pic_cat' LIMIT 1;");
$m_set_n = mysql_fetch_array($m_set);
if ($m_set_n['val'] == 1)
$filename = './theme/' . $set_user['skin'] . "/";
else
$filename = './';

$m_set = mysql_query("SELECT * FROM `cms_menu_settings` WHERE `key`='pic_path' LIMIT 1;");
$m_set_n = mysql_fetch_array($m_set);
$filename = $filename . $m_set_n['val'] . "/" . $m_group_n['pic'];

if (file_exists($filename) and $m_group_n['pic'] != '')
echo '<img class="mme_image" alt="" src="' . $filename . '" /> ';
else
echo $m_group_n['sumbo'] . ' ';
echo '<b>' . $m_group_n['name'] . '</b></div>';
$m_link = mysql_query("select * from cms_menu_link mode ORDER BY pos;");
if ($m_link) {
while ($m_link_n = mysql_fetch_array($m_link)) {
if ($m_link_n['show'] == 1) {
if ($m_group_n['id'] == $m_link_n['group']) {

$m_count = mysql_query("SELECT * FROM `cms_menu_count` WHERE `id`='" . $m_link_n['type'] .
"' LIMIT 1;");
$m_count_n = mysql_fetch_array($m_count);
if ($m_link_n['type'] != 0) {
if ($m_count_n['code'] == '$mp->newscount')
$ehe = ' (' . $mp->newscount . ')';
else
$ehe = ' (' . call_user_func($m_count_n['code']) . ')';
} else
$ehe = '';


echo '<div class="menu">';
$filename = '';
$m_set = mysql_query("SELECT * FROM `cms_menu_settings` WHERE `key`='pic_cat' LIMIT 1;");
$m_set_n = mysql_fetch_array($m_set);
if ($m_set_n['val'] == 1)
$filename = './theme/' . $set_user['skin'] . "/";
else
$filename = './';

$m_set = mysql_query("SELECT * FROM `cms_menu_settings` WHERE `key`='pic_path' LIMIT 1;");
$m_set_n = mysql_fetch_array($m_set);
$filename = $filename . $m_set_n['val'] . "/" . $m_link_n['pic'];

if (file_exists($filename) and $m_link_n['pic'] != '')
echo '<img class="mme_image" alt="" src="' . $filename . '" /> ';
else
echo $m_link_n['sumbo'] . ' ';

echo '<a href="' . $m_link_n['link'] . '">' . $m_link_n['name'] . '</a>' .
$ehe . '</div>';
}
}
}
}
}
}
} else {
echo "<p><b>Error: " . mysql_error() . "</b><p>";
exit();
}
} else {

}

Tiếp đến upload file zip lên host sau đó chạy domain/install để cài đặt data
Khi cài đặt xong vào phpmyadmin > SQL >

Nhập đoạn này vào

ALTER TABLE  `cms_menu_link` CHANGE  `name`  `name` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE`cms_menu_group`CHANGE`pic``pic`TEXTCHARACTERSETutf8COLLATEutf8_general_ciNOTNULL;

Bấm Go

Demo hình

Tải xuống tuoitreit.vn_mainmenu-install.zip (26.5 KB)
Chúc các bạn thành công!