Creating a userfield on register form

Hi all,

I want to create a required field on a registry form. I am using php nuke evolution and want the field "Game GUID" as a requirement. Where i am having the problems is i dont know where to put it in mysql and how to read it from the database.

I think there needs to be three files included in registering.

//new_user1.php

if (!defined('MODULE_FILE')) {
die ("You can't access this file directly...");
}

if (!defined('CNBYA')) {
die('CNBYA protection');
}

if(!isset($_SESSION)) { session_start(); }

unset($_SESSION['YA1']);
unset($_SESSION['YA2']);

$_SESSION['YA1'] = true;

include_once(NUKE_BASE_DIR.'header.php');
title(_USERAPPLOGIN);
OpenTable();
echo "\n";
echo "\n";
echo ""._REGNEWUSER."\n";
echo ""._NICKNAME.":"._REQUIRED."
("._YA_NICKLENGTH.")\n";
// menelaos: by request: added realname to the registration form
echo ""._UREALNAME.":"._REQUIRED."
"._YA_REALNAMENOTE."\n";

//GameGUID added By Geordie
echo ""._GAMEGUID.":"._REQUIRED."
"._YA_GAMEGUID."\n";

echo ""._EMAIL.":"._REQUIRED." \n";

// menelaos: added configurable doublecheck email routine
if ($ya_config['doublecheckemail']==1) {
echo ""._RETYPEEMAIL.":\n";
} else {
echo "\n";
}

$result = $db->sql_query("SELECT * FROM ".$user_prefix."_cnbya_field WHERE (need = '2') OR (need = '3') ORDER BY pos");
while ($sqlvalue = $db->sql_fetchrow($result)) {
$t = $sqlvalue[fid];
$value2 = explode("::", $sqlvalue[value]);
if (substr($sqlvalue[name],0,1)=='_') eval( "\$name_exit = $sqlvalue[name];"); else $name_exit = $sqlvalue[name];
if (count($value2) == 1) {
echo "$name_exit";
echo "\n";
} else {
echo "$name_exit";
echo "\n";
for ($i = 0; $i".trim($value2[$i])."\n";
}
echo "";
}
if (($sqlvalue[need]) > 1) echo" "._REQUIRED."";
echo "\n";
}
echo ""._PASSWORD.":";
/*****[BEGIN]******************************************
[ Mod: Password Strength Meter v1.0.0 ]
******************************************************/
echo "

"._PSM_NOTRATED."

";
echo _PSM_CLICK." "._PSM_HERE." "._PSM_HELP."
";
/*****[END]********************************************
[ Mod: Password Strength Meter v1.0.0 ]
******************************************************/
echo "
("._BLANKFORAUTO.")
("._YA_PASSLENGTH.")\n";
echo ""._RETYPEPASSWORD.":
("._BLANKFORAUTO.")
("._YA_PASSLENGTH.")\n";
$gfxchk = array(3,4,6);
$gfx = security_code($gfxchk, 'stacked');
if(!empty($gfx)) {
echo "".$gfx."";
}
echo "\n";
echo "\n";
echo "\n";
echo "
\n";
echo _WAITAPPROVAL."

\n";
echo _COOKIEWARNING."
\n";
echo _ASREGUSER."
\n";
echo "\n";
echo ""._ASREG1."\n";
echo ""._ASREG2."\n";
echo ""._ASREG3."\n";
echo ""._ASREG4."\n";
echo ""._ASREG5."\n";
$handle=opendir('themes');
while ($file = readdir($handle)) {
if ((!ereg("[.]",$file) AND file_exists("themes/$file/theme.php"))) { $thmcount++; }
}
closedir($handle);
if ($thmcount > 1) { echo ""._ASREG6."\n"; }
$sql = "SELECT custom_title FROM ".$prefix."_modules WHERE active='1' AND view='1' AND inmenu='1'";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$custom_title = $row[custom_title];
if (!empty($custom_title)) { echo ""._ACCESSTO." $custom_title\n"; }
}
$sql = "SELECT title FROM ".$prefix."_blocks WHERE active='1' AND view='1'";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$b_title = $row[title];
if (!empty($b_title)) { echo ""._ACCESSTO." $b_title\n"; }
}
if (is_active("Journal")) { echo ""._CREATEJOURNAL."\n"; }
if ($my_headlines == 1) { echo ""._READHEADLINES."\n"; }
echo ""._ASREG7."\n";
echo "\n";
echo _REGISTERNOW."
\n";
echo _WEDONTGIVE."

