edit.php

this the oscommerce 3.0 aplha 4

<?php
/*
  $Id: $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2007 osCommerce

  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License v2 (1991)
  as published by the Free Software Foundation.
*/

  $Qtemplate = $osC_Database->query('select id from :table_templates where code = :code');
  $Qtemplate->bindTable(':table_templates', TABLE_TEMPLATES);
  $Qtemplate->bindValue(':code', $_GET['filter']);
  $Qtemplate->execute();

  $filter_id = $Qtemplate->valueInt('id');

  $boxes_array = array();

  $Qboxes = $osC_Database->query('select id, title from :table_templates_boxes where modules_group = :modules_group order by title');
  $Qboxes->bindTable(':table_templates_boxes', TABLE_TEMPLATES_BOXES);
  $Qboxes->bindValue(':modules_group', $_GET['set']);
  $Qboxes->execute();

  while ( $Qboxes->next() ) {
    $boxes_array[] = array('id' => $Qboxes->valueInt('id'),
                           'text' => $Qboxes->value('title'));
  }

  $pages_array = array(array('id' => $filter_id . '/*',
                             'text' => '*'));

  $d_boxes = new osC_DirectoryListing('../templates/' . $_GET['filter'] . '/content');
  $d_boxes->setRecursive(true);
  $d_boxes->setAddDirectoryToFilename(true);
  $d_boxes->setCheckExtension('php');
  $d_boxes->setExcludeEntries('.svn');

  foreach ( $d_boxes->getFiles(false) as $box ) {
    if ( $box['is_directory'] === true ) {
      $entry = array('id' => $filter_id . '/' . $box['name'] . '/*',
                     'text' => $box['name'] . '/*');
    } else {
      $page_filename = substr($box['name'], 0, strrpos($box['name'], '.'));

      $entry = array('id' => $filter_id . '/' . $page_filename,
                     'text' => $page_filename);
    }

    if ( ( $_GET['filter'] != DEFAULT_TEMPLATE ) && ( $d_boxes->getSize() > 0 ) ) {
      $entry['group'] = '-- ' . $_GET['filter'] . ' --';
    }

    $pages_array[] = $entry;
  }

  if ( $_GET['filter'] != DEFAULT_TEMPLATE ) {
    $d_boxes = new osC_DirectoryListing('../templates/' . DEFAULT_TEMPLATE . '/content');
    $d_boxes->setRecursive(true);
    $d_boxes->setAddDirectoryToFilename(true);
    $d_boxes->setCheckExtension('php');
    $d_boxes->setExcludeEntries('.svn');

    foreach ( $d_boxes->getFiles(false) as $box ) {
      if ( $box['is_directory'] === true ) {
        $entry = array('id' => $filter_id . '/' . $box['name'] . '/*',
                       'text' => $box['name'] . '/*');
      } else {
        $page_filename = substr($box['name'], 0, strrpos($box['name'], '.'));

        $entry = array('id' => $filter_id . '/' . $page_filename,
                       'text' => $page_filename);
      }

      $check_entry = $entry;
      $check_entry['group'] = '-- ' . $_GET['filter'] . ' --';

      if ( !in_array($check_entry, $pages_array) ) {
        $entry['group'] = '-- ' . DEFAULT_TEMPLATE . ' --';

        $pages_array[] = $entry;
      }
    }
  }

  require('includes/templates/' . $_GET['filter'] . '.php');

  $class = 'osC_Template_' . $_GET['filter'];
  $filter_template = new $class();

  $groups_array = array();

  foreach ( $filter_template->getGroups($_GET['set']) as $group ) {
    $groups_array[] = array('id' => $group,
                            'text' => $group);
  }

  $Qgroups = $osC_Database->query('select distinct b2p.boxes_group from :table_templates_boxes_to_pages b2p, :table_templates_boxes b where b2p.templates_id = :templates_id and b2p.templates_boxes_id = b.id and b.modules_group = :modules_group and b2p.boxes_group not in (:boxes_group) order by b2p.boxes_group');
  $Qgroups->bindTable(':table_templates_boxes_to_pages', TABLE_TEMPLATES_BOXES_TO_PAGES);
  $Qgroups->bindTable(':table_templates_boxes', TABLE_TEMPLATES_BOXES);
  $Qgroups->bindInt(':templates_id', $filter_id);
  $Qgroups->bindValue(':modules_group', $_GET['set']);
  $Qgroups->bindRaw(':boxes_group', '"' . implode('", "', $filter_template->getGroups($_GET['set'])) . '"');
  $Qgroups->execute();

  while ( $Qgroups->next() ) {
    $groups_array[] = array('id' => $Qgroups->value('boxes_group'),
                            'text' => $Qgroups->value('boxes_group'));
  }

  if ( !empty($groups_array) ) {
    array_unshift($groups_array, array('id' => null, 'text' => $osC_Language->get('please_select')));
  }

  $Qlayout = $osC_Database->query('select b2p.*, b.title as box_title from :table_templates_boxes_to_pages b2p, :table_templates_boxes b where b2p.id = :id and b2p.templates_boxes_id = b.id');
  $Qlayout->bindTable(':table_templates_boxes_to_pages', TABLE_TEMPLATES_BOXES_TO_PAGES);
  $Qlayout->bindTable(':table_templates_boxes', TABLE_TEMPLATES_BOXES);
  $Qlayout->bindInt(':id', $_GET['lID']);
  $Qlayout->execute();
