[Summary view] [Print] [Text view]

   1  <?php
   2  /**
   3   * MyBB 1.4
   4   * Copyright © 2008 MyBB Group, All Rights Reserved
   5   *
   6   * Website: http://www.mybboard.net
   7   * License: http://www.mybboard.net/about/license
   8   *
   9   * $Id: announcements.php 4673 2009-12-30 12:09:43Z RyanGordon $
  10   */
  11  
  12  define("IN_MYBB", 1);
  13  define('THIS_SCRIPT', 'announcements.php');
  14  
  15  $templatelist = "announcement";
  16  require_once  "./global.php";
  17  require_once  MYBB_ROOT."inc/functions_post.php";
  18  
  19  // Load global language phrases
  20  $lang->load("announcements");
  21  
  22  $aid = intval($mybb->input['aid']);
  23  
  24  $plugins->run_hooks("announcements_start");
  25  
  26  // Get announcement fid
  27  $query = $db->simple_select("announcements", "fid", "aid='$aid'");
  28  $announcement = $db->fetch_array($query);
  29  
  30  if(!$announcement)
  31  {
  32      error($lang->error_invalidannouncement);
  33  }
  34  
  35  // Get forum info
  36  $fid = $announcement['fid'];
  37  if($fid > 0)
  38  {
  39      $forum = get_forum($fid);
  40  
  41      if(!$forum)
  42      {
  43          error($lang->error_invalidforum);
  44      }
  45  
  46      // Make navigation
  47      build_forum_breadcrumb($forum['fid']);
  48  
  49      // Permissions
  50      $forumpermissions = forum_permissions($forum['fid']);
  51  
  52      if($forumpermissions['canview'] == 0 || $forumpermissions['canviewthreads'] == 0)
  53      {
  54          error_no_permission();
  55      }
  56      
  57      // Check if this forum is password protected and we have a valid password
  58      check_forum_password($forum['fid']);
  59  }
  60  add_breadcrumb($lang->nav_announcements);
  61  
  62  $archive_url = build_archive_link("announcement", $aid);
  63  
  64  // Get announcement info
  65  $time = TIME_NOW;
  66  
  67  $query = $db->query("
  68      SELECT u.*, u.username AS userusername, a.*, f.*, g.title AS grouptitle, g.usertitle AS groupusertitle, g.stars AS groupstars, g.starimage AS groupstarimage, g.image AS groupimage, g.namestyle, g.usereputationsystem
  69      FROM ".TABLE_PREFIX."announcements a
  70      LEFT JOIN ".TABLE_PREFIX."users u ON (u.uid=a.uid)
  71      LEFT JOIN ".TABLE_PREFIX."userfields f ON (f.ufid=u.uid)
  72      LEFT JOIN ".TABLE_PREFIX."usergroups g ON (g.gid=u.usergroup)
  73      WHERE a.startdate<='$time' AND (a.enddate>='$time' OR a.enddate='0') AND a.aid='$aid'
  74  ");
  75  $announcementarray = $db->fetch_array($query);
  76  
  77  if(!$announcementarray)
  78  {
  79      error($lang->error_invalidannouncement);
  80  }
  81  
  82  $announcementarray['dateline'] = $announcementarray['startdate'];
  83  $announcementarray['userusername'] = $announcementarray['username'];
  84  $announcement = build_postbit($announcementarray, 3);
  85  $lang->forum_announcement = $lang->sprintf($lang->forum_announcement, htmlspecialchars_uni($announcementarray['subject']));
  86  
  87  $plugins->run_hooks("announcements_end");
  88  
  89  eval("\$forumannouncement = \"".$templates->get("announcement")."\";");
  90  output_page($forumannouncement);
  91  ?>