1
+ − 1
<?php
+ − 2
+ − 3
/**
+ − 4
* Enano - an open-source CMS capable of wiki functions, Drupal-like sidebar blocks, and everything in between
73
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 5
* Version 1.0.1 (Loch Ness)
1
+ − 6
* Copyright (C) 2006-2007 Dan Fuhry
+ − 7
* paths.php - The part of Enano that actually manages content. Everything related to page handling and namespaces is in here.
+ − 8
*
+ − 9
* This program is Free Software; you can redistribute and/or modify it under the terms of the GNU General Public License
+ − 10
* as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
+ − 11
*
+ − 12
* This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied
+ − 13
* warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for details.
+ − 14
*
+ − 15
* @package Enano
+ − 16
* @subpackage PathManager
23
+ − 17
* @see http://enanocms.org/Help:API_Documentation
1
+ − 18
*/
+ − 19
+ − 20
class pathManager {
+ − 21
var $pages, $custom_page, $cpage, $page, $fullpage, $page_exists, $namespace, $nslist, $admin_tree, $wiki_mode, $page_protected, $template_cache;
+ − 22
function __construct()
+ − 23
{
+ − 24
global $db, $session, $paths, $template, $plugins; // Common objects
+ − 25
+ − 26
$GLOBALS['paths'] =& $this;
+ − 27
$this->pages = Array();
+ − 28
+ − 29
dc_here('paths: setting up namespaces, admin nodes');
+ − 30
+ − 31
// DEFINE NAMESPACES HERE
+ − 32
// The key names should NOT EVER be changed, or Enano will be very broken
+ − 33
$this->nslist = Array(
+ − 34
'Article' =>'',
+ − 35
'User' =>'User:',
+ − 36
'File' =>'File:',
+ − 37
'Help' =>'Help:',
+ − 38
'Admin' =>'Admin:',
+ − 39
'Special' =>'Special:',
+ − 40
'System' =>'Enano:',
+ − 41
'Template'=>'Template:',
+ − 42
'Category'=>'Category:',
40
+ − 43
'Project' =>sanitize_page_id(getConfig('site_name')).':',
1
+ − 44
);
+ − 45
+ − 46
// ACL types
+ − 47
// These can also be added from within plugins
+ − 48
+ − 49
$session->register_acl_type('read', AUTH_ALLOW, 'Read page(s)');
+ − 50
$session->register_acl_type('post_comments', AUTH_ALLOW, 'Post comments', Array('read'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 51
$session->register_acl_type('edit_comments', AUTH_ALLOW, 'Edit own comments', Array('post_comments'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 52
$session->register_acl_type('edit_page', AUTH_WIKIMODE, 'Edit page', Array('view_source'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 53
$session->register_acl_type('view_source', AUTH_WIKIMODE, 'View source', Array('read'), 'Article|User|Project|Template|File|Help|System|Category'); // Only used if the page is protected
+ − 54
$session->register_acl_type('mod_comments', AUTH_DISALLOW, 'Moderate comments', Array('edit_comments'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 55
$session->register_acl_type('history_view', AUTH_WIKIMODE, 'View history/diffs', Array('read'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 56
$session->register_acl_type('history_rollback', AUTH_DISALLOW, 'Rollback history', Array('history_view'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 57
$session->register_acl_type('history_rollback_extra', AUTH_DISALLOW, 'Undelete page(s)', Array('history_rollback'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 58
$session->register_acl_type('protect', AUTH_DISALLOW, 'Protect page(s)', Array('read'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 59
$session->register_acl_type('rename', AUTH_WIKIMODE, 'Rename page(s)', Array('read'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 60
$session->register_acl_type('clear_logs', AUTH_DISALLOW, 'Clear page logs (dangerous)', Array('read', 'protect', 'even_when_protected'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 61
$session->register_acl_type('vote_delete', AUTH_ALLOW, 'Vote to delete', Array('read'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 62
$session->register_acl_type('vote_reset', AUTH_DISALLOW, 'Reset delete votes', Array('read'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 63
$session->register_acl_type('delete_page', AUTH_DISALLOW, 'Delete page(s)', Array(), 'Article|User|Project|Template|File|Help|System|Category');
+ − 64
$session->register_acl_type('set_wiki_mode', AUTH_DISALLOW, 'Set per-page wiki mode', Array('read'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 65
$session->register_acl_type('password_set', AUTH_DISALLOW, 'Set password', Array('read'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 66
$session->register_acl_type('password_reset', AUTH_DISALLOW, 'Disable/reset password', Array('read'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 67
$session->register_acl_type('mod_misc', AUTH_DISALLOW, 'Super moderator (generate SQL backtraces, view IP addresses, and send large numbers of private messages)', Array(), 'All');
+ − 68
$session->register_acl_type('edit_cat', AUTH_WIKIMODE, 'Edit categorization', Array('read'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 69
$session->register_acl_type('even_when_protected', AUTH_DISALLOW, 'Allow editing, renaming, and categorization even when protected', Array('edit_page', 'rename', 'mod_comments', 'edit_cat'), 'Article|User|Project|Template|File|Help|System|Category');
+ − 70
$session->register_acl_type('upload_files', AUTH_DISALLOW, 'Upload files', Array('create_page'), 'Article|User|Project|Template|File|Help|System|Category|Special');
+ − 71
$session->register_acl_type('upload_new_version', AUTH_WIKIMODE, 'Upload new versions of files', Array('upload_files'), 'Article|User|Project|Template|File|Help|System|Category|Special');
+ − 72
$session->register_acl_type('create_page', AUTH_WIKIMODE, 'Create pages', Array(), 'Article|User|Project|Template|File|Help|System|Category|Special');
11
ccad6026a168
Finalized permissions on files and directories; adding PHP shutoff button (actual shutoff not implemented)
Dan
diff
changeset
+ − 73
$session->register_acl_type('php_in_pages', AUTH_DISALLOW, 'Embed PHP code in pages', Array('edit_page'), 'Article|User|Project|Template|File|Help|System|Category|Admin');
1
+ − 74
$session->register_acl_type('edit_acl', AUTH_DISALLOW, 'Edit access control lists', Array('read', 'post_comments', 'edit_comments', 'edit_page', 'view_source', 'mod_comments', 'history_view', 'history_rollback', 'history_rollback_extra', 'protect', 'rename', 'clear_logs', 'vote_delete', 'vote_reset', 'delete_page', 'set_wiki_mode', 'password_set', 'password_reset', 'mod_misc', 'edit_cat', 'even_when_protected', 'upload_files', 'upload_new_version', 'create_page', 'php_in_pages'));
+ − 75
+ − 76
// DO NOT add new admin pages here! Use a plugin to call $paths->addAdminNode();
+ − 77
$this->addAdminNode('General', 'General Configuration', 'GeneralConfig');
+ − 78
$this->addAdminNode('General', 'File uploads', 'UploadConfig');
+ − 79
$this->addAdminNode('General', 'Allowed file types', 'UploadAllowedMimeTypes');
+ − 80
$this->addAdminNode('General', 'Manage Plugins', 'PluginManager');
+ − 81
$this->addAdminNode('General', 'Backup database', 'DBBackup');
+ − 82
$this->addAdminNode('Content', 'Manage Pages', 'PageManager');
+ − 83
$this->addAdminNode('Content', 'Edit page content', 'PageEditor');
73
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 84
$this->addAdminNode('Content', 'Manage page groups', 'PageGroups');
1
+ − 85
$this->addAdminNode('Appearance', 'Manage themes', 'ThemeManager');
+ − 86
$this->addAdminNode('Users', 'Manage users', 'UserManager');
+ − 87
$this->addAdminNode('Users', 'Edit groups', 'GroupManager');
30
+ − 88
$this->addAdminNode('Users', 'COPPA support', 'COPPA');
1
+ − 89
$this->addAdminNode('Users', 'Ban control', 'BanControl');
+ − 90
$this->addAdminNode('Users', 'Mass e-mail', 'MassEmail');
+ − 91
+ − 92
$code = $plugins->setHook('acl_rule_init');
+ − 93
foreach ( $code as $cmd )
+ − 94
{
+ − 95
eval($cmd);
+ − 96
}
+ − 97
+ − 98
$this->wiki_mode = (int)getConfig('wiki_mode')=='1';
+ − 99
$this->template_cache = Array();
+ − 100
}
+ − 101
function pathManager()
+ − 102
{
+ − 103
$this->__construct();
+ − 104
}
+ − 105
function init()
+ − 106
{
+ − 107
global $db, $session, $paths, $template, $plugins; // Common objects
+ − 108
+ − 109
dc_here('paths: selecting master page data');
+ − 110
+ − 111
$code = $plugins->setHook('paths_init_before');
+ − 112
foreach ( $code as $cmd )
+ − 113
{
+ − 114
eval($cmd);
+ − 115
}
+ − 116
+ − 117
$e = $db->sql_query('SELECT name,urlname,namespace,special,visible,comments_on,protected,delvotes,delvote_ips,wiki_mode,password FROM '.table_prefix.'pages ORDER BY name;');
+ − 118
if( !$e )
+ − 119
{
+ − 120
$db->_die('The error seems to have occured while selecting the page information. File: includes/paths.php; line: '.__LINE__);
+ − 121
}
+ − 122
while($r = $db->fetchrow())
+ − 123
{
+ − 124
+ − 125
$r['urlname_nons'] = $r['urlname'];
+ − 126
$r['urlname'] = $this->nslist[$r['namespace']] . $r['urlname']; // Applies the User:/File:/etc prefixes to the URL names
+ − 127
+ − 128
if ( $r['delvotes'] == null)
+ − 129
{
+ − 130
$r['delvotes'] = 0;
+ − 131
}
+ − 132
if ( $r['protected'] == 0 || $r['protected'] == 1 )
+ − 133
{
+ − 134
$r['really_protected'] = (int)$r['protected'];
+ − 135
}
+ − 136
else if ( $r['protected'] == 2 && getConfig('wiki_mode') == '1')
+ − 137
{
+ − 138
$r['really_protected'] = 1;
+ − 139
}
+ − 140
else if ( $r['protected'] == 2 && getConfig('wiki_mode') == '0' )
+ − 141
{
+ − 142
$r['really_protected'] = 0;
+ − 143
}
+ − 144
+ − 145
$this->pages[$r['urlname']] = $r;
+ − 146
$this->pages[] =& $this->pages[$r['urlname']];
+ − 147
+ − 148
}
+ − 149
$db->free_result();
+ − 150
dc_here('paths: determining page ID');
+ − 151
if( isset($_GET['title']) )
+ − 152
{
+ − 153
if ( $_GET['title'] == '' && getConfig('main_page') != '' )
+ − 154
{
+ − 155
$this->main_page();
+ − 156
}
+ − 157
if(strstr($_GET['title'], ' '))
+ − 158
{
+ − 159
$loc = urldecode(rawurldecode($_SERVER['REQUEST_URI']));
+ − 160
$loc = str_replace(' ', '_', $loc);
+ − 161
$loc = str_replace('+', '_', $loc);
+ − 162
$loc = str_replace('%20', '_', $loc);
+ − 163
redirect($loc, 'Redirecting...', 'Space detected in the URL, please wait whilst you are redirected', 0);
+ − 164
exit;
+ − 165
}
+ − 166
$url_namespace_special = substr($_GET['title'], 0, strlen($this->nslist['Special']) );
+ − 167
$url_namespace_template = substr($_GET['title'], 0, strlen($this->nslist['Template']) );
+ − 168
if($url_namespace_special == $this->nslist['Special'] || $url_namespace_template == $this->nslist['Template'] )
+ − 169
{
+ − 170
$ex = explode('/', $_GET['title']);
+ − 171
$this->page = $ex[0];
+ − 172
}
+ − 173
else
+ − 174
{
+ − 175
$this->page = $_GET['title'];
+ − 176
}
+ − 177
$this->fullpage = $_GET['title'];
+ − 178
}
+ − 179
elseif( isset($_SERVER['PATH_INFO']) )
+ − 180
{
+ − 181
$pi = explode('/', $_SERVER['PATH_INFO']);
+ − 182
+ − 183
if( !isset($pi[1]) || (isset($pi[1]) && $pi[1] == '' && getConfig('main_page') != '') )
+ − 184
{
+ − 185
$this->main_page();
+ − 186
}
+ − 187
if( strstr($pi[1], ' ') )
+ − 188
{
+ − 189
$loc = str_replace(' ', '_', urldecode(rawurldecode($_SERVER['REQUEST_URI'])));
+ − 190
$loc = str_replace('+', '_', $loc);
+ − 191
$loc = str_replace('%20', '_', $loc);
+ − 192
redirect($loc, 'Redirecting...', 'Please wait whilst you are redirected', 3);
+ − 193
exit;
+ − 194
}
+ − 195
unset($pi[0]);
+ − 196
if( substr($pi[1], 0, strlen($this->nslist['Special'])) == $this->nslist['Special'] || substr($pi[1], 0, strlen($this->nslist['Template'])) == $this->nslist['Template'] )
+ − 197
{
+ − 198
$pi2 = $pi[1];
+ − 199
}
+ − 200
else
+ − 201
{
+ − 202
$pi2 = implode('/', $pi);
+ − 203
}
+ − 204
$this->page = $pi2;
+ − 205
$this->fullpage = implode('/', $pi);
+ − 206
}
+ − 207
else
+ − 208
{
+ − 209
$k = array_keys($_GET);
+ − 210
foreach($k as $c)
+ − 211
{
+ − 212
if(substr($c, 0, 1) == '/')
+ − 213
{
+ − 214
$this->page = substr($c, 1, strlen($c));
+ − 215
+ − 216
// Bugfix for apache somehow passing dots as underscores
+ − 217
global $mime_types;
+ − 218
+ − 219
$exts = array_keys($mime_types);
+ − 220
$exts = '(' . implode('|', $exts) . ')';
+ − 221
+ − 222
if ( preg_match( '#_'.$exts.'#i', $this->page ) )
+ − 223
{
+ − 224
$this->page = preg_replace( '#_'.$exts.'#i', '.\\1', $this->page );
+ − 225
}
+ − 226
+ − 227
$this->fullpage = $this->page;
+ − 228
+ − 229
if(substr($this->page, 0, strlen($this->nslist['Special']))==$this->nslist['Special'] || substr($this->page, 0, strlen($this->nslist['Template']))==$this->nslist['Template'])
+ − 230
{
+ − 231
$ex = explode('/', $this->page);
+ − 232
$this->page = $ex[0];
+ − 233
}
+ − 234
if(strstr($this->page, ' '))
+ − 235
{
+ − 236
$loc = str_replace(' ', '_', urldecode(rawurldecode($_SERVER['REQUEST_URI'])));
+ − 237
$loc = str_replace('+', '_', $loc);
+ − 238
$loc = str_replace('%20', '_', $loc);
+ − 239
redirect($loc, 'Redirecting...', 'Space in the URL detected, please wait whilst you are redirected', 0);
+ − 240
exit;
+ − 241
}
+ − 242
break;
+ − 243
}
+ − 244
}
+ − 245
if(!$this->page && !($this->page == '' && getConfig('main_page') == ''))
+ − 246
{
+ − 247
$this->main_page();
+ − 248
}
+ − 249
}
+ − 250
15
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 251
$this->page = sanitize_page_id($this->page);
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 252
$this->fullpage = sanitize_page_id($this->fullpage);
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 253
1
+ − 254
dc_here('paths: setting $paths->cpage');
+ − 255
+ − 256
if(isset($this->pages[$this->page]))
+ − 257
{
+ − 258
dc_here('paths: page existence verified, our page ID is: '.$this->page);
+ − 259
$this->page_exists = true;
+ − 260
$this->cpage = $this->pages[$this->page];
+ − 261
$this->namespace = $this->cpage['namespace'];
+ − 262
if(!isset($this->cpage['wiki_mode'])) $this->cpage['wiki_mode'] = 2;
+ − 263
+ − 264
// Determine the wiki mode for this page, now that we have this->cpage established
+ − 265
if($this->cpage['wiki_mode'] == 2)
+ − 266
{
+ − 267
$this->wiki_mode = (int)getConfig('wiki_mode');
+ − 268
}
+ − 269
else
+ − 270
{
+ − 271
$this->wiki_mode = $this->cpage['wiki_mode'];
+ − 272
}
+ − 273
// Allow the user to create/modify his user page uncondtionally (admins can still protect the page)
+ − 274
if($this->page == $this->nslist['User'].str_replace(' ', '_', $session->username))
+ − 275
{
+ − 276
$this->wiki_mode = true;
+ − 277
}
+ − 278
// And above all, if the site requires wiki mode to be off for non-logged-in users, disable it now
+ − 279
if(getConfig('wiki_mode_require_login')=='1' && !$session->user_logged_in)
+ − 280
{
+ − 281
$this->wiki_mode = false;
+ − 282
}
+ − 283
if($this->cpage['protected'] == 2)
+ − 284
{
+ − 285
// The page is semi-protected, determine permissions
+ − 286
if($session->user_logged_in && $session->reg_time + 60*60*24*4 < time())
+ − 287
{
+ − 288
$this->page_protected = 0;
+ − 289
}
+ − 290
else
+ − 291
{
+ − 292
$this->page_protected = 1;
+ − 293
}
+ − 294
}
+ − 295
else
+ − 296
{
+ − 297
$this->page_protected = $this->cpage['protected'];
+ − 298
}
+ − 299
}
+ − 300
else
+ − 301
{
+ − 302
dc_here('paths: page doesn\'t exist, creating new page in memory<br />our page ID is: '.$this->page);
+ − 303
$this->page_exists = false;
15
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 304
$page_name = dirtify_page_id($this->page);
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 305
$page_name = str_replace('_', ' ', $page_name);
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 306
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 307
$pid_cleaned = sanitize_page_id($this->page);
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 308
if ( $pid_cleaned != $this->page )
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 309
{
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 310
redirect($pid_cleaned, 'Sanitizer message', 'page id sanitized', 0);
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 311
}
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 312
1
+ − 313
$this->cpage = Array(
15
ad5986a53197
Fixed complicated SQL injection vulnerability in URL handler, updated license info for Tigra Tree Menu, and killed one XSS vulnerability
Dan
diff
changeset
+ − 314
'name'=>$page_name,
1
+ − 315
'urlname'=>$this->page,
+ − 316
'namespace'=>'Article',
+ − 317
'special'=>0,
+ − 318
'visible'=>0,
+ − 319
'comments_on'=>1,
+ − 320
'protected'=>0,
+ − 321
'delvotes'=>0,
+ − 322
'delvote_ips'=>'',
+ − 323
'wiki_mode'=>2,
+ − 324
);
+ − 325
// Look for a namespace prefix in the urlname, and assign a different namespace, if necessary
+ − 326
$k = array_keys($this->nslist);
+ − 327
for($i=0;$i<sizeof($this->nslist);$i++)
+ − 328
{
+ − 329
$ln = strlen($this->nslist[$k[$i]]);
+ − 330
if( substr($this->page, 0, $ln) == $this->nslist[$k[$i]] )
+ − 331
{
+ − 332
$this->cpage['namespace'] = $k[$i];
+ − 333
$this->cpage['urlname_nons'] = substr($this->page, strlen($this->nslist[$this->cpage['namespace']]), strlen($this->page));
+ − 334
if(!isset($this->cpage['wiki_mode']))
+ − 335
{
+ − 336
$this->cpage['wiki_mode'] = 2;
+ − 337
}
+ − 338
}
+ − 339
}
+ − 340
$this->namespace = $this->cpage['namespace'];
+ − 341
+ − 342
if($this->namespace=='System')
+ − 343
{
+ − 344
$this->cpage['protected'] = 1;
+ − 345
}
+ − 346
if($this->namespace=='Special')
+ − 347
{
+ − 348
// Can't load nonexistent pages
+ − 349
$this->main_page();
+ − 350
}
+ − 351
// Allow the user to create/modify his user page uncondtionally (admins can still protect the page)
+ − 352
if($this->page == $this->nslist['User'].str_replace(' ', '_', $session->username))
+ − 353
{
+ − 354
$this->wiki_mode = true;
+ − 355
}
+ − 356
}
+ − 357
// This is used in the admin panel to keep track of form submission targets
+ − 358
$this->cpage['module'] = $this->cpage['urlname'];
+ − 359
+ − 360
// Page is set up, call any hooks
+ − 361
$code = $plugins->setHook('page_set');
+ − 362
foreach ( $code as $cmd )
+ − 363
{
+ − 364
eval($cmd);
+ − 365
}
+ − 366
+ − 367
$session->init_permissions();
+ − 368
}
+ − 369
+ − 370
function add_page($flags)
+ − 371
{
+ − 372
//dc_dump($flags, 'paths: page added by plugin:');
+ − 373
$flags['urlname_nons'] = $flags['urlname'];
+ − 374
$flags['urlname'] = $this->nslist[$flags['namespace']] . $flags['urlname']; // Applies the User:/File:/etc prefixes to the URL names
+ − 375
$pages_len = sizeof($this->pages)/2;
+ − 376
$this->pages[$pages_len] = $flags;
+ − 377
$this->pages[$flags['urlname']] =& $this->pages[$pages_len];
+ − 378
}
+ − 379
+ − 380
function main_page()
+ − 381
{
+ − 382
if( is_string(getConfig('main_page')) )
+ − 383
{
+ − 384
header('Location: '.makeUrl(getConfig('main_page')));
+ − 385
die('If you aren\'t redirected, <a href="' . makeUrl(getConfig('main_page')) . '">click here</a>.');
+ − 386
}
+ − 387
else
+ − 388
{
+ − 389
header('Location: '.makeUrl($this->pages[0]['urlname']));
+ − 390
die('If you aren\'t redirected, <a href="' . makeUrl($this->pages[0]['urlname']) . '">click here</a>.');
+ − 391
}
+ − 392
exit;
+ − 393
}
+ − 394
+ − 395
function sysmsg($n)
+ − 396
{
+ − 397
global $db, $session, $paths, $template, $plugins; // Common objects
+ − 398
dc_here('paths: system message requested: '.$n);
+ − 399
$q = $db->sql_query('SELECT page_text, char_tag FROM '.table_prefix.'page_text WHERE page_id=\''.$db->escape($n).'\' AND namespace=\'System\'');
+ − 400
if( !$q )
+ − 401
{
+ − 402
$db->_die('Error during generic selection of system page data.');
+ − 403
}
+ − 404
if($db->numrows() < 1)
+ − 405
{
+ − 406
return false;
+ − 407
//$db->_die('Error during generic selection of system page data: there were no rows in the text table that matched the page text query.');
+ − 408
}
+ − 409
$r = $db->fetchrow();
+ − 410
$db->free_result();
+ − 411
$message = $r['page_text'];
+ − 412
+ − 413
$message = preg_replace('/<noinclude>(.*?)<\/noinclude>/is', '', $message);
+ − 414
+ − 415
return $message;
+ − 416
}
+ − 417
function get_pageid_from_url()
+ − 418
{
+ − 419
if(isset($_GET['title']))
+ − 420
{
+ − 421
if( $_GET['title'] == '' && getConfig('main_page') != '' )
+ − 422
{
+ − 423
$this->main_page();
+ − 424
}
+ − 425
if(strstr($_GET['title'], ' '))
+ − 426
{
+ − 427
$loc = urldecode(rawurldecode($_SERVER['REQUEST_URI']));
+ − 428
$loc = str_replace(' ', '_', $loc);
+ − 429
$loc = str_replace('+', '_', $loc);
+ − 430
header('Location: '.$loc);
+ − 431
exit;
+ − 432
}
+ − 433
$ret = $_GET['title'];
+ − 434
}
+ − 435
elseif(isset($_SERVER['PATH_INFO']))
+ − 436
{
+ − 437
$pi = explode('/', $_SERVER['PATH_INFO']);
+ − 438
+ − 439
if(!isset($pi[1]) || (isset($pi[1]) && $pi[1] == ''))
+ − 440
{
+ − 441
return false;
+ − 442
}
+ − 443
+ − 444
if(strstr($pi[1], ' '))
+ − 445
{
+ − 446
$loc = urldecode(rawurldecode($_SERVER['REQUEST_URI']));
+ − 447
$loc = str_replace(' ', '_', $loc);
+ − 448
$loc = str_replace('+', '_', $loc);
+ − 449
header('Location: '.$loc);
+ − 450
exit;
+ − 451
}
+ − 452
if( !( substr($pi[1], 0, strlen($this->nslist['Special'])) == $this->nslist['Special'] ) )
+ − 453
{
+ − 454
unset($pi[0]);
+ − 455
$pi[1] = implode('/', $pi);
+ − 456
}
+ − 457
$ret = $pi[1];
+ − 458
}
+ − 459
else
+ − 460
{
+ − 461
$k = array_keys($_GET);
+ − 462
foreach($k as $c)
+ − 463
{
+ − 464
if(substr($c, 0, 1) == '/')
+ − 465
{
+ − 466
$ret = substr($c, 1, strlen($c));
+ − 467
if(substr($ret, 0, strlen($this->nslist['Special'])) == $this->nslist['Special'] ||
+ − 468
substr($ret, 0, strlen($this->nslist['Admin'])) == $this->nslist['Admin'])
+ − 469
{
+ − 470
$ret = explode('/', $ret);
+ − 471
$ret = $ret[0];
+ − 472
}
+ − 473
break;
+ − 474
}
+ − 475
}
+ − 476
}
+ − 477
+ − 478
return ( isset($ret) ) ? $ret : false;
+ − 479
}
+ − 480
// Parses a (very carefully formed) array into Javascript code compatible with the Tigra Tree Menu used in the admin menu
+ − 481
function parseAdminTree()
+ − 482
{
+ − 483
$k = array_keys($this->admin_tree);
+ − 484
$i = 0;
+ − 485
$ret = '';
+ − 486
$ret .= "var TREE_ITEMS = [\n ['Administration panel home', 'javascript:ajaxPage(\'".$this->nslist['Admin']."Home\');',\n ";
+ − 487
foreach($k as $key)
+ − 488
{
+ − 489
$i++;
+ − 490
$ret .= "['".$key."', 'javascript:trees[0].toggle($i)', \n";
+ − 491
foreach($this->admin_tree[$key] as $c)
+ − 492
{
+ − 493
$i++;
+ − 494
$ret .= " ['".$c['name']."', 'javascript:ajaxPage(\\'".$this->nslist['Admin'].$c['pageid']."\\');'],\n";
+ − 495
}
+ − 496
$ret .= " ],\n";
+ − 497
}
+ − 498
$ret .= " ['Log out of admin panel', 'javascript:ajaxPage(\\'".$this->nslist['Admin']."AdminLogout\\');'],\n";
+ − 499
// I used this while I painstakingly wrote the Runt code that auto-expands certain nodes based on the value of a bitfield stored in a cookie. *shudders*
+ − 500
// $ret .= " ['(debug) Clear menu bitfield', 'javascript:createCookie(\\'admin_menu_state\\', \\'1\\', 365);'],\n";
+ − 501
$ret .= "]\n];";
+ − 502
return $ret;
+ − 503
}
+ − 504
function addAdminNode($section, $page_title, $url)
+ − 505
{
+ − 506
if(!isset($this->admin_tree[$section]))
+ − 507
{
+ − 508
$this->admin_tree[$section] = Array();
+ − 509
}
+ − 510
$this->admin_tree[$section][] = Array(
+ − 511
'name'=>$page_title,
+ − 512
'pageid'=>$url
+ − 513
);
+ − 514
}
+ − 515
function getParam($id = 0)
+ − 516
{
55
+ − 517
// using !empty here is a bugfix for IIS 5.x on Windows 2000 Server
+ − 518
// It may affect other IIS versions as well
+ − 519
if(isset($_SERVER['PATH_INFO']) && !empty($_SERVER['PATH_INFO']))
1
+ − 520
{
+ − 521
$pi = explode('/', $_SERVER['PATH_INFO']);
+ − 522
$id = $id + 2;
+ − 523
return isset($pi[$id]) ? $pi[$id] : false;
+ − 524
}
+ − 525
else if( isset($_GET['title']) )
+ − 526
{
+ − 527
$pi = explode('/', $_GET['title']);
+ − 528
$id = $id + 1;
+ − 529
return isset($pi[$id]) ? $pi[$id] : false;
+ − 530
}
+ − 531
else
+ − 532
{
+ − 533
$k = array_keys($_GET);
+ − 534
foreach($k as $c)
+ − 535
{
+ − 536
if(substr($c, 0, 1) == '/')
+ − 537
{
+ − 538
// Bugfix for apache somehow passing dots as underscores
+ − 539
global $mime_types;
+ − 540
$exts = array_keys($mime_types);
+ − 541
$exts = '(' . implode('|', $exts) . ')';
+ − 542
if ( preg_match( '#_'.$exts.'#i', $c ) )
+ − 543
$c = preg_replace( '#_'.$exts.'#i', '.\\1', $c );
+ − 544
+ − 545
$pi = explode('/', $c);
+ − 546
$id = $id + 2;
+ − 547
return isset($pi[$id]) ? $pi[$id] : false;
+ − 548
}
+ − 549
}
+ − 550
return false;
+ − 551
}
+ − 552
}
+ − 553
+ − 554
function getAllParams()
+ − 555
{
55
+ − 556
// using !empty here is a bugfix for IIS 5.x on Windows 2000 Server
+ − 557
// It may affect other IIS versions as well
+ − 558
if(isset($_SERVER['PATH_INFO']) && !empty($_SERVER['PATH_INFO']))
1
+ − 559
{
+ − 560
$pi = explode('/', $_SERVER['PATH_INFO']);
+ − 561
unset($pi[0], $pi[1]);
+ − 562
return implode('/', $pi);
+ − 563
}
+ − 564
else if( isset($_GET['title']) )
+ − 565
{
+ − 566
$pi = explode('/', $_GET['title']);
+ − 567
unset($pi[0]);
+ − 568
return implode('/', $pi);
+ − 569
}
+ − 570
else
+ − 571
{
+ − 572
$k = array_keys($_GET);
+ − 573
foreach($k as $c)
+ − 574
{
+ − 575
if(substr($c, 0, 1) == '/')
+ − 576
{
+ − 577
// Bugfix for apache somehow passing dots as underscores
+ − 578
global $mime_types;
+ − 579
$exts = array_keys($mime_types);
+ − 580
$exts = '(' . implode('|', $exts) . ')';
+ − 581
if ( preg_match( '#_'.$exts.'#i', $c ) )
+ − 582
$c = preg_replace( '#_'.$exts.'#i', '.\\1', $c );
+ − 583
+ − 584
$pi = explode('/', $c);
+ − 585
unset($pi[0], $pi[1]);
+ − 586
return implode('/', $pi);
+ − 587
}
+ − 588
}
+ − 589
return false;
+ − 590
}
+ − 591
}
+ − 592
+ − 593
/**
+ − 594
* Creates a new namespace in memory
+ − 595
* @param string $id the namespace ID
+ − 596
* @param string $prefix the URL prefix, must not be blank or already used
+ − 597
* @return bool true on success false on failure
+ − 598
*/
+ − 599
+ − 600
function create_namespace($id, $prefix)
+ − 601
{
+ − 602
if(in_array($prefix, $this->nslist))
+ − 603
{
+ − 604
// echo '<b>Warning:</b> pathManager::create_namespace: Prefix "'.$prefix.'" is already taken<br />';
+ − 605
return false;
+ − 606
}
+ − 607
if( isset($this->nslist[$id]) )
+ − 608
{
+ − 609
// echo '<b>Warning:</b> pathManager::create_namespace: Namespace ID "'.$prefix.'" is already taken<br />';
+ − 610
return false;
+ − 611
}
+ − 612
$this->nslist[$id] = $prefix;
+ − 613
}
+ − 614
+ − 615
/**
+ − 616
* Fetches the page texts for searching
+ − 617
*/
+ − 618
+ − 619
function fetch_page_search_texts()
+ − 620
{
+ − 621
global $db, $session, $paths, $template, $plugins; // Common objects
+ − 622
$texts = Array();
+ − 623
$q = $db->sql_query('SELECT t.page_id,t.namespace,t.page_text,t.char_tag FROM '.table_prefix.'page_text AS t
+ − 624
LEFT JOIN '.table_prefix.'pages AS p
+ − 625
ON t.page_id=p.urlname
+ − 626
WHERE p.namespace=t.namespace
+ − 627
AND ( p.password=\'\' OR p.password=\'da39a3ee5e6b4b0d3255bfef95601890afd80709\' )
+ − 628
AND p.visible=1;'); // Only indexes "visible" pages
+ − 629
+ − 630
if( !$q )
+ − 631
{
+ − 632
return false;
+ − 633
}
+ − 634
while($row = $db->fetchrow())
+ − 635
{
+ − 636
$pid = $this->nslist[$row['namespace']] . $row['page_id'];
+ − 637
$texts[$pid] = $row['page_text'];
+ − 638
}
+ − 639
$db->free_result();
+ − 640
+ − 641
return $texts;
+ − 642
}
+ − 643
+ − 644
/**
+ − 645
* Fetches a MySQL search query to use for Searcher::searchMySQL()
+ − 646
*/
+ − 647
+ − 648
function fetch_page_search_resource()
+ − 649
{
+ − 650
global $db, $session, $paths, $template, $plugins; // Common objects
+ − 651
// sha1('') returns "da39a3ee5e6b4b0d3255bfef95601890afd80709"
+ − 652
$texts = 'SELECT t.page_text,CONCAT(\'ns=\',t.namespace,\';pid=\',t.page_id) FROM '.table_prefix.'page_text AS t
+ − 653
LEFT JOIN '.table_prefix.'pages AS p
+ − 654
ON ( t.page_id=p.urlname AND t.namespace=p.namespace )
+ − 655
WHERE p.namespace=t.namespace
+ − 656
AND ( p.password=\'\' OR p.password=\'da39a3ee5e6b4b0d3255bfef95601890afd80709\' )
+ − 657
AND p.visible=1;'; // Only indexes "visible" pages
+ − 658
return $texts;
+ − 659
}
+ − 660
+ − 661
/**
+ − 662
* Rebuilds the search index
+ − 663
*/
+ − 664
+ − 665
function rebuild_search_index()
+ − 666
{
+ − 667
global $db, $session, $paths, $template, $plugins; // Common objects
+ − 668
$search = new Searcher();
+ − 669
$texts = Array();
+ − 670
$textq = $db->sql_unbuffered_query($this->fetch_page_search_resource());
+ − 671
if(!$textq) $db->_die('');
+ − 672
while($row = $db->fetchrow_num())
+ − 673
{
+ − 674
$texts[(string)$row[1]] = $row[0];
+ − 675
}
+ − 676
$search->buildIndex($texts);
+ − 677
// echo '<pre>'.print_r($search->index, true).'</pre>';
+ − 678
// return;
+ − 679
$q = $db->sql_query('DELETE FROM '.table_prefix.'search_index');
+ − 680
if(!$q) return false;
+ − 681
$secs = Array();
+ − 682
$q = 'INSERT INTO '.table_prefix.'search_index(word,page_names) VALUES';
+ − 683
foreach($search->index as $word => $pages)
+ − 684
{
+ − 685
$secs[] = '(\''.$db->escape($word).'\', \''.$db->escape($pages).'\')';
+ − 686
}
+ − 687
$q .= implode(',', $secs);
+ − 688
unset($secs);
+ − 689
$q .= ';';
+ − 690
$result = $db->sql_query($q);
+ − 691
$db->free_result();
+ − 692
if($result)
+ − 693
return true;
+ − 694
else
+ − 695
$db->_die('The search index was trying to rebuild itself when the error occured.');
+ − 696
}
+ − 697
+ − 698
/**
+ − 699
* Partially rebuilds the search index, removing/inserting entries only for the current page
+ − 700
* @param string $page_id
+ − 701
* @param string $namespace
+ − 702
*/
+ − 703
+ − 704
function rebuild_page_index($page_id, $namespace)
+ − 705
{
+ − 706
global $db, $session, $paths, $template, $plugins; // Common objects
+ − 707
if(!$db->sql_query('SELECT page_text FROM '.table_prefix.'page_text
+ − 708
WHERE page_id=\''.$db->escape($page_id).'\' AND namespace=\''.$db->escape($namespace).'\';'))
+ − 709
{
+ − 710
return $db->get_error();
+ − 711
}
+ − 712
$row = $db->fetchrow();
+ − 713
$db->free_result();
+ − 714
$search = new Searcher();
+ − 715
$search->buildIndex(Array("ns={$namespace};pid={$page_id}"=>$row['page_text']));
+ − 716
$new_index = $search->index;
+ − 717
+ − 718
$keys = array_keys($search->index);
+ − 719
foreach($keys as $i => $k)
+ − 720
{
+ − 721
$c =& $keys[$i];
+ − 722
$c = hexencode($c, '', '');
+ − 723
}
+ − 724
$keys = "word=0x" . implode ( " OR word=0x", $keys ) . "";
+ − 725
+ − 726
// Zap the cache
+ − 727
$cache = array_keys($search->index);
+ − 728
if ( count($cache) < 1 )
+ − 729
{
+ − 730
return false;
+ − 731
}
+ − 732
$cache = "query LIKE '%" . implode ( "%' OR query LIKE '%", $cache ) . "%'";
+ − 733
$db->sql_query('DELETE FROM '.table_prefix.'search_cache WHERE '.$cache);
+ − 734
+ − 735
$query = $db->sql_query('SELECT word,page_names FROM '.table_prefix.'search_index WHERE '.$keys.';');
+ − 736
+ − 737
while($row = $db->fetchrow())
+ − 738
{
+ − 739
$row['word'] = rtrim($row['word'], "\0");
+ − 740
$new_index[ $row['word'] ] = $row['page_names'] . ',' . $search->index[ $row['word'] ];
+ − 741
}
+ − 742
$db->free_result();
+ − 743
+ − 744
$db->sql_query('DELETE FROM '.table_prefix.'search_index WHERE '.$keys.';');
+ − 745
+ − 746
$secs = Array();
+ − 747
$q = 'INSERT INTO '.table_prefix.'search_index(word,page_names) VALUES';
+ − 748
foreach($new_index as $word => $pages)
+ − 749
{
+ − 750
$secs[] = '(\''.$db->escape($word).'\', \''.$db->escape($pages).'\')';
+ − 751
}
+ − 752
$q .= implode(',', $secs);
+ − 753
unset($secs);
+ − 754
$q .= ';';
+ − 755
if(!$db->check_query($q))
+ − 756
{
+ − 757
die('BUG: PathManager::rebuild_page_index: Query rejected by SQL parser:<pre>'.$q.'</pre>');
+ − 758
}
+ − 759
$result = $db->sql_query($q);
+ − 760
if($result)
+ − 761
return true;
+ − 762
else
+ − 763
$db->_die('The search index was trying to rebuild itself when the error occured.');
+ − 764
+ − 765
}
+ − 766
+ − 767
/**
+ − 768
* Creates an instance of the Searcher class, including index info
+ − 769
* @return object
+ − 770
*/
+ − 771
+ − 772
function makeSearcher($match_case = false)
+ − 773
{
+ − 774
global $db, $session, $paths, $template, $plugins; // Common objects
+ − 775
$search = new Searcher();
+ − 776
$q = $db->sql_query('SELECT word,page_names FROM '.table_prefix.'search_index;');
+ − 777
if(!$q)
+ − 778
{
+ − 779
echo $db->get_error();
+ − 780
return false;
+ − 781
}
+ − 782
$idx = Array();
+ − 783
while($row = $db->fetchrow($q))
+ − 784
{
+ − 785
$row['word'] = rtrim($row['word'], "\0");
+ − 786
$idx[$row['word']] = $row['page_names'];
+ − 787
}
+ − 788
$db->free_result();
+ − 789
$search->index = $idx;
+ − 790
if($match_case)
+ − 791
$search->match_case = true;
+ − 792
return $search;
+ − 793
}
+ − 794
+ − 795
/**
+ − 796
* Creates an associative array filled with the values of all the page titles
+ − 797
* @return array
+ − 798
*/
+ − 799
+ − 800
function get_page_titles()
+ − 801
{
+ − 802
$texts = Array();
+ − 803
for ( $i = 0; $i < sizeof($this->pages) / 2; $i++ )
+ − 804
{
+ − 805
$texts[$this->pages[$i]['urlname']] = $this->pages[$i]['name'];
+ − 806
}
+ − 807
return $texts;
+ − 808
}
+ − 809
+ − 810
/**
+ − 811
* Creates an instance of the Searcher class, including index info for page titles
+ − 812
* @return object
+ − 813
*/
+ − 814
+ − 815
function makeTitleSearcher($match_case = false)
+ − 816
{
+ − 817
global $db, $session, $paths, $template, $plugins; // Common objects
+ − 818
$search = new Searcher();
+ − 819
$texts = $this->get_page_titles();
+ − 820
$search->buildIndex($texts);
+ − 821
if($match_case)
+ − 822
$search->match_case = true;
+ − 823
return $search;
+ − 824
}
+ − 825
73
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 826
/**
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 827
* Returns a list of groups that a given page is a member of.
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 828
* @param string Page ID
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 829
* @param string Namespace
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 830
* @return array
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 831
*/
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 832
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 833
function get_page_groups($page_id, $namespace)
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 834
{
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 835
global $db, $session, $paths, $template, $plugins; // Common objects
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 836
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 837
$page_id = $db->escape(sanitize_page_id($page_id));
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 838
if ( !isset($this->nslist[$namespace]) )
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 839
die('$paths->get_page_groups(): HACKING ATTEMPT');
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 840
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 841
$group_list = array();
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 842
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 843
// What linked categories have this page?
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 844
$q = $db->sql_query('SELECT g.pg_id FROM '.table_prefix.'page_groups AS g
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 845
LEFT JOIN '.table_prefix.'categories AS c
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 846
ON ( c.category_id = g.pg_target AND g.pg_type = ' . PAGE_GRP_CATLINK . ' )
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 847
WHERE c.page_id=\'' . $page_id . '\' AND c.namespace=\'' . $namespace . '\';');
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 848
if ( !$q )
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 849
$db->_die();
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 850
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 851
while ( $row = $db->fetchrow() )
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 852
{
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 853
$group_list[] = $row['pg_id'];
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 854
}
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 855
74
68469a95658d
Various bugfixes and cleanups, too much to remember... see the diffs for what got changed :-)
Dan
diff
changeset
+ − 856
$db->free_result();
68469a95658d
Various bugfixes and cleanups, too much to remember... see the diffs for what got changed :-)
Dan
diff
changeset
+ − 857
73
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 858
// Static-page groups
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 859
$q = $db->sql_query('SELECT g.pg_id FROM '.table_prefix.'page_groups AS g
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 860
LEFT JOIN '.table_prefix.'page_group_members AS m
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 861
ON ( g.pg_id = m.pg_id )
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 862
WHERE m.page_id=\'' . $page_id . '\' AND m.namespace=\'' . $namespace . '\'
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 863
GROUP BY g.pg_id;');
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 864
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 865
if ( !$q )
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 866
$db->_die();
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 867
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 868
while ( $row = $db->fetchrow() )
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 869
{
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 870
$group_list[] = $row['pg_id'];
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 871
}
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 872
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 873
// Tagging ain't implemented yet ;-)
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 874
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 875
return $group_list;
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 876
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 877
}
0a74676a2f2f
Made the move to Loch Ness, and got some basic page grouping functionality working. TODO: fix some UI issues in Javascript ACL editor and change non-JS ACL editor to work with page groups too
Dan
diff
changeset
+ − 878
1
+ − 879
}
+ − 880
+ − 881
?>