Jump to content
Latest News: (loading..)

drferrari

Members
  • Content count

    49
  • Joined

  • Last visited

4 Followers

Profile Information

  • Real Name
    drferrari
  • Gender
    Male

Recent Profile Visitors

10,509 profile views
  1. RMA Returns error for 2.2 MS2

    if your table returns_products_data is to big more that 3000 columns, in file admin/returns.php the query: $orders_query_raw = "select o.returns_id, o.returns_status, o.customers_name, o.contact_user_name, o.rma_value, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.return_reason_name, op.final_price, o.returns_date_finished, rs.returns_status_name from " . TABLE_RETURNS . " o left join " . TABLE_RETURNS_PRODUCTS_DATA . " op on (o.returns_id = op.returns_id), " . TABLE_RETURN_REASONS . " s " . ", " . TABLE_RETURNS_STATUS . " rs where o.returns_reason = s.return_reason_id and s.language_id = '" . $languages_id . "' and o.returns_status = rs.returns_status_id order by o.returns_id DESC"; is too slow about 5-6s, insert to table returns_products_data INDEX (name: idx_returns_products_data_returns_id || column: returns_id || UNIQUE) and your query time goes to 0.100 - 0.1500s, it is very god improvment to you query.
  2. How to get full cat path?

    this maybe help: http://forums.oscommerce.com/topic/391546-full-categories-path-in-xml-file/#entry1662445
  3. xml feed how I display full category path

    look here: http://forums.oscommerce.com/topic/391546-full-categories-path-in-xml-file/#entry1662445
  4. Square meter contrib

    I found it "YEAHHHH", wait for my square meter contrib. thanks all chat friend for advises.
  5. Square meter contrib

    forgot the above posts, it is Lenght * width = square metere value Look at my my attach files. (and make it work on your oscommerce) 1) product_info-1.php page (FOR ADD FIRST PRODUCTS WITH LENGHT AND WIDTH)-> rename to product_info.php for your first add to cart 2) product_info-2.php page (FOR ADD SECOND PRODUCTS NO LENGHT AND WIDTH only quantity e.g. 10)-> rename to product_info.php for your second add to cart 3) shopping_cart.php 4) includes/application_top.php 5) square-meter5.txt rename to -> square-meter5.js 6) includes/classes/shopping_cart.php look at : function update_quantity($products_id, $lenghtValue, $widthValue, $quantity = '', $attributes = '') { if you have product A with LENGHT AND WIDTH and product B with NO LENGHT AND WIDTH in your shopping cart and try change quantity of the product B you can't, if you change the function to: function update_quantity($products_id, $quantity = '', $lenghtValue, $widthValue, $attributes = '') { you can change the quantity BUT you loose LENGHT and WIDTH of your product A ANY IDEA HOW CAN I FIT IT.
  6. Square meter contrib

    Thank you, chris I know your contrib, sorry but I wanna create my own. if you have any idea. in shopping_cart.php page I check tep_draw_checkbox_field('cart_delete[]', $products[$i]['id'])); this goto aplication_top.php case 'update_product' $cart->remove($HTTP_POST_VARS['products_id'][$i]); and then this goto include/classes/shopping_cart.php function remove WHY THIS NOT WORK???
  7. Square meter contrib

    I try create my own square meter contrib, I have stuck. in products_info.php page I create <input type="text" id="widthValue" name="widthValue" value="" size="5"/> x <input type="text" id="heightValue" name="heightValue" value="" size="5"/> this value is goto my shopping cart. in shopping_cart.php page if($products[$i]['widthValue'] !== ''){ $totalSquereMeter = $products[$i]['widthValue'] * $products[$i]['heightValue']; $info_box_contents[] = array('params' => 'class="productListing-data2"', 'text' => '<br/>WIDTH:'.$products[$i]['widthValue'].' x HEIGHT:'.$products[$i]['heightValue'].' = '.$totalSquereMeter); AND THIS is if products have width and height. I don't wanna show quantity if I have add product with WIDTH and HEIGHT. if($products[$i]['widthValue'] == ''){ echo"NO width and height"; $info_box_contents[$cur_row][] = array('align' => 'center', 'params' => 'class="productListing-data2" valign="top"', 'text' => tep_draw_input_field('cart_quantity[]', $products[$i]['quantity'], 'size="4"') . tep_draw_hidden_field('products_id[]', $products[$i]['id'])); }else{ echo"width and height"; $info_box_contents[$cur_row][] = array('align' => 'center', 'params' => 'class="productListing-data2" valign="top"', 'text' => $products[$i]['quantity']); } in file -> includes/aplication_top.php $cart->add_cart( $HTTP_POST_VARS['products_id'][$i], $HTTP_POST_VARS['cart_quantity'][$i], $HTTP_POST_VARS['widthValue'][$i], $HTTP_POST_VARS['heightValue'][$i], $attributes, false); the problem is when I add product to shopping cart with WIDTH and HEIGHT then I can't delete it. I try this 'text' => tep_draw_hidden_field('cart_quantity[]', $products[$i]['quantity'], 'size="4"') . tep_draw_hidden_field('products_id[]', $products[$i]['id'])); NOW I can delete all my products BUT this is WRONG if I have product A (with = 2 height =3) and product B (no width and height) AND if I change quantity of my second product this qantity value goes to my first product. any Idea for this.
  8. WinBank Piraeus Greece - Urgent

    αυτο ψάχνω και εγω μαλον το λαθος ειναι καπου εδω function before_process() { global $HTTP_POST_VARS; if ($HTTP_POST_VARS['valid']=='true') { echo "0.1---------------------------------------------------"; if ($remote_host = getenv('REMOTE_HOST')) { if ($remote_host != 'https://paycenter.piraeusbank.gr/services/tickets/issuer.asmx') { if ($remote_host != 'https://paycenter.piraeusbank.gr/services/tickets/issuer.asmx') { $remote_host = gethostbyaddr($remote_host); } if ($remote_host != 'https://paycenter.piraeusbank.gr/services/tickets/issuer.asmx') { tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'payment_error2=' . $this->code, 'SSL', false, false)); } } else { tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, 'payment_error3=' . $this->code, 'SSL', false, false)); } } } } οποιός ξερει ας δωσει ενα χεράκι. thanks
  9. [Contribution] oscThumb

    what do you mean fan4chevy upgrade.
  10. [Contribution] oscThumb

    I apologize, but I was forced to suspend the script "/home/-----/public_html/oscthumb.php" as it was causing a high load on the server, and due to the nature of the problem, I forced to take immediate action for the health of the server. Unfortunately I do not have any specific recommendations for this script, however, in general, adding some sort of caching mechanism, where the script does not need to generate a new page with every request, helps to lower the over load that a script will cause. Likely the original author or support group of the software that you are using will be able to help you to understand how to add something of this nature. did anybody have solution for this problem.
  11. when I choose one option from attributes (product_info page) I wanna change price with ajax. look for live example this select Product Options or Qty: and price will be change. pls help.
×