Jump to content
Sign in to follow this  
bmcewan

Purchase Without Account Updated & Admin Functionality

Recommended Posts

Stew

 

I can't thank you enough for all your help and all the countless time you've put into this for us!!

 

Made the changes you stated above. I now have the PWA option displaying. However I have one small glitch showing up. In the table displaying PWA above the PWA checkout button this line appears "TEXT_PAYPALWPP_EC_HEADER2" screen cap below.

 

I've found the section of login.php where this is mentioned --

 

<table><tr>
		<td class="infoboxHeading" valign="top"><b><?php echo TEXT_PAYPALWPP_EC_HEADER; ?></b>
		</td></tr>
	  <tr>
		<td width="100%" colspan=2 valign="top" class="main">
		<?php echo TEXT_PAYPALWPP_EC_HEADER2; ?></td></tr>

		<tr>
<td width="100%" colspan=2 valign="top" class="main"><a href="<?php echo tep_href_link('ec_process.php', '', 'SSL'); ?>">
		<img src="https://www.paypal.com/en_US/i/btn/btn_xpressCheckout.gif" border=0></a></td></tr>
		<tr>
		<td width="100%" colspan=2 valign="top" class="main"><?php echo TEXT_PAYPALWPP_EC_BUTTON_TEXT; ?>

		</td>
	</tr></table>

 

But my newbie eyes can't see anything wrong with it. Do you have any ideas how I can fix this part?

 

Many Thanks -- Mindy

 

Snap1.jpg

 

Crikey- that's a language definition thing I never defined. In my site, in includes/languages/english/login.php I have

 

define('TEXT_PAYPALWPP_EC_HEADER2', 'I have a PayPal account!');

 

But you can just change the code in login.php to say "HEADER" instead of "HEADER2" and that will work just fine.


Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Share this post


Link to post
Share on other sites

Thanks so much the above problem is fixed now.

 

Just one more thing when I click on checkout for PWA the browser displays a 404 page not found. This is the file it's looking for --

 

https://www.bandinmyhand.com/store/FILENAME_CHECKOUT?osCsid=3975969e4a6649bd7d400a3f77c035ae

 

I don't see this file in the v0.910 pack or in my install directory. Hitting the boards to search for it or an answer now. But thought I may catch you still on the boards if I asked about it now.

 

Many Thanks -- Mindy

Share this post


Link to post
Share on other sites
Thanks so much the above problem is fixed now.

 

Just one more thing when I click on checkout for PWA the browser displays a 404 page not found. This is the file it's looking for --

 

https://www.bandinmyhand.com/store/FILENAME_CHECKOUT?osCsid=3975969e4a6649bd7d400a3f77c035ae

 

I don't see this file in the v0.910 pack or in my install directory. Hitting the boards to search for it or an answer now. But thought I may catch you still on the boards if I asked about it now.

 

Many Thanks -- Mindy

 

Wow- not a good day for Stew. There is no such file- references to FILENAME_CHECKOUT should not exist.

 

In login.php, change FILENAME_CHECKOUT (around line 300) to FILENAME_ORDER_INFO.

Edited by djmonkey1

Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Share this post


Link to post
Share on other sites
Wow- not a good day for Stew. There is no such file- references to FILENAME_CHECKOUT should not exist.

 

In login.php, change FILENAME_CHECKOUT (around line 300) to FILENAME_ORDER_INFO.

 

You're my HERO!!!

 

All is well and working great! Ran a test sale through and it worked perfectly. I'm so excited now thanks so much. Sorry that I pestered you repeatedly today.

 

Know I'm new to the osC scene but hope it's okay to upload the tweaked login.php file to the contrib section for this. My login.php contains no extra contribs or modificatins just the straight one outta the box with all the tweaks you helped me with today.

 

-- Mindy

Share this post


Link to post
Share on other sites
You're my HERO!!!

 

All is well and working great! Ran a test sale through and it worked perfectly. I'm so excited now thanks so much. Sorry that I pestered you repeatedly today.

 

Know I'm new to the osC scene but hope it's okay to upload the tweaked login.php file to the contrib section for this. My login.php contains no extra contribs or modificatins just the straight one outta the box with all the tweaks you helped me with today.

 

-- Mindy

 

 

That would be great- just be sure to identify it as being for use with PWA and WPP together.


Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Share this post


Link to post
Share on other sites

Released an updated version of Stew's v0.910 for using WPP and PWA together.

 

http://www.oscommerce.com/community/contributions,355

 

