Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

  • Days Won


Posts posted by andyn

  1. Hi Jim,


    I can see your point. That's reason why i'd like to involve into this topic.


    By the way, I know you are a very busy man as i do, 12-14 hours on computer. So I try to get the price tags and product names on the Scroller, however, the prices are shown up with many digits such as "39.9900" instead of "$39.99". I try to work on the code but not successful. If you have sometime later, please update these infos for all of us. I think there are people want those infos to be appeared on it, not just the scroller images.


    Some of products we are selling, they are the same type but some only works for this app and other only works for that app. That's why we need to have these infos stick with images, otherwise, it's useless if customers only see photos and dont know which is which.


    It's would be nice if you can make those infos ON and OFF in admin as you did on "Specials" header.


    I think I asked too much here. But dont panic, you can do it now or later on the new version, we still can live with the original Scroller version for now.


    PS: you can take a look on my site for the Scroller infos that i mentioned above.




  2. Hi Jim,


    Keep up your hard work, we will stand behind this module. I could not find the Paypal Donation on this "module" as well. (...kidding!!!).

    I like this module because it does everything by it own, without touching/importing SQL into the database, less trouble and headache.

    It's simple to install but powerful features.


    I am still waiting for the Flash Carousel add on with you package like the Scroller, not a stand alone module.


    You can check out the work i have done with your Module Front Page here: http://www.microheli.com/store/welcome.php


    Thanks again,



  3. Stream,


    I just done the code which shows the number (x) of how many reviews are in there like "Review (2)" before customer clicks on the tab. Add some codes base on the code that you shown me.




    $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and r.reviews_status = 1 and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "'");

    $reviews = tep_db_fetch_array($reviews_query);




    $(document).ready(function() {




    <div id="tabs">


    <li><a href="#fragment-1"><span>Description</span></a></li>

    <li><a href="#fragment-2"><span>Reviews<?php echo ' ' . '(' . $reviews['count'] . ')'; ?></span></a></li>

    <li><a href="#fragment-3"><span>Three</span></a></li>


    <div id="fragment-1">

    <?php echo stripslashes($product_info['products_description']); ?>


    <div id="fragment-2">

    Test 2


    <div id="fragment-3">

    Test 3







  4. Hi Pronux,


    I dont want to bother you and your time too much here. I appreciate for your effort to help us, but i failed on this stage.


    In the file content_tabs_en.php, i have this line:




    $reviewTabContent = 'test';


    $contentTab3 = '

    1. Warning when the sum of all tabWidthUserDefined tabs+border is bigger then totalWidth

    <br/>2. Auto-Size of the tabs (width) and/or the ability to define the width per language

    <br/>3. Caching of the whole tab-menu


    <br/>Having other suggestions or ideas about this addon? Feel free to contact us.



    ?> (<-----original file is missing this "?>" sign)


    then i have the text "test" appears on the tab2. As soon as I replace this "test" by this code:


    <!--Begin Product Reviews-->


    define('TEXT_OF_5_STARS', '%s of 5 Stars!');

    $reviews_query_raw = "select r.reviews_id, left(rd.reviews_text, 100) as reviews_text, r.reviews_rating, r.date_added, r.customers_name from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where r.products_id = '" . (int)$product_info['products_id'] . "' and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "' and r.reviews_status = 1 order by r.reviews_id desc";

    $reviews_split = new splitPageResults($reviews_query_raw, MAX_DISPLAY_NEW_REVIEWS);


    if ($reviews_split->number_of_rows > 0) {

    if ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3')) {



    <div class="ui-widget-content infoBoxContents">

    <div style="float: right;"><?php echo TEXT_RESULT_PAGE . ' ' . $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info'))); ?></div>


    <?php echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS); ?>






    $reviews_query = tep_db_query($reviews_split->sql_query);

    while ($reviews = tep_db_fetch_array($reviews_query)) {




    <span class="mainText" style="float: right;"><?php echo sprintf(TEXT_REVIEW_DATE_ADDED, tep_date_long($reviews['date_added'])); ?></span>

    <h2><?php echo '<a href="' . tep_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $product_info['products_id'] . '&reviews_id=' . $reviews['reviews_id']) . '">' . sprintf(TEXT_REVIEW_BY, tep_output_string_protected($reviews['customers_name'])) . '</a>'; ?></h2>



    <div class="contentText">

    <?php echo tep_break_string(tep_output_string_protected($reviews['reviews_text']), 60, '-<br />') . ((strlen($reviews['reviews_text']) >= 100) ? '..' : '') . '<br /><br /><i>' . sprintf(TEXT_REVIEW_RATING, tep_image(DIR_WS_IMAGES . 'stars_' . $reviews['reviews_rating'] . '.png', sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])), sprintf(TEXT_OF_5_STARS, $reviews['reviews_rating'])) . '</i>'; ?>





    } else {



    <div class="contentText">

    <?php echo TEXT_NO_REVIEWS; ?>






    if (($reviews_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) {



    <div class="ui-widget-content infoBoxContents">

    <div style="float: right;"><?php echo TEXT_RESULT_PAGE . ' ' . $reviews_split->display_links(MAX_DISPLAY_PAGE_LINKS, tep_get_all_get_params(array('page', 'info'))); ?></div>


    <?php echo $reviews_split->display_count(TEXT_DISPLAY_NUMBER_OF_REVIEWS); ?>






    <!--End Product Reviews-->


    It wont work. This is what i keep saying that i am confusing this statement: "...it does nothing else than putting the generated content into a temp variable ($reviewTabContent)..."


    I have wasted to much bandwidth here, something is not working for me, no matter what i try. I give it up!


    Thanks again for all your help and support.


    Happy New Year to all,


  5. Thanks Pronux for your time,


    All night, i keep thinking about how to make the review info appear on the tab2. I have done alot of works so far to set up the product_info.php page, till this stage, my tab 2 can not appear the review content.


    My TMS is working fine so far as i said, the only thing i want is how to make the content or some contents in the product_reviews.php page to be appeared on the tab2.

    In Conf.php, i have:


    $CONF['tabs']['en'][1] = 'Description';

    $CONF['tabs']['en'][2] = 'Customer Reviews (' . $reviews['count'] . ')';

    $CONF['tabs']['en'][3] = 'Notes';


    and in product_info.php, i have:


    $TMS->tab[1]['content'] = $product_info['products_description'];

    $TMS->tab[2]['content'] = $reviewTabContent;

    $TMS->tab[3]['content'] = $contentTab3;


    Everything is working smooth as silk, except no review content appears under tab2, there is something related with $reviewTabContent;. However, Pronux mentioned: "...it does nothing else than putting the generated content into a temp variable ($reviewTabContent)...", I am still confusing how to put those $reviewTabContent = ''; and $reviewTabContent .= ' on the product_reviews.php code in order to make them appeared on the tab2.


    Please give me more specific details. I almost give it up at this stage. Here is how far i have done on my product_info.php page: http://www.microheli.com/store/product_info.php/products_id/19#!tab2

    You can see I already copied some of the codes from product_reviews.php into the products_info.php so that the review content can be appeared at the bottom of the page for proving that the codes are working and ready, but still can not make them appeared under tab2.

    This drives me crazy now. Please help before i give it up, i can not go too far on this.


    Thanks again,


  6. Pronux, Thanks to you It's working. I've been trying to make it where it would also say "no reviews have been made" and when there is not reviews it would have a button or something telling users if they would like to leave a review.


    I'm going to keep messing with it to see if I could get it or not.


    Thank you for all your help!


    Hi Stream,


    I could not get it shows on the tab2, how can you get it works? Give me a hand!


    I am still confusing at this stage wrote by Pronux: "...it does nothing else than putting the generated content into a temp variable ($reviewTabContent)..."


    Please show me specific code of how you put those $reviewTabContent = ''; and $reviewTabContent .= ' on the codes.


    I spent 2 hours to play around with it. I got stuck here. Please help!


    By the way:

    I followed this step by Pronux:

    3. Go to catalog/includes/TMS/Conf.php and change the name of the second tab:


    $CONF['tabs']['en'][2] = 'Reviews';


    However i want it show the number of customer reviews after to the Reviews, like this Review (1), so customer will notice there is 1 review in there before clicking on it. What i did was:


    3. Go to catalog/includes/TMS/Conf.php and change the name of the second tab:

    add this code right underneath of //Language Settings:


    $reviews_query = tep_db_query("select count(*) as count from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and r.reviews_status = 1 and r.reviews_id = rd.reviews_id and rd.languages_id = '" . (int)$languages_id . "'");

    $reviews = tep_db_fetch_array($reviews_query);


    change this: $CONF['tabs']['en'][2] = 'Reviews';

    to this: $CONF['tabs']['en'][2] = 'Reviews (' . $reviews['count'] . ')';




  7. Hi Pronux,


    I am recently working on my site, along with TMS great module. So far so good to me. I will update it to the newer version which I can update information through Admin as you mentioned.

    During the time i were working on the TMS Module, I have a question here:


    In the file TabMenuSection.php on line 33 has this code: $path = $this->CONF['pathtms'].'TabMenuSectionStyles.css';


    We already done this step 3 per instruction:

    Step 3: Add the styles in TMS/TabMenuSectionStyles.css to your osCommerce stylesheet (normaly this is catalog/admin/includes/stylesheet.css)


    So, should i change the code above from 'TabMenuSectionStyles.css' to 'stylesheet.css', but what 'pathtms' to change to?

    The reason i am asking is i dont see the point why i have 2 duplicated *.css for one module, if i have to modify this stylesheet.css than i have to do other TabMenuSectionStyles.css as well, this is not what i want to do.


    Please advice.




  8. I followed the steps as Pronux mentioned:


    1. Add the new field to your database, to the table products_description, for example name the new field "new_field".

    >>>>Yes, I go into PHPMyAdmin and manually create a new field named:



    Now, i go back the main table "products_description" on the data base, i see alot of columns like: products_id, language_id, products_name, products_description, products_description2,....each column has its own information in it for each products, except the column products_description2, so what i do is just type some text in it like: "This is a text from description2"



    2. Add the new field to the sql-query on product_info.php, near line 37.

    >>>>Yes, I have:

    "$product_info_query = tep_db_query(select p.products_id, pd.products_name, pd.products_description, pd.products_description2,...."


    3. Add the new field f.e. to the second tab:

    >>>>Cool, I have:

    $TMS->tab[1]['content'] = $product_info['products_description'];

    $TMS->tab[2]['content'] = $product_info['products_description2'];

    $TMS->tab[3]['content'] = 'hello world 2';


    Done! I go back to the website, click on the Tab 2, here we go: "This is a text from description2" BINGO!!!. It works perfectly at this stage.


    My question is how we can import the text like: "This is a text from description2" from admin categories? I can not going to my database to update this text manually each time i upload a new product. Anyone here please give me a trick for the xmas? i apreciate it very much. Thanks.



  9. Anyone please tell me what i should do to fix this error:


    Warning: openssl_pkcs7_sign(): error getting private key in /home/content/n/e/x/nexrc/html/shop/includes/modules/payment/paypal_ipn.php on line 542


    Warning: file_get_contents(/home/content/n/e/x/nexrc/html/shop/tmp/373136-2-signed.txt): failed to open stream: No such file or directory in /home/content/n/e/x/nexrc/html/shop/includes/modules/payment/paypal_ipn.php on line 547


    I have tried many ways:

    -If i use the "cert_key_pem.txt" file that downloaded from Paypal in Your Private Key then I got the error above, but if i use my self-signed key generated by Cryto4 PKI in Your Private Key then no error occurred. Either ways, the Preparing [PayPal IPN] status still wont change, even after payment has made and return to click Continue.


    Also, in my setting I leave this value as default:

    OpenSSL Location


    Or should I contact Godaddy to ask for the location of openssl?


    Please HELP me!!!!!!





  10. Hello everybody,


    This is my first post on the osCommerce Forums. First, i would like to thank to all who contributes and supports the wonderful osCommerce community. I have read and pay close attention on most topic and troubleshooting guildes in order to build sucessfully this wonderful osCommerce Shopping cart.

    Today, i have decided to make my fist post on this osC Paypal IPN forums, specially thanks to Alex for his great Contribution and Instruction to complete setup the Paypal IPN.

    After days and nights reading, following step by step on the Instruction and work on the troubleshooting for the Paypal IPN, my test shop with a fresh osC 2.2MS2 and Paypal IPN module V2.3.3 still not working.


    The Preparing [PayPal IPN] status won't change, order status and stock not update. My brain is freeze, I almost give up...


    If anyone host your website at Godaddy, please give me an advise about this setup. I appreciate for any of your inputs to help me get my site goes LIVE!




    ...my Eye Drops is gone down half bottle....