plugins/Newsboy.php
author Dan
Mon, 30 Mar 2009 00:31:33 -0400
changeset 11 b0995e600bde
parent 9 162b0f10e3d0
child 12 62c594682bf6
permissions -rw-r--r--
Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
     1
<?php
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
     2
/*
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
     3
Plugin Name: Newsboy
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
     4
Plugin URI: javascript: // No URL yet, stay tuned!
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
     5
Description: Newsboy adds a news management system to Enano. It can integrate with the Feed Me plugin to provide an additional RSS feed. 
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
     6
Author: Dan Fuhry
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
     7
Version: 0.1
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
     8
Author URI: http://www.enanocms.org/
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
     9
*/
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    10
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    11
/*
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    12
 * Newsboy
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    13
 * Version 0.1
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    14
 * Copyright (C) 2007 Dan Fuhry
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    15
 *
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    16
 * This program is Free Software; you can redistribute and/or modify it under the terms of the GNU General Public License
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    17
 * as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    18
 *
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    19
 * This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    20
 * warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for details.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    21
 */
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    22
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    23
// Insert our News namespace
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    24
$plugins->attachHook('acl_rule_init', 'NewsBoy_namespace_setup($this);');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    25
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    26
// Hook into page rendering
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
    27
$plugins->attachHook('page_not_found', 'NewsBoy_namespace_handler($this);');
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    28
$plugins->attachHook('send_page_footers', 'NewsBoy_PortalLink();');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    29
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    30
// String to determine page type string
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    31
$plugins->attachHook('page_type_string_set', 'NewsBoy_set_page_string();');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    32
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    33
// Attach to the Feed Me plugin, if it's loaded (if not, the feed handler simply won't get called)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    34
$plugins->attachHook('feed_me_request', 'NewsBoy_feed_handler($mode);');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    35
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    36
function NewsBoy_namespace_setup(&$paths)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    37
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    38
  $paths->create_namespace('NewsBoy', 'News:');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    39
  $paths->addAdminNode('Newsboy portal', 'Configuration', 'NewsboyConfiguration');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    40
  $paths->addAdminNode('Newsboy portal', 'Manage news items', 'NewsboyItemManager');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    41
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    42
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    43
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    44
  $session->acl_extend_scope('read',                   'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    45
  $session->acl_extend_scope('post_comments',          'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    46
  $session->acl_extend_scope('edit_comments',          'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    47
  $session->acl_extend_scope('edit_page',              'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    48
  $session->acl_extend_scope('view_source',            'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    49
  $session->acl_extend_scope('mod_comments',           'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    50
  $session->acl_extend_scope('history_view',           'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    51
  $session->acl_extend_scope('history_rollback',       'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    52
  $session->acl_extend_scope('history_rollback_extra', 'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    53
  $session->acl_extend_scope('protect',                'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    54
  $session->acl_extend_scope('rename',                 'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    55
  $session->acl_extend_scope('clear_logs',             'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    56
  $session->acl_extend_scope('vote_delete',            'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    57
  $session->acl_extend_scope('vote_reset',             'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    58
  $session->acl_extend_scope('delete_page',            'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    59
  $session->acl_extend_scope('set_wiki_mode',          'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    60
  $session->acl_extend_scope('password_set',           'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    61
  $session->acl_extend_scope('password_reset',         'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    62
  $session->acl_extend_scope('mod_misc',               'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    63
  $session->acl_extend_scope('edit_cat',               'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    64
  $session->acl_extend_scope('even_when_protected',    'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    65
  $session->acl_extend_scope('upload_files',           'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    66
  $session->acl_extend_scope('upload_new_version',     'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    67
  $session->acl_extend_scope('create_page',            'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    68
  $session->acl_extend_scope('php_in_pages',           'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    69
  $session->acl_extend_scope('edit_acl',               'NewsBoy', $paths);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    70
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    71
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    72
11
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
    73
function NewsBoy_namespace_handler(&$page)
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    74
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    75
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    76
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    77
  if ( defined('ENANO_FEEDBURNER_INCLUDED') )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    78
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    79
    $template->add_header('<link rel="alternate" title="'.getConfig('site_name').' News feed" href="'.makeUrlNS('Special', 'RSS/news', null, true).'" type="application/rss+xml" />');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    80
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    81
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    82
  if ( $paths->namespace != 'NewsBoy' )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    83
    return;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    84
  
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
    85
  if ( $paths->cpage['urlname_nons'] == 'Portal' || preg_match('/^Archive(\/|$)/', $page->page_id) || preg_match('/^Article\//', $page->page_id) )
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    86
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    87
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    88
    // Add admin opener Javascript function
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    89
    $template->add_header('<!-- NewsBoy: admin panel nav function -->
4
bf5589120afb Fixed bad admin-nav function, which was rendered useless if aggressive_optimize_html is on
Dan
parents: 3
diff changeset
    90
    <enano:no-opt>
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    91
    <script type="text/javascript">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    92
      function newsboy_open_admin()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    93
      {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    94
        if ( auth_level < USER_LEVEL_ADMIN )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    95
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    96
          ajaxPromptAdminAuth(function(k) {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    97
            ENANO_SID = k;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    98
            auth_level = USER_LEVEL_ADMIN;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
    99
            var loc = String(window.location + \'\');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   100
            window.location = append_sid(loc);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   101
            var loc = makeUrlNS(\'Special\', \'Administration\', \'module=\' + namespace_list[\'Admin\'] + \'NewsboyItemManager\');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   102
            if ( (ENANO_SID + \' \').length > 1 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   103
              window.location = loc;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   104
          }, 9);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   105
          return false;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   106
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   107
        var loc = makeUrlNS(\'Special\', \'Administration\', \'module=\' + namespace_list[\'Admin\'] + \'NewsboyItemManager\');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   108
        window.location = loc;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   109
      }
4
bf5589120afb Fixed bad admin-nav function, which was rendered useless if aggressive_optimize_html is on
Dan
parents: 3
diff changeset
   110
    </script>
bf5589120afb Fixed bad admin-nav function, which was rendered useless if aggressive_optimize_html is on
Dan
parents: 3
diff changeset
   111
    </enano:no-opt>');
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   112
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   113
    $x = getConfig('nb_portal_title');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   114
    
9
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   115
    if ( $page->page_id == 'Portal' || $page->page_id == 'Archive' )
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   116
    {
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   117
      $page_name = ( $page->page_id == 'Portal' ) ?
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   118
            ( ( empty($x) ) ?
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   119
                'Welcome to ' . getConfig('site_name') :
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   120
                $x ) :
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   121
            'News Archive';
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   122
      if ( method_exists($template, 'assign_vars') )
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   123
      {
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   124
        $template->assign_vars(array(
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   125
            'PAGE_NAME' => $page_name
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   126
          ));
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   127
      }
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   128
      else
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   129
      {
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   130
        $template->tpl_strings['PAGE_NAME'] = $page_name;
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   131
      }
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   132
    }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   133
    
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   134
    if ( !$page->perms->get_permissions('read') )
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   135
    {
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   136
      $page->err_access_denied();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   137
      return false;
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   138
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   139
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   140
    $paths->cpage['comments_on'] = 0;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   141
    
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   142
    if ( $page->page_id == 'Portal' )
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   143
    {
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   144
      $template->header();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   145
      NewsBoy_portal();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   146
      $template->footer();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   147
    }
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   148
    else if ( preg_match('/^Archive(\/|$)/', $page->page_id) )
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   149
    {
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   150
      $template->header();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   151
      NewsBoy_archive();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   152
      $template->footer();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   153
    }
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   154
    else if ( preg_match('/^Article\//', $page->page_id) )
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   155
    {
9
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   156
      if ( !preg_match('#^Article/([0-9]{4})/([0-9]{1,2})/([0-9]{1,2})/(.+?)$#', $page->page_id, $id_match) )
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   157
      {
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   158
        return;
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   159
      }
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   160
      // look around for this page
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   161
      // int mktime  ([ int $hour  [, int $minute  [, int $second  [, int $month  [, int $day  [, int $year  [, int $is_dst  ]]]]]]] )
9
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   162
      $timestamp_min = gmmktime(0, 0, 0, intval($id_match[2]), intval($id_match[3]), intval($id_match[1]));
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   163
      $timestamp_max = $timestamp_min + 86400;
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   164
      // mysql and postgresql friendly
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   165
      $integer_prepend = ( ENANO_DBLAYER == 'MYSQL' ) ? "unsigned" : '';
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   166
      $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';");
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   167
      if ( !$q )
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   168
        $db->_die();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   169
      if ( $db->numrows() < 1 )
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   170
        return;
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   171
      // found a page
9
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   172
      $found_match = false;
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   173
      while ( $row = $db->fetchrow() )
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   174
      {
9
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   175
        if ( sanitize_page_id($row['name']) === $id_match[4] )
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   176
        {
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   177
          $found_match = true;
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   178
          // we have a definitive match, send the page through
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   179
          $article = new PageProcessor($row['urlname'], 'NewsBoy');
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   180
          $article->send_headers = $page->send_headers;
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   181
          $article->password = $page->password;
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   182
          $article->send(true);
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   183
        }
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   184
      }
9
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   185
      if ( !$found_match )
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   186
      {
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   187
        // can't find it.
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   188
        return;
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   189
      }
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   190
      return;
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   191
    }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   192
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   193
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   194
11
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   195
class Namespace_NewsBoy extends Namespace_Default
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   196
{
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   197
  public $perms;
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   198
  
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   199
  function __construct($a, $b, $c = 0)
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   200
  {
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   201
    global $db, $session, $paths, $template, $plugins; // Common objects
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   202
    
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   203
    parent::__construct($a, $b, $c);
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   204
    $this->perms = $session->fetch_page_acl($this->page_id, $this->namespace);
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   205
  }
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   206
  
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   207
  function send()
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   208
  {
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   209
    NewsBoy_namespace_handler($this);
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   210
  }
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   211
}
b0995e600bde Merged in Namespace_* support; here ends compatibility before 1.1.6 trunk
Dan
parents: 9
diff changeset
   212
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   213
function NewsBoy_set_page_string()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   214
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   215
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   216
  if ( $paths->namespace == 'NewsBoy' )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   217
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   218
    if ( $paths->cpage['urlname_nons'] == 'Portal' )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   219
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   220
      $template->namespace_string = 'portal';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   221
      
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   222
      // block editing
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   223
      $perm_arr = Array('edit_page' => AUTH_DENY, 'view_source' => AUTH_DENY);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   224
      $session->acl_merge_with_current($perm_arr, false, 2);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   225
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   226
    else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   227
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   228
      $template->namespace_string = 'news item';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   229
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   230
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   231
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   232
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   233
function NewsBoy_format_title($title)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   234
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   235
  $title = strtolower($title);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   236
  $title = preg_replace('/\W/', '-', $title);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   237
  $title = preg_replace('/([-]+)/', '-', $title);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   238
  $title = trim($title, '-');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   239
  return $title;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   240
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   241
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   242
function NewsBoy_feed_handler($mode)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   243
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   244
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   245
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   246
  if ( $mode != 'news' )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   247
    return;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   248
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   249
  $limit = ( $x = $paths->getParam(1) ) ? $x : 20;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   250
  $limit = intval($limit);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   251
  if ( $limit > 50 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   252
    $limit = 50;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   253
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   254
  $title = getConfig('site_name') . ': Site news';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   255
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   256
  $x = getConfig('nb_portal_title');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   257
  $desc = ( empty($x) ) ? 'Welcome to ' . getConfig('site_name') : $x;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   258
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   259
  $link = makeUrlComplete('NewsBoy', 'Portal');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   260
  $generator = 'Enano CMS ' . enano_version() . ' - NewsBoy plugin';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   261
  $email = getConfig('contact_email');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   262
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   263
  $rss = new RSS($title, $desc, $link, $generator, $email);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   264
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   265
  $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
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   266
         LEFT JOIN '.table_prefix.'comments AS c
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   267
           ON ( c.page_id=p.urlname AND c.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   268
         LEFT JOIN '.table_prefix.'logs AS l
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   269
           ON ( l.page_id=p.urlname AND l.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   270
         LEFT JOIN '.table_prefix.'users AS u
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   271
           ON ( u.username=l.author )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   272
         LEFT JOIN '.table_prefix.'page_text AS t
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   273
           ON ( t.page_id=p.urlname AND t.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   274
         WHERE p.namespace=\'NewsBoy\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   275
           AND l.action=\'create\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   276
           AND p.urlname REGEXP \'^([0-9]+)$\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   277
           AND p.visible=1
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   278
         GROUP BY p.urlname
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   279
         ORDER BY urlname DESC
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   280
         LIMIT '.$limit.';';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   281
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   282
  $q = $db->sql_unbuffered_query($sql);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   283
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   284
  if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   285
    $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   286
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   287
  $formatter = new NewsBoyFormatter();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   288
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   289
  if ( $row = $db->fetchrow() )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   290
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   291
    do {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   292
      
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   293
      $title = $row['name'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   294
      $link = makeUrlComplete('NewsBoy', $row['urlname']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   295
      $desc = RenderMan::render($row['page_text']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   296
      $time = intval($row['urlname']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   297
      
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   298
      $rss->add_item($title, $link, $desc, $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   299
      
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   300
    } while ( $row = $db->fetchrow() );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   301
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   302
  else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   303
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   304
    $rss->add_item('Error', $link, 'No news items yet.', time());
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   305
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   306
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   307
  echo $rss->render();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   308
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   309
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   310
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   311
function NewsBoy_portal()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   312
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   313
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   314
  
5
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   315
  if ( file_exists( ENANO_ROOT . "/themes/{$template->theme}/newsboy-post.tpl" ) )
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   316
  {
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   317
    $parser = $template->makeParser("newsboy-post.tpl");
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   318
  }
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   319
  else
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   320
  {
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   321
    $news_template = <<<TPLCODE
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   322
    <div class="tblholder news">
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   323
      <table border="0" cellspacing="1" cellpadding="4" style="width: 100%;">
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   324
        <tr>
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   325
          <th><a href="{LINK}" style="color: inherit;">{TITLE}</a></th>
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   326
        </tr>
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   327
        <tr>
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   328
          <td class="row3">
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   329
            {CONTENT}
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   330
          </td>
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   331
        </tr>
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   332
        <tr>
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   333
          <th class="subhead" style="font-weight: normal; font-size: 67%;">
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   334
            Posted by {USER_LINK} on {DATE}<br />
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   335
            [ {NUM_COMMENTS} comment{COMMENT_S} | {COMMENT_LINK} ]
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   336
          </th>
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   337
        </tr>
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   338
      </table>
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   339
    </div>
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   340
TPLCODE;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   341
  
5
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   342
    $parser = $template->makeParserText($news_template);
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   343
  }
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   344
  
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   345
  /*
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   346
  $p = RenderMan::strToPageID(getConfig('main_page'));
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   347
  if ( $p[1] != 'NewsBoy' )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   348
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   349
    echo RenderMan::getPage($p[0], $p[1]);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   350
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   351
  else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   352
  { */
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   353
    /*
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   354
    $s = $paths->nslist['NewsBoy'] . 'Announce';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   355
    if ( isPage($s) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   356
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   357
      $p = RenderMan::getPage('Announce', 'NewsBoy');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   358
      echo $p;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   359
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   360
  /* } */
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   361
  
6
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   362
  $announce_page_default = $paths->nslist['NewsBoy'] . 'Announce';
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   363
  $s = $announce_page_default;
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   364
  $announce_page = getConfig('nb_announce_page');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   365
  if ( !empty($announce_page) && isPage($announce_page) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   366
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   367
    $s = $announce_page;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   368
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   369
  else if ( !isPage($s) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   370
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   371
    $s = false;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   372
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   373
  if ( $s )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   374
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   375
    $stuff = RenderMan::strToPageID($s);
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   376
    // Hackish fix to prevent the categorization button and other stuff from being displayed
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   377
    $paths->pages[$s]['special'] = 1;
1
540d077b7612 Fix stupid announcement link bug; replace getPage call with PageProcessor
Dan
parents: 0
diff changeset
   378
    $page = new PageProcessor($stuff[0], $stuff[1]);
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   379
    $content = $page->fetch_text();
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   380
    $content = '?>' . RenderMan::render($content);
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   381
    eval($content);
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   382
  }
6
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   383
  else
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   384
  {
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   385
    $stuff = RenderMan::strToPageID($announce_page_default);
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   386
  }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   387
  
5
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   388
  if ( file_exists( ENANO_ROOT . "/themes/{$template->theme}/newsboy-portal-pre.tpl" ) )
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   389
  {
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   390
    $parser_pre = $template->makeParser("newsboy-portal-pre.tpl");
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   391
    echo $parser_pre->run();
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   392
  }
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   393
  else
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   394
  {
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   395
    echo '<h2>Latest news</h2>';
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   396
  }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   397
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   398
  $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
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   399
         LEFT JOIN '.table_prefix.'comments AS c
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   400
           ON ( c.page_id=p.urlname AND c.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   401
         LEFT JOIN '.table_prefix.'page_text AS t
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   402
           ON ( t.page_id=p.urlname AND t.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   403
         LEFT JOIN '.table_prefix.'logs AS l
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   404
           ON ( l.page_id=p.urlname AND l.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   405
         LEFT JOIN '.table_prefix.'users AS u
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   406
           ON ( u.username=l.author OR u.user_id=1 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   407
         WHERE p.namespace=\'NewsBoy\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   408
           AND l.action=\'create\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   409
           AND p.urlname!=\'Announce\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   410
           AND p.visible=1
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   411
         GROUP BY p.urlname
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   412
         ORDER BY urlname DESC;');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   413
  if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   414
    $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   415
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   416
  if ( $row = $db->fetchrow() )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   417
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   418
    $i = 0;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   419
    do
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   420
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   421
      if ( $i < 5 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   422
      {
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   423
        $content = $row['page_text'];
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   424
        
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   425
        $trimmed = false;
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   426
        if ( $pos = strpos($content, '<!--BREAK-->' ) )
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   427
        {
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   428
          $content = substr($content, 0, $pos);
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   429
          $trimmed = true;
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   430
        }
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   431
        
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   432
        $title = htmlspecialchars($row['name']);
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   433
        $content = RenderMan::render($content);
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   434
        
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   435
        if ( strlen($content) > 400 && !$trimmed )
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   436
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   437
          $content = nb_trim_paragraph($content, 400, $trimmed);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   438
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   439
        if ( $trimmed )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   440
        {
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   441
          $link = ' <a href="' . makeUrlNS('NewsBoy', $row['urlname'], false, true) . '">Read more...</a>';
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   442
          $content = preg_replace('/(.+?)<\/(p|ul|table|div|pre)>([\s]*?)$/Usi', '\\1' . $link . '</\\2>\\3', $content, 1);
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   443
          if ( !strstr($content, $link) )
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   444
          {
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   445
            $content .= $link;
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   446
          }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   447
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   448
        $user_link = nb_make_username_link($row['author'], $row['user_level']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   449
        $date = date('F d, Y h:i:s a', $row['urlname']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   450
        $num_comments = $row['num_comments'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   451
        $comment_s = ( $num_comments == 1 ) ? '' : 's';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   452
        $comment_link = '<a href="' . makeUrlNS('NewsBoy', $row['urlname'], false, true) . '#do:comments" style="color: inherit;">add a comment</a>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   453
        $parser->assign_vars(array(
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   454
            'TITLE' => $title,
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   455
            'LINK' => nb_make_article_url($row['urlname'], $row['name']),
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   456
            'CONTENT' => $content,
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   457
            'USER_LINK' => $user_link,
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   458
            'DATE' => $date,
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   459
            'NUM_COMMENTS' => $num_comments,
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   460
            'COMMENT_S' => $comment_s,
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   461
            'COMMENT_LINK' => $comment_link
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   462
          ));
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   463
        echo $parser->run();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   464
      }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   465
      else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   466
      {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   467
        echo '<p><a href="'.makeUrlNS('NewsBoy', 'Archive').'">Older news...</a></p>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   468
        break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   469
      }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   470
      $i++;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   471
    } while ( $row = $db->fetchrow() );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   472
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   473
  else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   474
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   475
    echo '<p>No news items yet.</p>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   476
  }
9
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
   477
  $db->free_result();
5
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   478
  if ( file_exists( ENANO_ROOT . "/themes/{$template->theme}/newsboy-portal-post.tpl" ) )
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   479
  {
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   480
    $parser_post = $template->makeParser("newsboy-portal-post.tpl");
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   481
    echo $parser_post->run();
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   482
  }
fed61fc8895b Added support for a custom template (newsboy-post.tpl) and templates to be shown before and after news content
Dan
parents: 4
diff changeset
   483
  
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   484
  if ( $session->user_level >= USER_LEVEL_ADMIN )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   485
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   486
    echo '<div class="tblholder" style="margin: 10px auto 0 auto; display: table;">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   487
            <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   488
              <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   489
                <th>Administrative tools:</th>
3
8ae9acb2e919 Re-implement announcement link fix, blame it on my bad Hg repo management
Dan
parents: 2
diff changeset
   490
                <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>
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   491
                <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>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   492
              </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   493
            </table>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   494
          </div><br />';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   495
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   496
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   497
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   498
/**
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   499
 * Formats row data in the archive.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   500
 * @package Enano
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   501
 * @subpackage Newsboy
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   502
 * @license GNU General Public License
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   503
 */
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   504
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   505
class NewsBoyFormatter
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   506
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   507
  function article_link($name, $row)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   508
  {
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   509
    $article_link = '<a href="' . nb_make_article_url($row['urlname'], $row['name']) . '">' . $row['name'] . '</a>';
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   510
    return $article_link;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   511
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   512
  function format_date($date, $row)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   513
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   514
    $date = date('Y-m-j g:m', intval ( $date ));
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   515
    return $date;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   516
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   517
  function format_username($x, $row)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   518
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   519
    $ul = intval($row['user_level']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   520
    $author = nb_make_username_link($row['author'], $ul);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   521
    return $author;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   522
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   523
  function format_commentlink($x, $row)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   524
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   525
    $comments = '<a href="' . makeUrlNS('NewsBoy', $row['urlname']) . '#do:comments">' . $row['num_comments'] . '</a>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   526
    return $comments;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   527
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   528
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   529
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   530
function NewsBoy_archive()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   531
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   532
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   533
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   534
  $lower_limit = ( isset($_GET['start']) ) ? intval($_GET['start']) : ( ( $xx = $paths->getParam(0) ) ? intval($xx) : 0 );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   535
  $entries_per_page = 50;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   536
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   537
  $row_count = $entries_per_page + 1;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   538
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   539
  // Determine number of total news entries
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   540
  $q = $db->sql_query('SELECT urlname FROM '.table_prefix.'pages WHERE namespace=\'NewsBoy\' AND urlname REGEXP \'^([0-9]+)$\' AND visible=1;');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   541
  if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   542
    $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   543
  $r = $db->fetchrow();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   544
  $num_total = intval($db->numrows());
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   545
  $db->free_result();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   546
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   547
  if ( $lower_limit >= $num_total )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   548
    $lower_limit = 0;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   549
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   550
  $sql = 'SELECT p.*, l.time_id, l.author, u.user_level,COUNT(c.comment_id) AS num_comments FROM '.table_prefix.'pages AS p
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   551
         LEFT JOIN '.table_prefix.'comments AS c
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   552
           ON ( c.page_id=p.urlname AND c.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   553
         LEFT JOIN '.table_prefix.'logs AS l
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   554
           ON ( l.page_id=p.urlname AND l.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   555
         LEFT JOIN '.table_prefix.'users AS u
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   556
           ON ( u.username=l.author )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   557
         WHERE p.namespace=\'NewsBoy\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   558
           AND l.action=\'create\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   559
           AND p.urlname REGEXP \'^([0-9]+)$\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   560
           AND p.visible=1
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   561
         GROUP BY p.urlname
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   562
         ORDER BY urlname DESC;';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   563
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   564
  $q = $db->sql_unbuffered_query($sql);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   565
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   566
  if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   567
    $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   568
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   569
  $formatter = new NewsBoyFormatter();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   570
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   571
  $callers = Array(
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   572
      'name' => Array($formatter, 'article_link'),
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   573
      'urlname' => Array($formatter, 'format_date'),
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   574
      'author' => Array($formatter, 'format_username'),
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   575
      'num_comments' => Array($formatter, 'format_commentlink')
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   576
    );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   577
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   578
  $head = '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   579
          <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   580
            <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   581
              <th>Article</th><th>Date</th><th>Author</th><th>Comments</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   582
            </tr>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   583
  $foot = "</table></div>";
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   584
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   585
  $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>',
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   586
                      $num_total, makeUrlNS('NewsBoy', 'Archive/%s'), $lower_limit, 20, $callers, $head, $foot);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   587
  echo $content;  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   588
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   589
  $code = $plugins->setHook('send_page_footers');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   590
  foreach ( $code as $cmd )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   591
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   592
    eval($cmd);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   593
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   594
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   595
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   596
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   597
function nb_make_username_link($username, $user_level)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   598
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   599
  $color = '#0000AA';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   600
  $user_level = intval($user_level);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   601
  if ( $user_level < USER_LEVEL_MEMBER ) return $username;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   602
  if ( $user_level >= USER_LEVEL_MOD ) $color = '#00AA00';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   603
  if ( $user_level >= USER_LEVEL_ADMIN ) $color = '#AA0000';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   604
  $link = '<a style="color: ' . $color . '" href="' . makeUrlNS('User', str_replace(' ', '_', $username) ) . '">' . $username . '</a>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   605
  return $link;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   606
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   607
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   608
function NewsBoy_PortalLink()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   609
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   610
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   611
  if ( $paths->namespace == 'NewsBoy' )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   612
    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 />';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   613
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   614
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   615
// Administration panel
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   616
function page_Admin_NewsboyItemManager()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   617
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   618
  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'); }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   619
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   620
  $done = false;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   621
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   622
  if ( isset( $_GET['act'] ) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   623
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   624
    switch ( $_GET['act'] )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   625
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   626
      case 'edit':
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   627
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   628
        // Error list
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   629
        $errors = Array();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   630
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   631
        if ( isset ( $_POST['submitting'] ) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   632
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   633
          // Generate timestamp
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   634
          $year = intval($_POST['pub_year']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   635
          $month = intval($_POST['pub_month']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   636
          $day = intval($_POST['pub_day']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   637
          $hour = intval($_POST['pub_hour']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   638
          $minute = intval($_POST['pub_minute']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   639
          $second = intval($_POST['pub_second']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   640
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   641
          // Validation
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   642
          if ( $year < 1500 || $year > 10000 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   643
            $errors[] = 'Invalid year.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   644
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   645
          if ( $month < 1 || $month > 12 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   646
            $errors[] = 'Invalid month.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   647
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   648
          if ( $day < 1 || $day > 31 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   649
            $errors[] = 'Invalid day.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   650
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   651
          if ( $hour < 0 || $hour > 23 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   652
            $errors[] = 'Invalid hour.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   653
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   654
          if ( $minute < 0 || $minute > 60 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   655
            $errors[] = 'Invalid minute.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   656
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   657
          if ( $second < 0 || $second > 60 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   658
            $errors[] = 'Invalid second.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   659
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   660
          $name = $_POST['article_name'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   661
          $name = $db->escape($name);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   662
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   663
          $author = $_POST['author'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   664
          $author = $db->escape($author);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   665
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   666
          if ( count($errors) < 1 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   667
          {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   668
            $time = mktime($hour, $minute, $second, $month, $day, $year);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   669
          }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   670
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   671
          if ( isset($paths->pages[ $paths->nslist['NewsBoy'] . $time ]) && $paths->pages[ $paths->nslist['NewsBoy'] . $time ] != $paths->pages[ $paths->nslist['NewsBoy'] . $_POST['page_id'] ] )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   672
            $errors[] = 'You cannot have two news articles with the same publish time.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   673
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   674
          if ( count($errors) < 1 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   675
          {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   676
            $publ = ( isset($_POST['published']) ) ? '1' : '0';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   677
            $sql = 'UPDATE '.table_prefix.'pages SET name=\'' . $name . '\',visible='.$publ.',urlname=\''.$time.'\' WHERE urlname=\'' . $db->escape($_POST['page_id']) . '\' AND namespace=\'NewsBoy\';';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   678
            $q = $db->sql_query($sql);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   679
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   680
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   681
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   682
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   683
            // Update author
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   684
            $q = $db->sql_query('UPDATE '.table_prefix.'logs SET author=\'' . $author . '\' WHERE page_id=\'' . $db->escape($_POST['page_id']) . '\' AND namespace=\'NewsBoy\' AND action=\'create\';');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   685
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   686
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   687
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   688
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   689
            // Update other tables with urlname info
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   690
            $q = $db->sql_query('UPDATE '.table_prefix.'logs SET page_id=\'' . $time . '\' WHERE page_id=\'' . $db->escape($_POST['page_id']) . '\' AND namespace=\'NewsBoy\';');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   691
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   692
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   693
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   694
            $q = $db->sql_query('UPDATE '.table_prefix.'comments SET page_id=\'' . $time . '\' WHERE page_id=\'' . $db->escape($_POST['page_id']) . '\' AND namespace=\'NewsBoy\';');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   695
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   696
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   697
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   698
            $q = $db->sql_query('UPDATE '.table_prefix.'page_text SET page_id=\'' . $time . '\' WHERE page_id=\'' . $db->escape($_POST['page_id']) . '\' AND namespace=\'NewsBoy\';');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   699
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   700
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   701
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   702
            $q = $db->sql_query('UPDATE '.table_prefix.'categories SET page_id=\'' . $time . '\' WHERE page_id=\'' . $db->escape($_POST['page_id']) . '\' AND namespace=\'NewsBoy\';');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   703
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   704
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   705
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   706
            echo '<div class="info-box">Your changes have been saved.</div>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   707
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   708
            break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   709
          }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   710
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   711
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   712
        if ( count($errors) > 0 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   713
          echo '<div class="warning-box">Errors encountered while saving data:<ul><li>' . implode('</li><li>', $errors) . '</li></ul></div>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   714
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   715
        // Obtain page information
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   716
        if ( !isset($paths->pages[ $paths->nslist['NewsBoy'] . $_GET['id'] ]) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   717
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   718
          echo 'Invalid ID';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   719
          return false;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   720
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   721
        $page_info =& $paths->pages[ $paths->nslist['NewsBoy'] . $_GET['id'] ];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   722
        $time = intval($page_info['urlname_nons']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   723
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   724
        // Get author
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   725
        $q = $db->sql_query('SELECT author FROM '.table_prefix.'logs WHERE page_id=\'' . $db->escape($page_info['urlname_nons']) . '\' AND namespace=\'NewsBoy\' AND action=\'create\' ORDER BY time_id DESC LIMIT 1;');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   726
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   727
        if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   728
          $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   729
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   730
        $row = $db->fetchrow();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   731
        $author = ( isset($row['author']) ) ? $row['author'] : '';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   732
        if ( empty($author) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   733
          $author = 'Anonymous';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   734
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   735
        // Set date & time
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   736
        $month  = date('n', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   737
        $year   = date('Y', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   738
        $day    = date('j', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   739
        $hour   = date('G', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   740
        $minute = date('m', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   741
        $second = date('s', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   742
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   743
        echo '<form id="nb_edit_form" action="'.makeUrlNS('Special', 'Administration', (( isset($_GET['sqldbg'])) ? 'sqldbg&amp;' : '') .'module='.$paths->cpage['module'] . '&act=edit').'" method="post" onsubmit="if ( !submitAuthorized ) return false;">';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   744
        echo '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   745
                <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   746
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   747
                    <th colspan="2">Editing news article</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   748
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   749
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   750
                    <td class="row1">Article name:</td><td class="row2"><input name="article_name" value="' . htmlspecialchars($page_info['name']) . '" /></td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   751
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   752
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   753
                    <td class="row1">Published date:</td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   754
                    <td class="row2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   755
                      <input name="pub_year" type="text" size="5" value="'.$year.'" />-<select name="pub_month">';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   756
       for ( $i = 1; $i <= 12; $i++ )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   757
       {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   758
         $m = "[$i] ";
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   759
         switch ( $i )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   760
         {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   761
           case 1:  $m .= 'January'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   762
           case 2:  $m .= 'February'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   763
           case 3:  $m .= 'March'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   764
           case 4:  $m .= 'April'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   765
           case 5:  $m .= 'May'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   766
           case 6:  $m .= 'June'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   767
           case 7:  $m .= 'July'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   768
           case 8:  $m .= 'August'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   769
           case 9:  $m .= 'September'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   770
           case 10: $m .= 'October'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   771
           case 11: $m .= 'November'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   772
           case 12: $m .= 'December'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   773
           default: $m .= 'Fuhrober'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   774
         }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   775
         if ( $month == $i )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   776
           echo '         <option selected="selected" value="' . $i . '">'.$m.'</option>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   777
         else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   778
           echo '         <option value="' . $i . '">'.$m.'</option>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   779
       }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   780
       echo '         </select>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   781
                      <input name="pub_day" type="text" size="3" value="' . $day . '" />, time:
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   782
                      <input name="pub_hour" type="text" size="3" value="' . $hour . '" />&nbsp;:&nbsp;<input name="pub_minute" type="text" size="3" value="' . $minute . '" />&nbsp;:&nbsp;<input name="pub_second" type="text" size="3" value="' . $second . '" /><br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   783
                      <small>Note: Hours are in 24-hour format.</small>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   784
                    </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   785
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   786
                  <!-- Inline developer blog, episode 1:
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   787
                       Right about the time I got here, I started sneezing like crazy. Must have caught it Friday night. Great... now
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   788
                       my life is officially stuck on pause for the next 3 days. I\'d swear here but (a) Mommy taught me better, and
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   789
                       (b) I wouldn\'t want to offend you hackers. (j/k)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   790
                       
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   791
                       Oh crap. And no, I don\'t give towels with my showers.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   792
                       
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   793
                       -Dan
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   794
                       -->
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   795
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   796
                    <td class="row1">Publish article:</td><td class="row2"><label><input name="published" type="checkbox" ' . ( $page_info['visible'] == 1 ? 'checked="checked"' : '' ) . ' /> Article is published (shown to the public)</label></td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   797
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   798
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   799
                    <td class="row1">Article author:</td><td class="row2">' . $template->username_field('author', $author) . '</td></tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   800
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   801
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   802
                    <td class="row3" style="text-align: center;" colspan="2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   803
                      <a href="#" onclick="var frm = document.getElementById(\'nb_edit_form\'); frm.submit(); return false;">Save changes</a>&nbsp;&nbsp;<a href="#" onclick="ajaxPage(\'' . $paths->cpage['module'] . '\');">Return to main menu</a>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   804
                    </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   805
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   806
                </table>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   807
              </div>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   808
              <input type="hidden" name="submitting" value="yes" />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   809
              <input type="hidden" name="page_id" value="' . $_GET['id'] . '" />';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   810
        echo '</form>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   811
        $done = true;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   812
        break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   813
      case 'del':
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   814
        if ( isset( $_POST['confirmed'] ) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   815
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   816
          $page_id = $_POST['page_id'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   817
          $namespace = 'NewsBoy';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   818
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   819
          $e = $db->sql_query('INSERT INTO '.table_prefix.'logs(time_id,date_string,log_type,action,page_id,namespace,author) VALUES('.time().', \''.date('d M Y h:i a').'\', \'page\', \'delete\', \''.$page_id.'\', \''.$namespace.'\', \''.$session->username.'\')');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   820
          if(!$e) $db->_die('The page log entry could not be inserted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   821
          $e = $db->sql_query('DELETE FROM '.table_prefix.'categories WHERE page_id=\''.$page_id.'\' AND namespace=\''.$namespace.'\'');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   822
          if(!$e) $db->_die('The page categorization entries could not be deleted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   823
          $e = $db->sql_query('DELETE FROM '.table_prefix.'comments WHERE page_id=\''.$page_id.'\' AND namespace=\''.$namespace.'\'');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   824
          if(!$e) $db->_die('The page comments could not be deleted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   825
          $e = $db->sql_query('DELETE FROM '.table_prefix.'page_text WHERE page_id=\''.$page_id.'\' AND namespace=\''.$namespace.'\'');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   826
          if(!$e) $db->_die('The page text entry could not be deleted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   827
          $e = $db->sql_query('DELETE FROM '.table_prefix.'pages WHERE urlname=\''.$page_id.'\' AND namespace=\''.$namespace.'\'');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   828
          if(!$e) $db->_die('The page entry could not be deleted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   829
          $e = $db->sql_query('DELETE FROM '.table_prefix.'files WHERE page_id=\''.$page_id.'\'');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   830
          if(!$e) $db->_die('The file entry could not be deleted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   831
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   832
          $result = 'This page has been deleted. Note that there is still a log of edits and actions in the database, and anyone with admin rights can raise this page from the dead unless the log is cleared. If the deleted file is an image, there may still be cached thumbnails of it in the cache/ directory, which is inaccessible to users.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   833
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   834
          echo $result . '<br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   835
               <br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   836
               <a href="#" onclick="ajaxPage(\'' . $paths->cpage['module'] . '\');">Return to Newsboy</a>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   837
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   838
        else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   839
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   840
          echo '<form id="nb_delete_form" action="'.makeUrlNS('Special', 'Administration', (( isset($_GET['sqldbg'])) ? 'sqldbg&amp;' : '') .'module='.$paths->cpage['module'] . '&act=del').'" method="post">';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   841
          echo '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   842
                  <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   843
                    <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   844
                      <th>Confirm deletion</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   845
                     </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   846
                     <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   847
                       <td class="row1" style="text-align: center;">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   848
                         <p>Are you sure you want to delete this news article?</p>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   849
                       </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   850
                     </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   851
                     <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   852
                       <td class="row3" style="text-align: center;">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   853
                         <a href="#" onclick="var frm = document.getElementById(\'nb_delete_form\'); frm.submit(); return false;">Delete</a>&nbsp;&nbsp;<a href="#" onclick="ajaxPage(\'' . $paths->cpage['module'] . '\');">Cancel</a>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   854
                       </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   855
                     </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   856
                  </table>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   857
                </div>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   858
                <input type="hidden" name="confirmed" value="yes" />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   859
                <input type="hidden" name="page_id" value="' . intval ( $_GET['id'] ) . '" />';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   860
          echo '</form>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   861
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   862
        $done = true;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   863
        break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   864
      case 'create':
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   865
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   866
        // Error list
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   867
        $errors = Array();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   868
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   869
        if ( isset ( $_POST['submitting'] ) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   870
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   871
          // Generate timestamp
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   872
          $year = intval($_POST['pub_year']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   873
          $month = intval($_POST['pub_month']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   874
          $day = intval($_POST['pub_day']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   875
          $hour = intval($_POST['pub_hour']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   876
          $minute = intval($_POST['pub_minute']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   877
          $second = intval($_POST['pub_second']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   878
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   879
          // Validation
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   880
          if ( $year < 1500 || $year > 10000 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   881
            $errors[] = 'Invalid year.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   882
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   883
          if ( $month < 1 || $month > 12 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   884
            $errors[] = 'Invalid month.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   885
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   886
          if ( $day < 1 || $day > 31 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   887
            $errors[] = 'Invalid day.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   888
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   889
          if ( $hour < 0 || $hour > 23 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   890
            $errors[] = 'Invalid hour.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   891
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   892
          if ( $minute < 0 || $minute > 60 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   893
            $errors[] = 'Invalid minute.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   894
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   895
          if ( $second < 0 || $second > 60 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   896
            $errors[] = 'Invalid second.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   897
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   898
          $name = $_POST['article_name'];
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   899
          // This is db-escaped by PageUtils
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   900
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   901
          $author = $_POST['author'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   902
          $author = $db->escape($author);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   903
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   904
          if ( count($errors) < 1 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   905
          {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   906
            $time = mktime($hour, $minute, $second, $month, $day, $year);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   907
          }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   908
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   909
          if ( isset($paths->pages[ $paths->nslist['NewsBoy'] . $time ]) && $paths->pages[ $paths->nslist['NewsBoy'] . $time ] != $paths->pages[ $paths->nslist['NewsBoy'] . $_POST['page_id'] ] )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   910
            $errors[] = 'You cannot have two news articles with the same publish time.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   911
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   912
          if ( count($errors) < 1 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   913
          {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   914
            $publ = ( isset($_POST['published']) ) ? 1 : 0;
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   915
            
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   916
            $result = PageUtils::createpage( (string)$time, 'NewsBoy', $name, $publ );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   917
            
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   918
            if ( $result == 'good' )
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   919
            {
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   920
              // Set content
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   921
              $content = RenderMan::preprocess_text($_POST['content'], true); // this also SQL-escapes it
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   922
              
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   923
              $q = $db->sql_query('UPDATE '.table_prefix.'page_text SET page_text=\'' . $content . '\' WHERE page_id=\'' . $time . '\' AND namespace=\'NewsBoy\';');
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   924
              if ( !$q )
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   925
                $db->_die();
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   926
              
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   927
              if ( $result )
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   928
                echo '<div class="info-box">Your changes have been saved.</div>';
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   929
              else
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   930
                $errors[] = 'PageUtils::createpage returned an error.';
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   931
            }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   932
            else
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   933
            {
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   934
              $errors[] = 'PageUtils::createpage returned an error: ' . htmlspecialchars($result);
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   935
            }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   936
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   937
            break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   938
          }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   939
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   940
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   941
        if ( count($errors) > 0 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   942
          echo '<div class="warning-box">Errors encountered while preparing data:<ul><li>' . implode('</li><li>', $errors) . '</li></ul></div>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   943
        
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   944
        $time = time();
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   945
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   946
        // Get author
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   947
        $author = $session->username;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   948
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   949
        if ( empty($author) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   950
          $author = 'Anonymous';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   951
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   952
        // Set date & time
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   953
        $month  = date('n', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   954
        $year   = date('Y', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   955
        $day    = date('j', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   956
        $hour   = date('G', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   957
        $minute = date('m', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   958
        $second = date('s', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   959
        
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   960
        echo '<form id="nb_create_form" action="'.makeUrlNS('Special', 'Administration', (( isset($_GET['sqldbg'])) ? 'sqldbg&' : '') .'module='.$paths->cpage['module'] . '&act=create').'" method="post" onsubmit="if ( !submitAuthorized ) return false;">';
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   961
        echo '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   962
                <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   963
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   964
                    <th colspan="2">Creating news article</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   965
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   966
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   967
                    <td class="row1">Article name:</td><td class="row2"><input name="article_name" value="" /></td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   968
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   969
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   970
                    <td class="row1">Published datestamp:</td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   971
                    <td class="row2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   972
                      <input name="pub_year" type="text" size="5" value="'.$year.'" />-<select name="pub_month">';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   973
       for ( $i = 1; $i <= 12; $i++ )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   974
       {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   975
         $m = "[$i] ";
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   976
         switch ( $i )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   977
         {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   978
           case 1:  $m .= 'January'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   979
           case 2:  $m .= 'February'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   980
           case 3:  $m .= 'March'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   981
           case 4:  $m .= 'April'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   982
           case 5:  $m .= 'May'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   983
           case 6:  $m .= 'June'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   984
           case 7:  $m .= 'July'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   985
           case 8:  $m .= 'August'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   986
           case 9:  $m .= 'September'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   987
           case 10: $m .= 'October'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   988
           case 11: $m .= 'November'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   989
           case 12: $m .= 'December'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   990
           default: $m .= 'Fuhrober'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   991
         }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   992
         if ( $month == $i )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   993
           echo '         <option selected="selected" value="' . $i . '">'.$m.'</option>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   994
         else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   995
           echo '         <option value="' . $i . '">'.$m.'</option>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   996
       }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   997
       echo '         </select>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   998
                      <input name="pub_day" type="text" size="3" value="' . $day . '" />, time:
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   999
                      <input name="pub_hour" type="text" size="3" value="' . $hour . '" />&nbsp;:&nbsp;<input name="pub_minute" type="text" size="3" value="' . $minute . '" />&nbsp;:&nbsp;<input name="pub_second" type="text" size="3" value="' . $second . '" /><br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1000
                      <small>Note: Hours are in 24-hour format.</small>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1001
                    </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1002
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1003
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1004
                    <td class="row1">Publish article:</td><td class="row2"><label><input name="published" type="checkbox" /> Article is published (shown to the public)</label></td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1005
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1006
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1007
                    <td class="row1">Article author:</td><td class="row2">' . $template->username_field('author', $author) . '</td></tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1008
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1009
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1010
                    <td class="row1">Initial content:<br /><small>You can always edit this later.</small></td><td class="row2"><textarea name="content" rows="15" cols="60" style="width: 100%;"></textarea></td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1011
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1012
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1013
                    <td class="row3" style="text-align: center;" colspan="2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1014
                      <a href="#" onclick="var frm = document.getElementById(\'nb_create_form\'); frm.submit(); return false;">Create article</a>&nbsp;&nbsp;<a href="#" onclick="ajaxPage(\'' . $paths->cpage['module'] . '\');">Return to main menu</a>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1015
                    </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1016
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1017
                </table>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1018
              </div>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1019
              <input type="hidden" name="submitting" value="yes" />';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1020
        echo '</form>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1021
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1022
        $done = true;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1023
        break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1024
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1025
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1026
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1027
  if ( !$done )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1028
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1029
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1030
    // Start output
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1031
    echo '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1032
      <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1033
        <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1034
          <th>Name</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1035
          <th>Date published</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1036
          <th colspan="3">Actions</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1037
        </tr>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1038
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1039
    $row_class = 'row2';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1040
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1041
    // List existing news entries
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1042
    $q = $db->sql_query('SELECT name,urlname FROM '.table_prefix.'pages WHERE namespace="NewsBoy" AND urlname!="Announce" ORDER BY name ASC;');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1043
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1044
    if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1045
      $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1046
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1047
    if ( $row = $db->fetchrow($q) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1048
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1049
      do {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1050
        $row_class = ( $row_class == 'row1' ) ? 'row2' : 'row1';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1051
        $ts = intval($row['urlname']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1052
        $date = date('F d, Y h:i a', $ts);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1053
        $edit_url = makeUrlNS('Special', 'Administration', "module={$paths->cpage['module']}&act=edit&id={$row['urlname']}", true);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1054
        $dele_url = makeUrlNS('Special', 'Administration', "module={$paths->cpage['module']}&act=del&id={$row['urlname']}", true);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1055
        $page_url = makeUrlNS('NewsBoy', $row['urlname']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1056
        echo "<tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1057
                <td class='$row_class' style='width: 50%;'>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1058
                  {$row['name']}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1059
                </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1060
                <td class='$row_class' style='width: 40%;'>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1061
                  $date
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1062
                </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1063
                <td class='$row_class'>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1064
                  <a href='$edit_url'>Settings</a>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1065
                </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1066
                <td class='$row_class'>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1067
                  <a href='$page_url' onclick='window.open(this.href); return false;'>Page</a>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1068
                </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1069
                <td class='$row_class'>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1070
                  <a href='$dele_url'>Delete</a>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1071
                </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1072
              </tr>";
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1073
      } while ( $row = $db->fetchrow($q) );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1074
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1075
    else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1076
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1077
      echo '<tr><td class="row3" colspan="5" style="text-align: center;">No news items yet.</td></tr>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1078
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1079
    echo '<tr><th class="subhead" colspan="5"><a href="' . makeUrlNS('Special', 'Administration', "module={$paths->cpage['module']}&act=create", true) . '" style="color: inherit;">Create new entry</a></th></tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1080
          </table></div>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1081
    $db->free_result();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1082
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1083
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1084
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1085
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1086
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1087
function page_Admin_NewsboyConfiguration()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1088
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1089
  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'); }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1090
  if ( isset($_POST['submit']) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1091
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1092
    setConfig('nb_portal_title', $_POST['portal_name']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1093
    if ( isPage($_POST['announce_page']) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1094
      setConfig('nb_announce_page', $_POST['announce_page']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1095
    else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1096
      setConfig('nb_announce_page', '');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1097
    // Submit
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1098
    echo '<div class="info-box">Your changes have been saved.</div>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1099
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1100
  echo '<form name="main" action="'.htmlspecialchars(makeUrl($paths->nslist['Special'].'Administration', 'module='.$paths->cpage['module'])).'" method="post">';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1101
  echo '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1102
          <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1103
            <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1104
              <th colspan="2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1105
                Newsboy portal: General configuration
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1106
              </th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1107
            </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1108
            <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1109
              <td class="row2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1110
                Portal title:<br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1111
                <small>This is the text that will be shown as the page title on the<br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1112
                portal. If you don\'t enter anything here, a default will be used.</small>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1113
              </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1114
              <td class="row1"><input type="text" size="30" name="portal_name" value="' . htmlspecialchars(getConfig('nb_portal_title')) . '"></td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1115
            </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1116
            <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1117
              <td class="row2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1118
                Page to embed as announcement:<br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1119
                <small>The page you enter here will always be shown at the top of the<br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1120
                portal. The default is "' . $paths->nslist['NewsBoy'] . 'Announce".</small>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1121
              </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1122
              <td class="row1">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1123
                ' . $template->pagename_field('announce_page', htmlspecialchars(getConfig('nb_announce_page'))) . '
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1124
              </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1125
            </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1126
            <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1127
              <th class="subhead" colspan="2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1128
                <input type="submit" name="submit" value="Save changes" />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1129
              </th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1130
            </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1131
          </table>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1132
        </div>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1133
  echo '</form>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1134
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1135
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1136
/**
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1137
 * Trims a wad of text to the specified length.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1138
 * @todo make HTML friendly (don't break tags)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1139
 * @param string The text to trim
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1140
 * @param int The maximum length to trim the text to.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1141
 * @param bool Reference. Set to true if the text was trimmed, otherwise set to false.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1142
 */
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1143
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
  1144
function nb_trim_paragraph($text, $len = 500, &$trimmed)
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1145
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1146
  $trimmed = false;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1147
  if ( strlen($text) <= $len )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1148
    return $text;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1149
  $trimmed = true;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1150
  $text = substr($text, 0, $len);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1151
  for ( $i = $len; $i > 0; $i-- )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1152
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1153
    $chr = $text{$i-1};
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1154
    if ( preg_match('/[\s]/', $chr) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1155
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1156
      $text = substr($text, 0, $i - 1);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1157
      $text .= '...';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1158
      return $text;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1159
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1160
    $text = substr($text, 0, $i);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1161
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1162
  return $text;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1163
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1164
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1165
/**
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1166
 * Generates a link to the given Newsboy article given the article name and timestamp
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1167
 * @param int Article timestamp
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1168
 * @param string Article title
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1169
 * @return string
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1170
 */
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1171
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1172
function nb_make_article_url($timestamp, $title = false)
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1173
{
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1174
  if ( !$title )
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1175
    return makeUrlNS('NewsBoy', $timestamp);
9
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
  1176
  $day = gmdate('d', $timestamp);
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
  1177
  $year = gmdate('Y', $timestamp);
162b0f10e3d0 Fixed a few issues with timestamp and Article/* matching
Dan
parents: 8
diff changeset
  1178
  $month = gmdate('m', $timestamp);
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1179
  return makeUrlNS('NewsBoy', "Article/$year/$month/$day/" . sanitize_page_id($title));
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1180
}
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1181
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1182
?>