Messages of today, yesterday, the day before

[Pyro]

Ok,

I'm sure I'm blind but didn't fount what I am looking for. I am looking for an simple hack, that produces a combobox with three choices:

messages of today
messages since yesterday
messages of the last three days

You can find a German version of this hack on http://forum.traum-projekt.com (that box with the yellow "go"-button on the top of that page.
The responsible guy there is on vacation so I cannot ask him directly for that hack.

Im sure it's pretty simple - any ideas?
Thanks in advance
Markus

[Admin]

In search.php find

PHP Code:

// ###################### Start posts by user x ####################### 


And above it put

PHP Code:

// ###################### Start get double-daily #######################
if ($action=="getddaily") {
  // get allowable forums:
  $forumsql=getallforumsql();

  // get date:
  $datesql=" AND thread.lastpost>=".(time()-24*60*60*2);

  $wheresql="1=1".$forumsql.$datesql;
  $wheresql.=" AND thread.open<>10";
  if ($getsearch=$DB_site->query_first("SELECT searchid FROM search WHERE query='".addslashes($wheresql)."'")) {
    $searchid=$getsearch[searchid];
  } else {
    // get last search for this user and check floodcheck
    if ($prevsearch=$DB_site->query_first("SELECT searchid,dateline FROM search WHERE ".iif($bbuserinfo[userid]==0,"ipaddress='$ipaddress'","userid=$bbuserinfo[userid]")." ORDER BY dateline DESC LIMIT 1")) {
      if (time()-$prevsearch[dateline]<$searchfloodcheck and $searchfloodcheck!=0) { // and !ismoderator()) {
                                eval("standarderror(\"".gettemplate("error_searchfloodcheck")."\");");
                                exit;
      }
    }
                // insert query into db
                $DB_site->query("INSERT INTO search (searchid,query,dateline,querystring,showposts,userid,ipaddress) VALUES (NULL,'".addslashes($wheresql)."',".time().",'".addslashes($query)."',0,$bbuserinfo[userid],'".addslashes($ipaddress)."')");
                $searchid=$DB_site->insert_id();
  }


  eval("standardredirect(\"".gettemplate("redirect_search")."\",\"search.php?s=$session[sessionhash]&action=showresults&getnew=true&searchid=$searchid\");");
}

// ###################### Start get triple-daily #######################
if ($action=="gettdaily") {
  // get allowable forums:
  $forumsql=getallforumsql();

  // get date:
  $datesql=" AND thread.lastpost>=".(time()-24*60*60*3);

  $wheresql="1=1".$forumsql.$datesql;
  $wheresql.=" AND thread.open<>10";
  if ($getsearch=$DB_site->query_first("SELECT searchid FROM search WHERE query='".addslashes($wheresql)."'")) {
    $searchid=$getsearch[searchid];
  } else {
    // get last search for this user and check floodcheck
    if ($prevsearch=$DB_site->query_first("SELECT searchid,dateline FROM search WHERE ".iif($bbuserinfo[userid]==0,"ipaddress='$ipaddress'","userid=$bbuserinfo[userid]")." ORDER BY dateline DESC LIMIT 1")) {
      if (time()-$prevsearch[dateline]<$searchfloodcheck and $searchfloodcheck!=0) { // and !ismoderator()) {
                                eval("standarderror(\"".gettemplate("error_searchfloodcheck")."\");");
                                exit;
      }
    }
                // insert query into db
                $DB_site->query("INSERT INTO search (searchid,query,dateline,querystring,showposts,userid,ipaddress) VALUES (NULL,'".addslashes($wheresql)."',".time().",'".addslashes($query)."',0,$bbuserinfo[userid],'".addslashes($ipaddress)."')");
                $searchid=$DB_site->insert_id();
  }


  eval("standardredirect(\"".gettemplate("redirect_search")."\",\"search.php?s=$session[sessionhash]&action=showresults&getnew=true&searchid=$searchid\");");
} 


Now just link to search.php?action=getddaily (note: two d's) for posts from two days ago, and search.php?action=gettdaily (note: two t's) for posts from three days ago. Posts from today are search.php?action=getdaily.
You can make the box itself by yourself.

Hope I helped.

[Pyro]

Thanks,

just had the time to check your hack - great! Exactly what I was looking for...

Markus

[Meta]

Yes ... just what i have been looking for.

A few more questions:

1. Is there any possibility to make this more variable? So the user can make a choice as he wants ... last 17 days or last 10 days or something like that. And so we dont have to do for each day one long code ... but only a variable?

2. Is there a possibility to get the results like if i click on "postsonly"? So with the posts and a little preview on it? That i am missing also on the getdaily-function.

3. One problem - or at least for me it seems so - is, if we dont get the posts a "last three days"-function (or a "last ten days"-function even more) isn't such as useful as it could be. E.g the last three days result could be not so differant from the last two day result ... means there are the same threads on the results ... and the user has to find the right posts by himself. He can jump to the beginning ... or jump to the end. But not to the post which has been written three days ago.

I tried a bit playing around which varios ideas on the search.php ... but i didn't find clue. It's not so hard to change the searchresultbit ... but the result isn't that what i wanted. At least until now. Same threats ... no preview ... but i'm a very poor coder also.

So ... nice try ... i had even almost the same idea (i multiplicated the hours ... 48 hrs, 72 hrs and so on) ... but it's not so useful as i would wish ... without the posts.

Any ideas?

(Hm? Yes ... in other words ... what i wish is a real "search by date"-function. Like at least Discus has it.)

[Meta]

(Ooh hell ... i'm a member now. I have to tell all my friends about it.)

[Meta]

Oh ... you can stop searching now. I find my clues for having a "last x days"-view with posts instaed of threads.

If somebody is interested ... i will write them down ... it's mostly three changes in the search.php

[Gutspiller]

What do I need to add so that I can assign which forum IDs it does and doesn't do this from?