Scrolling thumnails in Box below Navigation

  • I normally try to solve these issues on my own. I am not natively a programmer so it has been a learning process (as this is my second WP page).

    My link is https://guidedoutdoortrips.com/

    What I am trying to do is to get thumbnails to scroll across the blue box below the navigation links. I believe there is supposed to be a built-in function in the theme to do this but for some reason it is not working (not registering the products or whatever). I either would like to get that to work or set up something else that can scroll through thumbails that link to these 3 pages:
    https://guidedoutdoortrips.com/packages/canyoneering/
    https://guidedoutdoortrips.com/store/packages/rock-climbing/
    https://guidedoutdoortrips.com/store/packages/hike-adventure/

    I know this would probably take like 2 minutes for someone that knows what they are doing; it definitely is a frustrating learning curve!

    Here is header

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "https://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="https://www.w3.org/1999/xhtml">

<head profile="https://gmpg.org/xfn/11">
	<meta http-equiv="Content-Type" content="<?php bloginfo('html_type'); ?>; charset=<?php bloginfo('charset'); ?>" />

	<title><?php bloginfo('name'); ?><?php wp_title(); ?></title>

	<meta name="generator" content="WordPress <?php bloginfo('version'); ?>" />
    <link id="page_favicon" href="<?php bloginfo('template_url'); ?>/img/favicon.ico" rel="icon" type="image/x-icon" />

	<link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="<?php bloginfo('rss2_url'); ?>" />
	<link rel="alternate" type="text/xml" title="RSS .92" href="<?php bloginfo('rss_url'); ?>" />

	<link rel="pingback" href="<?php bloginfo('pingback_url'); ?>" />

	<?php wp_head(); ?>

	<style type="text/css" media="screen">
		@import url( <?php bloginfo('stylesheet_url'); ?> );
		<?php
		if ($_GET['category'] == ''){
		?>

		strong.cattitles {display:none;	z-index:1;}
	<?php } ?>
	</style>

</head>

<body>
<div id="wrapper">

<div id="header">
<div id="header_top">
<div id="logo"><h1><a href="<?php bloginfo('url'); ?>" title="Home"><span><?php bloginfo('name'); ?></span></a></h1></div>
<div id="nav">
<ul>

			<?php wp_list_pages('title_li=&depth=2'); ?>
		</ul>
</div>
</div>
<div id="header_middle">
<div id="latestbox">

<div id="latestproducts">
<span class="title"><img src="<?php bloginfo('template_url'); ?>/img/latest2.gif" /></span>
<ul>
<?php display_latest_products(3); ?>
</ul>
</div>

<div id="storedesc">
<div class="box">
	<h2><?php bloginfo('name'); ?></h2>
	<p><?php bloginfo('description'); ?></p>
</div>
</div>

</div>
</div>
<div id="header_bottom">

<ul id="categories">
<?php show_cats(1); ?>
</ul>

<div id="search">
<?php get_search_form(); ?>
</div>
</div>
</div>

    and the Main Index Template

    <?php
get_header();
?>

<div id="content">

<div id="homepage_products">
<span class="title"><img src="<?php bloginfo('template_url'); ?>/img/new.gif" /></span>
<ul>
<?php display_homepage_products(4); ?>
</ul>
</div>
</div>
<?php get_sidebar(); ?>
<?php get_footer(); ?>

Viewing 2 replies - 1 through 2 (of 2 total)
  • Thread Starter cmarcus86

    (@cmarcus86)

    anyone have any ideas of how to edit that box? or put another scrolling image with links overtop of it?

    Thread Starter cmarcus86

    (@cmarcus86)

    functions.php file

    <?php

if ( function_exists('register_sidebar') )
	register_sidebar(array(
		'before_widget' => '<li id="%1$s" class="widget %2$s">',
		'after_widget' => '</li>',
		'before_title' => '',
		'after_title' => '',
	));

