Old addon do not fit with osc2.3.4BS

root123 · January 18, 2015

I added old addon module from admin-module-box but it do not fit with existing left and right module in osc2.3.5bs , please help me how to make it to fit and where is the exact code to edit? Thanks !!!

auzStar · January 18, 2015

@@root123

Hi Benjamin,

What old add-on did you try to install? If you tell us we might be able to help.

The old add-ons haven't been coded to work with osc2.3.4bs i.e. not responsive (BTW there's no 2.3.5bs).

When you say old, for which version of osCommerce was it written for. If it's for osc2.2 then the add-on would need to be completely re-written. If it's for osc2.3.x then it most likely can be modified to work with 2.3.4bs. The current osc2.3.4bs module boxes are now made up of 2 files; the main module and a template file inside the template folder. If you have a look at the currently installed modules in "catalog\includes\modules\boxes\" and "catalog\includes\modules\boxes\templates\" you will get idea of how they are coded and using bootstrap.

cheers

root123 · January 18, 2015

Hi thank u very much for your immediate replay here is the addon I want to add http://addons.oscommerce.com/info/8065

auzStar · January 18, 2015

@@root123

Benjamin,

You need to make sure the add-ons you select are bootstrap versions if you're installing on osc2.3.4BS. At the moment there aren't that many bootstrap versions available. The ones that are bootstrap will state that they are.

Look at this thread here: http://forums.oscommerce.com/topic/399572-28-days-of-code-february-2015-rocking-oscommerce/ and then add yourself to the mailing list on the 28daysofcode site.

This particular add-on (scrolling boxes) you installed isn't a bootstrap version. It will require some recoding. If I get a chance I will have a look at it. Or perhaps @@De Dokta can assist. :D

cheers

De Dokta · January 18, 2015

@@root123

@@auzStar

Or perhaps @@De Dokta can assist. :D

Just an attempt on the fly as an example for the specials scroller. :rolleyes: Tested in bootstrap gold.

includes/modules/boxes add a new file bm_specials_scroller.php:

<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2015 osCommerce

  Released under the GNU General Public License


created: O.F.Y. - osCommerce for You
   http://www.oscommerceforyou.hu
  email: info@oscommerceforyou.hu
*/

    class bm_specials_scroller {
    var $code = 'bm_specials_scroller';
    var $group = 'boxes';
    var $title;
    var $description;
    var $sort_order;
    var $enabled = false;

    function bm_specials_scroller() {
      $this->title = MODULE_BOXES_SPECIALS_SCROLLER_TITLE;
      $this->description = MODULE_BOXES_SPECIALS_SCROLLER_DESCRIPTION;

      if ( defined('MODULE_BOXES_SPECIALS_SCROLLER_STATUS') ) {
        $this->sort_order = MODULE_BOXES_SPECIALS_SCROLLER_SORT_ORDER;
        $this->enabled = (MODULE_BOXES_SPECIALS_SCROLLER_STATUS == 'True');

        $this->group = ((MODULE_BOXES_SPECIALS_SCROLLER_CONTENT_PLACEMENT == 'Left Column') ? 'boxes_column_left' : 'boxes_column_right');
      }
    }

    function execute() {
      global $_GET, $languages_id, $currencies, $oscTemplate;

         $rp_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_SPECIALS . " s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc");
  if (tep_db_num_rows($rp_query)) {

            while ($random_product = tep_db_fetch_array($rp_query)) {

          $rp .= '<p class="text-center"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . $random_product['products_name'] . '</a></p>';
          $rp .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, NULL, NULL, 'img-responsive thumbnail') . '</a>';
          	          
          if(SCROLL_DESC != '0') {	          
          $rp .= '<p class="text-center">' .  substr(strip_tags($random_product['products_description']), 0, SCROLL_DESC). '...<br /></p>';
           }
          
          $rp .= '<p class="text-center"><s>' . $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</s><br /> <span class="productSpecialPrice">' . $currencies->display_price($random_product['specials_new_products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) .'</p>';
          $rp .= '<p class="text-center">' .tep_draw_button(SMALL_IMAGE_BUTTON_VIEW, '', tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product["products_id"]), '', '', 'btn-success btn-sm') . '</p>';
          $rp .= '<hr />';  
          }

          ob_start();
          include(DIR_WS_MODULES . 'boxes/templates/specials_scroller.php');
          $data = ob_get_clean();

          $oscTemplate->addBlock($data, $this->group);
        }
    }

    function isEnabled() {
       global $PHP_SELF;
       if($PHP_SELF !== 'specials.php') { 
      return $this->enabled;
    }
    }

    function check() {
      return defined('MODULE_BOXES_SPECIALS_SCROLLER_STATUS');
    }

    function install() {
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Specials Module', 'MODULE_BOXES_SPECIALS_SCROLLER_STATUS', 'True', 'Do you want to add the module to your shop?', '6', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Content Placement', 'MODULE_BOXES_SPECIALS_SCROLLER_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', '6', '1', 'tep_cfg_select_option(array(\'Left Column\', \'Right Column\'), ', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_BOXES_SPECIALS_SCROLLER_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '2', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Scroll Direction', 'SCROLL_DIRECTION', 'up', 'Change Scroller Direction', '6', '2', 'tep_cfg_select_option(array(\'up\', \'down\'), ',now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Scroll Height', 'SCROLL_HEIGHT', '260', 'Change Scroller Height, default: 260 px', '6', '3', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Scroll Speed', 'SCROLL_SPEED', '2', 'Change Scroller Speed, default: 2', '6', '4', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Scroll Delay', 'SCROLL_DELAY', '20', 'Change Scroller Delay, default: 20', '6', '5', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Description Length', 'SCROLL_DESC', '20', 'Display part of products description, default: 50 (0 = No description)', '6', '6', now())");
}

    function remove() {
      tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
    }

    function keys() {
      return array('MODULE_BOXES_SPECIALS_SCROLLER_STATUS', 'MODULE_BOXES_SPECIALS_SCROLLER_CONTENT_PLACEMENT', 'MODULE_BOXES_SPECIALS_SCROLLER_SORT_ORDER', 'SCROLL_DIRECTION', 'SCROLL_HEIGHT', 'SCROLL_SPEED', 'SCROLL_DELAY', 'SCROLL_DESC');
    }
  }
