> 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]
