<?php

/*

Plugin Name: Newsboy

Plugin URI: javascript: // No URL yet, stay tuned!

Description: Newsboy adds a news management system to Enano. It can integrate with the Feed Me plugin to provide an additional RSS feed. 

Author: Dan Fuhry

Version: 0.1

Author URI: http://www.enanocms.org/

*/

/*

 * Newsboy

 * Version 0.1

 * Copyright (C) 2007 Dan Fuhry

 *

 * This program is Free Software; you can redistribute and/or modify it under the terms of the GNU General Public License

 * as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.

 *

 * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied

 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for details.

 */

// Insert our News namespace

$plugins->attachHook('acl_rule_init', 'NewsBoy_namespace_setup($this);');

// Hook into page rendering

$plugins->attachHook('page_not_found', 'NewsBoy_namespace_handler($this);');

$plugins->attachHook('send_page_footers', 'NewsBoy_PortalLink();');

// String to determine page type string

$plugins->attachHook('page_type_string_set', 'NewsBoy_set_page_string();');

// Attach to the Feed Me plugin, if it's loaded (if not, the feed handler simply won't get called)

$plugins->attachHook('feed_me_request', 'NewsBoy_feed_handler($mode);');

function NewsBoy_namespace_setup(&$paths)

{

  $paths->create_namespace('NewsBoy', 'News:');

  $paths->addAdminNode('Newsboy portal', 'Configuration', 'NewsboyConfiguration');

  $paths->addAdminNode('Newsboy portal', 'Manage news items', 'NewsboyItemManager');

  global $db, $session, $paths, $template, $plugins; // Common objects

  $session->acl_extend_scope('read',                   'NewsBoy', $paths);

  $session->acl_extend_scope('post_comments',          'NewsBoy', $paths);

  $session->acl_extend_scope('edit_comments',          'NewsBoy', $paths);

  $session->acl_extend_scope('edit_page',              'NewsBoy', $paths);

  $session->acl_extend_scope('view_source',            'NewsBoy', $paths);

  $session->acl_extend_scope('mod_comments',           'NewsBoy', $paths);

  $session->acl_extend_scope('history_view',           'NewsBoy', $paths);

  $session->acl_extend_scope('history_rollback',       'NewsBoy', $paths);

  $session->acl_extend_scope('history_rollback_extra', 'NewsBoy', $paths);

  $session->acl_extend_scope('protect',                'NewsBoy', $paths);

  $session->acl_extend_scope('rename',                 'NewsBoy', $paths);

  $session->acl_extend_scope('clear_logs',             'NewsBoy', $paths);

  $session->acl_extend_scope('vote_delete',            'NewsBoy', $paths);

  $session->acl_extend_scope('vote_reset',             'NewsBoy', $paths);

  $session->acl_extend_scope('delete_page',            'NewsBoy', $paths);

  $session->acl_extend_scope('set_wiki_mode',          'NewsBoy', $paths);

  $session->acl_extend_scope('password_set',           'NewsBoy', $paths);

  $session->acl_extend_scope('password_reset',         'NewsBoy', $paths);

  $session->acl_extend_scope('mod_misc',               'NewsBoy', $paths);

  $session->acl_extend_scope('edit_cat',               'NewsBoy', $paths);

  $session->acl_extend_scope('even_when_protected',    'NewsBoy', $paths);

  $session->acl_extend_scope('upload_files',           'NewsBoy', $paths);

  $session->acl_extend_scope('upload_new_version',     'NewsBoy', $paths);

  $session->acl_extend_scope('create_page',            'NewsBoy', $paths);

  $session->acl_extend_scope('php_in_pages',           'NewsBoy', $paths);

  $session->acl_extend_scope('edit_acl',               'NewsBoy', $paths);

}

function NewsBoy_namespace_handler($page)

