Jump to content

lildog

Members
  • Content count

    613
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by lildog

  1. here are the settings for customer password in my db: if you have other contribs installed it may have changed. Field Type Collation Attributes Null Default Extra customers_password varchar(40) latin1_swedish_ci Yes NULL
  2. EVERYONE!!! 2. catalog/create_account.php ***FIND: $guestaccount = 'null'; OR $guestaccount = 'guestaccount'; ***REPLACE WITH: $guestaccount = '0';
  3. First of all...everyone: 1.in catalog/login.php ***FIND: $check_customer_query = tep_db_query( "select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, customers_block, guest_account from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address). "' and guest_account='0'"); ***REPLACE WITH: $check_customer_query = tep_db_query( "select customers_id, customers_firstname, customers_password, customers_email_address, customers_default_address_id, guest_account from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address). "' and guest_account='0'");
  4. Ok those of you having the database orders....is it an upgrade or a first time install? lildog
  5. Joyces, all in all it is not that hard. The hard part is making it work for all installations. I know it works on my install but I have alot of contribs installed. I will try to help sort these out and get it working for evryone. lildog
  6. Maxwell, you are not getting the checkout without account option in login? Check login.php for the pwa code. In my shopping cart I have continue shopping and checkout. lildog
  7. OK...for those of you getting the guest accountcannot be null. Go into your phpmyadmin and choose the guest account column in customers table. Make sure the settings are: Field Type Collation Attributes Null Default Extra guest_account tinyint(3) No 0 Please let me know if this works for you so I can fix the problem in the contrib. lildog
  8. hmm, maybe the old customers 'dummy account' are not set to 'true' or 'false' maybe null? which technically is different. The 2nd fix I posted could be correct as !1 maybe different that 0 too. The third fix should work too by just bypassing the email check....basically it just say blah blah blah They don't have an account so I don't care what their email addy is blah blah blah. If anyone else experiences this problem please report in and I will look into it. lildog
  9. Here is the best solution i think: in create account: find: // PWA BOF 2 // $check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "'"); // PWA BOF 2b $check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "' and guest_account != '1'"); // PWA EOF 2b // PWA EOF 2 $check_email = tep_db_fetch_array($check_email_query); if ($check_email['total'] > 0) { $error = true; $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS); } } CHANGE to: // PWA BOF 2 if (!isset($HTTP_GET_VARS['guest']) && !isset($HTTP_POST_VARS['guest'])) { $check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "' and guest_account != '1'"); // PWA EOF 2b $check_email = tep_db_fetch_array($check_email_query); if ($check_email['total'] > 0) { $error = true; $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS); } } // PWA BOF 2 } // PWA EOF 2
  10. you could also try this instead: in create account: change: $check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "' and guest_account != '1'"); to: $check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "' and guest_account = '0'");
  11. Paul try commenting out this in create_account.php: let me know if this works for you..... // PWA BOF 2b $check_email_query = tep_db_query("select count(*) as total from " . TABLE_CUSTOMERS . " where customers_email_address = '" . tep_db_input($email_address) . "' and guest_account != '1'"); // PWA EOF 2b // PWA EOF 2 $check_email = tep_db_fetch_array($check_email_query); if ($check_email['total'] > 0) { $error = true; $messageStack->add('create_account', ENTRY_EMAIL_ADDRESS_ERROR_EXISTS); }
  12. I am actually working on something like this right now.....stay tuned. I will let you know. I didn't do all the programming though, most of it was done by the guy that put the first 2.0 version up. lildog
  13. I just updated to v2.0 and was wondering if the dummy account gets deleted automatically? Everything works, orders go through, but an account is created and marked inactive in admin. So it is not PWa? it is PWithAccount? the upgrade was rough but incorporating with other contribs seems like it is going to be a breeze since technically an account is created. lildog
  14. lildog

    Contribution Tracker

    I am working on an update that includes Phocea's fixes and was wondering if anyone would like to be able access a link to the contributions support forum thread, I can never find them when I need them. Let me know..... lildog
  15. lildog

    Contribution Tracker

    Phocea, I have not had a chance to implement your code fix, as soon as I do I will post an update. Did you fix your cannot open XML error? if so what did you do? When I removed my sucess message I get the xml error again. lildog
  16. lildog

    Contribution Tracker

    Thanks carry_g, that must have been lost in updates. The instructions originally told you to update all of your contributions then install contrib tracker. I will put that in. I will look into AutoBackup Database in Admin problem. No promises, I am not really a php pro, just kinda stumble through. lildog
  17. lildog

    Contribution Tracker

    Phoecia Sometimes the feed goes down. And contrib tracker can't connect to it. It happens once in awhile. I actually put a line of code that told me each time it was sucessful, just to be sure it was working. When you get this error try going to the feed URL, your browser probably won't be able to connect to it either. lildog
  18. lildog

    Contribution Tracker

    I don't know about anyone else, but I like the idea of the email feature will try it out. lildog
  19. lildog

    Contribution Tracker

    Thanks pBor1234 for pointing that out. My bad. CarryG, it is compatible with OS Online Merchant 2.2 RC2a. I believe it is the latest version. As for PHP5 I am not sure, my server is using 4.?.?. The newest version of CT automatically looks to the add ons RSS Feed. I am not a php guru like some here, are you recieving any errors in your server scripts log? Make sure your permissions are correct to write the temp rss file. lildog
  20. lildog

    NEW! Complete Order Editing Tool!

    I have the latest version of order editor installed and when I add a product to the order it is not adding the amount to the sub total. It is adding the product and the tax and the total is correct just the subtotal. Any ideas? lildog
  21. lildog

    Contribution Tracker

    I fixed the new xml urls and added an email feature that will try to let you know if Contrib Tracker is down.
  22. lildog

    Contribution Tracker

    Lines 35 and 58 are lines that are checking for curl......
  23. lildog

    Official PayPal IPN Support Thread

    Yeah, you get those from Paypal, I don't think you use the ipn though. I believe you get it when you sign up as a paypal developer. I remember having problems finding it. lildog
  24. Where di dthis contribution go? I cannot find it in the add ons site. lildog
  25. lildog

    ### POINTS AND REWARDS MODULE V1.00 ###

    Mike, I have it working.(fingers crossed) But I also have Gift vouchers(CCGV) installed and together have had to apply all kinds of fixes and tweeks. I originally tried to keep track of my changes, but lost track A LONG LONG time ago.....But I do have it working. lildog
×