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] <javascript:>>
> 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
> > 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.
