elpaisa Posted February 12, 2008 Share Posted February 12, 2008 Hi all! I need to handle a date field called join_date, that is in a mysql table and calculate 1 month afther the user registration, and when the month ends set automatically a field called "activated" to "0". This is the first part of various modifications that I have to do, to this user system, so I would appreciate all your help to this cause! Thanks all!, ??? Link to comment https://forums.phpfreaks.com/topic/90765-help-with-membership-script-calculate-1-month-from-the-join-date/ Share on other sites More sharing options...
revraz Posted February 12, 2008 Share Posted February 12, 2008 How is the date stored? If you want this to happen automatically, as in without having the user log in and then set it, you'll have to use a CRON job. Link to comment https://forums.phpfreaks.com/topic/90765-help-with-membership-script-calculate-1-month-from-the-join-date/#findComment-465290 Share on other sites More sharing options...
elpaisa Posted February 12, 2008 Author Share Posted February 12, 2008 Yes, i'm thinking in a cron job, but it is so huge the code, i need something small, if you have some small cronjob php code to recomend I would thank you! Link to comment https://forums.phpfreaks.com/topic/90765-help-with-membership-script-calculate-1-month-from-the-join-date/#findComment-465294 Share on other sites More sharing options...
revraz Posted February 12, 2008 Share Posted February 12, 2008 I would just do it when they actually log in. Check the status of Activated, if it = 0 and is > 30 days, set to 1, if not then don't. If they never come back, why set it to Activated after 30 days. Link to comment https://forums.phpfreaks.com/topic/90765-help-with-membership-script-calculate-1-month-from-the-join-date/#findComment-465296 Share on other sites More sharing options...
elpaisa Posted February 12, 2008 Author Share Posted February 12, 2008 this is a good point to start, but how a i should calculate that 30 days for the date field Link to comment https://forums.phpfreaks.com/topic/90765-help-with-membership-script-calculate-1-month-from-the-join-date/#findComment-465303 Share on other sites More sharing options...
revraz Posted February 12, 2008 Share Posted February 12, 2008 Depends how you store the date. Link to comment https://forums.phpfreaks.com/topic/90765-help-with-membership-script-calculate-1-month-from-the-join-date/#findComment-465309 Share on other sites More sharing options...
elpaisa Posted February 12, 2008 Author Share Posted February 12, 2008 I use TIMENOW function Link to comment https://forums.phpfreaks.com/topic/90765-help-with-membership-script-calculate-1-month-from-the-join-date/#findComment-465312 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.