Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

mvigil514

Pioneers
  • Posts

    34
  • Joined

  • Last visited

About mvigil514

  • Birthday 09/17/1960

Profile Information

  • Real Name
    Michael
  • Location
    Georgia
  • Website

Recent Profile Visitors

6,174 profile views

mvigil514's Achievements

  1. Hello All, I am using Options as Images v1.2. I have looked through the forums and have not been able to make this work. I am trying to change the sort order in the admin section to sort by products_options_values_name. Currently, we have many (500+) option values for one option and they are sorted by options_values_id. I have tried adding "order by products_options_values_name" at the end of $query2, but it does not seem to work. Maybe someone with more PHP/MySQL knowledge can figure this out. Below is the relevant section of code. I can post the entire file if needed. <td valign="top" width="75%"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NAME; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_ID; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_IMAGE; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_IMAGE_NAME; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_DIMENSIONS; ?></td> </tr> <?php $query1 = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_id = '" . $options_id . "'" ); //First find all the products options values that belong to the selected product option while ($result1 = tep_db_fetch_array($query1)) { $products_options_values_id = $result1['products_options_values_id']; //Now pull their details from the database $query2 = tep_db_query ("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $products_options_values_id . "' and language_id = '" .$language_id . "'"); while ($result2 = tep_db_fetch_array($query2)) { $products_options_values_name = $result2 ['products_options_values_name']; $products_options_values_id = $result2 ['products_options_values_id']; $products_options_values_thumbnail = $result2['products_options_values_thumbnail']; $products_options_values_dimensions = $result2['products_options_values_dimensions']; if ($HTTP_GET_VARS['cID'] == $products_options_values_id){ $selected_value['name'] = $products_options_values_name; $selected_value['id'] = $products_options_values_id; $selected_value['image'] = $products_options_values_thumbnail; $selected_value['dimensions'] = $products_options_values_dimensions; $selected_value['id'] = $products_options_values_id; } if ( (isset($selected_value['id'])) && ($products_options_values_id == $selected_value['id']) ) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . tep_href_link(FILENAME_OPTIONS_IMAGES, '&cID=' . $products_options_values_id . '&box_id=' . $options_id . '&action=edit') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . tep_href_link(FILENAME_OPTIONS_IMAGES, '&cID=' . $products_options_values_id . '&box_id=' . $options_id ) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo $products_options_values_name ?></td> <td class="dataTableContent"><?php echo $products_options_values_id ?></td> <td class="dataTableContent" align="center"><?php echo tep_image(DIR_WS_CATALOG_IMAGES . 'options/' . $products_options_values_thumbnail, $products_options_values_name, OPTIONS_IMAGES_WIDTH, OPTIONS_IMAGES_HEIGHT) ?></td> <td class="dataTableContent"><?php echo $products_options_values_thumbnail ?></td> <td class="dataTableContent"><?php echo $products_options_values_dimensions ?></td> </tr> <?php } } ?> Thanks in advance for any consideration. Michael
  2. Hello All, I am using Options as Images v1.2. I have looked through the forums and have not been able to make this work. I am trying to change the sort order in the admin section to sort by products_options_values_name. Currently, we have many (500+) option values for one option and they are sorted by options_values_id. I have tried adding "order by products_options_values_name" at the end of $query2, but it does not seem to work. Maybe someone with more PHP/MySQL knowledge can figure this out. Below is the relevant section of code. I can post the entire file if needed. <td valign="top" width="75%"><table border="0" width="100%" cellspacing="0" cellpadding="2"> <tr class="dataTableHeadingRow"> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_NAME; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_ID; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_IMAGE; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_IMAGE_NAME; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_DIMENSIONS; ?></td> </tr> <?php $query1 = tep_db_query("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES_TO_PRODUCTS_OPTIONS . " where products_options_id = '" . $options_id . "'" ); //First find all the products options values that belong to the selected product option while ($result1 = tep_db_fetch_array($query1)) { $products_options_values_id = $result1['products_options_values_id']; //Now pull their details from the database $query2 = tep_db_query ("select * from " . TABLE_PRODUCTS_OPTIONS_VALUES . " where products_options_values_id = '" . $products_options_values_id . "' and language_id = '" .$language_id . "'"); while ($result2 = tep_db_fetch_array($query2)) { $products_options_values_name = $result2 ['products_options_values_name']; $products_options_values_id = $result2 ['products_options_values_id']; $products_options_values_thumbnail = $result2['products_options_values_thumbnail']; $products_options_values_dimensions = $result2['products_options_values_dimensions']; if ($HTTP_GET_VARS['cID'] == $products_options_values_id){ $selected_value['name'] = $products_options_values_name; $selected_value['id'] = $products_options_values_id; $selected_value['image'] = $products_options_values_thumbnail; $selected_value['dimensions'] = $products_options_values_dimensions; $selected_value['id'] = $products_options_values_id; } if ( (isset($selected_value['id'])) && ($products_options_values_id == $selected_value['id']) ) { echo ' <tr class="dataTableRowSelected" onmouseover="this.style.cursor=\'hand\'" onclick="document.location.href=\'' . tep_href_link(FILENAME_OPTIONS_IMAGES, '&cID=' . $products_options_values_id . '&box_id=' . $options_id . '&action=edit') . '\'">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="this.className=\'dataTableRowOver\';this.style.cursor=\'hand\'" onmouseout="this.className=\'dataTableRow\'" onclick="document.location.href=\'' . tep_href_link(FILENAME_OPTIONS_IMAGES, '&cID=' . $products_options_values_id . '&box_id=' . $options_id ) . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo $products_options_values_name ?></td> <td class="dataTableContent"><?php echo $products_options_values_id ?></td> <td class="dataTableContent" align="center"><?php echo tep_image(DIR_WS_CATALOG_IMAGES . 'options/' . $products_options_values_thumbnail, $products_options_values_name, OPTIONS_IMAGES_WIDTH, OPTIONS_IMAGES_HEIGHT) ?></td> <td class="dataTableContent"><?php echo $products_options_values_thumbnail ?></td> <td class="dataTableContent"><?php echo $products_options_values_dimensions ?></td> </tr> <?php } } ?> Thanks in advance for any consideration. Michael
  3. Hi All, I am getting a PHP Warning when I perform any of the operations on the orders page (capture, refund, charge). The transactions work even though I get this warning in my error_log. [04-Mar-2010 17:53:34] PHP Warning: include(): Failed opening '/path_to_html_files/includes/configure.php' for inclusion (include_path='.:/usr/local/lib/php-pear') in /path_to_html_files/admin/includes/paypal_wpp/paypal_wpp_capture.php on line 11 My admin directory is directly in the html folder and not in the catalog folder. This is from paypal_wpp_capture.php. The third line is generating this warning. chdir('../../'); include('includes/application_top.php'); include(DIR_FS_DOCUMENT_ROOT . DIR_WS_INCLUDES . 'configure.php'); include(DIR_WS_CLASSES . 'order.php'); include(DIR_WS_INCLUDES . 'paypal_wpp/paypal_wpp_include.php'); $paypal_wpp = new paypal_wpp_admin; My question is, does this matter and if so, which directory do I need to point to? admin/includes/configure.php or catalog/includes/configure.php Thank you for your help. Michael
  4. Brian, I didn't mention it, but I am upgrading from version 0.9.2. CCGV was working fine with this version. Michael
  5. Hi Brian, I tried changing it to what you have here, and it does work. For some reason or other, the version I downloaded had "htmlspecialchars" in front of each link. This is what did not work. At any rate, this code does work. However, I do have another problem I was hoping you could help me with. I've got the contribution working in the sandbox. I modified checkout_payment.php in order to allow coupons to be redeemed during the checkout process. This is the code. <!-- Points/Rewards Module V2.1rc2a Redeemption box bof --> <?php if ((USE_POINTS_SYSTEM == 'true') && (USE_REDEEM_SYSTEM == 'true')) { echo points_selection(); if (tep_not_null(USE_REFERRAL_SYSTEM) && (tep_count_customer_orders() == 0)) { echo referral_input(); } } ?> <!-- Points/Rewards Module V2.1rc2a Redeemption box eof --> <?php //---PayPal WPP Modification START ---// } else { tep_paypal_wpp_switch_checkout_method(FILENAME_CHECKOUT_PAYMENT); //---mvigil514 bof CCGV Mods ---// // #################### Added CGV ###################### echo $order_total_modules->credit_selection();//ICW ADDED FOR CREDIT CLASS SYSTEM // #################### End Added CGV ###################### //--- mvigil514 eof CCGV Mod ---// } //---PayPal WPP Modification END ---// The portion with mvigil514 comments is where I added the coupon redemption. My problem is that when a customer has a Gift Certificate balance, the checkout process doesn't work. What happens is the customer will go through the entire checkout process, express checkout or direct payment, and everything appears to have worked properly. The order is inserted into the database, and the customer can see it in order history and admin can also see the order. The problem is that the payment method or information is not being passed to or from Paypal as far as I can tell. The payment info never makes it into the database and therefore does not show up in the Paypal merchant account. I don't know if I have given you enough information, but any help would be appreciated. I am using CCGV 5.16. Let me know if you need any more information. Thank you for your time. Michael
  6. Hi All, I am upgrading from version 0.9.2 to version 1.0.7. I uninstalled the old version, updated all files to RC2A and then installed the update. I had to update includes/modules/payment/paypal_wpp.php because I was loosing session ID and cart contents (I got logged out) when I tried to use Express Checkout. //These strings need to have ampersands escaped //mvigil514 bof To fix on wpp post 3696 4/29/2009, comment out 1st set of statements and uncomment 2nd set of statements // /* $order_info['PAYPAL_RETURN_URL'] = htmlspecialchars(tep_href_link(basename($_SERVER['SCRIPT_NAME']), 'action=express_checkout', 'SSL')); $order_info['PAYPAL_CANCEL_URL'] = htmlspecialchars(tep_href_link($redirect_path, $redirect_attr, 'SSL')); */ $temp_return_link = tep_href_link(basename($_SERVER['SCRIPT_NAME']), '', 'SSL'); $order_info['PAYPAL_RETURN_URL'] = $temp_return_link . '&action=express_checkout'; $order_info['PAYPAL_CANCEL_URL'] = $temp_return_link . '&action=ec_cancel'; // // mvigil514 eof post 3696 // At this point, it seems as if Paypal was working properly, but I hadn't done extensive testing. I proceeded to modify the code so that I could allow people to redeem a coupon after returning from Paypal. I made some changes and got that working, but it seems that Paypal quit working. So, I undid all the changes???? I made a backup of the site, but no matter how I try to revert, I can't get Paypal to work. This is what is wrong. I click Use Express Checkout. I get directed to Sandbox. I sign in and choose continue at Paypal. I get redirected to my site. I choose shipping, continue and go to payment to choose coupon, if necessary, and continue and then confirm. The checkout is a success. The order is processed, emails are sent out, order shows up in admin, but the payment method isn't recorded or displayed anywhere, Paypal merchant account doesn't get paid and no "capture funds" button appears in the admin order edit screen. Additionally, when I use credit card on site, the payment method does not appear either. Also, I can use any CC number and it will still let me check out (I don't know if this is supposed to happen or not). I certainly would appreciate any help anyone can give me. I hope I'm just missing something obvious. Michael
  7. Hi Glen, Thanks for the quick response. I am using CCGV v5.16 from Feb 8, 2006. It has been working fine with WPP 0.92. I think I may not have been clear. When I get to the payment page, there are no other options for payment or for applying coupons or gift certificates, like in the previous version. It does say, "You are checking out the Express checkout, click here to select another payment method". And, the "Continue" button to proceed to confirmation. These are my WPP settings. Thanks again, Michael
  8. Hi All, First of all, thanks to everyone who has contributed to this great contribution. I've installed V1.07 (from Github). I am upgrading from 0.92. After installation, this is my status. Ran wpp_diagnostics.php, all is well. First problem was getting sent back to empty shopping cart (lost session id). Got that taken care of, previous post, by altering return url string in paypal_wpp.php. Now I have a couple of more problems. First one is that when I go to Paypal during express checkout and come back, I am redirected to shipping.php. All ok, select shipping method and hit continue, now I go to checkout_payment.php (paypal set to show payment page), but I don't have the options to apply coupon (CCGV installed) or to use gift certificate, or Reward Points. Only shows, you are checking out with Express Checkout and ability to choose another form of payment. Second problem is when I capture funds through admin, the order status is not being updated and the customer is not being notified. I have been looking through this forum for some time, and am having a hard time finding the solutions. Any help would be appreciated. Thanks, Michael
  9. I am also having this problem. I have version 5.16 installed, with Ultimate SEO urls, Points and Rewards plus others. I can't say exactly when it quit working, but I suspect it was after I installed SEO urls. Has anybody found the solution to the problem. I have also updated to RC2a. If anyone has solved this, I would appreciate any help. Michael
  10. I can definitely confirm that your code does in fact fix the total addup issue when an order is in the 4 digits. Thank you so much! I'm not proficient at PHP, but the way it was explained to me, you've reverted back to the original code and undone what the author intended to do??? I had a friend look at this as I was having the same problem. He came up with this. Replace: $order->info['total'] = number_format($order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4); With this: $order->info['total'] = number_format($order->info['total'] - tep_calc_shopping_pvalue($customer_shopping_points_spending), 4, '.', ''); It worked for me, and will still keep the original fix intact. Michael
  11. By the way, the thumbnail is being created in the imagecache folder. Michael
  12. Hi all, I installed this contribution, but cannot generate a catalog. Server is running PHP 5.2.0. Has anyone been successful installing with PHP 5.2+? With show images enabled, I get this error: FPDF error: Image file has no extension and no type was specified: /xxx/xxx/xxxx/xxx/xxx/catalog/images/imagecache/. With images disabled, I get a page with the header, left column and the title "PDF catalogs generation", but no catalog gets generated. Both catalogues and imagecache directories are set to 777, I only have one product, image is larger than config setting. It is a jpg image. I tried commenting out the debug lines in pdf_catalogue.php, but nothing happens to show an error. Any ideas? Michael
  13. As far as your first issue is concerned, did you make the necessary changes to admin/inlcudes/filenames.php? You should have added the following line: define ('FILENAME_OPTIONS_IMAGES', 'options_images.php'); As for the second part of your post, it seems you should be able to add width attributes to the <td> and <table> tags. But that did not work for me. If you figure it out, please post here and I will do the same. I haven't got a clue on the dropdown menu part. hth Michael
  14. Falkenberg, in the admin section, make sure you have options images disabled for the products which only have text options. Michael
×
×
  • Create New...