
<?
if (isset($_POST['pickup'])) {
  $_POST = array_map('mysql_real_escape_string', $_POST);
  $table = "car_pickup";
  unset ($_POST['pickup']);
  unset ($_POST['requiredStateC']);

  $VIN = $_POST['requiredVehicle_Identification_Number'];
  $don_email = $_POST['requiredEmail'];

  $dupcheck = mysql_query("SELECT id FROM ".$table." WHERE requiredVehicle_Identification_Number='".$VIN."'")or die(mysql_error());
  $dupcheck2 = mysql_num_rows($dupcheck);
  if ($dupcheck2 > 0) {
    $msg = "Either you hit Submit more then once or you have already submitted a pickup request on this vehicle.";
  } else {
    $numberq = mysql_query("SELECT * FROM phc_numbering WHERE location='".$location."'")or die(mysql_error());
    $nresult = mysql_num_rows($numberq);
    if ($nresult < 1 ) {
      $nquery = "INSERT INTO `phc_numbering` (`location`, `count`) VALUES ('".$location."', '1')";
      $result = mysql_query($nquery)or die(mysql_error());
      $ncount = 1;
    } else {
      $nresult = mysql_fetch_array($numberq);
      $ncount = $nresult['count'] + 1;
      $update = mysql_query("UPDATE phc_numbering SET count='".$ncount."' WHERE location='".$location."'")or die(mysql_error());
    }
    $_POST['tracking_id'] = "C" . str_pad($ncount, 8, "0", STR_PAD_LEFT) . "-" . $location;
    $query = "INSERT INTO `".$table."` (";
    $trigger = 0;

    foreach($_POST as $field => $value){
      if($trigger > 0){
        $query = $query . ", ";
      }
      $query = $query . $field;
      $trigger++;
    }
    $query = $query . ") VALUES (trim('";
    $trigger = 0;
    foreach($_POST as $field => $value){
      if($trigger > 0){
        $query = $query . ", trim('";
      }
	$value = str_replace(",", "", $value);
	$value = str_replace("\'", "", $value);
	$value = str_replace("\\", "", $value);
      $query = $query . $value."')";
      $trigger++;
    }
    $query = $query . ");";
    $result = mysql_query($query)or die(mysql_error());

// 5/3/12 Send e-mail to us so we know there is a donation
if($_POST['donation_agent'] != 'Web') {
$mrsmith = "This donation was submitted by an agent.";
}
else {
$mrsmith = "This donation was submitted through the web site.";
}
$thefname = $_POST['requiredFirstName'];
$thelname = $_POST['requiredLastName'];
$thefullname = $thefname . " " . $thelname;
$thedphone = $_POST['requiredHome_Phone'];
$thedemail = $_POST['requiredEmail'];
$thedcity = $_POST['requiredCity'];
$thedstate =  $_POST['requiredState'];
$thedzip =  $_POST['requiredZip_Code'];
$thedtype =  $_POST['requiredType'];
$thedyear =  $_POST['requiredYear'];
$thedmake =  $_POST['requiredMake'];
$thedmodel =  $_POST['requiredModel'];
$thedcolor =  $_POST['requiredColor'];
$thedvin =  $_POST['requiredVehicle_Identification_Number'];
$thedmilage =  $_POST['mileage'];
$theloc = $_POST['requiredState'];
$thedno = $_POST['tracking_id'];
$okname = "Purple Heart Cars (phcars.org)";
$dondate = date("F-d-Y g:iA T");
$email_contents = "Tracking ID: $thedno\n";
$email_contents .= "Donated To: Purple Heart Cars\n";
$email_contents .= "Donation Date: $dondate \n";
$email_contents .= "$mrsmith\n\n";
$email_contents .= "Type: $thedtype Donation\n";
$email_contents .= "Vin: $thedvin\n";
$email_contents .= "Year: $thedyear\n";
$email_contents .= "Make: $thedmake\n";
$email_contents .= "Model: $thedmodel\n";
$email_contents .= "Color: $thedcolor\n";
$email_contents .= "Milage: $thedmilage\n";
$email_contents .= "Location: $thedcity, $thedstate, $thedzip\n";
$subject = "PHC-Donation: " . $thedno;
$extra_headers .= "From: PHC Donation Form <noreply@purpleheartcars.org>\r\n";
//$to  = 'ab@domain.com' . ', '; // note the comma
//$to .= 'ab@domain.com' . ', '; // note a second comma
//$to = 'dmastrianni@purpleheartfoundation.org';
$to = 'wallen@purpleheartfoundation.org';

mail($to,$subject,"$email_contents",$extra_headers);

    // mail the user the information
    $email = $don_email;
    include '../pickup_form_mail.php';
    $subject = $mailSubj;
    $message = $mailMessage;
    $headers .= "MIME-Version: 1.0\r\n";
    $headers .= "Content-type: text/html; charset=iso-8859-1\r\n";
    $headers .= "From: $mailFrom\r\n";

//    if (in_array($location, $a)) {
//      $headers .= "BCC: donate@purpleheartcars.org\r\n";
//    }

    mail($email, $subject, $message, $headers);
    $msg = "Thank you.  Your donation pickup request has been submitted.";
    $donated = "yes";
  }
}
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" >

