Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.


  • Content count

  • Joined

  • Last visited

  • Days Won


andyn last won the day on December 3 2011

andyn had the most liked content!


Profile Information

  • Real Name
    Andy Nguyen
  • Gender
  • Location
    Calgary, AB, Canada
  1. Hi,

    Solved the division by zero issue by using an '@' before '($review_rating_total / $review_count);'

    Thank you for sharing this, looks really good now.

  2. Hi,

    I have used your 'REVIEWS AVERAGE RATING PRODUCT INFO for osCommerce v2.3.1' and it looks great on my site when there are reviews to show. However, on products that do not yet have any reviews it is showing the following error message:

    Warning: Division by zero in /websites/123reg/LinuxPackage22/mi/ni/ga/minigadget.co.uk/public_html/product_info.php on line 17...

  3. Hi How are you?

    I like the Idea of Categories CSS. Are you planning on having any fly out subcategories. The Postings don't Have a fly out menus.

  4. Work smart, not hard!

  5. andyn

    [Addon} Modular Front Page

    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. Thanks, Andy,
  6. andyn

    [Addon} Modular Front Page

    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, Andy,
  7. andyn

    [Addon} Modular Front Page

    Hi Jim, I love this Modular Front Page! a must to have... There is an extra semicolon ";" on line 74 in the catalog/includes/modules/front_page/upcoming_products.php. This should be removed? Thanks, Andy,
  8. By the way, i want to say thanks to Stream and specially to Pronux, without both of you, i think i can not get the work done as the way i want it to be. This is how far my TABs have been done http://www.microheli.com/store/product_info.php/products_id/19 Thanks again, Andy,
  9. 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. <!--tabs--> <?php $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); ?> <script> $(document).ready(function() { $("#tabs").tabs(); }); </script> <div id="tabs"> <ul> <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> </ul> <div id="fragment-1"> <?php echo stripslashes($product_info['products_description']); ?> </div> <div id="fragment-2"> Test 2 </div> <div id="fragment-3"> Test 3 </div> </div> <!--/tabs--> Thanks, Andy,
  10. Hi Stream, Thanks for your help. I just gave it a try. It works! I will do some twist to fit on my site. Also i will get the review number appears next to the Review (1). Andy,
  11. 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: <?php $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/> <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--> <?php 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); ?> </div> <?php } $reviews_query = tep_db_query($reviews_split->sql_query); while ($reviews = tep_db_fetch_array($reviews_query)) { ?> <div> <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> <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>'; ?> </div> <?php } } else { ?> <div class="contentText"> <?php echo TEXT_NO_REVIEWS; ?> </div> <?php } 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); ?> </div> <?php } ?> <!--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, Andy,
  12. 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, Andy,
  13. 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'] . ')'; Thanks, Andy,
  14. 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. Thanks, Andy,
  15. 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: "products_description2" 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. Andy,