Custom SQL upon Registration and Profile Update

[Joe Noon]

I would like to execute a few SQL statements for each new registration and each time a users profile is updated, at a safe point after the vBulletin processes have been run.

Heres why:

I use a zip code database to match up zip codes with cities/counties. This puts a large load on the server when some of my non-vb pages require a join to the large zip code database. I would like to create an intermediate table with userid, zip, city, and county so that upon new user registration or profile update, this information is pulled once. Then thereafter, the much smaller intermediate table will be used for database queries in a non-vb part of the site.

I am fully capable of writing the code. My only concern is making sure I execute the code in the right place, and making sure it does not affect the normal vb processes. If anyone could point me to the correct places to insert my modifications that would be great.