webgurl2006 Posted January 1, 2007 Share Posted January 1, 2007 I slowly manager to remove CITY from my customer details as I do not need this, however, in deleting the code, I am left with a comma which separates city from the postcode. As I have been altering so much code, I just cannot locate where I should be removing this from. I know this is plainly obvious, however I think my brain is overloaded with all this customising stuff! This is how the email order is returned to the customer so you can see the two commas I want to remove. dfdsffdfdf ------------------------------------------------------ Detailed Invoice: https://blahblah.com Items Purchased ------------------------------------------------------ 1 x test 2 () = $75.00 ------------------------------------------------------ Sub-Total: $75.00 Total: $75.00 ------------------------------------------------------ , Billing Address ------------------------------------------------------ dfdf fdgfdg fgfdgdg dfdfds dfdsf , 5555 sfdfdf, hgfhgfhgf Payment Method ------------------------------------------------------ Bank Deposit Payment Please use the following details to make your payment: Account No.: 12345678 BSB Number: 00-00-00 Account Name: Joe Bloggs Bank Name: The Bank ************************************************************** (I have also posted on how to receive this order to me, being the store owner as I still have not working that out. http://www.oscommerce.com/forums/index.php?act...t=0#entry997440 ) THANKS H-N-Y-2007 ! Link to comment Share on other sites More sharing options...
bill110 Posted January 1, 2007 Share Posted January 1, 2007 I am not positive that this will not remove the comma from somewhere else also but in catalog/admin/includes/functions/general.php about line 402 : if ($state != '') $statecomma = $state . ', '; change to if ($state != '') $statecomma = $state . ' '; as for receiving this email yourself in the admin section under configuration see the line that says: Send Extra Order Emails To edit that with your email address. (we created an email account [email protected] to send them to) My Contributions Stylesheet With Descriptions Glassy Grey Boxtops Our Products Meta Tags On The Fly Password Protect Admin "No matter where you go....There you are" - Buccaroo Bonsai Link to comment Share on other sites More sharing options...
webgurl2006 Posted January 2, 2007 Author Share Posted January 2, 2007 Thanks but that did not work. I will keep hunting for it! Link to comment Share on other sites More sharing options...
♥Monika in Germany Posted January 2, 2007 Share Posted January 2, 2007 I slowly manager to remove CITY from my customer details as I do not need this, however, in deleting the code, I am left with a comma which separates city from the postcode. As I have been altering so much code, I just cannot locate where I should be removing this from. I know this is plainly obvious, however I think my brain is overloaded with all this customising stuff! This is how the email order is returned to the customer so you can see the two commas I want to remove. dfdsffdfdf ------------------------------------------------------ Detailed Invoice: https://blahblah.com Items Purchased ------------------------------------------------------ 1 x test 2 () = $75.00 ------------------------------------------------------ Sub-Total: $75.00 Total: $75.00 ------------------------------------------------------ , Billing Address ------------------------------------------------------ dfdf fdgfdg fgfdgdg dfdfds dfdsf , 5555 sfdfdf, hgfhgfhgf Payment Method ------------------------------------------------------ Bank Deposit Payment Please use the following details to make your payment: Account No.: 12345678 BSB Number: 00-00-00 Account Name: Joe Bloggs Bank Name: The Bank ************************************************************** (I have also posted on how to receive this order to me, being the store owner as I still have not working that out. http://www.oscommerce.com/forums/index.php?act...t=0#entry997440 ) THANKS H-N-Y-2007 ! those commas are in your database!!! # 1 - Default, 2 - USA, 3 - Spain, 4 - Singapore, 5 - GermanyINSERT INTO address_format VALUES (1, '$firstname $lastname$cr$streets$cr$city, $postcode$cr$statecomma$country','$city / $country'); INSERT INTO address_format VALUES (2, '$firstname $lastname$cr$streets$cr$city, $state $postcode$cr$country','$city, $state / $country'); INSERT INTO address_format VALUES (3, '$firstname $lastname$cr$streets$cr$city$cr$postcode - $statecomma$country','$state / $country'); INSERT INTO address_format VALUES (4, '$firstname $lastname$cr$streets$cr$city ($postcode)$cr$country', '$postcode / $country'); INSERT INTO address_format VALUES (5, '$firstname $lastname$cr$streets$cr$postcode $city$cr$country','$city / $country'); :-) Monika addicted to writing code ... can't get enough of databases either, LOL! my toolbox: Textpad - Compare and Merge - phpMyAdmin - WS_FTP - Photoshop - How to search the forum Interactive Media Award July 2007 ~ category E-Commerce my advice on the forum is for free, PMs where you send me work are considered consultation which I charge for ... Link to comment Share on other sites More sharing options...
webgurl2006 Posted January 2, 2007 Author Share Posted January 2, 2007 That makes sense! My whole problem was that CITY is a required field and so I tried removing and thus, the remaining comma. In Australia, we do not have cities and so it is difficult to complete a required field. I am yet to get to any of the forum posts about changing the database to learn how to - probably as that scares me the most because muck that up and then I am really in strife! Is it simple for me to remove this from the database? I am PM you Monika as well. Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.