Need help finding this hack

[Carthriller]

Does anyone know where I can obtain a specific hack in this vbulletin:

http://forums.asianxo.com/

The hack I am looking for is under each category, where you see the new post icon, create a new thread icon, and the subscribe icon. Any help will be greatly appreciated, thank you.

[Lesane]

https://vborg.vbsupport.ru/showthrea...threadid=35660

[Carthriller]

Thanks for the quick reply Lesane, but what about the search for newest post icon. I'm trying to find the query string that can do that that for me, but can't seem to get it to work? Any suggestions?

[PET]

Some screenshots ?

[Carthriller]

I have a link to it in the first post.

http://forums.asianxo.com/

Next to any categories are 3 icons, I want to know what the query string for the first icon(search) is? I can't figure it out to work on my site. (The two other ones are included in the hack that Lesane so graciously provided.)

[Carthriller]

Essentially I want to know when a user click on an icon, what query string will bring him to the latest post for that forum?

<a href="search.php?action=getlatest&forumid=$forum[forumid]">icon</a>, but that didn't work.

Any suggestions?

[Carthriller]

Does anyone know how to do this, please help, thanks

[Lesane]

Open root/search.php and find:

PHP Code:

// ###################### Start getsearchforums ####################### 


Add BEFORE it:

PHP Code:

// ###################### Start get latest #######################
if ($action=="getlatest") {
  // generate query
  // do it!
  if ($bbuserinfo[userid]!=0 or $bbuserinfo[lastvisit]!=0) {
    $forumsql=" AND forumid=$forumid";

    // get date:
    $datesql=" AND thread.lastpost>=".$bbuserinfo[lastvisit];

    $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_pmfloodcheck")."\");");
          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\");");
  } else {
    $action="getdaily";
  }
} 


Now u can use this link to get the results of a specific forum:

PHP Code:

search.php?action=getlatest&forumid=XX 


Where xx is the forumid.

As you can see on my forum i putted it in the template: "Forum Home Page Templates -> forumhome_forumbit_level1_post & forumhome_forumbit_level2_post with the following code:

PHP Code:

<a href="search.php?action=getlatest&&forumid=$forum[forumid]">Read New Posts</a> 


Done.

[Chris M]

Lesane...

When I made your mod, I got this error :

Parse error: parse error in /usr/local/psa/home/vhosts/wootage.net/httpdocs/forums/search.php on line 126

Satan

[Chris M]

Here are the lines...

PHP Code:

$datesql=" AND thread.lastpost>=".$bbuserinfo[lastvisit]; 

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

if ($getsearch=$DB_site->query_first("SELECT searchid FROM search WHERE query='".addslashes <[url]http://www.php.net/addslashes[/url]>($wheresql)."'")) { 
$searchid=$getsearch[searchid]; 
} else { 
// get last search for this user and check floodcheck 


Satan