<?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['DEPARTMENT_ID'] = $_POST['departmentId'];
        session_register('SECTION_ID');   
        
        $Q = "SELECT * FROM department WHERE id='".$_POST['departmentId']."'";
        $result = mysql_query($Q);
        $department = mysql_fetch_array($result);
        
        $Q = "SELECT * FROM section WHERE departmentId='".$_POST['departmentId']."'";
                
        $result = mysql_query($Q);
       
        if( mysql_num_rows($result) != FALSE ) {
            $row = mysql_fetch_array($result);
        
        ?> 
        
        <br> 
            <a href="javascript:history.go(-1);">Τμήμα <?php echo $department['departmentName']; ?></a> > Επιλογή Τομέα
         
            <form method="post" action="?option=com_content&view=article&id=60">
               
                <input type="hidden" name="departmentName" value="<?php echo $department['departmentName']; ?>">
            
                <br><br>
                <table>
                    <tr>
                        <td>Επιλογή Τομέα</td><td><select name="sectionId">
                                                        <?php
                                                            do {
                                                                echo  "<option id='".$row['id']."' value='".$row['id']."'>".$row['sectionTitle']."</option>";    
                                                            } while( $row = mysql_fetch_array($result) );
                                                        ?>
                                                     </select>
                                                 </td>
                        <td><input type="submit" name="submit" value="Επόμενο >>"></td>
                    </tr>
                    
                </table>     
            </form>
            <br>
           <?php if( !empty($department['notice']) ) { ?>
            <font size="3">
                <table border="0" bgcolor="#F0FFF0">
                    <tr>
                        <td><hr color="#D0D0D0"></td>
                    </tr>                              
                    <tr><td><?php echo $department['notice']; ?></td></tr>
                </table>
            </font>
        <?php 
                  }    
        }
        else {
            echo "<font color='red'>Δεν υπάρχουν καταχωρημένα στοιχεία για τους Τομείς.</font>";    
        }
    }
    else {
        echo "<br><font color='red'>Απογορεύεται η πρόσβαση. Δεν είστε συνδεδεμένοι!</font>";
    }
?>