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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...