įvyko klaida komunikuojant su serveriu"; $skins = array ('default', 'simple'); @include("skin/" . $skin . "/header.php"); //echo "
Tvarkarastis pagal auditorijas, // versija spausdinimui //
"; if ($ein_semestras=="rudens") { include('.ht.db.rud.php'); } else { include('.ht.db.pav.php'); } $debug = 'echo "\n\n";'; if ("$type"=="") { $type="index"; } if ("$type"=="index") { if (!@include("skin/" . $skin . "/destyt.php")) { eval($debug); die ($die); } $sql_query = "select pakopa from $db_table2 group by pakopa order by pakopa"; $result1 = mysql_query($sql_query); if (! $result1) { eval($debug); die ($die); } $row1 = mysql_num_rows ($result1); for ($i1 = 0; $i1<$row1; $i1++) { $pakopa = mysql_result($result1, $i1, "pakopa"); if (!@include("skin/" . $skin . "/index.pakopa.start.php")) { eval($debug); die ($die); } # ---- kryptys ---- # $sql_query = "select kryptis from $db_table2 where pakopa='" . addslashes($pakopa) . "' group by kryptis order by kryptis"; $result2 = mysql_query($sql_query); if (! $result2) { eval($debug); die ($die); } $row2 = mysql_num_rows ($result2); for ($i2 = 0; $i2<$row2; $i2++) { $kryptis = mysql_result($result2, $i2, "kryptis"); if (!@include("skin/" . $skin . "/index.kryptis.start.php")) { eval($debug); die ($die); } # ---- programa (atsaka) ---- # $sql_query = "select programa from $db_table2 where pakopa='" . addslashes($pakopa) . "' and kryptis='" . addslashes($kryptis) . "' group by programa order by programa"; $result3 = mysql_query($sql_query); if (! $result3) { eval($debug); die ($die); } $row3 = mysql_num_rows ($result3); for ($i3 = 0; $i3<$row3; $i3++) { $programa = mysql_result($result3, $i3, "programa"); if (!@include("skin/" . $skin . "/index.programa.start.php")) { eval($debug); die ($die); } # ---- kursas ---- # $sql_query = "select kursas from $db_table2 where pakopa='" . addslashes($pakopa) . "' and kryptis='" . addslashes($kryptis) . "' and programa='" . addslashes($programa) . "' group by kursas order by kursas"; $result4 = mysql_query($sql_query); if (! $result4) { eval($debug); die ($die); } $row4 = mysql_num_rows ($result4); for ($i4 = 0; $i4<$row4; $i4++) { $kursas = mysql_result($result4, $i4, "kursas"); if (!@include("skin/" . $skin . "/index.kursas.start.php")) { eval($debug); die ($die); } # ---- grupe ---- # $sql_query = "select gnr, grupe from $db_table2 where pakopa='" . addslashes($pakopa) . "' and kryptis='" . addslashes($kryptis) . "' and kursas='" . addslashes($kursas) . "' and programa='" . addslashes($programa) . "' group by grupe order by grupe"; $result5 = mysql_query($sql_query); if (! $result5) { eval($debug); die ($die); } $row5 = mysql_num_rows ($result5); for ($i5 = 0; $i5<$row5; $i5++) { $gnr = mysql_result($result5, $i5, "gnr"); $grupe = mysql_result($result5, $i5, "grupe"); if (!@include("skin/" . $skin . "/index.grupe.php")) { eval($debug); die ($die); } } # / -- grupe ---- # if (!@include("skin/" . $skin . "/index.kursas.end.php")) { eval($debug); die ($die); } } # / -- kursas # if (!@include("skin/" . $skin . "/index.programa.end.php")) { eval($debug); die ($die); } } # / -- programa (atsaka) ---- # if (!@include("skin/" . $skin . "/index.kryptis.end.php")) { eval($debug); die ($die); } } # / -- kryptys ---- # if (!@include("skin/" . $skin . "/index.pakopa.end.php")) { eval($debug); die ($die); } } } else if ("$type"=="grupe") { $sql_select = "select pakopa, kursas, kryptis, programa, grupe from $db_table2 where gnr='" . addslashes($nr) . "'"; $result = mysql_query ($sql_select); if (! $result) { eval($debug); die ($die); } $pakopa = mysql_result($result, 0, "pakopa"); $programa = mysql_result($result, 0, "programa"); $kryptis = mysql_result($result, 0, "kryptis"); $grupe = mysql_result($result, 0, "grupe"); $kursas = mysql_result($result, 0, "kursas"); if (!@include("skin/" . $skin . "/grupe.start.php")) { eval($debug); die ($die); } for ($sdiena=1;$sdiena<=7;$sdiena++) { $sql_select = "select " .$db_table3.".pavadinimas, " .$db_table3.".laisvas, " .$db_table3.".url, " .$db_table3.".past, " .$db_table3.".aprasymas, " .$db_table1.".url, " .$db_table1.".dnr, " .$db_table1.".vardas, " .$db_table1.".pavarde, " .$db_table1.".laipsnis, " .$db_table4.".auditorija, " .$db_table4.".laikas1, " .$db_table4.".laikas2, " .$db_table4.".laikas3, " .$db_table4.".laikas4, " .$db_table4.".lygine, " .$db_table4.".pogrupis, " .$db_table4.".pogrupiu " . " from " .$db_table3.", " .$db_table1.", " .$db_table6.", " .$db_table4.", " .$db_table5 . " where " .$db_table6.".grupe = '" . addslashes($nr) . "' and " .$db_table6.".paskaita = ".$db_table3.".pnr and " .$db_table5.".destytojas = ".$db_table1.".dnr and " .$db_table5.".paskaita = ".$db_table3.".pnr and " .$db_table4.".paskaita = ".$db_table3.".pnr and " .$db_table4.".diena = '" . addslashes($sdiena) . "'" . " order by" . " round(".$db_table4.".laikas1), " . " round(".$db_table4.".laikas2), " . " round(".$db_table4.".laikas3), " . " round(".$db_table4.".laikas4), " . " round(".$db_table4.".pogrupis)"; $result = mysql_query ($sql_select); if (! $result) { eval($debug); die ($die); } $row = mysql_num_rows ($result); for ($local_i_1=0;$local_i_1<$row;$local_i_1++) { $res[$local_i_1]["paskaita"]["pavadinimas"] = mysql_result($result, $local_i_1, $db_table3.".pavadinimas"); $res[$local_i_1]["paskaita"]["laisvas"] = mysql_result($result, $local_i_1, $db_table3.".laisvas"); $res[$local_i_1]["paskaita"]["url"] = mysql_result($result, $local_i_1, $db_table3.".url"); $res[$local_i_1]["paskaita"]["pastaba"] = mysql_result($result, $local_i_1, $db_table3.".past"); $res[$local_i_1]["paskaita"]["aprasymas"] = mysql_result($result, $local_i_1, $db_table3.".aprasymas"); $res[$local_i_1]["destytojas"]["url"] = mysql_result($result, $local_i_1, $db_table1.".url"); $res[$local_i_1]["destytojas"]["dnr"] = mysql_result($result, $local_i_1, $db_table1.".dnr"); $res[$local_i_1]["destytojas"]["vardas"] = mysql_result($result, $local_i_1, $db_table1.".vardas"); $res[$local_i_1]["destytojas"]["pavarde"] = mysql_result($result, $local_i_1, $db_table1.".pavarde"); $res[$local_i_1]["destytojas"]["laipsnis"] = mysql_result($result, $local_i_1, $db_table1.".laipsnis"); $res[$local_i_1]["laikas"]["auditorija"] = mysql_result($result, $local_i_1, $db_table4.".auditorija"); $res[$local_i_1]["laikas"][0] = $sdiena; $res[$local_i_1]["laikas"][1] = mysql_result($result, $local_i_1, $db_table4.".laikas1"); $res[$local_i_1]["laikas"][2] = mysql_result($result, $local_i_1, $db_table4.".laikas2"); $res[$local_i_1]["laikas"][3] = mysql_result($result, $local_i_1, $db_table4.".laikas3"); $res[$local_i_1]["laikas"][4] = mysql_result($result, $local_i_1, $db_table4.".laikas4"); $res[$local_i_1]["laikas"]["lygine"] = mysql_result($result, $local_i_1, $db_table4.".lygine"); $res[$local_i_1]["laikas"]["pogrupis"] = mysql_result($result, $local_i_1, $db_table4.".pogrupis"); $res[$local_i_1]["laikas"]["pogrupiu"] = mysql_result($result, $local_i_1, $db_table4.".pogrupiu"); if ($res[$local_i_1]["laikas"][2] == 0) { $res[$local_i_1]["laikas"][2] = "00"; } if ($res[$local_i_1]["laikas"][4] == "0") { $res[$local_i_1]["laikas"][4] = "00"; } } if (!@include("skin/" . $skin . "/grupe.item.php")) { eval($debug); die ($die); } } if (!@include("skin/" . $skin . "/grupe.end.php")) { eval($debug); die ($die); } } else if ("$type"=="destyt") { echo "
"; $sql = "select * from ".$db_table1." order by pavarde"; $r = mysql_query($sql); if (! $r) { eval($debug); die ($die); } $rows = mysql_num_rows($r); #echo "
"; echo "\n"; #echo "
"; echo "
"; } else if ("$type"=="auditorija") { echo "
"; echo "

