This little code snippet is from a login system that
I've made, which takes unconfirmed user-info out of a
mysql table, and places it into a confirmed table
(Uses email confirmation). Now, this has really got
me baffled, because it seemed to be working fine
yesterday. Can anyone please tell me what's wrong
with the following code? Your help will be greatly
appreciated.
//confirm and register new user, get info from
unconfirmed_user and put it in user, then delete from
unconfirmed_user
function confirmNewUser ($confirm_new_user) {
include '../config.php';
global $DB_INCLUDE;
include $DB_INCLUDE;
$user_wait = "select * from unconfirmed_user
where username='$confirm_new_user'";
$user_result = mysql_db_query ($database,
$user_wait, $link);
while ($user_row =
mysql_fetch_array($user_result)) {
$insert_user = "insert into user values ('
','$user_row[name]','$user_row[email_address]','$user_row[password]','$user_row[access]','$user_row[username]','$user_row[description]','$user_row[homepage]','$user_row[online]','$user_row[image]')";
if (mysql_db_query ($database,
$insert_user, $link)) {
$Query2 = "delete from
unconfirmed_user where user_id='$row[user_id]'";
if (mysql_db_query ($database,
$Query2, $link)) {
include
$SERVER_ROOT.'admin/email.php';
mail($row[email_address], "Welcome to
".$SITE_NAME."",$mail_content,"From: News
Bomber@".$SITE_DOMAIN ,"Reply-To: Auto Mailer");
print "<center>Registration
Complete<br /><br />\n";
print "Welcome to ".$SITE_NAME.",
".$row[name].". <br />To make a news post, you must
first <h4><a href=\"index.php\">Login</a></h4><br
/><br />A welcome email has been sent to your email
address.<br /> Check this out for info of interest
about News Bomber.\n";
}else{
print "<center>Registration
Failed</center>\n";
}
}else{
print "<center>Registration
Failed</center>\n";
}
}
}
______________________________________________________________________
Post your free ad now! http://personals.yahoo.ca
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
