Jump to content



Photo

PayPal Express Checkout and Website Payments Pro (Official Payment Module)


  • Please log in to reply
56 replies to this topic

#21   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 08 April 2010 - 19:17

#3, hopefully this is the last one, i only have one file left to compare and change. this one is catalog/product_info.php


contribution code
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
  <tr>
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
    </table></td>
<!-- body_text //-->
    <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">
<?php
  if ($product_check['total'] < 1) {
?>
      <tr>
        <td><?php new infoBox(array(array('text' => TEXT_PRODUCT_NOT_FOUND))); ?></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">
          <tr class="infoBoxContents">
            <td><table border="0" width="100%" cellspacing="0" cellpadding="2">
              <tr>
                <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
                <td align="right"><?php echo '<a href="' . tep_href_link(FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>
                <td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
              </tr>
            </table></td>
          </tr>
        </table></td>
      </tr>
<?php
  } else {
      // added products_type
    $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_type from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
    $product_info = tep_db_fetch_array($product_info_query);

    tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");

    // see if rp product
    $rp_has_trial = false;
    if($product_info['products_type'] == 'recurring'){
        // recurring product
      $rp_array = array();
      $rp_product_query = tep_db_query('SELECT billingPeriod, billingFrequency, totalBillingCycles, trialBillingPeriod, trialBillingFrequency, trialTotalBillingCycles, trialAmt FROM ' . TABLE_RP_PAYPAL_PRODUCT_PROFILE . ' WHERE products_id=' . (int)$HTTP_GET_VARS['products_id']);
      if($rp_product = tep_db_fetch_array($rp_product_query)){
        // recurring data
         $rp_array = $rp_product;
         if(strlen($rp_product['trialBillingPeriod'])>0){
             $rp_has_trial = true;
         }
      }
    }
    if ($new_price = tep_get_products_special_price($product_info['products_id'])) {
      $products_price = '<s>' . $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])) . '</s> <span class="productSpecialPrice">' . $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])) . '</span>';
    } else {
      $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));
    }

    if (tep_not_null($product_info['products_model'])) {
      $products_name = $product_info['products_name'] . '<br><span class="smallText">[' . $product_info['products_model'] . ']</span>';
    } else {
      $products_name = $product_info['products_name'];
    }
    // rp addition here
    if(count($rp_array)>0){
         include_once(DIR_WS_CLASSES . '/paypal_rp_product_info.php');
         $rpPinfo = new paypal_rp_product_info($product_info, $rp_array, $products_price);
         $rpPinfoHeaderArr = $rpPinfo->getProductInfoHeader();
         $rpPInfoArr = $rpPinfo->getProductInfoFull();
    }
?>
      <tr>
        <td><table border="0" width="100%" cellspacing="0" cellpadding="0">
          <tr>
            <td class="pageHeading" valign="top"><?php echo $products_name; ?></td>
            <?php
            if(count($rp_array)>0 and $rp_has_trial){
            // rp with trial
            ?>
            <td class="pageHeading" align="right" valign="top"><?php echo $rpPinfoHeaderArr['trial']; ?><br><?php print $rpPinfoHeaderArr['normal'];?></td>
            <?php
            // rp no trial
            }elseif (count($rp_array)>0){
            ?>
            <td class="pageHeading" align="right" valign="top"><?php print $rpPinfoHeaderArr['normal']; ?></td>
            <?php
            }else{
            // standard product
            ?>
            <td class="pageHeading" align="right" valign="top"><?php echo $products_price; ?></td>
            <?php
            }
            ?>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
      <tr>
        <td class="main">
