<?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();');

$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()

{

  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;

  $chk = $paths->page;

  $chk1 = substr($chk, 0, ( strlen($paths->nslist['NewsBoy']) + 8 ));

  $chk2 = substr($chk, 0, ( strlen($paths->nslist['NewsBoy']) + 7 ));

  if ( $paths->cpage['urlname_nons'] == 'Portal' || $paths->cpage['urlname_nons'] == 'Archive' || $chk1 == $paths->nslist['NewsBoy'] . 'Archive/' || $chk2 == $paths->nslist['NewsBoy'] . 'Archive' )

  {

    // Add admin opener Javascript function

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

    <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>');

    $x = getConfig('nb_portal_title');

    $template->tpl_strings['PAGE_NAME'] = ( $paths->cpage['urlname_nons'] == 'Portal' ) ?

          ( ( empty($x) ) ?

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

              $x ) :

          'News Archive';

    if ( !$session->get_permissions('read') )

    {

      die_friendly('Access denied', '<div class="error-box"><b>Access to this page is denied.</b><br />This may be because you are not logged in or you have not met certain criteria for viewing this page.</div>');

    }

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

    $template->header();

    ( $paths->cpage['urlname_nons'] == 'Portal' ) ? NewsBoy_portal() : NewsBoy_archive();

    $template->footer();

  }

}

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

  $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;

  /*

  $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;

    }

  /* } */

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

  $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);

    echo $p;

  }

  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;

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

    do

    {

      if ( $i < 5 )

      {

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

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

        if ( strlen($content) > 400 )

        {

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

        }

        if ( $trimmed )

        {

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

        }

        $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' => makeUrlNS('NewsBoy', $row['urlname']),

            '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 ( $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('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="' . makeUrlNS('NewsBoy', $row['urlname']) . '">' . $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;

  $sql = 'SELECT p.*, l.time_id, l.author, u.user_level,COUNT(c.comment_id) AS num_comments 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 )

         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;';

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

  if ( !$q )

    $db->_die();

  $formatter = new NewsBoyFormatter();

  $callers = Array(

      'name' => Array($formatter, 'article_link'),

      'urlname' => Array($formatter, 'format_date'),

      'author' => Array($formatter, 'format_username'),

      'num_comments' => Array($formatter, 'format_commentlink')

    );

  $head = '<div class="tblholder">

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

            <tr>

              <th>Article</th><th>Date</th><th>Author</th><th>Comments</th>

            </tr>';

  $foot = "</table></div>";

  $content = paginate($q, "\n".'<tr><td class="{_css_class}">{name}</td><td class="{_css_class}">{urlname}</td><td class="{_css_class}">{author}</td><td class="{_css_class}">{num_comments}</td></tr>',

                      $num_total, makeUrlNS('NewsBoy', 'Archive/%s'), $lower_limit, 20, $callers, $head, $foot);

  echo $content;  

  $code = $plugins->setHook('send_page_footers');

  foreach ( $code as $cmd )

  {

    eval($cmd);

  }

}

function nb_make_username_link($username, $user_level)

{

  $color = '#0000AA';

  $user_level = intval($user_level);

  if ( $user_level < USER_LEVEL_MEMBER ) return $username;

  if ( $user_level >= USER_LEVEL_MOD ) $color = '#00AA00';

  if ( $user_level >= USER_LEVEL_ADMIN ) $color = '#AA0000';

  $link = '<a style="color: ' . $color . '" href="' . makeUrlNS('User', str_replace(' ', '_', $username) ) . '">' . $username . '</a>';

  return $link;

}

function NewsBoy_PortalLink()

{

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

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

    echo '<div class="tblholder"><table border="0" style="width: 100%;" cellspacing="1" cellpadding="4"><tr><th><a style="color: inherit;" href="' . makeUrlNS('NewsBoy', 'Portal') . '">&laquo; Return to News Portal</a></th></tr></table></div><br />';

}

// Administration panel

function page_Admin_NewsboyItemManager()

{

  global $db, $session, $paths, $template, $plugins; if($session->auth_level < USER_LEVEL_ADMIN || $session->user_level < USER_LEVEL_ADMIN) { redirect(makeUrlNS('Special', 'Administration', 'noheaders', true), '', '', 0); die('Hacking attempt'); }

  $done = false;

  if ( isset( $_GET['act'] ) )

  {

    switch ( $_GET['act'] )

    {

      case 'edit':

        // Error list

        $errors = Array();

        if ( isset ( $_POST['submitting'] ) )

        {

          // Generate timestamp

          $year = intval($_POST['pub_year']);

          $month = intval($_POST['pub_month']);

          $day = intval($_POST['pub_day']);

          $hour = intval($_POST['pub_hour']);

          $minute = intval($_POST['pub_minute']);

          $second = intval($_POST['pub_second']);

          // Validation

          if ( $year < 1500 || $year > 10000 )

            $errors[] = 'Invalid year.';

          if ( $month < 1 || $month > 12 )

            $errors[] = 'Invalid month.';

          if ( $day < 1 || $day > 31 )

            $errors[] = 'Invalid day.';

          if ( $hour < 0 || $hour > 23 )