<?PHP
+include_once('bots.php');
include_once('../slack.php');
include_once('security.php');
include_once('/var/www/secure.php'); //outside webserver
include_once('functions.php');
+global $sign_email;
+$sign_email = $_SESSION['sign_email'];
+if (isset($_GET['sign_email'])){
+ // here we use it, if it shows up next run, we block
+ $sign_email = $_GET['sign_email'];
+ $_SESSION['sign_email'] = $sign_email;
+}
+
function js_redirect($page){
+ global $sign_email;
$base = 'https://www.md-petition.com/admin/';
$url = $base.$page;
- echo "<script>window.location.href = \"$url\";</script>";
- die();
+ $pos = strpos($page, $sign_email);
+ if ($pos === false) {
+ // email not found - good to redirect
+ echo "<script>window.location.href = \"$url\";</script>";
+ die();
+ } else {
+ echo "<h1>Automated Loop Detected - Skip</h1>";
+ }
+
}
if ($_COOKIE['level'] == 'user'){
echo "<h1>Review $VTRID</h1><table width='100%' border='1' cellpadding='5' cellspacing='5'>";
$q = "SELECT * FROM signatures where VTRID = '$VTRID' and signature_status = 'verified' and petition_id = '$petition_id' order by petition_id, id DESC ";
$r = $petition->query($q);
+ $i=0;
while($d = mysqli_fetch_array($r)){
$color = 'white';
$pos = strpos($d['date_time_signed'], date('Y-m-d'));
<td><a href='?flag_phone=$d[contact_phone]'>contact phone</a></td>
<td><a href='?resign_requested=$d[id]'>resign requested</a></td>
<td><a href='?bot=$d[id]'>bot</a></td>
- </tr>";
+ </tr>";
+ if ($i == 0){
+ js_redirect("analytics.php?flag_duplicate=$d[id]");
+ }
+ $i++;
}
echo "</table>";
die();
<?PHP
$q="SELECT VTRID, petition_id, COUNT(*) as count FROM signatures where signature_status = 'verified' group by VTRID, petition_id";
$r = $petition->query($q);
- $i=0;
+$i=0;
while($d = mysqli_fetch_array($r)){
if ($d['count'] > 1){
echo "<li><a href='?VTRID=$d[VTRID]&petition_id=$d[petition_id]'>$d[VTRID]</a> ".id2petition($d['petition_id'])." <b>$d[count]</b> $d[signed_name_as]</li>";
+ if ($i == 0){
+ js_redirect("analytics.php?VTRID=$d[VTRID]&petition_id=$d[petition_id]");
+ }
+ $i++;
}
- if ($i == 1){
- js_redirect("analytics.php?VTRID=$d[VTRID]&petition_id=$d[petition_id]");
- }
- $i++;
+
}
?></ol>
</td></tr>
$d3 = mysqli_fetch_array($r3);
if ($d3['date_time_signed'] != ''){
$sig = "<b><a href='?sign_email=$d2[email_for_follow_up]'>SIGNATURE $d3[date_time_signed]</a></b><br>";
+ js_redirect("analytics.php?sign_email=$d2[email_for_follow_up]");
}
}
$presig='';
$d4 = mysqli_fetch_array($r4);
if ($d4['action_on']){
$presig = "<b><a href='?sign_email=$d2[email_for_follow_up]'>PRESIG $d4[action_on]</a></b><br>";
+ js_redirect("analytics.php?sign_email=$d2[email_for_follow_up]");
}
$invite_error='';
$q4="SELECT * FROM presign where email_for_follow_up = '$d2[email_for_follow_up]' and invite_error <> '' ";
$d4 = mysqli_fetch_array($r4);
if ($d4['invite_error'] != ''){
$invite_error = "<b><a href='?clear_email=$d2[email_for_follow_up]'>$d4[invite_error]</a></b><br>";
+ js_redirect("analytics.php?clear_email=$d2[email_for_follow_up]");
}
$php_session_id = $d2['php_session_id'];
- echo "<tr><td><a href='?php_session_id=$php_session_id'>$d2[action_on]</a></td><td>$presig $sig $invite_error</td><td>$d2[name]</td><td><a href='?email=$d2[email_for_follow_up]'>$d2[email_for_follow_up]</a></td><td>".id2petition($d2['petition'])."</td><td>$d2[invite]</td>
+ echo "<tr><td><a href='?php_session_id=$php_session_id'>$d2[action_on]</a></td><td>$presig $sig $invite_error</td>
+ <td>$d2[name]</td><td><a href='?email=$d2[email_for_follow_up]'>$d2[email_for_follow_up]</a></td>
+ <td>".id2petition($d2['petition'])."</td><td>$d2[invite]</td>
<td><a href='?php_session_id=$php_session_id&follow_up=X'>General</a>
- <a href='?php_session_id=$php_session_id&follow_up=1'>MGP</a>
- <a href='?php_session_id=$php_session_id&follow_up=2'>MLP</a>
- <a href='?php_session_id=$php_session_id&follow_up=3'>BTEC</a>
- <a href='?php_session_id=$php_session_id&follow_up=7'>PG</a>
- <a href='?php_session_id=$php_session_id&follow_up=8'>Ivey</a></td></tr>";
+ if( $presig == '' && $invite_error == '' && $sig == '' ){
+ if ($d2['invite'] == 'Ivey'){
+ js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=8");
+ }
+ if ($d2['invite'] == 'mlp'){
+ js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=2");
+ }
+ if ($d2['invite'] == 'BTEC'){
+ js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=3");
+ }
+ if ($d2['invite'] == 'RestorePGTermLimits'){
+ js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=7");
+ }
+ if ($d2['invite'] == 'mgp'){
+ js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=1");
+ }
+ }
}
?></table>
</td>
echo "<li>$d[date_time_signed] ".id2petition($d['petition_id'])." $d[signed_name_as]</li>";
}
?></ol>
+
</td>
</tr>