{

  global $db, $session, $paths, $template, $plugins; // Common objects

  if ( defined('ENANO_FEEDBURNER_INCLUDED') )

  {

    $template->add_header('<link rel="alternate" title="'.getConfig('site_name').' News feed" href="'.makeUrlNS('Special', 'RSS/news', null, true).'" type="application/rss+xml" />');

  }

  if ( $paths->namespace != 'NewsBoy' )

    return;

  if ( $paths->cpage['urlname_nons'] == 'Portal' || preg_match('/^Archive(\/|$)/', $page->page_id) || preg_match('/^Article\//', $page->page_id) )

  {

    // Add admin opener Javascript function

    $template->add_header('<!-- NewsBoy: admin panel nav function -->

    <enano:no-opt>

    <script type="text/javascript">

      function newsboy_open_admin()

      {

        if ( auth_level < USER_LEVEL_ADMIN )

        {

          ajaxPromptAdminAuth(function(k) {

            ENANO_SID = k;

            auth_level = USER_LEVEL_ADMIN;

            var loc = String(window.location + \'\');

            window.location = append_sid(loc);

            var loc = makeUrlNS(\'Special\', \'Administration\', \'module=\' + namespace_list[\'Admin\'] + \'NewsboyItemManager\');

            if ( (ENANO_SID + \' \').length > 1 )

              window.location = loc;

          }, 9);

          return false;

        }

        var loc = makeUrlNS(\'Special\', \'Administration\', \'module=\' + namespace_list[\'Admin\'] + \'NewsboyItemManager\');

        window.location = loc;

      }

    </script>

    </enano:no-opt>');

    $x = getConfig('nb_portal_title');

          ( ( empty($x) ) ?

              'Welcome to ' . getConfig('site_name') :

              $x ) :

          'News Archive';

    if ( !$page->perms->get_permissions('read') )

    {

      $page->err_access_denied();

      return false;

    }

    $paths->cpage['comments_on'] = 0;

    if ( $page->page_id == 'Portal' )

    {

      $template->header();

      NewsBoy_portal();

      $template->footer();

    }

    else if ( preg_match('/^Archive(\/|$)/', $page->page_id) )

    {

      $template->header();

      NewsBoy_archive();

      $template->footer();

    }

    else if ( preg_match('/^Article\//', $page->page_id) )

    {

      if ( !preg_match('#^Article/([0-9]{4})/([0-9]{2})/([0-9]{2})/(.+?)$#', $page->page_id, $id_match) )

      {

        return;

      }

      // look around for this page

      // int mktime  ([ int $hour  [, int $minute  [, int $second  [, int $month  [, int $day  [, int $year  [, int $is_dst  ]]]]]]] )

      $timestamp_min = mktime(0, 0, 0, intval($id_match[2]), intval($id_match[3]), intval($id_match[1]));

      $timestamp_max = $timestamp_min + 86400;

      // mysql and postgresql friendly

      $integer_prepend = ( ENANO_DBLAYER == 'MYSQL' ) ? "unsigned" : '';

      $q = $db->sql_query('SELECT urlname, name FROM ' . table_prefix . "pages WHERE CAST(urlname AS $integer_prepend integer) >= $timestamp_min AND CAST(urlname AS $integer_prepend integer) <= $timestamp_max AND namespace = 'NewsBoy';");

      if ( !$q )

        $db->_die();

      if ( $db->numrows() < 1 )

        return;

      // found a page

      $row = $db->fetchrow();

      if ( sanitize_page_id($row['name']) === $id_match[4] )

      {

        // we have a definitive match, send the page through

        $article = new PageProcessor($row['urlname'], 'NewsBoy');

        $article->send_headers = $page->send_headers;

        $article->password = $page->password;

        $article->send(true);

      }

      else

      {

        // can't find it.

        return;

      }

      return;

    }

  }

}

function NewsBoy_set_page_string()

{

  global $db, $session, $paths, $template, $plugins; // Common objects

  if ( $paths->namespace == 'NewsBoy' )

  {

    if ( $paths->cpage['urlname_nons'] == 'Portal' )

    {

      $template->namespace_string = 'portal';

      // block editing

      $perm_arr = Array('edit_page' => AUTH_DENY, 'view_source' => AUTH_DENY);

      $session->acl_merge_with_current($perm_arr, false, 2);

    }

    else

    {

      $template->namespace_string = 'news item';

    }

  }

}

function NewsBoy_format_title($title)

{

  $title = strtolower($title);

  $title = preg_replace('/\W/', '-', $title);

  $title = preg_replace('/([-]+)/', '-', $title);

  $title = trim($title, '-');

  return $title;

}

function NewsBoy_feed_handler($mode)

{

  global $db, $session, $paths, $template, $plugins; // Common objects

  if ( $mode != 'news' )

    return;

  $limit = ( $x = $paths->getParam(1) ) ? $x : 20;

  $limit = intval($limit);

  if ( $limit > 50 )

    $limit = 50;

  $title = getConfig('site_name') . ': Site news';

  $x = getConfig('nb_portal_title');

  $desc = ( empty($x) ) ? 'Welcome to ' . getConfig('site_name') : $x;

  $link = makeUrlComplete('NewsBoy', 'Portal');

  $generator = 'Enano CMS ' . enano_version() . ' - NewsBoy plugin';

  $email = getConfig('contact_email');

  $rss = new RSS($title, $desc, $link, $generator, $email);

  $sql = 'SELECT p.*, l.time_id, l.author, u.user_level,COUNT(c.comment_id) AS num_comments,t.page_text FROM '.table_prefix.'pages AS p

         LEFT JOIN '.table_prefix.'comments AS c

           ON ( c.page_id=p.urlname AND c.namespace=p.namespace )

         LEFT JOIN '.table_prefix.'logs AS l

           ON ( l.page_id=p.urlname AND l.namespace=p.namespace )

         LEFT JOIN '.table_prefix.'users AS u

           ON ( u.username=l.author )

         LEFT JOIN '.table_prefix.'page_text AS t

           ON ( t.page_id=p.urlname AND t.namespace=p.namespace )

         WHERE p.namespace=\'NewsBoy\'

           AND l.action=\'create\'

           AND p.urlname REGEXP \'^([0-9]+)$\'

           AND p.visible=1

         GROUP BY p.urlname

         ORDER BY urlname DESC

         LIMIT '.$limit.';';

  $q = $db->sql_unbuffered_query($sql);

  if ( !$q )

    $db->_die();

  $formatter = new NewsBoyFormatter();

  if ( $row = $db->fetchrow() )

  {

    do {

      $title = $row['name'];

      $link = makeUrlComplete('NewsBoy', $row['urlname']);

      $desc = RenderMan::render($row['page_text']);

      $time = intval($row['urlname']);

      $rss->add_item($title, $link, $desc, $time);

    } while ( $row = $db->fetchrow() );

  }

  else

  {

    $rss->add_item('Error', $link, 'No news items yet.', time());

  }

  echo $rss->render();

}

function NewsBoy_portal()

{

  global $db, $session, $paths, $template, $plugins; // Common objects

  if ( file_exists( ENANO_ROOT . "/themes/{$template->theme}/newsboy-post.tpl" ) )

  {

    $parser = $template->makeParser("newsboy-post.tpl");

  }

  else

  {

    $news_template = <<<TPLCODE

    <div class="tblholder news">

      <table border="0" cellspacing="1" cellpadding="4" style="width: 100%;">

        <tr>

          <th><a href="{LINK}" style="color: inherit;">{TITLE}</a></th>

        </tr>

        <tr>

          <td class="row3">

            {CONTENT}

          </td>

        </tr>

        <tr>

          <th class="subhead" style="font-weight: normal; font-size: 67%;">

            Posted by {USER_LINK} on {DATE}<br />

            [ {NUM_COMMENTS} comment{COMMENT_S} | {COMMENT_LINK} ]

          </th>

        </tr>

      </table>

    </div>

TPLCODE;

    $parser = $template->makeParserText($news_template);

  }

  /*

  $p = RenderMan::strToPageID(getConfig('main_page'));

  if ( $p[1] != 'NewsBoy' )

  {

    echo RenderMan::getPage($p[0], $p[1]);

  }

  else

  { */

    /*

    $s = $paths->nslist['NewsBoy'] . 'Announce';

    if ( isPage($s) )

    {

      $p = RenderMan::getPage('Announce', 'NewsBoy');

      echo $p;

    }

  /* } */

  $announce_page_default = $paths->nslist['NewsBoy'] . 'Announce';

  $s = $announce_page_default;

  $announce_page = getConfig('nb_announce_page');

  if ( !empty($announce_page) && isPage($announce_page) )

  {

    $s = $announce_page;

  }

  else if ( !isPage($s) )

  {

    $s = false;

  }

  if ( $s )

  {

    $stuff = RenderMan::strToPageID($s);

    // Hackish fix to prevent the categorization button and other stuff from being displayed

    $paths->pages[$s]['special'] = 1;

    $page = new PageProcessor($stuff[0], $stuff[1]);

    $content = $page->fetch_text();

    $content = '?>' . RenderMan::render($content);

    eval($content);

  }

  else

  {

    $stuff = RenderMan::strToPageID($announce_page_default);

  }

  if ( file_exists( ENANO_ROOT . "/themes/{$template->theme}/newsboy-portal-pre.tpl" ) )

  {

    $parser_pre = $template->makeParser("newsboy-portal-pre.tpl");

    echo $parser_pre->run();

  }

  else

  {

    echo '<h2>Latest news</h2>';

  }

  $q = $db->sql_unbuffered_query('SELECT p.*, COUNT(c.comment_id) AS num_comments, t.page_text, l.time_id, l.author, u.user_level FROM '.table_prefix.'pages AS p

         LEFT JOIN '.table_prefix.'comments AS c

           ON ( c.page_id=p.urlname AND c.namespace=p.namespace )

         LEFT JOIN '.table_prefix.'page_text AS t

           ON ( t.page_id=p.urlname AND t.namespace=p.namespace )

         LEFT JOIN '.table_prefix.'logs AS l

           ON ( l.page_id=p.urlname AND l.namespace=p.namespace )

         LEFT JOIN '.table_prefix.'users AS u

           ON ( u.username=l.author OR u.user_id=1 )

         WHERE p.namespace=\'NewsBoy\'

           AND l.action=\'create\'

           AND p.urlname!=\'Announce\'

           AND p.visible=1

         GROUP BY p.urlname

         ORDER BY urlname DESC;');

  if ( !$q )

    $db->_die();

  if ( $row = $db->fetchrow() )

  {

    $i = 0;

    do

    {

      if ( $i < 5 )

      {

        $content = $row['page_text'];

        $trimmed = false;

        if ( $pos = strpos($content, '<!--BREAK-->' ) )

        {

          $content = substr($content, 0, $pos);

          $trimmed = true;

        }

        $title = htmlspecialchars($row['name']);

        $content = RenderMan::render($content);

        if ( strlen($content) > 400 && !$trimmed )

        {

          $content = nb_trim_paragraph($content, 400, $trimmed);

        }

        if ( $trimmed )

        {

          $link = ' <a href="' . makeUrlNS('NewsBoy', $row['urlname'], false, true) . '">Read more...</a>';

          $content = preg_replace('/(.+?)<\/(p|ul|table|div|pre)>([\s]*?)$/Usi', '\\1' . $link . '</\\2>\\3', $content, 1);

          if ( !strstr($content, $link) )

          {

            $content .= $link;

          }

        }

        $user_link = nb_make_username_link($row['author'], $row['user_level']);

        $date = date('F d, Y h:i:s a', $row['urlname']);

        $num_comments = $row['num_comments'];

        $comment_s = ( $num_comments == 1 ) ? '' : 's';

        $comment_link = '<a href="' . makeUrlNS('NewsBoy', $row['urlname'], false, true) . '#do:comments" style="color: inherit;">add a comment</a>';

        $parser->assign_vars(array(

            'TITLE' => $title,

            'LINK' => nb_make_article_url($row['urlname'], $row['name']),

            'CONTENT' => $content,

            'USER_LINK' => $user_link,

            'DATE' => $date,

            'NUM_COMMENTS' => $num_comments,

            'COMMENT_S' => $comment_s,

            'COMMENT_LINK' => $comment_link

          ));

        echo $parser->run();

      }

      else

      {

        echo '<p><a href="'.makeUrlNS('NewsBoy', 'Archive').'">Older news...</a></p>';

        break;

      }

      $i++;

    } while ( $row = $db->fetchrow() );

  }

  else

  {

    echo '<p>No news items yet.</p>';

  }

  if ( file_exists( ENANO_ROOT . "/themes/{$template->theme}/newsboy-portal-post.tpl" ) )

  {

    $parser_post = $template->makeParser("newsboy-portal-post.tpl");

    echo $parser_post->run();

  }

  if ( $session->user_level >= USER_LEVEL_ADMIN )

  {

    echo '<div class="tblholder" style="margin: 10px auto 0 auto; display: table;">

            <table border="0" cellspacing="1" cellpadding="4">

              <tr>

                <th>Administrative tools:</th>

                <td class="row3" style="text-align: center;"><a style="color: inherit;" href="' . makeUrlNS($stuff[1], $stuff[0], '', true) . '#do:edit">Edit announcement &raquo;</a></td>

                <td class="row3" style="text-align: center;"><a style="color: inherit;" href="' . makeUrlNS('Special', 'Administration', 'module='.$paths->nslist['Admin'].'NewsboyItemManager', true) . '" onclick="newsboy_open_admin(); return false;">Portal Administration</a></td>

              </tr>

            </table>

          </div><br />';

  }

}

/**

 * Formats row data in the archive.

 * @package Enano

 * @subpackage Newsboy

 * @license GNU General Public License

 */

class NewsBoyFormatter

{

  function article_link($name, $row)

  {

    $article_link = '<a href="' . nb_make_article_url($row['urlname'], $row['name']) . '">' . $row['name'] . '</a>';

    return $article_link;

  }

  function format_date($date, $row)

  {

    $date = date('Y-m-j g:m', intval ( $date ));

    return $date;

  }

  function format_username($x, $row)

  {

    $ul = intval($row['user_level']);

    $author = nb_make_username_link($row['author'], $ul);

    return $author;

  }

  function format_commentlink($x, $row)

  {

    $comments = '<a href="' . makeUrlNS('NewsBoy', $row['urlname']) . '#do:comments">' . $row['num_comments'] . '</a>';

    return $comments;

  }

}

function NewsBoy_archive()

{

  global $db, $session, $paths, $template, $plugins; // Common objects

  $lower_limit = ( isset($_GET['start']) ) ? intval($_GET['start']) : ( ( $xx = $paths->getParam(0) ) ? intval($xx) : 0 );

  $entries_per_page = 50;

  $row_count = $entries_per_page + 1;

  // Determine number of total news entries

  $q = $db->sql_query('SELECT urlname FROM '.table_prefix.'pages WHERE namespace=\'NewsBoy\' AND urlname REGEXP \'^([0-9]+)$\' AND visible=1;');

  if ( !$q )

    $db->_die();

  $r = $db->fetchrow();

  $num_total = intval($db->numrows());

  $db->free_result();

  if ( $lower_limit >= $num_total )

    $lower_limit = 0;