[Discuz!] 论坛后台内置导航误删除的解决办法

进入phpmyadmin后,随意点开一个表的sql

下载 (80.2 KB)

2014-10-26 16:26

将默认sql替换为被删除的导航，例如之前误删除了门户的导航，如图

下载 (60.1 KB)

2014-10-26 16:36

情况一：是导入单个丢失内置导航的sql：


INSERT INTO pre_common_nav VALUES ('','0','门户','Portal','portal.php','1','0','0','-1','1','0','0','0', 0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','论坛','BBS','forum.php','2','0','0','1','2','0','0','0', 0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','群组','Group','group.php','3','0','0','-1','7','0','0','0', 0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','动态','Space','home.php','4','0','0','-1','8','0','0','0', 0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','游戏','Manyou','userapp.php','5','0','0','1','6','0','0','0', 0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','插件','Plugin','#','6','0','0','1','9','0','0','0', 0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','帮助','Help','misc.php?mod=faq','7','0','0','0','10','0','0','0', 0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','排行榜','Ranklist','misc.php?mod=ranklist','8','0','0','-1','16','0','0','0',  0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','广播','Follow','home.php?mod=follow','9','0','0','-1','5','0','0','0',  0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','导读','Guide','forum.php?mod=guide','10','0','0','-1','3','0','0','0',  0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','淘帖','Collection','forum.php?mod=collection','11','0','0','-1','11','0','0','0',  0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','日志','Blog','home.php?mod=space&do=blog','12','0','0','-1','12','0','0','0',  0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','相册','Album','home.php?mod=space&do=album','13','0','0','-1','13','0','0','0',  0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','分享','Share','home.php?mod=space&do=share','14','0','0','-1','14','0','0','0',  0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('','0','记录','Doing','home.php?mod=space&do=doing','15','0','0','-1','15','0','0','0',  0, '', '', '', 0, '');
INSERT INTO pre_common_nav VALUES ('', '0', '站点统计', '', 'misc.php?mod=stat', 'stat', 0, 0, 1, 1, 0, 0, 0, 0, '', '', '', 1, '');
INSERT INTO pre_common_nav VALUES ('', '0', '举报', '', '#', 'report', 0, 0, 1, 2, 0, 0, 0, 0, '', '', '', 1, '');
INSERT INTO pre_common_nav VALUES ('', '0', 'Archiver', '', 'archiver/', 'archiver', 0, 0, 1, 3, 0, 0, 0, 0, '', '', '', 1, '');
INSERT INTO pre_common_nav VALUES ('', '0', '手机版', '', 'forum.php?mobile=yes', 'mobile', 0, 0, 1, 3, 0, 0, 0, 0, '', '', '', 1, '');
INSERT INTO pre_common_nav VALUES ('', '0', '日志', '', 'home.php?mod=space&do=blog', 'blog', 0, 0, -1, 2, 0, 0, 0, 0, '{STATICURL}image/feed/blog.gif', '发布', 'home.php?mod=spacecp&ac=blog', 2, '');
INSERT INTO pre_common_nav VALUES ('', '0', '相册', '', 'home.php?mod=space&do=album', 'album', 0, 0, -1, 3, 0, 0, 0, 0, '{STATICURL}image/feed/album.gif', '上传', 'home.php?mod=spacecp&ac=upload', 2, '');
INSERT INTO pre_common_nav VALUES ('', '0', '分享', '', 'home.php?mod=space&do=share', 'share', 0, 0, -1, 4, 0, 0, 0, 0, '{STATICURL}image/feed/share.gif', '添加', 'home.php?mod=spacecp&ac=share', 2, '');
INSERT INTO pre_common_nav VALUES ('', '0', '记录', '', 'home.php?mod=space&do=doing', 'doing', 0, 0, -1, 5, 0, 0, 0, 0, '{STATICURL}image/feed/doing.gif', '', '', 2, '');
INSERT INTO pre_common_nav VALUES ('', '0', '广播', '', 'home.php?mod=follow', 'follow', 0, 0, -1, 6, 0, 0, 0, 0, '{STATICURL}image/feed/follow.gif', '', '', 2, '');
INSERT INTO pre_common_nav VALUES ('', '0', '{userpanelarea1}', '', '', '', 0, 0, 1, 7, 0, 0, 0, 0, '', '', '', 2, '');
INSERT INTO pre_common_nav VALUES ('', '0', '{hr}', '', '', '', 0, 1, 1, 8, 0, 0, 0, 0, '', '', '', 2, '');
INSERT INTO pre_common_nav VALUES ('', '0', '{userpanelarea2}', '', '', '', 0, 0, 1, 9, 0, 0, 0, 0, '', '', '', 2, '');
INSERT INTO pre_common_nav VALUES ('', '0', '好友', '', 'home.php?mod=space&do=friend', 'friend', 0, 0, 1, 1, 0, 0, 0, 0, '{STATICURL}image/feed/friend_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '帖子', '', 'forum.php?mod=guide&view=my', 'thread', 0, 0, 1, 2, 0, 0, 0, 0, '{STATICURL}image/feed/thread_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '收藏', '', 'home.php?mod=space&do=favorite&view=me', 'favorite', 0, 0, 1, 3, 0, 0, 0, 0, '{STATICURL}image/feed/favorite_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '道具', '', 'home.php?mod=magic', 'magic', 0, 0, 1, 4, 0, 0, 0, 0, '{STATICURL}image/feed/magic_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '勋章', '', 'home.php?mod=medal', 'medal', 0, 0, 1, 5, 0, 0, 0, 0, '{STATICURL}image/feed/medal_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '任务', '', 'home.php?mod=task', 'task', 0, 0, 1, 6, 0, 0, 0, 0, '{STATICURL}image/feed/task_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '淘帖', '', 'forum.php?mod=collection&op=my', 'collection', 0, 0, -1, 7, 0, 0, 0, 0, '{STATICURL}image/feed/collection_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '动态', '', 'home.php', 'feed', 0, 0, -1, 8, 0, 0, 0, 0, '{STATICURL}image/feed/feed_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '日志', '', 'home.php?mod=space&do=blog', 'blog', 0, 0, -1, 9, 0, 0, 0, 0, '{STATICURL}image/feed/blog_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '相册', '', 'home.php?mod=space&do=album', 'album', 0, 0, -1, 10, 0, 0, 0, 0, '{STATICURL}image/feed/album_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '分享', '', 'home.php?mod=space&do=share', 'share', 0, 0, -1, 11, 0, 0, 0, 0, '{STATICURL}image/feed/share_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '记录', '', 'home.php?mod=space&do=doing', 'doing', 0, 0, -1, 12, 0, 0, 0, 0, '{STATICURL}image/feed/doing_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '留言板', '', 'home.php?mod=space&do=wall', 'wall', 0, 0, -1, 13, 0, 0, 0, 0, '{STATICURL}image/feed/wall_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '广播', '', 'home.php?mod=follow', 'follow', 0, 0, -1, 14, 0, 0, 0, 0, '{STATICURL}image/feed/follow_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '群组', '', 'group.php', 'group', 0, 0, -1, 15, 0, 0, 0, 0, '{STATICURL}image/feed/group_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '门户', '', 'portal.php', 'portal', 0, 0, -1, 16, 0, 0, 0, 0, '{STATICURL}image/feed/portal_b.png', '', '', 3, '');
INSERT INTO pre_common_, '', '#', 'sethomepage', 0, 0, 1, 1, 0, 0, 0, 0, '', '', '', 4, '');
INSERT INTO pre_common_nav VALUES ('', '0', '收藏本站', '', '#', 'setfavorite', 0, 0, 1, 2, 0, 0, 0, 0, '', '', '', 4, '');
nav VALUES ('', '0', '导读', '', 'forum.php?mod=guide', 'guide', 0, 0, -1, 17, 0, 0, 0, 0, '{STATICURL}image/feed/guide_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '排行榜', '', 'misc.php?mod=ranklist', 'ranklist', 0, 0, -1, 18, 0, 0, 0, 0, '{STATICURL}image/feed/ranklist_b.png', '', '', 3, '');
INSERT INTO pre_common_nav VALUES ('', '0', '设为首页', '', '#', 'sethomepage', 0, 0, 1, 1, 0, 0, 0, 0, '', '', '', 4, '');
INSERT INTO pre_common_nav VALUES ('', '0', '收藏本站', '', '#', 'setfavorite', 0, 0, 1, 2, 0, 0, 0, 0, '', '', '', 4, '');

情况二：丢失所有内置导航的sql

INSERT INTO `pre_common_nav` (`id`, `parentid`, `name`, `title`, `url`, `identifier`, `target`, `type`, `available`, `displayorder`, `highlight`, `level`, `subtype`, `subcols`, `icon`, `subname`, `suburl`, `navtype`, `logo`) VALUES
(181, 0, '日志', '', 'home.php?mod=space&do=blog', 'blog', 0, 0, 0, 9, 0, 0, 0, 0, '{STATICURL}image/feed/blog_b.png', '', '', 3, ''),
(180, 0, '动态', '', 'home.php', 'feed', 0, 0, 1, 8, 0, 0, 0, 0, '{STATICURL}image/feed/feed_b.png', '', '', 3, ''),
(179, 0, '淘帖', '', 'forum.php?mod=collection&op=my', 'collection', 0, 0, 1, 7, 0, 0, 0, 0, '{STATICURL}image/feed/collection_b.png', '', '', 3, ''),
(178, 0, '任务', '', 'home.php?mod=task', 'task', 0, 0, 1, 6, 0, 0, 0, 0, '{STATICURL}image/feed/task_b.png', '', '', 3, ''),
(177, 0, '勋章', '', 'home.php?mod=medal', 'medal', 0, 0, 1, 5, 0, 0, 0, 0, '{STATICURL}image/feed/medal_b.png', '', '', 3, ''),
(176, 0, '道具', '', 'home.php?mod=magic', 'magic', 0, 0, 1, 4, 0, 0, 0, 0, '{STATICURL}image/feed/magic_b.png', '', '', 3, ''),
(175, 0, '收藏', '', 'home.php?mod=space&do=favorite&view=me', 'favorite', 0, 0, 1, 3, 0, 0, 0, 0, '{STATICURL}image/feed/favorite_b.png', '', '', 3, ''),
(145, 0, '门户', 'Portal', 'portal.php', '1', 0, 0, 1, 1, 0, 0, 0, 0, '', '', '', 0, ''),
(174, 0, '帖子', '', 'forum.php?mod=guide&view=my', 'thread', 0, 0, 1, 2, 0, 0, 0, 0, '{STATICURL}image/feed/thread_b.png', '', '', 3, ''),
(171, 0, '{hr}', '', '', '', 0, 1, 1, 8, 0, 0, 0, 0, '', '', '', 2, ''),
(172, 0, '{userpanelarea2}', '', '', '', 0, 0, 1, 9, 0, 0, 0, 0, '', '', '', 2, ''),
(173, 0, '好友', '', 'home.php?mod=space&do=friend', 'friend', 0, 0, 1, 1, 0, 0, 0, 0, '{STATICURL}image/feed/friend_b.png', '', '', 3, ''),
(170, 0, '{userpanelarea1}', '', '', '', 0, 0, 1, 7, 0, 0, 0, 0, '', '', '', 2, ''),
(169, 0, '广播', '', 'home.php?mod=follow', 'follow', 0, 0, 1, 6, 0, 0, 0, 0, '{STATICURL}image/feed/follow.gif', '', '', 2, ''),
(168, 0, '记录', '', 'home.php?mod=space&do=doing', 'doing', 0, 0, 1, 5, 0, 0, 0, 0, '{STATICURL}image/feed/doing.gif', '', '', 2, ''),
(167, 0, '分享', '', 'home.php?mod=space&do=share', 'share', 0, 0, 1, 4, 0, 0, 0, 0, '{STATICURL}image/feed/share.gif', '添加', 'home.php?mod=spacecp&ac=share', 2, ''),
(48, 0, '测试', '', 'http://bbs.duduyu.net/test/', '1', 0, 4, 1, 1, 0, 0, 1, 0, '', '', '', 0, ''),
(166, 0, '相册', '', 'home.php?mod=space&do=album', 'album', 0, 0, 1, 3, 0, 0, 0, 0, '{STATICURL}image/feed/album.gif', '上传', 'home.php?mod=spacecp&ac=upload', 2, ''),
(165, 0, '日志', '', 'home.php?mod=space&do=blog', 'blog', 0, 0, 1, 2, 0, 0, 0, 0, '{STATICURL}image/feed/blog.gif', '发布', 'home.php?mod=spacecp&ac=blog', 2, ''),
(164, 0, '小黑屋', '', 'forum.php?mod=misc&action=showdarkroom', 'darkroom', 0, 0, 1, 3, 0, 0, 0, 0, '', '', '', 1, ''),
(163, 0, '手机版', '', 'forum.php?mobile=yes', 'mobile', 0, 0, 1, 3, 0, 0, 0, 0, '', '', '', 1, ''),
(162, 0, 'Archiver', '', 'archiver/', 'archiver', 0, 0, 1, 3, 0, 0, 0, 0, '', '', '', 1, ''),
(161, 0, '举报', '', '#', 'report', 0, 0, 1, 2, 0, 0, 0, 0, '', '', '', 1, ''),
(160, 0, '站点统计', '', 'misc.php?mod=stat', 'stat', 0, 0, 1, 1, 0, 0, 0, 0, '', '', '', 1, ''),
(159, 0, '记录', 'Doing', 'home.php?mod=space&do=doing', '15', 0, 0, 0, 15, 0, 0, 0, 0, '', '', '', 0, ''),
(158, 0, '分享', 'Share', 'home.php?mod=space&do=share', '14', 0, 0, 0, 14, 0, 0, 0, 0, '', '', '', 0, ''),
(157, 0, '相册', 'Album', 'home.php?mod=space&do=album', '13', 0, 0, 0, 13, 0, 0, 0, 0, '', '', '', 0, ''),
(156, 0, '日志', 'Blog', 'home.php?mod=space&do=blog', '12', 0, 0, 1, 12, 0, 0, 0, 0, '', '', '', 0, ''),
(155, 0, '淘帖', 'Collection', 'forum.php?mod=collection', '11', 0, 0, 0, 11, 0, 0, 0, 0, '', '', '', 0, ''),
(154, 0, '导读', 'Guide', 'forum.php?mod=guide', '10', 0, 0, 0, 3, 0, 0, 0, 0, '', '', '', 0, ''),
(153, 0, '广播', 'Follow', 'home.php?mod=follow', '9', 0, 0, 0, 5, 0, 0, 0, 0, '', '', '', 0, ''),
(152, 0, '排行榜', 'Ranklist', 'misc.php?mod=ranklist', '8', 0, 0, 1, 16, 0, 0, 0, 0, '', '', '', 0, ''),
(151, 0, '帮助', 'Help', 'misc.php?mod=faq', '7', 0, 0, 0, 10, 0, 0, 0, 0, '', '', '', 0, ''),
(150, 0, '插件', 'Plugin', '#', '6', 0, 0, 1, 9, 0, 0, 0, 0, '', '', '', 0, ''),
(148, 0, '家园', 'Space', 'home.php', '4', 0, 0, -1, 8, 0, 0, 0, 0, '', '', '', 0, ''),
(149, 0, '游戏', 'Manyou', 'userapp.php', '5', 0, 0, 1, 6, 0, 0, 0, 0, '', '', '', 0, ''),
(147, 0, '群组', 'Group', 'group.php', '3', 0, 0, 1, 7, 0, 0, 0, 0, '', '', '', 0, ''),
(146, 0, '论坛', 'BBS', 'forum.php', '2', 0, 0, 1, 2, 0, 0, 0, 0, '', '', '', 0, ''),
(182, 0, '相册', '', 'home.php?mod=space&do=album', 'album', 0, 0, 0, 10, 0, 0, 0, 0, '{STATICURL}image/feed/album_b.png', '', '', 3, ''),
(183, 0, '分享', '', 'home.php?mod=space&do=share', 'share', 0, 0, 0, 11, 0, 0, 0, 0, '{STATICURL}image/feed/share_b.png', '', '', 3, ''),
(184, 0, '记录', '', 'home.php?mod=space&do=doing', 'doing', 0, 0, 0, 12, 0, 0, 0, 0, '{STATICURL}image/feed/doing_b.png', '', '', 3, ''),
(185, 0, '留言板', '', 'home.php?mod=space&do=wall', 'wall', 0, 0, 1, 13, 0, 0, 0, 0, '{STATICURL}image/feed/wall_b.png', '', '', 3, ''),
(186, 0, '广播', '', 'home.php?mod=follow', 'follow', 0, 0, 1, 14, 0, 0, 0, 0, '{STATICURL}image/feed/follow_b.png', '', '', 3, ''),
(187, 0, '群组', '', 'group.php', 'group', 0, 0, 0, 15, 0, 0, 0, 0, '{STATICURL}image/feed/group_b.png', '', '', 3, ''),
(188, 0, '门户', '', 'portal.php', 'portal', 0, 0, 1, 16, 0, 0, 0, 0, '{STATICURL}image/feed/portal_b.png', '', '', 3, ''),
(189, 0, '导读', '', 'forum.php?mod=guide', 'guide', 0, 0, 1, 17, 0, 0, 0, 0, '{STATICURL}image/feed/guide_b.png', '', '', 3, ''),
(190, 0, '排行榜', '', 'misc.php?mod=ranklist', 'ranklist', 0, 0, 0, 18, 0, 0, 0, 0, '{STATICURL}image/feed/ranklist_b.png', '', '', 3, ''),
(191, 0, '设为首页', '', '#', 'sethomepage', 0, 0, 0, 1, 0, 0, 0, 0, '', '', '', 4, ''),
(192, 0, '收藏本站', '', '#', 'setfavorite', 0, 0, 0, 2, 0, 0, 0, 0, '', '', '', 4, '');