#!/usr/bin/perl

print "Content-type: text/html\n\n";

require "config.idx";


use DBI;
my $dsn = "DBI:mysql:database=$d_name;host=localhost";
my $dbh = DBI->connect($dsn, $d_username, $d_pass, {RaiseError => 1}) || die $DBI::errstr;

my $hasth = $dbh->prepare("select firstname,lastname,email from users where userid = '$Cook{userid}'");
$hasth->execute;
while (($s_firstname,$s_lastname,$s_email) = $hasth->fetchrow_array()) {
$send_body = "$s_firstname $s_lastname $s_email";
}


open(MAIL,"|/usr/sbin/sendmail -t");
print MAIL "To: ryan\@orrhomes.com\n";
print MAIL "From: admin\@munciemls.com\n";
print MAIL "Subject: Read MuncieMLS.com SA\n";
print MAIL "Content-type: text/html\n\n";
print MAIL "$send_body\n";
close(MAIL);




&header;

print <<"STARTPAGECONTENT";
<td valign=top>
<table border="0" cellpadding="6" cellspacing="0" width="581">
<tr>
<td valign="top">
<font face="Trebuchet MS" size="3">
<font size="4"><b>MuncieMLS.com MLS Data Service Note</b><br><br>
<b>November 11th, 2006 at 10:32AM</b><br><br>
<b>For Immediate Release to all MuncieMLS.com users</b><br><br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Yesterday afternoon our MLS data provider experienced a glitch in which some past listings status was changed to ACTIVE allowing the homes to show on our website.   Prior listing data was available on our website from 5:30PM November 9th, 2006 to this morning at 10:06AM.   If you viewed or saved listings during this time please double check to see if the listing is still available.   If you saved the Listing to your MyHomes account it will automatically inform you the listing is no longer available.<br><br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;We are very sorry for the problem however the problem was out of our control and did affect other IDX enabled websites.     Please note: If you received a New Listing Notification yesterday for your saved search please delete the email as it contains mostly invaild information.
<br><br>&nbsp;&nbsp;&nbp;&nbsp;&nbsp;&nbsp;At this time our data is restored and all functions of MuncieMLS.com are up and running again.    Thank you for your understanding and use of our website!<br><br>Any questions or comments may be directed to Ryan Orr [ <a href="mailto:ryan\@orrhomes.com">Ryan\@ORRHomes.com</a> ].
</font>

</td>
</tr>
</table>

STARTPAGECONTENT


&footer;