Jump to content

Rusyn

Members
  • Content count

    133
  • Joined

  • Last visited

Everything posted by Rusyn

  1. Rusyn

    [Contrib] Shipping zoneworld

    For some reason the "The shipping rate cannot be determined at this time" message is not being displayed for countries not within any of my zones. I have 4 zones, plus one empty one for unlisted countries to default to, but this usually just ends up being $0 instead of the message. Any help would be appreciated.
  2. Rusyn

    2checkout issue

    Which contrib is that?
  3. Rusyn

    2 CHECKOUT ERROR PARAMETER WITH OSCOMMERCE

    I think I may be having the same problem as well. Where in osC is the routine for 2CO? For users of the new version 2 this routine has to be changed to https://www2.2checkout.com/2co/buyer/purchase
  4. Rusyn

    Using simple credit card module

    Okay, I am having some problems with gateways and I was wondering if the following is possible: Just install the credit card module, then run each credit card when the order comes in by hand. You see, we have expensive products and don't sell loads each month so it isn't much more work to run the card numbers once the email arrives. Plus we usually contact each customer anyways since there are a million customization options. I am just wondering if anyone can tell me if there are downsides to this. Cheers
  5. Hmmmm.... Some of the pulldowns for some attributes seem to be ordered alphabetically (as per my post above), others by ID in descending order (ie the first one I enter ends up as the first option) and others in ascending order (the first one I enter ends up as the last option). How do I know when an attribute sorts by name, id asc or desc? I thought they would all be the same? Are there other places in the code that determine this and I have a conflict?
  6. Strange.... about the options, it looks like they are set up to be in alphabetical order, but they are coming up using the ID I think. I use numbers (1-, 2-, etc) to order the options in the pulldown, but they aren't lining up correct. Can anyone see where I am making a mistake in the code: from product_listing.php //clr 030714 update query to pull option_type $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name, popt.products_options_type, popt.products_options_length, popt.products_options_comment from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)$languages_id . "' order by popt.products_options_name"); while ($products_options_name = tep_db_fetch_array($products_options_name_query)) { //clr 030714 add case statement to check option type switch ($products_options_name['products_options_type']) { case PRODUCTS_OPTIONS_TYPE_TEXT: //CLR 030714 Add logic for text option $products_attribs_query = tep_db_query("select distinct patrib.options_values_price, patrib.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = '" . $products_options_name['products_options_id'] . "'"); $products_attribs_array = tep_db_fetch_array($products_attribs_query); $tmp_html = '<input type="text" name ="id[' . TEXT_PREFIX . $products_options_name['products_options_id'] . ']" size="' . $products_options_name['products_options_length'] .'" maxlength="' . $products_options_name['products_options_length'] . '" value="' . $cart->contents[$HTTP_GET_VARS['products_id']]['attributes_values'][$products_options_name['products_options_id']] .'"> ' . $products_options_name['products_options_comment']; if ($products_attribs_array['options_values_price'] != '0') { $tmp_html .= '(' . $products_attribs_array['price_prefix'] . $currencies->display_price($products_attribs_array['options_values_price'], $product_info_values['products_tax_class_id']) .')'; } ?> <tr> <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td> <td class="main"><?php echo $tmp_html; ?></td> </tr> <?php break; case PRODUCTS_OPTIONS_TYPE_RADIO: //CLR 030714 Add logic for radio buttons $tmp_html = '<table>'; $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, 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 = '" . $products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . $languages_id . "'"); $checked = true; while ($products_options_array = tep_db_fetch_array($products_options_query)) { $tmp_html .= '<tr><td class="main">'; $tmp_html .= tep_draw_radio_field('id[' . $products_options_name['products_options_id'] . ']', $products_options_array['products_options_values_id'], $checked); $checked = false; $tmp_html .= $products_options_array['products_options_values_name']; $tmp_html .=$products_options_name['products_options_comment']; if ($products_options_array['options_values_price'] != '0') { $tmp_html .= '(' . $products_options_array['price_prefix'] . $currencies->display_price($products_options_array['options_values_price'], $product_info_values['products_tax_class_id']) .') '; } $tmp_html .= '</tr></td>'; } $tmp_html .= '</table>'; ?> <tr> <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td> <td class="main"><?php echo $tmp_html; ?></td> </tr> <?php break; case PRODUCTS_OPTIONS_TYPE_CHECKBOX: //CLR 030714 Add logic for checkboxes $products_attribs_query = tep_db_query("select distinct patrib.options_values_id, patrib.options_values_price, patrib.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)$HTTP_GET_VARS['products_id'] . "' and patrib.options_id = '" . $products_options_name['products_options_id'] . "'"); $products_attribs_array = tep_db_fetch_array($products_attribs_query); echo '<tr><td class="main">' . $products_options_name['products_options_name'] . ': </td><td class="main">'; echo tep_draw_checkbox_field('id[' . $products_options_name['products_options_id'] . ']', $products_attribs_array['options_values_id']); echo $products_options_name['products_options_comment']; if ($products_attribs_array['options_values_price'] != '0') { echo '(' . $products_attribs_array['price_prefix'] . $currencies->display_price($products_attribs_array['options_values_price'], $product_info_values['products_tax_class_id']) .') '; } echo '</td></tr>'; break; // iii 030813 added: support for file fields case PRODUCTS_OPTIONS_TYPE_FILE: $number_of_uploads++; $products_attribs_query = tep_db_query("select distinct patrib.options_values_price, patrib.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " patrib where patrib.products_id='" . (int)tep_db_input($HTTP_GET_VARS['products_id']) . "' and patrib.options_id = '" . $products_options_name['products_options_id'] . "'"); $products_attribs_array = tep_db_fetch_array($products_attribs_query); ?> <tr> <td class="main"><?php echo $products_options_name['products_options_name'] . ' (' . $products_attribs_array['price_prefix'] . $currencies->display_price($products_attribs_array['options_values_price'], $product_info_values['products_tax_class_id']) . ') '; ?></td> <td class="main"><input type="file" name="id[<?php echo TEXT_PREFIX . $products_options_name['products_options_id']; ?>]"><br><?php echo $cart->contents[$HTTP_GET_VARS['products_id']]['attributes_values'][$products_options_name['products_options_id']] . tep_draw_hidden_field(UPLOAD_PREFIX . $number_of_uploads, $products_options_name['products_options_id']) . tep_draw_hidden_field(TEXT_PREFIX . UPLOAD_PREFIX . $number_of_uploads, $cart->contents[$HTTP_GET_VARS['products_id']]['attributes_values'][$products_options_name['products_options_id']]); ?></td> </tr> <?php break; default: //clr 030714 default is select list //clr 030714 reset selected_attribute variable $selected_attribute = false; $products_options_array = array(); $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, 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 . "'"); while ($products_options = tep_db_fetch_array($products_options_query)) { $products_options_array[] = array('id' => $products_options['products_options_values_id'], 'text' => $products_options['products_options_values_name']); if ($products_options['options_values_price'] != '0') { $products_options_array[sizeof($products_options_array)-1]['text'] .= ' (' . $products_options['price_prefix'] . $currencies->display_price($products_options['options_values_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) .') '; } } if (isset($cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']])) { $selected_attribute = $cart->contents[$HTTP_GET_VARS['products_id']]['attributes'][$products_options_name['products_options_id']]; } else { $selected_attribute = false; } ?> <tr> <td class="main"><?php echo $products_options_name['products_options_name'] . ':'; ?></td> <td class="main"><?php echo tep_draw_pull_down_menu('id[' . $products_options_name['products_options_id'] . ']', $products_options_array, $selected_attribute) . $products_options_name['products_options_comment']; ?></td> </tr> <?php } //clr 030714 end switch } //clr 030714 end while ?>
  7. Rusyn

    Something like "free shipping"

    What I am looking for is something like free shipping, but different. Instead of shipping price dependant on the total cost, I would like to make the total cost dependant on the products in the cart. For example, the cart would check each product against the database to find what category it belongs to. If you have one product from three particular categories, then you get them cheaper. Say you have the following categories: Shirts (cPath=1), Pants (cPath=2), Shoes (cPath=3). If you buy 2 shirts and some pants you pay normal price, if you buy 1 shirt, 1 pants, and 1 shoes you get a discounted price because you bought a "set." To make it more sophisticated say you have to buy EQUAL numbers of each of the three categories. So 3 shirts, 3 pants, 3 shoes in your cart would give you 3 sets, but 3 shirts, 2 pants, 3 shoes would only give you 2 sets plus a shirt and shoes. I am sure this is doable, I just don't have the SQL/PHP skills to do it. Anyone know of something out there like this? Or someone want to tackle this? R
  8. How do I set it up so that the international shipping options disappear when the customer is a domestic? I am getting: Best way XXXX Shipping to Canada: 5.5 kg(s) XXXX When only the "best way" should change.
  9. Rusyn

    Master Products - MS2

    I read through all 92 pages a few times over the past couple of days and am suffereing some serious PTSD. ;) I am wondering if anyone has figured out how to hack MP to be able to give the Master a "price" that would be equal to the cheapest slave. Something like "From $XXXX". Obviously the problem with this includes keeping the Master "Select Quantity" drop down from appearing, and not allowing the Master to be purchased. Has anyone ever done this? Also, and I think I may have seen this somewhere or I could be imagining things, how do attributes on the master work? I am not talking about each of the slaves having attributes, I mean a general attrib that applies to all the slaves. To use the t-shirt example, say you have 5 slaves in different sizes/colors, and you offer "pre-washing" for an extra 5 bucks. So would you be able to put a "Pre Wash" checkbox on the master, and have it apply to any slaves bought if it is checked? Cheerio, R
  10. Rusyn

    Master Products - MS2

    I tried fiddling with the $master_sql .= " order by pd.products_name"; (a tip from Matti on page 53) but to no avail. Has something changed since way back on page 53? I tried p.products_model and p.products_price... neither seem to have any effect. And here is a shot of my quantity select problem: FYI, the Master price and quantity are set to zero. In which file is the tep_draw for the quantity select dropdown? There must be something wrong in there...
  11. Rusyn

    Master Products - MS2

    Oh yeah, and how does one alter the SORT ORDER of the slaves?
  12. Rusyn

    Master Products - MS2

    In Admin->Slave Products which column do I have to activate to make the dropdown menus appear alongside the slave products? I think something may be wrong here...
  13. I just installed Define Mainpage. What a GREAT contrib!! Unfortunately, when I edit the example text in the Admin, I hit save and check my store only to see this: Parse error: parse error in /home/user/public_html/catalog/includes/languages/english/define_mainpage.php on line 27 The offending line: 27 BE AWARE that changes (and possible errors/typo's) are That is the commented out copy that was in the template. It doesn't look like this thing is writing properly... I set the catalog/includes/languages/english/defin?mainpage.php to 777 like the instructions said... and after writing the file is definitely different than the original. I am just getting this parse error. Any clue as to what's happening?
  14. Great!! For others with the same problem, check out Brian's solution. It worked beautifully. R
  15. Hello, What am I doing wrong? Everything else is fine except my product_info pages which are all screwed up. Take a look. I don't want to bother with the product_info templates because I have too many contribs (Ultra pics, Master Prods etc) that will probably not be outputted. Anyone see what is wrong?
  16. !!Great!! Yeah something like that, but less complicated. I wouldn't need any selections being made in the popup, nor would I need an image (although I could make one). So can you do the same sorta thing with just text??? In the admin would I just put something like: java script:popupWindow('http://www.mysite.com/page.html') Will OTF be able to handle that?
  17. Hi all, Does anyone know if you can make comment text a link to a popup window? I would like to make comment text to the right of a text field that triggers a small popup that gvies example of the different kinds of things one might want to put in the text box. Can I do this with Option Type Feature?
  18. Does anyone know a contrib that allows one to add a link after an options/attributes drop down menu? The link could be used to explain the difference between the options in the dropdown menu. It would be great if the link was automagically added when an option was added to a product. Anyone ever seen this?
  19. Rusyn

    Japanese Prefecures???

    I tried to use this contrib, but to no avail. http://www.oscommerce.com/community/contributions,199/page,2 Does anyone know where I can get an updated version of it? Or, if anyone is using World Zones, are the Japanese zones in kanji? http://www.oscommerce.com/community/contri...ons,1792/page,3 Thx, R
  20. Rusyn

    Japanese Prefecures???

    Thanks for the pricelist. That'll come in handy. But isn't there a osC contrib that installs the prefectures?
  21. If anyone out there has Article Manager runing with STS can you please post the AM-related code from your sts_user_code.php? I can't seem to get it to display...
  22. I recently reinstalled Ultrapics on a clean MS2.2 and have come upon a problem. Using an FTP program I deleted the default folders in the catalog/images/ and tried to use the UltraPix interface to create a test folder and add a pic for an existing product. Unfortunately the interface still seems to think all the default folders are still there... Is this an SQL problem? How do I make UP read from the directory again (ie "refresh")? Cheerio, R PS, my images folder is set to 777
  23. I solved the folder question... just switched to IE ;) Unfortunately it looks like the fields aren't writing to the database... There must be a conflict between Master Prods and Ultra Images somewhere... I am going through it again now the best I can, but my PHP skills are pretty weak. Can anyone point me in the right direction? I posted it here so as not to make a huge long page here in the forums: /admin/categories.php
  24. Hello all, Everything seems to run okay, EXCEPT ;): I am having no problems uploading from the Admin page in all of the fields of the Admin section. When I check the /images/ folder everything is there no prob, and the images show up in the Admin preview, but only the default thumbnail and the popu-up show up on the actual product page! I have looked over the product_info files but can't find any differences... Also, is there a way to upload the image files into certain folders? I mean put product_A in folder /images/A/ Thirdly, for the people with Master Products: These are the iles that BOTH Master Prods and Ultrapics manipulate: /index.php (define mainpage. 1 line no problem) /product_info.php (3 changes...) /includes/filenames.php (no problem) /admin/categories.php (problematic) /admin/includes/languages/english/categories.php (no problem) I think everyone is having problems with categories.php... You have to tread carefully with this one as there are multiple tep_database_queries, and Master Prods adds two extra ones I think. Cheers, R
  25. Rusyn

    42 Bands required

    Before I have to install each and every one, can someone tell me a shipping module that does weight, price, and zones and can account for 42 "bands"? Weight Cost 1 1 2 2 3 3 The above has 3 bands. I need 42. Anyone?
×