Quote :
$newpassword = md5($member->password->GetValue());
$user_id = CCDLookup("max(user_id)","phpbb_users",'',$DBConnection1) + 1;
$suffix = ",'', '', '', '', '', '', '', '', 0, 0, '', '', '', 1, 1, 0, 1, 1, 0, 1, 1, 0, 'D M d, Y g:i a', 'english', 1, 0, 1, 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 (";
$sql = $sql."$user_id, '$nickname', ".time(). ", '$newpassword', '$email'".$suffix;
$user_id = CCDLookup("max(user_id)","phpbb_users",'',$DBConnection1);
$DBConnection1->query($sql);
$sql2 = "INSERT INTO phpbb_groups (group_name, group_description, group_single_user, group_moderator) VALUES ('', 'Personal User', 1, 0)";
$group_id = CCDLookup("max(group_id)","phpbb_groups",'',$DBConnection1);
$DBConnection1->query($sql2);
$sql3 = "INSERT INTO phpbb_user_group (user_id, group_id, user_pending) VALUES ($user_id, $group_id, 0)";
$DBConnection1->query($sql3);