vBulletin CMS Widgets - United-Forum Nivo Slider Widget

Based on the Nivo Slider - all credit for slider awesomeness goes to them.
vB4 implementation goes to me.


What it is:
A slider for cms articles, it gets the articles via database, uses (if possible) the previewimage there and resizes it to slider size *update 1.1.0 cropping function included.

Livedemo on a Big Board (>2.000.000 posts)
the nivo slider on our site is customized to fit our heavily customized cms. Default look of this addon is shown in the picture below


facts about the nivo slider

Originally Posted by nivo slider homepage

- ~ 600.000 downloads
- 16 transition effects
- a ton of options
- different available themes
- ...

Installation

• upload all files (attached zip file) in the folder where you do need them - this has to be the same folder you will set via $slider_img_filepath (see picture)
  
  
  
• create a new php-widget and insert the following code:
  

  // DEBUG MODUS !
  $debug_modus = false;
  
  if($debug_modus === false)
  {
  	ob_start();
  }
  
  //nivo slider - uf - vb.org version
  //set these values as you need them:
  
  //your slider folder - has to be read and writeable
  //folder where all slider files are saved
  $slider_img_filepath = 'external/unitedforum/slider/';   
  
  //picture width and height !same as in the CSS FILE!
  $maxwidth = 650;                                  
  $maxheight = 250;    
  
  //do you want images without previewimage to be shown? slider is using the fallback then
  $show_articles_without_image = false;           
  
  //picture shown if your articles has no previewpicture
  $fallback_img = $slider_img_filepath . 'uf_fallback_slider.png';  
  
  //hardcoded maximum is 20 - if you want more just ask
  $number_of_articles_shown = 10;                                
              
  //lengh in characters of the article descriptions
  $description_length = 95;
  
  //stretch picture or crop them? false = strechting (default) true = cropping (beta)
  $crop = false;
  
  
  //Debug Messages
  if($debug_modus)
  {
  	echo "<span style='color:red;'>DEBUG MODE is ON! </span><br />";
  	echo "slider_img_filepath: $slider_img_filepath <br />";
  	echo "width: $maxwidth   height: $maxheight <br />";
  	echo "Strech or Crop? $crop <br />";
  	echo "show_articles_without_image: "; 
          var_dump($show_articles_without_image); 
          echo " <br />";
  	echo "fallback_img: $fallback_img <br />";
  	echo "#img: $number_of_articles_shown <br />";
  	echo "description_length: $description_length <br />";
  	echo 'directory ' . DIR . '<br />';
  
  }
  
  
  
  
  $article_type = vb_Types::instance()->getContentTypeID("vBCms_Article");
  $time = TIMENOW;
   
  if(!extension_loaded('gd'))
  {
  	echo '<span style="color:red">Error occurred:</span> Your System does not support the GD-Libary. Please install the GD-Libary.<br />';
  }
         
  	$article_get = vB::$db->query_read('
          SELECT
              article.pagetext,
              article.previewimage,
              node.url,
              node.publishdate,
              node.parentnode,
              parentnode.url AS parenturl,
              thread.replycount,
              info.title,
              node.nodeid,            
              GROUP_CONCAT( category.category )
          FROM
              '.TABLE_PREFIX.'cms_article AS article INNER JOIN
              '.TABLE_PREFIX.'cms_node AS node 
                  ON (node.contentid = article.contentid AND node.contenttypeid = ' . vb::$db->sql_prepare($article_type) .') INNER JOIN
              '.TABLE_PREFIX.'cms_nodeinfo AS info 
                  ON info.nodeid = node.nodeid INNER JOIN
              '.TABLE_PREFIX.'cms_node AS parentnode 
                  ON parentnode.nodeid = node.parentnode LEFT JOIN
              '.TABLE_PREFIX.'thread AS thread ON thread.threadid = info.associatedthreadid LEFT JOIN
              '.TABLE_PREFIX.'cms_nodecategory AS nodecategory ON nodecategory.nodeid = node.nodeid LEFT JOIN
              '.TABLE_PREFIX.'cms_category AS category ON nodecategory.categoryid = category.categoryid 
          WHERE
              node.setpublish = 1 AND
              node.publishdate > '. vb::$db->sql_prepare($time) .' -34560000 AND
  			node.publishdate < '. vb::$db->sql_prepare($time) .' 
          GROUP BY node.nodeid
          ORDER BY node.publishdate
          DESC LIMIT 20');
  
      $database_articles = array();
      
      /* my version of sorting the articles via relevance - i'll keep it in case someone is interested*/
      while($article = vB::$db->fetch_array($article_get))
      {
          $article['value'] = ( 5 - ($time - $article['publishdate'] ) / 86400 ) * ( 5 - ($time - $article['publishdate'] ) / 86400 ) * ( 5 - ($time - $article['publishdate'] ) / 86400 ) + (10 * $article['replycount']);
          $database_articles[] = $article;        
      }
      
      foreach($database_articles as $c => $key)
      {
          $sort_value[] = $key['value'];
      }
      
      array_multisort($sort_value, SORT_DESC, $database_articles);    
      
      //
      $i = 0;
      $section_array = array();
      $featured_articles = array();
  	
      foreach($database_articles AS $article)
      {
          $section_array[$article['parentnode']]++;
  
          $categories = explode(',' , $article['GROUP_CONCAT( category.category )']);
       
          if($show_articles_without_image == true OR $article['previewimage'])
          {
              if($section_array[$article['parentnode']] < 50 AND $i < $number_of_articles_shown)
              {
  				if($debug_modus == true OR !file_exists($slider_img_filepath . 'slide_' . $article['nodeid'] . '.jpg'))
  				{
  					//rebuild image to the height and width we want in the slider 
  					//called sprite since i got the code from our sprite addon :P
  					$sprite = imagecreatetruecolor($maxwidth, $maxheight);
  					if(is_resource($sprite) AND $article['previewimage'] )
  					{                   				
  						$imageinfo = getimagesize($article['previewimage']);
  						if(is_array($imageinfo))
  						{   
  							$image = null;
  							switch($imageinfo[2])
  							{
  								case IMAGETYPE_PNG:
  								$image = imagecreatefrompng($article['previewimage']);
  								break;
  								case IMAGETYPE_GIF:
  								$image = imagecreatefromgif($article['previewimage']);
  								break;
  								case IMAGETYPE_JPEG:
  								$image = imagecreatefromjpeg($article['previewimage']);
  								break;
  								default:
  								echo '<span style="color:red">Error occurred:</span> Unknown image format. ' . $article['previewimage']. '<br />';
  								break;                        
  							}
  							
  							if(!is_resource($image))
  							{
  								//resiziing did not work - we are using the fallback image.
  								echo '<span style="color:red">Error occurred:</span> imagecreation failed. ' . $article['previewimage']. '<br />';
  								$article['previewimage'] = $fallback_img;
  							}
  							else
  							{
  								$img_width = $imageinfo[0];
  								$img_height = $imageinfo[1];							
  								
  								if($crop == false)
  								{									
  									imagecopyresampled($sprite, $image, 0, 0, 0, 0, $maxwidth, $maxheight, $img_width, $img_height );
  									imagedestroy($image);
  								}
  								else
  								{
  									//cropping
  									$ratiox = $maxheight / $img_height ;
  									$ratioy = $maxwidth / $img_width ;
  									$new_height = $img_height;
  									$new_width = $img_width;
  									
  									if ($maxheight > $img_height OR $maxwidth > $img_width)
  									{
  										if($ratiox > $ratioy)
  										{
  											$new_height = round($img_height * $ratiox);
  											$new_width = round($img_width * $ratiox);
  										}
  										else
  										{
  											$new_height = round($img_height * $ratioy);
  											$new_width = round($img_width * $ratioy);
  										}										
  									}
  									$cropx = $new_height - $maxheight;
  									$cropy = $new_width - $maxwidth;
  									
  									imagecopyresampled($sprite, $image, 0, 0, 0, 0, $new_width, $new_height, $img_width, $img_height);
  									imagedestroy($image);
  									
  								}
  								
  								
  								$img_filepath = $slider_img_filepath . 'slide_' . $article['nodeid'] . '.jpg';
  								$success = imagejpeg($sprite, DIR  . ($img_filepath[0] != DIRECTORY_SEPARATOR ?  DIRECTORY_SEPARATOR : '') . $img_filepath);
  								imagedestroy($sprite);
  								if($success)
  								{
  									$article['previewimage'] = $img_filepath;
  								}
  								else
  								{
  									$img_filepath = DIR  . ($img_filepath[0] != DIRECTORY_SEPARATOR ?  DIRECTORY_SEPARATOR : '') . $img_filepath;
  									echo '<span style="color:red">Error occurred:</span> imagejpeg failed. ' . $article['previewimage']. '<br />
  									directory: '. $img_filepath ;
  									
  									$article['previewimage'] = $fallback_img;
  								}
  							}
  							
  						}
  						else
  						{
  							//resiziing did not work - we are using the fallback image.
  							echo '<span style="color:red">Error occurred:</span> picture is not readable.' . $article['previewimage']. '<br /> ';
  							$article['previewimage'] = $fallback_img;
  						}                  
  					}
  					else
  					{
  						//resiziing did not work - we are using the fallback image.
  						echo '<span style="color:red">Warning:</span> article has no previewimage or sprite is no ressource. ' . $article['previewimage']. '<br />';
  						$article['previewimage'] = $fallback_img;
  					}
  				}
  				else
  				{
  					//we already have the image, no need to resize or crop anything
  					$article['previewimage'] = $slider_img_filepath . 'slide_' . $article['nodeid'] . '.jpg';
  				}
  
                  /*remove everything from the previewtext - html and bb. I do not want bold or colored text there. Cut to a decent length.*/        
                  $article['pagetext'] = strip_bbcode($article['pagetext'], true, true, false, true, false);
  
                  $article['previewtext'] = strip_tags($article['pagetext'], '<a>');
                      
                  $len = $description_length;
                  if ( strlen($article['previewtext']) > $len )
                  {                    
                      $article['previewtext'] = substr( $article['previewtext'] , 0 , strrpos( substr( $article['previewtext'], 0, $len), ' ' ));
                  }   
  
                  $i++;
                  //Build Array
                  $article_neu = array();
                  $article_neu['description'] = '<h2 style="font-weight:bold; font-size: 14px">'. $article['title'].'</h2><span>'. $article['previewtext'] .'</span> <a href="/content.php?r=' . $article['nodeid'] . '-' . $article['url'] . '">read on</a>';
                  $article_neu['htmlcaptionname'] = 'htmlcaption' . $article['nodeid'] ;
                  $article_neu['picture'] = '<a href="/content.php?r=' . $article['nodeid'] . '-' . $article['url'] . '"><img src="'.$article['previewimage'].'" alt="" title="#htmlcaption'. $article['nodeid'] . '" /></a>';
                  
                  $featured_articles[] = $article_neu;
              }
          }
      }
      
      //Randomize Array
      //shuffle($featured_articles);
  
  	//Debug Messages
  	if($debug_modus)
  	{
  		echo '#articles - featured and databasepull ';
  		var_dump(count($featured_articles));
  		var_dump(count($database_articles));
  	}
  
      
  $output_bits = '
      <link rel="stylesheet" href="' .$slider_img_filepath. 'nivo-slider.css" type="text/css" media="screen" />
      <link rel="stylesheet" href="' .$slider_img_filepath. 'nivo-slider_uf_theme.css" type="text/css" media="screen" />
      <div style="height:' . $maxheight . 'px;">
      <div id="wrapper">
          <div class="slider-wrapper theme-uf">
              <div class="ribbon"></div>
              <div id="slider" class="nivoSlider">';
              
                  foreach($featured_articles AS $article)
                  {
                      $output_bits .= $article['picture'];
                  }
              $output_bits .= '
              </div>';
              
              foreach($featured_articles AS $article)
              {
                  $output_bits .= '<div id="' . $article['htmlcaptionname'] . '" class="nivo-html-caption">' . $article['description'] .'</div>';
              }
              
              $output_bits .= '         
          </div>
  
      </div>
      <script type="text/javascript" src="' .$slider_img_filepath. 'jquery-1.6.1.min.js"></script>
      <script type="text/javascript" src="' .$slider_img_filepath. 'jquery.nivo.slider.pack.js"></script>
      <script type="text/javascript">
      $(window).load(function() {
          $("#slider").nivoSlider();
      });
      </script>
      </div>
      ';
          $output = $output_bits;
   
  if($debug_modus === false)
  {
  	ob_end_clean();        
  }

• set refresh time to something big!
• save - add the widget to your layout - enjoy

Custom settings:

At the top of the php-widget code you can see the following:

// DEBUG MODUS !
$debug_modus = false;

if($debug_modus === false)
{
	ob_start();
}

//nivo slider - uf - vb.org version
//set these values as you need them:

//your slider folder - has to be read and writeable
//folder where all slider files are saved
$slider_img_filepath = 'external/unitedforum/slider/';   

//picture width and height !same as in the CSS FILE!
$maxwidth = 650;                                  
$maxheight = 250;    

//do you want images without previewimage to be shown? slider is using the fallback then
$show_articles_without_image = false;           

//picture shown if your articles has no previewpicture
$fallback_img = $slider_img_filepath . 'uf_fallback_slider.png';  

//hardcoded maximum is 20 - if you want more just ask
$number_of_articles_shown = 5;                                
            
//lengh in characters of the article descriptions
$description_length = 95;

If you change $maxwidth and $maxheight you need to edit the nivo-slider_uf_theme.css file, here:

.theme-uf #slider {
    margin:0px auto 0 auto;
    width:650px; /* Make sure your images are the same size */
    height:250px; /* Make sure your images are the same size */
}

