File: /var/www/ilya/data/www/afish-ka.ru/admin/modules/firms/list.inc
<?php
//- Настройки модуля -----------------------------------------------------------
permission("mcp"); // tcp-техники; acp-админы; mcp-модеры; cp-рядовые участники
$skin_pname = "Управление заведениями";
$temp_html="";
//------------------------------------------------------------------------------
$result = query("SELECT COUNT(`firms`.`id`) as num, `firms_types`.`type_title`, `firms_types`.`id` FROM `firms` LEFT JOIN `firms_types` ON `firms`.`type`=`firms_types`.`id` GROUP BY `firms`.`type`");
$list_types = array();
while($data = mysql_fetch_array($result)) {
$list_types[] = "<a href=\"./?m=".$_GET['m']."&task=".$_GET['task']."&type=".$data['id']."\">".$data['type_title']."</a> (".$data['num'].")";
}
$list_types = join(" | ",$list_types);
if(isset($_GET['type'])) {
$result = query("SELECT `id` FROM `firms_types` WHERE `id`='".$_GET['type']."';");
if((mysql_num_rows($result)!=1) || $_GET['type']=='')
$type=1;
else
$type = $_GET['type'];
}
else
$type=1;
$list_firms = "";
$result = query("SELECT * FROM `firms` WHERE `type`=".$type." ORDER BY `title`;");
if(mysql_num_rows($result)==0)
$list_firms .= "Нет заведений данной категории";
while($data=mysql_fetch_array($result)) {
$list_firms .= "<a href=\"./?m=".$_GET['m']."&task=edit&id=".$data['id']."\">".$data['title']."</a> [<a href=\"./?m=".$_GET['m']."&task=comments&id=".$data['id']."\">отзывы</a>] [<a href=\"./?m=".$_GET['m']."&task=images&id=".$data['id']."\">изображения</a>]<br>\n";
}
$temp_html = preg_replace("/{%(\w+)%}/ee", "$\\1",skin_html("firms_list.htm",0));
skin_html_design($temp_html);
?>