What tables and fields are required for registration?
 

I am going to set up an automated registration process for my forum.

I have a customer database where I get their information from their purchase.

I want to automatically make them a member of my forum by generating a Username and Password (via a script) and then add the necessary information into any tables that are required to successfully make them registered without having to do any of it themselves.

I can generate the UN/PW and I already have all the data, I know how to use VB, Coldfusion. php etc so I can easily write an interface to actually put the data into the tables.

I just don't know WHICH tables in vBulletin MUST filled in to make a valid registration?

Thanks

it should be user table

That's the ONLY table that needs to be "hit" during registration?

Not these also?

forum useractivation
forum userfield

Thanks

1. useractivation: Its a table storing temporary records, you won't need it in your case. It stores info like useractivation ID, email change, etc.

2. userfield: This stores ONLY the fields listed in admincp->User Profile Field Manager. So, you won't need it coz you just want username and pass to get them registered.

User registration can affect many tables, user the vb data manager to create them.

Thanks for the advice.

After searching through as many posts (Paul) as I could back to your own "noobie" post on data managers in 2005 :) I still don't quite get it.

If I am simply inserting data into fields in already existing tables, why do I need to use the DataManager? I am simply saying I do not understand the underlying reason the DataManager would be required or even really preferable vs for example using Coldfusion to read data from one source and insert in into another (being my froum tables).

Perhaps inserting records directly into vbulletin tables is far more complex than I realize?

Just at a loss. I was thinking more like veenuisthebest...just insert the data and be done with it.

We always advise to use the DataManagers as registration involves many tables and probably updating certain counters.

To ensure that you do not miss anything and your script will still work correctly in future release, the easiest way is to let the DataManagers control the process.

ok thanks.

I will look into the Data Manager.

Where can I get more information on this "DataManager"? From my searching so far, it appears it's just scripts that you write yourself to manipulate your forum's data. Is there any core program to help you do this?

Thanks

You can read about the Data Managers in our online documentation at:
http://www.vbulletin.com/docs/html/data_managers
+
You can also see the entire vBulletin API at:
http://members.vbulletin.com/api/

Here is a tutorial on how to create a new user automatically:
https://vborg.vbsupport.ru/showthrea...reate+New+User

Excellent!

Many thanks