Jump to content

Nathali

Members
  • Content count

    364
  • Joined

  • Last visited

Posts posted by Nathali


  1. Hi,

     

    Could someone help please,

     

    When I go to admin. panel to faq manager.. I see all of them, and I can select them, so they have to be saved correctly in the database with the right ID's numbers.

    The problem is when I select a question and press the EDIT button then I see the edit page without the TEXT inside !

    I have OSC 2.2ms and tinymce installed and my admin/faq.php file I posted above..

     

    Any advises ? thanks

    Nathali


  2. Did u double check your install, did you run the sql?

     

    Hi spook !

     

    Thank you for helping me again..

     

    When I go to admin. panel to faq manager.. I see all of them, and I can select them, so they have to be saved correctly in the database with the right ID's numbers.

    The problem is when I select a question and press the EDIT button then I see the edit page without the TEXT inside !

    I have OSC 2.2ms and tinymce installed and here is my admin/faq.php file:

     

    I really appreciate you help.. Thank you !

     

    Nathali

     

    <?php

    /*

    $Id: FAQDesk 2.1

     

    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');

     

    $fID = (!empty($HTTP_GET_VARS['fID']) ? (int)$HTTP_GET_VARS['fID'] : 0 );

    $action = (!empty($HTTP_GET_VARS['action']) ? $HTTP_GET_VARS['action'] : '' );

    $languages = tep_get_languages();

    switch($action){

    case 'setflag':

    if( !empty($fID) && isset($HTTP_GET_VARS['flag']) && ( $HTTP_GET_VARS['flag'] == '1' || $HTTP_GET_VARS['flag'] == '0' ) ){

    tep_db_query('update '.TABLE_FAQ.' set faq_status='.$HTTP_GET_VARS['flag'].' where faq_id='.$fID.'');

    }

    tep_redirect(tep_href_link(FILENAME_FAQ, (isset($HTTP_GET_VARS['page']) ? 'page='.$HTTP_GET_VARS['page'].'&' : '' ).'iID='.$fID));

    break;

    case 'insert':

    case 'update':

    $sort_order = (int)$HTTP_POST_VARS['sort_order'];

    //echo $sort_order .'<br>';

    $faq_status = !empty($HTTP_POST_VARS['faq_status']) ? '1' : '0';

     

    $sql_data_array = array('sort_order' => $sort_order,

    'last_modified' => 'now()',

    'faq_status' => $faq_status);

     

    if ($action == 'insert') {

    tep_db_perform(TABLE_FAQ, $sql_data_array);

    $fID = tep_db_insert_id();

    } elseif ($action == 'update') {

    tep_db_perform(TABLE_FAQ, $sql_data_array, 'update', "faq_id = '".(int)$fID."'");

    }

     

    for ($i=0,$n=sizeof($languages);$i<$n;$i++) {

    $faq_question_array = $HTTP_POST_VARS['faq_question'];

    $faq_answer_array = $HTTP_POST_VARS['faq_answer'];

    $language_id = $languages[$i]['id'];

     

    $sql_data_array = array('faq_question' => tep_db_prepare_input($faq_question_array[$language_id]),

    'faq_answer' => tep_db_prepare_input($faq_answer_array[$language_id]),

    );

     

    if ($action == 'insert') {

    $insert_sql_data = array('faq_id' => (int)$fID,

    'language_id' => (int)$language_id);

    $sql_data_array = array_merge($sql_data_array, $insert_sql_data);

     

    tep_db_perform(TABLE_FAQ_DESCRIPTION, $sql_data_array);

    } elseif ($action == 'update') {

    tep_db_perform(TABLE_FAQ_DESCRIPTION, $sql_data_array, 'update', "faq_id = '".(int)$fID."' and language_id = '".(int)$language_id . "'");

    }

    }

     

    tep_redirect(tep_href_link(FILENAME_FAQ, (isset($HTTP_GET_VARS['page']) ? 'page='.$HTTP_GET_VARS['page'].'&' : '') . 'fID=' . $fID));

    break;

    case 'deleteconfirm':

    $faq_id = tep_db_prepare_input($HTTP_GET_VARS['fID']);

     

    tep_db_query("delete from " . TABLE_FAQ . " where faq_id = '".(int)$fID."'");

    tep_db_query("delete from " . TABLE_FAQ_DESCRIPTION . " where faq_id = '".(int)$fID."'");

     

    tep_redirect(tep_href_link(FILENAME_FAQ, 'page=' . $HTTP_GET_VARS['page']));

    break;

     

    }

     

     

    ?>

    <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

    <html <?php echo HTML_PARAMS; ?>>

    <head>

    <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

    <title><?php echo TITLE; ?></title>

    <link rel="stylesheet" type="text/css" href="includes/stylesheet.css">

    <script language="javascript" src="includes/general.js"></script>

    <script language="JavaScript">

    function showItem(id){

    var item = document.getElementById(id);

    if (item){

    if (!item.style.display || item.style.display == '' )

    item.style.display = 'none';

    else

    item.style.display = '';

    }

    }

    </script>

    </head>

    <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="SetFocus();">

    <!-- header //-->

    <?php require(DIR_WS_INCLUDES . 'header.php'); ?>

    <!-- header_eof //-->

     

    <!-- body //-->

    <table border="0" width="100%" height="80%" cellspacing="2" cellpadding="2">

    <tr>

    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="1" cellpadding="1" class="columnLeft">

    <!-- left_navigation //-->

    <?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

    <!-- left_navigation_eof //-->

    </table></td>

    <!-- body_text //-->

    <td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="2">

    <tr>

    <td width="100%"><table border="0" width="100%" cellspacing="0" cellpadding="0">

    <tr>

    <td class="pageHeading"><?php echo HEADING_TITLE; ?></td>

    </tr>

    </table></td>

    </tr>

    <tr>

    <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10')?></td>

    </tr>

    <?php

    if ( $action == 'new_faq' || $action == 'edit_faq' ){

     

    $faq_info_query = tep_db_query('select f.faq_id, fd.language_id, fd.faq_question, fd.faq_answer, f.last_modified, f.sort_order, f.faq_status from '.TABLE_FAQ.' f, '.TABLE_FAQ_DESCRIPTION.' fd where f.faq_id=fd.faq_id and f.faq_id='.(int)$fID);

    $faq_info = array();

    $faq_info['faq_question'] = array();

    $faq_info['faq_answer'] = array();

     

    while($faq = tep_db_fetch_array($faq_info_query)){

    $faq_info['status'] = $faq['faq_status'];

    $faq_info['question'][$faq['language_id']] = $faq['faq_question'];

    $faq_info['answer'][$faq['language_id']] = $faq['faq_answer'];

    $faq_info['sort_order'] = $faq['sort_order'];

     

    }

    $submit = ($action == 'edit_faq' ? tep_image_submit('button_update.gif', IMAGE_UPDATE) : tep_image_submit('button_insert.gif', IMAGE_INSERT));

    ?>

    <tr>

    <td>

    <?php echo tep_draw_form('new_faq', FILENAME_FAQ, ( empty($fID) ? 'action=insert' : 'action=update&fID='.$fID) );?>

    <table border="0" width="100%" cellspacing="0" cellpadding="2">

    <tr>

    <td class="main" align="right" colspan="2"><?php echo $submit . ' <a href="'.tep_href_link(FILENAME_FAQ, tep_get_all_get_params(array('action'))).'">'.tep_image_button('button_cancel.gif', IMAGE_CANCEL).'</a>' ;?></td>

    </tr>

    <tr>

    <td class="main" valign="top"><?php echo TITLE_STATUS;?></td>

    <td class="main" valign="top"><?php echo TEXT_ON.tep_draw_radio_field('faq_status', '1', ($faq_info['status'] ? true : false) ).'   '.TEXT_OFF.tep_draw_radio_field('faq_status', '0', ($faq_info['status'] ? false : true) );?></td>

    </tr>

    <tr>

    <td class="main" valign="top"><?php echo TITLE_SORT;?></td>

    <td class="main" valign="top"><?php echo tep_draw_input_field('sort_order', ( !empty($faq_info['sort_order']) ? $faq_info['sort_order'] : 0 ), ' size="4" ');?></td>

    </tr>

    <tr>

    <td class="main" valign="top"><?php echo TITLE_ADD_QUESTION;?></td>

    <td class="main" valign="top"><table border="0" cellspacing="0" cellpadding="2"><?php

    for($i=0,$x=count($languages);$i<$x;$i++){

    if ( !empty($faq_info['question'][$languages[$i]['id']]) ){

    $faq_question = $faq_info['question'][$languages[$i]['id']];

    } else {

    $faq_question = '';

    }

     

    echo '<tr>

    <td class="main" valign="top">' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name'], '', '', '', false).'</td>

    <td class="main" valign="top">' . tep_draw_textarea_field('faq_question['.$languages[$i]['id'].']','soft','70','3',$faq_question) . '</td>

    </tr>';

    }

    ?></table></td>

    </tr>

    <tr>

    <td class="main" valign="top"><?php echo TITLE_ADD_ANSWER;?></td>

    <td class="main" valign="top"><table border="0" cellspacing="0" cellpadding="2"><?php

    for($i=0,$x=count($languages);$i<$x;$i++){

    if ( !empty($faq_info['answer'][$languages[$i]['id']]) ){

    $faq_answer = $faq_info['answer'][$languages[$i]['id']];

    } else {

    $faq_answer = '';

    }

     

    echo '<tr>

    <td class="main" valign="top">'.tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name'], '', '', '', false).'</td>

    <td class="main" valign="top">'.tep_draw_textarea_field('faq_answer['.$languages[$i]['id'].']','soft','70','10',$faq_answer).'</td>

    </tr>';

    }

    ?></table></td>

    </tr>

    <tr>

    <td class="main" align="right" colspan="2"><?php echo $submit . ' <a href="'.tep_href_link(FILENAME_FAQ, tep_get_all_get_params(array('action'))).'">'.tep_image_button('button_cancel.gif', IMAGE_CANCEL).'</a>' ;?></td>

    </tr>

    </table>

    </form>

    </td>

    </tr>

    <?php

     

    } elseif ($action == 'preview_faq'){

    $plid = (isset($HTTP_GET_VARS['prevlang']) ? $HTTP_GET_VARS['prevlang'] : $languages_id);

    $faq_query = tep_db_query('select f.faq_id, fd.faq_question, fd.faq_answer, f.last_modified, f.sort_order, f.faq_status from '.TABLE_FAQ.' f, '.TABLE_FAQ_DESCRIPTION.' fd where f.faq_id=fd.faq_id and f.faq_status and fd.language_id=' . (int)$plid . ' order by f.sort_order, fd.faq_id');

    ?>

    <tr>

    <td class="main"><?php echo TEXT_CLICK_REVEAL; ?></td>

    <td class="main" align="right"><?php echo '<a href="'.tep_href_link(FILENAME_FAQ, tep_get_all_get_params(array('action'))).'">'.tep_image_button('button_back.gif', IMAGE_BACK).'</a>';?></td>

    </tr>

    <tr>

    <td style="padding-left:20px;"><table border="0" cellspacing="0" cellpadding="0">

    <?php

    while($faq = tep_db_fetch_array($faq_query)){

    ?>

    <tr>

    <td colspan="2" class="main"><b style="cursor:pointer;" onclick="showItem('faq_answer_<?php echo $faq['faq_id'];?>')"><?php echo $faq['faq_question'];?></b><br><small><?php echo TEXT_LAST_UPDATED.$faq['last_modified'];?></small></td>

    </tr>

    <tr>

    <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '5')?></td>

    </tr>

    <tr>

    <td colspan="2" class="main" style="display:none;" id="faq_answer_<?php echo $faq['faq_id'];?>"><?php echo $faq['faq_answer'];?></td>

    </tr>

    <tr>

    <td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10')?></td>

    </tr>

    <?php

    }

    ?>

    </td></table>

    </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">

    <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_FAQ_ID; ?></td>

    <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_FAQ_QUESTION; ?></td>

    <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_FAQ_STATUS; ?></td>

    <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_FAQ_LAST_MODIFIED; ?></td>

    </tr>

    <?php

    $faq_query_numrows = 0;

    $faq_query_raw = 'select f.faq_id, fd.faq_question, fd.faq_answer, f.last_modified, f.sort_order, f.faq_status from '.TABLE_FAQ.' f, '.TABLE_FAQ_DESCRIPTION.' fd where f.faq_id=fd.faq_id and fd.language_id=' . (int)$languages_id . ' order by f.sort_order, fd.faq_id';

    $faq_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $faq_query_raw, $faq_query_numrows);

    $faq_query = tep_db_query($faq_query_raw);

    while ($faq = tep_db_fetch_array($faq_query)) {

    if ((!isset($HTTP_GET_VARS['fID']) || (isset($HTTP_GET_VARS['fID']) && ($HTTP_GET_VARS['fID'] == $faq['faq_id']))) && !isset($fInfo)) {

    $fInfo = new objectInfo($faq);

    }

     

    if (isset($fInfo) && is_object($fInfo) && ($faq['faq_id'] == $fInfo->faq_id)) {

    echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_FAQ, 'page=' . $HTTP_GET_VARS['page'] . '&fID=' . $faq['faq_id'] . '&action=edit_faq') . '\'">' . "\n";

    } else {

    echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_FAQ, 'page=' . $HTTP_GET_VARS['page'] . '&fID=' . $faq['faq_id']) . '\'">' . "\n";

    }

    ?>

    <td class="dataTableContent" align="center"><?php echo $faq['faq_id']; ?></td>

    <td class="dataTableContent" width="70%"><?php echo $faq['faq_question']; ?></td>

    <td class="dataTableContent" align="center"><?php

    if ($faq['faq_status'] == '1') {

    echo tep_image( DIR_WS_IMAGES . 'icon_status_green.gif', IMAGE_ICON_STATUS_GREEN, 10, 10) . '  <a href="' . tep_href_link(FILENAME_FAQ, 'action=setflag&flag=0&fID=' . $faq['faq_id'] ) . '">' . tep_image( DIR_WS_IMAGES . 'icon_status_red_light.gif', IMAGE_ICON_STATUS_RED_LIGHT, 10, 10) . '</a>';

    } else {

    echo '<a href="' . tep_href_link(FILENAME_FAQ, 'action=setflag&flag=1&fID=' . $faq['faq_id']) . '">' . tep_image( DIR_WS_IMAGES . 'icon_status_green_light.gif', IMAGE_ICON_STATUS_GREEN_LIGHT, 10, 10) . '</a>  ' . tep_image( DIR_WS_IMAGES . 'icon_status_red.gif', IMAGE_ICON_STATUS_RED, 10, 10);

    }

    ?></td>

    <td class="dataTableContent" align="center"><?php echo $faq['last_modified']; ?></td>

    </tr>

    <?php

    }

    ?>

    <tr>

    <td colspan="4"><table border="0" width="100%" cellspacing="0" cellpadding="2">

    <tr>

    <td class="smallText" valign="top"><?php echo $faq_split->display_count($faq_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, $HTTP_GET_VARS['page'], TEXT_DISPLAY_NUMBER_OF_QUESTIONS); ?></td>

    <td class="smallText" align="right"><?php echo $faq_split->display_links($faq_query_numrows, MAX_DISPLAY_SEARCH_RESULTS, MAX_DISPLAY_PAGE_LINKS, $HTTP_GET_VARS['page']); ?></td>

    </tr>

    </table></td>

    </tr>

    <tr>

    <td align="right" colspan="4" class="smallText"><?php echo '<a href="' . tep_href_link(FILENAME_FAQ, 'page='.$HTTP_GET_VARS['page'].'&action=new_faq') . '">' . tep_image_button('button_insert.gif', IMAGE_INSERT) . '</a><br>';

    for($i=0,$x=count($languages);$i<$x;$i++){

    echo '<a href="' . tep_href_link(FILENAME_FAQ, 'page='.$HTTP_GET_VARS['page'].'&action=preview_faq&prevlang=' . $languages[$i]['id']) . '">' . tep_image_button('button_preview.gif', IMAGE_PREVIEW) . ' ' . tep_image(DIR_WS_CATALOG_LANGUAGES . $languages[$i]['directory'] . '/images/' . $languages[$i]['image'], $languages[$i]['name'], '', '', '', false) . '</a><br>';

    }

    ?>

    </td>

    </tr>

    </table></td>

    <?php

    $heading = array();

    $contents = array();

     

    switch ($action) {

    case 'delete':

    $heading[] = array('text' => '<b>' . sprintf(TEXT_HEADING_DELETE_INTRO, $fInfo->faq_id) . '</b>');

     

    $contents = array('form' => tep_draw_form('faq', FILENAME_FAQ, 'page=' . $HTTP_GET_VARS['page'] . '&fID=' . $fInfo->faq_id . '&action=deleteconfirm'));

    $contents[] = array('text' => '<br /><b>'.TEXT_QUESTION.'</b><br />' . $fInfo->faq_question );

    $contents[] = array('text' => '<br /><b>'.TEXT_ANSWER.'</b><br>' . $fInfo->faq_answer );

     

    if ($fInfo->products_count > 0) {

    $contents[] = array('text' => '<br>' . tep_draw_checkbox_field('delete_products') . ' ' . TEXT_DELETE_PRODUCTS);

    $contents[] = array('text' => '<br>' . sprintf(TEXT_DELETE_WARNING_PRODUCTS, $fInfo->products_count));

    }

     

    $contents[] = array('align' => 'center', 'text' => '<br>' . tep_image_submit('button_delete.gif', IMAGE_DELETE) . ' <a href="' . tep_href_link(FILENAME_FAQ, 'page=' . $HTTP_GET_VARS['page'] . '&fID=' . $fInfo->faq_id) . '">' . tep_image_button('button_cancel.gif', IMAGE_CANCEL) . '</a>');

    break;

    default:

    if (isset($fInfo) && is_object($fInfo)) {

    $heading[] = array('text' => '<b> #' . $fInfo->faq_id . '</b>');

     

    $contents[] = array('align' => 'center', 'text' => '<a href="' . tep_href_link(FILENAME_FAQ, 'page=' . $HTTP_GET_VARS['page'] . '&fID=' . $fInfo->faq_id . '&action=edit_faq') . '">' . tep_image_button('button_edit.gif', IMAGE_EDIT) . '</a> <a href="' . tep_href_link(FILENAME_FAQ, 'page=' . $HTTP_GET_VARS['page'] . '&fID=' . $fInfo->faq_id . '&action=delete') . '">' . tep_image_button('button_delete.gif', IMAGE_DELETE) . '</a>');

     

    $contents[] = array('text' => '<br /><b>'.TEXT_QUESTION.'</b><br />' . $fInfo->faq_question );

    $contents[] = array('text' => '<br /><b>'.TEXT_ANSWER.'</b><br>' . $fInfo->faq_answer );

    }

    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>

     

    <?php

    }

    ?>

    </table></td>

    <!-- body_text_eof //-->

    </tr>

    </table>

    <!-- body_eof //-->

     

    <!-- footer //-->

    <?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

    <!-- footer_eof //-->

    <br>

    </body>

    </html>

    <?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>


  3. Hi everyone,

     

    I would like to install PHPlist mailer. I want to install it on my host server, BUT as a separate unit from my OSCommerce.

    (folder as xxxxxx.co.il/phplist & sepearated php database)

     

    My questions are:

    1. Can I install it by fantastico tool I have on my Cpanel, without worry that this tool will trash my OSCommerce ? or it is

    better todo it manually ?

    2. If it safe to install by Fantastico, what variables I had to fill before the installation start? Is it written somewhere here ?

    Please advise and do not reply as "go and read in phplist installation guide!" :D (I'm tired from reading installations

    guides)

    3. If in the future I would like to integrate the newsletters will not be a problem.

    4. I would like to use PHPlist to send mass emails to dealers & computer stores, what should I be aware of when I will

    install PHPlist? (contacts groups, additional scripts etc.. )

     

    If I made an headache to one of you from my long questions, please accept my apology in advance.. :)

     

    Waiting please to any advise from you.. Thanks a lot!

     

    Nathali


  4. Hi,

     

    I installed FAQ2.2 and I have one problem.

     

    I can't EDIT the question/answer ! when I push the EDIT button, I don't see any text in the languages text boxes !

     

    Any help please?

     

    Thanks a lot,

    Nathali


  5. "the main" is really subjective, but have you looked at any of the last 3 versions I posted?

     

     

    Hi Todd,

     

    Did you reply to my question that was: "Is there a version that solves the main issue regarding Multi-language category support?? " If yes, then thank you very much !

     

    pls, I will explain..

     

    First, I use Easy Populate 2.76d-MS2

    $Id: easypopulate.php,v 2.76d 2006/10/16 22:50:52 surfalot Exp $

     

    I always preffered to choose to install your contributions.. ;-)

     

    I know that your version supports Multi languages and it is possible to upload products and categories. BUT there was an issue when you where switching languages while you where in a specific "product info" page, you didn't get the same parallel "product info" page on the other language.. you had to upload first on your choosen language then to open categories and products descriptions and copy then one by one, to be able todo what I mentioned above..

     

    Hope you understand what I mean, because it is difficult for me to explain, but PHP programmers will understand the meaning quite easy.. )

     

    Hope to get your reply soon, because I have a lot of products and categories to upload (multi lang.) , and it will really make my life much much easier !!

     

    Thanks for your attention,

     

    Nathali


  6. Hi,

     

    I installed "information pages unlimited" .

     

    I would like to hide sub pages on Information text Box on main page.. that only parents pages will be shown !

     

    Any advise please, where and what to Commet in the code..

     

    Thanks a lot for your help..

     

    Best Regards,

    Nathali

     

    Any help please !!

     

    Thanks..


  7. Hi,

     

    I installed the contribution 3.62 full package by Dear Scott and I am sure I missed something..

     

    I checked again and again and it looks like I installed it correct.

     

    My problem is that I don't see the "Testimonial box" on the index page !

     

    I have mysql MySQL 4.1.22 and php 5.

     

    Could someone advise please how to solve this mystery ?

     

    Thanks & regards,

    Nathali

     

    I found the "problem"...

     

    I had to enter the first Testimonial that the box will appear.

     

    Great contribution thanks to the authors !

     

    Regards,

    Nathali


  8. Hi,

     

    I installed the contribution 3.62 full package by Dear Scott and I am sure I missed something..

     

    I checked again and again and it looks like I installed it correct.

     

    My problem is that I don't see the "Testimonial box" on the index page !

     

    I have mysql MySQL 4.1.22 and php 5.

     

    Could someone advise please how to solve this mystery ?

     

    Thanks & regards,

    Nathali


  9. happy ny to you as well!

     

    here's what i found on the phponline forum:

     

    If you forgotten your admin login and/ or password, You need to reset everything to factory default. To do that drop all MySQL tables and let them to be created again. Then you may login with admin as username and adm123 as password.

     

    Thanks!

     

    Scott

     

    Thanks a lot Scott !

     

    So which MySQL tables I should delete? "bvars" & "msgdb" & "cs" ?

     

    Thanks,

    Nath


  10. you can look it up in the store database in the "bvars" table...

     

    Scott

     

    Hi Scott !

     

    How are you?

     

    I looked in the database in the "bvars" table, and I see there only this:

    bname bvalue

    conf_GEmailSubject Message from online support

    conf_Msg1 Please Wait...

    conf_Msg2 Locating an Available and Online

    Customer Service ...

     

     

     

    I think it's not there..

     

    Is there another place I could look for?

     

    Thanks Scott,

     

    Happy New Year,

    Nath


  11. you didn't make a backup of the database before trying that? Always backup the database before doing thing with EP. And if you follow this help, PLEASE, backup before.

     

    I suppose the way I would go about removing a product that doesn't show in the admin or shop is to use phpMyAdmin. It is a database management tool often included/offered by your host.

     

    go into the products table, sort by products_model (click the column header) and look for the one you inserted. Write down the products_id it was given.

     

    Then you can use the SQL tab in phpMyAdmin to issue these commands (replacing the xxxx with the products_id you found).

     

    delete from products where products_id = 'xxxx';
    delete from products_description where products_id = 'xxxx';
    delete from products_to_categories where products_id = 'xxxx';

     

    Thanks dear surfalot for your kind & clear instructions !!

     

    All the best,

    Nathali


  12. if it is creating a new product, that means EP is not finding the model number in the database. Could mean that the model number for the product you wish to change has a space or other characters you havn't included in the EP update file. Or maybe the EP update file has a space or other odd character in the model number that shouldn't be there.

     

    Thanks a lot Surfalot for your kind reply !

     

    I try to look for it, to delete it ,and I could't find it !?

     

    What should I do or how I can find it in the database and delete it ?

     

    Thanks,

     

    Nathali


  13. Hello,

     

    I have easypopulate 2.76d and it works fine.

     

    I have a little problem, that when I upload to update prices, it created to me a new product even that I didn't create a new product ???

     

    I try to look for it, to delete it ,and I could't find it !?

     

    Any advises where to search and how I solve this issue from coming again ??

     

    Thanks for the attention and will be glad to get some help..

     

    Regards,

    Nathali


  14. Hi,

     

    I use this contribution and it is really great. Thanks for the authors.

     

    I would like please to add a soft border lines between every page in the information pages unlimited Box.

     

    like that:

     

    who we are?

    ----------------------------

    international customers

    ----------------------------

    contact us

     

    Could someone help me please, what should I modify ?

     

    Thanks,

     

    Nathali


  15. Hello, I've got this great contribution working because of all the reactions on this topic.

    Only having a major problem for wich I can't find the solution.

     

    After a new customer creates an account he/she receives an confirmation email, normally.

     

    But in my case they only receive the following text;

     

    VARTABLE1

    VARLOGO

    VARTABLE2 EMAILGREET_MS

     

    EMAILWELCOMEEMAILTEXTEMAILCONTACTEMAILWARNING

    EMAIL_TEXT_FOOTER

     

    Is there anyone who has the solution to this problem?

     

     

    Hi,

     

    It seems like you didn't complete all the installation instructions.

     

    It looks like that you didn't modify the parts of the installation that related to the langauges modification.

     

    Check step by step again, where you missed..

     

    Let us know..

     

    Regards,

     

    Nathali


  16. Hi,

     

    I installed contribution: "Timezone Offset Module"

     

    The installation is:

    Contribution: Timezone Offset Module

    Designed for: Zen Cart v1.2.3 Release. Modified to work on osCommerce 2.2 MS2

    Originally Designed for Zen Cart by: Neville Kerr njkerr@earthlink.net

    Modified for osCommerce by: Dr_Lucas

    License: under the GPL - See attached License for info.

    Support: http://forums.oscommerce.com/index.php?showtopic=203878

     

    ========================================================

     

    WHAT DOES THIS MODULE DO?

     

    This module allows you to set a time zone offset into the cart if you are in a situation where your store is in a different time zone from the server on which it is hosted. (For example, your store is based in Australia but is hosted on a server in the USA.) This situation can become a problem for accounting because order dates will not be accurate for the store time zone.

    The module will also make the entire store and admin display the right date and time of your real location.

     

    The module inserts a new configuration key into the database that sets the value of the time zone difference. The offset value is set from Admin>Configuration>My Store>Time Zone Offset.

     

    All orders will have their 'date_purchased' value corrected for the timezone difference when they are inserted into the database. This corrected value will be displayed on all admin pages, on the customer's 'My Account' page

     

    ========================================================

     

    INSTALLATION

     

    Step 1. Use phpMyAdmin or a similar db manager to run the query in paragraph 1 below. This will add the TIME_ZONE_OFFSET configuration key into your database.

     

    Step 2. Make sure that you have BACKUP(!!!) copies of your original files.

     

    Step 3. Modify the seven files as described below

     

    Step 4. From your store admin panel, select Configuration>My Store. The new Time Zone Offset field should now be on that page: set the offset you require.

     

    That's it: you're done!

     

    ========================================================

     

    HISTORY:

     

    10/Apr/2006 - Initial Release

    01/Sep/2006 - Added support for order confirmation and status change emails as well as footer of site (Steps 4, 6, 9, 10, 11)

     

    ========================================================

     

    FILE MODIFICATIONS:

     

    includes/functions/database.php

    admin/includes/functions/database.php

    includes/languages/english.php

    admin/includes/languages/english.php

    includes/footer.php

    admin/orders.php

    checkout_process.php

     

    =======================================================

    1) RUN THE FOLLOWING SQL ON YOUR SQL DATABASE:

     

    INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Time Zone Offset', 'TIME_ZONE_OFFSET', '0', 'The time zone difference between your store and the server. Enter +h, 0 or -h where ''h'' is the number of hours. If your store time zone is ahead of the server time zone, use +', 1, 7, NULL, '0001-01-01 00:00:00', NULL, NULL);

     

     

    2) Go to your Configuration -> My Store -> Time Zone Offset

    and set the time difference between your server and your real location

     

     

    3) FILE includes/functions/database.php

    * Find:

    case 'now()':

    $query .= 'now(), ';

     

    * Change To:

    case 'now()':

    // Added a time offset function here

    $query .= 'date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR), ';

     

     

    4) FILE includes/functions/database.php

    * Find:

    function tep_db_fetch_array($db_query) {

     

    * Insert the following code BEFORE the line above:

    function tep_db_datetime() {

    $check_datetime_query = tep_db_query('select date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR) AS CurrTime');

    $check_datetime = tep_db_fetch_array($check_datetime_query);

    return $check_datetime['CurrTime'];

    }

     

     

    5) FILE admin/includes/functions/database.php

    * Find:

    case 'now()':

    $query .= 'now(), ';

     

    * Change To:

    case 'now()':

    // Added a time offset function here

    $query .= 'date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR), ';

     

     

    6) FILE admin/includes/functions/database.php

    * Find:

    function tep_db_fetch_array($db_query) {

     

    * Insert the following code before the line above:

    function tep_db_datetime() {

    $check_datetime_query = tep_db_query('select date_add(now(), INTERVAL ' . TIME_ZONE_OFFSET . ' HOUR) AS CurrTime');

    $check_datetime = tep_db_fetch_array($check_datetime_query);

    return $check_datetime['CurrTime'];

    }

     

     

    7) FILE includes/languages/english.php

    * Find:

    @setlocale(LC_TIME, 'en_US.ISO_8859-1');

     

    * Change To:

    @setlocale(LC_TIME, 'en_US.ISO_8859-1');

    putenv("TZ=Asia/Bangkok");

    $lcl_date_time = date("Y-m-d H:i:s");

     

    *** IMPORTANT: Please note that you should put your own time zone after the TZ=. I live in Bangkok, so I use the Asia/Bangkok timezone. Search google to find more time zones and the one that matches yours...

    *** NEW ZEALAND users should put Pacific/Auckland

     

    8) FILE admin/includes/languages/english.php

    * Find:

    @setlocale(LC_TIME, 'en_US.ISO_8859-1');

     

    * Change To:

    @setlocale(LC_TIME, 'en_US.ISO_8859-1');

    putenv("TZ=Asia/Bangkok");

    $lcl_date_time = date("Y-m-d H:i:s");

     

    *** IMPORTANT: Please note that you should set your own time zone after the TZ=. I live in Bangkok, so I use the Asia/Bangkok timezone. Search google to find more time zones and the one that matches yours...

    *** NEW ZEALAND users should put Pacific/Auckland

     

     

    9) FILE includes/footer.php

    * Find:

    <td class="footer">  <?php echo strftime(DATE_FORMAT_LONG); ?>  </td>

     

    * Change To:

    <td class="footer">  <?php $date_time = tep_db_datetime(); echo strftime(DATE_FORMAT_LONG, strtotime($date_time)); ?>  </td>

     

     

    10) FILE admin/orders.php

    * Find:

    tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', now(), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "')");

     

    * Change To:

    tep_db_query("insert into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . (int)$oID . "', '" . tep_db_input($status) . "', date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR), '" . tep_db_input($customer_notified) . "', '" . tep_db_input($comments) . "')");

     

     

    * Find:

    tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = now() where orders_id = '" . (int)$oID . "'");

     

    *Change To:

    tep_db_query("update " . TABLE_ORDERS . " set orders_status = '" . tep_db_input($status) . "', last_modified = date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR) where orders_id = '" . (int)$oID . "'");

     

     

    11) FILE checkout_process.php

    * Find:

    // lets start with the email confirmation

     

    * Insert the following AFTER the above line

    $date_time = tep_db_datetime();

     

    * Find:

    EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n";

     

    *Change To:

    EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG, strtotime($date_time)) . "\n";

     

     

    12) That's it. There are still many places in osCommerce which use the now() SQL function but the most obvious ones are fixed here.

     

    You can pretty much change occurrences of

    now()

    to

    date_add(now(), INTERVAL " . TIME_ZONE_OFFSET . " HOUR)

    but backup your files before you make changes and test straight away. The only exception to this is when fields are assigned to an array and the tep_db_perform function is called straight after. If in doubt, leave as is.

     

    If you do change these, be aware that " and ' can be used as string delimiters. Use the correct one between the . TIME_ZONE_OFFSET . for each case.

     

     

    Now, there is an instruction part 11, to modify the email sent to the customer.

    Which is:

     

    11) FILE checkout_process.php

    * Find:

    // lets start with the email confirmation

     

    * Insert the following AFTER the above line

    $date_time = tep_db_datetime();

     

    * Find:

    EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG) . "\n\n";

     

    *Change To:

    EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG, strtotime($date_time)) . "\n";

     

    I would like please to modify the "Send_order_html_email" to send the similar "Date format" like this:

     

    EMAIL_TEXT_DATE_ORDERED . ' ' . strftime(DATE_FORMAT_LONG, strtotime($date_time)) . "\n";

     

    Where I need to change the code ??

     

    Could someone please make my day??

     

    Best Regards,

     

    Nathali


  17. Nathali,

     

    If you download v1.2, it explains exactly what to do to update your installation from v1.1->v1.2 in the installation instructions. There are only 2 small changes in the addon and not changes to the core phpOnline files.

     

    Scott

     

     

    Thanks a lot Scott for making it clear !

     

    Regards,

    Nathali

×