jQuery Scrolling Sideboxes [Support Thread]

[lat9]

I'll make a note of your enhancement request!

[khejit]

How does this work? I can see new "Featured [MORE]" and "WHAT'S NEW [MORE]" and the rest if I turn it on in Layout Boxes Controller, but these are empty and useless.

[lat9]

How does this work? I can see new "Featured [MORE]" and "WHAT'S NEW [MORE]" and the rest if I turn it on in Layout Boxes Controller, but these are empty and useless.

Just like with the built-in featured and what's new sideboxes, if you don't have any products defined as featured or up-coming then these sideboxes won't have content ... so you should turn them off.

[DivaVocals]

Question: (yep here I go pushing the envelope again.. )

I haven't downloaded this yet to take a looksee, but I would like to add this kind of functionality to the Testimonials and reviews sideboxes.. In your opinion, will it be fairly OBVIOUS looking at your code to figure out how to apply this to the Testimonials and reviews sideboxes??

[lat9]

Question: (yep here I go pushing the envelope again.. )

I haven't downloaded this yet to take a looksee, but I would like to add this kind of functionality to the Testimonials and reviews sideboxes.. In your opinion, will it be fairly OBVIOUS looking at your code to figure out how to apply this to the Testimonials and reviews sideboxes??

Yes. In each case, the plugin's sideboxes were cloned from their built-in Zen Cart sidebox of a similar name. The jQuery that handles the scrolling is a common function, invoked via the sidebox's tpl_ file.

[DivaVocals]

Yes. In each case, the plugin's sideboxes were cloned from their built-in Zen Cart sidebox of a similar name. The jQuery that handles the scrolling is a common function, invoked via the sidebox's tpl_ file.

Cool!!! Thanks.. I'll have a looksee..

[lat9]

I've checked this plugin; it's compatible with Zen Cart v1.5.4 and v1.5.5 (no core-file changes).

[rlexyd]

Question: (yep here I go pushing the envelope again.. )

I haven't downloaded this yet to take a looksee, but I would like to add this kind of functionality to the Testimonials and reviews sideboxes.. In your opinion, will it be fairly OBVIOUS looking at your code to figure out how to apply this to the Testimonials and reviews sideboxes??

Hi Crystal, did you ever get this plugin to work with the Reviews Box?
I started to copy/merge some info from this plugin to the review files but my brain started to fade away and I gave up
Hope you had luck with this at least.

Yes. In each case, the plugin's sideboxes were cloned from their built-in Zen Cart sidebox of a similar name. The jQuery that handles the scrolling is a common function, invoked via the sidebox's tpl_ file.

Thank you very much Cindy for this plugin, works well out of the box on 1.5.7c on PHP 7.4 on responsive_classic :)
Hopefully I can manage to expand it to the reviews box.

[rlexyd]

Ok, so I had another go at it and I'm almost there, just need more help please as I'm very sure I've done a few things wrong
Can't seem to get the product to change, it stays on the same product.
Here's the snapshot of the reviews box at the test site: https://i.imgur.com/JegnOTQ.png