Auditorijos papildomiems renginiams rezervuojamos tik suderinus su Renata Sidorenkiene.

"; $sql = "select Distinct (auditorija) from ".$db_table4." order by auditorija"; $r = mysql_query($sql); if (! $r) { eval($debug); die ($die); } $rows = mysql_num_rows($r); #echo "
"; echo "\n"; #echo "
"; echo "
"; } else if ("$type"== "skaito") { $sql = "select vardas, pavarde, laipsnis, url from $db_table1 where dnr='" . addslashes($dnr) . "'"; $r = mysql_query($sql); if (! $r) { eval($debug); die ($die); } $laipsnis = mysql_result($r, 0, "laipsnis"); $vardas = mysql_result($r, 0, "vardas"); $pavarde = mysql_result($r, 0, "pavarde"); $url = mysql_result($r, 0, "url"); if (!@include("skin/" . $skin . "/dest.start.php")) { eval($debug); die ($die); } for ($sdiena = 1; $sdiena <= 7; $sdiena++) { $sql_select = "select " .$db_table3.".pavadinimas, " .$db_table3.".laisvas, " .$db_table3.".url, " .$db_table3.".past, " .$db_table2.".pakopa, " .$db_table2.".kursas, " .$db_table2.".kryptis, " .$db_table2.".programa, " .$db_table2.".grupe, " .$db_table4.".auditorija, " .$db_table4.".laikas1, " .$db_table4.".laikas2, " .$db_table4.".laikas3, " .$db_table4.".laikas4, " .$db_table4.".lygine, " .$db_table4.".pogrupis, " .$db_table4.".pogrupiu " . " from " .$db_table5.", " .$db_table3.", " .$db_table6.", " .$db_table2.", " .$db_table4 . " where " . $db_table5.".destytojas = '" . addslashes($dnr) . "' and " . $db_table3.".pnr = ". $db_table5.".paskaita and " . $db_table6.".paskaita = ".$db_table3.".pnr and " . $db_table2.".gnr = ". $db_table6.".grupe and " . $db_table4.".paskaita = ".$db_table3.".pnr and " . $db_table4.".diena = '" . addslashes($sdiena) . "'" . " order by" . " round(".$db_table4.".laikas1), " . " round(".$db_table4.".laikas2), " . " round(".$db_table4.".laikas3), " . " round(".$db_table4.".laikas4), " . $db_table3. ".pavadinimas, " . $db_table3. ".laisvas, " . $db_table4. ".lygine, " . $db_table2.".kursas, " . $db_table2.".programa, " . $db_table2.".grupe, " . " round(".$db_table4.".pogrupis)"; /* echo "Selectas : ".$sql_select; */ $result = mysql_query ($sql_select); if (! $result) { eval($debug); die ($die); } $row = mysql_num_rows ($result); for ($local_i_1=0;$local_i_1<$row;$local_i_1++) { $res[$local_i_1]["paskaita"]["pavadinimas"] = mysql_result($result, $local_i_1, $db_table3.".pavadinimas"); $res[$local_i_1]["paskaita"]["laisvas"] = mysql_result($result, $local_i_1, $db_table3.".laisvas"); $res[$local_i_1]["paskaita"]["url"] = mysql_result($result, $local_i_1, $db_table3.".url"); $res[$local_i_1]["paskaita"]["pastaba"] = mysql_result($result, $local_i_1, $db_table3.".past"); $res[$local_i_1]["grupes"]["pakopa"] = mysql_result($result, $local_i_1, $db_table2.".pakopa"); $res[$local_i_1]["grupes"]["kursas"] = mysql_result($result, $local_i_1, $db_table2.".kursas"); $res[$local_i_1]["grupes"]["kryptis"] = mysql_result($result, $local_i_1, $db_table2.".kryptis"); $res[$local_i_1]["grupes"]["programa"] = mysql_result($result, $local_i_1, $db_table2.".programa"); $res[$local_i_1]["grupes"]["grupe"] = mysql_result($result, $local_i_1, $db_table2.".grupe"); $res[$local_i_1]["laikas"]["auditorija"] = mysql_result($result, $local_i_1, $db_table4.".auditorija"); $res[$local_i_1]["laikas"][0] = $sdiena; $res[$local_i_1]["laikas"][1] = mysql_result($result, $local_i_1, $db_table4.".laikas1"); $res[$local_i_1]["laikas"][2] = mysql_result($result, $local_i_1, $db_table4.".laikas2"); $res[$local_i_1]["laikas"][3] = mysql_result($result, $local_i_1, $db_table4.".laikas3"); $res[$local_i_1]["laikas"][4] = mysql_result($result, $local_i_1, $db_table4.".laikas4"); $res[$local_i_1]["laikas"]["lygine"] = mysql_result($result, $local_i_1, $db_table4.".lygine"); $res[$local_i_1]["laikas"]["pogrupis"] = mysql_result($result, $local_i_1, $db_table4.".pogrupis"); $res[$local_i_1]["laikas"]["pogrupiu"] = mysql_result($result, $local_i_1, $db_table4.".pogrupiu"); if ($res[$local_i_1]["laikas"][2] == 0) { $res[$local_i_1]["laikas"][2] = "00"; } if ($res[$local_i_1]["laikas"][4] == "0") { $res[$local_i_1]["laikas"][4] = "00"; } } if (!@include("skin/" . $skin . "/dest.item.php")) { eval($debug); die ($die); } } if (!@include("skin/" . $skin . "/dest.end.php")) { eval($debug); die ($die); } } else if ("$type"=="auditorija") { echo "
"; $sql = "select Distinct (auditorija) from ".$db_table4." order by auditorija"; $r = mysql_query($sql); if (! $r) { eval($debug); die ($die); } $rows = mysql_num_rows($r); #echo "
"; echo "\n"; #echo "
"; echo "
"; } else if ("$type"== "auditor") { if (!@include("skin/" . $skin . "/aud.start.php")) { eval($debug); die ($die); } for ($sdiena = 1; $sdiena <= 7; $sdiena++) { // tikrinam ar yra '(', jei yra reikalaujam, kad butu isrinktos auditorijos su '(' if (strpos(addslashes($anr), ' (') !== false) { $pos_sk=strpos(addslashes($anr), ' ('); $sk_inf=substr(addslashes($anr),$pos_sk); $sk_info=substr(addslashes($anr),0,$pos_sk); $skliaust="like '%".$sk_inf."%' "; }elseif (strpos(addslashes($anr), '(') !== false) { $pos_sk=strpos(addslashes($anr), '('); $sk_inf=substr(addslashes($anr),$pos_sk); $sk_info=substr(addslashes($anr),0,$pos_sk); $skliaust="like '%".$sk_inf."%' "; } else { $skliaust="not like '%(%' "; $sk_info=addslashes($anr); } //echo "Auditorija - '$sk_info', skliaustu turinys - '$sk_inf'
"; $sql_select = "select " .$db_table3.".pavadinimas, " .$db_table3.".laisvas, " .$db_table3.".url, " .$db_table3.".past, " .$db_table1.".url, " .$db_table1.".dnr, " .$db_table1.".vardas, " .$db_table1.".pavarde, " .$db_table1.".laipsnis, " .$db_table2.".pakopa, " .$db_table2.".kursas, " .$db_table2.".kryptis, " .$db_table2.".programa, " .$db_table2.".grupe, " .$db_table4.".auditorija, " .$db_table4.".laikas1, " .$db_table4.".laikas2, " .$db_table4.".laikas3, " .$db_table4.".laikas4, " .$db_table4.".lygine, " .$db_table4.".pogrupis, " .$db_table4.".pogrupiu " . " from " .$db_table5.", " .$db_table3.", " .$db_table6.", " .$db_table2.", " .$db_table1.", " .$db_table4 . " where (" . $db_table4.".auditorija like '" . $sk_info . "') and " . $db_table4.".auditorija " . $skliaust . " and " . $db_table3.".pnr = ". $db_table5.".paskaita and " . $db_table6.".paskaita = ".$db_table3.".pnr and " . $db_table2.".gnr = ". $db_table6.".grupe and " . $db_table4.".paskaita = ".$db_table3.".pnr and " .$db_table5.".destytojas = ".$db_table1.".dnr and " . $db_table4.".diena = '" . addslashes($sdiena) . "'" ." GROUP BY " . $db_table2.".programa," .$db_table2.".kursas," .$db_table2.".grupe" . " order by " .$db_table4. ".laikas1, " . $db_table2.".kursas, " . $db_table2.".programa, " . $db_table2.".grupe "; //echo "Selectas : ".$sql_select."