?>

includes/modules/boxes/templates add a new file specials_scroller.php:

<div class="panel panel-default hidden-xs hidden-sm">
   <div class="panel-heading"><a href="<?php echo tep_href_link('specials.php') . '">' . MODULE_BOXES_SPECIALS_SCROLLER_BOX_TITLE; ?></a></div>
    <div class="panel-body text-center">
     <?php echo '<MARQUEE behavior= "scroll"  direction= "' . SCROLL_DIRECTION . '" height="' . SCROLL_HEIGHT . '" scrollamount= "' . SCROLL_SPEED . '" scrolldelay= "' . SCROLL_DELAY . '" onmouseover=\'this.stop()\' onmouseout=\'this.start()\'>'.$rp.'</MARQUEE>'; ?>
   </div>
</div>

includes/languages/Your Language(s)/modules/boxes add a new file bm_specials_scroller.php:

<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2014 osCommerce

  Released under the GNU General Public License
*/

  define('MODULE_BOXES_SPECIALS_SCROLLER_TITLE', 'Specials Scroller');
  define('MODULE_BOXES_SPECIALS_SCROLLER_DESCRIPTION', 'Install Specials Scroll Box');
  define('MODULE_BOXES_SPECIALS_SCROLLER_BOX_TITLE', 'Specials');

Install it in your admin -> modules -> boxes, configure it to your needs and have fun! (w00t)

In collapsed view the scroller is hidden. If you want to display it even in collapsed view remove the hidden-xs hidden-sm tags from includes/modules/boxes/templates/specials_scroller.php.

J.J.

Edited January 18, 2015 by De Dokta

auzStar · January 19, 2015

@@De Dokta

@@root123

Awesome. Thanks Doc. Save me a bit of work. :thumbsup: Things we do for people. :D

Have created and uploaded new package for both boxes with some slight changes to the one you posted (full package for both an unchanged non-bootstrap version and the new bootstrap version).

http://addons.oscommerce.com/info/8065

The bootstrap version probably requires the other languages as only english is included.

Don't really like the way marquee leaves a blank space between first and last products (I read a while back that the marquee tag was deprecated). May fix that one day using something like what I've done in the Customer Testimonials scroll box using jQuery (where it also pauses inside the box), or unless there is a way with bootstrap. Need to investigate.

thanks heaps

cheers

Edited January 19, 2015 by auzStar

root123 · January 19, 2015

@@De Dokta

@@auzStar

Wow guys what amazing help u do for me, what would I do if u werenot there for me? I really thanks a lot u saved my time!!

De Dokta · January 20, 2015

Ok, since I'm not really satisfied with the marquee version, I've tried something else with jquery.

ext/jquery/ add a new file jquery.scroller.min.js:

