window.location.href = \"$url\";";
slack_general('js_redirect('.$page.')','automation');
header('Location: '.$url);
//slack_general('CHECK COOKIE ('.$_COOKIE['sign_email'].') PAGE ('.$page.')','md-petition-admin');
$order = 'ASC';
setcookie("order", $order);
die();
} else {
slack_general('Loop Detected for '.$_COOKIE['sign_email'],'automation');
echo "
IP Address
Watching for duplicates.
query($q);
while($d = mysqli_fetch_array($r)){
if ($d['count'] > 1){
echo "- $d[ip_address] ".id2petition($d['petition_id'])." $d[count] $d[signed_name_as]
";
}
}
?>
| */ ?>
VTRID
Watching for duplicates.
query($q);
$i=0;
while($d = mysqli_fetch_array($r)){
if ($d['count'] > 1){
echo "- $d[VTRID] ".id2petition($d['petition_id'])." $d[count] $d[signed_name_as]
";
if ($i == 0){
js_redirect("analytics.php?VTRID=$d[VTRID]&petition_id=$d[petition_id]");
}
$i++;
}
}
?>
|
Pre-Sign
Follow up requested - never signed.
'' order by id $order";
$r = $petition->query($q);
while($d = mysqli_fetch_array($r)){
$q2="SELECT * FROM presign where php_session_id = '$d[php_session_id]' order by id desc";
$r2 = $petition->query($q2);
$d2 = mysqli_fetch_array($r2);
$sig = '';
if ($d2['name'] != ''){
$q3 = "SELECT date_time_signed FROM signatures where signed_name_as = '$d2[name]'";
$r3 = $petition->query($q3);
$d3 = mysqli_fetch_array($r3);
if ($d3['date_time_signed'] != ''){
$sig = "SIGNATURE $d3[date_time_signed] ";
js_redirect("analytics.php?sign_email=$d2[email_for_follow_up]");
}
}
$presig='';
$q4="SELECT * FROM presign where email_for_follow_up = '$d2[email_for_follow_up]' and php_page like '/sign.php%'";
$r4 = $petition->query($q4);
$d4 = mysqli_fetch_array($r4);
if ($d4['action_on']){
$presig = "PRESIG $d4[action_on] ";
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 <> '' ";
$r4 = $petition->query($q4);
$d4 = mysqli_fetch_array($r4);
if ($d4['invite_error'] != ''){
$invite_error = "$d4[invite_error] ";
js_redirect("analytics.php?clear_email=$d2[email_for_follow_up]");
}
$php_session_id = $d2['php_session_id'];
echo "$d2[action_on] | $presig $sig $invite_error |
$d2[name] | $d2[email_for_follow_up] |
".id2petition($d2['petition'])." | $d2[invite] |
General
- MGP
- MLP
- BTEC
- PG
- Ivey | ";
if( $presig == '' && $invite_error == '' && $sig == '' ){
if ($d2['invite'] == 'Ivey'){
js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=8");
die();
}
if ($d2['invite'] == 'mlp'){
js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=2");
die();
}
if ($d2['invite'] == 'BTEC'){
js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=3");
die();
}
if ($d2['invite'] == 'RestorePGTermLimits'){
js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=7");
die();
}
if (id2petition($d2['petition']) == 'RESTORE TWO TERM (8 YEAR) TERM LIMITS IN PRINCE GEORGE'){
js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=7");
die();
}
if ($d2['invite'] == 'mgp'){
js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=1");
die();
}
js_redirect("analytics.php?php_session_id=$php_session_id&follow_up=X"); // no invite found no petition found - send general follow/up
}
}
?>
|
Signatures
Last 10
query($q);
while($d = mysqli_fetch_array($r)){
echo "- $d[date_time_signed] ".id2petition($d['petition_id'])." $d[signed_name_as]
";
}
?>
|
VTRID Bugs
Watching for 0
'bot' and signature_status <> 'flag_invalid_signature' and signature_status <> 'resign_requested'";
$r = $petition->query($q);
while($d = mysqli_fetch_array($r)){
echo "- $d[date_time_signed] $d[ip_address] IP INFO $d[petition_id] $d[signed_name_as]
";
}
?>
|
Petition ID Bugs
Watching for 0
'bot' and signature_status <> 'flag_invalid_signature' and signature_status <> 'resign_requested'";
$r = $petition->query($q);
while($d = mysqli_fetch_array($r)){
echo "- $d[date_time_signed] $d[ip_address] IP INFO $d[petition_id] $d[signed_name_as]
";
}
?>
|
resign_requested
These are most likely from early bugs
query($q);
$show = 0;
while($d = mysqli_fetch_array($r)){
$show = 1;
echo "- $d[date_time_signed] $d[ip_address] IP INFO $d[VTRID] $d[petition_id] $d[signed_name_as]
";
}
?>
|
bots
These are bots on the site.
query($q);
$show = 0;
while($d = mysqli_fetch_array($r)){
$show = 1;
echo "- $d[date_time_signed] $d[ip_address] IP INFO $d[VTRID] $d[petition_id] $d[signed_name_as]
";
}
?>
|