Irin Posted October 27, 2006 Share Posted October 27, 2006 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. Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 27, 2006 Share Posted October 27, 2006 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? Quote 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 More sharing options...
Irin Posted October 27, 2006 Share Posted October 27, 2006 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'); ?> Quote Link to comment Share on other sites More sharing options...
Irin Posted October 27, 2006 Share Posted October 27, 2006 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. Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted October 29, 2006 Share Posted October 29, 2006 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. Quote 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 More sharing options...
Irin Posted November 3, 2006 Share Posted November 3, 2006 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. Quote Link to comment Share on other sites More sharing options...
Irin Posted November 4, 2006 Share Posted November 4, 2006 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. Quote Link to comment Share on other sites More sharing options...
galacnet Posted November 16, 2006 Share Posted November 16, 2006 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 Quote Link to comment Share on other sites More sharing options...
kthawat Posted January 25, 2007 Share Posted January 25, 2007 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. Quote Link to comment Share on other sites More sharing options...
katia Posted January 29, 2007 Share Posted January 29, 2007 Does it work for os commerce 3? Quote Link to comment Share on other sites More sharing options...
Guest Posted February 27, 2007 Share Posted February 27, 2007 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 //--> Quote Link to comment Share on other sites More sharing options...
AlexStudio Posted February 27, 2007 Share Posted February 27, 2007 (edited) <?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 February 27, 2007 by AlexStudio Quote 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 More sharing options...
Guest Posted February 27, 2007 Share Posted February 27, 2007 Thanks AlexStudio It works now Bob Quote Link to comment Share on other sites More sharing options...
yayak Posted April 10, 2007 Share Posted April 10, 2007 is there any 'expiration' feature? u know, it's like when the user has registered himself but doesn't activate it within a few days, than the account is expired, thus he has to make a new account Quote Link to comment Share on other sites More sharing options...
stefan1959 Posted April 12, 2007 Share Posted April 12, 2007 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 Quote Link to comment Share on other sites More sharing options...
tha steef Posted April 20, 2007 Share Posted April 20, 2007 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? Quote Link to comment Share on other sites More sharing options...
tha steef Posted April 20, 2007 Share Posted April 20, 2007 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! Quote Link to comment Share on other sites More sharing options...
robguay Posted April 23, 2007 Share Posted April 23, 2007 The store is now emailing out the code and link to the customer however, the validation will not update the database. Please help! Thanks :wacko: Quote Link to comment Share on other sites More sharing options...
T-bor Posted May 25, 2007 Share Posted May 25, 2007 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 Quote Link to comment Share on other sites More sharing options...
Robev Posted September 2, 2007 Share Posted September 2, 2007 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 Quote Link to comment Share on other sites More sharing options...
Lab5 Posted February 23, 2008 Share Posted February 23, 2008 cannot find it either .... maybe it isn't too omportant , since i simply will disregard it ... greez, 505 Quote Link to comment Share on other sites More sharing options...
sychosyd_28 Posted March 25, 2008 Share Posted March 25, 2008 (edited) Does anybody know why any items inside the visitor cart disappear after following the account validation link in the email and successfully activating the account? Edited March 25, 2008 by sychosyd_28 Quote Link to comment Share on other sites More sharing options...
rhp07 Posted April 23, 2008 Share Posted April 23, 2008 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!!! Quote Link to comment Share on other sites More sharing options...
gulshesh Posted April 30, 2008 Share Posted April 30, 2008 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... Quote Link to comment Share on other sites More sharing options...
Guest Posted September 25, 2008 Share Posted September 25, 2008 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''),'); Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.