I'd like to have the vBulletin plugin send the user's selected e-mail address back to the vBulletin user DB right after it finishes signing the user up.

Taking a look at the plugin, i can more or less tell where the code should go, and the SQL syntax isn't a problem.. but the perl is beyond me. (I'm a PHP and ASP programmer, unfortunately).

Anyone have a moment or three to suggest some code to run this query: (variables names simulated, i've no idea what they are in the plug in.. but hopefully this gets the idea across)

UPDATE `user` SET gmail = $gmailemailaddress WHERE username= $vbulletinusername

Thanks to any who help!

Anyone? I'd be willing to throw around a bit of money (whatever's fair) to see this accomplished. :)

Hi,

The code would just look something like:

my $sth = $AUTH_DBH->prepare("UPDATE user SET gmail = ? WHERE username = ?");
$sth->execute($username, $remote_user);

If you put that in sub authenticate() right after:

require GMail::Folders;
GMail::Folders->update();

that should do the trick.

Cheers,

Alex
--
Gossamer Threads Inc.

Alex, this worked *perfectly*. Thank you very, very much!