date_default_timezone_set(lethe_default_timezone);
$redu = letheURLEnc($redu, 1);
# Subscriber data will get by key
# Campaign data will get by key
if (empty($id)) {
$id = 'NULL';
}
$opCamp = $myconn->prepare("SELECT * FROM " . db_table_pref . "campaigns WHERE campaign_key=?") or die(mysqli_error($myconn));
$opCamp->bind_param('s', $id);
if ($opCamp->execute()) {
$opCamp->store_result();
if ($opCamp->num_rows != 0) {
$sr = new Statement_Result($opCamp);
$opCamp->fetch();
$campID = $sr->Get('ID');
$subArray = getSubscriber($sid, 2);
if (is_array($subArray) && count($subArray) != 0) {
# Add Report
$addRpt = new lethe();
$addRpt->OID = $subArray['subscriber_OID'];
$addRpt->reportCID = $campID;
$addRpt->reportPos = 0;
# Click
$addRpt->reportIP = $_SERVER['REMOTE_ADDR'];
$addRpt->reportMail = $subArray['subscriber_mail'];
$addRpt->reportBounceType = 'unknown';
$addRpt->reportExtraInfo = 'URL: ' . $redu . PHP_EOL;
$addRpt->addReport();
# Redirect URL
header('Location: ' . $redu);
} else {
<span class="badge"><?php
echo set_org_daily_sent;
?>
</span></li>
</ul>
</div>
<div class="col-xs-12 col-sm-12 col-md-5">
<h3><?php
echo subscribers_precious_subscribers;
?>
</h3><hr>
<ul class="list-group">
<?php
$opReport = $myconn->query("SELECT \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t*,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(SELECT SUM(hit_cnt) FROM " . db_table_pref . "reports WHERE email=R.email) AS score\n\t\t\t\t\t\t\t\t\t\t\t\tFROM " . db_table_pref . "reports AS R WHERE OID=" . set_org_id . " AND (pos=1 OR pos=0) GROUP BY email ORDER BY score DESC LIMIT 0,5") or die(mysqli_error($myconn));
while ($opReportRs = $opReport->fetch_assoc()) {
echo '<li class="list-group-item"><a href="javascript:;" data-sbr-id="' . getSubscriber($opReportRs['email'], 3) . '" class="sbr-acts text-success tooltips" title="' . subscribers_stats . '"><span class="glyphicon glyphicon-stats"></span></a> ' . showIn($opReportRs['email'], 'page') . ' <span class="label label-warning pull-right">' . letheglobal_score . ': ' . $opReportRs['score'] . '</span></li>';
}
$opReport->free();
?>
</ul>
<script type="text/javascript">
$(".sbr-acts").click(function(){
var subid = $(this).data('sbr-id');
$.fancybox({
type: "ajax",
href: "modules/lethe.subscribers/act.xmlhttp.php?pos=sbrstats&ID="+subid,
width: 700,
height: 600,
autoSize: false
$movStatus = false;
$movePrep = $myconn->prepare("UPDATE " . db_table_pref . "subscribers SET GID=? WHERE OID=" . set_org_id . " AND ID=?") or die(mysqli_error($myconn));
$moveGrpOwnerPrep = $myconn->prepare("SELECT ID FROM " . db_table_pref . "subscriber_groups WHERE OID=" . set_org_id . " AND ID=? " . (LETHE_AUTH_VIEW_TYPE ? ' AND UID=' . LETHE_AUTH_ID . '' : '') . "") or die(mysqli_error($myconn));
$moveGrpOwnerPrep->bind_param('i', $movGrp);
$moveGrpOwnerPrep->execute();
$moveGrpOwnerPrep->store_result();
if ($moveGrpOwnerPrep->num_rows > 0) {
$movStatus = true;
}
$moveGrpOwnerPrep->close();
$opRemCls = new lethe();
$opRemCls->OID = set_org_id;
foreach ($_POST['sbr'] as $k => $v) {
/* Delete */
if ($_POST['selOpt'] == 'delete') {
$selSubMail = getSubscriber($v, 0);
$opRemCls->removeSubscription($selSubMail);
} else {
if ($_POST['selOpt'] == 'move') {
if ($movStatus) {
$movePrep->bind_param('ii', $movGrp, $v);
$movePrep->execute();
}
}
}
}
$movePrep->close();
}
}
}
?>