<head>
<meta name="author" content="J Frazier, Purple Heart Services, Inc." />
<meta http-equiv="content-type" content="text/html;charset=utf-8" />
<title>Purple Heart Cars : Purple Heart Foundation | Donate My Car, Truck, Boat or RV to Purple Heart Cars</title>          
<meta name="RESOURCE-TYPE" content="DOCUMENT" />
<meta name="DISTRIBUTION" content="GLOBAL" />
<meta name="COPYRIGHT" content="Copyright (c) by Purple Heart Service Foundation" />
<meta name="KEYWORDS" content="Donate a car, boat, RV, Donate my car, Car donation, Purple Heart, Purple Heart Cars, Purple Heart Foundation, Combat veteran, Veterans Administration, Car donation, Combat veteran, business, training, center, vbtc, student center, disabled, combat wounded" />
<meta name="DESCRIPTION" content="Purple Heart Cars Donation Program - Purple Heart Foundation | Donate my car, truck, boat or rv to the Purple Heart Cars helps to sustain the local programs and services available to combat wounded and disabled veterans." />
<meta name="ROBOTS" content="INDEX, FOLLOW" />
<meta name="RATING" content="GENERAL" />
<link rel="stylesheet" href="../inc/style.css" type="text/css" />
<script language="JavaScript" type="text/javascript" src="http://www.phcars.org/inc/required.js"></script>
</head>
<body>

<div id="main" >
	<div id="spacer"></div>

<? $headerstate = $filterarray[$location];

if (in_array($location, $a)) {
  echo "<div id=\"head-donate2\"><b>&nbsp;".$headerstate."</b></div>";
} else {
  echo "<div id=\"head-donate\"><b>&nbsp;".$headerstate."</b></div>";
} ?>

    <div id="content-sub">
    <div id="nav-sub"><br /><br />
<a href="index.php?p=home&amp;S=PA&amp;agent=Web">Home</a>
<a href="index.php?p=about&amp;S=PA&amp;agent=Web">About Us</a>
<a href="index.php?p=why&amp;S=PA&amp;agent=Web">Why Donate</a>
<a href="index.php?p=items&amp;S=PA&amp;agent=Web">Items Accepted</a>
<a href="index.php?p=faq&amp;S=PA&amp;agent=Web">FAQ</a>
<a href="index.php?p=form&amp;S=PA&amp;agent=Web" class="red">Donate Now</a>
<a href="index.php?p=contact&amp;S=PA&amp;agent=Web">Contact Us</a>
<a href="http://www.phcars.org/index.php?agent=Web">Other States</a><br /><br />
    </div>
    <div id="nav-content">
<br /><br />

<? if (empty($_GET['p'])) {
  include "../form.php";
} else {
  $page = $_GET['p'];
  if ($page == "faq") {
    include "../faq.php";
  } elseif ($page == "about") {
    include "../about.php";
  } elseif ($page == "why") {
    include "../why.php";
  } elseif ($page == "items") {
    include "../items.php";
  } elseif ($page == "contact") {
    include "../contact.php";
  } elseif ($page == "form") {
    include "../form.php";
  } else {
    include "../home.php";
  }
} ?>

<br />
    </div>
  </div>
  <div id="footer-sub">
&copy; 2009 Purple Heart Services, a 501(c)(3) not-for-profit charity of the<br /> 
<a href="http://www.purpleheartfoundation.org" target="_blank">Military Order of the Purple Heart Service Foundation, Inc</a>. All Rights Reserved.
  </div>
</div>

<? include '../convtracker.php'; ?>

</body>
</html>

<?
if (isset($msg)) { confirm($msg); }
?>