Jump to content

Farrukh

Members
  • Content count

    457
  • Joined

  • Last visited

Everything posted by Farrukh

  1. Remove product_ship_method It is a part of another mod
  2. Which version of Download Controller are you using. Download this version Download_Controllev5.3 MS 2.2 http://www.oscommerce.com/community/contributions,994
  3. It seems for the above SQK Query that 'products_head_title_tag' is missing 'pd.' in front of it. Run this SQL Command. ALTER TABLE products_description ADD products_head_title_tag VARCHAR(80) NULL; ALTER TABLE products_description ADD products_head_desc_tag LONGTEXT NULL; ALTER TABLE products_description ADD products_head_keywords_tag LONGTEXT NULL;
  4. When you add a Products, you will see Three (3) Blank Boxes. First one will be " Products Page Title: " Second will be " Page Header Description: " Third will be " Product Keywords: " These are the places where you have to enter the details
  5. You have to run the SQL File in phpmyadmin you have to add this command ALTER TABLE products ADD products_ship_price DECIMAL(15,4) NOT NULL;
  6. did you run INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Downloads Controller Update Status Value', 'DOWNLOADS_ORDERS_STATUS_UPDATED_VALUE', '4', 'What orders_status resets the Download days and Max Downloads - Default is 4', '13', '90', '2003-02-18 13:22:32', '', NULL , NULL); INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Downloads Controller Download on hold message', 'DOWNLOADS_CONTROLLER_ON_HOLD_MSG', '<BR><font color="FF0000">NOTE: Downloads are not available until payment has been confirmed</font>', 'Downloads Controller Download on hold message', '13', '91', '2003-02-18 13:22:32', '', NULL , NULL); INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` ) VALUES ('', 'Downloads Controller Order Status Value', 'DOWNLOADS_CONTROLLER_ORDERS_STATUS', '2', 'Downloads Controller Order Status Value - Default=2', '13', '92', '2003-02-18 13:22:32', '', NULL , NULL);
  7. Try now http://www.oscommerce.com/community/contributions,1333
  8. Farrukh

    [Contribution Update] All Prods v2.4

    Not a problem and you are welcome
  9. Fixed some minor bugs. Now it also supports Additional Shipping Prices per product. This adds the ability for each additional product after the first to have a lower or different shipping price. (By chuck) Download it here: http://www.oscommerce.com/community/contributions,1333
  10. Fixed some minor bugs. Now it also supports Additional Shipping Prices per product. This adds the ability for each additional product after the first to have a lower or different shipping price. (By chuck) Download it here: http://www.oscommerce.com/community/contributions,1333
  11. Farrukh

    All Products = Spider Food

    Azer, I dont have MS1 installed so i wont be able to update it for MS1
  12. Farrukh

    All Products = Spider Food

    I have updated the mod. It removes the c.categories_status Download it here: http://www.oscommerce.com/community/contributions,137
  13. Farrukh

    [Contribution Update] All Prods v2.4

    Updated the mod. Download it here: http://www.oscommerce.com/community/contributions,137
  14. Farrukh

    [Contribution Update] All Prods v2.4

    Bob You can remove the c.categories_status=1. I am using the Enable Disable Contribution and this is its part. So now the code will become select p.products_id, p.products_model ,pd.products_name, p.products_image, p.products_price, p.products_tax_class_id, p.products_date_added, m.manufacturers_name from products p , categories c, products_to_categories p2c left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join products_description pd on p.products_id = pd.products_id and pd.language_id = '1' left join specials s on p.products_id = s.products_id where p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by pd.products_name Ill update the contribution also
  15. Did you read the Readme file. You have to replace ' 16' with any number greater in your configuration. Just try out 700
  16. Farrukh

    NEW! Complete Order Editing Tool!

    Yes, there is Restore Order For Customer Change V3.00 search for it in thre contributions
  17. 06 August 2003 by: -C. R. (chuck@rynoweb.com) ----------------------------------------- ** Step 1 ** Backup your database, and all files to be modified. ** Step 2 ** Using PHPmyadmin, or however you like to do it, run this SQL command on your database: ALTER TABLE products ADD products_ship_price_two DECIMAL(15,4) NOT NULL; ** Step 3 ** -> Open catalog/includes/classes/shopping_cart.php -> find this from indv.ship install // mod indvship $this->shiptotal += ($products_ship_price * $qty); // end indvship -> replace with // mod indvship // first mod ok $this->shiptotal += ($products_ship_price * $qty); $this->shiptotal += ($products_ship_price); if ($qty > 1) { if ($products_ship_price_two > 0) { $this->shiptotal += ($products_ship_price_two * ($qty-1)); } else { $this->shiptotal += ($products_ship_price * ($qty-1)); } } // end indvship -> Find $products_ship_price = $product['products_ship_price']; -> Add after $products_ship_price_two = $product['products_ship_price_two']; -> Find // products price - indvship added products_ship_price $product_query = tep_db_query("select products_id, products_price, products_ship_price, products_tax_class_id, products_weight from " . TABLE_PRODUCTS . " where products_id='" . tep_get_prid($products_id) . "'"); -> Add products_ship_price_two to query (same one you previously added products_ship_price to) // products price - indvship added products_ship_price and products_ship_price_two $product_query = tep_db_query("select products_id, products_price, products_ship_price, products_ship_price_two, products_tax_class_id, products_weight from " . TABLE_PRODUCTS . " where products_id='" . tep_get_prid($products_id) . "'"); -> Save and close file ** Step 4 ** -> Open admin/categories.php -> Find $sql_data_array = array('products_quantity' => tep_db_prepare_input($HTTP_POST_VARS['products_quantity']), // mod indvship 'products_ship_price' => tep_db_prepare_input($HTTP_POST_VARS['products_ship_price']), //indvship 'products_model' => tep_db_prepare_input($HTTP_POST_VARS['products_model']), 'products_image' => (($HTTP_POST_VARS['products_image'] == 'none') ? '' : tep_db_prepare_input($HTTP_POST_VARS['products_image'])), 'products_price' => tep_db_prepare_input($HTTP_POST_VARS['products_price']), 'products_date_available' => $products_date_available, 'products_weight' => tep_db_prepare_input($HTTP_POST_VARS['products_weight']), 'products_status' => tep_db_prepare_input($HTTP_POST_VARS['products_status']), 'products_tax_class_id' => tep_db_prepare_input($HTTP_POST_VARS['products_tax_class_id']), 'manufacturers_id' => tep_db_prepare_input($HTTP_POST_VARS['manufacturers_id'])); Insert a new line UNDER the line with 'products_ship_price'. Copy the line below onto the new line. 'products_ship_price_two' => tep_db_prepare_input($HTTP_POST_VARS['products_ship_price_two']), //indvship2 -> Find $product_query = tep_db_query("select /*mod indvship*/ products_ship_price, products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . tep_db_input($products_id) . "'"); -> Change it to Add products_ship_price_two $product_query = tep_db_query("select /*mod indvship*/ products_ship_price, /*mod indvship2*/ products_ship_price_two, products_quantity, products_model, products_image, products_price, products_date_available, products_weight, products_tax_class_id, manufacturers_id from " . TABLE_PRODUCTS . " where products_id = '" . tep_db_input($products_id) . "'"); -> Find tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model, /*changes indvship*/ products_ship_price, products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('" . $product['products_quantity'] . "', '" . $product['products_model'] . "', /*changes indvship*/ '" . $product['products_ship_price'] . "', '" . $product['products_image'] . "', '" . $product['products_price'] . "', now(), '" . $product['products_date_available'] . "', '" . $product['products_weight'] . "', '0', '" . $product['products_tax_class_id'] . "', '" . $product['manufacturers_id'] . "')"); -> Change it to add products ship method (there are two changes). You do not want to just replace the line as it will interfere with any other mods you might have installed. tep_db_query("insert into " . TABLE_PRODUCTS . " (products_quantity, products_model, /*changes indvship*/ products_ship_price, /*changes indvship2*/ products_ship_price_two, products_image, products_price, products_date_added, products_date_available, products_weight, products_status, products_tax_class_id, manufacturers_id) values ('" . $product['products_quantity'] . "', '" . $product['products_model'] . "', /*changes indvship*/ '" . $product['products_ship_price'] . "', /*changes indvship2*/ '" . $product['products_ship_price_two'] . "' '" . $product['products_image'] . "', '" . $product['products_price'] . "', now(), '" . $product['products_date_available'] . "', '" . $product['products_weight'] . "', '0', '" . $product['products_tax_class_id'] . "', '" . $product['manufacturers_id'] . "')"); -> Find $product_query = tep_db_query("select /*changes indvship*/ p.products_ship_price, pd.products_name, pd.products_description, pd.products_url, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . $HTTP_GET_VARS['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "'"); -> Add p.products_ship_price_two to the query like this $product_query = tep_db_query("select /*changes indvship*/ p.products_ship_price, /*changes indvship2*/ p.products_ship_price_two, pd.products_name, (ect... rest of query here) -> Find <!-- mod indvship --> <tr> <td class="main"><?php echo 'Indv. Shipping Price:'; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_ship_price', $pInfo->products_ship_price); ?></td> </tr> <!-- end indvship --> -> Replace With <!-- mod indvship --> <tr> <td class="main"><?php echo 'Indv. Shipping Price:'; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_ship_price', $pInfo->products_ship_price); ?></td> </tr> <tr> <td class="main"><?php echo 'Each Additional Price:'; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('products_ship_price_two', $pInfo->products_ship_price_two); ?></td> </tr> <!-- end indvship --> -> Find $product_query = tep_db_query("select /*changes indvship*/ p.products_ship_price, p.products_id, pd.language_id, pd.products_name, pd.products_description, pd.products_url, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_weight, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = pd.products_id and p.products_id = '" . $HTTP_GET_VARS['pID'] . "'"); -> Add p.products_ship_price_two to the query like this $product_query = tep_db_query("select /*changes indvship*/ p.products_ship_price, /*changes indvship2*/ p.products_ship_price_two, p.products_id, pd.language_id, (ect.... rest of query goes here) -> Find $products_query = tep_db_query("select /*changes indvship*/ p.products_ship_price, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . $HTTP_GET_VARS['search'] . "%' order by pd.products_name"); } else { $products_query = tep_db_query("select /*changes indvship*/ p.products_ship_price, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . $current_category_id . "' order by pd.products_name"); } -> Add p.products_ship_price_two to BOTH queries using the same method as above $products_query = tep_db_query("select /*changes indvship*/ p.products_ship_price, /*changes indvship2*/ p.products_ship_price_two, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . $HTTP_GET_VARS['search'] . "%' order by pd.products_name"); } else { $products_query = tep_db_query("select /*changes indvship*/ p.products_ship_price, /*changes indvship2*/ p.products_ship_price_two, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . $languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . $current_category_id . "' order by pd.products_name"); } -> Save and close file
  18. Farrukh

    multi vendor shipping questions

    it does not run on MS 2.2
  19. Open indvship.php and find the following lines: // mod indvship // first mod ok $this->shiptotal += ($products_ship_price * $qty); $this->shiptotal += ($products_ship_price); if ($qty > 1) { $this->shiptotal += ($products_ship_price_two * ($qty-1)); } // end indvship and Change it to // mod indvship // first mod ok $this->shiptotal += ($products_ship_price * $qty); $this->shiptotal += ($products_ship_price); if ($qty > 1) { if ($products_ship_price_two > 0) { $this->shiptotal += ($products_ship_price_two * ($qty-1)); } else { $this->shiptotal += ($products_ship_price * ($qty-1)); } } // end indvship This has been posted by dm.Gremlin and Chuck
  20. Farrukh

    NEW! Complete Order Editing Tool!

    You only have to Store the file once in your Administrator. And this mod does not allow customers to edit their orders. Only the administrator can edit the orders. Add, Delete Products etc.
  21. Hi dmGremlin Can you just make a slight change in the display of individual Ship at the checkout page. For. ex. If I have set-up Zone Rates or any other shipping module, and if I want to only show the individual shipping of a product without displaying any other Shipping Modules. Can you integrate it into the mod. Just, Individual Shipping should be visible when its set, for a product. Your help is greatly appreciated
  22. Farrukh

    NEW! Complete Order Editing Tool!

    Austin519 Go to Administrator => Files Access => Customers (where ever you wish to put it under ) => Store Files (Its on the Right Side ) Simply specify the file, it would be order_edit or something like that. And you can grant access to the file under any Menu. Hope this helps
  23. Farrukh

    [contribution] "osC_GiftWrap_v1.0"

    Hi Just like to know when will you be updating the GIftWrap Mod for MS 2.2
  24. Farrukh

    NEW! Complete Order Editing Tool!

    The problem you are facing is due to the Admin Access Mod which you might have installed. You will have to give access to the account which you are using in Admin Access
×