Jump to content

Toorqs

Members
  • Content count

    27
  • Joined

  • Last visited

Profile Information

  • Real Name
    Magnus Akselsen
  1. I went over the install, but still the same. I assume the error must be in the product_info.php? I had an error after i installed it with the text not showing at all, and it turned out i removed the "php echo stripslashes" in the process. Is anything missing from that part of the following code? <div class="main"><div class="desc2"><?php echo stripslashes($product_info['products_description']); ?></div><br> <?php } ?>
  2. Im having some issues with IE (both 7 and 8 i think) The text in the product description starts on top of the pictures, not further down the page like in every other browser i tested. I dont know if this is related to this addon, but it wasn't like that before. demo
  3. Toorqs

    "Dynamenu" for osCommerce

    I have both the dynamenu and the enable/disable categories installed. However im not able to hide categories shown in the dynamenu. Is there any way to make this work? There is 1 category in which i keep files used with the custom product builder i cant have shown to the public.
  4. Toorqs

    ### POINTS AND REWARDS MODULE V1.00 ###

    ok, the above errors are fixed. Another one has come up. Whenever i try to checkout, using any number of alloved points, the sum gets way to small. A 10.000$ item will list as 7$.. i could swear i saw someone else with the same problem, but i cant seem to find it now.
  5. Toorqs

    Custom Product Builder

    Could i trouble you for a bit more spesific instructions? im not to good with this stuff yet.. I did find more info on expando and know how to set it up, but i dont know which of the builder files to actually modify.
  6. Toorqs

    ### POINTS AND REWARDS MODULE V1.00 ###

    Turns out it wasn't solved aferall, i think those 2 errors must be connected somehow. Im back to getting a ../includes/functions/redemptions.php on line 341 error in the checkout_payment.php again, this error only occurs when redemtion is enabled and customer have any points.. If there are anyone that can help out, then please!
  7. Toorqs

    Custom Product Builder

    Has anyone figured out a way to get the thumbnails in the build menu to show as larger pictures on mouseover? Id like this to happen only in the CPB, not anywhere else on the site
  8. Toorqs

    ### POINTS AND REWARDS MODULE V1.00 ###

    Solved this one, had something to with the refferal code that was added at the end.. New problem however. Everything seems to be working well, except when a customer gets to the checkout_payment.php it lists the correct points, but where he can check for "clich here to use max points etc etc." the points lists as 0. I have tried all sorts of settings, and it shouldnt be anything wrong there. Ill fo some searching in these 100 something pages, but if someone has a quick fix, it would be apreciated.
  9. Toorqs

    ### POINTS AND REWARDS MODULE V1.00 ###

    When a customer with any amount of points gets to the checkout_payment.php, he gets a Fatal error: Call to a member function show_total() on a non-object in xxxxxxxxxxxxxx/public_html/includes/functions/redemptions.php on line 341. If he has no points its ok. The line looks like this: if ((POINTS_MIN_AMOUNT == '') || ($cart->show_total() >= POINTS_MIN_AMOUNT) ) { Whole section: if (($customer_shopping_points = tep_get_shopping_points()) && $customer_shopping_points > 0) { if (get_redemption_rules($order) && (get_points_rules_discounted($order) || get_cart_mixed($order))) { if ($customer_shopping_points >= POINTS_LIMIT_VALUE) { if ((POINTS_MIN_AMOUNT == '') || ($cart->show_total() >= POINTS_MIN_AMOUNT) ) { if (tep_session_is_registered('customer_shopping_points_spending')) tep_session_unregister('customer_shopping_points_spending'); $max_points = calculate_max_points($customer_shopping_points); if ($order->info['total'] > tep_calc_shopping_pvalue($max_points)) { $note = '<br /><small>' . TEXT_REDEEM_SYSTEM_NOTE .'</small>'; } $customer_shopping_points_spending = $max_points;
  10. Thanks. The only SQL file i can find in the download is the SQL V1.1 tho.. I have another problem im gona need some help with if u have time. I use a few addons like custom product builder and a premade template, so the product info php is looking very different from the standard one. Using some guesswork, i got it to work, and it looks great ;) however all the text i added to the products are gone when i try the modified file.. i guess i removed more than i should somehow. This is my current Product info.php if you are able to help me figure out where to put things and what to keep. <?php /* $Id: product_info.php 1739 2007-12-20 00:52:16Z hpdl $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_PRODUCT_INFO); // BUILDER INTERVENTION - redirect to builder_product_info if this is a builder product $product_check_query = tep_db_query("select p.builder_product_flag, count(*) as total from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where (p.products_status = '1' or p.builder_product_flag = '1') and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' group by p.products_id"); $product_check = tep_db_fetch_array($product_check_query); if ($product_check['builder_product_flag'] == '1') { tep_redirect(tep_href_link(FILENAME_BUILDER_PRODUCT_INFO, 'products_id=' . $_GET['products_id'])); } // END OF BUILDER INTERVENTION ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>"> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <script type="text/javascript" src="iepngfix_tilebg.js"></script> <style type="text/css"> .ie6_png {behavior: url("iepngfix.htc") } .ie6_png img {behavior: url("iepngfix.htc") } .ie6_png input {behavior: url("iepngfix.htc") } </style> <!--[if IE]> <script type="text/javascript" src="ie_png.js"></script> <script type="text/javascript"> ie_png.fix('.png'); </script> <![endif]--> <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=150') } //--></script> </head> <body> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" class="<?php echo MAIN_TABLE; ?>" cellspacing="0" cellpadding="0"> <tr> <td class="<?php echo BOX_WIDTH_TD_LEFT; ?>"><table border="0" class="<?php echo BOX_WIDTH_LEFT; ?>" cellspacing="0" cellpadding="0"> <!-- left_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?> <!-- left_navigation_eof //--> </table></td> <!-- body_text //--> <td class="<?php echo CONTENT_WIDTH_TD; ?>"><?php echo panel_top(); ?><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?> <?php if ($product_check['total'] < 1) { ?> <?php echo tep_draw_top();?> <?php echo tep_draw_title_top();?> <?php echo TEXT_PRODUCT_NOT_FOUND; ?> <?php echo tep_draw_title_bottom();?> <?php echo tep_draw1_top();?> <?php echo tep_draw_infoBox2_top();?> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr><td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td></tr> </table> <?php echo tep_draw_infoBox2_bottom();?> <?php echo tep_draw1_bottom();?> <?php } else { $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); $product_info = tep_db_fetch_array($product_info_query); tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'"); if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $products_price2 = '<span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span><br><s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s>'; } else { $products_price2 = '<span class="productSpecialPrice">'.$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])).'</span>'; } 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> <b class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</b>'; } else { $products_price = '<b class="productSpecialPrice">'.$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])).'</b>'; } if (tep_not_null($product_info['products_model'])) { $products_name = $product_info['products_name'] . '<br> <span class="smallText">[' . $product_info['products_model'] . ']</span>'; } else { $products_name = $product_info['products_name']; } ?> <?php echo tep_draw_top();?> <?php echo tep_draw_title_top();?> <div class="left_part"><?php echo $breadcrumb->trail(' » ')?> » <?php echo $products_name; ?></div><div class="right_part"><?php echo $products_price2; ?></div> <?php echo tep_draw_title_bottom();?> <?php echo tep_draw1_top();?> <?php /* echo tep_draw2_top(); */?> <?php /* echo tep_pixel_trans(); */?> <?php if (tep_not_null($product_info['products_image'])) { ?> <div class="main prod_info" style="width:<?php echo (SMALL_IMAGE_WIDTH +23);?>px;"> <?php echo tep_draw_prod_pic_top();?><script language="javascript"><!-- document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, '') . '</a>'; ?>'); //--></script><noscript> <?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, '') . '</a>'; ?></noscript><?php echo tep_draw_prod_pic_bottom();?> <script language="javascript"><!-- document.write('<?php echo '<a class="enlarge" href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>'); //--></script> <noscript><?php echo '<a class="enlarge" href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?></noscript></div> <div class="main"><div class="desc2"><?php echo stripslashes($product_info['products_description']); ?></div><br> <br><div><?php echo $products_price?></div></div><br> <div style="clear:both;"></div> <?php } ?> <?php /* echo tep_draw2_bottom(); */?> <div class="prod_line_x padd2_gg"><?php echo tep_draw_separator('spacer.gif', '1', '1'); ?></div> <?php echo tep_draw2_top(); ?> <?php $products_attributes_query = tep_db_query("select count(*) as total 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 . "'"); $products_attributes = tep_db_fetch_array($products_attributes_query); if ($products_attributes['total'] > 0) { ?> <table border="0" cellspacing="4" cellpadding="2"> <tr> <td class="main" colspan="2"><strong class="strong"><?php echo TEXT_PRODUCT_OPTIONS; ?></strong></td> </tr> <?php $products_options_name_query = tep_db_query("select distinct popt.products_options_id, popt.products_options_name 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)) { $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, pa.products_attributes_id 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 pa.options_values_price, pa.products_attributes_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); ?></td> </tr> <?php } ?> </table> <?php } ?> <?php $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'"); $reviews = tep_db_fetch_array($reviews_query); if ($reviews['count'] > 0) { ?> <table cellpadding="0" cellspacing="4" border="0"> <tr> <td class="main"><?php echo TEXT_CURRENT_REVIEWS . ' ' . $reviews['count']; ?></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> </table> <?php } if (tep_not_null($product_info['products_url'])) { ?> <table cellpadding="0" cellspacing="4" border="0"> <tr> <td class="main"><?php echo sprintf(TEXT_MORE_INFORMATION, tep_href_link(FILENAME_REDIRECT, 'action=url&goto=' . urlencode($product_info['products_url']), 'NONSSL', true, false)); ?></td> </tr> </table> <?php echo tep_pixel_trans();?> <?php } if ($product_info['products_date_available'] > date('Y-m-d H:i:s')) { ?> <?php echo tep_pixel_trans();?> <table cellpadding="0" cellspacing="4" border="0"> <tr> <td class="main"><?php echo sprintf(TEXT_DATE_AVAILABLE, tep_date_long($product_info['products_date_available'])); ?></td> </tr> </table> <?php } else { ?> <?php echo tep_pixel_trans();?> <table cellpadding="0" cellspacing="4" border="0"> <tr> <td class="main"><?php echo sprintf(TEXT_DATE_ADDED, tep_date_long($product_info['products_date_added'])); ?></td> </tr> </table> <?php } ?> <?php echo tep_draw2_bottom(); ?> <?php echo tep_pixel_trans();?> <div class="prod_line_x padd2_gg"><?php echo tep_draw_separator('spacer.gif', '1', '1'); ?></div> <?php /* echo tep_draw2_top(); */ ?> <?php echo tep_pixel_trans();?> <?php echo tep_pixel_trans();?> <?php /* echo tep_draw_infoBox2_top(); */ ?> <table border="0" width="100%" cellspacing="0" cellpadding="0"><tr> <td class="main button_marg"><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS, tep_get_all_get_params()) . '">' . tep_image_button('button_reviews.gif', IMAGE_BUTTON_REVIEWS) . '</a>'; ?></td> <td class="main button_marg" align="right"><?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_add_to_cart1.gif', IMAGE_BUTTON_IN_CART); ?></td> </tr> </table> <?php /* echo tep_draw_infoBox2_bottom(); */ ?> <?php /* echo tep_draw2_bottom(); */ ?> <?php echo tep_draw1_bottom();?> <?php if ((USE_CACHE == 'true') && empty($SID)) { echo tep_cache_also_purchased(3600); } else { include(DIR_WS_MODULES . FILENAME_ALSO_PURCHASED_PRODUCTS); } } ?> <?php echo tep_draw_bottom();?> </form></td> <!-- body_text_eof //--> <td class="<?php echo BOX_WIDTH_TD_RIGHT; ?>"><table border="0" class="<?php echo BOX_WIDTH_RIGHT; ?>" cellspacing="0" cellpadding="0"> <!-- right_navigation //--> <?php require(DIR_WS_INCLUDES . 'column_right.php'); ?> <!-- right_navigation_eof //--> </table></td> </tr> </table> <!-- body_eof //--> <!-- footer //--> <?php require(DIR_WS_INCLUDES . 'footer.php'); ?> <!-- footer_eof //--> </body> </html> <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>
  11. Hello, Im trying to run the SQL info in phpmyadmin for a new install, i assume i should use SQL v.1.1? However i get an error: SQL-spørring: ALTER TABLE `products` ADD `products_image_array` VARCHAR( 800 ) NULL DEFAULT NULL ; MySQL said: #1060 - Duplicate column name 'products_image_array' I cant seem to find any other entries like this one, but im really green with SQL.. Anyone able to point me in the right direction?
  12. Toorqs

    Custom Product Builder

    New questions arise: Pricing Is there any way i can give a flat % discount on the assembled product? I want to be able to change the price of the the build without having to manually edit 2-300 products..
  13. Toorqs

    Custom Product Builder

    Moahhaha (evil genious laugh..) Figured it out. All the products i tried to add had product attributes. clearly that was not good. Works like a charm now.
  14. Toorqs

    Custom Product Builder

    Please Please Please, If anyone have any idea why i cant click on the products, please let me know.. I have set up the custom builder with 25 product categories now, but when i click on the top category, it lists the products as it should, but all i can click is "deselect product" I went over the installation text again, and cant find anything wrong with it. Do anyone have any clue what php file this error must be in? from inspect:
×