[ianskate]

Ive also spent the entire day exploring vBulletin's caching. I suspected that user attributes were being loaded into a cache (datastore) of some sort, and most of the board's functionality referred to this cache as opposed to the _user table. From what ive found, this is not the case.

I am going to make an attempt at adding a user through a datamanager script, and pass the info to it through a URL, as a last ditch effort. I really wanted to be able to simply add new users via sql queries tho.

Oh and to reply to the above post: i dont believe there are any other tables associated with a user
as far as a user being registered or not goes. The userfields, usernote, usertextfield, etc, tables are not relevant when considering most of the problems im having (for example, those fields can be left totally blank, which most users will have them as, when looking up a userid to send a pm, or viewing a profile, or post, etc).

OK just in case anyone has this problem in the future:

I found a way of using the VB Datamanager_User externally (without having use any dependencies) by passing user metadata such as name, pw (hash), salt, options, etc, through a url that calls a datamanager_register php script within the forum branch on my server. However, just as I had accomplished this, my coworker found a problem with my initial attempt at accomplishing external registration.

When writing to the _user table, you must also write the userid to the _userfield and _usertextfield tables as well. The values for the rest of the columns can all be set to null, which is what caused me to overlook these tables (since their defaults are all null). Directly sending as much info as you can to the _user table, and sending the id to the _userfield and _usertextfield tables, allows external registration via sql queries to work perfectly fine!

http://nextnewnetworks.com/networks.html