(function($){$.fn.scroller=function(options) {var that=this;$(window).load(function() {var settings={transition:750,pause:5000,directionIn:1,directionOut:-1,height:150,}; if(options)$.extend(settings,options); var featuresWidth=that.width(),ul=that.find("ul"),li=ul.find("li"),liWidth=li.width(),t=undefined,on=false; that.css({overflow:"hidden"});li.hide().first().show(); var featuresHeight=ul.height(); ul.css({width:featuresWidth+"px",position:"relative",height:settings.height+"px"}); var position=li.first().position();li.css({position:"absolute",width:liWidth+"px"}); var loop=function(){if(on)return;on=true; var li=that.find("li"),first=li.first(),next=first.next(); first.css("top",position.top+"px").show().clone().hide().insertAfter(li.last()); next.css({"top":settings.directionIn*featuresWidth+"px",opacity:0}).show(); first.animate({opacity:0,top:settings.directionOut*featuresWidth+"px"},settings.transition,function(){$(this).remove();}); next.animate({opacity:1,top:position.top+"px",},settings.transition); setTimeout(function(){on=false;},settings.transition); if(t) t=setTimeout(function(){loop();},settings.pause);} 
that.hover(function(){clearTimeout(t);t=undefined;},function(){t=setTimeout(function(){loop();},settings.transition);});t=setTimeout(function(){loop();},settings.pause);});return this;};})(jQuery);

...modules/boxes/bm_whats_new_scroller.php changed to:

<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2010 osCommerce

  Released under the GNU General Public License

