Files
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>