[Elenna]

During a previous installation, I had a form set up to insert info into the database in the user profile field. If you want it inserted elsewhere, you'll need to modify as necessary. I HIGHLY HIGHLY HIGHLY recommend developing this on a test install because, if you don't know what you're doing, you can royally mess up your database.

Note: This may no longer work, try and use at your own risk.


You first need to get the question number where they enter in the info - you get this in the questions list (I believe) or by editing the individual question.

Then you need to find the corresponding user profile field ID. This is seen in the "name" field on the profile field manager (i.e. "field34").

There are two basic parts to this, the first is to make the field "play nice" with the database so it doesn't break any code. Replace the $q[###] with the appropriate question number. Repeat this line for each question you have that you want to insert into the database... change the $info# AND $query# so that each line (variable) is unique.

$userid=$vbulletin->userinfo['userid'];

$info# = addslashes($q[###]);

$query = $db->query_first_slave("UPDATE userfield SET field###='$info1' WHERE userid='$userid' LIMIT 1");

So for example, if I have a question #12 that I want put in user field 30, and a question #14 that I was in user field 33, this is what mine might look like:

$userid=$vbulletin->userinfo['userid'];

$info1 = addslashes($q[12]);
$info2 = addslashes($q[14]);

$query1 = $db->query_first_slave("UPDATE userfield SET field30='$info1' WHERE userid='$userid' LIMIT 1");

$query2 = $db->query_first_slave("UPDATE userfield SET field33='$info1' WHERE userid='$userid' LIMIT 1");