<? $sql=sprintf("SELECT a.* FROM %s AS a WHERE a.m_id = %d AND (a.m_del = 0 OR a.m_del IS NULL)", $tbl_main,$m_id); $query=mysql_query($sql,$db_conn); $row_s=mysql_fetch_assoc($query); ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=windows-1251"> <meta name="description" content="<!--#include virtual="/inc/navigation/description.html"-->"> <meta name="ROBOTS" content="all"> <link href="/" rel="home"> <link rel="alternate" type="application/rss+xml" title="RSS" href="http://www.sotovik.ru/news.xml"> <link rel="SHORTCUT ICON" href="http://www.sotovik.ru/favicon.ico"> <title><?=$row_s["m_name"]?> - Сотовик</title> <style type="text/css"> @import url(/styles/10827_main.css); </style> </head> <body> <div align="center"> <!-- Header --> <!--#include virtual="/inc/navigation/header.html"--> <!-- Header --> <div id="main"> <div class="left_zone"> <div class="menu"> <!-- Left menu --> <!--#include virtual="/inc/lib/left_menu.html"--> <!-- Left menu --> </div> </div> <div class="main_zone"> <h1><?=$row_s["m_name"]?></h1> <div class="center_zone"> <? $sql = sprintf("SELECT * FROM %s WHERE m_parent_id = %d AND m_id <> 80421 AND (m_del = 0 OR m_del IS NULL) LIMIT 0,1",$tbl_main,$m_id); $query = mysql_query($sql,$db_conn); while ($row=mysql_fetch_assoc($query)) { printf("<div class=\"head_blok_center\"><ul><li>%s</li></ul></div>\n", $row["m_name"]); $img = array(); $sql = sprintf("SELECT a.m_id,b.m_path AS img_path,b.m_file AS img_file FROM %s AS a JOIN %s AS b ON (a.m_id = b.m_parent_id AND b.m_code = 'small' AND (b.m_del = 0 OR b.m_del IS NULL)) WHERE a.m_parent_id = %d AND (a.m_del = 0 OR a.m_del IS NULL)", $tbl_main,$tbl_main,$row["m_id"]); $query=mysql_query($sql,$db_conn); while ($img_row=mysql_fetch_assoc($query)) { $img[$img_row["m_id"]] = $img_row; } mysql_free_result($query); $sql = sprintf("SELECT a.*,b.m_path AS categoty_path,b.m_name AS categoty_name FROM %s AS a JOIN %s AS b ON (a.m_link9 = b.m_id AND (b.m_del = 0 OR b.m_del IS NULL)) WHERE a.m_parent_id = %d AND (a.m_del = 0 OR a.m_del IS NULL) ORDER BY a.m_create_time DESC LIMIT 16", $tbl_main,$tbl_main,$row["m_id"]); $query=mysql_query($sql,$db_conn); while ($reviews=mysql_fetch_assoc($query)) { $xml=new xml(); $xml->xml=$reviews['m_main_content']; $xml->get(); $images = ($img[$reviews["m_id"]] ? $img[$reviews["m_id"]]["img_path"]."/".$img[$reviews["m_id"]]["img_file"] : "files/catalog/80962_middle.jpg"); printf("<div class=\"more_content_blok\" style=\"height: 210px;\"><a href=\"http://www.sotovik.ru/%s/%s\"><img src=\"/%s\" border=\"0\" align=\"left\"></a> <a href=\"http://www.sotovik.ru/%s/%s\"><strong>%s</strong></a> / <span class=\"source\">%s</span> <p>%s%s</p> <strong>Цена: <font size=\"3\">%s</font></strong> <div class=\"all\"><a href=\"%s\" target=\"_blank\"><strong>Купить</strong></a></div></div>", $reviews["m_path"],$reviews["m_file"],$images,$reviews["m_path"],$reviews["m_file"],$reviews["m_link5"],$xml->author,substr($xml->description,0,230),(strlen($xml->description) > 230 ? '...' : ''),$reviews["m_link1"],$reviews["m_link5"]); } mysql_free_result($query); } ?> </div> <div class="right_zone"> <!-- Banner zone 4 --> <!--#include virtual="/inc/banner_zone/4.html"--> <!-- Banner zone 4 --> </div> </div> </div> <!-- Footer --> <!--#include virtual="/inc/navigation/footer.html"--> <!-- Footer --> </div> </body> </html>