Jump to content


  • Content count

  • Joined

  • Last visited

1 Follower

Profile Information

  • Real Name
  1. fubu

    NEW! Complete Order Editing Tool!

    Hi, I'm using OSC MS1, with the randomised order number. I installed it following the instructions and changed the (int)$oID to $oID. Still I'm getting the following error: 1054 - Unknown column 'KW3101044' in 'field list' insert into orders_products set orders_id = KW3101044, products_id = 193, products_model = 'WAG311', products_name = 'Netgear 802.11g 108Mbps Triband PCI Card WAG311', products_price = '163.6364', final_price = '163.6364', products_tax = '10', products_quantity = 1; [TEP STOP] Also if I try to amend an order to add another product, after I choose the category in the first drop down box, the second drop down box has a number of blank lines before I see a few products displayed down the bottom. Please help!
  2. Hi, Just want to let you know that the posts u made earlier this thread doesn't work when I tried implementing it with the latest version of all categories mod. This is the code I have in the file before the modification. Please take a look: // 1.2 Test for presence of status field for compatibility with older versions $status = tep_db_num_rows(tep_db_query('describe categories status')); $query = "select c.categories_id, cd.categories_name, c.parent_id from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = cd.categories_id"; // 1.3 Can't have 'where' in an if statement! if ($status >0) $query.= " and c.status = '1'"; $query.= " and cd.language_id='" . $languages_id ."' order by sort_order, cd.categories_name"; $categories_query = tep_db_query($query); If anyone have further suggestions please let me know!
  3. Hi, I've just tried your suggestions above. I'm not getting any errors, so I'm probably getting closer. However it's still giving out free shipping for orders over 10kg. Any further suggestions? :cry:
  4. I'm poor with PHP and have been trying to modify free shipping to purchases above 50 dollars but at the same time I only want to give free shipping to orders under 10kg. I think this is the file that needs to be modified (htdocscatalogincludesmodulesorder_totalot_shipping.php) around line 44: if ( ($pass == true) && ( ($order->info['total'] - $order->info['shipping_cost']) >= MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER) ) { $order->info['shipping_method'] = $this->title; $order->info['total'] -= $order->info['shipping_cost']; $order->info['shipping_cost'] = 0; I've added a condition to the if statement to the following: if ( ($pass == true) && ($total_weight<'10') && ( ($order->info['total'] - $order->info['shipping_cost']) >= MODULE_ORDER_TOTAL_SHIPPING_FREE_SHIPPING_OVER) ) { $order->info['shipping_method'] = $this->title; $order->info['total'] -= $order->info['shipping_cost']; $order->info['shipping_cost'] = 0; and I've declared $total_weight = $cart->show_weight(); above it. I think it's just a matter of checking the weight of the cart in this bit, but my php is pretty poor, so please help!!!!
  5. fubu

    Aust post 1.7.1 problems

    I'm testing this on localhost which have internet access. When I stick the problem URL (http://drc.edeliver.com.au/ratecalc.asp?Pickup_Postcode=2000&Destination_Postcode=2136&Country=US&Weight=3300&Service_Type=Air&Height=100&Width=100&Length=100&Quantity=1) reported into the web browser, I get the following: charge=60 days=10 err_msg=OK so it should work but somehow isn't.
  6. Hi, I've installed Aust post 1.7.1. I'm getting warnings up the top of the page, could someone please help? Thanks in advance! Warning: file(http://drc.edeliver.com.au/ratecalc.asp?Pickup_Postcode=2000&Destination_Postcode=2136&Country=US&Weight=3300&Service_Type=Air&Height=100&Width=100&Length=100&Quantity=1) [function.file]: failed to create stream: HTTP request failed! ??!?t? in C:Program FilesAbyss Web Serverhtdocscatalogincludesmodulesshippingauspostair.php on line 67 Warning: Invalid argument supplied for foreach() in C:Program FilesAbyss Web Serverhtdocscatalogincludesmodulesshippingauspostair.php on line 68
  7. I've installed the latest development version of osc, and also version 2n0123 of qty_display_allow mod. I've followed the instructions and I've done it around 10 times over but still can't get it to work. I find that there are a lot of bells and whistles which I don't have and I'm confused with which sections I need to paste over. Does anyone have just the qty_display_allow mod with the base installation? Any help would be greatly appreciated!