<php 
Echo "VAOffices.php<BR>";

$Sorry="$State State District Office already claimed. Please collect signatures for this office.
					Remember to give the timism handout <I>with your email address</I> to each person you approach.
					each person you sponsor earns you five lifehour credits at the start. The petition is ";
 		$Winner="You are the winner. Timist entry in $db completed for $MemberEmail<BR>
						Your customized ballot petition is ";
		$con=mysqli_connect("localhost","timismor_RSB","ZVPdPT8^]v^q","timismor_EarnLifehours");
 		$db="NewTParty";
 			if (substr_count($Defaults,"TESTDB")) {$db.="Test";}		

		echo "<P>State Upper House Homesteading<BR>";
		$sql="SELECT * FROM $db WHERE State='$State' and StDivSu='$StDivSu'";
			$result = mysqli_query($con, $sql) or die("Could not execute query Sql of $con");
			$IDdb="";
			While($row = mysqli_fetch_array($result))
			{$IDdb=$row['ID'];
			 $dbEmailAddr=$row['Email'];
			}

		$flStUpPDF="<A HREF=https://timism.com/TmOrgHtm/2015Rush/$State/$StDivSu.pdf target=_blank>$State$StDivSu</A>";
		if ($IDdb=="")
			{	echo "Pre state define $State<BR>";
				$State="Virginia"; #NmState
				$Office="Senate (State Upper House)";
				$OfficeCode="StLegSu";
				fxPetitionCreate($Office); #SubmitBy, ElectMonth, ElectDay, ElectYear
				echo "$Winner $flStUpPDF .<P>
					As winner of an upper legislative office, you are not considered for the unhomesteaded lower office. 
					Hopefully, you will collect signatures for the lower office. Be sure to give the 
					<A HREF=http://handout>handout</A> to others to collect five lifehour credits.<P>";
					$result="INSERT INTO $db 
						(ID,State,StDivSu,Email,LastName,FirstName,StreetAddr,City,PostalCode,IPaddr)
					VALUES 
						('$ID','$State','$StDivSu','$MemberEmail','$LastName','$FirstName','$StreetAddr','$City','$PostalCode','$IPaddr')"; 
					mysqli_query($con, $result); 
			}
		else 
			{echo $StDivSu . $Sorry . $flStUpPDF;
				################ test for lower office ################
				echo "<P>State Lower House Homesteading<BR>";
				$sql="SELECT * FROM $db WHERE State='$State' and StDivSl='$StDivSl'";
	 			$result = mysqli_query($con, $sql) or die("Could not execute query Sql of $con");
	 			$IDdb="";
	 			While($row = mysqli_fetch_array($result))
					{$IDdb=$row['ID'];
					 $dbEmailAddr=$row['Email'];
					}
					$flStLoPDF="<A HREF=https://timism.com/TmOrgHtm/2015Rush/$State/$StDivSl.pdf target=_blank>$State$StDivSl</A>";
	 			
					if ($IDdb<>"")
						{echo $StDivSl . $Sorry . $flStLoPDF."<P>";
						}
					else
						fxPetitionCreate("Virginia","House",$StDivSl);
							echo "$Winner $flStLoPDF .<BR>
						When you collect signatures for your ballot access, please also collect for your upper house homesteader with $flStUpPDF.
						Be sure to give the <A HREF=http://handout>handout</A> to others to collect five lifehour credits.<P>";
						$result="INSERT INTO $db 
							(ID,State,StDivSl,Email,LastName,FirstName,StreetAddr,City,PostalCode,IPaddr)
						VALUES 
							('$ID','$State','$StDivSl','$MemberEmail','$LastName','$FirstName','$StreetAddr','$City','$PostalCode','$IPaddr')"; 
						mysqli_query($con, $result); 
					echo "Timist entry in $db completed for $MemberEmail of $State $StDivSl.<BR>";
			}
			
		#die ("EOC Rush2015State");
 		break; 	

?>