Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Mail_Validation


Alex2911

Recommended Posts

Hello,

 

I'm using the latest Mail Validation v2.1a by AlexStudio. It seems to be working partially. The problems I have are:

1. When I click on the link to validate/activate account from the email, it takes me to the pw.php page and here is what I get:

Account validation

 

Your Account is now validated!

 

Error!

 

Unable to determine the page link!

2. While still on pw.php, there are column_right and footer missing.

Any help would be highly appreciated.

 

Thanks in advance.

Link to comment
Share on other sites

  • Replies 92
  • Created
  • Last Reply

Top Posters In This Topic

Hello Allx,

 

I'm using your Mail Validation v2.1a. It seems to be working partially. The problems I have are:

1. When I click on the link to validate/activate account from the email, it takes me to the pw.php page and here is what I get:

Account validation

 

Your Account is now validated!

 

Error!

 

Unable to determine the page link!

2. While still on pw.php, there are column_right and footer missing.

Could you please advise on what might be wrong? Any help would be highly appreciated.

 

Thanks in advance,

Irina.

Would your please post your pw.php and let me see what's going wrong?

Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

 

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

Link to comment
Share on other sites

2. While still on pw.php, there are column_right and footer missing.

Could you please advise on what might be wrong? Any help would be highly appreciated.

 

Thanks in advance,

Irina.

Would your please post your pw.php and let me see what's going wrong?

Thanks for such a fast reply, Alex. Below is my pw.php code unchanged. I'll appreciate your help.

<?php

/*

***************************************

* Mail Validation Ver 2.1 *

* Mar. 05, 2006 *

* *

* Fixed one Bug and added a feature *

* that allow to redirect *

* the User after Logged in *

* to the Page he comes from. *

* *

* Created by Jungwirth Media *

* (http://www.jungwirth-media.at) *

* AKA "John Wood - www.z-is.net", *

* Alex Zach and Alex2911 *

* (German osc Board ;) ) *

* http://www.jungwirth-media.at *

***************************************

Comments and Donations(Paypal) pls to: [email protected]

 

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Released under the GNU General Public License for oscommerce.com

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

*/

 

require('includes/application_top.php');

require(DIR_WS_LANGUAGES . $language . '/pw.php');

$breadcrumb->add(NAVBAR_TITLE, tep_href_link('pw.php'));

?>

<!doctype html public "-//W3C//DTD HTML 4.01 Transitional//EN">

<html <?php echo HTML_PARAMS; ?>>

<head>

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">

<title><?php echo TITLE; ?></title>

<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">

<link rel="stylesheet" type="text/css" href="stylesheet.css">

</head>

<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0">

<!-- header //-->

<?php require(DIR_WS_INCLUDES . 'header.php'); ?>

<!-- header_eof //-->

 

<!-- body //-->

<table border="0" width="100%" cellspacing="3" cellpadding="3">

<tr>

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- left_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_left.php'); ?>

<!-- left_navigation_eof //-->

</table></td>

<!-- body_text //-->

<td width="100%" valign="top"><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="0">

<tr>

<td class="pageHeading"><?php echo HEADIN_TITLE; ?></td>

<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_specials.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>

</tr>

</table></td>

</tr>

<tr>

<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>

</tr>

 

<tr>

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<?php