?>

<h1><?php echo osc_link_object(osc_href_link_admin(FILENAME_DEFAULT, $osC_Template->getModule() . '&set=' . $_GET['set'] . '&filter=' . $_GET['filter']), $osC_Template->getPageTitle()); ?></h1>

<?php
  if ( $osC_MessageStack->size($osC_Template->getModule()) > 0 ) {
    echo $osC_MessageStack->output($osC_Template->getModule());
  }
?>

<div class="infoBoxHeading"><?php echo osc_icon('edit.png') . ' ' . $Qlayout->value('box_title'); ?></div>
<div class="infoBoxContent">
  <form name="lEdit" action="<?php echo osc_href_link_admin(FILENAME_DEFAULT, $osC_Template->getModule() . '&set=' . $_GET['set'] . '&filter=' . $_GET['filter'] . '&lID=' . $Qlayout->valueInt('id') . '&action=save'); ?>" method="post">

  <p><?php echo $osC_Language->get('introduction_edit_template_layout_module'); ?></p>

  <table border="0" width="100%" cellspacing="0" cellpadding="2">
    <tr>
      <td width="40%"><?php echo '<b>' . $osC_Language->get('field_module') . '</b>'; ?></td>
      <td width="60%"><?php echo $Qlayout->value('box_title'); ?></td>
    </tr>
    <tr>
      <td width="40%"><?php echo '<b>' . $osC_Language->get('field_pages') . '</b>'; ?></td>
      <td width="60%"><?php echo osc_draw_pull_down_menu('content_page', $pages_array, $Qlayout->valueInt('templates_id') . '/' . $Qlayout->value('content_page'), 'style="width: 100%;"'); ?></td>
    </tr>
    <tr>
      <td width="40%">&nbsp;</td>
      <td width="60%"><?php echo osc_draw_checkbox_field('page_specific', null, ($Qlayout->valueInt('page_specific') === 1 ? true : false)) . '&nbsp;<b>' . $osC_Language->get('field_page_specific') . '</b>'; ?></td>
    </tr>
    <tr>
      <td width="40%"><?php echo '<b>' . $osC_Language->get('field_group') . '</b>'; ?></td>
      <td width="60%">

<?php
  if ( !empty($groups_array) ) {
    echo osc_draw_pull_down_menu('group', $groups_array, $Qlayout->value('boxes_group'), 'style="width: 30%;"') . '&nbsp;&nbsp;<b>' . $osC_Language->get('field_group_new') . '</b>&nbsp;';
  }

  echo osc_draw_input_field('group_new', null, 'style="width: ' . (empty($groups_array) ? '100%' : '40%') . ';"');
?>

      </td>
    </tr>
    <tr>
      <td width="40%"><?php echo '<b>' . $osC_Language->get('field_sort_order') . '</b>'; ?></td>
      <td width="60%"><?php echo osc_draw_input_field('sort_order', $Qlayout->valueInt('sort_order'), 'style="width: 100%;"'); ?></td>
    </tr>
  </table>

  <p align="center"><?php echo osc_draw_hidden_field('subaction', 'confirm') . '<input type="submit" value="' . $osC_Language->get('button_save') . '" class="operationButton" /> <input type="button" value="' . $osC_Language->get('button_cancel') . '" onclick="document.location.href=\'' . osc_href_link_admin(FILENAME_DEFAULT, $osC_Template->getModule() . '&set=' . $_GET['set'] . '&filter=' . $_GET['filter']) . '\';" class="operationButton" />'; ?></p>

  </form>
</div>