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"; $r2 = $petition->query($q2); while($d2 = mysqli_fetch_array($r2)){ $checked = ''; $field = $d2['eligibleVoterListField']; $pass = $d2['eligibleVoterListEquals']; $q4 = "select * from signatures where VTRID = '$VTRID' and petition_id = '$d2[petition_id]' and signature_status <> 'removed' "; $r4 = $petition->query($q4); $d4 = mysqli_fetch_array($r4); if ($d4['id'] > 0){ slack_general($VTRID.' Already Signed '.$d2[petition_id].' ('.$_COOKIE['invite'].')','md-petition'); } /* if ($d4['id'] > 0){ $available .= "

Already Signed, View or Remove

$d2[petition_name]

$field == $pass

"; }else */ if($d[$field] == $pass){ $checked = ''; if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){ $checked = 'checked'; }else{ $checked = ''; } $available .= "

$d2[petition_name]

$field == $pass

"; if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){ $available .= ''; } }else{ $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

"; if($_COOKIE['invite'] != '' && strtoupper($_COOKIE['invite']) == strtoupper($d2['web_short_name'])){ $available .= ''; } } } ?>

Pick One

Petition Name

Requirements