30 replies to this topic

[mylo75]

Hello,

I have installed the 4.0a contribution but I still have a question related to the following quotation in your install file (read_me.txt):

"The contribution now adds 5 new rows to the database table 'configuration'. These constants can be seen by searching for the text 'FX_Verification_Email' in the column 'configuration_title'. The dafault values are used and no changes made to the database table 'configuration' until the 'Update' button is pressed in the Admin Panel Customers/Verify Customers - Settings Box."

And I don't see any SQL file to update the 'configuration' table in your 4.0a package.
Maybe I am wrong but it seems this file is missing?

Thanks in advance.

[photofxplus]

mylo75, on May 8 2008, 04:57 AM, said:

And I don't see any SQL file to update the 'configuration' table in your 4.0a package.
Maybe I am wrong but it seems this file is missing?

This seems to be a common question. Most contributions use an sql file to update the database. Versions up to 3.0 did not perform any changes to the database. The necessary variable were hard coded and changed by the user. These variables were set on pages, catalog/admin/customer_verify.php and catalog/create_account.php. I receievd a request to move these variables to the Admin panel - Customers/Customer Verification. This would enable the store owner to change these variables from the Admin panel rather than needing to change the files and re-load. So along came version 4.0, the newer version allows the store owner to administer changes to the contribution from the Admin panel rather than accessing the file code - and thus needs to place these varibles somewhere else for safekeeping. So I did instigate some database changes - and still did it without an sql file for previous version updates version 3 to 4 as well.

This means that you never need an sql file for early versions, and still do not need one for the latest version. The database updates are performed when you click the 'Update' button in the Admin panel under customers/customer verification. Even if you have previously installed version 3.0 or prior - then updated to 4.0, the code will check first time for database updates from previous versions which did not require it. If the database updates have not been added then the new rows will be inserted. There after the new rows are only updated. You can see this on page:

admin/customer_verify.php
Line:131

if ($check['total'] > '0') {
  while (list($key, $value) = each($post_array)) {											
		$update_array = array('configuration_value' => $value);
		tep_db_perform(TABLE_CONFIGURATION, $update_array, 'update', "configuration_key = '" . $key . "'");
	}
// Check if RETURN_URL exists in db - if not - needs to be inserted first time for previous version update				
	$check_query = tep_db_query("select configuration_key from " . TABLE_CONFIGURATION . " where configuration_key = 'RETURN_URL' limit 1");
	
	if (tep_db_num_rows($check_query) < 1) {
	tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, date_added) values ('FX_Verification_Email', 'RETURN_URL', '" . $post_array['RETURN_URL'] . "', now())");
	}
} else {
  while (list($key, $value) = each($post_array)) {											
		tep_db_query("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, date_added) values ('FX_Verification_Email', '" . $key . "', '" . $value . "', now())");
	}
}

As always I appreciate the feedback.
Speaking of which, I received a PM from Patrick van Zuijlen concerning the following,

Quote

understand you would like to hear when someone has a suggestion.

I noticed that if a customer has an account, it is possible that he/she could change their e-mail address to a bogus one.

I think the difficult here is in the situation they must be logged-in to be able to go to their account_edit.php, but your contribution checks to prevent a session so they must use their new password from the e-mail.
Maybe it is possible to delete the session(s) or logg them out, a check for sure and then changing the password and sent the e-mail?
If they are able to refresh the account_edit page after the new password is saved, it is possible to see the new password.

A other option is that the customer cannot change the e-mail address, or maybe the administrator must approve the changed e-mail address.

When thinking about this, maybe the password_forgotten.php page can be used. In addition they put in the old and also the new e-mail address. The password and e-mail address are changed and the 'standard' password-forgotten mail is sent to the customer.
I do see that password_forgotten.php is not able to prevent a session/to be logged in

I am working on this - but I have two other websites that I have to finish first, (I get paid for them) and they are some major projects.
It will be a few weeks yet - but I intend to upload a new version of FX_Email_Verfication in the future.
Any other suggestions or comments concerning a new version would be appreciated.

Please post to this forum.

Edited by photofxplus, 01 June 2008, 11:32.

[Ariffshah]

Dear Lloyd,

Thank you for sharing this wonderful contribution. . At least now we will know who is our genuine customer.

However, after successfully installing your version 4.0a, I tried to register new account and I did not received any email from my store for the password. Hope you can help me how to solve this problem as this contribution will help me to avoid getting credit card fraud customer in near future.

p/s: Emailed sent to gmail account but not to yahoo account.

Best regards.
Ariff

Edited by Ariffshah, 21 February 2009, 17:53.

[Ariffshah]

Dear Lloyd,

is there anyway we as a store owner can check password for our client? One of my customer sign up today and she said that she did not received any email verification for creating the account.

It would be nice if we can resent the password verification or send them the verification link to our customer.

