#!/usr/bin/perl

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

$long = $ENV{'QUERY_STRING'};

if ($long) {
	@pairs=split(/&/,$long);
	foreach $item(@pairs) {
		($name,$content)=split (/=/,$item,2);
		$content=~tr/+/ /;
		$content=~ s/%(..)/pack("c",hex($1))/ge;
		if ($INPUT{$name}) { $INPUT{$name} = $INPUT{$name}.",".$content; }
		else { $INPUT{$name} = $content; }
	}
}
else {
	read(STDIN, $buffer, $ENV{'CONTENT_LENGTH'});
	@pairs = split(/&/, $buffer);
	foreach $pair (@pairs) {
		($name, $value) = split(/=/, $pair);
		$value =~ tr/+/ /;
		$value =~ s/%([a-fA-F0-9][a-fA-F0-9])/pack("C", hex($1))/eg;
		if ($INPUT{$name}) { $INPUT{$name} = $INPUT{$name}.",".$value; }
		else { $INPUT{$name} = $value; }
	}
}

if ($INPUT{'action'} eq "verify") { &verify; }
elsif ($INPUT{'action'} eq "send") { &send; }
else { &html; }


sub html {


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 $zasth = $dbh->prepare("select mlsid,firstname,lastname from agents where display = '1'");
$zasth->execute;
while (($mlsid,$firstname,$lastname) = $zasth->fetchrow_array()) {
$buildagentlist .= "<option value=\"$firstname $lastname\">$firstname $lastname</option>\n";
}

&header;


print <<"THEPAGECONTENT";
<td valign="top" width="581">
<img src="images/headers/contacta_realtor.gif" width="581" height="33" alt="Contact A Realtor"><br>
<table border="0" cellpadding="4" cellspacing="0" width="581">
<tr>
<td valign="top" width="581">
<center>
	<form action="contact_a_realtor.idx" method="POST">
	<input type="hidden" name="action" value="verify">

		<table border="0" cellspacing="0" cellpadding="2" width="530">
			<tr>
				<td colspan="2"><b>Please fill out the following form to have a REALTOR contact you:</b></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td>*first name</td>
				<td>*last name</td>
			</tr>
			<tr>
				<td><INPUT TYPE="TEXTBOX" NAME="FIRSTNAME" SIZE="25" MAXLENGTH="25">&nbsp;</td>
				<td><INPUT TYPE="TEXTBOX" NAME="LASTNAME" SIZE="25" MAXLENGTH="25"></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td>*your email address</td>
				<td nowrap>*are you currently working with a realtor?</td>
			</tr>
			<tr>
				<td><INPUT TYPE="TEXTBOX" NAME="EMAILADDRESS" SIZE="25" MAXLENGTH="100">&nbsp;</td>
				<td><INPUT TYPE="RADIO" NAME="CURCUST" VALUE="Y">&nbsp;Yes&nbsp;<INPUT TYPE="RADIO" NAME="CURCUST" VALUE="N"></span>&nbsp;No</td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="2" align="center"><img src="images/black_fill.gif" height="2" width="525"><br></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="2"><b>contact information</b></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td>how should we contact you?</td>
				<td>best time to contact</td>
			</tr>
			<tr>
				<td><SELECT NAME="contacttype"><option value="Home">Home Phone</option><option value="Work">Work Phone</option><OPTION VALUE="Email" SELECTED>E-Mail</option></SELECT></td>
				<td><SELECT NAME="besttime">
					<option value="---">-- Choose --</option>
					<option value="6:00 AM">6:00 AM</option>
					<option value="7:00 AM">7:00 AM</option>
					<option value="8:00 AM">8:00 AM</option>
					<option value="9:00 AM">9:00 AM</option>
					<option value="10:00 AM">10:00 AM</option>
					<option value="11:00 AM">11:00 AM</option>
					<option value="12:00 PM">12:00 PM</option>
					<option value="1:00 PM">1:00 PM</option>
					<option value="2:00 PM">2:00 PM</option>
					<option value="3:00 PM">3:00 PM</option>
					<option value="4:00 PM">4:00 PM</option>
					<option value="5:00 PM">5:00 PM</option>
					<option value="6:00 PM">6:00 PM</option>
					<option value="7:00 PM">7:00 PM</option>
					<option value="8:00 PM">8:00 PM</option>
					<option value="9:00 PM">9:00 PM</option>
					<option value="10:00 PM">10:00 PM</option>
					<option value="11:00 PM">11:00 PM</option>
					<option value="---">----</option>
					<option value="Any">Any Time</option>
					<option value="Other">Other Time</option>
					</SELECT></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td>*home phone</td>
				<td>work / mobile phone</td>
			</tr>
			<tr>
				<td><INPUT TYPE="TEXTBOX" NAME="HOME_AREA_CODE" SIZE="3" MAXLENGTH="3">-<INPUT TYPE="TEXTBOX" NAME="HOME_PREFIX" SIZE="3" MAXLENGTH="3">-<INPUT TYPE="TEXTBOX" NAME="HOME_PHONE" SIZE="4" MAXLENGTH="4"></td>
				<td><INPUT TYPE="TEXTBOX" NAME="WORK_AREA_CODE" SIZE="3" MAXLENGTH="3">-<INPUT TYPE="TEXTBOX" NAME="WORK_PREFIX" SIZE="3" MAXLENGTH="3">-<INPUT TYPE="TEXTBOX" NAME="WORK_PHONE" SIZE="4" MAXLENGTH="4"></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="2" align="center"><img src="images/black_fill.gif" height="2" width="525"><br></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="2"><b>optional information</b></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
	</table>

	<table border="0" cellspacing="0" cellpadding="2" width="530">
			<tr>
				<td nowrap>do you currently own or rent</td>
				<td nowrap>buying or selling time frame</td>
				<td nowrap>do you have a preferred agent?</td>
			</tr>
			<tr>
				<td>
					<INPUT TYPE=RADIO NAME=IOwnOrRent VALUE="I Currently Own"> Own&nbsp;&nbsp;&nbsp;<INPUT TYPE=RADIO NAME=IOwnOrRent VALUE="I Currently Rent">Rent
				</td>
				<td>
					<SELECT NAME=iMovingTime>
					<OPTION VALUE = "">select time</option>
					<OPTION VALUE = "">---------------------&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</option>
					<OPTION value="0-3 Months">0-3 months</option>
					<OPTION value="3-6 Months">3-6 months</option>          
					<OPTION value="6-12 Months">6-12 months</option>
					<OPTION value="12+ Months">12+ months</option>
					</SELECT>					
				</td>
				<td>
				<select name=Preferred_Agent>
				<option value=a&nbsp;top&nbsp;producing&nbsp;agent>Select Agent</option>
				<option value=a&nbsp;top&nbsp;producing&nbsp;agent>Please Choose For Me</option>
				<option value=>==================</option>
				$buildagentlist
				</select>
				</td>
			</tr>
			<tr>
				<td colspan="3"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="3">please send your comments</td>
			</tr>
			<tr>
				<td colspan="3"><TEXTAREA NAME="COMMENTS" ROWS="6" COLS="63" wrap=true></TEXTAREA></td>
			</tr>
			<tr>
				<td colspan="3"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="3" align="center"><img src="images/black_fill.gif" height="2" width="525"><br></td>
			</tr>
			<tr>
				<td colspan="3"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="3"><center><input type="submit" value="Proceed To The Next Page"></center></td>
			</tr>
		</table>
	</form>



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


THEPAGECONTENT


&footer;

}

