PageRenderTime 123ms CodeModel.GetById 26ms RepoModel.GetById 1ms app.codeStats 0ms

/admin/categories.php

http://daocart.googlecode.com/
PHP | 1025 lines | 779 code | 147 blank | 99 comment | 167 complexity | a91cdd2d312df540c8c7d8bc509c66b5 MD5 | raw file
Possible License(s): AGPL-1.0, GPL-2.0, BSD-3-Clause

Large files files are truncated, but you can click here to view the full file

    

  1. <?php

    2. 

  2. /**

    3. 

  3.  * @package admin

    4. 

  4.  * @copyright Copyright 2003-2007 Zen Cart Development Team

    5. 

  5.  * @copyright Portions Copyright 2003 osCommerce

    6. 

  6.  * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0

    7. 

  7.  * @version $Id: categories.php 6991 2007-09-13 01:01:24Z drbyte $

    8. 

  8.  */

    9. 

  9. 

    10. 

  10.   require('includes/application_top.php');

    11. 

  11. 

    12. 

  12.   require(DIR_WS_MODULES . 'prod_cat_header_code.php');

    13. 

  13. 

    14. 

  14.   $action = (isset($_GET['action']) ? $_GET['action'] : '');

    15. 

  15. 

    16. 

  16.   if (!isset($_SESSION['categories_products_sort_order'])) {

    17. 

  17.     $_SESSION['categories_products_sort_order'] = CATEGORIES_PRODUCTS_SORT_ORDER;

    18. 

  18.   }

    19. 

  19. 

    20. 

  20.   if (!isset($_GET['reset_categories_products_sort_order'])) {

    21. 

  21.     $reset_categories_products_sort_order = $_SESSION['categories_products_sort_order'];

    22. 

  22.   }

    23. 

  23. 

    24. 

  24.   if (zen_not_null($action)) {

    25. 

  25.     switch ($action) {

    26. 

  26.       case 'set_categories_products_sort_order':

    27. 

  27.       $_SESSION['categories_products_sort_order'] = $_GET['reset_categories_products_sort_order'];

    28. 

  28.       $action='';

    29. 

  29.       zen_redirect(zen_href_link(FILENAME_CATEGORIES,  'cPath=' . $_GET['cPath'] . ((isset($_GET['pID']) and !empty($_GET['pID'])) ? '&pID=' . $_GET['pID'] : '') . ((isset($_GET['page']) and !empty($_GET['page'])) ? '&page=' . $_GET['page'] : '')));

    30. 

  30.       break;

    31. 

  31.       case 'set_editor':

    32. 

  32.       // Reset will be done by init_html_editor.php. Now we simply redirect to refresh page properly.

    33. 

  33.       $action='';

    34. 

  34.       zen_redirect(zen_href_link(FILENAME_CATEGORIES,  'cPath=' . $_GET['cPath'] . ((isset($_GET['pID']) and !empty($_GET['pID'])) ? '&pID=' . $_GET['pID'] : '') . ((isset($_GET['page']) and !empty($_GET['page'])) ? '&page=' . $_GET['page'] : '')));

    35. 

  35.       break;

    36. 

  36. 

    37. 

  37.       case 'update_category_status':

    38. 

  38.       // disable category and products including subcategories

    39. 

  39.       if (isset($_POST['categories_id'])) {

    40. 

  40.         $categories_id = zen_db_prepare_input($_POST['categories_id']);

    41. 

  41. 

    42. 

  42.         $categories = zen_get_category_tree($categories_id, '', '0', '', true);

    43. 

  43. 

    44. 

  44.         for ($i=0, $n=sizeof($categories); $i<$n; $i++) {

    45. 

  45.           $product_ids = $db->Execute("select products_id

    46. 

  46.                                          from " . TABLE_PRODUCTS_TO_CATEGORIES . "

    47. 

  47.                                          where categories_id = '" . (int)$categories[$i]['id'] . "'");

    48. 

  48. 

    49. 

  49.           while (!$product_ids->EOF) {

    50. 

  50.             $products[$product_ids->fields['products_id']]['categories'][] = $categories[$i]['id'];

    51. 

  51.             $product_ids->MoveNext();

    52. 

  52.           }

    53. 

  53.         }

    54. 

  54. 

    55. 

  55.         // change the status of categories and products

    56. 

  56.         zen_set_time_limit(600);

    57. 

  57.         for ($i=0, $n=sizeof($categories); $i<$n; $i++) {

    58. 

  58.           if ($_POST['categories_status'] == '1') {

    59. 

  59.             $categories_status = '0';

    60. 

  60.             $products_status = '0';

    61. 

  61.           } else {

    62. 

  62.             $categories_status = '1';

    63. 

  63.             $products_status = '1';

    64. 

  64.           }

    65. 

  65. 

    66. 

  66.           $sql = "update " . TABLE_CATEGORIES . " set categories_status='" . $categories_status . "'

    67. 

  67.                   where categories_id='" . $categories[$i]['id'] . "'";

    68. 

  68.           $db->Execute($sql);

    69. 

  69. 

    70. 

  70.           // set products_status based on selection

    71. 

  71.           if ($_POST['set_products_status'] == 'set_products_status_nochange') {

    72. 

  72.             // do not change current product status

    73. 

  73.           } else {

    74. 

  74.             if ($_POST['set_products_status'] == 'set_products_status_on') {

    75. 

  75.               $products_status = '1';

    76. 

  76.             } else {

    77. 

  77.               $products_status = '0';

    78. 

  78.             }

    79. 

  79. 

    80. 

  80.             $sql = "select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id='" . $categories[$i]['id'] . "'";

    81. 

  81.             $category_products = $db->Execute($sql);

    82. 

  82. 

    83. 

  83.             while (!$category_products->EOF) {

    84. 

  84.               $sql = "update " . TABLE_PRODUCTS . " set products_status='" . $products_status . "' where products_id='" . $category_products->fields['products_id'] . "'";

    85. 

  85.               $db->Execute($sql);

    86. 

  86.               $category_products->MoveNext();

    87. 

  87.             }

    88. 

  88.           }

    89. 

  89.         } // for

    90. 

  90. 

    91. 

  91.       }

    92. 

  92.       zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $_GET['cPath'] . '&cID=' . $_GET['cID']));

    93. 

  93.       break;

    94. 

  94. 

    95. 

  95.       case 'remove_type':

    96. 

  96.       $sql = "delete from " .  TABLE_PRODUCT_TYPES_TO_CATEGORY . "

    97. 

  97.               where category_id = '" . zen_db_prepare_input($_GET['cID']) . "'

    98. 

  98.               and product_type_id = '" . zen_db_prepare_input($_GET['type_id']) . "'";

    99. 

  99. 

    100. 

  100.       $db->Execute($sql);

    101. 

  101. 

    102. 

  102.       zen_remove_restrict_sub_categories($_GET['cID'], $_GET['type_id']);

    103. 

  103. 

    104. 

  104.       $action = "edit";

    105. 

  105.       zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'action=edit_category&cPath=' . $_GET['cPath'] . '&cID=' . zen_db_prepare_input($_GET['cID'])));

    106. 

  106.       break;

    107. 

  107.       case 'setflag':

    108. 

  108.       if ( ($_GET['flag'] == '0') || ($_GET['flag'] == '1') ) {

    109. 

  109.         if (isset($_GET['pID'])) {

    110. 

  110.           zen_set_product_status($_GET['pID'], $_GET['flag']);

    111. 

  111.         }

    112. 

  112. 

    113. 

  113.       }

    114. 

  114. 

    115. 

  115.       zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $_GET['cPath'] . '&pID=' . $_GET['pID'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));

    116. 

  116.       break;

    117. 

  117.       case 'insert_category':

    118. 

  118.       case 'update_category':

    119. 

  119.       if ( isset($_POST['add_type']) or isset($_POST['add_type_all']) ) {

    120. 

  120.         // check if it is already restricted

    121. 

  121.         $sql = "select * from " . TABLE_PRODUCT_TYPES_TO_CATEGORY . "

    122. 

  122.                 where category_id = '" . zen_db_prepare_input($_POST['categories_id']) . "'

    123. 

  123.                 and product_type_id = '" . zen_db_prepare_input($_POST['restrict_type']) . "'";

    124. 

  124. 

    125. 

  125.         $type_to_cat = $db->Execute($sql);

    126. 

  126.         if ($type_to_cat->RecordCount() < 1) {

    127. 

  127.           //@@TODO find all sub-categories and restrict them as well.

    128. 

  128. 

    129. 

  129.           $insert_sql_data = array('category_id' => zen_db_prepare_input($_POST['categories_id']),

    130. 

  130.                                    'product_type_id' => zen_db_prepare_input($_POST['restrict_type']));

    131. 

  131. 

    132. 

  132.           zen_db_perform(TABLE_PRODUCT_TYPES_TO_CATEGORY, $insert_sql_data);

    133. 

  133.           /*

    134. 

  134.           // moved below so evaluated separately from current category

    135. 

  135.           if (isset($_POST['add_type_all'])) {

    136. 

  136.           zen_restrict_sub_categories($_POST['categories_id'], $_POST['restrict_type']);

    137. 

  137.           }

    138. 

  138.           */

    139. 

  139.         }

    140. 

  140.         // add product type restrictions to subcategories if not already set

    141. 

  141.         if (isset($_POST['add_type_all'])) {

    142. 

  142.           zen_restrict_sub_categories($_POST['categories_id'], $_POST['restrict_type']);

    143. 

  143.         }

    144. 

  144.         $action = "edit";

    145. 

  145.         zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'action=edit_category&cPath=' . $cPath . '&cID=' . zen_db_prepare_input($_POST['categories_id'])));

    146. 

  146.       }

    147. 

  147.       if (isset($_POST['categories_id'])) $categories_id = zen_db_prepare_input($_POST['categories_id']);

    148. 

  148.       $sort_order = zen_db_prepare_input($_POST['sort_order']);

    149. 

  149. 

    150. 

  150.       $sql_data_array = array('sort_order' => (int)$sort_order);

    151. 

  151. 

    152. 

  152.       if ($action == 'insert_category') {

    153. 

  153.         $insert_sql_data = array('parent_id' => $current_category_id,

    154. 

  154.                                  'date_added' => 'now()');

    155. 

  155. 

    156. 

  156.         $sql_data_array = array_merge($sql_data_array, $insert_sql_data);

    157. 

  157. 

    158. 

  158.         zen_db_perform(TABLE_CATEGORIES, $sql_data_array);

    159. 

  159. 

    160. 

  160.         $categories_id = zen_db_insert_id();

    161. 

  161.         // check if [arent is restricted

    162. 

  162.         $sql = "select parent_id from " . TABLE_CATEGORIES . "

    163. 

  163.                 where categories_id = '" . $categories_id . "'";

    164. 

  164. 

    165. 

  165.         $parent_cat = $db->Execute($sql);

    166. 

  166.         if ($parent_cat->fields['parent_id'] != '0') {

    167. 

  167.           $sql = "select * from " . TABLE_PRODUCT_TYPES_TO_CATEGORY . "

    168. 

  168.                   where category_id = '" . $parent_cat->fields['parent_id'] . "'";

    169. 

  169.           $has_type = $db->Execute($sql);

    170. 

  170.           if ($has_type->RecordCount() > 0 ) {

    171. 

  171.             while (!$has_type->EOF) {

    172. 

  172.               $insert_sql_data = array('category_id' => $categories_id,

    173. 

  173.                                        'product_type_id' => $has_type->fields['product_type_id']);

    174. 

  174.               zen_db_perform(TABLE_PRODUCT_TYPES_TO_CATEGORY, $insert_sql_data);

    175. 

  175.               $has_type->moveNext();

    176. 

  176.             }

    177. 

  177.           }

    178. 

  178.         }

    179. 

  179.       } elseif ($action == 'update_category') {

    180. 

  180.         $update_sql_data = array('last_modified' => 'now()');

    181. 

  181. 

    182. 

  182.         $sql_data_array = array_merge($sql_data_array, $update_sql_data);

    183. 

  183. 

    184. 

  184.         zen_db_perform(TABLE_CATEGORIES, $sql_data_array, 'update', "categories_id = '" . (int)$categories_id . "'");

    185. 

  185.       }

    186. 

  186. 

    187. 

  187.       $languages = zen_get_languages();

    188. 

  188.       for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

    189. 

  189.         $categories_name_array = $_POST['categories_name'];

    190. 

  190.         $categories_description_array = $_POST['categories_description'];

    191. 

  191.         $language_id = $languages[$i]['id'];

    192. 

  192. 

    193. 

  193.         // clean $categories_description when blank or just <p /> left behind

    194. 

  194.         $sql_data_array = array('categories_name' => zen_db_prepare_input($categories_name_array[$language_id]),

    195. 

  195.                                 'categories_description' => ($categories_description_array[$language_id] == '<p />' ? '' : zen_db_prepare_input($categories_description_array[$language_id])));

    196. 

  196. 

    197. 

  197.         if ($action == 'insert_category') {

    198. 

  198.           $insert_sql_data = array('categories_id' => $categories_id,

    199. 

  199.                                    'language_id' => $languages[$i]['id']);

    200. 

  200. 

    201. 

  201.           $sql_data_array = array_merge($sql_data_array, $insert_sql_data);

    202. 

  202. 

    203. 

  203.           zen_db_perform(TABLE_CATEGORIES_DESCRIPTION, $sql_data_array);

    204. 

  204.         } elseif ($action == 'update_category') {

    205. 

  205.           zen_db_perform(TABLE_CATEGORIES_DESCRIPTION, $sql_data_array, 'update', "categories_id = '" . (int)$categories_id . "' and language_id = '" . (int)$languages[$i]['id'] . "'");

    206. 

  206.         }

    207. 

  207.       }

    208. 

  208. 

    209. 

  209.       if ($_POST['categories_image_manual'] != '') {

    210. 

  210.         // add image manually

    211. 

  211.         $categories_image_name = $_POST['img_dir'] . $_POST['categories_image_manual'];

    212. 

  212.         $db->Execute("update " . TABLE_CATEGORIES . "

    213. 

  213.                       set categories_image = '" . $categories_image_name . "'

    214. 

  214.                       where categories_id = '" . (int)$categories_id . "'");

    215. 

  215.       } else {

    216. 

  216.         if ($categories_image = new upload('categories_image')) {

    217. 

  217.           $categories_image->set_destination(DIR_FS_CATALOG_IMAGES . $_POST['img_dir']);

    218. 

  218.           if ($categories_image->parse() && $categories_image->save()) {

    219. 

  219.             $categories_image_name = $_POST['img_dir'] . $categories_image->filename;

    220. 

  220.           }

    221. 

  221.           if ($categories_image->filename != 'none' && $categories_image->filename != '' && $_POST['image_delete'] != 1) {

    222. 

  222.             // save filename when not set to none and not blank

    223. 

  223.             $db->Execute("update " . TABLE_CATEGORIES . "

    224. 

  224.                           set categories_image = '" . $categories_image_name . "'

    225. 

  225.                           where categories_id = '" . (int)$categories_id . "'");

    226. 

  226.           } else {

    227. 

  227.             // remove filename when set to none and not blank

    228. 

  228.             if ($categories_image->filename != '' || $_POST['image_delete'] == 1) {

    229. 

  229.               $db->Execute("update " . TABLE_CATEGORIES . "

    230. 

  230.                             set categories_image = ''

    231. 

  231.                             where categories_id = '" . (int)$categories_id . "'");

    232. 

  232.             }

    233. 

  233.           }

    234. 

  234.         }

    235. 

  235.       }

    236. 

  236. 

    237. 

  237.       zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories_id));

    238. 

  238.       break;

    239. 

  239. 

    240. 

  240.       // bof: categories meta tags

    241. 

  241.       case 'update_category_meta_tags':

    242. 

  242.       // add or update meta tags

    243. 

  243.       //die('I SEE ' . $action . ' - ' . $_POST['categories_id']);

    244. 

  244.       $categories_id = $_POST['categories_id'];

    245. 

  245.       $languages = zen_get_languages();

    246. 

  246.       for ($i=0, $n=sizeof($languages); $i<$n; $i++) {

    247. 

  247.         $language_id = $languages[$i]['id'];

    248. 

  248.         $check = $db->Execute("select *

    249. 

  249.                                from " . TABLE_METATAGS_CATEGORIES_DESCRIPTION . "

    250. 

  250.                                where categories_id = '" . (int)$categories_id . "'

    251. 

  251.                                and language_id = '" . (int)$language_id . "'");

    252. 

  252.         if ($check->RecordCount() > 0) {

    253. 

  253.           $action = 'update_category_meta_tags';

    254. 

  254.         } else {

    255. 

  255.           $action = 'insert_categories_meta_tags';

    256. 

  256.         }

    257. 

  257. 

    258. 

  258.         $sql_data_array = array('metatags_title' => zen_db_prepare_input($_POST['metatags_title'][$language_id]),

    259. 

  259.                                 'metatags_keywords' => zen_db_prepare_input($_POST['metatags_keywords'][$language_id]),

    260. 

  260.                                 'metatags_description' => zen_db_prepare_input($_POST['metatags_description'][$language_id]));

    261. 

  261. 

    262. 

  262.         if ($action == 'insert_categories_meta_tags') {

    263. 

  263.           $insert_sql_data = array('categories_id' => $categories_id,

    264. 

  264.                                    'language_id' => $language_id);

    265. 

  265.           $sql_data_array = array_merge($sql_data_array, $insert_sql_data);

    266. 

  266. 

    267. 

  267.           zen_db_perform(TABLE_METATAGS_CATEGORIES_DESCRIPTION, $sql_data_array);

    268. 

  268.         } elseif ($action == 'update_category_meta_tags') {

    269. 

  269.           zen_db_perform(TABLE_METATAGS_CATEGORIES_DESCRIPTION, $sql_data_array, 'update', "categories_id = '" . (int)$categories_id . "' and language_id = '" . (int)$language_id . "'");

    270. 

  270.         }

    271. 

  271.       }

    272. 

  272. 

    273. 

  273.       zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $categories_id));

    274. 

  274.       break;

    275. 

  275.       // eof: categories meta tags

    276. 

  276. 

    277. 

  277.       case 'delete_category_confirm_old':

    278. 

  278.       // demo active test

    279. 

  279.       if (zen_admin_demo()) {

    280. 

  280.         $_GET['action']= '';

    281. 

  281.         $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');

    282. 

  282.         zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));

    283. 

  283.       }

    284. 

  284.       if (isset($_POST['categories_id'])) {

    285. 

  285.         $categories_id = zen_db_prepare_input($_POST['categories_id']);

    286. 

  286. 

    287. 

  287.         $categories = zen_get_category_tree($categories_id, '', '0', '', true);

    288. 

  288.         $products = array();

    289. 

  289.         $products_delete = array();

    290. 

  290. 

    291. 

  291.         for ($i=0, $n=sizeof($categories); $i<$n; $i++) {

    292. 

  292.           $product_ids = $db->Execute("select products_id

    293. 

  293.                                            from " . TABLE_PRODUCTS_TO_CATEGORIES . "

    294. 

  294.                                            where categories_id = '" . (int)$categories[$i]['id'] . "'");

    295. 

  295. 

    296. 

  296.           while (!$product_ids->EOF) {

    297. 

  297.             $products[$product_ids->fields['products_id']]['categories'][] = $categories[$i]['id'];

    298. 

  298.             $product_ids->MoveNext();

    299. 

  299.           }

    300. 

  300.         }

    301. 

  301. 

    302. 

  302.         reset($products);

    303. 

  303.         while (list($key, $value) = each($products)) {

    304. 

  304.           $category_ids = '';

    305. 

  305. 

    306. 

  306.           for ($i=0, $n=sizeof($value['categories']); $i<$n; $i++) {

    307. 

  307.             $category_ids .= "'" . (int)$value['categories'][$i] . "', ";

    308. 

  308.           }

    309. 

  309.           $category_ids = substr($category_ids, 0, -2);

    310. 

  310. 

    311. 

  311.           $check = $db->Execute("select count(*) as total

    312. 

  312.                                            from " . TABLE_PRODUCTS_TO_CATEGORIES . "

    313. 

  313.                                            where products_id = '" . (int)$key . "'

    314. 

  314.                                            and categories_id not in (" . $category_ids . ")");

    315. 

  315.           if ($check->fields['total'] < '1') {

    316. 

  316.             $products_delete[$key] = $key;

    317. 

  317.           }

    318. 

  318.         }

    319. 

  319. 

    320. 

  320.         // removing categories can be a lengthy process

    321. 

  321.         zen_set_time_limit(600);

    322. 

  322.         for ($i=0, $n=sizeof($categories); $i<$n; $i++) {

    323. 

  323.           zen_remove_category($categories[$i]['id']);

    324. 

  324.         }

    325. 

  325. 

    326. 

  326.         reset($products_delete);

    327. 

  327.         while (list($key) = each($products_delete)) {

    328. 

  328.           zen_remove_product($key);

    329. 

  329.         }

    330. 

  330.       }

    331. 

  331. 

    332. 

  332. 

    333. 

  333.       zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));

    334. 

  334.       break;

    335. 

  335. 

    336. 

  336.       //////////////////////////////////

    337. 

  337.       // delete new

    338. 

  338. 

    339. 

  339.       case 'delete_category_confirm':

    340. 

  340.       // demo active test

    341. 

  341.       if (zen_admin_demo()) {

    342. 

  342.         $_GET['action']= '';

    343. 

  343.         $messageStack->add_session(ERROR_ADMIN_DEMO, 'caution');

    344. 

  344.         zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));

    345. 

  345.       }

    346. 

  346. 

    347. 

  347.       // future cat specific deletion

    348. 

  348.       $delete_linked = 'true';

    349. 

  349.       if ($_POST['delete_linked'] == 'delete_linked_no') {

    350. 

  350.         $delete_linked = 'false';

    351. 

  351.       } else {

    352. 

  352.         $delete_linked = 'true';

    353. 

  353.       }

    354. 

  354. 

    355. 

  355.       // delete category and products

    356. 

  356.       if (isset($_POST['categories_id'])) {

    357. 

  357.         $categories_id = zen_db_prepare_input($_POST['categories_id']);

    358. 

  358. 

    359. 

  359.         // create list of any subcategories in the selected category,

    360. 

  360.         $categories = zen_get_category_tree($categories_id, '', '0', '', true);

    361. 

  361. 

    362. 

  362.         zen_set_time_limit(600);

    363. 

  363. 

    364. 

  364.         // loop through this cat and subcats for delete-processing.

    365. 

  365.         for ($i=0, $n=sizeof($categories); $i<$n; $i++) {

    366. 

  366.           $sql = "select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id='" . $categories[$i]['id'] . "'";

    367. 

  367.           $category_products = $db->Execute($sql);

    368. 

  368. 

    369. 

  369.           while (!$category_products->EOF) {

    370. 

  370.             $cascaded_prod_id_for_delete = $category_products->fields['products_id'];

    371. 

  371.             $cascaded_prod_cat_for_delete = array();

    372. 

  372.             $cascaded_prod_cat_for_delete[] = $categories[$i]['id'];

    373. 

  373.             //echo 'processing product_id: ' . $cascaded_prod_id_for_delete . ' in category: ' . $cascaded_prod_cat_for_delete . '<br>';

    374. 

  374. 

    375. 

  375.             // determine product-type-specific override script for this product

    376. 

  376.             $product_type = zen_get_products_type($category_products->fields['products_id']);

    377. 

  377.             // now loop thru the delete_product_confirm script for each product in the current category

    378. 

  378.             if (file_exists(DIR_WS_MODULES . $zc_products->get_handler($product_type) . '/delete_product_confirm.php')) {

    379. 

  379.               require(DIR_WS_MODULES . $zc_products->get_handler($product_type) . '/delete_product_confirm.php');

    380. 

  380.             } else {

    381. 

  381.               require(DIR_WS_MODULES . 'delete_product_confirm.php');

    382. 

  382.             }

    383. 

  383. 

    384. 

  384.             // THIS LINE COMMENTED BECAUSE IT'S DONE ALREADY DURING DELETE_PRODUCT_CONFIRM.PHP:

    385. 

  385.             //zen_remove_product($category_products->fields['products_id'], $delete_linked);

    386. 

  386.             $category_products->MoveNext();

    387. 

  387.           }

    388. 

  388. 

    389. 

  389.           zen_remove_category($categories[$i]['id']);

    390. 

  390. 

    391. 

  391.         } // end for loop

    392. 

  392.       }

    393. 

  393.       zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));

    394. 

  394.       break;

    395. 

  395. 

    396. 

  396.       // eof delete new

    397. 

  397.       /////////////////////////////////

    398. 

  398.       // @@TODO where is delete_product_confirm

    399. 

  399. 

    400. 

  400.       case 'move_category_confirm':

    401. 

  401.       if (isset($_POST['categories_id']) && ($_POST['categories_id'] != $_POST['move_to_category_id'])) {

    402. 

  402.         $categories_id = zen_db_prepare_input($_POST['categories_id']);

    403. 

  403.         $new_parent_id = zen_db_prepare_input($_POST['move_to_category_id']);

    404. 

  404. 

    405. 

  405.         $path = explode('_', zen_get_generated_category_path_ids($new_parent_id));

    406. 

  406. 

    407. 

  407.         if (in_array($categories_id, $path)) {

    408. 

  408.           $messageStack->add_session(ERROR_CANNOT_MOVE_CATEGORY_TO_PARENT, 'error');

    409. 

  409. 

    410. 

  410.           zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));

    411. 

  411.         } else {

    412. 

  412. 

    413. 

  413.           $sql = "select count(*) as count from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id='" . (int)$new_parent_id . "'";

    414. 

  414.           $zc_count_products = $db->Execute($sql);

    415. 

  415. 

    416. 

  416.           if ( $zc_count_products->fields['count'] > 0) {

    417. 

  417.             $messageStack->add_session(ERROR_CATEGORY_HAS_PRODUCTS, 'error');

    418. 

  418.           } else {

    419. 

  419.             $messageStack->add_session(SUCCESS_CATEGORY_MOVED, 'success');

    420. 

  420.           }

    421. 

  421. 

    422. 

  422.           $db->Execute("update " . TABLE_CATEGORIES . "

    423. 

  423.                             set parent_id = '" . (int)$new_parent_id . "', last_modified = now()

    424. 

  424.                             where categories_id = '" . (int)$categories_id . "'");

    425. 

  425. 

    426. 

  426.           // fix here - if this is a category with subcats it needs to know to loop through

    427. 

  427.           // reset all products_price_sorter for moved category products

    428. 

  428.           $reset_price_sorter = $db->Execute("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id='" . (int)$categories_id . "'");

    429. 

  429.           while (!$reset_price_sorter->EOF) {

    430. 

  430.             zen_update_products_price_sorter($reset_price_sorter->fields['products_id']);

    431. 

  431.             $reset_price_sorter->MoveNext();

    432. 

  432.           }

    433. 

  433. 

    434. 

  434.           zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $new_parent_id));

    435. 

  435.         }

    436. 

  436.       } else {

    437. 

  437.         $messageStack->add_session(ERROR_CANNOT_MOVE_CATEGORY_TO_CATEGORY_SELF . $cPath, 'error');

    438. 

  438.         zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath));

    439. 

  439.       }

    440. 

  440. 

    441. 

  441.       break;

    442. 

  442.       // @@TODO where is move_product_confirm

    443. 

  443.       // @@TODO where is insert_product

    444. 

  444.       // @@TODO where is update_product

    445. 

  445. 

    446. 

  446.       // attribute features

    447. 

  447.       case 'delete_attributes':

    448. 

  448.       zen_delete_products_attributes($_GET['products_id']);

    449. 

  449.       $messageStack->add_session(SUCCESS_ATTRIBUTES_DELETED . ' ID#' . $_GET['products_id'], 'success');

    450. 

  450.       $action='';

    451. 

  451. 

    452. 

  452.       // reset products_price_sorter for searches etc.

    453. 

  453.       zen_update_products_price_sorter($_GET['products_id']);

    454. 

  454. 

    455. 

  455.       zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $_GET['products_id'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));

    456. 

  456.       break;

    457. 

  457. 

    458. 

  458.       case 'update_attributes_sort_order':

    459. 

  459.       zen_update_attributes_products_option_values_sort_order($_GET['products_id']);

    460. 

  460.       $messageStack->add_session(SUCCESS_ATTRIBUTES_UPDATE . ' ID#' . $_GET['products_id'], 'success');

    461. 

  461.       $action='';

    462. 

  462.       zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $_GET['products_id'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));

    463. 

  463.       break;

    464. 

  464. 

    465. 

  465.       // attributes copy to product

    466. 

  466.       case 'update_attributes_copy_to_product':

    467. 

  467.       $copy_attributes_delete_first = ($_POST['copy_attributes'] == 'copy_attributes_delete' ? '1' : '0');

    468. 

  468.       $copy_attributes_duplicates_skipped = ($_POST['copy_attributes'] == 'copy_attributes_ignore' ? '1' : '0');

    469. 

  469.       $copy_attributes_duplicates_overwrite = ($_POST['copy_attributes'] == 'copy_attributes_update' ? '1' : '0');

    470. 

  470.       zen_copy_products_attributes($_POST['products_id'], $_POST['products_update_id']);

    471. 

  471.       //      die('I would copy Product ID#' . $_POST['products_id'] . ' to a Product ID#' . $_POST['products_update_id'] . ' - Existing attributes ' . $_POST['copy_attributes']);

    472. 

  472.       $_GET['action']= '';

    473. 

  473.       zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $_GET['products_id'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));

    474. 

  474.       break;

    475. 

  475. 

    476. 

  476.       // attributes copy to category

    477. 

  477.       case 'update_attributes_copy_to_category':

    478. 

  478.       $copy_attributes_delete_first = ($_POST['copy_attributes'] == 'copy_attributes_delete' ? '1' : '0');

    479. 

  479.       $copy_attributes_duplicates_skipped = ($_POST['copy_attributes'] == 'copy_attributes_ignore' ? '1' : '0');

    480. 

  480.       $copy_attributes_duplicates_overwrite = ($_POST['copy_attributes'] == 'copy_attributes_update' ? '1' : '0');

    481. 

  481.       $copy_to_category = $db->Execute("select products_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id='" . $_POST['categories_update_id'] . "'");

    482. 

  482.       while (!$copy_to_category->EOF) {

    483. 

  483.         zen_copy_products_attributes($_POST['products_id'], $copy_to_category->fields['products_id']);

    484. 

  484.         $copy_to_category->MoveNext();

    485. 

  485.       }

    486. 

  486.       //      die('CATEGORIES - I would copy Product ID#' . $_POST['products_id'] . ' to a Category ID#' . $_POST['categories_update_id']  . ' - Existing attributes ' . $_POST['copy_attributes'] . ' Total Products ' . $copy_to_category->RecordCount());

    487. 

  487. 

    488. 

  488.       $_GET['action']= '';

    489. 

  489.       zen_redirect(zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&pID=' . $_GET['products_id'] . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')));

    490. 

  490.       break;

    491. 

  491.       case 'new_product':

    492. 

  492.       if (isset($_GET['product_type'])) {

    493. 

  493.         // see if this category is restricted

    494. 

  494.         $pieces = explode('_',$_GET['cPath']);

    495. 

  495.         $cat_id = $pieces[sizeof($pieces)-1];

    496. 

  496.         //	echo $cat_id;

    497. 

  497.         $sql = "select product_type_id from " . TABLE_PRODUCT_TYPES_TO_CATEGORY . " where category_id = '" . $cat_id . "'";

    498. 

  498.         $product_type_list = $db->Execute($sql);

    499. 

  499.         $sql = "select product_type_id from " . TABLE_PRODUCT_TYPES_TO_CATEGORY . " where category_id = '" . $cat_id . "' and product_type_id = '" . $_GET['product_type'] . "'";

    500. 

  500.         $product_type_good = $db->Execute($sql);

    501. 

  501.         if ($product_type_list->RecordCount() < 1 || $product_type_good->RecordCount() > 0) {

    502. 

  502.           $url = zen_get_all_get_params();

    503. 

  503.           $sql = "select type_handler from " . TABLE_PRODUCT_TYPES . " where type_id = '" . $_GET['product_type'] . "'";

    504. 

  504.           $handler = $db->Execute($sql);

    505. 

  505.           zen_redirect(zen_href_link($handler->fields['type_handler'] . '.php', zen_get_all_get_params()));

    506. 

  506.         } else {

    507. 

  507.           $messageStack->add(ERROR_CANNOT_ADD_PRODUCT_TYPE, 'error');

    508. 

  508.         }

    509. 

  509.       }

    510. 

  510.       break;

    511. 

  511.     }

    512. 

  512.   }

    513. 

  513. 

    514. 

  514.   // check if the catalog image directory exists

    515. 

  515.   if (is_dir(DIR_FS_CATALOG_IMAGES)) {

    516. 

  516.     if (!is_writeable(DIR_FS_CATALOG_IMAGES)) $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_NOT_WRITEABLE, 'error');

    517. 

  517.   } else {

    518. 

  518.     $messageStack->add(ERROR_CATALOG_IMAGE_DIRECTORY_DOES_NOT_EXIST, 'error');

    519. 

  519.   }

    520. 

  520. ?>

    521. 

  521. <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

    522. 

  522. <html <?php echo HTML_PARAMS; ?>>

    523. 

  523. <head>

    524. 

  524. <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

    525. 

  525. <title><?php echo TITLE; ?></title>

    526. 

  526. <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

    527. 

  527. <link rel="stylesheet" type="text/css" href="includes/cssjsmenuhover.css" media="all" id="hoverJS">

    528. 

  528. <script language="javascript" src="includes/menu.js"></script>

    529. 

  529. <script language="javascript" src="includes/general.js"></script>

    530. 

  530. <script type="text/javascript">

    531. 

  531. <!--

    532. 

  532. function init()

    533. 

  533. {

    534. 

  534.   cssjsmenu('navbar');

    535. 

  535.   if (document.getElementById)

    536. 

  536.   {

    537. 

  537.     var kill = document.getElementById('hoverJS');

    538. 

  538.     kill.disabled = true;

    539. 

  539.   }

    540. 

  540.   if (typeof _editor_url == "string") HTMLArea.replaceAll();

    541. 

  541. }

    542. 

  542. // -->

    543. 

  543. </script>

    544. 

  544. <?php if ($action != 'edit_category_meta_tags') { // bof: categories meta tags ?>

    545. 

  545. <?php if ($editor_handler != '') include ($editor_handler); ?>

    546. 

  546. <?php } // meta tags disable editor eof: categories meta tags?>

    547. 

  547. </head>

    548. 

  548. <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onLoad="init()">

    549. 

  549. <div id="spiffycalendar" class="text"></div>

    550. 

  550. <!-- header //-->

    551. 

  551. <?php require(DIR_WS_INCLUDES . 'header.php'); ?>

    552. 

  552. <!-- header_eof //-->

    553. 

  553. 

    554. 

  554. <!-- body //-->

    555. 

  555. <table border="0" width="100%" cellspacing="2" cellpadding="2">

    556. 

  556. <?php if ($action == '') { ?>

    557. 

  557.       <tr>

    558. 

  558.         <td><table border="0" cellspacing="0" cellpadding="0">

    559. 

  559.           <tr>

    560. 

  560.             <td class="smallText" align="center" width="100" valign="top"><?php echo TEXT_LEGEND; ?></td>

    561. 

  561.             <td class="smallText" align="center" width="100" valign="top"><?php echo TEXT_LEGEND_STATUS_OFF . '<br />' . zen_image(DIR_WS_IMAGES . 'icon_red_on.gif', IMAGE_ICON_STATUS_OFF); ?></td>

    562. 

  562.             <td class="smallText" align="center" width="100" valign="top"><?php echo TEXT_LEGEND_STATUS_ON . '<br />' . zen_image(DIR_WS_IMAGES . 'icon_green_on.gif', IMAGE_ICON_STATUS_ON); ?></td>

    563. 

  563.             <td class="smallText" align="center" width="100" valign="top"><?php echo TEXT_LEGEND_LINKED . '<br />' . zen_image(DIR_WS_IMAGES . 'icon_yellow_on.gif', IMAGE_ICON_LINKED); ?></td>

    564. 

  564.             <td class="smallText" align="center" width="150" valign="top"><?php echo TEXT_LEGEND_META_TAGS . '<br />' . TEXT_YES . '&nbsp;' . TEXT_NO . '<br />' . zen_image(DIR_WS_IMAGES . 'icon_edit_metatags_on.gif', ICON_METATAGS_ON) . '&nbsp;' . zen_image(DIR_WS_IMAGES . 'icon_edit_metatags_off.gif', ICON_METATAGS_OFF); ?></td>

    565. 

  565.           </tr>

    566. 

  566.         </table></td>

    567. 

  567.       </tr>

    568. 

  568.   <tr>

    569. 

  569.     <td class="smallText" width="100%" align="right">

    570. 

  570. <?php

    571. 

  571.       // toggle switch for editor

    572. 

  572.       echo TEXT_EDITOR_INFO . zen_draw_form('set_editor_form', FILENAME_CATEGORIES, '', 'get') . '&nbsp;&nbsp;' . zen_draw_pull_down_menu('reset_editor', $editors_pulldown, $current_editor_key, 'onChange="this.form.submit();"') . zen_hide_session_id() .

    573. 

  573.             zen_draw_hidden_field('cID', $cPath) .

    574. 

  574.             zen_draw_hidden_field('cPath', $cPath) .

    575. 

  575.             zen_draw_hidden_field('pID', $_GET['pID']) .

    576. 

  576.             zen_draw_hidden_field('page', $_GET['page']) .

    577. 

  577.             zen_draw_hidden_field('action', 'set_editor') .

    578. 

  578.       '</form>';

    579. 

  579. ?>

    580. 

  580.     </td>

    581. 

  581.   </tr>

    582. 

  582. 

    583. 

  583.   <tr>

    584. 

  584.     <td class="smallText" width="100%" align="right">

    585. 

  585.       <?php

    586. 

  586.       // check for which buttons to show for categories and products

    587. 

  587.       $check_categories = zen_has_category_subcategories($current_category_id);

    588. 

  588.       $check_products = zen_products_in_category_count($current_category_id, false, false, 1);

    589. 

  589. 

    590. 

  590.       $zc_skip_products = false;

    591. 

  591.       $zc_skip_categories = false;

    592. 

  592. 

    593. 

  593.       if ($check_products == 0) {

    594. 

  594.         $zc_skip_products = false;

    595. 

  595.         $zc_skip_categories = false;

    596. 

  596.       }

    597. 

  597.       if ($check_categories == true) {

    598. 

  598.         $zc_skip_products = true;

    599. 

  599.         $zc_skip_categories = false;

    600. 

  600.       }

    601. 

  601.       if ($check_products > 0) {

    602. 

  602.         $zc_skip_products = false;

    603. 

  603.         $zc_skip_categories = true;

    604. 

  604.       }

    605. 

  605. 

    606. 

  606.       if ($zc_skip_products == true) {

    607. 

  607.         // toggle switch for display sort order

    608. 

  608.         $categories_products_sort_order_array = array(array('id' => '0', 'text' => TEXT_SORT_CATEGORIES_SORT_ORDER_PRODUCTS_NAME),

    609. 

  609.         array('id' => '1', 'text' => TEXT_SORT_CATEGORIES_NAME)

    610. 

  610.         );

    611. 

  611.       } else {

    612. 

  612.         // toggle switch for display sort order

    613. 

  613.         $categories_products_sort_order_array = array(array('id' => '0', 'text' => TEXT_SORT_PRODUCTS_SORT_ORDER_PRODUCTS_NAME),

    614. 

  614.         array('id' => '1', 'text' => TEXT_SORT_PRODUCTS_NAME),

    615. 

  615.         array('id' => '2', 'text' => TEXT_SORT_PRODUCTS_MODEL),

    616. 

  616.         array('id' => '3', 'text'=> TEXT_SORT_PRODUCTS_QUANTITY),

    617. 

  617.         array('id' => '4', 'text'=> TEXT_SORT_PRODUCTS_QUANTITY_DESC),

    618. 

  618.         array('id' => '5', 'text'=> TEXT_SORT_PRODUCTS_PRICE),

    619. 

  619.         array('id' => '6', 'text'=> TEXT_SORT_PRODUCTS_PRICE_DESC)

    620. 

  620.         );

    621. 

  621.       }

    622. 

  622. 

    623. 

  623.       echo TEXT_CATEGORIES_PRODUCTS_SORT_ORDER_INFO . zen_draw_form('set_categories_products_sort_order_form', FILENAME_CATEGORIES, '', 'get') . '&nbsp;&nbsp;' . zen_draw_pull_down_menu('reset_categories_products_sort_order', $categories_products_sort_order_array, $reset_categories_products_sort_order, 'onChange="this.form.submit();"') . zen_hide_session_id() .

    624. 

  624.             zen_draw_hidden_field('cID', $cPath) .

    625. 

  625.             zen_draw_hidden_field('cPath', $cPath) .

    626. 

  626.             zen_draw_hidden_field('pID', $_GET['pID']) .

    627. 

  627.             zen_draw_hidden_field('page', $_GET['page']) .

    628. 

  628.             zen_draw_hidden_field('action', 'set_categories_products_sort_order') .

    629. 

  629.       '</form>';

    630. 

  630.       ?>

    631. 

  631.     </td>

    632. 

  632.   </tr>

    633. 

  633. 

    634. 

  634. <?php } ?>

    635. 

  635.   <tr>

    636. 

  636. <!-- body_text //-->

    637. 

  637.     <td width="100%" valign="top">

    638. 

  638. <?php

    639. 

  639.   require(DIR_WS_MODULES . 'category_product_listing.php');

    640. 

  640. 

    641. 

  641.   $heading = array();

    642. 

  642.   $contents = array();

    643. 

  643.   // Make an array of product types

    644. 

  644.   $sql = "select type_id, type_name from " . TABLE_PRODUCT_TYPES;

    645. 

  645.   $product_types = $db->Execute($sql);

    646. 

  646.   while (!$product_types->EOF) {

    647. 

  647.     $type_array[] = array('id' => $product_types->fields['type_id'], 'text' => $product_types->fields['type_name']);

    648. 

  648.     $product_types->MoveNext();

    649. 

  649.   }

    650. 

  650.   switch ($action) {

    651. 

  651.     case 'setflag_categories':

    652. 

  652.     $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_STATUS_CATEGORY . '</b>');

    653. 

  653.     $contents = array('form' => zen_draw_form('categories', FILENAME_CATEGORIES, 'action=update_category_status&cPath=' . $_GET['cPath'] . '&cID=' . $_GET['cID'], 'post', 'enctype="multipart/form-data"') . zen_draw_hidden_field('categories_id', $cInfo->categories_id) . zen_draw_hidden_field('categories_status', $cInfo->categories_status));

    654. 

  654.     $contents[] = array('text' => zen_get_category_name($cInfo->categories_id, $_SESSION['languages_id']));

    655. 

  655.     $contents[] = array('text' => '<br />' . TEXT_CATEGORIES_STATUS_WARNING . '<br /><br />');

    656. 

  656.     $contents[] = array('text' => TEXT_CATEGORIES_STATUS_INTRO . ' ' . ($cInfo->categories_status == '1' ? TEXT_CATEGORIES_STATUS_OFF : TEXT_CATEGORIES_STATUS_ON));

    657. 

  657.     if ($cInfo->categories_status == '1') {

    658. 

  658.       $contents[] = array('text' => '<br />' . TEXT_PRODUCTS_STATUS_INFO . ' ' . TEXT_PRODUCTS_STATUS_OFF . zen_draw_hidden_field('set_products_status_off', true));

    659. 

  659.     } else {

    660. 

  660.       $contents[] = array('text' => '<br />' . TEXT_PRODUCTS_STATUS_INFO . '<br />' .

    661. 

  661.       zen_draw_radio_field('set_products_status', 'set_products_status_on', true) . ' ' . TEXT_PRODUCTS_STATUS_ON . '<br />' .

    662. 

  662.       zen_draw_radio_field('set_products_status', 'set_products_status_off') . ' ' . TEXT_PRODUCTS_STATUS_OFF . '<br />' .

    663. 

  663.       zen_draw_radio_field('set_products_status', 'set_products_status_nochange') . ' ' . TEXT_PRODUCTS_STATUS_NOCHANGE);

    664. 

  664.     }

    665. 

  665. 

    666. 

  666. 

    667. 

  667.     //        $contents[] = array('text' => '<br />' . TEXT_PRODUCTS_STATUS_INFO . '<br />' . zen_draw_radio_field('set_products_status', 'set_products_status_off', true) . ' ' . TEXT_PRODUCTS_STATUS_OFF . '<br />' . zen_draw_radio_field('set_products_status', 'set_products_status_on') . ' ' . TEXT_PRODUCTS_STATUS_ON);

    668. 

  668. 

    669. 

  669.     $contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_update.gif', IMAGE_UPDATE) . ' <a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    670. 

  670.     break;

    671. 

  671. 

    672. 

  672.     case 'new_category':

    673. 

  673.     $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_NEW_CATEGORY . '</b>');

    674. 

  674. 

    675. 

  675.     $contents = array('form' => zen_draw_form('newcategory', FILENAME_CATEGORIES, 'action=insert_category&cPath=' . $cPath, 'post', 'enctype="multipart/form-data"'));

    676. 

  676.     $contents[] = array('text' => TEXT_NEW_CATEGORY_INTRO);

    677. 

  677. 

    678. 

  678.     $category_inputs_string = '';

    679. 

  679.     $languages = zen_get_languages();

    680. 

  680.     for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {

    681. 

  681.       $category_inputs_string .= '<br />' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . zen_draw_input_field('categories_name[' . $languages[$i]['id'] . ']', '', zen_set_field_length(TABLE_CATEGORIES_DESCRIPTION, 'categories_name'));

    682. 

  682.     }

    683. 

  683. 

    684. 

  684.     $contents[] = array('text' => '<br />' . TEXT_CATEGORIES_NAME . $category_inputs_string);

    685. 

  685.     $category_inputs_string = '';

    686. 

  686. 

    687. 

  687.     for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {

    688. 

  688.       $category_inputs_string .= '<br />' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;';

    689. 

  689.       if ($_SESSION['html_editor_preference_status']=='FCKEDITOR') {

    690. 

  690.                 $oFCKeditor = new FCKeditor('categories_description[' . $languages[$i]['id']  . ']') ;

    691. 

  691.                 $oFCKeditor->Value = zen_get_category_description($cInfo->categories_id, $languages[$i]['id']);

    692. 

  692.                 $oFCKeditor->Width  = '97%' ;

    693. 

  693.                 $oFCKeditor->Height = '200' ;

    694. 

  694. //                $oFCKeditor->Config['ToolbarLocation'] = 'Out:xToolbar' ;

    695. 

  695. //                $oFCKeditor->Create() ;

    696. 

  696.                 $output = $oFCKeditor->CreateHtml() ;

    697. 

  697.         $category_inputs_string .= '<br />' . $output;

    698. 

  698. 

    699. 

  699. //        $category_inputs_string .= '<IFRAME src= "' . DIR_WS_CATALOG . 'FCKeditor/fckeditor.html?FieldName=categories_description[' . $languages[$i]['id']  . ']&Upload=false&Browse=false&Toolbar=Short" width="97%" height="200" frameborder="no" scrolling="yes"></IFRAME>';

    700. 

  700. //        $category_inputs_string .= '<INPUT type="hidden" name="categories_description[' . $languages[$i]['id']  . ']" ' . 'value=' . "'" . zen_get_category_description($cInfo->categories_id, $languages[$i]['id']) . "'>";

    701. 

  701.       } else {

    702. 

  702.         $category_inputs_string .= zen_draw_textarea_field('categories_description[' . $languages[$i]['id'] . ']', 'soft', '100%', '20', zen_get_category_description($cInfo->categories_id, $languages[$i]['id']));

    703. 

  703.       }

    704. 

  704.     }

    705. 

  705.     $contents[] = array('text' => '<br />' . TEXT_CATEGORIES_DESCRIPTION . $category_inputs_string);

    706. 

  706.     $contents[] = array('text' => '<br />' . TEXT_CATEGORIES_IMAGE . '<br />' . zen_draw_file_field('categories_image'));

    707. 

  707.     $dir = @dir(DIR_FS_CATALOG_IMAGES);

    708. 

  708.     $dir_info[] = array('id' => '', 'text' => "Main Directory");

    709. 

  709.     while ($file = $dir->read()) {

    710. 

  710.       if (is_dir(DIR_FS_CATALOG_IMAGES . $file) && strtoupper($file) != 'CVS' && $file != "." && $file != "..") {

    711. 

  711.         $dir_info[] = array('id' => $file . '/', 'text' => $file);

    712. 

  712.       }

    713. 

  713.     }

    714. 

  714.     $dir->close();

    715. 

  715.     sort($dir_info);

    716. 

  716.     $default_directory = 'categories/';

    717. 

  717. 

    718. 

  718.     $contents[] = array('text' => TEXT_CATEGORIES_IMAGE_DIR . ' ' . zen_draw_pull_down_menu('img_dir', $dir_info, $default_directory));

    719. 

  719.     $contents[] = array('text' => '<br />' . TEXT_CATEGORIES_IMAGE_MANUAL . '&nbsp;' . zen_draw_input_field('categories_image_manual'));

    720. 

  720. 

    721. 

  721.     $contents[] = array('text' => '<br />' . TEXT_SORT_ORDER . '<br />' . zen_draw_input_field('sort_order', '', 'size="6"'));

    722. 

  722.     $contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_save.gif', IMAGE_SAVE) . ' <a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    723. 

  723.     break;

    724. 

  724.     case 'edit_category':

    725. 

  725.     // echo 'I SEE ' . $_SESSION['html_editor_preference_status'];

    726. 

  726.     // set image delete

    727. 

  727.     $on_image_delete = false;

    728. 

  728.     $off_image_delete = true;

    729. 

  729.     $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_EDIT_CATEGORY . '</b>');

    730. 

  730. 

    731. 

  731.     $contents = array('form' => zen_draw_form('categories', FILENAME_CATEGORIES, 'action=update_category&cPath=' . $cPath, 'post', 'enctype="multipart/form-data"') . zen_draw_hidden_field('categories_id', $cInfo->categories_id));

    732. 

  732.     $contents[] = array('text' => TEXT_EDIT_INTRO);

    733. 

  733. 

    734. 

  734.     $languages = zen_get_languages();

    735. 

  735. 

    736. 

  736.     $category_inputs_string = '';

    737. 

  737.     for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {

    738. 

  738.       $category_inputs_string .= '<br />' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' . zen_draw_input_field('categories_name[' . $languages[$i]['id'] . ']', zen_get_category_name($cInfo->categories_id, $languages[$i]['id']), zen_set_field_length(TABLE_CATEGORIES_DESCRIPTION, 'categories_name'));

    739. 

  739.     }

    740. 

  740.     $contents[] = array('text' => '<br />' . TEXT_EDIT_CATEGORIES_NAME . $category_inputs_string);

    741. 

  741.     $category_inputs_string = '';

    742. 

  742.     for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {

    743. 

  743.       $category_inputs_string .= '<br />' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' ;

    744. 

  744.       if ($_SESSION['html_editor_preference_status']=='FCKEDITOR') {

    745. 

  745.                 $oFCKeditor = new FCKeditor('categories_description[' . $languages[$i]['id']  . ']') ;

    746. 

  746.                 $oFCKeditor->Value = zen_get_category_description($cInfo->categories_id, $languages[$i]['id']);

    747. 

  747.                 $oFCKeditor->Width  = '97%' ;

    748. 

  748.                 $oFCKeditor->Height = '200' ;

    749. 

  749. //                $oFCKeditor->Config['ToolbarLocation'] = 'Out:xToolbar' ;

    750. 

  750. //                $oFCKeditor->Create() ;

    751. 

  751.                 $output = $oFCKeditor->CreateHtml() ;

    752. 

  752.         $category_inputs_string .= '<br />' . $output;

    753. 

  753. //        $category_inputs_string .= '<IFRAME src= "' . DIR_WS_CATALOG . 'FCKeditor/fckeditor.html?FieldName=categories_description[' . $languages[$i]['id']  . ']&Upload=false&Browse=false&Toolbar=Short" width="97%" height="200" frameborder="no" scrolling="yes"></IFRAME>';

    754. 

  754. //        $category_inputs_string .= '<INPUT type="hidden" name="categories_description[' . $languages[$i]['id']  . ']" ' . 'value=' . "'" . zen_get_category_description($cInfo->categories_id, $languages[$i]['id']) . "'>";

    755. 

  755.       } else {

    756. 

  756.         $category_inputs_string .= zen_draw_textarea_field('categories_description[' . $languages[$i]['id'] . ']', 'soft', '100%', '20', zen_get_category_description($cInfo->categories_id, $languages[$i]['id']));

    757. 

  757.       }

    758. 

  758.     }

    759. 

  759.     $contents[] = array('text' => '<br />' . TEXT_CATEGORIES_DESCRIPTION . $category_inputs_string);

    760. 

  760.     $contents[] = array('text' => '<br />' . TEXT_EDIT_CATEGORIES_IMAGE . '<br />' . zen_draw_file_field('categories_image'));

    761. 

  761. 

    762. 

  762.     $dir = @dir(DIR_FS_CATALOG_IMAGES);

    763. 

  763.     $dir_info[] = array('id' => '', 'text' => "Main Directory");

    764. 

  764.     while ($file = $dir->read()) {

    765. 

  765.       if (is_dir(DIR_FS_CATALOG_IMAGES . $file) && strtoupper($file) != 'CVS' && $file != "." && $file != "..") {

    766. 

  766.         $dir_info[] = array('id' => $file . '/', 'text' => $file);

    767. 

  767.       }

    768. 

  768.     }

    769. 

  769.     $dir->close();

    770. 

  770.     sort($dir_info);

    771. 

  771.     $default_directory = substr( $cInfo->categories_image, 0,strpos( $cInfo->categories_image, '/')+1);

    772. 

  772. 

    773. 

  773.     $contents[] = array('text' => TEXT_CATEGORIES_IMAGE_DIR . ' ' . zen_draw_pull_down_menu('img_dir', $dir_info, $default_directory));

    774. 

  774. 

    775. 

  775.     $contents[] = array('text' => '<br />' . TEXT_CATEGORIES_IMAGE_MANUAL . '&nbsp;' . zen_draw_input_field('categories_image_manual'));

    776. 

  776. 

    777. 

  777.     $contents[] = array('text' => '<br />' . zen_info_image($cInfo->categories_image, $cInfo->categories_name));

    778. 

  778.     $contents[] = array('text' => '<br />' . $cInfo->categories_image);

    779. 

  779.     $contents[] = array('text' => '<br />' . TEXT_IMAGES_DELETE . ' ' . zen_draw_radio_field('image_delete', '0', $off_image_delete) . '&nbsp;' . TABLE_HEADING_NO . ' ' . zen_draw_radio_field('image_delete', '1', $on_image_delete) . '&nbsp;' . TABLE_HEADING_YES);

    780. 

  780. 

    781. 

  781.     $contents[] = array('text' => '<br />' . TEXT_EDIT_SORT_ORDER . '<br />' . zen_draw_input_field('sort_order', $cInfo->sort_order, 'size="6"'));

    782. 

  782.     $contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_save.gif', IMAGE_SAVE) . ' <a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    783. 

  783.     $contents[] = array('text' => TEXT_RESTRICT_PRODUCT_TYPE . ' ' . zen_draw_pull_down_menu('restrict_type', $type_array) . '&nbsp<input type="submit" name="add_type_all" value="' . BUTTON_ADD_PRODUCT_TYPES_SUBCATEGORIES_ON . '">' . '&nbsp<input type="submit" name="add_type" value="' . BUTTON_ADD_PRODUCT_TYPES_SUBCATEGORIES_OFF . '">');

    784. 

  784.     $sql = "select * from " . TABLE_PRODUCT_TYPES_TO_CATEGORY . "

    785. 

  785.                            where category_id = '" . $cInfo->categories_id . "'";

    786. 

  786. 

    787. 

  787.     $restrict_types = $db->Execute($sql);

    788. 

  788.     if ($restrict_types->RecordCount() > 0 ) {

    789. 

  789.       $contents[] = array('text' => '<br />' . TEXT_CATEGORY_HAS_RESTRICTIONS . '<br />');

    790. 

  790.       while (!$restrict_types->EOF) {

    791. 

  791.         $sql = "select type_name from " . TABLE_PRODUCT_TYPES . " where type_id = '" . $restrict_types->fields['product_type_id'] . "'";

    792. 

  792.         $type = $db->Execute($sql);

    793. 

  793.         $contents[] = array('text' => '<a href="' . zen_href_link(FILENAME_CATEGORIES, 'action=remove_type&cPath=' . $cPath . '&cID='.$cInfo->categories_id.'&type_id='.$restrict_types->fields['product_type_id']) . '">' . zen_image_button('button_delete.gif', IMAGE_DELETE) . '</a>&nbsp;' . $type->fields['type_name'] . '<br />');

    794. 

  794.         $restrict_types->MoveNext();

    795. 

  795.       }

    796. 

  796.     }

    797. 

  797.     break;

    798. 

  798.     case 'delete_category':

    799. 

  799.     $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_CATEGORY . '</b>');

    800. 

  800. 

    801. 

  801.     $contents = array('form' => zen_draw_form('categories', FILENAME_CATEGORIES, 'action=delete_category_confirm&cPath=' . $cPath) . zen_draw_hidden_field('categories_id', $cInfo->categories_id));

    802. 

  802.     $contents[] = array('text' => TEXT_DELETE_CATEGORY_INTRO);

    803. 

  803.     $contents[] = array('text' => '<br />' . TEXT_DELETE_CATEGORY_INTRO_LINKED_PRODUCTS);

    804. 

  804.     $contents[] = array('text' => '<br /><b>' . $cInfo->categories_name . '</b>');

    805. 

  805.     if ($cInfo->childs_count > 0) $contents[] = array('text' => '<br />' . sprintf(TEXT_DELETE_WARNING_CHILDS, $cInfo->childs_count));

    806. 

  806.     if ($cInfo->products_count > 0) $contents[] = array('text' => '<br />' . sprintf(TEXT_DELETE_WARNING_PRODUCTS, $cInfo->products_count));

    807. 

  807.     /*

    808. 

  808.     // future cat specific

    809. 

  809.     if ($cInfo->products_count > 0) {

    810. 

  810.     $contents[] = array('text' => '<br />' . TEXT_PRODUCTS_LINKED_INFO . '<br />' .

    811. 

  811.     zen_draw_radio_field('delete_linked', 'delete_linked_yes') . ' ' . TEXT_PRODUCTS_DELETE_LINKED_YES . '<br />' .

    812. 

  812.     zen_draw_radio_field('delete_linked', 'delete_linked_no', true) . ' ' . TEXT_PRODUCTS_DELETE_LINKED_NO);

    813. 

  813.     }

    814. 

  814.     */

    815. 

  815.     $contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    816. 

  816.     break;

    817. 

  817. 

    818. 

  818.     // bof: categories meta tags

    819. 

  819.     case 'edit_category_meta_tags':

    820. 

  820.     $heading[] = array('text' => '<strong>' . TEXT_INFO_HEADING_EDIT_CATEGORY_META_TAGS . '</strong>');

    821. 

  821. 

    822. 

  822.     $contents = array('form' => zen_draw_form('categories', FILENAME_CATEGORIES, 'action=update_category_meta_tags&cPath=' . $cPath, 'post', 'enctype="multipart/form-data"') . zen_draw_hidden_field('categories_id', $cInfo->categories_id));

    823. 

  823.     $contents[] = array('text' => TEXT_EDIT_CATEGORIES_META_TAGS_INTRO . ' - <strong>' . $cInfo->categories_id . ' ' . $cInfo->categories_name . '</strong>');

    824. 

  824. 

    825. 

  825.     $languages = zen_get_languages();

    826. 

  826. 

    827. 

  827.     $category_inputs_string_metatags_title = '';

    828. 

  828.     for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {

    829. 

  829.       $category_inputs_string_metatags_title .= '<br />' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['metatags_title']) . '&nbsp;' . zen_draw_input_field('metatags_title[' . $languages[$i]['id'] . ']', zen_get_category_metatags_title($cInfo->categories_id, $languages[$i]['id']), zen_set_field_length(TABLE_METATAGS_CATEGORIES_DESCRIPTION, 'metatags_title'));

    830. 

  830.     }

    831. 

  831.     $contents[] = array('text' => '<br />' . TEXT_EDIT_CATEGORIES_META_TAGS_TITLE . $category_inputs_string_metatags_title);

    832. 

  832. 

    833. 

  833.     $category_inputs_string_metatags_keywords = '';

    834. 

  834.     for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {

    835. 

  835.       $category_inputs_string_metatags_keywords .= '<br />' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['metatags_keywords']) . '&nbsp;' ;

    836. 

  836.       $category_inputs_string_metatags_keywords .= zen_draw_textarea_field('metatags_keywords[' . $languages[$i]['id'] . ']', 'soft', '100%', '20', zen_get_category_metatags_keywords($cInfo->categories_id, $languages[$i]['id']));

    837. 

  837.     }

    838. 

  838.     $contents[] = array('text' => '<br />' . TEXT_EDIT_CATEGORIES_META_TAGS_KEYWORDS . $category_inputs_string_metatags_keywords);

    839. 

  839. 

    840. 

  840.     $category_inputs_string_metatags_description = '';

    841. 

  841.     for ($i = 0, $n = sizeof($languages); $i < $n; $i++) {

    842. 

  842.       $category_inputs_string_metatags_description .= '<br />' . zen_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) . '&nbsp;' ;

    843. 

  843.       $category_inputs_string_metatags_description .= zen_draw_textarea_field('metatags_description[' . $languages[$i]['id'] . ']', 'soft', '100%', '20', zen_get_category_metatags_description($cInfo->categories_id, $languages[$i]['id']));

    844. 

  844.     }

    845. 

  845.     $contents[] = array('text' => '<br />' . TEXT_EDIT_CATEGORIES_META_TAGS_DESCRIPTION . $category_inputs_string_metatags_description);

    846. 

  846. 

    847. 

  847.     $contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_save.gif', IMAGE_SAVE) . ' <a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    848. 

  848.     break;

    849. 

  849.     // eof: categories meta tags

    850. 

  850. 

    851. 

  851.     case 'move_category':

    852. 

  852.     $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_MOVE_CATEGORY . '</b>');

    853. 

  853. 

    854. 

  854.     $contents = array('form' => zen_draw_form('categories', FILENAME_CATEGORIES, 'action=move_category_confirm&cPath=' . $cPath) . zen_draw_hidden_field('categories_id', $cInfo->categories_id));

    855. 

  855.     $contents[] = array('text' => sprintf(TEXT_MOVE_CATEGORIES_INTRO, $cInfo->categories_name));

    856. 

  856.     $contents[] = array('text' => '<br />' . sprintf(TEXT_MOVE, $cInfo->categories_name) . '<br />' . zen_draw_pull_down_menu('move_to_category_id', zen_get_category_tree(), $current_category_id));

    857. 

  857.     $contents[] = array('align' => 'center', 'text' => '<br />' . zen_image_submit('button_move.gif', IMAGE_MOVE) . ' <a href="' . zen_href_link(FILENAME_CATEGORIES, 'cPath=' . $cPath . '&cID=' . $cInfo->categories_id) . '">' . zen_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    858. 

  858.     break;

    859. 

  859.     case 'delete_product':

    860. 

  860.     $heading[] = array('text' => '<b>' . TEXT_INFO_HEADING_DELETE_PRODUCT . '</b>');

    861. 

  861. 

    862. 

  862.     $contents = array('form' => zen_draw_form('products', FILENAME_CATEGORIES, 'action=delete_product_confirm&cPath=' . $cPath . (isset($_GET['page']) ? '&page=' . $_GET['page'] : '')) . zen_draw_hidden_field('products_id', $pInfo->products_id));

    863. 

  863.     $contents[] = array('text' => TEXT_DELETE_PRODUCT_INTRO);

    864. 

  864.     $contents[] = array('text' => '<br /><b>' . $pInfo->products_name . ' ID#' . $pInfo->products_id . '</b>');

    865. 

  865. 

    866. 

  866.     $product_categories_string = '';

    867. 

  867.     $product_categories = zen_generate_category_path($pInfo->products_id, 'product');

    868. 

  868.     for ($i = 0, $n …
    869.

Large files files are truncated, but you can click here to view the full file