Trial Membership

Hi,

I need to write a script for my client, and want to use DataAssist, my requriement is, when user get registered his membership should expire on certain date(say after 7 days)... please tell me how I can write this

1.Membership expiry date
2.Duration of Expiry can be changed by admin

Kind Regards
Jussay

There are a million ways you can do it... here is one:

When the user registers you need to store the date they registered.

Then using security assist when they log in, you would store the registration date as a session variable.

Then update your security assist access rule to check the login date and restrict access if a certain number of days have passed.

I'm not sure if you would want the admin to be able to change the duration on a user by user basis or globally or both, but you would either store the number of days it is valid for as a separate field in the users table and use that in your security rule, or look it up in a database of configurable settings that you create for the admin.

Hi,

I want to write dynamic condition for trail period..I will try to explain here more clearly. I want admin can change trial period whenever he wants. so I will put one column in database to store that desirable expiry date /duration and will write condition to check validation of period then allow access

I need your help in
1.How to call that column in DA rules and check
2.How to convert date to period.For example on admin side I keep a drop down with 7 days/8 days to select trail period then how it will convert to date, current date+7 days...

Hope you understand

Kind Regards
Jusay

1) You can create a recordset to retrieve the value and store it as a session variable. Then you can refer to that session variable whenever it is needed.

2) in php you can use: strtotime("+7 day",$startDate)... in mysql there are several options, but one example is to use: DATE_ADD(DateColumn,INTERVAL 7 DAY)

hi

on mysql database where I need to put this DATE_ADD(DateColumn,INTERVAL 7 DAY)


thanks

I want to store current date+ 7 days in mysql database, dont want just to create a recordset and put DATE_ADD(DateColumn,INTERVAL 7 DAY).. for future references I need to store expiry date in my database, so please tell me how I can write trigger on new insertion by using DA

hi

please tell me how to write trigger