Contains the same version and files v0.910 for combined use of WPP and PWA together as released by djmonkey1 on 11-06-2005. With added tweaks to the extras/wpp/catalog/login.php file to make them work seamlessly together. Make sure to read the instructions to use both contributions together in extras/wpp.

 

Thanks to Stew this is working perfectly on my store tested and double checked before adding the update.

 

-- Mindy

Share this post


Link to post
Share on other sites

Hi, I wonder if you could help me a little bit as my PHP knowledge is still bit limited. I was using v0.82 and updated to v0.910 thus merged contents of includes/login_pwa.php into login.php - no problem there. However because I use CCGV on my site, I had this bit of code in includes/login_pwa.php

//Detect if there is a gift voucher in the basket
 $voucher_in_basket = false;
 foreach ($cart->contents as $prod_id=>$params) {
  $mod_q = "select * from products where products_id = '" . $prod_id . "'";
	$mod_res = tep_db_query($mod_q);
	$mod_row = tep_db_fetch_array($mod_res);
	$model_code = $mod_row['products_model'];
	if (substr($model_code,0,4) == 'GIFT') $voucher_in_basket=true;
} 
//End CCGV Code
if (($cart->count_contents() > 0) && (!isset($HTTP_GET_VARS['my_account_f']) || $HTTP_GET_VARS['my_account_f'] !=1) && (!$voucher_in_basket)) 	// only display of box if something in cart

I didn't want to offer PWA if GIFT was in the basket. However I'am unable to find the correct place in new login.php for this bit of code - no matter where I insert it, the PWA box is still displayed. I guess it has to be around $cart->count_contents() > 0 somewhere...

 

Thanks alot.

 

Alex


Absinthe Original Liquor Store

Share this post


Link to post
Share on other sites

Hello, I'm sorry if this has been asked before but I can't seem to find anything on it. I am trying to install the "Purchase without Account" and have come to a point where it tells you to

 

"Go into your server's backend and use a SQL tool such as PHPMYADMIN to run the following SQL scripts. "

 

I am not sure how to do that. I have never used the phpmyadmin and don't know where to start. Can anyone help me please.

 

Thank you,

 

Jay d

Share this post


Link to post
Share on other sites
Hello, I'm sorry if this has been asked before but I can't seem to find anything on it. I am trying to install the "Purchase without Account" and have come to a point where it tells you to

 

"Go into your server's backend and use a SQL tool such as PHPMYADMIN to run the following SQL scripts. "

 

I am not sure how to do that. I have never used the phpmyadmin and don't know where to start. Can anyone help me please.

 

Thank you,

 

Jay d

 

Easy stuff, jay d:

 

Login to PHPMyAdmin

Click on the SQL tab (sometimes you have to first click on a table in the left column for the SQL tab to show)

Copy all of the text that is in the pwa_install.sql file

Paste it into the SQL text field (titled "Run SQL query/queries on database yourdatabasename" or similar)

Click
Go

Taa daaaah! You're done.


cdickson

Share this post


Link to post
Share on other sites

Thank you for your help. I did that and it said it was successful. Do I have to do anything else after that or do I just close myphpadmin and I'm done?

 

Jay d

Share this post


Link to post
Share on other sites

Sorry for the spamming, but I have to try posting this again in case someone's come across an answer in the last month or so. From my previous message:

 

"I'm running PWA 0.82 using the addition from March 25 called "PWA straight to checkout", which is supposed to eliminate even the choice of creating an account. This has been working quite well. However, I've now added in manufacturers, and when you try to click on the manufacturer's home page link, it just redirects to the order page rather than the manufacturer's URL. Has anyone else encountered this?"

 

Thanks to anyone who can help!

Share this post


Link to post
Share on other sites

I am using PWA v.091 and added manufacturers as a test and am not seeing any problems with the links. Perhaps someone with v0.82 could do this and see if it is a bug in that version....

Share this post


Link to post
Share on other sites
Thank you for your help. I did that and it said it was successful. Do I have to do anything else after that or do I just close myphpadmin and I'm done?

 

Jay d

 

You're done! Pretty slick, B) eh?

 

All this process does is add the appropriate fields and whatever content is necessary to implement the function.

 

The alternative is to do it manually, so I think it's very cool that the authors of the contributions provide an SQL file to save time. It also insures accuracy. :thumbsup:


cdickson

Share this post


Link to post
Share on other sites
Sorry for the spamming, but I have to try posting this again in case someone's come across an answer in the last month or so. From my previous message:

 

"I'm running PWA 0.82 using the addition from March 25 called "PWA straight to checkout", which is supposed to eliminate even the choice of creating an account. This has been working quite well. However, I've now added in manufacturers, and when you try to click on the manufacturer's home page link, it just redirects to the order page rather than the manufacturer's URL. Has anyone else encountered this?"

 