\n";
CloseTable();
include_once(NUKE_BASE_DIR.'footer.php');

//new_user2.php

if (!defined('MODULE_FILE')) {
die ("You can't access this file directly...");
}

if (!defined('CNBYA')) {
die('CNBYA protection');
}

include_once(NUKE_BASE_DIR.'header.php');
title(_USERREGLOGIN);
OpenTable();
echo "\n";
echo "\n";
echo ""._REGNEWUSER."\n";
echo ""._NICKNAME.": "._REQUIRED."
("._YA_NICKLENGTH.")\n";
// menelaos: by request: added realname to the registration form
echo ""._UREALNAME.":"._REQUIRED."\n";

echo ""._EMAIL.": "._REQUIRED."\n";

// menelaos: added configurable doublecheck email routine
if ($ya_config['doublecheckemail']==1) {
echo ""._RETYPEEMAIL.":\n";
} else {
echo "\n";
}

$gfxchk = array(3,4,6);
$gfx = security_code($gfxchk, 'stacked');
if(!empty($gfx)) {
echo "".$gfx."";
}
echo "\n";
echo "\n";
echo "\n";
echo "
\n";
echo _YOUWILLRECEIVE."

\n";
echo _COOKIEWARNING."
\n";
echo _ASREGUSER."
\n";
echo "\n";
echo ""._ASREG1."\n";
echo ""._ASREG2."\n";
echo ""._ASREG3."\n";
echo ""._ASREG4."\n";
echo ""._ASREG5."\n";
$handle=opendir('themes');
while ($file = readdir($handle)) {
if ((!ereg("[.]",$file) AND file_exists("themes/$file/theme.php"))) { $thmcount++; }
}
closedir($handle);
if ($thmcount > 1) { echo ""._ASREG6."\n"; }
$sql = "SELECT custom_title FROM ".$prefix."_modules WHERE active='1' AND view='1' AND inmenu='1'";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$custom_title = $row[custom_title];
if (!empty($custom_title)) { echo ""._ACCESSTO." $custom_title\n"; }
}
$sql = "SELECT title FROM ".$prefix."_blocks WHERE active='1' AND view='1'";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$b_title = $row[title];
if (!empty($b_title)) { echo ""._ACCESSTO." $b_title\n"; }
}
if (is_active("Journal")) { echo ""._CREATEJOURNAL."\n"; }
if ($my_headlines == 1) { echo ""._READHEADLINES."\n"; }
echo ""._ASREG7."\n";
echo "\n";
echo _REGISTERNOW."
\n";
echo _WEDONTGIVE."

\n";
echo "[ "._USERLOGIN." | "._PASSWORDLOST." ]\n";
CloseTable();
include_once(NUKE_BASE_DIR.'footer.php');

//new_user3.php

if (!defined('MODULE_FILE')) {
die ("You can't access this file directly...");
}

if (!defined('CNBYA')) {
die('CNBYA protection');
}

if(!isset($_SESSION)) { session_start(); }

unset($_SESSION['YA1']);
unset($_SESSION['YA2']);

$_SESSION['YA1'] = true;