sub verify {


require "config.idx";
&header;


if ($INPUT{'CURCUST'} eq "Y") {
$CURCUST = "Yes";
}
else {
$CURCUST = "No";
}

print <<"THEPAGECONTENT";
<td valign="top" width="581">
<img src="images/headers/contacta_realtor.gif" width="581" height="33" alt="Contact A Realtor"><br>
<table border="0" cellpadding="4" cellspacing="0" width="581">
<tr>
<td valign="top" width="581">
<center>
	<form action="contact_a_realtor.idx" method="POST">
	<input type="hidden" name="action" value="send">
	<input type="hidden" name="FIRSTNAME" value="$INPUT{'FIRSTNAME'}">
	<input type="hidden" name="LASTNAME" value="$INPUT{'LASTNAME'}">
	<input type="hidden" name="EMAILADDRESS" value="$INPUT{'EMAILADDRESS'}">
	<input type="hidden" name="CURCUST" value="$CURCUST">
	<input type="hidden" name="contacttype" value="$INPUT{'contacttype'}">
	<input type="hidden" name="besttime" value="$INPUT{'besttime'}">
	<input type="hidden" name="HOME_AREA_CODE" value="$INPUT{'HOME_AREA_CODE'}">
	<input type="hidden" name="HOME_PREFIX" value="$INPUT{'HOME_PREFIX'}">
	<input type="hidden" name="HOME_PHONE" value="$INPUT{'HOME_PHONE'}">
	<input type="hidden" name="WORK_AREA_CODE" value="$INPUT{'WORK_AREA_CODE'}">
	<input type="hidden" name="WORK_PREFIX" value="$INPUT{'WORK_PREFIX'}">
	<input type="hidden" name="WORK_PHONE" value="$INPUT{'WORK_PHONE'}">
	<input type="hidden" name="IOwnOrRent" value="$INPUT{'IOwnOrRent'}">
	<input type="hidden" name="iMovingTime" value="$INPUT{'iMovingTime'}">
	<input type="hidden" name="Preferred_Agent" value="$INPUT{'Preferred_Agent'}">
	<input type="hidden" name="COMMENTS" value="$INPUT{'COMMENTS'}">
		<table border="0" cellspacing="0" cellpadding="2" width="530">
			<tr>
				<td colspan="2"><b>Please verify your information before submitting to have a REALTOR contact you</b></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td>*first name</td>
				<td>*last name</td>
			</tr>
			<tr>
				<td><font size="2" color="red"><b>$INPUT{'FIRSTNAME'}&nbsp;</b></font></td>
				<td><font size="2" color="red"><b>$INPUT{'LASTNAME'}</b></font></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td>*your email address</td>
				<td nowrap>*are you currently working with a realtor?</td>
			</tr>
			<tr>
				<td><font size="2" color="red"><b>$INPUT{'EMAILADDRESS'}&nbsp;</b></font></td>
				<td><font size="2" color="red"><b>$CURCUST</b></font></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="2" align="center"><img src="images/black_fill.gif" height="2" width="525"><br></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="2"><b>contact information</b></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td>how should we contact you?</td>
				<td>best time to contact</td>
			</tr>
			<tr>
				<td><font size="2" color="red"><b>$INPUT{'contacttype'}</b></font></td>
				<td><font size="2" color="red"><b>$INPUT{'besttime'}</b></font></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td>*home phone</td>
				<td>work / mobile phone</td>
			</tr>
			<tr>
				<td><font size="2" color="red"><b>$INPUT{'HOME_AREA_CODE'}-$INPUT{'HOME_PREFIX'}-$INPUT{'HOME_PHONE'}</b></font></td>
				<td><font size="2" color="red"><b>$INPUT{'WORK_AREA_CODE'}-$INPUT{'WORK_PREFIX'}-$INPUT{'WORK_PHONE'}</b></font></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="2" align="center"><img src="images/black_fill.gif" height="2" width="525"><br></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="2"><b>optional information</b></td>
			</tr>
			<tr>
				<td colspan="2"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
	</table>

	<table border="0" cellspacing="0" cellpadding="2" width="530">
			<tr>
				<td nowrap>do you currently own or rent</td>
				<td nowrap>buying or selling time frame</td>
				<td nowrap>do you have a preferred agent?</td>
			</tr>
			<tr>
				<td>
					<font size="2" color="red"><b>$INPUT{'IOwnOrRent'}</b></font>
				</td>
				<td>
					<font size="2" color="red"><b>$INPUT{'iMovingTime'}</b></font>
				</td>
				<td>
					<font size="2" color="red"><b>$INPUT{'Preferred_Agent'}</b></font>
				</td>
			</tr>
			<tr>
				<td colspan="3"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="3" bgcolor="#E2E2E2"><b>your comments</b></td>
			</tr>
			<tr>
				<td colspan="3" bgcolor="#E2E2E2"><font size="2" color="red"><b>$INPUT{'COMMENTS'}</b></font></td>
			</tr>
			<tr>
				<td colspan="3"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="3" align="center"><img src="images/black_fill.gif" height="2" width="525"><br></td>
			</tr>
			<tr>
				<td colspan="3"><img src="images/trans.gif" height="3" width="1"><br></td>
			</tr>
			<tr>
				<td colspan="3"><center><input type="submit" value="Looks Correct Send Contact Request"></center></td>
			</tr>
		</table>
	</form>



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


THEPAGECONTENT


&footer;

}

