Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

nrlatsha

Members
  • Posts

    486
  • Joined

  • Last visited

Everything posted by nrlatsha

  1. I don't have any options for shipping, just flat amount radio button, no checkbox. Don't get double charged for shipping.
  2. PayPal and CCGV - I've had to change around the sort order a little bit, based on confusion to the customer as well. 1. Discount Coupons 2. Gift Vouchers 3. Sub-Total 4. Tax 5. Shipping 6. Total In that order the subtotal will be shown with the DC/GV taken off. Now, keep in mind there are options within the CCGV modules, such as, re-calculate shipping, re-calc tax, add shipping, add tax before calculation, so on and so forth. I think the default options here are to re-calculate everything. That is where you add/remove discounts on shipping and whatnot For tax/double tax - For those that have both an OSC website AND auctions on eBay. I don't know of the best way around this. Perhaps it could be written into the next PayPal module ;) Or it already might be, but I didn't see an option, anyway... PayPal charges based on the tax zone you set up on their site AND the tax you passed in order subtotal (subtotal calculates this auto, even if you remove the subtotal module?!?) I don't quite know where the tax variable is being passed in the IPN contrib, I'm sure Greg knows that PDF back and forth by now. But I didn't want to dive into that without getting Greg's opinion first... ;) So you'll have to remove the tax zone from either your PayPal module or your store (If you only use PayPal, you can remove it from your store, otherwise I'd remove it from PayPal) Or set up a second account with PayPal for auctions/whatnot... I think for the shipping issues you'll need to double check your shipping options on the PayPal site. I think I got everything there, did I miss something? Donations are gladly accepted through PayPal.... Whoops, sorry, forgot you guys couldn't get it workin :lol: ....Just Kidding, thought I'd try to lighten the mood in here... :D
  3. Ask and you shall receive... I also added an area so you can input your own DNS query address. Keep in mind, if you have user_tracking installed, you won't need to add the first two queries. Run this on mysql: 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 ('', 'User Tracking (exclude this IP-Address)', 'CONFIG_USER_TRACKING_EXCLUDED', 'your IP', 'Do NOT record this IP Address<br>(like webmaster/owners/Beta-testers)', 1, 2, 'now()', 'now()', NULL, NULL); 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 ('', 'User Tracking (your favorite WHOIS URL)', 'USER_TRACKING_WHOIS_URL', 'http://www.dnsstuff.com/tools/whois.ch?ip=', 'Put here you favorite WHOIS tracking site<br>(the IP will follow automatically after this url)', 1, 3, 'now()', 'now()', NULL, NULL); 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 ('', 'Who\'s Online Refresh Time', 'WHOS_ONLINE_REFRESH', '60', 'Who\'s Online Refresh Time', 1, 3, 'now()', 'now()', NULL, NULL); Use this as your whos_online.php: <?php /* $Id: whos_online.php,v 1.32 2003/06/29 22:50:52 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2003 osCommerce Released under the GNU General Public License Updated by Noel Latsha www.nabcomdiamonds.com */ $xx_mins_ago = (time() - 900); require('includes/application_top.php'); require(DIR_WS_CLASSES . 'currencies.php'); $currencies = new currencies(); $refresh = WHOS_ONLINE_REFRESH; // Mod by Noel // remove entries that have expired tep_db_query("delete from " . TABLE_WHOS_ONLINE . " where time_last_click < '" . $xx_mins_ago . "'"); ?> <!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN"> <html <?php echo HTML_PARAMS; ?>> <head> <meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>"> <title><?php echo TITLE; ?></title> <META HTTP-EQUIV="Refresh" CONTENT="<? echo $refresh; ?>;"> <link rel="stylesheet" type="text/css" href="includes/stylesheet.css"> <script language="javascript" src="includes/general.js"></script> </head> <body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF"> <!-- header //--> <?php require(DIR_WS_INCLUDES . 'header.php'); ?> <!-- header_eof //--> <!-- body //--> <table border="0" width="100%" 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><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_draw_separator('pixel_trans.gif', HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td> </tr> </table></td> </tr> <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"><?php echo TABLE_HEADING_ONLINE; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_CUSTOMER_ID; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_FULL_NAME; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_IP_ADDRESS; ?></td> <!-- <td class="dataTableHeadingContent" align="center"><?php echo WhoIs ?></td> --> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_ENTRY_TIME; ?></td> <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_LAST_CLICK; ?></td> <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_LAST_PAGE_URL; ?> </td> </tr> <?php // Modified by Noel $whos_online_query = tep_db_query("select customer_id, full_name, ip_address, time_entry, time_last_click, last_page_url, session_id from " . TABLE_WHOS_ONLINE . " where ip_address != '" . CONFIG_USER_TRACKING_EXCLUDED . "' order by ip_address"); while ($whos_online = tep_db_fetch_array($whos_online_query)) { $time_online = (time() - $whos_online['time_entry']); if ((!isset($HTTP_GET_VARS['info']) || (isset($HTTP_GET_VARS['info']) && ($HTTP_GET_VARS['info'] == $whos_online['session_id']))) && !isset($info)) { $info = $whos_online['session_id']; } /* BEGIN COUNT MOD */ if ($old_array['ip_address'] == $whos_online['ip_address']) { $i++; } /* END COUNT MOD */ if ($whos_online['session_id'] == $info) { echo ' <tr id="defaultSelected" class="dataTableRowSelected" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)">' . "\n"; } else { echo ' <tr class="dataTableRow" onmouseover="rowOverEffect(this)" onmouseout="rowOutEffect(this)" onclick="document.location.href=\'' . tep_href_link(FILENAME_WHOS_ONLINE, tep_get_all_get_params(array('info', 'action')) . 'info=' . $whos_online['session_id'], 'NONSSL') . '\'">' . "\n"; } ?> <td class="dataTableContent"><?php echo gmdate('H:i:s', $time_online); ?></td> <td class="dataTableContent" align="center"><a HREF="customers.php?selected_box=customers&cID=<?php echo $whos_online['customer_id']; ?>&action=edit"><?php echo $whos_online['customer_id']; ?></a></td> <td class="dataTableContent"><?php echo $whos_online['full_name']; ?></td> <!-- BEGIN LINK MOD --> <td class="dataTableContent" align="center"><a href="<?php echo USER_TRACKING_WHOIS_URL; echo $whos_online['ip_address']; ?>" target="_blank"><?php echo $whos_online['ip_address']; ?></a></td> <!-- END LINK MOD --> <td class="dataTableContent"><?php echo date('H:i:s', $whos_online['time_entry'] - 7200 ); ?></td> <td class="dataTableContent" align="center"><?php echo date('H:i:s', $whos_online['time_last_click'] - 7200 ); ?></td> <td class="dataTableContent"><a HREF="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . $whos_online['last_page_url']; ?>" target=\"_blank\"><?php if (eregi('^(.*)' . tep_session_name() . '=[a-f,0-9]+[&]*(.*)', $whos_online['last_page_url'], $array)) { echo $array[1] . $array[2]; } else { echo $whos_online['last_page_url']; } ?></a> </td> </tr> <?php $old_array = $whos_online; } if (!$i) { $i=0; } $total_dupes = $i; $total_sess = tep_db_num_rows($whos_online_query); $total_cust = $total_sess - $total_dupes; ?> <tr> <td class="smallText" colspan="7"><?php echo sprintf(TEXT_NUMBER_OF_CUSTOMERS, $total_sess); print "<br>Duplicate IPs: $total_dupes<br>Real customers: $total_cust";?></td> </tr> </table></td> <?php $heading = array(); $contents = array(); if (isset($info)) { $heading[] = array('text' => '<b>' . TABLE_HEADING_SHOPPING_CART . '</b>'); if (STORE_SESSIONS == 'mysql') { $session_data = tep_db_query("select value from " . TABLE_SESSIONS . " WHERE sesskey = '" . $info . "'"); $session_data = tep_db_fetch_array($session_data); $session_data = trim($session_data['value']); } else { if ( (file_exists(tep_session_save_path() . '/sess_' . $info)) && (filesize(tep_session_save_path() . '/sess_' . $info) > 0) ) { $session_data = file(tep_session_save_path() . '/sess_' . $info); $session_data = trim(implode('', $session_data)); } } if ($length = strlen($session_data)) { if (PHP_VERSION < 4) { $start_id = strpos($session_data, 'customer_id[==]s'); $start_cart = strpos($session_data, 'cart[==]o'); $start_currency = strpos($session_data, 'currency[==]s'); $start_country = strpos($session_data, 'customer_country_id[==]s'); $start_zone = strpos($session_data, 'customer_zone_id[==]s'); } else { $start_id = strpos($session_data, 'customer_id|s'); $start_cart = strpos($session_data, 'cart|O'); $start_currency = strpos($session_data, 'currency|s'); $start_country = strpos($session_data, 'customer_country_id|s'); $start_zone = strpos($session_data, 'customer_zone_id|s'); } for ($i=$start_cart; $i<$length; $i++) { if ($session_data[$i] == '{') { if (isset($tag)) { $tag++; } else { $tag = 1; } } elseif ($session_data[$i] == '}') { $tag--; } elseif ( (isset($tag)) && ($tag < 1) ) { break; } } $session_data_id = substr($session_data, $start_id, (strpos($session_data, ';', $start_id) - $start_id + 1)); $session_data_cart = substr($session_data, $start_cart, $i); $session_data_currency = substr($session_data, $start_currency, (strpos($session_data, ';', $start_currency) - $start_currency + 1)); $session_data_country = substr($session_data, $start_country, (strpos($session_data, ';', $start_country) - $start_country + 1)); $session_data_zone = substr($session_data, $start_zone, (strpos($session_data, ';', $start_zone) - $start_zone + 1)); session_decode($session_data_id); session_decode($session_data_currency); session_decode($session_data_country); session_decode($session_data_zone); session_decode($session_data_cart); if (PHP_VERSION < 4) { $broken_cart = $cart; $cart = new shoppingCart; $cart->unserialize($broken_cart); } if (is_object($cart)) { $products = $cart->get_products(); for ($i = 0, $n = sizeof($products); $i < $n; $i++) { $contents[] = array('text' => $products[$i]['quantity'] . ' x ' . $products[$i]['name']); } if (sizeof($products) > 0) { $contents[] = array('text' => tep_draw_separator('pixel_black.gif', '100%', '1')); $contents[] = array('align' => 'right', 'text' => TEXT_SHOPPING_CART_SUBTOTAL . ' ' . $currencies->format($cart->show_total(), true, $currency)); } else { $contents[] = array('text' => ' '); } } } } 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> </table></td> </tr> </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'); ?> Also - anywhere you see "- 7200" is where I set up the times to be local to MST. You can delete that for EST or modify it for your time zone. You'll need to go into admin->my store to set up the "your IP" field at least. Refresh is default of 60 and NSLookup is the original one... Lemme know if you have any problems... Or if its of use to you... Noel
  4. Follow your instructions for admin secure contrib. You need to add that page under "file access"
  5. Keep going down the list until you get to the one with the instructions. The one you downloaded is an update. You'll need the 10 Aug one...
  6. Hello, I noticed this thread and the new contrib, just wanted to share what I did to my whos_online file, its very similar to the contrib. I only made a couple of differences: 1. I have the refresh time as a database entry, so it can be changed to what I see fit. Similar to the buttons I see now, but I don't know if those values stay the next time you visit. 2. I have User Tracking installed and use the database entry to exclude my IP address from the results all together. Of course you can do this without that contrib too... 3. I got rid of the separate whois field and turned the IP address into the link to whois server to help it be less cluttered. If anybody is interested, I can post them here. I see the current contrib does pretty much the same thing, just differently (cept for the exclude IP thing). Noel
  7. Sorry for the late replies here guys. I've had back problems and an highly medicated. As you can guess, its hard to try to look at code when you're highly medicated... kenb - Try the same example you used, but use it with an order id already in your orders table. It should put it into your maxmind table (Like you tested already.) Then when you go into admin, it should be able to pull up the maxmind info for that order. Then we can see if the problem is when it is getting called for a new order, or if its a problem with the query. You're probably right, its a problem with where its getting called in the order process. I didn't see any changes that were made to order conf with surepay though. Unless I missed something, which I very well could have... sefu -Try changin this part in maxmind.php: $string = $sql_data_array['cc_number']; $cc = substr($string, 0, 6); To this: $cc = substr($plain_data, 0, 6); stevel -I'll have to look at that one more, but it does seem weird, all variables are different and I don't see anything that would stop it from getting those emails out... magicproshop - Did the final changes get everything to work? Let me know if this stuff works guys. I'm not in the best mind state right now, but didn't want to leave anybody hanging.
  8. PayPal IPN and CCGV - Two great tastes that taste great together I have Greg's PayPal IPN and Strider's CCGV working great together. I just tested it using: 1. Gift Voucher: Check 2. Discount Coupon: Check 3. Gift Voucher and Discount Coupon: Check There is also a bug report about checkout_process.php's logic. You can see this here: Error in checkout_process.php's logic The fix for the above code is here: http://www.oscommerce.com/forums/index.php?sho...10entry333815 The only thing that I can see might give people an issue is with the sort order of the order totals module. That is the fix for 85% of questions Strider gets asked about order totals. Make sure they are set up as follows (Your numbers may vary, but make sure they are in this order): 1. Shipping 2. Discount Coupons 3. Gift Vouchers 4. Sub-Total 5. Tax 6. Total 1. Shipping is static - You want this for the total of the order, nat after discounts/Gift certs are applied. 2. Discount Coupons - You want discounts to be applied before gift certificates, not after. 3. You want their gift certificates taken off after you apply shipping and a discount. 4. Sub total - When placed here, You get the true subtotal of everything. This is the number passed to PayPal or your CC processor. 5. Tax - You want tax applied to the subtotal. 6. Total - This is the total price you pay. PayPal IPN sends the shipping total and the sub-total to PayPal. Its not that it's sending the incorrect amount to PayPal, but you may not have the correct sort order. There is also an issue with these modules both calling the order module. To fix this, do this: In \catalog\includes\modules\payment\paypal\checkout_process.php find: require(DIR_WS_CLASSES . 'order_total.php'); $order_total_modules = new order_total; Change that to: if(!class_exists('order_total')) { include(DIR_WS_CLASSES . 'order_total.php'); $order_total_modules = new order_total; } Hope this helps. Let me know. Noel
  9. I don't know how you have it set in admin, but it needs to look like this: Sales<[email protected]>, Information<[email protected]>, Store Owner<[email protected]>, Webmaster<[email protected]>, Customer Service<[email protected]> It looks like an error due to incorrect settings...
  10. I just upgraded to premium services. It offers the following: Bank Name Credit Card's registered address city IP address region (It shows state for me) IP address Latitude and Longitude (Put your finger right on them!) Thought that was pretty cool. I will be updating this contrib over the next couple of days with this new information in case any other store owners want to upgrade, its already included in the files... You can see what the new parts will look like here: http://www.nabcomdiamonds.com/catalog/images/maxmind2.jpeg Right now though.... gotta go to work :(
  11. I have it working good on mine, there were a couple issues, but got that sorted out quickly. I'd say on a contribution this large and with soooo many different store configurations and everybody modifying their own code that yeah, there are going to be some issues you may come across. But obviously Greg is willing to help out any and all who install this. Once again, great contrib Greg.
  12. Yes, but you'll have to download and follow the "how to add fields to easy populate" here: http://www.oscommerce.com/community/contributions,1717
  13. bglkk - Glad you like it I don't get Bin Name at all, Bin Match and Bin Country yeah, but not Bin Name... Alright, Linkpoint, Authorize.net and default CC module down, 8 million more to go...
  14. Now when I try to place an order I get the following error. This error is genereated when I hit the "confirm order" button. Any ideas? You need to make sure you added the lines to admin's english.php per the instructions. Make sure those files are there in catalog/includes/modules/maxmind/ folder.
  15. magicshoppro - Step 3 (Sorry, getting ahead of myself) 1. in admin/orders.php find this: <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td> <td class="main"><?php echo $order->info['payment_method']; ?></td> </tr> <?php Add the code you added before after that, like this: <td><table border="0" cellspacing="0" cellpadding="2"> <tr> <td class="main"><b><?php echo ENTRY_PAYMENT_METHOD; ?></b></td> <td class="main"><?php echo $order->info['payment_method']; ?></td> </tr> <? // Addition for MaxMind CC check $check_maxmind_query = tep_db_query("select distance, country_match, country_code, free_mail, anonymous_proxy, score, bin_match, bin_country, err, proxy_score, spam_score, bin_name, ip_isp, ip_org from " . TABLE_ORDERS_MAXMIND . " where order_id = '" . (int)$oID . "'"); $maxmind_query = tep_db_fetch_array($check_maxmind_query); ?> </tr> </table> <table width="75%"> <tr> <td class="main"><?php echo '<br><br><b>MAXMIND</b>' . ' ' . MAXMIND_SCORE . '<b>' . $maxmind_query['score'] . '</b>'; ?></td> </tr> <tr> <td class="main"><?php echo MAXMIND_DISTANCE . '<b>' . $maxmind_query['distance'] . '</b>'; ?></td> <td class="main"><?php echo MAXMIND_COUNTRY . '<b>' . $maxmind_query['country_match'] . '</b>'; ?></td> <td class="main"><?php echo MAXMIND_CODE . '<b>' . $maxmind_query['country_code'] . '</b>'; ?></td> <td class="main"><?php echo MAXMIND_FREE_EMAIL . '<b>' . $maxmind_query['free_mail'] . '</b>'; ?></td> </tr> <tr> <td class="main"><?php echo MAXMIND_ANONYMOUS . '<b>' . $maxmind_query['anonymous_proxy'] . '</b>'; ?></td> <td class="main"><?php echo MAXMIND_BIN_MATCH . '<b>' . $maxmind_query['bin_match'] . '</b>'; ?></td> <td class="main"><?php echo MAXMIND_BIN_COUNTRY . '<b>' . $maxmind_query['bin_country'] . '</b>'; ?></td> <td class="main"><?php echo MAXMIND_ERR . '<b>' . $maxmind_query['err'] . '</b>'; ?></td> </tr> <tr> <td class="main"><?php echo MAXMIND_PROXY_SCORE . '<b>' . $maxmind_query['proxy_score'] . '</b>'; ?></td> <td class="main"><?php echo MAXMIND_SPAM . '<b>' . $maxmind_query['spam_score'] . '</b>'; ?></td> <td class="main"><?php echo MAXMIND_BIN_NAME . '<b>' . $maxmind_query['bin_name'] . '</b>'; ?></td> <td class="main"><?php echo MAXMIND_IP_ISP . '<b>' . $maxmind_query['ip_isp'] . '</b>'; ?></td> </tr> <tr> <td class="main"><?php echo MAXMIND_IP_ISP_ORG . '<b>' . $maxmind_query['ip_org'] . '</b>'; ?></td> </tr> <?php // End addition for MaxMind Don't forget to delete the code you added to keep this file clean. Now when you go into admin, you should see the MaxMind addition....hopefully. Let me/thread know...
  16. magicproshop - Step 2: 1. open checkout_process and find this: if(MODULE_PAYMENT_AUTHORIZENET_STATUS) { include(DIR_WS_MODULES . 'authorizenet_direct.php'); } Replace with this: if(MODULE_PAYMENT_AUTHORIZENET_STATUS) { include(DIR_WS_MODULES . 'authorizenet_direct.php'); require(DIR_WS_MODULES . 'maxmind/maxmind.php'); } Run a test order and check the database to see if that order_maxmind table was populated with your test order. 2. Report your findings here.
  17. stevel - good point, missed that, will remove it for the next upload, which will probably have to include something special for Authorize.net. Do you happen to use auth.net for cc processing, and if so, does it work? I'm curious if this is an issue with just that specific contrib magic is using. magicproshop - I missed that in the example, but it will populate that when it does it in conjunction with an order. Now I just have to figure out auth.net code to get this working with that contrib.
  18. And is the databse table order_maxmind getting populated with the results?
  19. magicproshop - All right, we'll start from the beginning here and work our way down to the end... 1. Copy and save this test file as testmax.php or something and put it in your catalog/admin folder: <?php /* $Id: testmax.php,v 1.43 2004/05/21 22:50:51 hpdl Exp $ osCommerce, Open Source E-Commerce Solutions http://www.oscommerce.com Copyright (c) 2004 osCommerce Released under the GNU General Public License Noel Latsha, www.nabcomdiamonds.com */ // A couple of countries have to ruin it for everyone... require('includes/application_top.php'); // $oID = $insert_id; $oID = 10; // for testing, set this to a number of an order in your database that used CC to purchase //Enter your license key here $h["license_key"] = "XXXXXXX"; // ************************************* $check_status_query = tep_db_query("select customers_name, customers_street_address, customers_city, customers_postcode, customers_state, customers_country, customers_email_address from " . TABLE_ORDERS . " where orders_id = '" . (int)$oID . "'"); $check_status = tep_db_fetch_array($check_status_query); $check_country_query = tep_db_query("select countries_iso_code_2 from " . TABLE_COUNTRIES . " where countries_name = '" . $check_status['customers_country'] . "'"); $check_country = tep_db_fetch_array($check_country_query); $check_state_query = tep_db_query("select zone_code from " . TABLE_ZONES . " where zone_name = '" . $check_status['customers_state'] . "'"); $check_state = tep_db_fetch_array($check_state_query); require(DIR_WS_MODULES . 'maxmind/CreditCardFraudDetection.php'); //first we create a new CreditCardFraudDetection object $ccfs = new CreditCardFraudDetection; //Modify a few variables to match what MaxMind is expecting. $string = $sql_data_array['cc_number']; $cc = substr($string, 0, 6); $str = $check_status['customers_email_address']; list ($addy, $domain) = split ('[@]', $str); //next we set inputs and store them in a hash $h["i"] = $REMOTE_ADDR; // set the client ip address $h["domain"] = $domain; // set the Email domain $h["city"] = $check_status['customers_city']; // set the billing city $h["region"] = $select_state['zone_code']; // set the billing state $h["postal"] = $check_status['customers_postcode']; // set the billing zip code $h["country"] = $check_country['countries_iso_code_2']; // set the billing country // $h["bin"] = $cc; // set bank identification number - Obviously can't use this testing // If you want Secure HTTPS and you have Curl and OpenSSL installed // and the php curl binding then // uncomment the next line with the word isSecure $ccfs->isSecure = 1; //next we pass the input hash to the server $ccfs->input($h); //then we query the server $ccfs->query(); //then we get the result from the server $h = $ccfs->output(); //then finally we print out the result $outputkeys = array_keys($h); $sql_data_array = array( 'order_id' => $insert_id, 'distance' => $h['distance'], 'country_match' => $h['countryMatch'], 'country_code' => $h['countryCode'], 'free_mail' => $h['freeMail'], 'anonymous_proxy' => $h['anonymousProxy'], 'score' => $h['score'], 'bin_match' => $h['binMatch'], 'bin_country' => $h['binCountry'], 'err' => $h['err'], 'proxy_score' => $h['proxyScore'], 'spam_score' => $h['spamScore'], 'bin_name' => $h['binName'], 'ip_isp' => $h['ip_isp'], 'ip_org' => $h['ip_org']); tep_db_perform(TABLE_ORDERS_MAXMIND, $sql_data_array); $numoutputkeys = count($h); for ($i = 0; $i < $numoutputkeys; $i++) { $key = $outputkeys[$i]; $value = $h[$key]; print $key . " = " . $value . "\n"; echo '<br>'; } ?> 3. Modify that file to represent an order # in your database that has paid with a creditcard on this line: $oID = 10; // for testing, set this to a number of an order in your database that used CC to purchase 4. Go to that file via your web browser and you should see if it is working or the error message you are getting. Paste that info back here and we'll go from there.
  20. RobinsonDixon - You'll need those lines in HTTPBase.php. When I said to delete the last line in HTTPBase, I should have said, delete the last line, the extra line after the last ?>. Check CreditCardFraudProtection.php for an extra line after the last ?> as well. magicproshop - Yours has to do with Auth.net that I haven't quite solved yet (read: had to sleep) but I'll take a closer look at that now. I'll get a testing script together for you to test with to see what errors you may be getting...
  21. What does it show in orders.php for cc transactions? Does it show cc owner, first 4 numbers, anything?
  22. I'm gonna download and take a look at that contrib, see if I can't find something for ya. In the mean time, could you check your database table orders_maxmind and see if thats getting populated with information? Then at least half of its working...
  23. Could this be causing some troubles? Any help would be so greatly appreciated. Thank yoiu You don't see anything on the order page in admin? Even on previous orders, you should see something, as long as it was a credit card purchase. Anybody here use Auth.net and does this work for you? 1. Check to see if you see anything under the order details for this. 2. Look over the instructions and make sure you did them all. 3. If that still doesn't work, post here and we'll go from there.
×
×
  • Create New...