function tz_select($default, $select_name = 'timezone')
{
$lang['tz']['-12'] = 'GMT - 12 Hours';
$lang['tz']['-11'] = 'GMT - 11 Hours';
$lang['tz']['-10'] = 'GMT - 10 Hours';
$lang['tz']['-9'] = 'GMT - 9 Hours';
$lang['tz']['-8'] = 'GMT - 8 Hours';
$lang['tz']['-7'] = 'GMT - 7 Hours';
$lang['tz']['-6'] = 'GMT - 6 Hours';
$lang['tz']['-5'] = 'GMT - 5 Hours';
$lang['tz']['-4'] = 'GMT - 4 Hours';
$lang['tz']['-3.5'] = 'GMT - 3.5 Hours';
$lang['tz']['-3'] = 'GMT - 3 Hours';
$lang['tz']['-2'] = 'GMT - 2 Hours';
$lang['tz']['-1'] = 'GMT - 1 Hours';
$lang['tz']['0'] = 'GMT';
$lang['tz']['1'] = 'GMT + 1 Hour';
$lang['tz']['2'] = 'GMT + 2 Hours';
$lang['tz']['3'] = 'GMT + 3 Hours';
$lang['tz']['3.5'] = 'GMT + 3.5 Hours';
$lang['tz']['4'] = 'GMT + 4 Hours';
$lang['tz']['4.5'] = 'GMT + 4.5 Hours';
$lang['tz']['5'] = 'GMT + 5 Hours';
$lang['tz']['5.5'] = 'GMT + 5.5 Hours';
$lang['tz']['6'] = 'GMT + 6 Hours';
$lang['tz']['6.5'] = 'GMT + 6.5 Hours';
$lang['tz']['7'] = 'GMT + 7 Hours';
$lang['tz']['8'] = 'GMT + 8 Hours';
$lang['tz']['9'] = 'GMT + 9 Hours';
$lang['tz']['9.5'] = 'GMT + 9.5 Hours';
$lang['tz']['10'] = 'GMT + 10 Hours';
$lang['tz']['11'] = 'GMT + 11 Hours';
$lang['tz']['12'] = 'GMT + 12 Hours';
$lang['tz']['13'] = 'GMT + 13 Hours';

if ( !isset($default) )
{
$default == $sys_timezone;
}
$tz_select = '';

while( list($offset, $zone) = @each($lang['tz']) )
{
$selected = ( $offset == $default ) ? ' selected="selected"' : '';
$tz_select .= '' . str_replace('GMT', 'UTC', $zone) . '';
}
$tz_select .= '';

return $tz_select;
}

/*****[BEGIN]******************************************
[ Mod: XData v0.1.1 ]
******************************************************/
define_once('XDATA', true);
include_once(NUKE_MODULES_DIR.'Your_Account/public/custom_functions.php');
/*****[END]********************************************
[ Mod: XData v0.1.1 ]
******************************************************/
include_once(NUKE_BASE_DIR.'header.php');
title(_USERREGLOGIN);
OpenTable();
echo "\n";
echo "\n";
echo ""._REGNEWUSER."\n";
echo ""._NICKNAME.":"._REQUIRED." "._REQUIRED."
("._YA_NICKLENGTH.")\n";
echo ""._UREALNAME.":"._REQUIRED."\n";
echo ""._EMAIL.":"._REQUIRED." "._REQUIRED."\n";

// menelaos: added configurable doublecheck email routine
if ($ya_config['doublecheckemail']==1) {
echo ""._RETYPEEMAIL.":\n";
} else {
echo "\n";
}

echo ""._PASSWORD.":";
/*****[BEGIN]******************************************
[ Mod: Password Strength Meter v1.0.0 ]
******************************************************/
echo "

"._PSM_NOTRATED."