if (($HTTP_GET_VARS['pass'] != '') && ($HTTP_GET_VARS['cuid'] != '')){

$select = tep_db_query("SELECT * from " . TABLE_CUSTOMERS . " where customers_id = " . (int)$HTTP_GET_VARS['cuid'] . "");

$start = tep_db_fetch_array($select);

if ($start['customers_validation_code'] == $HTTP_GET_VARS['pass']) {

if ($start['customers_validation'] == '1'){

?>

<td class="main">

<?php echo TEXT_YOUR_ACCOUNT_ALREADY_EXIST . '<br>'; ?>

</td>

<?php

}else{

tep_db_query("update " . TABLE_CUSTOMERS . " set customers_validation = '1', customers_email_registered = '" . $start['customers_email_address'] . "' where customers_id = '" . (int)$HTTP_GET_VARS['cuid'] . "'");

 

if (LOGIN_AFTER_VALIDATE == 'true'){

$customer_id = $start['customers_id'];

$customer_default_address_id = $start['customers_default_address_id'];

$customer_first_name = $start['customers_firstname'];

$customer_country_id = $start['entry_country_id'];

$customer_zone_id = $start['entry_zone_id'];

tep_session_register('customer_id');

tep_session_register('customer_default_address_id');

tep_session_register('customer_first_name');

tep_session_register('customer_country_id');

tep_session_register('customer_zone_id');

 

tep_db_query("update " . TABLE_CUSTOMERS_INFO . " set customers_info_date_of_last_logon = now(), customers_info_number_of_logons = customers_info_number_of_logons+1 where customers_info_id = '" . (int)$customer_id . "'");

$cart->restore_contents();

if (isset($HTTP_GET_VARS['woher'])):

$FILENAME_DEFAULT = tep_db_prepare_input($HTTP_GET_VARS['woher'] . '.php');

else:

$FILENAME_DEFAULT = FILENAME_DEFAULT;

endif;

}

?>

<td class="main">

<?php echo TEXT_ACCOUNT_CREATED . '<br>'; ?>

</td>

</tr>

<tr>

<td>

<?php

}

} else {

?>

<td class="main">

<?php

$FILENAME_DEFAULT = FILENAME_DEFAULT;

echo TEXT_ACCOUNT_CREATED_FAIL . '<br>';

?>

</td>

</tr>

<tr>

<td>

<?php

}

} else {

?>

<td class="main">

<?php

$FILENAME_DEFAULT = FILENAME_DEFAULT;

echo TEXT_ACCOUNT_CREATED_FAIL2 . '<br>';

?>

</td>

</tr>

<tr>

<td>

<?php

}

echo tep_draw_separator('pixel_trans.gif', '100%', '10');

?>

</td>

</tr>

<tr>

<tr>

<td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox">

<tr class="infoBoxContents">

<td><table border="0" width="100%" cellspacing="0" cellpadding="2">

<tr>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

<td align="right"><?php echo '<a href="' . tep_href_link($FILENAME_DEFAULT) . '">' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . '</a>'; ?></td>

<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>

</tr>

</table></td>

</tr>

</table></td>

</tr>

 

</tr>

</table></td>

</tr>

 

</table></td>

<!-- body_text_eof //-->

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

</tr>

</table>

<!-- body_eof //-->

<!-- footer //-->

<?php require(DIR_WS_INCLUDES . 'footer.php'); ?>

<!-- footer_eof //-->

<br>

</body>

</html>

<?php require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>

Link to comment
Share on other sites

Alex, you know nothing offending, but I just tried to upload pw.php file from the previous package by TheExterminator and all my problems are gone, no errors, and column_right and footer are both exactly where they suppose to be. Everything works perfectly now.

 

Regards.

Link to comment
Share on other sites

Well, that code by TheExterminator just removed the feature introduced in 2.1 which will lead your customers back to the page where they came from. The page link redirecting after validation is defined in FILENAME_DEFAULT, usually designated as catalog/index.php.

 

The file I uploaded just fixed the bug I found, but there still are other bugs. If you don't need the redirecting feature, you can stay with the one which is working. I'll try again to fix the package I uploaded when I have time.

Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

 

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

Link to comment
Share on other sites

I use a "Guest Account" module in my store, so customers can checkout without actually creating an account. The problem is that when somebody goes through quick checkout without creating account, they are still recorded in admin as not validated users, although they never will be validated because no email was sent to them to validate their account because there is no account created. How can I modify the code so when there is a quick checkout, customers are not listed in admin/Users not validated? Here is the code from my create_account.php with "Mail validation" and "Guest Account" together:

// build the message content

$pw="ABCDEFGHJKMNOPQRSTUVWXYZabcdefghjkmnopqrstuvwxyz0123456789";

srand((double)microtime()*1000000);

for ($i=1;$i<=5;$i++){

$Pass .= $pw{rand(0,strlen($pw)-1)};

}

$pw1="ABCDEFGHJKMNOPQRSTUVWXYZabcdefghjkmnopqrstuvwxyz0123456789";

srand((double)microtime()*1000000);

for ($i=1;$i<=5;$i++){

$Pass_neu .= $pw1{rand(0,strlen($pw1)-1)};

}

$id = $customer_id;

tep_db_query('update customers set customers_validation_code = "' . $Pass . $Pass_neu . '" where customers_id = "' . $id . '"');

 

