<?php
    include(JPATH_BASE .DS.'externalpages'.DS.'ams'.DS.'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' );

    $mainframe =& JFactory::getApplication('site');
    $user =& JFactory::getUser(); 
    
                $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);   
                  
    if ( !$user->guest ) {
        
        $departmentQuery = "SELECT * FROM department WHERE id='".$_SESSION['departmentId']."'"; 
        $departmentResult = mysql_query($departmentQuery);
        $departmentRow = mysql_fetch_array($departmentResult);
        
        $sectionQuery = "SELECT * FROM section WHERE departmentId='".$_SESSION['departmentId']."'";
        $sectionResult = mysql_query($sectionQuery);
        $sectionRow = mysql_fetch_array($sectionResult);
        
         ?>
         <br>
            <a href="javascript:history.go(-1)"><b>[ << Πίσω]</b></a>  
         
         <br>
         
            <form method="POST" action="?option=com_content&view=article&id=66">
                <table align="center" cellspacing="7">
                   <th bgcolor="#B9EEAC" colspan="2" align="left"> <b>Προσθήκη Νέου Μαθήματος</b>  </th>   
                   <tr>
                        <td>Κωδικός Μαθήματος</td> <td><input type="text" name="lessonId" size="15"></td>
                   </tr>                
                   <tr>
                        <td>Τομέας</td><td><select name="sectionId">
                                                        <?php
                                                            do {
                                                                echo  "<option id='".$sectionRow['id']."' value='".$sectionRow['id']."'>".$sectionRow['sectionTitle']."</option>";    
                                                            } while( $sectionRow = mysql_fetch_array($sectionResult) );
                                                        ?>
                                                     </select>
                                                 </td>
                        </td>
                   </tr>
                   <tr>
                        <td>Τίτλος Μαθήματος</td> <td><input type="text" name="lessonTitle" size="71"></td>
                   </tr> 
                   <tr>
                        <td>Ώρες Διδασκαλίας</td><td><select name="teachingHours">  
                                                        <?php
                                                            for($hours = 1; $hours <= 9; $hours++) {
                                                                echo "<option id='$hours'>$hours</option>";
                                                            }
                                                        ?>
                                              </select>  
                        </td> 
                    </tr>
                    <tr>
                        <td>Εξάμηνο</td><td><select name="semester">  
                                                        <?php
                                                            for($semester = 1; $semester <= 8; $semester++) {
                                                                echo "<option id='$semester'>$semester</option>";
                                                            }
                                                        ?>
                                              </select>  
                        </td>
                    </tr>
                    <tr>
                        <td colspan="2" align="right" bgcolor="#B9EEAC"><input type="reset" value="Απαλοιφή"> <input type="submit" value="Καταχώρηση"></td>
                    </tr>
                </table>
            </form>
         
         <?php   
    }
    else {
        echo "<br><font color='red'>Απογορεύεται η πρόσβαση. Δεν είστε συνδεδεμένοι!</fpnt>";
    }
?>