";
echo _PSM_CLICK." "._PSM_HERE." "._PSM_HELP."
";
/*****[END]********************************************
[ Mod: Password Strength Meter v1.0.0 ]
******************************************************/
echo "("._BLANKFORAUTO.")
("._YA_PASSLENGTH.")\n";
echo ""._RETYPEPASSWORD.":
("._BLANKFORAUTO.")
("._YA_PASSLENGTH.")\n";
echo ""._UFAKEMAIL.":"._OPTIONAL."
"._EMAILPUBLIC."\n";
/*****[BEGIN]******************************************
[ Mod: XData v0.1.1 ]
******************************************************/
$xd_meta = get_xd_metadata();
while ( list($code_name, $info) = each($xd_meta) )
{
if ($info['display_register'] == XD_DISPLAY_NORMAL && $info['signup'])
{
$value = isset($xdata[$code_name]) ? str_replace('"', '"', $xdata[$code_name]) : '';
$length = ( $info['field_length'] > 0) ? ( $info['field_length'] ) : '';

switch ($info['field_type'])
{
case 'text':
$value = isset($xdata[$code_name]) ? str_replace('"', '"', $xdata[$code_name]) : '';
$length = ( $info['field_length'] > 0) ? ( $info['field_length'] ) : '';
echo ''.$info['field_name'].':'.$info['field_desc'].'
';
break;

case 'textarea':
echo ''.$info['field_name'].':'.$info['field_desc'].'
'.$value.'';
break;

case 'radio':
echo ''.$info['field_name'].':'.$info['field_desc'].'';
while ( list( , $option) = each($info['values_array']) )
{
$select = ($xdata[$code_name] == $option) ? 'selected="selected"' : '';
echo ''.$option.'
';
}
echo '';
break;

case 'select':
echo ''.$info['field_name'].':'.$info['field_desc'].'';
echo '';
while ( list( , $option) = each($info['values_array']) )
{
$select = ($xdata[$code_name] == $option) ? 'selected="selected"' : '';
echo ''.$option.'';
}
echo '';
break;
}
}
elseif ($info['display_register'] == XD_DISPLAY_ROOT)
{
switch ($code_name) {
case "icq":
echo ""._YICQ.":"._OPTIONAL."\n";
break;
case "aim":
echo ""._YAIM.":"._OPTIONAL."\n";
break;
case "msn":
echo ""._YMSNM.":"._OPTIONAL."\n";
break;
case "yim":
echo ""._YYIM.":"._OPTIONAL."\n";
break;
case "website":
echo ""._YOURHOMEPAGE.":"._OPTIONAL."\n";
break;
case "location":
echo ""._YLOCATION.":"._OPTIONAL."\n";
break;
case "occupation":
echo ""._YOCCUPATION.":"._OPTIONAL."\n";
break;
case "interests":
echo ""._YINTERESTS.":"._OPTIONAL."\n";
break;
case "signature":
echo ""._SIGNATURE.":"._OPTIONAL."
"._NOHTML."
"._255CHARMAX."\n";
break;
}
}
}
/*****[END]********************************************
[ Mod: XData v0.1.1 ]
******************************************************/
echo ""._RECEIVENEWSLETTER.":"._YES.""._NO."\n";
echo ""._ALWAYSSHOWEMAIL.":"._YES.""._NO."\n";
echo ""._HIDEONLINE.":"._YES.""._NO."\n";
echo ""._FORUMSTIME.":";
global $board_config;
echo tz_select($board_config['board_timezone'], 'timezone');
echo "\n";
echo ""._FORUMSDATE.":"._FORUMSDATEMSG."\n";
echo ""._EXTRAINFO.":"._OPTIONAL."
"._NOHTML."
"._CANKNOWABOUT."\n";

$gfxchk = array(3,4,6);
$gfx = security_code($gfxchk, 'stacked');
if(!empty($gfx)) {
echo "".$gfx."";
}

