Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 21
  1. #11
    Join Date
    Nov 2005
    Location
    Colorado Springs, CO USA
    Posts
    7,033
    Plugin Contributions
    31

    Default Re: Testimonials Manager

    Quote Originally Posted by lina0962 View Post
    hello, Clyde:

    I installed your tesmonial manager too. Eveything looks great except the "submit my tesmonial" button and "submit my tesmoinal" button are missing from the page. How should I fix it? in which file?

    Thank you very much!!

    Lina
    Buttons are included with the MOD make sure you have uploaded includes/templates/YOUR_TEMPLATE/buttons/english

  2. #12
    Join Date
    Feb 2007
    Location
    Los Angeles
    Posts
    359
    Plugin Contributions
    0

    Default Re: Testimonials Manager

    Hello Clyde, Again

    well after almost a day brake i try installing the testimonial maneger.

    after finishing whan i turn my box on in the layot boxes my site gone ku ku Lol

    it dose say on top "Successfully Updated settings for box: testimonials_manager.php

    2 thinks i am not sure i done right
    1 this is where i copy the part that supose to be copy to
    "/public_html/store/includes/templates/MY_TEMPLATE/css/"
    and this is how it look
    " */
    <style type="text/css">
    <!--
    .style20 {font-family: Georgia, "Times New Roman", Times, serif}
    .style22 {font-family: Georgia, "Times New Roman", Times, serif; font-size: xx-small; }
    .style24 {font-size: small}
    .style29 {font-family: Georgia, "Times New Roman", Times, serif; font-size: small; }
    body {
    .testimonial {
    color: #000;
    padding: 0 5px 5px 5px;
    text-align:left;
    }
    .testimonial p {
    margin: 0; padding: 5px 0;
    }
    .testimonial span {
    float:right;
    }
    margin: 0;
    font-family: verdana, arial, helvetica, sans-serif;
    font-size: 62.5&#37;;
    color: #000000;
    background-color: #e5edf5;
    }

    a img {border: none; }
    a:link, #navEZPagesTOC ul li a { "
    2nd think i was not sure was, i copy the whole text file install_testimonials_manager.sql in too SQL Query Executor

    other than that i changed my folder to MY_TEMPLATE and dubble checkd all the file go to same direction as what i unzip.

    i do use new instalation, and i use zen 1.37

    P.S switching the testemony box off got my site to normal , and i did make full backup also

    Ty

  3. #13
    Join Date
    Feb 2007
    Location
    Los Angeles
    Posts
    359
    Plugin Contributions
    0

    Default Re: Testimonials Manager

    i just try it again and copy the errors

    Warning: main(includes/templates/template_default/sideboxes/tpl_testimonials_manager.php) [function.main]: failed to open stream: No such file or directory in /home/tiledepo/public_html/store/includes/modules/sideboxes/MY_TEMPLATE/testimonials_manager.php on line 41

    Warning: main(includes/templates/template_default/sideboxes/tpl_testimonials_manager.php) [function.main]: failed to open stream: No such file or directory in /home/tiledepo/public_html/store/includes/modules/sideboxes/MY_TEMPLATE/testimonials_manager.php on line 41

    Fatal error: main() [function.require]: Failed opening required 'includes/templates/template_default/sideboxes/tpl_testimonials_manager.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/tiledepo/public_html/store/includes/modules/sideboxes/MY_TEMPLATE/testimonials_manager.php on line 41

  4. #14
    Join Date
    Feb 2007
    Location
    Los Angeles
    Posts
    359
    Plugin Contributions
    0

    Default Re: Testimonials Manager

    Oops

    my fault i fix it , i forgat to change one of the Your_template name


    and wow looking good

    Ty once again for your work

    wish i could delete the previous posts heheheh
    Last edited by motti; 21 Apr 2007 at 06:27 AM.

  5. #15
    Join Date
    Nov 2005
    Location
    Colorado Springs, CO USA
    Posts
    7,033
    Plugin Contributions
    31

    Default Re: Testimonials Manager

    Motti,

    You'll need to fix this as follows:

    .style20 {font-family: Georgia, "Times New Roman", Times, serif}
    .style22 {font-family: Georgia, "Times New Roman", Times, serif; font-size: xx-small; }
    .style24 {font-size: small}
    .style29 {font-family: Georgia, "Times New Roman", Times, serif; font-size: small; }
    body {
    margin: 0;
    font-family: verdana, arial, helvetica, sans-serif;
    font-size: 62.5%;
    color: #000000;
    background-color: #e5edf5;
    }
    a img {border: none; }

    .testimonial {
    color: #000;
    padding: 0 5px 5px 5px;
    text-align:left;
    }
    .testimonial p {
    margin: 0; padding: 5px 0;
    }
    .testimonial span {
    float:right;
    }

  6. #16
    Join Date
    Feb 2007
    Location
    Los Angeles
    Posts
    359
    Plugin Contributions
    0

    Default Re: Testimonials Manager

    Hi Clyde

    did what u say so and this is how my whole page look

    /**
    * Main CSS Stylesheet
    *
    * @package templateSystem
    * @copyright Copyright 2003-2006 Zen Cart Development Team
    * @copyright Portions Copyright 2003 osCommerce
    * @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
    * @version $Id: stylesheet.css 5349 2006-12-22 20:34:40Z birdbrain $
    */
    <style type="text/css">
    <!--
    .style20 {font-family: Georgia, "Times New Roman", Times, serif}
    .style22 {font-family: Georgia, "Times New Roman", Times, serif; font-size: xx-small; }
    .style24 {font-size: small}
    .style29 {font-family: Georgia, "Times New Roman", Times, serif; font-size: small; }
    body {
    margin: 0;
    font-family: verdana, arial, helvetica, sans-serif;
    font-size: 62.5%;
    color: #000000;
    background-color: #e5edf5;
    }
    a img {border: none; }
    .testimonial {
    color: #000;
    padding: 0 5px 5px 5px;
    text-align:left;
    }
    .testimonial p {
    margin: 0; padding: 5px 0;
    }
    .testimonial span {
    float:right;
    }
    a:link, #navEZPagesTOC ul li a {
    color: #3300FF;
    text-decoration: none;
    }

    a:visited {
    color: #3300FF;
    text-decoration: none;
    }
    a:hover, #navEZPagesTOC ul li a:hover, #navMain ul li a:hover, #navSupp ul li a:hover, #navCatTabs ul li a:hover {
    color: #FF0000;
    }
    a:active {
    color: #0000FF;
    }
    h1 {
    font-size: 1.5em;
    color: #9a9a9a;
    }
    h2 {
    font-size: 1.4em;
    }
    h3 {
    font-size: 1.3em;
    }
    h4, h5, h6, LABEL, h4.optionName, LEGEND, ADDRESS, .sideBoxContent, .larger{
    font-size: 1.1em;
    }
    .biggerText {
    font-size: 1.2em;
    }
    h1, h2, h3, h4, h5, h6 {
    margin: 0.3em 0;
    }
    /* Might uncomment either or both of these if having problems with IE peekaboo bug:
    h1, h2, h3, h4, h5, h6, p {
    position: relative;
    }
    *html .centerColumn {
    height: 1%;
    }
    */
    CODE {
    font-family: arial, verdana, helvetica, sans-serif;
    font-size: 1em;
    }
    FORM, SELECT, INPUT {
    display: inline;
    font-size: 1em;
    margin: 0.1em;
    }
    TEXTAREA {
    float: left;
    margin: auto;
    display: block;
    width: 95%;
    }
    input:focus, select:focus, textarea:focus {
    background: #E4FEF5;
    }
    FIELDSET {
    padding: 0.5em;
    margin: 0.5em 0em;
    border: 1px solid #cccccc;
    }
    LEGEND {
    font-weight: bold;
    padding: 0.3em;
    }
    LABEL, h4.optionName {
    line-height: 1.5em;
    padding: 0.2em;
    }
    LABEL.checkboxLabel, LABEL.radioButtonLabel {
    margin: 0.5em 0.3em;
    }
    #logo, .centerBoxContents, .specialsListBoxContents, .categoryListBoxContents, .centerBoxContentsAlsoPurch, .attribImg {
    float: left;
    }
    LABEL.inputLabel {
    width: 9em;
    float: left;
    }
    LABEL.inputLabelPayment {
    width: 14em;
    float: left;
    padding-left: 2.5em;
    }
    LABEL.selectLabel, LABEL.switchedLabel, LABEL.uploadsLabel {
    width: 11em;
    float: left;
    }
    #checkoutPayment LABEL.radioButtonLabel {
    font-weight: bold;
    }
    P, ADDRESS {
    padding: 0.5em;
    }
    ADDRESS {
    font-style: normal;
    }
    .clearBoth {
    clear: both;
    }
    HR {
    height: 1px;
    margin-top: 0.5em;
    border: none;
    border-bottom: 1px solid #9a9a9a;
    }
    /*warnings, errors, messages*/
    .messageStackWarning, .messageStackError, .messageStackSuccess, .messageStackCaution {
    line-height: 1.8em;
    padding: 0.2em;
    border: 1px solid #9a9a9a;
    }
    .messageStackWarning, .messageStackError {
    background-color: #ff0000;
    color: #ffffff;
    }
    .messageStackSuccess {
    background-color: #99FF99;
    color: #000000;
    }
    .messageStackCaution {
    background-color: #FFFF66;
    color: #000000;
    }
    /*wrappers - page or section containers*/
    #mainWrapper {
    background-color: #ffffff;
    text-align: left;
    width: 98%;
    vertical-align: top;
    border: 1px solid #9a9a9a;
    }
    #headerWrapper, #contentMainWrapper, #logoWrapper, #cartBoxListWrapper, #ezPageBoxList, #cartBoxListWrapper ul, #ezPageBoxList ul, #mainWrapper, #popupAdditionalImage, #popupImage {
    margin: 0em;
    padding: 0em;
    }
    #logoWrapper{
    background-image: url(../images/header_bg.jpg);
    background-repeat: none;
    background-color: #ffffff;
    height:75px;
    }
    #navColumnOneWrapper, #navColumnTwoWrapper, #mainWrapper {
    margin: auto;
    }
    #navColumnOneWrapper, #navColumnTwoWrapper {
    margin-left: 0.5em;
    margin-right: 0.5em;
    }

    #tagline {
    color:#000000;
    font-size: 2em;
    text-align : center;
    vertical-align: middle;
    }
    #sendSpendWrapper {
    border: 1px solid #cacaca;
    float: right;
    margin: 0em 0em 1em 1em;
    }
    .floatingBox, #accountLinksWrapper, #sendSpendWrapper, #checkoutShipto, #checkoutBillto, #navEZPagesTOCWrapper {
    margin: 0;
    width: 47%;
    }
    .wrapperAttribsOptions {
    margin: 0.3em 0em;
    }
    /*navigation*/
    .navSplitPagesResult {}
    .navSplitPagesLinks {}
    .navNextPrevCounter {
    margin: 0em;
    font-size: 0.9em;
    }
    .navNextPrevList {
    display: inline;
    white-space: nowrap;
    margin: 0;
    padding: 0.5em 0em;
    list-style-type: none;
    }
    #navMainWrapper, #navSuppWrapper, #navCatTabsWrapper {
    margin: 0em;
    background-color: #abbbd3;
    background-image: url(../images/tile_back.gif);
    padding: 0.5em 0.2em;
    font-weight: bold;
    color: #ffffff;
    height: 1%;
    }
    #navCatTabsWrapper {
    background-color: #ffffff;
    color: #9a9a9a;
    background-image:none;
    }
    #navMain ul, #navSupp ul, #navCatTabs ul {
    margin: 0;
    padding: 0.5em 0em;
    list-style-type: none;
    text-align: center;
    line-height: 1.5em;
    }
    #navMain ul li, #navSupp ul li, #navCatTabs ul li {
    display: inline;
    }
    #navMain ul li a, #navSupp ul li a, #navCatTabs ul li a {
    text-decoration: none;
    padding: 0em 0.5em;
    margin: 0;
    color: #ffffff;
    white-space: nowrap;
    }
    #navCatTabs ul li a {
    color: #9a9a9a;
    }
    #navEZPagesTOCWrapper {
    font-weight: bold;
    float: right;
    height: 1%;
    border: 1px solid #9a9a9a;
    }
    #navEZPagesTOC ul {
    margin: 0;
    padding: 0.5em 0em;
    list-style-type: none;
    line-height: 1.5em;
    }
    #navEZPagesTOC ul li {
    white-space: nowrap;
    }
    #navEZPagesTOC ul li a {
    padding: 0em 0.5em;
    margin: 0;
    }
    #navCategoryIcon, .buttonRow, #indexProductListCatDescription {
    margin: 0.5em;
    }
    #navMainSearch {
    float: right;
    }
    #navBreadCrumb {
    padding: 0.5em 0.5em;
    background-color: #ffffff;
    font-size: 0.95em;
    font-weight: bold;
    margin: 0em;
    }
    #navEZPagesTop {
    background-color: #abbbd3;
    background-image: url(../images/tile_back.gif);
    font-size: 0.95em;
    font-weight: bold;
    margin: 0em;
    padding: 0.5em;
    }
    #navColumnOne, #navColumnTwo {
    background-color: transparent;
    }
    /*The main content classes*/
    #contentColumnMain, #navColumnOne, #navColumnTwo, .centerBoxContents, .specialsListBoxContents, .categoryListBoxContents, .additionalImages, .centerBoxContentsSpecials, .centerBoxContentsAlsoPurch, .centerBoxContentsFeatured, .centerBoxContentsNew, .alert {
    vertical-align: top;
    }
    /*.content,*/ #productDescription, .shippingEstimatorWrapper {
    /*font-size: 1.2em;*/
    padding: 0.5em;
    }
    .alert {
    color: #FF0000;
    margin-left: 0.5em;
    }
    .advisory {}
    .important {
    font-weight: bold;
    }
    .notice {}
    .rating{}
    .gvBal {
    float: right;
    }
    .centerColumn, #bannerOne, #bannerTwo, #bannerThree, #bannerFour, #bannerFive, #bannerSix {
    padding: 0.8em;
    }
    .smallText, #siteinfoLegal, #siteinfoCredits, #siteinfoStatus, #siteinfoIP {
    font-size: 0.9em;
    }
    /*Shopping Cart Display*/
    #cartAdd {
    float: right;
    text-align: center;
    margin: 1em;
    border: 1px solid #000000;
    padding: 1em;
    }
    .tableHeading TH {
    border-bottom: 1px solid #9a9a9a;
    }
    .tableHeading, #cartSubTotal {
    background-color: #e9e9e9;
    }
    #cartSubTotal {
    border-top: 1px solid #cccccc;
    font-weight: bold;
    text-align: right;
    line-height: 2.2em;
    padding-right: 2.5em;
    }
    .tableRow, .tableHeading, #cartSubTotal {
    height: 2.2em;
    }
    .cartProductDisplay, .cartUnitDisplay, .cartTotalDisplay, .cartRemoveItemDisplay, .cartQuantityUpdate, .cartQuantity, #cartInstructionsDisplay, .cartTotalsDisplay {
    padding: 0.5em 0em;
    }
    .cartUnitDisplay, .cartTotalDisplay {
    text-align: right;
    padding-right: 0.2em;
    }
    #scUpdateQuantity {
    width: 2em;
    }
    .cartQuantity {
    width: 4.7em;
    }
    .cartNewItem {
    color: #33CC33;
    position: relative; /*do not remove-fixes stupid IEbug*/
    }
    .cartOldItem {
    color: #660099;
    position: relative; /*do not remove-fixes stupid IEbug*/
    }
    .cartBoxTotal {
    text-align: right;
    font-weight: bold;
    }
    .cartRemoveItemDisplay {
    width: 3.5em;
    }
    .cartAttribsList {
    margin-left: 1em;
    }
    #mediaManager {
    width: 50%;
    margin: 0.2em;
    padding: 0.5em;
    background-color: #E4FEf5;
    border: 1px solid #003D00;
    }
    .normalprice, .productSpecialPriceSale {
    text-decoration: line-through;
    }
    .productSpecialPrice, .productSalePrice, .productSpecialPriceSale, .productPriceDiscount {
    color: #ff0000;
    }
    .orderHistList {
    margin: 1em;
    padding: 0.2em 0em;
    list-style-type: none;
    }
    #cartBoxListWrapper ul, #ezPageBoxList ul {
    list-style-type: none;
    }
    #cartBoxListWrapper li, #ezPageBoxList li, .cartBoxTotal {
    margin: 0;
    padding: 0.2em 0em;
    }
    #cartBoxEmpty, #cartBoxVoucherBalance {
    font-weight: bold;
    }
    .totalBox {
    width: 5.5em;
    text-align: right;
    padding: 0.2em;
    }
    .lineTitle, .amount {
    text-align: right;
    padding: 0.2em;
    }
    .amount {
    width: 5.5em;
    }
    /*Image Display*/
    #productMainImage, #reviewsInfoDefaultProductImage, #productReviewsDefaultProductImage, #reviewWriteMainImage {
    margin: 0em 1em 1em 0em ;
    }
    .categoryIcon {}
    #cartImage {
    margin: 0.5em 1em;
    }
    /*Attributes*/
    .attribImg {
    width: 20%;
    margin: 0.3em 0em;
    }
    .attributesComments {}
    /*list box contents*/
    .centerBoxContents, .specialsListBoxContents, .categoryListBoxContents, .additionalImages, .centerBoxContentsSpecials, .centerBoxContentsAlsoPurch, .centerBoxContentsFeatured, .centerBoxContentsNew {
    margin: 1em 0em;
    }
    .centerBoxWrapper {
    border: 1px solid #9a9a9a;
    height: 1%;
    margin: 1.1em 0;
    }
    h2.centerBoxHeading {
    font-size: 1.3em;
    color: #ffffff;
    }
    /*sideboxes*/
    .columnLeft {}
    h3.leftBoxHeading, h3.leftBoxHeading a,
    h3.rightBoxHeading, h3.rightBoxHeading a {
    font-size: 1em;
    color: #ffffff;
    }
    #manufacturersHeading, #currenciesHeading, #musicgenresHeading, #recordcompaniesHeading, #searchHeading, #search-headerHeading {
    font-size: 0.9em;
    color: #ffffff;
    }
    .leftBoxHeading, .centerBoxHeading, .rightBoxHeading {
    margin: 0em;
    background-color: #abbbd3;
    background-image: url(../images/tile_back.gif);
    padding: 0.5em 0.2em;
    }
    .leftBoxContainer, .rightBoxContainer {
    margin: 0em;
    border: 1px solid #9a9a9a;
    border-bottom: 5px solid #336633;
    margin-top: 1.5em;
    }
    .sideBoxContent {
    background-color: #ffffff;
    padding: 0.4em;
    }
    h3.leftBoxHeading a:hover, h3.rightBoxHeading a:hover {
    color: #FFFF33;
    text-decoration: none;
    }
    .rightBoxHeading a:visited, .leftBoxHeading a:visited, .centerBoxHeading a:visited {
    color: #FFFFFF;
    }
    .centeredContent, TH, #cartEmptyText, #cartBoxGVButton, #cartBoxEmpty, #cartBoxVoucherBalance, #navCatTabsWrapper, #navEZPageNextPrev, #bannerOne, #bannerTwo, #bannerThree, #bannerFour, #bannerFive, #bannerSix, #siteinfoLegal, #siteinfoCredits, #siteinfoStatus, #siteinfoIP, .center, .cartRemoveItemDisplay, .cartQuantityUpdate, .cartQuantity, .cartTotalsDisplay, #cartBoxGVBalance, .leftBoxHeading, .centerBoxHeading,.rightBoxHeading, .productListing-data, .accountQuantityDisplay, .ratingRow, LABEL#textAreaReviews, #productMainImage, #reviewsInfoDefaultProductImage, #productReviewsDefaultProductImage, #reviewWriteMainImage, .centerBoxContents, .specialsListBoxContents, .categoryListBoxContents, .additionalImages, .centerBoxContentsSpecials, .centerBoxContentsAlsoPurch, .centerBoxContentsFeatured, .centerBoxContentsNew, .gvBal, .attribImg {
    text-align: center;
    }
    #bestsellers .wrapper {
    margin: 0em 0em 0em 1.5em;
    }
    #bestsellers ol {
    padding: 0;
    margin-left: 1.1em;
    }
    #bestsellers li {
    padding: 0;
    margin: 0.3em 0em 0.3em 0em;
    }
    #bannerboxHeading {
    background-color: #0000CC;
    }
    #upProductsHeading {
    text-align: left;
    }
    #upDateHeading {
    text-align: right;
    }
    /* categories box parent and child categories */
    A.category-top, A.category-top:visited {
    color: #008000;
    text-decoration: none;
    }
    A.category-links, A.category-links:visited {
    color: #004080;
    text-decoration: none;
    }
    A.category-subs, A.category-products, A.category-subs:visited, A.category-products:visited {
    color: #FF0000;
    text-decoration: none;
    }
    SPAN.category-subs-parent {
    font-weight: bold;
    }
    SPAN.category-subs-selected {
    font-weight: bold;
    }
    /* end categories box links */
    /*misc*/
    .back {
    float: left;
    }
    .forward, #shoppingCartDefault #PPECbutton {
    float: right;
    }
    .bold {
    font-weight: bold;
    }
    .rowOdd {
    background-color: #E8E8E8;
    height: 1.5em;
    vertical-align: top;
    }
    .rowEven {
    background-color: #F0F0F0;
    height: 1.5em;
    vertical-align: top;
    }
    .hiddenField {
    display: none;
    }
    .visibleField {
    display: inline;
    }
    CAPTION {
    /*display: none;*/
    }
    #myAccountGen li, #myAccountNotify li {
    margin: 0;
    }
    .accountTotalDisplay, .accountTaxDisplay {
    width: 20%;
    text-align: right;
    /*vertical-align: top*/
    }
    .accountQuantityDisplay {
    width: 10%;
    vertical-align: top
    }
    TR.tableHeading {
    background-color: #cacaca;
    height: 2em;
    }
    .productListing-rowheading {
    background-color: #abbbd3;
    background-image: url(../images/tile_back.gif);
    height: 2em;
    color: #FFFFFF;
    }
    #siteMapList {
    width: 90%;
    float: right;
    }
    .ratingRow {
    margin: 1em 0em 1.5em 0em;
    }
    LABEL#textAreaReviews {
    font-weight: normal;
    margin: 1em 0em;
    }
    #popupShippingEstimator, #popupSearchHelp, #popupAdditionalImage, #popupImage, #popupCVVHelp, #popupCouponHelp, #popupAtrribsQuantityPricesHelp, #infoShoppingCart {
    background-color: #ffffff;
    }



    thank you for your input

  7. #17
    Join Date
    Feb 2007
    Location
    Los Angeles
    Posts
    359
    Plugin Contributions
    0

    Default Re: Testimonials Manager

    [FONT=Times New Roman]Hi Clyde [/FONT]
    [FONT=Times New Roman][/FONT]
    [FONT=Times New Roman]I got a new site as this one had too many problems, and I install the Testimonial mod,[/FONT]
    [FONT=Times New Roman]It all look good and working , just under my configuration/testimonial manger is is all empty in their . other than that it all look perfect and working well[/FONT]
    [FONT=Times New Roman][/FONT]
    [FONT=Times New Roman][/FONT]
    [FONT=Times New Roman]Any idea? I try uninstalling it and re install it back but got some issue[/FONT]
    [FONT=Times New Roman]The links for that site [/FONT][FONT=Times New Roman]www.tiledepot.us/tstore[/FONT]
    [FONT=Times New Roman][/FONT]
    [FONT=Times New Roman]Ty [/FONT]

  8. #18
    Join Date
    Nov 2005
    Location
    Colorado Springs, CO USA
    Posts
    7,033
    Plugin Contributions
    31

    Default Re: Testimonials Manager

    Quote Originally Posted by motti View Post
    [FONT=Times New Roman]Hi Clyde [/FONT]
    [FONT=Times New Roman][/FONT]
    [FONT=Times New Roman]I got a new site as this one had too many problems, and I install the Testimonial mod,[/FONT]
    [FONT=Times New Roman]It all look good and working , just under my configuration/testimonial manger is is all empty in their . other than that it all look perfect and working well[/FONT]
    [FONT=Times New Roman][/FONT]
    [FONT=Times New Roman][/FONT]
    [FONT=Times New Roman]Any idea? I try uninstalling it and re install it back but got some issue[/FONT]
    [FONT=Times New Roman]The links for that site [/FONT][FONT=Times New Roman]www.tiledepot.us/tstore[/FONT]
    [FONT=Times New Roman][/FONT]
    [FONT=Times New Roman]Ty [/FONT]
    run the following sql from admin -> tools -> install sql patches.

    Code:
    #Testimonials Manager v1.4 upgrade SQL
    # For Zen-Cart 1.3.7
    # Last Updated: 3/9/2007
    
    SET @configuration_group_id=0;
    SELECT @configuration_group_id:=configuration_group_id 
    FROM configuration_group
    WHERE configuration_group_title= 'Testimonials Manager'
    LIMIT 1;
    
    DELETE FROM configuration WHERE configuration_group_id = @configuration_group_id;
    DELETE FROM configuration WHERE configuration_key = 'DEFINE_TESTIMONIAL_STATUS';
    DELETE FROM configuration_group WHERE configuration_group_id = @configuration_group_id;
    
    INSERT INTO configuration_group VALUES (NULL, 'Testimonials Manager', 'Testimonials Manager Display Settings', '1', '1');
    SET @configuration_group_id=last_insert_id();
    UPDATE configuration_group SET sort_order = @configuration_group_id WHERE configuration_group_id = @configuration_group_id;
    
    
    INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display in Latest Testimonials box', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', @configuration_group_id, 1, NULL, now(), NULL, NULL);
    
    INSERT INTO configuration VALUES (NULL, 'Display Truncated Testimonials in Sidebox', 'DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT', 'true', 'Display truncated text in sidebox', @configuration_group_id, 2, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
    
    INSERT INTO configuration VALUES (NULL, 'Length of truncated testimonials to display', 'TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH', '150', 'If Display Truncated Testimonials in Sidebox is true - set the amount of characters to display from the Testimonials in the Testimonials Manager sidebox.', @configuration_group_id, 3, NULL, now(), NULL, NULL);
    
    INSERT INTO configuration VALUES (NULL, 'Number Of Testimonials to display on all testimonials page', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS', '5', 'Set the number of testimonials to display on the all testimonials page.', @configuration_group_id, 4, NULL, now(), NULL, NULL);
    
    INSERT INTO configuration VALUES (NULL, 'Display Date Published on Testimonials page', 'DISPLAY_TESTIMONIALS_DATE_PUBLISHED', 'true', 'Display date published on testimonials page', @configuration_group_id, 5, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
    
    INSERT INTO configuration VALUES (NULL, 'Display View All Testimonials Link In Sidebox', 'DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK', 'true', 'Display View All Testimonials Link In Sidebox', @configuration_group_id, 6, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
    
    INSERT INTO `configuration` VALUES (NULL, 'Display Add New Testimonial Link In Sidebox', 'DISPLAY_ADD_TESTIMONIAL_LINK', 'true', 'Display Add New Testimonial Link In Sidebox', @configuration_group_id, 7, NULL, NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
    
    INSERT INTO configuration VALUES (NULL, 'Only registered customers may submit a testimonial', 'REGISTERED_TESTIMONIAL', 'false', 'Only registered customers may submit a testimonial', @configuration_group_id, 8, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');
    
    INSERT INTO `configuration` VALUES (NULL, 'Define Testimonial', 'DEFINE_TESTIMONIAL_STATUS', '1', 'Enable the Defined Testimonial Link/Text?<br />0= Link ON, Define Text OFF<br />1= Link ON, Define Text ON<br />2= Link OFF, Define Text ON<br />3= Link OFF, Define Text OFF', 25, 999, NULL, now(), NULL, 'zen_cfg_select_option(array(''0'', ''1'', ''2'', ''3''),');

  9. #19
    Join Date
    Feb 2007
    Location
    Los Angeles
    Posts
    359
    Plugin Contributions
    0

    Default Re: Testimonials Manager

    Hi Clyde

    It fix it but i got all those errors also

    ERROR: Cannot ADD column testimonials_url because it already exists.ERROR: Cannot ADD column testimonials_url because it already exists.ERROR: Cannot ADD column testimonials_url because it already exists.ERROR: Cannot ADD column testimonials_url because it already exists.ERROR: Cannot ADD column testimonials_url because it already exists. ERROR: Cannot ADD column testimonials_url because it already exists. ERROR: Cannot ADD column testimonials_url because it already exists. ERROR: Cannot ADD column testimonials_url because it already exists. ERROR: Cannot ADD column testimonials_url because it already exists. ERROR: Cannot insert configuration_key "MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES" because it already exists ERROR: Cannot insert configuration_key "DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT" because it already exists ERROR: Cannot insert configuration_key "TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH" because it already exists ERROR: Cannot insert configuration_key "MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS" because it already exists ERROR: Cannot insert configuration_key "DISPLAY_TESTIMONIALS_DATE_PUBLISHED" because it already exists ERROR: Cannot insert configuration_key "DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK" because it already exists ERROR: Cannot insert configuration_key "REGISTERED_TESTIMONIAL" because it already

    Thank You
    Last edited by motti; 2 May 2007 at 03:41 AM.

  10. #20
    Join Date
    Nov 2005
    Location
    Colorado Springs, CO USA
    Posts
    7,033
    Plugin Contributions
    31

    Default Re: Testimonials Manager

    Quote Originally Posted by motti View Post
    Hi Clyde

    It fix it but i got all those errors also

    ERROR: Cannot ADD column testimonials_url because it already exists.ERROR: Cannot ADD column testimonials_url because it already exists.ERROR: Cannot ADD column testimonials_url because it already exists.ERROR: Cannot ADD column testimonials_url because it already exists.ERROR: Cannot ADD column testimonials_url because it already exists. ERROR: Cannot ADD column testimonials_url because it already exists. ERROR: Cannot ADD column testimonials_url because it already exists. ERROR: Cannot ADD column testimonials_url because it already exists. ERROR: Cannot ADD column testimonials_url because it already exists. ERROR: Cannot insert configuration_key "MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES" because it already exists ERROR: Cannot insert configuration_key "DISPLAY_TESTIMONIALS_MANAGER_TRUNCATED_TEXT" because it already exists ERROR: Cannot insert configuration_key "TESTIMONIALS_MANAGER_DESCRIPTION_LENGTH" because it already exists ERROR: Cannot insert configuration_key "MAX_DISPLAY_TESTIMONIALS_MANAGER_ALL_TESTIMONIALS" because it already exists ERROR: Cannot insert configuration_key "DISPLAY_TESTIMONIALS_DATE_PUBLISHED" because it already exists ERROR: Cannot insert configuration_key "DISPLAY_ALL_TESTIMONIALS_TESTIMONIALS_MANAGER_LINK" because it already exists ERROR: Cannot insert configuration_key "REGISTERED_TESTIMONIAL" because it already

    Thank You
    they just mean that they already exist(ed) and it just skips insterting them.

 

 
Page 2 of 3 FirstFirst 123 LastLast

Similar Threads

  1. v150 testimonials manager
    By antonart in forum Addon Sideboxes
    Replies: 3
    Last Post: 16 Oct 2012, 10:39 PM
  2. Help!!!How could the'Testimonials manager' works?
    By kaka2300 in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 30 Mar 2009, 04:48 PM
  3. Testimonials and Link Manager
    By armie in forum General Questions
    Replies: 1
    Last Post: 2 May 2007, 02:15 AM
  4. Testimonials Manager 1.01 by Derek - help?? errors
    By apemusic in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 1 Jul 2006, 01:53 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR