| Server IP : 109.234.164.53 / Your IP : 216.73.216.110 Web Server : Apache System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64 User : computer3 ( 1098) PHP Version : 7.1.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/computer3/litsolide.com/ODLDDD_2/seo-mailing/groups/ |
Upload File : |
<script>
jQuery.noConflict()(function($){
$(document).ready(function()
{
$(".cheackall").click(function()
{
var checked_status = this.checked;
var clickId = this.id;
for (i=1; i<=<?php echo $_SET['users_page']?>; i++){
$('#tab'+i+clickId).each(function()
{
this.checked = checked_status;
});
}
});
});
});
</script>
<?php
if(count($_POST) && !empty($_POST['email']) && !isset($_POST['table']) && !isset($_POST['id_array'])){
$email_array = '';
$email_array = explode(',',trim($_POST['email']));
foreach($email_array as $email){
if(!filter_var(trim($email), FILTER_VALIDATE_EMAIL)){?>
<div class="alert alert-block">
<h4><?php echo __('Warning!');?></h4>
<?php echo __('E-mail is not valid');?> - <?php echo $email?>
</div>
<?php }else{
$query = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE email = '".trim($email)."' AND id_cat = {$_POST['group']}
AND SUBSTRING_INDEX('".trim($email)."','@',-1) NOT IN (SELECT domain FROM ".$INFO['sql_tbl_prefix']."blacklist)
LIMIT 1";
$result = mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
if(mysqli_num_rows($result) == 0){
if(isset($_POST['feature'])){
$feature = serialize($_POST['feature']);
}else{
$feature = '';
}
$unsubscribe_code = substr(md5(trim($_POST['name']).trim($_POST['email'])), 0, 7);
$query = "INSERT INTO ".$INFO['sql_tbl_prefix']."mail_user (id, insert_date, id_user, id_cat, name, email, unsubscribe_code, time_unsubscribe, ip_unsubscribe, status, feature) VALUES ('', '".time()."', '{$_SESSION['id']}', '{$_POST['group']}', '{$_POST['name']}', '{$_POST['email']}','".$unsubscribe_code."', '0','0','0', '{$feature}')";
mysqli_query($db,$query) or exit("insert error" . mysqli_error()."<br>".$query);
?>
<script type="application/javascript">
document.location.href="?group_users=<?php echo $_POST['group']?>";
</script>
<?php }
}
}
}elseif(count($_POST) && empty($_POST['email']) && !isset($_POST['table']) && !isset($_POST['id_array'])){?>
<div class="alert alert-block">
<h4><?php echo __('Warning!');?></h4>
<?php echo __('Please enter E-mail');?>
</div>
<hr>
<?php }elseif(isset($_POST['table']) && isset($_POST['ope']) && $_POST['ope'] == 2 && count($_POST['table']) > 0 && is_array($_POST['table']) && !isset($_POST['id_array'])){
foreach($_POST['table'] as $k=>$v){
$query = "DELETE FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE id=".$k." LIMIT 1";
mysqli_query($db,$query) or exit("delet error" . mysqli_error());
}
?>
<script type="application/javascript">
document.location.href="?group_users=<?php echo $_GET['group_users']?>";
</script>
<?php }elseif(isset($_POST['id_array'])){
$_POST['id_array'] = str_replace('\"', '"', $_POST['id_array']);
$id_user = unserialize($_POST['id_array']);
foreach($id_user as $k=>$v){
mysqli_query($db,"UPDATE ".$INFO['sql_tbl_prefix']."mail_user SET id_cat = '{$_POST['group']}' WHERE id = ".$k." LIMIT 1");
}?>
<script type="application/javascript">
document.location.href="?group_users=<?php echo $_GET['group_users']?>";
</script>
<?php }?>
<?php $group = mysqli_fetch_array(mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_group WHERE id = {$_GET['group_users']} LIMIT 1"));
?>
<div class="page-header">
<h1><i class="icon-group"></i> <?php echo __('Group');?>: <?php echo $group['name']?><div class="pull-right btn-group"><a href="?groups" class="btn btn-primary"><i class="icon-circle-arrow-left"></i> <?php echo __('All groups');?></a><?php if($_SESSION['PERM'][4]['a'] == 1){?><a href="" id="form" class="btn btn-primary"><i class="icon-plus-sign icon-white"></i> <?php echo __('Add');?></a><?php } ?></div></h1>
</div>
<?php if($_SESSION['PERM'][4]['a'] == 1){?>
<div id="form-content" style="display:none">
<form class="form-horizontal" method="post" action="">
<h4><?php echo __('Add new');?></h4>
<div class="control-group">
<label class="control-label" for="name"><?php echo __('Name');?></label>
<div class="controls">
<input type="text" class="input-xlarge" id="name" name="name">
</div>
</div>
<div class="control-group">
<label class="control-label" for="email"><?php echo __('E-mail');?></label>
<div class="controls">
<input type="email" class="input-xlarge" id="email" name="email">
</div>
</div>
<div class="control-group">
<label class="control-label" for="group"><?php echo __('Group');?></label>
<div class="controls">
<select name="group">
<?php
if($_SESSION['PERM'][4]['v'] == 1){
$where = "WHERE id_user = {$_SESSION['id']}";
}else{
$where = "";
}
$query_g = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_group {$where} ORDER by name ";
$result_g = mysqli_query($db,$query_g) or exit("select advice error");
while($gr = mysqli_fetch_array($result_g)){ ?>
<option value="<?php echo $gr['id']?>" <?php if($gr['id'] == $_GET['group_users']){?> selected="selected"<?php }?>><?php echo $gr['name']?></option>
<?php } ?>
</select>
</div>
</div>
<?php $fea_res = mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user_feature");
if(mysqli_num_rows($fea_res) > 0){
while($fea = mysqli_fetch_array($fea_res)){
?>
<div class="control-group">
<label class="control-label"><?php echo $fea['name']?></label>
<div class="controls">
<input type="text" class="input-xlarge" id="fea" name="feature[<?php echo $fea['id']?>][]">
</div>
</div>
<?php } ?>
<?php }?>
<div class="form-actions">
<button type="submit" class="btn btn-primary"><?php echo __('Save');?></button>
</div>
</form>
</div>
<?php } ?>
<?php
function page()
{
if(empty($_GET["page"])){
$page = 0;
} else {
if(!is_numeric($_GET["page"])) die("<div class='alert alert-danger'>".__('Invalid format for the page number!')."</div>");
$page = $_GET["page"];
}
return $page;
}
function sql_query($onpage, $page, $table)
{
global $db, $lng, $INFO, $where, $wher;
$begin = $page*$onpage;
$sql = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE id_cat = {$_GET['group_users']} ORDER by email LIMIT ".$begin.", ".$onpage;
$result = mysqli_query($db,$sql) or die(mysqli_error().$count);
return $result;
}
function navigation($onpage, $page, $table)
{
global $db, $lng, $INFO,$where, $wher;
if(!empty($_GET['group_users'])){
$gr = '='.$_GET['group_users'];
}else{
$gr = '';
}
$re = '';
$count = mysqli_query($db,"SELECT COUNT(id) FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE id_cat = {$_GET['group_users']}") or die(mysql_error().$count);
$count = mysqli_fetch_array($count);
$count = $count[0];
$pages = $count/$onpage;
$itemscount= $count;
$itemsperpage=$onpage;
if (isset($_GET['page']))
{ $cpage=$_GET['page']; }
else { $cpage=1; }
$pagedisprange=3;
$pagescount=ceil($itemscount/$itemsperpage) -1 ;
$stpage=$cpage-$pagedisprange;
if ($stpage<1) { $stpage=1; }
$endpage=$cpage+$pagedisprange;
if ($endpage>$pagescount) { $endpage=$pagescount; }
if ($cpage>=1) {
if($cpage==1){
$re .= "<a href='#' class='btn btn-small disabled'>".__('First')."</a>";
$re .= "<a href='#' class='btn btn-small disabled'>".__('Previous')."</a>";
}else{
$re .= "<a href='?group_users".$gr."&page=1' class='btn btn-small'>".__('First')."</a>";
$re .= "<a href='?group_users".$gr."&page=".($cpage-1)."' class='btn btn-small'>".__('Previous')."</a>";
}
}
if ($stpage>1) $re .= "<a href='#' class='btn btn-small disabled'>...</a>"; // если начало вывода не 1, то напечатаем три точки
for ($i=$stpage;$i<=$endpage;$i++) {
if ($i==$cpage) { $re .= '<a href="#" class="btn btn-small disabled">'.$i.'</a> '; }
else { $re .= '<a href="?group_users'.$gr.'&page='.$i.'" class="btn btn-small">'.$i.'</a> '; }
}
if ($endpage<$pagescount) $re .= "<a href='#' class='btn btn-small disabled'>...</a>"; // если начало конец вывода не последняя страница, то напечатаем три точки
if ($cpage<=$pagescount) {
if($cpage == $pagescount){
$re .= '<a href="#" class="btn btn-small disabled">'.__('Next').'</a>';
$re .= "<a href='#' class='btn btn-small disabled'>".__('Last')."</a>";
}else{
$re .= '<a href="?group_users'.$gr.'&page='.($cpage+1).'" class="btn btn-small">'.__('Next').'</a>';
$re .= "<a href='?group_users".$gr."&page=".($pagescount)."' class='btn btn-small'>".__('Last')."</a>";
}
}
return $re;
}
$onpage = $_SET['users_page'];
$table = $INFO['sql_tbl_prefix']."mail_user"; //<?php echo search_highlight($item['name'], array($_GET['search']))
$page = page();
$result = sql_query($onpage, $page, $table);
$navigation = navigation($onpage, $page, $table);
?> <div class="btn-group">
<?php echo $navigation?>
</div>
<hr>
<?php if(isset($_POST['table']) && isset($_POST['ope']) && $_POST['ope'] == 1 && count($_POST['table']) > 0 && is_array($_POST['table'])){?>
<form class="form-horizontal" method="post" action="">
<input type="hidden" name="id_array" value='<?php echo serialize($_POST['table'])?>'>
<div class="control-group">
<label class="control-label" for="group"><?php echo __('Group');?></label>
<div class="controls">
<select name="group">
<?php
if($_SESSION['PERM'][4]['v'] == 1){
$where = "WHERE id_user = {$_SESSION['id']}";
}else{
$where = "";
}
$query_g = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_group {$where} ORDER by name ";
$result_g = mysqli_query($db,$query_g) or exit("select advice error");
while($gr = mysqli_fetch_array($result_g)){ ?>
<option value="<?php echo $gr['id']?>" <?php if($gr['id'] == $_GET['group_users']){?> selected="selected"<?php }?>><?php echo $gr['name']?></option>
<?php } ?>
</select>
</div>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-primary"><?php echo __('Save');?></button>
</div>
</form>
</form>
<?php }?>
<?php if(mysqli_num_rows($result)>0){ ?>
<form action="" method="post">
<table class="table table-bordered table-striped">
<thead>
<tr>
<th class="span1">##</th>
<th class="span1 center"><input type="checkbox" class="cheackall"></th>
<th class="span1"><?php echo __('Created')?></th>
<th class="span2"><?php echo __('User');?></th>
<th class="span2"><?php echo __('Group');?></th>
<th class="span2"><?php echo __('E-mail');?></th>
<th><?php echo __('Name');?></th>
<th class="span1"><?php echo __('Unsubscribe code');?></th>
<th class="span1"><?php echo __('Status')?></th>
<?php if(($_SESSION['PERM'][4]['r'] == 1 && $_SESSION['PERM'][4]['e'] == 1) ||
$_SESSION['PERM'][4]['r'] + $_SESSION['PERM'][4]['e'] > 0
){?>
<th class="span1"><?php echo __('Operations');?></th>
<?php } ?>
</tr>
</thead>
<tbody>
<?php $i=1;while($user = mysqli_fetch_array($result)){ ?>
<tr class="font11">
<td><?php echo $user['id']?></td>
<td class="center">
<input type="checkbox" id="tab<?php echo $i++?>" name="table[<?php echo $user['id'];?>]" value="<?php echo $user['id']?>">
</td>
<td><?php if(isset($user['insert_date']) && $user['insert_date'] > 0){
echo date("H:i d.m.Y", $user['insert_date']);
}else{
echo "<span class='label'>".__('Not date')."</span>";
}?></td>
<td><?php $user_name = mysqli_fetch_array(mysql_query($db,"SELECT name FROM ".$INFO['sql_tbl_prefix']."user WHERE id = {$user['id_user']} LIMIT 1"));
if(isset($user_name['id_cat']) && $user_name['id_cat'] > 0){
echo $user_name['name'];
}else{
echo "<i class='icon-globe'></i> ".__('Added from outside');
}
?></td>
<td><?php $que = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_group WHERE id = {$user['id_cat']} LIMIT 1";
$res = mysqli_query($db,$que) or exit("select advice error");
$group = mysqli_fetch_array($res);
echo $group['name'];?></td>
<td><ul style="list-style:none; margin:0px; padding:0px"><?php $email_array = '';
$email_array = explode(',',trim($user['email']));
foreach($email_array as $email){
if(!filter_var(trim($email), FILTER_VALIDATE_EMAIL)){
echo "<li><span class='label label-important'>".__('E-mail is not valid')."</span>";
}else{
echo "<li>";
}
echo $email."</li>";
}?></ul></td>
<td><?php echo $user['name']?></td>
<td><i><?php echo $user['unsubscribe_code']?></i></td>
<td class="center"><?php
if($user['valid'] == 1){
echo "<span class='label'>".__('Checked')."</span>";
}else{
echo "<span class='label label-important'>".__('No checked')."</span>";
}
?></td>
<?php if(($_SESSION['PERM'][4]['r'] == 1 && $_SESSION['PERM'][4]['e'] == 1) ||
$_SESSION['PERM'][4]['r'] + $_SESSION['PERM'][4]['e'] > 0
){?>
<td>
<div class="btn-group">
<a class="btn btn-primary btn-small dropdown-toggle" data-toggle="dropdown" href="#">
<?php echo __('Action');?>
<span class="caret"></span>
</a>
<ul class="dropdown-menu">
<?php if($_SESSION['PERM'][4]['e'] == 1){?>
<!-- dropdown menu links -->
<li><a href="?user_edit=<?php echo $user['id']?>" title="<?php echo __('Edit');?>" ><i class="icon-pencil"></i> <?php echo __('Edit');?></a></li>
<?php } ?>
<?php if($_SESSION['PERM'][4]['r'] == 1){?>
<li class="divider"></li>
<li><a href="?user_del=<?php echo $user['id']?>" onClick="return confirm('<?php echo __('Remove?');?>');"><i class="icon-remove-sign"></i> <?php echo __('Remove');?></a></li>
<?php } ?>
</ul>
</div>
</td>
<?php } ?>
</tr>
<?php } ?>
</tbody>
<tfoot>
<tr>
<td colspan="10">
<div class="input-append">
<select name="ope">
<option value="0">----</option>
<option value="1"><?php echo __('Transfer to another group')?></option>
<option value="2"><?php echo __('Delete Selected')?></option>
</select>
<button type="submit" class="btn btn-danger"><i class="icon-remove-sign"></i> <?php echo __('Ok')?></button></td>
</div>
</td>
</tr>
</tfoot>
</table>
</form>
<div class="btn-group">
<?php echo $navigation?>
</div>
<?php }else{ ?>
<div class="alert alert-info">
<h4><i class="icon-info-sign"></i> <?php echo __('Information');?></h4>
<?php echo __('List of Users is empty. Please add.');?>
</div>
<?php } ?>