Jump to content

Zaitsev

Members
  • Content count

    6
  • Joined

  • Last visited

Profile Information

  • Real Name
    Vlad Zaitsev
  1. // //find about 10 lines below tep_db_query("delete from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "'"); } //INSERT BEFORE "}" return $ret; //so it's look like tep_db_query("delete from " . TABLE_ORDERS_TOTAL . " where orders_id = '" . (int)$order_id . "'"); return $ret; }
  2. in admin - catalog - "Attributes - Add values" when you edit "Products Attributes " and attribute is PIN checkbox displayed as not checked. some fix in query: #FILE /admin/products_attributes.php //find if (DOWNLOAD_ENABLED == 'true') { $download_query_raw ="select products_attributes_filename, ............ //INSERT after "select ^^^^^ products_attributes_is_pin, //so query looks as "select products_attributes_is_pin,products_attributes_filename, // ^^^^^^^^^^^^^^^^^^
  3. Thanks for module! Here some suggestions On order delete it's desirable to return PIN to stock if 'order status' < 'PIN Show status' i.e. not shown to customer, so PIN not compromised example #FILE /admin/orders.php //find tep_remove_order($oID, $HTTP_POST_VARS['restock']); //replace with //VUP vlzstart // tep_remove_order($oID, $HTTP_POST_VARS['restock']); $ret = tep_remove_order($oID, $HTTP_POST_VARS['restock']); if (tep_not_null($ret)){ $messageStack->add_session($ret, 'error'); } //VUP vlz end #FILE /admin/includes/functions/general.php //////// if you want to return PIN on delete even when 'Restock product quantity' IS NOT CHECKED then //find tep_db_query("delete from " . TABLE_ORDERS . " where orders_id = '" . (int)$order_id . "'"); //BEFORE add //VUP vlz + //return pins in pool if pin is not shown orders.orders_status <DOWNLOADS_AVAILABLE_STATUS $ret = ''; $sSQL = 'select orders_status from '.TABLE_ORDERS. " where orders_id = '" . (int)$order_id . "'"; $row = tep_db_fetch_array(tep_db_query($sSQL)); if ($row['orders_status'] < DOWNLOADS_CONTROLLER_ORDERS_STATUS){ tep_db_query('update '.TABLE_PRODUCTS_PINS. " set products_pin_used = '0' where products_pin_used = '" . (int)$order_id . "'"); }else{ $ret = 'PIN could not be returnet into PIN-pool - compromised'; } //VUP vlz - /////////// if you want to return PIN on delete ONLY when 'Restock product quantity' CHECKED then //find if ($restock == 'on') { //AFTER ADD //VUP vlz + //return pins in pool if pin is not shown orders.orders_status < DOWNLOADS_AVAILABLE_STATUS $ret = ''; $sSQL = 'select orders_status from '.TABLE_ORDERS. " where orders_id = '" . (int)$order_id . "'"; $row = tep_db_fetch_array(tep_db_query($sSQL)); if ($row['orders_status'] < DOWNLOADS_CONTROLLER_ORDERS_STATUS){ tep_db_query('update '.TABLE_PRODUCTS_PINS. " set products_pin_used = '0' where products_pin_used = '" . (int)$order_id . "'"); }else{ $ret = 'PIN could not be returnet into PIN-pool - compromised'; } //VUP vlz -
×