Contributions

Made a fix to the instructions and SQL error.

Finally, a real update to the Fraud Detection Service. Protects more that just credit card transactions. Lots of updated fields and scores are more accurate than ever.

Support Thread Here:
http://forums.oscommerce.com/index.php?showtopic=94275

Small Update - I will try to get back into the add-on and update things as required very soon.

Change notes: 24 Dec 2006 01:45:01 V1.54
(1) Added PayPal IPN compatibility for the PayPal_Shopping_Cart_IPN module.
(2) Modified the "Everybody else (so far) FIND:" in Step 6 to ALWAYS perform a fraud check even if its not a credit card transaction!

Change notes: 09 Sept 2004 08:20:59 V1.52
(1) Added comment to relate scores
(2) Updated english.php link.
(3) Moved code around
(4) Added more info to debug code/testing

Added small comment to orders.php to reflect the score:

Score 2.4 (Low Risk)
Score 9 (Extremely High Risk)

and so on...

Also added default CC folder, forgot to add it in the last package and update the install docs.

Version 1.5

Change notes: 20 August 2004 11:20:59 V1.5
(1) Added Stuart's code for split email CC/default module
(2) New Instructions in HTML format. (Its perdyier)
(3) Auth.net instructions updated
(4) Fixed wrong query that got left out somewhere between 1.2 and 1.3 with thanks to Strider (CCGV contributor )
(5) New API's from MaxMind (More features, you can get an account here: www.maxmind.com Tell em Noel sent ya!
(6) New feature allows you to do a reverse search of the telephone #, hover over where it says: "Phone Match" to search.

This is a complete package containing a workaround for the extra order email not being sent when using the stock cc.php module from osC

It has ONLY been tested against cc.php on a osC2.2 (Dec 2002) installation, but I "think" that it should be OK on MS2. It HAS NOT been tested against any other credit modules other than the stock osC cc.php

Other changes:
1) Added customer phone match and high risk country fields to the output
2) Added a clickable link to the Technical Details page at MaxMind.com
3) Reformatted the output that appears in admin/orders.php (screenshot included)
4) Changed some references that were calling "customer" when they should be calling "billing"

All credit for the original mod goes to Noel Latsha and thanks for assistance with these changes to Acheron and stevel!

Change notes: 14 June 2004 08:20:59 V1.4
(1) Cleaned up code
(2) Added options for advanced queries
(3) Replaced maxmind files with updated versions
(4) Added testing file & instructs
(5) Instructions for upgrades added too...

In case anybody was wondering, this is a FREE service from MaxMind.

Change notes: 22 May 2004 18:20:59
(1) Fixed wrong files uploaded
(1) Removed a db query, because it was already there (thanks stevel)

Change notes: 22 May 2004 08:50:59
(1) Fixed need to enter code (if you want, otherwise its 20 requests per IP address, per day)
(1) Fixed another problem with the file, upload over old one...

Change notes: 22 May 2004 08:12:59
(1) Fixed IP address call, no longer out of the database, upload maxmind.php over your old one for this to work.
(2) Updated instructs for comments and extra line in orders.php
(3) New DB call for correct state code.

This will allow the the owner to query the MaxMind servers to place a risk score (1-10, 1=Good, 10=U Crazy?) with credit card transactions.

From MaxMind Site:

"Credit card fraud is a growing problem for online merchants. As the merchant, you are liable for fraudulent credit card transactions, as well as chargeback fees. Excessive chargebacks

can lead to losing your merchant account and being unable to open another one.

MaxMind Credit Card Fraud Detection tools automatically sift through your online charges to flag potentially fraudulent transactions. The service works by combining MaxMind GeoIP
geolocation metrics - identifying the geographic source of the charge - with additional checks for known security risks. MaxMind tools pin down potential fraud and identify associated risk
factors, pointing you to the best strategy to verify the flagged transaction and prevent future fraud."

Example:

This is on your order details page:

MAXMIND Score: 2.4
Distance: 1500 Country Match: YES Country Code: US Free Email: NO
Anonymous Proxy: NO Bin Match: NA Bin Country: NA Error:
Proxy Score: 3 Spam Score: 3 Bin Name: NA Bin Country: NA
ISP: COMCAST ISP Org: COMCAST

But it looks better than that!

View image here:
http://www.nabcomdiamonds.com/catalog/images/maxmind.jpg

Support thread here: http://forums.oscommerce.com/index.php?act=ST&f=7&t=94275