Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Purchase Without Account Updated & Admin Functionality


Guest

Recommended Posts

I have new problems. Unless they're actually bugs in the programming. I had enabled the customer to print their invoice from a javascript popup window but it only works for customers who signed up now, not PWAs. For PWAs it pops up the window with my website's login page without the toolbars. Is there any way to fix it so that they can still print their invoice since the order DOES in fact exist? After all, it's the customer that doesn't exist, not the order. Every customer should be able to print their invoice, not just the ones that created an account. I used the osC-PrintOrder with Store Logo v1.0 contribution for this feature by the way.

 

 

Also when a PWA customer clicks continue on the confirmation screen, they get taken to an empty shopping cart instead of the main page of my store. Actual signed up customers are taken to the index page as intended. Not sure what's going on there either.

Link to comment
Share on other sites

  • 3 weeks later...

Hi everybody, first post. I am trying to set up my first store and have installed as third contrib this one, PWA. Very good! Thanks to all for sharing that!

 

However I'd like to streamline the whole process of checking out even more, to follow these steps

1. put something in cart

2. Click: Checkout

3. fill in personal info OR login (one page)

Click: Proceed ...

 

So what I need is to get a login box on the order_info page.

Since I have practically no knowledge of PHP yet I wonder if anybody has done this and could share a little tip to get me started.

 

What I have done is trying to strip the login.php of all html except the actual login box and include the rest into order-info php but without success so far. Am I even on the right track with that approach?

 

Thanks for any help and sorry if this has been dealt with in some thread here, I haven't found anything yet.

Link to comment
Share on other sites

Hi everybody, first post. I am trying to set up my first store and have installed as third contrib this one, PWA. Very good! Thanks to all for sharing that!

 

However I'd like to streamline the whole process of checking out even more, to follow these steps

1.  put something in cart

2. Click: Checkout

3. fill in personal info OR login (one page)

Click: Proceed ...

 

So what I need is to get a login box on the order_info page.

Since I have practically no knowledge of PHP yet I wonder if anybody has done this and could share a little tip to get me started.

 

What I have done is trying to strip the login.php of all html except the actual login box and include the rest into order-info php but without success so far. Am I even on the right track with that approach?

 

Thanks for any help and sorry if this has been dealt with in some thread here, I haven't found anything yet.

 

 

If you get that successully and cleanly done, let me know because I would also like to do that.

Link to comment
Share on other sites

If you get that successully and cleanly done, let me know because I would also like to do that.

 

Well I have added the functionality of the original osc login.php to the PWA order_info.php and that seems to work.

I now have two areas displayed on the order_info page, one a loginbox (minus the welcome message, little pic and visitors cart note), the other the regular table to fill out for new customers. Both upon submit lead to checkout_shipping and transport the cart contents.

The redirect in checkout_shipping is changed to order_info.php, so that any click on "checkout" directly brings the customer to the new order_info page.

 

I'm going to have to test this now.

Link to comment
Share on other sites

Hi everybody, first post. I am trying to set up my first store and have installed as third contrib this one, PWA. Very good! Thanks to all for sharing that!

 

However I'd like to streamline the whole process of checking out even more, to follow these steps

1.  put something in cart

2. Click: Checkout

3. fill in personal info OR login (one page)

Click: Proceed ...

 

So what I need is to get a login box on the order_info page.

Since I have practically no knowledge of PHP yet I wonder if anybody has done this and could share a little tip to get me started.

 

What I have done is trying to strip the login.php of all html except the actual login box and include the rest into order-info php but without success so far. Am I even on the right track with that approach?

 

Thanks for any help and sorry if this has been dealt with in some thread here, I haven't found anything yet.

 

 

 

i have in checkout_shipping :

 

// if the customer is not logged on, redirect them to the login page

if (!tep_session_is_registered('customer_id')) {

 

$navigation->set_snapshot();

 

if ((PWA_ON == 'true') and ($cart->count_contents() > 0)) {

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

} else {

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

}

}

Treasurer MFC

Link to comment
Share on other sites

Hello, i'm fairly new to os, let along php, lol.

 

