Latest News: (loading..)

B.C.

Members
  • Content count

    46
  • Joined

  • Last visited

1 Follower

About B.C.

Profile Information

  • Real Name
    BC
  • Gender
    Male
  • Location
    USA

Recent Profile Visitors

4,430 profile views
  1. I've tried everything available and either it's buggy or broken or it doesn't do what I need done. But years ago on a 2.2 shop I was able to mask account and cut two more useless pages out of the checkout process, I was hoping somebody would know how to do the same on 2.3.4
  2. Years ago on an old 2.2 shop, I used threads from this site to mask the account creating process. Some of you may remember it....you renamed create_account.php to shipping_details.php and replaced some code to autofill the password so you could just remove the password field completely, then you replaced some code that allowed multiple accounts to use the same e-mail address, so repeat customers weren't told that their email was already in use, etc... I would like to upgrade to the 2.3.4 master/responsive version, and would like to mask the account creating process. The exact code that worked on 2.2 won't work on 2.3.4, so I'm wondering if anyone would care to help to fix it. If so, I will paste the instructions from 2.2 below: - Rename create_account.php to shipping_details.php - Edit Filenames.php Around line 36 find: CODE define('FILENAME_CREATE_ACCOUNT', 'create_account.php'); Change it to: CODE define('FILENAME_CREATE_ACCOUNT', 'shipping_details.php'); Around line 41 find: CODE define('FILENAME_LOGIN', .............); Change it to: CODE define('FILENAME_LOGIN', FILENAME_CREATE_ACCOUNT); - Edit shipping_details.php This gets rid of telephone form field, replacing it with dummy number Around line 47 find: CODE $telephone = $HTTP_POST_VARS['telephone']; Change it to: CODE $telephone = tep_db_prepare_input('555-555-5555'); This creates a temporary password Around line 54 find: CODE $password = $HTTP_POST_VARS['password']; $confirmation = $HTTP_POST_VARS['confirmation']; Change it to: CODE $tmpPW = rand(5,10).'TemporaryPassword'; $password = tep_db_prepare_input($tmpPW); $confirmation = tep_db_prepare_input($tmpPW); This makes OSC allow more than 1 of the same email addy Around line 100 find: CODE if ($check_email['total'] > 0) { $error = true; $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS); } Change it to: CODE if ($check_email['total'] > 0) { $error = false;//true //$messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS); } This gets rid of the auto-email sending OSC does Around line 233 find: CODE // 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; tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); Change it to: CODE // build the message content /* COMMENTED OUT SO IT DOES NOT SEND AN EMAIL AFTER FILLING OUT "SHIPPING DETAILS" // WHICH USED TO BE "CREATE ACCOUNT" $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; tep_mail($name, $email_address, EMAIL_SUBJECT, $email_text, STORE_OWNER, STORE_OWNER_EMAIL_ADDRESS); */ This removes all the HTML code that displays all the data entry fields we dont want I merely used HTML comment code to block out the display Around line 438-500 find: CODE <tr> <td class="main"><b><?php echo CATEGORY_CONTACT; ?></b></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td> <td class="main"><?php echo tep_draw_input_field('telephone') . '&nbsp;' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_FAX_NUMBER; ?></td> <td class="main"><?php echo tep_draw_input_field('fax') . '&nbsp;' . (tep_not_null(ENTRY_FAX_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_FAX_NUMBER_TEXT . '</span>': ''); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo CATEGORY_OPTIONS; ?></b></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo ENTRY_NEWSLETTER; ?></td> <td class="main"><?php echo tep_draw_checkbox_field('newsletter', '1') . '&nbsp;' . (tep_not_null(ENTRY_NEWSLETTER_TEXT) ? '<span class="inputRequirement">' . ENTRY_NEWSLETTER_TEXT . '</span>': ''); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo CATEGORY_PASSWORD; ?></b></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo ENTRY_PASSWORD; ?></td> <td class="main"><?php echo tep_draw_password_field('password') . '&nbsp;' . (tep_not_null(ENTRY_PASSWORD_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_TEXT . '</span>': ''); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_PASSWORD_CONFIRMATION; ?></td> <td class="main"><?php echo tep_draw_password_field('confirmation') . '&nbsp;' . (tep_not_null(ENTRY_PASSWORD_CONFIRMATION_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_CONFIRMATION_TEXT . '</span>': ''); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> Change it to: CODE <!--tr> <td class="main"><b><?php echo CATEGORY_CONTACT; ?></b></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo ENTRY_TELEPHONE_NUMBER; ?></td> <td class="main"><?php echo tep_draw_input_field('telephone') . '&nbsp;' . (tep_not_null(ENTRY_TELEPHONE_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_TELEPHONE_NUMBER_TEXT . '</span>': ''); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_FAX_NUMBER; ?></td> <td class="main"><?php echo tep_draw_input_field('fax') . '&nbsp;' . (tep_not_null(ENTRY_FAX_NUMBER_TEXT) ? '<span class="inputRequirement">' . ENTRY_FAX_NUMBER_TEXT . '</span>': ''); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo CATEGORY_OPTIONS; ?></b></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo ENTRY_NEWSLETTER; ?></td> <td class="main"><?php echo tep_draw_checkbox_field('newsletter', '1') . '&nbsp;' . (tep_not_null(ENTRY_NEWSLETTER_TEXT) ? '<span class="inputRequirement">' . ENTRY_NEWSLETTER_TEXT . '</span>': ''); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr> <tr> <td class="main"><b><?php echo CATEGORY_PASSWORD; ?></b></td> </tr> <tr> <td><table border="0" width="100%" cellspacing="1" cellpadding="2" class="infoBox"> <tr class="infoBoxContents"> <td><table border="0" cellspacing="2" cellpadding="2"> <tr> <td class="main"><?php echo ENTRY_PASSWORD; ?></td> <td class="main"><?php echo tep_draw_password_field('password') . '&nbsp;' . (tep_not_null(ENTRY_PASSWORD_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_TEXT . '</span>': ''); ?></td> </tr> <tr> <td class="main"><?php echo ENTRY_PASSWORD_CONFIRMATION; ?></td> <td class="main"><?php echo tep_draw_password_field('confirmation') . '&nbsp;' . (tep_not_null(ENTRY_PASSWORD_CONFIRMATION_TEXT) ? '<span class="inputRequirement">' . ENTRY_PASSWORD_CONFIRMATION_TEXT . '</span>': ''); ?></td> </tr> </table></td> </tr> </table></td> </tr> <tr> <td><?php echo tep_draw_separator('pixel_trans.gif', '100%', '10'); ?></td> </tr--> And I think that does all the NECESSARY changes Now let us know what cosmetic changes are needed as well Well this has worked a treat for me. The only other necessary changes were to remove the login and my account links from the header (header.php) and to change the redirect in shipping_details.php to miss out create_account_success.php.
  3. I'll be following this closely, as I've been searching my brains out for something similar to what you need. Everything that works to shorten the stock checkout by several useless pages and/or allow customers to checkout without an account is either clunky and buggy, or simply won't work on 2.3.4/BS without being re-written.
  4. Has anyone gotten this to work on 2.3.4?
  5. Yeah, I bet that's it, because I opened it in Notepad to rename it. Since I am trying to move it to a different hosting account, the naming scheme is different, that whole "account_dbname" thing, so I think I'll do what you suggest, but stop trying to move the db to a different server, since I think that's where the problem is.
  6. Yeah, it's failing on the import.........it could be buggy phpmyadmin, could be because of different versions of mysql on the different servers.....I don't know........another day of futilely grinding away at what is supposed to be so easy.........This is exactly why I put off even thinking about upgrading for years........Unfortunately your help is wasted on me at this point, I'm in the weeds again...I think I'll scrub everything and start the whole thing again fresh on the same server, just to hopefully avoid the import/export situation being the culprit. Thanks again, though, it is appreciated.
  7. Dan, I had seen that as well when I Googled it, and one of the suggestions was to upgrade phpmyadmin......are you suggesting that, or you saying go ahead and export with the possibly buggy phpmyadmin, then updating the database on the new server?
  8. Dan, it seems to be failing at the import with the above error message.....there are no errors on the new store, just no products, no categories, etc...Maybe I should have been doing all of this on the same server........I think all the advice here is exact and correct, I'm just screwing it all up by trying to export to another server/host.......
  9. this is what i have.......... -- phpMyAdmin SQL Dump -- version 4.0.10.14 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Jul 02, 2017 at 01:10 PM -- Server version: 5.1.73-cll -- PHP Version: 5.4.31 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `newshop_oldStore` ------------------------------------------------------------ -- Table structure for table......etc, etc...
  10. I'm starting to get clear on that, it's making more sense. In my particular case, I'm rebuilding the new store on a different server with a different host, so I'm having to export/import tables and/or databases after running the update scripts on them....I'm successfully running the scripts you guys have made, I'm just hitting errors on the attempt to import the updated database into the new store..........I think I'm going to give up on updating the old stuff......I have installed the new shop (2.3.4 responsive) and all I really need from my old shop is the products/attributes and customer reviews.....Maybe it is easier to do that? A lot of my old contributions are stock in the new package anyway.......But I probably shouldn't clutter up this thread with it.....I assume I'll need help and I'll try to start a new thread in the appropriate place.
  11. OK, I have copied the old database, run the SQL changes script, run Burt's db update script to get it up to 2.3.4 Responsive. I exported that db to import it over the other server where I'm trying to set up the new store, but I'm hitting errors on the import: Error Static analysis: 2 errors were found during analysis. Unexpected beginning of statement. (near "phpMyAdmin" at position 0) Unrecognized statement type. (near "SQL" at position 11) SQL query: phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO" MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'phpMyAdmin SQL Dump SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"' at line 1 Not sure what that calls for?
  12. Brockley John--definitely time for a break, but thanks for the control click tip, I have never heard of that before. Dan- OK, light at the end of the tunnel, thanks, I'll do that and report back..... I graduated high school in prison, never went to college, and I just silk screen shirts....99% of all of this computer stuff is over my head.....what seems obvious to you is Latin to me. That's why for years I just Google and tinker and try not to bother the smart folks.....but this 2.3.4 stuff seems like a whole new ball game. Thanks for taking the time to help me........
  13. Dan, yes, absolutely, but I think I am using the version of that that goes up to 2.3.4, not just 2.3.3 or whatever.... But yes, I copied my database and renamed it "oldStore" then followed the instructions in this thread above and deleted everything that wasn't needed, and imported it. Now I'm on Step 4 of "Converting from OSC 2.2 to 2.3x, for dummies" where I'm supposed to select only certain tables for a custom export, which should then be able to be imported into the new store. But I can't select only certain tables. I can select all or deselect all.
  14. Dan, yes, I read that, and yes, that's exactly what he said. Then immediately after that, he said: And the thread he linked to was all about updating from BS 2.3.4 to Responsive 2.3.4. So, like I said, it seemed (to me, of course) like that post was all about showing you how to go from BS to Responsive. You may have to allow for the possibility that what someone says and what my limited understanding of what was said may not correspond, exactly. So if I express what I think was said and ask for clarification, I hope that isn't interpreted as an attempt to contradict anybody. I know I'm the deficient moron in this situation, humbly asking for assistance, so I appreciate any help. So anyway, does anyone have any idea why I can't select only certain tables for a custom export?
  15. How I missed that I don't know, but thanks, that worked for that step. Now I'm on the next step of doing the custom export of oldStore, but you say in your instructions to only export certain tables. For some reason I can either select all or deselect all, if I try to only select certain tables, I can't. If I select one, then go to select another, it deselects the previous one, like playing Wack-a-Mole. Normally I would Google and tinker and figure it out myself, but I'm so brain dead on this project I'm going to strictly go by the instructions exactly and post my results and hope you guys are patient enough to point out my obvious errors. So, if I can't do selective table exports, should I just select all tables and export?