Jump to content

DS_Sultan

Members
  • Content count

    42
  • Joined

  • Last visited

1 Follower

About DS_Sultan

  • Birthday 10/29/1960

Profile Information

  1. DS_Sultan

    Bundled products

    You need to implement the above code that Monk provided. If you don't then the bundle update will never remove the existing bundle info, and if it does not do that then there will be a dupe entry every time. If you nered help just PM me.
  2. DS_Sultan

    Bundled products

    I have tried your code in place of mine and it works fine on my site. I think there must either be a part of the insstall you missed or another mod that is involved. Perhaps we need to go a bit deeper into your other files...
  3. DS_Sultan

    Bundled products

    Figures that my fix does not help everyone. My site is heavily mod'ed and I take carefull measures when applying another one. My site works perfectly with the exception of attributes, even existing items can become a bundle master. If they do not work for you, then it is likely you missed something during the install. The unexpected T_ELSEIF is ussually due to a missing bracket, so be sure you check your installation instructions and go thru each step in detail. If you need help you can PM me and I will see what I can do to help get this workin for you.
  4. DS_Sultan

    Bundled products

    Figures that my fix does no
  5. DS_Sultan

    Bundled products

    Figures that my fix does not help ev
  6. DS_Sultan

    Bundled products

    Sorry for the double post. Could not edit previous post. OK, I got this figured out for me at least. To get this error out of the way replace the following function in the product_info.php file. seach for: WHERE pb.bundle_id = " . tep_get_prid($products_id) . " and language_id = '" . (int)$languages_id . "'"); and replace with: WHERE pb.bundle_id = " . (int)$HTTP_GET_VARS['products_id'] . " and language_id = '" . (int)$languages_id . "'"); additionaly I implemented Monks code with a slight change, otherwise the tables never get updated correctly. A missing right bracket was the culprit as mentioned earlier in this thread. In admin/catagories.php Find this code... // update bundle contents if ($HTTP_POST_VARS['products_bundle'] = "yes") { tep_db_query("DELETE FROM products_bundles WHERE bundle_id = '" . $products_id . "'"); for ($i=0, $n=6; $i<$n; $i++) { if (isset($HTTP_POST_VARS['subproduct_' . $i . '_qty']) && $HTTP_POST_VARS['subproduct_' . $i . '_qty'] > 0) { tep_db_query("INSERT INTO products_bundles (bundle_id, subproduct_id, subproduct_qty) VALUES ('" . $products_id . "', '" . $HTTP_POST_VARS['subproduct_' . $i . '_id'] . "', '" . $HTTP_POST_VARS['subproduct_' . $i . '_qty'] . "')"); } } } and replace with this: // update bundle contents } if ($HTTP_POST_VARS['products_bundle'] == "yes") { // original was: if ($HTTP_POST_VARS['products_bundle'] = "yes") tep_db_query("DELETE FROM products_bundles WHERE bundle_id = " . $products_id . ""); for ($i=0; $i<6; $i++) { if (isset($HTTP_POST_VARS['subproduct_' . $i . '_qty']) && $HTTP_POST_VARS['subproduct_' . $i . '_qty'] > 0) { tep_db_query("INSERT INTO products_bundles (bundle_id, subproduct_id, subproduct_qty) VALUES (" . $products_id . ", " . $HTTP_POST_VARS['subproduct_' . $i . '_id'] . ", " . $HTTP_POST_VARS['subproduct_' . $i . '_qty'] . ")"); } } } //exit; ////END update bundle contents } elseif ($action == 'update_product') { $update_sql_data = array('products_last_modified' => 'now()'); $sql_data_array = array_merge($sql_data_array, $update_sql_data); tep_db_perform(TABLE_PRODUCTS, $sql_data_array, 'update', "products_id = '" . (int)$products_id . "'"); //delete categories saved in the tables tep_db_query("delete from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '". $products_id . "'"); // update bundle contents if ($HTTP_POST_VARS['products_bundle'] == "yes") { // original was: if ($HTTP_POST_VARS['products_bundle'] = "yes") tep_db_query("DELETE FROM products_bundles WHERE bundle_id = " . $products_id . ""); for ($i=0; $i<6; $i++) { if (isset($HTTP_POST_VARS['subproduct_' . $i . '_qty']) && $HTTP_POST_VARS['subproduct_' . $i . '_qty'] > 0) { tep_db_query("INSERT INTO products_bundles (bundle_id, subproduct_id, subproduct_qty) VALUES (" . $products_id . ", " . $HTTP_POST_VARS['subproduct_' . $i . '_id'] . ", " . $HTTP_POST_VARS['subproduct_' . $i . '_qty'] . ")"); } } } ////END update bundle contents This fixed this issue for me. I hope it helps you too! Feel free to contact me if you need help with this.
  7. DS_Sultan

    Bundled products

    OK, I got this figured out for me at least. To get this error out of the way replace the following function in the product_info.php file. seach for: WHERE pb.bundle_id = " . tep_get_prid($products_id) . " and language_id = '" . (int)$languages_id . "'"); and replace with: WHERE pb.bundle_id = " . (int)$HTTP_GET_VARS['products_id'] . " and language_id = '" . (int)$languages_id . "'"); This fixed this issue for me. I hope it helps you too!
  8. DS_Sultan

    Bundled products

    Hello world, I have been working on this issue and have at least found out what is not working. For the above error messages that we all seem to be getting on the query as follows: SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price FROM products p INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id =and language_id = '1' THere is a call in the product_info.php file as follows: <!-- start bundle --> <?php if ($product_info['products_bundle'] == "yes") { $products_bundle = $product_info['products_bundle']; echo "This product contains the following items: "; $bundle_query = tep_db_query(" SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price FROM products p INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id = " . tep_get_prid($products_id) . " and language_id = '" . (int)$languages_id . "'"); This is the query producing the acatual error. The issue is this, the function in the WHERE statement at the end is NOT returning the proper bundle ID. In fact, it does not reurn the ID at all as evidenced by the following in the above error. SELECT pd.products_name, pb.*, p.products_bundle, p.products_id, p.products_price FROM products p INNER JOIN products_description pd ON p.products_id=pd.products_id INNER JOIN products_bundles pb ON pb.subproduct_id=pd.products_id WHERE pb.bundle_id =and language_id = '1' Note that the language_id has a value of '1', but the bundle_id has no returned value at all. WHERE pb.bundle_id = it is this missing return from the function tep_get_prid($product_id) I have proven this by taking this function out and replacing it with an actual value of a known bundle, then it works fine. I have also had to implement the code from 'Monk' posted Sep 9, 2004 to even get my system to write the bundle to the database. This may be related but I have NOT yet figgered that one out. This post is just an update of where I am now, I will indeed keep working on this to figure out why this function is not returning a value, once I do I believe that this mod will work for me. With the exception of the attributes issue I have yet to tackle. I will keep this thread updated if I find anything new on this mod. If anyone else can look into this specific function it would be helpfull. Please feel free to contact me with any questions.
  9. DS_Sultan

    RMA Returns error for 2.2 MS2

    Also, GD. You state that you have this working, but then in the contributions area you post that it is NOT working and do not use it... So which is correct?
  10. DS_Sultan

    RMA Returns error for 2.2 MS2

    So does your fix make this system usable? I am looking for just such a package and was hoping this one would work. If not, pleases be sure to post when your package is available. I look forward to your contribution.
  11. DS_Sultan

    family 3.0 problems

    To remove items is not impossible. It just take a little MySQL knowhow. You can manually go into the table Product_Family and remove the items you do not want in the family anymore. But you are likely to hose things up if you are not carefull so this is not something for the timid. If you have an understanding of MySQL in the least is should be something that can be done with great ease. As with any contribution, this one is a good one. But before you muck with your database tables. BACKUP BACKUP BACKUP!
  12. DS_Sultan

    NEW! Complete Order Editing Tool!

    Any chance of getting the code you have shown in your image here that gives those status flags? Also including the javascript for the comments would be an excellent thing to get a hold of. And what mod are you running that gives you a specific tracking number field? Great work.
  13. Just a note on this mod. Very usefull and working great! Added a few extra things along the way as well like many of you. I did however have one thing happen (which still does happen but it is so minor it was not worth investigating any further) when running on an SSL connection. Has anyone had the Create Order make the screen go real funky?? I did, and the fix was to change the HTTPS = 'on' to 'off' in both the Creat_Account.php and the Create_Order.php files. It does not affect the proccessing and the sstem still stys on my SSL cert. Additionally, the minor issue mentioned above has to do with the border and background color for the column_left.php file. It's like it's not using the stylesheet, but I know it is. So like I said it aint no big thang! Just thought I'd mention it. Good work to all who took part in this mod. Wonderfull thing this net of ours!
  14. Just a note on this mod. Very usefull and working great! Added a few extra things along the way as well like ma
  15. Just a note on this mod. Very usefull and working great! Added a few extra things along the way as well like ma
×