Using Security Assist and Power Store 3 to work with EXISTING user registration
I have an existing website restricted with a user registration system I built with Adobe Dreamweaver Developer's Toolkit. I have a very large database that contains a CustomerID that is tied in to the company's accounting system. We need to be able to pull up customers by Customer ID or company name. The existing registration system uses encrypted passwords and the CustomerID. (The CustomerID is pre-assigned and not an auto-fill.)
Here's my question - and I'm not sure where to begin.
1) I would like to use this pre-existing customer registration database with my PowerStore 3 log-in system. The existing registration database has encrypted passwords.
2)I would like to create a new customer registration system (or adapt the Power Store 3 one) so that from now on new customers are registered under the new system. (So I can use Security Assist to maintain.)
3) I need to add the fields CustomerID and Company Name to my Power Store 3 registration system and database and be able to call up the existing log-in system with it's encrypted passwords in my new store (created from PowerStore 3). It is crucial that the CustomerID and Company Name by carried throughout the registration system and the PowerStore because that is how we track customers.
4) I also need 3 user levels - Site Administrators, End Users and would like another level of Super Administrator. The Super Admin would be the only one who could change the content on the Power Store 3. (What is now just the admin log-in.)
I have the Power Store up and running but need to incorporate my existing registered users into the system. I have Data Assist, Security Assist. eCart 5 and Power Store 3. I develop on Dreamweaver. I'm knowledgable with MySQL database creation and modification on the server site. I can add fields to my PowerStore 3 registration database and import the data from my existing registration database to modify the PowerStore 3 registration database if needed.
How do I integrate this software to modify my store and site?
I realize that this is a big question - but I thought I'd start here because it seemed like perhaps the kind of thing that Security Assist / Data Assist was built for.