Width and height have to be the same value in your php-widget and in the css file.

In additon to these settings i also included a "value/relevance function". Meaning the slider doesn't show your latest 5 articles, but instead weights them based on age and comments.

As older an article is the less likely it will show up in the slider.
More comments make it more likely.

This behaviour can be easily changed. I didn't include an if condition cause every board has different needs and i don't know whats best for you.
In addition conditions like "articles just from this section - or these sections, or this category, with a minimum of 10 posts" can be included via one single if condition. Again, i don't know what your board needs or what your category names are.

You can also modify the preview length (more words, less words), the preview style (color fontsize, fontweight .... Again different forums different needs. It's highly customizable.

Support:

Support and requests for the slider itself should be asked here http://nivo.dev7studios.com/
Same goes for different slider themes - a lot is possible, even thumbnails - again this is part of the nivo slider and not the vb4 implementation.

If you have any questions regarding the settings - or want different settings (which have to do with vb4) - ask, and i'll try to come up with some code // show you where you have to put what.

Slider not working. No idea why?

You will find a FAQ in the first comment, which will be kept up to date:
FAQ

The widget here is completely free. No charge, no branding.
But, we do not mind donations either. If you want to give us something. Since we are advertising free and fan based we are happy about every small donation.
( On Forumhome bottom right paypal button: http://www.united-forum.de/forum.php )



That's all
Hope it works for you.
Regards Mooff

[Aramist]

Works Fine !!

Ty again Dude !

Cya

[The Rocketeer]

great work on the slider Moof. thank you very much. I have been following the topic since my original post back at the slider request fund gathering topic.

anyhow, i had some questions and suggestions.

1. Are we able to select which articles to display on the slider? maybe have an option in the acp or somewhere so we can just enter the article numbers / ids / urls and it will go get them?

2. Also maybe you could try to enhance it a bit? make it faster and lite so it doesn't end up slowing down our forums(not that it does that but just a suggestion.)

3. Lets say the first image is a verticle rectangle instead of the horizontal one. lets say my articles first image is 200px wide and 500px high but my second image is ideal, 600px wide x 400px high. Can we program it to fetch the second image instead(if the first one is too small and if a second one exists and is bigger / proper size?)

these are some of the many things i wanted to ask and suggest, i hope you'd have a look through them all.

[Mooff]

thanks


1.
Yes, that is possible. Actually this is kinda running on our board. We are using a hybrid system where a) a maximum of 2 articles per section are added into the slider b) tournaments (from our self coded tournament system) gain a value-bonus c) an extra query in a special database checks whether the article should be in there definitely or not at all d) articles are not allowed to be older than 40 days. All points are interconnected via the value function and it probably will be extended if the vbseo like system we activated today is used sensible by our users.

