Hi, I lost my midgard bugtracker password, can someone mail it to me ,
there's no "lost my pwd" functionality in the bugtraker.
Tarjei
----- Original Message -----
From: "Tarjei Huse" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 16, 2001 8:11 PM
Subject: Re: [midgard-user] calanderfunction date format.
> Has this been fixed now?
> Tarjei
> ----- Original Message -----
> From: "David Guerizec" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, June 26, 2001 12:11 PM
> Subject: Re: [midgard-user] calanderfunction date format.
>
>
> > > What is the dateformat to be used in this midgard function ?
> > >
> > > object mgd_list_topic_calendar_all(int topic, int start, int stop,
> string
> > [sort], int [type]);
> > >
> > > I've tried timestamp and mm-dd-year, but I cannot figure it out. Any
> tips?
> >
> > It seems, from the source that it's timestamps:
> >
> > convert_to_long_ex(startn);
> > convert_to_long_ex(stopn);
> > ...
> > startv = (*startn)->value.lval;
> > stopv = ((*stopn)->value.lval > 0) ? (*stopn)->value.lval :
> > DATE_MAX;
> >
> > but it seems also there is something wrong with the SQL query:
> >
> > php_midgard_select(&MidgardArticle, return_value,
> > ARTICLE_SELECT "," ARTICLE_CALENDAR, ARTICLE_FROM,
> > "article.topic IN $D AND author=person.id"
> > " AND article.up=0 AND Unix_Timestamp(calstart)<$d"
> > " AND 24*60*60-1+Unix_timestamp("
> > " Date_Add(calstart, INTERVAL caldays DAY))>$d",
> > sortv, topics, stopv, startv);
> >
> > ie. the startv and stopv seem not to be in the right order, and the <
and
> >
> > signs look reversed too...
> >
> > Unfortunatly, I'm pretty busy these days at my new job, and I won't have
> > time to do any development during an unkown period, so if someone could
> look
> > deeper into it...
> >
> > > Tarjei
> >
> > David
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> >
> >
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
