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