<? include('dbconnect.php');
if(!empty($_POST['username']) && !empty($_POST['pass']) && !empty($_POST['email']) && !empty($_POST['randimage_txt'])) {
$error = 0;
$check = mysql_query("select username from phpbb_users where username='$_POST[username]'") or die(mysql_error());
if(mysql_num_rows($check) > 0) {
echo "Съществува такъв потребител!";
$error = 1;
}
if(!eregi("^[[:alnum:]][a-z0-9_.-]*@[a-z0-9.-]+\.[a-z]{2,4}$", $_POST['email'])) {
echo "Невалиден е-майл адрес!";
$error = 1;
}
if(md5($_POST['randimage_txt']) != $_SESSION['image_random_value']) {
echo "Кода не съвпада!";
$error = 1;
}
if($error == 0) {
$username = trim(strip_tags($_POST['username']));
$password = md5(trim(strip_tags($_POST['pass'])));
$email = trim(strip_tags($_POST['email']));
$date = time();
$sql = "SELECT MAX(user_id)
FROM phpbb_users";
$result = mysql_query($sql) or die('Error, query failed');
$row = mysql_fetch_row($result);
$user_id = $row['0'] + 1;
$insert = mysql_query(" INSERT INTO phpbb_users (user_id,username, user_password,user_regdate,user_level,user_timezone,user_style,user_lang,user_viewemail,user_attachsig,user_allowhtml,user_notify,user_notify_pm,user_popup_pm,user_avatar,user_email,user_icq,user_website,user_from,user_sig,user_sig_bbcode_uid,user_aim,user_yim,user_msnm,user_occ,user_interests,user_actkey)
VALUES ('$user_id','$username', '$password','$date','0','2.00','2','bulgarian','0','1','0','0','1','1','','$email','','','','','','','','','','','')") or die(mysql_error());
if($insert) {
echo "Регистрирахте се успешно!";
echo '<meta http-equiv="refresh" content="2;url=index.php">';
}
}
}
?>