MySQL database creation.

[Artok]

OK, heres my prob.

Trying to integrate the account creation proceedure for Teamspeak into the Nuke-like website (Dragonfly) I have already established, so that when a new user creates an account, it also creates the appropriate information for the ts2_clients table.

Problem is, it just isn't working...and I know I'm probably way off towards why. Any suggestions, or has anyone done this to a nuke-based website before?

Account creation is handled by 'register.php' (if you've done this, you have your own flavor, I'm sure...I hesitate to post the whole code) but the area I see attention required is here...

function register_finish() {
	global $db, $user_cfg, $user_prefix, $sitename, $sec_code, $CPG_SESS, $userinfo, $MAIN_CFG;
	if ($sec_code & 4) {
		$gfxid = isset($_POST['gfxid']) ? $_POST['gfxid'] : 0;
		$code = $CPG_SESS['gfx'][$gfxid];
		$gfx_check	= isset($_POST['gfx_check']) ? $_POST['gfx_check'] : '';
		if (strlen($gfx_check) < 2 || $code != $gfx_check) { cpg_error(_SECCODEINCOR); }
	}

	$username = Fix_Quotes($_POST['username'],1);
	$user_email = strtolower(Fix_Quotes($_POST['email'],1));
	$password = Fix_Quotes($_POST['password'],1);
	$fieldlist = $valuelist = '';
	check_fields($fieldlist, $valuelist, $fields);
	userCheck($username, $user_email);

	mt_srand ((double)microtime()*1000000);
	$check_num = mt_rand(0, 1000000);
	$check_num = md5($check_num);
	$new_password = md5($password);
	$user_regdate = date('M d, Y');
	if ($user_cfg['useactivate'] || $user_cfg['requireadmin']) {
		$result = $db->sql_query("INSERT INTO ".$user_prefix."_users_temp (username, user_email, user_password, user_regdate, check_num, time".$fieldlist.") VALUES ('$username', '$user_email', '$new_password', '$user_regdate', '$check_num', '".gmtime()."'".$valuelist.")",false, __FILE__,__LINE__);
	} else {
		$result = $db->sql_query("INSERT INTO ".$user_prefix."_users (username, user_email, user_password, user_regdate, user_lastvisit, user_avatar, user_lang $fieldlist) VALUES ('$username', '$user_email', '$new_password', '$user_regdate', ".gmtime().", '".$MAIN_CFG['avatar']['default']."', '$language' ".$valuelist.")",false, __FILE__,__LINE__);

// HERE FOR TEAMSPEAK?


		if ($user_cfg['send_welcomepm']) { welcome_pm(); }
	}
	$uid = $db->sql_nextid('user_id');
	$finishlink = getlink("&file=register&activate=$uid&check_num=$check_num", true, true);

	$message = _WELCOMETO." $sitename!\n\n"._YOUUSEDEMAIL." ($user_email) ";
	if ($_POST['coppa']) {
//				$message = $lang['COPPA'];
//				$email_template = 'coppa_welcome_inactive';
		$message .= _TOAPPLY." $sitename.\n\n"._WAITAPPROVAL."\n\n"._FOLLOWINGMEM."\n"._USERNAME.": $username\n"._PASSWORD.": $password";
		$subject = _APPLICATIONSUB;
		OpenTable();
		echo "<center><b>"._ACCOUNTRESERVED."</b><br /><br />"._YOUAREPENDING."<br /><br />"._THANKSAPPL." $sitename!</center>";
	} else if (!$user_cfg['requireadmin']) {
		$message .= _TOREGISTER." $sitename.\n\n";
		OpenTable();
		echo "<center><b>"._ACCOUNTCREATED."</b><br /><br />"._YOUAREREGISTERED."<br /><br />";
		if ($user_cfg['useactivate']) {
			echo _FINISHUSERCONF;
			$message .= _TOFINISHUSER."\n\n $finishlink\n\n"; //<- Is the activation link in email. DJMaze
			$subject = _ACTIVATIONSUB;
		} else {
			echo _FINISHUSERCONF2.'<a href="'.getlink().'">'._FINISHUSERCONF3.'</a>.';
			$subject = _REGISTRATIONSUB;
		}
		echo '<br /><br />'._THANKSUSER." $sitename!</center>";
		$message .= _FOLLOWINGMEM."\n"._USERNAME.": $username\n"._PASSWORD.": $password";
	} else {
		$message .= _TOAPPLY." $sitename.\n\n"._WAITAPPROVAL."\n\n"._FOLLOWINGMEM."\n"._USERNAME.": $username\n"._PASSWORD.": $password";
		$subject = _APPLICATIONSUB;
		OpenTable();
		echo '<center><b>'._ACCOUNTRESERVED.'</b><br /><br />'._YOUAREPENDING.'<br /><br />'._THANKSAPPL." $sitename!</center>";
	}
	$from = 'noreply@'.ereg_replace('www.', '', $MAIN_CFG['server']['domain']);
	if (!send_mail($mailer_message,$message,0,$subject,$user_email,$username,$from)) {
		echo 'Member mail: '.$mailer_message;
	}
	if ($user_cfg['sendaddmail']) {
		if ($user_cfg['requireadmin']) { $subject = "$sitename - "._MEMAPL; }
		else { $subject = "$sitename - "._MEMADD; }
		$message = "$username has been added to $sitename.\n\nUser IP: ".decode_ip($userinfo['user_ip'])."\n--------------------------------------------------------\nDo not reply to this message!!";
		if(!send_mail($mailer_message,$message,0,$subject)) {
			echo "Admin mail: ".$mailer_message;
		}
	}
	CloseTable();
}
function activate($uid, $check_num) {
	global $db, $user_prefix, $user_cfg, $MAIN_CFG;
	if (!$user_cfg['requireadmin']) {
		$db->sql_query('DELETE FROM '.$user_prefix.'_users_temp WHERE time < '.(gmtime()-86400),false, __FILE__,__LINE__);
	}
	$result = $db->sql_query('SELECT * FROM '.$user_prefix."_users_temp WHERE user_id=$uid", false, __FILE__, __LINE__);
	if ($db->sql_numrows($result) == 1) {
		$row = $db->sql_fetchrow($result);
		if ($check_num == $row['check_num']) {
			$fieldlist = $valuelist = '';
			$result = $db->sql_query('SELECT field FROM '.$user_prefix.'_users_fields WHERE visible > 0', false, __FILE__, __LINE__, true);
			while (list($field) = $db->sql_fetchrow($result)) {
				$val = Fix_Quotes($row[$field]);
				if (strlen($val) > 0) {
					$fieldlist .= ", $field";
					$valuelist .= ", '$val'";
				}
				if ($field == 'user_timezone') {
					$fieldlist .= ', user_dst';
					$valuelist .= ', '.$row['user_dst'];
				}
			}
			$db->sql_query('INSERT INTO '.$user_prefix."_users (username, user_email, user_password, user_avatar, user_regdate, user_lastvisit $fieldlist) VALUES ('$row[username]', '$row[user_email]', '$row[user_password]', '".$MAIN_CFG['avatar']['default']."', '$row[user_regdate]', '$row[time]' $valuelist)",false, __FILE__,__LINE__);

// HERE FOR TEAMSPEAK?

			if ($user_cfg['send_welcomepm']) {
				welcome_pm();
			}
			$db->sql_query('DELETE FROM '.$user_prefix."_users_temp WHERE user_id=$uid", false, __FILE__, __LINE__);
			$pagetitle = _ACTIVATIONYES;
			$msg = "<center><b>$row[username]:</b> "._ACTMSG.'</center>';
		} else {
			$pagetitle = _ACTIVATIONERROR;
			$msg = '<center>'._ACTERROR1.'</center>';
		}
	} else {
		$pagetitle = _ACTIVATIONERROR;
		$msg = '<center>'._ACTERROR2.'</center>';
	}
	require_once('header.php');
	OpenTable();
	echo $msg;;
	CloseTable();
}

Any help is greatly appriciated