Credit Card Fraud Detection (MaxMind)

[Triforcetechs]

Hey i was getting errors on both the maxmind.php and maxmind_update.php and i had to replace
$h["passwordMD5"] = $check_customer_password['customers_password']; // CCFS will hash for us

with

$h["passwordMD5"] = $check_customer_password->fields['customers_password']; // CCFS will hash for us

In both of though files and then it started working becuase it would not let customers process any orders untell the maxmind.php was updated

Might want to check this out so you dont loose business.

Thank Chris

[SophWise.com]

Oop, sorry I forgot to post that here. Yes, I caught that one on the first order that came through after mods were done, but it didn't cause me a problem as I didn't use the standard implementation where you add a line to the /includes/modules/pages/checkout_process/header_php.php

I instead went ahead and wrote an observer class for it to attach at NOTIFY_HEADER_END_CHECKOUT_PROCESS

and added in exception handling to to the observer to prevent it from choking if something fails while doing the update.

If I can squeeze some time out of this horrible schedule of mine, I'll bag up my mods for others to enjoy.

Wes

[Goshawk]

Hi all,

This is an awesome mod, specially as recently I processed 2 orders that later proved to be paid by stolen cards.

I am using a 3rd party provider to process my online transactions for credit cards, (DirectOne) here in Australia. (Payment module has been adapted by me last year, and contribution available for download).

So I am not using the cc.php module. Will I now need to update the DirectOne module (written in cURL) to make it work?

And what needs to be altered?

Many thanks,

Goshawk

[ses707]

An update for this mod will be available shortly, there are a couple of other bug fixes and several new features, I'll try and get it bundled up this weekend. For other 3rd party payment modules all you need to do is mimic the credit card module with what is asked and kept on your own server before transferring or submitting the payment for processing.

[ses707]

Updated module has been submitted to download section and should be available soon.

Change Notes 1.1 - 1.2
1. Fixed delivery city not being passed for processing.
2. Fixed delivery state not being passed for processing.
3. Now compatible with GoogleCheckout (Check to see if state & country are already zone id's, store ip address).
4. Implemented new scoring (0-100 vs 0-10).
5. Implemented new score explanation.
6. Now includes checkout definitions for BIN name and phone on order page.
7. Manual update now shows what information is being sent out for processing.
8. Manual update query type selectable link (basic, standard, premium).
9. Manual delete now uses messageStack for success message.
10. Credit card checkout now has language file for bin name and phone.

[xman888]

Hello,

I am using Eway for accepting credit card payments.

I have uploaded the Maxmind files, and installed the database file.

After I have entered in the credit card details in the shopping cart, I get this error:

1054 Unknown column 'cc_bin_name' in 'field list'
in:
[select customers_name, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, customers_email_address, cc_number, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, ip_address, cc_bin_name, cc_bin_phone from zen_orders where orders_id = '4']


Anyone know what this error message might mean?

Kind regards,
Anthony

[xman888]

Hello,

I replaced the old header_php.php file, and now the error does not occur.

However there is no instance of Maxmind occuring/actually working.

Am I meant to actually modify something with the Eway plugin to get it working for the Maxmind plugin?

If so, does anyone know what file I would need to modify?

Kind regards,
Anthony

[Goshawk]

1054 Unknown column 'cc_bin_name' in 'field list'
in:
[select customers_name, billing_street_address, billing_city, billing_state, billing_postcode, billing_country, customers_telephone, customers_email_address, cc_number, delivery_street_address, delivery_city, delivery_state, delivery_postcode, delivery_country, ip_address, cc_bin_name, cc_bin_phone from zen_orders where orders_id = '4']

This refers to a column in your database that is not expected by the program, I I suggest you compare this table with the table in the sql file of Maxmind and see if there are any differences.

Goshawk

[xman888]

Hello,

Within Zen-cart --> Admin --> Orders, the Maxmind graphic does not appear below the orders.

Does anyone know what I have done wrong?

Kind regards,
anthony

[xman888]

Hello,

I am now getting this error:

1054 Unknown column 'high_risk_username' in 'field list'
in:
[INSERT INTO zen_orders_maxmind (order_id, country_match, country_code, hi_risk, distance, ip_region, ip_city, ip_latitude, ip_longitude, ip_isp, ip_org, anonymous_proxy, proxy_score, trans_proxy, free_mail, carder_email, high_risk_username, high_risk_password, bin_match, bin_country, bin_name_match, bin_name, bin_phone_match, bin_phone, cust_phone, ship_forward, city_postal_match, ship_city_postal_match, score, risk_score, explanation, queries_remaining, maxmind_id, err) VALUES ('8', 'Yes', 'AU', 'No', '3214', '02', 'Moss Vale', '-34.5500', '150.3832', 'ispOne Pty Ltd, Wholesale Internet Solutions', 'ispOne Pty Ltd, Wholesale Internet Solutions', 'No', '0.00', '', 'No', 'No', 'No', 'No', 'Yes', 'AU', 'NA', '', 'NA', '', '', 'NA', '', '', '1.60', '0.04', 'This order is low risk. This order is higher risk because the distance between the billing address and the user\'s actual location is so great', '985', 'QP54LAU5', '')]


Has anyone seen this error before?

Kind regards,
Anthony