documentation/zencart/ezpages_8php_source.html

00001 <?php
00010 // Sets the status of a page
00011   function zen_set_ezpage_status($pages_id, $status, $status_field) {
00012   global $db;
00013     if ($status == '1') {
00014       return $db->Execute("update " . TABLE_EZPAGES . " set " . zen_db_input($status_field) . " = '0'  where pages_id = '" . (int)$pages_id . "'");
00015     } elseif ($status == '0') {
00016       return $db->Execute("update " . TABLE_EZPAGES . " set " . zen_db_input($status_field) . " = '1'  where pages_id = '" . (int)$pages_id . "'");
00017     } else {
00018       return -1;
00019     }
00020   }
00021
00022
00023   require('includes/application_top.php');
00024
00025   if (!isset($_SESSION['ez_sort_order'])) {
00026     $_SESSION['ez_sort_order'] = 0;
00027   }
00028   if (!isset($_GET['reset_ez_sort_order'])) {
00029     $reset_ez_sort_order = $_SESSION['ez_sort_order'];
00030   }
00031
00032   if ($_GET['action'] == 'set_editor') {
00033     // Reset will be done by init_html_editor.php. Now we simply redirect to refresh page properly.
00034     $action='';
00035     zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN));
00036   }
00037
00038   $action = (isset($_GET['action']) ? $_GET['action'] : '');
00039   if (zen_not_null($action)) {
00040     switch ($action) {
00041       case 'set_ez_sort_order':
00042         $_SESSION['ez_sort_order'] = $_GET['reset_ez_sort_order'];
00043         $action='';
00044         zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . ($_GET['ezID'] != '' ? '&ezID=' . $_GET['ezID'] : '')));
00045         break;
00046       case 'setflag':
00047         if ( ($_GET['flag'] == '0') || ($_GET['flag'] == '1') ) {
00048           zen_set_ezpage_status(zen_db_prepare_input($_GET['ezID']), zen_db_prepare_input($_GET['flag']));
00049           $messageStack->add(SUCCESS_PAGE_STATUS_UPDATED, 'success');
00050         } else {
00051           $messageStack->add(ERROR_UNKNOWN_STATUS_FLAG, 'error');
00052         }
00053         zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $_GET['ezID']));
00054         break;
00055
00056       case 'page_open_new_window':
00057         zen_set_ezpage_status(zen_db_prepare_input($_GET['ezID']), zen_db_prepare_input($_GET['current']), 'page_open_new_window');
00058         $messageStack->add(SUCCESS_PAGE_STATUS_UPDATED, 'success');
00059         zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $_GET['ezID']));
00060         break;
00061       case 'page_is_ssl':
00062         zen_set_ezpage_status(zen_db_prepare_input($_GET['ezID']), zen_db_prepare_input($_GET['current']), 'page_is_ssl');
00063         $messageStack->add(SUCCESS_PAGE_STATUS_UPDATED, 'success');
00064         zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $_GET['ezID']));
00065         break;
00066       case 'status_header':
00067         zen_set_ezpage_status(zen_db_prepare_input($_GET['ezID']), zen_db_prepare_input($_GET['current']), 'status_header');
00068         $messageStack->add(SUCCESS_PAGE_STATUS_UPDATED, 'success');
00069         zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $_GET['ezID']));
00070         break;
00071       case 'status_sidebox':
00072         zen_set_ezpage_status(zen_db_prepare_input($_GET['ezID']), zen_db_prepare_input($_GET['current']), 'status_sidebox');
00073         $messageStack->add(SUCCESS_PAGE_STATUS_UPDATED, 'success');
00074         zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $_GET['ezID']));
00075         break;
00076       case 'status_footer':
00077         zen_set_ezpage_status(zen_db_prepare_input($_GET['ezID']), zen_db_prepare_input($_GET['current']), 'status_footer');
00078         $messageStack->add(SUCCESS_PAGE_STATUS_UPDATED, 'success');
00079         zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $_GET['ezID']));
00080         break;
00081       case 'status_toc':
00082         zen_set_ezpage_status(zen_db_prepare_input($_GET['ezID']), zen_db_prepare_input($_GET['current']), 'status_toc');
00083         $messageStack->add(SUCCESS_PAGE_STATUS_UPDATED, 'success');
00084         zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $_GET['ezID']));
00085         break;
00086       case 'insert':
00087       case 'update':
00088         if (isset($_POST['pages_id'])) $pages_id = zen_db_prepare_input($_POST['pages_id']);
00089         $pages_title = zen_db_prepare_input($_POST['pages_title']);
00090         $page_open_new_window = (int)$_POST['page_open_new_window'];
00091         $page_is_ssl  = (int)$_POST['page_is_ssl'];
00092
00093         $pages_html_text = zen_db_prepare_input($_POST['pages_html_text']);
00094         $alt_url = zen_db_prepare_input($_POST['alt_url']);
00095
00096         $alt_url_external = zen_db_prepare_input($_POST['alt_url_external']);
00097
00098         $pages_header_sort_order = (int)$_POST['header_sort_order'];
00099         $pages_sidebox_sort_order = (int)$_POST['sidebox_sort_order'];
00100         $pages_footer_sort_order = (int)$_POST['footer_sort_order'];
00101         $pages_toc_sort_order = (int)$_POST['toc_sort_order'];
00102
00103         $toc_chapter = (int)$_POST['toc_chapter'];
00104
00105         $status_header = ($pages_header_sort_order == 0 ? 0 : (int)$_POST['status_header']);
00106         $status_sidebox = ($pages_sidebox_sort_order == 0 ? 0 : (int)$_POST['status_sidebox']);
00107         $status_footer = ($pages_footer_sort_order == 0 ? 0 : (int)$_POST['status_footer']);
00108         $status_toc = ($pages_toc_sort_order == 0 ? 0 : (int)$_POST['status_toc']);
00109
00110         $page_error = false;
00111         if (empty($pages_title)) {
00112           $messageStack->add(ERROR_PAGE_TITLE_REQUIRED, 'error');
00113           $page_error = true;
00114         }
00115         if (empty($pages_html_text)) {
00116         }
00117
00118         $zv_link_method_cnt = 0;
00119         if ($alt_url !='') {
00120           $zv_link_method_cnt++;
00121         }
00122         if ($alt_url_external !='') {
00123           $zv_link_method_cnt++;
00124         }
00125         if ($pages_html_text !='' and strlen(trim($pages_html_text)) > 6) {
00126           $zv_link_method_cnt++;
00127         }
00128         if ($zv_link_method_cnt > 1) {
00129           $messageStack->add(ERROR_MULTIPLE_HTML_URL, 'error');
00130           $page_error = true;
00131         }
00132
00133         if ($page_error == false) {
00134           $sql_data_array = array('pages_title' => $pages_title,
00135                                   'page_open_new_window' => $page_open_new_window,
00136                                   'page_is_ssl' => $page_is_ssl,
00137                                   'alt_url' => $alt_url,
00138                                   'alt_url_external' => $alt_url_external,
00139                                   'status_header' => $status_header,
00140                                   'status_sidebox' => $status_sidebox,
00141                                   'status_footer' => $status_footer,
00142                                   'status_toc' => $status_toc,
00143                                   'header_sort_order' => $pages_header_sort_order,
00144                                   'sidebox_sort_order' => $pages_sidebox_sort_order,
00145                                   'footer_sort_order' => $pages_footer_sort_order,
00146                                   'toc_sort_order' => $pages_toc_sort_order,
00147                                   'toc_chapter' => $toc_chapter,
00148                                   'pages_html_text' => $pages_html_text);
00149
00150           if ($action == 'insert') {
00151             zen_db_perform(TABLE_EZPAGES, $sql_data_array);
00152             $pages_id = $db->insert_ID();
00153             $messageStack->add(SUCCESS_PAGE_INSERTED, 'success');
00154           } elseif ($action == 'update') {
00155             zen_db_perform(TABLE_EZPAGES, $sql_data_array, 'update', "pages_id = '" . (int)$pages_id . "'");
00156             $messageStack->add(SUCCESS_PAGE_UPDATED, 'success');
00157           }
00158
00159           zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . 'ezID=' . $pages_id));
00160         } else {
00161           if ($page_error == false) {
00162             $action = 'new';
00163           } else {
00164             $_GET['pages_id'] = $pages_id;
00165             $_GET['ezID'] = $pages_id;
00166             $_GET['action'] = 'new';
00167             $action = 'new';
00168             $ezID = $pages_id;
00169             $page = $_GET['page'];
00170           }
00171         }
00172         break;
00173       case 'deleteconfirm':
00174         $pages_id = zen_db_prepare_input($_POST['ezID']);
00175         $db->Execute("delete from " . TABLE_EZPAGES . " where pages_id = '" . (int)$pages_id . "'");
00176         $messageStack->add(SUCCESS_PAGE_REMOVED, 'success');
00177         zen_redirect(zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page']));
00178         break;
00179     }
00180   }
00181 ?>
00182 <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">
00183 <html <?php echo HTML_PARAMS; ?>>
00184 <head>
00185 <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
00186 <title><?php echo TITLE; ?></title>
00187 <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">
00188 <link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">
00189 <script language="javascript" src="includes/menu.js"></script>
00190 <script language="javascript" src="includes/general.js"></script>
00191 <script type="text/javascript">
00192   <!--
00193   function init()
00194   {
00195     cssjsmenu('navbar');
00196     if (document.getElementById)
00197     {
00198       var kill = document.getElementById('hoverJS');
00199       kill.disabled = true;
00200     }
00201   if (typeof _editor_url == "string") HTMLArea.replaceAll();
00202   }
00203   // -->
00204 </script>
00205 <?php if ($editor_handler != '') include ($editor_handler); ?>
00206 </head>
00207 <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onLoad="init()">
00208 <?php require(DIR_WS_INCLUDES . 'header.php'); ?>
00209 <!-- header_eof //-->
00210 <!-- body //-->
00211 <table border="0" width="100%" cellspacing="2" cellpadding="2">
00212   <tr>
00213 <!-- body_text //-->
00214     <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
00215       <tr>
00216         <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
00217           <tr>
00218             <td class="pageHeading"><?php echo HEADING_TITLE . ' ' . ($ezID != '' ? TEXT_INFO_PAGES_ID . $ezID : TEXT_INFO_PAGES_ID_SELECT); ?></td>
00219             <td class="pageHeading" align="right"><?php echo zen_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
00220             <td class="main">
00221 <?php
00222       if ($action != 'new') {
00223 // toggle switch for display sort order
00224         $ez_sort_order_array = array(array('id' => '0', 'text' => TEXT_SORT_CHAPTER_TOC_TITLE),
00225                               array('id' => '1', 'text' => TEXT_SORT_HEADER_TITLE),
00226                               array('id' => '2', 'text' => TEXT_SORT_SIDEBOX_TITLE),
00227                               array('id' => '3', 'text' => TEXT_SORT_FOOTER_TITLE),
00228                               array('id' => '4', 'text' => TEXT_SORT_PAGE_TITLE),
00229                               array('id' => '5', 'text' => TEXT_SORT_PAGE_ID_TITLE)
00230                               );
00231         echo TEXT_SORT_CHAPTER_TOC_TITLE_INFO . zen_draw_form('set_ez_sort_order_form', FILENAME_EZPAGES_ADMIN, '', 'get') . '&nbsp;&nbsp;' . zen_draw_pull_down_menu('reset_ez_sort_order', $ez_sort_order_array, $reset_ez_sort_order, 'onChange="this.form.submit();"') . zen_hide_session_id() .
00232         ($_GET['page'] != '' ? zen_draw_hidden_field('page', $_GET['page']) : '') .
00233         zen_draw_hidden_field('action', 'set_ez_sort_order') .
00234         '</form>';
00235 ?>
00236             </td>
00237             <td class="main">
00238 <?php
00239 // toggle switch for editor
00240         echo TEXT_EDITOR_INFO . zen_draw_form('set_editor_form', FILENAME_EZPAGES_ADMIN, '', 'get') . '&nbsp;&nbsp;' . zen_draw_pull_down_menu('reset_editor', $editors_pulldown, $current_editor_key, 'onChange="this.form.submit();"') .
00241         zen_hide_session_id() .
00242         zen_draw_hidden_field('action', 'set_editor') .
00243         '</form>';
00244       }
00245 ?>
00246           </td>
00247           </tr>
00248         </table></td>
00249       </tr>
00250 <?php
00251   if ($action == 'new') {
00252     $form_action = 'insert';
00253
00254     $parameters = array('pages_title' => '',
00255                         'page_open_new_window' => '',
00256                         'page_is_ssl' => '',
00257                         'pages_html_text' => '',
00258                         'alt_url' => '',
00259                         'alt_url_external' => '',
00260                         'header_sort_order' => '',
00261                         'sidebox_sort_order' => '',
00262                         'footer_sort_order' => '',
00263                         'toc_sort_order' => '',
00264                         'toc_chapter' => '',
00265                         'status_header' => '',
00266                         'status_sidebox' => '',
00267                         'status_footer' => '',
00268                         'status_toc' => '',
00269                         'page_open_new_window' => '',
00270                         'page_is_ssl' => ''
00271                         );
00272
00273     $ezInfo = new objectInfo($parameters);
00274
00275     if (isset($_GET['ezID'])) {
00276       $form_action = 'update';
00277
00278       $ezID = zen_db_prepare_input($_GET['ezID']);
00279
00280       $page_query = "select * from " . TABLE_EZPAGES . " where pages_id = '" . (int)$_GET['ezID'] . "'";
00281       $page = $db->Execute($page_query);
00282       $ezInfo->objectInfo($page->fields);
00283     } elseif (zen_not_null($_POST)) {
00284       $ezInfo->objectInfo($_POST);
00285     }
00286
00287 // set all status settings and switches
00288     if (!isset($ezInfo->status_header)) $ezInfo->status_header = '1';
00289     switch ($ezInfo->status_header) {
00290       case '0': $is_status_header = false; $not_status_header = true; break;
00291       case '1': $is_status_header = true; $not_status_header = false; break;
00292       default: $is_status_header = true; $not_status_header = false; break;
00293     }
00294     if (!isset($ezInfo->status_sidebox)) $ezInfo->status_sidebox = '1';
00295     switch ($ezInfo->status_sidebox) {
00296       case '0': $is_status_sidebox = false; $not_status_sidebox = true; break;
00297       case '1': $is_status_sidebox = true; $not_status_sidebox = false; break;
00298       default: $is_status_sidebox = true; $not_status_sidebox = false; break;
00299     }
00300     if (!isset($ezInfo->status_footer)) $ezInfo->status_footer = '1';
00301     switch ($ezInfo->status_footer) {
00302       case '0': $is_status_footer = false; $not_status_footer = true; break;
00303       case '1': $is_status_footer = true; $not_status_footer = false; break;
00304       default: $is_status_footer = true; $not_status_footer = false; break;
00305     }
00306     if (!isset($ezInfo->status_toc)) $ezInfo->status_toc = '1';
00307     switch ($ezInfo->status_toc) {
00308       case '0': $is_status_toc = false; $not_status_toc = true; break;
00309       case '1': $is_status_toc = true; $not_status_toc = false; break;
00310       default: $is_status_toc = true; $not_status_toc = false; break;
00311     }
00312     if (!isset($ezInfo->page_open_new_window)) $ezInfo->not_page_open_new_window = '1';
00313     switch ($ezInfo->page_open_new_window) {
00314       case '0': $is_page_open_new_window = false; $not_page_open_new_window = true; break;
00315       case '1': $is_page_open_new_window = true; $not_page_open_new_window = false; break;
00316       default: $is_page_open_new_window = false; $not_page_open_new_window = true; break;
00317     }
00318     if (!isset($ezInfo->page_is_ssl)) $ezInfo->page_is_ssl = '1';
00319     switch ($ezInfo->page_is_ssl) {
00320       case '0': $is_page_is_ssl = false; $not_page_is_ssl = true; break;
00321       case '1': $is_page_is_ssl = true; $not_page_is_ssl = false; break;
00322       default: $is_page_is_ssl = false; $not_page_is_ssl = true; break;
00323     }
00324 ?>
00325       <tr>
00326         <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
00327       </tr>
00328       <tr>
00329 <?php
00330     echo zen_draw_form('new_page', FILENAME_EZPAGES_ADMIN, (isset($_GET['page']) ? 'page=' . zen_db_prepare_input($_GET['page']) . '&' : '') . 'action=' . $form_action, 'post', 'enctype="multipart/form-data"');
00331     if ($form_action == 'update') echo zen_draw_hidden_field('pages_id', $ezID);
00332  ?>
00333
00334       <tr>
00335         <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
00336           <tr>
00337             <td colspan="2" class="main" align="left" valign="top" nowrap><?php echo (($form_action == 'insert') ? zen_image_submit('button_insert.gif', IMAGE_INSERT) : zen_image_submit('button_update.gif', IMAGE_UPDATE)). '&nbsp;&nbsp;<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . (isset($_GET['ezID']) ? 'ezID=' . $_GET['ezID'] : '')) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>
00338           </tr>
00339         </table></td>
00340       </tr>
00341         <td><table border="0" cellspacing="0" cellpadding="2">
00342           <tr>
00343             <td class="main"><?php echo TEXT_PAGES_TITLE; ?></td>
00344             <td class="main"><?php echo zen_draw_input_field('pages_title', htmlspecialchars($ezInfo->pages_title, ENT_COMPAT, CHARSET, TRUE), zen_set_field_length(TABLE_EZPAGES, 'pages_title'), true); ?></td>
00345           </tr>
00346           <tr>
00347             <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
00348           </tr>
00349
00350           <tr>
00351             <td colspan="2"><table border="0" cellspacing="4" cellpadding="4">
00352               <tr>
00353                 <td class="main" align="left" valign="top"><strong>
00354                 <?php echo TABLE_HEADING_PAGE_OPEN_NEW_WINDOW; ?></strong><br />
00355                   <?php echo zen_draw_radio_field('page_open_new_window', '1', $is_page_open_new_window) . '&nbsp;' . TEXT_YES . '<br />' . zen_draw_radio_field('page_open_new_window', '0', $not_page_open_new_window) . '&nbsp;' . TEXT_NO; ?>
00356                 </td>
00357                 <td class="main" align="left" valign="top"><strong>
00358                 <?php echo TABLE_HEADING_PAGE_IS_SSL; ?></strong><br />
00359                   <?php echo zen_draw_radio_field('page_is_ssl', '1', $is_page_is_ssl) . '&nbsp;' . TEXT_YES . '<br />' . zen_draw_radio_field('page_is_ssl', '0', $not_page_is_ssl) . '&nbsp;' . TEXT_NO; ?>
00360                 </td>
00361               </tr>
00362             </table></td>
00363           </tr>
00364
00365           <tr>
00366             <td colspan="2"><table border="0" cellspacing="4" cellpadding="4">
00367               <tr>
00368                 <td class="main" align="left" valign="top"><strong>
00369                 <?php echo TABLE_HEADING_STATUS_HEADER; ?></strong><br />
00370                   <?php echo zen_draw_radio_field('status_header', '1', $is_status_header) . '&nbsp;' . TEXT_YES . '<br />' . zen_draw_radio_field('status_header', '0', $not_status_header) . '&nbsp;' . TEXT_NO; ?>
00371                 </td>
00372                 <td class="main" align="center" valign="bottom">
00373                 <?php echo TEXT_HEADER_SORT_ORDER; ?><br />
00374                   <?php echo zen_draw_input_field('header_sort_order', $ezInfo->header_sort_order, zen_set_field_length(TABLE_EZPAGES, 'header_sort_order'), false); ?>
00375                 </td>
00376                 <td align="center">&nbsp;<?php echo zen_draw_separator('pixel_black.gif', '2', '50'); ?>&nbsp;</td>
00377
00378                 <td class="main" align="left" valign="top"><strong>
00379                 <?php echo TABLE_HEADING_STATUS_SIDEBOX; ?></strong><br />
00380                   <?php echo zen_draw_radio_field('status_sidebox', '1', $is_status_sidebox) . '&nbsp;' . TEXT_YES . '<br />' . zen_draw_radio_field('status_sidebox', '0', $not_status_sidebox) . '&nbsp;' . TEXT_NO; ?>
00381                 </td>
00382                 <td class="main" align="center" valign="bottom">
00383                 <?php echo TEXT_SIDEBOX_SORT_ORDER; ?><br />
00384                   <?php echo zen_draw_input_field('sidebox_sort_order', $ezInfo->sidebox_sort_order, zen_set_field_length(TABLE_EZPAGES, 'sidebox_sort_order'), false); ?>
00385                 </td>
00386                 <td align="center">&nbsp;<?php echo zen_draw_separator('pixel_black.gif', '2', '50'); ?>&nbsp;</td>
00387
00388                 <td class="main" align="left" valign="top"><strong>
00389                 <?php echo TABLE_HEADING_STATUS_FOOTER; ?></strong><br />
00390                   <?php echo zen_draw_radio_field('status_footer', '1', $is_status_footer) . '&nbsp;' . TEXT_YES . '<br />' . zen_draw_radio_field('status_footer', '0', $not_status_footer) . '&nbsp;' . TEXT_NO; ?>
00391                 </td>
00392                 <td class="main" align="center" valign="bottom">
00393                   <?php echo TEXT_FOOTER_SORT_ORDER; ?><br />
00394                   <?php echo zen_draw_input_field('footer_sort_order', $ezInfo->footer_sort_order, zen_set_field_length(TABLE_EZPAGES, 'footer_sort_order'), false); ?>
00395                 </td>
00396                 <td align="center">&nbsp;<?php echo zen_draw_separator('pixel_black.gif', '2', '50'); ?>&nbsp;</td>
00397
00398                 <td class="main" align="left" valign="top"><strong>
00399                 <?php echo TABLE_HEADING_CHAPTER_PREV_NEXT; ?></strong>
00400                 <?php echo zen_draw_input_field('toc_chapter', $ezInfo->toc_chapter, zen_set_field_length(TABLE_EZPAGES, 'toc_chapter', '6'), false); ?>
00401                 </td>
00402
00403                 <td class="main" align="left" valign="top"><strong>
00404                 <?php echo TABLE_HEADING_STATUS_TOC; ?></strong><br />
00405                   <?php echo zen_draw_radio_field('status_toc', '1', $is_status_toc) . '&nbsp;' . TEXT_YES . '<br />' . zen_draw_radio_field('status_toc', '0', $not_status_toc) . '&nbsp;' . TEXT_NO; ?>
00406                 </td>
00407                 <td class="main" align="center" valign="bottom">
00408                   <?php echo TEXT_TOC_SORT_ORDER; ?><br />
00409                   <?php echo zen_draw_input_field('toc_sort_order', $ezInfo->toc_sort_order, zen_set_field_length(TABLE_EZPAGES, 'toc_sort_order'), false); ?>
00410                 </td>
00411
00412               </tr>
00413             </table></td>
00414           </tr>
00415               <tr>
00416                 <td class="main" colspan="2">
00417                   <?php echo TEXT_HEADER_SORT_ORDER_EXPLAIN . '<br />'; ?>
00418                   <?php echo TEXT_SIDEBOX_ORDER_EXPLAIN . '<br />'; ?>
00419                   <?php echo TEXT_FOOTER_ORDER_EXPLAIN . '<br />'; ?>
00420                   <?php echo TEXT_TOC_SORT_ORDER_EXPLAIN . '<br />'; ?>
00421                   <?php echo TEXT_CHAPTER_EXPLAIN; ?>
00422                 </td>
00423               </tr>
00424
00425
00426           <tr>
00427             <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
00428           </tr>
00429           <tr>
00430             <td valign="top" class="main"><?php echo TEXT_PAGES_HTML_TEXT; ?></td>
00431             <td class="main"><?php echo zen_draw_textarea_field('pages_html_text', 'soft', '100%', '40', htmlspecialchars($ezInfo->pages_html_text, ENT_COMPAT, CHARSET, TRUE));?></td>
00432           </tr>
00433
00434           <tr>
00435             <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
00436           </tr>
00437
00438           <tr>
00439             <td class="main" valign="top"><?php echo TEXT_ALT_URL; ?></td>
00440             <td class="main" valign="top"><?php echo zen_draw_input_field('alt_url', $ezInfo->alt_url, 'size="100"');
00441                                    echo '<br />' . TEXT_ALT_URL_EXPLAIN;
00442                         ?></td>
00443           </tr>
00444
00445           <tr>
00446             <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
00447           </tr>
00448
00449           <tr>
00450             <td class="main" valign="top"><?php echo TEXT_ALT_URL_EXTERNAL; ?></td>
00451             <td class="main" valign="top"><?php echo zen_draw_input_field('alt_url_external', $ezInfo->alt_url_external, 'size="100"');
00452                                    echo '<br />' . TEXT_ALT_URL_EXTERNAL_EXPLAIN;
00453                         ?></td>
00454           </tr>
00455
00456           <tr>
00457             <td colspan="2"><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
00458           </tr>
00459
00460         </table></td>
00461       </tr>
00462       <tr>
00463         <td><?php echo zen_draw_separator('pixel_trans.gif', '1', '10'); ?></td>
00464       </tr>
00465       <tr>
00466         <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
00467           <tr>
00468             <td colspan="2" class="main" align="left" valign="top" nowrap><?php echo (($form_action == 'insert') ? zen_image_submit('button_insert.gif', IMAGE_INSERT) : zen_image_submit('button_update.gif', IMAGE_UPDATE)). '&nbsp;&nbsp;<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . (isset($_GET['ezID']) ? 'ezID=' . $_GET['ezID'] : '')) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td>
00469           </tr>
00470         </table></td>
00471       </form></tr>
00472 <?php
00473   } else {
00474 ?>
00475       <tr>
00476         <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
00477           <tr>
00478             <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">
00479               <tr class="dataTableHeadingRow" width="100%">
00480                 <td class="dataTableHeadingContent" width="75px" align="center"><?php echo TABLE_HEADING_ID; ?></td>
00481                 <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PAGES; ?></td>
00482                 <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_PAGE_OPEN_NEW_WINDOW; ?></td>
00483                 <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_PAGE_IS_SSL; ?></td>
00484                 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS_HEADER; ?></td>
00485                 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS_SIDEBOX; ?></td>
00486                 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS_FOOTER; ?></td>
00487                 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_CHAPTER; ?></td>
00488                 <td class="dataTableHeadingContent" align="right"><?php echo TABLE_HEADING_STATUS_TOC; ?></td>
00489                 <td class="dataTableHeadingContent" align="center">&nbsp;</td>
00490               </tr>
00491
00492 <?php
00493 // set display order
00494   switch(true) {
00495     case ($_SESSION['ez_sort_order'] == 0):
00496       $ez_order_by =  " order by toc_chapter, toc_sort_order, pages_title";
00497       break;
00498     case ($_SESSION['ez_sort_order'] == 1):
00499       $ez_order_by =  " order by header_sort_order, pages_title";
00500       break;
00501     case ($_SESSION['ez_sort_order'] == 2):
00502       $ez_order_by =  " order by sidebox_sort_order, pages_title";
00503       break;
00504     case ($_SESSION['ez_sort_order'] == 3):
00505       $ez_order_by =  " order by footer_sort_order, pages_title";
00506       break;
00507     case ($_SESSION['ez_sort_order'] == 4):
00508       $ez_order_by =  " order by pages_title";
00509       break;
00510     case ($_SESSION['ez_sort_order'] == 5):
00511       $ez_order_by =  " order by  pages_id, pages_title";
00512       break;
00513     default:
00514       $ez_order_by =  " order by toc_chapter, toc_sort_order, pages_title";
00515       break;
00516   }
00517
00518     $pages_query_raw = "select * from " . TABLE_EZPAGES . $ez_order_by;
00519
00520 // Split Page
00521 // reset page when page is unknown
00522 if (($_GET['page'] == '' or $_GET['page'] == '1') and $_GET['ezID'] != '') {
00523   $check_page = $db->Execute($pages_query_raw);
00524   $check_count=1;
00525   if ($check_page->RecordCount() > MAX_DISPLAY_SEARCH_RESULTS_EZPAGE) {
00526     while (!$check_page->EOF) {
00527       if ($check_page->fields['customers_id'] == $_GET['cID']) {
00528         break;
00529       }
00530       $check_count++;
00531       $check_page->MoveNext();
00532     }
00533     $_GET['page'] = round((($check_count/MAX_DISPLAY_SEARCH_RESULTS_EZPAGE)+(fmod_round($check_count,MAX_DISPLAY_SEARCH_RESULTS_EZPAGE) !=0 ? .5 : 0)),0);
00534   } else {
00535     $_GET['page'] = 1;
00536   }
00537 }
00538
00539     $pages_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS_EZPAGE, $pages_query_raw, $pages_query_numrows);
00540     $pages = $db->Execute($pages_query_raw);
00541
00542 while (!$pages->EOF) {
00543      if ((!isset($_GET['ezID']) || (isset($_GET['ezID']) && ($_GET['ezID'] == $pages->fields['pages_id']))) && !isset($ezInfo) && (substr($action, 0, 3) != 'new')) {
00544         $ezInfo_array = $pages->fields;
00545         $ezInfo = new objectInfo($ezInfo_array);
00546       }
00547     $zv_link_method_cnt = 0;
00548     if ($pages->fields['alt_url'] !='') {
00549       $zv_link_method_cnt++;
00550     }
00551     if ($pages->fields['alt_url_external'] !='') {
00552       $zv_link_method_cnt++;
00553     }
00554     if ($pages->fields['pages_html_text'] !='' and strlen(trim($pages->fields['pages_html_text'])) > 6) {
00555       $zv_link_method_cnt++;
00556     }
00557       if (isset($ezInfo) && is_object($ezInfo) && ($pages->fields['pages_id'] == $ezInfo->pages_id)) {
00558         echo '              <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $pages->fields['pages_id']) . '\'">' . "\n";
00559       } else {
00560         echo '              <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $pages->fields['pages_id']) . '\'">' . "\n";
00561       }
00562 ?>
00563                 <td class="dataTableContent" width="75px" align="right"><?php echo ($zv_link_method_cnt > 1 ? zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED_EZPAGES, 10, 10) : '') . '&nbsp;' . $pages->fields['pages_id']; ?></td>
00564                 <td class="dataTableContent"><?php echo '&nbsp;' . $pages->fields['pages_title']; ?></td>
00565                 <td class="dataTableContent" align="center"><?php echo ($pages->fields['page_open_new_window'] == 1 ? '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=page_open_new_window&current=' . $pages->fields['page_open_new_window'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_ON) . '</a>' : '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=page_open_new_window&current=' . $pages->fields['page_open_new_window'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF) . '</a>'); ?></td>
00566                 <td class="dataTableContent" align="center"><?php echo ($pages->fields['page_is_ssl'] == 1 ? '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=page_is_ssl&current=' . $pages->fields['page_is_ssl'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_ON) . '</a>' : '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=page_is_ssl&current=' . $pages->fields['page_is_ssl'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF) . '</a>'); ?></td>
00567                 <td class="dataTableContent" align="right"><?php echo $pages->fields['header_sort_order'] . '&nbsp;' . ($pages->fields['status_header'] == 1 ? '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=status_header&current=' . $pages->fields['status_header'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_ON) . '</a>' : '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=status_header&current=' . $pages->fields['status_header'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF) . '</a>'); ?></td>
00568                 <td class="dataTableContent" align="right"><?php echo $pages->fields['sidebox_sort_order'] . '&nbsp;' . ($pages->fields['status_sidebox'] == 1 ? '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=status_sidebox&current=' . $pages->fields['status_sidebox'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_ON) . '</a>' : '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=status_sidebox&current=' . $pages->fields['status_sidebox'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF) . '</a>'); ?></td>
00569                 <td class="dataTableContent" align="right"><?php echo $pages->fields['footer_sort_order'] . '&nbsp;' . ($pages->fields['status_footer'] == 1 ? '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=status_footer&current=' . $pages->fields['status_footer'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_ON) . '</a>' : '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=status_footer&current=' . $pages->fields['status_footer'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF) . '</a>'); ?></td>
00570                 <td class="dataTableContent" align="right"><?php echo $pages->fields['toc_chapter']; ?></td>
00571                 <td class="dataTableContent" align="right"><?php echo $pages->fields['toc_sort_order'] . '&nbsp;' . ($pages->fields['status_toc'] == 1 ? '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=status_toc&current=' . $pages->fields['status_toc'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_ON) . '</a>' : '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=status_toc&current=' . $pages->fields['status_toc'] . '&ezID=' . $pages->fields['pages_id'] . ($_GET['page'] > 0 ? '&page=' . $_GET['page'] : ''), 'NONSSL') . '">' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF) . '</a>'); ?></td>
00572                 <td class="dataTableContent" align="center">&nbsp;&nbsp;<?php echo '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN,
00573 (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . (isset($ezInfo) && is_object($ezInfo) && ($pages->fields['pages_id'] == $ezInfo->pages_id)) ? 'ezID=' . $pages->fields['pages_id'] . '&action=new' : '') . '">' . zen_image(DIR_WS_IMAGES . 'icon_edit.gif', ICON_EDIT) . '</a>'; ?><?php if (isset($ezInfo) && is_object($ezInfo) && ($pages->fields['pages_id'] == $ezInfo->pages_id)) { echo zen_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . (isset($pages->fields['pages_id']) ? 'ezID=' . $pages->fields['pages_id'] : '')) . '">' . zen_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . '</a>'; } ?></td>
00574               </tr>
00575 <?php
00576
00577  $pages->MoveNext();
00578     }
00579 ?>
00580                   <tr>
00581
00582                     <td class="smallText" valign="top" colspan="2"><?php echo $pages_split->display_count($pages_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_EZPAGE, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PAGES); ?></td>
00583                     <td class="smallText" align="right" colspan="8"><?php echo $pages_split->display_links($pages_query_numrows, MAX_DISPLAY_SEARCH_RESULTS_EZPAGE, MAX_DISPLAY_PAGE_LINKS, $_GET['page'], zen_get_all_get_params(array('page', 'info', 'x', 'y', 'ezID'))); ?></td>
00584                   </tr>
00585
00586               <tr>
00587                 <td colspan="10"><table border="0" width="100%" cellspacing="0" cellpadding="2">
00588                   <tr>
00589                     <td align="right" colspan="2"><?php echo '<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'action=new') . '">' . zen_image_button('button_new_file.gif', IMAGE_NEW_PAGE) . '</a>'; ?></td>
00590                   </tr>
00591                 </table></td>
00592               </tr>
00593             </table></td>
00594 <?php
00595   $heading = array();
00596   $contents = array();
00597   switch ($action) {
00598     case 'delete':
00599       $heading[] = array('text' => '<b>' . $ezInfo->pages_title . '</b>');
00600
00601       $contents = array('form' => zen_draw_form('pages', FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&action=deleteconfirm') . zen_draw_hidden_field('ezID', $ezInfo->pages_id));
00602       $contents[] = array('text' => TEXT_INFO_DELETE_INTRO);
00603       $contents[] = array('text' => '<br /><b>' . $ezInfo->pages_title . '</b>');
00604
00605       $contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_delete.gif', IMAGE_DELETE) . '&nbsp;<a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $_GET['ezID']) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');
00606       break;
00607     default:
00608       if (is_object($ezInfo)) {
00609         $heading[] = array('text' => '<b>' . TEXT_PAGE_TITLE . '&nbsp;' . $ezInfo->pages_title . '&nbsp;|&nbsp;' . TEXT_CHAPTER . '&nbsp;' . $ezInfo->toc_chapter . '</b>');
00610
00611         $zv_link_method_cnt = 0;
00612         if ($ezInfo->alt_url !='') {
00613           $zv_link_method_cnt++;
00614         }
00615         if ($ezInfo->alt_url_external !='') {
00616           $zv_link_method_cnt++;
00617         }
00618         if ($ezInfo->pages_html_text !='' and strlen(trim($ezInfo->pages_html_text)) > 6) {
00619           $zv_link_method_cnt++;
00620         }
00621
00622         if ($zv_link_method_cnt > 1) {
00623           $contents[] = array('align' => 'left', 'text' => zen_image(DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED_EZPAGES, 10, 10) . ' &nbsp;' . TEXT_WARNING_MULTIPLE_SETTINGS);
00624         }
00625
00626         $contents[] = array('align' => 'left', 'text' => TEXT_ALT_URL . (empty($ezInfo->alt_url) ? '&nbsp;' . TEXT_NONE : '<br />' . $ezInfo->alt_url));
00627         $contents[] = array('align' => 'left', 'text' => '<br />' . TEXT_ALT_URL_EXTERNAL . (empty($ezInfo->alt_url_external) ? '&nbsp;' . TEXT_NONE : '<br />' . $ezInfo->alt_url_external));
00628         $contents[] = array('align' => 'left', 'text' => '<br />' . TEXT_PAGES_HTML_TEXT . '<br />' . substr(strip_tags($ezInfo->pages_html_text),0,100));
00629
00630         $contents[] = array('align' => 'left', 'text' => '<br /><a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $ezInfo->pages_id . '&action=new') . '">' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . zen_href_link(FILENAME_EZPAGES_ADMIN, 'page=' . $_GET['page'] . '&ezID=' . $ezInfo->pages_id . '&action=delete') . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a><br /><br /><br />');
00631
00632         if ($ezInfo->date_scheduled) $contents[] = array('text' => '<br />' . sprintf(TEXT_PAGES_SCHEDULED_AT_DATE, zen_date_short($ezInfo->date_scheduled)));
00633
00634         if ($ezInfo->expires_date) {
00635           $contents[] = array('text' => '<br />' . sprintf(TEXT_PAGES_EXPIRES_AT_DATE, zen_date_short($ezInfo->expires_date)));
00636         } elseif ($ezInfo->expires_impressions) {
00637           $contents[] = array('text' => '<br />' . sprintf(TEXT_PAGES_EXPIRES_AT_IMPRESSIONS, $ezInfo->expires_impressions));
00638         }
00639
00640         if ($ezInfo->date_status_change) $contents[] = array('text' => '<br />' . sprintf(TEXT_PAGES_STATUS_CHANGE, zen_date_short($ezInfo->date_status_change)));
00641       }
00642       break;
00643   }
00644
00645   if ( (zen_not_null($heading)) && (zen_not_null($contents)) ) {
00646     echo '            <td width="25%" valign="top">' . "\n";
00647
00648     $box = new box;
00649     echo $box->infoBox($heading, $contents);
00650
00651     echo '            </td>' . "\n";
00652   }
00653 ?>
00654           </tr>
00655         </table></td>
00656       </tr>
00657 <?php
00658   }
00659 ?>
00660     </table></td>
00661 <!-- body_text_eof //-->
00662   </tr>
00663 </table>
00664 <!-- body_eof //-->
00665
00666 <!-- footer //-->
00667 <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>
00668 <!-- footer_eof //-->
00669 <br />
00670 </body>
00671 </html>
00672 <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>