Testimonial Manager Support Thread (for ZC v1.5.x)

[DivaVocals]

Hi, I'm using 1.5 and love testimonial manager. Having a strange issue where things go haywire on all testimonial display when I add testimonial #5.

Admittedly I know just enough about zen to be dangerous and I did add a product field and a switch case request to allow links to a specific product's testimonials. Is it because of my hack or has anyone run into this before?

And yes...I know the styling should all be in my css files, but my server is caching the css results and I can find no quick relief, so please pardon the inline styling here. :-/

Appreciate any help or guidance. Thanks so much!

<?php
/**
 * Testimonials Manager
 *
 * @package Template System
 * @copyright 2007 Clyde Jones
  * @copyright Portions Copyright 2003-2007 Zen Cart Development Team
 * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
 * @version $Id: Testimonials_Manager.php v1.5.4
 */

?> <style>
blockquote {margin:0 !important;padding:0 !important;
-webkit-border-radius: 20px; -mozborder-radius: 20px; border-radius: 20px; 
box-shadow: 5px 5px 5px #007;;
height:1%;width:95%;
background-color:#ffffff;}

blockquote div {padding:38px 56px;height:1%;margin-left:auto; margin-right:auto;}
</style>
<div class="centerColumn" id="testimonialDefault" style="background-image:url(includes/templates/classic/images/background-wallpaper2.jpg); box-shadow: 5px 5px 5px #007;">


<? switch($_REQUEST['req']){
        case    "read": ?>
<h3> All Testimonials for:</h3>        
<? $query = mysql_query("SELECT * FROM zen_testimonials_manager 
WHERE testimonials_pid='{$_GET['testimonials_pid']}'");?>
<? $row = mysql_fetch_assoc($query);
$pid = $row['testimonials_pid']; 
{?>
<div style="width:250px; height:250px; box-shadow:5px 5px 5px #000080; text-align:center; margin-right:auto; margin-left:auto; border-radius:25px;background-image:url(images/products/<? echo $pid?>.jpg); background-size: 250px 250px;"></div><br />
 <?  echo "<a href='index.php?main_page=product_info&products_id=".$pid."'>";   echo "<p><br />Click here for product details.</p></a>";?>
     <?php
   }
?>
<br class="clearBoth" />
<? $query = mysql_query("SELECT * FROM zen_testimonials_manager
WHERE testimonials_pid='{$_GET['testimonials_pid']}'");?>
<? while($row = mysql_fetch_assoc($query)){ 
$text = $row['testimonials_html_text']; 
$pid = $row['testimonials_pid']; 
$id = $row['products_id']; 
$title = $row['testimonials_title'];
$author = $row['testimonials_name']; 
?>
<blockquote>
<div class="testimonial">
<h3><? echo $title ?></h3>
<p>&quot;<?php echo $text?>&quot;</p>
<p align="right"><? echo $author?></p> 
</div>
</blockquote><br /><br />  
<br class="clearBoth" />
<div class="buttonRow back"><?php echo zen_back_link() . zen_image_button(BUTTON_IMAGE_BACK, BUTTON_BACK_ALT) . '</a>'; ?></div>
<div class="buttonRow forward"><a href="<?php echo zen_href_link(FILENAME_TESTIMONIALS_ADD, '', 'SSL'); ?>"><?php echo zen_image_button(BUTTON_IMAGE_TESTIMONIALS, BUTTON_TESTIMONIALS_ADD_ALT); ?></a></div>

<br class="clearBoth" />
</div><?
 } break;    ?> 
<? default: ?>
<span style="color:#fff"><?php echo HEADING_TITLE; ?></span> 
<?php
//  $testimonials_query_raw = "select * from " . TABLE_TESTIMONIALS_MANAGER . " where status = 1 and language_id = '" . (int)$_SESSION['languages_id'] . "' order by date_added DESC, testimonials_title";
//  $testimonials_split = new splitPageResults($testimonials_query_raw, MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS);

  if (($testimonials_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '1') || (PREV_NEXT_BAR_LOCATION == '3'))) {
?>


<div id="productsListingTopNumber" class="navSplitPagesResult back"><?php echo $testimonials_split->display_count(TEXT_DISPLAY_NUMBER_OF_TESTIMONIALS_MANAGER_ITEMS); ?></div>


<div id="productsListingListingTopLinks" class="navSplitPagesLinks forward"><?php echo TEXT_RESULT_PAGE . ' ' . $testimonials_split->display_links(MAX_DISPLAY_PAGE_LINKS, zen_get_all_get_params(array('page', 'info', 'x', 'y', 'main_page'))); ?></div>
<br />
<br class="clearBoth" />

<hr />

<?php
  } // split page
?>
<?php
    $testimonials = $db->Execute($testimonials_split->sql_query);
    while (!$testimonials->EOF) {
    $date_published = $testimonials->fields['date_added'];
?>


<blockquote>
<div class="testimonial">
<table width="100%" border="0" cellpadding="5">
  <tr>
    <td width="44%"><p class="back"><b><a href="<?php echo zen_href_link(FILENAME_TESTIMONIALS_MANAGER, 'testimonials_id=' . $testimonials->fields['testimonials_id']);?>"><?php echo $testimonials->fields['testimonials_title'];?></a></b></p>
    
</td>
    <td width="56%"><p class="forward"><?php if (DISPLAY_TESTIMONIALS_DATE_PUBLISHED == 'true') { echo zen_date_long($date_published); } ?></p><br class="clearBoth" /></td>
  </tr>
  <tr>
    <td><?php
   if (($testimonials->fields[testimonials_image]) != ('')) {
     $testimonials_image = zen_image(DIR_WS_IMAGES . $testimonials->fields[testimonials_image], $testimonials->fields['testimonials_title'], TESTIMONIAL_IMAGE_WIDTH, TESTIMONIAL_IMAGE_HEIGHT);
?><?php /*if (($testimonials->fields['testimonials_url']) == ('http://') or ($testimonials->fields['testimonials_url']) == ('')) {

echo $testimonials_image;
} else {
echo '<a href="' . $testimonials->fields['testimonials_url'] . '" target="_blank">' . $testimonials_image . '</a>';
}*/

?>
      <a href="index.php?main_page=product_info&amp;products_id=<? echo $testimonials->fields['testimonials_pid']?>"><img src="images/products/<? echo ($testimonials->fields['testimonials_pid'])?>.jpg" width="250" height="250" alt="Mark Cahill Ministries" /></a><br /><? if  ($testimonials->fields['testimonials_pid'] !=0){ 
  echo "<a href='index.php?main_page=product_info&products_id=".nl2br($testimonials->fields['testimonials_pid']."'>"); ?>     </p>
   <p><br />
     Click here for product details.</p>
   </a>
   <? } ?></td>
    <td style="font-size:16px; font-family: 'Palatino Linotype', 'Book Antiqua', Palatino, serif">&quot;<?php echo nl2br($testimonials->fields['testimonials_html_text']);?>&quot;
     <p align="right"> <span class="buttonRow back" style="text-align:right; font-size:11px;"><?php echo TESTIMONIALS_BY; ?> <?php echo $testimonials->fields[testimonials_name] . $testimonial_info; ?></span></p></td>
  </tr>
  <tr>
    <td colspan="2"></td>
    </tr>

</table>

   <?php
   }
?>
  
</div>
</blockquote>

<?php
$testimonial_info = '';
if ( (!empty($testimonials->fields[testimonials_city])) and (!empty($testimonials->fields[testimonials_country])) ) {
$testimonial_info .= NAME_SEPARATOR . $testimonials->fields[testimonials_city] . CITY_STATE_SEPARATOR . $testimonials->fields[testimonials_country];
}
if ( (!empty($testimonials->fields[testimonials_city])) and (empty($testimonials->fields[testimonials_country])) ) {
$testimonial_info .= NAME_SEPARATOR . $testimonials->fields[testimonials_city];
}
if ( (empty($testimonials->fields[testimonials_city])) and (!empty($testimonials->fields[testimonials_country])) ) {
$testimonial_info .= NAME_SEPARATOR . $testimonials->fields[testimonials_country];
}
if (!empty($testimonials->fields[testimonials_company])) {
$testimonial_info .= NAME_SEPARATOR . $testimonials->fields[testimonials_company];
}
?>


<br class="clearBoth" />
<br />
<hr />

<?php
      $testimonials->MoveNext();
      }
?>

<?php
  if (($testimonials_split->number_of_rows > 0) && ((PREV_NEXT_BAR_LOCATION == '2') || (PREV_NEXT_BAR_LOCATION == '3'))) {
?>

<div id="productsListingBottomNumber" class="navSplitPagesResult back"><?php echo $testimonials_split->display_count(TEXT_DISPLAY_NUMBER_OF_TESTIMONIALS_MANAGER_ITEMS); ?></div>

<div id="productsListingListingBottomLinks" class="navSplitPagesLinks forward"><?php echo TEXT_RESULT_PAGE . ' ' . $testimonials_split->display_links(MAX_DISPLAY_PAGE_LINKS, zen_get_all_get_params(array('page', 'info', 'x', 'y', 'main_page'))); ?></div>

<?php
  } // split page
?>
<br class="clearBoth" />
<div class="buttonRow back"><?php echo zen_back_link() . zen_image_button(BUTTON_IMAGE_BACK, BUTTON_BACK_ALT) . '</a>'; ?></div>
<div class="buttonRow forward"><a href="<?php echo zen_href_link(FILENAME_TESTIMONIALS_ADD, '', 'SSL'); ?>"><?php echo zen_image_button(BUTTON_IMAGE_TESTIMONIALS, BUTTON_TESTIMONIALS_ADD_ALT); ?></a></div>

<br class="clearBoth" />
</div><? } ?>

don't know what you mean by going haywire

Yep.. I have no IDEA what is meant by "things go haywire on all testimonial display when I add testimonial #5".. Looking at this code doesn't help..(it is NOT enclosed in proper code tags to make reading it easier -- took the liberty of doing it in quoting the post..)

What WOULD help is to see an example of where "things go haywire on all testimonial display when I add testimonial #5" so we can see what the heck that statement means.. (or at LEAST some narrative detail included in the post about what "things go haywire on all testimonial display when I add testimonial #5" means) Then it would help if Yvonne DeBandi could let us know what specific changes she made in the module code (yes I know you posted your code, but don't make us fish through the WHOLE file just to find your changes please .. make it easy on folks..)

[Yvonne DeBandi]

Hey, thanks for responding. Of course, will be happy to provide details. First time posting and wasn't sure what to expect.

Here is the link to see what is going haywire:
http://a2zsmartgroup.com/mcministrie...monials&page=1

If you navigate to page 2 of testimonials you will see that everything then resolves itself and the layout is fine.

As I mentioned, I added a switch case request so that I can retrieve a page that pulls only the testimonials for a specific product.
You can see this here:
http://a2zsmartgroup.com/mcministrie...imonials_pid=3

The layout is fine on all counts until I approve testimonial #5.

The code I added is the third block of code down beginning with the SWITCH CASE REQ and ending at the default/break.

<? switch($_REQUEST['req']){
case "read": ?>
<h3> All Testimonials for:</h3>
<? $query = mysql_query("SELECT * FROM zen_testimonials_manager
WHERE testimonials_pid='{$_GET['testimonials_pid']}'");?>
<? $row = mysql_fetch_assoc($query);
$pid = $row['testimonials_pid'];
{?>
<div style="width:250px; height:250px; box-shadow:5px 5px 5px #000080; text-align:center; margin-right:auto; margin-left:auto; border-radius:25px;background-image:url(images/products/<? echo $pid?>.jpg); background-size: 250px 250px;"></div><br />
<? echo "<a href='index.php?main_page=product_info&products_id=".$pid."'>"; echo "<p><br />Click here for product details.</p></a>";?>
<?php
}
?>
<br class="clearBoth" />
<? $query = mysql_query("SELECT * FROM zen_testimonials_manager
WHERE testimonials_pid='{$_GET['testimonials_pid']}'");?>
<? while($row = mysql_fetch_assoc($query)){
$text = $row['testimonials_html_text'];
$pid = $row['testimonials_pid'];
$id = $row['products_id'];
$title = $row['testimonials_title'];
$author = $row['testimonials_name'];
?>
<blockquote>
<div class="testimonial">
<h3><? echo $title ?></h3>
<p>&quot;<?php echo $text?>&quot;</p>
<p align="right"><? echo $author?></p>
</div>
</blockquote><br /><br />
<br class="clearBoth" />
<div class="buttonRow back"><?php echo zen_back_link() . zen_image_button(BUTTON_IMAGE_BACK, BUTTON_BACK_ALT) . '</a>'; ?></div>
<div class="buttonRow forward"><a href="<?php echo zen_href_link(FILENAME_TESTIMONIALS_ADD, '', 'SSL'); ?>"><?php echo zen_image_button(BUTTON_IMAGE_TESTIMONIALS, BUTTON_TESTIMONIALS_ADD_ALT); ?></a></div>

<br class="clearBoth" />
</div><?
} break; ?>

I simply added this code above the original code provided, making the original code the default result. Strangely enough, the error also occurs on the default layout....

Hope this makes sense. Thanks in advance for any guidance or assistance provided. :)

[Yvonne DeBandi]

Nevermind, figured out the cause of the issue. Current code requires a pic for each testimonial. Thanks anyway!

[DivaVocals]

Nevermind, figured out the cause of the issue. Current code requires a pic for each testimonial. Thanks anyway!

Glad you worked out whatever it was that was at issue.. but if you don't mind some constructive criticism.. it's still not clear what the issue was or where/how your code is to be used. It's not clear from your post what part of the code you posted is your custom code and what is the default code for this module.. You also don't say which file you updated.. and you are NOT using any of the proper codes for posting code. The reason for using them is twofold:

Makes your code easier to read
Prevents the forum software from parsing the code and accidentally making smilies or other strange characters of your code (it CAN happen)

when posting code you SHOULD use the forum codes for posting code (I've added spaces so the forum software doesn't parse this and you can see the codes I refer to)
[ CODE ] YOUR CODE GOES HERE [ /CODE ]
[ PHP ] YOUR CODE GOES HERE [ /PHP ]

So using the "CODE" forum code, the code you posted looks like this:

<? switch($_REQUEST['req']){
        case    "read": ?>
<h3> All Testimonials for:</h3>        
<? $query = mysql_query("SELECT * FROM zen_testimonials_manager 
WHERE testimonials_pid='{$_GET['testimonials_pid']}'");?>
<? $row = mysql_fetch_assoc($query);
$pid = $row['testimonials_pid']; 
{?>
<div style="width:250px; height:250px; box-shadow:5px 5px 5px  #000080; text-align:center; margin-right:auto; margin-left:auto;  border-radius:25px;background-image:url(images/products/<? echo  $pid?>.jpg); background-size: 250px 250px;"></div><br  />
 <?  echo "<a  href='index.php?main_page=product_info&products_id=".$pid."'>";    echo "<p><br />Click here for product  details.</p></a>";?>
     <?php
   }
?>
<br class="clearBoth" />
<? $query = mysql_query("SELECT * FROM zen_testimonials_manager
WHERE testimonials_pid='{$_GET['testimonials_pid']}'");?>
<? while($row = mysql_fetch_assoc($query)){ 
$text = $row['testimonials_html_text']; 
$pid = $row['testimonials_pid']; 
$id = $row['products_id']; 
$title = $row['testimonials_title'];
$author = $row['testimonials_name']; 
?>
<blockquote>
<div class="testimonial">
<h3><? echo $title ?></h3>
<p>&quot;<?php echo $text?>&quot;</p>
<p align="right"><? echo $author?></p> 
</div>
</blockquote><br /><br />  
<br class="clearBoth" />
<div class="buttonRow back"><?php echo zen_back_link() .  zen_image_button(BUTTON_IMAGE_BACK, BUTTON_BACK_ALT) . '</a>';  ?></div>
<div class="buttonRow forward"><a href="<?php echo  zen_href_link(FILENAME_TESTIMONIALS_ADD, '', 'SSL'); ?>"><?php  echo zen_image_button(BUTTON_IMAGE_TESTIMONIALS,  BUTTON_TESTIMONIALS_ADD_ALT); ?></a></div>

<br class="clearBoth" />
</div><?
 } break;    ?>

Anyway.. glad it's all working now..

[speedyrider]

Hello, i installed it on my site www.kite-addicti***on.es/tienda

Please delete the *

Its working ok in english, but not in spanish. I have copied all the files in the installation languages/english folder to my languages/spanish folder, but still is not appearing there where it should be in the spanish version, while it does on the english one.

Kind regards,

David

[speedyrider]

It is working now. When i added a new testimonial in the admin panel it appeared. Now the problem is it seems there are 2 database testimonials, one for spanish one for english, i would like both to point to the same one. Any ideas?

[lat9]

I'm using v1.5.2 of Testimonials Manager on one of my sites and it's got a setting in Configuration->Testimonials Manager: Display All Languages. Set to true, and both the English and Spanish testimonials will be displayed on your store.

[speedyrider]

I'm using v1.5.2 of Testimonials Manager on one of my sites and it's got a setting in Configuration->Testimonials Manager: Display All Languages. Set to true, and both the English and Spanish testimonials will be displayed on your store.

Hi, that is already set to true. The box is displaying in both languages. However if i add a new testimonial while on english language this new testimonial wont appear when i switch language to spanish and viceversa

[lat9]

Hi, that is already set to true. The box is displaying in both languages. However if i add a new testimonial while on english language this new testimonial wont appear when i switch language to spanish and viceversa

When you say that "the box" is displaying in both languages, do you mean that existing testimonials display both English and Spanish, no matter which language is currently selected?

Would you be more specific about that last bit. Are you saying that if you add a new testimonial while the language is set to English that the testimonial displays in the "all testimonials" page in English but not Spanish (and vice-versa)?

[robbie269]

Is there a way of getting the Testimonial Manager to display in a center box on the homepage?