How to Update Custom Profile Fields (solved)

[shlomot]

Hi. After completing a set of calculations in a PHP file (as a CMPS module), I'm trying to commit the results into a few custom profile fields for the current user.

I've read all posts and articles, but still without success. My last code is:

$query = "UPDATE vbulletin_prefix_userfield
          SET field75 = $intimacy_score, field73 = $intimacy_level, field76 = $intimacy_status
          WHERE userid = $vbulletin->userinfo['userid']";

Please help. Thank you.

--------------- Added [DATE]1214541980[/DATE] at [TIME]1214541980[/TIME] ---------------

I was helped by Ideal Web Technologies who reminded me to add the following statement after the query definition:

$vbulletin->db->query($query);

Thank you, Tim, so very much.

Unfortunately, I couldn't make do with vbulletin_prefix_userfield, vbulletin_prefixuserfield, or .table_prefix.
Maybe CMPS cannot read these globals.
So the final script looks like this:

$query = "UPDATE userfield
          SET field75 = $intimacy_score, field73 = $intimacy_level, field76 = $intimacy_status
          WHERE userid = $user_id";
$vbulletin->db->query($query);