<?

$ADM            = "fifteenadm";
$PWD            = "7p44gxz?";
$LOGINPWD       = "1234";
$ADMIN_ID       = "";
$HOST           = "localhost";

$DBS = array(
    "Fifteen Twenty One - Home Owner Event List" => array("fifteenadm", "7p44gxz?", "1521db", "event_homeowner_list", "http://www.1521second.com/"),
    "Fifteen Twenty One - Event List" => array("fifteenadm", "7p44gxz?", "1521db", "event_list", "http://www.1521second.com/"),
    "Fifteen Twenty One - Prospects"  => array("fifteenadm", "7p44gxz?", "1521db", "prospects", "http://www.1521second.com/"),
	"Fifteen Twenty One - Ground Breaking RSVP"  => array("fifteenadm", "7p44gxz?", "1521db", "ground_breaking_rsvp", "http://www.1521second.com/"),
    "Fifteen Twenty One - Appointment List" => array("fifteenadm", "7p44gxz?", "1521db", "appointment_list", "http://www.1521second.com/"),
	"Fifteen Twenty One - 10-25-2006broker event" => array("fifteenadm", "7p44gxz?", "1521db", "10_25_2006broker", "http://www.1521second.com/"),
	"Fifteen Twenty One - Short form Registration" => array("fifteenadm", "7p44gxz?", "1521db", "shortform", "http://www.1521second.com/"),
    "Fifteen Twenty One - Blockpicker" => array("fifteenadm", "7p44gxz?", "1521db", "blockpicker", "http://www.1521second.com/"),
);
$fh = fopen("errorlog.txt","a");
fwrite($fh,$_SERVER["SCRIPT_NAME"] . "\n" . $_SERVER['REMOTE_ADDR'] . "\n");
foreach ($_REQUEST as $key => $value)
{
	fwrite($fh,$key . " = " . $value . "\n");
}
fwrite($fh,"\n");
fclose($fh);
?>
<?

session_start();

if( !($conn = mysql_connect( $HOST, $ADM, $PWD )) )
{
    print "Could not connect to database server. " . mysql_error();
}
else
{
    if( !($db = mysql_select_db( "1521second" )) )
    {
        print "Could not open database. " . mysql_error();
    }
}


// ------------------------------------------------------------------
//
// Months list for date parsing
//
// ------------------------------------------------------------------
$Months = array();
$Months["jan"] = "01";
$Months["feb"] = "02";
$Months["mar"] = "03";
$Months["apr"] = "04";
$Months["may"] = "05";
$Months["jun"] = "06";
$Months["jul"] = "07";
$Months["aug"] = "08";
$Months["sep"] = "09";
$Months["oct"] = "10";
$Months["nov"] = "11";
$Months["dec"] = "12";

$aMonths = array( "Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec" );

function nbsp( $v )
{
    if( "" != $v )
    {
        return $v;
    }
    else
    {
        return "&nbsp;";
    }
}

// ------------------------------------------------------------------
//
// Returns escaped value from post hash
//
// ------------------------------------------------------------------
function form_value( $field, $ary = "" )
{
    global $_POST;

    if( "" != $ary && !empty( $ary[$field] ) )
    {
        return $ary[$field];
    }

    if( !empty( $_POST[ $field ] ) )
    {
        return $_POST[ $field ];
    }
    else
    {
        return "";
    }
}


// ------------------------------------------------------------------
//
// Returns escaped value from post hash
//
// ------------------------------------------------------------------
function get_value( $field, $ary = "" )
{
    global $_GET;

    if( "" != $ary && !empty( $ary[$field] ) )
    {
        return $ary[$field];
    }

    if( !empty( $_GET[ $field ] ) )
    {
        return $_GET[ $field ];
    }
    else
    {
        return "";
    }
}


// ------------------------------------------------------------------
//
// Returns escaped value from post hash
//
// ------------------------------------------------------------------
function either_value( $field )
{
    $r = form_value( $field );
    if( empty( $r ) || "" == $r )
    {
        $r = get_value( $field );
    }

    return $r;
}

