<?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 * FROM available_hours WHERE userId='".$user->id."'";
                
        $result = mysql_query($Q);
  
        if( mysql_num_rows($result) != FALSE ) {
?>
<br> 
            <table width="100%" align="center">
                <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['day']; ?></td>
                    <td><?php echo $row['fromHour']; ?></td> 
                    <td><?php echo $row['toHour']; ?></td>  
                    <td><?php echo $row['comment']; ?></td>    
                    <td align="center"><a href="?option=com_content&view=article&id=39&entryId=<?php echo $row['id'];?>">[Επεξεργασία]</a> </td>
                    <td align="center"><a href="?option=com_content&view=article&id=40&entryId=<?php echo $row['id'];?>&req=0">[Διαγραφή]</a></td>       
                </tr>
  <?php 
            }
            echo "</table>";
            echo "<p><center>[ <a href='?option=com_content&view=article&id=37'>+ Προσθήκη</a> ]</center></p>";    
        }
        else {
            echo "<font color='red'>Δεν υπάρχουν καταχωρημένα στοιχεία για τις Διαθέσιμες Ώρες.</font>";
            echo "<p><center>[ <a href='?option=com_content&view=article&id=37'>+ Προσθήκη</a> ]</center></p>";    
        }
    }
    else {
        echo "<br><font color='red'>Απογορεύεται η πρόσβαση. Δεν είστε συνδεδεμένοι!</font>";
    }
?>