/modules/forum/index.php
PHP | 278 lines | 270 code | 7 blank | 1 comment | 30 complexity | 2b76abd0810d31703f52339dcafb4a94 MD5 | raw file
- <? include "../../inc/header_m.php";?>
- <?
- $searchinmodul=$_POST['searchinmodul'];
- if (!empty($searchinmodul)){
- $searchinmodul=explode(' ', $searchinmodul);
- foreach ($searchinmodul as $key => $value) {
- $searchinmodules.="or UPPER(title) LIKE '%".strtoupper($value)."%' ";
- $searchinmodules.="or UPPER(text) LIKE '%".strtoupper($value)."%' ";
- }
- $searchinmodules=' ('.substr($searchinmodules, 2).') and ';
- }
- mysql_query("delete from {$pref}db_{$modul}_cat where status=-1");
- mysql_query("delete from {$pref}db_{$modul}_th where status=-1");
- mysql_query("delete from {$pref}db_{$modul} where status=-1");
- $back_link=getenv("HTTP_REFERER");
- if (!$back_link){
- $back = '';
- }
- else{
- $back = '<a href="'.$back_link.'">Вернуться назад</a>';
- }
- $back = '<article class="breadcrumbs"><a href="index.php">Корень</a>';
- if (!empty($_GET['id_cat'])){
- $sql= mysql_query("select * from {$pref}db_{$modul}_cat where id='{$_GET['id_cat']}'");
- $inf=mysql_fetch_array($sql);
- $back .= '<div class="breadcrumb_divider"></div><a href="index.php?id_cat='.$_GET['id_cat'].'">'.$inf['name'].'</a>';
- }
- if (!empty($_GET['id_th'])){
- $sql= mysql_query("select * from {$pref}db_{$modul}_cat where id='{$_GET['id_th']}'");
- $inf=mysql_fetch_array($sql);
- $sql1= mysql_query("select * from {$pref}db_{$modul}_cat where id='{$inf['pid']}'");
- $inf1=mysql_fetch_array($sql1);
- $back .= '<div class="breadcrumb_divider"></div><a href="index.php?id_cat='.$inf1['id'].'">'.$inf1['name'].'</a>';
- $back .= '<div class="breadcrumb_divider"></div><a href="index.php?id_th='.$_GET['id_th'].'">'.$inf['name'].'</a>';
- }
- if (!empty($_GET['id_material'])){
- $sql= mysql_query("select * from {$pref}db_{$modul}_th where id='{$_GET['id_material']}'");
- $inf=mysql_fetch_array($sql);
- $sql1= mysql_query("select * from {$pref}db_{$modul}_cat where id='{$inf['pid']}'");
- $inf1=mysql_fetch_array($sql1);
- $sql2= mysql_query("select * from {$pref}db_{$modul}_cat where id='{$inf1['pid']}'");
- $inf2=mysql_fetch_array($sql2);
- $back .= '<div class="breadcrumb_divider"></div><a href="index.php?id_cat='.$inf2['id'].'">'.$inf2['name'].'</a>';
- $back .= '<div class="breadcrumb_divider"></div><a href="index.php?id_th='.$inf1['id'].'">'.$inf1['name'].'</a>';
- $back .= '<div class="breadcrumb_divider"></div><a href="index.php?id_material='.$_GET['id_material'].'">'.$inf['name'].'</a>';
- }
- $back.='</article> ';
- $del = $_POST['list'];
- $sor = $_POST['sor'];
- $del2 = $_POST['list2'];
- $sor2 = $_POST['sor2'];
- $del3 = $_POST['list3'];
- $sor3 = $_POST['sor3'];
- if (isset($del))
- foreach ($del as &$delv)
- {
- mysql_query("delete from {$pref}db_{$modul}_cat where id={$delv}");
- // mysql_query("delete from {$pref}db_gallery where pid={$delv}");
- }
- if (isset($sor))
- foreach ($sor as $sork=>$sorv)
- {
- mysql_query("update {$pref}db_{$modul}_cat set sort={$sorv} where id={$sork}");
- }
- if (isset($del2))
- foreach ($del2 as &$delv2)
- {
- mysql_query("delete from {$pref}db_{$modul}_th where id={$delv2}");
- }
- if (isset($sor2))
- foreach ($sor2 as $sork2=>$sorv2)
- {
- mysql_query("update {$pref}db_{$modul}_th set sort={$sorv2} where id={$sork2}");
- }
- if (isset($del3))
- foreach ($del3 as &$delv3)
- {
- mysql_query("delete from {$pref}db_{$modul} where id={$delv3}");
- }
- if (isset($sor3))
- foreach ($sor3 as $sork3=>$sorv3)
- {
- mysql_query("update {$pref}db_{$modul} set sort={$sorv3} where id={$sork3}");
- }
- 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_gallery_cat where status=-1");
- mysql_query("delete from {$pref}db_gallery where status=-1");
- $lim=30;
- if (isset($_GET['p'])) $p=$_GET['p']; else {$p=1;$_GET['p']=1;}
- $start=$p*$lim-$lim;
- if (isset($_GET['id_material'])||isset($_POST['id_material'])){
- if (!empty($_GET['id_material'])) $id =$_GET['id_material'];
- if (!empty($_POST['id_material'])) $id =$_POST['id_material'];
- $query=mysql_query("select * from {$pref}db_{$modul} where {$searchinmodules} pid='{$id}' order by {$sort} limit $start,$lim");
- $total=mysql_num_rows(mysql_query("select * from {$pref}db_{$modul} where {$searchinmodules} pid='{$id}' "));
- $m_title="Сообщения";
- $body="
- <table class='tablesorter' cellspacing='0'>
- <thead>
- <tr>
- <th>ID</th>
- <th>Текст</th>
- <th>Сортировка</th>
- <th>Статус</th>
- <td>Удалить<input type='checkbox' class='selectdelete'></td>
- </tr>
- </thead>
- <tbody>
- ";
- while ($res=mysql_fetch_array($query)){
- $text = strip_tags(mb_substr($res['text'], 0,50),' ');
- $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']}'>{$text}</td>
- <td><span class='hid'>{$res['sort']}</span><input type='text' size='3' name='sor3[{$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><input type='checkbox' onclick='check();' name='list3[]' class='listdelete' value='{$res['id']}' /></td>
- </tr>";
- }
- $body.="
- </tbody>
- </table>
- ";
- }
- elseif (isset($_GET['id_th'])||isset($_POST['id_th'])){
- if (!empty($_GET['id_th'])) $id_th =$_GET['id_th'];
- if (!empty($_POST['id_th'])) $id_th =$_POST['id_th'];
- $query=mysql_query("select * from {$pref}db_{$modul}_th where pid='{$id_th}' order by {$sort} limit $start,$lim");
- $total=mysql_num_rows(mysql_query("select * from {$pref}db_{$modul}_th where pid='{$id_th}' "));
- $m_title="Темы";
- $body="
- <table class='tablesorter' cellspacing='0'>
- <thead>
- <tr>
- <th>ID</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)){
- $body.="
- <tr>
- <td><a href='index.php?id_material={$res['id']}'>{$res['id']}</td>
- <td><a href='index.php?id_material={$res['id']}'>{$res['name']}</td>
- <td><span class='hid'>{$res['sort']}</span><input type='text' size='3' name='sor2[{$res['id']}]' value='{$res['sort']}' /></td>
- <td><span class='hid'>{$res['status']}</span><a class='statmat' id='_{$modul}_th-{$res['id']}-{$res['status']}' >
- <img src='{$pt}/{$cmspatch}/templates/img/{$res['status']}.gif' /></td>
- <td><a href='edit.th.php?id_material={$res['id']}'><img src='{$pt}{$tpl_admin}/images/icn_edit.png' /></td>
- <td><input type='checkbox' onclick='check();' name='list2[]' class='listdelete' value='{$res['id']}' /></td>
- </tr>";
- }
- $body.="
- </tbody>
- </table>
- ";
- }
- elseif (isset($_GET['id_cat'])||isset($_POST['id_cat'])){
- if (!empty($_GET['id_cat'])) $id_cat =$_GET['id_cat'];
- if (!empty($_POST['id_cat'])) $id_cat =$_POST['id_cat'];
- $query=mysql_query("select * from {$pref}db_{$modul}_cat where pid='{$id_cat}' order by {$sort} limit $start,$lim");
- $total=mysql_num_rows(mysql_query("select * from {$pref}db_{$modul}_cat where pid='{$id_cat}' "));
- $m_title="Форумы";
- $body="
- <table class='tablesorter' cellspacing='0'>
- <thead>
- <tr>
- <th>ID</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)){
- $body.="
- <tr>
- <td><a href='index.php?id_th={$res['id']}'>{$res['id']}</td>
- <td><a href='index.php?id_th={$res['id']}'>{$res['name']}</td>
- <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}_cat-{$res['id']}-{$res['status']}' >
- <img src='{$pt}/{$cmspatch}/templates/img/{$res['status']}.gif' /></td>
- <td><a href='edit.cat.php?id_material={$res['id']}'><img src='{$pt}{$tpl_admin}/images/icn_edit.png' /></td>
- <td><input type='checkbox' onclick='check();' name='list[]' class='listdelete' value='{$res['id']}' /></td>
- </tr>";
- }
- $body.="
- </tbody>
- </table>
- ";
- }
- else {
- $query=mysql_query("select * from {$pref}db_{$modul}_cat where pid=0 order by {$sort} limit $start,$lim");
- $total=mysql_num_rows(mysql_query("select * from {$pref}db_{$modul}_cat where pid=0 "));
- $m_title="Категории";
- $body="
- <table class='tablesorter' cellspacing='0'>
- <thead>
- <tr>
- <th>ID</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)){
- $body.="
- <tr>
- <td><a href='index.php?id_cat={$res['id']}'>{$res['id']}</td>
- <td><a href='index.php?id_cat={$res['id']}'>{$res['name']}</td>
- <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}_cat-{$res['id']}-{$res['status']}' >
- <img src='{$pt}/{$cmspatch}/templates/img/{$res['status']}.gif' /></td>
- <td><a href='edit.cat.php?id_material={$res['id']}'><img src='{$pt}{$tpl_admin}/images/icn_edit.png' /></td>
- <td><input type='checkbox' onclick='check();' name='list[]' class='listdelete' value='{$res['id']}' /></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><?}?>
- <?=$back?>
- <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"; ?>