| 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/lavignotte.com/seo-mailing/tools/ |
Upload File : |
<?php
if(count($_POST)){
$id_group = $_POST['group'];
$str = $_POST['data'];
$str = str_replace("\"", "", $str);
$gg = explode("\n", $str);
foreach ($gg as $val){
$value = explode(";", $val);
$name = trim($value[0]);
if(!isset($value[1])){
$email = trim($value[0]);
}else{
$email = trim($value[1]);
}
$re = mysqli_query($db,"SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE email = '".$email."' AND id_cat = '{$id_group}' LIMIT 1");
if(mysqli_num_rows($re)==0 && trim($email) != ''){
$unsubscribe_code = substr(md5(trim($name).trim($email)), 0, 7);
$result = mysqli_query($db,"SELECT domain FROM ".$INFO['sql_tbl_prefix']."blacklist WHERE domain = SUBSTRING_INDEX('".trim($email)."','@',-1) LIMIT 1");
if(mysqli_num_rows($result) ==0 ){
mysqli_query($db,"INSERT INTO ".$INFO['sql_tbl_prefix']."mail_user (id, insert_date, id_user, id_cat, name, email, unsubscribe_code, time_unsubscribe, ip_unsubscribe, status) VALUES ('', '".time()."', '{$_SESSION['id']}', '{$id_group}', '{$name}', '{$email}','".$unsubscribe_code."', '0', '0', '0')");
}
}
}
?>
<script type="application/javascript">
document.location.href="?users";
</script>
<?php } ?>
<form action="" method="post" class="form-horizontal">
<div class="control-group">
<label class="control-label" for="group"><?php echo __('Group');?> <i class="icon-exclamation-sign" rel="tooltip" title="<?php echo __('In brackets you can see the amount of email address in group');?>"></i></label>
<div class="controls">
<select name="group">
<?php
if($_SESSION['PERM'][5]['v'] == 1){
$where = ' WHERE id_user ='.$_SESSION['id'];
}else{
$where = '';
}
$query = "SELECT *,
(SELECT COUNT(*) FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE ".$INFO['sql_tbl_prefix']."mail_user.id_cat = ".$INFO['sql_tbl_prefix']."mail_group.id AND ".$INFO['sql_tbl_prefix']."mail_user.status = 0) as count_user
FROM ".$INFO['sql_tbl_prefix']."mail_group {$where} ORDER by name ";
$result = mysqli_query($db,$query) or exit("select advice error");
while($group = mysqli_fetch_array($result)){ ?>
<option value="<?php echo $group['id']?>">(<?php echo $group['count_user']?>) <?php echo $group['name']?></option>
<?php } ?>
</select>
</div>
</div>
<div class="control-group">
<label class="control-label" for="data"><?php echo __('Custom Email list');?><br><i><?php echo __('Separated by ;');?></i></label>
<div class="controls">
<textarea id="data" name="data" class="span6" rows="10"></textarea><br><br>
<div class="alert alert-info"><h5><?php echo __('Example:');?></h5>name; email@site.com<br>name2; email2@site.com<br>name3; email3-1@site.com,email3-2@site.com</div>
</div>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-primary"><?php echo __('Save');?></button>
</div>
</form>