function show_brands($id){

    global $wpdb;

    $sidebar_brands = $wpdb->get_results("SELECT * FROM <code>&quot;.WPSC_TABLE_PRODUCT_CATEGORIES.&quot;</code> WHERE group_id =".$id." AND Active = 1 LIMIT 0 , 30",ARRAY_A);
    $output = "";
    $i = 1 ;

    if($sidebar_brands != null){

      foreach($sidebar_brands as $sidebar_brand) {

       $output .= "<li class='sidebar_brand".$i."'><a href='".wpsc_category_url($sidebar_brand['id'])."' />".$sidebar_brand['name']."</a></li>";

       $i++;

       }
      }
     echo $output;

    }	

    function show_cats($id){

    global $wpdb;

    $header_cats = $wpdb->get_results("SELECT * FROM <code>&quot;.WPSC_TABLE_PRODUCT_CATEGORIES.&quot;</code> WHERE group_id =".$id." AND Active = 1 LIMIT 0 , 30",ARRAY_A);
    $output = "";
    $i = 1 ;

    if($header_cats != null){

      foreach($header_cats as $header_cat) {

       $output .= "<li class='header_cat".$i."'><a href='".wpsc_category_url($header_cat['id'])."' />".$header_cat['name']."</a></li>";

       $i++;

       }
      }
     echo $output;

    }	

    function display_top_products(){
    global $wpdb;

	$top_products_ids = $wpdb->get_results("SELECT * FROM <code>&quot;.WPSC_TABLE_PRODUCT_CATEGORIES.&quot;</code> WHERE name = 'top products' LIMIT 0 , 30" ,ARRAY_A);
	if($top_products_ids != null){
	foreach($top_products_ids as $top_products_id) {
	$id = $top_products_id['id'];
	}
	}else{
	$id = '';
	}

    $top_products = $wpdb->get_results("SELECT <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.id AS Pid, <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.name AS Pname FROM <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code> INNER JOIN <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code> ON <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.id = <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code>.product_id AND <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code>.category_id = ".$id." And <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.active = 1  LIMIT 5",ARRAY_A);
    $output = "";
    $i = 1 ;

    if($top_products != null){

      foreach($top_products as $top_product) {

       $output .= "<li class='top_product".$i."'><a href='".wpsc_product_url($top_product['Pid'])."' />".$top_product['Pname']."</a></li>";

       $i++;

       }
      }
     echo $output;
    }

    function display_latest_products(){
    global $wpdb;

    $latest_products_ids = $wpdb->get_results("SELECT * FROM <code>&quot;.WPSC_TABLE_PRODUCT_CATEGORIES.&quot;</code> WHERE name = 'latest products' LIMIT 0 , 30" ,ARRAY_A);

    if($latest_products_ids != null){
	foreach($latest_products_ids as $latest_products_id) {
	$id = $latest_products_id['id'];
	}
	}else{
	$id = '';
	}

    $latest_products = $wpdb->get_results("SELECT <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.id AS Pid, <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.name AS Pname, <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.price AS Pprice,<code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.special_price AS Pspecial_price,<code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.notax AS Pnotax  FROM <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code> INNER JOIN <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code> ON <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.id = <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code>.product_id AND <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code>.category_id = ".$id." And <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.active = 1 LIMIT 4",ARRAY_A);

    if(get_option('permalink_structure') != '') {
    $seperator ="?";
	} else {
		$seperator ="&";
	}

    $output = "";

    if($latest_products != null){

      foreach($latest_products as $latest_product) {
      		$product_image_id = $wpdb->get_row("SELECT id FROM <code>&quot;.WPSC_TABLE_PRODUCT_IMAGES.&quot;</code> WHERE product_id = ".$latest_product['Pid']." order by id desc LIMIT 1 " ,ARRAY_A);

      		$image_id = $product_image_id['id'];

      	$output .= "<li class='latest_product'>";
       		$output .= "<form id='product_".$latest_product['Pid']."' name='product_".$latest_product['Pid']."' method='post' action='".get_option('product_list_url').$seperator."category=".$_GET['category']."' enctype='multipart/form-data'' class=''product_form' onsubmit='submitform(this);return false;'>";
					$output .= "<input type='hidden' name='wpsc_ajax_action' value='add_to_cart'/>
";
					$output .= "<input type='hidden' name='product_id' value='".$latest_product['Pid']."' />";
       $output .= "<a href='".wpsc_product_url($latest_product['Pid'])."' /><img class='product_image' src='index.php?image_id=".$image_id."&width=118&height=118' title='".$latest_product['Pname']."' alt='".$latest_product['Pname']."' /></a><br />\n\r";
       $output .= "<div class='product_info'><a href='".wpsc_product_url($latest_product['Pid'])."' />".$latest_product['Pname']."</a><br />";
	   $output .= nzshpcrt_currency_display(($latest_product['Pprice'] - $latest_product['Pspecial_price']), $latest_product['Pnotax'],false,$latest_product['Pid']);
	   $output .= "</div><input type='submit' id='product_".$latest_product['Pid']."_submit_button' class='wpsc_buy_button' name='Buy' value='".TXT_WPSC_ADDTOCART."'  />";

	   $output .= "</li></form>";

       }
      }
     echo $output;
    }

    function display_homepage_products(){
    global $wpdb;

    $homepage_products_ids = $wpdb->get_results("SELECT * FROM <code>&quot;.WPSC_TABLE_PRODUCT_CATEGORIES.&quot;</code> WHERE name = 'homepage products' LIMIT 0 , 30" ,ARRAY_A);

    if($homepage_products_ids != null){
	foreach($homepage_products_ids as $homepage_products_id) {
	$id = $homepage_products_id['id'];
	}
	}else{
	$id = '';
	}

    $homepage_products = $wpdb->get_results("SELECT <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.id AS Pid, <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.name AS Pname, <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.price AS Pprice,<code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.special_price AS Pspecial_price,<code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.notax AS Pnotax  FROM <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code> INNER JOIN <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code> ON <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.id = <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code>.product_id AND <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code>.category_id = ".$id." And <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.active = 1  ORDER BY RAND() LIMIT 12",ARRAY_A);

    if(get_option('permalink_structure') != '') {
    $seperator ="?";
	} else {
		$seperator ="&";
	}

    $output = "";

    if($homepage_products != null){

      foreach($homepage_products as $homepage_product) {
      	$Pid = $homepage_product['Pid'];
      	$product_image_id = $wpdb->get_row("SELECT id FROM <code>&quot;.WPSC_TABLE_PRODUCT_IMAGES.&quot;</code> WHERE product_id = ".$homepage_product['Pid']." order by id desc LIMIT 1 " ,ARRAY_A);

      		$image_id = $product_image_id['id'];

       $output .= "<li class='homepage_product'>";
       	$output .= "<form id='product_".$homepage_product['Pid']."' name='product_".$homepage_product['Pid']."' method='post' action='".get_option('product_list_url').$seperator."category=".$_GET['category']."' enctype='multipart/form-data'' class=''product_form' onsubmit='submitform(this);return false;'>";
					$output .= "<input type='hidden' name='wpsc_ajax_action' value='add_to_cart'/>
";
					$output .= "<input type='hidden' name='product_id' value='".$homepage_product['Pid']."' />";
       $output .= "<a href='".wpsc_product_url($homepage_product['Pid'])."' /><img class='product_image' src='index.php?image_id=".$image_id."&width=118&height=118' title='".$homepage_product['Pname']."' alt='".$homepage_product['Pname']."' /></a><br />\n\r";
       $output .= "<div class='product_info'><a href='".wpsc_product_url($homepage_product['Pid'])."' />".$homepage_product['Pname']."</a><br />";
	   $output .= nzshpcrt_currency_display(($homepage_product['Pprice'] - $homepage_product['Pspecial_price']), $homepage_product['Pnotax'],false,$homepage_product['Pid']);
	   $output .= "</div><input type='submit' id='product_".$homepage_product['Pid']."_submit_button' class='wpsc_buy_button' name='Buy' value='".TXT_WPSC_ADDTOCART."'  />";

	   $output .= "</li></form>";

       }
      }
     echo $output;
    }

    function display_more_products(){
    global $wpdb;

    if ($_GET['category'] == ''){

	$id = 1;

	}else{
	$id = $_GET['category'];
	}

	if ($_GET['product_id'] == ''){

	$product_id = 1;

	}else{
	$product_id = $_GET['product_id'];
	}

    $more_products = $wpdb->get_results("SELECT <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.id AS Pid, <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.name AS Pname, <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.price AS Pprice,<code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.special_price AS Pspecial_price,<code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.notax AS Pnotax  FROM <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code> INNER JOIN <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code> ON <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.id = <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code>.product_id AND <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code>.product_id <> ".$product_id." AND <code>&quot;.WPSC_TABLE_ITEM_CATEGORY_ASSOC.&quot;</code>.category_id = ".$id." And <code>&quot;.WPSC_TABLE_PRODUCT_LIST.&quot;</code>.active = 1  ORDER BY RAND() LIMIT 4",ARRAY_A);

    if(get_option('permalink_structure') != '') {
    $seperator ="?";
	} else {
		$seperator ="&";
	}

    $output = "";

    if($more_products != null){

      foreach($more_products as $more_product) {
      	$product_image_id = $wpdb->get_row("SELECT id FROM <code>&quot;.WPSC_TABLE_PRODUCT_IMAGES.&quot;</code> WHERE product_id = ".$more_product['Pid']." order by id desc LIMIT 1 " ,ARRAY_A);

      		$image_id = $product_image_id['id'];

       $output .= "<li class='homepage_product'>";
       	$output .= "<form id='product_".$more_product['Pid']."' name='product_".$more_product['Pid']."' method='post' action='".get_option('product_list_url').$seperator."category=".$_GET['category']."' enctype='multipart/form-data'' class=''product_form' onsubmit='submitform(this);return false;'>";
					$output .= "<input type='hidden' name='wpsc_ajax_action' value='add_to_cart'/>
";
					$output .= "<input type='hidden' name='product_id' value='".$more_product['Pid']."' />";
       $output .= "<a href='".wpsc_product_url($more_product['Pid'])."' /><img class='product_image' src='index.php?image_id=".$image_id."&width=118&height=118' title='".$more_product['Pname']."' alt='".$more_product['Pname']."' /></a><br />\n\r";
       $output .= "<div class='product_info'><a href='".wpsc_product_url($homepage_product['Pid'])."' />".$more_product['Pname']."</a><br />";
	   $output .= nzshpcrt_currency_display(($more_product['Pprice'] - $more_product['Pspecial_price']), $more_product['Pnotax'],false,$more_product['Pid']);
	   $output .= "</div><input type='submit' id='product_".$more_product['Pid']."_submit_button' class='wpsc_buy_button' name='Buy' value='".TXT_WPSC_ADDTOCART."'  />";

	   $output .= "</li></form>";

       }
      }
     echo $output;
    }

?>

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Scrolling thumnails in Box below Navigation’ is closed to new replies.