"; $result = mysql_query ($sql_select); if (! $result) { eval($debug); die ($die); } $row = mysql_num_rows ($result); for ($local_i_1=0;$local_i_1<$row;$local_i_1++) { $res[$local_i_1]["paskaita"]["pavadinimas"] = mysql_result($result, $local_i_1, $db_table3.".pavadinimas"); $res[$local_i_1]["paskaita"]["laisvas"] = mysql_result($result, $local_i_1, $db_table3.".laisvas"); $res[$local_i_1]["paskaita"]["url"] = mysql_result($result, $local_i_1, $db_table3.".url"); $res[$local_i_1]["paskaita"]["pastaba"] = mysql_result($result, $local_i_1, $db_table3.".past"); $res[$local_i_1]["destytojas"]["url"] = mysql_result($result, $local_i_1, $db_table1.".url"); $res[$local_i_1]["destytojas"]["dnr"] = mysql_result($result, $local_i_1, $db_table1.".dnr"); $res[$local_i_1]["destytojas"]["vardas"] = mysql_result($result, $local_i_1, $db_table1.".vardas"); $res[$local_i_1]["destytojas"]["pavarde"] = mysql_result($result, $local_i_1, $db_table1.".pavarde"); $res[$local_i_1]["destytojas"]["laipsnis"] = mysql_result($result, $local_i_1, $db_table1.".laipsnis"); $res[$local_i_1]["grupes"]["pakopa"] = mysql_result($result, $local_i_1, $db_table2.".pakopa"); $res[$local_i_1]["grupes"]["kursas"] = mysql_result($result, $local_i_1, $db_table2.".kursas"); $res[$local_i_1]["grupes"]["kryptis"] = mysql_result($result, $local_i_1, $db_table2.".kryptis"); $res[$local_i_1]["grupes"]["programa"] = mysql_result($result, $local_i_1, $db_table2.".programa"); $res[$local_i_1]["grupes"]["grupe"] = mysql_result($result, $local_i_1, $db_table2.".grupe"); $res[$local_i_1]["laikas"]["auditorija"] = mysql_result($result, $local_i_1, $db_table4.".auditorija"); $res[$local_i_1]["laikas"][0] = $sdiena; $res[$local_i_1]["laikas"][1] = mysql_result($result, $local_i_1, $db_table4.".laikas1"); $res[$local_i_1]["laikas"][2] = mysql_result($result, $local_i_1, $db_table4.".laikas2"); $res[$local_i_1]["laikas"][3] = mysql_result($result, $local_i_1, $db_table4.".laikas3"); $res[$local_i_1]["laikas"][4] = mysql_result($result, $local_i_1, $db_table4.".laikas4"); $res[$local_i_1]["laikas"]["lygine"] = mysql_result($result, $local_i_1, $db_table4.".lygine"); $res[$local_i_1]["laikas"]["pogrupis"] = mysql_result($result, $local_i_1, $db_table4.".pogrupis"); $res[$local_i_1]["laikas"]["pogrupiu"] = mysql_result($result, $local_i_1, $db_table4.".pogrupiu"); if ($res[$local_i_1]["laikas"][2] == 0) { $res[$local_i_1]["laikas"][2] = "00"; } if ($res[$local_i_1]["laikas"][4] == "0") { $res[$local_i_1]["laikas"][4] = "00"; } } if (!@include("skin/" . $skin . "/aud.item2.php")) { eval($debug); die ($die); } } if (!@include("skin/" . $skin . "/aud.end.php")) { eval($debug); die ($die); } } @include("skin/" . $skin . "/tail.php"); ?>