Write Some Settings

[Pc 1203]

Hi,
I'm wondering, is there a vBulletin function that will allow me to write something to a database in vBulletin?

- Pc1203

[Kirk Y]

What exactly are you trying to write?

[Pc 1203]

I'm trying to write what user profile template the user wants. It will be in an external page, not the UserCP.

- Pc1203

[Kirk Y]

Well the vBulletin database is no different than any other. You can use an insert/update query to add rows or tables.

$db->query("UPDATE " . TABLE_PREFIX . "table SET row = var");

[Pc 1203]

Ok, thanks!

- Pc1203

EDIT: Where would I put the information I want to update? EX: Can you tell me how to update this:

vB_userfield, field7

[Kirk Y]

If you want to update a profile field, try the following:
$vbulletin->db->query("UPDATE userfield SET fieldX ='" . $data . "' WHERE userid =".$userid);

[Pc 1203]

Ok, thanks a bunch! You're a great helper!

- Pc1203