$name = $firstname . ' ' . $lastname;

 

if (ACCOUNT_GENDER == 'true') {

if ($gender == 'm') {

$email_text = sprintf(EMAIL_NOTICE . EMAIL_GREET_MR, $lastname);

} else {

$email_text = sprintf(EMAIL_NOTICE . EMAIL_GREET_MS, $lastname);

}

} else {

$email_text = sprintf(EMAIL_NOTICE . EMAIL_GREET_NONE, $firstname);

}

 

// Guest Account Start

if ($guest_account == true) {

tep_redirect(tep_href_link(FILENAME_CHECKOUT_SHIPPING, '', 'SSL'));

} else {

if (sizeof($navigation->snapshot) > 0) {

$woher_href = tep_href_link($navigation->snapshot['page'], tep_array_to_string($navigation->snapshot['get'], array(tep_session_name())), $navigation->snapshot['mode']);

$woher_href = explode("?", $woher_href);

$woher_href = explode(".php", $woher_href[0]);

$woher_href = explode("/", $woher_href[0]);

$woher_href = $woher_href[sizeof($woher_href)-1];

$woher_href = '&woher=' . $woher_href;

} else {

$woher_href = '';

}

$email_text .= EMAIL_WELCOME . EMAIL_PASS . EMAIL_USERNAME . EMAIL_PASSWORD . CREATE_ACCOUNT_EMAIL_TEXT . EMAIL_SEPARATOR . EMAIL_WARNING . "\n" . "\n";

if (EMAIL_VALIDATION == 'true'){

$email_text .= "\n" . MAIL_VALIDATION . "\n" . '<a href="' . tep_href_link('pw.php', 'action=reg&pass=' . $Pass . $Pass_neu . '&cuid=' . $id, 'SSL', false) . '">' . VALIDATE_YOUR_MAILADRESS . '</a>' . "\n" . "\n" . SECOND_LINK . ' ' . tep_href_link('pw.php', 'action=reg&pass=' . $Pass . $Pass_neu . '&cuid=' . $id, 'SSL', false) . "\n" . "\n". OR_VALIDATION_CODE . $Pass . $Pass_neu . "\n" . "\n";

}

Any help would be appreciated. Thanks in advance.

Link to comment
Share on other sites

I got it to work by adding c.guest_flag != '1' to the $siu_query_raw in admin/stats_not_valid_users.php. Here is the modified query just in case if anybody else is having the same problem:

<?php

$siu_query_raw = "select * from " . TABLE_CUSTOMERS_INFO . " ci, " . TABLE_CUSTOMERS . " c where c.customers_id = ci.customers_info_id and c.customers_validation = '0' and c.guest_flag != '1' order by c.customers_id";

$siu_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $siu_query_raw, $siu_query_numrows );

$siu_query = tep_db_query($siu_query_raw);

while ($customers = tep_db_fetch_array($siu_query)) {

 

?>

 

Regards.

Link to comment
Share on other sites

  • 2 weeks later...
I've got weird problem.

 

When a customer register.It seem all working.The validation code is sent to email.BUT....FOR those who didnot click the URL.They still can log in...

 

WHY??

 

please check it out at http://www.rezolles.com .Need XPERT help please.

 

 

I am getting the exact same problem....

http://eshop.worldsurfs.com

 

Is there something that I must do to the login.php to ban all unverified users?

Thanks

Link to comment
Share on other sites

  • 2 months later...

Dear,

 

I use mail validation version Full Pack "Danish, English And German"

 

I have a bit problem about edit the file login.php

 

I don't understand about install.txt below

 

**********

* STEP 2 *

**********

 

**ADD** ~line 49--> statement

 

customers_validation,

 

 

**RESULT**

 

$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_validation, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");

 

Please advise and thanks in advance.

Link to comment
Share on other sites

  • 4 weeks later...

Hi All:

 

I got the contrib working and validating accounts - and with SEO URL's installed BUT . . .

 

I get a

 

Parse error: syntax error, unexpected ')' in /home/centcom/public_html/onlinestore/admin/includes/boxes/reports.php on line 31

 

but all I did was put in the simple replace code

 

I do not see an extra ")", and I already tried pulling out all the white space.

 

Here's my reports file

 

Any ideas?

 

Bob

 

<?php

/*

$Id: reports.php,v 1.5 2003/07/09 01:18:53 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

*/

?>

<!-- reports //-->

<tr>

<td>

<?php

$heading = array();

$contents = array();

 

$heading[] = array('text' => BOX_HEADING_REPORTS,

'link' => tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, 'selected_box=reports'));

 

