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

    $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);
            
        $Q = "SELECT language.id, language.languageTypeId, language_type.language, language.titleCertificate, language.snCertificate, language.teachability 
              FROM language, language_type
              WHERE language.userId='".$user->id."' AND language_type.id=language.languageTypeId";
                
        $result = mysql_query($Q);
        
        if( mysql_num_rows($result) != FALSE ) {
?>
<br> 
            <table width="100%" align="center" cellspacing="2">
                <tr align="center" align="center" style='background-color: #B9EEAC;'>
                    <th>Γλώσσα </th>
                    <th>Τίτλος Πτυχίου </th> 
                    <th>Αριθμός Παραστατικού </th>    
                    <th>Διδακτική Ικανότητα </th>
                    <th align="center"> </th>
                    <th align="center"> </th>             
                </tr>
<?php        
            while( $row = mysql_fetch_array($result) ) {
  ?>            
                <tr onMouseOut="this.style.background='#FFFFFF'" onMouseOver="this.style.background ='#FFA346';">
                    <td><?php echo $row['language']; ?></td>
                    <td><?php echo $row['titleCertificate']; ?></td>
                    <td><?php echo $row['snCertificate']; ?></td> 
                    <td><?php if($row['teachability']==0){echo 'Όχι';}else {echo 'Ναι';}?></td>
                    <td align="center"><a href="?option=com_content&view=article&id=18&entryId=<?php echo $row['id'];?>&lLevel=<?php echo $row['languageTypeId']; ?>">[Επεξεργασία]</a></td>
                    <td align="center"><a href="?option=com_content&view=article&id=20&entryId=<?php echo $row['id'];?>&req=0">[Διαγραφή]</a></td>       
                </tr>
  <?php 
            }
            echo "</table>";
            echo "<p><center>[ <a href='?option=com_content&view=article&id=16'>+ Προσθήκη</a> ]</center></p>";    
        }
        else {
            echo "<font color='red'>Δεν υπάρχουν καταχωρημένα στοιχεία για τις Ξένες Γλώσσες.</font>";
            echo "<p><center>[ <a href='?option=com_content&view=article&id=16'>+ Προσθήκη</a> ]</center></p>";    
        }
    }
    else {
        echo "<br><font color='red'>Απογορεύεται η πρόσβαση. Δεν είστε συνδεδεμένοι!</fpnt>";
    }
?>