Hello, thank you for the link, but unfortunately we decided against using that mod early on, and we are way to far along with customization to ever turn back he he. I will paste the code I wrote and maybe you guys can spot an error in it.
This code is on the postNuke registration page:
// ORIGINAL POSTNUKE REGISTRATION CODE
$result = $dbconn->Execute("INSERT INTO $pntable[users] ($column[name], $column[uname], $column[email],
$column[femail], $column[url], $column[user_avatar], $column[user_regdate], $column[user_icq],
$column[user_occ], $column[user_from], $column[user_intrest], $column[user_sig],
$column[user_viewemail], $column[user_theme], $column[user_aim], $column[user_yim],
$column[user_msnm], $column[pass], $column[storynum], $column[umode], $column[uorder],
$column[thold], $column[noscore], $column[bio], $column[ublockon], $column[ublock],
$column[theme], $column[commentmax], $column[counter], $column[timezone_offset])
VALUES ('" . pnVarPrepForStore($name) . "','" . pnVarPrepForStore($uname) . "',
'" . pnVarPrepForStore($email) . "','" . pnVarPrepForStore($femail) . "',
'" . pnVarPrepForStore($url) . "','" . pnVarPrepForStore($user_avatar) . "',
'" . pnVarPrepForStore($user_regdate) . "','" . pnVarPrepForStore($user_icq) . "',
'" . pnVarPrepForStore($user_occ) . "','" . pnVarPrepForStore($user_from) . "',
'" . pnVarPrepForStore($user_intrest) . "','" . pnVarPrepForStore($user_sig) . "',
'" . pnVarPrepForStore($user_viewemail) . "','',
'" . pnVarPrepForStore($user_aim) . "','" . pnVarPrepForStore($user_yim) . "',
'" . pnVarPrepForStore($user_msnm) . "','" . pnVarPrepForStore($cryptpass) . "',
'" . pnVarPrepForStore($storynum) . "','',0,0,0,'" . pnVarPrepForStore($bio) . "',0,'','',
'" . pnVarPrepForStore($commentlimit) . "', '0', '" . pnVarPrepForStore($timezoneoffset) . "')");
// END ORIGINAL POSTNUKE REGISTRATION CODE
$cgcentralusername='username';
$cgcentralpassword='password';
$cgcentralhostname='localhost';
$cgcentraldatabasename='dbname';
$cgcentralconection = @mysql_connect($cgcentralhostname, $cgcentralusername, $cgcentralpassword);
mysql_select_db($cgcentraldatabasename);
$sql = "SELECT MAX(user_id) AS total FROM phpbb_users";
if ( !($result = mysql_query($sql)) )
{
message_die('Could not obtain next user_id information');
}
if ( !($row = mysql_fetch_row($result)) )
{
message_die('Could not obtain next user_id information');
}
$user_id = $row['total'] + 1;
$sql = "INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_sig_bbcode_uid, user_avatar, user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_active, user_actkey) VALUES (".$user_id.",'".$uname."','".$user_regdate."','".$cryptpass."','".$email."','".$user_icq."','".$url."','".$user_occ."','".$user_from."','".$user_intrest."','".$user_sig."','','',0,".$user_viewemail.",'".$user_aim."','".$user_yim."','".$user_msnm."',1,1,0,1,1,0,1,1,'0.00','D M d, Y g:i a','english',4,0,1,1,'')";
mysql_query($sql);
