Хранилища Subversion linwin

<?PHP
        include "head.php";
        include "config.php";
        $mas_no_section_id_transfer = array();
        $mas_no_section_id_transfer[] = $_GET['section_id'];
        if (count($_GET['no_section_id']) > 0)
                foreach ($_GET['no_section_id'] as $val)
                        $mas_no_section_id_transfer[] = $val;
        $section_id_transfer = $_GET['section_id'];
        $db = mysql_connect("localhost", "linwin");
        mysql_select_db("linwin", $db);
        mysql_query("SET NAMES 'utf8';", $db);
        $sql = "SELECT pid FROM prog_in_sect WHERE sid = ". $mas_no_section_id_transfer[0];
        $query=mysql_query($sql, $db);
        $mas_sect_id = array();
        $num_record = mysql_num_rows($query);
        for($i = 0; $i < $num_record; $i++)
        {
                        $mas_prog_in_sect_id[0][$i] = mysql_result($query,$i,0);
        }
        for ($j = 1; $j < count($mas_no_section_id_transfer); $j++)
        {
                $sql_part = "('";
                for ($i = 0; $i < $num_record; $i++)
                        $sql_part = $sql_part. "','". $mas_prog_in_sect_id[$j-1][$i];
                $sql_part = $sql_part. "')";
                $sql ="SELECT pid FROM prog_in_sect WHERE sid = ". $mas_no_section_id_transfer[$j]. " and pid in ". $sql_part;
                $query=mysql_query($sql, $db);
                $mas_sect_id = array();
                $num_record = mysql_num_rows($query);
                for($i = 0; $i < $num_record; $i++)
                        $mas_prog_in_sect_id[$j][$i] = mysql_result($query,$i,0);
        }
        $sql_part = "('". $mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1][0];
        for ($i = 1; $i < count($mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1]); $i++)
                $sql_part = $sql_part. "','". $mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1][$i];
        $sql_part = $sql_part. "')";
        if ($debug == "1")
                print "<br/>sql_part:<br/>$sql_part<br/>";
       
        $sql = "SELECT id, name, description FROM program WHERE id in ". $sql_part. " ORDER BY name";
        $query = mysql_query($sql, $db);
        $num_record = mysql_num_rows($query);
        $mas_program_id = array();
        $mas_program_name = array();
        $mas_program_description = array();
        for ($i = 0; $i < $num_record; $i++)
        {
                $mas_program_id[$i] = mysql_result($query, $i, 0);
                $mas_program_name[$i] = mysql_result($query, $i, 1);
                $mas_program_description[$i] = mysql_result($query, $i, 2);
        }
        $sql_part = "pid in ('". $mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1][0];
        for ($i = 1; $i < count($mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1]); $i++)
                $sql_part = $sql_part. "','". $mas_prog_in_sect_id[count($mas_prog_in_sect_id)-1][$i];
        $sql_part = $sql_part. "')";
        if (count($mas_no_section_id_transfer))
        {
                $sql_part = $sql_part. " and sid not in ('". $mas_no_section_id_transfer[0];
                for ($i = 1; $i < count($mas_no_section_id_transfer); $i++)
                        $sql_part = $sql_part. "','". $mas_no_section_id_transfer[$i];
                $sql_part = $sql_part. "')";
        }
        $sql = "SELECT sid FROM prog_in_sect WHERE ". $sql_part;
        $query=mysql_query($sql, $db);
        $mas_sect_id = array();
        $num_record = mysql_num_rows($query);
        for($i = 0; $i < $num_record; $i++)
        {
                $mas_section_id[] = mysql_result($query,$i,0);
        }
        if (count($mas_section_id))
        {
                $sql_part = "('". $mas_section_id[0];
                for ($i = 1; $i < count($mas_section_id); $i++)
                        $sql_part = $sql_part. "','". $mas_section_id[$i];
                $sql_part = $sql_part. "')";
                $sql = "SELECT id, name FROM section WHERE id in ". $sql_part. " ORDER BY name";
                $query = mysql_query($sql, $db);
                $mas_section_id = array();
                $mas_section_name = array();
                $num_record = mysql_num_rows($query);
                for ($i = 0; $i < $num_record; $i++)
                {
                        $mas_section_id[] = mysql_result($query, $i, 0);
                        $mas_section_name[] = mysql_result($query, $i, 1);
                }
        }
                $sql_part = "('". $mas_no_section_id_transfer[0];
                for ($i = 1; $i < count($mas_no_section_id_transfer); $i++)
                        $sql_part = $sql_part. "','". $mas_no_section_id_transfer[$i];
                $sql_part = $sql_part. "')";
                $sql = "SELECT id, name FROM section WHERE id in ". $sql_part. " ORDER BY name";
                $query = mysql_query($sql, $db);
                $mas_section_in_id = array();
                $mas_section_in_name = array();
                $num_record = mysql_num_rows($query);
                for ($i = 0; $i < $num_record; $i++)
                {
                        $mas_section_in_id[] = mysql_result($query, $i, 0);
                        $mas_section_in_name[] = mysql_result($query, $i, 1);
                }
        mysql_close($db);
       
       
        print "
                <table width = \"100%\" align = \"center\">
                <tr><td width = \"50%\" align = \"left\" valign = \"top\"><b>Программы находятся в группах:</b><br/>";
        for ($i = 0; $i < count($mas_section_in_id); $i++)
                print "$mas_section_in_name[$i]<br/> ";
        print "
                </td><td><table>";
        $no_section_id = "";
        for ($i = 0; $i < count($mas_no_section_id_transfer); $i++)
                $no_section_id = $no_section_id. "&no_section_id%5B%5D=". $mas_no_section_id_transfer[$i];
        print "<tr><td><b>Группы:</b><br/>";
        for ($i = 0; $i < count($mas_section_id); $i++)
                print "<a href = \"view_section_wood.php?section_id=$mas_section_id[$i]&$no_section_id\">$mas_section_name[$i]</a><br/>";
        print "
                </td></tr></table></td></tr>
                <tr><td colspan = \"2\"><hr/></td></tr>
                <tr><td align = \"center\" colspan = \"2\"><b>Программы:</b><br/>
                <table width = \"100%\" class = \"without-border\" cellpadding = \"0\" cellspacing = \"1\" bgcolor = \"cccccc\">
                <tr><td><b>Название программы</b></td><td><b>Описание</b></td>
                </tr>";
        for ($i = 0; $i < count($mas_program_id); $i++)
        {
                print "<tr><td bgcolor = \"ffffff\"><a href = what_is_the_program.php?program_id=$mas_program_id[$i] >$mas_program_name[$i]</a></td><td bgcolor = \"ffffff\">$mas_program_description[$i]</td></tr>";
        }
               
        print "
                </table>
                </td></tr></table>";
include "foot.php";
?>