-<?php\r
-/************************************************************************\r
- * MXChange v0.2.1 Start: 04/30/2005 *\r
- * ================ Last change: 04/30/2005 *\r
- * *\r
- * -------------------------------------------------------------------- *\r
- * File : what-list_country.php *\r
- * -------------------------------------------------------------------- *\r
- * Short description : Manage country codes *\r
- * -------------------------------------------------------------------- *\r
- * Kurzbeschreibung : Country codes verwalten *\r
- * -------------------------------------------------------------------- *\r
- * *\r
- * -------------------------------------------------------------------- *\r
- * Copyright (c) 2003 - 2008 by Roland Haeder *\r
- * For more information visit: http://www.mxchange.org *\r
- * *\r
- * This program is free software; you can redistribute it and/or modify *\r
- * it under the terms of the GNU General Public License as published by *\r
- * the Free Software Foundation; either version 2 of the License, or *\r
- * (at your option) any later version. *\r
- * *\r
- * This program is distributed in the hope that it will be useful, *\r
- * but WITHOUT ANY WARRANTY; without even the implied warranty of *\r
- * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *\r
- * GNU General Public License for more details. *\r
- * *\r
- * You should have received a copy of the GNU General Public License *\r
- * along with this program; if not, write to the Free Software *\r
- * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *\r
- * MA 02110-1301 USA *\r
- ************************************************************************/\r
-\r
-// Some security stuff...\r
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!is_admin()))\r
-{\r
- $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";\r
- require($INC);\r
-}\r
-\r
-// Add description as navigation point\r
-ADD_DESCR("admin", basename(__FILE__));\r
-\r
-// Add new code?\r
-if ((isset($_POST['add'])) && (!empty($_POST['code'])) && (!empty($_POST['descr'])))\r
-{\r
- // Check if country code does already exist\r
- $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_countries WHERE code='%s' LIMIT 1",\r
- array(strtoupper($_POST['code'])), __FILE__, __LINE__);\r
- if (SQL_NUMROWS($result) == 0)\r
- {\r
- // Save entry\r
- $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_countries (code, descr, is_active)\r
- VALUES('%s', '%s', '%s')",\r
- array(strtoupper(substr($_POST['code'], 0, 2)), $_POST['descr'], $_POST['is_active']), __FILE__, __LINE__);\r
-\r
- // Country added\r
- $MSG = ADMIN_COUNTRY_ADDED_1.strtoupper($_POST['descr']).ADMIN_COUNTRY_ADDED_2;\r
- }\r
- else\r
- {\r
- // Free memory\r
- SQL_FREERESULT($result);\r
-\r
- // Does already exist\r
- $MSG = ADMIN_COUNTRY_ALREADY_1.strtoupper($_POST['code']).ADMIN_COUNTRY_ALREADY_2;\r
- }\r
-\r
- // Display message\r
- LOAD_TEMPLATE("admin_settings_saved", false, $MSG);\r
- OUTPUT_HTML("<BR>");\r
-}\r
-// Change status?\r
- elseif ((isset($_POST['change'])) && (!empty($_POST['id'])))\r
-{\r
- // Change all status\r
- ADMIN_CHANGE_ACTIVATION_STATUS($_POST['id'], "countries", "is_active");\r
-}\r
-// Edit / delete entries?\r
- elseif (((isset($_POST['edit'])) || (isset($_POST['delete']))) && (!empty($_POST['id'])))\r
-{\r
- if (count($_POST['id']) > 0)\r
- {\r
- if (isset($_POST['edit']))\r
- {\r
- // Edit template\r
- $row = "admin_list_country_edit_row";\r
- $post = "modify";\r
- $class = "admin_submit";\r
- $submit = ADMIN_COUNTRY_EDIT_NOW;\r
- $title = ADMIN_COUNTRY_EDIT_TITLE;\r
- $reset = "<INPUT type=\"reset\" class=\"admin_reset\" value=\"".UNDO_SELECTIONS."\"> *\n";\r
- }\r
- else\r
- {\r
- // Delete template\r
- $row = "admin_list_country_del_row";\r
- $post = "remove";\r
- $class = "admin_delete";\r
- $submit = ADMIN_COUNTRY_DELETE_NOW;\r
- $title = ADMIN_COUNTRY_DELETE_TITLE;\r
- $reset = "";\r
- }\r
-\r
- // Edit all selected country codes\r
- $OUT = ""; $SW = 2;\r
- foreach ($_POST['id'] as $id=>$status)\r
- {\r
- // Load data from DB\r
- $result = SQL_QUERY_ESC("SELECT code, descr FROM "._MYSQL_PREFIX."_countries WHERE id=%d LIMIT 1",\r
- array(bigintval($id)), __FILE__, __LINE__);\r
- if (SQL_NUMROWS($result) == 1)\r
- {\r
- // Load data\r
- list($code, $descr) = SQL_FETCHROW($result);\r
- SQL_FREERESULT($result);\r
-\r
- // Prepare data, load row template and switch colors\r
- $content = array(\r
- 'id' => $id,\r
- 'code' => $code,\r
- 'descr' => $descr,\r
- 'sw' => $SW,\r
- );\r
- if ($post == "modify")\r
- {\r
- // Generate default selection in edit-mode\r
- $content['status'] = ADD_OPTION_LINES("/ARRAY/", array('Y', 'N'), array(YES, NO ), $status);\r
- }\r
- else\r
- {\r
- // Only display status when in delete-mode\r
- $content['status'] = TRANSLATE_YESNO($status);\r
- }\r
- $OUT .= LOAD_TEMPLATE($row, true, $content);\r
- $SW = 3 - $SW;\r
- }\r
- }\r
- define('__COUNTRY_ROWS' , $OUT);\r
- define('__COUNTRY_MODE' , $post);\r
- define('__COUNTRY_CLASS' , $class);\r
- define('__COUNTRY_SUBMIT', $submit);\r
- define('__COUNTRY_TITLE' , $title);\r
- define('__COUNTRY_RESET' , $reset);\r
-\r
- // Load main template\r
- LOAD_TEMPLATE("admin_list_country_form");\r
- }\r
-}\r
- else\r
-{\r
- // Shall we modify / remove entries now?\r
- $MSG = ""; $SQLs = array();\r
- if ((isset($_POST['modify'])) && (!empty($_POST['id'])))\r
- {\r
- // Modify\r
- foreach ($_POST['id'] as $id=>$sel)\r
- {\r
- $SQLs[] = "UPDATE "._MYSQL_PREFIX."_countries SET code='".$_POST['code'][$id]."', descr='".$_POST['descr'][$id]."', is_active='".$_POST['is_active'][$id]."' WHERE id='".$id."' LIMIT 1";\r
- }\r
-\r
- // Create message\r
- $MSG = ADMIN_COUNTRIES_MODIFIED;\r
- }\r
- elseif ((isset($_POST['remove'])) && (!empty($_POST['id'])))\r
- {\r
- // Remove\r
- $IDs = implode(", ", bigintval($_POST['id']));\r
- $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_countries WHERE id IN (".$IDs.") LIMIT ".count($_POST['id'])."";\r
-\r
- // Create message\r
- $MSG = ADMIN_COUNTRIES_REMOVED;\r
- }\r
-\r
- if ((!empty($MSG)) && (count($SQLs) > 0))\r
- {\r
- // Run SQL commands\r
- foreach ($SQLs as $sql)\r
- {\r
- $result = SQL_QUERY($sql, __FILE__, __LINE__);\r
- }\r
-\r
- // Display message\r
- LOAD_TEMPLATE("admin_settings_saved", false, $MSG);\r
- OUTPUT_HTML("<BR>");\r
- }\r
-\r
- // Load currenty setup country codes to list\r
- $result = SQL_QUERY("SELECT id, code, descr, is_active FROM "._MYSQL_PREFIX."_countries ORDER BY code", __FILE__, __LINE__);\r
- if (SQL_NUMROWS($result) > 0)\r
- {\r
- // List all countries\r
- $OUT = ""; $SW = 2;\r
- while(list($id, $code, $descr, $active) = SQL_FETCHROW($result))\r
- {\r
- // Prepare array for the template\r
- $content = array(\r
- 'id' => $id,\r
- 'code' => $code,\r
- 'name' => $descr,\r
- 'active' => TRANSLATE_YESNO($active),\r
- 'sw' => $SW,\r
- 'status' => $active,\r
- );\r
-\r
- // Load row template and switch colors\r
- $OUT .= LOAD_TEMPLATE("admin_list_country_row", true, $content);\r
- $SW = 3 - $SW;\r
- }\r
-\r
- // Free memory\r
- SQL_FREERESULT($result);\r
- }\r
- else\r
- {\r
- // No code setup so far (not possible by this software! 'DE' for 'Deutschland' is default\r
- $OUT = LOAD_TEMPLATE("admin_list_country_no_row", true);\r
- }\r
-\r
- // Add list to constant for the template\r
- define('__COUNTRY_ROWS', $OUT);\r
-\r
- // Include add template\r
- define('__ADD_COUNTRY_FORM', LOAD_TEMPLATE("admin_add_country", true));\r
-\r
- // Load main template\r
- LOAD_TEMPLATE("admin_list_country");\r
-}\r
-\r
-//\r
-?>\r
+<?php
+/************************************************************************
+ * MXChange v0.2.1 Start: 04/30/2005 *
+ * ================ Last change: 04/30/2005 *
+ * *
+ * -------------------------------------------------------------------- *
+ * File : what-list_country.php *
+ * -------------------------------------------------------------------- *
+ * Short description : Manage country codes *
+ * -------------------------------------------------------------------- *
+ * Kurzbeschreibung : Country codes verwalten *
+ * -------------------------------------------------------------------- *
+ * *
+ * -------------------------------------------------------------------- *
+ * Copyright (c) 2003 - 2008 by Roland Haeder *
+ * For more information visit: http://www.mxchange.org *
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ * This program is distributed in the hope that it will be useful, *
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of *
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
+ * GNU General Public License for more details. *
+ * *
+ * You should have received a copy of the GNU General Public License *
+ * along with this program; if not, write to the Free Software *
+ * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
+ * MA 02110-1301 USA *
+ ************************************************************************/
+
+// Some security stuff...
+if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!is_admin()))
+{
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ require($INC);
+}
+
+// Add description as navigation point
+ADD_DESCR("admin", basename(__FILE__));
+
+// Add new code?
+if ((isset($_POST['add'])) && (!empty($_POST['code'])) && (!empty($_POST['descr'])))
+{
+ // Check if country code does already exist
+ $result = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_countries WHERE code='%s' LIMIT 1",
+ array(strtoupper($_POST['code'])), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) == 0)
+ {
+ // Save entry
+ $result = SQL_QUERY_ESC("INSERT INTO "._MYSQL_PREFIX."_countries (code, descr, is_active)
+ VALUES('%s', '%s', '%s')",
+ array(strtoupper(substr($_POST['code'], 0, 2)), $_POST['descr'], $_POST['is_active']), __FILE__, __LINE__);
+
+ // Country added
+ $MSG = ADMIN_COUNTRY_ADDED_1.strtoupper($_POST['descr']).ADMIN_COUNTRY_ADDED_2;
+ }
+ else
+ {
+ // Free memory
+ SQL_FREERESULT($result);
+
+ // Does already exist
+ $MSG = ADMIN_COUNTRY_ALREADY_1.strtoupper($_POST['code']).ADMIN_COUNTRY_ALREADY_2;
+ }
+
+ // Display message
+ LOAD_TEMPLATE("admin_settings_saved", false, $MSG);
+ OUTPUT_HTML("<BR>");
+}
+// Change status?
+ elseif ((isset($_POST['change'])) && (!empty($_POST['id'])))
+{
+ // Change all status
+ ADMIN_CHANGE_ACTIVATION_STATUS($_POST['id'], "countries", "is_active");
+}
+// Edit / delete entries?
+ elseif (((isset($_POST['edit'])) || (isset($_POST['delete']))) && (!empty($_POST['id'])))
+{
+ if (count($_POST['id']) > 0)
+ {
+ if (isset($_POST['edit']))
+ {
+ // Edit template
+ $row = "admin_list_country_edit_row";
+ $post = "modify";
+ $class = "admin_submit";
+ $submit = ADMIN_COUNTRY_EDIT_NOW;
+ $title = ADMIN_COUNTRY_EDIT_TITLE;
+ $reset = "<INPUT type=\"reset\" class=\"admin_reset\" value=\"".UNDO_SELECTIONS."\"> *\n";
+ }
+ else
+ {
+ // Delete template
+ $row = "admin_list_country_del_row";
+ $post = "remove";
+ $class = "admin_delete";
+ $submit = ADMIN_COUNTRY_DELETE_NOW;
+ $title = ADMIN_COUNTRY_DELETE_TITLE;
+ $reset = "";
+ }
+
+ // Edit all selected country codes
+ $OUT = ""; $SW = 2;
+ foreach ($_POST['id'] as $id=>$status)
+ {
+ // Load data from DB
+ $result = SQL_QUERY_ESC("SELECT code, descr FROM "._MYSQL_PREFIX."_countries WHERE id=%d LIMIT 1",
+ array(bigintval($id)), __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) == 1)
+ {
+ // Load data
+ list($code, $descr) = SQL_FETCHROW($result);
+ SQL_FREERESULT($result);
+
+ // Prepare data, load row template and switch colors
+ $content = array(
+ 'id' => $id,
+ 'code' => $code,
+ 'descr' => $descr,
+ 'sw' => $SW,
+ );
+ if ($post == "modify")
+ {
+ // Generate default selection in edit-mode
+ $content['status'] = ADD_OPTION_LINES("/ARRAY/", array('Y', 'N'), array(YES, NO ), $status);
+ }
+ else
+ {
+ // Only display status when in delete-mode
+ $content['status'] = TRANSLATE_YESNO($status);
+ }
+ $OUT .= LOAD_TEMPLATE($row, true, $content);
+ $SW = 3 - $SW;
+ }
+ }
+ define('__COUNTRY_ROWS' , $OUT);
+ define('__COUNTRY_MODE' , $post);
+ define('__COUNTRY_CLASS' , $class);
+ define('__COUNTRY_SUBMIT', $submit);
+ define('__COUNTRY_TITLE' , $title);
+ define('__COUNTRY_RESET' , $reset);
+
+ // Load main template
+ LOAD_TEMPLATE("admin_list_country_form");
+ }
+}
+ else
+{
+ // Shall we modify / remove entries now?
+ $MSG = ""; $SQLs = array();
+ if ((isset($_POST['modify'])) && (!empty($_POST['id'])))
+ {
+ // Modify
+ foreach ($_POST['id'] as $id=>$sel)
+ {
+ $SQLs[] = "UPDATE "._MYSQL_PREFIX."_countries SET code='".$_POST['code'][$id]."', descr='".$_POST['descr'][$id]."', is_active='".$_POST['is_active'][$id]."' WHERE id='".$id."' LIMIT 1";
+ }
+
+ // Create message
+ $MSG = ADMIN_COUNTRIES_MODIFIED;
+ }
+ elseif ((isset($_POST['remove'])) && (!empty($_POST['id'])))
+ {
+ // Remove
+ $IDs = implode(", ", bigintval($_POST['id']));
+ $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_countries WHERE id IN (".$IDs.") LIMIT ".count($_POST['id'])."";
+
+ // Create message
+ $MSG = ADMIN_COUNTRIES_REMOVED;
+ }
+
+ if ((!empty($MSG)) && (count($SQLs) > 0))
+ {
+ // Run SQL commands
+ foreach ($SQLs as $sql)
+ {
+ $result = SQL_QUERY($sql, __FILE__, __LINE__);
+ }
+
+ // Display message
+ LOAD_TEMPLATE("admin_settings_saved", false, $MSG);
+ OUTPUT_HTML("<BR>");
+ }
+
+ // Load currenty setup country codes to list
+ $result = SQL_QUERY("SELECT id, code, descr, is_active FROM "._MYSQL_PREFIX."_countries ORDER BY code", __FILE__, __LINE__);
+ if (SQL_NUMROWS($result) > 0)
+ {
+ // List all countries
+ $OUT = ""; $SW = 2;
+ while(list($id, $code, $descr, $active) = SQL_FETCHROW($result))
+ {
+ // Prepare array for the template
+ $content = array(
+ 'id' => $id,
+ 'code' => $code,
+ 'name' => $descr,
+ 'active' => TRANSLATE_YESNO($active),
+ 'sw' => $SW,
+ 'status' => $active,
+ );
+
+ // Load row template and switch colors
+ $OUT .= LOAD_TEMPLATE("admin_list_country_row", true, $content);
+ $SW = 3 - $SW;
+ }
+
+ // Free memory
+ SQL_FREERESULT($result);
+ }
+ else
+ {
+ // No code setup so far (not possible by this software! 'DE' for 'Deutschland' is default
+ $OUT = LOAD_TEMPLATE("admin_list_country_no_row", true);
+ }
+
+ // Add list to constant for the template
+ define('__COUNTRY_ROWS', $OUT);
+
+ // Include add template
+ define('__ADD_COUNTRY_FORM', LOAD_TEMPLATE("admin_add_country", true));
+
+ // Load main template
+ LOAD_TEMPLATE("admin_list_country");
+}
+
+//
+?>