не могу поменять права доступа код прилагается с об польз. на админа

<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 Nick Jones
| [url]http://www.php-fusion.co.uk[/url]/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit [url]http://gnu.org[/url]
+----------------------------------------------------+
| Modified by PHP-Fusion SF Group
| Copyright © 2007 by SF
| [url]http://www.rus-phpfusion.com[/url]/
+----------------------------------------------------*/

require_once "../maincore.php";
require_once BASEDIR."subheader.php";
require_once ADMIN."navigation.php";
include LOCALE.LOCALESET."admin/downloads.php";
//Проверка на возможность редактирования объявления. Админ, СуперАдмин.
if(isset($_GET['hotel_id'])){
$query = dbquery("SELECT hotel_prava FROM ".DB_PREFIX."downloads WHERE hotel_id = ".$_GET['hotel_id']);
$res = dbresult($query, 0);
} else {
    $res = 100;
    }
if ($userdata['user_level']<$res) {
 echo "У Вас не хватает прав для редактирования";
}else{
function zamena($cto,$zamenaemoya){
    global $db_prefix;
     $result = dbquery("UPDATE ".$db_prefix."downloads SET  hotel_position='65535' WHERE hotel_position='".$cto."'");
     $result = dbquery("UPDATE ".$db_prefix."downloads SET  hotel_position='".$cto."' WHERE hotel_position='".$zamenaemoya."'");
     $result = dbquery("UPDATE ".$db_prefix."downloads SET  hotel_position='".$zamenaemoya."' WHERE hotel_position='65535'");
}
function files ($cats_id = 0, $chort = ''){
    global $db_prefix, $download_cat_id, $locale503, $locale504, $locale505, $aidlink;
    if ($cats_id!=0){$chort.='-';}
    $result = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_idc='".$cats_id."' ORDER BY download_cat_id ASC");
    while ($data = dbarray($result)) {
        if (!isset($download_cat_id)) $download_cat_id = "";
        if ($data['download_cat_id'] == $download_cat_id) {
            echo "<tr>
            <td class='quote' colspan='2'><a href='".FUSION_SELF.$aidlink."&amp;download_cat_id=".$chort.$data['download_cat_id']."'>".$chort.$data['download_cat_name']."</a></td>
            </tr>\n";
            $result2 = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE hotel_gorod='".$data['download_cat_id']."' ORDER BY hotel_position ASC");
            if (dbrows($result2) != 0) {
                echo "<tr>
                <td colspan='2'>
                <table cellpadding='0' cellspacing='0' width='100%'>\n";
                while ($data2 = dbarray($result2)) {
                    if($data2['hotel_vid']==1)$videl="style='color:#FF0000;'"; else $videl="";
                    echo "<tr>\n<td class='tbl'><a href='".$settings['sitename']."/downloads.php?page_id=".$data2['hotel_id']."' target='_blank' $videl>".$data2['hotel_name']."</a></td>
                    <td align='right' width='200' class='tbl'>
                    <table width='95' cellpadding='0' cellspacing='0'><tr>
                    <td width='45'>
                    <a href='".FUSION_SELF.$aidlink."&step=edit&amp;download_cat_id=".$data['download_cat_id']."&amp;hotel_id=".$data2['hotel_id']."' $videl>".$locale503."</a> -
                    <a href='".FUSION_SELF.$aidlink."&step=delete&amp;download_cat_id=".$data['download_cat_id']."&amp;hotel_id=".$data2['hotel_id']."' onClick='return DeleteItem()' $videl>".$locale504."</a>
                    </td></tr></table>
                    </td>
                    </tr>\n";
                }
                echo "</table>
                </td>
                </tr>\n";
            }else{
                $result2 = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_idc='".$_GET['download_cat_id']."'");
                if(dbrows($result2) != 0){
                    $data2=dbarray($result2);
                    $popravka = "(";
                    $popravka .="hotel_gorod='".$data2['download_cat_id']."' ";
                    while($data2=dbarray($result2)){
                        $popravka.="OR hotel_gorod='".$data2['download_cat_id']."' ";
                    }
                    $popravka .=")";
                    $result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE $popravka ORDER BY hotel_position");
                    echo "<tr>
                    <td colspan='2'>
                    <table cellpadding='0' cellspacing='0' width='100%'>\n";
                    while ($data2 = dbarray($result)) {
                        if($data2['hotel_vid']==1)$videl="style='color:#FF0000;'"; else $videl="";
                        echo "<tr>\n<td class='tbl'><a href='".$settings['sitename']."/downloads.php?page_id=".$data2['hotel_id']."' target='_blank' $videl>".$data2['hotel_name']."</a></td>
                        <td align='right' width='200' class='tbl'>
                        <table width='95' cellpadding='0' cellspacing='0'><tr>
                        <td width='95'>
                        <form name='newroom' method='post' action='".FUSION_SELF.$aidlink."&amp;download_cat_id=".$_GET['download_cat_id']."&amp;position=".$data2['hotel_position']."' enctype='multipart/form-data'>
                        <input type='submit' name='vverh' value='В' class='button'>
                        <input type='text' name='pozizii' class='textbox' style='width:30px;'>
                        <input type='submit' name='vniz' value='Н' class='button'>
                        </form>\n
                        </td></tr></table>
                        </td>
                        </tr>\n";
                    }
                    echo "</table>
                    </td>
                    </tr>\n";
                }else{
                    echo "<tr>
                    <td class='quote' colspan='2'>Пусто</td>
                    </tr>\n";
                }
            }

        } else {
            echo "<tr>
            <td class='quote' colspan='2'><a href='".FUSION_SELF.$aidlink."&amp;download_cat_id=".$data['download_cat_id']."'>".$chort.$data['download_cat_name']."</a></td>
            </tr>\n";
        }

        files ($data['download_cat_id'], $chort);
    }
}

if (!checkrights("D") || !defined("iAUTH") || $aid != iAUTH) fallback("../index.php");
if (isset($hotel_id) && !isNum($hotel_id)) fallback(FUSION_SELF.$aidlink);
if (!isset($step)) $step = "";
$result = dbquery("SELECT * FROM ".$db_prefix."download_cats");
if (dbrows($result) != 0) {
        if ($step == "delete") {
            $result1 = dbquery("SELECT * FROM ".$db_prefix."room WHERE room_father='$hotel_id'");
            if(dbrows($result1)!=0){
                opentable('Сообщение');
                echo "<table align='center' cellpadding='0' cellspacing='0' width='450'><tr class='tbl'>
                <tr class='tbl'><td class='tbl' align='center'>Пержде чем удалить гостиницу, удалите все комнаты.</td></tr>
                </table>";
                closetable();
                tablebreak();
            }else{
                $data = dbarray(dbquery("SELECT * FROM ".$db_prefix."downloads WHERE hotel_id='".$hotel_id."'"));
                $photos = explode(",",$data['hotel_photos']);
                for ($n=0;$n<13;++$n) {
                    if($photos[$n]!=""){
                        unlink ("../images/".$photos[$n].".jpg");
                        unlink ("../images/".$photos[$n]."_s.jpg");
                    }
                }
                $result = dbquery("DELETE FROM ".$db_prefix."downloads WHERE hotel_id='$hotel_id'");
                dopPolya($hotel_id,2);
                redirect(FUSION_SELF.$aidlink."&download_cat_id=$download_cat_id");
            }
        }
        if (isset($_POST['save_hotel'])) {
            $hotel_name = $_POST['hotel_name'];
            if(!empty($_POST['public'])) { $public = 1; } else { $public = 0; } 
            $hotel_opisanie = addslashes($_POST['hotel_opisanie']);
            $hotel_opisanie_kr = addslashes($_POST['hotel_opisanie_kr']);
            $hotel_adres = addslashes($_POST['hotel_adres']);
            $hotel_gorod = $_POST['hotel_gorod'];
            $hotel_type = $_POST['hotel_type'];
            $hotel_pitanie = addslashes($_POST['hotel_pitanie']);
            $hotel_vid = $_POST['hotel_vid'];
            $hotel_primechania = addslashes($_POST['hotel_primechania']);
            $hotel_dopuslugi = addslashes($_POST['hotel_dopuslugi']);
            $hotel_sea = addslashes($_POST['hotel_sea']);
            $hotel_city = addslashes($_POST['hotel_city']);
            $hotel_avto = addslashes($_POST['hotel_avto']);
            $hotel_comments = ($_POST['hotel_comments'] == "yes" ? "1" : "");
            $hotel_ratings = ($_POST['hotel_ratings'] == "yes" ? "1" : "");
            $hotel_prava = $_POST['hotel_prava'];
            $hotel_kontakt_info = addslashes($_POST['hotel_kontakt_info']);
            $hotel_email = $_POST['hotel_email'];
            $hotel_hozain = $_POST['hotel_hozain'];
            $hotel_site = $_POST['hotel_site'];
            $hotel_rabotaet = $_POST['hotel_rabotaet'];
            $hotel_map_x = $_POST['hotel_map_x'];
            $hotel_map_y = $_POST['hotel_map_y'];
            $hotel_map_desc = $_POST['hotel_map_desc'];
            $hotel_men = $_POST['hotel_men'];
            $hotel_dopolnitelno = addslashes($_POST['hotel_dopolnitelno']);
            $esti1=false;
            if(!empty($_POST['price'])) { $price = 1; } else { $price = 0; } 
            $data = dbarray(dbquery("SELECT * FROM ".$db_prefix."downloads WHERE hotel_id='".$hotel_id."'"));
            $photos = explode(",",$data['hotel_photos']);
            for ($i=0;$i<13;++$i) {
                if($photos[$i]!=""){
                    $pos = strripos($photos[$i], "_");
                    $hotel_foto_name = substr($photos[$i],0,$pos);
                    break;
                }
            }
            if ($hotel_foto_name!=$_POST['hotel_foto_name']){
                for ($n=0;$n<13;++$n) {
                    if($photos[$n]!="") {
                        rename("../images/".$hotel_foto_name."_".$n.".jpg","../images/".$_POST['hotel_foto_name']."_".$n.".jpg");
                        rename("../images/".$hotel_foto_name."_".$n."_s.jpg","../images/".$_POST['hotel_foto_name']."_".$n."_s.jpg");
                        $photos[$n]=$_POST['hotel_foto_name']."_".$n;
                    }
                }
            }
            $hotel_photos="";
            for($n=0;$n<17;$n++){
                $image_ext = explode(".",$_FILES['file_'.$n]['name']);
                if (isset($_POST['foto_'.$n]) and $_POST['foto_'.$n]=="yes") {
                    unlink ("../images/".$photos[$n].".jpg");
                    unlink ("../images/".$photos[$n]."_s.jpg");
                    if($esti1)$hotel_photos .=",";
                }else{
                    if(!isset($_POST['foto_'.$n])){
                        if($_FILES['file_'.$n]['tmp_name']!=""  and in_array($image_ext[1],array("jpg","JPG","jpeg","JPEG"))){
                            $name = $_POST['hotel_foto_name']."_".$n;
                            if($esti1)$hotel_photos .=",";
                            $hotel_photos .= $name;
                            imgShtamp ($_FILES['file_'.$n]['tmp_name'],"../",$name);
                            if($n==0)glavImg ($_FILES['file_'.$n]['tmp_name'],"../",$name."_s"); else imgRamks ($_FILES['file_'.$n]['tmp_name'],"../",$name."_s");
                        }else{
                            if($esti1)$hotel_photos .=",";
                            $hotel_photos .=$photos[$n];
                        }
                    }else{
                        if($esti1)$hotel_photos .=",";
                        $hotel_photos .=$photos[$n];
                    }
                }
                $esti1 = true;
            }
            if ($step == "edit") {
                $hotel_date = ($_POST['update_datestamp']=="yes" ? "hotel_date='".time()."'," : "");
                 print $_POST['update_datestamp']."<br>";
                   $result = dbquery("UPDATE ".$db_prefix."downloads SET
                public = '".$public."',
                 hotel_name = '".$hotel_name."',
                hotel_opisanie = '".$hotel_opisanie."',
                hotel_opisanie_kr = '".$hotel_opisanie_kr."',
                hotel_adres = '".$hotel_adres."',
                hotel_gorod = '".$hotel_gorod."',
                ".$hotel_date."
                hotel_type = '".$hotel_type."',
                hotel_pitanie = '".$hotel_pitanie."',
                hotel_vid = '".$hotel_vid."',
                hotel_primechania = '".$hotel_primechania."',
                hotel_dopuslugi = '".$hotel_dopuslugi."',
                hotel_sea = '".$hotel_sea."',
                hotel_city = '".$hotel_city."',
                hotel_avto = '".$hotel_avto."',
                hotel_comments = '".$hotel_comments."',
                hotel_ratings = '".$hotel_ratings."',
                hotel_prava = '".$hotel_prava."',
                hotel_kontakt_info = '".$hotel_kontakt_info."',
                hotel_photos = '".$hotel_photos."',
                hotel_email = '".$hotel_email."',
                hotel_hozain = '".$hotel_hozain."',
                hotel_site = '".$hotel_site."',
                hotel_rabotaet = '".$hotel_rabotaet."',
                hotel_map_x = '".$hotel_map_x."',
                hotel_map_y = '".$hotel_map_y."',
                hotel_map_desc = '".$hotel_map_desc."',
                 hotel_men = '".$hotel_men."',
                 hotel_dopolnitelno = '".$hotel_dopolnitelno."',
                price = '".$price."'
                WHERE hotel_id='".$hotel_id."'");
                 dopPolya($hotel_id,1);
                //redirect(FUSION_SELF.$aidlink."&download_cat_id=$download_cat_id");
            } else {
                $result = dbquery("INSERT INTO ".$db_prefix."downloads VALUES('','$public','".$userdata['user_id']."','$hotel_name',
                '$hotel_opisanie' ,'$hotel_opisanie_kr' , '$hotel_adres' , '$hotel_gorod' ,'$hotel_type','$hotel_pitanie','$hotel_vid','$hotel_primechania' ,'$hotel_dopuslugi',
                '$hotel_sea','$hotel_city', '".time()."','$hotel_avto' ,'$hotel_comments' ,'$hotel_ratings' ,'$hotel_prava' ,'$hotel_kontakt_info' ,'".$settings['hotel_chet']."',
                '$hotel_photos', '$hotel_email','$hotel_hozain' ,'$hotel_site','$hotel_rabotaet','$hotel_map_x','$hotel_map_y','$hotel_map_desc','$hotel_men','$hotel_dopolnitelno', '$price')");
                $hotel_schet = $settings['hotel_chet']+1;
                $result = dbquery("UPDATE ".$db_prefix."settings SET hotel_chet='$hotel_schet'");
                //redirect(FUSION_SELF.$aidlink."&download_cat_id=$download_cat");
            }
        }

        if ($step == "edit") {
             $result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE hotel_id='$hotel_id'");
             $data = dbarray($result);
             $hotel_name = $data['hotel_name'];
             $hotel_opisanie = stripslashes($data['hotel_opisanie']);
             $hotel_opisanie_kr = stripslashes($data['hotel_opisanie_kr']);
             $hotel_adres = stripslashes($data['hotel_adres']);
             $hotel_gorod = $data['hotel_gorod'];
             $hotel_type = $data['hotel_type'];
             $hotel_pitanie = stripslashes($data['hotel_pitanie']);
             $hotel_vid = $data['hotel_vid'];
             $hotel_primechania = stripslashes($data['hotel_primechania']);
             $hotel_dopuslugi = stripslashes($data['hotel_dopuslugi']);
             $hotel_sea = stripslashes($data['hotel_sea']);
             $hotel_city = stripslashes($data['hotel_city']);
             $hotel_avto = stripslashes($data['hotel_avto']);
             $hotel_comments = ($data['hotel_comments'] == "1" ? " checked" : "");
             $hotel_ratings = ($data['hotel_ratings'] == "1" ? " checked" : "");
             $hotel_prava = $data['hotel_prava'];
             $hotel_kontakt_info = stripslashes($data['hotel_kontakt_info']);
             $hotel_position = $data['hotel_position'];
             $hotel_photos = explode(",",$data['hotel_photos']);
             $test = $data['hotel_photos'];
             $hotel_email = $data['hotel_email'];
             $hotel_hozain = $data['hotel_hozain'];
             $hotel_site = $data['hotel_site'];
             $hotel_rabotaet = $data['hotel_rabotaet'];
             $hotel_map_x = $data['hotel_map_x'];
             $hotel_map_y = $data['hotel_map_y'];
             $hotel_map_desc = $data['hotel_map_desc'];
             $hotel_men = $data['hotel_men'];
             $public = $data['public'];
             $hotel_dopolnitelno = stripslashes($data['hotel_dopolnitelno']);
             $price = $data['price'];
             for ($i=0;$i<13;++$i) {
                 if($hotel_photos[$i]!=""){
                     $pos = strripos($hotel_photos[$i], "_");
                     $hotel_foto_name = substr($hotel_photos[$i],0,$pos);
                     break;
                 }
             }
             $formaction = FUSION_SELF.$aidlink."&step=edit&amp;download_cat_id=$download_cat_id&amp;hotel_id=$hotel_id";
             opentable($locale['470']);
        } else {
            $hotel_name = "";
            $hotel_opisanie = "";
            $hotel_opisanie_kr = "";
            $hotel_adres = "";
            $hotel_gorod = "";
            $hotel_type = "";
            $hotel_pitanie = "";
            $hotel_vid = "";
            $hotel_primechania = "";
            $hotel_dopuslugi = "";
            $hotel_sea = "";
            $hotel_city = "";
            $hotel_avto = "";
            $hotel_comments = "";
            $hotel_ratings = "";
            $hotel_prava = "";
            $hotel_kontakt_info = "";
            $hotel_position = "";
            $hotel_photos = "";
            $hotel_email = "";
            $hotel_hozain = "";
            $hotel_site = "";
            $hotel_rabotaet = "";
            $hotel_map_x = "";
            $hotel_map_y = "";
            $hotel_map_desc = "";
            $hotel_foto_name = "";
            $hotel_men = "";
            $hotel_dopolnitelno = "";
            $hotel_public = "";
            $price = "0";
            $formaction = FUSION_SELF.$aidlink;
            opentable($locale['471']);
        }
        $editlist = ""; $sel = "";
    $d_cat = @$data['hotel_gorod'];
function catSelect($cats_id = 0, $chort = ''){
    global $db_prefix, $editlist, $sel, $d_cat, $step ;
    if ($cats_id!=0){$chort.='-';}
    $result2 = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_idc='".$cats_id."' ORDER BY download_cat_id ASC");
    while ($data2 = dbarray($result2)) {
          if ($step == "edit") $sel = ($d_cat == $data2['download_cat_id'] ? " selected" : "");
          $editlist .= "<option value='".$data2['download_cat_id']."'$sel>$chort ".$data2['download_cat_name']."</option>\n";
          catSelect($data2['download_cat_id'], $chort);
    }
}
$user_groups = getusergroups(); $access_opts = ""; $sel = "";
        while(list($key, $user_group) = each($user_groups)){
                $sel = ($download_access == $user_group['0'] ? " selected" : "");
                $access_opts .= "<option value='".$user_group['0']."'$sel>".$user_group['1']."</option>\n";
        }
catSelect();
        echo "<form name='inputform' method='post' action='$formaction' enctype='multipart/form-data'>
<table align='center' cellpadding='0' cellspacing='0' width='460'>
<tr><td width='80' class='tbl'>Название отеля:</td></tr>
<tr><td class='tbl'><textarea name='hotel_name' rows='1' cols='100' class='textbox'>".$hotel_name."</textarea></td></tr>
<tr><td nowrap valign='top' width='80' class='tbl'>Краткое описание:</td></tr>
<tr><td class='tbl'><textarea name='hotel_opisanie_kr' rows='5' cols='100' class='textbox'>".$hotel_opisanie_kr."</textarea></td></tr>
<tr><td nowrap valign='top' width='80' class='tbl'>".$locale['005d']."</td></tr>
<tr><td class='tbl'><textarea name='hotel_opisanie' rows='25' cols='100' class='textbox'>".$hotel_opisanie."</textarea></td></tr>
<tr><td width='80'>
Расcтояние до моря: <select name='hotel_sea' class='textbox' style='width:160px;'>";
spisokVremya($hotel_sea);
echo "</select>
Расcтояние до города: <select name='hotel_city' class='textbox' style='width:160px;'>";
spisokVremya($hotel_city);
echo "</select>";
if (!empty($price)) { $price = " checked"; } else { $price = ""; }
echo "<p><strong>Цены</strong> <input type=\"checkbox\" name=\"price\"".$price."></p>
</td></tr>
<tr><td width='80' class='tbl'>Питание:</td></tr>
<tr><td class='tbl'><textarea name='hotel_pitanie' rows='5' cols='100' class='textbox'>".$hotel_pitanie."</textarea></td></tr>
<tr><td width='80' class='tbl'>Автостоянка:</td></tr>
<tr><td class='tbl'><textarea name='hotel_avto' rows='1' cols='100' class='textbox'>".$hotel_avto."</textarea></td><tr>
<tr><td width='80' class='tbl'>Контактная информация:</td></tr>
<tr><td class='tbl'><textarea name='hotel_kontakt_info' rows='1' cols='100' class='textbox'>".$hotel_kontakt_info."</textarea></td></tr>
<tr><td width='80' class='tbl'>Адрес:</td></tr>
<tr><td class='tbl'><textarea name='hotel_adres' rows='1' cols='100' class='textbox'>".$hotel_adres."</textarea></td></tr>
<tr><td width='80' class='tbl'>Тип места:<select name='hotel_type' class='textbox' style='width:350px;'>";
spisokType($hotel_type);
echo"</select></td>
</tr>
<tr><td width='80' class='tbl'>Город:<select name='hotel_gorod' class='textbox' style='width:350px;'>$editlist</select></td></tr>
<tr>
<td width='80' class='tbl' style='white-space:nowrap'>Доступ:<select name='hotel_prava' class='textbox' style='width:350px;'>$access_opts</select></td></tr>
<tr><td width='80' class='tbl' style='white-space:nowrap'>Выделение:<select name='hotel_vid' class='textbox' style='width:350px;'>";
if($hotel_vid==0){
        $select="selected";
        $add="*";
}else{
        $select="";
        $add="";
}
echo "<option value='0' $select>".$add."Нет</option>";
if($hotel_vid==1){
        $select="selected";
        $add="*";
    }else{
        $select="";
        $add="";
}
echo "<option value='1' $select>".$add."Выделено</option></select></td></tr>
<tr><td width='80' class='tbl' style='white-space:nowrap'>Менеджер:<select name='hotel_men' class='textbox' style='width:350px;'>";
if($hotel_men==0){$select="selected";$add="*";}else{$select="";$add="";}
echo "<option value='0' $select>".$add."Нет</option>";
if($hotel_men==1){$select="selected";$add="*";}else{$select="";$add="";}
echo "<option value='1' $select>".$add."Анна Сергеевна</option>";
if($hotel_men==2){$select="selected";$add="*";}else{$select="";$add="";}
echo "<option value='2' $select>".$add."Лариса Кириченко</option>";
if($hotel_men==3){$select="selected";$add="*";}else{$select="";$add="";}
echo "<option value='3' $select>".$add."МАС</option>";
if($hotel_men==4){$select="selected";$add="*";}else{$select="";$add="";}
echo "<option value='4' $select>".$add."Татьяна Алексеевна</option>";
if($hotel_men==5){$select="selected";$add="*";}else{$select="";$add="";}
echo "<option value='5' $select>".$add."Юля Мякишева</option>";
if($hotel_men==6){$select="selected";$add="*";}else{$select="";$add="";}
echo "<option value='6' $select>".$add."Наталья Торжинская</option>";
if($hotel_men==7){$select="selected";$add="*";}else{$select="";$add="";}
echo "<option value='7' $select>".$add."Некто</option>";
if($hotel_men==8){$select="selected";$add="*";}else{$select="";$add="";}
echo "<option value='8' $select>".$add."Некто</option></select></td></tr>
<tr><td class='tbl'>
<input type='checkbox' name='hotel_comments' value='yes' $hotel_comments>Разрешить отзывы:<br>
<input type='checkbox' name='hotel_ratings' value='yes' $hotel_ratings> ".$locale['424D']."</td></tr>

<tr><td class='tbl'>Дополнительные услуги:</td></tr>
<tr><td class='tbl'><textarea name='hotel_dopuslugi' rows='15' cols='100' class='textbox'>".$hotel_dopuslugi."</textarea></td></tr>
<tr><td class='tbl'>Примечания:</td></tr>
<tr><td class='tbl'><textarea name='hotel_primechania' rows='5' cols='100' class='textbox'>".$hotel_primechania."</textarea></td></tr>
<tr><td class='tbl'>Префикс фотографий:</td></tr>
<tr><td class='tbl'><input type='text' name='hotel_foto_name' value='$hotel_foto_name' class='textbox' style='width:380px;'></td></tr>
<tr>
<td class='tbl'>
Главное фото:";if($hotel_photos[0]!="")echo "Удалить?<input type='checkbox' name='foto_0' value='yes'><br><img src='../images/".$hotel_photos[0]."_s.jpg'>";echo"<input type='file' name='file_0'>";
echo "
<table width='100%'>
<tr><td>Фото 1:";if($hotel_photos[1]!="")echo "Удалить?<input type='checkbox' name='foto_1' value='yes'><br><img src='../images/".$hotel_photos[1]."_s.jpg'>";echo "<input type='file' name='file_1'></td><td>Фото 5:";if($hotel_photos[5]!="")echo "Удалить?<input type='checkbox' name='foto_5' value='yes'><br><img src='../images/".$hotel_photos[5]."_s.jpg'>";echo "<input type='file' name='file_5'></td><td>Фото 9:";if($hotel_photos[9]!="")echo "Удалить?<input type='checkbox' name='foto_9' value='yes'><br><img src='../images/".$hotel_photos[9]."_s.jpg'>";echo "<input type='file' name='file_9'></td></tr>
<tr><td>Фото 2:";if($hotel_photos[2]!="")echo "Удалить?<input type='checkbox' name='foto_2' value='yes'><br><img src='../images/".$hotel_photos[2]."_s.jpg'>";echo "<input type='file' name='file_2'></td><td>Фото 6:";if($hotel_photos[6]!="")echo "Удалить?<input type='checkbox' name='foto_6' value='yes'><br><img src='../images/".$hotel_photos[6]."_s.jpg'>";echo "<input type='file' name='file_6'></td><td>Фото 10:";if($hotel_photos[10]!="")echo "Удалить?<input type='checkbox' name='foto_10' value='yes'><br><img src='../images/".$hotel_photos[10]."_s.jpg'>";echo "<input type='file' name='file_10'></td></tr>
<tr><td>Фото 3:";if($hotel_photos[3]!="")echo "Удалить?<input type='checkbox' name='foto_3' value='yes'><br><img src='../images/".$hotel_photos[3]."_s.jpg'>";echo "<input type='file' name='file_3'></td><td>Фото 7:";if($hotel_photos[7]!="")echo "Удалить?<input type='checkbox' name='foto_7' value='yes'><br><img src='../images/".$hotel_photos[7]."_s.jpg'>";echo "<input type='file' name='file_7'></td><td>Фото 11:";if($hotel_photos[11]!="")echo "Удалить?<input type='checkbox' name='foto_11' value='yes'><br><img src='../images/".$hotel_photos[11]."_s.jpg'>";echo "<input type='file' name='file_11'></td></tr>
<tr><td>Фото 4:";if($hotel_photos[4]!="")echo "Удалить?<input type='checkbox' name='foto_4' value='yes'><br><img src='../images/".$hotel_photos[4]."_s.jpg'>";echo "<input type='file' name='file_4'></td><td>Фото 8:";if($hotel_photos[8]!="")echo "Удалить?<input type='checkbox' name='foto_8' value='yes'><br><img src='../images/".$hotel_photos[8]."_s.jpg'>";echo "<input type='file' name='file_8'></td><td>Фото 12:";if($hotel_photos[12]!="")echo "Удалить?<input type='checkbox' name='foto_12' value='yes'><br><img src='../images/".$hotel_photos[12]."_s.jpg'>";echo "<input type='file' name='file_12'></td></tr>
</table></td>
</tr>
<tr><td>Координаты на карте:<br></td></tr>
<tr>
<td><input type='text' name='hotel_map_x' value='$hotel_map_x' id='coord_x' class='textbox' style='width:150px;'>
<input type='text' name='hotel_map_y' value='$hotel_map_y' id='coord_y' class='textbox' style='width:150px;'></td>
</tr>
<tr>
<td width='80' class='tbl'>
Карта:<script type='text/javascript' language='javascript' src='map.js'></script>
<select name='hotel_map_desc' class='textbox' onChange='show_map(this)'>
<option value='none'>---\n";
$result3 = dbquery("SELECT * FROM ".$db_prefix."maps");
$coordArray="";
while ($data3 = dbarray($result3)) {
    echo "<option value='".$data3['maps_id']."'";
    if($hotel_map_desc==$data3['maps_id'])echo " selected";
    echo ">".$data3['maps_name']."\n";
    $coordArray.="coordArrayX['".$data3['maps_id']."']=".$data3['maps_x'].";coordArrayY['".$data3['maps_id']."']=".$data3['maps_y'].";";
}
echo "</select><div id='pole' style='display:none;'>&nbsp;</div>
<script type='text/javascript' language='javascript'>
var coordArrayX = new Array();
var coordArrayY = new Array();".$coordArray;
echo "</script></td>
</tr>
<tr>
<td width='80' class='tbl'>E-mail:<input type='text' name='hotel_email' value='$hotel_email' class='textbox' style='width:580px;'></td>
</tr>
<tr>
<td width='80' class='tbl'>Хозяин:<input type='text' name='hotel_hozain' value='$hotel_hozain' class='textbox' style='width:580px;'></td>
</tr>
<tr>
<td width='80' class='tbl'>Сайт:<input type='text' name='hotel_site' value='$hotel_site' class='textbox' style='width:580px;'></td>
</tr>
<tr>
<td width='80' class='tbl' style='white-space:nowrap'>Работает:
<select name='hotel_rabotaet' class='textbox' style='width:150px;'>";
if($hotel_rabotaet==0){
        $select="selected";
        $add="*";
    }else{
        $select="";
        $add="";
}
echo "<option value='0' $select>".$add."Сезон</option>";
if($hotel_rabotaet==1){
        $select="selected";
        $add="*";
    }else{
        $select="";
        $add="";
}
if($public==1) { $check = " checked"; } else { $check = ""; }
echo "<option value='1' $select>".$add."Круглый год</option></select></td></tr>
<tr><td class='tbl'>Занести в базу но скрыть от посетителей это объявление <input type=\"checkbox\" name=\"public\"".$check."></td></tr>
<tr><td class='tbl'>Информация не для глаз:</td></tr>
<tr><td class='tbl'><textarea name='hotel_dopolnitelno' rows='15' cols='100' class='textbox'>".$hotel_dopolnitelno."</textarea></td></tr>
<tr>
<td align='center' class='tbl'>";
        if ($step == "edit") echo "<input type='checkbox' name='update_datestamp' value='yes'> ".$locale['489']."<br><br>\n";
        echo "<input type='submit' name='save_hotel' value='".$locale['488']."' class='button'></td>
</tr>
</table>
</form>\n";
if ($step=="edit") {
    echo "<form name='newroom' method='post' action='".FUSION_SELF.$aidlink."&amp;download_cat_id=".$hotel_gorod."&amp;position=".$hotel_position."' enctype='multipart/form-data'>
    Редактирование позиции: <input type='submit' name='vverh' value='В' class='button'>
    <input type='text' name='pozizii' class='textbox' style='width:30px;'>
    <input type='submit' name='vniz' value='Н' class='button'>
    </form>\n<br>
    <form name='newroom' method='post' action='$formaction' enctype='multipart/form-data'>
    <input type='text' name='kol_room' class='textbox' style='width:30px;'>
    <input type='submit' name='dalee' value='Выдать формы' class='button'>
    </form>";
}
closetable();
tablebreak();
if($_GET['delete_room_id']){
    $data = dbarray(dbquery("SELECT * FROM ".$db_prefix."room WHERE room_id='".$_GET['delete_room_id']."'"));
    $photos = explode(",",$data['room_cook']);
    for ($n=0;$n<4;++$n) {
        if($photos[$n]!=""){
            unlink ("../images/".$photos[$n].".jpg");
            unlink ("../images/".$photos[$n]."_s.jpg");
        }
    }
    $result = dbquery("DELETE FROM ".$db_prefix."room WHERE room_id='".$_GET['delete_room_id']."'");
    opentable('Сообщение');
    echo "<table align='center' cellpadding='0' cellspacing='0' width='450'><tr class='tbl'>
    <tr class='tbl'><td class='tbl' align='center'>Комната удалена</td></tr>
    </table>";
    closetable();
    tablebreak();
}
$vivod="";
if(isset($_POST['new_room'])){
    for($i=1;$i<=$_POST['kol_room'];++$i) {
       $tv = isset($_POST['room_udob_tv_'.$i]) ? "1" : "0";
       $cond = isset($_POST['room_udob_cond_'.$i]) ? "1" : "0";
       $refr = isset($_POST['room_udob_refr_'.$i]) ? "1" : "0";
       $phone = isset($_POST['room_udob_phone_'.$i]) ? "1" : "0";
       $soul = isset($_POST['room_udob_soul_'.$i]) ? "1" : "0";
       $safe = isset($_POST['room_udob_safe_'.$i]) ? "1" : "0";
       $vent = isset($_POST['room_udob_vent_'.$i]) ? "1" : "0";
       $room_room_cenaza = $_POST['room_cenaza_'.$i];
       $room_number = $_POST['room_number_'.$i];
       $moneu = explode("/",$_POST['room_moneu_'.$i]);
       $prise = "";
       for ($k=0;$k<(sizeof($moneu)-1);++$k) {
               $vremya = explode(";",$moneu[$k]);
               $period = explode("-",$vremya[0]);
               $prise .= kolDnei($period[0])."-".kolDnei($period[1]).";".$vremya[1]."/";
       }
       $room_udob = $tv.";".$cond.";".$refr.";".$phone.";".$soul.";".$safe.";".$vent.";".$room_room_cenaza;
       if ($_POST['room_id_'.$i] != ""){
               //--------
            $esti1=false;
            $data = dbarray(dbquery("SELECT * FROM ".$db_prefix."room WHERE room_id='".$_POST['room_id_'.$i]."'"));
            $photos = array ("","","","");
            $photos = explode(",",$data['room_cook']);
            for ($n=0;$n<4;++$n) {
                if($photos[$n]!=""){
                    $pos = strripos($photos[$n], "_");
                    $room_foto_name = substr($photos[$n],0,$pos);
                    break;
                }
            }
            if ($room_foto_name!=$_POST['room_foto_name_'.$i]){
                for ($n=1;$n<5;++$n) {
                    if($photos[$n-1]!="") {
                        rename("../images/".$room_foto_name."_".$n.".jpg","../images/".$_POST['room_foto_name_'.$i]."_".$n.".jpg");
                        rename("../images/".$room_foto_name."_".$n."_s.jpg","../images/".$_POST['room_foto_name_'.$i]."_".$n."_s.jpg");
                        $photos[$n-1]=$_POST['room_foto_name_'.$i]."_".$n;
                    }
                }
            }
            $room_photos="";
            for($n=1;$n<9;$n++){
                $image_ext = explode(".",$_FILES['file_'.$n.'_'.$i]['name']);
                if (isset($_POST['foto_'.$n.'_'.$i]) and $_POST['foto_'.$n.'_'.$i]=="yes") {
                    unlink ("../images/".$photos[$n-1].".jpg");
                    unlink ("../images/".$photos[$n-1]."_s.jpg");
                    if($esti1)$room_photos .=",";
                   }else{
                       if(!isset($_POST['foto_'.$n.'_'.$i])){
                        if($_FILES['file_'.$n.'_'.$i]['tmp_name']!=""  and in_array($image_ext[1],array("jpg","JPG","jpeg","JPEG"))){
                            $name = $_POST['room_foto_name_'.$i]."_".$n;
                            if($esti1)$room_photos .=",";
                            $room_photos .= $name;
                            imgShtamp ($_FILES['file_'.$n.'_'.$i]['tmp_name'],"../",$name);
                            imgRamks ($_FILES['file_'.$n.'_'.$i]['tmp_name'],"../",$name."_s");

                        }else{
                            if($esti1)$room_photos .=",";
                            $room_photos .=$photos[$n-1];
                        }
                    }else{
                        if($esti1)$room_photos .=",";
                        $room_photos .=$photos[$n-1];
                    }
                }
                $esti1 = true;
            }
            //--------
            $result = dbquery("UPDATE ".$db_prefix."room SET room_title='".$_POST['room_title_'.$i]."', room_plase='".$_POST['room_plase_'.$i]."', room_room='".$_POST['room_room_'.$i]."' , room_cook ='".$room_photos."', room_san ='".$_POST['room_san_'.$i]."', room_mebel='".$_POST['room_mebel_'.$i]."', room_udob='".$room_udob."',room_dis ='".$_POST['room_dis_'.$i]."', room_moneu='".$prise."', room_number='".$room_number."' WHERE room_id='".$_POST['room_id_'.$i]."'");
            $vivod .= "Комната отредактирована<br>";
       } else {
               $esti1=false;
               $room_photos="";
               $photos = array ("","","","");
            for($n=1;$n<9;$n++){
                $image_ext = explode(".",$_FILES['file_'.$n.'_'.$i]['name']);".$hotel_dopolnitelno."
                   if(!isset($_POST['foto_'.$n.'_'.$i])){
                    if($_FILES['file_'.$n.'_'.$i]['tmp_name']!=""  and in_array($image_ext[1],array("jpg","JPG","jpeg","JPEG"))){
                        $name = $_POST['room_foto_name_'.$i]."_".$n;
                        if($esti1)$room_photos .=",";
                        $room_photos .= $name;
                        imgShtamp ($_FILES['file_'.$n.'_'.$i]['tmp_name'],"../",$name);
                        imgRamks ($_FILES['file_'.$n.'_'.$i]['tmp_name'],"../",$name."_s");

                    }else{
                        if($esti1)$room_photos .=",";
                        $room_photos .=$photos[$n-1];
                    }
                }else{
                    if($esti1)$room_photos .=",";
                    $room_photos .=$photos[$n-1];
                }
                $esti1 = true;
            }
            $result = dbquery("INSERT INTO ".$db_prefix."room VALUES('','".$_POST['room_title_'.$i]."','".$_POST['down_id']."','".$_POST['room_plase_'.$i]."','".$_POST['room_room_'.$i]."','".$room_photos."','".$_POST['room_san_'.$i]."','".$_POST['room_mebel_'.$i]."','".$room_udob."','".$_POST['room_dis_'.$i]."','".$prise."','".$_POST['room_number_'.$i]."')");
            $vivod .= $room_photos."<br>Комната создана<br>";
       }
    }
    dopPolya($_POST['down_id'],1);
    opentable('Сообщение');
    echo "<table align='center' cellpadding='0' cellspacing='0' width='450'><tr class='tbl'>
    <tr class='tbl'><td class='tbl' align='center'>$vivod</td></tr>
    </table>";
    closetable();
    tablebreak();
}
if($hotel_id) {
    $resuel = dbquery("SELECT * FROM ".$db_prefix."room WHERE room_father='".$hotel_id."'");
    $komnati = dbrows($resuel);
    echo "<script type='text/javascript' language='javascript' src='admin.js'></script>
    <table style='position:fixed;bottom:1px;left:1px;background-color:#0CFF74;display:block;cursor:pointer;' id='pokazat'><tr><td onClick='pokazTablizi(0)'>Показать таблицу</td></tr></table>
    <table style='position:fixed;bottom:1px;left:1px;background-color:#FFFFFF;display:none;' id='skrit'>
    <tr><td colspan='4' style='background-color:#0CFF74;cursor:pointer;' align='center' onClick='pokazTablizi(1)'>Скрыть</td></tr>
    <tr>";
    $koldneiVmes = array(31,28,31,30,31,30,31,31,30,31,30,31);
    $nazVmes = array("Январь","Февраль","Март","Апрель","Май","Июнь","Июль","Август","Сентябрь","Октябрь","Ноябрь","Декабрь");
    for ($s=0,$den=1;$s<12;++$s) {
           echo "<td><table border='1' cellpadding='0' cellspacing='0'>".$nazVmes[$s];
           for ($k=0;$k<7;++$k,++$den) {
               echo "<tr>";
               echo "<td id='d".$den."' onClick='vibor(this)'>".($k+1)."</td><td id='d".($den+7)."' onClick='vibor(this)'>".($k+8)."</td><td id='d".($den+14)."' onClick='vibor(this)'>".($k+15)."</td><td id='d".($den+21)."' onClick='vibor(this)'>".($k+22)."</td>";
               if ($k+29<=$koldneiVmes[$s]){echo "<td id='d".($den+28)."' onClick='vibor(this)'>".($k+29)."</td>";}
               echo "</tr>\n";
           }
           echo "</table></td>";
           if($s==3 or $s==7)echo "</tr><tr>";
           $den-=7;
           $den+=$koldneiVmes[$s];
    }
    echo "</tr></table>";
    opentable('Форма создания/редатирования комнаты');
    $kolKomnat=$komnati+$_POST['kol_room'];
    echo "<form name='newroom' method='post' action='".FUSION_SELF.$aidlink."&amp;download_cat_id=$download_cat_id' enctype='multipart/form-data'>
    <table align='center' cellpadding='0' cellspacing='0' width='450'>";
    for($i=1;$i<=$kolKomnat;++$i) {
        if($i<=$komnati){
            $Rdata = dbarray($resuel);
            $room_id = $Rdata['room_id'];
            $room_title = $Rdata['room_title'];
            $room_dis = $Rdata['room_dis'];
            $room_plase = $Rdata['room_plase'];
            $room_room = $Rdata['room_room'];
            $room_san = $Rdata['room_san'];
            $room_mebel = $Rdata['room_mebel'];
            $room_number = $Rdata['room_number'];
            $moneu = explode("/",$Rdata['room_moneu']);
            $room_moneu = "";
            for ($k=0;$k<(sizeof($moneu)-1);++$k) {
                $period = explode(";",$moneu[$k]);
                $chisla = explode("-",$period[0]);
                $room_moneu .= kolMesaz($chisla[0])."-".kolMesaz($chisla[1]).";".$period[1]."/";
            }
            //$room_moneu = $Rdata['room_moneu'];
            $udob  = explode(";",$Rdata['room_udob']);
            $room_udob_tv = ($udob['0'] == "1" ? " checked" : "");
            $room_udob_cond = ($udob['1'] == "1" ? " checked" : "");
            $room_udob_refr = ($udob['2'] == "1" ? " checked" : "");
            $room_udob_phone = ($udob['3'] == "1" ? " checked" : "");
            $room_udob_soul = ($udob['4'] == "1" ? " checked" : "");
            $room_udob_safe = ($udob['5'] == "1" ? " checked" : "");
            $room_udob_vent = ($udob['6'] == "1" ? " checked" : "");
            $room_cenaza = $udob['7'];
            $room_cook = explode(",",$Rdata['room_cook']);
            for ($j=0;$j<12;++$j) {
                if($room_cook[$j]!=""){
                    $pos = strripos($room_cook[$j], "_");
                    $room_foto_name = substr($room_cook[$j],0,$pos);
                    break;
                }
            }
        }else{
            $room_id = "";
            $room_title = "";
            $room_dis = "";
            $room_plase = "";
            $room_room = "";
            $room_san = "";
            $room_mebel = "";
            $room_udob = "";
            $room_cook = "";
            $room_moneu = "";
            $room_udob_tv = "";
            $room_udob_cond = "";
            $room_udob_refr = "";
            $room_udob_phone = "";
            $room_udob_soul = "";
            $room_udob_safe = "";
            $room_udob_vent = "";
            $room_foto_name = "";
            $room_cenaza = "";
            $room_number = "";
        }
        echo "
        <tr><td width='80' class='tbl'>Название:</td></tr>
        <tr><td class='tbl'><input type='text' name='room_title_$i' value='$room_title' class='textbox' style='width:580px;'></td></tr>
        <tr><td nowrap valign='top' width='80' class='tbl'>Описание:</td></tr>
        <tr><td class='tbl'><textarea name='room_dis_$i'  rows='8' cols='100' class='textbox'>$room_dis</textarea></td></tr>
        <tr><td width='80' class='tbl'>Спальные места:<select name='room_plase_$i' class='textbox' style='width:40px;'>";
        kolVchislah($room_plase);
        echo "</select></td></tr>
        <tr><td width='80' class='tbl'>Количество комнат:<select name='room_room_$i' class='textbox' style='width:40px;'>";
        kolVchislah($room_room);
        echo "</select></td></tr>
        <tr><td width='80' class='tbl'>Количество номеров этой категории:</td></tr>
        <tr><td class='tbl'><input type='text' name='room_number_$i' class='textbox' style='width:472px;' value='$room_number'></td></tr>
        <tr><td width='80' class='tbl'>Мебель:</td></tr>
        <tr><td class='tbl'><textarea name='room_san_$i' rows='2' cols='100' class='textbox'>$room_san</textarea></td></tr>
        <tr><td width='80' class='tbl'>Дополнительно:</td></tr>
        <tr><td class='tbl'><textarea name='room_mebel_$i' rows='2' cols='100' class='textbox'>$room_mebel</textarea></td></tr>
        <tr><td width='80' class='tbl'>
        <table><tr>
        <td><img src='../images/tv.gif' align='left'>:<input type='checkbox' name='room_udob_tv_$i' value='yes' $room_udob_tv></td>
        <td><img src='../images/cond.gif' align='left'>:<input type='checkbox' name='room_udob_cond_$i' value='yes' $room_udob_cond></td>
        <td><img src='../images/refr.gif' align='left'>:<input type='checkbox' name='room_udob_refr_$i' value='yes' $room_udob_refr></td>
        <td><img src='../images/phone.gif' align='left'>:<input type='checkbox' name='room_udob_phone_$i' value='yes' $room_udob_phone></td>
        <td><img src='../images/soul.gif' align='left'>:<input type='checkbox' name='room_udob_soul_$i' value='yes' $room_udob_soul></td>
        <td><img src='../images/safe.gif' align='left'>:<input type='checkbox' name='room_udob_safe_$i' value='yes' $room_udob_safe></td>
        <td><img src='../images/vent.gif' align='left'>:<input type='checkbox' name='room_udob_vent_$i' value='yes' $room_udob_vent></td>
        </tr></table>
        </td>
        </tr>
        <tr><td width='80' class='tbl'>Префикс фотографий:</td></tr>
        <tr><td class='tbl'><input type='text' name='room_foto_name_$i' value='$room_foto_name' class='textbox' style='width:380px;'></td></tr>
        <tr><td width='80' class='tbl'>Изображения:</td></tr>
        <tr><td class='tbl'>
        <table width='100%'>
        <tr><td>Фото 1:";if($room_cook[0]!="")echo "Удалить?<input type='checkbox' name='foto_1_".$i."' value='yes'><br><img src='../images/".$room_cook[0]."_s.jpg'>";echo "<input type='file' name='file_1_".$i."'></td><td>Фото 3:";if($room_cook[2]!="")echo "Удалить?<input type='checkbox' name='foto_3_".$i."' value='yes'><br><img src='../images/".$room_cook[2]."_s.jpg'>";echo "<input type='file' name='file_3_".$i."'></td></tr>
        <tr><td>Фото 2:";if($room_cook[1]!="")echo "Удалить?<input type='checkbox' name='foto_2_".$i."' value='yes'><br><img src='../images/".$room_cook[1]."_s.jpg'>";echo "<input type='file' name='file_2_".$i."'></td><td>Фото 4:";if($room_cook[3]!="")echo "Удалить?<input type='checkbox' name='foto_4_".$i."' value='yes'><br><img src='../images/".$room_cook[3]."_s.jpg'>";echo "<input type='file' name='file_4_".$i."'></td></tr>
        </table></td>
        </tr>
        <tr><td class='tbl'>
        <textarea name='room_moneu_$i' id='room_moneu_$i' rows='3' cols='100' class='textbox'>$room_moneu</textarea><br>
        Цена: <input type='text' name='room_zena_$i' id='room_zena_$i' class='textbox' style='width:80px;'><table width='100' heihgt='20' bgcolor='#FFD800'><tr><td onClick='dobav(".$i.")' align='center' style='cursor:pointer;'>Добавить</td></tr></table></td></tr>
        <tr><td class='tbl'><input type=hidden name='room_id_$i' value='".$room_id."'>Цена за:<select name='room_cenaza_$i' class='textbox' style='width:180px;'>";
        if($room_cenaza==1)echo "<option value='1' selected>*Номер"; else echo "<option value='1'>Номер";
        if($room_cenaza==2)echo "<option value='2' selected>*Койку"; else echo "<option value='2'>Койку";
        echo "</select></tr>
        <tr>
        <td align='center' class='tbl'>";
        if($room_id!="") {
        echo "<a href='".FUSION_SELF.$aidlink."&amp;delete_room_id=".$room_id."'>Удалить</a>";
        }
        echo"<br>----------------------------------------------------------------------------------</td>
        </tr>
        <tr><td><br><br></td></tr>";
      }
    echo "<tr>
    <td align='center' class='tbl'><input type=hidden name='kol_room' value='".$kolKomnat."'>
    <input type=hidden name='down_id' value='".$_GET['hotel_id']."'>
    <input type='submit' name='new_room' value='Выполнить' class='button'></td>
    </tr>
    </table></form>";
    closetable();
    tablebreak();
}
if(isset($_POST['vverh'])){
    $result2 = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE hotel_gorod='".$_GET['download_cat_id']."'");
    if(dbrows($result2) == 0){
        $result2 = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_idc='".$_GET['download_cat_id']."'");
        $data2=dbarray($result2);
        $popravka = "(";
        $popravka .="hotel_gorod='".$data2['download_cat_id']."' ";
        while($data2=dbarray($result2)){
            $popravka.="OR hotel_gorod='".$data2['download_cat_id']."' ";
        }
        $popravka .=")";
    }else{
        $popravka = "hotel_gorod='".$_GET['download_cat_id']."'";
    }
    $result4 = dbquery("SELECT hotel_position FROM ".$db_prefix."downloads WHERE $popravka ORDER BY hotel_position DESC");
    while ($data4 = dbarray($result4)) {
        if($data4['hotel_position']==$_GET['position']) {
            $position = $_GET['position'];
            for($i=0;$data4 = dbarray($result4) and $i<$_POST['pozizii'];++$i){
                zamena($data4['hotel_position'],$position);
                $position = $data4['hotel_position'];
            }
            break;
        }
    }
}elseif(isset($_POST['vniz'])){
    $result2 = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE hotel_gorod='".$_GET['download_cat_id']."'");
    if(dbrows($result2) == 0){
        $result2 = dbquery("SELECT * FROM ".$db_prefix."download_cats WHERE download_cat_idc='".$_GET['download_cat_id']."'");
        $data2=dbarray($result2);
        $popravka = "(";
        $popravka .="hotel_gorod='".$data2['download_cat_id']."' ";
        while($data2=dbarray($result2)){
            $popravka.="OR hotel_gorod='".$data2['download_cat_id']."' ";
        }
        $popravka .=")";
    }else{
        $popravka = "hotel_gorod='".$_GET['download_cat_id']."'";
    }
    $position = $_GET['position'];
    for($n=0;$n<$_POST['pozizii'];$n++){
        $result4 = dbquery("SELECT hotel_position FROM ".$db_prefix."downloads WHERE $popravka ORDER BY hotel_position ASC");
        while($data4 = dbarray($result4)){
            if($position==$data4['hotel_position']){
                if($data4 = dbarray($result4)){
                    zamena($position,$data4['hotel_position']);
                     $position = $data4['hotel_position'];
                     break;
                 }
            }
        }
    }
}
opentable($locale['500']);
echo "<table align='center' cellpadding='0' cellspacing='0' width='400'>\n";
$locale503 = $locale['503']; $locale504 = $locale['504'];
$locale505 = $locale['505'];

$result = dbquery("SELECT * FROM ".$db_prefix."download_cats ORDER BY download_cat_id");
if (dbrows($result) != 0) {
    echo "<tr>
    <td class='tbl2'>".$locale['501']."</td>
    <td align='right' class='tbl2'>".$locale['502']."</td>
    </tr>
    <tr>
    <td colspan='2' height='1'></td>
    </tr>\n";
    files();
    echo "</table>\n";
} else {
    echo "<tr>
    <td align='center'><br>
    ".$locale['506']."<br><br>
    <a href='download_cats.php".$aidlink."'>".$locale['507']."<br><br></td>
    </tr>
    </table>\n";
}
closetable();
} else {
    opentable($locale['500']);
    echo "<center>".$locale['508']."<br>
    ".$locale['509']."<br><br>
    <a href='download_cats.php".$aidlink."'>".$locale['510']."</a>".$locale['511']."</center>\n";
    closetable();
}
}
echo "</td>\n";
require_once BASEDIR."footer.php";
?>