سوال: ساخت فهرست و صفحه و پست

CREATE TABLE IF NOT EXISTS `menus` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`fonticon` text COLLATE utf8_persian_ci,
`menu_name` varchar(255) COLLATE utf8_persian_ci NOT NULL,
`parentid` int(11) NOT NULL,
`sort` int(11) NOT NULL,
`menu_type` int(11) NOT NULL,
`status` int(11) NOT NULL,
`adminid` int(11) NOT NULL,
PRIMARY KEY (`ID`)
) ENGINE=IoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `pages` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`mid` int(11) NOT NULL,
`pubtime` int(11) NOT NULL,
`title` text COLLATE utf8_persian_ci NOT NULL,
`slug` text COLLATE utf8_persian_ci NOT NULL,
`descriptions` text COLLATE utf8_persian_ci NOT NULL,
`keywords` text COLLATE utf8_persian_ci NOT NULL,
`contents` text COLLATE utf8_persian_ci NOT NULL,
`reviews` int(11) NOT NULL,
`status` int(11) NOT NULL,
`adminid` int(11) NOT NULL,
PRIMARY KEY (`ID`),
KEY `mid` (`mid`)
) ENGINE=IoDB DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `posts` (
`ID` int(11) NOT NULL AUTO_INCREMENT,
`mid` int(11) NOT NULL,
`pubtime` int(11) NOT NULL,
`title` text COLLATE utf8_persian_ci NOT NULL,
`slug` text COLLATE utf8_persian_ci NOT NULL,
`descriptions` text COLLATE utf8_persian_ci NOT NULL,
`keywords` text COLLATE utf8_persian_ci NOT NULL,
`contents` text COLLATE utf8_persian_ci NOT NULL,
`reviews` int(11) NOT NULL,
`status` int(11) NOT NULL,
`adminid` int(11) NOT NULL,
PRIMARY KEY (`ID`),
KEY `mid` (`mid`)
) ENGINE=IoDB DEFAULT CHARSET=utf8 COLLATE=utf8_persian_ci AUTO_INCREMENT=1 ;

function MenuGroups($parent = 0) {
$parent = mysql_real_escape_string($parent);
$items = mysql_query("SELECT * FROM `menus` WHERE (`parentid`='{$parent}') ORDER BY `sort`");
if ($items && mysql_num_rows($items) > 0) {
while ($item = mysql_fetch_assoc($items)) {
$count = mysql_result(mysql_query("SELECT COUNT(*) AS `count` FROM `menus` WHERE (`parentid`='{$item['ID']}')"), 0, 0);
if ($count > 0) {
echo '<li class="dropdown"><a href="#" class="dropdown-toggle" data-toggle="dropdown"><i class="fa fa-' . $item['fonticon'] . '"></i> ' . $item['menu_name'] . '<span class="caret"></span></a>';
echo '<ul class="dropdown-menu" role="menu">';
MenuGroups($item['ID']);
echo '</ul>';
echo '</li>';
} else {
/*
$Url = Url_Slug($item['ID'].'-'.$item['menu_name']);
echo '<li><a href="'.GetDomainURL().'/pid'.$Url.'.html">' . $item['menu_name'] . '</a></li>';
*/
if ($item['menu_type'] == 1 && $item['status'] == 1){
$Url = Url_Slug($item['ID'].'-'.$item['menu_name']);
echo '<li><a href="'.GetDomainURL().'/page'.$Url.'.html">' . $item['menu_name'] . '</a></li>';
}elseif($item['menu_type'] == 2 && $item['status'] == 1){
$Url = Url_Slug($item['ID'].'-'.$item['menu_name']);
echo '<li><a href="'.GetDomainURL().'/archives'.$Url.'.html">' . $item['menu_name'] . '</a></li>';
}elseif($item['menu_type'] == 3 && $item['status'] == 1){
$Url = Url_Slug($item['ID'].'-'.$item['menu_name']);
echo '<li><a href="'.GetDomainURL().'/galleries'.$Url.'.html">' . $item['menu_name'] . '</a></li>';
}
}
}
mysql_free_result($items);
}
}