*/

  class bm_whats_new_scroller {
    var $code = 'bm_whats_new_scroller';
    var $group = 'boxes';
    var $title;
    var $description;
    var $sort_order;
    var $enabled = false;

    function bm_whats_new_scroller() {
      $this->title = MODULE_BOXES_WHATS_NEW_SCROLLER_TITLE;
      $this->description = MODULE_BOXES_WHATS_NEW_SCROLLER_DESCRIPTION;

      if ( defined('MODULE_BOXES_WHATS_NEW_SCROLLER_STATUS') ) {
        $this->sort_order = MODULE_BOXES_WHATS_NEW_SCROLLER_SORT_ORDER;
        $this->enabled = (MODULE_BOXES_WHATS_NEW_SCROLLER_STATUS == 'True');

        $this->group = ((MODULE_BOXES_WHATS_NEW_SCROLLER_CONTENT_PLACEMENT == 'Left Column') ? 'boxes_column_left' : 'boxes_column_right');
      }
    }

    function execute() {
       global  $oscTemplate, $languages_id, $currencies, $valuein, $valueout;
         
  
          $wn_query = tep_db_query("  select p.products_id, pd.products_name, pd.products_description, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, s.status from
" . TABLE_PRODUCTS . " p join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id left join " . TABLE_SPECIALS . " s on s.products_id = p.products_id where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int) $languages_id . "' order by p.products_date_added desc limit " . MAX_RANDOM_SELECT_NEW);
    
  if (tep_db_num_rows($wn_query)) {
      while ($randoms_product = tep_db_fetch_array($wn_query)) {
     $wn .= '<li>';
        if ($randoms_product['status'] == 1) {
              $p_price = '<s>' . $currencies->display_price($randoms_product['products_price'], tep_get_tax_rate($randoms_product['products_tax_class_id'])) . '</s> ';
              $p_price .= '<span class="productSpecialPrice">' . $currencies->display_price($randoms_product['specials_new_products_price'], tep_get_tax_rate($randoms_product['products_tax_class_id'])) . '</span>';
            } else {
              $p_price = $currencies->display_price($randoms_product['products_price'], tep_get_tax_rate($randoms_product['products_tax_class_id']));
            }

          
          $wn .= '<p class="text-center"><br /><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $randoms_product['products_id']) . '">' . $randoms_product['products_name'] . '</a></p>';
          
           $wn .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $randoms_product['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $randoms_product['products_image'], $randoms_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, NULL, NULL, 'img-responsive thumbnail') . '</a>';
          
         if(MODULE_BOXES_WHATS_NEW_SCROLLER_DESC != '0') {
         $wn .= '<p class="text-center">' . substr(strip_tags($randoms_product['products_description']), 0, SCROLLER_DESC). '...<br /></p>';
         }
         $wn .= '<p class="text-center">' . $p_price . '</p>';

         $wn .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $randoms_product["products_id"]) . '">'.tep_image_button("button_details.gif").'</a>';

         $wn .= '<p class="text-center">' .tep_draw_button(SMALL_IMAGE_BUTTON_VIEW, '', tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $randoms_product["products_id"]), '', '', 'btn-success btn-sm') . '</p>';
         $wn .= '</li>';
         }

         $direction = MODULE_BOXES_WHATS_NEW_SCROLLER_DIRECTION;
         if($direction == 'up') {
         $valuein = '1';
         $valueout = '-1';
         }else{
         $valuein = '-1';
         $valueout = '1';
         }

         $wn .='<script src="ext/jquery/jquery.scroller.min.js"></script>';
         $wn .= '<script>$("#whats_new").scroller({ directionIn :' .$valuein .', directionOut:' .$valueout .', pause:' . MODULE_BOXES_WHATS_NEW_SCROLLER_DELAY. ', transition:'. MODULE_BOXES_WHATS_NEW_SCROLLER_SPEED .', height:' . MODULE_BOXES_WHATS_NEW_SCROLLER_HEIGHT .'});</script>';


          ob_start();
          include(DIR_WS_MODULES . 'boxes/templates/whats_new_scroller.php');
          $data = ob_get_clean();

          $oscTemplate->addBlock($data, $this->group);
        }
      }
   

    function isEnabled() {
       global $PHP_SELF;
       if($PHP_SELF !== 'products_new.php') { 
      return $this->enabled;
    }
    }

    function check() {
      return defined('MODULE_BOXES_WHATS_NEW_SCROLLER_STATUS');
    }

    function install() {
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable What\'s New Module', 'MODULE_BOXES_WHATS_NEW_SCROLLER_STATUS', 'True', 'Do you want to add the module to your shop?', '6', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Content Placement', 'MODULE_BOXES_WHATS_NEW_SCROLLER_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', '6', '2', 'tep_cfg_select_option(array(\'Left Column\', \'Right Column\'), ', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_BOXES_WHATS_NEW_SCROLLER_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '3', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Scroll Direction', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DIRECTION', 'up', 'Change Scroller Direction', '6', '4', 'tep_cfg_select_option(array(\'up\', \'down\'), ',now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Scroller Height', 'MODULE_BOXES_WHATS_NEW_SCROLLER_HEIGHT', '260', 'Change Scroller Height, default: 260 px', '6', '5', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Scroller Transition Speed', 'MODULE_BOXES_WHATS_NEW_SCROLLER_SPEED', '1500', 'Change Scroller Transition Speed in ms, default: 1500 (Value MUST be smaller than Scroller Pause', '6', '6', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Scroller Pause', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DELAY', '2000', 'Change Scroller Pause in ms, default: 2000', '6', '7', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Description Length', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DESC', '20', 'Display part of products description, default: 50 (0 = No description)', '6', '8', now())");
    }

    function remove() {
      tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
    }
    
    function keys() {
      return array('MODULE_BOXES_WHATS_NEW_SCROLLER_STATUS', 'MODULE_BOXES_WHATS_NEW_SCROLLER_CONTENT_PLACEMENT', 'MODULE_BOXES_WHATS_NEW_SCROLLER_SORT_ORDER', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DIRECTION', 'MODULE_BOXES_WHATS_NEW_SCROLLER_HEIGHT', 'MODULE_BOXES_WHATS_NEW_SCROLLER_SPEED', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DELAY', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DESC');
    }
  }
?>

and modules/boxes/templates/whats_new_scroller.php to:

<div class="panel panel-default">
   <div class="panel-heading"><a href="<?php echo tep_href_link('products_new.php') . '">' . MODULE_BOXES_WHATS_NEW_SCROLLER_BOX_TITLE; ?></a></div>
    <div id="whats_new" class="panel-body" style="padding:0;">
	<ol style="list-style:none;padding-left: 0;">
     <?php echo '<center>' . $wn .'</center>'; ?>
    </ol>
  </div>
</div>

includes/languages/your_language/modules/bm_whats_new_scroller.php - no changes.

You can see the difference between the two approaches here - New Products with jquery, Specials with marquee.

And if someone want to try it: jquery Scroll Box.zip - contains only files for New Products Scroll Box. Installation is simple: Upload files to the appropriate folders, install the module in Admin -> Modules -> Boxes, configure it to your need - ready!

J.J.

PupStar · January 20, 2015

@@De Dokta

I always did like at least one scrolling box but I do think its a bit old hat these days.

Maybe freshen it up a bit and make it fade in/out, just a thought.

Mark

grandpaj · January 20, 2015

@@De Dokta

Hi JJ

Gave your "addon" a go. But got this.

The admin section has been left as default.

Any suggestions.

Cheers

Grandpa

Edited January 20, 2015 by grandpaj

De Dokta · January 20, 2015

@@grandpaj

@@De Dokta

The admin section has been left as default.

Any suggestions.

Cheers

Grandpa

Sorry, my mistake: :x

bm_whats_new_scroller.php:

<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2015 osCommerce

  Released under the GNU General Public License
*/

  class bm_whats_new_scroller {
    var $code = 'bm_whats_new_scroller';
    var $group = 'boxes';
    var $title;
    var $description;
    var $sort_order;
    var $enabled = false;

    function bm_whats_new_scroller() {
      $this->title = MODULE_BOXES_WHATS_NEW_SCROLLER_TITLE;
      $this->description = MODULE_BOXES_WHATS_NEW_SCROLLER_DESCRIPTION;

      if ( defined('MODULE_BOXES_WHATS_NEW_SCROLLER_STATUS') ) {
        $this->sort_order = MODULE_BOXES_WHATS_NEW_SCROLLER_SORT_ORDER;
        $this->enabled = (MODULE_BOXES_WHATS_NEW_SCROLLER_STATUS == 'True');

        $this->group = ((MODULE_BOXES_WHATS_NEW_SCROLLER_CONTENT_PLACEMENT == 'Left Column') ? 'boxes_column_left' : 'boxes_column_right');
      }
    }

    function execute() {
       global  $oscTemplate, $languages_id, $currencies, $valuein, $valueout;
         
 
          $wn_query = tep_db_query("  select p.products_id, pd.products_name, pd.products_description, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price, s.status from
" . TABLE_PRODUCTS . " p join " . TABLE_PRODUCTS_DESCRIPTION . " pd on pd.products_id = p.products_id left join " . TABLE_SPECIALS . " s on s.products_id = p.products_id where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int) $languages_id . "' order by p.products_date_added desc limit " . MAX_RANDOM_SELECT_NEW);
    
  if (tep_db_num_rows($wn_query)) {
      while ($randoms_product = tep_db_fetch_array($wn_query)) {
     $wn .= '<li>';
        if ($randoms_product['status'] == 1) {
              $p_price = '<s>' . $currencies->display_price($randoms_product['products_price'], tep_get_tax_rate($randoms_product['products_tax_class_id'])) . '</s> ';
              $p_price .= '<span class="productSpecialPrice">' . $currencies->display_price($randoms_product['specials_new_products_price'], tep_get_tax_rate($randoms_product['products_tax_class_id'])) . '</span>';
            } else {
              $p_price = $currencies->display_price($randoms_product['products_price'], tep_get_tax_rate($randoms_product['products_tax_class_id']));
            }

          
          $wn .= '<p class="text-center"><br /><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $randoms_product['products_id']) . '">' . $randoms_product['products_name'] . '</a></p>';
          
           $wn .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $randoms_product['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $randoms_product['products_image'], $randoms_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, NULL, NULL, 'img-responsive thumbnail') . '</a>';
          
         if(MODULE_BOXES_WHATS_NEW_SCROLLER_DESC != '0') {
         $wn .= '<p class="text-center">' . substr(strip_tags($randoms_product['products_description']), 0, MODULE_BOXES_WHATS_NEW_SCROLLER_DESC). '...<br /></p>';
         }
         $wn .= '<p class="text-center">' . $p_price . '</p>';

         $wn .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $randoms_product["products_id"]) . '">'.tep_image_button("button_details.gif").'</a>';

         $wn .= '<p class="text-center">' .tep_draw_button(SMALL_IMAGE_BUTTON_VIEW, '', tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $randoms_product["products_id"]), '', '', 'btn-success btn-sm') . '</p>';
         $wn .= '</li>';
         }

         $direction = MODULE_BOXES_WHATS_NEW_SCROLLER_DIRECTION;
         if($direction == 'up') {
         $valuein = '1';
         $valueout = '-1';
         }else{
         $valuein = '-1';
         $valueout = '1';
         }

         $wn .='<script src="ext/jquery/jquery.scroller.min.js"></script>';
         $wn .= '<script>$("#whats_new").scroller({ directionIn :' .$valuein .', directionOut:' .$valueout .', pause:' . MODULE_BOXES_WHATS_NEW_SCROLLER_DELAY. ', transition:'. MODULE_BOXES_WHATS_NEW_SCROLLER_SPEED .', height:' . MODULE_BOXES_WHATS_NEW_SCROLLER_HEIGHT .'});</script>';


          ob_start();
          include(DIR_WS_MODULES . 'boxes/templates/whats_new_scroller.php');
          $data = ob_get_clean();

          $oscTemplate->addBlock($data, $this->group);
        }
      }
   

    function isEnabled() {
       global $PHP_SELF;
       if($PHP_SELF !== 'products_new.php') {
      return $this->enabled;
    }
    }

    function check() {
      return defined('MODULE_BOXES_WHATS_NEW_SCROLLER_STATUS');
    }

    function install() {
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable What\'s New Module', 'MODULE_BOXES_WHATS_NEW_SCROLLER_STATUS', 'True', 'Do you want to add the module to your shop?', '6', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Content Placement', 'MODULE_BOXES_WHATS_NEW_SCROLLER_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', '6', '2', 'tep_cfg_select_option(array(\'Left Column\', \'Right Column\'), ', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_BOXES_WHATS_NEW_SCROLLER_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '3', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Scroll Direction', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DIRECTION', 'up', 'Change Scroller Direction', '6', '4', 'tep_cfg_select_option(array(\'up\', \'down\'), ',now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Scroller Height', 'MODULE_BOXES_WHATS_NEW_SCROLLER_HEIGHT', '260', 'Change Scroller Height, default: 260 px', '6', '5', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Scroller Transition Speed', 'MODULE_BOXES_WHATS_NEW_SCROLLER_SPEED', '1500', 'Change Scroller Transition Speed in ms, default: 1500 (Value MUST be smaller than Scroller Pause', '6', '6', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Scroller Pause', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DELAY', '2000', 'Change Scroller Pause in ms, default: 2000', '6', '7', now())");
      tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Description Length', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DESC', '20', 'Display part of products description, default: 50 (0 = No description)', '6', '8', now())");
    }

    function remove() {
      tep_db_query("delete from " . TABLE_CONFIGURATION . " where configuration_key in ('" . implode("', '", $this->keys()) . "')");
    }
    
    function keys() {
      return array('MODULE_BOXES_WHATS_NEW_SCROLLER_STATUS', 'MODULE_BOXES_WHATS_NEW_SCROLLER_CONTENT_PLACEMENT', 'MODULE_BOXES_WHATS_NEW_SCROLLER_SORT_ORDER', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DIRECTION', 'MODULE_BOXES_WHATS_NEW_SCROLLER_HEIGHT', 'MODULE_BOXES_WHATS_NEW_SCROLLER_SPEED', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DELAY', 'MODULE_BOXES_WHATS_NEW_SCROLLER_DESC');
    }
  }