What a board needs there is highly dependend on the board itself. So i won't add something like this as default behaviour. In addition if you just want 'those' articles and nothing else the database query can be optimized for that need.

Long story short, as said in the first topic. If someone wants a customized query i need to know what exactly they want and i can try to come up with some code for it. No promises though. =) (these special queries will then be linked in the FAQ in post two, a category based one is allready in there, so as a work around you could use that one and add the articles you need in there, or remove them when the time comes for that).


2. The slider is blazing IF it can load all data out of the cms cache system - and i can't speed that one up*. Running the database query and saving pictures and rebuilding the output is not that fast. But, that does not have to be done often. Considering point 1, you want only articles in there which you specify in the code, you don't need it to update at all. So set the cache time for the slider to over 9000 (well or more). And rebuild it (clear cms cache) every time you change the article ids.


3. As for preview pictures. I won't comment on that one until i know what vbulletin changed in 4.1.5 (jira said they are doing something to preview pictures).


*well not in this addon anyway

[The Rocketeer]

Originally Posted by Mooff

thanks


1.
Yes, that is possible. Actually this is kinda running on our board. We are using a hybrid system where a) a maximum of 2 articles per section are added into the slider b) tournaments (from our self coded tournament system) gain a value-bonus c) an extra query in a special database checks whether the article should be in there definitely or not at all d) articles are not allowed to be older than 40 days. All points are interconnected via the value function and it probably will be extended if the vbseo like system we activated today is used sensible by our users.

