عضویت در خبرنامه

{source}
<?php
if(!isset($_POST['check'])){
?>
<form method="post">
<div class="acymailing_module_form">
<table class="acymailing_form">
<tbody>
<tr>
<td class="acyfield_name acy_requiredField">
<input id="user_name" type="text" name="user_name" style="width:80%" value="نام" title="نام">
</td>
</tr>
<tr>
<td class="acyfield_email acy_requiredField">
<input id="user_email" type="text" name="user_email" style="width:80%" value="ایمیل" title="ایمیل">
</td>
</tr>
<tr>
<td class="acysubbuttons">
<input class="button subbutton btn btn-primary" type="submit" value="اشتراک در خبرنامه" name="Submit">
</td>
</tr>
</tbody>
</table>
<input type="hidden" name="check" value="0">
</div>
</form>
<?php
}
else{
$now = date("Y-m-d G:i:s");
$email = $_POST['user_email'];
$user_name = $_POST['user_name'];
define('DBHOST', 'localhost');
define('DBUSER', 'bcdm_bcdmusr');
define('DBPASS', 'UX{$QIZ~p)1e');
define('DBNAME', 'bcdm_new');
$connection = @mysql_connect(DBHOST, DBUSER, DBPASS) or die('error1');
mysql_select_db(DBNAME) or die('error2');
mysql_query("SET NAMES 'utf8'");
$link = mysql_connect(DBHOST, DBUSER, DBPASS);
mysql_select_db(DBNAME, $link);
$my_q="SELECT * FROM `x7q0y_users` WHERE `email` = '".$email."'";
$result = mysql_query($my_q, $link);
$number = mysql_num_rows($result);
if ($number == 0)
{
$sql= "INSERT INTO `bcdm_new`.`x7q0y_users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) VALUES (NULL, '$user_name', '$user_name', '$email', '6700659', '0', '0', '$now', '$now', '', '{}', '0000-00-00 00:00:00', '0', '', '', '0')";
$query=mysql_query($sql) or die("error");
if(!$query){
$msg = "در ثبت اطلاعات شما خطایی رخ داد";
}
else{
$msg = "اطلاعات شما با موفقیت ثبت گردید";
}
$sql = "SELECT * FROM `x7q0y_users` ORDER BY `id` DESC LIMIT 0 , 1";
$result = mysql_query($sql);
while ($row = mysql_fetch_assoc($result)) {
$id = $row["id"];
}
$sql = "INSERT INTO `bcdm_new`.`x7q0y_user_usergroup_map` (`user_id`, `group_id`) VALUES ('$id', '2')";
$query=mysql_query($sql) or die("error");
}
else{$msg = "ایمیل وارد شده قبلا در سامانه ثبت شده است";}
echo $msg;
}
?>
{/source}