if ($selected_box == 'reports') {

$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_NOT_VALID_USER, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_NOT_VALID_USER . '</a>');

 

'<a href="' . tep_href_link(FILENAME_STATS_CREDITS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_CREDITS . '</a>'

);

}

 

$box = new box;

echo $box->menuBox($heading, $contents);

?>

</td>

</tr>

<!-- reports_eof //-->

Link to comment
Share on other sites

<?php

/*

$Id: reports.php,v 1.5 2003/07/09 01:18:53 hpdl Exp $

 

osCommerce, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Copyright © 2002 osCommerce

 

Released under the GNU General Public License

*/

?>

<!-- reports //-->

<tr>

<td>

<?php

$heading = array();

$contents = array();

 

$heading[] = array('text' => BOX_HEADING_REPORTS,

'link' => tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, 'selected_box=reports'));

 

if ($selected_box == 'reports') {

$contents[] = array('text' => '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a><br>' .

'<a href="' . tep_href_link(FILENAME_STATS_NOT_VALID_USER, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_NOT_VALID_USER . '</a>');

 

'<a href="' . tep_href_link(FILENAME_STATS_CREDITS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_CREDITS . '</a>'

);

}

 

$box = new box;

echo $box->menuBox($heading, $contents);

?>

</td>

</tr>

<!-- reports_eof //-->

Replace the red text with <br>' .

<?php
/*
 $Id: reports.php,v 1.5 2003/07/09 01:18:53 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 http://www.oscommerce.com

 Copyright (c) 2002 osCommerce

 Released under the GNU General Public License
*/
?>
<!-- reports //-->
	  <tr>
		<td>
<?php
 $heading = array();
 $contents = array();

 $heading[] = array('text'  => BOX_HEADING_REPORTS,
				 'link'  => tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, 'selected_box=reports'));

 if ($selected_box == 'reports') {
$contents[] = array('text'  => '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_VIEWED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_VIEWED . '</a><br>' .
							   '<a href="' . tep_href_link(FILENAME_STATS_PRODUCTS_PURCHASED, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_PRODUCTS_PURCHASED . '</a><br>' .
							  '<a href="' . tep_href_link(FILENAME_STATS_CUSTOMERS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_ORDERS_TOTAL . '</a><br>' .
						  '<a href="' . tep_href_link(FILENAME_STATS_NOT_VALID_USER, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_NOT_VALID_USER . '</a><br>' .
							   '<a href="' . tep_href_link(FILENAME_STATS_CREDITS, '', 'NONSSL') . '" class="menuBoxContentLink">' . BOX_REPORTS_CREDITS . '</a>'
							   );
 }

 $box = new box;
 echo $box->menuBox($heading, $contents);
?>
		</td>
	  </tr>
<!-- reports_eof //-->

Edited by AlexStudio

Super Download Shop, PayPal Express Checkout IPN, Selling Downloads, Visual Validation (preventing robotic flood), phpBB2 Integration

 

Yes, I'm willing to help, but please ask in the right place. Think twice before trying to PM me, it might be ignored.

Link to comment
Share on other sites

  • 1 month later...

Is this for a old version?

 

**********

* STEP 2 *

**********

 

Add to the line 49 following statement: customers_validation,

 

result:

$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_validation, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");

 

 

I can't find customers_validation anywhere

Link to comment
Share on other sites

  • 2 weeks later...

Hi there,

 

I installed the latest version of the mail validation,

when i try to register i get a email with welcome to (myshowname)

but not a email with a validation code or link.

 

Anybody has any idea what the problem can be?

Link to comment
Share on other sites

i believe i all ready found the problem

 

FIND THIS:

 

// build the message content

$name = $firstname . ' ' . $lastname;

 

if (ACCOUNT_GENDER == 'true') {

if ($gender == 'm') {

$email_text = sprintf(EMAIL_GREET_MR, $lastname);

} else {

$email_text = sprintf(EMAIL_GREET_MS, $lastname);

}

} else {

$email_text = sprintf(EMAIL_GREET_NONE, $firstname);

}

 

$email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;

 

REPLACE WITH:

 

// build the message content

 

$pw="ABCDEFGHJKMNOPQRSTUVWXYZabcdefghjkmnopqrstuvwxyz0123456789";

srand((double)microtime()*1000000);

for ($i=1;$i<=5;$i++){

$Pass .= $pw{rand(0,strlen($pw)-1)};

}

$pw1="ABCDEFGHJKMNOPQRSTUVWXYZabcdefghjkmnopqrstuvwxyz0123456789";

srand((double)microtime()*1000000);

for ($i=1;$i<=5;$i++){

$Pass_neu .= $pw1{rand(0,strlen($pw1)-1)};

}

$id = $customer_id;

tep_db_query('update customers set customers_validation_code = "' . $Pass . $Pass_neu . '" where customers_id = "' . $id . '"');

 

$name = $firstname . ' ' . $lastname;

 

if (ACCOUNT_GENDER == 'true') {

if ($gender == 'm') {

$email_text = sprintf(EMAIL_GREET_MR, $lastname);

} else {

$email_text = sprintf(EMAIL_GREET_MS, $lastname);

}

} else {

$email_text = sprintf(EMAIL_GREET_NONE, $firstname);

}

 

 

 

search for:

$email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING . "\n" . "\n";

 

Before insert:

 

if (sizeof($navigation->snapshot) > 0) {

$woher_href = tep_href_link($navigation->snapshot['page'], tep_array_to_string($navigation->snapshot['get'], array(tep_session_name())), $navigation->snapshot['mode']);

$woher_href = explode("?", $woher_href);

$woher_href = explode(".php", $woher_href[0]);

$woher_href = explode("/", $woher_href[0]);

$woher_href = $woher_href[sizeof($woher_href)-1];

$woher_href = '&woher=' . $woher_href;

} else {

$woher_href = '';

}

 

 

 

$email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING . "\n" . "\n";

$email_text .= "\n" . MAIL_VALIDATION . "\n" . '<a href="' . tep_href_link('pw.php', 'action=reg&pass=' . $Pass . $Pass_neu . '&cuid=' . $id . $woher_href, 'SSL', false) . '">' . VALIDATE_YOUR_MAILADRESS . '</a>' . "\n" . "\n" . '(' . SECOND_LINK . ' ' . tep_href_link('pw.php', 'action=reg&pass=' . $Pass . $Pass_neu . '&cuid=' . $id . $woher_href, 'SSL', false) . ' )' . "\n" . "\n". OR_VALIDATION_CODE . $Pass . $Pass_neu . "\n" . "\n";

 

this line was missing in my files

 

Now i'm going to translate it al to the dutch language, en perhaps change some layout of the e-mail!

Link to comment
Share on other sites

  • 1 month later...

Hy everyone,

 

I'm installing, re-installing but still looking for the error for 1,5 week in Mail Validation Contribution in my site.

I installed 'only' the Full Pack "Danish, English And German" of Mail Validation, nothing else from 'Mail_Validation' Contributions.

 

There isn't any error till the new customer comes to the point where he has to confirm his registration with the validation key in the site.

He gets the email with the validation code then he types in the Email address then the Validation key on my site and clicks the Continue Button. But when he clicks it jumps to the 'catalog/pw.php?cuid=13&pass=' (in this case) which is a complete blank page except of the 'application top' - but no text, no confirmation success, nothing. Even no 'application bottom'.

This also happens when the new customer clicks the link which is linked in the validation key - email.

And when the customer clicks on the 'Request a new Validation-key here' link, no mail is sent and the blank page comes out again.

 

I use phpMyAdmin - 2.9.2, MySQL client version: 5.0.32, Server version: 5.0.27

 

Please help me cause I'm getting mad... :'(

 

Thanx and looking forward to anyone's helping answer

 

T-bor

Link to comment
Share on other sites

  • 3 months later...

Can anyone tell me if they have this contribution working with osCommerce Merchant RC1 Release?

 

I have started the install but the catalog\admin\index.php file in RC1 must have been changed from the previous version as I cannot find the edits that need to be changed manually.

 

ie I am supposed to be able to find

array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')))),

 

and replace it with

array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')),

 

array('title' => BOX_REPORTS_NOT_VALID_USER, 'link' => tep_href_link(FILENAME_STATS_NOT_VALID_USER, 'selected_box=reports')))),

 

however I cannot find that statement in the file.

 

any help will be appreciated.

 

Cheers all

Link to comment
Share on other sites

  • 5 months later...
  • 1 month later...
  • 4 weeks later...

HELP!!! there are some things that doesn´t appear!!!

 

***********************************************************************

* [catalog]/admin/index.php ~ 1 STEP *

***********************************************************************

 

**********

* STEP 1 *

**********

 

FIND:

 

array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')))),

 

REPLACE WITH:

 

array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')),

 

array('title' => BOX_REPORTS_NOT_VALID_USER, 'link' => tep_href_link(FILENAME_STATS_NOT_VALID_USER, 'selected_box=reports')))),

 

 

