Execute("insert into " . TABLE_COUNTRIES . " (countries_name, countries_iso_code_2, countries_iso_code_3, address_format_id) values ('" . zen_db_input($countries_name) . "', '" . zen_db_input($countries_iso_code_2) . "', '" . zen_db_input($countries_iso_code_3) . "', '" . (int)$address_format_id . "')"); zen_redirect(zen_href_link(FILENAME_COUNTRIES)); break; case 'save': $countries_id = zen_db_prepare_input($_GET['cID']); $countries_name = zen_db_prepare_input($_POST['countries_name']); $countries_iso_code_2 = zen_db_prepare_input($_POST['countries_iso_code_2']); $countries_iso_code_3 = zen_db_prepare_input($_POST['countries_iso_code_3']); $address_format_id = zen_db_prepare_input($_POST['address_format_id']); $db->Execute("update " . TABLE_COUNTRIES . " set countries_name = '" . zen_db_input($countries_name) . "', countries_iso_code_2 = '" . zen_db_input($countries_iso_code_2) . "', countries_iso_code_3 = '" . zen_db_input($countries_iso_code_3) . "', address_format_id = '" . (int)$address_format_id . "' where countries_id = '" . (int)$countries_id . "'"); zen_redirect(zen_href_link(FILENAME_COUNTRIES, 'page=' . $_GET['page'] . '&cID=' . $countries_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_COUNTRIES, 'page=' . $_GET['page'])); } $countries_id = zen_db_prepare_input($_GET['cID']); $db->Execute("delete from " . TABLE_COUNTRIES . " where countries_id = '" . (int)$countries_id . "'"); zen_redirect(zen_href_link(FILENAME_COUNTRIES, 'page=' . $_GET['page'])); break; } } ?> >

'' . TEXT_INFO_HEADING_NEW_COUNTRY . ''); $contents = array('form' => zen_draw_form('countries', FILENAME_COUNTRIES, 'page=' . $_GET['page'] . '&action=insert')); $contents[] = array('text' => TEXT_INFO_INSERT_INTRO); $contents[] = array('text' => ' ' . TEXT_INFO_COUNTRY_NAME . ' ' . zen_draw_input_field('countries_name')); $contents[] = array('text' => ' ' . TEXT_INFO_COUNTRY_CODE_2 . ' ' . zen_draw_input_field('countries_iso_code_2')); $contents[] = array('text' => ' ' . TEXT_INFO_COUNTRY_CODE_3 . ' ' . zen_draw_input_field('countries_iso_code_3')); $contents[] = array('text' => ' ' . TEXT_INFO_ADDRESS_FORMAT . ' ' . zen_draw_pull_down_menu('address_format_id', zen_get_address_formats())); $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_COUNTRY . ''); $contents = array('form' => zen_draw_form('countries', FILENAME_COUNTRIES, 'page=' . $_GET['page'] . '&cID=' . $cInfo->countries_id . '&action=save')); $contents[] = array('text' => TEXT_INFO_EDIT_INTRO); $contents[] = array('text' => ' ' . TEXT_INFO_COUNTRY_NAME . ' ' . zen_draw_input_field('countries_name', $cInfo->countries_name)); $contents[] = array('text' => ' ' . TEXT_INFO_COUNTRY_CODE_2 . ' ' . zen_draw_input_field('countries_iso_code_2', $cInfo->countries_iso_code_2)); $contents[] = array('text' => ' ' . TEXT_INFO_COUNTRY_CODE_3 . ' ' . zen_draw_input_field('countries_iso_code_3', $cInfo->countries_iso_code_3)); $contents[] = array('text' => ' ' . TEXT_INFO_ADDRESS_FORMAT . ' ' . zen_draw_pull_down_menu('address_format_id', zen_get_address_formats(), $cInfo->address_format_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_COUNTRY . ''); $contents = array('form' => zen_draw_form('countries', FILENAME_COUNTRIES, 'page=' . $_GET['page'] . '&cID=' . $cInfo->countries_id . '&action=deleteconfirm')); $contents[] = array('text' => TEXT_INFO_DELETE_INTRO); $contents[] = array('text' => ' ' . $cInfo->countries_name . ''); $contents[] = array('align' => 'center', 'text' => ' ' . zen_image_submit('button_delete.gif', IMAGE_UPDATE) . ' ' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . ''); break; default: if (is_object($cInfo)) { $heading[] = array('text' => '' . $cInfo->countries_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_COUNTRY_NAME . ' ' . $cInfo->countries_name); $contents[] = array('text' => ' ' . TEXT_INFO_COUNTRY_CODE_2 . ' ' . $cInfo->countries_iso_code_2); $contents[] = array('text' => ' ' . TEXT_INFO_COUNTRY_CODE_3 . ' ' . $cInfo->countries_iso_code_3); $contents[] = array('text' => ' ' . TEXT_INFO_ADDRESS_FORMAT . ' ' . $cInfo->address_format_id); } break; } if ( (zen_not_null($heading)) && (zen_not_null($contents)) ) { echo ' ' . "\n"; } ?> Execute($countries_query_raw); while (!$countries->EOF) { if ((!isset($_GET['cID']) || (isset($_GET['cID']) && ($_GET['cID'] == $countries->fields['countries_id']))) && !isset($cInfo) && (substr($action, 0, 3) != 'new')) { $cInfo = new objectInfo($countries->fields); } if (isset($cInfo) && is_object($cInfo) && ($countries->fields['countries_id'] == $cInfo->countries_id)) { echo ' ' . "\n"; } else { echo ' ' . "\n"; } ?> MoveNext(); } ?>   fields['countries_name']; ?> fields['countries_iso_code_2']; ?> fields['countries_iso_code_3']; ?> fields['countries_id'] == $cInfo->countries_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($countries_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_COUNTRIES); ?> display_links($countries_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?> ' . zen_image_button('button_new_country.gif', IMAGE_NEW_COUNTRY) . ''; ?> ' . "\n"; $box = new box; echo $box->infoBox($heading, $contents); echo '