Jump to content

jorgeo

Members
  • Content count

    35
  • Joined

  • Last visited

About jorgeo

  • Birthday May 15

Profile Information

  1. This is the main support thread for the add-on "phpBB3 / osCommerce Bridge" This mod acts as a bridge between phpBB3 (notice this is version 3 of phpBB, not 2) and osCommerce. Alllows for a common login to both systems using email/password combination. It synchronizes user account changes (email, password) from both user and admin perspective. Main signup is through store, and users are allowed to pick a username for the phpBB forums after account creation. Update Log: v1.0 - Initial release (2013/05/20)
  2. jorgeo

    fast easy checkout

    For those of you getting after trying to submit your your credit card in the checkout_shipping.php page (either by using the credit card module, authorize.net or authorize.net AIM), I believe the "error" (I'm not sure if it is one) is found in checkout_shipping.php at around line 124: while (list($key, $value) = each($_POST)) { tep_session_register($key); } Some people mentioned to use $HTTP_POST_VARS instead of $_POST. I found out there was no difference (in my version of php), but I changed that anyway. I changed the code to: while (list($key, $value) = each($HTTP_POST_VARS)) { tep_session_register($key); $_SESSION[$key] = $HTTP_POST_VARS[$key]; } So now, after assigning the name of the POST variables (key) into the SESSION, we are also forcing the value of such key to be updated in the SESSION. I would assume tep_session_register() would do that, but it seems it doesn't. The rationale: I'm unsure if this fix is comprehensive, so I'm posting no fix patch on the contribution page. For those of you interested on why this happens, this is my take: checkout_shipping.php submits the credit card information to itself through POST If shipping info is ok, we will reload this page into checkout_confirmation.php?paynow= , so we need to store POST variables into SESSION ones to preserve them The fix above makes sure the variables are not only defined in the SESSION, but their values too Now we are in checkout_confirmation.php. We were supposed to get here by submitting a form, so we take the SESSION variables and put them back into POST variables (around line 18) Next thing is to delete the session variables that contain sensitive data, like "authorizenet_cc_number" So by now, everything should work fine. The submitted credit card data was swapped in and out of session variables, and the payment modules should work. I think that did it for me (I was messing with code for many many hours), and now I can use the authorize.net (not AIM) module with no problem. If it works for you, let others know. ~Jorge
  3. jorgeo

    Wishlist 2.0 Support Thread

    Make sure you've declared TABLE_FAVORIS, TABLE_FAVORIS_ATTRIBUTES and TABLE_WISHLIST, TABLE_WISHLIST_ATTRIBUTES to be two different tables (in includes/database_tables.php). Example: // Wishlist define('TABLE_WISHLIST', 'customers_wishlist'); // Wish List w/Attributes define('TABLE_WISHLIST_ATTRIBUTES', 'customers_wishlist_attributes'); // Favorites define('TABLE_FAVORIS', 'customers_favorite'); // Favorites w/Attributes define('TABLE_FAVORIS_ATTRIBUTES', 'customers_favorite_attributes'); To actually create the tables in OsCommerce, modify the sql file replacing the names of the database table to customers_favorite and customers_favorite_attributes. Good luck! ~Jorge
  4. jorgeo

    Wishlist 2.0 Support Thread

    Nope. Instead, you want to delete this line: tep_db_query("delete from " . TABLE_WISHLIST . " where customers_id= '" . $customer_id . "' and products_quantity = '999'"); about 7 lines after the "case 'wishlist_add_cart'" line. ~Jorge
  5. jorgeo

    Wishlist 2.0 Support Thread

    For the new version with html links to products, you probably need to enable HTML emails in your Admin configuration. Admin->Configuration->Email options->Use MIME HTML When Sending Emails->true
  6. jorgeo

    Wishlist 2.0 Support Thread

    in /catalog/includes/application_top.php: find: case 'wishlist_add_cart' :if (ereg('^[0-9]+$', $HTTP_POST_VARS['products_id'])) { if ($HTTP_POST_VARS['products_id']) { if ($customer_id > 0) { tep_db_query("delete from " . TABLE_WISHLIST . " where products_id = '" . $HTTP_POST_VARS['products_id'] . "' and customers_id = '" . $customer_id . "'"); tep_db_query("delete from " . TABLE_WISHLIST_ATTRIBUTES . " where products_id = '" . $HTTP_POST_VARS['products_id'] . "' and customers_id = '" . $customer_id . "'"); // Read array of options and values for attributes in id[] Replace with case 'wishlist_add_cart' :if (ereg('^[0-9]+$', $HTTP_POST_VARS['products_id'])) { if ($HTTP_POST_VARS['products_id']) { if ($customer_id > 0) { // Read array of options and values for attributes in id[] That will keep the items in your wishlist even if they move them to the shopping cart
  7. jorgeo

    Wishlist 2.0 Support Thread

    Hi j0ker, The wishlist currently does that. It will remain available until the items are specifically removed from the wishlist (or moved to the shopping cart) ~Jorge
  8. jorgeo

    Wishlist 2.0 Support Thread

    Wish List 2.3 Consolidated http://www.oscommerce.com/community/contributions,1682 It includes all the updates and add-ons to the wishlist. You should be able to use just this contribution to install the Wish List... Finally :P Enjoy! ~Jorge
  9. jorgeo

    Wishlist 2.0 Support Thread

    Yeah, I've been wanting to consolidate all previous contributions into a single one, but I've been out of time for the past month. I'll try to work on it tonight.
  10. jorgeo

    Wishlist 2.0 Support Thread

    Hi Mibble, I would install the "4 May 2004 - Wishlist including checkbox's" wishlist contribution. in the Wishlist Contribution page After that, you can add the updates as you see fit.
  11. jorgeo

    Wishlist 2.0 Support Thread

    Yeah, I missed that, sorry. Change your catalog/includes/application_top.php: FROM: case 'cust_order' : if (tep_session_is_registered('customer_id') && isset($HTTP_GET_VARS['pid'])) { // begin mod for Wishlist v2.2 tep_db_query("delete from " . TABLE_WISHLIST . " where products_id = '" . $HTTP_GET_VARS['pid'] . "' and customers_id = '" . $customer_id . "'"); // Begin Wish List Code w/Attributes tep_db_query("delete from " . TABLE_WISHLIST_ATTRIBUTES . " WHERE customers_id=$customer_id AND products_id=$products_id"); // End Wish List Code w/Attributes // end mod for Wishlist 2.2 TO: case 'cust_order' : if (tep_session_is_registered('customer_id') && isset($HTTP_GET_VARS['pid'])) { // begin mod for Wishlist v2.2 tep_db_query("delete from " . TABLE_WISHLIST . " where products_id = '" . $HTTP_GET_VARS['pid'] . "' and customers_id = '" . $customer_id . "'"); // Begin Wish List Code w/Attributes tep_db_query("delete from " . TABLE_WISHLIST_ATTRIBUTES . " WHERE customers_id=$customer_id AND products_id='" . $HTTP_GET_VARS['pid']."'"); // End Wish List Code w/Attributes // end mod for Wishlist 2.2
  12. jorgeo

    Wishlist 2.0 Support Thread

    Ok, I found out that my previous post was very vague and hence why people might be having trouble. What I really meant was: Turn this: // Now we have an array of options and values for attributes in id[] foreach($id as $att_option=>$att_value) { // Add to customers_wishlist_attributes table tep_db_query("insert into " . TABLE_WISHLIST_ATTRIBUTES . " (customers_id, products_id, products_options_id , products_options_value_id) values ('" . $customer_id . "', '" . $products_id . "', '" . $att_option . "', '" . $att_value . "' )"); } into this: // Now we have an array of options and values for attributes in id[] if (isset ($id)) { foreach($id as $att_option=>$att_value) { // Add to customers_wishlist_attributes table tep_db_query("insert into " . TABLE_WISHLIST_ATTRIBUTES . " (customers_id, products_id, products_options_id , products_options_value_id) values ('" . $customer_id . "', '" . $products_id . "', '" . $att_option . "', '" . $att_value . "' )"); } }
  13. jorgeo

    Wishlist 2.0 Support Thread

    Hi Doug, I'm wondering if you could post the differences you found in the forum. Hopefully someone else can benefit from them! :thumbsup:
  14. jorgeo

    Wishlist 2.0 Support Thread

    Hmmm.... I don't find a way to attach files to a message, or else I would send my current versions of the files I changed for you guys to look at (I can't figure out what went wrong with your installations, I guess something minor.... and really annnoying! :P ) I'd post them on the contribution page, but my files have some extra modifications that I don't have time for removing. Ravenwulf, BearHappy: If you want a copy, send me a PM through the board with your email addy, and I'll send them to you. Then you can contrast and compare for possible errors.
  15. jorgeo

    Wishlist 2.0 Support Thread

    Just in case: This is how the relevant part of my application_top looks like for the corrections on the issue: case 'add_wishlist' : if (ereg('^[0-9]+$', $HTTP_POST_VARS['products_id'])) { if ($HTTP_POST_VARS['products_id']) { if ($customer_id > 0) { tep_db_query("delete from " . TABLE_WISHLIST . " where products_id = '" . $HTTP_POST_VARS['products_id'] . "' and customers_id = '" . $customer_id . "'"); tep_db_query("insert into " . TABLE_WISHLIST . " (customers_id, products_id, products_model, products_name, products_price) values ('" . $customer_id . "', '" . $products_id . "', '" . $products_model . "', '" . $products_name . "', '" . $products_price . "' )"); tep_db_query("delete from " . TABLE_WISHLIST_ATTRIBUTES . " where products_id = '" . $HTTP_POST_VARS['products_id'] . "' and customers_id = '" . $customer_id . "'"); // Now we have an array of options and values for attributes in id[] if (isset ($id)) { foreach($id as $att_option=>$att_value) { // Add to customers_wishlist_attributes table tep_db_query("insert into " . TABLE_WISHLIST_ATTRIBUTES . " (customers_id, products_id, products_options_id , products_options_value_id) values ('" . $customer_id . "', '" . $products_id . "', '" . $att_option . "', '" . $att_value . "' )"); } } } } } break;
×