I just got done installing this contribution PWA

 

After i got done filling in all info (name, etc...) click checkout,

 

i got this error?

 

1054 - Unknown column 'purchased_without_account' in 'field list'

 

 

 

any help would be much appreciated!

 

thanks

mike

Link to comment
Share on other sites

you need to use phpmyadmin or mysql cvonnector to add the database addition to the file.

 

perhaps the best ting to do is search the internet for phpmyadmin tutorial to learn how to use it, then you will be able to go back to the contribution and know exactly what to do

Link to comment
Share on other sites

There are several things that could be wrong. First off, the install instructions have a few problems, especially for a novice. That installation step for admin/orders.php needs to be cleaned up a lot. The way it is, part of the code is actually commented out. Id download a free copy of Crimson Editor, which color codes all php tags and makes everything really easy. Anywy, try looking at this file and fixing it. Then id manually look at your DB and make sure the column exists.

Link to comment
Share on other sites

OK...that don't sound fun! I'm not sure what i'm looking for in the order.php.

 

I wanted everything to work, then i was going to take out the create account and login, so PWA is the only option.

 

I guess thats what ya call hiding,lol.

Link to comment
Share on other sites

Ok,

 

Id go through all steps and make sure no

 is included. Also, make sure you go through the install instructions manually, as just copying the new files over yours will miss some changes. For the admin/orders.php step, you must remove the [COde] and fix it even more. Take the code after the first comment and move it to a new line. Look for all semicolons. Place the code after each on a new line. This is true for the code you are trying to replace in the instructions, too. It is placed all on one line, when in actuality it is several lines of code you will be removing. Id try to get this working As-IS, then try to mod it to your liking. Other than that, i cant really offer any help.
Link to comment
Share on other sites

This is exaclty what it shows. What going on with the UPPER?

 

 

1054 - Unknown column 'purchased_without_account' in 'field list'

 

select customers_id, purchased_without_account, customers_firstname, customers_password, customers_email_address, customers_default_address_id from customers where upper(customers_email_address) = '[email protected]' and upper(customers_firstname) = 'HHHHH' and upper(customers_lastname) = 'HHHHH'

 

[TEP STOP]

Link to comment
Share on other sites

i got it too work! I must have had something wrong with the:-----

// start pwa changes

 

Looked thru the 30 pages and copy pasted a code, must have been the problem?

It works now, lol. yahoo...only took all day! lol

 

thanks for replies

mike

Edited by bigbuck
Link to comment
Share on other sites

i have in checkout_shipping :

 

// if the customer is not logged on, redirect them to the login page

  if (!tep_session_is_registered('customer_id')) {

 

    $navigation->set_snapshot();

 

    if ((PWA_ON == 'true') and ($cart->count_contents() > 0)) {

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

    } else {

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

    }

  }

 

Hello Amanda,

thanks for your reply! I have to admit I'm a bit puzzled by that piece of code. At the site in your profile visitors when hitting Checkout get redirected to order_info if they are not logged in which is fine and just what I do. The code above to this php illiterate seems to say that visitors get redirected to login.php, which is stamdard PWA behaviour?

 

In any case it looks like I have achieved my goal for now.

 

- Visitors who are logged in and hit Checkout:

1. go to checkout-shipment directly

 

- Visitors who are NOT logged in and hit Checkout:

1. get redirected to Order_info.php

fill in personal info form OR

login on the same page

2. go to checkout-shipment.

 

If anybody is interested I'd share my hacked order_info.php.

Link to comment
Share on other sites

In any case it looks like I have achieved my goal for now.

 

- Visitors who are logged in and hit Checkout:

1. go to checkout-shipment directly

 

- Visitors who are NOT logged in and hit Checkout:

1. get redirected to Order_info.php

  fill in personal info form OR

  login on the same page

2. go to checkout-shipment.

 

If anybody is interested I'd share my hacked order_info.php.

 

I would like to see the actual page of your website and the code as well.

Link to comment
Share on other sites

I would like to see the actual page of your website and the code as well.

