Jump to content

Farrukh

Members
  • Content count

    457
  • Joined

  • Last visited

Posts posted by Farrukh


  1. Help! Having a problem with IndividualShip-v3.0.  

    Followed all installation, twice now and i'm gettin the same error each time at the top of the Catagories section in Admin.  

    ----------------------------------------------------------------------  

    1054 - Unknown column 'p.products_ship_price' in 'field list'

     

    select 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 products p, products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name  

     

    [TEP STOP]

     

    You did not run the SQL File

     

     

     

    -------------------------------------------------------------------------  

    Maybe i'm missing something obvious but i'm quite new at this. Anyone having the same problem.  

     

    Russ Clarke


  2. Thanks for taking the time to modify the contribution for me. Seriously, I wasn't expecting such incredible service. The open source community continues to amaze me.

     

    With that said, I'm getting the following error when I try and run the new version of allprods (the one with manufacturers but not model numbers):

     

    1054 - Unknown column 'c.categories_status' in 'where clause'

     

    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 c.categories_status=1 and p.products_id = p2c.products_id and c.categories_id = p2c.categories_id and products_status = '1' order by p.products_date_added DESC, pd.products_name

     

    [TEP STOP]

     

     

    Any help is appreciated.

     

    Thanks again,

     

    Bob

     

    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


  3. i just installed it, but now my catalog is not working and the sql file is wrong... i keep getting
    Fehler 
    
    SQL-Befehl: 
    
    
    
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('','<B>Down for Maintenance: ON/OFF</B>', 'DOWN_FOR_MAINTENANCE', 'false', 'Down for Maintenance <br>(true=on false=off)', '16', '1', 'tep_cfg_select_option(array('true', 'false'), ', now(), NULL);
    
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('','Down for Maintenance: filename', 'DOWN_FOR_MAINTENANCE_FILENAME', 'down_for_maintenance.php', 'Down for Maintenance filename Default=down_for_maintenance.php', '16', '2', '', now(), NULL);
    
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('','Down for Maintenance: Hide Header', 'DOWN_FOR_MAINTENANCE_HEADER_OFF', 'false', 'Down for Maintenance: Hide Header <br>(true=hide false=show)', '16', '3', 'tep_cfg_select_option(array('true', 'false'), ', now(), NULL);
    
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('','Down for Maintenance: Hide Column Left', 'DOWN_FOR_MAINTENANCE_COLUMN_LEFT_OFF', 'false', 'Down for Maintenance: Hide Column Left <br>(true=hide false=show)', '16', '4', 'tep_cfg_select_option(array('true', 'false'), ', now(), NULL);
    
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('','Down for Maintenance: Hide Column Right', 'DOWN_FOR_MAINTENANCE_COLUMN_RIGHT_OFF', 'false', 'Down for Maintenance: Hide Column Right <br>(true=hide false=show)r', '16', '5', 'tep_cfg_select_option(array('true', 'false'), ', now(), NULL);
    
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('','Down for Maintenance: Hide Footer', 'DOWN_FOR_MAINTENANCE_FOOTER_OFF', 'false', 'Down for Maintenance: Hide Footer <br>(true=hide false=show)', '16', '6', 'tep_cfg_select_option(array('true', 'false'), ', now(), NULL);
    
    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added, use_function) VALUES ('','Down for Maintenance: Hide Prices', 'DOWN_FOR_MAINTENANCE_PRICES_OFF', 'false', 'Down for Maintenance: Hide Prices <br>(true=hide false=show)', '16', '7', 'tep_cfg_select_option(array('true', 'false'), ', now(), 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 ('', 'Down For Maintenance (exclude this IP-Address)', 'EXCLUDE_ADMIN_IP_FOR_MAINTENANCE', 'your IP (ADMIN)', 'This IP Address is able to access the website while it is Down For Maintenance (like webmaster)', 16, 8, '2003-03-21 13:43:22', '2003-03-21 21:20:07', 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 ('', 'NOTIFY PUBLIC Before going Down for Maintenance: ON/OFF', 'WARN_BEFORE_DOWN_FOR_MAINTENANCE', 'false', 'Give a WARNING some time before you put your website Down for Maintenance<br>(true=on false=off)<br>If you set the 'Down For Maintenance: ON/OFF' to true this will automaticly be updated to false', 16, 9, '2003-03-21 13:08:25', '2003-03-21 11:42:47', NULL, 'tep_cfg_select_option(array('true', 'false'),')
    
    MySQL meldet: You have an error in your SQL syntax near '; INSERT INTO configuration (configuration_id, configuration_title, configurati' at line 1

     

    the problem is i aint got a clou of sql and cant find what is wrong !!!

    anybody help please !!!

     

    Regards John

     

    Did you read the Readme file. You have to replace ' 16' with any number greater in your configuration.

     

    Just try out 700


  4. Farrukh:

    Ah I see. Okay in that case...just curious...is there a mod out there that allows customers to change their orders while the order is still in a certain stage?

     

    Austin519

     

    Yes, there is

     

    Restore Order For Customer Change V3.00

     

    Allows the admin/customer delete or modify and cancel an order that hasnt reached a set status.

    The order then gets placed in the customers basket for them to change and resubmit or deleted.

     

    search for it in thre contributions


  5. 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


  6. 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

     

    By Ryno Chuck == This mod adds to the table in the product page so that you can not only add the individual shipping cost, but add the each additional shipping cost as well..

    NOTE* - If you have a shipping rate in the indv. shipping field and its the same shipping no matter how many they buy.. You have to put the same amount in for each additional as well - else everything after one will default to 0 or whatever is in that 'each additional' field.


  7. Farrukh:

    Okay, very helpful! Works perfectly now. Maybe I just don't understand this mod. What exactly is in the administrator section for editing things like that? I assumed I could edit everything, but I had to add the edit_order file. Does that now mean that customers can edit their own orders to or...what? Either way, thanks a lot!

     

    Austin519

     

    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.


  8. Hi

     

    I have just updated the Individual Product Shipping Prices v1.0 by dm.gremlin for Milestone 2.2

     

    I have added all the necessary files.

     

    Added Feature:

     

    If the Individual Shipping Prices is enabled and the price set in the Admin => Categories => Products

     

    At checkout_shipping.pho page, only Individual Shipping Module will be visible and available. And if the Individual Price is not set for a product. You will get other Shipping Modules which you might be running besides Individual Shipping Mod.

     

     

    Download here:

    http://www.oscommerce.com/community/contributions,1333


  9. 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


  10. Farrukh:

    Okay...I upgraded to the new 2.2 admin or whatnot...and I seem to have full access (top adminstrator, all write privileges) but I still can't edit the orders...what do you suggest?

     

    Austin519

     

    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


  11. Okay this is a retarded question I know...but I am trying to check out the edit order features. When looking at a customer's order, he wants to add items to his order (he used m.o)...it gives this error:

     

    Please contact your Web Administrator to request

    more access or if you found any problem.

     

    I'm running my own server and logged in to the admin panel...what's up?

     

    Also...as someone else asked earlier...how can I add an order manually? Anyone? Thanks.

     

    Austin519

     

     

    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


  12. farruck could u tell me wich of the both contrib 2.4 and all in one 2.5 are also compatible with MS1 version ? by the way on my ian load 5 version it doesnt work at all ....

     

    Azer, i regret to tell you that I havent tested the All-Prods v 2.5 All in One on Loaded 5.

     

    But what you can do is to install a previous version than 2.4.

     

    Install v2.3 on Loaded 5 and it will work with it. I have done it before and it works fine. As far as MS1 is concerned , the update I have done for the compatibility for MS 2.2. only.

×