Showing Featured Products On Outside Page

[ft11]

I have a wordpress installed on the root, and my ZC cart in /root/shop.

I looked around for a bit of code to pull the featured products from the DB, and display them on a WP page.

i tried using this in the template file, but all that was output was "ILLEGAL ACCESS". As im sure you can tell, im not exactly a programmer. I was kinda guessing at what might work.

Has anyone come across a way to do this? Or perhaps a way to call it directly from the Database?

<?php

 include('shop/includes/configure.php');

require('shop/includes/autoload_func.php');


   $zc_show_featured = true;
  include(DIR_WS_MODULES . zen_get_module_directory(FILENAME_FEATURED_PRODUCTS_MODULE));
 
require(DIR_WS_MODULES . zen_get_module_directory('footer.php'));
// the following IF statement can be duplicated/modified as needed to set additional flags
  if (in_array($current_page_base,explode(",",'list_pages_to_skip_all_right_sideboxes_on_here,separated_by_commas,and_no_spaces')) ) {
    $flag_disable_right = true;
  }

?>








<!-- bof: featured products  -->
<?php if ($zc_show_featured == true) { ?>

<?php
/**
 * require the list_box_content template to display the product
 */
  require($template->get_template_dir('tpl_columnar_display.php',DIR_WS_TEMPLATE, $current_page_base,'common'). '/tpl_columnar_display.php');
?>

<?php } ?>
<!-- eof: featured products  -->

[gjh42]

There is a "dynamic sidebox" mod in downloads that is designed for this kind of use.

[ft11]

Thanks for the lead.

Here is the module you suggested.

I tweaked it up to make it work with my Wordpress install.