my store is not in a state that I want to give out the address so here's a screenshot

screenshot_order_info.jpg. It needs of course some formatting and styling.

 

The code of the order_info.php:

<?php
/*
?$Id: Order_Info.php,v 0.52 2002/09/21 hpdl Exp $
? ? ? ?by Cheng

? ? ? ?OSCommerce v2.2 CVS (09/17/02)

? Modified versions of create_account.php and related
?files. ?Allowing 'purchase without account'.

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

?Copyright (c) 2002 osCommerce

?Released under the GNU General Public License
*/

?require('includes/application_top.php');


// Begin added php stuff from original OSC login php ?
?
?// redirect the customer to a friendly cookie-must-be-enabled page if cookies are disabled (or the session has not started)
? ?if ($session_started == false) {
? ? ?tep_redirect(tep_href_link(FILENAME_COOKIE_USAGE));
? ?}
?
? ?require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_LOGIN);
?
? ?$error = false;
? ?if (isset($HTTP_GET_VARS['action']) && ($HTTP_GET_VARS['action'] == 'process')) {
? ? ?$email_address = tep_db_prepare_input($HTTP_POST_VARS['email_address']);
? ? ?$password = tep_db_prepare_input($HTTP_POST_VARS['password']);
?
?// Check if email exists
? ? ?$check_customer_query = tep_db_query("select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'");
? ? ?if (!tep_db_num_rows($check_customer_query)) {
? ? ? ?$error = true;
? ? ?} else {
? ? ? ?$check_customer = tep_db_fetch_array($check_customer_query);
?// Check that password is good
? ? ? ?if (!tep_validate_password($password, $check_customer['customers_password'])) {
? ? ? ? ?$error = true;
? ? ? ?} else {
? ? ? ? ?if (SESSION_RECREATE == 'True') {
? ? ? ? ? ?tep_session_recreate();
? ? ? ? ?}
?
? ? ? ? ?$check_country_query = tep_db_query("select entry_country_id, entry_zone_id from " . TABLE_ADDRESS_BOOK . " where customers_id = '" . (int)$check_customer['customers_id'] . "' and address_book_id = '" . (int)$check_customer['customers_default_address_id'] . "'");
? ? ? ? ?$check_country = tep_db_fetch_array($check_country_query);
?
? ? ? ? ?$customer_id = $check_customer['customers_id'];
? ? ? ? ?$customer_default_address_id = $check_customer['customers_default_address_id'];
? ? ? ? ?$customer_first_name = $check_customer['customers_firstname'];
? ? ? ? ?$customer_country_id = $check_country['entry_country_id'];
? ? ? ? ?$customer_zone_id = $check_country['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 . "'");
?
?// restore cart contents
? ? ? ? ?$cart->restore_contents();
?
? ? ? ? ?if (sizeof($navigation->snapshot) > 0) {
? ? ? ? ? ?$origin_href = tep_href_link($navigation->snapshot['page'], tep_array_to_string($navigation->snapshot['get'], array(tep_session_name())), $navigation->snapshot['mode']);
? ? ? ? ? ?$navigation->clear_snapshot();
? ? ? ? ? ?tep_redirect($origin_href);
? ? ? ? ?} else {
? ? ? ? ? ?tep_redirect(tep_href_link(FILENAME_DEFAULT));
? ? ? ? ?}
? ? ? ?}
? ? ?}
? ?}
?
? ?if ($error == true) {
? ? ?$messageStack->add('login', TEXT_LOGIN_ERROR);
? ?}
?
?
// End of included php stuff

?require(DIR_WS_LANGUAGES . $language . '/' . FILENAME_CREATE_ACCOUNT);

?$breadcrumb->add(NAV_ORDER_INFO, tep_href_link('Order_Info.php', '', 'SSL'));
?>
<!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 (getenv('HTTPS') == 'on' ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<?php require('includes/form_check.js.php'); ?>

</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">
? ?
<!-- A T T E N T I O N ?Start login form table--> ? ?
? ?<?php echo tep_draw_form('login', tep_href_link(FILENAME_LOGIN, 'action=process', 'SSL')); ?><table border="0" width="100%" cellspacing="0" cellpadding="0">
<!--Cut out welcome table with little pic--> ? ? ? ? ?
? ? ? ? ?<tr>
? ? ? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ?</tr>
? ?<?php
? ? ?if ($messageStack->size('login') > 0) {
? ??>
? ? ? ? ?<tr>
? ? ? ? ? ?<td><?php echo $messageStack->output('login'); ?></td>
? ? ? ? ?</tr>
? ? ? ? ?<tr>
? ? ? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ?</tr>
<!--Cut out Visitor Cart Note-->

? ?<?php
? ? ?}
? ??>
? ? ? ? ?<tr>
? ? ? ? ? ?<td><table border="1" bordercolor="red" width="100%" cellspacing="0" cellpadding="2">
? ? ? ? ? ? ?<tr>
<!--cut out new customer 1. cell--> ? ? ? ? ? ? ? 
? ? ? ? ? ? ? ?<td class="main" width="50%" valign="top"><b><?php echo HEADING_RETURNING_CUSTOMER_LOGINBOX; ?></b></td>
? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ?<tr>
?<!--cut out new customer 2. cell--> ? ? ? ? ? ? ? 
? ? ? ? ? ? ? ?<td width="50%" height="100%" valign="top"><table border="0" width="100%" height="100%" cellspacing="1" cellpadding="2" class="infoBox">
? ? ? ? ? ? ? ? ?<tr class="infoBoxContents">
? ? ? ? ? ? ? ? ? ?<td><table border="0" width="100%" height="100%" cellspacing="0" cellpadding="2">
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td class="main" colspan="2"><?php echo TEXT_RETURNING_CUSTOMER_LOGINBOX; ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td class="main"><b><?php echo ENTRY_EMAIL_ADDRESS; ?></b></td>
? ? ? ? ? ? ? ? ? ? ? ?<td class="main"><?php echo tep_draw_input_field('email_address'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td class="main"><b><?php echo ENTRY_PASSWORD; ?></b></td>
? ? ? ? ? ? ? ? ? ? ? ?<td class="main"><?php echo tep_draw_password_field('password'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td class="smallText" colspan="2"><?php echo '<a href="' . tep_href_link(FILENAME_PASSWORD_FORGOTTEN, '', 'SSL') . '">' . TEXT_PASSWORD_FORGOTTEN . '</a>'; ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td colspan="2"><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ?<tr>
? ? ? ? ? ? ? ? ? ? ? ?<td colspan="2"><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 tep_image_submit('button_login.gif', IMAGE_BUTTON_LOGIN); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? ? ?<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
? ? ? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ? ? ?</table></td>
? ? ? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ? ? ?</table></td>
? ? ? ? ? ? ? ? ?</tr>
? ? ? ? ? ? ? ?</table></td>
? ? ? ? ? ? ?</tr>
? ? ? ? ? ?</table></td>
? ? ? ? ?</tr>
? ?</table></form>

<!-- A T T E N T I O N End of Login form table-->

? ?</td>
<!-- body_text //-->
? ?<td width="100%" valign="top"><form name="account_edit" method="post" <?php echo 'action="' .
tep_href_link('Order_Info_Process.php', '', 'SSL')
. '"'; ?> onSubmit="return check_form(this);"><input type="hidden" name="action" value="process"><table border="0" width="75%" cellspacing="0" cellpadding="0" align="center">
? ? ?<tr>
? ? ? ?<td><table border="0" width="75%" cellspacing="0" cellpadding="0">
? ? ? ? ?<!--tr>
? ? ? ? ? ?<td class="pageHeading"><?php echo HEADING_TITLE; ?></td>
? ? ? ? ? ?<td class="pageHeading" align="right"><?php echo tep_image(DIR_WS_IMAGES . 'table_background_account.gif', HEADING_TITLE, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT); ?></td>
? ? ? ? ?</tr//-->
? ? ? ?</table></td>
? ? ?</tr>
<?php
?if (sizeof($navigation->snapshot) > 0) {
?>
? ? ?
<!--Cut out: Text_origin_login message for existing account holders--> ? ? ?
? ? ?
<?php
?}
?>
? ? ?<tr>
? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td>
<?php
?$email_address = tep_db_prepare_input($HTTP_GET_VARS['email_address']);
?$account['entry_country_id'] = STORE_COUNTRY;

?require(DIR_WS_MODULES . 'Order_Info_Check.php');
?>
? ? ? ?</td>
? ? ?</tr>
? ? ?<tr>
? ? ? ?<td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td>
? ? ?</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 tep_image_submit('button_continue.gif', IMAGE_BUTTON_CONTINUE); ?></td>
? ? ? ? ? ? ? ?<td width="10"><?php echo tep_draw_separator('pixel_trans.gif', '10', '1'); ?></td>
? ? ? ? ? ? ?</tr>
? ? ? ? ? ?</table></td>
? ? ? ? ?</tr>
? ? ? ?</table></td>
? ? ?</tr>
? ?</table></form></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'); ?>

 

The TEXT_RETURNING_CUSTOMER_LOGINBOX and the HEADING_RETURNING_CUSTOMER_LOGINBOX need to be defined in the includes/languages/english(or whatever languages)login.php

 

The redirect in checkout_shipping.php must be changed to order_info.php.

 

// A T T E N T I O N Please, be aware that I`m not a coder and don't know jack about php, and I mean it! Use at your own risk! And, btw, it would be most wonderful if some of you php buffs could take a look at the code and see if I really managed NOT to mess up anything.

Edited by UK61
Link to comment
Share on other sites

Sorry for this I have gone through the 600 posts here but I have yet to find an answer, even an inkling of an answer to this problem with the PWA when a customer whose email address is in the system tries to buy. Basically a 404 error page is generated instead of the ordinary page when a purchase attempt is made by a customer with an email address in the system. 2 others on this thread have asked and I have not seen any response to that either.

 

It looks like something to do with Search friendly URLs. I need those on, so can someone tell me how to bypass or solve this problem.

error message below.....

 

404 Error

The requested URL /login.php/login/fail/reason/An+account+already+exists+for+the+email+address+

i>[email protected]</i>.

++You+must+login+here+with+the+password+for+that

+account+before+proceeding+to+checkout. was not found on this server.

The best thing about learning is that no-one can take it away from you - B.B.King

Link to comment
Share on other sites

I have another error:

 

1054 - Unknown column 'purchased_without_account' in 'field list'

 

update orders set purchased_without_account = '1' where orders_id = '1'

 

 

What do the 1 and 1 mean

purchased without accont=1 ???

 

I always wondered this!

 

thanks

mike

Link to comment
Share on other sites

I have another error:

 

1054 - Unknown column 'purchased_without_account' in 'field list'

 

update orders set purchased_without_account = '1' where orders_id = '1'

What do the 1  and  1  mean

purchased without accont=1      ???

 

I always wondered this!

 

thanks

mike

Try commenting out this line in catalog/checkout_success.php:

 

tep_db_query("insert into " . TABLE_ORDERS . " (purchased_without_account) values ('1') where orders_id = '" . (int)$orders['orders_id'] . "'");

Link to comment
Share on other sites

First of all sorry if this is slightly off topic:

 

I am confused about installing the PWA module (especially the SQL part) because I have already installed the Master Password MD5 module in the configuration tables.

 

- Do I overwrite those values with the PWA values? If so will the Master Password module still work?

 

- I am also confused about the Master Password installation procedure. Can I confirm that this is what I'm meant to do:

 

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 ('188', 'Master Password', 'MASTER_PASS', MD5('yourpassword'), 'This password will allow you to login to any customers account.', 1, 23, '2004-06-15 07:10:52', '2004-06-15 07:10:52', NULL, NULL);

 

And therefore if I want to login into a customer's account I use their email address and 'yourpassword' (without the apostrophes) as the password?

 

Cheers

 

(edit: And also, the Default value for configuration_value is MD5('yourpassword')? and not something else?)

Edited by dentonio69
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...