<?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' );

    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);
   
        $dbManagerQuery = "SELECT * FROM db_manager WHERE userId='".$user->id."'";
        $dbManagerResult = mysql_query($dbManagerQuery); 
        $dbManagerRow = mysql_fetch_array($dbManagerResult);
        
        $_SESSION['departmentId'] = $dbManagerRow['departmentId'];
        
        $departmentQuery = "SELECT * FROM department WHERE id='".$dbManagerRow['departmentId']."'"; 
        $departmentResult = mysql_query($departmentQuery);
        $departmentRow = mysql_fetch_array($departmentResult);
        
        
        echo "<h2><font color='#0080C0'><center>Τμήμα ".$departmentRow['departmentName']."</center></font></h2>";

    ?>     
    <br><br><br>           
            <table cellspacing="10" border="" align="center">
                <tr>
                    <td>
                        <button style="height: 100; width: 120px" width="80" height="80" type="button" onclick="location.href='?option=com_content&view=article&id=65'">
                        <img width="70" height="70" src="/ees_request/images/stories/add.png" alt="Προσθήκη Μαθήματος"/>
                        <br />Προσθήκη</button>
                    </td>
                    <td>
                        <button style="height: 100; width: 120px" width="80" height="80" type="button" onclick="location.href='?option=com_content&view=article&id=67'">
                        <img  width="70" height="70" src="/ees_request/images/stories/edit.png" alt="Επεξεργασία Μαθήματος" />
                        <br /> <font size="2">Επεξεργασία</font></button>
                    </td>
                    <td>
                        <button style="height: 100; width: 120px" width="80" height="80" type="button" onclick="location.href='?option=com_content&view=article&id=69'">
                        <img  width="70" height="70" src="/ees_request/images/stories/delete.png" alt="Διαγραφή Μαθήματος" />
                        <br /> <font size="2">Διαγραφή</font></button>
                    </td>
                    <td>
                        <button style="height: 100; width: 120px" width="80" height="80" type="button" onclick="location.href='?option=com_content&view=article&id=71'">
                        <img  width="70" height="70" src="/ees_request/images/stories/search.png" alt="Διαγραφή Μαθήματος" />
                        <br /> <font size="2">Αναζήτηση</font></button>
                    </td>
                </tr>
            </table>        
    <?php    
    }
    else {
        echo "<br><font color='red'>Απογορεύεται η πρόσβαση. Δεν είστε συνδεδεμένοι!</font>";
    }
?>