<?php
    include('config.php');
    define( '_JEXEC', 1 );
    define('JPATH_BASE', dirname(__FILE__) );
    define( 'DS', DIRECTORY_SEPARATOR );
    require_once ( JPATH_BASE .DS.'includes'.DS.'defines.php' );
    require_once ( JPATH_BASE .DS.'includes'.DS.'framework.php' );
    require_once ( JPATH_BASE .DS.'libraries'.DS.'joomla'.DS.'factory.php' );
    
    session_start();

    $mainframe =& JFactory::getApplication('site');
    $user =& JFactory::getUser();             
    
    if (!$user->guest) {
        
        $db_connection=mysql_connect($host, $username, $password, $db_name);
            if (!$db_connection) {
                die("<br><b>Database Error:</b> Could not connected. Try again later.<br>");
                exit;
            }
        @mysql_select_db($db_name, $db_connection) or die("Unable to select database.");
        mysql_query("SET NAMES 'utf8'", $db_connection);

            $_SESSION['SECTION_ID'] = $_GET['sId'];   
            session_register('LESSONS_IDS');
            session_register('DEPARTMENT_ID'); 
            $_SESSION['DEPARTMENT_ID'] = $_GET['dId']; 
              
            //$Q = "SELECT * FROM lesson WHERE (sectionId='".$_GET['sId']."' OR sectionId='0') AND departmentId='".$_SESSION['DEPARTMENT_ID']."'";
            $Q = "SELECT * FROM lesson WHERE sectionId='".$_GET['sId']."' AND departmentId='".$_SESSION['DEPARTMENT_ID']."' ORDER BY semester,lessonTitle";        
            $result = mysql_query($Q);
           
            if( mysql_num_rows($result) != FALSE ) {
            ?>
            <br>
                <form method="post" action="?option=com_content&view=article&id=52">
                    <table>
                        <tr align="center" style='background-color: #B9EEAC;'>
                            <th>Τίτλος Μαθήματος
                            <th>Ώρες Διδασκαλίας
                            <th>Εξάμηνο
                            <th>Επιλογή Μαθήματος
    
                        </tr>
                        <?php
                            while( $lesson = mysql_fetch_array($result) ) {
                                echo "<tr onMouseOut=\"this.style.background='#FFFFFF'\" onMouseOver=\"this.style.background ='#FFA346';\">";
                                echo "<td>".$lesson['lessonTitle']."</td>"; 
                                echo "<td>".$lesson['teachingHours']."</td>"; 
                                echo "<td>".$lesson['semester']."</td>"; 
                                echo "<td align='center'><input type='checkbox' name='lessons[]' value='".$lesson['id']."'></td>"; 
                                echo "</tr>";
                            }
                        ?>
                        <tr>
                            <td colspan="5" align="right"><input type="submit" value="Επόμενο >>"></td>
                        <tr>
                    </table>
                </form>
            
            <?php     
            }
            else {
                echo "<font color='red'>Δεν υπάρχουν καταχωρημένα Μαθήματα για τον Επιλεγμένο Τομέα.</font>";    
            }

    }
    else {
        echo "<br><font color='red'>Απογορεύεται η πρόσβαση. Δεν είστε συνδεδεμένοι!</font>";
    }
?>