Find threads started by user

ok, real quicky one: find all threads (note: threads, not posts!) started by X.

Open search.php and find:

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

Above it insert:

// ###################### Start threads by user x #######################
if ($action=="userthreads") {
  // get allowable forums:
  $forumsql=getallforumsql();

  // get user:
  $usersql=" AND thread.postuserid='$userid'";

  $wheresql="1=1".$forumsql.$usersql;

  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&searchid=$searchid\");");
}

That's it, essentially. Now you just need to decide where you want to place the link to this.

For example, If you want it to appear in a user's profile, then place the following link in the getinfo template:

<a href="search.php?s=$session[sessionhash]&action=userthreads&userid=$userinfo[userid]">Find threads started by $userinfo[username]</a>

[Tommy Boy]

Neat one, bira! Can the result show preview of the post, like the regular posts search?

[bira]

Parker - your title preview addon is fan-bloody-tastic. I love it and my users reacted very happily to it (I think it's the latest add-on they most like). No slow-downs or anything on my site. Thanks

Tommy - it uses the normal search script. If you search for threads (latest threads or in threadsubject only), you don't get a preview post. And, since this is a search for threads user X started, this post snippet is redundent, really.

[Sadie Frost]

I love this

The other thing that would be better is if it was added to the actual search page functions.

Another great hack bira

[LanciaStratos]

Wow, just what I was looking for, bira! Thanks, great work! Now, I just need a hack that will show the last 10 threads a user made in their profile...

[wolfe]

Cant you make it like the posts on Vbbb.org

where it shows the number and it is a link to search how do i do that in Post bit temp

[kippesp]

Just getting ready to install it.

Found one bug. If a thread has been moved, it shows up as a poll in the search results. This will fix.

after this

$wheresql="1=1".$forumsql.$usersql;

add this

$wheresql.=" AND thread.open<>10";

[inetd]

Good hack!
I install this

[FleaBag]

Thanks for this hack, working on 2.2.6!

[FleaBag]

Works with 2.2.7.

[X-Fan]

Just trying to install this on a clean copy of 2.2.8, but I'm not finding this code in showthread.php:

PHP Code:

$post[postcount] = ++$postcount; 


Help!