Execute("insert into " . TABLE_ZONES . " (zone_country_id, zone_code, zone_name) values ('" . (int)$zone_country_id . "', '" . zen_db_input($zone_code) . "', '" . zen_db_input($zone_name) . "')"); zen_redirect(zen_href_link(FILENAME_ZONES)); break; case 'save': $zone_id = zen_db_prepare_input($_GET['cID']); $zone_country_id = zen_db_prepare_input($_POST['zone_country_id']); $zone_code = zen_db_prepare_input($_POST['zone_code']); $zone_name = zen_db_prepare_input($_POST['zone_name']); $db->Execute("update " . TABLE_ZONES . " set zone_country_id = '" . (int)$zone_country_id . "', zone_code = '" . zen_db_input($zone_code) . "', zone_name = '" . zen_db_input($zone_name) . "' where zone_id = '" . (int)$zone_id . "'"); zen_redirect(zen_href_link(FILENAME_ZONES, 'page=' . $_GET['page'] . '&cID=' . $zone_id)); break; case 'deleteconfirm': // demo active test if (zen_admin_demo()) { $_GET['action']= ''; $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution'); zen_redirect(zen_href_link(FILENAME_ZONES, 'page=' . $_GET['page'])); } $zone_id = zen_db_prepare_input($_GET['cID']); $db->Execute("delete from " . TABLE_ZONES . " where zone_id = '" . (int)$zone_id . "'"); zen_redirect(zen_href_link(FILENAME_ZONES, 'page=' . $_GET['page'])); break; } } ?> > <?php echo TITLE; ?>
'' . TEXT_INFO_HEADING_NEW_ZONE . ''); $contents = array('form' => zen_draw_form('zones', FILENAME_ZONES, 'page=' . $_GET['page'] . '&action=insert')); $contents[] = array('text' => TEXT_INFO_INSERT_INTRO); $contents[] = array('text' => '
' . TEXT_INFO_ZONES_NAME . '
' . zen_draw_input_field('zone_name')); $contents[] = array('text' => '
' . TEXT_INFO_ZONES_CODE . '
' . zen_draw_input_field('zone_code')); $contents[] = array('text' => '
' . TEXT_INFO_COUNTRY_NAME . '
' . zen_draw_pull_down_menu('zone_country_id', zen_get_countries())); $contents[] = array('align' => 'center', 'text' => '
' . zen_image_submit('button_insert.gif', IMAGE_INSERT) . ' ' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ''); break; case 'edit': $heading[] = array('text' => '' . TEXT_INFO_HEADING_EDIT_ZONE . ''); $contents = array('form' => zen_draw_form('zones', FILENAME_ZONES, 'page=' . $_GET['page'] . '&cID=' . $cInfo->zone_id . '&action=save')); $contents[] = array('text' => TEXT_INFO_EDIT_INTRO); $contents[] = array('text' => '
' . TEXT_INFO_ZONES_NAME . '
' . zen_draw_input_field('zone_name', $cInfo->zone_name)); $contents[] = array('text' => '
' . TEXT_INFO_ZONES_CODE . '
' . zen_draw_input_field('zone_code', $cInfo->zone_code)); $contents[] = array('text' => '
' . TEXT_INFO_COUNTRY_NAME . '
' . zen_draw_pull_down_menu('zone_country_id', zen_get_countries(), $cInfo->countries_id)); $contents[] = array('align' => 'center', 'text' => '
' . zen_image_submit('button_update.gif', IMAGE_UPDATE) . ' ' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ''); break; case 'delete': $heading[] = array('text' => '' . TEXT_INFO_HEADING_DELETE_ZONE . ''); $contents = array('form' => zen_draw_form('zones', FILENAME_ZONES, 'page=' . $_GET['page'] . '&cID=' . $cInfo->zone_id . '&action=deleteconfirm')); $contents[] = array('text' => TEXT_INFO_DELETE_INTRO); $contents[] = array('text' => '
' . $cInfo->zone_name . ''); $contents[] = array('align' => 'center', 'text' => '
' . zen_image_submit('button_delete.gif', IMAGE_DELETE) . ' ' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ''); break; default: if (isset($cInfo) && is_object($cInfo)) { $heading[] = array('text' => '' . $cInfo->zone_name . ''); $contents[] = array('align' => 'center', 'text' => '' . zen_image_button('button_edit.gif', IMAGE_EDIT) . '' . zen_image_button('button_delete.gif', IMAGE_DELETE) . ''); $contents[] = array('text' => '
' . TEXT_INFO_ZONES_NAME . '
' . $cInfo->zone_name . ' (' . $cInfo->zone_code . ')'); $contents[] = array('text' => '
' . TEXT_INFO_COUNTRY_NAME . ' ' . $cInfo->countries_name); } break; } if ( (zen_not_null($heading)) && (zen_not_null($contents)) ) { echo ' ' . "\n"; } ?>
Execute($zones_query_raw); while (!$zones->EOF) { if ((!isset($_GET['cID']) || (isset($_GET['cID']) && ($_GET['cID'] == $zones->fields['zone_id']))) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) { $cInfo = new objectInfo($zones->fields); } if (isset($cInfo) && is_object($cInfo) && ($zones->fields['zone_id'] == $cInfo->zone_id)) { echo ' ' . "\n"; } else { echo ' ' . "\n"; } ?> MoveNext(); } ?>
 
fields['countries_name']; ?> fields['zone_name']; ?> fields['zone_code']; ?> fields['zone_id'] == $cInfo->zone_id) ) { echo zen_image(DIR_WS_IMAGES . 'icon_arrow_right.gif', ''); } else { echo '' . zen_image(DIR_WS_IMAGES . 'icon_info.gif', IMAGE_ICON_INFO) . ''; } ?>  
display_count($zones_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_ZONES); ?> display_links($zones_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?>
' . zen_image_button('button_new_zone.gif', IMAGE_NEW_ZONE) . ''; ?>
' . "\n"; $box = new box; echo $box->infoBox($heading, $contents); echo '