?>

Line 56 is:

         $wn .= '<p class="text-center">' . substr(strip_tags($randoms_product['products_description']), 0, SCROLLER_DESC). '...<br /></p>';

must be:

   $wn .= '<p class="text-center">' . substr(strip_tags($randoms_product['products_description']), 0, MODULE_BOXES_WHATS_NEW_SCROLLER_DESC). '...<br /></p>';

jquery Scroll Box.zip

J.J.

grandpaj · January 20, 2015

@@De Dokta

Fantastic work. Now works great.

Are you looking to do the same to "Specials"

Cheers

Grandpa

De Dokta · January 20, 2015

@@grandpaj

Are you looking to do the same to "Specials"

I'll do my best, if I find the time! But why don't you try it yourself? Take the specials files from the contrib that Auzstar created and compare it with my new products files. Then you will see what to do. The difference is not that big.

J.J.

grandpaj · January 20, 2015

@@De Dokta

Hi JJ

Will have a go, and see what happens. Will let you know.

Also, with the new products shown in the scroller, can the number of products shown be increased, or how are the products shown, "selected" as on the index page I have 6 new products shown, but in the scroller it shows 10 and I would like to increase to say 20/30 random products.

Cheers

Grandpa

Edited January 20, 2015 by grandpaj

grandpaj · January 20, 2015

