vB Save() mysql_insert_id ?

[JamesTalbot]

Hey,

I am trying to alter my newly upgraded vBulletin Forum register.php file.

All i want to do is insert the userid from that registered person and insert it into another table.

In vB2 this was very easy. I am unsure how to do this in vB3 though. I have looked at vBulletin Data Documentation but didnt see anything relevant to this issue.

Can anyone help me?

Thanks in Advance.

James

[cheesegrits]

Don't edit the register.php file. Use a plugin on the register_addmember_complete hook, where $vbulletin->userinfo['userid'] will be the new userid.

-- hugh

[Eikinskjaldi]

or use a trigger.

[Opserty]

Originally Posted by Eikinskjaldi

or use a trigger.

trigger?

P.S. the id value is normally returned when the save() function is execute so...

PHP Code:

$somevar = $userdm->save()

// $somevar is the userid 


Obviously it won't be $somevar but it maybe be another variable.

[Lynne]

Originally Posted by cheesegrits

Don't edit the register.php file. Use a plugin on the register_addmember_complete hook, where $vbulletin->userinfo['userid'] will be the new userid.

-- hugh

This is exactly what I do for my tracker. I have a separate table for registration to the tracker that I populate with the userid and username at the time of registration. I use the register_addmember_complete hook and simply put a query in there:

PHP Code:

$db->query_write("INSERT INTO mytable (all variables) VALUES
  (variable contents)
          "); 


[JamesTalbot]

Sorry, have you got a link for more info on these hooks you are referring to?

EDIT - I have found the hook you are referring to. I will test my code and see if it works.

Thanks.

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

Thanks that worked great!



James

[cheesegrits]

Originally Posted by Opserty

trigger?

As of MySQL 5.02, you can add 'triggers' to tables. So you can specify things like "when data is inserted into table A, do such-and-such to table B". See:

http://dev.mysql.com/doc/refman/5.0/en/triggers.html

The advantage of this approach is that you don't have to write any PHP code, it just happens automagically within MySQL. The disadvantage is that ... well, you don't have any PHP code and it happens automagically within MySQL. So you can't add any data which can't be derived from a select on existing MySQL data, and you can't handle errors gracefully. And of course it's MySQL version specific.

If all you are doing is literally inserting data already present in your table(s) into another table, triggers are a useful shortcut.

-- hugh

[Coders Shack]

wow thats f***in sweet! Thx for pointing that out, too bad the company i work at still uses PHP 4 ><.

[Adrian Schneider]

MySQL... not PHP.

[Dismounted]

Still, most servers have MySQL 4.x installed .