function calcSource($OID, $w)
{
$getVal = 0;
switch ($w) {
case $w == 'users':
$getVal = cntData("SELECT ID FROM " . db_table_pref . "users WHERE OID=" . $OID . "");
break;
case $w == 'shortcode':
$getVal = cntData("SELECT ID FROM " . db_table_pref . "short_codes WHERE OID=" . $OID . " AND isSystem=0");
break;
case $w == 'templates':
$getVal = cntData("SELECT ID FROM " . db_table_pref . "templates WHERE OID=" . $OID . " AND temp_type='normal'");
break;
case $w == 'subscriber.groups':
$getVal = cntData("SELECT ID FROM " . db_table_pref . "subscriber_groups WHERE OID=" . $OID . "");
break;
case $w == 'subscribers':
$getVal = cntData("SELECT ID FROM " . db_table_pref . "subscribers WHERE OID=" . $OID . "");
break;
case $w == 'subscriber.blacklist':
$getVal = cntData("SELECT ID FROM " . db_table_pref . "blacklist WHERE OID=" . $OID . "");
break;
case $w == 'subscriber.forms':
$getVal = cntData("SELECT ID FROM " . db_table_pref . "subscribe_forms WHERE OID=" . $OID . " AND isSystem<>1");
break;
case $w == 'newsletters':
$getVal = cntData("SELECT ID FROM " . db_table_pref . "campaigns WHERE OID=" . $OID . " AND campaign_type=0");
break;
case $w == 'autoresponder':
$getVal = cntData("SELECT ID FROM " . db_table_pref . "campaigns WHERE OID=" . $OID . " AND campaign_type=1");
break;
default:
break;
}
return $getVal;
}
} else {
die(errMod('DB Settings Could Not Be Write', 'danger'));
}
}
# Update Settings
$setLethe = new lethe();
$setLethe->onInstall = true;
$setLethe->letheSettings();
# Organization
if (cntData("SELECT ID FROM " . $db_prefix . "organizations") == 0) {
$orgLethe = new lethe();
$orgLethe->onInstall = true;
$orgLethe->addOrganization();
}
# User
if (cntData("SELECT ID FROM " . $db_prefix . "users") == 0) {
$opOr = $myconn->query("SELECT ID FROM " . $db_prefix . "organizations");
$opOrRs = $opOr->fetch_assoc();
$usrLethe = new lethe();
$usrLethe->onInstall = true;
$usrLethe->isMaster = 1;
$usrLethe->auth_mode = 2;
$usrLethe->isPrimary = 1;
$usrLethe->OID = $opOrRs['ID'];
$usrLethe->addUser();
}
# Main Cron
$letChr = new Crontab();
$mainCroner = "* * * * * curl -s '" . lethe_root_url . "chronos/lethe.php' >/dev/null 2>&1";
$letChr->addJob($mainCroner);
die('<script>$("#myLethe").attr("disabled",true);</script>' . errMod('Lethe Successfully Installed on Your System!<br>Dont Forget to Remove <strong>install.php</strong> File!', 'success'));
public function fieldModeller()
{
global $LETHE_SUBSCRIBE_SAVE_FIELDS;
$fieldData = '';
/* Save Area */
if ($this->fieldType != 'recaptcha' && $this->fieldType != 'addremove') {
$fieldData .= '<div class="form-group"><label for="fieldSave">' . sh('kA6j3CA0Ci') . subscribers_recording_area . '</label>';
$fieldData .= '<select name="fieldSave" id="fieldSave" class="form-control autoWidth">';
foreach ($LETHE_SUBSCRIBE_SAVE_FIELDS as $kf => $vf) {
if (cntData("SELECT ID FROM " . db_table_pref . "subscribe_form_fields WHERE OID=" . set_org_id . " AND FID=" . $this->FID . " AND field_save='" . mysql_prep($kf) . "'") == 0 || $kf == 'subscriber_full_data') {
$fieldData .= '<option value="' . $kf . '">' . $vf . '</option>';
}
}
$fieldData .= '</select></div>';
}
# **********************************
/* Text */
if ($this->fieldType == 'text' || $this->fieldType == 'phone' || $this->fieldType == 'number' || $this->fieldType == 'url' || $this->fieldType == 'textarea') {
$fieldData .= '<div class="form-group"><label for="f_field_label">' . sh('MTpWva4d4t') . subscribers_field_label . '</label>';
$fieldData .= '<input type="text" name="f_field_label" id="f_field_label" class="form-control" required>';
$fieldData .= '</div>';
$fieldData .= '<div class="form-group"><label for="f_field_placeholder">' . sh('ynYKnxzFx4') . subscribers_placeholder . '</label>';
$fieldData .= '<input type="text" name="f_field_placeholder" id="f_field_placeholder" class="form-control">';
$fieldData .= '</div>';
$fieldData .= '<div class="form-group"><label for="f_field_pattern">' . sh('b7H8gLtspF') . subscribers_regex_pattern . '</label>';
$fieldData .= '<input type="text" name="f_field_pattern" id="f_field_pattern" class="form-control">';
$fieldData .= '</div>';
$fieldData .= '<div class="container-fluid"><div class="col-md-4"><div class="form-group">';
$fieldData .= '<span>' . sh('DQzwYjoVhQ') . '</span> <label><input type="checkbox" name="isRequired" id="isRequired" value="YES"> ' . subscribers_required . '?</label>';
$fieldData .= '</div></div>';
$fieldData .= '<div class="col-md-8"><div class="form-group errAlertField sHide">';
$fieldData .= '<label for="f_field_error">' . sh('pkikR7j8Zb') . subscribers_error_message . '</label><input type="text" name="f_field_error" id="f_field_error" class="form-control input-sm">';
$fieldData .= '</div></div></div>';
} else {
if ($this->fieldType == 'date') {
$fieldData .= '<div class="form-group"><label for="f_field_label">' . sh('MTpWva4d4t') . subscribers_field_label . '</label>';
$fieldData .= '<input type="text" name="f_field_label" id="f_field_label" class="form-control" required>';
$fieldData .= '</div>';
$fieldData .= '<div class="form-group"><label for="f_field_placeholder">' . sh('ynYKnxzFx4') . subscribers_placeholder . '</label>';
$fieldData .= '<input type="text" name="f_field_placeholder" id="f_field_placeholder" class="form-control">';
$fieldData .= '</div>';
$fieldData .= '<div class="form-group"><label for="f_field_pattern">' . sh('b7H8gLtspF') . subscribers_regex_pattern . '</label>';
$fieldData .= '<input type="text" name="f_field_pattern" id="f_field_pattern" class="form-control">';
$fieldData .= '</div>';
$fieldData .= '<div class="container-fluid"><div class="col-md-4"><div class="form-group">';
$fieldData .= '<span>' . sh('DQzwYjoVhQ') . '</span> <label><input type="checkbox" name="isRequired" id="isRequired" value="YES"> ' . subscribers_required . '?</label>';
$fieldData .= '</div></div>';
$fieldData .= '<div class="col-md-8"><div class="form-group errAlertField sHide">';
$fieldData .= '<label for="f_field_error">' . sh('pkikR7j8Zb') . subscribers_error_message . '</label><input type="text" name="f_field_error" id="f_field_error" class="form-control input-sm">';
$fieldData .= '</div></div></div>';
$fieldData .= '<div class="container-fluid"><div class="col-md-5"><div class="form-group">';
$fieldData .= '<span>' . sh('rt7Cq8bHvu') . '</span> <label><input type="checkbox" name="isDatepicker" id="isDatepicker" value="YES"> ' . subscribers_add_datepicker . '</label>';
$fieldData .= '</div></div></div>';
} else {
if ($this->fieldType == 'select') {
$fieldData .= '<div class="form-group"><label for="f_field_label">' . sh('MTpWva4d4t') . subscribers_field_label . '</label>';
$fieldData .= '<input type="text" name="f_field_label" id="f_field_label" class="form-control" required>';
$fieldData .= '</div>';
$fieldData .= '<div class="form-group"><label for="f_field_select">' . sh('MTpWva4d4t') . subscribers_options . '</label>';
$fieldData .= '<select name="f_field_select" id="f_field_select" class="form-control" multiple></select>';
$fieldData .= '</div>';
$fieldData .= '<div class="form-group">
<label>' . sh('6WYoauQXgG') . subscribers_controls . '</label>
<button type="button" onclick="javascript:listbox_move(\'f_field_select\', \'up\',\'' . letheglobal_please_select_a_option_to_move . '\');" class="btn btn-warning btn-sm init-list tooltips" title="' . letheglobal_up . '"><span class="glyphicon glyphicon-chevron-up"></span></button>
<button type="button" onclick="javascript:listbox_move(\'f_field_select\', \'down\',\'' . letheglobal_please_select_a_option_to_move . '\');" class="btn btn-warning btn-sm init-list tooltips" title="' . letheglobal_down . '"><span class="glyphicon glyphicon-chevron-down"></span></button>
<button type="button" onclick="javascript:listbox_remove(\'f_field_select\',\'' . letheglobal_please_select_a_option_to_remove . '\');" class="btn btn-danger btn-sm init-list tooltips" title="' . letheglobal_delete . '"><span class="glyphicon glyphicon-remove"></span></button>
</div>
';
$fieldData .= '<div class="container-fluid"><label>' . sh('iqHcTILAYR') . subscribers_new_option . '</label><div class="clearfix"></div>';
$fieldData .= '<div class="col-md-6"><input id="boxKey" type="text" class="form-control" placeholder="' . subscribers_value . '"></div>';
$fieldData .= '<div class="col-md-6">
<div class="input-group">
<input type="text" id="boxVal" class="form-control" placeholder="' . subscribers_text . '">
<span class="input-group-btn">
<button class="btn btn-success" id="addBoxItem" type="button">' . letheglobal_add . '</button>
</span>
</div>
</div>';
$fieldData .= '</div>';
$fieldData .= '<hr><div class="container-fluid"><div class="col-md-4"><div class="form-group">';
$fieldData .= '<span>' . sh('DQzwYjoVhQ') . '</span> <label><input type="checkbox" name="isRequired" id="isRequired" value="YES"> ' . subscribers_required . '?</label>';
$fieldData .= '</div></div>';
$fieldData .= '<div class="col-md-8"><div class="form-group errAlertField sHide">';
$fieldData .= '<label for="f_field_error">' . sh('pkikR7j8Zb') . subscribers_error_message . '</label><input type="text" name="f_field_error" id="f_field_error" class="form-control input-sm">';
$fieldData .= '</div></div></div>';
$fieldData .= '<input type="hidden" name="f_field_data" id="tempbox" value="">';
$fieldData .= '<script>
/* Add Item */
$("#addBoxItem").click(function(){
var commaSep = "";
if($("#tempbox").val()==""){commaSep="";}else{commaSep=",";}
if($("#boxKey").val()=="" || $("#boxVal").val()==""){alert("' . letheglobal_please_enter_a_value . '");return false;}
$("#tempbox").val($("#tempbox").val()+commaSep+$("#boxKey").val()+":"+$("#boxVal").val());
$("#boxKey").val("");
$("#boxVal").val("");
var newList = $("#tempbox").val().split(",");
/* Clear List */
$("#f_field_select").html("");
/* Make List */
for (a in newList) {
parseData = newList[a].split(":");
$("#f_field_select").append(\'<option value="\'+ parseData[0] +\'">\'+ parseData[1] +\'</option>\');
}
});
/* Init List */
$(".init-list").click(function(){
var initData = "";
$("#f_field_select > option").each(function() {
if(initData!=""){initData=initData+",";}
initData = initData + $(this).text() + ":" + $(this).val();
});
$("#tempbox").val(initData);
});
/* Init Helpers */
$(".tooltips").tooltip();
</script>';
} else {
if ($this->fieldType == 'checkbox') {
$fieldData .= '<div class="form-group"><label for="f_field_label">' . sh('MTpWva4d4t') . subscribers_field_label . '</label>';
$fieldData .= '<input type="text" name="f_field_label" id="f_field_label" class="form-control" required>';
$fieldData .= '</div>';
$fieldData .= '<div class="form-group"><label for="f_field_select">' . sh('MTpWva4d4t') . subscribers_options . '</label>';
$fieldData .= '<select name="f_field_select" id="f_field_select" class="form-control" multiple></select>';
$fieldData .= '</div>';
$fieldData .= '<div class="form-group">
<label>' . sh('6WYoauQXgG') . subscribers_controls . '</label>
<button type="button" onclick="javascript:listbox_move(\'f_field_select\', \'up\',\'' . letheglobal_please_select_a_option_to_move . '\');" class="btn btn-warning btn-sm init-list tooltips" title="' . letheglobal_up . '"><span class="glyphicon glyphicon-chevron-up"></span></button>
<button type="button" onclick="javascript:listbox_move(\'f_field_select\', \'down\',\'' . letheglobal_please_select_a_option_to_move . '\');" class="btn btn-warning btn-sm init-list tooltips" title="' . letheglobal_down . '"><span class="glyphicon glyphicon-chevron-down"></span></button>
<button type="button" onclick="javascript:listbox_remove(\'f_field_select\',\'' . letheglobal_please_select_a_option_to_remove . '\');" class="btn btn-danger btn-sm init-list tooltips" title="' . letheglobal_delete . '"><span class="glyphicon glyphicon-remove"></span></button>
</div>
';
$fieldData .= '<div class="container-fluid"><label>' . sh('iqHcTILAYR') . subscribers_new_option . '</label><div class="clearfix"></div>';
$fieldData .= '<div class="col-md-6"><input id="boxKey" type="text" class="form-control" placeholder="' . subscribers_value . '"></div>';
$fieldData .= '<div class="col-md-6">
<div class="input-group">
<input type="text" id="boxVal" class="form-control" placeholder="' . subscribers_text . '">
<span class="input-group-btn">
<button class="btn btn-success" id="addBoxItem" type="button">' . letheglobal_add . '</button>
</span>
</div>
</div>';
$fieldData .= '</div>';
$fieldData .= '<hr><div class="container-fluid"><div class="col-md-4"><div class="form-group">';
$fieldData .= '<span>' . sh('DQzwYjoVhQ') . '</span> <label><input type="checkbox" name="isRequired" id="isRequired" value="YES"> ' . subscribers_required . '?</label>';
$fieldData .= '</div></div>';
$fieldData .= '<div class="col-md-8"><div class="form-group errAlertField sHide">';
$fieldData .= '<label for="f_field_error">' . sh('pkikR7j8Zb') . subscribers_error_message . '</label><input type="text" name="f_field_error" id="f_field_error" class="form-control input-sm">';
$fieldData .= '</div></div></div>';
$fieldData .= '<input type="hidden" name="f_field_data" id="tempbox" value="">';
$fieldData .= '<script>
/* Add Item */
$("#addBoxItem").click(function(){
var commaSep = "";
if($("#tempbox").val()==""){commaSep="";}else{commaSep=",";}
if($("#boxKey").val()=="" || $("#boxVal").val()==""){alert("' . letheglobal_please_enter_a_value . '");return false;}
$("#tempbox").val($("#tempbox").val()+commaSep+$("#boxKey").val()+":"+$("#boxVal").val());
$("#boxKey").val("");
$("#boxVal").val("");
var newList = $("#tempbox").val().split(",");
/* Clear List */
$("#f_field_select").html("");
/* Make List */
for (a in newList) {
parseData = newList[a].split(":");
$("#f_field_select").append(\'<option value="\'+ parseData[0] +\'">\'+ parseData[1] +\'</option>\');
}
});
/* Init List */
$(".init-list").click(function(){
var initData = "";
$("#f_field_select > option").each(function() {
if(initData!=""){initData=initData+",";}
initData = initData + $(this).text() + ":" + $(this).val();
});
$("#tempbox").val(initData);
});
/* Init Helpers */
$(".tooltips").tooltip();
</script>';
} else {
if ($this->fieldType == 'radio') {
$fieldData .= '<div class="form-group"><label for="f_field_label">' . sh('MTpWva4d4t') . subscribers_field_label . '</label>';
$fieldData .= '<input type="text" name="f_field_label" id="f_field_label" class="form-control" required>';
$fieldData .= '</div>';
$fieldData .= '<div class="form-group"><label for="f_field_select">' . sh('MTpWva4d4t') . subscribers_options . '</label>';
$fieldData .= '<select name="f_field_select" id="f_field_select" class="form-control" multiple></select>';
$fieldData .= '</div>';
$fieldData .= '<div class="form-group">
<label>' . sh('6WYoauQXgG') . subscribers_controls . '</label>
<button type="button" onclick="javascript:listbox_move(\'f_field_select\', \'up\',\'' . letheglobal_please_select_a_option_to_move . '\');" class="btn btn-warning btn-sm init-list tooltips" title="' . letheglobal_up . '"><span class="glyphicon glyphicon-chevron-up"></span></button>
<button type="button" onclick="javascript:listbox_move(\'f_field_select\', \'down\',\'' . letheglobal_please_select_a_option_to_move . '\');" class="btn btn-warning btn-sm init-list tooltips" title="' . letheglobal_down . '"><span class="glyphicon glyphicon-chevron-down"></span></button>
<button type="button" onclick="javascript:listbox_remove(\'f_field_select\',\'' . letheglobal_please_select_a_option_to_remove . '\');" class="btn btn-danger btn-sm init-list tooltips" title="' . letheglobal_delete . '"><span class="glyphicon glyphicon-remove"></span></button>
</div>
';
$fieldData .= '<div class="container-fluid"><label>' . sh('iqHcTILAYR') . subscribers_new_option . '</label><div class="clearfix"></div>';
$fieldData .= '<div class="col-md-6"><input id="boxKey" type="text" class="form-control" placeholder="' . subscribers_value . '"></div>';
$fieldData .= '<div class="col-md-6">
<div class="input-group">
<input type="text" id="boxVal" class="form-control" placeholder="' . subscribers_text . '">
<span class="input-group-btn">
<button class="btn btn-success" id="addBoxItem" type="button">' . letheglobal_add . '</button>
</span>
</div>
</div>';
$fieldData .= '</div>';
$fieldData .= '<hr><div class="container-fluid"><div class="col-md-4"><div class="form-group">';
$fieldData .= '<span>' . sh('DQzwYjoVhQ') . '</span> <label><input type="checkbox" name="isRequired" id="isRequired" value="YES"> ' . subscribers_required . '?</label>';
$fieldData .= '</div></div>';
$fieldData .= '<div class="col-md-8"><div class="form-group errAlertField sHide">';
$fieldData .= '<label for="f_field_error">' . sh('pkikR7j8Zb') . subscribers_error_message . '</label><input type="text" name="f_field_error" id="f_field_error" class="form-control input-sm">';
$fieldData .= '</div></div></div>';
$fieldData .= '<input type="hidden" name="f_field_data" id="tempbox" value="">';
$fieldData .= '<script>
/* Add Item */
$("#addBoxItem").click(function(){
var commaSep = "";
if($("#tempbox").val()==""){commaSep="";}else{commaSep=",";}
if($("#boxKey").val()=="" || $("#boxVal").val()==""){alert("' . letheglobal_please_enter_a_value . '");return false;}
$("#tempbox").val($("#tempbox").val()+commaSep+$("#boxKey").val()+":"+$("#boxVal").val());
$("#boxKey").val("");
$("#boxVal").val("");
var newList = $("#tempbox").val().split(",");
/* Clear List */
$("#f_field_select").html("");
/* Make List */
for (a in newList) {
parseData = newList[a].split(":");
$("#f_field_select").append(\'<option value="\'+ parseData[0] +\'">\'+ parseData[1] +\'</option>\');
}
});
/* Init List */
$(".init-list").click(function(){
var initData = "";
$("#f_field_select > option").each(function() {
if(initData!=""){initData=initData+",";}
initData = initData + $(this).text() + ":" + $(this).val();
});
$("#tempbox").val(initData);
});
/* Init Helpers */
$(".tooltips").tooltip();
</script>';
} else {
if ($this->fieldType == 'recaptcha') {
global $LETHE_SUBSCRIBE_FORM_RECAPTCHA_LANG;
$fieldData .= '<div class="form-group"><label for="f_field_label">' . sh('MTpWva4d4t') . subscribers_field_label . '</label>';
$fieldData .= '<input type="text" name="f_field_label" id="f_field_label" class="form-control" required>';
$fieldData .= '</div>';
$fieldData .= '<div class="form-group"><label for="f_field_error">' . sh('pkikR7j8Zb') . subscribers_error_message . '</label><input type="text" name="f_field_error" id="f_field_error" class="form-control"></div>';
$fieldData .= '<div class="form-group"><label for="f_field_recapt_api">' . sh('za7rBvqrZy') . subscribers_api_version . '</label><select name="f_field_recapt_api" id="f_field_recapt_api" class="form-control autoWidth"><option value="v1">API V1</option><option value="v2">API V2</option></select></div>
<div id="f_field_recapt_api_lang_area"><input type="hidden" name="f_field_recapt_api_lang" value="en"></div>
<div id="f_field_recapt_api_theme_area"><input type="hidden" name="f_field_recapt_api_theme" value="light"></div>
<div id="f_field_recapt_api_type_area"><input type="hidden" name="f_field_recapt_api_type" value="image"></div>
<script>
$("#f_field_recapt_api").on("change",function(){
if($(this).val()=="v1"){
$("#f_field_recapt_api_lang_area").html(\'<input type="hidden" name="f_field_recapt_api_lang" value="en">\');
$("#f_field_recapt_api_theme_area").html(\'<input type="hidden" name="f_field_recapt_api_theme" value="light">\');
$("#f_field_recapt_api_type_area").html(\'<input type="hidden" name="f_field_recapt_api_type" value="image">\');
}else{
// Language
$("#f_field_recapt_api_lang_area").html(\'<div class="form-group"><label for="f_field_recapt_api_lang">' . sh('ZlPryzxM0A') . subscribers_language . '</label><select name="f_field_recapt_api_lang" id="f_field_recapt_api_lang" class="form-control autoWidth"></select></div>\');';
foreach ($LETHE_SUBSCRIBE_FORM_RECAPTCHA_LANG as $kk => $vv) {
$fieldData .= '$("#f_field_recapt_api_lang").append(\'<option value="' . $kk . '">' . $vv . '</option>\');';
}
$fieldData .= '
// Theme
$("#f_field_recapt_api_theme_area").html(\'<div class="form-group"><label for="f_field_recapt_api_theme">' . sh('zb3rOGprAQ') . subscribers_theme . '</label><select name="f_field_recapt_api_theme" id="f_field_recapt_api_theme" class="form-control autoWidth"><option value="light">Light</option><option value="dark">Dark</option></select></div>\');
// Type
$("#f_field_recapt_api_type_area").html(\'<div class="form-group"><label for="f_field_recapt_api_type">' . sh('41PgQN2rna') . subscribers_type . '</label><select name="f_field_recapt_api_type" id="f_field_recapt_api_type" class="form-control autoWidth"><option value="image">Image</option><option value="audio">Audio</option></select></div>\');
}
});
</script>
';
} else {
if ($this->fieldType == 'addremove') {
$fieldData .= '<div class="form-group"><label for="f_field_error">' . sh('pkikR7j8Zb') . subscribers_error_message . '</label><input type="text" name="f_field_error" id="f_field_error" class="form-control"></div>';
$fieldData .= '<div class="form-group"><label for="f_addremove_add">' . subscribers_add_label . ':</label><input type="text" name="f_addremove_add" id="f_addremove_add" class="form-control" placeholder="' . letheglobal_add . '"></div>';
$fieldData .= '<div class="form-group"><label for="f_addremove_remove">' . subscribers_label_of_remove . ':</label><input type="text" name="f_addremove_remove" id="f_addremove_remove" class="form-control" placeholder="' . letheglobal_remove . '"></div>';
}
}
}
}
}
}
}
/* Actions */
$fieldData .= '<script>
$("#isRequired").change(function(){
$(".errAlertField").slideToggle();
});
$(".intoAjax input[type=checkbox]").ionCheckRadio();
</script>
';
return $fieldData;
}
# Percentage for Opens
$totalUnsubPerc = percentage($totalUnsub, $totalSub, 2);
# Percentage for Unsubscription
$bouncesPerc = percentage($bounces, $totalSub, 2);
# Percentage for Bounces
/* Get Score */
$score = ($sent - ($totalUnsub + $bounces + $nonopens)) * 100;
$score = $sent != 0 ? $score / $sent : $score;
$score = $score < 0 ? 0 : $score;
/* Calc Clicks */
$clikDatas = array();
$clikDataMon = array();
for ($i = 1; $i <= 12; $i++) {
$mm = date("m", strtotime("2015-" . $i));
$clikDataMon[] = '"' . date("m-y", strtotime('01-' . $i . '-' . date("Y") . '')) . '"';
$clikDatas[] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND CID=" . $ID . " AND MONTH(add_date)='" . $mm . "' AND YEAR(add_date)='" . date("Y") . "'");
}
echo '
<div class="container-fluid">
<div class="row">
<div class="col-md-5">
<div class="row">
<div class="col-md-6">
<h4>' . letheglobal_submission . '</h4><hr>
<canvas id="myChart" width="125" height="125"></canvas>
</div>
<div class="col-md-6">
<h4>' . letheglobal_deliveries . '</h4><hr>
<canvas id="myChart2" width="125" height="125"></canvas>
</div>
</div>
$listDays = dates_month($selMon, $selectedYear);
//print_r(dates_month($selMon,$selectedYear));
foreach ($listDays as $k => $v) {
$table_qry[] = " " . (count($table_qry) > 1 ? ' OR ' : ' ') . " (MONTH(add_date)='" . mysql_prep($selMon) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "') ";
$graph_lab[] = '"' . $LETHE_MONTH_NAMES['short'][$selMon] . ' ' . $v . '"';
$graph_data['click'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=0 AND CID=" . $ID . " AND DAY(add_date)='" . mysql_prep($v) . "' AND MONTH(add_date)='" . mysql_prep($selMon) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
$graph_data['open'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=1 AND CID=" . $ID . " AND DAY(add_date)='" . mysql_prep($v) . "' AND MONTH(add_date)='" . mysql_prep($selMon) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
$graph_data['bounce'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=2 AND CID=" . $ID . " AND DAY(add_date)='" . mysql_prep($v) . "' AND MONTH(add_date)='" . mysql_prep($selMon) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
}
} else {
foreach ($selectedMonths as $k => $v) {
$table_qry[] = " " . (count($table_qry) > 1 ? ' OR ' : ' ') . " (MONTH(add_date)='" . mysql_prep($v) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "') ";
$graph_lab[] = '"' . $LETHE_MONTH_NAMES['short'][$v] . ' ' . date("y", strtotime("01-01-" . $selectedYear)) . '"';
$graph_data['click'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=0 AND CID=" . $ID . " AND MONTH(add_date)='" . mysql_prep($v) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
$graph_data['open'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=1 AND CID=" . $ID . " AND MONTH(add_date)='" . mysql_prep($v) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
$graph_data['bounce'][] = cntData("SELECT ID FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=2 AND CID=" . $ID . " AND MONTH(add_date)='" . mysql_prep($v) . "' AND YEAR(add_date)='" . mysql_prep($selectedYear) . "'");
}
}
$table_qry[] = ")";
?>
<div class="row">
<div class="col-md-2"><h3><span class="label label-success"><?php
echo array_sum($graph_data['click']);
?>
<?php
echo letheglobal_clicks;
?>
</span> </h3></div>
<div class="col-md-2"><h3><span class="label label-warning"><?php
echo array_sum($graph_data['open']);
<canvas id="glob3" width="100" height="100"></canvas>
</div>
<div class="col-xs-6 col-sm-3 col-md-3">
<h4><?php
echo letheglobal_unsubscribe;
?>
</h4>
<canvas id="glob4" width="100" height="100"></canvas>
</div>
</div>
<?php
# Stat Calcs
$total_subscriber = cntData("SELECT ID FROM " . db_table_pref . "subscribers WHERE OID=" . set_org_id . "");
$total_unsubscriber = cntData("SELECT ID FROM " . db_table_pref . "unsubscribes WHERE OID=" . set_org_id . "");
$total_sent = cntData("SELECT ID FROM " . db_table_pref . "tasks WHERE OID=" . set_org_id . "");
$opRepCnt = $myconn->query("SELECT \n\t\t\t\t\t\t\t\t\t*,\n\t\t\t\t\t\t\t\t\t(SELECT COUNT(ID) FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=1) AS t_open,\n\t\t\t\t\t\t\t\t\t(SELECT COUNT(ID) FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=0) AS t_click,\n\t\t\t\t\t\t\t\t\t(SELECT COUNT(ID) FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND pos=2) AS t_bounce\n\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\t\t" . db_table_pref . "reports \n\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\t\tOID=" . set_org_id . "\n\t\t\t\t\t\t\t") or die(mysqli_error($myconn));
$opRepCntRs = $opRepCnt->fetch_assoc();
$total_open = $opRepCntRs['t_open'];
$total_click = $opRepCntRs['t_click'];
$total_bounce = $opRepCntRs['t_bounce'];
$nonopens = $total_sent - $total_open;
$opRepCnt->free();
# Percs
$open_perc = percentage($total_open, $total_sent, 0);
$click_perc = percentage($total_click, $total_sent, 0);
$bounce_perc = percentage($total_bounce, $total_sent, 0);
$unsub_perc = percentage($total_unsubscriber, $total_subscriber, 0);
$unsub_perc = $unsub_perc > 100 ? 100 : $unsub_perc;
/* Get Score */
$score = ($total_sent - ($total_unsubscriber + $total_bounce + $nonopens)) * 100;
} else {
if ($acts == 'toinactive') {
$myconn->query("UPDATE " . db_table_pref . "subscribers SET subscriber_active=0 WHERE " . $grps . "");
die(errMod('' . letheglobal_updated . ': <strong>' . cntData("SELECT ID FROM " . db_table_pref . "subscribers WHERE " . $grps . "") . '</strong> ' . letheglobal_record . '', 'success'));
} else {
if ($acts == 'tounverified') {
$myconn->query("UPDATE " . db_table_pref . "subscribers SET subscriber_verify=0 WHERE " . $grps . "");
die(errMod('' . letheglobal_updated . ': <strong>' . cntData("SELECT ID FROM " . db_table_pref . "subscribers WHERE " . $grps . "") . '</strong> ' . letheglobal_record . '', 'success'));
} else {
if ($acts == 'tosingleverified') {
$myconn->query("UPDATE " . db_table_pref . "subscribers SET subscriber_verify=1 WHERE " . $grps . "");
die(errMod('' . letheglobal_updated . ': <strong>' . cntData("SELECT ID FROM " . db_table_pref . "subscribers WHERE " . $grps . "") . '</strong> ' . letheglobal_record . '', 'success'));
} else {
if ($acts == 'todoubleverified') {
$myconn->query("UPDATE " . db_table_pref . "subscribers SET subscriber_verify=2 WHERE " . $grps . "");
die(errMod('' . letheglobal_updated . ': <strong>' . cntData("SELECT ID FROM " . db_table_pref . "subscribers WHERE " . $grps . "") . '</strong> ' . letheglobal_record . '', 'success'));
}
}
}
}
}
} else {
die(errMod($errText, 'danger'));
}
die;
}
/* Load Groups for All Sections */
$listGrps = array();
$opGroups = $myconn->query("SELECT \n\t\t\t\t\t\t\t\t\t\tSG.*,\n\t\t\t\t\t\t\t\t\t\t(SELECT COUNT(ID) FROM " . db_table_pref . "subscribers WHERE GID=SG.ID) AS sbr_cnt\n\t\t\t\t\t\t\t\t FROM \n\t\t\t\t\t\t\t\t\t\t" . db_table_pref . "subscriber_groups AS SG\n\t\t\t\t\t\t\t\t WHERE \n\t\t\t\t\t\t\t\t\t\tOID=" . set_org_id . " \n\n\t\t\t\t\t\t\t\t\t\t" . (LETHE_AUTH_VIEW_TYPE ? ' AND UID=' . LETHE_AUTH_ID . '' : '') . "\n\t\t\t\t\t\t\t ORDER BY\n\t\t\t\t\t\t\t\t\t\tgroup_name\n\t\t\t\t\t\t\t\t ASC\n\t\t\t\t\t\t\t\t") or die(mysqli_error($myconn));
while ($opGroupsRs = $opGroups->fetch_assoc()) {
$listGrps[] = $opGroupsRs;
die;
}
/* Demo Check */
if (!isDemo('editBlacklist,addRecord')) {
$errText = errMod(letheglobal_demo_mode_active, 'danger');
}
$sourceLimit = calcSource(set_org_id, 'subscriber.blacklist');
/* Navigation */
$pg_nav_buts = '';
/* Add Record */
if (isset($_POST['addRecord'])) {
if (limitBlock($sourceLimit, set_org_max_blacklist)) {
if (!isset($_POST['new_rec_mail']) || !mailVal($_POST['new_rec_mail'])) {
$errText .= '* ' . letheglobal_invalid_e_mail_address . '<br>';
} else {
if (cntData("SELECT ID FROM " . db_table_pref . "blacklist WHERE email='" . mysql_prep($_POST['new_rec_mail']) . "'") != 0) {
$errText .= '* ' . letheglobal_e_mail_already_exists . '<br>';
}
}
if (!isset($_POST['new_rec_ip']) || empty($_POST['new_rec_ip'])) {
$_POST['new_rec_ip'] = '0.0.0.0';
}
if (!isset($_POST['new_rec_reason']) || !is_numeric($_POST['new_rec_reason'])) {
$errText .= '* ' . subscribers_please_choose_a_reason . '<br>';
}
if ($errText == '') {
$blist = new lethe();
$blist->OID = set_org_id;
$blist->addBlacklist();
/* Init Limits */
$sourceLimit = calcSource(set_org_id, 'subscriber.blacklist');
}
/* Demo Check */
if (!isDemo('editCodes')) {
$errText = errMod(letheglobal_demo_mode_active, 'danger');
}
$sourceLimit = calcSource(set_org_id, 'shortcode');
$pg_nav_buts = '';
if (isset($_POST['editCodes'])) {
/* Add New */
if (limitBlock($sourceLimit, set_org_max_shortcode)) {
if (isset($_POST['new_code']) && !empty($_POST['new_code'])) {
if (isset($_POST['new_code_val']) && !empty($_POST['new_code_val'])) {
if (array_key_exists(strtoupper($_POST['new_code']), $LETHE_SYSTEM_SHORTCODES)) {
$errText .= '* ' . organizations_short_code_has_defined_as_a_system_code . '<br>';
}
if (cntData("SELECT ID FROM " . db_table_pref . "short_codes WHERE OID=" . set_org_id . " AND code_key='" . mysql_prep($_POST['new_code']) . "'") != 0) {
$errText .= '* ' . organizations_short_code_already_exists . '<br>';
}
if ($errText == '') {
$addCode = $myconn->prepare("INSERT INTO " . db_table_pref . "short_codes SET OID=" . set_org_id . ", code_key=?, code_val=?") or die(mysqli_error($myconn));
$addCode->bind_param('ss', $_POST['new_code'], $_POST['new_code_val']);
$addCode->execute();
$addCode->close();
}
}
}
}
/* Update */
if (isset($_POST['code_datas'])) {
$upCode = $myconn->prepare("UPDATE " . db_table_pref . "short_codes SET code_val=? WHERE OID=" . set_org_id . " AND ID=?") or die(mysqli_error($myconn));
foreach ($_POST['code_datas'] as $k => $v) {
public function addOrganization()
{
global $myconn;
global $LETHE_ORG_DISK_QUOTA_LIST;
global $LETHE_ORG_EDITABLE_CODES;
global $LETHE_SUBSCRIBE_ERRORS;
$this->errPrint = '';
if (!isset($_POST['org_name']) || empty($_POST['org_name'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_organization_name . '<br>';
}
if (!isset($_POST['org_max_user']) || !is_numeric($_POST['org_max_user'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_maximum_user_limit . '<br>';
}
if (!isset($_POST['org_max_newsletter']) || !is_numeric($_POST['org_max_newsletter'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_maximum_newsletter_limit . '<br>';
}
if (!isset($_POST['org_max_autoresponder']) || !is_numeric($_POST['org_max_autoresponder'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_maximum_autoresponder_limit . '<br>';
}
if (!isset($_POST['org_max_subscriber']) || !is_numeric($_POST['org_max_subscriber'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_maximum_subscriber_limit . '<br>';
}
if (!isset($_POST['org_max_subscriber_group']) || !is_numeric($_POST['org_max_subscriber_group'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_maximum_subscriber_group_limit . '<br>';
}
if (!isset($_POST['org_max_subscribe_form']) || !is_numeric($_POST['org_max_subscribe_form'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_maximum_subscribe_form_limit . '<br>';
}
if (!isset($_POST['org_max_blacklist']) || !is_numeric($_POST['org_max_blacklist'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_maximum_black_list_limit . '<br>';
}
if (!isset($_POST['org_max_template']) || !is_numeric($_POST['org_max_template'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_maximum_template_limit . '<br>';
}
if (!isset($_POST['org_max_shortcode']) || !is_numeric($_POST['org_max_shortcode'])) {
$this->errPrint .= '* ' . organizations_please_enter_maximum_short_code_limit . '<br>';
}
if (!isset($_POST['org_max_daily_limit']) || !is_numeric($_POST['org_max_daily_limit'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_daily_sending_limit . '<br>';
}
if (!isset($_POST['org_standby_organization']) || !is_numeric($_POST['org_standby_organization'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_standby_time_for_organizations . '<br>';
}
if (!isset($_POST['org_submission_account']) || intval($_POST['org_submission_account']) == 0) {
$this->errPrint .= '* ' . organizations_please_choose_a_submission_account . '<br>';
}
if (!isset($_POST['org_sender_title']) || empty($_POST['org_sender_title'])) {
$this->errPrint .= '* ' . organizations_please_enter_a_sender_title . '<br>';
}
if (!isset($_POST['org_reply_mail']) || !mailVal($_POST['org_reply_mail'])) {
$this->errPrint .= '* ' . organizations_invalid_reply_mail . '<br>';
}
if (!isset($_POST['org_test_mail']) || !mailVal($_POST['org_test_mail'])) {
$this->errPrint .= '* ' . organizations_invalid_test_mail . '<br>';
}
if (!isset($_POST['org_timezone']) || empty($_POST['org_timezone'])) {
$this->errPrint .= '* ' . organizations_please_choose_a_timezone . '<br>';
}
if (!isset($_POST['org_after_unsubscribe']) || !is_numeric($_POST['org_after_unsubscribe'])) {
$this->errPrint .= '* ' . organizations_please_choose_a_unsubscribe_action . '<br>';
}
if (!isset($_POST['org_verification']) || !is_numeric($_POST['org_verification'])) {
$this->errPrint .= '* ' . organizations_please_choose_a_verification_method . '<br>';
}
if (!isset($_POST['org_random_load']) || empty($_POST['org_random_load'])) {
$_POST['org_random_load'] = '';
} else {
$_POST['org_random_load'] = 1;
}
if (!isset($_POST['org_load_type']) || !is_numeric($_POST['org_load_type'])) {
$this->errPrint .= '* ' . organizations_please_choose_a_load_type . '<br>';
}
if (!isset($_POST['org_max_disk_quota']) || !in_array($_POST['org_max_disk_quota'], $LETHE_ORG_DISK_QUOTA_LIST)) {
$this->errPrint .= '* ' . organizations_invalid_disk_quota_value . '<br>';
}
if ($this->errPrint == '') {
/* Common Values */
$this->isPrimary = cntData("SELECT * FROM " . db_table_pref . "organizations WHERE isPrimary=1") == 0 ? 1 : 0;
$billingDate = $this->billingDate == 0 ? '' : $this->billingDate;
$orgTag = $this->orgTag == '' ? slugify($_POST['org_name'] . '-' . substr(encr($_POST['org_name'] . time()), 0, 12)) : $this->orgTag;
$public_key = $this->public_key == '' ? md5($orgTag . time() . rand() . $_POST['org_name'] . uniqid(true)) : $this->public_key;
$private_key = $this->private_key == '' ? md5($orgTag . sha1(time() . rand() . $_POST['org_name'] . uniqid(true)) . sha1(uniqid(true))) : $this->private_key;
$genAPIKey = sha1($private_key + time() + $_SERVER['REMOTE_ADDR'] + $private_key + $public_key);
$genAPIKey = substr(base64_encode($genAPIKey), 0, 32);
# RSS Url
if (!isset($_POST['org_rss_url']) || empty($_POST['org_rss_url'])) {
# Define as system URL
$_POST['org_rss_url'] = lethe_root_url . 'lethe.newsletter.php?pos=rss&oid=' . $public_key;
} else {
$_POST['org_rss_url'] = $_POST['org_rss_url'];
}
$addOrg = $myconn->prepare("INSERT INTO \n\t\t\t\t\t\t\t\t\t\t\t\t\t\t" . db_table_pref . "organizations\n\t\t\t\t\t\t\t\t\t\t\t\tSET\n\t\t\t\t\t\t\t\t\t\t\t\t\t\torgTag=?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\torgName=?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tbillingDate=?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tisActive=1,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tpublic_key=?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tprivate_key=?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tapi_key=?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tip_addr=?,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tisPrimary=" . $this->isPrimary . ",\n\t\t\t\t\t\t\t\t\t\t\t\t\t\trss_url=?\n\t\t\t\t\t\t\t\t\t\t\t\t\t") or die(mysqli_error($myconn));
$addOrg->bind_param('ssssssss', $orgTag, $_POST['org_name'], $billingDate, $public_key, $private_key, $genAPIKey, $_SERVER['REMOTE_ADDR'], $_POST['org_rss_url']);
$addOrg->execute();
$addOrg->close();
/* Organization ID */
$orgID = $myconn->insert_id;
$this->OID = $orgID;
/* Create Folders */
if (mkdir(LETHE_RESOURCE . DIRECTORY_SEPARATOR . $orgTag, 0755)) {
mkdir(LETHE_RESOURCE . DIRECTORY_SEPARATOR . $orgTag . '/expimp', 0755);
}
/* Load Settings */
global $LETHE_ORG_SET_VALS;
$addSet = $myconn->prepare("INSERT INTO " . db_table_pref . "organization_settings SET set_key=?,set_val=?,OID=?") or die(mysqli_error($myconn));
foreach ($LETHE_ORG_SET_VALS as $k => $v) {
$addSet->bind_param('ssi', $v, $_POST[$v], $orgID);
$addSet->execute();
}
$addSet->close();
/* Primary Records */
# Groups
$myconn->query("INSERT INTO " . db_table_pref . "subscriber_groups (OID,UID,group_name,isUnsubscribe,isUngroup) VALUES \n\t\t\t\t(" . $orgID . ",0,'Unsubscribes',1,0),\n\t\t\t\t(" . $orgID . ",0,'Ungrouped',0,1)\n\t\t\t") or die(mysqli_error($myconn));
$unGroupID = getOrgData($orgID, 0);
# Forms
$newFormID = "LetheForm_" . substr(encr(time() . uniqid(true)), 0, 7);
$defCustErrors = array();
foreach ($LETHE_SUBSCRIBE_ERRORS as $fks => $fvs) {
$defCustErrors[] = $fvs[1];
}
$defCustErrors = implode("[@]", $defCustErrors);
$myconn->query("INSERT INTO \n\t\t\t\t\t\t\t\t\t\t\t" . db_table_pref . "subscribe_forms\n\t\t\t\t\t\t\t\t\tSET\n\t\t\t\t\t\t\t\t\t\t\tOID=" . $orgID . ",\n\t\t\t\t\t\t\t\t\t\t\tform_name='System Form',\n\t\t\t\t\t\t\t\t\t\t\tform_id='" . $newFormID . "',\n\t\t\t\t\t\t\t\t\t\t\tform_type=0,\n\t\t\t\t\t\t\t\t\t\t\tform_success_url=NULL,\n\t\t\t\t\t\t\t\t\t\t\tform_success_url_text=NULL,\n\t\t\t\t\t\t\t\t\t\t\tform_success_text='Your mail recorded successfully!',\n\t\t\t\t\t\t\t\t\t\t\tform_success_redir=0,\n\t\t\t\t\t\t\t\t\t\t\tform_remove=0,\n\t\t\t\t\t\t\t\t\t\t\tisSystem=1,\n\t\t\t\t\t\t\t\t\t\t\tisDraft=0,\n\t\t\t\t\t\t\t\t\t\t\tform_errors='" . $defCustErrors . "',\n\t\t\t\t\t\t\t\t\t\t\tform_group=" . $unGroupID . "\n\t\t\t\t\t\t\t") or die(mysqli_error($myconn));
$sysFormID = getOrgData($orgID, 2);
$myconn->query("INSERT INTO\n\t\t\t\t\t\t\t\t\t\t\t" . db_table_pref . "subscribe_form_fields (OID,FID,field_label,field_name,field_type,field_required,field_pattern,field_placeholder,sorting,field_data,field_static,field_save,field_error) VALUES\n\t\t\t\t\t\t\t\t\t\t\t(" . $orgID . ", " . $sysFormID . ", 'E-Mail', 'LetheForm_Mail', 'email', 1, NULL, 'E-Mail', 1, NULL, 1, 'subscriber_mail', 'Invalid E-Mail Address'),\n\t\t\t\t\t\t\t\t\t\t\t(" . $orgID . ", " . $sysFormID . ", 'Save', 'LetheForm_Save', 'submit', 0, NULL, NULL, 2, NULL, 1, NULL, NULL)\n\t\t\t\t\t\t\t\n\t\t\t\t\t\t\t") or die(mysqli_error($myconn));
# Templates
$this->createSystemTemplates();
/* Public Registration */
if ($this->public_registration) {
/* Verification Mails Here */
# Only PRO
}
if (!$this->onInstall) {
unset($_POST);
}
$this->isSuccess = 1;
$this->errPrint = errMod('' . letheglobal_recorded_successfully . '!', 'success');
} else {
$this->errPrint = errMod($this->errPrint, 'danger');
}
}
?>
</a></td>
<td><?php
echo $LETHE_SUBSCRIBE_FORM_TYPES[$opFormsRs['form_type']];
?>
</td>
<td><?php
echo $LETHE_SUBSCRIBE_FORM_VIEWS[$opFormsRs['form_view']];
?>
</td>
<td><?php
echo showIn(getGroup($opFormsRs['form_group'], 0), 'page');
?>
</td>
<td><?php
echo cntData("SELECT ID FROM " . db_table_pref . "subscribe_form_fields WHERE FID=" . $opFormsRs['ID'] . "");
?>
</td>
<td><?php
echo getBullets($opFormsRs['isSystem']);
?>
</td>
<td><?php
echo getBullets($opFormsRs['subscription_stop'] ? 0 : 1);
?>
</td>
<td><?php
echo setMyDate($opFormsRs['add_date'], 2);
?>
</td>
</tr>
<a class="collapsed" data-toggle="collapse" data-parent="#accordion" href="#collapseTwo" aria-expanded="true" aria-controls="collapseTwo">
<?php
echo subscribers_groups;
?>
(<span class="total-cntr"></span>)
</a>
</h4>
</div>
<div id="collapseTwo" class="panel-collapse collapse in" role="tabpanel" aria-labelledby="headingTwo">
<div class="panel-body">
<?php
$grpCntr = 0;
$opGroup = $myconn->query("SELECT * FROM " . db_table_pref . "subscriber_groups WHERE OID=" . set_org_id . " " . (LETHE_AUTH_VIEW_TYPE ? ' AND UID=' . LETHE_AUTH_ID . '' : '') . " ORDER BY group_name ASC") or die(mysqli_error($myconn));
while ($opGroupRs = $opGroup->fetch_assoc()) {
$grpCount = cntData("SELECT ID FROM " . db_table_pref . "subscribers WHERE GID=" . $opGroupRs['ID'] . "");
$grpCntr = (int) ($grpCntr + $grpCount);
?>
<div class="row">
<div class="col-md-1"><div title="<?php
echo letheglobal_delete;
?>
" class="form-group tooltips"><label for="del_<?php
echo $opGroupRs['ID'];
?>
"><span class="visible-xs"><?php
echo letheglobal_delete;
?>
</span></label><input type="checkbox" name="del_<?php
echo $opGroupRs['ID'];
?>
}
/* Template Downloader */
if ($pos == 'tempdown') {
$tempID = !isset($_GET['tempID']) || empty($_GET['tempID']) ? '' : trim($_GET['tempID']);
$prevs = !isset($_GET['prevs']) || empty($_GET['prevs']) ? '' : '1';
$tempLoad = get_web_page('http://www.newslether.com/resources/feeds/lethe.temp.loader.php?prevs=' . $prevs . '&ID=' . mysql_prep($tempID) . '&key=' . lethe_license_key);
if ($tempLoad['errno'] != 0) {
echo '<span class="text-danger glyphicon glyphicon-remove"></span>';
} else {
$tempRes = json_decode($tempLoad['content'], true);
if ($tempRes['err'] == 'OK') {
$tempData = $tempRes['cont'][0];
if ($prevs == '1') {
die($tempData['temp_data_real']);
}
$controller = cntData("SELECT ID FROM " . db_table_pref . "templates WHERE OID=" . set_org_id . " AND temp_id='" . mysql_prep($tempData['temp_id']) . "'");
if ($controller == 0) {
$temp_name = $tempData['name'];
$temp_contents = $tempData['temp_data'];
$temp_type = $tempData['temp_type'];
$isSystem = $tempData['isSystem'];
$temp_id = $tempData['temp_id'];
$temp_prev = $tempData['image'];
# Try to upload preview image
$path_parts = pathinfo($temp_prev);
$newName = rand(1000, 99999) . '_' . $path_parts['basename'];
$saveto = set_org_resource . DIRECTORY_SEPARATOR . $newName;
if (grab_image($temp_prev, $saveto)) {
$temp_prev = set_org_resource_url . '/' . $newName;
} else {
$temp_prev = NULL;
