vB5 API help - latest / trending posts list only returns if < 5 days

[Beergeeksf]

I created a simple PHP script that loads the vB5 API and generates a simple JSON list of the trending posts. (See sample code below). The problem is that I can't get the scripts to generate anything for more than a couple days. Ideally I'd like to get the trending posts in the last 7 days, last 31 days, etc. But it I go over 3-5 days, nothing is returned. Any suggestions?

Sample code to load the vB5 API, and get the last 20 days of posts:

$vbpath = $_SERVER['DOCUMENT_ROOT'];
define('CSRF_PROTECTION', false);
require_once($vbpath . '/includes/vb5/autoloader.php');
vB5_Autoloader::register($vbpath);
vB5_Frontend_Application::init('config.php');

$api = Api_InterfaceAbstract::instance();

$search_json = '{"channel":["15"],"starter_only":1,"date":{"from":"'7'"},"sort":{"lastcontent":"desc"},"view":"","exclude_type":["vBForum_PrivateMessage"]}';

$threads = vB_Api::instanceInternal('search')->getInitialResults($search_json, 30, 1);      

$i = 0;
$thread_returns = array();

if (!isset($threads['errors']) AND !empty($threads['results'])) {
  //let's get views too
  $threads['results'] = vB_Api::instanceInternal('node')->mergeNodeviewsForTopics($threads['results']);

  foreach ($threads['results'] as $tid => $thread_details) {
    $i++;
    $thread_returns['results'][$i] = array(
      'title'         => $thread_details['content']['title'],
      'publishdate'   => $thread_details['content']['publishdate'],
      'channeltitle'  => $thread_details['content']['channeltitle'],
      'description'   => $thread_details['content']['description'],
      'userid'        => $thread_details['content']['userid'],  
      'authorname'    => $thread_details['content']['authorname'],
      'uniqueid'      => $thread_details['content']['nodeid']
    );

    //Get author profile page
    if($user_info = vB_User::fetchUserinfo($thread_details['content']['userid'], 0, false, false)) {
      $thread_returns['results'][$i]['user_bbprofileurl'] = vB5_Route::buildUrl('profile|bburl', array('userid' => $thread_details['content']['userid'], 'username' => $thread_details['content']['authorname']));
    }
    
    //vB5_Route::buildUrl -- build out the URL to the post
    $thread_returns['results'][$i]['postlink'] = vB5_Route::buildUrl(
      $thread_details['routeid'] . '|fullurl',
      array(
        'nodeid' => $thread_details['nodeid'],
        'title' => $thread_details['title']
      )
    );

    //vB5_Route::buildUrl -- build out the URL to the channel
    $thread_returns['results'][$i]['channellink'] = vB5_Route::buildUrl( $thread_details['content']['channelroute'] . '|fullurl' );

    //Add in the views and votes
    $thread_returns['results'][$i]['views'] = $thread_details['content']['views'];
    $thread_returns['results'][$i]['votes'] = $thread_details['content']['votes'];

  }
}
$thread_returns['totalRecords'] = count($thread_returns['results']);
$thread_returns['searchJSON'] = $search_json;
$thread_returns['days'] = $num_days;

if ($thread_returns['totalRecords'] > 0) {
  header('Content-Type: application/json');
  echo json_encode($thread_returns);
} else {
  var_dump($thread_returns);
}

If I change the $search_json code above 5 days, nothing is returned, no error is create, just blank output.

Any help is greatly appreciated.

Cheers,
Jeff

[delicjous]

You could use template for this also... just search for initialResult in templates for examples. There is also a ignore cache as search option . You could try this.

[Beergeeksf]

An update -- one of the problems was actually a silent json_encode error in PHP -- once I checked for json errors I saw that error. Wrapping all of the thread details in utf8_encode() fixed that error:

'title'         => utf8_encode($thread_details['content']['title']),

Still seeing inconsistent results, but at least I get results every time now.

Cheers,
Jeff