<?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) {
 // Check for override hours ---------------------------------------------------------------------------------       
        $isCovered = false;
        $Q = "SELECT * FROM available_hours WHERE userId='".$user->id."'";
        $availability = mysql_query($Q);
        
        while( $row = mysql_fetch_array($availability) ) {
            
            if($row['day'] == $_POST['day']) {
                
                 if( $_POST['fromHour'] <= $row['fromHour'] && $_POST['toHour'] >= $row['fromHour']) {
                        $isCovered = true;
                        break;    
                 }
                 if($_POST['fromHour'] >= $row['fromHour'] && $_POST['toHour'] <= $row['toHour']) {
                        
                        $isCovered = true;
                        break;   
                 }
                 if($_POST['fromHour'] <= $row['fromHour'] && $_POST['toHour'] >= $row['fromHour']) {
                     
                        $isCovered = true;
                        break;   
                 }
            }         
        }
 // End of Check for override hours --------------------------------------------------------------------------
          
        if($isCovered) {      
            echo "<font color='red'>Εσφαλμένη καταχώρηση.Υπήρξε επικάλυψη των διαθέσιμων ωρών.</font><br><br>";
            echo "[<a href='?option=com_content&view=article&id=6&Itemid=7'> Πίσω </a>]";   
        }
        else {
            $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 = "INSERT INTO available_hours(`userId`, `day`,`fromHour`,`toHour`,`comment`,`rank`)
                  VALUES('".$user->id."', '".$_POST['day']."', '".$_POST['fromHour']."', '".$_POST['toHour']."', '".$_POST['comment']."', '0')";  
            
            if(mysql_query($Q)) {
                echo "<b><font color='blue'>Επιτυχής Καταχώρηση!</font></b><br>";
                echo "[<a href='?option=com_content&view=article&id=6&Itemid=7'> Συνέχεια </a>]"; 
            }
            else {
                echo "<font color='red'>Υπήρξε Σφάλμα κατά την Καταχώρηση της εγγραφής σας.</font><br><br>";
                echo "[<a href='?option=com_content&view=article&id=6&Itemid=7'> Πίσω </a>]";     
            }  
        }
    }
    else {
        echo "<br><font color='red'>Απογορεύεται η πρόσβαση. Δεν είστε συνδεδεμένοι!</fpnt>";
    }
?>