Auto Registration 
Author: Sam S.Hello,
I need advice/suggestions on how to best create database for Auto Registration.
Category 1 are people who would register requiring only their name and email for basic privileges.
Category 2 would require them for more information but have more priveleges.
Category 3 would require the most amount of information for the most privileges.
Questions:
1. What is the best or better way to build database and tables?
2. When one increases or decreases their privileges, can that be done automatically? By them providing more information and membership renewal their privileges would increase and decrease when expires.
3. Can these privileges be granted automatically? More privileges would have access to more locked pages and vice versa.
I was thinking of grouping them in Access Management. Can they be automatically categorized?
4. How do I create automatic numbering for membership ID purposes?
Thanks for your advice and suggestions,
Sam
Hello Sam,
the required data for the automatically registration are not editable, you can set the permission of the user in setp 4, you can update the list of the user so you can set the permission for particular users. try to see the help of the software in the internal guide.
Hope this help.
Author
Hello,
I am not clear with your response and if they answer my questions. Perhaps I was not clear. Could that be elaborated more? Could you please number your answers to the number on my questions? It would be easier for me to understand?
Let me redescribe what I wanted WX5 to do.
Category 1 Users only need to provide 3 pieces of information to get Privilege A. Information needed is First, Last Name and email. And is free to join.
Category 2 Users need to provide about 10 pieces of information, 3 are same as Cat 1 and 7 of which are new and they get Privileges A & B. Members here pay 1/2 price and is good for 12 months then if not renewed, privilege will revert to Category 1.
Category 3 Users need to provide 20 pieces of information, 10 of which are new and they get Privileges A, B & C. Members here pay full price good for 12 months and if not renewed, privilege will revert to Category 1.
More the privileges means more access to locked pages.
Question:
1. Do I need to create 3 databases - one for each category?
Or do I create 1 database with 3 tables. Wherein Table 1 contains the 3 pieces of information, Table 2 contains the 7 pieces of information and Table 3 contains the last 10 pieces of information?
Or what is a better way to do this?
2. My main concern is to figure out how to enable this so that the user can automatically be granted more privileges or reduce them based on their membership payment/renewals. As soon as payment is validated, privileges are granted. Can this be done automatically or must it be done manually?
3. How do I create auto numbering for membership ID number?
Thanks,
Sam
Hello Sam,
the program create only one table with the user for the automatically registration,
these users areassigned at the automatically registration group.
If you need to set different privileges for user you can download the list (by step 4 in acces management) and change the gruoup for each user.
If not possibile insert a auto numbering for membership ID number, you can create a script that do this.
Hope this help.
Author
Hello,
1. Could you please elaborate how to "downloading the list"?
Do I have to manually enter all those names in Step4 - access mgmt? Or can they be automatically entered in access mgmt and just change group for each user?
I can imagine this becoming a nightmare and frustrating when someone signs up, pays for it but would have to "wait a long time" to get access to those pages. Is there an alternative to this?
Or, can this be made to similar like buying a product? After paying, they have access immediately to certain locked pages?
2. Can you provide me with a script for autonumbering?
Many thanks,
Sam
Hello Sam,
you can insert in you progect the registration automatically, then the users save in teh DB.
When you open the progct in the website X5 Professional 10, go in step 4 and clik on the "acces management" in the left there is a button "update" so you can download le list of the user in locan and modify it.
For the script, i'm sorry but i not assist you for external code, try to search tutorial in internet about this.
Hope this help.
No you can not edit the list for it! Because the update goes only once. Changes in the database are also not collected for existing users. Deleted users are not deleted!
Riccardo see here
http://answers.websitex5.com/post/77238
But what really bothers even more is the storage of passwords in plain text