- $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 .= "<div class='row' style='background-color:lightyellow;'>
- <div class='col-sm-3'>Already Signed, <a target='_Blank' href='soft_copy.php?id=$d4[id]'>View</a> or <a href='?remove=$d4[id]'>Remove</a></div>
- <div class='col-sm-6'>$d2[petition_name]</div>
- <div class='col-sm-3'>$field == $pass</div>
- </div>";
- }else */