Yvonne DeBandi:
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 [URL]http://www.zen-cart.com/license/2_0.txt[/URL] 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>"<?php echo $text?>"</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&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">"<?php echo nl2br($testimonials->fields['testimonials_html_text']);?>"
<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><? } ?>
```
> **mc12345678:**
>
> 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 :smile:.. make it easy on folks..)