Thanks to anyone who can help!

 

I'm not quite sure what this means, but I can't see how this function would be affected by PWA. How does the website know what the manufacturer's website address is? Perhaps this information is malformed or missing.


Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Share this post


Link to post
Share on other sites

I have added the PWA contribution and I am now getting the following error when I try to create a new account. What do I need to fix?

 

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

 

select customers_id, customers_email_address, purchased_without_account from customers where customers_email_address = '****'

 

[TEP STOP]

 

Thanks

 

Jay d

Share this post


Link to post
Share on other sites
I have added the PWA contribution and I am now getting the following error when I try to create a new account. What do I need to fix?

 

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

 

select customers_id, customers_email_address, purchased_without_account from customers where customers_email_address = '****'

 

[TEP STOP]

 

Thanks

 

Jay d

 

This means that somehow that field didn't get added when you ran your SQL command earlier. Which version of PWA are you installing?

 

I have added the PWA contribution and I am now getting the following error when I try to create a new account. What do I need to fix?

 

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

 

select customers_id, customers_email_address, purchased_without_account from customers where customers_email_address = '****'

 

[TEP STOP]

 

Thanks

 

Jay d

Actually I just checked the documentation and it doesn't matter which version - the SQL commands are the same.

 

When you ran it earlier, did you make sure that all 4 commands were run? You don't have to do them individually, but all 4 must be included. The commands are:

ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id;

ALTER TABLE customers ADD INDEX (purchased_without_account);

INSERT INTO configuration_group VALUES (40, 'Accounts', 'Configuration of Account settings', 40, 1);
INSERT INTO configuration VALUES ('', 'Purchase Without Account', 'PWA_ON','true','Allow Customers to purchase without an account', 40, 1, '2003-04-08 13:07:44', '2003-04-08 12:10:51', NULL, 'tep_cfg_select_option(array(\'true\', \'false\'),');

ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL;


cdickson

Share this post


Link to post
Share on other sites
Hi, I am pretty sure I processed the whole thing. Is there a way to check?

Go into your PHP MyAdmin and look at the tables. Based on your SQL command you can view and analyze. Your error message indicates that you are missing a field called purchased_without_account.

  • The first SQL command reads
    ALTER TABLE customers ADD purchased_without_account TINYINT(1) UNSIGNED DEFAULT '0' NOT NULL AFTER customers_id;
    which means that your customers table should have this field.
     
  • The last SQL command reads
    ALTER TABLE orders ADD purchased_without_account TINYINT (1) UNSIGNED DEFAULT '0' NOT NULL;
    so there should be a purchased_without_account field in your orders table as well.

If one of them is missing, run the SQL command for the table that is missing that field.


cdickson

Share this post


Link to post
Share on other sites

Okay, I have a purchased without account in the fields column in both the customers and orders tables and it seems that everything is included in it. In the first command it says NOT NULL AFTER customers_id;. Should something have changed here?

 

Thanks

 

 

 

I checked the other two commands for configuration and configuration_groups and I don't see the information in there. Is it this that may be missing?

Share this post


Link to post
Share on other sites
Okay, I have a purchased without account in the fields column in both the customers and orders tables and it seems that everything is included in it. In the first command it says NOT NULL AFTER customers_id;. Should something have changed here?

 

Thanks

 

 

 

I checked the other two commands for configuration and configuration_groups and I don't see the information in there. Is it this that may be missing?

 

Are you still getting errors?


Do, or do not. There is no try.

 

Order Editor 5.0.6 "Ultra Violet" is now available!

For support or to post comments, suggestions, etc, please visit the Order Editor support thread.

Share this post


Link to post
Share on other sites
"I'm running PWA 0.82 using the addition from March 25 called "PWA straight to checkout", which is supposed to eliminate even the choice of creating an account. This has been working quite well. However, I've now added in manufacturers, and when you try to click on the manufacturer's home page link, it just redirects to the order page rather than the manufacturer's URL. Has anyone else encountered this?"

 

I'm not quite sure what this means, but I can't see how this function would be affected by PWA. How does the website know what the manufacturer's website address is? Perhaps this information is malformed or missing.

 

Well, it's not PWA alone - I think it's the "PWA straight to checkout" addon. It heavily modifies the redirect.php file, which also seems to be used in generating the manufacturer home page links (these are generated from the manufacturer info put into admin, and the info is all there and complete). I just haven't been able to figure out exactly how...

Edited by teleute

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×