What a board needs there is highly dependend on the board itself. So i won't add something like this as default behaviour. In addition if you just want 'those' articles and nothing else the database query can be optimized for that need.

Long story short, as said in the first topic. If someone wants a customized query i need to know what exactly they want and i can try to come up with some code for it. No promises though. =) (these special queries will then be linked in the FAQ in post two, a category based one is allready in there, so as a work around you could use that one and add the articles you need in there, or remove them when the time comes for that).


2. The slider is blazing IF it can load all data out of the cms cache system - and i can't speed that one up*. Running the database query and saving pictures and rebuilding the output is not that fast. But, that does not have to be done often. Considering point 1, you want only articles in there which you specify in the code, you don't need it to update at all. So set the cache time for the slider to over 9000 (well or more). And rebuild it (clear cms cache) every time you change the article ids.


3. As for preview pictures. I won't comment on that one until i know what vbulletin changed in 4.1.5 (jira said they are doing something to preview pictures).


*well not in this addon anyway

Thanks Mooff,


1. So yes, as for the customized query, What I am wanting is not a category based one but maybe an option with a YEs / No and a box somewhere in the Admin CP so we can login and click that option, set it to yes(?) and enter article ID's numbers with commas (,) eg, 178,162,78 and it will only show those articles.

2. Yes, exactly, I want to spesify the articles that should be displayed on the slider, so I dont need it to automatically update anything as I will probably do it myself once every couple of weeks depending on which article I want to feature. So some instructions on that would be great, as we can probably cut down some database querys etc.

