battles/vxod.php
Igor Barkov (iwork) 3502904656 Рефакторинг, очистка, работа над ошибками, связанными с базой, отказ от глобальной переменной $user во многих файлах.
Singleton в некоторых местах вместо решения #42.
Новые шаги для решения #16 и #52.
Closes #42.
Closes #32.
Closes #31.
2022-01-27 01:15:33 +02:00

300 lines
27 KiB
PHP
Raw Permalink Blame History

This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

<?php
use Battles\Template;
use Battles\User;
require_once "functions.php";
if (User::getInstance()->getLevel() < 4 && User::getInstance()->getLevel() > 10) {
header('location: main.php?act=none');
exit;
}
if (User::getInstance()->getRoom() == 403) {
header('Location: canalizaciya.php');
exit;
}
Template::header('Вход в водосток');
?>
<style>
legend {
padding: 0.2em 0.5em;
color: #A52A2A;
FONT-WEIGHT: bold;
}
body {
background-image: url('i/canal.jpg');
background-repeat: no-repeat;
background-position: top right;
}
</style>
<div id=hint4 class=ahint></div>
<TABLE width=100%>
<TR>
<TD valign=top width=100%>
<center><h3>Вход в водосток</h3></center>
<?
$select = mysql_query("SELECT `time` FROM `visit_podzem` WHERE `login`='" . $user['login'] . "' and `time`>'0'");
if ($el = mysql_fetch_array($select)) {
$wait_sec = $el["time"];
$new_t = time();
$left_time = $wait_sec - $new_t;
$left_hour = floor(($left_time / 60) / 60);
$left_min = floor($left_time / 60);
$left_sec = $left_time - $left_min * 60;
$left_min = ($left_min - $left_hour * 60);
if ($wait_sec > $new_t) {
print "<span style='font-size: 11px;'><span style='font-size:12px; color: #009; font-style: italic;'>До следующего входа осталось</span>:
<span style='color:#990000'>$left_hour</span> ч. <span style='color:#990000'>$left_min</span> мин. <span style='color:#990000'>$left_sec</span> сек.</span><br>";
} else {
mysql_query("DELETE FROM visit_podzem WHERE login='" . $user['login'] . "'");
print "<script>location.href='main.php?act=none'</script>";
exit();
}
} else {
$login = $user['login'];
$ya = mysql_query("SELECT `login` FROM `vxodd` WHERE `login` = '$login' LIMIT 1");
$wawe = 0;
if ($daw = mysql_fetch_array($ya)) {
$wawe = 1;
}
$naw = mysql_query("SELECT `login` FROM `vxod` WHERE `login` = '$login' LIMIT 1");
$nawe = 0;
if ($ser = mysql_fetch_array($naw)) {
$nawe = 1;
}
$rt = mysql_query("select id,level from users where login='$login'");
$est = mysql_fetch_array($rt);
$user_id = $est["id"];
$user_lvl = $est["level"];
if ($wawe == 0) {
echo "<FORM id='REQUEST'>
<FIELDSET style='padding-left: 5px; width=50%; color:#000000;'>
<LEGEND><B> Группа </B> </LEGEND>
Комментарий <INPUT style=\"font-size:12px;\" TYPE=text NAME=cmt maxlength=40 size=40><BR>
Пароль&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <INPUT style=\"font-size:12px;\" TYPE=password NAME=pass maxlength=6 size=40><BR>
<INPUT style='font-size:12px;' TYPE=submit name=open value='Создать группу'>&nbsp;<BR>
</FIELDSET>
</FORM>";
} else {
print"<FORM id='REQUEST'>
<FIELDSET style='padding-left: 5px; width=50%'>
<LEGEND><B> Группа </B> </LEGEND>";
if ($nawe == 1) {
echo "<INPUT style=\"font-size:12px;\" type='submit' name='start' value='Начать'> &nbsp;";
}
echo "<INPUT style=\"font-size:12px;\" type='submit' name='del' value='Покинуть группу'>
</FIELDSET>
</FORM>";
}
if ($_GET['warning'] == 1) {
print"<span style='color:#CC0000'>&nbsp;Вы покинули группу</span>";
}
if ($_GET['warning'] == 2) {
print"<span style='color:#CC0000'>&nbsp;Увы! Не угадали пароль!</span>";
}
if ($_GET['warning'] == 3) {
print"<span style='color:#CC0000'>&nbsp;Вы подали заявку! Отзавите!</span>";
}
if ($_GET['warning'] == 4) {
print"<span style='color:#CC0000'>&nbsp;Вы уже в группе!</span>";
}
if ($_GET['warning'] == 5) {
print"<span style='color:#CC0000'>&nbsp;Группа уже собранна!</span>";
}
print"<TABLE cellpadding=1 cellspacing=0>";
$i = 0;
$Q = mysql_query("SELECT * FROM vxod");
while ($DATA = mysql_fetch_array($Q)) {
$cr = $DATA["glav_id"];
$z_login[$i] = $DATA["login"];
$date[$i] = $DATA["date"];
$comment[$i] = $DATA["comment"];
$password[$i] = $DATA["pass"];
$mine_z[$i] = 0;
$Q2 = mysql_query("SELECT glav_id FROM vxodd WHERE glav_id='$cr'");
$t1_all[$i] = 0;
while ($DATAS = mysql_fetch_array($Q2)) {
$t1_all[$i]++;
}
$creator[$i] = $DATA["glav_id"];
$i++;
}
for ($n = 0; $n < $i; $n++) {
echo "<FORM id='REQUEST'><TR><TD><span class=date>$date[$n]</span>&nbsp;";
$QUER = mysql_query("SELECT login,lvl FROM vxodd WHERE glav_id='$creator[$n]' ORDER BY id ASC");
while ($DATAS = mysql_fetch_array($QUER)) {
$p1 = $DATAS["login"];
$p_login = $DATAS["login"];
$p_lvl = $DATAS["lvl"];
if ($p1 != "") {
$p1 = "<b>$p1</b> [$p_lvl]<a href='inf.php?login=$p1' target='_blank'><img src='i/inf.gif' border=0></a> ";
if ($t1_all[$n] == 1) {
echo "&nbsp;$p1";
} else {
echo "&nbsp;$p1,";
}
}
}
if (!empty($comment[$n])) {
print"| $comment[$n]";
}
if ($wawe == '0') {
if (!empty($password[$n])) {
echo "<input name='naw_pass' type='hidden' value='$password[$n]'><INPUT type='password' name='pass' size=5> ";
}
echo "<input style=\"font-size:12px;\" name='naw_id' type='hidden' value='$creator[$n]'>
<INPUT style='font-size:12px;' TYPE=submit name=add value='Присоед.'>";
}
echo "</TD></TR></FORM>";
}/////////закрытие
?>
<TR>
<TD></TD>
</TR>
<TR height=1>
<TD height=1 bgcolor=#A0A0A0 colspan=2><SPAN></SPAN></TD>
</TR>
</TABLE>
<?php
///////////////Подача заявки////////////////////
if ($_GET['open']) {
$der = mysql_query("SELECT glav_id FROM vxodd WHERE login='" . $user['login'] . "'");
if ($deras = mysql_fetch_array($der)) {
print "<script>location.href='?warning=4'</script>";
exit;
}
$time = date("H:i");
$SQL2 = mysql_query("INSERT INTO vxod(date,login,glav_id,comment,pass) VALUES('$time','$login','$user_id','" . $_GET['cmt'] . "','" . $_GET['pass'] . "')");
$SQL2 = mysql_query("INSERT INTO vxodd(login,glav_id,lvl) VALUES('$login','$user_id','$user_lvl')");
if ($SQL2) {
print "<script>location.href='main.php?act=none'</script>";
exit;
} else {
print"Ошибка!!! Сообщите администратору!";
}
}
//////////////Удаление заявки//////////////////////
if ($_GET['del']) {
$e = mysql_query("DELETE FROM vxod WHERE login='$login'");
$es = mysql_query("DELETE FROM vxodd WHERE glav_id='$user_id'");
$ed = mysql_query("DELETE FROM vxodd WHERE login='$login'");
if ($e) {
print "<script>location.href='?warning=1'</script>";
exit;
} else {
print"Ошибка!!! Сообщите администратору!";
}
}
/////////////Присоединится///////////////
if ($_GET['add']) {
$der = mysql_query("SELECT glav_id,id FROM vxodd WHERE login='" . $user['login'] . "'");
if ($deras = mysql_fetch_array($der)) {
print "<script>location.href='?warning=4'</script>";
exit;
}
$den = mysql_query("SELECT id FROM vxodd WHERE glav_id='" . $_GET['naw_id'] . "'");
if (mysql_num_rows($den) >= 4) {
print "<script>location.href='?warning=5'</script>";
exit;
}
if ($_GET['pass'] == $_GET['naw_pass']) {
$rt = mysql_query("select level from users where login='$login'");
$est = mysql_fetch_array($rt);
$s = mysql_query("INSERT INTO vxodd(login,glav_id,lvl) VALUES('$login','" . $_GET['naw_id'] . "','" . $est["level"] . "')");
if ($s) {
print "<script>location.href='?act=none'</script>";
exit;
} else {
print"Ошибка!!! Сообщите администратору!";
}
} else {
print "<script>location.href='?warning=2'</script>";
exit;
}
}
//////////////////Начинаем////////////////////
if ($_GET['start']) {
$zax = mysql_query("select login from vxodd where glav_id='" . $user['id'] . "'");
while ($nana = mysql_fetch_array($zax)) {
$n_login = $nana["login"];
$rty = mysql_query("select id,level,login from users where login='$n_login'");
$esth = mysql_fetch_array($rty);
$est_id = $esth["id"];
$est_login = $esth["login"];
//Время до следующего визита
$vremya = 3600 * 6 + time();
mysql_query('insert into visit_podzem (login,time) values("' . $n_login . '","' . $vremya . '")');
$vrem = 120 * 60 + time();
mysql_query('insert into labirint(user_id, login, location, vector, glav_id, glava, t, l,key1,key2,key3,el,name,visit_time) values("' . $est_id . '", "' . $est_login . '", "16", "0", "' . $user['id'] . '", "' . $user['login'] . '","226","453","99","96","92","47","Канализация 1 этаж","' . $vrem . '")');
mysql_query("UPDATE `users`,`online` SET `users`.`room` = '403',`online`.`room` = '403' WHERE `online`.`id` = `users`.`id` AND `online`.`id` = '" . $esth["id"] . "' ;");
}
$ferrr = mysql_query("SELECT * FROM podzem3 WHERE glava='default' and name='Канализация 1 этаж'");
$retr = mysql_fetch_array($ferrr);
mysql_query('insert into podzem3(glava,name,n1,n2,n3,n4,n5,n6,n7,n8,n9,n11,n12,n13,n14,n15,n16,n17,n18,n19,n21,n22,n23,n24,n25,n26,n27,n28,n29,n31,n32,n33,n34,n35,n36,n37,n38,n39,n41,n42,n43,n44,n45,n46,n47,n48,n49,n51,n52,n53,n54,n55,n56,n57,n58,n59,n61,n62,n63,n64,n65,n66,n67,n68,n69,n71,n72,n73,n74,n75,n76,n77,n78,n79,n81,n82,n83,n84,n85,n86,n87,n88,n89,n91,n92,n93,n94,n95,n96,n97,n98,n99,sunduk1,sunduk2,sunduk3,sunduk4,sunduk5,sunduk6,sunduk7)
values("' . $login . '","Канализация 1 этаж","' . $retr["n1"] . '","' . $retr["n2"] . '","' . $retr["n3"] . '","' . $retr["n4"] . '","' . $retr["n5"] . '","' . $retr["n6"] . '","' . $retr["n7"] . '","' . $retr["n8"] . '","' . $retr["n9"] . '","' . $retr["n11"] . '","' . $retr["n12"] . '","' . $retr["n13"] . '","' . $retr["n14"] . '","' . $retr["n15"] . '","' . $retr["n16"] . '","' . $retr["n17"] . '","' . $retr["n18"] . '","' . $retr["n19"] . '","' . $retr["n21"] . '","' . $retr["n22"] . '","' . $retr["n23"] . '","' . $retr["n24"] . '","' . $retr["n25"] . '","' . $retr["n26"] . '","' . $retr["n27"] . '","' . $retr["n28"] . '","' . $retr["n29"] . '","' . $retr["n31"] . '","' . $retr["n32"] . '","' . $retr["n33"] . '","' . $retr["n34"] . '","' . $retr["n35"] . '","' . $retr["n36"] . '","' . $retr["n37"] . '","' . $retr["n38"] . '","' . $retr["n39"] . '","' . $retr["n41"] . '","' . $retr["n42"] . '","' . $retr["n43"] . '","' . $retr["n44"] . '","' . $retr["n45"] . '","' . $retr["n46"] . '","' . $retr["n47"] . '","' . $retr["n48"] . '","' . $retr["n49"] . '","' . $retr["n51"] . '","' . $retr["n52"] . '","' . $retr["n53"] . '","' . $retr["n54"] . '","' . $retr["n55"] . '","' . $retr["n56"] . '","' . $retr["n57"] . '","' . $retr["n58"] . '","' . $retr["n59"] . '","' . $retr["n61"] . '","' . $retr["n62"] . '","' . $retr["n63"] . '","' . $retr["n64"] . '","' . $retr["n65"] . '","' . $retr["n66"] . '","' . $retr["n67"] . '","' . $retr["n68"] . '","' . $retr["n69"] . '","' . $retr["n71"] . '","' . $retr["n72"] . '","' . $retr["n73"] . '","' . $retr["n74"] . '","' . $retr["n75"] . '","' . $retr["n76"] . '","' . $retr["n77"] . '","' . $retr["n78"] . '","' . $retr["n79"] . '","' . $retr["n81"] . '","' . $retr["n82"] . '","' . $retr["n83"] . '","' . $retr["n84"] . '","' . $retr["n85"] . '","' . $retr["n86"] . '","' . $retr["n87"] . '","' . $retr["n88"] . '","' . $retr["n89"] . '","' . $retr["n91"] . '","' . $retr["n92"] . '","' . $retr["n93"] . '","' . $retr["n94"] . '","' . $retr["n95"] . '","' . $retr["n96"] . '","' . $retr["n97"] . '","' . $retr["n98"] . '","' . $retr["n99"] . '","' . $retr["sunduk1"] . '","' . $retr["sunduk2"] . '","' . $retr["sunduk3"] . '","' . $retr["sunduk4"] . '","' . $retr["sunduk5"] . '","' . $retr["sunduk6"] . '","' . $retr["sunduk7"] . '")');
$ferrr = mysql_query("SELECT * FROM podzem3 WHERE glava='default' and name='Канализация 2 этаж'");
$retr = mysql_fetch_array($ferrr);
mysql_query('insert into podzem3(glava,name,n1,n2,n3,n4,n5,n6,n7,n8,n9,n11,n12,n13,n14,n15,n16,n17,n18,n19,n21,n22,n23,n24,n25,n26,n27,n28,n29,n31,n32,n33,n34,n35,n36,n37,n38,n39,n41,n42,n43,n44,n45,n46,n47,n48,n49,n51,n52,n53,n54,n55,n56,n57,n58,n59,n61,n62,n63,n64,n65,n66,n67,n68,n69,n71,n72,n73,n74,n75,n76,n77,n78,n79,n81,n82,n83,n84,n85,n86,n87,n88,n89,n91,n92,n93,n94,n95,n96,n97,n98,n99,sunduk1,sunduk2,sunduk3,sunduk4,sunduk5,sunduk6,sunduk7)
values("' . $login . '","Канализация 2 этаж","' . $retr["n1"] . '","' . $retr["n2"] . '","' . $retr["n3"] . '","' . $retr["n4"] . '","' . $retr["n5"] . '","' . $retr["n6"] . '","' . $retr["n7"] . '","' . $retr["n8"] . '","' . $retr["n9"] . '","' . $retr["n11"] . '","' . $retr["n12"] . '","' . $retr["n13"] . '","' . $retr["n14"] . '","' . $retr["n15"] . '","' . $retr["n16"] . '","' . $retr["n17"] . '","' . $retr["n18"] . '","' . $retr["n19"] . '","' . $retr["n21"] . '","' . $retr["n22"] . '","' . $retr["n23"] . '","' . $retr["n24"] . '","' . $retr["n25"] . '","' . $retr["n26"] . '","' . $retr["n27"] . '","' . $retr["n28"] . '","' . $retr["n29"] . '","' . $retr["n31"] . '","' . $retr["n32"] . '","' . $retr["n33"] . '","' . $retr["n34"] . '","' . $retr["n35"] . '","' . $retr["n36"] . '","' . $retr["n37"] . '","' . $retr["n38"] . '","' . $retr["n39"] . '","' . $retr["n41"] . '","' . $retr["n42"] . '","' . $retr["n43"] . '","' . $retr["n44"] . '","' . $retr["n45"] . '","' . $retr["n46"] . '","' . $retr["n47"] . '","' . $retr["n48"] . '","' . $retr["n49"] . '","' . $retr["n51"] . '","' . $retr["n52"] . '","' . $retr["n53"] . '","' . $retr["n54"] . '","' . $retr["n55"] . '","' . $retr["n56"] . '","' . $retr["n57"] . '","' . $retr["n58"] . '","' . $retr["n59"] . '","' . $retr["n61"] . '","' . $retr["n62"] . '","' . $retr["n63"] . '","' . $retr["n64"] . '","' . $retr["n65"] . '","' . $retr["n66"] . '","' . $retr["n67"] . '","' . $retr["n68"] . '","' . $retr["n69"] . '","' . $retr["n71"] . '","' . $retr["n72"] . '","' . $retr["n73"] . '","' . $retr["n74"] . '","' . $retr["n75"] . '","' . $retr["n76"] . '","' . $retr["n77"] . '","' . $retr["n78"] . '","' . $retr["n79"] . '","' . $retr["n81"] . '","' . $retr["n82"] . '","' . $retr["n83"] . '","' . $retr["n84"] . '","' . $retr["n85"] . '","' . $retr["n86"] . '","' . $retr["n87"] . '","' . $retr["n88"] . '","' . $retr["n89"] . '","' . $retr["n91"] . '","' . $retr["n92"] . '","' . $retr["n93"] . '","' . $retr["n94"] . '","' . $retr["n95"] . '","' . $retr["n96"] . '","' . $retr["n97"] . '","' . $retr["n98"] . '","' . $retr["n99"] . '","' . $retr["sunduk1"] . '","' . $retr["sunduk2"] . '","' . $retr["sunduk3"] . '","' . $retr["sunduk4"] . '","' . $retr["sunduk5"] . '","' . $retr["sunduk6"] . '","' . $retr["sunduk7"] . '")');
$ferrr = mysql_query("SELECT * FROM podzem4 WHERE glava='default' and name='Канализация 1 этаж'");
$retr = mysql_fetch_array($ferrr);
mysql_query('insert into podzem4(glava,name,n1,n2,n3,n4,n5,n6,n7,n8,n9,n11,n12,n13,n14,n15,n16,n17,n18,n19,n21,n22,n23,n24,n25,n26,n27,n28,n29,n31,n32,n33,n34,n35,n36,n37,n38,n39,n41,n42,n43,n44,n45,n46,n47,n48,n49,n51,n52,n53,n54,n55,n56,n57,n58,n59,n61,n62,n63,n64,n65,n66,n67,n68,n69,n71,n72,n73,n74,n75,n76,n77,n78,n79,n81,n82,n83,n84,n85,n86,n87,n88,n89,n91,n92,n93,n94,n95,n96,n97,n98,n99,v1,v2,v3,v4,v5,v6,v7,v8,v9,v11,v12,v13,v14,v15,v16,v17,v18,v19,v21,v22,v23,v24,v25,v26,v27,v28,v29,v31,v32,v33,v34,v35,v36,v37,v38,v39,v41,v42,v43,v44,v45,v46,v47,v48,v49,v51,v52,v53,v54,v55,v56,v57,v58,v59,v61,v62,v63,v64,v65,v66,v67,v68,v69,v71,v72,v73,v74,v75,v76,v77,v78,v79,v81,v82,v83,v84,v85,v86,v87,v88,v89,v91,v92,v93,v94,v95,v96,v97,v98,v99)
values("' . $login . '","Канализация 1 этаж","' . $retr["n1"] . '","' . $retr["n2"] . '","' . $retr["n3"] . '","' . $retr["n4"] . '","' . $retr["n5"] . '","' . $retr["n6"] . '","' . $retr["n7"] . '","' . $retr["n8"] . '","' . $retr["n9"] . '","' . $retr["n11"] . '","' . $retr["n12"] . '","' . $retr["n13"] . '","' . $retr["n14"] . '","' . $retr["n15"] . '","' . $retr["n16"] . '","' . $retr["n17"] . '","' . $retr["n18"] . '","' . $retr["n19"] . '","' . $retr["n21"] . '","' . $retr["n22"] . '","' . $retr["n23"] . '","' . $retr["n24"] . '","' . $retr["n25"] . '","' . $retr["n26"] . '","' . $retr["n27"] . '","' . $retr["n28"] . '","' . $retr["n29"] . '","' . $retr["n31"] . '","' . $retr["n32"] . '","' . $retr["n33"] . '","' . $retr["n34"] . '","' . $retr["n35"] . '","' . $retr["n36"] . '","' . $retr["n37"] . '","' . $retr["n38"] . '","' . $retr["n39"] . '","' . $retr["n41"] . '","' . $retr["n42"] . '","' . $retr["n43"] . '","' . $retr["n44"] . '","' . $retr["n45"] . '","' . $retr["n46"] . '","' . $retr["n47"] . '","' . $retr["n48"] . '","' . $retr["n49"] . '","' . $retr["n51"] . '","' . $retr["n52"] . '","' . $retr["n53"] . '","' . $retr["n54"] . '","' . $retr["n55"] . '","' . $retr["n56"] . '","' . $retr["n57"] . '","' . $retr["n58"] . '","' . $retr["n59"] . '","' . $retr["n61"] . '","' . $retr["n62"] . '","' . $retr["n63"] . '","' . $retr["n64"] . '","' . $retr["n65"] . '","' . $retr["n66"] . '","' . $retr["n67"] . '","' . $retr["n68"] . '","' . $retr["n69"] . '","' . $retr["n71"] . '","' . $retr["n72"] . '","' . $retr["n73"] . '","' . $retr["n74"] . '","' . $retr["n75"] . '","' . $retr["n76"] . '","' . $retr["n77"] . '","' . $retr["n78"] . '","' . $retr["n79"] . '","' . $retr["n81"] . '","' . $retr["n82"] . '","' . $retr["n83"] . '","' . $retr["n84"] . '","' . $retr["n85"] . '","' . $retr["n86"] . '","' . $retr["n87"] . '","' . $retr["n88"] . '","' . $retr["n89"] . '","' . $retr["n91"] . '","' . $retr["n92"] . '","' . $retr["n93"] . '","' . $retr["n94"] . '","' . $retr["n95"] . '","' . $retr["n96"] . '","' . $retr["n97"] . '","' . $retr["n98"] . '","' . $retr["n99"] . '","' . $retr["v1"] . '","' . $retr["v2"] . '","' . $retr["v3"] . '","' . $retr["v4"] . '","' . $retr["v5"] . '","' . $retr["v6"] . '","' . $retr["v7"] . '","' . $retr["v8"] . '","' . $retr["v9"] . '","' . $retr["v11"] . '","' . $retr["v12"] . '","' . $retr["v13"] . '","' . $retr["v14"] . '","' . $retr["v15"] . '","' . $retr["v16"] . '","' . $retr["v17"] . '","' . $retr["v18"] . '","' . $retr["v19"] . '","' . $retr["v21"] . '","' . $retr["v22"] . '","' . $retr["v23"] . '","' . $retr["v24"] . '","' . $retr["v25"] . '","' . $retr["v26"] . '","' . $retr["v27"] . '","' . $retr["v28"] . '","' . $retr["v29"] . '","' . $retr["v31"] . '","' . $retr["v32"] . '","' . $retr["v33"] . '","' . $retr["v34"] . '","' . $retr["v35"] . '","' . $retr["v36"] . '","' . $retr["v37"] . '","' . $retr["v38"] . '","' . $retr["v39"] . '","' . $retr["v41"] . '","' . $retr["v42"] . '","' . $retr["v43"] . '","' . $retr["v44"] . '","' . $retr["v45"] . '","' . $retr["v46"] . '","' . $retr["v47"] . '","' . $retr["v48"] . '","' . $retr["v49"] . '","' . $retr["v51"] . '","' . $retr["v52"] . '","' . $retr["v53"] . '","' . $retr["v54"] . '","' . $retr["v55"] . '","' . $retr["v56"] . '","' . $retr["v57"] . '","' . $retr["v58"] . '","' . $retr["v59"] . '","' . $retr["v61"] . '","' . $retr["v62"] . '","' . $retr["v63"] . '","' . $retr["v64"] . '","' . $retr["v65"] . '","' . $retr["v66"] . '","' . $retr["v67"] . '","' . $retr["v68"] . '","' . $retr["v69"] . '","' . $retr["v71"] . '","' . $retr["v72"] . '","' . $retr["v73"] . '","' . $retr["v74"] . '","' . $retr["v75"] . '","' . $retr["v76"] . '","' . $retr["v77"] . '","' . $retr["v78"] . '","' . $retr["v79"] . '","' . $retr["v81"] . '","' . $retr["v82"] . '","' . $retr["v83"] . '","' . $retr["v84"] . '","' . $retr["v85"] . '","' . $retr["v86"] . '","' . $retr["v87"] . '","' . $retr["v88"] . '","' . $retr["v89"] . '","' . $retr["v91"] . '","' . $retr["v92"] . '","' . $retr["v93"] . '","' . $retr["v94"] . '","' . $retr["v95"] . '","' . $retr["v96"] . '","' . $retr["v97"] . '","' . $retr["v98"] . '","' . $retr["v99"] . '")');
$ferrr = mysql_query("SELECT * FROM podzem4 WHERE glava='default' and name='Канализация 2 этаж'");
$retr = mysql_fetch_array($ferrr);
mysql_query('insert into podzem4(glava,name,n1,n2,n3,n4,n5,n6,n7,n8,n9,n11,n12,n13,n14,n15,n16,n17,n18,n19,n21,n22,n23,n24,n25,n26,n27,n28,n29,n31,n32,n33,n34,n35,n36,n37,n38,n39,n41,n42,n43,n44,n45,n46,n47,n48,n49,n51,n52,n53,n54,n55,n56,n57,n58,n59,n61,n62,n63,n64,n65,n66,n67,n68,n69,n71,n72,n73,n74,n75,n76,n77,n78,n79,n81,n82,n83,n84,n85,n86,n87,n88,n89,n91,n92,n93,n94,n95,n96,n97,n98,n99,v1,v2,v3,v4,v5,v6,v7,v8,v9,v11,v12,v13,v14,v15,v16,v17,v18,v19,v21,v22,v23,v24,v25,v26,v27,v28,v29,v31,v32,v33,v34,v35,v36,v37,v38,v39,v41,v42,v43,v44,v45,v46,v47,v48,v49,v51,v52,v53,v54,v55,v56,v57,v58,v59,v61,v62,v63,v64,v65,v66,v67,v68,v69,v71,v72,v73,v74,v75,v76,v77,v78,v79,v81,v82,v83,v84,v85,v86,v87,v88,v89,v91,v92,v93,v94,v95,v96,v97,v98,v99)
values("' . $login . '","Канализация 2 этаж","' . $retr["n1"] . '","' . $retr["n2"] . '","' . $retr["n3"] . '","' . $retr["n4"] . '","' . $retr["n5"] . '","' . $retr["n6"] . '","' . $retr["n7"] . '","' . $retr["n8"] . '","' . $retr["n9"] . '","' . $retr["n11"] . '","' . $retr["n12"] . '","' . $retr["n13"] . '","' . $retr["n14"] . '","' . $retr["n15"] . '","' . $retr["n16"] . '","' . $retr["n17"] . '","' . $retr["n18"] . '","' . $retr["n19"] . '","' . $retr["n21"] . '","' . $retr["n22"] . '","' . $retr["n23"] . '","' . $retr["n24"] . '","' . $retr["n25"] . '","' . $retr["n26"] . '","' . $retr["n27"] . '","' . $retr["n28"] . '","' . $retr["n29"] . '","' . $retr["n31"] . '","' . $retr["n32"] . '","' . $retr["n33"] . '","' . $retr["n34"] . '","' . $retr["n35"] . '","' . $retr["n36"] . '","' . $retr["n37"] . '","' . $retr["n38"] . '","' . $retr["n39"] . '","' . $retr["n41"] . '","' . $retr["n42"] . '","' . $retr["n43"] . '","' . $retr["n44"] . '","' . $retr["n45"] . '","' . $retr["n46"] . '","' . $retr["n47"] . '","' . $retr["n48"] . '","' . $retr["n49"] . '","' . $retr["n51"] . '","' . $retr["n52"] . '","' . $retr["n53"] . '","' . $retr["n54"] . '","' . $retr["n55"] . '","' . $retr["n56"] . '","' . $retr["n57"] . '","' . $retr["n58"] . '","' . $retr["n59"] . '","' . $retr["n61"] . '","' . $retr["n62"] . '","' . $retr["n63"] . '","' . $retr["n64"] . '","' . $retr["n65"] . '","' . $retr["n66"] . '","' . $retr["n67"] . '","' . $retr["n68"] . '","' . $retr["n69"] . '","' . $retr["n71"] . '","' . $retr["n72"] . '","' . $retr["n73"] . '","' . $retr["n74"] . '","' . $retr["n75"] . '","' . $retr["n76"] . '","' . $retr["n77"] . '","' . $retr["n78"] . '","' . $retr["n79"] . '","' . $retr["n81"] . '","' . $retr["n82"] . '","' . $retr["n83"] . '","' . $retr["n84"] . '","' . $retr["n85"] . '","' . $retr["n86"] . '","' . $retr["n87"] . '","' . $retr["n88"] . '","' . $retr["n89"] . '","' . $retr["n91"] . '","' . $retr["n92"] . '","' . $retr["n93"] . '","' . $retr["n94"] . '","' . $retr["n95"] . '","' . $retr["n96"] . '","' . $retr["n97"] . '","' . $retr["n98"] . '","' . $retr["n99"] . '","' . $retr["v1"] . '","' . $retr["v2"] . '","' . $retr["v3"] . '","' . $retr["v4"] . '","' . $retr["v5"] . '","' . $retr["v6"] . '","' . $retr["v7"] . '","' . $retr["v8"] . '","' . $retr["v9"] . '","' . $retr["v11"] . '","' . $retr["v12"] . '","' . $retr["v13"] . '","' . $retr["v14"] . '","' . $retr["v15"] . '","' . $retr["v16"] . '","' . $retr["v17"] . '","' . $retr["v18"] . '","' . $retr["v19"] . '","' . $retr["v21"] . '","' . $retr["v22"] . '","' . $retr["v23"] . '","' . $retr["v24"] . '","' . $retr["v25"] . '","' . $retr["v26"] . '","' . $retr["v27"] . '","' . $retr["v28"] . '","' . $retr["v29"] . '","' . $retr["v31"] . '","' . $retr["v32"] . '","' . $retr["v33"] . '","' . $retr["v34"] . '","' . $retr["v35"] . '","' . $retr["v36"] . '","' . $retr["v37"] . '","' . $retr["v38"] . '","' . $retr["v39"] . '","' . $retr["v41"] . '","' . $retr["v42"] . '","' . $retr["v43"] . '","' . $retr["v44"] . '","' . $retr["v45"] . '","' . $retr["v46"] . '","' . $retr["v47"] . '","' . $retr["v48"] . '","' . $retr["v49"] . '","' . $retr["v51"] . '","' . $retr["v52"] . '","' . $retr["v53"] . '","' . $retr["v54"] . '","' . $retr["v55"] . '","' . $retr["v56"] . '","' . $retr["v57"] . '","' . $retr["v58"] . '","' . $retr["v59"] . '","' . $retr["v61"] . '","' . $retr["v62"] . '","' . $retr["v63"] . '","' . $retr["v64"] . '","' . $retr["v65"] . '","' . $retr["v66"] . '","' . $retr["v67"] . '","' . $retr["v68"] . '","' . $retr["v69"] . '","' . $retr["v71"] . '","' . $retr["v72"] . '","' . $retr["v73"] . '","' . $retr["v74"] . '","' . $retr["v75"] . '","' . $retr["v76"] . '","' . $retr["v77"] . '","' . $retr["v78"] . '","' . $retr["v79"] . '","' . $retr["v81"] . '","' . $retr["v82"] . '","' . $retr["v83"] . '","' . $retr["v84"] . '","' . $retr["v85"] . '","' . $retr["v86"] . '","' . $retr["v87"] . '","' . $retr["v88"] . '","' . $retr["v89"] . '","' . $retr["v91"] . '","' . $retr["v92"] . '","' . $retr["v93"] . '","' . $retr["v94"] . '","' . $retr["v95"] . '","' . $retr["v96"] . '","' . $retr["v97"] . '","' . $retr["v98"] . '","' . $retr["v99"] . '")');
?>
<script>top.frames['online'].location = 'ch.php?online=' + Math.round(Math.random() * 100000);</script>
<?
mysql_query("DELETE FROM vxod WHERE login='$login'");
mysql_query("DELETE FROM vxodd WHERE glav_id=" . $user['id'] . "");
mysql_query("DELETE FROM vxodd WHERE login='$login'");
print "<script>location.href='canalizaciya.php'</script>";
exit;
}
}
?>
<div>
<div id="mmoves"
style="background-color:#FFFFCC; visibility:hidden; overflow:visible; position:absolute; border-color:#666666; border-style:solid; border-width: 1px; padding: 2px; white-space: nowrap;"></div>
<div style="text-align: right;">
<form action="city.php" method="GET">
<INPUT style="font-size:12px;" type='button'
onClick="let f;if( f=document.getElementById('REQUEST')){f.action+='#e1';f.submit()} else{location='/main.php?act=none'}"
value=Обновить>
<INPUT style="font-size:12px;" type='submit' name='bps' value=Вернуться>
<input value="Подсказка" style="background-color: rgb(169, 175, 192);"
onclick="window.open('help/canalizaciya.html', 'help', 'height=300,width=500,location=no,menubar=no,status=no,toolbar=no,scrollbars=yes')"
type="button">
</form>
</div>
</div>