close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

Trial Membership

Thread began 7/22/2011 2:17 pm by mdsayeed_u394092 | Last modified 8/02/2011 2:32 pm by mdsayeed_u394092 | 1089 views | 6 replies |

mdsayeed_u394092

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

Sign in to reply to this post

Ray BorduinWebAssist

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.

Sign in to reply to this post

mdsayeed_u394092

I want to write dynamic condition for trail period

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

Sign in to reply to this post

Ray BorduinWebAssist

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)

Sign in to reply to this post

mdsayeed_u394092

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

hi

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


thanks

Sign in to reply to this post

mdsayeed_u394092

How to write mysql trigger current date + 7 days

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

Sign in to reply to this post

mdsayeed_u394092

no response from 3 days

hi

please tell me how to write trigger

Sign in to reply to this post

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...