1. Ok, thanks for the clarification on the version.
2. Should I just delete that statement (line 59, for me) from the sql file?
Printable View
Hi Clyde,
This is really just for anyone else who might be having the same issue I did (errors when running the sql patch for new installs.)
Just an FYI, I had to comment out lines 56-59 in the sql file for new installs. I had to go one by one until I finally got a success message from phpmyadmin. I'm assuming its because I do have a number of addons installed on my site.
Hope that helps someone else save some time.
ok i just installed this and where on the stylesheet do I place :
.testimonial {
color: #000;
padding: 0 5px 5px 5px;
text-align:left;
}
.testimonial p {
margin: 0; padding: 5px 0;
}
.testimonial span {
float:right;
}
.testimonialImage {
margin: 0;
padding: 0;
text-align: center;
}
metatags
//TESTIMONIALS:
case 'testimonials_manager_all_testimonials':
$sql = "select * from " . TABLE_TESTIMONIALS_MANAGER . " where status = 1 and language_id = '" . (int)$_SESSION['languages_id'] . "' order by date_added DESC, testimonials_title";
$testimonials = $db->Execute($sql);
while (!$testimonials->EOF) {
$testimonial_string_metatags .= zen_clean_html($testimonials->fields['testimonials_title']) . METATAGS_DIVIDER;
$testimonials->MoveNext();
} //EOF
define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
break;
case 'testimonials_manager':
define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
break;
open includes/templates/YOUR_TEMPLATE/css/stylesheet.css
scroll to the bottom of the page and add the following
.testimonial {
color: #000;
padding: 0 5px 5px 5px;
text-align:left;
}
.testimonial p {
margin: 0; padding: 5px 0;
}
.testimonial span {
float:right;
}
.testimonialImage {
margin: 0;
padding: 0;
text-align: center;
}
the other section is used to add meta tags when vewing your testimonial pages and is not included in the stylesheet.
There are instruction earlier in this support thread on add the meta tag section (I just don't remember where exactly)
I downloaded this mod from the free software section and installed it. I added the below code to /includes/modules/mytemplatename/meta_tags.php
Did this code need to be added to the meta_tags.php file or was that supplied for upgrades?Quote:
//TESTIMONIALS:
case 'testimonials_manager_all_testimonials':
$sql = "select * from " . TABLE_TESTIMONIALS_MANAGER . " where status = 1 and language_id = '" . (int)$_SESSION['languages_id'] . "' order by date_added DESC, testimonials_title";
$testimonials = $db->Execute($sql);
while (!$testimonials->EOF) {
$testimonial_string_metatags .= zen_clean_html($testimonials->fields['testimonials_title']) . METATAGS_DIVIDER;
$testimonials->MoveNext();
} //EOF
define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS . $testimonial_string_metatags);
break;
case 'testimonials_manager':
define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
break;
After adding it to the file, this string is showing up in the top/title of the browser window bar along with the title of the comment.
META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER
Clyde, first of all, thanks for all your contributions. I wanted to verify whether this was the proper way to add the code to the metatags.php.
When adding:
I get the following on my metatags:PHP Code:
define('META_TAG_TITLE', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
define('META_TAG_DESCRIPTION', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
define('META_TAG_KEYWORDS', META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER . $page_check->fields['testimonials_title']);
When deleting "META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGER"HTML Code:<title>META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGERGreat</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="keywords" content="META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGERGreat" />
<meta name="description" content="META_TAG_TITLE_PAGE_TESTIMONIALS_MANAGERThis is just a test submission to show you how it looks, great, eh?" />
as inmy meta tags show as they should...PHP Code:
define('META_TAG_TITLE', $page_check->fields['testimonials_title']);
define('META_TAG_DESCRIPTION', zen_trunc_string($page_check->fields['testimonials_html_text'],TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH));
define('META_TAG_KEYWORDS', $page_check->fields['testimonials_title']);
Will doing so will create any problems with other pages? I ask because I assume the original code worked for you and you added it for a reason...HTML Code:<title>Great</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="keywords" content="Great" />
<meta name="description" content="This is just a test submission to show you how it looks, great, eh?" />
Thanks