Хранилища 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";

?>