array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')))), doesn´t exist!!!!!

 

Or here:

 

*****************************************

* [catalog]/create_account.php ~ 1 STEP *

*****************************************

 

**********

* STEP 1 *

**********

 

FIND THIS:

 

// build the message content

$name = $firstname . ' ' . $lastname;

 

if (ACCOUNT_GENDER == 'true') {

if ($gender == 'm') {

$email_text = sprintf(EMAIL_GREET_MR, $lastname);

} else {

$email_text = sprintf(EMAIL_GREET_MS, $lastname);

}

} else {

$email_text = sprintf(EMAIL_GREET_NONE, $firstname);

}

 

$email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;

 

REPLACE WITH:

 

// build the message content

 

$pw="ABCDEFGHJKMNOPQRSTUVWXYZabcdefghjkmnopqrstuvwxyz0123456789";

srand((double)microtime()*1000000);

for ($i=1;$i<=5;$i++){

$Pass .= $pw{rand(0,strlen($pw)-1)};

}

$pw1="ABCDEFGHJKMNOPQRSTUVWXYZabcdefghjkmnopqrstuvwxyz0123456789";

srand((double)microtime()*1000000);

for ($i=1;$i<=5;$i++){

$Pass_neu .= $pw1{rand(0,strlen($pw1)-1)};

}

