Products that can only be purchased once.

[Ajeh]

Try this ... paren issues and that , after the products_id in the array ...

// bof: do not allow customer to add to cart if already purchased
// if not logged in and a free product make login


if (!$_SESSION['customer_id'] && in_array((int)$product_id, array(65, 64 )) ) {
  return 'login for free product';
}


if ( in_array((int)$product_id, array(65, 64 )) ) {
  $chk_product_purchased_query = "select distinct op.products_id, o.orders_id
    from " . TABLE_ORDERS_PRODUCTS . " op
    left join " . TABLE_ORDERS . " o on o.orders_id = op.orders_id
    where op.products_id = '". (int)$product_id . "'
    and o.customers_id='" . $_SESSION['customer_id'] . "'";

  $chk_product_purchased = $db->Execute($chk_product_purchased_query);

  if (!$chk_product_purchased->EOF) {
    return 'You have already received this offer!';
  }
}

// eof: do not allow customer to add to cart if already purchased

[Youngblood]

Thank you once again Ajeh,


I aspire to achieve your level of understanding of php and generosity.

Till next time!

[Ajeh]

You are most welcome ... thanks for the update that this is working for you now to only allow the purchase of some products once ...

[Youngblood]

Well this is certainly frustrating....

With either of the codes you've provided, when installed....I can confirm that it does indeed make the selected products a "buy once" feature.

However, it also causes a blank page to display whenever a user creates a new account or tries to log into an existing one.

*Launches Distress Flare*

Any and all assistance is appreciated, this is outside of my knowledge.

[Ajeh]

If in v1.3.9 ... check your /cache for error logs ...

If not in v1.3.9 ... get the Debug Tool from the Free Software Add Ons and see what error message you are getting ...

[Youngblood]

Problem Solved -

Initially, I had used your category code twice with different ID's. I did not use an array as suggested.

The second time I had put the code in the wrong line and therefore caused some syntax errors with php.

Finally, Using the product ID code with what you wrote worked. I guess I was a bit fatigued yesterday.

So, for anyone else looking to do the same, listen to Ajeh! and don't try to do your own thing like I did. It will only humble you.

Thanks Ajeh for your continued patience with me....

Jonah

[Ajeh]

Glad to hear that this is now working for you ...