3. No proiblem we will see that later on,

But at the moment the first and second feature is what I and a lot of others could really use to define what articles we want to display manually. Hope you can look into it and post some instructions on your second post / F.A.Q for us. Really looking forward to this, so please let me know or if I sounded a bit confusing.

Thanks again and do let me know

[The Rocketeer]

I'm getting this error Mooff

// DEBUG MODUS ! $debug_modus = false; if($debug_modus === false)  '

[Mooff]

On first glance it looks like you are using the wrong widget type. Html static instead of php execute.

Please check (or create a new widget) from type php execution and insert the code again.

[The Rocketeer]

Thanks, Looks like I missed that one. Seems to be okay now, But its using the fallback image, its not pulling images from the articles? something I missed ? (Sorry, but I cant seem to get much help from the FAQ I am afraid.)

[Mooff]

Last question. :P

Q: My question wasn't answered in this FAQ
A: Please set the slider into debug mode via $debug_modus = true;
You then should see debug messages, which might point you in the right direction.
If that doesn't help. Post in the thread and please provide above debug and very detailed information what doesn't work and what you want.


Debug will help me a great deal finding out what's amiss.


As for the specific articles. I will rewrite the query to account for that, basecially i know what to do, but i can't type that out of my head and give it to you untested. Should find some time during the next days for that.

[The Rocketeer]

Hahaha lol

looks like I missed that one too, here is the debug code I got..

DEBUG MODE is ON! 
slider_img_filepath: public_html/frontpage_nivo_slider/ 
width: 650 height: 250 
show_articles_without_image: 
fallback_img: public_html/frontpage_nivo_slider/uf_fallback_slider.png 
#img: 5 
description_length: 95 

Warning: imagejpeg() [function.imagejpeg]: Unable to open '[path]/public_html/frontpage_nivo_slider/slide_0.jpg' for writing: No such file or directory in [path]/packages/vbcms/widget/execphp.php(191) : eval()'d code on line 165

[Mooff]

The folder public_html/frontpage_nivo_slider/ is not writeable for the user/group your webserver is in.

chmod777 that directory and it should work.