$id = $customer_id;

tep_db_query('update customers set customers_validation_code = "' . $Pass . $Pass_neu . '" where customers_id = "' . $id . '"');

 

$name = $firstname . ' ' . $lastname;

 

if (ACCOUNT_GENDER == 'true') {

if ($gender == 'm') {

$email_text = sprintf(EMAIL_GREET_MR, $lastname);

} else {

$email_text = sprintf(EMAIL_GREET_MS, $lastname);

}

} else {

$email_text = sprintf(EMAIL_GREET_NONE, $firstname);

}

 

 

 

search for:

$email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING . "\n" . "\n";

 

Before insert:

 

if (sizeof($navigation->snapshot) > 0) {

$woher_href = tep_href_link($navigation->snapshot['page'], tep_array_to_string($navigation->snapshot['get'], array(tep_session_name())), $navigation->snapshot['mode']);

$woher_href = explode("?", $woher_href);

$woher_href = explode(".php", $woher_href[0]);

$woher_href = explode("/", $woher_href[0]);

$woher_href = $woher_href[sizeof($woher_href)-1];

$woher_href = '&woher=' . $woher_href;

} else {

$woher_href = '';

}

 

 

 

$email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING . "\n" . "\n";

$email_text .= "\n" . MAIL_VALIDATION . "\n" . '<a href="' . tep_href_link('pw.php', 'action=reg&pass=' . $Pass . $Pass_neu . '&cuid=' . $id . $woher_href, 'SSL', false) . '">' . VALIDATE_YOUR_MAILADRESS . '</a>' . "\n" . "\n" . '(' . SECOND_LINK . ' ' . tep_href_link('pw.php', 'action=reg&pass=' . $Pass . $Pass_neu . '&cuid=' . $id . $woher_href, 'SSL', false) . ' )' . "\n" . "\n". OR_VALIDATION_CODE . $Pass . $Pass_neu . "\n" . "\n";

 

Here is the error:

It says:

 

 

***********************************************************************

* [catalog]/admin/index.php ~ 1 STEP *

***********************************************************************

 

**********

* STEP 1 *

**********

 

FIND:

 

array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')))),

 

REPLACE WITH:

 

array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')),

 

