Jump to content

SQL Query to create a USER Account for each LISTING

Recommended Posts

I have entered approx 300 directory listings to build up the content of my directory.

They are all owned by my admin user account.


Now I would like to create a Joomla Account for each of these 300 listings, and associate each listing with a Basic JomDirectory Subscription.

Once this is done, I can begin to hand-over control of the accounts to the businesses that have been listed.


I am very familiar with SQL, but not with the Joomla DB schema, related dependencies for Joomla users, and the dependencies for JomDirectory subscriptions.



Can anyone provide me with the basic SQL for this ???


1. Create a Joomla Account for each listing ( in a specified JomDirectory Category and where the listing email is not null )

- SET Joomla Account Email = Listing.Email

- SET Joomla Account Password = Listing.Email

- SET Joomla Account Disabled = TRUE

- SET Joomla Account Type = Registered (?)


2. Create/Link a JomDirectory Basic Subscription for each Joomla Account created in step 1 above.



Thanks in advance.


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now