Revision 1346
Added by Dietmar over 14 years ago
| index.php | ||
|---|---|---|
| 36 | 36 |
// $database = new database(); |
| 37 | 37 |
|
| 38 | 38 |
// Get page list from database |
| 39 |
$sql = 'SELECT * FROM `'.TABLE_PREFIX.'pages` WHERE `parent` = '.$parent; |
|
| 40 |
$sql .= (PAGE_TRASH != 'inline') ? ' AND `visibility` != "deleted"' : '';
|
|
| 41 |
$sql .= ' ORDER BY `position` ASC';
|
|
| 39 |
$sql = 'SELECT * FROM `'.TABLE_PREFIX.'pages` WHERE `parent` = '.$parent.' ';
|
|
| 40 |
$sql .= (PAGE_TRASH != 'inline') ? 'AND `visibility` != \'deleted\' ' : ' ';
|
|
| 41 |
$sql .= 'ORDER BY `position` ASC'; |
|
| 42 | 42 |
$get_pages = $database->query($sql); |
| 43 | 43 |
/* |
| 44 | 44 |
if(PAGE_TRASH != 'inline') |
| ... | ... | |
| 88 | 88 |
} |
| 89 | 89 |
} |
| 90 | 90 |
// Work out if we should show a plus or not |
| 91 |
$sql = 'SELECT `page_id`,`admin_groups`,`admin_users` FROM `'.TABLE_PREFIX.'pages` WHERE `parent` = '.$page['page_id']; |
|
| 92 |
$sql .= (PAGE_TRASH != 'inline') ? ' AND `visibility` != "deleted"' : '';
|
|
| 91 |
$sql = 'SELECT `page_id`,`admin_groups`,`admin_users` FROM `'.TABLE_PREFIX.'pages` WHERE `parent` = '.$page['page_id'].' ';
|
|
| 92 |
$sql .= (PAGE_TRASH != 'inline') ? 'AND `visibility` != \'deleted\' ' : ' ';
|
|
| 93 | 93 |
// $sql .= ' ORDER BY `position` ASC'; |
| 94 | 94 |
$get_page_subs = $database->query($sql); |
| 95 | 95 |
/* |
| ... | ... | |
| 193 | 193 |
if(MANAGE_SECTIONS == 'enabled' && $admin->get_permission('pages_modify')==true && $can_modify==true)
|
| 194 | 194 |
{
|
| 195 | 195 |
|
| 196 |
$sql = 'SELECT `publ_start`, `publ_end` FROM `'.TABLE_PREFIX.'sections`'; |
|
| 197 |
$sql .= ' WHERE `page_id` = '.$page['page_id'].' AND `module` != "menu_link"';
|
|
| 196 |
$sql = 'SELECT `publ_start`, `publ_end` FROM `'.TABLE_PREFIX.'sections` ';
|
|
| 197 |
$sql .= 'WHERE `page_id` = '.$page['page_id'].' AND `module` != \'menu_link\' ';
|
|
| 198 | 198 |
$query_sections = $database->query($sql); |
| 199 | 199 |
|
| 200 | 200 |
// $query_sections = $database->query("SELECT publ_start, publ_end FROM ".TABLE_PREFIX."sections WHERE page_id = '{$page['page_id']}' AND module != 'menu_link'");
|
Also available in: Unified diff
Ticket #999 wrong sql statement in admin/pages/index.php (Tks to Lucutus)