Jump to content

maxemus

Members
  • Content count

    106
  • Joined

  • Last visited

Everything posted by maxemus

  1. I have a suggestion here. after really messing up my DB. I now realize something and have a question. Why is easy populate connected to the modifiable model when the Product_ID would be unique and automatic so it could not over lap other products.
  2. maxemus

    Alphabetical Search - [support]

    in order for this to isolate Filter the categories to display only the selected letter make the following changes. change: <!-- Alphabetical Search - begin //--> <td class="main" align="left"><table> <b> <?php $lstr = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; for( $i = 0; $i < strlen($lstr); $i++ ) { $l = substr( $lstr, $i, 1); echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'alpha=' . $l ) . '"><u>' . $l . '</u></a> '; } ?> </b><br style="line-height:10px;"> <?php echo tep_draw_form('advanced_search', tep_href_link(FILENAME_ADVANCED_SEARCH_RESULT, '', 'NONSSL', false), 'get'); echo ' ' . tep_draw_hidden_field('search_in_description','1') . tep_draw_hidden_field('inc_subcat', '1', true) . tep_draw_input_field('keywords', 'Enter Search...', ' onfocus="this.value=\'\'" size="10" maxlength="30" style="width:410px"'); ?> <tr> <td style="width:116px;"> <?php echo tep_draw_pull_down_menu('categories_id', tep_get_categories(array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES)))) . tep_hide_session_id(); ?></td> <td valign="bottom" align="right"><?php echo tep_image_submit('button_search.gif', IMAGE_BUTTON_SEARCH) . tep_draw_separator('pixel_trans.gif', '10', '10'); ?></td> </tr> </form></table> <br style="line-height:6px;"> </td> <!-- Alphabetical Search - end //--> to <!-- Alphabetical Search - begin //--> <td class="main" align="left"><table> <b> <?php $lstr = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"; for( $i = 0; $i < strlen($lstr); $i++ ) { $l = substr( $lstr, $i, 1); echo '<a href="' . tep_href_link(FILENAME_DEFAULT, 'alpha=' . $l ) . '"><u>' . $l . '</u></a> '; } if (tep_session_is_registered('last_cat')); if (tep_not_null($current_category_id)){ tep_session_register('last_cat'); $last_cat = $current_category_id; } ?> </b><br style="line-height:10px;"> <?php echo tep_draw_form('advanced_search', tep_href_link(FILENAME_ADVANCED_SEARCH_RESULT, '', 'NONSSL', false), 'get'); echo ' ' . tep_draw_hidden_field('search_in_description','1') . tep_draw_hidden_field('inc_subcat', '1', true) . tep_draw_input_field('keywords', 'Enter Search...', ' onfocus="this.value=\'\'" size="10" maxlength="30" style="width:410px"'); ?> <tr> <td style="width:116px;"> <?php echo tep_draw_pull_down_menu('categories_id', tep_get_categories(array(array('id' => '', 'text' => TEXT_ALL_CATEGORIES)))) . tep_hide_session_id(); ?></td> <td valign="bottom" align="right"><?php echo tep_image_submit('button_search.gif', IMAGE_BUTTON_SEARCH) . tep_draw_separator('pixel_trans.gif', '10', '10'); ?></td> </tr> </form></table> <br style="line-height:6px;"> </td> <!-- Alphabetical Search - end //--> change // Alphabetical Search - begin if (isset($_GET['alpha'])) { $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.products_name like '" . $_GET['alpha'] . "%' and pd.language_id = '" . (int)$languages_id . "'"; // show the products in a given categorie } elseif(isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) { // Alphabetical Search - end // We are asked to show only specific catgeory to if (isset($_GET['alpha'])) { $listing_sql = "select " . $select_column_list . " p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.products_name like '" . $_GET['alpha'] . "%' and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '" . (int)$_SESSION['last_cat'] ."'"; // show the products in a given category } elseif(isset($HTTP_GET_VARS['filter_id']) && tep_not_null($HTTP_GET_VARS['filter_id'])) {
  3. maxemus

    One Page Checkout Support

    I have an Idea how about taking out the KGT and other mods out of the main code and put in instructions on how to put them back in if the person has or wants those mods. I think it might be better for all.
  4. Hi people. Is there an updated install Doc out there found - 0 tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING_ADDRESS, '', 'SSL')); and tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT_ADDRESS, '', 'SSL')); found 2 tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL')); found 0 in checkout_confirmation.php tep_redirect(tep_href_link(FILENAME_CHECKOUT_PAYMENT, '', 'SSL')); Would like a single page checkout
  5. I just have a question. is the product number suppose to be in the URL like this /vanity-license-plates-fantasy-and-horror-dragon-license-plate-p-1332.html http://cosmoscrystal.com/graphics/vanity-license-plates-fantasy-and-horror-dragon-license-plate-p-1332.html
  6. maxemus

    One Page Checkout Support

    Hey still having problems with paypal standard notifying me or the customer. It seems to be changing the status to the wrong status.
  7. maxemus

    Attribute Sets Plus

    OOps kinda didn't get enough sleep. Most defiantly you need Options as Images contrib for this to work.
  8. maxemus

    Attribute Sets Plus

    Oh yeah forgot to say this will sort your Attributes as you mark them in the Attribute Sets screen.. wow this hurt my head making this up
  9. maxemus

    Attribute Sets Plus

    Ok here it is. I don't know how this will react if you don't have options as images installed. you just might have to take out pov.products_options_values_thumbnail, but not sure Have any of you wanted to have the sort order actually work. well here is the fix. one stipulation this script is for options as images along with attribute sets contrib installed together. so if you have both installed this should work for you. Make sure you back up so you can go back if this don't work for you. Replace in catalog/options_images.php -----find------ $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pov.products_options_values_thumbnail, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pov.products_options_values_name asc"); -----Replace with------ $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pov.products_options_values_thumbnail, pa.options_values_price, pa.price_prefix, pase.sort_order from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS . " pase where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' and pase.options_values_id = pa.options_values_id order by pase.sort_order asc");
  10. maxemus

    Options as images

    Have any of you wanted to have the sort order actually work. well here is the fix. one stipulation this script is for options as images along with attribute sets contrib installed together. so if you have both installed this should work for you. Make sure you back up so you can go back if this don't work for you. Replace in catalog/options_images.php -----find------ $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pov.products_options_values_thumbnail, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pov.products_options_values_name asc"); -----Replace with------ $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pov.products_options_values_thumbnail, pa.options_values_price, pa.price_prefix, pase.sort_order from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov, " . TABLE_PRODUCTS_ATTRIBUTES_SETS_ELEMENTS . " pase where pa.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' and pase.options_values_id = pa.options_values_id order by pase.sort_order asc"); Hope this helps a lot. Donations would be great when I get that sort of things up and running
  11. Hello Did you get Alphabetical Search to be isolated to current category. If so How did you do it exactly?

    thankyou

  12. maxemus

    One Page Checkout Support

    Might be a nice thing to do. Since everyone's stores look and act different. PHP is designed to be Modular.
  13. maxemus

    One Page Checkout Support

    The problem is I don't have the Credit Class & Gift Voucher contrib installed just commented out the code
  14. maxemus

    One Page Checkout Support

    Hi Happy new year Looks like I have 2 errors now 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where customer_id = '344'' at line 1 select amount from where customer_id = '344' this is a great conrtib thanks for making it
  15. maxemus

    One Page Checkout Support

    Ok I get an error 1146 - Table 'mydb_osc1.TABLE_COUPON_GV_CUSTOMER' doesn't exist select amount from TABLE_COUPON_GV_CUSTOMER where customer_id = '344 If I use the new includes/checkout/payment_method.php I have the new KGT installed haven't tested it yet I figure it is this line $gv_query = tep_db_query("select amount from " . TABLE_COUPON_GV_CUSTOMER . " where customer_id = '" . $customer_id . "'") where is TABLE_COUPON_GV_CUSTOMER supposed to be defined?
  16. maxemus

    One Page Checkout Support

    Hi I am useing 1.09 and haveing problems with the pay pal thing other wise no problem. So I updated to the 1.1 and now haveing the KTG coupon sql error. How to take out the KTG support?
  17. maxemus

    free shipping by categories support thread

    Did you ever get the other shipping methods to hide? I'm in need of the same
  18. Hi great contrib. The Update works fantastic. I do need one thing. I am using Alphabetical Search and I am trying to isolate the searches to a category. I almost have it down. Ultimate Seo is kinda standing in my way. would it be possible to have seo move ?Alpha=A or any ?Alpha=Z to the end after .html
  19. maxemus

    Browse by Categories

    Hi I got this working Kinda. I have a Modified store in production. I have tried this on a new test store and works lust fine. So I figure it is what ever mods I have going. Ok here is what is happening the primary category is showing the picture but not the text. Yes I do have the text and picture enabled in the admin. It shows the text on the sub-categories. and on that topic it only shows the first sub-categories not the 2nd sub-categories. any Ideas where I should be looking?
  20. Ok sorry about the craby session. thnakyou everyone who has debugged and improved this contrib. I did have 2 small problems with the classic images werent showing up with if (tep_not_null($product_info['products_image']) && MOPICS_GROUP_WITH_PARENT == 'false') I took out && MOPICS_GROUP_WITH_PARENT == 'false'. I guess turning it into true would have worked too. also I have a modified store and had a problem with the placement of some code after a } somewhere I can't remember where it was it was very late. seems like this contrip has gotten pretty complex. kinda was shooting for simple and easy when I first sat down to make it. again thanks to all who worked on it it looks great.
  21. maxemus

    Attribute Sets Plus

    Hello I have been using this contrib since early this year it works great. I would like to use the sort order function. Mine don't seem to work. It is going by price then alphabetical. Thanks for making it it has saved Lots of time.
  22. Ant the first time someone has laid clame to my work and didn't even give me any credit
  23. Hello This is Raphael Muscarelle. I'm about to use this contribute. I haven't seen how it works yet. I'm glad my work progressed in other peoples hands. I'm kinda wondering who are these people that have attached a clam to it Copyright © 1989, 1991 Free Software Foundation, Inc. I never worked for them If they want to employ me maybe they should contact me.
  24. maxemus

    Alphabetical Search - [support]

    Hello I am wondering if you came up with the ability to do this For example, rather than all products starting with "A", how can i search all products starting with "A" in category "electronics"?
×