| 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/seo-mailing/tools/ |
Upload File : |
<?php
if(count($_POST) && isset($_POST['username']) && !isset($db_wp)){
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("SHOW COLUMNS FROM ".$_POST['prefix'].$_POST['db_tb']);
$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($db_tb = mysql_fetch_array($sqlResult, MYSQL_ASSOC)){
$tb[] = $db_tb['Field'];
}
}
$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(isset($_POST['tb_name']) && isset($_POST['tb_email']) && $_POST['group']){
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'].$_POST['db_tb']);
$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();
$i = 1;
while($user_db = mysql_fetch_array($sqlResult, MYSQL_ASSOC)){
$users[$i]['name']= $user_db[$_POST['tb_name']];
$users[$i]['email']= $user_db[$_POST['tb_email']];
$i++;
}
}
mysql_close($db_wp);
$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");
foreach($users as $val){
$query = "SELECT * FROM ".$INFO['sql_tbl_prefix']."mail_user WHERE email = '".trim($val['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['name']).trim($val['email'])), 0, 7);
$result = mysql_query("SELECT domain FROM ".$INFO['sql_tbl_prefix']."blacklist WHERE domain = SUBSTRING_INDEX('".trim($val['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['name']}', '{$val['email']}','".$unsubscribe_code."', '','0','0','0')";
mysql_query($query) or exit("insert error" . mysql_error()."<br>".$query);
}
}
}
}
?>
<?php if(isset($error) && count($error)){?>
<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="<?php if(isset($_POST['hostname'])) {echo $_POST['hostname'];}else{?>localhost<?php }?>" 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" value="<?php if(isset($_POST['databasename']))echo $_POST['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" value="<?php if(isset($_POST['username'])) echo $_POST['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" value="<?php if(isset($_POST['password']))echo $_POST['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" value="<?php if(isset($_POST['prefix']))echo $_POST['prefix']?>">
</div>
</div>
<div class="control-group">
<label class="control-label" for="db_tb"><?php echo __('Users Database Table');?></label>
<div class="controls">
<input type="text" style="width:100%" name="db_tb" id="db_tb" value="<?php if(isset($_POST['db_tb']))echo $_POST['db_tb']?>">
</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 if(isset($_POST['group']) && $_POST['group'] == $group['id']) {echo "selected";}?> ><?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>
<?php if(isset($db_wp)){?>
<hr>
<div class="control-group">
<label class="control-label" for="group"><?php echo __('Export User Name Column');?></label>
<div class="controls">
<select name="tb_name" style="width:100%" >
<?php foreach($tb as $key => $val){ ?>
<option value="<?php echo $val?>"><?php echo $val?></option>
<?php } ?>
</select>
</div>
</div>
<div class="control-group">
<label class="control-label" for="group"><?php echo __('Export Email Column');?></label>
<div class="controls">
<select name="tb_email" style="width:100%" >
<?php foreach($tb as $key => $val){ ?>
<option value="<?php echo $val?>"><?php echo $val?></option>
<?php } ?>
</select>
</div>
</div>
<?php }?>
</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>';
if(is_array($user)){
foreach($user as $value){
$i++;
if($i<10){
echo "<li>".$value['display_name']." - ".$value['user_email'];
}else{
break;
}
}
}
echo "</pre>";
}?>
</div>
</div>