Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Clement

Archived
  • Posts

    85
  • Joined

  • Last visited

Posts posted by Clement

  1. I, like may others am gettinthe following error

    1064 - You have an error in your SQL syntax near 'select pd.faqdesk_answer_long, pd.faqdesk_answer_short, p.faqdesk_id, p.faqdesk' at line 1
    
    
    
    select count(select pd.faqdesk_answer_long, pd.faqdesk_answer_short, p.faqdesk_id, p.faqdesk_date_added, pd.faqdesk_question, pd.faqdesk_answer_long, pd.faqdesk_answer_short from faqdesk_description pd, faqdesk p, faqdesk_to_categories p2c where p.faqdesk_status = '1' and p.faqdesk_id = p2c.faqdesk_id and pd.faqdesk_id = p2c.faqdesk_id and pd.language_id = '1' and p2c.categories_id = '2' order by pd.faqdesk_question) as total 
    
    
    
    [TEP STOP]

     

    I saw the problem listed but no fix (atleast not what I saw)  Any help for this????

     

    Chris

    Hello,

     

    If you use MS2 osC then the error occure because of the differences of the splitPageResults() function in MS1 and MS2.

     

    In order to fix this you have to edite the file from:

     

    catalog/includes/modules/faqdesk/faqdesk_listing.php

     

    there around the line 14

     

    FIND

     

    $listing_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, $listing_sql, $listing_numrows);

     

    AND REPLACE WITH

     

    $listing_split = new splitPageResults($listing_sql, MAX_DISPLAY_FAQDESK_SEARCH_RESULTS, '*', $HTTP_GET_VARS['page']);

     

     

    Good luck,

    Clement

  2. Hello,

     

    For all having problem with the IE6 crash when trying to insert a new FAQ i can certain tell you that the problem occure from the html bar editor.

     

    I don't know a fix so I just commented out the html editor part from admin/includes/modules/faqdesk/html/editor/content_bb.php and summary_bb.php .

     

    So, this is not a fix but ay least you can work with this great contribution.

     

    Best Regards,

    Clement

  3. Ok. Here is how I fixed the problem of special groups prices in modules/new_products.php

     

    >>>>>>>>>>>>

     

    REPLACE

     

    $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

     

    WITH

     

    $new_products_query = tep_db_query("select products_id, products_image, products_tax_class_id,  products_price from " . TABLE_PRODUCTS . " where products_status = '1' order by products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

     

     

    >>>>>>>>>>>

     

     

    REPLACE

     

    $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

     

    WITH

     

    $new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id,  p.products_price from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

     

     

    >>>>>>>>>>

     

     

    BEFORE

     

        $info_box_contents[$row][$col] = array('align' => 'center',
    
                                              'params' => 'class="smallText" width="33%" valign="top"',
    
                                              'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br>' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])));

     

    ADD

     

            $special_price_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . $new_products['products_id'] . "' and customers_group_id =  '" . $customer_group['customers_group_id'] . "' and status <> '0'");
    
     if ($special_price = tep_db_fetch_array($special_price_query)) {
    
      $new_products['products_price'] = $special_price['specials_new_products_price'];
    
           }

     

     

     

    Good Luck!!

  4. Hello everybody,

     

    Here are some problems that I found into 3.5 version for different specials for each new group:

     

     

    A. In the install instructions

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

     

    1. At catalog/specials.php changes:

     

    Around line 80
    
    
    
    After
    
    
    
       $row = 0;
    
       $specials_query = tep_db_query($specials_split->sql_query);
    
       while ($specials = tep_db_fetch_array($specials_query)) {
    
         $row++;
    
    
    
    Add 
    
    
    
             $customer_group_query = tep_db_query("select customers_group_id from " . TABLE_CUSTOMERS . "        where customers_id =  '" . $customer_id . "'");
    
             $customer_group = tep_db_fetch_array($customer_group_query);
    
    
    
       $row = 0;
    
       $specials_query = tep_db_query($specials_split->sql_query);
    
       while ($specials = tep_db_fetch_array($specials_query)) {
    
         $row++;
    
    
    
             $customer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . $specials['products_id'] . "' and customers_group_id =  '" . $customer_group['customers_group_id'] . "'");
    
             if ( $customer_group['customers_group_id'] != 0)
    
               if ($customer_group_price = tep_db_fetch_array($customer_group_price_query))
    
                   $specials['products_price']= $customer_group_price['customers_group_price'];

     

     

    I think there must be "replace" and not "add" because if I just add the seccond part of code then I've got an arror into specials.php file.

     

     

     

     

    2. For catalog/includes/functions/general.php changes the instructions say that :

     

    Around 200
    
    
    
    After
    
    
    
       $select_string .= '>';
    
    
    
    Add .......

     

     

    But "$select_string .= '>';" is only in admin/includes/functions/general.php , so I think at this point all changes must be swiched to the admin/functions/general.php

     

     

     

    A. Runing the script

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

     

     

    3. The special prices for "Resellers" - not the default group - arn't displayed from the catalog/includes/modules/new_products.php

     

     

    4. If I setup a special price for "Reseller" as percent, then the special price is calculated based on the default group price not as a percent from the "reseller" price.

     

     

    Thank you very much for this contribution,

  5. You got me started on a better predifined input solution, should have some progress up here by tommorow. much simpler then before -  

     

    Take alook at this:

    http://www.maxidvd.com.au/ms1/admin/mail.php

     

    [/b]

     

     

    Thanks Lee,

     

    This will be a great improvment of an already great contribution :)

     

    Please let me know if you will upload those changes in the contrib area...

     

     

    Thank you again,

    Clement

  6. Hello Lee,

     

     

    Thank you for your help.

     

    Here is what works for my problem:

     

    admin/htmlarea/popups/file/config.inc.php

     

    In this file, between the lines 14-16 I found a hardcoded path:

    //this is where the files will be stored relative to the $BASE_DIR (and $BASE_URL)

    //this directory MUST be readable AND writable by the web server.

    $BASE_ROOT = 'catalog/download';

     

    So, I have to change "catalog/download" to "download" ..

     

     

    Thank you for the custom info inserting help, too.

     

    Also, I have to know 2 more things:

     

    1. How to create a custom button?

    - how to create the reaction on click for that custom buton;

    - how to change the face (grafhics) of any custom button

     

     

    2. How to handle the showing and not showing a custom button in different pages (product description or email sending...)

     

    I ask that because I noticed for example that in the basic mode, is a custom button for inserting some html code (a logo from http://www.kmart.com.au/images/top/KmartLogo.gif and some text).

     

    So, can I have a custom button displayed in the "Send Email" section but not in the "Product description".

     

    Also, this button is in the basic mode but isn't in the advanced mode.

     

     

     

    IF the answers of my questions are in this topic (in the previous posts) JUST TELL ME ...

     

     

    I wont to spend your time with no reason.

     

     

    Thank you very much for your support.

     

    Clement

  7. Hello,

     

    I just installed this great contrib as the first mod on a fresh MS2.

     

    Everything is just fine.. EXCEPT:

     

    When I try to use the "Link to a file" icon an error occure:

     

    Configuration problem: "/home/******/public_html/catalog/download" does not exist.

     

    That's right because I don't have a "catalog" folder (the shop is installed in the public_html direcory).

     

    So, please tell me where I need to change (fix ?) this path.

     

     

    Also, I can't figure out how to setup some "Custom info" for repetitive use.

     

     

    Thank you for helping,

    Clement

  8. I don't know very well if it is right, but seems to work .....

     

    So, in catalog side ot_coupon.php file, in calculate_tax_deduction function the originale code was:

     

     

     

        
    
        if ($get_result['products'] || $get_result['categories']) {
    
    
    
         } else {
    
           if ($get_result['type'] !='P') {
    
             $tod_amount = 0;
    
    ........................................................
    
    
    
         }
    
    
    
       }

     

     

    Because the if condition contain no instructions, I was comented out this condition.

    So, the code is now:

     

     

         
    
    //     if ($get_result['products'] || $get_result['categories']) {
    
    
    
    //      } else {
    
           if ($get_result['type'] !='P') {
    
             $tod_amount = 0;
    
    ........................................................
    
    
    
         }
    
    
    
    //    }

     

     

    The calculations seems to be made correct now when the coupon is for certain categories and the product has attributes.

     

    Ian, please tell me if this is a wrong way..

     

    Thank you for all your work!

  9. This problems occurs from cookies.

     

    If you manually delete the cookie from your cookie director (in your computer) after a previous login asa affiliate in catalog part, you will be able to login as admin in admin part.

     

    This is my problem, too. But I don't have a fix.

     

    Sorry,

  10. Ok. I don't know very well why but here is the code that works for situation when the Admin leave the "Live Support" :

     

    in admin/ls_callwaiting.php file

     

     

    FIND:

     

     

    <script language="javascript">
    
    function LSWarning() {
    
    alert("Closing this window has turned off Live Support!");
    
    window.open('ls_exit.php?tech=1', 'tech');
    
    }
    
    </script>
    
    </head>
    
    <body onUnload="LSWarning()">

     

     

    REPLACE WITH

     

     

    <script language="javascript">
    
    function LSWarning() {
    
    window.open('ls_exit.php?tech=1', 'tech');
    
    alert("Closing this window has turned off Live Support!");
    
    }
    
    window.onunload=LSWarning;
    
    </script>
    
    </head>
    
    <body>

     

     

     

    ANOTHER solution in case that the above changes dont't work to you is:

     

     

    in admin/live_support.php file

     

     

    FIND:

     

                <tr>
    
                 <td valign="top" align="center">
    
         <a href="javascript:void(0);" onclick="NewWindow('ls_start.php','tech','200','200','no');return false"><b style="font-size:14pt;">Start Live Support</b></a>
    
                 </td>
    
               </tr>

     

     

    AFTER THIS ADD:

     

     

    <tr>
    
                 <td valign="top" align="center">
    
        <br><br><br>
    
         <a href="javascript:void(0);" onclick="NewWindow('ls_exit.php?tech=1','tech');return false"><b style="font-size:14pt;">Close Live Support</b></a>

     

     

    Good Luck,

  11. this is the code in the script portion of admin/ls_commwindow.php

    <script language="javascript">
    
    function popup(){
    
           window.open('ls_comm_exit.php?osCsid=<? echo $session_id; ?>');
    
    }
    
    </script>
    
    </head>

     

     

    I think in the js is missing the unload condition.

     

    So, correct script is:

     

    <script language="javascript"> 
    
    function popup(){ 
    
           window.open('ls_comm_exit.php?osCsid=<? echo $session_id; ?>'); 
    
    } 
    
    window.onunload=popup;
    
    </script>

     

     

    At least only this works for me.

     

    Thank you,

  12. Because our customers may be ungry if they see in the left column the "Live support avaiable" picture but, if the operator is busy, they can't speack or login (after oddie mod),

     

    AND

     

    because is better to tell customers (in right column) that the operators is here but is keep busy by the other customer,

     

    I was created a new image file that I called "live_support3.gif" with "Busy" message and make some little modification in catalog/includes/boxes/live_support.php

     

    So,

     

     

    $support_query = tep_db_query("select status from " . TABLE_LS_TECHS . " where status='yes' or status='busy' ");
    
    $support_results = tep_db_num_rows($support_query);

     

    REPLACED WITH:

     

     

    	$support_query = tep_db_query("select status from " . TABLE_LS_TECHS . " where support_tech ='Sales'  ");
    
    $support_results = tep_db_fetch_array($support_query);

     

     

    A litlle bit down

     

    if($support_results > 0 ) {

     

    REPLACED WITH:

     

    if($support_results['status'] == 'yes') {

     

     

    A little bit down

     

     

    }else {

     

     

    REPLACED WITH:

     

    elseif ($support_results['status'] == 'busy') {
    
     $info_box_contents[] = array('align' => 'center',
    
                                  'text'  => '<a href="' . tep_href_link(FILENAME_CONTACT_US, '', 'NONSSL') . '">' . tep_image(DIR_WS_IMAGES . 'live_support3.gif', IMAGE_LIVE_SUPPORT_NOT_AVAILABLE) . '</a>');
    
    }else {

     

     

     

    Good luck,

×
×
  • Create New...