Jump to content

andychev

Members
  • Content count

    4
  • Joined

  • Last visited

  1. andychev

    One Page Checkout Support

    To reslove the multiple new duplicate customers problem detailed in my post above in includes/classes/onepage_checkout.php Around line 755 Replace ------------------ function createCustomerAccount(){ global $currencies, $customer_id, $onepage, $customer_default_address_id, $customer_first_name, $customer_country_id, $customer_zone_id, $languages_id; if ($onepage['createAccount'] === true){ if (!tep_session_is_registered('customer_id')) tep_session_register('customer_id'); if (!tep_session_is_registered('customer_default_address_id')) tep_session_register('customer_default_address_id'); if (!tep_session_is_registered('customer_first_name')) tep_session_register('customer_first_name'); if (!tep_session_is_registered('customer_country_id')) tep_session_register('customer_country_id'); if (!tep_session_is_registered('customer_zone_id')) tep_session_register('customer_zone_id'); $sql_data_array = array( 'customers_firstname' => $onepage['billing']['firstname'], 'customers_lastname' => $onepage['billing']['lastname'], 'customers_email_address' => $onepage['customer']['email_address'], 'customers_telephone' => $onepage['customer']['telephone'], 'customers_fax' => $onepage['customer']['fax'], 'customers_newsletter' => $onepage['customer']['newsletter'], 'customers_password' => tep_encrypt_password($onepage['customer']['password']) ); if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $onepage['billing']['gender']; if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = tep_date_raw($onepage['customer']['dob']); tep_db_perform(TABLE_CUSTOMERS, $sql_data_array); ------------------ With ------------------ function createCustomerAccount(){ global $currencies, $customer_id, $onepage, $customer_default_address_id, $customer_first_name, $customer_country_id, $customer_zone_id, $languages_id; $check_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . $onepage['customer']['email_address'] . "'"); $check_p = tep_db_fetch_array($check_query); if ($check_p['total'] < 1) { if ($onepage['createAccount'] === true){ if (!tep_session_is_registered('customer_id')) tep_session_register('customer_id'); if (!tep_session_is_registered('customer_default_address_id')) tep_session_register('customer_default_address_id'); if (!tep_session_is_registered('customer_first_name')) tep_session_register('customer_first_name'); if (!tep_session_is_registered('customer_country_id')) tep_session_register('customer_country_id'); if (!tep_session_is_registered('customer_zone_id')) tep_session_register('customer_zone_id'); $sql_data_array = array( 'customers_firstname' => $onepage['billing']['firstname'], 'customers_lastname' => $onepage['billing']['lastname'], 'customers_email_address' => $onepage['customer']['email_address'], 'customers_telephone' => $onepage['customer']['telephone'], 'customers_fax' => $onepage['customer']['fax'], 'customers_newsletter' => $onepage['customer']['newsletter'], 'customers_password' => tep_encrypt_password($onepage['customer']['password']) ); if (ACCOUNT_GENDER == 'true') $sql_data_array['customers_gender'] = $onepage['billing']['gender']; if (ACCOUNT_DOB == 'true') $sql_data_array['customers_dob'] = tep_date_raw($onepage['customer']['dob']); tep_db_perform(TABLE_CUSTOMERS, $sql_data_array); } --------------------- This will add a simple check to see whether the customer already exists in the customer table and skip adding them if they are. It also resolves the problem of logged in customers telephone numbers not being added to the orders table.
  2. andychev

    One Page Checkout Support

    1.08 is a lot better although still has some major bugs: In 1.07 there were a lot of errors caused by duplicate entries added into the customers table when the order was placed. This is now fixed first time round. However, if you place an order (dont enter a password) then enter another order (with the system already having logged in from the previous one) another customer is entered into the customers table with the same details. Ie causing a duplication of the email address which causes big problems. The second major issue is the storing of session variables for the customer details. Again if multiple orders are placed on after the other it is possible to have the customer details based on session variables from a previous order while the shipping and billing address are correct. These variables are alto used to create the duplicate account as detailed above. One thing that would resolve a lot of problems is a check to see if the email address exists before adding the customer into the customers table and causing duplication. It would also be nice to have telephone as a required field. Bring on 1.09 :)
  3. andychev

    Pwa Email Link In Order Email

    Yes, it is incredably easy as i did it a few weeks back. It is one file you have to edit and just remove one line if you are using the standard text emails. I cant remember which it is off the top of my head i will have a look and post again.
  4. andychev

    stolen credit card shopping through paypal webpayment pro

    What a nightmare, i cant stand people like that who want something for nothing. Unfortunately you need to plan for the worst. There are several things to consider: The first being is that when the credit card companies find out that a card is used fraudulenty (this could be hours, days or weeks away) they will put it on stop and any suspicious transactions over £100 will be investigated. Paypal will flag this up as suspicious and put your paypal account on hold and remove the suspicious funds from your account (putting it into a negative balance if funds arent in there) Fundermentaly as soon as someone reports a card as stolen etc you arent going to have a usable paypal account. I belive the card companies also have the power to place a hold on funds in your bank account (i may be worng on that) You arent going to get the money back, it sucks big time, but unfortunately that is the hard truth the money isnt yours as much as you may think it is even for the goods you have shipped. The most you can hope for is for the police to recover the goods that you shipped (have you noted whether these were shipped to confirmed address's? if so you may be covered under paypals payment protection policy) the chances of them finding what you have shipped are slim to none. You need to bear in mind that YOU are going to be investigated. As the store owever you are expected to take 'reasonable steps' to ensure against card fraud. However, with paypal beig the card processor i dont know how you stand on this. Either way paypals terms & conditions are water tight so even considering trying to blaim them and try and ge something back from them the chances are slim at best. ----------------------------------------------------------------- So, i hear you ask what do i do! If it was me i think i would pull the plug on your website. Even if you are still getting orders in that look to be legit as soon as paypal recognises the fraud on your account they will put your account on hold so you wont be able to accept any more payments or any you do accept they wont let you have. You need to consider that this is going to be a long and drawn out process as there isnt just you and a card processor (like there would be if you had your own card machine) you have paypal in the middle which are notorious for being very slow. The whole thing to get sorted you are looking 6-12 months. When it is 'sorted' the worst (and probably the most likely) outcome is going to be: you loose any money that was given to you fraudulently (30k) you will loose the good you shipped (15k) It will take a long time before you will be able to use your paypal account again, it can sometimes take years. If you still have all the money from the purchases then you will just loose the price of buying the goods you shipped out. However if you have spent the 30k you got in then you will have to repay that plus the price of the goods. You need to take the aproach that your website is no more. stop any advertising that you do and pull the plug on it as this problem isnt going to be resolved quickly. The best you can hope for is to get it back up once you get your paypal account back. If your website is essential to your income then you need to look at alternatives 1 beacause you need ot have an income and 2 because you will be expected to pay back any fraudulent transactions and 3 you have had to pay for the goods you have shipped. I hope what i have written help in some way and you manage to get this sorted as soon as possible. I hope the people who commited the fraud go to ..... Just a thought, perhaps speak to your bank about this. If they are in the 'loop' about what is happening then they will be more likely to help in the future if a loan or whatever is needed. Instead of going along and telling them 6 months down the line. PS, Not trying to make things worse but i belive paypal will charge YOU £20-£30 for each fraudulent transaction on your paypal account. :(
×