<?php
    if (tep_not_null($product_info['products_image'])) {
?>
          <table border="0" cellspacing="0" cellpadding="2" align="right">
            <tr>
              <td align="center" class="smallText">
<script language="javascript"><!--
document.write('<?php echo '<a href="javascript:popupWindow(\\\'' . tep_href_link(FILENAME_POPUP_IMAGE, 'pID=' . $product_info['products_id']) . '\\\')">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], addslashes($product_info['products_name']), SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>');
//--></script>
<noscript>
<?php echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $product_info['products_image']) . '" target="_blank">' . tep_image(DIR_WS_IMAGES . $product_info['products_image'], $product_info['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT, 'hspace="5" vspace="5"') . '<br>' . TEXT_CLICK_TO_ENLARGE . '</a>'; ?>
</noscript>
              </td>
            </tr>
          </table>
<?php
    }

my code that it wants to replace
<body style="margin:0px">
<?php 
$inc_file = basename(__FILE__); 
require(DIR_WS_INCLUDES .'theme/main_theme.php');


#22   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 08 April 2010 - 19:22

ok here is #4, the last one though!! not bad out of 20 or so files to be changed. I can ssume three of them are because of my theme, so hopefully one of you guys or gals can give an easy quick answer. /biggrin.gif' class='bbc_emoticon' alt=':D' />

this file is catalog/shopping_cart.php

contribution code is
<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">
<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php'); ?>
<!-- header_eof //-->

<!-- body //-->
<table border="0" width="100%" cellspacing="3" cellpadding="3">
  <tr>
    <td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">
<!-- left_navigation //-->
<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>
<!-- left_navigation_eof //-->
    </table></td>
<!-- body_text //-->
    <td width="100%" valign="top"><?php echo tep_draw_form('cart_quantity', tep_href_link(FILENAME_SHOPPING_CART, 'action=update_product')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">
      <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_image(DIR_WS_IMAGES . 'table_background_cart.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
          </tr>
        </table></td>
      </tr>
      <tr>
        <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
      </tr>
<?php
  if ($cart->count_contents() > 0) {
?>
      <tr>
        <td>
<?php
    $info_box_contents = array();
    $info_box_contents[0][] = array('align' => 'center',
                                    'params' => 'class="productListing-heading"',
                                    'text' => TABLE_HEADING_REMOVE);

    $info_box_contents[0][] = array('params' => 'class="productListing-heading"',
                                    'text' => TABLE_HEADING_PRODUCTS);

    $info_box_contents[0][] = array('align' => 'center',
                                    'params' => 'class="productListing-heading"',
                                    'text' => TABLE_HEADING_QUANTITY);

    $info_box_contents[0][] = array('align' => 'right',
                                    'params' => 'class="productListing-heading"',
                                    'text' => TABLE_HEADING_TOTAL);

    $any_out_of_stock = 0;
    $products = $cart->get_products();
    for ($i=0, $n=sizeof($products); $i<$n; $i++) {
// Push all attributes information in an array
      if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) {
        while (list($option, $value) = each($products[$i]['attributes'])) {
          echo tep_draw_hidden_field('id[' . $products[$i]['id'] . '][' . $option . ']', $value);
          $attributes = tep_db_query("select popt.products_options_name, poval.products_options_values_name, pa.options_values_price, pa.price_prefix
                                      from " . TABLE_PRODUCTS_OPTIONS . " popt, " . TABLE_PRODUCTS_OPTIONS_VALUES . " poval, " . TABLE_PRODUCTS_ATTRIBUTES . " pa
                                      where pa.products_id = '" . (int)$products[$i]['id'] . "'
                                       and pa.options_id = '" . (int)$option . "'
                                       and pa.options_id = popt.products_options_id
                                       and pa.options_values_id = '" . (int)$value . "'
                                       and pa.options_values_id = poval.products_options_values_id
                                       and popt.language_id = '" . (int)$languages_id . "'
                                       and poval.language_id = '" . (int)$languages_id . "'");
          $attributes_values = tep_db_fetch_array($attributes);

          $products[$i][$option]['products_options_name'] = $attributes_values['products_options_name'];
          $products[$i][$option]['options_values_id'] = $value;
          $products[$i][$option]['products_options_values_name'] = $attributes_values['products_options_values_name'];
          $products[$i][$option]['options_values_price'] = $attributes_values['options_values_price'];
          $products[$i][$option]['price_prefix'] = $attributes_values['price_prefix'];
        }
      }
    }

    for ($i=0, $n=sizeof($products); $i<$n; $i++) {
      if (($i/2) == floor($i/2)) {
        $info_box_contents[] = array('params' => 'class="productListing-even"');
      } else {
        $info_box_contents[] = array('params' => 'class="productListing-odd"');
      }

      $cur_row = sizeof($info_box_contents) - 1;

      $info_box_contents[$cur_row][] = array('align' => 'center',
                                             'params' => 'class="productListing-data" valign="top"',
                                             'text' => tep_draw_checkbox_field('cart_delete[]', $products[$i]['id']));

      $products_name = '<table border="0" cellspacing="2" cellpadding="2">' .
                       '  <tr>' .
                       '    <td class="productListing-data" align="center"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '">' . tep_image(DIR_WS_IMAGES . $products[$i]['image'], $products[$i]['name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td>' .
                       '    <td class="productListing-data" valign="top"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $products[$i]['id']) . '"><b>' . $products[$i]['name'] . '</b></a>';

      if (STOCK_CHECK == 'true') {
        $stock_check = tep_check_stock($products[$i]['id'], $products[$i]['quantity']);
        if (tep_not_null($stock_check)) {
          $any_out_of_stock = 1;

          $products_name .= $stock_check;
        }
      }

      if (isset($products[$i]['attributes']) && is_array($products[$i]['attributes'])) {
        reset($products[$i]['attributes']);
        while (list($option, $value) = each($products[$i]['attributes'])) {
          $products_name .= '<br><small><i> - ' . $products[$i][$option]['products_options_name'] . ' ' . $products[$i][$option]['products_options_values_name'] . '</i></small>';
        }
      }
// rp extra display data for shopping cart
      if(count($products[$i]['rp']) > 0){
          // include the product display class
          include_once(DIR_WS_CLASSES . '/paypal_rp_product_info.php');
          $rpPprice = $currencies->display_price($products[$i]['rp']['amt'], tep_get_tax_rate($products[$i]['tax_class_id']));
          $rpPinfo = new paypal_rp_product_info($products[$i], $products[$i]['rp'], $rpPprice);
          $rpPinfoArr = $rpPinfo->getProductInfoFull();
          if(array_key_exists('trial', $rpPinfoArr)){
              $products_name .= '<br><small><i>'. $rpPinfoArr['trial'] . '</i></small>';
          }
          $products_name .= '<br><small><i>' . $rpPinfoArr['normal'] . '</i></small>';
      }
      $products_name .= '    </td>' .
                        '  </tr>' .
                        '</table>';

      $info_box_contents[$cur_row][] = array('params' => 'class="productListing-data"',
                                             'text' => $products_name);

          $info_box_contents[$cur_row][] = array('align' => 'center',
                                                 'params' => 'class="productListing-data" valign="top"',
                                                 'text' => tep_draw_input_field('cart_quantity[]', $products[$i]['quantity'], 'size="4"') . tep_draw_hidden_field('products_id[]', $products[$i]['id']));
      //}
      $info_box_contents[$cur_row][] = array('align' => 'right',
                                             'params' => 'class="productListing-data" valign="top"',
                                             'text' => '<b>' . $currencies->display_price($products[$i]['final_price'], tep_get_tax_rate($products[$i]['tax_class_id']), $products[$i]['quantity']) . '</b>');
    }

    new productListingBox($info_box_contents);

my original code that it wants to replace is
<body style="margin:0px">
<?php 
$inc_file = basename(__FILE__); 
require(DIR_WS_INCLUDES .'theme/main_theme.php');


#23   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 12 April 2010 - 16:32

any help!? please!?

#24   PayPal_Tin

PayPal_Tin
  • Members
  • 15 posts
  • Real Name:Tin Cheung

Posted 12 April 2010 - 16:41

any help!? please!?


Hi Danny,

Apologies for the delayed response. I am just consulting with with our deployment team, and I will hopefully be in a better position to advise you soon.

Thanks,

Tin

#25   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 12 April 2010 - 19:13

Hi Danny,

Apologies for the delayed response. I am just consulting with with our deployment team, and I will hopefully be in a better position to advise you soon.

Thanks,

Tin


Thank you!!!

#26   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 13 April 2010 - 16:29

I emailed the template company and they said

The code you will find in this file:

includes\theme\checkout_payment.php


So I went into the theme folder for all four files that I previously asked about, and changed the code. I uploaded all files.

I logged into admin, clicked modules. I got this

Payment Modules

Modules Sort Order Action
Authorize.net Credit Card AIM
Authorize.net Credit Card SIM
Credit Card (Not For Production Use) 0
ChronoPay
Cash on Delivery 0
iPayment
Check/Money Order
NOCHEX

Warning: require_once(/home/jscb/public_html/catalog/includes/modules/payment/paypal/paypal_base.php) [function.require-once]: failed to open stream: No such file or directory in /home/jscb/public_html/catalog/includes/modules/payment/paypal_direct.php on line 12

Fatal error: require_once() [function.require]: Failed opening required '/home/jscb/public_html/catalog/includes/modules/payment/paypal/paypal_base.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/jscb/public_html/catalog/includes/modules/payment/paypal_direct.php on line 12


Any help?

#27   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 13 April 2010 - 17:18

I emailed the template company and they said

So I went into the theme folder for all four files that I previously asked about, and changed the code. I uploaded all files.

I logged into admin, clicked modules. I got this

Any help?


I forgot to upload all of the other files, that did not have changed code. So far everything looks to be in working order.

#28   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 13 April 2010 - 18:34

I got the api username, pw, and other functions setup. I went into admin, then to catalog, to change prices on my products, and im getting this error.

Parse error: syntax error, unexpected $end in /home/jscb/public_html/catalog/admin/categories.php on line 1492


I dont think I can figure that one out by myself.

UPDATE:: Guess I can figure it out, at least for the moment. Sorry for jumping to help first!

Edited by dcrider1, 13 April 2010 - 18:46.


#29   Pinball

Pinball
  • Members
  • 47 posts
  • Real Name:John
  • Gender:Male
  • Location:Canada

Posted 15 April 2010 - 05:32

My apologies all sorted now...


What did you do to fix the problem? Just saying 'all sorted out now' doesn't help anyone much - I too have a problem with PayPal not charging the shipping component in OSCMax. Trying to find the hic-up with not much success so far.

Perhaps what you found was your error would help me (and others).

Thanks,

John :-#(#

#30   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 15 April 2010 - 14:42

Well Im back to more problems.

#1)Now my tables or columns are all jacked up

www.burgersmarketpc.com/catalog

#2) I tried to order a product just for fun, I get this error

Fatal error: Cannot redeclare usu5_base_filename() (previously declared in /home/jscb/public_html/catalog/includes/application_top.php:50) in /home/jscb/public_html/catalog/includes/application_top.php on line 69



#31   PayPal_Tin

PayPal_Tin
  • Members
  • 15 posts
  • Real Name:Tin Cheung

Posted 15 April 2010 - 15:37

Well Im back to more problems.

#1)Now my tables or columns are all jacked up

www.burgersmarketpc.com/catalog

#2) I tried to order a product just for fun, I get this error


dcrider1 - thank you for persistence with this, and apologise for the trouble that it is causing you. We are trying to work on a way to communicate how to implement the changes on customised carts, but this is proving quite tricky at the moment, so I'm afraid that I don't actually have a quick answer for you.

In regards to the error you're getting - the appication_top.php is not from our distribution, and I can't find anything obvious in the "stock" file - can you please confirm what might on lines 50 and 69 of the file that you are using?

Pinball - are you using the 180 distribution of the update?

Thanks,

Tin

#32   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 16 April 2010 - 00:42

dcrider1 - thank you for persistence with this, and apologise for the trouble that it is causing you. We are trying to work on a way to communicate how to implement the changes on customised carts, but this is proving quite tricky at the moment, so I'm afraid that I don't actually have a quick answer for you.

In regards to the error you're getting - the appication_top.php is not from our distribution, and I can't find anything obvious in the "stock" file - can you please confirm what might on lines 50 and 69 of the file that you are using?

Pinball - are you using the 180 distribution of the update?

Thanks,

Tin



Here is lines 45 to 71
/** 
  * USU5 function to return the base filename  
  */ 
  function usu5_base_filename() { 
    // Probably won't get past SCRIPT_NAME unless this is reporting cgi location 
    $base = new ArrayIterator( array( 'SCRIPT_NAME', 'PHP_SELF', 'REQUEST_URI', 'ORIG_PATH_INFO', 'HTTP_X_ORIGINAL_URL', 'HTTP_X_REWRITE_URL' ) ); 
    while ( $base->valid() ) { 
      if ( array_key_exists(  $base->current(), $_SERVER ) && !empty(  $_SERVER[$base->current()] ) ) { 
        if ( false !== strpos( $_SERVER[$base->current()], '.php' ) ) { 
          preg_match( '@[a-z0-9_]+\.php@i', $_SERVER[$base->current()], $matches ); 
          if ( is_array( $matches ) && ( array_key_exists( 0, $matches ) ) 
                                    && ( substr( $matches[0], -4, 4 ) == '.php' ) 
                                    && ( is_readable( $matches[0] ) || ( false !== strpos( $_SERVER[$base->current()], 'ext/modules/' ) ) ) ) { 
            return $matches[0]; 
          }  
        }  
      } 
      $base->next(); 
    } 
    // Some odd server set ups return / for SCRIPT_NAME and PHP_SELF when accessed as mysite.com (no index.php) where they usually return /index.php 
    if ( ( $_SERVER['SCRIPT_NAME'] == '/' ) || ( $_SERVER['PHP_SELF'] == '/' ) ) { 
      return 'index.php'; 
    }  
    trigger_error( 'USU5 could not find a valid base filename, please inform the developer.', E_USER_WARNING ); 
  } // End function 
// set php_self in the local scope 
  $PHP_SELF = usu5_base_filename();


#33   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 27 April 2010 - 19:16

Here is lines 45 to 71

/** 
  * USU5 function to return the base filename  
  */ 
  function usu5_base_filename() { 
    // Probably won't get past SCRIPT_NAME unless this is reporting cgi location 
    $base = new ArrayIterator( array( 'SCRIPT_NAME', 'PHP_SELF', 'REQUEST_URI', 'ORIG_PATH_INFO', 'HTTP_X_ORIGINAL_URL', 'HTTP_X_REWRITE_URL' ) ); 
    while ( $base->valid() ) { 
      if ( array_key_exists(  $base->current(), $_SERVER ) && !empty(  $_SERVER[$base->current()] ) ) { 
        if ( false !== strpos( $_SERVER[$base->current()], '.php' ) ) { 
          preg_match( '@[a-z0-9_]+\.php@i', $_SERVER[$base->current()], $matches ); 
          if ( is_array( $matches ) && ( array_key_exists( 0, $matches ) ) 
                                    && ( substr( $matches[0], -4, 4 ) == '.php' ) 
                                    && ( is_readable( $matches[0] ) || ( false !== strpos( $_SERVER[$base->current()], 'ext/modules/' ) ) ) ) { 
            return $matches[0]; 
          }  
        }  
      } 
      $base->next(); 
    } 
    // Some odd server set ups return / for SCRIPT_NAME and PHP_SELF when accessed as mysite.com (no index.php) where they usually return /index.php 
    if ( ( $_SERVER['SCRIPT_NAME'] == '/' ) || ( $_SERVER['PHP_SELF'] == '/' ) ) { 
      return 'index.php'; 
    }  
    trigger_error( 'USU5 could not find a valid base filename, please inform the developer.', E_USER_WARNING ); 
  } // End function 
// set php_self in the local scope 
  $PHP_SELF = usu5_base_filename();



Any help?

#34   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 28 April 2010 - 12:44

With the help of a few great people, the cart looks to be working. I have not tested the functionality.

Now, how do I fix or find the problems relating to the jacked up tables and or columns?

www.burgersmarketpc.com/catalog

#35   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 28 April 2010 - 13:04

With the help of a few great people, the cart looks to be working. I have not tested the functionality.

Now, how do I fix or find the problems relating to the jacked up tables and or columns?

www.burgersmarketpc.com/catalog


So i think this might be the issue. In the module, column_left.php has to be modified. Because of my "theme/template", I think this is where the issue is. Can anyone see the problem?

Original column_left code
<?php
/*
  $Id: column_right.php,v 1.17 2003/06/09 22:06:41 hpdl Exp $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
  
  <div style="padding-top:5px"><?php if ($banner = tep_banner_exists('dynamic', 'baner_01')) echo tep_display_banner('static', $banner); ?></div>
  
*/
?>

<table border="0" cellspacing="0" cellpadding="0">
  <?php require DIR_WS_BOXES.'categories.php';?>
  <tr><td height="5"></td></tr>
  <?php require DIR_WS_BOXES.'specials.php';?>
  <tr><td height="5"></td></tr>
  <tr><td><?php require DIR_WS_BOXES.'best_sellers.php';?></td></tr>
  <tr><td height="10"></td></tr>
</table>



Module column_left code
<?php
/*
  $Id: column_left.php 1739 2007-12-20 00:52:16Z hpdl $

  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com

  Copyright (c) 2003 osCommerce

  Released under the GNU General Public License
*/

  if ((USE_CACHE == 'true') && empty($SID)) {
    echo tep_cache_categories_box();
  } else {
    include(DIR_WS_BOXES . 'categories.php');
  }

  if ((USE_CACHE == 'true') && empty($SID)) {
    echo tep_cache_manufacturers_box();
  } else {
    include(DIR_WS_BOXES . 'manufacturers.php');
  }

  require(DIR_WS_BOXES . 'whats_new.php');
  require(DIR_WS_BOXES . 'search.php');
  require(DIR_WS_BOXES . 'information.php');
  /**
   * START
   * PayPal Logo
   *
   * This will put the paypal logo in the left column
   */
  require(DIR_WS_BOXES . 'paypalLogo.php');
  /**
   * END
   * PayPal Logo
   */
?>

Edited by dcrider1, 28 April 2010 - 13:06.


#36   dcrider1

dcrider1
  • Members
  • 124 posts
  • Real Name:danny

Posted 28 April 2010 - 13:54

The problem was within the column_left file. I have it fixed now. On to testing and such now. Thanks to those that helped!

#37   col_b

col_b
  • Members
  • 25 posts
  • Real Name:col_b

Posted 29 April 2010 - 05:42

Hi PayPal,

I have an issue with PayPal Express.

I use PayPal Pro and PayPal Express.

I have two checkout buttons at my shopping_cart: a regular checkout button, and a Checkout with Paypal button. I understand that the deal with PayPal Express is that it populates all the delivery and billing fields so that the customer doesn't have to register their details with my store.

So if someone does the regular checkout with my store, they go thru the regular process, i.e. login --> delivery options --> payment options --> confirmation / enter cc details --> success.

When a customer clicks the PayPal Express button from the shopping_cart, they are taken to PayPal, they confirm their address and payment choice, then they are taken directly to checkout confirmation - at no stage are they able to choose a delivery option. It just populates the delivery option with a default, which I guess is dependent on the country code of where they're coming in from.

So how on earth do I let people checking out with PayPal Express choose their delivery option?

#38   sphinx797

sphinx797
  • Members
  • 12 posts
  • Real Name:Bret
  • Gender:Male

Posted 09 May 2010 - 11:07

Hey guys I'm having a slight problem with the installation of osc_Paypal_v180

I installed all the necessary files (I think) but now something is broken on each individual product page.

it's giving me an error like this on each page


1054 - Unknown column 'p.products_type' in 'field list'

select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_type from products p, products_description pd where p.products_status = '1' and p.products_id = '26' and pd.products_id = p.products_id and pd.language_id = '1'

[TEP STOP]


Any ideas where the conflict might be or where to look? I guess I'm going to try and restore certain files one at a time and hope i get lucky.

Thanks

EDIT** Restoring the original product_info.php page fixed it temporarily, I just have to go through the supplied version and see what's been modified....

Edited by sphinx797, 09 May 2010 - 11:17.


#39   SASSYSARAH

SASSYSARAH
  • Members
  • 14 posts
  • Real Name:SARAH MOORE

Posted 17 May 2010 - 13:59

Hi Anthony

I have tried the dowlaod that you recommend but I could still not get the checkout to work and it completely messed up the website so had to restore the backup.

To clarify - I amended the files you list and I ALSO added the other files to the site - is the latter correct or do I just amend the files listed on your notes?

Sarah

#40   Desertsky

Desertsky
  • Members
  • 120 posts
  • Real Name:Paul Mcintosh

Posted 21 May 2010 - 14:05

Is there any way to switch off Paypal Express changing the shipping address during checkout? Some people aren't keeping their Paypal addresses up to date and they also do not inform me of the change. Product is getting shipped and not received or returned.