The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
I am running a Joomla! website, and need two components within it to sync between 3 tables;
JC Registration plugin (JoomConnect )
External Database WHMCS
J!WHMCS sync's user login credentials from Joomla! to WHMCS. what I need to do is set up a cron that syncs the additional contact information as it changes.
A user would use the JoomConnect subscription form to sign up, from here the data populates in the jos_users table and the jos_custom_user_info (database: 1). a plugin has also been added from J!WHMCS that populates their tables (jos_jwhmcs_user) with the base jos_users table information (email address, password etc) and takes care of the password replication between Joomla! and WHMCS.
The cron needs to replicate to the jos_jwhmcs_user with the fields in the table (there is more than just these fields in this table but these are all that need to be replicated):
address1 address2 city state postal country phonenumber
To match with the fields in the jos_custom_user_...
Sign in or Register to see more