sub send {

$sendto = "info\@eagle-online.com";

open(MAIL,"|/usr/sbin/sendmail -t");
print MAIL "To: $sendto\n";
print MAIL "From: info\@munciemls.com\n";
print MAIL "Subject: \*\*Online Contact Request Recieved!\*\*\n\n";
print MAIL "NEW ONLINE CONTACT REQUESTED ONLINE!\nBelow is a copy of the contact request.\n\n\nContact Information:\n$INPUT{'FIRSTNAME'} $INPUT{'LASTNAME'}\n$INPUT{'EMAILADDRESS'}\n\n\nCurrently working with a REALTOR: $INPUT{'CURCUST'}\nContact: $INPUT{'contacttype'} at $INPUT{'besttime'}\nHome Phone: $INPUT{'HOME_AREA_CODE'}-$INPUT{'HOME_PREFIX'}-$INPUT{'HOME_PHONE'}\nWork Phone: $INPUT{'WORK_AREA_CODE'}-$INPUT{'WORK_PREFIX'}-$INPUT{'WORK_PHONE'}\n\nPreferred Agent: $INPUT{'Preferred_Agent'}\nOwn Or Rent: $INPUT{'IOwnOrRent'}\nMoving Time: $INPUT{'iMovingTime'}\n\nComments: $INPUT{'COMMENTS'}\n\n\n";
close(MAIL);

open(MAIL,"|/usr/sbin/sendmail -t");
print MAIL "To: $INPUT{'EMAILADDRESS'}\n";
print MAIL "From: info\@munciemls.com\n";
print MAIL "Subject: \*\*Your Recent Online Contact Request!\*\*\n\n";
print MAIL "Thank you for your recent inquiry with MuncieMLS.com!\nBelow is a copy of the online request for your records.\n\n\nContact Information:\n$INPUT{'FIRSTNAME'} $INPUT{'LASTNAME'}\n$INPUT{'EMAILADDRESS'}\n\n\nCurrently working with a REALTOR: $INPUT{'CURCUST'}\nContact: $INPUT{'contacttype'} at $INPUT{'besttime'}\nHome Phone: $INPUT{'HOME_AREA_CODE'}-$INPUT{'HOME_PREFIX'}-$INPUT{'HOME_PHONE'}\nWork Phone: $INPUT{'WORK_AREA_CODE'}-$INPUT{'WORK_PREFIX'}-$INPUT{'WORK_PHONE'}\n\nPreferred Agent: $INPUT{'Preferred_Agent'}\nOwn Or Rent: $INPUT{'IOwnOrRent'}\nMoving Time: $INPUT{'iMovingTime'}\n\nComments: $INPUT{'COMMENTS'}\n\n\n";
close(MAIL);

require "config.idx";

&header;

print <<HTML2;

<td valign="top" width="581">
<img src="images/headers/contacta_realtor.gif" width="581" height="33" alt="Contact A Realtor"><br>
<font face="Arial"><font size="3"><b>
$INPUT{FIRSTNAME}, Your Request Has Been Successfully Submitted!</b><br>
<i>Please expect a response shortly</i><br><br>
<center><A HREF="http://www.munciemls.com">Return To MuncieMLS.com!</A></center>
</font></font>
</td>


HTML2

&footer;

}