| 41 |
41 |
exit();
|
| 42 |
42 |
}
|
| 43 |
43 |
*/
|
| 44 |
|
|
| 45 |
44 |
$sql = 'SELECT * FROM `'.TABLE_PREFIX.'pages` WHERE `page_id` = '.$page_id;
|
| 46 |
45 |
$results = $database->query($sql);
|
| 47 |
46 |
$results_array = $results->fetchRow();
|
| ... | ... | |
| 116 |
115 |
);
|
| 117 |
116 |
|
| 118 |
117 |
// Work-out if we should show the "manage sections" link
|
| 119 |
|
$sql = 'SELECT `section_id` FROM `'.TABLE_PREFIX.'sections` WHERE `page_id`='.$page_id.' AND `module`="menu_link"';
|
| 120 |
|
$query_sections = $database->query($sql);
|
| 121 |
|
if (isset($query_sections) && $query_sections->numRows() > 0)
|
|
118 |
$sql = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'sections` WHERE `page_id`='.$page_id.' AND `module`="menu_link"';
|
|
119 |
$sections_available = (intval($database->get_one($sql)) != 0);
|
|
120 |
if ($sections_available)
|
| 122 |
121 |
{
|
| 123 |
122 |
$template->set_var('DISPLAY_MANAGE_SECTIONS', 'display:none;');
|
| 124 |
123 |
} elseif(MANAGE_SECTIONS == 'enabled')
|
| ... | ... | |
| 194 |
193 |
$template->parse('group_list', 'group_list_block', true);
|
| 195 |
194 |
}
|
| 196 |
195 |
}
|
|
196 |
|
| 197 |
197 |
// Group list 2 (viewing_groups)
|
| 198 |
198 |
$viewing_groups = explode(',', str_replace('_', '', $results_array['viewing_groups']));
|
| 199 |
199 |
|
| ... | ... | |
| 471 |
471 |
$template->set_block('main_block', 'template_list_block', 'template_list');
|
| 472 |
472 |
|
| 473 |
473 |
$sql = 'SELECT * FROM `'.TABLE_PREFIX.'addons` WHERE `type` = "template" AND `function` = "template" order by `name`';
|
| 474 |
|
$result = $database->query($sql);
|
| 475 |
|
if (isset($result) && $result->numRows() > 0)
|
|
474 |
if( ($res_templates = $database->query($sql)) )
|
| 476 |
475 |
{
|
| 477 |
|
while($addon = $result->fetchRow())
|
|
476 |
while($rec_template = $res_templates->fetchRow())
|
| 478 |
477 |
{
|
| 479 |
478 |
// Check if the user has perms to use this template
|
| 480 |
|
if($addon['directory'] == $results_array['template'] OR $admin->get_permission($addon['directory'], 'template') == true)
|
|
479 |
if($rec_template['directory'] == $results_array['template'] OR $admin->get_permission($rec_template['directory'], 'template') == true)
|
| 481 |
480 |
{
|
| 482 |
|
$template->set_var('VALUE', $addon['directory']);
|
| 483 |
|
$template->set_var('NAME', $addon['name']);
|
| 484 |
|
if($addon['directory'] == $results_array['template'])
|
|
481 |
$template->set_var('VALUE', $rec_template['directory']);
|
|
482 |
$template->set_var('NAME', $rec_template['name']);
|
|
483 |
if($rec_template['directory'] == $results_array['template'])
|
| 485 |
484 |
{
|
| 486 |
485 |
$template->set_var('SELECTED', ' selected="selected"');
|
| 487 |
486 |
} else {
|
| ... | ... | |
| 533 |
532 |
$template->set_block('main_block', 'language_list_block', 'language_list');
|
| 534 |
533 |
|
| 535 |
534 |
$sql = 'SELECT * FROM `'.TABLE_PREFIX.'addons` WHERE `type` = "language" ORDER BY `name`';
|
| 536 |
|
$result = $database->query($sql);
|
| 537 |
|
if (isset($result) && $result->numRows() > 0)
|
|
535 |
if( ($res_languages = $database->query($sql)) )
|
| 538 |
536 |
{
|
| 539 |
|
while($addon = $result->fetchRow())
|
|
537 |
while($rec_language = $res_languages->fetchRow())
|
| 540 |
538 |
{
|
| 541 |
|
$l_codes[$addon['name']] = $addon['directory'];
|
| 542 |
|
$l_names[$addon['name']] = entities_to_7bit($addon['name']); // sorting-problem workaround
|
|
539 |
$l_codes[$rec_language['name']] = $rec_language['directory'];
|
|
540 |
$l_names[$rec_language['name']] = entities_to_7bit($rec_language['name']); // sorting-problem workaround
|
| 543 |
541 |
}
|
| 544 |
542 |
asort($l_names);
|
| 545 |
543 |
foreach($l_names as $l_name=>$v)
|
fixed unsave sql-queries in /admin/pages/settings