Jump to content

L. Haase

Members
  • Content count

    85
  • Joined

  • Last visited

2 Followers

About L. Haase

  • Rank
    Computer Geekette
  • Birthday 02/17/1957

Profile Information

Recent Profile Visitors

6,606 profile views
  1. Mommaroodles (Melanie), is working on a newer version of this module. I am sure she will take all the issues found into consideration when she does her re-writing.
  2. L. Haase

    Seperate Pricing Per Customer v3.5

    Ok, another issue. I have registered my admin email in the mentioned file so that I can get the window that allows me to select either wholesale or retail group however no matter which I select, I am routed back to the login.php. When I look at the source code, I see my email address as well as the password I set up for that account although I do not remember setting the password in english/login.php. Is it supposed to do that? I see nothing about it in the documentation for this file and there is really only 2 edits, simple ones, for that file so I don't see how I could have messed it up. :)
  3. L. Haase

    Seperate Pricing Per Customer v3.5

    To show the issue, here is a screen shot. http://aquarian-artisan-bath-body.com/images/sppc-no.images.jpg
  4. L. Haase

    Seperate Pricing Per Customer v3.5

    I have done a search here for my issue of my up/down arrows not showing (I am only getting the text from "catalog/admin/includes/languages/english/customers.php". I have uploaded the image files to both catalog/images as well as catalog/admin/images with no luck, I still only get the alt text...no arrows. There is another image issue when I go to admin/customers/customers groups (customers_groups.php), the "new group" image is not showing and instead I see the text "+Image_new_group". Everything else seems to work properly. This was an all day affair for me...I still have my altered files up in hopes I can pin point this issue quickly. Any ideas?
  5. L. Haase

    Credit Class & Gift Vouchers for 2.3.4

    Will start removing this weekend. I had to re-do my site anyway and a new version would be wonderful for a totally new site.
  6. L. Haase

    Credit Class & Gift Vouchers for 2.3.4

    Melanie, I look forward to the new version. One quick mention, if possible, could you mention in the instructions the files to edit for custom verbiage in the sent emails as well as listing any known problems in the install file for quick reference. Your instructions are quite explicit which is great however a mention would be nice as an addition. Guys, this work is great. The module is perfecto and Melanie is the bomb.
  7. L. Haase

    Contribution Issue

    Here is the entire file. <?php /* $Id: extra_info_pages.php 4.50 2003/06/29 22:50:51 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright © 2003 osCommerce Released under the GNU General Public License */ require('includes/application_top.php'); $action = (isset($_GET['action']) ? $_GET['action'] : ''); $languages = tep_get_languages(); // Sets the status of a page function tep_set_page_status($pages_id, $status) { if ($status == '1') { return tep_db_query("update " . TABLE_ABOUT_US . " set status = '1' where pages_id = '" . $pages_id . "'"); } elseif ($status == '0') { return tep_db_query("update " . TABLE_ABOUT_US . " set status = '0' where pages_id = '" . $pages_id . "'"); } else { return -1; } } if (tep_not_null($action)) { switch ($action) { case 'setflag': if ( ($_GET['flag'] == '0') || ($_GET['flag'] == '1') ) { tep_set_page_status($_GET['bID'], $_GET['flag']); $messageStack->add_session(SUCCESS_PAGE_STATUS_UPDATED, 'success'); } else { $messageStack->add_session(ERROR_UNKNOWN_STATUS_FLAG, 'error'); } tep_redirect(tep_href_link(FILENAME_PAGE_MANAGER, 'page=' . $_GET['page'] . '&bID=' . $_GET['bID'])); break; case 'insert': case 'update': if (isset($_POST['pages_id'])) $pages_id = tep_db_prepare_input($_POST['pages_id']); $pages_title = tep_db_prepare_input($_POST['pages_title']); $pages_html_text = tep_db_prepare_input($_POST['pages_html_text']); $sort_order = tep_db_prepare_input($_POST['sort_order']); $intorext = tep_db_prepare_input($_POST['intorext']); if($intorext == 1) { $externallink = tep_db_prepare_input($_POST['externallink']); }else{ $externallink=""; } $page_error = false; for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $title_field_name=$_POST['pages_title_'.$languages[$i]['id']]; if (empty($title_field_name)) { $messageStack->add(ERROR_PAGE_TITLE_REQUIRED, 'error'); $page_error = true; } } if (empty($pages_html_text)) { } if ($page_error == false) { if ($action == 'insert') { if($page_type == "1" || $page_type == "2" || $page_type == "3" || $page_type == "4" || $page_type == "5" || $page_type == "6" || $page_type == "7" || $page_type == "8" || $page_type == "9") { $selectquery=tep_db_query("select count(*) as count from ". TABLE_ABOUT_US ." where page_type=\"$page_type\""); $exists = tep_db_fetch_array($selectquery); if($exists['count'] >= 1) { $updateall=tep_db_query("update ". TABLE_ABOUT_US ." set page_type=\"9\" where page_type=\"$page_type\""); } } } if ($action == 'update') { if($page_type == "1" || $page_type == "2" || $page_type == "3" || $page_type == "4" || $page_type == "5" || $page_type == "6" || $page_type == "7" || $page_type == "8" || $page_type == "9") { $selectquery=tep_db_query("select count(*) as count from ". TABLE_ABOUT_US ." where page_type=\"$page_type\" and pages_id != \"(int)$pages_id\""); $exists = tep_db_fetch_array($selectquery); if($exists['count'] >= 1) { $updateall=tep_db_query("update ". TABLE_ABOUT_US ." set page_type=\"9\" where page_type=\"$page_type\""); } } } for ($i=0, $n=sizeof($languages); $i<$n; $i++) { $pages_titlem=$_POST['pages_title_'.$languages[$i]['id']]; $pages_html_textm=$_POST['pages_html_text_'.$languages[$i]['id']]; $intorextm=$_POST['intorext_'.$languages[$i]['id']]; $externallinkm=$_POST['externallink_'.$languages[$i]['id']]; $link_targetm=$_POST['link_target_'.$languages[$i]['id']]; $language_idm='language_id_'.$languages[$i]['id']; $sql_data_array_pages = array('sort_order' => $sort_order, 'status' => '1', 'page_type' => $_POST['page_type']); $sql_data_array_pages_description = array('pages_title' => $pages_titlem, 'pages_html_text' => stripslashes($pages_html_textm), 'intorext' => $intorextm, 'externallink' => $externallinkm, 'link_target' => $link_targetm); if ($action == 'insert') { $bID=""; if ($i == 0) { tep_db_perform(TABLE_ABOUT_US, $sql_data_array_pages); $pages_id = tep_db_insert_id(); } $pageid_merge= array('pages_id' => $pages_id, 'language_id' => $languages[$i]['id']); $sql_data_array_pages_desc = array_merge($sql_data_array_pages_description, $pageid_merge); tep_db_perform(TABLE_ABOUT_US_DESCRIPTION, $sql_data_array_pages_desc); $messageStack->add_session(SUCCESS_PAGE_INSERTED, 'success'); } elseif ($action == 'update') { if ($i == 0) { tep_db_perform(TABLE_ABOUT_US, $sql_data_array_pages, 'update', "pages_id = '" . (int)$pages_id . "'"); } $selectexists=tep_db_query("select count( * ) as `countrecords` from `".TABLE_ABOUT_US_DESCRIPTION."` where pages_id='" . (int)$pages_id . "' and language_id='".$languages[$i]['id']."'"); $recordexists = tep_db_fetch_array($selectexists); if($recordexists['countrecords'] >= 1 ) { tep_db_perform(TABLE_ABOUT_US_DESCRIPTION, $sql_data_array_pages_description, 'update', "pages_id = '" . (int)$pages_id . "' and language_id='".$languages[$i]['id']."'"); } else { $pageid_merge= array('pages_id' => $pages_id, 'language_id' => $languages[$i]['id']); $sql_data_array_pages_desc = array_merge($sql_data_array_pages_description, $pageid_merge); tep_db_perform(TABLE_ABOUT_US_DESCRIPTION, $sql_data_array_pages_desc); } $messageStack->add_session(SUCCESS_PAGE_UPDATED, 'success'); } } //for tep_redirect(tep_href_link(FILENAME_PAGE_MANAGER, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . 'bID=' . $pages_id)); } else { $action = 'new'; } break; case 'deleteconfirm': $pages_id = tep_db_prepare_input($_GET['bID']); tep_db_query("delete from " . TABLE_ABOUT_US . " where pages_id = '" . (int)$pages_id . "'"); tep_db_query("delete from " . TABLE_ABOUT_US_DESCRIPTION . " where pages_id = '" . (int)$pages_id . "'"); $messageStack->add_session(SUCCESS_PAGE_REMOVED, 'success'); tep_redirect(tep_href_link(FILENAME_PAGE_MANAGER, 'page=' . $_GET['page'])); break; } } require(DIR_WS_INCLUDES . 'template_top.php'); ?> <script language="javascript"> function disableIt(a){ document.getElementById(a).disabled=true; } function enableIt(a){ document.getElementById(a).disabled=false; } </script> <table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> <td class="pageHeading" align="right"><?php echo tep_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <?php if ($action == 'new') { $form_action = 'insert'; $parameters = array('pages_title' => '', 'pages_html_text' => '', 'sort_order' =>'', 'status' =>''); $bInfo = new objectInfo($parameters); if (isset($_GET['bID'])) { $form_action = 'update'; $bID = tep_db_prepare_input($_GET['bID']); $page_query = tep_db_query("select s.status, s.sort_order, s.page_type, p.pages_title, p.pages_html_text, p.intorext, p.externallink, p.link_target, p.language_id from " . TABLE_ABOUT_US . " s left join " . TABLE_ABOUT_US_DESCRIPTION . " p on s.pages_id=p.pages_id where s.pages_id = '" . (int)$bID . "'"); while($page = tep_db_fetch_array($page_query)) { $languageid=$page['language_id']; $page_type=$page['page_type']; $pagetitle[$languageid]= $page['pages_title']; $sortorder=$page['sort_order']; $pages_html_text[$languageid]=$page['pages_html_text']; $intorext[$languageid]=$page['intorext']; $externallink[$languageid]=$page['externallink']; $link_target[$languageid]=$page['link_target']; } } elseif (tep_not_null($_POST)) { $bInfo->objectInfo($_POST); } $bIDif=""; if(!empty($bID) && $bID != "") { $bIDif='&bID='.$bID; } ?> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr><?php echo tep_draw_form('new_page', FILENAME_PAGE_MANAGER, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . 'action=' . $form_action.$bIDif, 'post', 'enctype="multipart/form-data"'); if ($form_action == 'update') echo tep_draw_hidden_field('pages_id', $bID); ?> <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><?php echo TEXT_PAGES_TYPE; ?></td> <td class="main"><?echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' '?><select name="page_type" size=1> <option value="1" <?php if($page_type == 1) { echo 'selected="selected"'; } ?>>1 - Index</option> <option value="2" <?php if($page_type == 2) { echo 'selected="selected"'; } ?>>2 - Contact Us</option> <option value="3" <?php if($page_type == 3) { echo 'selected="selected"'; } ?>>3 - Shipping</option> <option value="4" <?php if($page_type == 4) { echo 'selected="selected"'; } ?>>4 - Privacy</option> <option value="5" <?php if($page_type == 5) { echo 'selected="selected"'; } ?>>5 - Links</option> <option value="6" <?php if($page_type == 6) { echo 'selected="selected"'; } ?>>6 - Content</option> <option value="7" <?php if($page_type == 7) { echo 'selected="selected"'; } ?>>7 - Other</option> </select></td> </tr> <?php for ($i=0, $n=sizeof($languages); $i<$n; $i++) { ?> <tr> <td class="main"><?php if ($i == 0) echo TEXT_PAGES_TITLE; ?></td> <td class="main"> <?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']). ' '.tep_draw_input_field('pages_title_'.$languages[$i]['id'], $pagetitle[$languages[$i]['id']], '', true); } ?> </td> </tr> <tr> <td class="main"><?php echo TEXT_PAGES_SORT_ORDER; ?></td> <td class="main"><?php echo tep_draw_separator('pixel_trans.gif', '24', '15') . ' ' . tep_draw_input_field('sort_order', $sortorder, '', false); ?></td> </tr> <tr> <td class="main"> </td> <td class="main"> </td> </tr> <?php for ($i=0, $n=sizeof($languages); $i<$n; $i++) { ?> <?php if(empty($intorext[$languages[$i]['id']]) or $intorext[$languages[$i]['id']] == "0") { $internalchecked="checked"; $externalchecked=""; $disabledlinkbox="disabled"; } else { $internalchecked=""; $externalchecked="checked"; $disabledlinkbox=""; } ?> <tr> <td class="main"><?php echo TEXT_PAGES_INTEXT; ?></td> <td class="main"> <?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']) ?><input type="radio" value="0" name="intorext_<?php echo $languages[$i]['id']; ?>" <?php echo $internalchecked; ?> onclick='disableIt("<?php echo 'externallink_'.$languages[$i]['id']; ?>");'><?php echo TEXT_TARGET_INTERNAL; ?> <?php echo tep_draw_separator('pixel_trans.gif', '24', '15'); ?><input type="radio" value="1" name="intorext_<?php echo $languages[$i]['id']; ?>" <?php echo $externalchecked;?> onclick='enableIt("<?php echo 'externallink_'.$languages[$i]['id']; ?>");'><?php echo TEXT_TARGET_EXTERNAL; ?> </td> </tr> <tr> <td class="main"><?php echo TEXT_PAGES_EXTERNAL_LINK; ?></td> <td class="main"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']).' '.tep_draw_input_field('externallink_'.$languages[$i]['id'], $externallink[$languages[$i]['id']], 'id='.'"externallink_'.$languages[$i]['id'].'"'. $disabledlinkbox, false); ?></td> </tr> <?php if(empty($link_target[$languages[$i]['id']]) or $link_target[$languages[$i]['id']] == "0") { $samewindowchecked="checked"; $newwindowchecked=""; }else { $samewindowchecked=""; $newwindowchecked="checked"; } ?> <tr> <td class="main"><?php echo TEXT_TARGET; ?></td> <td class="main"> <?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']);?><input type="radio" value="0" name="link_target_<?php echo $languages[$i]['id']; ?>" <?php echo $samewindowchecked; ?>><?php echo TEXT_TARGET_SAMEWINDOW; ?> <input type="radio" value="1" name="link_target_<?php echo $languages[$i]['id']; ?>" <?php echo $newwindowchecked; ?>><?php echo TEXT_TARGET_NEWWINDOW; ?> </td> </tr> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <?php } ?> <?php for ($i=0, $n=sizeof($languages); $i<$n; $i++) { ?> <tr> <td valign="top" class="main"><br> <td class="main"><?php echo tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name']). ' '.tep_draw_textarea_field('pages_html_text_'.$languages[$i]['id'],'soft','50','10', $pages_html_text[$languages[$i]['id']]); ?> </td> </tr> <?php } ?> <tr> <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '1', '10'); ?></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="main" align="center"><?php echo TEXT_PAGES_PAGE_NOTE . '<br>'; ?></td> <td class="main" align="right" valign="top" nowrap><?php echo (($form_action == 'insert') ? tep_image_submit('button_insert.gif', IMAGE_INSERT) : tep_image_submit('button_update.gif', IMAGE_UPDATE)). ' <a href="' . tep_href_link(FILENAME_PAGE_MANAGER, (isset($_GET['page']) ? 'page=' . $_GET['page'] . '&' : '') . (!empty($bID) and $bID != "" ? 'bID=' . $bID : '')) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'; ?></td> </tr> </table> <input type="hidden" name="bID" value="<?php echo $bID; ?>"> </td> </form></tr> <?php } else { ?> <tr> <td><table border="0" width="100%" cellspacing="0" cellpadding="0"> <tr> <td valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow" width="100%"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_PAGES; ?></td> <td class="dataTableHeadingContent"><?php echo TEXT_PAGES_TYPE; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_SORT_ORDER; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_STATUS; ?></td> <td class="dataTableHeadingContent"></td> <td class="dataTableHeadingContent"></td> </tr> <?php $pages_query_raw = "select p.pages_id, p.status, p.page_type, p.sort_order, s.pages_title from " . TABLE_ABOUT_US . " p LEFT JOIN " .TABLE_ABOUT_US_DESCRIPTION . " s on p.pages_id = s.pages_id where s.language_id='" . (int)$languages_id . "' order by p.sort_order, s.pages_title"; $pages_split = new splitPageResults($_GET['page'], MAX_DISPLAY_SEARCH_RESULTS, $pages_query_raw, $pages_query_numrows); $pages_query = tep_db_query($pages_query_raw); while ($pages = tep_db_fetch_array($pages_query)) { if ((!isset($_GET['bID']) || (isset($_GET['bID']) && ($_GET['bID'] == $pages['pages_id']))) && !isset($bInfo) && (substr($action, 0, 3) != 'new')) { $bInfo_array = array_merge($pages, (array) $info); $bInfo = new objectInfo($bInfo_array); } if (isset($bInfo) && is_object($bInfo) && ($pages['pages_id'] == $bInfo->pages_id)) { echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_PAGE_MANAGER, 'page=' . $_GET['page'] . '&bID=' . $pages['pages_id']) . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_PAGE_MANAGER, 'page=' . $_GET['page'] . '&bID=' . $pages['pages_id']) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo '<a href="javascript:popupImageWindow(\'' . FILENAME_POPUP_IMAGE . '?page=' . $pages['pages_id'] . '\')">' . tep_image(DIR_WS_IMAGES . 'icon_popup.gif', 'View Page') . '</a> ' . $pages['pages_title']; ?></td> <td class="dataTableContent"><?php echo $pages['page_type']; ?></td> <td class="dataTableContent"><?php echo $pages['sort_order']; ?></td> <td class="dataTableContent" align="center"> <?php if ($pages['status'] == '1') { echo tep_image(DIR_WS_IMAGES . 'icon_status_green.gif', 'Active', 10, 10) . ' <a href="' . tep_href_link(FILENAME_PAGE_MANAGER, 'page=' . $_GET['page'] . '&bID=' . $pages['pages_id'] . '&action=setflag&flag=0') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_red_light.gif', 'Set Inactive', 10, 10) . '</a>'; } else { echo '<a href="' . tep_href_link(FILENAME_PAGE_MANAGER, 'page=' . $_GET['page'] . '&bID=' . $pages['pages_id'] . '&action=setflag&flag=1') . '">' . tep_image(DIR_WS_IMAGES . 'icon_status_green_light.gif', 'Set Active', 10, 10) . '</a> ' . tep_image(DIR_WS_IMAGES . 'icon_status_red.gif', 'Inactive', 10, 10); } ?> </td> <td class="dataTableContent" align="right"></td> <td class="dataTableContent" align="right"></td> </tr> <?php } ?> <tr> <td colspan="5"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr> <td class="smallText" valign="top"><?php echo $pages_split->display_count($pages_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $_GET['page'], TEXT_DISPLAY_NUMBER_OF_PAGES); ?></td> <td class="smallText" align="right"><?php echo $pages_split->display_links($pages_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $_GET['page']); ?></td> </tr> <tr> <td align="right" colspan="2"><?php echo '<a href="' . tep_href_link(FILENAME_PAGE_MANAGER, 'action=new') . '">' . tep_image_button('button_new_file.gif', IMAGE_NEW_PAGE) . '</a>'; ?></td> </tr> </table></td> </tr> </table></td> <?php $heading = array(); $contents = array(); switch ($action) { case 'delete': $heading[] = array('text' => '<b>' . $bInfo->pages_title . '</b>'); $contents = array('form' => tep_draw_form('pages', FILENAME_PAGE_MANAGER, 'page=' . $_GET['page'] . '&bID=' . $bInfo->pages_id . '&action=deleteconfirm')); $contents[] = array('text' => TEXT_INFO_DELETE_INTRO); $contents[] = array('text' => '<br><b>' . $bInfo->pages_title . '</b>'); if ($bInfo->pages_image) $contents[] = array('text' => '<br>' . tep_draw_checkbox_field('delete_image', 'on', true) . ' ' . TEXT_INFO_DELETE_IMAGE); $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_PAGE_MANAGER, 'page=' . $_GET['page'] . '&bID=' . $_GET['bID']) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>'); break; default: if (is_object($bInfo)) { $heading[] = array('text' => '<b>' . $bInfo->pages_title . '</b>'); $contents[] = array('align' => 'center', 'text' => '<br><br><a href="' . tep_href_link(FILENAME_PAGE_MANAGER, 'page=' . $_GET['page'] . '&bID=' . $bInfo->pages_id . '&action=new') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_PAGE_MANAGER, 'page=' . $_GET['page'] . '&bID=' . $bInfo->pages_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a><br><br><br>'); if ($bInfo->date_scheduled) $contents[] = array('text' => '<br>' . sprintf(TEXT_PAGES_SCHEDULED_AT_DATE, tep_date_short($bInfo->date_scheduled))); if ($bInfo->expires_date) { $contents[] = array('text' => '<br>' . sprintf(TEXT_PAGES_EXPIRES_AT_DATE, tep_date_short($bInfo->expires_date))); } elseif ($bInfo->expires_impressions) { $contents[] = array('text' => '<br>' . sprintf(TEXT_PAGES_EXPIRES_AT_IMPRESSIONS, $bInfo->expires_impressions)); } if ($bInfo->date_status_change) $contents[] = array('text' => '<br>' . sprintf(TEXT_PAGES_STATUS_CHANGE, tep_date_short($bInfo->date_status_change))); } break; } if ( (tep_not_null($heading)) && (tep_not_null($contents)) ) { echo ' <td width="25%" valign="top">' . "\n"; $box = new box; echo $box->infoBox($heading, $contents); echo ' </td>' . "\n"; } ?> </tr> </table></td> </tr> <?php } ?> </table> <?php require(DIR_WS_INCLUDES . 'template_bottom.php'); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?> I think the issue is somewhere in the call to the DB tables and columns.
  8. L. Haase

    Contribution Issue

    I have this working perfectly and I am trying to duplicate it to an "About Us" box module. I have modified all the files from "extrainfopages" and it's variant "extra_info_pages(_manager).php" to "extraaboutus" and "extra_about_us" and modified all appropriate coding within each new file. I have also modified the insertion codes in the filenames.php and databasetables.php in both directories noted. I also changed the sql to create tables called "about _us" and "about_us_description". The sql set up properly. My issue seems to be within the call to the sql tables within catalog/admin/extra_about_us_pages.php (formerly extra_info_pages.php) so that I am getting the following error. 1054 - Unknown column 'p.pages_id' in 'on clause' select count(*) as total from about_us p LEFT JOIN about_us_description s on p.pages_id = s.pages_id where s.language_id='1' I think this is somewhere within the following code: // Sets the status of a page function tep_set_page_status($pages_id, $status) { if ($status == '1') { return tep_db_query("update " . TABLE_ABOUT_US . " set status = '1' where pages_id = '" . $pages_id . "'"); } elseif ($status == '0') { return tep_db_query("update " . TABLE_ABOUT_US . " set status = '0' where pages_id = '" . $pages_id . "'"); } else { return -1; } } and other similar code. My question is since I changed the "extra_pages_..." reference and the table names to "about_us" and "about_us_description", is there something within this type of call I also need to change, for example the "$pages_id" to "$about_us_id" or something similar. (I actually tried this and it didnt work.) My issue is I have little to no experience with sql other than being able to import/export, perform a query (add into the database) and other limited changes. I am hoping someone can point me in the right direction according to the error message or at least tell me what it means. It seems to me it is the p.pages_id in the file.
  9. Agreed. I am in no way a programmer although I do understand HTML and CSS. PHP and MySQL escape me other than being able to recognize opening and closing tags sometimes. It was your fix on my USPS and a comment on this topic that made me try it. I had tried copying the correctly formatted code directly into the server file and it still came up garbled again. It was only by transferring binary that it worked in this specific instance. I use Filezilla and set my default editor to wordpad instead of notepad. That might have something to do with the code being garbled when opened. I know wordpad allows some formatting that notepad does not. I do know that the simpler the editor you use (pure text editor) the less likely you will have formatting issues come up but I just don't like notepad's wrap function. It makes it difficult to read the code without the indents and line breaks. I have your box here. Adding products as they cure.
  10. Jim, you were the person who told me that you had to fix my USPS by transferring the usps.php as binary instead of ascii to get my module to work a few months ago. Don't you rememeber?
  11. I am unsure whether anyone monitors this topic or not but I have a simple styling question. I have installed this module, everything I want to add works perfectly but instead of a right alignment on the sub-footer, I want a center alignment. I have tried many different things in the places I thought it would work but can't find the answer. Any ideas?
  12. I have resolved the error of "unexpected T_CLASS on line 1" with some help of another answer here. I thought I would post a more recent fix to this for anyone else who is having this issue. The problem comes from the type of ftp transfer you are doing, Typically an all text file would be transferred by ASCII and images, videos and other files by binary however for some reason, and I have seen this before, the coding is written in such a manner that some hosting companies settings interpret this incorrectly. If you get these parse errors, make note of the file it is saying is creating the error. You will probably see a few as you go through this fix. Instead of copying and pasting from the original file to the server file, try transferring as a binary file first. Check your FTP manager settings to find where you can change from AUTO to BINARY.
  13. L. Haase

    Contribution Issue

    John, you make a very good point, something in all my brilliance (yeah, right) I should have thought of myself. All kidding about my intelligence aside, it is a great idea and one that I will follow. I did get this contribution installed and working perfectly. I have even made some changes, minor that they are, to change the box name to something which is appropriate for my site. As usual, it was my own error, I missed one of the filenames.php file insertions.
  14. L. Haase

    Credit Class & Gift Vouchers for 2.3.4

    I copied this code exactly into my catalog/checkout_payment.php file, refreshed the site and still I am getting the error message that I must select a payment method even when I tick the voucher credit field. Still not working.
  15. L. Haase

    Contribution Issue

    I too am having the same issue with this contribution that the link in admin/tools to the page is non-functioning. It tries to reference a file called "page_manager.php" which is non-existent. What am I missing? Generally when this error occurs it is because the file was not uploaded however there was no such file in the most current download.
×