@@De Dokta

Also noticed in IE that the just above the "View" image button a wee x appears, Chrome is similar too. FF is OK

http://120.138.17.237/~grandp/index.php

Cheers

grandpa

De Dokta · January 20, 2015

@@grandpaj

Will have a go, and see what happens. Will let you know.

Also, with the new products shown in the scroller, can the number of products shown be increased, or how are the products shown, "selected" as on the index page I have 6 new products shown, but in the scroller it shows 10 and I would like to increase to say 20/30 random products.

Don't hesitate to ask if you have problems.. :)

The number of new products displayed in the scroller is defined by Admin -> Configuration -> Maximum Values -> Selection of Random New Products. To increase the number of products shown at the same time would mean to change the script or to write a new one :wacko: .......

J.J.

De Dokta · January 20, 2015

@@De Dokta

Also noticed in IE that the just above the "View" image button a wee x appears, Chrome is similar too. FF is OK

http://120.138.17.237/~grandp/index.php

Cheers

grandpa

You are right. Remove in bm_whats_new_scroller.php line 61:

         $wn .= '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $randoms_product["products_id"]) . '">'.tep_image_button("button_details.gif").'</a>';

I give it up for today! Seems that I'm too tired to bring about something reasonable... :blush:

auzStar · January 21, 2015

@@De Dokta

You can knock off now, next shift has arrived :)

I've investigated a way of doing it with bootstrap carousel. Still testing. Works OK in IE11 so far but not scrolling properly in Chrome. Still to check FF.

Might look at fade-in/out also as PupStar suggested.

auzStar · January 21, 2015

Hi guys,

I've created a new Specials box - fading version (file attached) - using bootstrap carousel, if you'd like to have a look at.

(Please remove any installed Specials/Specials Scroller boxes first via admin)

I've also created a Specials scrolling version, also using bootstrap carousel, but getting it to scroll vertically with some css. Tested OK in IE11, latest FF and latest Chrome but not scrolling too perfect in Chrome. In Chrome, the current display just disappears instead of easing out, otherwise all good. Tried a few things to fix but nothing worked. I'll post this code here for everyone to look at and possibly test to see if anyone can uncover what the issue is with Chrome.

Aim is to eventually package complete working versions that everyone is happy with, with the ability to choose between scroll or fade, for both What's New and Specials.

At the moment, neither have the extra options i.e. up/down for scrolling etc. It's a work in progress.

Below is the code for the bootstrap carousel "vertical scrolling" version for the Specials box. (The attached file is the fading version)

catalog\includes\languages\english\modules\boxes\bm_specials_scroller.php

<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2014 osCommerce

  Released under the GNU General Public License
