-
-
-
-real_escape_string($web_first_name);
+ $web_last_name = $petition->real_escape_string($web_last_name);
+ $web_house_number = $petition->real_escape_string($web_house_number);
+ $web_zip_code = $petition->real_escape_string($web_zip_code);
+ $DOB = $petition->real_escape_string($DOB);
+ $PHONE = $petition->real_escape_string($PHONE);
+}else{
+ // we should NEVER hit this page anymore
+ header('Location: warning_incomplete.php');
+}
+$q = "select * from $VoterList_table where LASTNAME = '$web_last_name' and FIRSTNAME = '$web_first_name' and HOUSE_NUMBER = '$web_house_number' and RESIDENTIALZIP5 = '$web_zip_code'";
+$r = $petition->query($q);
+$d = mysqli_fetch_array($r);
+if ($d['VTRID'] != ''){
+ $VTRID = $d['VTRID'];
+ $FIRSTNAME = $d['FIRSTNAME'];
+ $MIDDLENAME = $d['MIDDLENAME'];
+ $LASTNAME = $d['LASTNAME'];
+ $ADDRESS = $d['ADDRESS'];
+ $RESIDENTIALCITY = $d['RESIDENTIALCITY'];
+ $COUNTY = $d['COUNTY'];
+ $RESIDENTIALZIP5 = $d['RESIDENTIALZIP5'];
+ slack_general('MATCH: eligible ('.$FIRSTNAME.' '.$LASTNAME.' '.$RESIDENTIALCITY.') ('.$_COOKIE['invite'].')','md-petition');
+}else{
+ slack_general('MISS: eligible ('.$web_first_name.' '.$web_last_name.' '.$PHONE.') ('.$_COOKIE['invite'].')','md-petition');
+ header('Location: warning_not_found.php');
+}
+
+if (isset($_GET['remove'])){
+ $id = $_GET['remove'];
+ $q = "update signatures set signature_status = 'removed' where id = '$id'";
+ $petition->query($q);
+ slack_general('SQL: eligible ('.$q.') ('.$_COOKIE['invite'].')','md-petition');
+ header('Location: eligible.php');
+}
+
+echo $head;
+
+
+$available='';
+$q2 = "SELECT * FROM petitions where admin_status = 'approved'";
+$r2 = $petition->query($q2);
+while($d2 = mysqli_fetch_array($r2)){
+ $checked = '';
+ $field = $d2['eligibleVoterListField'];
+ $pass = $d2['eligibleVoterListEquals'];
+
+$my_test = $d[$field];
+
+ if($my_test == $pass){
+ // good to go
+ $checked = '';
+ if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
+ $checked = 'checked';
+ }else{
+ $checked = '';
+ }
+ $available .= "
+
→←
+
$d2[petition_name]
$field == $pass
+
$d2[eligibleVoterListEnforce]
+
";
+
+ if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
+ $available .= '';
+ }
+ }else{
+ // not a eligable voter
+ $checked = '';
+ if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){
+ $checked = 'checked';
+ }else{
+ $checked = '';
+ }
+ $available .= "
+
"; if ($d2['eligibleVoterListEnforce'] == 'NO'){ $available .="→←"; }else{ $available .= "
Constituents Only
"; } $available .= "
+
$d2[petition_name]
$field != $pass ($my_test)
+
$d2[eligibleVoterListEnforce]
+
";
+ if($d2['eligibleVoterListEnforce'] == 'NO' && $_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name']) ){
+ $available .= '';
+ }elseif($d2['eligibleVoterListEnforce'] == 'YES' && $_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name']) ){
+ setcookie("invite", ""); // clear invite
+ $error = "$field is not $pass it is $my_test";
+ setcookie("invite_error", $error); // record error
+ $available .= '';
+ }
+ }
+}
+?>
+
+
+
+