plugins/Newsboy.php
author Dan
Sat, 14 Jun 2008 22:42:26 -0400
changeset 7 c3710cbed6d0
parent 6 432eed804b7f
child 8 81693fc2f660
permissions -rw-r--r--
Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
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
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
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
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   115
    $template->tpl_strings['PAGE_NAME'] = ( $paths->cpage['urlname_nons'] == 'Portal' ) ?
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   116
          ( ( empty($x) ) ?
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   117
              'Welcome to ' . getConfig('site_name') :
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   118
              $x ) :
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   119
          'News Archive';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   120
    
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   121
    if ( !$page->perms->get_permissions('read') )
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   122
    {
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   123
      $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
   124
      return false;
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   125
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   126
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   127
    $paths->cpage['comments_on'] = 0;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   128
    
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   129
    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
   130
    {
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   131
      $template->header();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   132
      NewsBoy_portal();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   133
      $template->footer();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   134
    }
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   135
    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
   136
    {
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   137
      $template->header();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   138
      NewsBoy_archive();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   139
      $template->footer();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   140
    }
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   141
    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
   142
    {
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   143
      if ( !preg_match('#^Article/([0-9]{4})/([0-9]{2})/([0-9]{2})/(.+?)$#', $page->page_id, $id_match) )
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   144
      {
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   145
        return;
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   146
      }
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   147
      // 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
   148
      // int mktime  ([ int $hour  [, int $minute  [, int $second  [, int $month  [, int $day  [, int $year  [, int $is_dst  ]]]]]]] )
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   149
      $timestamp_min = mktime(0, 0, 0, intval($id_match[2]), intval($id_match[3]), intval($id_match[1]));
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   150
      $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
   151
      // 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
   152
      $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
   153
      $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
   154
      if ( !$q )
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   155
        $db->_die();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   156
      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
   157
        return;
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   158
      // found a page
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   159
      $row = $db->fetchrow();
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   160
      if ( sanitize_page_id($row['name']) === $id_match[4] )
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   161
      {
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   162
        // we have a definitive match, send the page through
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   163
        $article = new PageProcessor($row['urlname'], 'NewsBoy');
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   164
        $article->send_headers = $page->send_headers;
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   165
        $article->password = $page->password;
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   166
        $article->send(true);
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   167
      }
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   168
      else
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   169
      {
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   170
        // 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
   171
        return;
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   172
      }
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   173
      return;
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   174
    }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   175
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   176
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   177
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   178
function NewsBoy_set_page_string()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   179
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   180
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   181
  if ( $paths->namespace == 'NewsBoy' )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   182
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   183
    if ( $paths->cpage['urlname_nons'] == 'Portal' )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   184
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   185
      $template->namespace_string = 'portal';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   186
      
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   187
      // block editing
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   188
      $perm_arr = Array('edit_page' => AUTH_DENY, 'view_source' => AUTH_DENY);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   189
      $session->acl_merge_with_current($perm_arr, false, 2);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   190
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   191
    else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   192
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   193
      $template->namespace_string = 'news item';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   194
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   195
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   196
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   197
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   198
function NewsBoy_format_title($title)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   199
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   200
  $title = strtolower($title);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   201
  $title = preg_replace('/\W/', '-', $title);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   202
  $title = preg_replace('/([-]+)/', '-', $title);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   203
  $title = trim($title, '-');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   204
  return $title;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   205
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   206
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   207
function NewsBoy_feed_handler($mode)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   208
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   209
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   210
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   211
  if ( $mode != 'news' )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   212
    return;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   213
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   214
  $limit = ( $x = $paths->getParam(1) ) ? $x : 20;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   215
  $limit = intval($limit);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   216
  if ( $limit > 50 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   217
    $limit = 50;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   218
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   219
  $title = getConfig('site_name') . ': Site news';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   220
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   221
  $x = getConfig('nb_portal_title');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   222
  $desc = ( empty($x) ) ? 'Welcome to ' . getConfig('site_name') : $x;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   223
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   224
  $link = makeUrlComplete('NewsBoy', 'Portal');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   225
  $generator = 'Enano CMS ' . enano_version() . ' - NewsBoy plugin';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   226
  $email = getConfig('contact_email');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   227
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   228
  $rss = new RSS($title, $desc, $link, $generator, $email);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   229
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   230
  $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
   231
         LEFT JOIN '.table_prefix.'comments AS c
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   232
           ON ( c.page_id=p.urlname AND c.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   233
         LEFT JOIN '.table_prefix.'logs AS l
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   234
           ON ( l.page_id=p.urlname AND l.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   235
         LEFT JOIN '.table_prefix.'users AS u
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   236
           ON ( u.username=l.author )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   237
         LEFT JOIN '.table_prefix.'page_text AS t
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   238
           ON ( t.page_id=p.urlname AND t.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   239
         WHERE p.namespace=\'NewsBoy\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   240
           AND l.action=\'create\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   241
           AND p.urlname REGEXP \'^([0-9]+)$\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   242
           AND p.visible=1
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   243
         GROUP BY p.urlname
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   244
         ORDER BY urlname DESC
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   245
         LIMIT '.$limit.';';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   246
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   247
  $q = $db->sql_unbuffered_query($sql);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   248
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   249
  if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   250
    $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   251
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   252
  $formatter = new NewsBoyFormatter();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   253
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   254
  if ( $row = $db->fetchrow() )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   255
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   256
    do {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   257
      
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   258
      $title = $row['name'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   259
      $link = makeUrlComplete('NewsBoy', $row['urlname']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   260
      $desc = RenderMan::render($row['page_text']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   261
      $time = intval($row['urlname']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   262
      
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   263
      $rss->add_item($title, $link, $desc, $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   264
      
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   265
    } while ( $row = $db->fetchrow() );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   266
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   267
  else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   268
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   269
    $rss->add_item('Error', $link, 'No news items yet.', time());
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   270
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   271
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   272
  echo $rss->render();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   273
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   274
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   275
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   276
function NewsBoy_portal()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   277
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   278
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   279
  
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
   280
  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
   281
  {
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
   282
    $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
   283
  }
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
   284
  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
   285
  {
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
   286
    $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
   287
    <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
   288
      <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
   289
        <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
   290
          <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
   291
        </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
   292
        <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
   293
          <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
   294
            {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
   295
          </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
   296
        </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
   297
        <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
   298
          <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
   299
            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
   300
            [ {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
   301
          </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
   302
        </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
   303
      </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
   304
    </div>
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   305
TPLCODE;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   306
  
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
   307
    $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
   308
  }
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
   309
  
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   310
  /*
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   311
  $p = RenderMan::strToPageID(getConfig('main_page'));
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   312
  if ( $p[1] != 'NewsBoy' )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   313
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   314
    echo RenderMan::getPage($p[0], $p[1]);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   315
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   316
  else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   317
  { */
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   318
    /*
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   319
    $s = $paths->nslist['NewsBoy'] . 'Announce';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   320
    if ( isPage($s) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   321
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   322
      $p = RenderMan::getPage('Announce', 'NewsBoy');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   323
      echo $p;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   324
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   325
  /* } */
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   326
  
6
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   327
  $announce_page_default = $paths->nslist['NewsBoy'] . 'Announce';
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   328
  $s = $announce_page_default;
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   329
  $announce_page = getConfig('nb_announce_page');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   330
  if ( !empty($announce_page) && isPage($announce_page) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   331
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   332
    $s = $announce_page;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   333
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   334
  else if ( !isPage($s) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   335
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   336
    $s = false;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   337
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   338
  if ( $s )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   339
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   340
    $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
   341
    // 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
   342
    $paths->pages[$s]['special'] = 1;
1
540d077b7612 Fix stupid announcement link bug; replace getPage call with PageProcessor
Dan
parents: 0
diff changeset
   343
    $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
   344
    $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
   345
    $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
   346
    eval($content);
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   347
  }
6
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   348
  else
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   349
  {
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   350
    $stuff = RenderMan::strToPageID($announce_page_default);
432eed804b7f Fixed some logic bugs with the announcement page
Dan
parents: 5
diff changeset
   351
  }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   352
  
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
   353
  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
   354
  {
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
   355
    $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
   356
    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
   357
  }
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
   358
  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
   359
  {
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
   360
    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
   361
  }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   362
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   363
  $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
   364
         LEFT JOIN '.table_prefix.'comments AS c
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   365
           ON ( c.page_id=p.urlname AND c.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   366
         LEFT JOIN '.table_prefix.'page_text AS t
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   367
           ON ( t.page_id=p.urlname AND t.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   368
         LEFT JOIN '.table_prefix.'logs AS l
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   369
           ON ( l.page_id=p.urlname AND l.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   370
         LEFT JOIN '.table_prefix.'users AS u
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   371
           ON ( u.username=l.author OR u.user_id=1 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   372
         WHERE p.namespace=\'NewsBoy\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   373
           AND l.action=\'create\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   374
           AND p.urlname!=\'Announce\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   375
           AND p.visible=1
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   376
         GROUP BY p.urlname
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   377
         ORDER BY urlname DESC;');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   378
  if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   379
    $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   380
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   381
  if ( $row = $db->fetchrow() )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   382
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   383
    $i = 0;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   384
    do
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   385
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   386
      if ( $i < 5 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   387
      {
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   388
        $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
   389
        
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   390
        $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
   391
        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
   392
        {
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   393
          $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
   394
          $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
   395
        }
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   396
        
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   397
        $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
   398
        $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
   399
        
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   400
        if ( strlen($content) > 400 && !$trimmed )
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   401
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   402
          $content = nb_trim_paragraph($content, 400, $trimmed);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   403
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   404
        if ( $trimmed )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   405
        {
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   406
          $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
   407
          $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
   408
          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
   409
          {
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   410
            $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
   411
          }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   412
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   413
        $user_link = nb_make_username_link($row['author'], $row['user_level']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   414
        $date = date('F d, Y h:i:s a', $row['urlname']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   415
        $num_comments = $row['num_comments'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   416
        $comment_s = ( $num_comments == 1 ) ? '' : 's';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   417
        $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
   418
        $parser->assign_vars(array(
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   419
            '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
   420
            'LINK' => nb_make_article_url($row['urlname'], $row['name']),
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   421
            'CONTENT' => $content,
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   422
            'USER_LINK' => $user_link,
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   423
            'DATE' => $date,
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   424
            'NUM_COMMENTS' => $num_comments,
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   425
            'COMMENT_S' => $comment_s,
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   426
            'COMMENT_LINK' => $comment_link
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   427
          ));
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   428
        echo $parser->run();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   429
      }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   430
      else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   431
      {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   432
        echo '<p><a href="'.makeUrlNS('NewsBoy', 'Archive').'">Older news...</a></p>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   433
        break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   434
      }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   435
      $i++;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   436
    } while ( $row = $db->fetchrow() );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   437
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   438
  else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   439
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   440
    echo '<p>No news items yet.</p>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   441
  }
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
   442
  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
   443
  {
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
   444
    $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
   445
    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
   446
  }
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
   447
  
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   448
  if ( $session->user_level >= USER_LEVEL_ADMIN )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   449
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   450
    echo '<div class="tblholder" style="margin: 10px auto 0 auto; display: table;">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   451
            <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   452
              <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   453
                <th>Administrative tools:</th>
3
8ae9acb2e919 Re-implement announcement link fix, blame it on my bad Hg repo management
Dan
parents: 2
diff changeset
   454
                <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
   455
                <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
   456
              </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   457
            </table>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   458
          </div><br />';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   459
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   460
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   461
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   462
/**
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   463
 * Formats row data in the archive.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   464
 * @package Enano
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   465
 * @subpackage Newsboy
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   466
 * @license GNU General Public License
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   467
 */
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   468
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   469
class NewsBoyFormatter
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   470
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   471
  function article_link($name, $row)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   472
  {
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
   473
    $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
   474
    return $article_link;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   475
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   476
  function format_date($date, $row)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   477
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   478
    $date = date('Y-m-j g:m', intval ( $date ));
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   479
    return $date;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   480
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   481
  function format_username($x, $row)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   482
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   483
    $ul = intval($row['user_level']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   484
    $author = nb_make_username_link($row['author'], $ul);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   485
    return $author;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   486
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   487
  function format_commentlink($x, $row)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   488
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   489
    $comments = '<a href="' . makeUrlNS('NewsBoy', $row['urlname']) . '#do:comments">' . $row['num_comments'] . '</a>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   490
    return $comments;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   491
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   492
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   493
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   494
function NewsBoy_archive()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   495
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   496
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   497
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   498
  $lower_limit = ( isset($_GET['start']) ) ? intval($_GET['start']) : ( ( $xx = $paths->getParam(0) ) ? intval($xx) : 0 );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   499
  $entries_per_page = 50;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   500
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   501
  $row_count = $entries_per_page + 1;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   502
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   503
  // Determine number of total news entries
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   504
  $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
   505
  if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   506
    $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   507
  $r = $db->fetchrow();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   508
  $num_total = intval($db->numrows());
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   509
  $db->free_result();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   510
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   511
  if ( $lower_limit >= $num_total )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   512
    $lower_limit = 0;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   513
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   514
  $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
   515
         LEFT JOIN '.table_prefix.'comments AS c
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   516
           ON ( c.page_id=p.urlname AND c.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   517
         LEFT JOIN '.table_prefix.'logs AS l
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   518
           ON ( l.page_id=p.urlname AND l.namespace=p.namespace )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   519
         LEFT JOIN '.table_prefix.'users AS u
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   520
           ON ( u.username=l.author )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   521
         WHERE p.namespace=\'NewsBoy\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   522
           AND l.action=\'create\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   523
           AND p.urlname REGEXP \'^([0-9]+)$\'
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   524
           AND p.visible=1
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   525
         GROUP BY p.urlname
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   526
         ORDER BY urlname DESC;';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   527
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   528
  $q = $db->sql_unbuffered_query($sql);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   529
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   530
  if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   531
    $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   532
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   533
  $formatter = new NewsBoyFormatter();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   534
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   535
  $callers = Array(
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   536
      'name' => Array($formatter, 'article_link'),
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   537
      'urlname' => Array($formatter, 'format_date'),
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   538
      'author' => Array($formatter, 'format_username'),
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   539
      'num_comments' => Array($formatter, 'format_commentlink')
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   540
    );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   541
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   542
  $head = '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   543
          <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   544
            <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   545
              <th>Article</th><th>Date</th><th>Author</th><th>Comments</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   546
            </tr>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   547
  $foot = "</table></div>";
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   548
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   549
  $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
   550
                      $num_total, makeUrlNS('NewsBoy', 'Archive/%s'), $lower_limit, 20, $callers, $head, $foot);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   551
  echo $content;  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   552
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   553
  $code = $plugins->setHook('send_page_footers');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   554
  foreach ( $code as $cmd )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   555
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   556
    eval($cmd);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   557
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   558
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   559
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   560
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   561
function nb_make_username_link($username, $user_level)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   562
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   563
  $color = '#0000AA';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   564
  $user_level = intval($user_level);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   565
  if ( $user_level < USER_LEVEL_MEMBER ) return $username;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   566
  if ( $user_level >= USER_LEVEL_MOD ) $color = '#00AA00';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   567
  if ( $user_level >= USER_LEVEL_ADMIN ) $color = '#AA0000';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   568
  $link = '<a style="color: ' . $color . '" href="' . makeUrlNS('User', str_replace(' ', '_', $username) ) . '">' . $username . '</a>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   569
  return $link;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   570
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   571
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   572
function NewsBoy_PortalLink()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   573
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   574
  global $db, $session, $paths, $template, $plugins; // Common objects
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   575
  if ( $paths->namespace == 'NewsBoy' )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   576
    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
   577
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   578
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   579
// Administration panel
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   580
function page_Admin_NewsboyItemManager()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   581
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   582
  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
   583
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   584
  $done = false;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   585
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   586
  if ( isset( $_GET['act'] ) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   587
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   588
    switch ( $_GET['act'] )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   589
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   590
      case 'edit':
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   591
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   592
        // Error list
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   593
        $errors = Array();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   594
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   595
        if ( isset ( $_POST['submitting'] ) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   596
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   597
          // Generate timestamp
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   598
          $year = intval($_POST['pub_year']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   599
          $month = intval($_POST['pub_month']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   600
          $day = intval($_POST['pub_day']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   601
          $hour = intval($_POST['pub_hour']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   602
          $minute = intval($_POST['pub_minute']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   603
          $second = intval($_POST['pub_second']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   604
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   605
          // Validation
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   606
          if ( $year < 1500 || $year > 10000 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   607
            $errors[] = 'Invalid year.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   608
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   609
          if ( $month < 1 || $month > 12 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   610
            $errors[] = 'Invalid month.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   611
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   612
          if ( $day < 1 || $day > 31 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   613
            $errors[] = 'Invalid day.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   614
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   615
          if ( $hour < 0 || $hour > 23 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   616
            $errors[] = 'Invalid hour.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   617
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   618
          if ( $minute < 0 || $minute > 60 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   619
            $errors[] = 'Invalid minute.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   620
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   621
          if ( $second < 0 || $second > 60 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   622
            $errors[] = 'Invalid second.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   623
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   624
          $name = $_POST['article_name'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   625
          $name = $db->escape($name);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   626
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   627
          $author = $_POST['author'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   628
          $author = $db->escape($author);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   629
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   630
          if ( count($errors) < 1 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   631
          {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   632
            $time = mktime($hour, $minute, $second, $month, $day, $year);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   633
          }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   634
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   635
          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
   636
            $errors[] = 'You cannot have two news articles with the same publish time.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   637
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   638
          if ( count($errors) < 1 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   639
          {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   640
            $publ = ( isset($_POST['published']) ) ? '1' : '0';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   641
            $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
   642
            $q = $db->sql_query($sql);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   643
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   644
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   645
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   646
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   647
            // Update author
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   648
            $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
   649
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   650
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   651
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   652
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   653
            // Update other tables with urlname info
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   654
            $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
   655
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   656
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   657
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   658
            $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
   659
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   660
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   661
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   662
            $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
   663
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   664
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   665
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   666
            $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
   667
            if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   668
              $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   669
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   670
            echo '<div class="info-box">Your changes have been saved.</div>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   671
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   672
            break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   673
          }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   674
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   675
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   676
        if ( count($errors) > 0 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   677
          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
   678
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   679
        // Obtain page information
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   680
        if ( !isset($paths->pages[ $paths->nslist['NewsBoy'] . $_GET['id'] ]) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   681
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   682
          echo 'Invalid ID';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   683
          return false;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   684
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   685
        $page_info =& $paths->pages[ $paths->nslist['NewsBoy'] . $_GET['id'] ];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   686
        $time = intval($page_info['urlname_nons']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   687
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   688
        // Get author
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   689
        $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
   690
        
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
        $row = $db->fetchrow();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   695
        $author = ( isset($row['author']) ) ? $row['author'] : '';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   696
        if ( empty($author) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   697
          $author = 'Anonymous';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   698
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   699
        // Set date & time
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   700
        $month  = date('n', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   701
        $year   = date('Y', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   702
        $day    = date('j', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   703
        $hour   = date('G', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   704
        $minute = date('m', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   705
        $second = date('s', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   706
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   707
        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
   708
        echo '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   709
                <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   710
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   711
                    <th colspan="2">Editing news article</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   712
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   713
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   714
                    <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
   715
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   716
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   717
                    <td class="row1">Published date:</td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   718
                    <td class="row2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   719
                      <input name="pub_year" type="text" size="5" value="'.$year.'" />-<select name="pub_month">';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   720
       for ( $i = 1; $i <= 12; $i++ )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   721
       {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   722
         $m = "[$i] ";
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   723
         switch ( $i )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   724
         {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   725
           case 1:  $m .= 'January'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   726
           case 2:  $m .= 'February'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   727
           case 3:  $m .= 'March'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   728
           case 4:  $m .= 'April'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   729
           case 5:  $m .= 'May'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   730
           case 6:  $m .= 'June'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   731
           case 7:  $m .= 'July'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   732
           case 8:  $m .= 'August'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   733
           case 9:  $m .= 'September'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   734
           case 10: $m .= 'October'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   735
           case 11: $m .= 'November'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   736
           case 12: $m .= 'December'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   737
           default: $m .= 'Fuhrober'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   738
         }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   739
         if ( $month == $i )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   740
           echo '         <option selected="selected" value="' . $i . '">'.$m.'</option>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   741
         else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   742
           echo '         <option value="' . $i . '">'.$m.'</option>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   743
       }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   744
       echo '         </select>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   745
                      <input name="pub_day" type="text" size="3" value="' . $day . '" />, time:
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   746
                      <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
   747
                      <small>Note: Hours are in 24-hour format.</small>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   748
                    </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   749
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   750
                  <!-- Inline developer blog, episode 1:
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   751
                       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
   752
                       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
   753
                       (b) I wouldn\'t want to offend you hackers. (j/k)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   754
                       
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   755
                       Oh crap. And no, I don\'t give towels with my showers.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   756
                       
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   757
                       -Dan
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   758
                       -->
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   759
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   760
                    <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
   761
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   762
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   763
                    <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
   764
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   765
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   766
                    <td class="row3" style="text-align: center;" colspan="2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   767
                      <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
   768
                    </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   769
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   770
                </table>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   771
              </div>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   772
              <input type="hidden" name="submitting" value="yes" />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   773
              <input type="hidden" name="page_id" value="' . $_GET['id'] . '" />';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   774
        echo '</form>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   775
        $done = true;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   776
        break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   777
      case 'del':
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   778
        if ( isset( $_POST['confirmed'] ) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   779
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   780
          $page_id = $_POST['page_id'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   781
          $namespace = 'NewsBoy';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   782
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   783
          $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
   784
          if(!$e) $db->_die('The page log entry could not be inserted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   785
          $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
   786
          if(!$e) $db->_die('The page categorization entries could not be deleted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   787
          $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
   788
          if(!$e) $db->_die('The page comments could not be deleted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   789
          $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
   790
          if(!$e) $db->_die('The page text entry could not be deleted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   791
          $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
   792
          if(!$e) $db->_die('The page entry could not be deleted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   793
          $e = $db->sql_query('DELETE FROM '.table_prefix.'files WHERE page_id=\''.$page_id.'\'');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   794
          if(!$e) $db->_die('The file entry could not be deleted.');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   795
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   796
          $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
   797
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   798
          echo $result . '<br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   799
               <br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   800
               <a href="#" onclick="ajaxPage(\'' . $paths->cpage['module'] . '\');">Return to Newsboy</a>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   801
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   802
        else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   803
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   804
          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
   805
          echo '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   806
                  <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   807
                    <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   808
                      <th>Confirm deletion</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   809
                     </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   810
                     <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   811
                       <td class="row1" style="text-align: center;">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   812
                         <p>Are you sure you want to delete this news article?</p>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   813
                       </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   814
                     </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   815
                     <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   816
                       <td class="row3" style="text-align: center;">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   817
                         <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
   818
                       </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   819
                     </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   820
                  </table>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   821
                </div>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   822
                <input type="hidden" name="confirmed" value="yes" />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   823
                <input type="hidden" name="page_id" value="' . intval ( $_GET['id'] ) . '" />';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   824
          echo '</form>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   825
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   826
        $done = true;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   827
        break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   828
      case 'create':
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   829
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   830
        // Error list
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   831
        $errors = Array();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   832
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   833
        if ( isset ( $_POST['submitting'] ) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   834
        {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   835
          // Generate timestamp
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   836
          $year = intval($_POST['pub_year']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   837
          $month = intval($_POST['pub_month']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   838
          $day = intval($_POST['pub_day']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   839
          $hour = intval($_POST['pub_hour']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   840
          $minute = intval($_POST['pub_minute']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   841
          $second = intval($_POST['pub_second']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   842
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   843
          // Validation
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   844
          if ( $year < 1500 || $year > 10000 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   845
            $errors[] = 'Invalid year.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   846
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   847
          if ( $month < 1 || $month > 12 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   848
            $errors[] = 'Invalid month.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   849
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   850
          if ( $day < 1 || $day > 31 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   851
            $errors[] = 'Invalid day.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   852
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   853
          if ( $hour < 0 || $hour > 23 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   854
            $errors[] = 'Invalid hour.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   855
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   856
          if ( $minute < 0 || $minute > 60 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   857
            $errors[] = 'Invalid minute.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   858
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   859
          if ( $second < 0 || $second > 60 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   860
            $errors[] = 'Invalid second.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   861
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   862
          $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
   863
          // This is db-escaped by PageUtils
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   864
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   865
          $author = $_POST['author'];
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   866
          $author = $db->escape($author);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   867
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   868
          if ( count($errors) < 1 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   869
          {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   870
            $time = mktime($hour, $minute, $second, $month, $day, $year);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   871
          }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   872
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   873
          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
   874
            $errors[] = 'You cannot have two news articles with the same publish time.';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   875
          
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   876
          if ( count($errors) < 1 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   877
          {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   878
            $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
   879
            
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   880
            $result = PageUtils::createpage( (string)$time, 'NewsBoy', $name, $publ );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   881
            
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   882
            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
   883
            {
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   884
              // 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
   885
              $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
   886
              
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   887
              $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
   888
              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
   889
                $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
   890
              
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   891
              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
   892
                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
   893
              else
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   894
                $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
   895
            }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   896
            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
   897
            {
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   898
              $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
   899
            }
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   900
            
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   901
            break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   902
          }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   903
        }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   904
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   905
        if ( count($errors) > 0 )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   906
          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
   907
        
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   908
        $time = time();
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   909
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   910
        // Get author
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   911
        $author = $session->username;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   912
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   913
        if ( empty($author) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   914
          $author = 'Anonymous';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   915
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   916
        // Set date & time
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   917
        $month  = date('n', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   918
        $year   = date('Y', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   919
        $day    = date('j', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   920
        $hour   = date('G', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   921
        $minute = date('m', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   922
        $second = date('s', $time);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   923
        
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
   924
        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
   925
        echo '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   926
                <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   927
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   928
                    <th colspan="2">Creating news article</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   929
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   930
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   931
                    <td class="row1">Article name:</td><td class="row2"><input name="article_name" value="" /></td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   932
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   933
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   934
                    <td class="row1">Published datestamp:</td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   935
                    <td class="row2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   936
                      <input name="pub_year" type="text" size="5" value="'.$year.'" />-<select name="pub_month">';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   937
       for ( $i = 1; $i <= 12; $i++ )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   938
       {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   939
         $m = "[$i] ";
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   940
         switch ( $i )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   941
         {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   942
           case 1:  $m .= 'January'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   943
           case 2:  $m .= 'February'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   944
           case 3:  $m .= 'March'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   945
           case 4:  $m .= 'April'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   946
           case 5:  $m .= 'May'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   947
           case 6:  $m .= 'June'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   948
           case 7:  $m .= 'July'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   949
           case 8:  $m .= 'August'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   950
           case 9:  $m .= 'September'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   951
           case 10: $m .= 'October'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   952
           case 11: $m .= 'November'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   953
           case 12: $m .= 'December'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   954
           default: $m .= 'Fuhrober'; break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   955
         }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   956
         if ( $month == $i )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   957
           echo '         <option selected="selected" value="' . $i . '">'.$m.'</option>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   958
         else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   959
           echo '         <option value="' . $i . '">'.$m.'</option>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   960
       }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   961
       echo '         </select>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   962
                      <input name="pub_day" type="text" size="3" value="' . $day . '" />, time:
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   963
                      <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
   964
                      <small>Note: Hours are in 24-hour format.</small>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   965
                    </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   966
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   967
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   968
                    <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
   969
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   970
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   971
                    <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
   972
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   973
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   974
                    <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
   975
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   976
                  <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   977
                    <td class="row3" style="text-align: center;" colspan="2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   978
                      <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
   979
                    </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   980
                  </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   981
                </table>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   982
              </div>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   983
              <input type="hidden" name="submitting" value="yes" />';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   984
        echo '</form>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   985
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   986
        $done = true;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   987
        break;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   988
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   989
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   990
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   991
  if ( !$done )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   992
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   993
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   994
    // Start output
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   995
    echo '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   996
      <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   997
        <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   998
          <th>Name</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
   999
          <th>Date published</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1000
          <th colspan="3">Actions</th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1001
        </tr>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1002
        
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1003
    $row_class = 'row2';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1004
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1005
    // List existing news entries
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1006
    $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
  1007
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1008
    if ( !$q )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1009
      $db->_die();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1010
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1011
    if ( $row = $db->fetchrow($q) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1012
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1013
      do {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1014
        $row_class = ( $row_class == 'row1' ) ? 'row2' : 'row1';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1015
        $ts = intval($row['urlname']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1016
        $date = date('F d, Y h:i a', $ts);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1017
        $edit_url = makeUrlNS('Special', 'Administration', "module={$paths->cpage['module']}&act=edit&id={$row['urlname']}", true);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1018
        $dele_url = makeUrlNS('Special', 'Administration', "module={$paths->cpage['module']}&act=del&id={$row['urlname']}", true);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1019
        $page_url = makeUrlNS('NewsBoy', $row['urlname']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1020
        echo "<tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1021
                <td class='$row_class' style='width: 50%;'>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1022
                  {$row['name']}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1023
                </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1024
                <td class='$row_class' style='width: 40%;'>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1025
                  $date
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1026
                </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1027
                <td class='$row_class'>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1028
                  <a href='$edit_url'>Settings</a>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1029
                </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1030
                <td class='$row_class'>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1031
                  <a href='$page_url' onclick='window.open(this.href); return false;'>Page</a>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1032
                </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1033
                <td class='$row_class'>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1034
                  <a href='$dele_url'>Delete</a>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1035
                </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1036
              </tr>";
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1037
      } while ( $row = $db->fetchrow($q) );
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1038
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1039
    else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1040
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1041
      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
  1042
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1043
    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
  1044
          </table></div>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1045
    $db->free_result();
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1046
    
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1047
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1048
  
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1049
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1050
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1051
function page_Admin_NewsboyConfiguration()
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1052
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1053
  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
  1054
  if ( isset($_POST['submit']) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1055
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1056
    setConfig('nb_portal_title', $_POST['portal_name']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1057
    if ( isPage($_POST['announce_page']) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1058
      setConfig('nb_announce_page', $_POST['announce_page']);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1059
    else
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1060
      setConfig('nb_announce_page', '');
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1061
    // Submit
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1062
    echo '<div class="info-box">Your changes have been saved.</div>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1063
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1064
  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
  1065
  echo '<div class="tblholder">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1066
          <table border="0" cellspacing="1" cellpadding="4">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1067
            <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1068
              <th colspan="2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1069
                Newsboy portal: General configuration
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1070
              </th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1071
            </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1072
            <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1073
              <td class="row2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1074
                Portal title:<br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1075
                <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
  1076
                portal. If you don\'t enter anything here, a default will be used.</small>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1077
              </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1078
              <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
  1079
            </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1080
            <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1081
              <td class="row2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1082
                Page to embed as announcement:<br />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1083
                <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
  1084
                portal. The default is "' . $paths->nslist['NewsBoy'] . 'Announce".</small>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1085
              </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1086
              <td class="row1">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1087
                ' . $template->pagename_field('announce_page', htmlspecialchars(getConfig('nb_announce_page'))) . '
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1088
              </td>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1089
            </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1090
            <tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1091
              <th class="subhead" colspan="2">
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1092
                <input type="submit" name="submit" value="Save changes" />
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1093
              </th>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1094
            </tr>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1095
          </table>
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1096
        </div>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1097
  echo '</form>';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1098
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1099
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1100
/**
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1101
 * Trims a wad of text to the specified length.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1102
 * @todo make HTML friendly (don't break tags)
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1103
 * @param string The text to trim
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1104
 * @param int The maximum length to trim the text to.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1105
 * @param bool Reference. Set to true if the text was trimmed, otherwise set to false.
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1106
 */
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1107
2
66b299fdb9ca Fixed Wicked Flea's bug (apostrophes in page title) and fixed error checking on PageUtils::createpage return
Dan
parents: 1
diff changeset
  1108
function nb_trim_paragraph($text, $len = 500, &$trimmed)
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1109
{
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1110
  $trimmed = false;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1111
  if ( strlen($text) <= $len )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1112
    return $text;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1113
  $trimmed = true;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1114
  $text = substr($text, 0, $len);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1115
  for ( $i = $len; $i > 0; $i-- )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1116
  {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1117
    $chr = $text{$i-1};
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1118
    if ( preg_match('/[\s]/', $chr) )
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1119
    {
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1120
      $text = substr($text, 0, $i - 1);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1121
      $text .= '...';
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1122
      return $text;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1123
    }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1124
    $text = substr($text, 0, $i);
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1125
  }
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1126
  return $text;
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1127
}
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1128
7
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1129
/**
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1130
 * 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
  1131
 * @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
  1132
 * @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
  1133
 * @return string
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1134
 */
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1135
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1136
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
  1137
{
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1138
  if ( !$title )
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1139
    return makeUrlNS('NewsBoy', $timestamp);
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1140
  $day = date('d', $timestamp);
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1141
  $year = date('Y', $timestamp);
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1142
  $month = date('m', $timestamp);
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1143
  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
  1144
}
c3710cbed6d0 Modified article links and stuff to be more SEO-friendly. Here ends 1.0.x compatibility!
Dan
parents: 6
diff changeset
  1145
0
9f29b32e5224 Initial repository population
dan@fuhry
parents:
diff changeset
  1146
?>