*/

  define('MODULE_BOXES_SPECIALS_SCROLLER_TITLE', 'Specials Scroller');
  define('MODULE_BOXES_SPECIALS_SCROLLER_DESCRIPTION', 'Show specials scroll box<br />NOTE: Set maximum number of specials to display in scroll box in "admin->configuration->maximum values->Selection of Products on Special"');
  define('MODULE_BOXES_SPECIALS_SCROLLER_BOX_TITLE', 'Specials');

catalog\includes\modules\boxes\templates\specials_scroller.php

<div class="panel panel-default">
   <div class="panel-heading"><?php echo '<a href="' . tep_href_link('specials.php') . '">' . MODULE_BOXES_SPECIALS_SCROLLER_BOX_TITLE . '</a>'; ?></div>
    <div class="panel-body">
     <?php echo $sp; ?>
   </div>
</div>

catalog\includes\modules\boxes\bm_specials_scroller.php

<?php
/*
  $Id$

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2014 osCommerce

  Released under the GNU General Public License
*/

  class bm_specials_scroller {
    var $code = 'bm_specials_scroller';
    var $group = 'boxes';
    var $title;
    var $description;
    var $sort_order;
    var $enabled = false;

    function bm_specials_scroller() {
      $this->title = MODULE_BOXES_SPECIALS_SCROLLER_TITLE;
      $this->description = MODULE_BOXES_SPECIALS_SCROLLER_DESCRIPTION;

      if ( defined('MODULE_BOXES_SPECIALS_SCROLLER_STATUS') ) {
        $this->sort_order = MODULE_BOXES_SPECIALS_SCROLLER_SORT_ORDER;
        $this->enabled = (MODULE_BOXES_SPECIALS_SCROLLER_STATUS == 'True');

        $this->group = ((MODULE_BOXES_SPECIALS_SCROLLER_CONTENT_PLACEMENT == 'Left Column') ? 'boxes_column_left' : 'boxes_column_right');
      }
    }

    function execute() {
      global $languages_id, $currencies, $oscTemplate;

      $sp_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_price, p.products_tax_class_id, p.products_image, s.specials_new_products_price from products p, products_description pd, specials s where p.products_status = '1' and p.products_id = s.products_id and pd.products_id = s.products_id and pd.language_id = '" . (int)$languages_id . "' and s.status = '1' order by s.specials_date_added desc limit " . MAX_RANDOM_SELECT_SPECIALS);
      if (tep_db_num_rows($sp_query)) {

        $i = 0;
        $sp .= '<div class="carousel slide vertical">';
        $sp .= '<div class="carousel-inner">';
        while ($specials_product = tep_db_fetch_array($sp_query)) {

          $sp .= '<div class="' . ($i == 0 ? 'active ' : '') . 'item">';
          
          $sp .= '<p class="text-center"><a href="' . tep_href_link('product_info.php', 'products_id=' . $specials_product['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $specials_product['products_image'], $specials_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></p>';
          $sp .= '<p class="text-center"><a href="' . tep_href_link('product_info.php', 'products_id=' . $specials_product['products_id']) . '">' . $specials_product['products_name'] . '</a></p>';

          if(MODULE_BOXES_SPECIALS_SCROLLER_SHORT_DESCRIPTION != '0') {
            $sp .= '<p class="text-center">' .  substr(strip_tags($specials_product['products_description']), 0, MODULE_BOXES_SPECIALS_SCROLLER_SHORT_DESCRIPTION). '...<br /></p>';
          }

          $sp .= '<p class="text-center"><del>' . $currencies->display_price($specials_product['products_price'], tep_get_tax_rate($specials_product['products_tax_class_id'])) . '</del><br /> <span class="productSpecialPrice">' . $currencies->display_price($specials_product['specials_new_products_price'], tep_get_tax_rate($specials_product['products_tax_class_id'])) .'</p>';
          $sp .= '<p class="text-center">' .tep_draw_button(SMALL_IMAGE_BUTTON_VIEW, '', tep_href_link('product_info.php', 'products_id=' . $specials_product["products_id"]), '', '', 'btn-success btn-sm') . '</p>';

          $sp .= '</div>';
          
          $i++;

        }
        $sp .= '</div>';
        $sp .= '</div>';

        $sp .= '<script>$(document).ready(function(){$(".carousel").carousel();});</script>';

        ob_start();
        include(DIR_WS_MODULES . 'boxes/templates/specials_scroller.php');
        $data = ob_get_clean();

        $oscTemplate->addBlock($data, $this->group);
      }
    }

    function isEnabled() {
      global $PHP_SELF;
      if($PHP_SELF !== 'specials.php') {
        return $this->enabled;
      }
    }

    function check() {
      return defined('MODULE_BOXES_SPECIALS_SCROLLER_STATUS');
    }

    function install() {
      tep_db_query("insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Enable Specials Module', 'MODULE_BOXES_SPECIALS_SCROLLER_STATUS', 'True', 'Do you want to add the module to your shop?', '6', '1', 'tep_cfg_select_option(array(\'True\', \'False\'), ', now())");
      tep_db_query("insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Content Placement', 'MODULE_BOXES_SPECIALS_SCROLLER_CONTENT_PLACEMENT', 'Left Column', 'Should the module be loaded in the left or right column?', '6', '1', 'tep_cfg_select_option(array(\'Left Column\', \'Right Column\'), ', now())");
      tep_db_query("insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Description Length', 'MODULE_BOXES_SPECIALS_SCROLLER_SHORT_DESCRIPTION', '20', 'Display part of products description, default: 20 (0 = No description)', '6', '6', now())");
      tep_db_query("insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added) values ('Sort Order', 'MODULE_BOXES_SPECIALS_SCROLLER_SORT_ORDER', '0', 'Sort order of display. Lowest is displayed first.', '6', '2', now())");
    }

    function remove() {
      tep_db_query("delete from configuration where configuration_key in ('" . implode("', '", $this->keys()) . "')");
    }

    function keys() {
      return array('MODULE_BOXES_SPECIALS_SCROLLER_STATUS', 'MODULE_BOXES_SPECIALS_SCROLLER_CONTENT_PLACEMENT', 'MODULE_BOXES_SPECIALS_SCROLLER_SHORT_DESCRIPTION', 'MODULE_BOXES_SPECIALS_SCROLLER_SORT_ORDER');
    }
  }
?>

add the following css to the end of of your catalog\user.css

/******* start specials scroller ********/
.vertical .carousel-inner {
  height: 100%;
}

.carousel.vertical .item {
  -webkit-transition: 1s ease-in-out top;
     -moz-transition: 1s ease-in-out top;
      -ms-transition: 1s ease-in-out top;
       -o-transition: 1s ease-in-out top;
          transition: 1s ease-in-out top;
}

.carousel.vertical .active {
  top: 0;
}

.carousel.vertical .next {
  top: 400px;
}

.carousel.vertical .prev {
  top: -400px;
}

.carousel.vertical .next.left,
.carousel.vertical .prev.right {
  top: 0;
}

.carousel.vertical .active.left {
  top: -400px;
}

.carousel.vertical .active.right {
  top: 400px;
}

.carousel.vertical .item {
    left: 0;
}
/******** end specials scroller ********/

Scroll box fade.zip

Edited January 21, 2015 by auzStar

root123 · January 21, 2015

@auzStar, and @

i installed what's new_scroller.php but it do not show any scroll , what is my problem? it shows only the products , no scrolling products seen...?

thanks again ...?

auzStar · January 22, 2015

i installed what's new_scroller.php but it do not show any scroll , what is my problem? it shows only the products , no scrolling products seen...?

thanks again ...?

@@root123

Benjamin. Is this De Dokta's one above or the one from the add-ons? If it's De Dokta's one, make sure you followed all the steps. Did you create the new ext/jquery/jquery.scroller.min.js from De Dokta's post (8) above? Maybe that's the reason why it's not scrolling.

Make sure you always remove existing modules in admin before you upload new files (backup existing files first), then install new module.

Also, have you tried the new Specials fading version?

root123 · January 22, 2015

@auzStar

i have followed all the steps for sure, i tried removing and installing the module again again... i dont know why still it is same...no scrolling , it simply display all the products to the left side...!

auzStar · January 22, 2015

@@root123

I just tested and works OK. Did you download the second file "jquery Scroll Box.zip" at post 11 and then apply the fix at post 17?

Silly question, but I have to ask...is javascript enabled in your browser?

Maybe try clearing you browser cache a couple of times and reloading the page.

auzStar · January 29, 2015

@@De Dokta

Hi Doc,

I saw that you recently added a new bs package to the "Scroll Boxes" addon (replace scrolling marquee with js scroller): http://addons.oscommerce.com/info/8065

d'oh! :(

I was also about to add a new bs package which I'd been working on but this one uses bootstrap carousel with the ability to enable swipe feature. Has a few options to enable/disable various other features. The bs version is ready and have almost completed updating the non-bs version with the js scroller since I thought I would be a good idea to remove the marquee scroller from there also. I thought the swipe feature would be a good idea for the bs version for use on mobile devices.

I hope you don't mind if I add this new package for both versions, or do you want a test run first?

cheers

De Dokta · January 29, 2015

@@auzStar

Hi Dom

No problem! Just upload it - if you've tested it yourself, that's quite enough! If there are multiple versions, the users have the freedom to choose what they prefer. :rolleyes:

J.J.

Old addon do not fit with osc2.3.4BS

Recommended Posts

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Share this post

Link to post

Share on other sites

Create an account or sign in to comment

Create an account

Sign in