pparse("body");
include('includes/page_tail.'.$phpEx);
}
else
{
if(isset($submit))
{
$error = FALSE;
if(empty($username) || empty($password) || empty($password_confirm) || empty($email))
{
$error = TRUE;
$error_msg = $l_notfilledin;
}
if(isset($username) && (!validate_username($username, $db)))
{
$error = TRUE;
if(isset($error_msg))
{
$error_msg .= "
";
}
$error_msg .= $l_invalidname;
}
if(isset($password) && ($password != $password_confirm))
{
$error = TRUE;
if(isset($error_msg))
{
$error_msg .= "
";
}
$error_msg .= $l_mismatch;
}
}
if(isset($submit) && !$error)
{
$md_pass = md5($password);
$sql = "INSERT INTO ".USERS_TABLE." (
username,
user_regdate,
user_password,
user_email,
user_icq,
user_website,
user_occ,
user_from,
user_intrest,
user_sig,
user_viewemail,
user_theme,
user_aim,
user_yim,
user_msnm,
user_attachsig,
user_desmile,
user_html,
user_bbcode,
user_timezone,
user_lang,
user_active,
user_actkey)
VALUES (
'".addslashes($username)."',
'".time()."',
'$md_pass',
'$email',
'$icq',
'".addslashes($website)."',
'".addslashes($occ)."',
'".addslashes($from)."',
'".addslashes($intrest)."',
'".addslashes($sig)."',
'$viewemail',
'$theme',
'".addslashes($aim)."',
'".addslashes($yim)."',
'".addslashes($msn)."',
'$alwayssig',
'$alwayssmile',
'$alwayshtml',
'$alwaysbbcode',
'$timezone',
'$lang',
";
if($require_activation || $coppa)
{
$act_key = generate_activation_key();
$sql .= "0, '$act_key')";
}
else
{
$sql .= "1, '')";
}
if($result = $db->sql_query($sql))
{
if($require_activation)
{
$msg = $l_accountinactive;
$email_msg = $l_welcomeemailactivate;
}
else if($coppa)
{
$msg = $l_coppa;
}
else
{
$msg = $l_accountadded;
$email_msg = $l_welcomeemail;
}
mail($email, $l_welcomesubj, $email_msg, "From: $email_from\r\n");
error_die($db, GENERAL_ERROR, $msg);
}
}
if($error)
{
$template->set_filenames(array("reg_header" => "error_body.tpl"));
$template->assign_vars(array("ERROR_MESSAGE" => $error_msg));
$template->pparse("reg_header");
}
if(!isset($coppa))
{
$coppa = FALSE;
}
$template->assign_vars(array("COPPA" => $coppa,
"L_SUBMIT" => $l_submit,
"USERNAME" => $username,
"EMAIL" => $email,
"YIM" => $yim,
"ICQ" => $icq,
"MSN" => $msn,
"AIM" => $aim,
"OCC" => $occ,
"INTERESTS" => $interests,
"FROM" => $from,
"WEBSITE" => $website,
"SIG" => $sig,
"VIEWEMAIL_YES" => ($viewemail) ? "CHECKED" : "",
"VIEWEMAIL_NO" => (!$viewemail) ? "CHECKED" : "",
"STOREUSERNAME_YES" => (!isset($storeusername) || $storeusername == 1) ? "CHECKED" : "",
"STOREUSERNAME_NO" => (isset($storeusername) && $storeusername == 0) ? "CHECKED" : "",
"ALWAYSSIG_YES" => ($alwayssig) ? "CHECKED" : "",
"ALWAYSSIG_NO" => (!$alwayssig) ? "CHECKED" : "",
"ALWAYSBBCODE_YES" => ($alwaysbbcode) ? "CHECKED" : "",
"ALWAYSBBCODE_NO" => (!$alwaysbbcode) ? "CHECKED" : "",
"ALWAYSHTML_YES" => ($alwayshtml) ? "CHECKED" : "",
"ALWAYSHTML_NO" => (!$alwayshtml) ? "CHECKED" : "",
"ALWAYSSMILE_YES" => ($alwayssmile) ? "CHECKED" : "",
"ALWAYSSMILE_NO" => (!$alwayssmile) ? "CHECKED" : "",
"LANGUAGE_SELECT" => language_select($default_lang, "lang"),
"THEME_SELECT" => theme_select($theme, $db),
"TIMEZONE_SELECT" => tz_select($timezone),
"L_ICQNUMBER" => $l_icqnumber,
"L_STORECOOKIE" => $l_storecookie,
"L_MESSENGER" => $l_messenger,
"L_YAHOO" => $l_yahoo,
"L_WEBSITE" => $l_website,
"L_AIM" => $l_aim,
"L_FROM" => $l_from,
"L_OCC" => $l_occupation,
"L_ALWAYSSMILE" => $l_alwayssmile,
"L_BOARDLANG" => $l_boardlang,
"L_BOARDTHEME" => $l_boardtheme,
"L_TIMEZONE" => $l_timezone,
"L_YES" => $l_yes,
"L_NO" => $l_no,
"L_INTERESTS" => $l_interests,
"L_USERUNIQ" => $l_useruniq,
"L_ALWAYSBBCODE" => $l_alwaysbbcode,
"L_ALWAYSHTML" => $l_alwayshtml,
"L_ALWAYSSIG" => $l_alwayssig,
"L_SIGNATURE" => $l_signature,
"L_SIGEXPLAIN" => $l_sigexplain,
"L_PREFERENCES" => $l_preferences,
"L_PUBLICMAIL" => $l_publicmail,
"L_ITEMSREQ" => $l_itemsreq,
"MODE" => $mode,
"L_REGINFO" => $l_reginfo,
"L_PROFILEINFO" => $l_profileinfo,
"L_CONFIRM" => $l_confirm,
"L_EMAILADDRESS" => $l_emailaddress));
$template->pparse("body");
include('includes/page_tail.'.$phpEx);
}
break;
case 'activate':
$sql = "SELECT user_id FROM ".USERS_TABLE." WHERE user_actkey = '$act_key'";
if($result = $db->sql_query($sql))
{
if($num = $db->sql_numrows($result))
{
$rowset = $db->sql_fetchrowset($result);
$sql_update = "UPDATE ".USERS_TABLE." SET user_active = 1, user_actkey = '' WHERE user_id = ".$rowset[0]["user_id"];
if($result = $db->sql_query($sql_update))
{
error_die($db, GENERAL_ERROR, $l_nowactive);
}
else
{
error_die($db, QUERY_ERROR);
}
}
else
{
error_die($db, GENERAL_ERROR, $l_wrongactiv);
}
}
else
{
error_die($db, QUERY_ERROR);
}
break;
}
?>