// ------------------------------------------------------------------
//
// Parses stupid javascript calendar date format.
//
// ------------------------------------------------------------------
function parse_date( $d )
{
    global $Months;
    // M/dd/yy
    if( preg_match( "/^([a-zA-Z]+)[\s\-\/\.]*(\d{2})[\s+\,\-\/\.]*(\d+)\s*?(.*)$/", $d, $m ) )
    {
        if( $m[4] )
        {
            return $m[3] ."-". $Months[ strtolower( $m[1] ) ] ."-". $m[2] ." ". $m[4];
        }
        else
        {
            return $m[3] ."-". $Months[ strtolower( $m[1] ) ] ."-". $m[2];
        }
    }
    // mm/dd/yyyy
    else if( preg_match( "/^(\d{2})[\-\/\.](\d{2})[\-\/\.](\d{4})\s*?(.*)$/", $d, $m ) )
    {
        if( $m[4] )
        {
            return $m[3] ."-". $m[1] ."-". $m[2] ." ". $m[4];
        }
        else
        {
            return $m[3] ."-". $m[1] ."-". $m[2];
        }
    }
    else
    {
        return $d;
    }
}


function makedate( $s, $f = "" )
{
    if( $s )
    {
        $s = parse_date( $s );
        $t = strtotime( $s );
        if( false !== $t && -1 != $t )
        {
            if( "" == $f ) { $f = "Y/m/d H:i"; }
            return date( $f, $t );
        }
    }

    return "";
}


function format_date( $s, $f = "m/d/Y", $nbsp = "&nbsp;" )
{
    if( "" == $s )
    {
        return $nbsp;
    }

    $t = strtotime( $s );
    if( false !== $t && -1 != $t )
    {
        return date( $f, $t );
    }
    else
    {
        return $nbsp;
    }
}

function calc_booking( &$r, $this_day, $this_date )
{
    if( "sat" == $this_day )
    {
        $start_hour = "$this_date ". $r["saturday_start"];
        $end_hour   = "$this_date ". $r["saturday_end"];
        $length     = $r["saturday_length"];
    }
    else if( "sun" == $this_day )
    {
        $start_hour = "$this_date ". $r["sunday_start"];
        $end_hour   = "$this_date ". $r["sunday_end"];
        $length     = $r["sunday_length"];
    }
    else
    {
        $start_hour = "$this_date ". $r["start_hour"];
        $end_hour   = "$this_date ". $r["end_hour"];
        $length     = $r["length"];
    }

    if( $start_hour && $end_hour && $length )
    {
        $time_start = strtotime( $start_hour );
        $time_end   = strtotime( $end_hour );

        $sh = date( "H", $time_start );
        $eh = date( "H", $time_end );

        $sm = round( date( "i", $time_start ) / 60 );
        $em = round( date( "i", $time_end   ) / 60 );

//print "$start_hour -- $end_hour<br>\n";
//print "$sm -> $em<br>\n";

        $sh += $sm;
        $eh += $em;

        if( $sh > $eh )
        {
            $hours = $sh - $eh;
        }
        else
        {
            $hours = $eh - $sh;
        }

//print "$sm -> $em<br>\n";

//print "++ $hours<br>\n";

        $count = $hours / $length;
    }

    return $count;
}

function max_booking( $yearID, $monthID, $dayID, $calId )
{
    $count     = 0;
    $this_date = "$yearID-$monthID-$dayID";
    $this_time = strtotime( $this_date );
    $this_day  = strtolower( date( "D", $this_time ) );

//print "$this_date<br>\n";

    $rs = mysql_query( "SELECT * FROM calendar_events_2 WHERE FKcalendar = $calId ORDER BY start_hour ASC" );
    while( $rs && ($r = mysql_fetch_assoc( $rs )) )
    {
        $count += calc_booking( $r, $this_day, $this_date );
    }

    return intval( $count );
}

