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(); } } } ?>