function getOrgData($v, $d)
{
global $myconn;
# 0 - Get Ungroup ID
# 1 - Get ID by Public Key
# 2 - Get System Form ID
# 3 - Get ID by Private Key
if ($d == 0) {
$retData = array();
$opSbs = $myconn->query("SELECT * FROM " . db_table_pref . "subscriber_groups WHERE OID=" . intval($v) . " AND isUngroup=1") or die(mysqli_error($myconn));
if (mysqli_num_rows($opSbs) == 0) {
$opSbs->free();
return 0;
} else {
$rs = $opSbs->fetch_assoc();
$retData = trim($rs['ID']);
$opSbs->free();
return $retData;
}
} else {
if ($d == 1) {
$retData = 0;
$opSbs = $myconn->prepare("SELECT * FROM " . db_table_pref . "organizations WHERE public_key=?") or die(mysqli_error($myconn));
$opSbs->bind_param('s', $v);
$opSbs->execute();
$opSbs->store_result();
if ($opSbs->num_rows == 0) {
$opSbs->close();
} else {
$srb = new Statement_Result($opSbs);
$opSbs->fetch();
$opSbs->close();
$retData = $srb->Get('ID');
}
return $retData;
} else {
if ($d == 2) {
$retData = array();
$opSbs = $myconn->query("SELECT * FROM " . db_table_pref . "subscribe_forms WHERE OID=" . intval($v) . " AND isSystem=1") or die(mysqli_error($myconn));
if (mysqli_num_rows($opSbs) == 0) {
$opSbs->free();
return 0;
} else {
$rs = $opSbs->fetch_assoc();
$retData = trim($rs['ID']);
$opSbs->free();
return $retData;
}
} else {
if ($d == 3) {
$retData = 0;
$opSbs = $myconn->prepare("SELECT * FROM " . db_table_pref . "organizations WHERE private_key=?") or die(mysqli_error($myconn));
$opSbs->bind_param('s', $v);
$opSbs->execute();
$opSbs->store_result();
if ($opSbs->num_rows == 0) {
$opSbs->close();
} else {
$srb = new Statement_Result($opSbs);
$opSbs->fetch();
$opSbs->close();
$retData = $srb->Get('ID');
}
return $retData;
}
}
}
}
}
if ($lmail == '' || !mailVal($lmail)) {
jsonRet(false, 'INVALID_EMAIL');
}
if (!in_array($act, $actionList)) {
jsonRet(false, 'INVALID_ACTION');
}
/* Check Auth */
$opOrg = $myconn->prepare("SELECT * FROM " . db_table_pref . "organizations WHERE public_key=? AND BINARY api_key=?") or die(mysqli_error($myconn));
$opOrg->bind_param('ss', $pkey, $akey);
$opOrg->execute();
$opOrg->store_result();
if ($opOrg->num_rows == 0) {
$opOrg->close();
jsonRet(false, 'INVALID_ORG');
} else {
$sr = new Statement_Result($opOrg);
$opOrg->fetch();
$opOrg->close();
if ($sr->Get('isActive') == 0) {
jsonRet(false, 'INVALID_ORG');
} else {
# LOAD ORG SETTINGS
$opSC = new lethe();
$orgSets = array();
if (!$opSC->loadOrg($sr->Get('ID'))) {
jsonRet(false, 'INVALID_ORG');
}
# ACTIONS START *******************************************************************************************************
# Add
if ($act == 'add') {
/* Limit Controller */
<!-- Organization Add End -->
<?php
} else {
if ($page_sub2 == 'edit') {
#Edit
?>
<!-- Organization Edit Start -->
<?php
$opOrg = $myconn->prepare("SELECT * FROM " . db_table_pref . "users WHERE ID=? AND OID=" . set_org_id . "") or die(mysqli_error($myconn));
$opOrg->bind_param('s', $ID);
$opOrg->execute();
$opOrg->store_result();
if ($opOrg->num_rows == 0) {
echo errMod('* ' . letheglobal_record_not_found . '', 'danger');
} else {
$sr = new Statement_Result($opOrg);
$opOrg->fetch();
echo '<h1>' . organizations_organization . '<span class="help-block"><span class="text-primary">' . organizations_edit_user . '</span></span></h1><hr>' . $errText;
if (!isset($lethe->isSuccess) || $lethe->isSuccess == 0) {
$permPages = array();
$opPerList = $myconn->query("SELECT * FROM " . db_table_pref . "user_permissions WHERE UID=" . $sr->Get('ID') . "") or die(mysqli_error($myconn));
while ($opPerListRs = $opPerList->fetch_assoc()) {
$permPages[$opPerListRs['perm']] = '';
}
$opPerList->free();
?>
<form action="" method="POST" onsubmit="listbox_selectall('perm-sel-list', true);listbox_selectall('perm-all-list', true)">
<div role="tabpanel">
<!-- Nav tabs -->
<ul class="nav nav-tabs" role="tablist">
# | Email developer@artlantis.net |
# | Web http://www.artlantis.net |
# +------------------------------------------------------------------------+
/* Load Settings */
if (isLogged()) {
/* Load User Settings */
$LTH = $myconn->stmt_init();
$LTH = $myconn->prepare("SELECT * FROM " . db_table_pref . "users WHERE session_token=?") or die(mysqli_error($myconn));
$LTH->bind_param('s', $_COOKIE['lethe']);
$LTH->execute();
$LTH->store_result();
if ($LTH->num_rows == 0) {
header('Location: pg.login.php');
die('<script>window.location.href="' . lethe_admin_url . 'pg.login.php";</script>');
}
$sr = new Statement_Result($LTH);
$LTH->fetch();
/* Settings */
define('LETHE_AUTH_MODE', $sr->Get('auth_mode'));
define('LETHE_AUTH_ID', $sr->Get('ID'));
define('LETHE_AUTH_NAME', $sr->Get('real_name'));
define('LETHE_AUTH_ORG_ID', $sr->Get('OID'));
define('LETHE_AUTH_VIEW_TYPE', usrAllowRecords($sr->Get('user_spec_view')));
/* Permissions */
if (LETHE_AUTH_MODE != 2) {
$opPerm = $myconn->query("SELECT * FROM " . db_table_pref . "user_permissions WHERE UID=" . $sr->Get('ID') . "") or die(mysqli_error($myconn));
while ($opPermRs = $opPerm->fetch_assoc()) {
$LETHE_PERMISSIONS[] = $opPermRs['perm'];
}
$opPerm->free();
}
</script>
';
die($fieldData);
}
/* Report Extra Info */
if ($pos == 'extInfo') {
# Clicked URLs etc
$extraInfo = '<h4 class="text-primary">' . autoresponder_extra_info . '</h4><hr>';
$opData = $myconn->prepare("SELECT * FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND ID=?") or die(mysqli_error($myconn));
$opData->bind_param('i', $ID);
$opData->execute();
$opData->store_result();
if ($opData->num_rows == 0) {
$extraInfo .= errMod(letheglobal_record_not_found, 'danger');
} else {
$extST = new Statement_Result($opData);
$opData->fetch();
$extraInfo .= letheglobal_e_mail . ': ' . showIn($extST->Get('email'), 'page') . '<br>';
$extraInfo .= letheglobal_date . ': ' . setMyDate($extST->Get('add_date'), 2) . '<br>';
$extraInfo .= letheglobal_clicks . ' / ' . letheglobal_opens . ' ' . autoresponder_hit . ': ' . showIn($extST->Get('hit_cnt'), 'page') . '<br>';
$extraInfo .= autoresponder_extra_info . ': <hr>';
if ($extST->Get('extra_info') != '') {
$extraInfo .= '<pre>' . showIn($extST->Get('extra_info'), 'page') . '</pre>';
}
}
$opData->close();
echo $extraInfo;
}
?>
?>
<!-- Organization Edit Start -->
<?php
if (!PRO_MODE) {
$ID = set_org_id;
} else {
$ID = LETHE_AUTH_MODE != 2 ? set_org_id : intval($ID);
}
$opOrg = $myconn->prepare("SELECT * FROM " . db_table_pref . "organizations WHERE ID=?") or die(mysqli_error($myconn));
$opOrg->bind_param('s', $ID);
$opOrg->execute();
$opOrg->store_result();
if ($opOrg->num_rows == 0) {
echo errMod('* ' . letheglobal_record_not_found . '', 'danger');
} else {
$sr = new Statement_Result($opOrg);
$opOrg->fetch();
echo '<h1>' . showIn($sr->Get('orgName')) . '<span class="help-block"><span class="text-primary">' . letheglobal_edit . '</span></span></h1><hr>' . $errText;
//if(!isset($lethe->isSuccess) || $lethe->isSuccess==0){
?>
<form action="" method="POST">
<div role="tabpanel">
<!-- Nav tabs -->
<ul class="nav nav-tabs" role="tablist">
<li role="presentation" class="active"><a href="#general" aria-controls="general" role="tab" data-toggle="tab"><?php
echo organizations_general;
?>
</a></li>
<li role="presentation" style="display:none;"><a href="#limits" aria-controls="limits" role="tab" data-toggle="tab"><?php
echo organizations_limits;
$opCamp->close();
} else {
if ($pos == 'track') {
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();
public function buildForm()
{
global $myconn;
$formData = '';
if ($this->formID == 0) {
$formIDs = 1;
} else {
$formIDs = $this->formID;
}
$opForms = $myconn->prepare("SELECT * FROM " . db_table_pref . "subscribe_forms WHERE OID=" . $this->OID . " AND " . (!$this->formID ? 'isSystem=?' : 'ID=?') . "") or die(mysqli_error($myconn));
$opForms->bind_param('i', $formIDs);
$opForms->execute();
$opForms->store_result();
if ($opForms->num_rows == 0) {
$opForms->close();
return errMod('Subscribe Form Error!', 'danger');
die;
}
$sr = new Statement_Result($opForms);
$opForms->fetch();
$opForms->close();
$formFields = array('form_view' => $sr->Get('form_view'), 'form_fields' => array());
$formData .= '<div id="lethe-result"></div><form ' . ($sr->Get('form_view') == 1 ? 'class="form-inline"' : '') . ' name="' . $sr->Get('form_id') . '" id="' . $sr->Get('form_id') . '" method="POST" enctype="application/x-www-form-urlencoded" action="javascript:;">' . PHP_EOL;
$formData .= '<input type="hidden" id="lethe_form" name="lethe_form" value="' . $sr->Get('form_id') . '">';
$formData .= '<input type="hidden" id="lethe_oid" name="lethe_oid" value="' . set_org_public_key . '">';
$opFields = $myconn->query("SELECT * FROM " . db_table_pref . "subscribe_form_fields WHERE FID=" . $sr->Get('ID') . " ORDER BY sorting ASC") or die(mysqli_error($myconn));
if (mysqli_num_rows($opFields) == 0) {
$formData .= errMod('Form fields can not be found', 'danger');
} else {
while ($opFieldsRs = $opFields->fetch_assoc()) {
$formFields['form_fields'][] = array('field_id' => $opFieldsRs['ID'], 'field_name' => $opFieldsRs['field_name'], 'field_label' => $opFieldsRs['field_label'], 'field_type' => $opFieldsRs['field_type'], 'field_required' => $opFieldsRs['field_required'], 'field_pattern' => $opFieldsRs['field_pattern'], 'field_placeholder' => $opFieldsRs['field_placeholder'], 'field_data' => $opFieldsRs['field_data']);
}
$formData .= $this->formDesigner($formFields);
$opFields->free();
}
$formData .= '</form>' . PHP_EOL;
/* Ajax Code */
$formData .= '<script type="text/javascript">' . PHP_EOL;
$formData .= '
$("#' . $sr->Get('form_id') . '").on("submit",function(){
$.ajax({
url: "' . lethe_root_url . 'lethe.newsletter.php?pos=subscribe",
type: "POST",
contentType: "application/x-www-form-urlencoded",
crossDomain: true,
data: $("#' . $sr->Get('form_id') . '").serialize(),
success: function(data){
$("#lethe-result").html(data);
$("html,body").animate({scrollTop: $("#lethe-result").offset().top},"slow");
},
error: function(){
$("#lethe-result").html("<div class=\\"alert alert-danger\\">' . subscribers_there_is_error_while_submit . '</div>");
}
});});' . PHP_EOL;
$formData .= '</script>' . PHP_EOL;
if (!$this->isPreviewForm) {
/* Add JQuery */
if ($sr->Get('include_jquery')) {
$formData .= '<script src="//code.jquery.com/jquery-1.11.2.min.js"></script>' . PHP_EOL;
}
/* Add JQuery UI */
if ($sr->Get('include_jqueryui')) {
$formData .= '
<link rel="stylesheet" href="//ajax.googleapis.com/ajax/libs/jqueryui/1.11.2/themes/smoothness/jquery-ui.css" />
<script src="//ajax.googleapis.com/ajax/libs/jqueryui/1.11.2/jquery-ui.min.js"></script>' . PHP_EOL;
}
}
$formData = preg_replace('/\\s+/', ' ', $formData);
$formDataAll = '<!-- LETHE NEWSLETTER -->' . PHP_EOL;
$formDataAll .= $formData . PHP_EOL;
$formDataAll .= '<!-- LETHE NEWSLETTER -->' . PHP_EOL;
return $formDataAll;
}
if (DEMO_MODE) {
$pwRem = true;
$pwrm_res = mysql_prep(errMod(letheglobal_demo_mode_active, 'danger'));
} else {
$pwRem = true;
if (!isset($_POST['pw_rem']) || !mailVal($_POST['pw_rem'])) {
$pwrm_res = mysql_prep(errMod(letheglobal_invalid_e_mail_address, 'danger'));
} else {
$opUser = $myconn->prepare("SELECT * FROM " . db_table_pref . "users WHERE mail=?") or die(mysqli_error($myconn));
$opUser->bind_param('s', $_POST['pw_rem']);
$opUser->execute();
$opUser->store_result();
if ($opUser->num_rows < 1) {
$pwrm_res = mysql_prep(errMod(letheglobal_record_not_found, 'danger'));
} else {
$srm = new Statement_Result($opUser);
$opUser->fetch();
# Load phpMailer basic mail sender
# Start
/* Design Receiver Data (Mail body could be used with system template) */
$rndPassEnc = encr('myLethe' . time() . rand() . uniqid(true));
$newPass = substr($rndPassEnc, 1, 12);
$newPassEnc = encr($newPass);
$mailBody = '<p>Hello ' . $srm->Get('real_name') . ',</p>';
$mailBody .= '<p><strong>Your new password:</strong> ' . $newPass . '</p>';
$mailBody .= '<p>Do not forget to change your password after logged in.</p>';
$mailBody .= '<p>Thank you!</p>';
$rcMail = showIn($srm->Get('mail'), 'page');
$rcName = showIn($srm->Get('real_name'), 'page');
$rcSubject = showIn(letheglobal_password_recovery, 'page');
$rcBody = $mailBody;
?>
<!-- Newsletter Add End -->
<?php
} else {
if ($page_sub == 'edit') {
echo '<h1>' . $pg_title . '
<span class="help-block text-primary">' . newsletter_edit_campaign . '</span></h1><hr>' . $pg_nav_buts . $errText;
/* Load Campaign */
$opCamp = $myconn->prepare("SELECT \n\t\t\t\t\t\t\t\t\t\t\tC.*,\n\t\t\t\t\t\t\t\t\t\t\tNSG.CID,NSG.GID\n\t\t\t\t\t\t\t\t FROM \n\t\t\t\t\t\t\t\t\t\t\t" . db_table_pref . "campaigns AS C,\n\t\t\t\t\t\t\t\t\t\t\t" . db_table_pref . "campaign_groups AS NSG\n\t\t\t\t\t\t\t\t WHERE \n\t\t\t\t\t\t\t\t\t\t\tC.OID=" . set_org_id . " \n\t\t\t\t\t\t\t\t AND\n\t\t\t\t\t\t\t\t\t\t\tNSG.CID=C.ID\n\t\t\t\t\t\t\t\t AND \n\t\t\t\t\t\t\t\t\t\t\tC.ID=?\n\t\t\t\t\t\t\t\t\t") or die(mysqli_error($myconn));
$opCamp->bind_param('i', $ID);
$opCamp->execute();
$opCamp->store_result();
if ($opCamp->num_rows == 0) {
echo errMod(letheglobal_record_not_found, 'danger');
} else {
$srCamp = new Statement_Result($opCamp);
while ($rc = $opCamp->fetch()) {
$_POST['groups'][] = $srCamp->Get('GID');
}
$valMods['launch_date'] = date('d-m-Y', strtotime($srCamp->Get('launch_date')));
$valMods['launch_hour'] = date('H', strtotime($srCamp->Get('launch_date')));
$valMods['launch_min'] = date('i', strtotime($srCamp->Get('launch_date')));
/* 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\t\t\t\t\t\t\t\t AND\n\t\t\t\t\t\t\t\t\t\tisUnsubscribe=0\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;
}
$opGroups->free();
?>
<!-- Newsletter Edit Start -->
<script>$(".footable").footable();</script>
';
}
$opSbr->close();
echo $subReport;
}
/* Subscriber Edit */
if ($pos == 'sbredit') {
$opSub = $myconn->prepare("SELECT \n\t\t\t\t\t\t\t\t\t\tS.*,\n\t\t\t\t\t\t\t\t\t\tSG.ID AS SGID, SG.group_name\n\t\t\t\t\t\t\t\t FROM \n\t\t\t\t\t\t\t\t\t\t" . db_table_pref . "subscribers AS S,\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\tWHERE \n\t\t\t\t\t\t\t\t\t\tS.OID=" . set_org_id . " \n\t\t\t\t\t\t\t\t AND \n\t\t\t\t\t\t\t\t\t\tS.ID=?\n\t\t\t\t\t\t\t\t AND\n\t\t\t\t\t\t\t\t\t\t(SG.ID = S.GID)\n\t\t\t\t\t\t\t\t\t") or die(mysqli_error($myconn));
$opSub->bind_param('i', $ID);
$opSub->execute();
$opSub->store_result();
if ($opSub->num_rows == 0) {
echo errMod(letheglobal_record_not_found, 'danger');
} else {
$sr = new Statement_Result($opSub);
$opSub->fetch();
/* Update Subscriber */
if (!isDemo('uptSubscriber')) {
die(errMod(letheglobal_demo_mode_active, 'danger'));
}
$errText = '';
if (isset($_POST['uptSubscriber'])) {
if (!isset($_POST['group']) || !is_numeric($_POST['group'])) {
$errText .= '* ' . subscribers_please_choose_a_group . '<br>';
}
if (!isset($_POST['subscriber_name']) || empty($_POST['subscriber_name'])) {
$_POST['subscriber_name'] = NULL;
}
if (!isset($_POST['subscriber_mail']) || !mailVal($_POST['subscriber_mail'])) {
$errText .= '* ' . letheglobal_invalid_e_mail_address . '<br>';
public function bounceHandle()
{
global $myconn;
# Open Campaign
if (!empty($this->bounceKey)) {
$campID = $this->bounceKey;
$opCamp = $myconn->prepare("SELECT * FROM " . db_table_pref . "campaigns WHERE campaign_key=?") or die(mysqli_error($myconn));
$opCamp->bind_param('s', $campID);
if ($opCamp->execute()) {
$opCamp->store_result();
if ($opCamp->num_rows != 0) {
$srArg = new Statement_Result($opCamp);
$opCamp->fetch();
$opCamp->close();
# Add to Reports
$this->reportCID = $srArg->Get('ID');
$this->OID = $srArg->Get('OID');
$this->reportPos = 2;
# Bounce
if ($this->addReport()) {
# Apply Action
if ($this->bounceActs()) {
return true;
} else {
return false;
}
} else {
return false;
}
} else {
return false;
}
} else {
return false;
}
} else {
return false;
}
}
}
/* Live Date */
if ($pos == 'getlivedate') {
echo date('d.m.Y H:i:s A');
}
include_once LETHE_ADMIN . DIRECTORY_SEPARATOR . '/inc/inc_auth.php';
/* Template Preview */
if ($pos == 'temprev') {
$opTemp = $myconn->prepare("SELECT * FROM " . db_table_pref . "templates WHERE OID=" . set_org_id . " AND ID=? " . (LETHE_AUTH_VIEW_TYPE ? ' AND UID=' . LETHE_AUTH_ID . '' : '') . "") or die(mysqli_error($myconn));
$opTemp->bind_param('i', $ID);
$opTemp->execute();
$opTemp->store_result();
if ($opTemp->num_rows == 0) {
echo letheglobal_record_not_found;
}
$sr = new Statement_Result($opTemp);
$opTemp->fetch();
$opTemp->close();
echo $sr->Get('temp_contents');
}
/* Submission Account Details */
if ($pos == 'getSubInfos') {
$subAccData = getSubmission($ID, 0);
$printData = '<div class="row">
<div class="col-md-4">
<p><strong>' . newsletter_daily_limit . ':</strong></p>
<p><strong>' . letheglobal_sending . ':</strong></p>
<p><strong>' . letheglobal_type . ':</strong></p>
<p><strong>' . newsletter_test_mail . ':</strong></p>
</div>
<div class="col-md-8">
});
</script>
';
}
/* Report Extra Info */
if ($pos == 'extInfo') {
# Clicked URLs etc
$extraInfo = '<h4 class="text-primary">' . newsletter_extra_info . '</h4><hr>';
$opData = $myconn->prepare("SELECT * FROM " . db_table_pref . "reports WHERE OID=" . set_org_id . " AND ID=?") or die(mysqli_error($myconn));
$opData->bind_param('i', $ID);
$opData->execute();
$opData->store_result();
if ($opData->num_rows == 0) {
$extraInfo .= errMod(letheglobal_record_not_found, 'danger');
} else {
$extST = new Statement_Result($opData);
$opData->fetch();
$extInfos = $extST->Get('extra_info');
$extraInfo .= letheglobal_e_mail . ': ' . showIn($extST->Get('email'), 'page') . '<br>';
$extraInfo .= letheglobal_date . ': ' . setMyDate($extST->Get('add_date'), 2) . '<br>';
$extraInfo .= letheglobal_clicks . ' / ' . letheglobal_opens . ' ' . newsletter_hit . ': ' . showIn($extST->Get('hit_cnt'), 'page') . '<br>';
$extraInfo .= newsletter_extra_info . ': <hr>';
if (!empty($extInfos)) {
$extraInfo .= '<pre>' . showIn($extST->Get('extra_info'), 'page') . '</pre>';
}
}
$opData->close();
echo $extraInfo;
}
?>
<!-- Template Add End -->
<?php
} else {
if ($page_sub == 'edit') {
echo '<h1>' . $pg_title . '<span class="help-block"><span class="text-primary">' . letheglobal_edit . '</span></span></h1><hr>' . $pg_nav_buts . $errText;
?>
<!-- Template Edit Start -->
<?php
$opTemp = $myconn->prepare("SELECT * FROM " . db_table_pref . "templates WHERE OID=" . set_org_id . " AND ID=? " . (LETHE_AUTH_VIEW_TYPE ? ' AND UID=' . LETHE_AUTH_ID . '' : '') . "") or die(mysqli_error($myconn));
$opTemp->bind_param('i', $ID);
$opTemp->execute();
$opTemp->store_result();
if ($opTemp->num_rows == 0) {
echo errMod(letheglobal_record_not_found, 'danger');
} else {
$sr = new Statement_Result($opTemp);
$opTemp->fetch();
$opTemp->close();
?>
<script>
var customMCEchar='<?php
echo LOADED_LANG;
?>
';
var miniPAN=true;
</script>
<script src="Scripts/tinymce/tinymce.min.js"></script>
<script src="Scripts/tinymce/tinymce.custom.js"></script>
<script src="Scripts/leUpload.js"></script>
<form method="POST" action="">
