functions.php

<?php
// No cookies whatsoever
define('NOCOOKIES', 1);
$_COOKIE = array();

chdir('..');
require_once('./global.php');
require_once(DIR . '/includes/functions.php');
require_once(DIR . '/includes/functions_login.php');

function str($str, $amp = false) {
  global $vbulletin;

  if ($amp)
    $str = str_replace('&amp;', '&', $str);

  $charset = vB_Template_Runtime::fetchStyleVar('charset');
  if ($charset == '') $charset ='ISO-8859-1';
  return to_utf8($str, $charset);
}

function fetch_forum($forumid) {
  global $vbulletin;

  if ($forumid == -1) {
    return array(
      'title' => str($vbulletin->options['bbtitle']),
      'threadcount' => 0,
    );
  }

  // Don't use cache as it doesn't include threadcount by default
  $foruminfo = fetch_foruminfo($forumid, false);
  if (!$foruminfo)
    return false;

  return array(
    'id' => intval($foruminfo['forumid']),
    'title' => str($foruminfo['title'], true),
    'description' => str($foruminfo['description'], true),
    'threadcount' => intval($foruminfo['threadcount']),
    'replycount' => intval($foruminfo['replycount']),
  );
}

function can_view_forum($foruminfo) {
  global $vbulletin;

  $forumperms = fetch_permissions($foruminfo['forumid']);
  return ($forumperms & $vbulletin->bf_ugp_forumpermissions['canview']);

  // TODO: Forum password?
}

// @see construct_subforum_bit
function fetch_subforum_list($parentid = -1) {
  global $vbulletin;
  cache_ordered_forums(1); // 1 means: also cache thread/reply counts

  $result = array();

  if (!isset($vbulletin->iforumcache["$parentid"]))
    return $result;

  foreach ($vbulletin->iforumcache["$parentid"] as $forumid) {
    $forum = $vbulletin->forumcache["$forumid"];
    $forumperms = $vbulletin->userinfo['forumpermissions']["$forumid"];
    if (!($forumperms & $vbulletin->bf_ugp_forumpermissions['canview']) AND
         ($vbulletin->forumcache["$forumid"]['showprivate'] == 1 OR
           (!$vbulletin->forumcache["$forumid"]['showprivate'] AND
            !$vbulletin->options['showprivateforums'])
         )
       ) {
      // no permission to view current forum
      continue;
    }

    if (!$forum['displayorder'] OR
        !($forum['options'] & $vbulletin->bf_misc_forumoptions['active'])) {
      // forum not active
      continue;
    }

    // get on/off status
    //$lastpostinfo = $vbulletin->forumcache["$lastpostarray[$forumid]"];
    //$forum['statusicon'] = fetch_forum_lightbulb($forumid, $lastpostinfo, $forum);
    //$show['newposticon'] = ($forum['statusicon'] ? true : false);
    $result[] = array(
      'id' => $forum['forumid'],
      'title' => str($forum['title'], true),
      'description' => str($forum['description'], true),
      'threadcount' => intval($forum['threadcount']),
      'replycount' => intval($forum['replycount']),
    );
  }

  return $result;
}

function fetch_threads($forumid, $perpage = 10, $page = 1) {
  global $db;

  if ($page < 1) $page = 1;
  $offset = ($page - 1) * $perpage;

  $allthreads = array();

  // Show sticky threads only on first page
  if ($page == 1) {
    $stickies = $db->query_read_slave("
      SELECT t.threadid, t.title, t.replycount
      FROM " . TABLE_PREFIX . "thread t
      WHERE t.forumid = $forumid
        AND t.visible = 1
        AND t.sticky = 1
        AND t.open <> 10
      ORDER BY t.lastpost DESC
    ");
    while ($sticky = $db->fetch_array($stickies)) {
      $sticky['sticky'] = true;
      $allthreads[] = $sticky;
    }
  }

  $threads = $db->query_read_slave("
    SELECT t.threadid, t.title, t.replycount
    FROM " . TABLE_PREFIX . "thread t
    WHERE t.forumid = $forumid
      AND t.visible = 1
      AND t.sticky <> 1
      AND t.open <> 10
    ORDER BY t.lastpost DESC
    LIMIT $offset, $perpage
  ");

  $result = array();
  while ($thread = $db->fetch_array($threads)) {
    $allthreads[] = $thread;
  }

  foreach ($allthreads as $thread) {
     $result[] = array(
      'id' => intval($thread['threadid']),
      'title' => str($thread['title'], true),
      'replycount' => intval($thread['replycount']),
      'sticky' => $thread['sticky'] ? true : false,
    );
  }

  return $result;
}

function fetch_thread($threadid) {
  global $vbulletin;

  $threadinfo = fetch_threadinfo($threadid);
  if (!$threadinfo)
    return false;

  return array(
    'id' => intval($threadinfo['threadid']),
    'forumid' => intval($threadinfo['forumid']),
    'title' => str($threadinfo['title']),
    'replycount' => intval($threadinfo['replycount']),
    'open' => $threadinfo['open'] == 1,
  );
}

function fetch_posts($threadid, $perpage = 10, $page = 1) {
  global $db;

  $threadid = intval($threadid);
  $perpage = intval($perpage);
  $page = intval($page);

  if ($page < 1) $page = 1;
  $offset = ($page - 1) * $perpage;

  $posts = $db->query_read("
    SELECT p.username, p.pagetext
    FROM " . TABLE_PREFIX . "post AS p
    LEFT JOIN " . TABLE_PREFIX . "user AS u ON (u.userid = p.userid)
    WHERE p.threadid = $threadid
      AND p.visible = 1
    ORDER BY p.dateline
    LIMIT $offset, $perpage
  ");

  $result = array();
  while ($post = $db->fetch_array($posts)) {
    $result[] = $post;
  }

  return $result;
}

function can_view_thread($threadinfo) {
  // @see showthread.php
  global $vbulletin;

  $forumperms = fetch_permissions($threadinfo['forumid']);
  if (!($forumperms & $vbulletin->bf_ugp_forumpermissions['canview']))
    return false;

  if (!($forumperms & $vbulletin->bf_ugp_forumpermissions['canviewthreads']))
    return false;

  if (!($forumperms & $vbulletin->bf_ugp_forumpermissions['canviewothers']) AND
      ($thread['postuserid'] != $vbulletin->userinfo['userid'] OR
       $vbulletin->userinfo['userid'] == 0))
    return false;

  // TODO: Forum password?
  return true;
}

function login($username, $password) {
  global $vbulletin;
  if (verify_authentication($username, $password, '', '', '', false)) {
    process_new_login('', '', '');
    return get_userinfo();
  } else {
    return false;
  }
}

function logout() {
  process_logout();
  return get_userinfo();
}

function get_userinfo() {
  global $vbulletin;
  return array(
    'id' => intval($vbulletin->userinfo['userid']),
    'name' => str($vbulletin->userinfo['username']),
    's' => str($vbulletin->session->vars['dbsessionhash']),
  );
}

function shutdown() {
  exec_shut_down(); // Save session, close DB etc.
}

?>