| 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/vracandbio.com/seo-mailing/tools/ |
Upload File : |
<?php
if(count($_POST) && isset($_POST['username'])){
mysql_close($db);
$connect_wp = mysql_connect(trim($_POST['hostname']),trim($_POST['username']),trim($_POST['password']),TRUE);
$db_wp = mysql_select_db(trim($_POST['databasename']));
$sqlResult = mysql_query("SELECT * FROM ".$_POST['prefix']."users");
$result = mysql_num_rows($sqlResult);
if(!$connect_wp){$error[]= "Error: <b>Connection to the database</b>";}
if(!$db_wp){$error[]= "Error: <b>Database not found</b>";}
if($result == 0){$error[]= "Error: <b>Connection error to the user table Wordpress</b>";}else{
$user = array();
while($wp_user = mysql_fetch_array($sqlResult, MYSQL_ASSOC)){
$user[$wp_user['ID']]['display_name'] = $wp_user['display_name'];
$user[$wp_user['ID']]['user_email'] = $wp_user['user_email'];
}
}
$db = mysql_connect($INFO['sql_host'], $INFO['sql_user'], $INFO['sql_pass']) or exit ("sql_connect");
mysql_query("SET CHARSET ".$INFO['mysql_codepage']) or exit ("db set charset error: " . mysql_error());
mysql_query ("set character_set_client='".$INFO['sql_charset']."'");
mysql_query ("set character_set_results='".$INFO['sql_charset']."'");
mysql_query ("set collation_connection='".$INFO['sql_charset']."_general_ci'");
mysql_select_db($INFO['sql_database']) or exit ("select db");
if(count($user) > 0){
foreach($user as $val){
$query = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE email = '".trim($val['user_email'])."' AND id_cat = {$_POST['group']} LIMIT 1";
$result = mysql_query($query) or exit("insert error" . mysql_error()."<br>".$query);
if(mysql_num_rows($result) == 0){
$unsubscribe_code = substr(md5(trim($val['display_name']).trim($val['user_email'])), 0, 7);
$result = mysql_query("SELECT domain FROM ".$INFO['sql_tbl_prefix']."blacklist WHERE domain = SUBSTRING_INDEX('".trim($val['user_email'])."','@',-1) LIMIT 1");
if(mysql_num_rows($result) ==0 ){
$query = "INSERT INTO ".$INFO['sql_tbl_prefix']."mail_user (id, insert_date, id_user, id_cat, name, email, unsubscribe_code,feature, time_unsubscribe, ip_unsubscribe, status) VALUES
('', '".time()."', '{$_SESSION['id']}', '{$_POST['group']}', '{$val['display_name']}', '{$val['user_email']}','".$unsubscribe_code."', '','0','0','0')";
mysql_query($query) or exit("insert error" . mysql_error()."<br>".$query);
}
}
}?>
<?php }
}
?>
<?php if(isset($error) && count($error) > 0){?>
<div class="alert alert-error">
<?php echo "<li>".implode('<li>',$error)?>
</div>
<?php } ?>
<div class="row-fluid">
<div class="span6">
<form action="" method="post" class="form-horizontal">
<div class="well">
<div class="control-group">
<label class="control-label" for="hostname"><?php echo __('Hostname');?></label>
<div class="controls">
<input type="text" style="width:100%" name="hostname" id="hostname" value="localhost" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="databasename"><?php echo __('Database Name');?></label>
<div class="controls">
<input type="text" style="width:100%" name="databasename" id="databasename" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="username"><?php echo __('User Name');?></label>
<div class="controls">
<input type="text" style="width:100%" name="username" id="username" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="password"><?php echo __('Password');?></label>
<div class="controls">
<input type="password" style="width:100%" name="password" id="password" required>
</div>
</div>
<div class="control-group">
<label class="control-label" for="prefix"><?php echo __('Prefix');?></label>
<div class="controls">
<input type="text" style="width:100%" name="prefix" id="prefix">
</div>
</div>
<div class="control-group">
<label class="control-label" for="group"><?php echo __('Group');?></label>
<div class="controls">
<select name="group" style="width:100%" >
<?php
if($_SESSION['PERM'][4]['v'] == 1){
$where = "WHERE id_user = {$_SESSION['id']}";
}else{
$where = "";
}
$query = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_group {$where} ORDER by name ";
$result = mysql_query($query) or exit("select advice error");
if(mysql_num_rows($result) > 0){
while($group = mysql_fetch_array($result, MYSQL_ASSOC)){ ?>
<option value="<?php echo $group['id']?>"><?php echo $group['name']?></option>
<?php }
$error=false;
?>
<?php }else{
$error= true;
?>
<option value="0"><?php echo __('Error: First, you need to add a user group');?></option>
<?php } ?>
</select>
</div>
</div>
</div>
<div class="form-actions">
<button type="submit" class="btn btn-primary <?php if($_SESSION['PERM'][5]['a'] == 0){?>disabled<?php } ?>"><?php echo __('Import');?></button>
</div>
</form>
</div>
<div class="span6">
<?php
if(isset($user) && count($user) > 0){
$i=0;
echo '<pre><h4>';
if(count($user)<10) {echo count($user);}else{echo 10;};
echo '('.count($user).')</h4>';
foreach($user as $value){
$i++;
if($i<10){
echo "<li>".$value['display_name']." - ".$value['user_email'];
}else{
break;
}
}
echo "</pre>";
}?>
</div>
</div>