Cheers.

[Ariffshah]

Ariffshah, on Feb 22 2009, 01:44 AM, said:

Dear Lloyd,

Thank you for sharing this wonderful contribution. . At least now we will know who is our genuine customer.

However, after successfully installing your version 4.0a, I tried to register new account and I did not received any email from my store for the password. Hope you can help me how to solve this problem as this contribution will help me to avoid getting credit card fraud customer in near future.

p/s: Emailed sent to gmail account but not to yahoo account.

Best regards.
Ariff

Till to date, more than 30+ new customer register and did not complete the verification. I am worried as all this customer are using yahoo & hotmail email account. Is anyone could help me to solve this as the other solution is to inform the customer to not register using yahoo or hotmail email account.

Thank you in advance.

[rmatcar]

Hi!

I am really interested in this contribution, but I have a old store and I can NOT replace the files, which already exist...

Can anybody write a txt with the steps for a old store, please?

I will be eternally grateful...

Thanks in advance!

Edited by rmatcar, 16 January 2010, 17:27.

[cww66]

HI!
first of all: thanks for this contribution - great job. Since I belong to the group of peolple with quite low php comptence, I hope for some help after looking through the forum without success.

After implenting FX_Email_Verification v4.1 in my oscommerce-2.3.1 most seems to work absolutely fine. Just one problem with the create account page I can not solve. The text I entered in the "catalog/includes/languages/english/create_account_redirect.php" is displayed correctly, but it kind of 'hijacks' the text area/field/table that formerly displayed the terms & Conditions (by contrib MATC_v2.3.4). The same field I use at the checkout process, there everything still works correctly displaying the T&C.

I tried to find any kind of double terms (e.g. identical nomenclature in bothe contribs) as well as careful check of the prior/after file versionss but I seem to be either blind or simply to incompetent to find anything.

Is there anybody out there who experienced the same problem and found a solution?

Thanks for any kind of hint.

ps: other contributions I used so far in this shop are Super_Download_Store_2.3.x (R1), SLiCK reCaptcha 1.0.0 for OSC 2.3.1, osc_qd_1.0.1 and Tax Info

[g2777]

Dear anybody,
I installed this last night as it was better than my original system but I have two issues.

1. In the Verify Customers panel in Admin when I press 'Update' I constantly get the error " The values entered as the account verification date must be seperated by a dash "-"" This is annoying because there is nowhere for me to change the date in the Admin section. I have the 'Account verification start date (yyyy-MM-dd)' in the Settings panel and I assume that there is supposed to be a box to type the date in but not on mine.
[img]http://www.rain-e-daze.co.uk/images/cus_veri_sett.JPG[/img]

As a consequence of this error the script will not update the database. Is this just me? The files in the admin folder where new files, so I didn't have to merge anything, just a straight copy over. The only file I had to mess around with was create_account.php in the root because I already had other things in it.

I have another issue with the e-mail not sending correctly, but I'm assuming it's me and the bad job of merging the file I did.

Any thoughts at all would be welcome.

Regards,
Graham

[g2777]

Nevermind. Took me all night trying to figure out what was wrong and I still couldn't. In the end I just added the info to the db manually and had to put in a text box on the Verify Customers page in Admin so that I could see and change the Verification Date.

Problem with me or a problem with the script? I don't suppose anyone else has had this problem as I don't see anyone saying so.

[YuhnavSingh]

g2777, on 11 September 2011, 13:28, said:

Dear anybody,
I installed this last night as it was better than my original system but I have two issues.

1. In the Verify Customers panel in Admin when I press 'Update' I constantly get the error " The values entered as the account verification date must be seperated by a dash "-"" This is annoying because there is nowhere for me to change the date in the Admin section. I have the 'Account verification start date (yyyy-MM-dd)' in the Settings panel and I assume that there is supposed to be a box to type the date in but not on mine.
[img]http://www.rain-e-daze.co.uk/images/cus_veri_sett.JPG[/img]

As a consequence of this error the script will not update the database. Is this just me? The files in the admin folder where new files, so I didn't have to merge anything, just a straight copy over. The only file I had to mess around with was create_account.php in the root because I already had other things in it.

I have another issue with the e-mail not sending correctly, but I'm assuming it's me and the bad job of merging the file I did.

Any thoughts at all would be welcome.

Regards,
Graham

Hi There

I'm having the exact same problem. I'm not receiving the activation email either. Any help would be greatly appreciated.

[Ohrstinker]

hi there,
this is my first post and i really stuck with this problem @g2777

can you please explain me how do you just validate a user in the admin panel?
i get the same error " The values entered as the account verification date must be seperated by a dash "-"" "
and need this option to activate a user (because we have customers they forget to change there passwort).

I Hope anoyne can help me with this, i would really appreciate it.

and sry for my bad english, its not my native