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);

[Ideal Web Tech]

No problem glad we got it fixed for you.

[Dismounted]

The User datamanager should be used when dealing with user data.

[shlomot]

Can you please explain.

Originally Posted by Dismounted

The User datamanager should be used when dealing with user data.

[Dismounted]

<a href="http://www.vbulletin.com/docs/html/data_managers" target="_blank">Data Managers</a>

[shlomot]

Many thanks, but as a non-technical, doing-the-best-I-can-to-get-by type of a person, I beg you to translate the above statements to appropriate data_manager ones. I'll take it from there to be implemented all around, and so will so many other vBs who recognize the importance of using these classes.

The Data Managers manual is overwhelming at best

Originally Posted by Dismounted

Data Managers