Jump to content

bhbilbao

Members
  • Content count

    308
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by bhbilbao

  1. bhbilbao

    Multi_Vendor_Shipping new thread

    I dont know why dispear. these codes: account_history_info.php for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { if ($order->products[$i]['model'] == "Custom"){ echo ' <tr>' . "\n" . ' <td class="main" align="right" valign="top" width="30">' . $order->products[$i]['qty'] . 'x</td>' . "\n" . ' <td class="main" valign="top">' . $order->products[$i]['name'] . '<small><i>' . $order->products[$i]['description'] . '</small></i>'; }else{ echo ' <tr>' . ' <td class="main" align="right" valign="top" width="30">' . $order->products[$i]['qty'] . 'x</td>' . "\n" . ' <td class="main" valign="top">' . $order->products[$i]['name']; } if ( (isset($order->products[$i]['attributes'])) && (sizeof($order->products[$i]['attributes']) > 0) ) { for ($j=0, $n2=sizeof($order->products[$i]['attributes']); $j<$n2; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value'] . '</i></small></nobr>'; } } admin/orders.php <?php for ($i=0, $n=sizeof($order->products); $i<$n; $i++) { if ($order->products[$i]['model'] == "Custom"){ echo ' <tr class="dataTableRow">' . ' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . 'x</td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['name'] . '<small><i>' . $order->products[$i]['description'] . '</small></i>'; $custom_computer="1"; }else{ echo ' <tr class="dataTableRow">' . ' <td class="dataTableContent" valign="top" align="right">' . $order->products[$i]['qty'] . 'x</td>' . "\n" . ' <td class="dataTableContent" valign="top">' . $order->products[$i]['name']; } if (isset($order->products[$i]['attributes']) && (sizeof($order->products[$i]['attributes']) > 0)) { for ($j = 0, $k = sizeof($order->products[$i]['attributes']); $j < $k; $j++) { echo '<br><nobr><small> <i> - ' . $order->products[$i]['attributes'][$j]['option'] . ': ' . $order->products[$i]['attributes'][$j]['value']; if ($order->products[$i]['attributes'][$j]['price'] != '0') echo ' (' . $order->products[$i]['attributes'][$j]['prefix'] . $currencies->format($order->products[$i]['attributes'][$j]['price'] * $order->products[$i]['qty'], true, $order->info['currency'], $order->info['currency_value']) . ')'; echo '</i></small></nobr>'; } } Contrib installed: Custom Computer Creator (this works because the options are a description) Custom Product Builder Quick atributes Ajax Atribute Manager Attribute Sorter and Copier v.6 Attribute Sort with Attribute Clone The atributes are working well. Also when a customer receives the confirmation email all atributes are right. Looking in the database orders_products_attributes in the orders_products_id all files are with number 0. ¿?
  2. bhbilbao

    Bundled Products

    Modified for more lines and diferent order. The contrib works fine. <?php ?> <div id="bundled_subproducts"> <? for ($i=0, $n = $bundle_count ? $bundle_count+1:6; $i<$n; $i++) { echo "\n" . '<input type="text" size="3" name="subproduct_' . $i . '_qty" value="' . $bundle_array[$i]['qty'] . '">'; echo "\n" . '<input type="text" size="70" name="subproduct_' . $i . '_name" value="' . $bundle_array[$i]['name'] . '">'; echo "\n" . '<input type="text" size="6" name="subproduct_' . $i . '_id" value="' . $bundle_array[$i]['id'] . '">'; echo "\n" . '<a href="javascript:clearSubproduct(' . $i . ')">[x]</a><br>'; } ?> </div> <? echo tep_draw_hidden_field('bundled_subproducts_i', $i,'id="bundled_subproducts_i"'); echo 'Product : <select name="subproduct_selector" onChange="fillCodes()">'; echo '<option name="null" value="" SELECTED></option>'; $products = tep_db_query("select pd.products_name, p.products_id, p.products_model from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "' and p.products_id <> '" . $HTTP_GET_VARS['pID'] . "' order by pd.products_name"); // byMODEL $products = tep_db_query("select pd.products_name, p.products_id, p.products_model from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where pd.products_id = p.products_id and pd.language_id = '" . $languages_id . "' and p.products_id <> '" . $HTTP_GET_VARS['pID'] . "' order by p.products_model"); while($products_values = tep_db_fetch_array($products)) { echo "\n" . '<option name="' . $products_values['products_id'] . '" value="' . $products_values['products_id'] . '">' . $products_values['products_id'] . ' - - - ' . $products_values['products_name'] . " (" . $products_values['products_model'] . ')</option>'; // byID echo "\n" . '<option name="' . $products_values['products_id'] . '" value="' . $products_values['products_id'] . '">' . $products_values['products_id'] . ' - - - ' . $products_values['products_name'] . " (" . $products_values['products_model'] . ')</option>'; // byMODEL echo "\n" . '<option name="' . $products_values['products_id'] . '" value="' . $products_values['products_id'] . '">' . $products_values['products_id'] . ' - - - ' . $products_values['products_name'] . " (" . $products_values['products_model'] . ')</option>'; } echo '</select>'; ?> </td> </tr> </table> </td> </tr> <!-- EOF Bundled Products --> In other hand I think there is a bug. If anyone can try this. 1. create a bundle of 3 products. 2. then in admin/atributes asign 2 or 3 options to it. 3. In the shop front end. Buy it. It goes to the basket. 4. Then go to shoping cart (shoping_cart.php) 5. Click on the bundled product. 6. The error:
  3. I have diferent atributes contribs. Ajax atributes manager - Working Quick Atributes - Working Attribute Sorter and Copier v.6.0.2 - Semi-working I need to copy all atributes from one product to other. This can be make with Ajax Atributes adding SETS but i need to enter and edit the product = more time. The problem is diferent column names. For default I have 1 more column named "attribute_sort" ref: ALTER TABLE products_attributes ADD products_options_sort_order int(6) NOT NULL default '0' AFTER price_prefix; ALTER TABLE products_options_values_to_products_options ADD products_options_values_sort_order int(6) NOT NULL default '0' AFTER products_options_values_id; ALTER TABLE products_attributes ADD attribute_sort int(6) NOT NULL default '0' AFTER products_options_sort_order; In catalog/admin product list. When duplicating a product + atribute (atribute clone) it gets an error: I know that this was also comented but i dont find a solution to this and where to modify categories.php archive. All fixes I found where to add only one column, products_options_sort_order or attribute_sort Also ther is a function that I need (Copy atributes from one product to varios products) but is comented: // WebMakers.com Added: Copy Attributes Existing Product to All Existing Products in a Category ... // echo 'Copy from products_id# ' . $make_copy_from_products_id . ' Copy to all products in category: ' . $cID . '<br>'; Help.
  4. bhbilbao

    QUICK ATRIBUTES

    When changing any atribute it gets an error: Cannot modify header information already send .... The error is on genela.php line 27: header('Location: ' . $url); general.php i tried: // header('Location: ' . $url); header('Location:'.$_GET['URL']); changed in php.ini: output_buffering = on output_buffering = 4096 also: $mosConfig_locale_debug = 0; $mosConfig_locale_use_gettext = 0; Also looked for white spaces before and after <?php
  5. bhbilbao

    [Contribution] Pollbooth v2.0

    Sorry for the last post. Working with the last fix. I downloaded only the full version. :blush:
  6. bhbilbao

    [Contribution] Pollbooth v2.0

    Warning: mysql_insert_id(): supplied argument is not a valid MySQL-Link resource in /htdocs/admin/includes/functions/database.php on line 117 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 ' 'TEST', 0, 0, '3')' at line 1 insert into phesis_poll_data (pollid,optiontext,optioncount,voteid, language_id) values (, 'TEST', 0, 0, '3') [TEP STOP]
  7. bhbilbao

    Wishlist 3.0 Support Thread

    Working. But when a customer receives the Whislist link , it appears as text link. Not html link. ¿how it should modify to appears as the "View detail order" link of the orders??
  8. Im using the contribution width 3 diferent languages(english, espanol, german). I want if anyone knows to use the same field for all languages without changing the names. For example, i have like this in categories.php Garantia: 2 Warranty: 2 Garantie: 2 All times I need to edit a product i must fill al field. = more stupid work. I want something like this(a define in includes/languages/*/product_info.php): . TEXT_WARRANTY . : 2 For the moment, the only one method to do this, is adding Garantia/Warranty/Garantie as field, and select it for all-languages in the box. If anybody kwnows how to modify or some type of tricky. Thanks.
  9. Thanks FOD. Also worked for me. A point for you.
  10. Need help with that contribution. Im trying to integrate "products date available" for upcoming products. Works in all pages except in product_listing.php I have this after the weight case: case 'PRODUCT_LIST_AVAILABLE': $lc_align = 'center'; if (tep_not_null($listing[$x]['products_date_available'])) { $lc_text = ' ' . tep_date_short($listing[$x]['products_date_available']) . ' '; } else { $lc_text = ' ' . 'Y'; } break; and then: $product_text .= ' <td width="100" height="1" class="infoBoxContents" align="center" valign="middle">' . $product_contents['products_date_available'] . '</td>'; Help.
  11. bhbilbao

    Multi_Vendor_Shipping new thread

    it is not my job to provide it for you. I dont say you "must" provide to us. Im grateful wich you for your time Jim. I sugested, as you are working on this contribution, you could add new features in a future like the ones I descrived before. 1. Stock feature of MVS. Its incredible but now works (orders_by_vendor.php). I modified something and now its working. In the order, the link also works but doesnt update. ref: "Email send to vendor: No." 2. Not part of MVS. There is a PDF addon, but it will need to be modified to work with MVS. ok. I will try to modify it soon. 3. What? I don't understand this. In checkout_shipping.php a form to select the main shop (ref:INSERT INTO `vendors` VALUES (1, 'Store Owner', 'My Store') and skip the others. And then in checkout_confirmation.php if this condition is tru, not to send any email to the vendors. 4. Where? What page? The product attributes (products_attributes.php) dont appear in orders.php or edit_orders.php after a customer finishes the order.
  12. bhbilbao

    Simply Hide Products (SHP)

    ok, i will find for it tomorrow. Thanks for your moment Prounx. Im thinking that the problem could be "Custom Computer Creator" or "Custom Product Builder". These contributions creates "extrange virtual" products in catalog.
  13. bhbilbao

    Multi_Vendor_Shipping new thread

    Yeah, that seems to me. Because replacing the code was the same. Need to fix: 1. A button to send to the vendor a copy of the order (only with the products assigned to it and after a customer makes the payment). 2. PDF invoice for admin. Doesnt work. All items white (empty). 3. A form to send all items from only one Shop with a unique price. 4. The atributions and options dont appear after the order. Please Jim, work hard!!! :D
  14. bhbilbao

    Simply Hide Products (SHP)

    Also the index.php archive. I look this: // the following cPath references come from application_top.php $category_depth = 'top'; if (isset($cPath) && tep_not_null($cPath)) { $categories_products_query = tep_db_query("select count(*) as total from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$current_category_id . "'"); $cateqories_products = tep_db_fetch_array($categories_products_query); if ($cateqories_products['total'] > 0) { $category_depth = 'products'; // display products } else { $category_parent_query = tep_db_query("select count(*) as total from " . TABLE_CATEGORIES . " where parent_id = '" . (int)$current_category_id . "'"); $category_parent = tep_db_fetch_array($category_parent_query); if ($category_parent['total'] > 0) { $category_depth = 'nested'; // navigate through the categories } else { $category_depth = 'products'; // category has no products, but display the 'no products' message } } } application_top.php // custom product builder add to cart from builder_info page case 'add_build' : if (isset($HTTP_POST_VARS['products_id']) && is_numeric($HTTP_POST_VARS['products_id'])) { if ($_POST['uncloaked_build'] == '0') { tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '1' where products_id = '" . $_POST['products_id'] . "' and products_quantity > '" . $cart->get_quantity(tep_get_uprid($_POST['products_id'],$_POST['id'])) . "'"); } $cart->add_cart($HTTP_POST_VARS['products_id'], $cart->get_quantity(tep_get_uprid($HTTP_POST_VARS['products_id'], $HTTP_POST_VARS['id']))+1, $HTTP_POST_VARS['id']); if ($_POST['disable_build'] == '1' or $_POST['uncloaked_build'] =='0') { tep_db_query("update " . TABLE_PRODUCTS . " set products_status = '0' where products_id = '" . $_POST['products_id'] . "'"); } } tep_redirect(tep_href_link($goto, tep_get_all_get_params($parameters))); break; // add category names or the manufacturer name to the breadcrumb trail if (isset($cPath_array)) { for ($i=0, $n=sizeof($cPath_array); $i<$n; $i++) { $categories_query = tep_db_query("select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$cPath_array[$i] . "' and language_id = '" . (int)$languages_id . "'"); if (tep_db_num_rows($categories_query) > 0) { $categories = tep_db_fetch_array($categories_query); $breadcrumb->add($categories['categories_name'], tep_href_link(FILENAME_DEFAULT, 'cPath=' . implode('_', array_slice($cPath_array, 0, ($i+1))))); } else { break; } } } elseif (isset($HTTP_GET_VARS['manufacturers_id'])) { $manufacturers_query = tep_db_query("select manufacturers_name from " . TABLE_MANUFACTURERS . " where manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'"); if (tep_db_num_rows($manufacturers_query)) { $manufacturers = tep_db_fetch_array($manufacturers_query); $breadcrumb->add($manufacturers['manufacturers_name'], tep_href_link(FILENAME_DEFAULT, 'manufacturers_id=' . $HTTP_GET_VARS['manufacturers_id'])); } } // add the products model to the breadcrumb trail if (isset($HTTP_GET_VARS['products_id'])) { $model_query = tep_db_query("select products_model from " . TABLE_PRODUCTS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); if (tep_db_num_rows($model_query)) { $model = tep_db_fetch_array($model_query); $breadcrumb->add($model['products_model'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id'])); } } cache.php //! Cache the categories box // Cache the categories box function tep_cache_categories_box($auto_expire = false, $refresh = false) { global $cPath, $language, $languages_id, $tree, $cPath_array, $categories_string; $cache_output = ''; if (($refresh == true) || !read_cache($cache_output, 'categories_box-' . $language . '.cache' . $cPath, $auto_expire)) { ob_start(); include(DIR_WS_BOXES . 'categories.php'); $cache_output = ob_get_contents(); ob_end_clean(); write_cache($cache_output, 'categories_box-' . $language . '.cache' . $cPath); } return $cache_output; } The 1064 error says ".....describe categories status where categories_id not in(924, 240,...." Loking the database tables there is any column named as "category_status" or "status"
  15. bhbilbao

    Simply Hide Products (SHP)

    This could be dificult for me. I have 142contributions installed and in any moment this going to blow up. When I install a new contrib other 2 or 3 begins to fault. Im a semi-coder not programer. Where do you thing the querie error are?? On what archive??? application_top.php cache.php database.php split_page_results.php
  16. In checkout_payment.php i need to apply diferent coupon boxes. On top a Distributor Code, for special clients (some like SPPC). And bottom the Discount Coupon box code. I have tried it and only one works for the form. Im thinking on duplicate the ot_discount_coupon.php to ot_discount_coupon2.php and edit it as new one for using both. Can anyone help me how to do it??
  17. bhbilbao

    Ajax Buy Now

    product_info.php <td width="220" align="right" valign="middle" class="infoBoxContents"> <?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?> </td> includes/functions/general.php // Redirect to another page or site function tep_redirect($url) { // AJAX Addto shopping_cart - Begin global $HTTP_GET_VARS, $PHP_SELF, $_RESULT; if ( strpos( basename($PHP_SELF), 'ajax_shopping_cart.php')!==FALSE ) { if ( $url == tep_href_link(FILENAME_SSL_CHECK) || $url == tep_href_link(FILENAME_LOGIN) || $url == tep_href_link(FILENAME_COOKIE_USAGE) || ( $HTTP_GET_VARS['action'] === 'buy_now' && tep_has_product_attributes($HTTP_GET_VARS['products_id']) ) ) { $_RESULT['ajax_redirect'] = $url; tep_exit(); } return; } // AJAX Addto shopping_cart - End In includes/ ajax_sc.js and ajax_sc.js1 In column_right.php // AJAX Addto shopping_cart - Begin ?> <tr> <td style="padding: 0"> <script language="JavaScript" src="includes/ajax_sc.js"></script> <div id="divShoppingCard"><table border="0" width="100%" cellspacing="0" cellpadding="2"><?php require(DIR_WS_BOXES . 'shopping_cart.php'); ?> </table></div> </td> </tr> <?php // AJAX Addto shopping_cart - End Born to serve.
  18. bhbilbao

    Ajax Buy Now

    I have this contribution installed by disabled. (Idle) My product_listing.php code for this contrib: line231: // AJAX Addto shopping_cart - Begin $lc_text['button_buy_now'] = '<a href="' . tep_href_link(basename($_SERVER['PHP_SELF']), tep_get_all_get_params(array('action','sort','products_id')) . 'action=buy_now&products_id=' . $listing[$x]['products_id']) . '">' . tep_image(DIR_WS_IMAGES . 'loading.gif', '', '', '', 'align="absmiddle" id="loading_' . $listing['products_id'] . '" style="visibility: hidden;"') . tep_image_button('add_buy.gif', IMAGE_BUTTON_BUY_NOW, 'style="padding-bottom: 5px;"') . '</a>'; // AJAX Addto shopping_cart - End
  19. bhbilbao

    Simply Hide Products (SHP)

    You said from includes/application_top.php???? or other file???
  20. bhbilbao

    [Contribution] oscThumb

    Same problem wih me, othertime its transformed with a grey background if transparent. Try to change Use Zoom Crop to True. My config: oscThumb Master Switch On Process Store's Graphics False Encrypt Image Filenames True Filename Encryption Key blackhole bilbao Output GIFs as JPEGs False 'GIF as JPEG' Matte colour (HEX) FFFFFF Thumbnail Cache directory phpThumb/cache/ Use Zoom Crop? True My problem is when diferent product have the same image asigned. When listing products images with various contributions phpthumb takes the first image queried and cached it. But the second image appears in the same size. For example I want the product_image with big size , and down optional products with small size. Does anybody kwons how to fix this????
  21. bhbilbao

    Daily Specials

    Its better to use a Banner Manager contribution and create a new group "Daily especials". And then place the condicion "if banner" in the header. Baners can be defined to determined date start-end.
  22. bhbilbao

    Multi_Vendor_Shipping new thread

    New question, there is a contribution named: Vendor_Auto_E-mail (In_Development) http://addons.oscommerce.com/info/2196 What is the purpouse of this???. I need to send an e-mail to an specific vendor "after a cusotmer has purchased and you have received payment confirmation from your payment processor". A button to send a copy/confirmation of the products to ship. Like this contribution Order confirmation email text http://addons.oscommerce.com/info/3115 but sending it to vendor with the especific products asigned to it.
  23. Need help with product_listing.php ref my code: // if (tep_not_null($listing[$x]['specials_new_products_price'])) { // $lc_text['products_price'] = '<s>' . $currencies->display_price($listing[$x]['products_price'], tep_get_tax_rate($listing[$x]['products_tax_class_id'])) . '</s> <span class="productSpecialPrice"><blink>' . $currencies->display_price($listing[$x]['specials_new_products_price'], tep_get_tax_rate($listing[$x]['products_tax_class_id'])) . '</blink></span>'; // } else { // $lc_text['products_price'] = ' ' . $currencies->display_price($listing[$x]['products_price'], tep_get_tax_rate($listing[$x]['products_tax_class_id'])) . ' '; // } changed to: = REPLACE THE ABOVE WITH ================================================= ========================================================================== if (tep_get_products_special_price($listing['products_id'])) { $lc_text = ' <s>' . $currencies->display_price($listing['products_price'], tep_get_tax_rate($listing['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price(tep_get_products_special_price($listing['products_id']), tep_get_tax_rate($listing['products_tax_class_id'])) . '</span> '; ========================================================================== = END REPLACE ============================================================ also changed to: case 'PRODUCT_LIST_PRICE': $lc_align = 'right'; if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>'; } else { $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); } break; Doesn´t work. Help.
  24. bhbilbao

    Coupons by Ingo

    More problems: Percent Discount dont seen to work. 10% Discount is always = 10€ I tried as 0.10 0,10 10% 10 /1.10 is a bug????
  25. bhbilbao

    Coupons by Ingo

    New problems in admin/coupons.php: 2006 - MySQL server has gone away select count(*) as total from sessions where sesskey = '540x31f9f1c2c5dc33f7a11d594f774a' [TEP STOP] The the coupon can be edited right. ¿?
×