This topic is locked

modify user permissions

11/13/2011 12:28:32 AM
PHPRunner General questions
4
46super author

After much additional research, it seems I may have a user permission issue rather than an event issue.
I have one database which produces one standard type of full property record/view. The full records/views naturally vary by location, type, size, sale price, date of sale, etc.
I want to modify the permissions for the general user group so that after their query is run: a.) the maximum number of any and all viewable (full) records is limited by the permission assigned; and b.) that maximum # of full views is only permitted within a specific time frame.
Basically, within each X day period, the user group is permitted to view only X# of any records they choose to view. And on again for the next X day period.
In sum, I need a way to limit the total number of views (and their ability to print the data) within a given time frame.
Is this possible in PHPRunner and if so, what process is required? Any ideas on other approaches would be helpful too!
Thanks very much for your assistance.

C
cgphp 11/13/2011

Create a new table in the database to track the views of the users:

id | user_id | view_record_id | view_date


Every time a user loads a view page, you track the action in the above table. If the number of viewed records for the current month is less than the limit (for example 30), the view page will be loaded otherwise the user will be informed about the reached limit. Make the control in the Process record values event of the view page before to insert a new tracking record.
The view_record_id field is optional but if you want to do some additional controls over a single record you need it.

4
46super author 11/13/2011



Create a new table in the database to track the views of the users:

id | user_id | view_record_id | view_date


Every time a user loads a view page, you track the action in the above table. If the number of viewed records for the current month is less than the limit (for example 30), the view page will be loaded otherwise the user will be informed about the reached limit. Make the control in the Process record values event of the view page before to insert a new tracking record.
The view_record_id field is optional but if you want to do some additional controls over a single record you need it.


Thank you for your excellent help on this issue! This makes very good sense and I am encouraged to keep pressing on with my project.
You are a key asset to the Forum and your many A+ contributions are very appreciated.
Thank you again Cristian.
-- 46Super