Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

tarmogr

Pioneers
  • Posts

    27
  • Joined

  • Last visited

Posts posted by tarmogr

  1. Hi Ben

     

    One thing I noticed you had a mossing echo in the order history table "while loop"

       	while ($orders_history = tep_db_fetch_array($orders_history_query)) {
            echo '          <tr>' . "\n" .
                 '            <td class="smallText" align="center">' . tep_datetime_short($orders_history['date_added']) . '</td>' . "\n" .
                 '            <td class="smallText" align="center">';
            if ($orders_history['customer_notified'] == '1') {
              echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>\n";
            } else {
              echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n";
            }
            echo '            <td class="smallText">' . $orders_status_array[$orders_history['orders_status_id']] . '</td>' . "\n" .
                 '            <td class="smallText">' . nl2br(tep_db_output($orders_history['comments'])) . ' </td>' . "\n" .
                 '            <td class="smallText" align="center">';
            if ($orders_history['invoice_sent'] == '1') {
              echo tep_image(DIR_WS_ICONS . 'tick.gif', ICON_TICK) . "</td>\n";
            } else {
              echo tep_image(DIR_WS_ICONS . 'cross.gif', ICON_CROSS) . "</td>\n";
              }
                 //'          </tr>' . "\n";//
    
    	    // tracking module start
    			 '            <td class="smallText">';
    			 if ($orders_history['tracking_no']!==''){
    			 if (isset($tracking_names_array[$orders_history['tracking_methods_id']])){
    			 $carrier= $tracking_names_array[$orders_history['tracking_methods_id']];
    			 $button=  ' <a href="' . $tracking_methods_array[$orders_history['tracking_methods_id']] . $orders_history['tracking_no'] . '" target="_blank"><button>' . TEXT_TRACKING_BUTTONNAME . '</button></a></td>'  . ' </td>' . "\n";
    			 }else{
    			 $carrier='-module removed-';
    			 $button='';
    			 } 
             echo  sprintf(TEXT_TRACKING_INFO,$carrier,$orders_history['tracking_no']) . $button;
              } 
    		echo   '          </tr>' . "\n";
    		// tracking module end
          }
    

    add echo in front of line 360.

    correct code:

    			 echo '            <td class="smallText">';
    

    Also your table heading has tracking info first and then pdf invoice field, but in actual table you have invoice column before tracking column.

     

    I suggest switch lines 314 and 315

                <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_TRACK; ?></strong></td>
    	    <td class="smallText" align="center"><strong><?php echo TABLE_HEADING_INVOICE; ?></strong></td>
    
  2. there is an error in step 2. I must have been in real hurry posting this contribution, anyway correct query is:

     

    2. Insert this query into your oscommerce database (go to myphpadmin, select store database and click SQL tab, paste this into the field and click go)


    CREATE TABLE IF NOT EXISTS `tracking_methods` (
      `tracking_methods_id` int(11) NOT NULL DEFAULT '0',
      `language_id` int(11) NOT NULL DEFAULT '1',
      `tracking_methods_name` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
      `tracking_methods_url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
      `mach` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
      `icon` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
      `autostatus` int(11) NOT NULL,
      PRIMARY KEY (`tracking_methods_id`,`language_id`),
      KEY `idx_tracking_methods_url` (`tracking_methods_url`)
    ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;



    ALTER table `orders_status_history` ADD `tracking_no` VARCHAR(32) NOT NULL;
    ALTER table `orders_status_history` ADD `tracking_methods_id` int(11) NOT NULL DEFAULT '0';

     

    Yu may want to delete the tracking_methods table and new columns in order status history table before running this

  3. Hi

     

    it seems that I have missed one edit.

     

    Please go to catalog/admin/includes/boxes/localization.php

     

    Find:

            'link' => tep_href_link(FILENAME_ORDERS_STATUS)
    

    Add right after it:

    		// tracking module
    	  ),
          array(
            'code' => FILENAME_TRACKING,
            'title' => BOX_LOCALIZATION_TRACKING,
            'link' => tep_href_link(FILENAME_TRACKING)		
    

    Let me know if it works, then I'll update the package

  4. I would like to install this addon but I have one theoretical question

     

    If somebody inserts a VAT number that is valid but not owned by the customers company, then he automattically gets tax free prices.

    So how do I know he is not just camming me but really can order in behalf of this company?

  5. Anyone has this running on php5.5?

    I am getting the following error with php 5.5.15 on my local test server

     

    Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in D:\xampp\htdocs\XXXX\includes\classes\seo.class.php on line 78

    I also had a series of sql errors when I tested it on Wampserver. It is working fine on my actual server but it has sligthly older PHP version. So if the PHP will be updated the contribution will stop working. Would be great if somebody could look ito it.

  6. oh I just found th fix. I wonder how the code worked before but started acting weird after the update. anyway, If you are also uable to add custom order totals whith ajax turned on do this:

     

    in edit_orders.php find:

     

     

          if (ORDER_EDITOR_USE_AJAX == 'true') {
          echo '                    <td align="right" class="dataTableContent"><input name="update_totals['.$i.'][title]" id="'.$id.'[title]" value="' . trim($order->totals[$i]['title']) . '" onChange="obtainTotals()"></td>' . "\n" .
     

     remove onChange="obtainTotals()" so it looks like this:

     

     

          if (ORDER_EDITOR_USE_AJAX == 'true') {
          echo '                    <td align="right" class="dataTableContent"><input name="update_totals['.$i.'][title]" id="'.$id.'[title]" value="' . trim($order->totals[$i]['title']) . '" ></td>' . "\n" .
     

     

    Now if you write something in the order total title field, the ajax will not reload. It will reload only if you insert something into value field. So remember to enter the order total title before the amount.

  7. Question 2:

    And can you add a new ot_custom field in AJAX mode? I couldn't. Because when I enter the title I have to click "tab-key" or click with my mouse cursor on the amount field but just at that moment the page updates (AJAX) and it disappears.

     

    I have exactly the same problem and I don't know how to fix it. I think the bug came out after updating my site from 2.3.1 to 2.3.3.3

     

    If javascript updating is turned off then I am able to add cusom order totals but then again I can't change shipping methods.

     

    Any idea how to fix it?

  8. Does any of those contribution have a feature to pay later? For example during checkout the customer is directed to paypal and then decides not to pay and closes the window. Would then be possible for the customer to later log in, go to "my orders" section and press a payment button to complete the payment?

  9. Hi

     

    I have a problem accessing products or categories that have special UTF-8 characters. Whenever I click certain products with those characters in title, firefox gives me redirect error

    The page isn't redirecting properly
    
    Firefox has detected that the server is redirecting the request for this address in a way that will never complete.
    
        This problem can sometimes be caused by disabling or refusing to accept cookies.

    I have also noticed that when hovering a mouse over a product:

    this kind of url is displayed in firefox: http://...  .../product_info.php/8x70mm-ümar-õhudüüs-p-133

    Although the real name of product is: 8x70mm ümar õhudüüs

     

    And when I copy the link location in firefox the result is: http:... .../product_info.php/8x70mm-%C3%83%C2%BCmar-%C3%83%C2%B5hud%C3%83%C2%BC%C3%83%C2%BCs-p-133

     

    When it is successful loading the page the url looks like: http://...  .../8x70mm-umar-ohuduus-p-133   - Jus as it should be

     

    It is also interesting that the problem sometimes occurs and sometimes not. I have an exact copy of my site whre I cleared the SEO chase and the problem went away. Doing the same thing on my live site has no effect. And also some products with special characters load without any problems. Any idea where the problem could be?

×
×
  • Create New...