array('title' => BOX_REPORTS_NOT_VALID_USER, 'link' => tep_href_link(FILENAME_STATS_NOT_VALID_USER, 'selected_box=reports')))),

 

 

array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports')))), doesn´t exist!!!!!

 

Or here:

 

*****************************************

* [catalog]/create_account.php ~ 1 STEP *

*****************************************

 

**********

* STEP 1 *

**********

 

FIND THIS:

 

// build the message content

$name = $firstname . ' ' . $lastname;

 

if (ACCOUNT_GENDER == 'true') {

if ($gender == 'm') {

$email_text = sprintf(EMAIL_GREET_MR, $lastname);

} else {

$email_text = sprintf(EMAIL_GREET_MS, $lastname);

}

} else {

$email_text = sprintf(EMAIL_GREET_NONE, $firstname);

}

 

$email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;

 

REPLACE WITH:

 

// build the message content

 

$pw="ABCDEFGHJKMNOPQRSTUVWXYZabcdefghjkmnopqrstuvwxyz0123456789";

srand((double)microtime()*1000000);

for ($i=1;$i<=5;$i++){

$Pass .= $pw{rand(0,strlen($pw)-1)};

}

$pw1="ABCDEFGHJKMNOPQRSTUVWXYZabcdefghjkmnopq... ... ... and so on...

 

and then

 

search for:

$email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING . "\n" . "\n";

Before insert:

...

 

 

It isnt possible to find because it has been replaced before!!!!

 

-----------------------------------------------------------------

 

Plz need help!!! I need this script working!!!

Link to comment
Share on other sites

Ive implemented the script without problems into my ver 2.2 RC 2a...

 

regarding following steps:

 

$email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING;

and

$email_text .= EMAIL_WELCOME . EMAIL_TEXT . EMAIL_CONTACT . EMAIL_WARNING . "\n" . "\n"; etc...

 

DO NOT delete the 1st sentence, but replace it in the following step... so its a slight error in the readme file...

 

 

 

regarding:

array('title' => REPORTS_ORDERS, 'link' => tep_href_link(FILENAME_STATS_CUSTOMERS, 'selected_box=reports'))));

 

you are right, it does not exist, looking for reports_orders or filename_stats_customers with a full-text-search-engine tells me it doesn't exist in ANY of the original files, so I just ignored it...

 

AND IT WORKS FINE!

 

do everything else as told, (also updating the SQL DB was without errors) and activate the mod in the admin panel...

 

It works flawlessly... added new customer, couldn't login without activation, activated it, and logged in...

Link to comment
Share on other sites

  • 4 months later...

Here is the English translation for MySQL Entry which was previously missing from the install.txt file.

 

ENGLISH:

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
VALUES ('', 'Email Validation required to Activate Account', 'EMAIL_VALIDATION', 'false', 'Is the customer required to validate their email address to activate the account?', '1', '22', '2006-05-30 00:02:20', '2006-05-30 00:02:20', NULL , 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
VALUES ('', 'Auto-Login after successful Email Validation', 'LOGIN_AFTER_VALIDATE', 'false', 'Are customers to be automatically logged in after the email validation?', '1', '23', '2006-05-30 00:02:20', '2006-05-30 00:02:20', NULL , 'tep_cfg_select_option(array(''true'', ''false''),');

 

Also, the minor change in the following MySQL Entry (configuration_group_id = 12) will add the email validation options to 'Configuration/E-Mail Options' menu instead of on the main Configuration screen:

INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
VALUES ('', 'Email Validation required to Activate Account', 'EMAIL_VALIDATION', 'false', 'Is the customer required to validate their email address to activate the account?', '12', '22', '2006-05-30 00:02:20', '2006-05-30 00:02:20', NULL , 'tep_cfg_select_option(array(''true'', ''false''),');
INSERT INTO `configuration` ( `configuration_id` , `configuration_title` , `configuration_key` , `configuration_value` , `configuration_description` , `configuration_group_id` , `sort_order` , `last_modified` , `date_added` , `use_function` , `set_function` )
VALUES ('', 'Auto-Login after successful Email Validation', 'LOGIN_AFTER_VALIDATE', 'false', 'Are customers to be automatically logged in after the email validation?', '12', '23', '2006-05-30 00:02:20', '2006-05-30 00:02:20', NULL , 'tep_cfg_select_option(array(''true'', ''false''),');

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...