/modules/structure/index.php

<? include "../../inc/header_m.php";?>
<?
if (!empty($structure_home))
	$home_parent=" and parent='$structure_home' ";
$searchinmodul=$_POST['searchinmodul'];
if (!empty($searchinmodul)){
	$searchinmodul=explode(' ', $searchinmodul);
	foreach ($searchinmodul as $key => $value) {
		$searchinmodules.="or UPPER(alias) LIKE '%".strtoupper($value)."%' ";
		$searchinmodules.="or UPPER(name) LIKE '%".strtoupper($value)."%' ";
		$searchinmodules.="or UPPER(menu_name) LIKE '%".strtoupper($value)."%' ";
		$searchinmodules.="or UPPER(anons) LIKE '%".strtoupper($value)."%' ";
		$searchinmodules.="or UPPER(text) LIKE '%".strtoupper($value)."%' ";
		$searchinmodules.="or UPPER(href) LIKE '%".strtoupper($value)."%' ";
		$searchinmodules.="or UPPER(title) LIKE '%".strtoupper($value)."%' ";
		$searchinmodules.="or UPPER(description) LIKE '%".strtoupper($value)."%' ";
	}
	$searchinmodules=' and ('.substr($searchinmodules, 2).')';
}

$del = $_POST['list'];
$sor = $_POST['sor'];
if (isset($del)) 
	foreach ($del as &$delv)
		{
		if ($delv>1) {
		if (!empty($structure_home) && $structure_home==$delv) die();
		if (mysql_num_rows(mysql_query("select * from {$pref}db_{$modul} where id={$delv} $home_parent limit 1"))>0) {

			$sql1="select * from {$pref}db_pic where id_type={$id_modules} and id_el={$delv} ";
			$query1=mysql_query($sql1);
			if ($query1 && mysql_num_rows($query1)>0)
				while ($res1=mysql_fetch_array($query1)) {
					$pic=$res1['pic'];
					unlink("{$_SERVER['DOCUMENT_ROOT']}/files/images/{$id_modules}/{$pic}");
					unlink("{$_SERVER['DOCUMENT_ROOT']}/files/images/{$id_modules}/mcith/mcith_{$pic}");
				}
			mysql_query("delete from {$pref}db_pic where id_type={$id_modules} and id_el={$delv}");
			mysql_query("delete from {$pref}db_{$modul} where id={$delv} $home_parent");
			mysql_query("delete from {$pref}db_structure_alias where id_page=$delv");
			}
		}}
if (isset($sor)) 
	foreach ($sor as $sork=>$sorv)
		{
		if (mysql_num_rows(mysql_query("select * from {$pref}db_{$modul} where id={$sork} $home_parent limit 1"))>0) {
		mysql_query("update {$pref}db_{$modul} set sort={$sorv} where id={$sork}");
		}}
if (isset($_GET['sort'])) $_SESSION['sort'] = $_GET['sort'];
if (isset($_SESSION['sort'])) $sort = $_SESSION['sort'];
if (strpos($mod_ver,substr($sort,0,2))===false)
$sort = 'sort,id';
mysql_query("delete from {$pref}db_{$modul} where status=-1");
$lim=30;
if (isset($_GET['p'])) $p=$_GET['p']; else {$p=1;$_GET['p']=1;}
$o=$p*$lim-$lim;

$query=mysql_query("select * from {$pref}db_{$modul} where 1=1 {$home_parent} {$searchinmodules} order by {$sort} limit $o,$lim");
$total=mysql_num_rows(mysql_query("select * from {$pref}db_{$modul} where 1=1 {$home_parent} {$searchinmodules}"));
$m_title="Структура";
$body="
<table class='tablesorter' cellspacing='0'>
	<thead> 
	<tr>
		<th>ID</th>
		<th>Название</th>
		<th>Шаблон</th>
		<th>Ссылка</th>
		<th>Сортировка</th>
		<th>Статус</th>
		<td>Удалить<input type='checkbox' class='selectdelete'></td>
	</tr>	
	</thead> 	
	<tbody> 
";
while ($res=mysql_fetch_array($query))
{
	if (empty($res['tpl'])) $res['tpl']='По умолчанию';
$body.="
	<tr>
		<td><a href='edit.materials.php?id_material={$res['id']}'>{$res['id']}</td>
		<td><a href='edit.materials.php?id_material={$res['id']}'>{$res['name']}</td>
		<td><a href='edit.materials.php?id_material={$res['id']}'>{$res['tpl']}</td>";
		if (empty($home_root))
		$body.="
		<td><a href='{$res['href']}' target='_blank'>".substr($res['href'],0,50)."...</td>";
		else
		$body.="
		<td><a href='".str_replace($home_root, '/', str_replace($home_root.'/', '/', $res['href']))."' target='_blank'>".substr(str_replace($home_root, '/', str_replace($home_root.'/', '/', $res['href'])),0,50)."...</td>";
		$body.="
		<td><span class='hid'>{$res['sort']}</span><input type='text' size='3' name='sor[{$res['id']}]' value='{$res['sort']}' /></td>
		<td><span class='hid'>{$res['status']}</span><a class='statmat' id='_{$modul}-{$res['id']}-{$res['status']}' >
		<img src='{$pt}/{$cmspatch}/templates/img/{$res['status']}.gif' /></td>
		<td>";
		if (!(!empty($structure_home) && $structure_home==$res['id']))
		$body.="<input type='checkbox' onclick='check();' name='list[]' class='listdelete' value='{$res['id']}' />";
		$body.="</td>
	</tr>";
}
$body.="
	</tbody> 
</table>
";
?>
<script>
$(document).ready(function(){
$('.modulForm').submit(function(){
	if (!confirm("Уверены, что хотите внести изменения?"))
		return false;
})
});
</script>
<form method='POST' acction='' class='modulForm' >
<? if (isset($_POST['sf'])){?><h4 class="alert_success">Сохранено</h4><?}?>

<article class="module width_full">
<header><h3 class="tabs_involved"><?=$m_title?></h3>
		<!-- <ul class="tabs">
   			<li><a href="#tab1">Список</a></li>
		</ul> -->
</header>
		<div class="tab_container">
			<div id="tab1" class="tab_content">

<?=$body?>
</div></div>
<footer>
				<div class="submit_link fl">
					<? paging_m($total,$lim,$p);?>
				</div>
				<div class="submit_link">
					<input type='submit' value='Сохранить' name='sf' />
				</div>
			</footer>
</article>
</form>

<? include "../../inc/footer_m.php"; ?>