<?php
    include('config.php');
    require_once('Availability.class.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(); 
    $availabilityClass = new Availability();
    $days = $availabilityClass->getWeek();
    
                $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 id='".$_GET['entryId']."' AND userId='".$user->id."'"; 
                $result = mysql_query($Q);           
                $row = mysql_fetch_array($result);
    
    if (!$user->guest) {
         ?>
         <br>
            <a href="javascript:history.go(-1)"><b>[ << Πίσω]</b></a>  
         <br>
         
            <form method="POST" action="?option=com_content&view=article&id=41">
                <input type="hidden" name="ahId" value="<?php echo $row['id']; ?>">   
                <table align="center">
                   <tr>
                        <td>Ημέρα</td><td><select name="day">
                                                <?php
                                                    while(list($idDay,$day) = each($days)) {
                                                        if($day == $row['day'])
                                                             echo "<option id='$idDay' selected>$day</option>";
                                                        else echo "<option id='$idDay'>$day</option>";
                                                    }
                                                ?>
                                              </select>   <b> *</b>  
                        </td>
                   </tr>
                   <tr>
                        <td>Από</td><td><select name="fromHour">
                                                <?php
                                                    $hours = $availabilityClass->getHours();
                                                    while(list($idHour, $hour) = each($hours)) {
                                                        if($hour == $row['fromHour'])
                                                             echo "<option id='$idHour' selected>$hour</option>";
                                                        else echo "<option id='$idHour'>$hour</option>";
                                                    }
                                                ?>
                                              </select>  <b> *</b>  
                        </td> 
                   </tr>
                   <tr>
                        <td>Έως</td><td><select name="toHour">
                                                <?php
                                                    $hours = $availabilityClass->getHours();
                                                    while(list($idHour, $hour) = each($hours)) {
                                                        if($hour == $row['toHour'])
                                                             echo "<option id='$idHour' selected>$hour</option>";
                                                        else echo "<option id='$idHour'>$hour</option>";
                                                    }
                                                ?>
                                              </select> <b> *</b>  
                        </td> 
                    </tr>
                    <tr>
                        <td>Σχόλιο</td><td><textarea name="comment" rows="2" cols="30"><?php echo $row['comment']; ?></textarea></td>
                    </tr>
                    <tr>
                        <td colspan="2" align="right"><input type="reset" value="Απαλοιφή"> <input type="submit" value="Αποθήκευση"></td>
                    </tr>
                    <tr>
                        <td colspan="2">( * ) Υποχρεωτικά πεδία</td>
                    </tr>
                </table>
            </form>
         
<?php   
    }
    else {
        echo "<br><font color='red'>Απογορεύεται η πρόσβαση. Δεν είστε συνδεδεμένοι!</fpnt>";
    }
?>