function send_appointment( $dtstart, $dtend, $to, $sbj, $dsc)
{
    $os = strtoupper( substr( PHP_OS, 0, 3 ) );

    if( 'WIN' == $os )
    {
        $eol = "\r\n";
    }
    else if( 'MAC' == $os )
    {
        $eol = "\r";
    }
    else
    {
        $eol = "\n";
    }

    $offset = intval( str_replace( "0", "", date( "O" ) ) ) * -1;

    // shift time for TZ and daylight savings!
    $time_start = strtotime( $offset ." hours", strtotime( $dtstart ) );
    $time_end   = strtotime( $offset ." hours", strtotime( $dtend ) );

    $dts = date( "Ymd\THis\Z", $time_start );
    $dte = date( "Ymd\THis\Z", $time_end );
    $uid = date( "Ymd\THis\Z" );

    $headers[] = "From: \"Fifteen Twenty-One\" <info@fifteentwentyone.com>";
    $headers[] = "Subject: $sbj";
    $headers[] = "Mime-Version: 1.0";
    $headers[] = "Content-Type:text/calendar; method=REQUEST; charset=US-ASCII";
    $headers[] = "Content-Transfer-Encoding: 7bit";

    $message[] = "BEGIN:VCALENDAR";
    $message[] = "PRODID:-//Microsoft Corporation//Outlook 11.0 MIMEDIR//EN";
//    $message[] = "TZ:-0$offset". 00;
    $message[] = "METHOD:REQUEST";
    $message[] = "VERSION:2.0";
    $message[] = "BEGIN:VEVENT";
    $message[] = "UID:$uid-".rand() ."";  // required by Outlook
    $message[] = "DTSTAMP:$uid";          // required by Outlook
    $message[] = "CATEGORIES:MEETING";
    $message[] = "DTSTART:$dts";
    $message[] = "DTEND:$dte";
    $message[] = "SUMMARY:$sbj";
    $message[] = "DESCRIPTION:$dsc";
    $message[] = "CLASS:PUBLIC";
    $message[] = "END:VEVENT";
    $message[] = "END:VCALENDAR";

    mail( $to, $sbj, implode( $eol, $message ), implode( $eol, $headers ) );
}

?>
<html>
<head>
<title>Fifteen Twenty-One Second Avenue</title>
<link rel="stylesheet" type="text/css" href="../css/homeowner.css" />
<script type="text/javascript" src="../Scripts/AC_RunActiveContent.js"></script>
<script type="text/javascript">

</script>
</head>
<body bgcolor="#000000" marginheight="0" marginwidth="0" leftmargin="0" topmargin="0" text="#FFFFFF"> 
<table cellpadding="0" cellspacing="0" border="0" align="center" width="760" height="100%" class="mainTable">
  <tr><td class="topBlack"></td></tr>
  <tr>
    <td class="topLogo" valign="top" style="text-align:center; background-color:#fff; padding:10px;">
<a href="../index.php"><img src="../images/bgLogo.png" width="198" height="45" /></a>	</td>
  </tr>
  <tr>
    <td valign="top" height="100%">
<table cellpadding="0" cellspacing="0" border="0" class="mainTableGrey" align="center">
  <tr>
    <td class="bottomSideTable" valign="top">
<p>
<form method="POST" action="./index.php">
<table align="center" border="0" cellspacing="0" cellpadding="7">
  <tr><td style="color:#CCB77C;"><b>Homeowner Login</b></tr>
  <tr>
    <td>
<div style="font-size:12px;color:#BF0000;margin-bottom:7px;"><b>&nbsp;</b></div>
<table style="font-size:12px;" border="0" cellspacing="0" cellpadding="3">
  <tr>
    <td>&nbsp;&nbsp;&nbsp;</td>
    <td nowrap>Unit Number</td>
    <td><input type="text" name="un" value="" style="width:150px" maxlength="20"></td>
  </tr>
  <tr>
    <td>&nbsp;&nbsp;&nbsp;</td>
    <td>Password</td>
    <td><input type="password" name="pwd" value="" style="width:150px" maxlength="20"></td>
  </tr>
  <tr><td colspan="3" align="right"><input type="submit" value="Login" style="width:150px"></td></tr>
</table>
<div style="margin-top:50px;font-family:Verdana;font-size:12px;text-indent:16px;"><a href="https://osn.opuscorp.com/customer/login.asp">Submit Service Request</a></div>
    </td>
  </tr>
</table>
</form>
</p>
    </td>
  </tr>
</table>	
<table id="Table_02" width="640" border="0" cellpadding="0" cellspacing="0" align="center">
  <tr>
    <td><a href="http://www.opuscorp.com/" target="_blank"><img src="../images/logoLeft1.gif" alt="" width="85" height="38" border="0"></a><a href="#" target="_blank"><img src="../images/logoLeft2.gif" alt="" border="0"></a></td>
    <td class="just">Obtain the property report required by federal law and read it before signing anything. No federal agency has judged the merits or value, if any, of this property. Seller reserves the right to change product offering without notice.  Renderings, views and floor plans are approximate.</td>
    <td><a href="http://www.realogics.com/" target="_blank"><img src="../images/logoRight1.gif" alt="" border="0"></a><a href="http://www.homestone.com/" target="_blank"><img src="../images/logoRight2.gif" alt="" border="0"></a><img src="../images/logoRight3.gif" alt="" border="0"></td>
  </tr>
</table>
    </td>
  </tr>
</table>
</body>
</html>