1) This is the new file created in (includes/modules/sideboxes/reviews_scrolling.php):

  $review_status = " and r.status = 1 ";


  $scrolling_review_sql = "select r.reviews_id, r.reviews_rating, p.products_id, p.products_image, pd.products_name,
                    substring(reviews_text, 1, 70) as reviews_text
                    from " . TABLE_REVIEWS . " r, " . TABLE_REVIEWS_DESCRIPTION . " rd, "
                           . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd
                    where p.products_status = '1'
                    and p.products_id = r.products_id
                    and r.reviews_id = rd.reviews_id
                    and rd.languages_id = '" . (int)$_SESSION['languages_id'] . "'
                    and p.products_id = pd.products_id
                    and pd.language_id = '" . (int)$_SESSION['languages_id'] . "'" .
                    $review_status;


  if (isset($_GET['products_id'])) {
    $scrolling_review .= " and p.products_id = '" . (int)$_GET['products_id'] . "'";
  }


  $scrolling_review = $db->ExecuteRandomMulti($scrolling_review_sql, MAX_RANDOM_SELECT_REVIEWS);
  
  
  if (!$scrolling_review->EOF) {
    require($template->get_template_dir('tpl_reviews_random_scrolling.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_reviews_random_scrolling.php');
  } elseif (isset($_GET['products_id']) and zen_products_id_valid($_GET['products_id'])) {
// display 'write a review' box
    require($template->get_template_dir('tpl_reviews_write.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_reviews_write.php');
  } else {
// display 'no reviews' box
    require($template->get_template_dir('tpl_reviews_none.php',DIR_WS_TEMPLATE, $current_page_base,'sideboxes'). '/tpl_reviews_none.php');
  }
  $title =  BOX_HEADING_REVIEWS_SCROLLING;
  $title_link = FILENAME_REVIEWS;
  require($template->get_template_dir($column_box_default, DIR_WS_TEMPLATE, $current_page_base,'common') . '/' . $column_box_default);
?>

2) This is the new file created in (includes/templates/template_default/sideboxes/tpl_reviews_random_scrolling.php):

  $content = '<div class="sideBoxContent centeredContent">';
  $review_box_counter = 0;
  while (!$scrolling_review->EOF) {
    $review_box_counter++;
	$rs_pid = $scrolling_review->fields['products_id'];
    $rs_pname = $scrolling_review->fields['products_name'];
    $content .= '<br />' . $rs_pname . '</a>';
//	$content .= "\n" . '  <div class="sideBoxContentItem hiddenField reviewsScroller">'; (If I un-comment this, website jumbles up)
    $content .= '<div class="' . str_replace('_', '-', $box_id . 'Content') . ' sideBoxContent centeredContent">';
//    $content .= '<a href="' . zen_href_link(zen_get_info_page($rs_pid), 'cPath=' . zen_get_generated_category_path_rev($scrolling_review->fields['master_categories_id']) . "&products_id=$rs_pid") . '">' . zen_image(DIR_WS_IMAGES . $scrolling_review->fields['products_image'], $rs_pname, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br />' . nl2br(zen_trunc_string(zen_output_string_protected(stripslashes($scrolling_review->fields['reviews_text'])), 60)) . '</a><br /><br />' . zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $scrolling_review->fields['reviews_rating'] . '.gif' , sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $scrolling_review->fields['reviews_rating']));
    $content .= '<a href="' . zen_href_link(FILENAME_PRODUCT_REVIEWS_INFO, 'products_id=' . $scrolling_review->fields['products_id'] . '&reviews_id=' . $scrolling_review->fields['reviews_id']) . '">' . zen_image(DIR_WS_IMAGES . $scrolling_review->fields['products_image'], $scrolling_review->fields['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '<br />' . nl2br(zen_trunc_string(zen_output_string_protected(stripslashes($scrolling_review->fields['reviews_text'])), 60)) . '</a><br /><br />' . zen_image(DIR_WS_TEMPLATE_IMAGES . 'stars_' . $scrolling_review->fields['reviews_rating'] . '.gif' , sprintf(BOX_REVIEWS_TEXT_OF_5_STARS, $scrolling_review->fields['reviews_rating']));
    $content .= '</div>';
    $scrolling_review->MoveNextRandom();
  }
$content .= '</div><script type="text/javascript">$("div.reviewsScroller").cycle(5000);</script>' . "\n";

3) I added this to includes/languages/english/extra_definitions/scrolling_sideboxes.php:

define('BOX_HEADING_REVIEWS_SCROLLING', 'Reviews');

[rlexyd]

p.s: If I set the Admin/Configuration/Maximum Value --> Random Product Reviews for SideBox to a value More than 1, the sidebox will display several reviews all at once under each other in the sidebox, not scrolling.