rk9 site Code

<?php
echo "<div > ";
  
  $lmitems = mysql_query("select * from leftmenu where permission<=$permis order by morder");		
  $lmitemcount = mysql_num_rows($lmitems);

  
  
  $k=0;//Находим максимальное число пунктов подменю
  for($i=0;$i<$lmitemcount;$i++) {
		
		$lmsitemsstr = "select * from leftsubmenu where parent=".mysql_result($lmitems,$i,0)." and permission<=$permis order by morder";
		$lmsitems = mysql_query($lmsitemsstr);		
		$lmsitemcount = mysql_num_rows($lmsitems);
		if($k<$lmsitemcount) $k = $lmsitemcount;
  }
  
  
  for($i=0;$i<$lmitemcount;$i++) {
		
 		$toptable[0][$i*2]="<td><img src=\"".$design_path.mysql_result($lmitems,$i,4)." \"></td>\n";//Взять картинку иконки левого меню
		$toptable[0][$i*2+1]="<td class=\"left_menu\">".mysql_result($lmitems,$i,1)."</td>\n";//Взять название пункта левого меню
		
		$lmsitemsstr = "select * from leftsubmenu where parent=".mysql_result($lmitems,$i,0)." and permission<=$permis order by morder";//Находим пункты каждого подменю
		$lmsitems = mysql_query($lmsitemsstr);		
		
		for($j=0;$j<$k;$j++) {
			if(mysql_result($lmsitems,$j,3)<=$permis) {
				$toptable[$j+1][$i*2]="<td>&nbsp;</td>\n";
				
				//if( mysql_result($lmsitems,$j,5)!="" ) ;//	echo"<td><p class=\"left_menu_item\"><a href=\"".mysql_result($lmsitems,$j,5)."\" class=\"left_menu_item\" target=\"blanc\"></a></p></td>\n";
				//else echo "<td><p class=\"left_menu_item\"><a href=\"?lsm=".mysql_result($lmsitems,$j,0)."\" class=\"left_menu_item\"></a></p></td>\n";
				if(mysql_result($lmsitems,$j,1)!="") {
					if( mysql_result($lmsitems,$j,5)!="" ) $toptable[$j+1][$i*2+1] =$toptable[$j+1][$i*2+1]."<td><p class=\"left_menu_item\"><a href=\"".mysql_result($lmsitems,$j,5)."\" class=\"left_menu_item\" target=\"blanc\">".mysql_result($lmsitems,$j,1)."</a></p></td>\n";
					else $toptable[$j+1][$i*2+1] =$toptable[$j+1][$i*2+1]."<td><p class=\"left_menu_item\"><a href=\"?lsm=".mysql_result($lmsitems,$j,0)."\" class=\"left_menu_item\">".mysql_result($lmsitems,$j,1)."</a></p></td>\n";
				}
				else $toptable[$j+1][$i*2+1]="<td>&nbsp;</td>\n";				
			}
			else {
				$toptable[$j+1][$i*2]="<td>&nbsp;</td>\n";
				$toptable[$j+1][$i*2+1]="<td>&nbsp;</td>\n";		
				
			}
		}
  }
  
  //Вывод короткого меню
  
  echo "<table width=\"100%\"  cellpadding=\"0\" cellspacing=\"0\" border=\"0\">\n";
   for($i=0;$i<$k+1;$i++) {
	echo "	<tr>\n";	  
	  for($j=0;$j<$lmitemcount*2;$j++) {
		  echo $toptable[$i][$j]; 
	  }
	  echo "	</tr>\n";	
  }
  echo "</table>";
  echo "</div>";
  echo "<br>";
  //Вывод баннеров
  $page_request = "select * from banners where >;
  $p = mysql_query($page_request);
  $pageexsist = mysql_num_rows($p);
  
  if($pageexsist) {
	echo "<div  align=\"center\">";
	  echo "<table width=\"80%\" align=\"center\" cellpadding=\"0\" cellspacing=\"5\" border=\"0\">\n";
	  echo "<tr>\n";
	  for($i=0;$i<$pageexsist;$i++){
		  echo "<tr><td>\n";
		  echo "<a href=\"".mysql_result($p,$i,3)."\">";
		  echo "<img src=\"http://".$GLOBALS[HTTP_HOST]."/".mysql_result($p,$i,2)."\">";
		  echo "</a>\n";
		  echo "</td>\n";
		  
	  }
	  echo "</tr>";
	  echo "</table>\n";
	echo "</div>";
  }
  
  //Вывод новостей и объявлений
  $now_date = date("Y-m-d");
  
  $messagesitems = mysql_query("select * from messages where >\"1\" and permis<=$permis and actual_date>=\"$now_date\" order by messagesdate DESC");		
  $messagesitemcount = mysql_num_rows($messagesitems );
  
  $newsitems = mysql_query("select * from news where >\"1\" and permis<=$permis order by newsdate DESC");		
  $newsitemcount = mysql_num_rows($newsitems );
  
  echo "<br><br > ";
  echo "<div > ";
  echo "<table width=\"80%\" align=\"center\" cellpadding=\"0\" cellspacing=\"5\" border=\"0\">\n";
  echo "<tr>\n";
  if($messagesitemcount>0) {
	echo "	<td class=\"news_top_text\" width=\"50%\">\n"; 
	echo "<a class=\"news_top\" href=\"/?mm=4&sm=18\" >Объявления</a>";
	echo "	</td>\n";
  }
  if($newsitemcount>0) {
	  echo "	<td class=\"news_top_text\">\n";
	  echo "<a class=\"news_top\" href=\"/?mm=4&sm=17\" >Последние новости</a>\n";
	  echo "	</td>\n";
  }
  echo "</tr>\n";
  
  echo "<tr>\n";
  //Содержание объявлений
  if($messagesitemcount>0) {
	  echo "	<td valign=\"top\">\n" ;
	  

	  for($i=0;$i<$messagesitemcount;$i++)  {
		echo "<b>".MStrToDate(mysql_result($messagesitems ,$i,1))." : ".mysql_result($messagesitems ,$i,2)."</b><br>".mysql_result($messagesitems ,$i,3)."<br>";
		echo "<table width=\"100%\" border=\"0\"><tr><td aling=\"left\" width=\"50%\">";
		if(mysql_result($messagesitems ,$i,4)!="") echo "<a href=\"/?mm=4&sm=18&messagesid=".mysql_result($messagesitems ,$i,0)."\"><img src=\"".$design_path."details.png\"></a>";
		echo "</td><td align=\"right\">";
		echo "<a href=\"/?mm=4&sm=18&messagesid=".mysql_result($messagesitems ,$i,0)."\"><img src=\"".$design_path."link.png\"></a>";
		echo "</td></tr></table>";
		echo "<hr>";
	  }
	  echo "	</td>\n";
  }
  if($newsitemcount>0) {
	  echo "	<td valign=\"top\">\n";
	  //Содержание новостей
	  for($i=0;$i<$newsitemcount;$i++)  {
		echo "<b>".MStrToDate(mysql_result($newsitems ,$i,1))." : ".mysql_result($newsitems ,$i,2)."</b><br>".mysql_result($newsitems ,$i,3)."<br>";
		echo "<table width=\"100%\" border=\"0\"><tr><td aling=\"left\" width=\"50%\">";
		if(mysql_result($newsitems ,$i,4)!="") echo "<a href=\"/?mm=4&sm=17&newsid=".mysql_result($newsitems ,$i,0)."\"><img src=\"".$design_path."details.png\"></a> ";
		echo "</td><td align=\"right\">";
		echo "<a href=\"/?mm=4&sm=17&newsid=".mysql_result($newsitems ,$i,0)."\"><img src=\"".$design_path."link.png\"></a>";
		echo "</td></tr></table>";
		echo "<hr>";
	  }
	  echo "	</td>\n";
  }
  echo "</tr>\n";
 
  echo "</table>";
  
echo "</div>";
?>