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 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 .= ''; } } } ?>
query($q); $d = mysqli_fetch_array($r); ?>

Pick One

Petition Name
Eligible

Locked