lrparr

Hi David, This should be a fairly easy edit to the create_account.php file. Also you may want to consider my contribution for account agreement checkbox. This puts a checkbox on the create account page that the customer must check prior to setting up an account. It would be easy to modify the language to read something like, "By checking this box you are verifying that you are 18 years of age or older". Hope that helps.

Ian, try this: Find your code in create_account.php: if (strlen($password) < ENTRY_PASSWORD_MIN_LENGTH) { $error = true; $messageStack->add('create_account', ENTRY_PASSWORD_ERROR); // BOC Added for Account Agreement $agreement = tep_db_prepare_input($HTTP_POST_VARS['agreement']); // EOC Added for Account Agreement } elseif ($password != $confirmation) { $error = true; $messageStack->add('create_account', ENTRY_PASSWORD_ERROR_NOT_MATCHING); } And replace with this: if (strlen($password) < ENTRY_PASSWORD_MIN_LENGTH) { $error = true; $messageStack->add('create_account', ENTRY_PASSWORD_ERROR); } elseif ($password != $confirmation) { $error = true; $messageStack->add('create_account', ENTRY_PASSWORD_ERROR_NOT_MATCHING); } // BOC Added for Account Agreement if (ACCOUNT_AGREEMENT_REQUIRED == 'true') { if ($agreement == false) { $error = true; $messageStack->add('create_account',ENTRY_AGREEMENT_ERROR); } } // EOC Added for Account Agreement That should do the trick.

You mentioned you ran the SQL in the customer database, but did you also run the SQL for the configuration database? This is the SQL that creates the ability to enable/disable the checkbox through the administration panel. Also without this SQL change the code in create_account.php will not recognize that the feature is enabled and will not show up. This is likely the problem. The sql you need to run is: INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) VALUES ('Agreement', 'ACCOUNT_AGREEMENT_REQUIRED', 'true', 'Display agreement checkbox during account creation', '5', '7', 'tep_cfg_select_option(array(\'true\', \'false\'), ', now()); Hope this helps.

I believe those can all be found in catalog/includes/languages/english.php starting at about line 50.

Here is a contribution that will accomplish what Mark mentioned with sending the individual items ordered to Paypal: http://www.oscommerce.com/community/contributions,3376

I just saw this on the contributions page. I have not tested it yet, but apparently this fix may address the issue many of us are seeing with customer orders not being returned to the site after completeing the payment process with PayPal. Please post the results of whether or not this works. http://www.oscommerce.com/community/contributions,3819

anj, I haven't had a chance to modify this yet, but I haven't forgotten about your request. Just an FYI, if you ever do need to verify that the user checked the box you can always go to the actual customer table through your SQL administration program and verify that the field customers_agreement is checked.

Ivo, I have no idea. This is the first time I've heard of this being an issue, and I just retested on my site, and it does require that the box is checked. If you want to send me a copy of your create_account.php code I can take a look at it.

I'm reposting this reply from wilfy as it answers the following half dozen or so posts after it. As you can see from wilfy's post PayPal has changed the way their Auto Return feature works. Bummer!!

The table is in your oscommerce database. The easiest way to edit is using a tool like phpmyadmin, which is usually available in the admin of your hosting company, and run the SQL statement above. Hope that helps.

Yes, BACKUP your store (modified files and databases). Hopefully all the instructions you will need are in the contribution you are adding. I would also strongly recommend keeping track of all mods/contr you install as future contributions may be affected. Good luck.

You are correct, the results do not currently display anywhere. When I created the contrib my assumption was that since the field was required to set up the account, the only value that could be there is "checked". I didn't see any benefit in displaying a value that I already knew. With that said it would not be difficult to create a display on the admin side, so if you still feel you need it let me know and I could help put something together. May take a few days before I get a chance to write the code though.

Sounds like you have already successfully added the field to your table. Are you able to look at your database structure for the customers table to see if the field "customers_agreement" exists?

I found that it slowed down the loading of images on my site as well. I liked the contribution, but the cost in slower page load was not worth the benefits so I have currently disabled it.

Made some minor changes to the code to allow the ability to enable/disable the agreement checkbox from the Admin console. Full package has been posted in the contribution.