资讯后台前台不显示分类!! 查过数据库了分类可以存入数据库
导出的数据表:
--
-- 表的结构 `supe_categories`
--
CREATE TABLE IF NOT EXISTS `supe_categories` (
`catid` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
`upid` smallint(6) unsigned NOT NULL DEFAULT '0',
`name` varchar(50) NOT NULL DEFAULT '',
`note` text NOT NULL,
`type` varchar(15) NOT NULL DEFAULT '',
`ischannel` tinyint(1) NOT NULL DEFAULT '0',
`displayorder` mediumint(6) unsigned NOT NULL DEFAULT '0',
`tpl` varchar(80) NOT NULL DEFAULT '',
`viewtpl` varchar(80) NOT NULL DEFAULT '',
`thumb` varchar(150) NOT NULL DEFAULT '',
`image` varchar(150) NOT NULL DEFAULT '',
`haveattach` tinyint(1) NOT NULL DEFAULT '0',
`bbsmodel` tinyint(1) NOT NULL DEFAULT '0',
`bbsurltype` varchar(15) NOT NULL DEFAULT '',
`blockmodel` tinyint(1) NOT NULL DEFAULT '1',
`blockparameter` text NOT NULL,
`blocktext` text NOT NULL,
`url` varchar(255) NOT NULL DEFAULT '',
`subcatid` text NOT NULL,
PRIMARY KEY (`catid`),
KEY `type` (`type`),
KEY `upid` (`upid`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk AUTO_INCREMENT=15 ;
--
-- 导出表中的数据 `supe_categories`
--
INSERT INTO `supe_categories` (`catid`, `upid`, `name`, `note`, `type`, `ischannel`, `displayorder`, `tpl`, `viewtpl`, `thumb`, `image`, `haveattach`, `bbsmodel`, `bbsurltype`, `blockmodel`, `blockparameter`, `blocktext`, `url`, `subcatid`) VALUES
(1, 0, '科技世界', '', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '1'),
(2, 0, '互联网络', '', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '2'),
(3, 0, '财经报道', '', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '3'),
(4, 0, '体育资讯', '', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '4'),
(5, 0, '明星娱乐', '', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '5'),
(6, 0, '生活资讯', '', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '6'),
(7, 0, '网站建设', '', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '7'),
(8, 0, '动态报道', '', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '8'),
(9, 0, '特别关注', '', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '9'),
(10, 0, 'ffsf', 'sfdddddddddddd', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '10'),
(11, 0, '新闻', '', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '11'),
(12, 0, '新闻', '', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '12'),
(13, 0, 'sss', 'fddddddddddddddd', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '13'),
(14, 0, 'sdfsdfffffffffffffff', 'dfssssssssssssss', 'news', 0, 0, '', '', '', '', 0, 0, '', 1, '', '', '', '14'); |