echo "\n";
echo "\n";
echo "\n";
echo "
\n";
echo ""._COOKIEWARNING."
\n";
echo ""._ASREGUSER."
\n";
echo "\n";
echo ""._ASREG1."\n";
echo ""._ASREG2."\n";
echo ""._ASREG3."\n";
echo ""._ASREG4."\n";
echo ""._ASREG5."\n";
$handle=opendir('themes');
while ($file = readdir($handle)) {
if ((!ereg("[.]",$file) AND file_exists("themes/$file/theme.php"))) { $thmcount++; }
}
closedir($handle);
if ($thmcount > 1) { echo ""._ASREG6."\n"; }
$sql = "SELECT custom_title FROM ".$prefix."_modules WHERE active='1' AND view='1' AND inmenu='1'";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$custom_title = $row[custom_title];
if (!empty($custom_title)) { echo ""._ACCESSTO." $custom_title\n"; }
}
$sql = "SELECT title FROM ".$prefix."_blocks WHERE active='1' AND view='1'";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$b_title = $row[title];
if (!empty($b_title)) { echo ""._ACCESSTO." $b_title\n"; }
}
if (is_active("Journal")) { echo ""._CREATEJOURNAL."\n"; }
if ($my_headlines == 1) { echo ""._READHEADLINES."\n"; }
echo ""._ASREG7."\n";
echo "\n";
echo _REGISTERNOW."
\n";
echo _WEDONTGIVE."

\n";
CloseTable();
include_once(NUKE_BASE_DIR.'footer.php');

You can see the registery for http://www.thelastcause.com/CallOfDuty4/modules.php?name=Your_Account&op=new_user

Hope i have explained well, and that someone could be so kind as to help me out.

Thanks You,
Greetz
Geordie ;)

Geordie_Ben

Newbie Poster

5 posts since Sep 2010

Reputation Points: 10

Solved Threads: 0

1 Year Ago

I guess thus is the file that reads from the database?

//saveuser.php

if (!defined('MODULE_FILE')) {
die ("You can't access this file directly...");
}

if (!defined('CNBYA')) {
die('CNBYA protection');
}

