thank you jsunquist,...
I'll try,...
On Wednesday, December 19, 2012 12:45:28 PM UTC-8, jsundquist wrote:
>
> Chris,
>
> Just to help you out instead of the giant mktime string you have you can
> also use strtotime(). Within the function you can simply do strtotime('+30
> days') which will do the same thing as above.
>
>
> On Wed, Dec 19, 2012 at 2:39 PM, Chris <[email protected] <javascript:>>wrote:
>
>> hi cricket,.... thank you for your response
>> I have another approach to it,... on the click to advertising banner
>> and/or link thru function (link goes thru function), and checks and compare
>> "featured_end" date with today's date,... and if it less than today's date
>> it resets table.
>> here is the function,... just in case anyone needs it:
>>
>> function featured($id = null)
>> {
>> if(!($dba = $this->Dba->findById($id)))
>> {
>> $this->flash('error', ucfirst(i18n::translate('dba not found')));
>> $this->redirect('/not_found');
>> }
>> elseif(!($user = $this->User->findById($dba['Dba']['user_id'])))
>> {
>> $this->flash('error', ucfirst(i18n::translate('user not found')));
>> $this->redirect('/not_found');
>> }
>> else
>> {
>> $today = date('Y-m-d H:i:s');
>>
>> if($dba['Dba']['featured_end'] <= $today)
>> {
>> $dba['Dba']['featured'] = 0;
>> $dba['Dba']['featured_start'] = NULL;
>> $dba['Dba']['featured_end'] = NULL;
>>
>> $this->Dba->save($dba);
>>
>> $this->redirect('/');
>>
>> }
>> $this->redirect('/dbas/view/' . $dba['Dba']['id']);
>> }
>> }
>>
>>
>>
>>
>> On Wednesday, December 19, 2012 11:11:07 AM UTC-8, cricket wrote:
>>
>>> Create a shell task to fetch all records with featured == 1 and
>>> end_date in the past. Run a cron job at midnight to call it.
>>>
>>> On Wed, Dec 19, 2012 at 6:22 AM, Chris <[email protected]> wrote:
>>> > hi guys,... can anyone help please
>>> >
>>> > I'm building promotional advertising feature on a site,...
>>> > and have a table fields: "featured_start" once the user is call the
>>> function
>>> > and "featured_end" after 30 days:
>>> >
>>> > $dba['Dba']['featured'] = 1;
>>> > $dba['Dba']['featured_start'] = date('Y-m-d H:i:s');
>>> > $after_30 = mktime(date("H"), date("i"), date("s"), date("m"),
>>> date("d")+30,
>>> > date("y"));
>>> > $dba['Dba']['featured_end'] = date('Y-m-d H:i:s', $after_30);
>>> >
>>> > now I want to set $dba['Dba']['featured'] = 0; after 30 days,
>>> > and reset "featured_start" and "featured_end" to NULL
>>> > so the promotion can stop,...
>>> >
>>> > how can I this,...?
>>> >
>>> > thanks in advance
>>> > chris
>>> >
>>> >
>>> >
>>> > --
>>> > Like Us on FaceBook
>>> > https://www.facebook.com/**CakePHP<https://www.facebook.com/CakePHP>
>>> > Find us on Twitter http://twitter.com/CakePHP
>>> >
>>> > ---
>>> > You received this message because you are subscribed to the Google
>>> Groups
>>> > "CakePHP" group.
>>> > To post to this group, send email to [email protected].
>>> > To unsubscribe from this group, send email to
>>> > cake-php+u...@**googlegroups.com.
>>> > Visit this group at
>>> > http://groups.google.com/**group/cake-php?hl=en<http://groups.google.com/group/cake-php?hl=en>.
>>> >
>>>
>>> >
>>> >
>>>
>> --
>> Like Us on FaceBook https://www.facebook.com/CakePHP
>> Find us on Twitter http://twitter.com/CakePHP
>>
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "CakePHP" group.
>> To post to this group, send email to [email protected]<javascript:>
>> .
>> To unsubscribe from this group, send email to
>> [email protected] <javascript:>.
>> Visit this group at http://groups.google.com/group/cake-php?hl=en.
>>
>>
>>
>
>
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en.