$stop = "";
global $cookie;
$check = $cookie[1];
$check2 = $cookie[2];
$result = $db->sql_query("SELECT user_id, user_password, user_email FROM ".$user_prefix."_users WHERE username='$check'");
$row = $db->sql_fetchrow($result);
$vuid = $row['user_id'];
$ccpass = $row['user_password'];
$tuemail = strtolower($row['user_email']);
$user_sig = str_replace("
", "\r\n", $user_sig);
$user_sig = ya_fixtext($user_sig);
$user_email = strtolower($user_email);
$user_email = ya_fixtext($user_email);
$femail = ya_fixtext($femail);
$user_website = ya_fixtext($user_website);
$bio = ya_fixtext($bio);
$user_icq = ya_fixtext($user_icq);
$user_aim = ya_fixtext($user_aim);
$user_yim = ya_fixtext($user_yim);
$user_msnm = ya_fixtext($user_msnm);
$user_occ = ya_fixtext($user_occ);
$user_from = ya_fixtext($user_from);
$user_interests = ya_fixtext($user_interests);
$realname = ya_fixtext($realname);
$user_dateformat = ya_fixtext($user_dateformat);
$newsletter = intval($newsletter);
$user_viewemail = intval($user_viewemail);
$user_allow_viewonline = intval($user_allow_viewonline);
$user_timezone = intval($user_timezone);
if ($ya_config['allowmailchange'] < 1) {
if ($tuemail != $user_email) { ya_mailCheck($user_email); }
}
if ($user_password > "" OR $vpass > "") { ya_passCheck($user_password, $vpass); }

$result = $db->sql_query("SELECT * FROM ".$user_prefix."_cnbya_field WHERE need = '3' ORDER BY pos");
while ($sqlvalue = $db->sql_fetchrow($result)) {
$t = $sqlvalue[fid];
if (empty($nfield[$t])) {
include_once(NUKE_BASE_DIR.'header.php');
opentable();
if (substr($sqlvalue[name],0,1)=='_') eval( "\$name_exit = $sqlvalue[name];"); else $name_exit = $sqlvalue[name];
echo ""._ERRORREG."

";
echo ""._YA_FILEDNEED1."$name_exit"._YA_FILEDNEED2."

"._GOBACK."";
closetable();
include_once(NUKE_BASE_DIR.'footer.php');
exit;
};
}

if (empty($stop) AND ($user_id == $vuid) AND ($check2 == $ccpass)) {
if (!eregi("http://", $user_website) AND !empty($user_website)) {
$user_website = "http://$user_website";
}
if ($bio) { filter_text($bio); $bio = $EditedMessage; $bio = Fix_Quotes($bio); }
if (!empty($user_password)) {
global $cookie;
$db->sql_query("LOCK TABLES ".$user_prefix."_users, ".$user_prefix."_cnbya_value WRITE");
/*****[BEGIN]******************************************
[ Base: Evolution Functions v1.5.0 ]
******************************************************/
$user_password = md5($user_password);
/*****[END]********************************************
[ Base: Evolution Functions v1.5.0 ]
******************************************************/

if ( ($ya_config['emailvalidate'] == '0') OR ($tuemail == $user_email) ) {
$db->sql_query("UPDATE ".$user_prefix."_users SET name='$realname', user_email='$user_email', femail='$femail', user_website='$user_website', user_password='$user_password', bio='$bio', user_icq='$user_icq', user_occ='$user_occ', user_from='$user_from', user_interests='$user_interests', user_sig='$user_sig', user_aim='$user_aim', user_yim='$user_yim', user_msnm='$user_msnm', newsletter='$newsletter', user_viewemail='$user_viewemail', user_allow_viewonline='$user_allow_viewonline', user_notify='$user_notify', user_notify_pm='$user_notify_pm', user_popup_pm='$user_popup_pm', user_attachsig='$user_attachsig', user_allowbbcode='$user_allowbbcode', user_allowhtml='$user_allowhtml', user_allowsmile='$user_allowsmile', user_timezone='$user_timezone', user_dateformat='$user_dateformat' WHERE user_id='$user_id'");
} else {
$db->sql_query("UPDATE ".$user_prefix."_users SET name='$realname', femail='$femail', user_website='$user_website', user_password='$user_password', bio='$bio', user_icq='$user_icq', user_occ='$user_occ', user_from='$user_from', user_interests='$user_interests', user_sig='$user_sig', user_aim='$user_aim', user_yim='$user_yim', user_msnm='$user_msnm', newsletter='$newsletter', user_viewemail='$user_viewemail', user_allow_viewonline='$user_allow_viewonline', user_notify='$user_notify', user_notify_pm='$user_notify_pm', user_popup_pm='$user_popup_pm', user_attachsig='$user_attachsig', user_allowbbcode='$user_allowbbcode', user_allowhtml='$user_allowhtml', user_allowsmile='$user_allowsmile', user_timezone='$user_timezone', user_dateformat='$user_dateformat' WHERE user_id='$user_id'");
$datekey = date("F Y");
$check_num = substr(md5(hexdec($datekey) * hexdec($cookie[2]) * hexdec($sitekey) * hexdec($user_email) * hexdec($tuemail)), 2, 10);
$finishlink = "$nukeurl/modules.php?name=$module_name&op=changemail&id=$user_id&mail=$user_email&check_num=$check_num";
$message .= _CHANGEMAIL1." $tuemail "._CHANGEMAIL2." $user_email"._CHANGEMAIL3." $sitename.

";
$message .= _CHANGEMAILFIN."

$finishlink

";
$subject = _CHANGEMAILSUB;
ya_mail($user_email, $subject, $message, '');
}

if (count($nfield) > 0) {
foreach ($nfield as $key => $var) {
if (($db->sql_numrows($db->sql_query("SELECT * FROM ".$user_prefix."_cnbya_value WHERE fid='$key' AND uid = '$user_id'"))) == 0) {
$sql = "INSERT INTO ".$user_prefix."_cnbya_value (uid, fid, value) VALUES ('$user_id', '$key','$nfield[$key]')";
$db->sql_query($sql);
}
else {
$db->sql_query("UPDATE ".$user_prefix."_cnbya_value SET value='$nfield[$key]' WHERE fid='$key' AND uid = '$user_id'");
}
}
}

$sql = "SELECT * FROM ".$user_prefix."_users WHERE username='$username' AND user_password='$user_password'";
$result = $db->sql_query($sql);
if ($db->sql_numrows($result) == 1) {
$userinfo = $db->sql_fetchrow($result);
yacookie($userinfo[user_id],$userinfo[username],$userinfo[user_password],$userinfo[storynum],$userinfo[umode],$userinfo[uorder],$userinfo[thold],$userinfo[noscore],$userinfo[ublockon],$userinfo[theme],$userinfo[commentmax]);
} else {
echo ""._SOMETHINGWRONG."
";
}
$db->sql_query("UNLOCK TABLES");
} else {
$db->sql_query("LOCK TABLES ".$user_prefix."_users,".$user_prefix."_cnbya_value WRITE");

if ( ($ya_config['emailvalidate'] == '0') OR ($tuemail == $user_email) ) {
$q = "UPDATE ".$user_prefix."_users SET name='$realname', user_email='$user_email', femail='$femail', user_website='$user_website', bio='$bio', user_icq='$user_icq', user_occ='$user_occ', user_from='$user_from', user_interests='$user_interests', user_sig='$user_sig', user_aim='$user_aim', user_yim='$user_yim', user_msnm='$user_msnm', newsletter='$newsletter', user_viewemail='$user_viewemail', user_allow_viewonline='$user_allow_viewonline', user_notify='$user_notify', user_notify_pm='$user_notify_pm', user_popup_pm='$user_popup_pm', user_attachsig='$user_attachsig', user_allowbbcode='$user_allowbbcode', user_allowhtml='$user_allowhtml', user_allowsmile='$user_allowsmile', user_timezone='$user_timezone', user_dateformat='$user_dateformat' WHERE user_id='$user_id'";
$db->sql_query($q);
} else {

$db->sql_query("UPDATE ".$user_prefix."_users SET name='$realname', femail='$femail', user_website='$user_website', bio='$bio', user_icq='$user_icq', user_occ='$user_occ', user_from='$user_from', user_interests='$user_interests', user_sig='$user_sig', user_aim='$user_aim', user_yim='$user_yim', user_msnm='$user_msnm', newsletter='$newsletter', user_viewemail='$user_viewemail', user_allow_viewonline='$user_allow_viewonline', user_notify='$user_notify', user_notify_pm='$user_notify_pm', user_popup_pm='$user_popup_pm', user_attachsig='$user_attachsig', user_allowbbcode='$user_allowbbcode', user_allowhtml='$user_allowhtml', user_allowsmile='$user_allowsmile', user_timezone='$user_timezone', user_dateformat='$user_dateformat' WHERE user_id='$user_id'");
$datekey = date("F Y");
$check_num = substr(md5(hexdec($datekey) * hexdec($cookie[2]) * hexdec($sitekey) * hexdec($user_email) * hexdec($tuemail)), 2, 10);

$finishlink = "$nukeurl/modules.php?name=$module_name&op=changemail&id=$user_id&mail=$user_email&check_num=$check_num";
$message .= _CHANGEMAIL1." $tuemail "._CHANGEMAIL2." $user_email"._CHANGEMAIL3." $sitename.

";
$message .= _CHANGEMAILFIN."

$finishlink

";
$subject = _CHANGEMAILSUB;
ya_mail($user_email, $subject, $message, '');
}

$db->sql_query("UNLOCK TABLES");
}
redirect("modules.php?name=$module_name");
} else {
include_once(NUKE_BASE_DIR.'header.php');
OpenTable();
echo ""._ERRORREG."

";
echo "$stop

"._GOBACK."";
CloseTable();
include_once(NUKE_BASE_DIR.'footer.php');
}

Geordie_Ben

Newbie Poster

5 posts since Sep 2010

Reputation Points: 10

Solved Threads: 0

This article has been dead for over three months

You